API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 26th, 2020
171
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 42.91 KB | None | 0 0
raw download clone embed print report
  1. package me.dragonpvp.test;
  2.  
  3. import java.sql.Connection;
  4. import java.sql.DriverManager;
  5. import java.sql.PreparedStatement;
  6. import java.sql.ResultSet;
  7. import java.util.Arrays;
  8.  
  9. import org.bukkit.Bukkit;
  10. import org.bukkit.ChatColor;
  11. import org.bukkit.Material;
  12. import org.bukkit.command.Command;
  13. import org.bukkit.command.CommandExecutor;
  14. import org.bukkit.command.CommandSender;
  15. import org.bukkit.configuration.file.YamlConfiguration;
  16. import org.bukkit.enchantments.Enchantment;
  17. import org.bukkit.entity.Player;
  18. import org.bukkit.event.EventHandler;
  19. import org.bukkit.event.Listener;
  20. import org.bukkit.event.inventory.InventoryClickEvent;
  21. import org.bukkit.event.player.PlayerJoinEvent;
  22. import org.bukkit.inventory.Inventory;
  23. import org.bukkit.inventory.ItemStack;
  24. import org.bukkit.inventory.meta.ItemMeta;
  25. import org.bukkit.inventory.meta.SkullMeta;
  26.  
  27.  
  28.  
  29. public class CommandClass implements CommandExecutor{
  30.  
  31.  
  32. public static Connection connection;
  33.  
  34. String prefix = "§6§lDragon§f§lPvP §8» ";
  35.  
  36. public synchronized void openConnection() {
  37. try {
  38.  
  39. connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/" + "mysql","admin","Thomas96");
  40.  
  41. } catch (Exception e) {
  42. e.printStackTrace();
  43. }
  44. }
  45.  
  46. public synchronized void closeConnection() {
  47. try {
  48. connection.close();
  49. } catch (Exception e) {
  50. e.printStackTrace();
  51. }
  52. }
  53.  
  54. public static String itemToStringBlob(ItemStack itemStack) {
  55. YamlConfiguration config = new YamlConfiguration();
  56. config.set("i", itemStack);
  57. return config.saveToString();
  58. }
  59.  
  60.  
  61. public static ItemStack stringBlobToItem(String stringBlob) {
  62. YamlConfiguration config = new YamlConfiguration();
  63. try {
  64. config.loadFromString(stringBlob);
  65. } catch (Exception e) {
  66. e.printStackTrace();
  67. return null;
  68. }
  69. return config.getItemStack("i", null);
  70. }
  71.  
  72. public boolean onCommand(CommandSender sender, Command command, String label, String[] args)
  73. {
  74.  
  75. Player p = (Player) sender;
  76.  
  77. if ((label.equalsIgnoreCase("kitty")) &&
  78. ((sender instanceof Player)))
  79. {
  80.  
  81. if(args.length == 0){
  82.  
  83. try {
  84.  
  85. createFirstMenu(p);;
  86.  
  87. }
  88. catch (Exception ec) {
  89. System.out.print(ec);
  90. }
  91.  
  92. }
  93.  
  94. }
  95.  
  96. return true;
  97. }
  98.  
  99.  
  100. public void createFirstMenu(Player p) {
  101.  
  102. Inventory gui = Bukkit.createInventory(null, 27, ChatColor.AQUA + "Kit Menu");
  103.  
  104. ItemStack glassOrange = new ItemStack(Material.STAINED_GLASS_PANE, 1, (short)1);
  105. ItemMeta glassOrangemeta = glassOrange.getItemMeta();
  106. glassOrangemeta.setDisplayName("§7");
  107. glassOrange.setItemMeta(glassOrangemeta);
  108. gui.setItem(0, glassOrange);
  109. gui.setItem(1, glassOrange);
  110. gui.setItem(2, glassOrange);
  111. gui.setItem(3, glassOrange);
  112. gui.setItem(4, glassOrange);
  113. gui.setItem(5, glassOrange);
  114. gui.setItem(6, glassOrange);
  115. gui.setItem(7, glassOrange);
  116. gui.setItem(8, glassOrange);
  117.  
  118. ItemStack glassWhite = new ItemStack(Material.STAINED_GLASS_PANE, 1);
  119. ItemMeta glassWhitemeta = glassWhite.getItemMeta();
  120. glassWhitemeta.setDisplayName("§7");
  121. glassWhite.setItemMeta(glassWhitemeta);
  122. gui.setItem(18, glassWhite);
  123. gui.setItem(19, glassWhite);
  124. gui.setItem(20, glassWhite);
  125. gui.setItem(21, glassWhite);
  126. gui.setItem(22, glassWhite);
  127. gui.setItem(23, glassWhite);
  128. gui.setItem(24, glassWhite);
  129. gui.setItem(25, glassWhite);
  130. gui.setItem(26, glassWhite);
  131.  
  132. ItemStack enchant = new ItemStack(Material.ENCHANTMENT_TABLE, 1);
  133. ItemMeta enchantmeta = enchant.getItemMeta();
  134. enchantmeta.setDisplayName("§5§lOPGRADER KITS");
  135. enchant.setItemMeta(enchantmeta);
  136. gui.setItem(11, enchant);
  137.  
  138. ItemStack pick = new ItemStack(Material.DIAMOND_HELMET, 1);
  139. ItemMeta pickmeta = pick.getItemMeta();
  140. pickmeta.setDisplayName("§e§lVÆLG KIT");
  141. pick.setItemMeta(pickmeta);
  142. gui.setItem(15, pick);
  143.  
  144. p.openInventory(gui);
  145.  
  146. }
  147.  
  148. public void createSelectKitMenu(Player p) {
  149.  
  150. Inventory gui = Bukkit.createInventory(null, 45, ChatColor.AQUA + "Vælg Kit");
  151.  
  152. ItemStack glassOrange = new ItemStack(Material.STAINED_GLASS_PANE, 1, (short)1);
  153. ItemMeta glassOrangemeta = glassOrange.getItemMeta();
  154. glassOrangemeta.setDisplayName("§7");
  155. glassOrange.setItemMeta(glassOrangemeta);
  156. gui.setItem(0, glassOrange);
  157. gui.setItem(1, glassOrange);
  158. gui.setItem(2, glassOrange);
  159. gui.setItem(3, glassOrange);
  160. gui.setItem(4, glassOrange);
  161. gui.setItem(5, glassOrange);
  162. gui.setItem(6, glassOrange);
  163. gui.setItem(7, glassOrange);
  164. gui.setItem(8, glassOrange);
  165.  
  166. ItemStack glassWhite = new ItemStack(Material.STAINED_GLASS_PANE, 1);
  167. ItemMeta glassWhitemeta = glassWhite.getItemMeta();
  168. glassWhitemeta.setDisplayName("§7");
  169. glassWhite.setItemMeta(glassWhitemeta);
  170. gui.setItem(36, glassWhite);
  171. gui.setItem(37, glassWhite);
  172. gui.setItem(38, glassWhite);
  173. gui.setItem(39, glassWhite);
  174. gui.setItem(40, glassWhite);
  175. gui.setItem(41, glassWhite);
  176. gui.setItem(42, glassWhite);
  177. gui.setItem(43, glassWhite);
  178. gui.setItem(44, glassWhite);
  179.  
  180. ItemStack warriorSkull = new ItemStack(Material.SKULL_ITEM, 1, (short) 3);
  181. SkullMeta warriorSkullmeta = (SkullMeta) warriorSkull.getItemMeta();
  182. warriorSkullmeta.setDisplayName(ChatColor.DARK_RED + "WARRIOR");
  183. warriorSkullmeta.setOwner("0Orion0");
  184. warriorSkull.setItemMeta(warriorSkullmeta);
  185. gui.setItem(11, warriorSkull);
  186.  
  187. ItemStack masterSkull = new ItemStack(Material.SKULL_ITEM, 1, (short) 3);
  188. SkullMeta masterSkullmeta = (SkullMeta) masterSkull.getItemMeta();
  189. masterSkullmeta.setDisplayName(ChatColor.DARK_RED + "MASTER");
  190. masterSkullmeta.setOwner("11Hubble_BuildIt");
  191. masterSkull.setItemMeta(masterSkullmeta);
  192. gui.setItem(13, masterSkull);
  193.  
  194. ItemStack dragonSkull = new ItemStack(Material.SKULL_ITEM, 1, (short) 3);
  195. SkullMeta dragonSkullmeta = (SkullMeta) dragonSkull.getItemMeta();
  196. dragonSkullmeta.setDisplayName(ChatColor.DARK_RED + "DRAGON");
  197. dragonSkullmeta.setOwner("364days");
  198. dragonSkull.setItemMeta(dragonSkullmeta);
  199. gui.setItem(15, dragonSkull);
  200.  
  201. ItemStack archer = new ItemStack(Material.LEATHER_HELMET, 1);
  202. ItemMeta archermeta = archer.getItemMeta();
  203. archermeta.setDisplayName(ChatColor.DARK_RED + "ARCHER");
  204. archer.setItemMeta(archermeta);
  205. gui.setItem(29, archer);
  206.  
  207. ItemStack tank = new ItemStack(Material.CHAINMAIL_HELMET, 1);
  208. ItemMeta tankmeta = tank.getItemMeta();
  209. tankmeta.setDisplayName(ChatColor.DARK_RED + "TANK");
  210. tank.setItemMeta(tankmeta);
  211. gui.setItem(31, tank);
  212.  
  213. ItemStack diamond = new ItemStack(Material.DIAMOND_HELMET, 1);
  214. ItemMeta diamondmeta = diamond.getItemMeta();
  215. diamondmeta.setDisplayName(ChatColor.DARK_RED + "DIAMOND");
  216. diamond.setItemMeta(diamondmeta);
  217. gui.setItem(33, diamond);
  218.  
  219. p.openInventory(gui);
  220. }
  221.  
  222. public void createEnchantMenu(Player p) {
  223.  
  224. Inventory gui = Bukkit.createInventory(null, 27, ChatColor.AQUA + "Opgrader Kits");
  225.  
  226. ItemStack glassOrange = new ItemStack(Material.STAINED_GLASS_PANE, 1, (short)1);
  227. ItemMeta glassOrangemeta = glassOrange.getItemMeta();
  228. glassOrangemeta.setDisplayName("§7");
  229. glassOrange.setItemMeta(glassOrangemeta);
  230. gui.setItem(0, glassOrange);
  231. gui.setItem(1, glassOrange);
  232. gui.setItem(2, glassOrange);
  233. gui.setItem(3, glassOrange);
  234. gui.setItem(4, glassOrange);
  235. gui.setItem(5, glassOrange);
  236. gui.setItem(6, glassOrange);
  237. gui.setItem(7, glassOrange);
  238. gui.setItem(8, glassOrange);
  239.  
  240. ItemStack glassWhite = new ItemStack(Material.STAINED_GLASS_PANE, 1);
  241. ItemMeta glassWhitemeta = glassWhite.getItemMeta();
  242. glassWhitemeta.setDisplayName("§7");
  243. glassWhite.setItemMeta(glassWhitemeta);
  244. gui.setItem(18, glassWhite);
  245. gui.setItem(19, glassWhite);
  246. gui.setItem(20, glassWhite);
  247. gui.setItem(21, glassWhite);
  248. gui.setItem(22, glassWhite);
  249. gui.setItem(23, glassWhite);
  250. gui.setItem(24, glassWhite);
  251. gui.setItem(25, glassWhite);
  252. gui.setItem(26, glassWhite);
  253.  
  254. ItemStack archer = new ItemStack(Material.LEATHER_HELMET, 1);
  255. ItemMeta archermeta = archer.getItemMeta();
  256. archermeta.setDisplayName(ChatColor.DARK_RED + "ARCHER");
  257. archer.setItemMeta(archermeta);
  258. gui.setItem(11, archer);
  259.  
  260. ItemStack tank = new ItemStack(Material.CHAINMAIL_HELMET, 1);
  261. ItemMeta tankmeta = tank.getItemMeta();
  262. tankmeta.setDisplayName(ChatColor.DARK_RED + "TANK");
  263. tank.setItemMeta(tankmeta);
  264. gui.setItem(13, tank);
  265.  
  266. ItemStack diamond = new ItemStack(Material.DIAMOND_HELMET, 1);
  267. ItemMeta diamondmeta = diamond.getItemMeta();
  268. diamondmeta.setDisplayName(ChatColor.DARK_RED + "DIAMOND");
  269. diamond.setItemMeta(diamondmeta);
  270. gui.setItem(15, diamond);
  271.  
  272. p.openInventory(gui);
  273. }
  274.  
  275. public void kitMenu(Player p,String kit) {
  276.  
  277. // ItemMeta.addFlags(ItemFlag.HIDE_ENCHANTS)
  278.  
  279. Inventory gui = Bukkit.createInventory(null, 54, ChatColor.AQUA + "Opgrader " + kit);
  280.  
  281. ItemStack glassOrange = null;
  282.  
  283. if (kit == "Archer") {
  284. glassOrange = new ItemStack(Material.STAINED_GLASS_PANE, 1, (short)1);
  285. }
  286.  
  287. else if (kit == "Tank") {
  288. glassOrange = new ItemStack(Material.STAINED_GLASS_PANE, 1, (short)2);
  289. }
  290.  
  291. else if (kit == "Diamond") {
  292. glassOrange = new ItemStack(Material.STAINED_GLASS_PANE, 1, (short)14);
  293. }
  294.  
  295. ItemMeta glassOrangemeta = glassOrange.getItemMeta();
  296. glassOrangemeta.setDisplayName("§7");
  297. glassOrange.setItemMeta(glassOrangemeta);
  298. gui.setItem(1, glassOrange);
  299. gui.setItem(2, glassOrange);
  300. gui.setItem(6, glassOrange);
  301. gui.setItem(7, glassOrange);
  302. gui.setItem(9, glassOrange);
  303. gui.setItem(10, glassOrange);
  304. gui.setItem(16, glassOrange);
  305. gui.setItem(17, glassOrange);
  306. gui.setItem(18, glassOrange);
  307. gui.setItem(26, glassOrange);
  308. gui.setItem(36, glassOrange);
  309. gui.setItem(44, glassOrange);
  310. gui.setItem(46, glassOrange);
  311. gui.setItem(52, glassOrange);
  312.  
  313. ItemStack glassWhite = new ItemStack(Material.STAINED_GLASS_PANE, 1);
  314. ItemMeta glassWhitemeta = glassWhite.getItemMeta();
  315. glassWhitemeta.setDisplayName("§7");
  316. glassWhite.setItemMeta(glassWhitemeta);
  317. gui.setItem(0, glassWhite);
  318. gui.setItem(8, glassWhite);
  319. gui.setItem(45, glassWhite);
  320. gui.setItem(53, glassWhite);
  321.  
  322.  
  323. try {
  324.  
  325.  
  326. openConnection();
  327.  
  328. PreparedStatement sql = null;
  329.  
  330. if (kit == "Archer") {
  331. sql = connection.prepareStatement("SELECT helmet,chestplate,leggings,boots,sword,bow FROM archer_table WHERE spiller=?;");
  332. }
  333.  
  334. else if (kit == "Tank") {
  335. sql = connection.prepareStatement("SELECT helmet,chestplate,leggings,boots,sword FROM tank_table WHERE spiller=?;");
  336. }
  337.  
  338. else if (kit == "Diamond") {
  339. sql = connection.prepareStatement("SELECT helmet,chestplate,leggings,boots,sword FROM diamond_table WHERE spiller=?;");
  340. }
  341.  
  342.  
  343. sql.setString(1, p.getUniqueId() + "");
  344. ResultSet result = sql.executeQuery();
  345. result.next();
  346. String hjelm = result.getString("helmet");
  347. String bryst = result.getString("chestplate");
  348. String bukser = result.getString("leggings");
  349. String sko = result.getString("boots");
  350. String svaerd = result.getString("sword");
  351.  
  352. if (kit == "Archer") {
  353. String bue = result.getString("bow");
  354. ItemStack bow = stringBlobToItem(bue);
  355. ItemMeta bowMeta = bow.getItemMeta();
  356. bowMeta.setDisplayName("§eUpgrader §e§nBow");
  357. bow.setItemMeta(bowMeta);
  358. gui.setItem(30, bow);
  359. }
  360.  
  361. ItemStack helmet = stringBlobToItem(hjelm);
  362. ItemMeta helmetMeta = helmet.getItemMeta();
  363. helmetMeta.setDisplayName("§eUpgrader §e§nHelmet");
  364. helmet.setItemMeta(helmetMeta);
  365. gui.setItem(13, helmet);
  366. ItemStack chestplate = stringBlobToItem(bryst);
  367. ItemMeta chestplateMeta = chestplate.getItemMeta();
  368. chestplateMeta.setDisplayName("§eUpgrader §e§nChestplate");
  369. chestplate.setItemMeta(chestplateMeta);
  370. gui.setItem(22, chestplate);
  371. ItemStack leggings = stringBlobToItem(bukser);
  372. ItemMeta leggingsMeta = leggings.getItemMeta();
  373. leggingsMeta.setDisplayName("§eUpgrader §e§nLeggings");
  374. leggings.setItemMeta(leggingsMeta);
  375. gui.setItem(31, leggings);
  376. ItemStack boots = stringBlobToItem(sko);
  377. ItemMeta bootsMeta = boots.getItemMeta();
  378. bootsMeta.setDisplayName("§eUpgrader §e§nBoots");
  379. boots.setItemMeta(bootsMeta);
  380. gui.setItem(40, boots);
  381. ItemStack sword = stringBlobToItem(svaerd);
  382. ItemMeta swordMeta = sword.getItemMeta();
  383. swordMeta.setDisplayName("§eUpgrader §e§nSword");
  384. sword.setItemMeta(swordMeta);
  385. gui.setItem(21, sword);
  386.  
  387.  
  388. sql.close();
  389. result.close();
  390.  
  391. closeConnection();
  392.  
  393. } catch (Exception exc) {
  394. p.sendMessage(exc.getMessage());
  395. return;
  396. }
  397.  
  398. p.openInventory(gui);
  399.  
  400. }
  401.  
  402. public void upgradeArmor(Player p, String kit, String armorDel) {
  403.  
  404. Inventory gui = Bukkit.createInventory(null, 45, ChatColor.AQUA + "(" + kit + ") Opgrader " + armorDel);
  405.  
  406.  
  407. try {
  408.  
  409.  
  410. openConnection();
  411.  
  412. PreparedStatement sql = null;
  413.  
  414. if (kit.contains("Archer")) {
  415. sql = connection.prepareStatement("SELECT helmet,chestplate,leggings FROM archer_table WHERE spiller=?;");
  416. }
  417.  
  418. else if (kit.contains("Tank")) {
  419. sql = connection.prepareStatement("SELECT helmet,chestplate,leggings FROM tank_table WHERE spiller=?;");
  420. }
  421.  
  422. else if (kit.contains("Diamond")) {
  423. sql = connection.prepareStatement("SELECT helmet,chestplate,leggings FROM diamond_table WHERE spiller=?;");
  424. }
  425.  
  426. sql.setString(1, p.getUniqueId() + "");
  427. ResultSet result = sql.executeQuery();
  428. result.next();
  429. String hjelm = result.getString("helmet");
  430. String bryst = result.getString("chestplate");
  431. String bukser = result.getString("leggings");
  432.  
  433. ItemStack armorProtection = null;
  434. ItemStack armorUnbreaking = null;
  435.  
  436.  
  437. if (armorDel.contains("Helmet")) {
  438.  
  439.  
  440. armorProtection = stringBlobToItem(hjelm);
  441. ItemMeta armorProtectionMeta = armorProtection.getItemMeta();
  442. armorProtectionMeta.setDisplayName("§5§lProtection");
  443.  
  444. armorUnbreaking = stringBlobToItem(hjelm);
  445. ItemMeta armorUnbreakingMeta = armorUnbreaking.getItemMeta();
  446. armorUnbreakingMeta.setDisplayName("§5§lUnbreaking");
  447.  
  448. armorProtection.setItemMeta(armorProtectionMeta);
  449. armorUnbreaking.setItemMeta(armorUnbreakingMeta);
  450.  
  451. gui.setItem(20, armorProtection);
  452. gui.setItem(24, armorUnbreaking);
  453. }
  454.  
  455. else if (armorDel.contains("Chestplate")) {
  456.  
  457. armorProtection = stringBlobToItem(bryst);
  458. ItemMeta armorProtectionMeta = armorProtection.getItemMeta();
  459. armorProtectionMeta.setDisplayName("§5§lProtection");
  460.  
  461.  
  462. armorUnbreaking = stringBlobToItem(bryst);
  463. ItemMeta armorUnbreakingMeta = armorUnbreaking.getItemMeta();
  464. armorUnbreakingMeta.setDisplayName("§5§lUnbreaking");
  465.  
  466. armorProtection.setItemMeta(armorProtectionMeta);
  467. armorUnbreaking.setItemMeta(armorUnbreakingMeta);
  468.  
  469. gui.setItem(20, armorProtection);
  470. gui.setItem(24, armorUnbreaking);
  471. }
  472.  
  473. else if (armorDel.contains("Leggings")) {
  474.  
  475. armorProtection = stringBlobToItem(bukser);
  476. ItemMeta armorProtectionMeta = armorProtection.getItemMeta();
  477. armorProtectionMeta.setDisplayName("§5§lProtection");
  478.  
  479. armorUnbreaking = stringBlobToItem(bukser);
  480. ItemMeta armorUnbreakingMeta = armorUnbreaking.getItemMeta();
  481. armorUnbreakingMeta.setDisplayName("§5§lUnbreaking");
  482.  
  483. armorUnbreaking.setItemMeta(armorUnbreakingMeta);
  484. armorProtection.setItemMeta(armorProtectionMeta);
  485.  
  486. gui.setItem(20, armorProtection);
  487. gui.setItem(24, armorUnbreaking);
  488. }
  489.  
  490. sql.close();
  491. result.close();
  492.  
  493. closeConnection();
  494.  
  495. ItemStack fuldOpgr = new ItemStack(Material.BARRIER,1);
  496. ItemMeta fuldOpgrMeta = fuldOpgr.getItemMeta();
  497. fuldOpgrMeta.setDisplayName("§c§lFULD OPGRADERET");
  498. fuldOpgr.setItemMeta(fuldOpgrMeta);
  499.  
  500.  
  501. ItemStack opgrProtection = new ItemStack(Material.INK_SACK, 1, (short)10);
  502. ItemMeta opgrProtectionmeta = opgrProtection.getItemMeta();
  503. opgrProtectionmeta.setDisplayName("§a§nOpgrader Protection");
  504. if (armorProtection.getEnchantmentLevel(Enchantment.PROTECTION_ENVIRONMENTAL) == 4) {
  505. gui.setItem(11,fuldOpgr);
  506.  
  507. } else {
  508.  
  509. if (armorProtection.getEnchantmentLevel(Enchantment.PROTECTION_ENVIRONMENTAL) == 1) {
  510. opgrProtectionmeta.setLore(Arrays.asList(new String[] { "","§e§lPris: §e§n$2500" }));
  511. }
  512. else if (armorProtection.getEnchantmentLevel(Enchantment.PROTECTION_ENVIRONMENTAL) == 2) {
  513. opgrProtectionmeta.setLore(Arrays.asList(new String[] { "","§e§lPris: §e§n$3500" }));
  514. }
  515. else if (armorProtection.getEnchantmentLevel(Enchantment.PROTECTION_ENVIRONMENTAL) == 3) {
  516. opgrProtectionmeta.setLore(Arrays.asList(new String[] { "","§e§lPris: §e§n$5500" }));
  517. }
  518. else {
  519. opgrProtectionmeta.setLore(Arrays.asList(new String[] { "","§e§lPris: §e§n$1000" }));
  520. }
  521. opgrProtection.setItemMeta(opgrProtectionmeta);
  522. gui.setItem(11, opgrProtection);
  523. }
  524.  
  525. ItemStack opgrUnbreaking = new ItemStack(Material.INK_SACK, 1, (short)10);
  526. ItemMeta opgrUnbreakingmeta = opgrUnbreaking.getItemMeta();
  527. opgrUnbreakingmeta.setDisplayName("§a§nOpgrader Unbreaking");
  528. opgrUnbreaking.setItemMeta(opgrUnbreakingmeta);
  529. gui.setItem(15, opgrUnbreaking);
  530.  
  531. ItemStack nedgrProtection = new ItemStack(Material.INK_SACK, 1, (short)1);
  532. ItemMeta nedgrProtectionmeta = nedgrProtection.getItemMeta();
  533. nedgrProtectionmeta.setDisplayName("§c§nNedgrader Protection");
  534. nedgrProtection.setItemMeta(nedgrProtectionmeta);
  535. gui.setItem(29, nedgrProtection);
  536.  
  537.  
  538. ItemStack nedgrUnbreaking = new ItemStack(Material.INK_SACK, 1, (short)1);
  539. ItemMeta nedgrUnbreakingmeta = nedgrUnbreaking.getItemMeta();
  540. nedgrUnbreakingmeta.setDisplayName("§c§nNedgrader Unbreaking");
  541. nedgrUnbreaking.setItemMeta(nedgrUnbreakingmeta);
  542. gui.setItem(33, nedgrUnbreaking);
  543.  
  544.  
  545. ItemStack glassOrange = new ItemStack(Material.STAINED_GLASS_PANE, 1, (short)2);
  546. ItemMeta glassOrangemeta = glassOrange.getItemMeta();
  547. glassOrangemeta.setDisplayName("§7");
  548. glassOrange.setItemMeta(glassOrangemeta);
  549. gui.setItem(0, glassOrange);
  550. gui.setItem(1, glassOrange);
  551. gui.setItem(2, glassOrange);
  552. gui.setItem(3, glassOrange);
  553. gui.setItem(4, glassOrange);
  554. gui.setItem(5, glassOrange);
  555. gui.setItem(6, glassOrange);
  556. gui.setItem(7, glassOrange);
  557. gui.setItem(8, glassOrange);
  558. gui.setItem(36, glassOrange);
  559. gui.setItem(37, glassOrange);
  560. gui.setItem(38, glassOrange);
  561. gui.setItem(39, glassOrange);
  562. gui.setItem(40, glassOrange);
  563. gui.setItem(41, glassOrange);
  564. gui.setItem(42, glassOrange);
  565. gui.setItem(43, glassOrange);
  566. gui.setItem(44, glassOrange);
  567.  
  568. ItemStack glassWhite = new ItemStack(Material.STAINED_GLASS_PANE, 1, (short)4);
  569. ItemMeta glassWhitemeta = glassWhite.getItemMeta();
  570. glassWhitemeta.setDisplayName("§7");
  571. glassWhite.setItemMeta(glassWhitemeta);
  572. gui.setItem(9, glassWhite);
  573. gui.setItem(10, glassWhite);
  574. gui.setItem(12, glassWhite);
  575. gui.setItem(13, glassWhite);
  576. gui.setItem(14, glassWhite);
  577. gui.setItem(16, glassWhite);
  578. gui.setItem(17, glassWhite);
  579. gui.setItem(18, glassWhite);
  580. gui.setItem(19, glassWhite);
  581. gui.setItem(21, glassWhite);
  582. gui.setItem(22, glassWhite);
  583. gui.setItem(23, glassWhite);
  584. gui.setItem(25, glassWhite);
  585. gui.setItem(26, glassWhite);
  586. gui.setItem(27, glassWhite);
  587. gui.setItem(28, glassWhite);
  588. gui.setItem(30, glassWhite);
  589. gui.setItem(31, glassWhite);
  590. gui.setItem(32, glassWhite);
  591. gui.setItem(34, glassWhite);
  592. gui.setItem(35, glassWhite);
  593.  
  594. p.openInventory(gui);
  595.  
  596. } catch (Exception ec) {
  597. System.out.print(ec);
  598. }
  599.  
  600.  
  601.  
  602. }
  603.  
  604. public void upgradeBoots(Player p, String kit) {
  605. Inventory gui = Bukkit.createInventory(null, 45, ChatColor.AQUA + "(" + kit + ") Opgrader Boots");
  606.  
  607.  
  608.  
  609. try {
  610.  
  611.  
  612. openConnection();
  613.  
  614. PreparedStatement sql = null;
  615.  
  616. if (kit == "Archer") {
  617. sql = connection.prepareStatement("SELECT boots FROM archer_table WHERE spiller=?;");
  618. }
  619.  
  620. else if (kit == "Tank") {
  621. sql = connection.prepareStatement("SELECT boots FROM tank_table WHERE spiller=?;");
  622. }
  623.  
  624. else if (kit == "Diamond") {
  625. sql = connection.prepareStatement("SELECT boots FROM diamond_table WHERE spiller=?;");
  626. }
  627.  
  628.  
  629. sql.setString(1, p.getUniqueId() + "");
  630. ResultSet result = sql.executeQuery();
  631. result.next();
  632. String boots = result.getString("boots");
  633.  
  634. ItemStack fuldOpgr = new ItemStack(Material.BARRIER,1);
  635. ItemMeta fuldOpgrMeta = fuldOpgr.getItemMeta();
  636. fuldOpgrMeta.setDisplayName("§c§lFULD OPGRADERET");
  637. fuldOpgr.setItemMeta(fuldOpgrMeta);
  638.  
  639. ItemStack bootsItem1 = stringBlobToItem(boots);
  640. ItemMeta bootsItem1Meta = bootsItem1.getItemMeta();
  641. bootsItem1Meta.setDisplayName("§5§lProtection");
  642.  
  643. ItemStack bootsItem2 = stringBlobToItem(boots);
  644. ItemMeta bootsItem2Meta = bootsItem2.getItemMeta();
  645. bootsItem2Meta.setDisplayName("§5§lDepthstrider");
  646.  
  647. ItemStack bootsItem3 = stringBlobToItem(boots);
  648. ItemMeta bootsItem3Meta = bootsItem3.getItemMeta();
  649. bootsItem3Meta.setDisplayName("§5§lUnbreaking");
  650.  
  651. bootsItem1.setItemMeta(bootsItem1Meta);
  652. bootsItem2.setItemMeta(bootsItem2Meta);
  653. bootsItem3.setItemMeta(bootsItem3Meta);
  654.  
  655. gui.setItem(20, bootsItem1);
  656. gui.setItem(22, bootsItem2);
  657. gui.setItem(24, bootsItem3);
  658.  
  659. sql.close();
  660. result.close();
  661.  
  662. closeConnection();
  663.  
  664. ItemStack opgrProtection = new ItemStack(Material.INK_SACK, 1, (short)10);
  665. ItemMeta opgrProtectionmeta = opgrProtection.getItemMeta();
  666. opgrProtectionmeta.setDisplayName("§a§nOpgrader Protection");
  667. opgrProtection.setItemMeta(opgrProtectionmeta);
  668. if (bootsItem1.getEnchantmentLevel(Enchantment.PROTECTION_ENVIRONMENTAL) == 4) {
  669. gui.setItem(11,fuldOpgr);
  670. } else {
  671. gui.setItem(11, opgrProtection);
  672. }
  673.  
  674.  
  675.  
  676. ItemStack opgrUnbreaking = new ItemStack(Material.INK_SACK, 1, (short)10);
  677. ItemMeta opgrUnbreakingmeta = opgrUnbreaking.getItemMeta();
  678. opgrUnbreakingmeta.setDisplayName("§a§nOpgrader Unbreaking");
  679. opgrUnbreaking.setItemMeta(opgrUnbreakingmeta);
  680. gui.setItem(15, opgrUnbreaking);
  681.  
  682. ItemStack opgrDepthstrider = new ItemStack(Material.INK_SACK, 1, (short)10);
  683. ItemMeta opgrDepthstridermeta = opgrDepthstrider.getItemMeta();
  684. opgrDepthstridermeta.setDisplayName("§a§nOpgrader Depthstrider");
  685. opgrDepthstrider.setItemMeta(opgrDepthstridermeta);
  686. gui.setItem(13, opgrDepthstrider);
  687.  
  688. ItemStack nedgrProtection = new ItemStack(Material.INK_SACK, 1, (short)1);
  689. ItemMeta nedgrProtectionmeta = nedgrProtection.getItemMeta();
  690. nedgrProtectionmeta.setDisplayName("§c§nNedgrader Protection");
  691. nedgrProtection.setItemMeta(nedgrProtectionmeta);
  692. gui.setItem(29, nedgrProtection);
  693.  
  694.  
  695. ItemStack nedgrUnbreaking = new ItemStack(Material.INK_SACK, 1, (short)1);
  696. ItemMeta nedgrUnbreakingmeta = nedgrUnbreaking.getItemMeta();
  697. nedgrUnbreakingmeta.setDisplayName("§c§nNedgrader Unbreaking");
  698. nedgrUnbreaking.setItemMeta(nedgrUnbreakingmeta);
  699. gui.setItem(33, nedgrUnbreaking);
  700.  
  701. ItemStack nedgrDepthstrider = new ItemStack(Material.INK_SACK, 1, (short)1);
  702. ItemMeta nedgrDepthstridermeta = nedgrDepthstrider.getItemMeta();
  703. nedgrDepthstridermeta.setDisplayName("§c§nNedgrader Depthstrider");
  704. nedgrDepthstrider.setItemMeta(nedgrDepthstridermeta);
  705. gui.setItem(31, nedgrDepthstrider);
  706.  
  707.  
  708. ItemStack glassOrange = new ItemStack(Material.STAINED_GLASS_PANE, 1, (short)2);
  709. ItemMeta glassOrangemeta = glassOrange.getItemMeta();
  710. glassOrangemeta.setDisplayName("§7");
  711. glassOrange.setItemMeta(glassOrangemeta);
  712. gui.setItem(0, glassOrange);
  713. gui.setItem(1, glassOrange);
  714. gui.setItem(2, glassOrange);
  715. gui.setItem(3, glassOrange);
  716. gui.setItem(4, glassOrange);
  717. gui.setItem(5, glassOrange);
  718. gui.setItem(6, glassOrange);
  719. gui.setItem(7, glassOrange);
  720. gui.setItem(8, glassOrange);
  721. gui.setItem(36, glassOrange);
  722. gui.setItem(37, glassOrange);
  723. gui.setItem(38, glassOrange);
  724. gui.setItem(39, glassOrange);
  725. gui.setItem(40, glassOrange);
  726. gui.setItem(41, glassOrange);
  727. gui.setItem(42, glassOrange);
  728. gui.setItem(43, glassOrange);
  729. gui.setItem(44, glassOrange);
  730.  
  731. ItemStack glassWhite = new ItemStack(Material.STAINED_GLASS_PANE, 1, (short)4);
  732. ItemMeta glassWhitemeta = glassWhite.getItemMeta();
  733. glassWhitemeta.setDisplayName("§7");
  734. glassWhite.setItemMeta(glassWhitemeta);
  735. gui.setItem(9, glassWhite);
  736. gui.setItem(10, glassWhite);
  737. gui.setItem(12, glassWhite);
  738. gui.setItem(14, glassWhite);
  739. gui.setItem(16, glassWhite);
  740. gui.setItem(17, glassWhite);
  741. gui.setItem(18, glassWhite);
  742. gui.setItem(19, glassWhite);
  743. gui.setItem(21, glassWhite);
  744. gui.setItem(23, glassWhite);
  745. gui.setItem(25, glassWhite);
  746. gui.setItem(26, glassWhite);
  747. gui.setItem(27, glassWhite);
  748. gui.setItem(28, glassWhite);
  749. gui.setItem(30, glassWhite);
  750. gui.setItem(32, glassWhite);
  751. gui.setItem(34, glassWhite);
  752. gui.setItem(35, glassWhite);
  753.  
  754. p.openInventory(gui);
  755.  
  756. } catch (Exception exc) {
  757. p.sendMessage(exc.getMessage());
  758. return;
  759. }
  760.  
  761. }
  762.  
  763. public void upgradeSword(Player p, String kit) {
  764.  
  765. Inventory gui = Bukkit.createInventory(null, 45, ChatColor.AQUA + "(" + kit + ") Opgrader Sword");
  766.  
  767.  
  768.  
  769. try {
  770.  
  771.  
  772. openConnection();
  773.  
  774. PreparedStatement sql = null;
  775.  
  776. if (kit == "Archer") {
  777. sql = connection.prepareStatement("SELECT sword FROM archer_table WHERE spiller=?;");
  778. }
  779.  
  780. else if (kit == "Tank") {
  781. sql = connection.prepareStatement("SELECT sword FROM tank_table WHERE spiller=?;");
  782. }
  783.  
  784. else if (kit == "Diamond") {
  785. sql = connection.prepareStatement("SELECT sword FROM diamond_table WHERE spiller=?;");
  786. }
  787.  
  788.  
  789. sql.setString(1, p.getUniqueId() + "");
  790. ResultSet result = sql.executeQuery();
  791. result.next();
  792. String sword = result.getString("sword");
  793.  
  794.  
  795. ItemStack swordItem1 = stringBlobToItem(sword);
  796. ItemMeta swordItem1Meta = swordItem1.getItemMeta();
  797. swordItem1Meta.setDisplayName("§5§lSharpness");
  798.  
  799. ItemStack swordItem2 = stringBlobToItem(sword);
  800. ItemMeta swordItem2Meta = swordItem2.getItemMeta();
  801. swordItem2Meta.setDisplayName("§5§lFire Aspect");
  802.  
  803. ItemStack swordItem3 = stringBlobToItem(sword);
  804. ItemMeta swordItem3Meta = swordItem3.getItemMeta();
  805. swordItem3Meta.setDisplayName("§5§lUnbreaking");
  806.  
  807. swordItem1.setItemMeta(swordItem1Meta);
  808. swordItem2.setItemMeta(swordItem2Meta);
  809. swordItem3.setItemMeta(swordItem3Meta);
  810.  
  811. gui.setItem(20, swordItem1);
  812. gui.setItem(22, swordItem2);
  813. gui.setItem(24, swordItem3);
  814.  
  815. sql.close();
  816. result.close();
  817.  
  818. closeConnection();
  819.  
  820. } catch (Exception exc) {
  821. p.sendMessage(exc.getMessage());
  822. return;
  823. }
  824.  
  825. ItemStack opgrProtection = new ItemStack(Material.INK_SACK, 1, (short)10);
  826. ItemMeta opgrProtectionmeta = opgrProtection.getItemMeta();
  827. opgrProtectionmeta.setDisplayName("§a§nOpgrader Sharpness");
  828. opgrProtection.setItemMeta(opgrProtectionmeta);
  829. gui.setItem(11, opgrProtection);
  830.  
  831.  
  832. ItemStack opgrUnbreaking = new ItemStack(Material.INK_SACK, 1, (short)10);
  833. ItemMeta opgrUnbreakingmeta = opgrUnbreaking.getItemMeta();
  834. opgrUnbreakingmeta.setDisplayName("§a§nOpgrader Unbreaking");
  835. opgrUnbreaking.setItemMeta(opgrUnbreakingmeta);
  836. gui.setItem(15, opgrUnbreaking);
  837.  
  838. ItemStack opgrDepthstrider = new ItemStack(Material.INK_SACK, 1, (short)10);
  839. ItemMeta opgrDepthstridermeta = opgrDepthstrider.getItemMeta();
  840. opgrDepthstridermeta.setDisplayName("§a§nOpgrader Fire Aspect");
  841. opgrDepthstrider.setItemMeta(opgrDepthstridermeta);
  842. gui.setItem(13, opgrDepthstrider);
  843.  
  844. ItemStack nedgrProtection = new ItemStack(Material.INK_SACK, 1, (short)1);
  845. ItemMeta nedgrProtectionmeta = nedgrProtection.getItemMeta();
  846. nedgrProtectionmeta.setDisplayName("§c§nNedgrader Sharpness");
  847. nedgrProtection.setItemMeta(nedgrProtectionmeta);
  848. gui.setItem(29, nedgrProtection);
  849.  
  850.  
  851. ItemStack nedgrUnbreaking = new ItemStack(Material.INK_SACK, 1, (short)1);
  852. ItemMeta nedgrUnbreakingmeta = nedgrUnbreaking.getItemMeta();
  853. nedgrUnbreakingmeta.setDisplayName("§c§nNedgrader Unbreaking");
  854. nedgrUnbreaking.setItemMeta(nedgrUnbreakingmeta);
  855. gui.setItem(33, nedgrUnbreaking);
  856.  
  857. ItemStack nedgrDepthstrider = new ItemStack(Material.INK_SACK, 1, (short)1);
  858. ItemMeta nedgrDepthstridermeta = nedgrDepthstrider.getItemMeta();
  859. nedgrDepthstridermeta.setDisplayName("§c§nNedgrader Fire Aspect");
  860. nedgrDepthstrider.setItemMeta(nedgrDepthstridermeta);
  861. gui.setItem(31, nedgrDepthstrider);
  862.  
  863.  
  864. ItemStack glassOrange = new ItemStack(Material.STAINED_GLASS_PANE, 1, (short)2);
  865. ItemMeta glassOrangemeta = glassOrange.getItemMeta();
  866. glassOrangemeta.setDisplayName("§7");
  867. glassOrange.setItemMeta(glassOrangemeta);
  868. gui.setItem(0, glassOrange);
  869. gui.setItem(1, glassOrange);
  870. gui.setItem(2, glassOrange);
  871. gui.setItem(3, glassOrange);
  872. gui.setItem(4, glassOrange);
  873. gui.setItem(5, glassOrange);
  874. gui.setItem(6, glassOrange);
  875. gui.setItem(7, glassOrange);
  876. gui.setItem(8, glassOrange);
  877. gui.setItem(36, glassOrange);
  878. gui.setItem(37, glassOrange);
  879. gui.setItem(38, glassOrange);
  880. gui.setItem(39, glassOrange);
  881. gui.setItem(40, glassOrange);
  882. gui.setItem(41, glassOrange);
  883. gui.setItem(42, glassOrange);
  884. gui.setItem(43, glassOrange);
  885. gui.setItem(44, glassOrange);
  886.  
  887. ItemStack glassWhite = new ItemStack(Material.STAINED_GLASS_PANE, 1, (short)4);
  888. ItemMeta glassWhitemeta = glassWhite.getItemMeta();
  889. glassWhitemeta.setDisplayName("§7");
  890. glassWhite.setItemMeta(glassWhitemeta);
  891. gui.setItem(9, glassWhite);
  892. gui.setItem(10, glassWhite);
  893. gui.setItem(12, glassWhite);
  894. gui.setItem(14, glassWhite);
  895. gui.setItem(16, glassWhite);
  896. gui.setItem(17, glassWhite);
  897. gui.setItem(18, glassWhite);
  898. gui.setItem(19, glassWhite);
  899. gui.setItem(21, glassWhite);
  900. gui.setItem(23, glassWhite);
  901. gui.setItem(25, glassWhite);
  902. gui.setItem(26, glassWhite);
  903. gui.setItem(27, glassWhite);
  904. gui.setItem(28, glassWhite);
  905. gui.setItem(30, glassWhite);
  906. gui.setItem(32, glassWhite);
  907. gui.setItem(34, glassWhite);
  908. gui.setItem(35, glassWhite);
  909.  
  910. p.openInventory(gui);
  911.  
  912.  
  913.  
  914. }
  915.  
  916. public void upgradeBow(Player p) {
  917.  
  918. Inventory gui = Bukkit.createInventory(null, 45, ChatColor.AQUA + "(Archer) Opgrader Bow");
  919.  
  920.  
  921.  
  922. try {
  923.  
  924.  
  925. openConnection();
  926.  
  927. PreparedStatement sql = connection.prepareStatement("SELECT bow FROM archer_table WHERE spiller=?;");
  928.  
  929.  
  930. sql.setString(1, p.getUniqueId() + "");
  931. ResultSet result = sql.executeQuery();
  932. result.next();
  933. String bow = result.getString("bow");
  934.  
  935.  
  936. ItemStack bowItem1 = stringBlobToItem(bow);
  937. ItemMeta bowItem1Meta = bowItem1.getItemMeta();
  938. bowItem1Meta.setDisplayName("§5§lFlame");
  939.  
  940. ItemStack bowItem2 = stringBlobToItem(bow);
  941. ItemMeta bowItem2Meta = bowItem2.getItemMeta();
  942. bowItem2Meta.setDisplayName("§5§lUnbreaking");
  943.  
  944. ItemStack bowItem3 = stringBlobToItem(bow);
  945. ItemMeta bowItem3Meta = bowItem3.getItemMeta();
  946. bowItem3Meta.setDisplayName("§5§lPower");
  947.  
  948. ItemStack bowItem4 = stringBlobToItem(bow);
  949. ItemMeta bowItem4Meta = bowItem4.getItemMeta();
  950. bowItem4Meta.setDisplayName("§5§lPunch");
  951.  
  952. bowItem1.setItemMeta(bowItem1Meta);
  953. bowItem2.setItemMeta(bowItem2Meta);
  954. bowItem3.setItemMeta(bowItem3Meta);
  955. bowItem4.setItemMeta(bowItem4Meta);
  956.  
  957. gui.setItem(19, bowItem1);
  958. gui.setItem(21, bowItem2);
  959. gui.setItem(23, bowItem3);
  960. gui.setItem(25, bowItem4);
  961.  
  962. sql.close();
  963. result.close();
  964.  
  965. closeConnection();
  966.  
  967. } catch (Exception exc) {
  968. p.sendMessage(exc.getMessage());
  969. return;
  970. }
  971.  
  972. ItemStack opgrFlame = new ItemStack(Material.INK_SACK, 1, (short)10);
  973. ItemMeta opgrFlamemeta = opgrFlame.getItemMeta();
  974. opgrFlamemeta.setDisplayName("§a§nOpgrader Flame");
  975. opgrFlame.setItemMeta(opgrFlamemeta);
  976. gui.setItem(10, opgrFlame);
  977.  
  978.  
  979. ItemStack opgrUnbreaking = new ItemStack(Material.INK_SACK, 1, (short)10);
  980. ItemMeta opgrUnbreakingmeta = opgrUnbreaking.getItemMeta();
  981. opgrUnbreakingmeta.setDisplayName("§a§nOpgrader Unbreaking");
  982. opgrUnbreaking.setItemMeta(opgrUnbreakingmeta);
  983. gui.setItem(12, opgrUnbreaking);
  984.  
  985. ItemStack opgrPower = new ItemStack(Material.INK_SACK, 1, (short)10);
  986. ItemMeta opgrPowermeta = opgrPower.getItemMeta();
  987. opgrPowermeta.setDisplayName("§a§nOpgrader Power");
  988. opgrPower.setItemMeta(opgrPowermeta);
  989. gui.setItem(14, opgrPower);
  990.  
  991. ItemStack opgrPunch = new ItemStack(Material.INK_SACK, 1, (short)10);
  992. ItemMeta opgrPunchmeta = opgrPunch.getItemMeta();
  993. opgrPunchmeta.setDisplayName("§a§nOpgrader Punch");
  994. opgrPunch.setItemMeta(opgrPunchmeta);
  995. gui.setItem(16, opgrPunch);
  996.  
  997. ItemStack nedgrFlame = new ItemStack(Material.INK_SACK, 1, (short)1);
  998. ItemMeta nedgrFlamemeta = nedgrFlame.getItemMeta();
  999. nedgrFlamemeta.setDisplayName("§c§nNedgrader Flame");
  1000. nedgrFlame.setItemMeta(nedgrFlamemeta);
  1001. gui.setItem(28, nedgrFlame);
  1002.  
  1003.  
  1004. ItemStack nedgrUnbreaking = new ItemStack(Material.INK_SACK, 1, (short)1);
  1005. ItemMeta nedgrUnbreakingmeta = nedgrUnbreaking.getItemMeta();
  1006. nedgrUnbreakingmeta.setDisplayName("§c§nNedgrader Unbreaking");
  1007. nedgrUnbreaking.setItemMeta(nedgrUnbreakingmeta);
  1008. gui.setItem(30, nedgrUnbreaking);
  1009.  
  1010. ItemStack nedgrPower = new ItemStack(Material.INK_SACK, 1, (short)1);
  1011. ItemMeta nedgrPowermeta = nedgrPower.getItemMeta();
  1012. nedgrPowermeta.setDisplayName("§c§nNedgrader Power");
  1013. nedgrPower.setItemMeta(nedgrPowermeta);
  1014. gui.setItem(32, nedgrPower);
  1015.  
  1016. ItemStack nedgrPunch = new ItemStack(Material.INK_SACK, 1, (short)1);
  1017. ItemMeta nedgrPunchmeta = nedgrPunch.getItemMeta();
  1018. nedgrPunchmeta.setDisplayName("§c§nNedgrader Punch");
  1019. nedgrPunch.setItemMeta(nedgrPunchmeta);
  1020. gui.setItem(34, nedgrPunch);
  1021.  
  1022.  
  1023. ItemStack glassOrange = new ItemStack(Material.STAINED_GLASS_PANE, 1, (short)2);
  1024. ItemMeta glassOrangemeta = glassOrange.getItemMeta();
  1025. glassOrangemeta.setDisplayName("§7");
  1026. glassOrange.setItemMeta(glassOrangemeta);
  1027. gui.setItem(0, glassOrange);
  1028. gui.setItem(1, glassOrange);
  1029. gui.setItem(2, glassOrange);
  1030. gui.setItem(3, glassOrange);
  1031. gui.setItem(4, glassOrange);
  1032. gui.setItem(5, glassOrange);
  1033. gui.setItem(6, glassOrange);
  1034. gui.setItem(7, glassOrange);
  1035. gui.setItem(8, glassOrange);
  1036. gui.setItem(36, glassOrange);
  1037. gui.setItem(37, glassOrange);
  1038. gui.setItem(38, glassOrange);
  1039. gui.setItem(39, glassOrange);
  1040. gui.setItem(40, glassOrange);
  1041. gui.setItem(41, glassOrange);
  1042. gui.setItem(42, glassOrange);
  1043. gui.setItem(43, glassOrange);
  1044. gui.setItem(44, glassOrange);
  1045.  
  1046. ItemStack glassWhite = new ItemStack(Material.STAINED_GLASS_PANE, 1, (short)4);
  1047. ItemMeta glassWhitemeta = glassWhite.getItemMeta();
  1048. glassWhitemeta.setDisplayName("§7");
  1049. glassWhite.setItemMeta(glassWhitemeta);
  1050. gui.setItem(9, glassWhite);
  1051. gui.setItem(11, glassWhite);
  1052. gui.setItem(13, glassWhite);
  1053. gui.setItem(15, glassWhite);
  1054. gui.setItem(17, glassWhite);
  1055. gui.setItem(18, glassWhite);
  1056. gui.setItem(20, glassWhite);
  1057. gui.setItem(22, glassWhite);
  1058. gui.setItem(24, glassWhite);
  1059. gui.setItem(26, glassWhite);
  1060. gui.setItem(27, glassWhite);
  1061. gui.setItem(29, glassWhite);
  1062. gui.setItem(31, glassWhite);
  1063. gui.setItem(33, glassWhite);
  1064. gui.setItem(35, glassWhite);
  1065.  
  1066. p.openInventory(gui);
  1067.  
  1068. }
  1069.  
  1070. public void newPlayerCreateSQL(Player p) {
  1071.  
  1072. try {
  1073. openConnection();
  1074.  
  1075. ItemStack diamondhelmet = new ItemStack(Material.DIAMOND_HELMET,1);
  1076. ItemStack diamondchest = new ItemStack(Material.DIAMOND_CHESTPLATE,1);
  1077. ItemStack diamondleggings = new ItemStack(Material.DIAMOND_LEGGINGS,1);
  1078. ItemStack diamondboots = new ItemStack(Material.DIAMOND_BOOTS,1);
  1079.  
  1080. ItemStack tankhelmet = new ItemStack(Material.CHAINMAIL_HELMET,1);
  1081. ItemStack tankchest = new ItemStack(Material.CHAINMAIL_CHESTPLATE,1);
  1082. ItemStack tankleggings = new ItemStack(Material.CHAINMAIL_LEGGINGS,1);
  1083. ItemStack tankboots = new ItemStack(Material.CHAINMAIL_BOOTS,1);
  1084.  
  1085. ItemStack archerhelmet = new ItemStack(Material.LEATHER_HELMET,1);
  1086. ItemStack archerchest = new ItemStack(Material.LEATHER_CHESTPLATE,1);
  1087. ItemStack archerleggings = new ItemStack(Material.LEATHER_LEGGINGS,1);
  1088. ItemStack archerboots = new ItemStack(Material.LEATHER_BOOTS,1);
  1089. ItemStack bue = new ItemStack(Material.BOW,1);
  1090.  
  1091. ItemStack sword = new ItemStack(Material.DIAMOND_SWORD,1);
  1092.  
  1093.  
  1094. PreparedStatement sql = connection.prepareStatement("INSERT INTO archer_table values(?,?,?,?,?,?,?)");
  1095. sql.setString(1, p.getUniqueId() + "");
  1096. sql.setString(2, itemToStringBlob(archerhelmet));
  1097. sql.setString(3, itemToStringBlob(archerchest));
  1098. sql.setString(4, itemToStringBlob(archerleggings));
  1099. sql.setString(5, itemToStringBlob(archerboots));
  1100. sql.setString(6, itemToStringBlob(sword));
  1101. sql.setString(7, itemToStringBlob(bue));
  1102. sql.execute();
  1103.  
  1104. sql.close();
  1105.  
  1106.  
  1107. sql = connection.prepareStatement("INSERT INTO tank_table values(?,?,?,?,?,?)");
  1108. sql.setString(1, p.getUniqueId() + "");
  1109. sql.setString(2, itemToStringBlob(tankhelmet));
  1110. sql.setString(3, itemToStringBlob(tankchest));
  1111. sql.setString(4, itemToStringBlob(tankleggings));
  1112. sql.setString(5, itemToStringBlob(tankboots));
  1113. sql.setString(6, itemToStringBlob(sword));
  1114. sql.execute();
  1115.  
  1116. sql.close();
  1117.  
  1118. sql = connection.prepareStatement("INSERT INTO diamond_table values(?,?,?,?,?,?)");
  1119. sql.setString(1, p.getUniqueId() + "");
  1120. sql.setString(2, itemToStringBlob(diamondhelmet));
  1121. sql.setString(3, itemToStringBlob(diamondchest));
  1122. sql.setString(4, itemToStringBlob(diamondleggings));
  1123. sql.setString(5, itemToStringBlob(diamondboots));
  1124. sql.setString(6, itemToStringBlob(sword));
  1125. sql.execute();
  1126.  
  1127. sql.close();
  1128.  
  1129. closeConnection();
  1130.  
  1131. }
  1132. catch (Exception ec) {
  1133.  
  1134. }
  1135.  
  1136. }
  1137.  
  1138.  
  1139.  
  1140. }
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!