示例#1
0
  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;
  }
示例#2
0
  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;
    }
  }
示例#3
0
  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;
    }
  }