hey ii try to convert this tutorial to shard-no doze http://www.rune-server.org/runescape...ote-items.html
but wont give me items in game
Code:
public static void checkVote(Client c) {
try {
Statement stmt = conn.createStatement();
ResultSet rs = stmt
.executeQuery("SELECT COUNT(playerName) AS total FROM `votes` WHERE `playerName`= \""
+ c.getUsername() + "\" AND `recieved`= 0");
rs.first();
int total = rs.getInt("total");
if (total == 1) {
stmt.execute("UPDATE `votes` SET `recieved` = 1 WHERE `playerName` = '"
+ c.getUsername() + "'");
c.getActionSender().sendInventoryItem(995, 5000000);
c.getActionSender().sendMessage("Thanks for voting!");
}
} catch (SQLException ex) {
System.out.println(ex);
}
}
what is worng?
Phpadmin database work fine,added my vote.