Code:
if (playerCommand.startsWith("donated")) {
if (!Config.MYSQL_ACTIVE) {
c.sendMessage("Sorry this is currently disabled.");
return;
} else {
try {
String name2 = c.playerName.replaceAll(" ","_");
PreparedStatement ps = Database.getConnection().prepareStatement("SELECT * FROM `donation` WHERE `username` = '"+name2+"'");
ResultSet rs = ps.executeQuery();
boolean b = false;
if(rs.next()){
int prod = Integer.parseInt(rs.getString("productid"));
int price = Integer.parseInt(rs.getString("price"));
if(prod == 1 && price == 3.50){
c.playerRights = 4;
c.isDonator = 1;
b = true;
} else if(prod == 2 && price == 2.50){
c.getItems().addItem(15241,1);
c.getItems().addItem(15243,500);
b = true;
} else if(prod == 3 && price == 10.00){
c.getItems().addItem(13450,1);
b = true;
} else if(prod == 4 && price == 8.50){
c.getItems().addItem(13452,1);
b = true;
} else if(prod == 5 && price == 7.00){
c.getItems().addItem(13451,1);
b = true;
} else if(prod == 6 && price == 6.00){
c.getItems().addItem(13453,1);
b = true;
} else if(prod == 7 && price == 10.00){
c.getItems().addItem(13458,1);
c.getItems().addItem(13459,1);
c.getItems().addItem(13460,1);
b = true;
} else if(prod == 8 && price == 10.00){
c.getItems().addItem(13362,1);
b = true;
} else if(prod == 9 && price == 10.00){
c.getItems().addItem(13358,1);
b = true;
} else if(prod == 10 && price == 10.00){
c.getItems().addItem(13360,1);
b = true;
} else if(prod == 11 && price == 8.00){
c.getItems().addItem(13350,1);
b = true;
} else if(prod == 12 && price == 8.00){
c.getItems().addItem(13348,1);
b = true;
} else if(prod == 13 && price == 8.00){
c.getItems().addItem(13346,1);
b = true;
} else if(prod == 14 && price == 8.00){
c.getItems().addItem(13355,1);
b = true;
} else if(prod == 15 && price == 8.00){
c.getItems().addItem(13354,1);
b = true;
} else if(prod == 16 && price == 8.00){
c.getItems().addItem(13352,1);
b = true;
} else if(prod == 17 && price == 17.50){
c.getItems().addItem(1042,1);
b = true;
} else if(prod == 18 && price == 15.00){
c.getItems().addItem(1044,1);
b = true;
} else if(prod == 19 && price == 15.00){
c.getItems().addItem(1040,1);
b = true;
} else if(prod == 20 && price == 15.00){
c.getItems().addItem(1038,1);
b = true;
} else if(prod == 21 && price == 13.50){
c.getItems().addItem(1046,1);
b = true;
} else if(prod == 22 && price == 17.50){
c.getItems().addItem(1048,1);
b = true;
} else if(prod == 23 && price == 11.00){
c.getItems().addItem(1057,1);
b = true;
} else if(prod == 24 && price == 11.00){
c.getItems().addItem(1055,1);
b = true;
} else if(prod == 25 && price == 11.00){
c.getItems().addItem(1053,1);
b = true;
} else if(prod == 26 && price == 10.00){
c.getItems().addItem(1050,1);
b = true;
} else if(prod == 27 && price == 6.00){
c.getItems().addItem(1419,1);
b = true;
} else if(prod == 28 && price == 10.00){
c.getItems().addItem(1037,1);
b = true;
} else if(prod == 29 && price == 12.50){
c.getItems().addItem(18349,1);
b = true;
} else if(prod == 30 && price == 12.50){
c.getItems().addItem(18353,1);
b = true;
} else if(prod == 31 && price == 4.00){
c.getItems().addItem(11730,1);
b = true;
} else if(prod == 32 && price == 5.00){
c.getItems().addItem(11283,1);
b = true;
} else if(prod == 33 && price == 12.50){
c.getItems().addItem(13887,1);
c.getItems().addItem(13893,1);
c.getItems().addItem(13899,1);
b = true;
} else if(prod == 34 && price == 12.50){
c.getItems().addItem(13884,1);
c.getItems().addItem(13890,1);
c.getItems().addItem(13896,1);
c.getItems().addItem(13902,1);
b = true;
} else if(prod == 35 && price == 11.00){
c.getItems().addItem(13870,1);
c.getItems().addItem(13873,1);
c.getItems().addItem(13876,1);
b = true;
} else if(prod == 36 && price == 11.00){
c.getItems().addItem(13858,1);
c.getItems().addItem(13861,1);
c.getItems().addItem(13864,1);
c.getItems().addItem(13867,1);
b = true;
} else if(prod == 37 && price == 5.00){
c.getItems().addItem(8839,1);
c.getItems().addItem(8840,1);
c.getItems().addItem(8841,1);
c.getItems().addItem(8842,1);
c.getItems().addItem(11663,1);
c.getItems().addItem(11664,1);
c.getItems().addItem(11665,1);
b = true;
} else if(prod == 38 && price == 10.00){
c.getItems().addItem(10400,1);
c.getItems().addItem(10402,1);
b = true;
} else if(prod == 39 && price == 10.00){
c.getItems().addItem(10404,1);
c.getItems().addItem(10406,1);
b = true;
} else if(prod == 40 && price == 10.00){
c.getItems().addItem(10408,1);
c.getItems().addItem(10410,1);
b = true;
} else if(prod == 41 && price == 10.00){
c.getItems().addItem(10412,1);
c.getItems().addItem(10414,1);
b = true;
} else if(prod == 42 && price == 10.00){
c.getItems().addItem(10416,1);
c.getItems().addItem(10418,1);
b = true;
} else if(prod == 43 && price == 10.00){
c.getItems().addItem(10420,1);
c.getItems().addItem(10422,1);
b = true;
} else if(prod == 44 && price == 1.00){
c.getItems().addItem(1042,1);
b = true;
}
} else {
c.sendMessage("You haven't donated or we havn't received your payment.");
}
if(b){
ps = Database.getConnection().prepareStatement("DELETE FROM `donation` WHERE `username` = '"+name2+"';");
}
ps.close();
} catch (Exception e) {
e.printStackTrace();
}
}
return;
}
It compiles and executes without an error but the player doesn't receive the item... Help please?