private boolean getPlayerInfo() {
// FIND THIS PLAYER IN THE DB, FILL IN HIS INFO
MySQL mysql = new MySQL();
// NOW LETS FIND EM
PreparedStatement stmt = mysql.prepareStatement("SELECT * FROM players WHERE name LIKE ? ");
try {
stmt.setString(1, playerName);
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
ResultSet result = mysql.query(stmt);
try {
while (result.next()) {
// WE FOUND IT, STORE SOME INFO
stmt = mysql.prepareStatement("SELECT stockID FROM stocks");
ResultSet result2 = mysql.query(stmt);
while (result2.next()) {
PlayerStock newS = new PlayerStock();
newS.stock = new Stock(result2.getString("stockID"));
newS.amount = result.getInt(newS.stock.toID());
this.stock.put(newS.stock.getID().toUpperCase(), newS);
}
mysql.close();
return true;
}
} catch (SQLException e) {
e.printStackTrace();
}
// WE DIDNT FIND IT, LETS CREATE IT
stmt = mysql.prepareStatement("INSERT INTO players (name) Values(?)");
try {
stmt.setString(1, playerName);
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
mysql.execute(stmt);
mysql.close();
return false;
}
public boolean sell(Stock stock, int amount) {
Message m = new Message(player);
if (stock.exists()) {
// CHECK THE PLAYER HAS ENOUGH TO SELL
if (this.stock.get(stock.getID()).amount - amount < 0) {
m.errorMessage("Failed to sell! Check that you have that many!");
return false;
}
// OKAY THEY DO, LETS SELL EM
this.stock.get(stock.getID()).amount -= amount;
// OK NOW LETS UPADTE THE DATABASE
MySQL mysql = new MySQL();
PreparedStatement stmt =
mysql.prepareStatement("UPDATE players SET " + stock.getID() + " = ? WHERE name LIKE ?");
try {
stmt.setInt(1, this.stock.get(stock.getID()).amount);
stmt.setString(2, player.getName());
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
mysql.execute(stmt);
// UPDATE AMOUNT IF NOT INFINITE
if (stock.getAmount() != -1) {
stmt = mysql.prepareStatement("UPDATE stocks SET amount = amount + ? WHERE StockID LIKE ?");
try {
stmt.setInt(1, amount);
stmt.setString(2, stock.getID());
} catch (SQLException e) {
e.printStackTrace();
return false;
}
mysql.execute(stmt);
}
mysql.close();
StockMarket.economy.depositPlayer(player.getName(), amount * stock.getPrice());
m.successMessage(
"Successfully sold "
+ amount
+ " "
+ stock
+ " stocks for "
+ stock.getPrice()
+ " "
+ StockMarket.economy.currencyNamePlural()
+ " each.");
return true;
} else {
m.errorMessage("Invalid stock ID");
return false;
}
}
public boolean buy(Stock stock, int amount) {
Message m = new Message(player);
if (stock.exists()) {
if ((stock.getAmount() >= amount || stock.getAmount() == -1)) {
// CHECK THE PLAYER HAS ENOUGH MONEY TO BUY THIS MANY
if (StockMarket.economy.getBalance(player.getName()) < amount * stock.getPrice()) {
m.errorMessage("Not enough money!");
return false;
}
// CHECK THE PLAYER ISNT OVER HIS TOTAL LIMIT OF STOCKS
if (numTotal() + amount > StockMarket.maxPerPlayer) {
m.errorMessage("Buying that many would put you over the limit for total stocks!");
return false;
}
// CHECK THE PLAYER ISNT OVER HIS LIMIT FOR THIS STOCK
if (numStock(stock) + amount > StockMarket.maxPerPlayerPerStock) {
m.errorMessage("Buying that many would put you over the limit for that stock!");
return false;
}
// OKAY THEY DO, LETS BUY EM
this.stock.get(stock.getID()).amount += amount;
// OK NOW LETS UPADTE THE DATABASE
MySQL mysql = new MySQL();
PreparedStatement stmt =
mysql.prepareStatement(
"UPDATE players SET " + stock.getID() + " = ? WHERE name LIKE ?");
try {
stmt.setInt(1, this.stock.get(stock.getID()).amount);
stmt.setString(2, player.getName());
} catch (SQLException e) {
e.printStackTrace();
return false;
}
mysql.execute(stmt);
// UPDATE AMOUNT IF NOT INFINITE
if (stock.getAmount() != -1) {
stmt =
mysql.prepareStatement("UPDATE stocks SET amount = amount - ? WHERE StockID LIKE ?");
try {
stmt.setInt(1, amount);
stmt.setString(2, stock.getID());
} catch (SQLException e) {
e.printStackTrace();
return false;
}
mysql.execute(stmt);
}
mysql.close();
StockMarket.economy.withdrawPlayer(player.getName(), amount * stock.getPrice());
m.successMessage(
"Successfully purchased "
+ amount
+ " "
+ stock
+ " stocks for "
+ stock.getPrice()
+ " "
+ StockMarket.economy.currencyNamePlural()
+ " each.");
return true;
} else {
m.errorMessage("There is not enough of that stock left to buy that many!");
return false;
}
} else {
m.errorMessage("Invalid stock ID");
return false;
}
}