API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 19th, 2017
112
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 21.46 KB | None | 0 0
raw download clone embed print report
  1. package com.mayhem.core.network.mysql;
  2.  
  3. import java.sql.Connection;
  4. import java.sql.DriverManager;
  5. import java.sql.ResultSet;
  6. import java.sql.SQLException;
  7. import java.sql.Statement;
  8.  
  9. import com.mayhem.core.util.Utility;
  10. import com.mayhem.rs2.content.membership.RankHandler;
  11. import com.mayhem.rs2.entity.World;
  12. import com.mayhem.rs2.entity.item.Item;
  13. import com.mayhem.rs2.entity.player.Player;
  14. import com.mayhem.rs2.entity.player.net.out.impl.SendMessage;
  15.  
  16. /**
  17. * Using this class:
  18. * To call this class, it's best to make a new thread. You can do it below like so:
  19. * new Thread(new Donation(player)).start();
  20. */
  21. public class Donation implements Runnable {
  22.  
  23. public static final String HOST = "66.85.79.60";
  24. public static final String USER = "runeziuj_StoreU";
  25. public static final String PASS = "imanub5765?";
  26. public static final String DATABASE = "runeziuj_StoreV2";
  27.  
  28. private Player player;
  29. private Connection conn;
  30. private Statement stmt;
  31.  
  32. /**
  33. * The constructor
  34. * @param player
  35. */
  36. public Donation(Player player) {
  37. this.player = player;
  38. }
  39.  
  40.  
  41. @Override
  42. public void run() {
  43. try {
  44. player.send(new SendMessage("Your donation is being processed....Please wait."));
  45. if (!connect(HOST, DATABASE, USER, PASS)) {
  46. player.send(new SendMessage("Donation claim failed, please contact an administrator."));
  47. return;
  48. }
  49. String name = player.getUsername().replace("_", " ");
  50. ResultSet rs = executeQuery("SELECT * FROM payments WHERE player_name='"+name+"' AND status='Completed' AND claimed=0");
  51.  
  52. while (rs.next()) {
  53. int item_number = rs.getInt("item_number");
  54. double paid = rs.getDouble("amount");
  55. int quantity = rs.getInt("quantity");
  56.  
  57. switch (item_number) {// add products according to their ID in the ACP
  58.  
  59. case 18: // 100 RuneZilla bucks
  60. player.getInventory().add(13190, 1 * quantity);
  61. //player.setMoneySpent(player.getMoneySpent() + (int)paid);
  62. //RankHandler.upgrade(player);
  63. //player.setMember(true);
  64. player.getClient().queueOutgoingPacket(new SendMessage("Thank you for supporting RuneZilla."));
  65. World.sendGlobalMessage("</col>[ @dre@RuneZilla </col>] @dre@" + player.determineIcon(player) + " " + Utility.formatPlayerName(player.getUsername()) + " has just Donated to RuneZilla! Thank you for your contribution! ");
  66. break;
  67. case 26: // 300 RuneZilla bucks
  68. player.getInventory().add(13191, 1 * quantity);
  69. //player.setMoneySpent(player.getMoneySpent() + (int)paid);
  70. //RankHandler.upgrade(player);
  71. //player.setMember(true);
  72. player.getClient().queueOutgoingPacket(new SendMessage("Thank you for supporting RuneZilla."));
  73. World.sendGlobalMessage("</col>[ @dre@RuneZilla </col>] @dre@" + player.determineIcon(player) + " " + Utility.formatPlayerName(player.getUsername()) + " has just Donated to RuneZilla! Thank you for your contribution! ");
  74.  
  75. break;
  76. case 27: // 500 RuneZilla bucks
  77. player.getInventory().add(13192, 1 * quantity);
  78. //player.setMoneySpent(player.getMoneySpent() + (int)paid);
  79. // RankHandler.upgrade(player);
  80. // player.setMember(true);
  81. player.getClient().queueOutgoingPacket(new SendMessage("Thank you for supporting RuneZilla."));
  82. World.sendGlobalMessage("</col>[ @dre@RuneZilla </col>] @dre@" + player.determineIcon(player) + " " + Utility.formatPlayerName(player.getUsername()) + " has just Donated to RuneZilla! Thank you for your contribution! ");
  83. break;
  84. case 28: // 1000 RuneZilla bucks
  85. player.getInventory().add(14000, 1 * quantity);
  86. // player.setMoneySpent(player.getMoneySpent() + (int)paid);
  87. // RankHandler.upgrade(player);
  88. // player.setMember(true);
  89. player.getClient().queueOutgoingPacket(new SendMessage("Thank you for supporting RuneZilla."));
  90. World.sendGlobalMessage("</col>[ @dre@RuneZilla </col>] @dre@" + player.determineIcon(player) + " " + Utility.formatPlayerName(player.getUsername()) + " has just Donated to RuneZilla! Thank you for your contribution! ");
  91. break;
  92. case 29: // 2500 RuneZilla bucks
  93. player.getInventory().add(13195, 1 * quantity);
  94. // player.setMoneySpent(player.getMoneySpent() + (int)paid);
  95. // RankHandler.upgrade(player);
  96. // player.setMember(true);
  97. player.getClient().queueOutgoingPacket(new SendMessage("Thank you for supporting RuneZilla."));
  98. World.sendGlobalMessage("</col>[ @dre@RuneZilla </col>] @dre@" + player.determineIcon(player) + " " + Utility.formatPlayerName(player.getUsername()) + " has just Donated to RuneZilla! Thank you for your contribution! ");
  99. break;
  100. case 30: // 5000 RuneZilla bucks
  101. player.getInventory().add(13196, 1 * quantity);
  102. // player.setMoneySpent(player.getMoneySpent() + (int)paid);
  103. // RankHandler.upgrade(player);
  104. // player.setMember(true);
  105. player.getClient().queueOutgoingPacket(new SendMessage("Thank you for supporting RuneZilla."));
  106. World.sendGlobalMessage("</col>[ @dre@RuneZilla </col>] @dre@" + player.determineIcon(player) + " " + Utility.formatPlayerName(player.getUsername()) + " has just Donated to RuneZilla! Thank you for your contribution! ");
  107. break;
  108. case 31: // 10,000 RuneZilla bucks
  109. player.getInventory().add(5444, 1 * quantity);
  110. // player.setMoneySpent(player.getMoneySpent() + (int)paid);
  111. // RankHandler.upgrade(player);
  112. // player.setMember(true);
  113. player.getClient().queueOutgoingPacket(new SendMessage("Thank you for supporting RuneZilla."));
  114. World.sendGlobalMessage("</col>[ @dre@RuneZilla </col>] @dre@" + player.determineIcon(player) + " " + Utility.formatPlayerName(player.getUsername()) + " has just Donated to RuneZilla! Thank you for your contribution! ");
  115. break;
  116. case 32: // 20,000 RuneZilla bucks
  117. player.getInventory().add(13198, 1 * quantity);
  118. // player.setMoneySpent(player.getMoneySpent() + (int)paid);
  119. // RankHandler.upgrade(player);
  120. // player.setMember(true);
  121. player.getClient().queueOutgoingPacket(new SendMessage("Thank you for supporting RuneZilla."));
  122. World.sendGlobalMessage("</col>[ @dre@RuneZilla </col>] @dre@" + player.determineIcon(player) + " " + Utility.formatPlayerName(player.getUsername()) + " has just Donated to RuneZilla! Thank you for your contribution! ");
  123. break;
  124. case 290: // Bag of dice
  125. player.getInventory().add(13190, 1 * quantity);
  126. player.setMoneySpent(player.getMoneySpent() + (int)paid);
  127. RankHandler.upgrade(player);
  128. player.setMember(true);
  129. player.getClient().queueOutgoingPacket(new SendMessage("Thank you for supporting RuneZilla."));
  130. World.sendGlobalMessage("</col>[ @dre@RuneZilla </col>] @dre@" + player.determineIcon(player) + " " + Utility.formatPlayerName(player.getUsername()) + " has just Donated to RuneZilla! Thank you for your contribution! ");
  131. break;
  132. case 256: // 10x keys
  133. player.getInventory().add(990, 10 * quantity);
  134. player.setMoneySpent(player.getMoneySpent() + (int)paid);
  135. RankHandler.upgrade(player);
  136. player.setMember(true);
  137. player.getClient().queueOutgoingPacket(new SendMessage("Thank you for supporting RuneZilla."));
  138. World.sendGlobalMessage("</col>[ @dre@RuneZilla </col>] @dre@" + player.determineIcon(player) + " " + Utility.formatPlayerName(player.getUsername()) + " has just Donated to RuneZilla! Thank you for your contribution! ");
  139. break;
  140. case 270: // 50x keys
  141. player.getInventory().add(990, 50 * quantity);
  142. player.setMoneySpent(player.getMoneySpent() + (int)paid);
  143. RankHandler.upgrade(player);
  144. player.setMember(true);
  145. player.getClient().queueOutgoingPacket(new SendMessage("Thank you for supporting RuneZilla."));
  146. World.sendGlobalMessage("</col>[ @dre@RuneZilla </col>] @dre@" + player.determineIcon(player) + " " + Utility.formatPlayerName(player.getUsername()) + " has just Donated to RuneZilla! Thank you for your contribution! ");
  147. break;
  148. case 280: //100x keys
  149. player.getInventory().add(990, 100 * quantity);
  150. player.setMoneySpent(player.getMoneySpent() + (int)paid);
  151. RankHandler.upgrade(player);
  152. player.setMember(true);
  153. player.getClient().queueOutgoingPacket(new SendMessage("Thank you for supporting RuneZilla."));
  154. World.sendGlobalMessage("</col>[ @dre@RuneZilla </col>] @dre@" + player.determineIcon(player) + " " + Utility.formatPlayerName(player.getUsername()) + " has just Donated to RuneZilla! Thank you for your contribution! ");
  155. break;
  156. case 44: // partyhat
  157. player.getInventory().add(1040, 1 * quantity);
  158. player.setMoneySpent(player.getMoneySpent() + (int)paid);
  159. RankHandler.upgrade(player);
  160. player.setMember(true);
  161. player.getClient().queueOutgoingPacket(new SendMessage("Thank you for supporting RuneZilla."));
  162. World.sendGlobalMessage("</col>[ @dre@RuneZilla </col>] @dre@" + player.determineIcon(player) + " " + Utility.formatPlayerName(player.getUsername()) + " has just Donated to RuneZilla! Thank you for your contribution! ");
  163. break;
  164. case 45: // partyhat
  165. player.getInventory().add(1042, 1 * quantity);
  166. player.setMoneySpent(player.getMoneySpent() + (int)paid);
  167. RankHandler.upgrade(player);
  168. player.setMember(true);
  169. player.getClient().queueOutgoingPacket(new SendMessage("Thank you for supporting RuneZilla."));
  170. World.sendGlobalMessage("</col>[ @dre@RuneZilla </col>] @dre@" + player.determineIcon(player) + " " + Utility.formatPlayerName(player.getUsername()) + " has just Donated to RuneZilla! Thank you for your contribution! ");
  171. case 46: // partyhat
  172. player.getInventory().add(1044, 1 * quantity);
  173. player.setMoneySpent(player.getMoneySpent() + (int)paid);
  174. RankHandler.upgrade(player);
  175. player.setMember(true);
  176. player.getClient().queueOutgoingPacket(new SendMessage("Thank you for supporting RuneZilla."));
  177. World.sendGlobalMessage("</col>[ @dre@RuneZilla </col>] @dre@" + player.determineIcon(player) + " " + Utility.formatPlayerName(player.getUsername()) + " has just Donated to RuneZilla! Thank you for your contribution! ");
  178. break;
  179. case 47: // partyhat
  180. player.getInventory().add(1046, 1 * quantity);
  181. player.setMoneySpent(player.getMoneySpent() + (int)paid);
  182. RankHandler.upgrade(player);
  183. player.setMember(true);
  184. player.getClient().queueOutgoingPacket(new SendMessage("Thank you for supporting RuneZilla."));
  185. World.sendGlobalMessage("</col>[ @dre@RuneZilla </col>] @dre@" + player.determineIcon(player) + " " + Utility.formatPlayerName(player.getUsername()) + " has just Donated to RuneZilla! Thank you for your contribution! ");
  186. break;
  187. case 48: // partyhat
  188. player.getInventory().add(1048, 1 * quantity);
  189. player.setMoneySpent(player.getMoneySpent() + (int)paid);
  190. RankHandler.upgrade(player);
  191. player.setMember(true);
  192. player.getClient().queueOutgoingPacket(new SendMessage("Thank you for supporting RuneZilla."));
  193. World.sendGlobalMessage("</col>[ @dre@RuneZilla </col>] @dre@" + player.determineIcon(player) + " " + Utility.formatPlayerName(player.getUsername()) + " has just Donated to RuneZilla! Thank you for your contribution! ");
  194. break;
  195. case 49: // mystery box
  196. player.getInventory().add(6199, 1 * quantity);
  197. player.setMoneySpent(player.getMoneySpent() + (int)paid);
  198. RankHandler.upgrade(player);
  199. player.setMember(true);
  200. player.getClient().queueOutgoingPacket(new SendMessage("Thank you for supporting RuneZilla."));
  201. World.sendGlobalMessage("</col>[ @dre@RuneZilla </col>] @dre@" + player.determineIcon(player) + " " + Utility.formatPlayerName(player.getUsername()) + " has just Donated to RuneZilla! Thank you for your contribution! ");
  202. break;
  203. case 50: // mystery box x10
  204. if (player.getInventory().hasSpaceFor(new Item(6199, 10 * quantity))) {
  205. player.getInventory().add(6199, 10 * quantity);
  206. player.setMoneySpent(player.getMoneySpent() + (int)paid);
  207. RankHandler.upgrade(player);
  208. player.setMember(true);
  209. player.getClient().queueOutgoingPacket(new SendMessage("Thank you for supporting RuneZilla."));
  210. World.sendGlobalMessage("</col>[ @dre@RuneZilla </col>] @dre@" + player.determineIcon(player) + " " + Utility.formatPlayerName(player.getUsername()) + " has just Donated to RuneZilla! Thank you for your contribution! ");
  211. } else if (player.getBank().hasSpaceFor((new Item(6199, 10 * quantity)))) {
  212. player.getBank().add(6199, 10 * quantity);
  213. player.setMoneySpent(player.getMoneySpent() + (int)paid);
  214. RankHandler.upgrade(player);
  215. player.setMember(true);
  216. player.getClient().queueOutgoingPacket(new SendMessage("Thank you for supporting RuneZilla. Your donation has been sent to your bank."));
  217. }
  218. break;
  219. case 300: // 50,000 bloodmoney
  220. player.getInventory().add(13307, 50000 * quantity);
  221. player.setMoneySpent(player.getMoneySpent() + (int)paid);
  222. RankHandler.upgrade(player);
  223. player.setMember(true);
  224. player.getClient().queueOutgoingPacket(new SendMessage("Thank you for supporting RuneZilla."));
  225. World.sendGlobalMessage("</col>[ @dre@RuneZilla </col>] @dre@" + player.determineIcon(player) + " " + Utility.formatPlayerName(player.getUsername()) + " has just Donated to RuneZilla! Thank you for your contribution! ");
  226. break;
  227. case 310: // 100,000 bloodmoney
  228. player.getInventory().add(13307, 100000 * quantity);
  229. player.setMoneySpent(player.getMoneySpent() + (int)paid);
  230. RankHandler.upgrade(player);
  231. player.setMember(true);
  232. player.getClient().queueOutgoingPacket(new SendMessage("Thank you for supporting RuneZilla."));
  233. World.sendGlobalMessage("</col>[ @dre@RuneZilla </col>] @dre@" + player.determineIcon(player) + " " + Utility.formatPlayerName(player.getUsername()) + " has just Donated to RuneZilla! Thank you for your contribution! ");
  234. break;
  235. case 320: // 250,000 bloodmoney
  236. player.getInventory().add(13307, 250000 * quantity);
  237. player.setMoneySpent(player.getMoneySpent() + (int)paid);
  238. RankHandler.upgrade(player);
  239. player.setMember(true);
  240. player.getClient().queueOutgoingPacket(new SendMessage("Thank you for supporting RuneZilla."));
  241. World.sendGlobalMessage("</col>[ @dre@RuneZilla </col>] @dre@" + player.determineIcon(player) + " " + Utility.formatPlayerName(player.getUsername()) + " has just Donated to RuneZilla! Thank you for your contribution! ");
  242. break;
  243. case 33: // 500000 bloodmoney
  244. player.getInventory().add(13307, 500000 * quantity);
  245. player.setMoneySpent(player.getMoneySpent() + (int)paid);
  246. RankHandler.upgrade(player);
  247. player.setMember(true);
  248. player.getClient().queueOutgoingPacket(new SendMessage("Thank you for supporting RuneZilla."));
  249. World.sendGlobalMessage("</col>[ @dre@RuneZilla </col>] @dre@" + player.determineIcon(player) + " " + Utility.formatPlayerName(player.getUsername()) + " has just Donated to RuneZilla! Thank you for your contribution! ");
  250. break;
  251. case 34: // 100x Mithril Seeds
  252. player.getInventory().add(299, 100 * quantity);
  253. player.setMoneySpent(player.getMoneySpent() + (int)1);
  254. RankHandler.upgrade(player);
  255. player.setMember(true);
  256. player.getClient().queueOutgoingPacket(new SendMessage("Thank you for supporting RuneZilla."));
  257. World.sendGlobalMessage("</col>[ @dre@RuneZilla </col>] @dre@" + player.determineIcon(player) + " " + Utility.formatPlayerName(player.getUsername()) + " has just Donated to RuneZilla! Thank you for your contribution! ");
  258. break;
  259. case 35: // 300x Mithril Seeds
  260. player.getInventory().add(299, 300 * quantity);
  261. player.setMoneySpent(player.getMoneySpent() + (int)3);
  262. RankHandler.upgrade(player);
  263. player.setMember(true);
  264. player.getClient().queueOutgoingPacket(new SendMessage("Thank you for supporting RuneZilla."));
  265. World.sendGlobalMessage("</col>[ @dre@RuneZilla </col>] @dre@" + player.determineIcon(player) + " " + Utility.formatPlayerName(player.getUsername()) + " has just Donated to RuneZilla! Thank you for your contribution! ");
  266. break;
  267. case 36: // 500x Mithril Seeds
  268. player.getInventory().add(299, 500 * quantity);
  269. player.setMoneySpent(player.getMoneySpent() + (int)5);
  270. RankHandler.upgrade(player);
  271. player.setMember(true);
  272. player.getClient().queueOutgoingPacket(new SendMessage("Thank you for supporting RuneZilla."));
  273. World.sendGlobalMessage("</col>[ @dre@RuneZilla </col>] @dre@" + player.determineIcon(player) + " " + Utility.formatPlayerName(player.getUsername()) + " has just Donated to RuneZilla! Thank you for your contribution! ");
  274. break;
  275. case 37: // 1000x Mithril Seeds
  276. player.getInventory().add(299, 1000 * quantity);
  277. player.setMoneySpent(player.getMoneySpent() + (int)10);
  278. RankHandler.upgrade(player);
  279. player.setMember(true);
  280. player.getClient().queueOutgoingPacket(new SendMessage("Thank you for supporting RuneZilla."));
  281. World.sendGlobalMessage("</col>[ @dre@RuneZilla </col>] @dre@" + player.determineIcon(player) + " " + Utility.formatPlayerName(player.getUsername()) + " has just Donated to RuneZilla! Thank you for your contribution! ");
  282. break;
  283. case 38: // 5M
  284. player.getInventory().add(995, 5000000 * quantity);
  285. player.setMoneySpent(player.getMoneySpent() + (int)2);
  286. RankHandler.upgrade(player);
  287. player.setMember(true);
  288. player.getClient().queueOutgoingPacket(new SendMessage("Thank you for supporting RuneZilla."));
  289. World.sendGlobalMessage("</col>[ @dre@RuneZilla </col>] @dre@" + player.determineIcon(player) + " " + Utility.formatPlayerName(player.getUsername()) + " has just Donated to RuneZilla! Thank you for your contribution! ");
  290. break;
  291. case 39: // 25M
  292. player.getInventory().add(995, 25000000 * quantity);
  293. player.setMoneySpent(player.getMoneySpent() + (int)10);
  294. RankHandler.upgrade(player);
  295. player.setMember(true);
  296. player.getClient().queueOutgoingPacket(new SendMessage("Thank you for supporting RuneZilla."));
  297. World.sendGlobalMessage("</col>[ @dre@RuneZilla </col>] @dre@" + player.determineIcon(player) + " " + Utility.formatPlayerName(player.getUsername()) + " has just Donated to RuneZilla! Thank you for your contribution! ");
  298. break;
  299. case 40: // 50M
  300. player.getInventory().add(995, 50000000 * quantity);
  301. player.setMoneySpent(player.getMoneySpent() + (int)18);
  302. RankHandler.upgrade(player);
  303. player.setMember(true);
  304. player.getClient().queueOutgoingPacket(new SendMessage("Thank you for supporting RuneZilla."));
  305. World.sendGlobalMessage("</col>[ @dre@RuneZilla </col>] @dre@" + player.determineIcon(player) + " " + Utility.formatPlayerName(player.getUsername()) + " has just Donated to RuneZilla! Thank you for your contribution! ");
  306. break;
  307. case 41: // 100M
  308. player.getInventory().add(995, 100000000 * quantity);
  309. player.setMoneySpent(player.getMoneySpent() + (int)35);
  310. RankHandler.upgrade(player);
  311. player.setMember(true);
  312. player.getClient().queueOutgoingPacket(new SendMessage("Thank you for supporting RuneZilla."));
  313. World.sendGlobalMessage("</col>[ @dre@RuneZilla </col>] @dre@" + player.determineIcon(player) + " " + Utility.formatPlayerName(player.getUsername()) + " has just Donated to RuneZilla! Thank you for your contribution! ");
  314. break;
  315.  
  316.  
  317.  
  318. }
  319. player.send(new SendMessage("You've claimed your donation."));
  320. World.sendGlobalMessage("</col>[ @dre@RuneZilla </col>] @dre@" + player.determineIcon(player) + " " + Utility.formatPlayerName(player.getUsername()) + " has just Donated to RuneZilla! Thank you for your contribution! ");
  321. rs.updateInt("claimed", 1); // do not delete otherwise they can reclaim!
  322. rs.updateRow();
  323. }
  324.  
  325. destroy();
  326. } catch (Exception e) {
  327. e.printStackTrace();
  328. }
  329. }
  330.  
  331. /**
  332. *
  333. * @param host the host ip address or url
  334. * @param database the name of the database
  335. * @param user the user attached to the database
  336. * @param pass the users password
  337. * @return true if connected
  338. */
  339. public boolean connect(String host, String database, String user, String pass) {
  340. try {
  341. this.conn = DriverManager.getConnection("jdbc:mysql://"+host+":3306/"+database, user, pass);
  342. return true;
  343. } catch (SQLException e) {
  344. System.out.println("[Donation]: Failed connecting to database!");
  345. return false;
  346. }
  347. }
  348.  
  349. /**
  350. * Disconnects from the MySQL server and destroy the connection
  351. * and statement instances
  352. */
  353. public void destroy() {
  354. try {
  355. conn.close();
  356. conn = null;
  357. if (stmt != null) {
  358. stmt.close();
  359. stmt = null;
  360. }
  361. } catch(Exception e) {
  362. e.printStackTrace();
  363. }
  364. }
  365.  
  366. /**
  367. * Executes an update query on the database
  368. * @param query
  369. * @see {@link Statement#executeUpdate}
  370. */
  371. public int executeUpdate(String query) {
  372. try {
  373. this.stmt = this.conn.createStatement(1005, 1008);
  374. int results = stmt.executeUpdate(query);
  375. return results;
  376. } catch (SQLException ex) {
  377. ex.printStackTrace();
  378. }
  379. return -1;
  380. }
  381.  
  382. /**
  383. * Executres a query on the database
  384. * @param query
  385. * @see {@link Statement#executeQuery(String)}
  386. * @return the results, never null
  387. */
  388. public ResultSet executeQuery(String query) {
  389. try {
  390. this.stmt = this.conn.createStatement(1005, 1008);
  391. ResultSet results = stmt.executeQuery(query);
  392. return results;
  393. } catch (SQLException ex) {
  394. ex.printStackTrace();
  395. }
  396. return null;
  397. }
  398. }
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!