API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 14th, 2018
87
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 27.01 KB | None | 0 0
raw download clone embed print report
  1. package fr.zencraft.zenapi.Utils;
  2.  
  3. import fr.zencraft.zenapi.Listeners.staffListener;
  4. import fr.zencraft.zenapi.Main;
  5. import net.md_5.bungee.api.chat.ClickEvent;
  6. import net.md_5.bungee.api.chat.ComponentBuilder;
  7. import net.md_5.bungee.api.chat.HoverEvent;
  8. import net.md_5.bungee.api.chat.TextComponent;
  9. import org.bukkit.Bukkit;
  10. import org.bukkit.Material;
  11. import org.bukkit.entity.Player;
  12. import org.bukkit.inventory.ItemStack;
  13. import org.bukkit.potion.PotionEffect;
  14. import org.bukkit.potion.PotionEffectType;
  15.  
  16. import java.sql.*;
  17. import java.text.DateFormat;
  18. import java.text.ParseException;
  19. import java.text.SimpleDateFormat;
  20. import java.util.Date;
  21.  
  22. public class Sql {
  23. private Main main;
  24.  
  25. public Sql(Main main) {
  26. this.main = main;
  27. }
  28.  
  29. private Connection connection;
  30. private String urlbase, host, database, user, password;
  31.  
  32.  
  33. public Sql(String urlbase, String host, String database, String user, String password) {
  34. this.urlbase = urlbase;
  35. this.host = host;
  36. this.database = database;
  37. this.user = user;
  38. this.password = password;
  39. }
  40.  
  41. @SuppressWarnings("static-access")
  42. public void connection() {
  43. if (!isconnected()) {
  44. try {
  45. connection = DriverManager.getConnection(urlbase + host + "/" + database, user, password);
  46. main.logSend("§6ZenAPI: §aConnexion à la base de données effectué avec succès !");
  47. } catch (SQLException e) {
  48. e.printStackTrace();
  49. main.logSend("§6ZenAPI: §cErreur de connexion à la base de données !");
  50. }
  51. createTable();
  52. }
  53. }
  54.  
  55. @SuppressWarnings("static-access")
  56. public void disconnect() {
  57. if (isconnected()) {
  58. try {
  59. connection.close();
  60. main.logSend("§6ZenAPI: §aDéconnecté de la base de données avec succès !");
  61. } catch (SQLException e) {
  62. e.printStackTrace();
  63. main.logSend("§6ZenAPI: §cErreur de déconnexion à la base de données !");
  64. }
  65. }
  66. }
  67.  
  68. public boolean isconnected() {
  69. return connection != null;
  70. }
  71.  
  72. public void createTable() {
  73. try {
  74. PreparedStatement q = connection.prepareStatement(
  75. "CREATE TABLE IF NOT EXISTS players ("
  76. + "id INT(11) NOT NULL AUTO_INCREMENT, "
  77. + "name VARCHAR(255) NOT NULL, "
  78. + "IP VARCHAR(255) NOT NULL,"
  79. + "nick VARCHAR(255),"
  80. + "argent DOUBLE(64,2) NOT NULL,"
  81. + "flytime INT(11) NOT NULL,"
  82. + "points_de_vote INT(11) NOT NULL,"
  83. + "homes LONGTEXT,"
  84. + "notes LONGTEXT,"
  85. + "last_death TEXT,"
  86. + "last_connexion TEXT,"
  87. + "last_position TEXT,"
  88. + "freeze BOOLEAN,"
  89. + "freezed_by VARCHAR(255),"
  90. + "freeze_item_head TEXT,"
  91. + "last_inventory LONGTEXT,"
  92. + "reports LONGTEXT,"
  93. + "date_last_reports TEXT,"
  94. + "timeplayed TEXT,"
  95. + "date_created TIMESTAMP,"
  96. + "mention TEXT,"
  97. + "msg_death TEXT,"
  98. + "PRIMARY KEY (id))");
  99. q.execute();
  100. q.close();
  101. } catch (SQLException e) {
  102. e.printStackTrace();
  103. }
  104. }
  105.  
  106. public void createplayersqlaccount(String p) {
  107. if (!playerhassqlaccount(p)) {
  108. try {
  109. PreparedStatement q = connection.prepareStatement("INSERT INTO players(name,IP,argent,flytime,points_de_vote,date_created) VALUES (?,?,?,?,?,now())");
  110. q.setString(1, p);
  111. Player pl = Bukkit.getPlayer(p);
  112. q.setString(2, pl.getAddress().getAddress().toString());
  113. q.setDouble(3, 100.00);
  114. q.setInt(4, 0);
  115. q.setInt(5, 0);
  116. q.execute();
  117. q.close();
  118. } catch (SQLException e) {
  119. e.printStackTrace();
  120. }
  121. }
  122. }
  123.  
  124.  
  125. public boolean playerhassqlaccount(String p) {
  126. try {
  127. PreparedStatement q = connection.prepareStatement("SELECT name FROM players WHERE name = ?");
  128. q.setString(1, p);
  129. ResultSet res = q.executeQuery();
  130. boolean hasaccount = res.next();
  131. q.close();
  132. return hasaccount;
  133. } catch (SQLException e) {
  134. e.printStackTrace();
  135. }
  136. return false;
  137. }
  138.  
  139. public String getplayername(String p) {
  140. if (!playerhassqlaccount(p)) {
  141. createplayersqlaccount(p);
  142. }
  143. try {
  144. PreparedStatement q = connection.prepareStatement("SELECT name FROM players WHERE name = ?");
  145. q.setString(1, p);
  146. String name = "";
  147. ResultSet res = q.executeQuery();
  148. while (res.next()) {
  149. name = res.getString("name");
  150. }
  151. q.close();
  152. return name;
  153. } catch (SQLException e) {
  154. e.printStackTrace();
  155. }
  156. return null;
  157. }
  158.  
  159. public String getplayerip(String p) {
  160. if (!playerhassqlaccount(p)) {
  161. createplayersqlaccount(p);
  162. }
  163. try {
  164. PreparedStatement q = connection.prepareStatement("SELECT IP FROM players WHERE name = ?");
  165. q.setString(1, p);
  166. String ip = "";
  167. ResultSet res = q.executeQuery();
  168. while (res.next()) {
  169. ip = res.getString("IP");
  170. }
  171. q.close();
  172. return ip;
  173. } catch (SQLException e) {
  174. e.printStackTrace();
  175. }
  176. return "";
  177. }
  178.  
  179. public String getplayernick(String p) {
  180. if (!playerhassqlaccount(p)) {
  181. createplayersqlaccount(p);
  182. }
  183. try {
  184. PreparedStatement q = connection.prepareStatement("SELECT nick FROM players WHERE name = ?");
  185. q.setString(1, p);
  186. String ip = "";
  187. ResultSet res = q.executeQuery();
  188. while (res.next()) {
  189. ip = res.getString("nick");
  190. if((ip == null) || (ip == "")){
  191. ip = "Aucun";
  192. }
  193. }
  194. q.close();
  195. return ip;
  196. } catch (SQLException e) {
  197. e.printStackTrace();
  198. }
  199. return "";
  200. }
  201.  
  202. public Integer getplayerflytime(String p) {
  203. if (!playerhassqlaccount(p)) {
  204. createplayersqlaccount(p);
  205. }
  206. try {
  207. PreparedStatement q = connection.prepareStatement("SELECT flytime FROM players WHERE name = ?");
  208. q.setString(1, p);
  209. Integer flytime = 0;
  210. ResultSet res = q.executeQuery();
  211. while (res.next()) {
  212. flytime = res.getInt("flytime");
  213. }
  214. q.close();
  215. return flytime;
  216. } catch (SQLException e) {
  217. e.printStackTrace();
  218. }
  219. return 0;
  220. }
  221.  
  222. public Integer getplayervotepoint(String p) {
  223. if (!playerhassqlaccount(p)) {
  224. createplayersqlaccount(p);
  225. }
  226. try {
  227. PreparedStatement q = connection.prepareStatement("SELECT points_de_vote FROM players WHERE name = ?");
  228. q.setString(1, p);
  229. Integer points_de_vote = 0;
  230. ResultSet res = q.executeQuery();
  231. while (res.next()) {
  232. points_de_vote = res.getInt("points_de_vote");
  233. }
  234. q.close();
  235. return points_de_vote;
  236. } catch (SQLException e) {
  237. e.printStackTrace();
  238. }
  239. return 0;
  240. }
  241.  
  242. //Argent
  243.  
  244. public double getplayermoney(String p) {
  245. if (!playerhassqlaccount(p)) {
  246. createplayersqlaccount(p);
  247. }
  248. try {
  249. PreparedStatement q = connection.prepareStatement("SELECT argent FROM players WHERE name = ?");
  250. q.setString(1, p);
  251. double money = 0.00;
  252. ResultSet res = q.executeQuery();
  253. while (res.next()) {
  254. money = res.getDouble("argent");
  255. }
  256. q.close();
  257. return money;
  258. } catch (SQLException e) {
  259. e.printStackTrace();
  260. }
  261. return 0.00;
  262. }
  263.  
  264. public boolean playerhassqlmoney(String p, double montant) {
  265. if (!playerhassqlaccount(p)) {
  266. createplayersqlaccount(p);
  267. }
  268. try {
  269. PreparedStatement q = connection.prepareStatement("SELECT argent FROM players WHERE name = ?");
  270. q.setString(1, p);
  271. double money = 0.00;
  272. ResultSet res = q.executeQuery();
  273. while (res.next()) {
  274. money = res.getDouble("argent");
  275. }
  276. q.close();
  277. if (money >= montant) {
  278. return true;
  279. }
  280. } catch (SQLException e) {
  281. e.printStackTrace();
  282. }
  283. return false;
  284. }
  285.  
  286.  
  287. public void addmoney(String p, double amount) {
  288. Double money = getplayermoney(p);
  289. Double nvmontant = money + amount;
  290. try {
  291. PreparedStatement q = connection.prepareStatement("UPDATE players SET argent = ? WHERE name = ?");
  292. q.setDouble(1, nvmontant);
  293. q.setString(2, p);
  294. q.executeUpdate();
  295. q.close();
  296. } catch (SQLException e) {
  297. e.printStackTrace();
  298. }
  299. }
  300.  
  301.  
  302. public void setmoney(String p, double amount) {
  303. try {
  304. PreparedStatement q = connection.prepareStatement("UPDATE players SET argent = ? WHERE name = ?");
  305. q.setDouble(1, amount);
  306. q.setString(2, p);
  307. q.executeUpdate();
  308. q.close();
  309. } catch (SQLException e) {
  310. e.printStackTrace();
  311. }
  312. }
  313.  
  314. public void removemoney(String p, double amount) {
  315. Double money = getplayermoney(p);
  316. Double nvmontant = money - amount;
  317. if (nvmontant <= 0) {
  318. return;
  319. }
  320. try {
  321. PreparedStatement q = connection.prepareStatement("UPDATE players SET argent = ? WHERE name = ?");
  322. q.setDouble(1, nvmontant);
  323. q.setString(2, p);
  324. q.executeUpdate();
  325. q.close();
  326. } catch (SQLException e) {
  327. e.printStackTrace();
  328. }
  329. }
  330.  
  331. public void getclassement(Player p, int nbr) {
  332. try {
  333. PreparedStatement q = connection.prepareStatement("SELECT * FROM players WHERE argent ORDER BY argent DESC");
  334. ResultSet resultat = q.executeQuery();
  335. p.sendMessage("§9§m\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0");
  336. p.sendMessage("§aClassement des fortunes sur le serveur :");
  337. p.sendMessage("§9§m\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0");
  338. for (int i = 1; i <= nbr; i++) {
  339. if (resultat.next()) {
  340. String pseudo = resultat.getString("name");
  341. String argent = resultat.getString("argent");
  342. p.sendMessage("§a[" + String.valueOf(i) + "] §6" + pseudo + "§a avec§6 " + String.valueOf(argent) + " $");
  343. }
  344. }
  345. q.close();
  346. } catch (SQLException e) {
  347. e.printStackTrace();
  348. }
  349. }
  350.  
  351. //Fin eco
  352.  
  353. public void searchIP(Player p, String ip) {
  354. try {
  355. PreparedStatement q = connection.prepareStatement("SELECT * FROM players TRY where IP = ?");
  356. int reponse = 0;
  357. q.setString(1,"/"+ip);
  358. ResultSet resultat = q.executeQuery();
  359. p.sendMessage("§7§m\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0");
  360. p.sendMessage("§7Recherche des comptes associés à §6" + ip);
  361. p.sendMessage("§7§m\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0\u25a0");
  362. while (resultat.next()) {
  363. reponse ++;
  364. String pseudo = resultat.getString("name");
  365. TextComponent pip = new TextComponent("§7Nom du joueur: §6" + pseudo + " [Cliquer ici pour voir ces infos]");
  366. pip.setHoverEvent(new HoverEvent(HoverEvent.Action.SHOW_TEXT,
  367. new ComponentBuilder("§7Clique pour voir les infos du joueur §6" + pseudo)
  368. .create()));
  369. pip.setClickEvent(new ClickEvent(ClickEvent.Action.RUN_COMMAND, "/seen " + pseudo));
  370. p.spigot().sendMessage(pip);
  371. }
  372. if(reponse == 0){
  373. p.sendMessage("\n§7Aucun joueur trouvé ...");
  374. } else {
  375. p.sendMessage("\n§6"+reponse + " §7joueurs trouvés");
  376. }
  377. q.close();
  378. } catch (SQLException e) {
  379. e.printStackTrace();
  380. }
  381. }
  382.  
  383. public boolean playerhasfreeze(String p) {
  384. if (!playerhassqlaccount(p)) {
  385. createplayersqlaccount(p);
  386. }
  387. try {
  388. PreparedStatement q = connection.prepareStatement("SELECT freeze FROM players WHERE name = ?");
  389. q.setString(1, p);
  390. ResultSet res = q.executeQuery();
  391. while (res.next()) {
  392. if(res.getBoolean("freeze")){
  393. return true;
  394. }
  395. }
  396. q.close();
  397. } catch (SQLException e) {
  398. e.printStackTrace();
  399. }
  400. return false;
  401. }
  402.  
  403.  
  404. @SuppressWarnings("deprecation")
  405. public void freeze(String cible, String author) {
  406. if (!playerhassqlaccount(cible)) {
  407. createplayersqlaccount(cible);
  408. }
  409. if (playerhasfreeze(cible)) {
  410. try {
  411. PreparedStatement q = connection.prepareStatement("UPDATE players SET freeze = ?,freezed_by = ? WHERE name = ?");
  412. q.setBoolean(1, false);
  413. q.setString(2, null);
  414. q.setString(3, cible);
  415. q.executeUpdate();
  416. q.close();
  417. if(staffListener.freeze.containsKey(cible)){
  418. staffListener.freeze.remove(cible);
  419. }
  420. if (Bukkit.getPlayer(cible) != null) {
  421. Player pcible = Bukkit.getPlayer(cible);
  422. pcible.sendMessage("§aVous avez été unfreeze par " + author + " !");
  423. pcible.setAllowFlight(false);
  424. pcible.removePotionEffect(PotionEffectType.BLINDNESS);
  425. freezerunnable.bar1.removePlayer(pcible);
  426. pcible.getInventory().setHelmet(null);
  427. if(freezegetheaditem(pcible.getName()) != null && freezegetheaditem(pcible.getName()) != ""){
  428. Material m = Material.matchMaterial(freezegetheaditem(pcible.getName()));
  429. ItemStack stack = new ItemStack(m, 1);
  430. pcible.getInventory().setHelmet(stack);
  431. }
  432. freezesetheaditem(pcible.getName(),null);
  433. }
  434. if (Bukkit.getPlayer(author) != null) {
  435. Player pauthor = Bukkit.getPlayer(author);
  436. pauthor.sendMessage("§2[STAFF] §6>> Vous avez unfreeze avec succès " + cible);
  437. }
  438. } catch (SQLException e) {
  439. e.printStackTrace();
  440. }
  441. } else {
  442. try {
  443. PreparedStatement q = connection.prepareStatement("UPDATE players SET freeze = ?,freezed_by = ? WHERE name = ?");
  444. q.setBoolean(1, true);
  445. q.setString(2, author);
  446. q.setString(3, cible);
  447. q.executeUpdate();
  448. q.close();
  449. if(!staffListener.freeze.containsKey(cible)){
  450. staffListener.freeze.put(cible,author);
  451. }
  452. if (Bukkit.getPlayer(cible) != null) {
  453. Player pcible = Bukkit.getPlayer(cible);
  454. pcible.sendMessage("§cVous avez été freeze par " + author + " !");
  455. pcible.setAllowFlight(true);
  456. pcible.sendTitle("","§cVous avez été freeze par " + staffListener.freeze.get(pcible.getName()));
  457. pcible.addPotionEffect(new PotionEffect(PotionEffectType.BLINDNESS, Integer.MAX_VALUE, 255, false, false));
  458. if(pcible.getInventory().getHelmet() != null){
  459. freezesetheaditem(pcible.getName(),pcible.getInventory().getHelmet().getType().toString());
  460. }
  461. pcible.getInventory().setHelmet(new ItemStack(Material.ICE,1));
  462. }
  463. if (Bukkit.getPlayer(author) != null) {
  464. Player pauthor = Bukkit.getPlayer(author);
  465. pauthor.sendMessage("§2[STAFF] §6>> Vous avez freeze avec succès " + cible);
  466. }
  467. } catch (SQLException e) {
  468. e.printStackTrace();
  469. }
  470. }
  471. }
  472.  
  473. public String freezedby(String cible) {
  474. if (!playerhassqlaccount(cible)) {
  475. createplayersqlaccount(cible);
  476. }
  477. try {
  478. PreparedStatement q = connection.prepareStatement("SELECT freezed_by FROM players WHERE name = ?");
  479. q.setString(1, cible);
  480. String name = "";
  481. ResultSet res = q.executeQuery();
  482. while (res.next()) {
  483. name = res.getString("freezed_by");
  484. }
  485. q.close();
  486. return name;
  487. } catch (SQLException e) {
  488. e.printStackTrace();
  489. }
  490. return null;
  491. }
  492.  
  493. public void freezesetheaditem(String p, String item){
  494. try {
  495. PreparedStatement q = connection.prepareStatement("UPDATE players SET freeze_item_head = ? WHERE name = ?");
  496. q.setString(1, item);
  497. q.setString(2, p);
  498. q.executeUpdate();
  499. q.close();
  500. } catch (SQLException e) {
  501. e.printStackTrace();
  502. }
  503. }
  504.  
  505. public String freezegetheaditem(String p){
  506. try {
  507. PreparedStatement q = connection.prepareStatement("SELECT freeze_item_head FROM players WHERE name = ?");
  508. q.setString(1, p);
  509. ResultSet res = q.executeQuery();
  510. String item = null;
  511. while (res.next()) {
  512. item = res.getString("freeze_item_head");
  513. }
  514. q.close();
  515. return item;
  516. } catch (SQLException e) {
  517. e.printStackTrace();
  518. }
  519. return null;
  520. }
  521.  
  522. public void setreport(String p,String report,Boolean editdate) {
  523. if (!playerhassqlaccount(p)) {
  524. createplayersqlaccount(p);
  525. }
  526. String stringrequete;
  527. if(editdate){
  528. stringrequete = "UPDATE players SET reports = ?,date_last_reports = NOW() WHERE name = ?";
  529. } else {
  530. stringrequete = "UPDATE players SET reports = ? WHERE name = ?";
  531. }
  532. try {
  533. PreparedStatement q = connection.prepareStatement(stringrequete);
  534. q.setString(1, report);
  535. q.setString(2, p);
  536. q.executeUpdate();
  537. q.close();
  538. } catch (SQLException e) {
  539. e.printStackTrace();
  540. }
  541. }
  542.  
  543. public void removereport(String p) {
  544. if (!playerhassqlaccount(p)) {
  545. createplayersqlaccount(p);
  546. }
  547. try {
  548. PreparedStatement q = connection.prepareStatement("UPDATE players SET reports = ?,date_last_reports = ? WHERE name = ?");
  549. q.setString(1,null);
  550. q.setString(2,null);
  551. q.setString(3, p);
  552. q.executeUpdate();
  553. q.close();
  554. } catch (SQLException e) {
  555. e.printStackTrace();
  556. }
  557. }
  558.  
  559. public String getreportplayer(String p) {
  560. if (!playerhassqlaccount(p)) {
  561. createplayersqlaccount(p);
  562. }
  563. try {
  564. PreparedStatement q = connection.prepareStatement("SELECT reports FROM players WHERE name = ?");
  565. q.setString(1, p);
  566. String report = "Aucun";
  567. ResultSet res = q.executeQuery();
  568. while (res.next()) {
  569. if(res.getString("reports") != null){
  570. report = res.getString("reports");
  571. }
  572. }
  573. q.close();
  574. return report;
  575. } catch (SQLException e) {
  576. e.printStackTrace();
  577. }
  578. return "Aucun";
  579. }
  580.  
  581. public String getdatelastreportplayer(String p) {
  582. if (!playerhassqlaccount(p)) {
  583. createplayersqlaccount(p);
  584. }
  585. try {
  586. PreparedStatement q = connection.prepareStatement("SELECT date_last_reports FROM players WHERE name = ?");
  587. q.setString(1, p);
  588. String report = "Aucun";
  589. ResultSet res = q.executeQuery();
  590. while (res.next()) {
  591. if(res.getString("date_last_reports") != null){
  592. report = res.getString("date_last_reports");
  593. }
  594. }
  595. q.close();
  596. return report;
  597. } catch (SQLException e) {
  598. e.printStackTrace();
  599. }
  600. return "Aucun";
  601. }
  602.  
  603. // homes
  604.  
  605. public void setHomeString(String player, String result) {
  606. try {
  607. PreparedStatement q = connection.prepareStatement("UPDATE players SET homes = ? WHERE name = ?");
  608. q.setString(1, result);
  609. q.setString(2, player);
  610. q.executeUpdate();
  611. q.close();
  612. } catch (SQLException e) {
  613. e.printStackTrace();
  614. }
  615. }
  616.  
  617. public String getHomeString(String player) {
  618. if (!playerhassqlaccount(player)) {
  619. createplayersqlaccount(player);
  620. }
  621. try {
  622. PreparedStatement q = connection.prepareStatement("SELECT homes FROM players WHERE name = ?");
  623. q.setString(1, player);
  624. String result = null;
  625. ResultSet res = q.executeQuery();
  626. while (res.next()) {
  627. result = res.getString("homes");
  628. }
  629. q.close();
  630. return result;
  631. } catch (SQLException e) {
  632. e.printStackTrace();
  633. }
  634. return null;
  635. }
  636.  
  637. public String getDateCreated(String player) {
  638. if (!playerhassqlaccount(player)) {
  639. createplayersqlaccount(player);
  640. }
  641. try {
  642. PreparedStatement q = connection.prepareStatement("SELECT date_created FROM players WHERE name = ?");
  643. q.setString(1, player);
  644. String result = "";
  645. ResultSet res = q.executeQuery();
  646. while (res.next()) {
  647. result = res.getString("date_created");
  648. }
  649. q.close();
  650. return result;
  651. } catch (SQLException e) {
  652. e.printStackTrace();
  653. }
  654. return "";
  655. }
  656.  
  657.  
  658.  
  659. public void setLastConnexion(String p) {
  660. SimpleDateFormat formater = null;
  661. Date aujourdhui = new Date();
  662. formater = new SimpleDateFormat("dd MMMM yyyy 'à' hh:mm:ss aa");
  663. try {
  664. PreparedStatement q = connection.prepareStatement("UPDATE players SET Last_Connexion = ? WHERE name = ?");
  665. q.setString(1,formater.format(aujourdhui));
  666. q.setString(2, p);
  667. q.executeUpdate();
  668. q.close();
  669. } catch (SQLException e) {
  670. e.printStackTrace();
  671. }
  672. }
  673.  
  674. public void setTimePlayed(String p,String timeplayed) {
  675. try {
  676. PreparedStatement q = connection.prepareStatement("UPDATE players SET timeplayed = ? WHERE name = ?");
  677. q.setString(1,timeplayed);
  678. q.setString(2, p);
  679. q.executeUpdate();
  680. q.close();
  681. } catch (SQLException e) {
  682. e.printStackTrace();
  683. }
  684. }
  685.  
  686. public String getTimePlayed(String p) {
  687. if (!playerhassqlaccount(p)) {
  688. createplayersqlaccount(p);
  689. }
  690. try {
  691. PreparedStatement q = connection.prepareStatement("SELECT timeplayed FROM players WHERE name = ?");
  692. q.setString(1, p);
  693. String timeplayed = "0";
  694. ResultSet res = q.executeQuery();
  695. while (res.next()) {
  696. timeplayed = res.getString("timeplayed");
  697. if(timeplayed == null){
  698. timeplayed = "0";
  699. }
  700. }
  701. q.close();
  702. return timeplayed;
  703. } catch (SQLException e) {
  704. e.printStackTrace();
  705. }
  706. return "0";
  707. }
  708.  
  709. public String getLastConnexion(String p) {
  710. if (!playerhassqlaccount(p)) {
  711. createplayersqlaccount(p);
  712. }
  713. try {
  714. PreparedStatement q = connection.prepareStatement("SELECT Last_Connexion FROM players WHERE name = ?");
  715. q.setString(1, p);
  716. String result = null;
  717. ResultSet res = q.executeQuery();
  718. while (res.next()) {
  719. String dateStr = res.getString("Last_Connexion");
  720. DateFormat inFormat = new SimpleDateFormat( "dd MMMM yyyy 'à' hh:mm:ss aa");
  721. DateFormat outFormat = new SimpleDateFormat( "yyyy/MM/dd HH:mm:ss");
  722. Date date = null;
  723. try
  724. {
  725. date = inFormat.parse(dateStr);
  726. }
  727. catch ( ParseException e )
  728. {
  729. e.printStackTrace();
  730. }
  731. if( date != null )
  732. {
  733. result = outFormat.format(date);
  734. }
  735. }
  736. q.close();
  737. return result;
  738. } catch (SQLException e) {
  739. e.printStackTrace();
  740. }
  741. return null;
  742. }
  743.  
  744.  
  745. }
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!