API tools faq
paste
Guest User

Untitled

a guest
Oct 17th, 2017
97
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 24.34 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(
  15. "jdbc:mysql://localhost/autodonations", "root",
  16. "1a2b34596z");
  17. stm = con.createStatement();
  18. } catch (Exception e) {
  19. e.printStackTrace();
  20. con = null;
  21. stm = null;
  22. }
  23. }
  24.  
  25. public MadTurnipConnection() {
  26.  
  27. }
  28.  
  29. public void run() {
  30. while (true) {
  31. try {
  32. if (con == null) {
  33. createConnection();
  34. System.out.println("AutoDonation connected successfully.");
  35. } else
  36. ping();
  37. Thread.sleep(10000);// 10 seconds
  38. } catch (Exception e) {
  39. e.printStackTrace();
  40. }
  41. }
  42. }
  43.  
  44. public static void ping() {
  45. try {
  46. String query = "SELECT * FROM donation WHERE username = 'null'";
  47. query(query);
  48. } catch (Exception e) {
  49. e.printStackTrace();
  50. con = null;
  51. stm = null;
  52. }
  53. }
  54.  
  55. public static void addDonateItems(final Client c, final String name) {
  56. if (con == null) {
  57. if (stm != null) {
  58. try {
  59. stm = con.createStatement();
  60. } catch (Exception e) {
  61. con = null;
  62. stm = null;
  63. c.sendMessage("Relog to recieve your items.");
  64. return;
  65. }
  66. } else {
  67. c.sendMessage("Relog to recieve your items.");
  68. return;
  69. }
  70. }
  71. new Thread() {
  72. @Override
  73. public void run() {
  74. try {
  75. String name2 = name.replaceAll(" ", "_");
  76. String query = "SELECT * FROM donation WHERE username = '"
  77. + name2 + "'";
  78. ResultSet rs = query(query);
  79. boolean b = false;
  80. while (rs.next()) {
  81. int prod = Integer.parseInt(rs.getString("productid"));
  82. int price = Integer.parseInt(rs.getString("price"));
  83. if (prod == 1 && price == 12.00) {
  84. if (c.playerRights == 0) {
  85. c.getItems().addItem(1038, 1);
  86. c.memberStatus = 1;
  87. c.playerRights = 1;
  88. c.disconnected = true;
  89. b = true;
  90. } else {
  91. c.getItems().addItem(1038, 1);
  92. }
  93. } else if (prod == 2 && price == 12.00) {
  94. if (c.playerRights == 0) {
  95. c.getItems().addItem(1040, 1);
  96. c.memberStatus = 1;
  97. c.playerRights = 1;
  98. c.disconnected = true;
  99. b = true;
  100. } else {
  101. c.getItems().addItem(1040, 1);
  102. b = true;
  103. }
  104. } else if (prod == 3 && price == 12.00) {
  105. if (c.playerRights == 0) {
  106. c.getItems().addItem(1042, 1);
  107. c.memberStatus = 1;
  108. c.playerRights = 1;
  109. c.disconnected = true;
  110. b = true;
  111. } else {
  112. c.getItems().addItem(1042, 1);
  113. b = true;
  114. }
  115. } else if (prod == 4 && price == 12.00) {
  116. if (c.playerRights == 0) {
  117. c.getItems().addItem(1044, 1);
  118. c.memberStatus = 1;
  119. c.playerRights = 1;
  120. c.disconnected = true;
  121. b = true;
  122. } else {
  123. c.getItems().addItem(1044, 1);
  124. b = true;
  125. }
  126. } else if (prod == 5 && price == 12.00) {
  127. if (c.playerRights == 0) {
  128. c.getItems().addItem(1046, 1);
  129. c.memberStatus = 1;
  130. c.playerRights = 1;
  131. c.disconnected = true;
  132. b = true;
  133. } else {
  134. c.getItems().addItem(1046, 1);
  135. b = true;
  136. }
  137. } else if (prod == 6 && price == 12.00) {
  138. if (c.playerRights == 0) {
  139. c.getItems().addItem(1048, 1);
  140. c.memberStatus = 1;
  141. c.playerRights = 1;
  142. c.disconnected = true;
  143. b = true;
  144. } else {
  145. c.getItems().addItem(1048, 1);
  146. b = true;
  147. }
  148. } else if (prod == 7 && price == 12.00) {
  149. if (c.playerRights == 0) {
  150. c.getItems().addItem(4977, 1);
  151. c.memberStatus = 1;
  152. c.playerRights = 1;
  153. c.disconnected = true;
  154. b = true;
  155. } else {
  156. c.getItems().addItem(4977, 1);
  157. b = true;
  158. }
  159. } else if (prod == 8 && price == 12.00) {
  160. if (c.playerRights == 0) {
  161. c.getItems().addItem(4978, 1);
  162. c.memberStatus = 1;
  163. c.playerRights = 1;
  164. c.disconnected = true;
  165. b = true;
  166. } else {
  167. c.getItems().addItem(4978, 1);
  168. b = true;
  169. }
  170. } else if (prod == 9 && price == 12.00) {
  171. if (c.playerRights == 0) {
  172. c.getItems().addItem(4980, 1);
  173. c.memberStatus = 1;
  174. c.playerRights = 1;
  175. c.disconnected = true;
  176. b = true;
  177. } else {
  178. c.getItems().addItem(4980, 1);
  179. b = true;
  180. }
  181. } else if (prod == 10 && price == 12.00) {
  182. if (c.playerRights == 0) {
  183. c.getItems().addItem(10308, 1);
  184. c.memberStatus = 1;
  185. c.playerRights = 1;
  186. c.disconnected = true;
  187. b = true;
  188. } else {
  189. c.getItems().addItem(10308, 1);
  190. b = true;
  191. }
  192. } else if (prod == 11 && price == 12.00) {
  193. if (c.playerRights == 0) {
  194. c.getItems().addItem(10304, 1);
  195. c.memberStatus = 1;
  196. c.playerRights = 1;
  197. c.disconnected = true;
  198. b = true;
  199. } else {
  200. c.getItems().addItem(10304, 1);
  201. b = true;
  202. }
  203. } else if (prod == 12 && price == 12.00) {
  204. if (c.playerRights == 0) {
  205. c.getItems().addItem(10310, 1);
  206. c.memberStatus = 1;
  207. c.playerRights = 1;
  208. c.disconnected = true;
  209. b = true;
  210. } else {
  211. c.getItems().addItem(10310, 1);
  212. b = true;
  213. }
  214. } else if (prod == 13 && price == 12.00) {
  215. if (c.playerRights == 0) {
  216. c.getItems().addItem(10312, 1);
  217. c.memberStatus = 1;
  218. c.playerRights = 1;
  219. c.disconnected = true;
  220. b = true;
  221. } else {
  222. c.getItems().addItem(10312, 1);
  223. b = true;
  224. }
  225. } else if (prod == 14 && price == 12.00) {
  226. if (c.playerRights == 0) {
  227. c.getItems().addItem(6659, 1);
  228. c.memberStatus = 1;
  229. c.playerRights = 1;
  230. c.disconnected = true;
  231. b = true;
  232. } else {
  233. c.getItems().addItem(6659, 1);
  234. b = true;
  235. }
  236. } else if (prod == 15 && price == 12.00) {
  237. if (c.playerRights == 0) {
  238. c.getItems().addItem(10314, 1);
  239. c.memberStatus = 1;
  240. c.playerRights = 1;
  241. c.disconnected = true;
  242. b = true;
  243. } else {
  244. c.getItems().addItem(10314, 1);
  245. b = true;
  246. }
  247. } else if (prod == 16 && price == 12.00) {
  248. if (c.playerRights == 0) {
  249. c.getItems().addItem(6656, 1);
  250. c.memberStatus = 1;
  251. c.playerRights = 1;
  252. c.disconnected = true;
  253. b = true;
  254. } else {
  255. c.getItems().addItem(6656, 1);
  256. b = true;
  257. }
  258. // end of partyhats
  259. // start of santa hats
  260. } else if (prod == 17 && price == 20.00) {
  261. if (c.playerRights == 0) {
  262. c.getItems().addItem(1050, 1);
  263. c.memberStatus = 1;
  264. c.playerRights = 1;
  265. c.disconnected = true;
  266. b = true;
  267. } else {
  268. c.getItems().addItem(1050, 1);
  269. b = true;
  270. }
  271. } else if (prod == 18 && price == 20.00) {
  272. if (c.playerRights == 0) {
  273. c.getItems().addItem(10286, 1);
  274. c.memberStatus = 1;
  275. c.playerRights = 1;
  276. c.disconnected = true;
  277. b = true;
  278. } else {
  279. c.getItems().addItem(10286, 1);
  280. b = true;
  281. }
  282. } else if (prod == 19 && price == 20.00) {
  283. if (c.playerRights == 0) {
  284. c.getItems().addItem(10310, 1);
  285. c.memberStatus = 1;
  286. c.playerRights = 1;
  287. c.disconnected = true;
  288. b = true;
  289. } else {
  290. c.getItems().addItem(10310, 1);
  291. b = true;
  292. }
  293. } else if (prod == 20 && price == 20.00) {
  294. if (c.playerRights == 0) {
  295. c.getItems().addItem(10290, 1);
  296. c.memberStatus = 1;
  297. c.playerRights = 1;
  298. c.disconnected = true;
  299. b = true;
  300. } else {
  301. c.getItems().addItem(10290, 1);
  302. b = true;
  303. }
  304. } else if (prod == 21 && price == 20.00) {
  305. if (c.playerRights == 0) {
  306. c.getItems().addItem(10292, 1);
  307. c.memberStatus = 1;
  308. c.playerRights = 1;
  309. c.disconnected = true;
  310. b = true;
  311. } else {
  312. c.getItems().addItem(10292, 1);
  313. b = true;
  314. }
  315. } else if (prod == 22 && price == 20.00) {
  316. if (c.playerRights == 0) {
  317. c.getItems().addItem(10294, 1);
  318. c.memberStatus = 1;
  319. c.playerRights = 1;
  320. c.disconnected = true;
  321. b = true;
  322. } else {
  323. c.getItems().addItem(10294, 1);
  324. b = true;
  325. }
  326. } else if (prod == 23 && price == 20.00) {
  327. if (c.playerRights == 0) {
  328. c.getItems().addItem(10296, 1);
  329. c.memberStatus = 1;
  330. c.playerRights = 1;
  331. c.disconnected = true;
  332. b = true;
  333. } else {
  334. c.getItems().addItem(10296, 1);
  335. b = true;
  336. }
  337. } else if (prod == 24 && price == 20.00) {
  338. if (c.playerRights == 0) {
  339. c.getItems().addItem(10298, 1);
  340. c.memberStatus = 1;
  341. c.playerRights = 1;
  342. c.disconnected = true;
  343. b = true;
  344. } else {
  345. c.getItems().addItem(10298, 1);
  346. b = true;
  347. }
  348. } else if (prod == 25 && price == 20.00) {
  349. if (c.playerRights == 0) {
  350. c.getItems().addItem(10302, 1);
  351. c.memberStatus = 1;
  352. c.playerRights = 1;
  353. c.disconnected = true;
  354. b = true;
  355. } else {
  356. c.getItems().addItem(10302, 1);
  357. b = true;
  358. }
  359. } else if (prod == 26 && price == 20.00) {
  360. if (c.playerRights == 0) {
  361. c.getItems().addItem(10300, 1);
  362. c.memberStatus = 1;
  363. c.playerRights = 1;
  364. c.disconnected = true;
  365. b = true;
  366. } else {
  367. c.getItems().addItem(10300, 1);
  368. b = true;
  369. }
  370. } else if (prod == 27 && price == 20.00) {
  371. if (c.playerRights == 0) {
  372. c.getItems().addItem(20006, 1);
  373. c.memberStatus = 1;
  374. c.playerRights = 1;
  375. c.disconnected = true;
  376. b = true;
  377. } else {
  378. c.getItems().addItem(20006, 1);
  379. b = true;
  380. }
  381. } else if (prod == 28 && price == 20.00) {
  382. if (c.playerRights == 0) {
  383. c.getItems().addItem(20008, 1);
  384. c.memberStatus = 1;
  385. c.playerRights = 1;
  386. c.disconnected = true;
  387. b = true;
  388. } else {
  389. c.getItems().addItem(20008, 1);
  390. b = true;
  391. }
  392. } else if (prod == 29 && price == 20.00) {
  393. if (c.playerRights == 0) {
  394. c.getItems().addItem(20004, 1);
  395. c.memberStatus = 1;
  396. c.playerRights = 1;
  397. c.disconnected = true;
  398. b = true;
  399. } else {
  400. c.getItems().addItem(20004, 1);
  401. b = true;
  402. }
  403. } else if (prod == 30 && price == 20.00) {
  404. if (c.playerRights == 0) {
  405. c.getItems().addItem(20002, 1);
  406. c.memberStatus = 1;
  407. c.playerRights = 1;
  408. c.disconnected = true;
  409. b = true;
  410. } else {
  411. c.getItems().addItem(20002, 1);
  412. b = true;
  413. }
  414. } else if (prod == 31 && price == 20.00) {
  415. if (c.playerRights == 0) {
  416. c.getItems().addItem(20000, 1);
  417. c.memberStatus = 1;
  418. c.playerRights = 1;
  419. c.disconnected = true;
  420. b = true;
  421. } else {
  422. c.getItems().addItem(20000, 1);
  423. b = true;
  424. }
  425. } else if (prod == 32 && price == 20.00) {
  426. if (c.playerRights == 0) {
  427. c.getItems().addItem(20010, 1);
  428. c.memberStatus = 1;
  429. c.playerRights = 1;
  430. c.disconnected = true;
  431. b = true;
  432. } else {
  433. c.getItems().addItem(20010, 1);
  434. b = true;
  435. }
  436. } else if (prod == 33 && price == 10.00) {
  437. if (c.playerRights == 0) {
  438. c.getItems().addItem(11694, 1);
  439. c.memberStatus = 1;
  440. c.playerRights = 1;
  441. c.disconnected = true;
  442. b = true;
  443. } else {
  444. c.getItems().addItem(11694, 1);
  445. b = true;
  446. }
  447. } else if (prod == 34 && price == 6.00) {
  448. if (c.playerRights == 0) {
  449. c.getItems().addItem(11698, 1);
  450. c.memberStatus = 1;
  451. c.playerRights = 1;
  452. c.disconnected = true;
  453. b = true;
  454. } else {
  455. c.getItems().addItem(11698, 1);
  456. b = true;
  457. }
  458. } else if (prod == 35 && price == 4.00) {
  459. if (c.playerRights == 0) {
  460. c.getItems().addItem(11700, 1);
  461. c.memberStatus = 1;
  462. c.playerRights = 1;
  463. c.disconnected = true;
  464. b = true;
  465. } else {
  466. c.getItems().addItem(11700, 1);
  467. b = true;
  468. }
  469. } else if (prod == 36 && price == 2.00) {
  470. if (c.playerRights == 0) {
  471. c.getItems().addItem(11696, 1);
  472. c.memberStatus = 1;
  473. c.playerRights = 1;
  474. c.disconnected = true;
  475. b = true;
  476. } else {
  477. c.getItems().addItem(11696, 1);
  478. b = true;
  479. }
  480. } else if (prod == 37 && price == 6.00) {
  481. if (c.playerRights == 0) {
  482. c.getItems().addItem(15486, 1);
  483. c.memberStatus = 1;
  484. c.playerRights = 1;
  485. c.disconnected = true;
  486. b = true;
  487. } else {
  488. c.getItems().addItem(15486, 1);
  489. b = true;
  490. }
  491. } else if (prod == 38 && price == 10.00) {
  492. if (c.playerRights == 0) {
  493. c.getItems().addItem(10346, 1);
  494. c.getItems().addItem(10348, 1);
  495. c.getItems().addItem(10350, 1);
  496. c.getItems().addItem(10352, 1);
  497. c.memberStatus = 1;
  498. c.playerRights = 1;
  499. c.disconnected = true;
  500. b = true;
  501. } else {
  502. c.getItems().addItem(10346, 1);
  503. c.getItems().addItem(10348, 1);
  504. c.getItems().addItem(10350, 1);
  505. c.getItems().addItem(10352, 1);
  506. b = true;
  507. }
  508. } else if (prod == 39 && price == 10.00) {
  509. if (c.playerRights == 0) {
  510. c.getItems().addItem(16755, 1);
  511. c.getItems().addItem(16865, 1);
  512. c.getItems().addItem(16931, 1);
  513. c.getItems().addItem(17017, 1);
  514. c.getItems().addItem(17171, 1);
  515. c.getItems().addItem(17237, 1);
  516. c.memberStatus = 1;
  517. c.playerRights = 1;
  518. c.disconnected = true;
  519. b = true;
  520. } else {
  521. c.getItems().addItem(16755, 1);
  522. c.getItems().addItem(16865, 1);
  523. c.getItems().addItem(16931, 1);
  524. c.getItems().addItem(17017, 1);
  525. c.getItems().addItem(17171, 1);
  526. c.getItems().addItem(17237, 1);
  527. b = true;
  528. }
  529. } else if (prod == 40 && price == 8.00) {
  530. c.getItems().addItem(9813, 1);
  531. c.getItems().addItem(9814, 1);
  532. b = true;
  533. } else if (prod == 41 && price == 20.00) {
  534. if (c.playerRights == 0) {
  535. c.getItems().addItem(16291, 1);
  536. c.getItems().addItem(16357, 1);
  537. c.getItems().addItem(16423, 1);
  538. c.getItems().addItem(16687, 1);
  539. c.getItems().addItem(16709, 1);
  540. c.getItems().addItem(17257, 1);
  541. c.getItems().addItem(17359, 1);
  542. c.memberStatus = 1;
  543. c.playerRights = 1;
  544. c.disconnected = true;
  545. b = true;
  546. } else {
  547. c.getItems().addItem(16291, 1);
  548. c.getItems().addItem(16357, 1);
  549. c.getItems().addItem(16423, 1);
  550. c.getItems().addItem(16687, 1);
  551. c.getItems().addItem(16709, 1);
  552. c.getItems().addItem(17257, 1);
  553. c.getItems().addItem(17359, 1);
  554. b = true;
  555. }
  556. } else if (prod == 42 && price == 20.00) {
  557. if (c.playerRights == 0) {
  558. c.getItems().addItem(16293, 1);
  559. c.getItems().addItem(16359, 1);
  560. c.getItems().addItem(16425, 1);
  561. c.getItems().addItem(16689, 1);
  562. c.getItems().addItem(16711, 1);
  563. c.getItems().addItem(17259, 1);
  564. c.getItems().addItem(17361, 1);
  565. c.memberStatus = 1;
  566. c.playerRights = 1;
  567. c.disconnected = true;
  568. b = true;
  569. } else {
  570. c.getItems().addItem(16293, 1);
  571. c.getItems().addItem(16359, 1);
  572. c.getItems().addItem(16425, 1);
  573. c.getItems().addItem(16689, 1);
  574. c.getItems().addItem(16711, 1);
  575. c.getItems().addItem(17259, 1);
  576. c.getItems().addItem(17361, 1);
  577. b = true;
  578. }
  579. } else if (prod == 43 && price == 12.00) {
  580. if (c.playerRights == 0) {
  581. c.getItems().addItem(14484, 1);
  582. c.memberStatus = 1;
  583. c.playerRights = 1;
  584. b = true;
  585.  
  586. } else {
  587. c.getItems().addItem(14484, 1);
  588. b = true;
  589. }
  590. } else if (prod == 44 && price == 24.00) {
  591. if (c.playerRights == 0) {
  592. c.getItems().addItem(13358, 1);
  593. c.getItems().addItem(13360, 1);
  594. c.getItems().addItem(13362, 1);
  595. c.memberStatus = 1;
  596. c.playerRights = 1;
  597. b = true;
  598.  
  599. } else {
  600. c.getItems().addItem(13358, 1);
  601. c.getItems().addItem(13360, 1);
  602. c.getItems().addItem(13362, 1);
  603. b = true;
  604. }
  605. } else if (prod == 45 && price == 10.00) {
  606. if (c.playerRights == 0) {
  607. c.getItems().addItem(1057, 1);
  608. c.memberStatus = 1;
  609. c.playerRights = 1;
  610. b = true;
  611.  
  612. } else {
  613. c.getItems().addItem(1057, 1);
  614. b = true;
  615. }
  616. } else if (prod == 46 && price == 12.00) {
  617. if (c.playerRights == 0) {
  618. c.getItems().addItem(8839, 1);
  619. c.getItems().addItem(8840, 1);
  620. c.getItems().addItem(8842, 1);
  621. c.getItems().addItem(10663, 1);
  622. c.getItems().addItem(10664, 1);
  623. c.getItems().addItem(10665, 1);
  624. c.memberStatus = 1;
  625. c.playerRights = 1;
  626. b = true;
  627.  
  628. } else {
  629. c.getItems().addItem(8839, 1);
  630. c.getItems().addItem(8840, 1);
  631. c.getItems().addItem(8842, 1);
  632. c.getItems().addItem(10663, 1);
  633. c.getItems().addItem(10664, 1);
  634. c.getItems().addItem(10665, 1);
  635. b = true;
  636. }
  637. } else if (prod == 47 && price == 4.00) {
  638. c.getItems().addItem(6306, 1);
  639. b = true;
  640. } else if (prod == 48 && price == 6.00) {
  641. c.getItems().addItem(18335, 1);
  642. b = true;
  643. } else if (prod == 49 && price == 10.00) {
  644. if (c.playerRights == 0) {
  645. c.getItems().addItem(13740, 1);
  646. c.memberStatus = 1;
  647. c.playerRights = 1;
  648. c.disconnected = true;
  649. b = true;
  650. } else {
  651. c.getItems().addItem(13740, 1);
  652. b = true;
  653. }
  654. } else if (prod == 50 && price == 10.00) {
  655. if (c.playerRights == 0) {
  656. c.getItems().addItem(18351, 1);
  657. c.memberStatus = 1;
  658. c.playerRights = 1;
  659. c.disconnected = true;
  660. b = true;
  661. } else {
  662. c.getItems().addItem(18351, 1);
  663. b = true;
  664. }
  665. } else if (prod == 51 && price == 50.00) {
  666. if (c.playerRights == 0) {
  667. c.getItems().addItem(1038, 1);
  668. c.getItems().addItem(1040, 1);
  669. c.getItems().addItem(1042, 1);
  670. c.getItems().addItem(1046, 1);
  671. c.getItems().addItem(1048, 1);
  672. c.memberStatus = 1;
  673. c.playerRights = 1;
  674. c.disconnected = true;
  675. b = true;
  676. } else {
  677. c.getItems().addItem(1038, 1);
  678. c.getItems().addItem(1040, 1);
  679. c.getItems().addItem(1042, 1);
  680. c.getItems().addItem(1046, 1);
  681. c.getItems().addItem(1048, 1);
  682. b = true;
  683. }
  684. } else if (prod == 52 && price == 10.00) {
  685. c.memberStatus = 1;
  686. c.playerRights = 1;
  687. c.disconnected = true;
  688. b = true;
  689. } else if (prod == 53 && price == 10.00) {
  690. if (c.playerRights == 0) {
  691. c.getItems().addItem(10340, 1);
  692. c.getItems().addItem(10342, 1);
  693. c.getItems().addItem(10344, 1);
  694. c.getItems().addItem(10338, 1);
  695. c.memberStatus = 1;
  696. c.playerRights = 1;
  697. c.disconnected = true;
  698. b = true;
  699. } else {
  700. c.getItems().addItem(10340, 1);
  701. c.getItems().addItem(10342, 1);
  702. c.getItems().addItem(10344, 1);
  703. c.getItems().addItem(10338, 1);
  704. b = true;
  705. }
  706. } else if (prod == 54 && price == 10.00) {
  707. if (c.playerRights == 0) {
  708. c.getItems().addItem(10330, 1);
  709. c.getItems().addItem(10332, 1);
  710. c.getItems().addItem(10334, 1);
  711. c.getItems().addItem(10336, 1);
  712. c.memberStatus = 1;
  713. c.playerRights = 1;
  714. c.disconnected = true;
  715. b = true;
  716. } else {
  717. c.getItems().addItem(10330, 1);
  718. c.getItems().addItem(10332, 1);
  719. c.getItems().addItem(10334, 1);
  720. c.getItems().addItem(10336, 1);
  721. b = true;
  722. }
  723. } else if (prod == 55 && price == 10.00) {
  724. if (c.playerRights == 0) {
  725. c.getItems().addItem(1055, 1);
  726. c.playerRights = 1;
  727. c.memberStatus = 1;
  728. c.disconnected = true;
  729. b = true;
  730. } else {
  731. c.getItems().addItem(1055, 1);
  732. b = true;
  733. }
  734. } else if (prod == 56 && price == 10.00) {
  735. if (c.playerRights == 0) {
  736. c.getItems().addItem(1053, 1);
  737. c.playerRights = 1;
  738. c.memberStatus = 1;
  739. c.disconnected = true;
  740. b = true;
  741. } else {
  742. c.getItems().addItem(1053, 1);
  743. b = true;
  744. }
  745. } else if (prod == 57 && price == 10.00) {
  746. if (c.playerRights == 0) {
  747. c.getItems().addItem(13738, 1);
  748. c.playerRights = 1;
  749. c.memberStatus = 1;
  750. c.disconnected = true;
  751. b = true;
  752. } else {
  753. c.getItems().addItem(13738, 1);
  754. b = true;
  755. }
  756. } else if (prod == 58 && price == 10.00) {
  757. if (c.playerRights == 0) {
  758. c.getItems().addItem(13744, 1);
  759. c.playerRights = 1;
  760. c.memberStatus = 1;
  761. c.disconnected = true;
  762. b = true;
  763. } else {
  764. c.getItems().addItem(13744, 1);
  765. b = true;
  766. }
  767. } else if (prod == 59 && price == 10.00) {
  768. if (c.playerRights == 0) {
  769. c.getItems().addItem(13742, 1);
  770. c.playerRights = 1;
  771. c.memberStatus = 1;
  772. c.disconnected = true;
  773. b = true;
  774. } else {
  775. c.getItems().addItem(13742, 1);
  776. b = true;
  777. }
  778. } else if (prod == 60 && price == 10.00) {
  779. if (c.playerRights == 0) {
  780. c.getItems().addItem(18353, 1);
  781. c.playerRights = 1;
  782. c.memberStatus = 1;
  783. c.disconnected = true;
  784. b = true;
  785. } else {
  786. c.getItems().addItem(18353, 1);
  787. b = true;
  788. }
  789. } else if (prod == 61 && price == 10.00) {
  790. if (c.playerRights == 0) {
  791. c.getItems().addItem(18349, 1);
  792. c.playerRights = 1;
  793. c.memberStatus = 1;
  794. c.disconnected = true;
  795. b = true;
  796. } else {
  797. c.getItems().addItem(18349, 1);
  798. b = true;
  799. }
  800. } else if (prod == 62 && price == 10.00) {
  801. if (c.playerRights == 0) {
  802. c.getItems().addItem(18357, 1);
  803. c.playerRights = 1;
  804. c.memberStatus = 1;
  805. c.disconnected = true;
  806. b = true;
  807. } else {
  808. c.getItems().addItem(18357, 1);
  809. b = true;
  810. }
  811. } else if (prod == 63 && price == 10.00) {
  812. if (c.playerRights == 0) {
  813. c.getItems().addItem(18355, 1);
  814. c.playerRights = 1;
  815. c.memberStatus = 1;
  816. c.disconnected = true;
  817. b = true;
  818. } else {
  819. c.getItems().addItem(18355, 1);
  820. b = true;
  821. }
  822. }
  823. }
  824. if (b) {
  825. query("DELETE FROM `donation` WHERE `username` = '"
  826. + name2 + "';");
  827. }
  828. } catch (Exception e) {
  829. e.printStackTrace();
  830. con = null;
  831. stm = null;
  832. }
  833. }
  834. }.start();
  835. }
  836.  
  837. public static ResultSet query(String s) throws SQLException {
  838. try {
  839. if (s.toLowerCase().startsWith("select")) {
  840. ResultSet rs = stm.executeQuery(s);
  841. return rs;
  842. } else {
  843. stm.executeUpdate(s);
  844. }
  845. return null;
  846. } catch (Exception e) {
  847. e.printStackTrace();
  848. con = null;
  849. stm = null;
  850. }
  851. return null;
  852. }
  853. }
Add Comment
Please, Sign In to add comment
Public Pastes
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!