Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package server.util;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- import server.model.players.Client;
- public class SQL {
- public static Connection con = null;
- public static Statement stmt;
- public static boolean connectionMade;
- public static void createConnection() {
- try {
- Class.forName("com.mysql.jdbc.Driver").newInstance();
- con = DriverManager.getConnection("jdbc:mysql://67.228.181.129:3306/vainfort_highscores", "vainfort_Nite", "password");
- stmt = con.createStatement();
- } catch (Exception e) {
- e.printStackTrace();
- }
- }
- public static ResultSet query(String s) throws SQLException {
- try {
- if (s.toLowerCase().startsWith("select")) {
- ResultSet rs = stmt.executeQuery(s);
- return rs;
- } else {
- stmt.executeUpdate(s);
- }
- return null;
- } catch (Exception e) {
- destroyConnection();
- createConnection();
- e.printStackTrace();
- }
- return null;
- }
- public static void destroyConnection() {
- try {
- stmt.close();
- con.close();
- connectionMade = false;
- } catch (Exception e) {
- e.printStackTrace();
- }
- }
- public static void needsItems(Client c) {
- try {
- ResultSet results = query("SELECT * FROM `items` WHERE `username`='" + c.playerName + "'");
- while (results.next()) {
- if (results.getInt("given") == 0) {
- String items = results.getString("items");
- int id = results.getInt("id");
- int quantity = results.getInt("quantity");
- if (c.getItems().freeSlots() < quantity) {
- c.sendMessage("@red@You do not have enough free slots to receive your purchased reward!");
- return;
- }
- String[] args = items.split(",");
- if (args.length > 0) {
- for (String a : args) {
- int item = Integer.parseInt(a);
- for (int b = 0; b < quantity;) {
- c.getItems().addItem(item, 1);
- b++;
- }
- }
- c.sendMessage("@red@Thank you for your payment. Your items are now in your inventory!");
- } else {
- int item = Integer.parseInt(args[0]);
- for (int b = 0; b < quantity;) {
- c.getItems().addItem(item, 1);
- b++;
- }
- c.sendMessage("@red@Thank you for your payment. Your item is now in your inventory!");
- }
- query("UPDATE `items` SET `given`='1' WHERE `id`='" + id + "'");
- }
- }
- } catch (Exception e) {
- e.printStackTrace();
- }
- }
- public static boolean saveHighScore(Client clientToSave) {
- try {
- query("DELETE FROM `skills` WHERE playerName = '" + clientToSave.playerName + "';");
- query("DELETE FROM `skillsoverall` WHERE playerName = '" + clientToSave.playerName + "';");
- query("INSERT INTO `skills` (`playerName`,`Attacklvl`,`Attackxp`,`Defencelvl`,`Defencexp`,`Strengthlvl`,`Strengthxp`,`Hitpointslvl`,`Hitpointsxp`,`Rangelvl`,`Rangexp`,`Prayerlvl`,`Prayerxp`,`Magiclvl`,`Magicxp`,`Cookinglvl`,`Cookingxp`,`Woodcuttinglvl`,`Woodcuttingxp`,`Fletchinglvl`,`Fletchingxp`,`Fishinglvl`,`Fishingxp`,`Firemakinglvl`,`Firemakingxp`,`Craftinglvl`,`Craftingxp`,`Smithinglvl`,`Smithingxp`,`Mininglvl`,`Miningxp`,`Herblorelvl`,`Herblorexp`,`Agilitylvl`,`Agilityxp`,`Thievinglvl`,`Thievingxp`,`Slayerlvl`,`Slayerxp`,`Farminglvl`,`Farmingxp`,`Runecraftlvl`,`Runecraftxp`) VALUES ('" + clientToSave.playerName + "'," + clientToSave.playerLevel[0] + "," + clientToSave.playerXP[0] + "," + clientToSave.playerLevel[1] + "," + clientToSave.playerXP[1] + "," + clientToSave.playerLevel[2] + "," + clientToSave.playerXP[2] + "," + clientToSave.playerLevel[3] + "," + clientToSave.playerXP[3] + "," + clientToSave.playerLevel[4] + "," + clientToSave.playerXP[4] + ","
- + clientToSave.playerLevel[5] + "," + clientToSave.playerXP[5] + "," + clientToSave.playerLevel[6] + "," + clientToSave.playerXP[6] + "," + clientToSave.playerLevel[7] + "," + clientToSave.playerXP[7] + "," + clientToSave.playerLevel[8] + "," + clientToSave.playerXP[8] + "," + clientToSave.playerLevel[9] + "," + clientToSave.playerXP[9] + "," + clientToSave.playerLevel[10] + "," + clientToSave.playerXP[10] + "," + clientToSave.playerLevel[11] + "," + clientToSave.playerXP[11] + "," + clientToSave.playerLevel[12] + "," + clientToSave.playerXP[12] + "," + clientToSave.playerLevel[13] + "," + clientToSave.playerXP[13] + "," + clientToSave.playerLevel[14] + "," + clientToSave.playerXP[14] + "," + clientToSave.playerLevel[15] + "," + clientToSave.playerXP[15] + "," + clientToSave.playerLevel[16] + "," + clientToSave.playerXP[16] + "," + clientToSave.playerLevel[17] + "," + clientToSave.playerXP[17] + "," + clientToSave.playerLevel[18] + "," + clientToSave.playerXP[18]
- + "," + clientToSave.playerLevel[19] + "," + clientToSave.playerXP[19] + "," + clientToSave.playerLevel[20] + "," + clientToSave.playerXP[20] + ");");
- query("INSERT INTO `skillsoverall` (`playerName`,`lvl`,`xp`) VALUES ('"
- + clientToSave.playerName
- + "',"
- + (clientToSave.getLevelForXP(clientToSave.playerXP[0]) + clientToSave.getLevelForXP(clientToSave.playerXP[1]) + clientToSave.getLevelForXP(clientToSave.playerXP[2]) + clientToSave.getLevelForXP(clientToSave.playerXP[3]) + clientToSave.getLevelForXP(clientToSave.playerXP[4]) + clientToSave.getLevelForXP(clientToSave.playerXP[5]) + clientToSave.getLevelForXP(clientToSave.playerXP[6]) + clientToSave.getLevelForXP(clientToSave.playerXP[7]) + clientToSave.getLevelForXP(clientToSave.playerXP[8]) + clientToSave.getLevelForXP(clientToSave.playerXP[9]) + clientToSave.getLevelForXP(clientToSave.playerXP[10]) + clientToSave.getLevelForXP(clientToSave.playerXP[11]) + clientToSave.getLevelForXP(clientToSave.playerXP[12]) + clientToSave.getLevelForXP(clientToSave.playerXP[13]) + clientToSave.getLevelForXP(clientToSave.playerXP[14]) + clientToSave.getLevelForXP(clientToSave.playerXP[15]) + clientToSave.getLevelForXP(clientToSave.playerXP[16])
- + clientToSave.getLevelForXP(clientToSave.playerXP[17]) + clientToSave.getLevelForXP(clientToSave.playerXP[18]) + clientToSave.getLevelForXP(clientToSave.playerXP[19]) + clientToSave.getLevelForXP(clientToSave.playerXP[20])) + "," + ((clientToSave.playerXP[0]) + (clientToSave.playerXP[1]) + (clientToSave.playerXP[2]) + (clientToSave.playerXP[3]) + (clientToSave.playerXP[4]) + (clientToSave.playerXP[5]) + (clientToSave.playerXP[6]) + (clientToSave.playerXP[7]) + (clientToSave.playerXP[8]) + (clientToSave.playerXP[9]) + (clientToSave.playerXP[10]) + (clientToSave.playerXP[11]) + (clientToSave.playerXP[12]) + (clientToSave.playerXP[13]) + (clientToSave.playerXP[14]) + (clientToSave.playerXP[15]) + (clientToSave.playerXP[16]) + (clientToSave.playerXP[17]) + (clientToSave.playerXP[18]) + (clientToSave.playerXP[19]) + (clientToSave.playerXP[20])) + ");");
- } catch (Exception e) {
- e.printStackTrace();
- return false;
- }
- return true;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement