API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 14th, 2017
73
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.90 KB | None | 0 0
raw download clone embed print report
  1. package palidino76.rs2.io;
  2.  
  3. import java.sql.*;
  4. import java.security.MessageDigest;
  5. import java.util.*;
  6. import java.lang.*;
  7. import palidino76.rs2.Server;
  8. import palidino76.rs2.Engine;
  9. import palidino76.rs2.io.*;
  10. import palidino76.rs2.player.Player;
  11. import palidino76.rs2.util.Misc;
  12.  
  13. public class SQL {
  14.  
  15.  
  16. public static Connection con = null;
  17. public static Statement stmt;
  18.  
  19. public static void createConnection() {
  20. try {
  21. Class.forName("com.mysql.jdbc.Driver").newInstance();
  22. String IP="localhost";
  23. String DB="DATABASE";
  24. String User="root";
  25. String Pass="PASSWORD";
  26. con = DriverManager.getConnection("jdbc:mysql://"+IP+"/"+DB, User, Pass);
  27. stmt = con.createStatement();
  28. Misc.println("Connection to SQL database successful!");
  29. } catch (Exception e) {
  30. Misc.println("Connection to SQL database failed");
  31. e.printStackTrace();
  32. }
  33. }
  34. public static ResultSet query(String s) throws SQLException {
  35. try {
  36. if (s.toLowerCase().startsWith("select")) {
  37. ResultSet rs = stmt.executeQuery(s);
  38. Misc.println("Success");
  39. return rs;
  40. } else {
  41. stmt.executeUpdate(s);
  42. }
  43. return null;
  44. } catch (Exception e) {
  45. destroyConnection();
  46. createConnection();
  47. Misc.println("Failed");
  48. //e.printStackTrace();
  49. }
  50. return null;
  51. }
  52.  
  53. public static void destroyConnection() {
  54. try {
  55. stmt.close();
  56. con.close();
  57. Misc.println("Destruction from SQL database successful");
  58. } catch (Exception e) {
  59. Misc.println("Destruction from SQL database successful");
  60. //e.printStackTrace();
  61. }
  62. }
  63.  
  64. public static boolean saveHighScore(Player p) {
  65. try {
  66. query("DELETE FROM `skills` WHERE playerName = '"+p.username+"';");
  67. query("DELETE FROM `skillsoverall` WHERE playerName = '"+p.username+"';");
  68. 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`,`Hunterlvl`,`Hunterxp`,`Constructionlvl`,`Constructionxp`,`Summoninglvl`,`Summoningxp`) VALUES ('"+p.username+"',"+p.skillLvl[0]+","+p.skillXP[0]+","+p.skillLvl[1]+","+p.skillXP[1]+","+p.skillLvl[2]+","+p.skillXP[2]+","+p.skillLvl[3]+","+p.skillXP[3]+","+p.skillLvl[4]+","+p.skillXP[4]+","+p.skillLvl[5]+","+p.skillXP[5]+","+p.skillLvl[6]+","+p.skillXP[6]+","+p.skillLvl[7]+","+p.skillXP[7]+","+p.skillLvl[8]+","+p.skillXP[8]+","+p.skillLvl[9]+","+p.skillXP[9]+","+p.skillLvl[10]+","+p.skillXP[10]+","+p.skillLvl[11]+","+p.skillXP[11]+","+p.skillLvl[12]+","+p.skillXP[12]+","+p.skillLvl[13]+","+p.skillXP[13]+","+p.skillLvl[14]+","+p.skillXP[14]+","+p.skillLvl[15]+","+p.skillXP[15]+","+p.skillLvl[16]+","+p.skillXP[16]+","+p.skillLvl[17]+","+p.skillXP[17]+","+p.skillLvl[18]+","+p.skillXP[18]+","+p.skillLvl[19]+","+p.skillXP[19]+","+p.skillLvl[20]+","+p.skillXP[20]+","+p.skillLvl[21]+","+p.skillXP[21]+","+p.skillLvl[22]+","+p.skillXP[22]+","+p.skillLvl[23]+","+p.skillXP[23]+");");
  69. query("INSERT INTO `skillsoverall` (`playerName`,`lvl`,`xp`) VALUES ('"+p.username+"',"+(p.skillLvl[0] + p.skillLvl[1] + p.skillLvl[2] + p.skillLvl[3] + p.skillLvl[4] + p.skillLvl[5] + p.skillLvl[6] + p.skillLvl[7] + p.skillLvl[8] + p.skillLvl[9] + p.skillLvl[10] + p.skillLvl[11] + p.skillLvl[12] + p.skillLvl[13] + p.skillLvl[14] + p.skillLvl[15] + p.skillLvl[16] + p.skillLvl[17] + p.skillLvl[18] + p.skillLvl[19] + p.skillLvl[20] + p.skillLvl[21] + p.skillLvl[22] + p.skillLvl[23])+","+((p.skillXP[0]) + (p.skillXP[1]) + (p.skillXP[2]) + (p.skillXP[3]) + (p.skillXP[4]) + (p.skillXP[5]) + (p.skillXP[6]) + (p.skillXP[7]) + (p.skillXP[8]) + (p.skillXP[9]) + (p.skillXP[10]) + (p.skillXP[11]) + (p.skillXP[12]) + (p.skillXP[13]) + (p.skillXP[14]) + (p.skillXP[15]) + (p.skillXP[16]) + (p.skillXP[17]) + (p.skillXP[18]) + (p.skillXP[19]) + (p.skillXP[20]) + (p.skillXP[21]) + (p.skillXP[22]) + (p.skillXP[23]))+");");
  70. Misc.println("Values inserted into SQL database");
  71. } catch (Exception e) {
  72. Misc.println("Values NOT inserted into SQL database");
  73. e.printStackTrace();
  74. return false;
  75. }
  76. return true;
  77. }
  78. }package palidino76.rs2.io;
  79.  
  80. import java.sql.*;
  81. import java.security.MessageDigest;
  82. import java.util.*;
  83. import java.lang.*;
  84. import palidino76.rs2.Server;
  85. import palidino76.rs2.Engine;
  86. import palidino76.rs2.io.*;
  87. import palidino76.rs2.player.Player;
  88. import palidino76.rs2.util.Misc;
  89.  
  90. public class SQL {
  91.  
  92.  
  93. public static Connection con = null;
  94. public static Statement stmt;
  95.  
  96. public static void createConnection() {
  97. try {
  98. Class.forName("com.mysql.jdbc.Driver").newInstance();
  99. String IP="localhost";
  100. String DB="DATABASE";
  101. String User="root";
  102. String Pass="PASSWORD";
  103. con = DriverManager.getConnection("jdbc:mysql://"+IP+"/"+DB, User, Pass);
  104. stmt = con.createStatement();
  105. Misc.println("Connection to SQL database successful!");
  106. } catch (Exception e) {
  107. Misc.println("Connection to SQL database failed");
  108. e.printStackTrace();
  109. }
  110. }
  111. public static ResultSet query(String s) throws SQLException {
  112. try {
  113. if (s.toLowerCase().startsWith("select")) {
  114. ResultSet rs = stmt.executeQuery(s);
  115. Misc.println("Success");
  116. return rs;
  117. } else {
  118. stmt.executeUpdate(s);
  119. }
  120. return null;
  121. } catch (Exception e) {
  122. destroyConnection();
  123. createConnection();
  124. Misc.println("Failed");
  125. //e.printStackTrace();
  126. }
  127. return null;
  128. }
  129.  
  130. public static void destroyConnection() {
  131. try {
  132. stmt.close();
  133. con.close();
  134. Misc.println("Destruction from SQL database successful");
  135. } catch (Exception e) {
  136. Misc.println("Destruction from SQL database successful");
  137. //e.printStackTrace();
  138. }
  139. }
  140.  
  141. public static boolean saveHighScore(Player p) {
  142. try {
  143. query("DELETE FROM `skills` WHERE playerName = '"+p.username+"';");
  144. query("DELETE FROM `skillsoverall` WHERE playerName = '"+p.username+"';");
  145. 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`,`Hunterlvl`,`Hunterxp`,`Constructionlvl`,`Constructionxp`,`Summoninglvl`,`Summoningxp`) VALUES ('"+p.username+"',"+p.skillLvl[0]+","+p.skillXP[0]+","+p.skillLvl[1]+","+p.skillXP[1]+","+p.skillLvl[2]+","+p.skillXP[2]+","+p.skillLvl[3]+","+p.skillXP[3]+","+p.skillLvl[4]+","+p.skillXP[4]+","+p.skillLvl[5]+","+p.skillXP[5]+","+p.skillLvl[6]+","+p.skillXP[6]+","+p.skillLvl[7]+","+p.skillXP[7]+","+p.skillLvl[8]+","+p.skillXP[8]+","+p.skillLvl[9]+","+p.skillXP[9]+","+p.skillLvl[10]+","+p.skillXP[10]+","+p.skillLvl[11]+","+p.skillXP[11]+","+p.skillLvl[12]+","+p.skillXP[12]+","+p.skillLvl[13]+","+p.skillXP[13]+","+p.skillLvl[14]+","+p.skillXP[14]+","+p.skillLvl[15]+","+p.skillXP[15]+","+p.skillLvl[16]+","+p.skillXP[16]+","+p.skillLvl[17]+","+p.skillXP[17]+","+p.skillLvl[18]+","+p.skillXP[18]+","+p.skillLvl[19]+","+p.skillXP[19]+","+p.skillLvl[20]+","+p.skillXP[20]+","+p.skillLvl[21]+","+p.skillXP[21]+","+p.skillLvl[22]+","+p.skillXP[22]+","+p.skillLvl[23]+","+p.skillXP[23]+");");
  146. query("INSERT INTO `skillsoverall` (`playerName`,`lvl`,`xp`) VALUES ('"+p.username+"',"+(p.skillLvl[0] + p.skillLvl[1] + p.skillLvl[2] + p.skillLvl[3] + p.skillLvl[4] + p.skillLvl[5] + p.skillLvl[6] + p.skillLvl[7] + p.skillLvl[8] + p.skillLvl[9] + p.skillLvl[10] + p.skillLvl[11] + p.skillLvl[12] + p.skillLvl[13] + p.skillLvl[14] + p.skillLvl[15] + p.skillLvl[16] + p.skillLvl[17] + p.skillLvl[18] + p.skillLvl[19] + p.skillLvl[20] + p.skillLvl[21] + p.skillLvl[22] + p.skillLvl[23])+","+((p.skillXP[0]) + (p.skillXP[1]) + (p.skillXP[2]) + (p.skillXP[3]) + (p.skillXP[4]) + (p.skillXP[5]) + (p.skillXP[6]) + (p.skillXP[7]) + (p.skillXP[8]) + (p.skillXP[9]) + (p.skillXP[10]) + (p.skillXP[11]) + (p.skillXP[12]) + (p.skillXP[13]) + (p.skillXP[14]) + (p.skillXP[15]) + (p.skillXP[16]) + (p.skillXP[17]) + (p.skillXP[18]) + (p.skillXP[19]) + (p.skillXP[20]) + (p.skillXP[21]) + (p.skillXP[22]) + (p.skillXP[23]))+");");
  147. Misc.println("Values inserted into SQL database");
  148. } catch (Exception e) {
  149. Misc.println("Values NOT inserted into SQL database");
  150. e.printStackTrace();
  151. return false;
  152. }
  153. return true;
  154. }
  155. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!