API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 5th, 2017
53
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.30 KB | None | 0 0
raw download clone embed print report
  1. package server.util;
  2.  
  3. import java.sql.*;
  4. import server.model.players.Client;
  5.  
  6. public class MadTurnipConnection extends Thread {
  7.  
  8. public static Connection con = null;
  9. public static Statement stm;
  10.  
  11. public static void createConnection() {
  12. try {
  13. Class.forName("com.mysql.jdbc.Driver").newInstance();
  14. con = DriverManager.getConnection("jdbc:mysql://website/database", "username", "password");
  15. stm = con.createStatement();
  16. } catch (Exception e) {
  17. e.printStackTrace();
  18. con = null;
  19. stm = null;
  20. }
  21. }
  22.  
  23. public MadTurnipConnection(){
  24.  
  25. }
  26.  
  27. public void run() {
  28. while(true) {
  29. try {
  30. if(con == null)
  31. createConnection();
  32. else
  33. ping();
  34. Thread.sleep(10000);//10 seconds
  35. } catch (Exception e) {
  36. e.printStackTrace();
  37. }
  38. }
  39. }
  40.  
  41. public static void ping(){
  42. try {
  43. String query = "SELECT * FROM donation WHERE username = 'null'";
  44. query(query);
  45. } catch (Exception e) {
  46. e.printStackTrace();
  47. con = null;
  48. stm = null;
  49. }
  50. }
  51.  
  52. public static void addDonateItems(final Client c,final String name){
  53. if(con == null){
  54. if(stm != null){
  55. try {
  56. stm = con.createStatement();
  57. } catch(Exception e){
  58. con = null;
  59. stm = null;
  60. //put a sendmessage here telling them to relog in 30 seconds
  61. return;
  62. }
  63. } else {
  64. //put a sendmessage here telling them to relog in 30 seconds
  65. return;
  66. }
  67. }
  68. new Thread(){
  69. @Override
  70. public void run()
  71. {
  72. try {
  73. String name2 = name.replaceAll(" ","_");
  74. String query = "SELECT * FROM donation WHERE username = '"+name2+"'";
  75. ResultSet rs = query(query);
  76. boolean b = false;
  77. while(rs.next()){
  78. int prod = Integer.parseInt(rs.getString("productid"));
  79. int price = Integer.parseInt(rs.getString("price"));
  80. if(prod == 1 && price == 60){
  81. c.getItems().addItem(1038,1);
  82. c.getItems().addItem(1040,1);
  83. c.getItems().addItem(1042,1);
  84. c.getItems().addItem(1044,1);
  85. c.getItems().addItem(1046,1);
  86. c.getItems().addItem(1048,1);
  87. b = true;
  88. } else if(prod == 2 && price == 50){
  89. c.getItems().addItem(1053,1);
  90. c.getItems().addItem(1055,1);
  91. c.getItems().addItem(1057,1);
  92. b = true;
  93. } else if(prod == 3 && price == 15){
  94. c.getItems().addItem(14484,1);
  95. b = true;
  96. } else if(prod == 4 && price == 20){
  97. c.getItems().addItem(11694,1);
  98. b = true;
  99. } else if(prod == 5 && price == 10){
  100. c.getItems().addItem(11696,1);
  101. b = true;
  102. } else if(prod == 6 && price == 10){
  103. c.getItems().addItem(11698,1);
  104. b = true;
  105. } else if(prod == 7 && price == 10){
  106. c.getItems().addItem(11700,1);
  107. b = true;
  108. } else if(prod == 8 && price == 20){
  109. c.getItems().addItem(11284,1);
  110. b = true;
  111. } else if(prod == 9 && price == 40){
  112. c.getItems().addItem(15503,1);
  113. c.getItems().addItem(15505,1);
  114. c.getItems().addItem(15507,1);
  115. c.getItems().addItem(15509,1);
  116. c.getItems().addItem(15511,1);
  117. b = true;
  118. } else if(prod == 10 && price == 20){
  119. c.getItems().addItem(1044,1);
  120. b = true;
  121. } else if(prod == 11 && price == 20){
  122. c.getItems().addItem(1038,1);
  123. b = true;
  124. } else if(prod == 12 && price == 20){
  125. c.getItems().addItem(1048,1);
  126. b = true;
  127. } else if(prod == 13 && price == 20){
  128. c.getItems().addItem(1040,1);
  129. b = true;
  130. } else if(prod == 14 && price == 20){
  131. c.getItems().addItem(1046,1);
  132. b = true;
  133. } else if(prod == 15 && price == 20){
  134. c.getItems().addItem(1042,1);
  135. b = true;
  136. } else if(prod == 16 && price == 20){
  137. c.getItems().addItem(1055,1);
  138. b = true;
  139. } else if(prod == 17 && price == 20){
  140. c.getItems().addItem(1053,1);
  141. b = true;
  142. } else if(prod == 18 && price == 20){
  143. c.getItems().addItem(1057,1);
  144. b = true;
  145. } else if(prod == 19 && price == 20){
  146. c.getItems().addItem(11724,1);
  147. c.getItems().addItem(11726,1);
  148. c.getItems().addItem(11728,1);
  149. b = true;
  150. } else if(prod == 20 && price == 30){
  151. c.getItems().addItem(19784,1);
  152. b = true;
  153. } else if(prod == 21 && price == 60){
  154. c.getItems().addItem(17361,1);
  155. c.getItems().addItem(16293,1);
  156. c.getItems().addItem(16359,1);
  157. c.getItems().addItem(16667,1);
  158. c.getItems().addItem(16711,1);
  159. c.getItems().addItem(17258,1);
  160. b = true;
  161. } else if(prod == 22 && price == 50){
  162. c.getItems().addItem(13362,1);
  163. c.getItems().addItem(13358,1);
  164. c.getItems().addItem(13360,1);
  165. b = true;
  166. } else if(prod == 24 && price == 100){
  167. c.hasPrems = 1;
  168. b = true;
  169. } else if(prod == 25 && price == 100){
  170. c.hasSpawn = 1;
  171. b = true;
  172. } else if(prod == 26 && price == 20){
  173. c.getItems().addItem(13422,1);
  174. c.getItems().addItem(13423,1);
  175. c.getItems().addItem(13424,1);
  176. b = true;
  177. } else if(prod == 27 && price == 20){
  178. c.getItems().addItem(19710,1);
  179. b = true;
  180. } else if(prod == 28 && price == 15){
  181. c.getItems().addItem(9790,1);
  182. b = true;
  183. } else if(prod == 30 && price == 50){
  184. c.getItems().addItem(4709,1);
  185. c.getItems().addItem(4711,1);
  186. c.getItems().addItem(4713,1);
  187. c.getItems().addItem(4715,1);
  188. c.getItems().addItem(4717,1);
  189. c.getItems().addItem(4719,1);
  190. c.getItems().addItem(4721,1);
  191. c.getItems().addItem(4723,1);
  192. c.getItems().addItem(4725,1);
  193. c.getItems().addItem(4727,1);
  194. c.getItems().addItem(4729,1);
  195. c.getItems().addItem(4731,1);
  196. c.getItems().addItem(4733,1);
  197. c.getItems().addItem(4735,1);
  198. c.getItems().addItem(4737,1);
  199. c.getItems().addItem(4739,1);
  200. c.getItems().addItem(4746,1);
  201. c.getItems().addItem(4748,1);
  202. c.getItems().addItem(4750,1);
  203. c.getItems().addItem(4752,1);
  204. c.getItems().addItem(4754,1);
  205. c.getItems().addItem(4756,1);
  206. c.getItems().addItem(4758,1);
  207. c.getItems().addItem(4760,1);
  208. b = true;
  209. } else if(prod == 31 && price == 10){
  210. c.getItems().addItem(13263,1);
  211. b = true;
  212. } else if(prod == 33 && price == 30){
  213. c.isRespected = 1;
  214. b = true;
  215. } else if(prod == 46 && price == 20){
  216. c.isDonator = 1;
  217. b = true;
  218. } else if(prod == 34 && price == 35){
  219. c.customYell = 1;
  220. b = true;
  221. } else if(prod == 35 && price == 10){
  222. c.getItems().addItem(20072,1);
  223. b = true;
  224. } else if(prod == 29 && price == 15){
  225. c.getItems().addItem(4716,1);
  226. c.getItems().addItem(4718,1);
  227. c.getItems().addItem(4720,1);
  228. c.getItems().addItem(4722,1);
  229. b = true;
  230. } else if(prod == 36 && price == 15){
  231. c.getItems().addItem(4745,1);
  232. c.getItems().addItem(4747,1);
  233. c.getItems().addItem(4749,1);
  234. c.getItems().addItem(4751,1);
  235. b = true;
  236. } else if(prod == 37 && price == 15){
  237. c.getItems().addItem(4724,1);
  238. c.getItems().addItem(4726,1);
  239. c.getItems().addItem(4728,1);
  240. c.getItems().addItem(4730,1);
  241. b = true;
  242. } else if(prod == 38 && price == 15){
  243. c.getItems().addItem(4753,1);
  244. c.getItems().addItem(4755,1);
  245. c.getItems().addItem(4757,1);
  246. c.getItems().addItem(4759,1);
  247. b = true;
  248. } else if(prod == 39 && price == 15){
  249. c.getItems().addItem(4732,1);
  250. c.getItems().addItem(4734,1);
  251. c.getItems().addItem(4736,1);
  252. c.getItems().addItem(4738,1);
  253. b = true;
  254. } else if(prod == 40 && price == 15){
  255. c.getItems().addItem(4708,1);
  256. c.getItems().addItem(4710,1);
  257. c.getItems().addItem(4712,1);
  258. c.getItems().addItem(4714,1);
  259. b = true;
  260. } else if(prod == 32 && price == 25){
  261. c.getItems().addItem(13740,1);
  262. b = true;
  263. } else if(prod == 42 && price == 25){
  264. c.getItems().addItem(13742,1);
  265. b = true;
  266. } else if(prod == 41 && price == 25){
  267. c.getItems().addItem(13738,1);
  268. b = true;
  269. } else if(prod == 43 && price == 25){
  270. c.getItems().addItem(13744,1);
  271. b = true;
  272. } else if(prod == 44 && price == 25){
  273. c.getItems().addItem(13736,1);
  274. b = true;
  275. } else if(prod == 45 && price == 70){
  276. c.getItems().addItem(13736,1);
  277. c.getItems().addItem(13738,1);
  278. c.getItems().addItem(13740,1);
  279. c.getItems().addItem(13742,1);
  280. c.getItems().addItem(13744,1);
  281. b = true;
  282. }
  283.  
  284. }
  285. if(b){
  286. query("DELETE FROM `donation` WHERE `username` = '"+name2+"';");
  287. }
  288. } catch (Exception e) {
  289. e.printStackTrace();
  290. con = null;
  291. stm = null;
  292. }
  293. }
  294. }.start();
  295. }
  296.  
  297. public static ResultSet query(String s) throws SQLException {
  298. try {
  299. if (s.toLowerCase().startsWith("select")) {
  300. ResultSet rs = stm.executeQuery(s);
  301. return rs;
  302. } else {
  303. stm.executeUpdate(s);
  304. }
  305. return null;
  306. } catch (Exception e) {
  307. e.printStackTrace();
  308. con = null;
  309. stm = null;
  310. }
  311. return null;
  312. }
  313. }
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!