Yeah as you can see my post count is now 1!
I have been trying to get help on Runelocus for ages now. But the community just doesn't want to help anyone So I have moved here to see what it is like
Anyway.. On topic
< -- Click IMAGE to see more detail
This error comes up when I logout of my server - Note: I put the vote system in the logout method in client.java just because in initialize it ass rapes my server. So it is only there until I fix it.
Here are the codes:
Client.java
Code:
public void logout() {
MysqlManager.checkVote(this);
MysqlManager.java
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.playerName + "\" AND `recieved`= 0");
rs.first();
int total = rs.getInt("total");
if (total == 1) {
stmt.execute("UPDATE `votes` SET `recieved` = 1 WHERE `playerName` = '"
+ c.playerName + "'");
c.getItems().addItem(995, 10000000);
c.sendMessage("Thanks for voting!");
}
} catch (SQLException ex) {
System.out.println(ex);
}
}
So yeah if someone could help me ASAP I would appreciate it very much
Thanks
Auto
EDIT: I used Joshua's tutorial > http://www.rune-server.org/runescape...ote-items.html