dJ6v6h9g

1package fr.zencraft.zenapi.Utils;
2
3import fr.zencraft.zenapi.Listeners.staffListener;
4import fr.zencraft.zenapi.Main;
5import net.md_5.bungee.api.chat.ClickEvent;
6import net.md_5.bungee.api.chat.ComponentBuilder;
7import net.md_5.bungee.api.chat.HoverEvent;
8import net.md_5.bungee.api.chat.TextComponent;
9import org.bukkit.Bukkit;
10import org.bukkit.Material;
11import org.bukkit.entity.Player;
12import org.bukkit.inventory.ItemStack;
13import org.bukkit.potion.PotionEffect;
14import org.bukkit.potion.PotionEffectType;
15
16import java.sql.*;
17import java.text.DateFormat;
18import java.text.ParseException;
19import java.text.SimpleDateFormat;
20import java.util.Date;
21
22public 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}