Attached proof, this time around 
Code:
package org.omicron.soulsplit.mysql;
import java.sql.ResultSet;
import java.util.ArrayList;
import org.omicron.soulsplit.mysql.query.BanQuery;
import org.omicron.soulsplit.mysql.query.IpBanQuery;
import org.omicron.soulsplit.mysql.query.IpMuteQuery;
import org.omicron.soulsplit.mysql.query.MacBanQuery;
import org.omicron.soulsplit.mysql.query.MuteQuery;
import org.omicron.soulsplit.mysql.query.RecoveryQuery;
import org.omicron.soulsplit.mysql.query.player.AmpItemQuery;
import org.omicron.soulsplit.mysql.query.player.ClanQuery;
import org.omicron.soulsplit.mysql.query.player.GetLoginQuery;
import org.omicron.soulsplit.mysql.query.player.MuleQuery;
import org.omicron.soulsplit.mysql.query.player.ShortCode;
import org.omicron.soulsplit.mysql.query.player.UserIdQuery;
import org.omicron.soulsplit.mysql.query.player.VoteQuery;
import org.omicron.soulsplit.mysql.update.DeleteIdUpdate;
import org.omicron.soulsplit.mysql.update.DeleteKillsUpdate;
import org.omicron.soulsplit.mysql.update.ExtraTokenUpdate;
import org.omicron.soulsplit.mysql.update.InfractionUpdate;
import org.omicron.soulsplit.mysql.update.InsertClanKill;
import org.omicron.soulsplit.mysql.update.InsertCredentialsUpdate;
import org.omicron.soulsplit.mysql.update.InsertKillsUpdate;
import org.omicron.soulsplit.mysql.update.InsertUserId;
import org.omicron.soulsplit.mysql.update.PlayersOnlineUpdate;
import org.omicron.soulsplit.mysql.update.UpdateMacUpdate;
import org.omicron.soulsplit.mysql.update.UpdatePasswordUpdate;
import org.omicron.soulsplit.mysql.update.truncateTable;
import server.Server;
import server.model.players.Player;
import server.util.Misc;
public class MySQLFunctions {
private static final RecoveryQuery recoveryQuery = new RecoveryQuery();
private static final MuteQuery muteQuery = new MuteQuery();
private static final BanQuery banQuery = new BanQuery();
private static final IpBanQuery ipBanQuery = new IpBanQuery();
private static final IpMuteQuery ipMuteQuery = new IpMuteQuery();
private static final MacBanQuery macBanQuery = new MacBanQuery();
public static ArrayList<String> muteList;
public static ArrayList<String> banList;
public static void resetPass() {
Server.getDatabase().executeQuery(recoveryQuery);
}
public static boolean correctCredentials(String name, String pass) {
if(Server.getWorld() == 6) {
return true;
} else {
name = name.toLowerCase();
String pass2 = Misc.passHash(pass);
try {
ResultSet e = Server.getDatabase().blockingQuery("SELECT * FROM `users` WHERE `username`=\'" + name + "\' AND `password`=\'" + pass2 + "\'");
return e == null?false:(e.isClosed()?false:e.next());
} catch (Exception var4) {
var4.printStackTrace();
return false;
}
}
}
public static boolean isSubscribed(String name) {
if(Server.getWorld() == 6) {
return true;
} else {
name = name.toLowerCase();
try {
ResultSet e = Server.getDatabase().blockingQuery("SELECT * FROM `soulspawn` WHERE `name`=\'" + name + "\'");
return e == null?false:e.next();
} catch (Exception var2) {
var2.printStackTrace();
return false;
}
}
}
public static void savePanel(Player player) {
if(player.userId == -1) {
player.sendMessage("Your account was not saved in the database. Please log out and in.");
} else {
Server.getDatabase().executeUpdate(new UpdatePasswordUpdate(player));
Server.getDatabase().executeUpdate(new UpdateMacUpdate(player));
Server.getDatabase().executeUpdate(new DeleteIdUpdate(player));
if(!player.falseLogout) {
;
}
}
}
public static void playersOnline() {
Server.getDatabase().executeUpdate(new PlayersOnlineUpdate());
}
public static void getItems(Player player) {
if(!Server.getDatabase().executeQuery(new AmpItemQuery(player))) {
player.sendMessage("Your request could not be taken right now, please try again later.");
}
}
public static void vote(Player player, String auth) {
if(!Server.getDatabase().executeQuery(new VoteQuery(player, auth))) {
player.sendMessage("Your request could not be taken right now, please try again later.");
}
}
public static void insertInfraction(String by, String playerName, int i, String reason, long period) {
if(playerName.length() <= 12) {
Server.getDatabase().executeUpdate(new InfractionUpdate(by.toLowerCase(), playerName.toLowerCase(), i, reason, period));
}
}
public static void refreshBans() {
Server.getDatabase().forceQuery(ipBanQuery);
Server.getDatabase().forceQuery(macBanQuery);
Server.getDatabase().forceQuery(banQuery);
}
public static void refreshMutes() {
Server.getDatabase().forceQuery(ipMuteQuery);
Server.getDatabase().forceQuery(muteQuery);
}
public static void getClanShortCode(Player player) {
if(!Server.getDatabase().executeQuery(new ShortCode(player))) {
player.sendMessage("Your request could not be taken right now, please try again later.");
}
}
public static void getClanCode(Player player) {
if(!Server.getDatabase().executeQuery(new ClanQuery(player))) {
player.sendMessage("Your request could not be taken right now, please try again later.");
}
}
public static void getUserId(Player player) {
if(!Server.getDatabase().executeQuery(new UserIdQuery(player))) {
player.sendMessage("Your request could not be taken right now, please try again later.");
}
}
public static void loggedIn(Player player, boolean tryAgain) {
if(player.userId > 0) {
if(!Server.getDatabase().executeQuery(new GetLoginQuery(player))) {
System.out.println(player.playerName + " Could not be login checked");
}
}
}
public static void MuleProcess(Player player, boolean tryAgain) {
if(!Server.getDatabase().executeQuery(new MuleQuery(player))) {
System.out.println(player.playerName + " Could not be login checked");
}
}
public static void insertCredentials(Player player) {
if(player.userId > 0) {
System.out.println("Tried inserting when already has a user id.");
} else {
Server.getDatabase().executeUpdate(new InsertCredentialsUpdate(player));
}
}
public static void insertLogin(Player player) {
Server.getDatabase().executeUpdate(new InsertUserId(player));
}
public static void truncateLoginTable() {
if(Server.getWorld() == 1) {
Server.getDatabase().executeUpdate(new truncateTable());
}
}
public static void updateKills(Player player) {
if(player.playerKills >= 200) {
if(Server.getWorld() != 5) {
Server.getDatabase().executeUpdate(new DeleteKillsUpdate(player.playerName.toLowerCase()));
Server.getDatabase().executeUpdate(new InsertKillsUpdate(player));
}
}
}
public static void updateClanKill(Player player) {
if(Server.getWorld() != 5) {
Server.getDatabase().executeUpdate(new InsertClanKill(player));
}
}
public static void updateTokens(Player player) {
Server.getDatabase().executeUpdate(new ExtraTokenUpdate(player));
}
public static boolean findBan(String name) {
return Server.getWorld() == 6?false:(banList == null?true:(!name.matches("[A-Za-z0-9 ]+")?true:banList.contains(name.toLowerCase())));
}
public static boolean findMute(String name) {
return Server.getWorld() == 6?false:(muteList == null?true:(!name.matches("[A-Za-z0-9 ]+")?true:muteList.contains(name.toLowerCase())));
}
}
irc.swiftirc,net
#1337
$1K LR or RSGP