· 8 years ago · Dec 07, 2017, 11:04 PM
1pr = "§r §8» §3SyndicateGames §8×"
2pr + "§cDazu hast du keine Rechte!"
3
4package de.keinwlan.api;
5
6import java.sql.PreparedStatement;
7import java.sql.ResultSet;
8
9import org.bukkit.entity.Player;
10
11public class CoinsAPI {
12
13 public static void createTable() {
14 try {
15 PreparedStatement ps = MySQL.getStatement(
16 "CREATE TABLE IF NOT EXISTS Money (Spielername VARCHAR(100), UUID VARCHAR(100), Money INT(100))");
17 PreparedStatement ps1 = MySQL.getStatement(
18 "CREATE TABLE IF NOT EXISTS Players (Registered INT(10000), Joined INT(10000))");
19 ps.executeUpdate();
20 } catch (Exception ex) {
21 ex.printStackTrace();
22 }
23 }
24
25 public static void register(Player p) {
26 try {
27 PreparedStatement ps = MySQL.getStatement("INSERT INTO Money (Spielername, UUID, Money) VALUES (?, ?, ?)");
28 ps.setString(1, p.getName());
29 ps.setString(2, p.getUniqueId().toString());
30 ps.setInt(3, 0);
31 ps.executeUpdate();
32 ps.close();
33 } catch (Exception ex) {
34 ex.printStackTrace();
35 }
36 }
37
38 public static boolean isRegistered(Player p) {
39 try {
40 PreparedStatement ps = MySQL.getStatement("SELECT * FROM Money WHERE UUID= ?");
41 ps.setString(1, p.getUniqueId().toString());
42 ResultSet rs = ps.executeQuery();
43 boolean user = rs.next();
44 rs.close();
45 rs.close();
46 return user;
47 } catch (Exception ex) {
48 ex.printStackTrace();
49 }
50 return false;
51 }
52
53 public static boolean isRegistered(String name) {
54 try {
55 PreparedStatement ps = MySQL.getStatement("SELECT * FROM Money WHERE Spielername= ?");
56 ps.setString(1, name);
57 ResultSet rs = ps.executeQuery();
58 boolean user = rs.next();
59 rs.close();
60 rs.close();
61 return user;
62 } catch (Exception ex) {
63 ex.printStackTrace();
64 }
65 return false;
66 }
67
68 public static int getMoney(Player p) {
69 try {
70 PreparedStatement ps = MySQL.getStatement("SELECT * FROM Money WHERE UUID= ?");
71 ps.setString(1, p.getUniqueId().toString());
72 ResultSet rs = ps.executeQuery();
73 rs.next();
74 int Money = rs.getInt("Money");
75 rs.close();
76 ps.close();
77 return Money;
78 } catch (Exception ex) {
79 ex.printStackTrace();
80 }
81 return 0;
82 }
83
84 public static void setMoney(Player p, int Money) {
85 try {
86 PreparedStatement ps = MySQL.getStatement("UPDATE Money SET Money= ? WHERE UUID= ?");
87 ps.setInt(1, Money);
88 ps.setString(2, p.getUniqueId().toString());
89 ps.executeUpdate();
90 ps.close();
91 } catch (Exception ex) {
92 ex.printStackTrace();
93 }
94 }
95
96 public static void addMoney(Player p, int Money) {
97 try {
98 PreparedStatement ps = MySQL.getStatement("UPDATE Money SET Money= ? WHERE UUID= ?");
99 ps.setInt(1, getMoney(p) + Money);
100 ps.setString(2, p.getUniqueId().toString());
101 ps.executeUpdate();
102 ps.close();
103 } catch (Exception ex) {
104 ex.printStackTrace();
105 }
106 }
107
108 public static void removeMoney(Player p, int Money) {
109 try {
110 PreparedStatement ps = MySQL.getStatement("UPDATE Money SET Money= ? WHERE UUID= ?");
111 ps.setInt(1, getMoney(p) - Money);
112 ps.setString(2, p.getUniqueId().toString());
113 ps.executeUpdate();
114 ps.close();
115 } catch (Exception ex) {
116 ex.printStackTrace();
117 }
118 }
119
120 public static int getMoney(String name) {
121 try {
122 PreparedStatement ps = MySQL.getStatement("SELECT * FROM Money WHERE Spielername= ?");
123 ps.setString(1, name);
124 ResultSet rs = ps.executeQuery();
125 rs.next();
126 int Money = rs.getInt("Money");
127 rs.close();
128 ps.close();
129 return Money;
130 } catch (Exception ex) {
131 ex.printStackTrace();
132 }
133 return 0;
134 }
135
136 public static void setMoney(String name, int Money) {
137 try {
138 PreparedStatement ps = MySQL.getStatement("UPDATE Money SET Money= ? WHERE Spielername= ?");
139 ps.setInt(1, Money);
140 ps.setString(2, name);
141 ps.executeUpdate();
142 ps.close();
143 } catch (Exception ex) {
144 ex.printStackTrace();
145 }
146 }
147
148 public static void addMoney(String name, int Money) {
149 try {
150 PreparedStatement ps = MySQL.getStatement("UPDATE Money SET Money= ? WHERE Spielername= ?");
151 ps.setInt(1, getMoney(name) + Money);
152 ps.setString(2, name);
153 ps.executeUpdate();
154 ps.close();
155 } catch (Exception ex) {
156 ex.printStackTrace();
157 }
158 }
159
160 public static void removeMoney(String name, int Money) {
161 try {
162 PreparedStatement ps = MySQL.getStatement("UPDATE Money SET Money= ? WHERE Spielername= ?");
163 ps.setInt(1, getMoney(name) - Money);
164 ps.setString(2, name);
165 ps.executeUpdate();
166 ps.close();
167 } catch (Exception ex) {
168 ex.printStackTrace();
169 }
170 }
171
172}
173
174package de.byTydoo.util;
175
176import java.sql.PreparedStatement;
177import java.sql.ResultSet;
178import java.sql.SQLException;
179
180public class languageManager {
181
182 public static boolean playerExists(String name) {
183 try {
184 PreparedStatement ps = MySQL.getStatement("SELECT * FROM Language WHERE Spielername = '"+name+"'");
185 ResultSet rs = ps.executeQuery();
186 boolean user = rs.next();
187 rs.close();
188 rs.close();
189 return user;
190 } catch (Exception ex) {
191 ex.printStackTrace();
192 }
193 return false;
194 }
195 public static boolean isGerman(String name, String string) {
196 if(playerExists(name)) {
197 ResultSet rs = MySQL.getResult("SELECT * FROM Language WHERE Spielername = '" + name + "';");
198 try {
199 if ((!rs.next()) || (rs.getString("language").equals("english"))) {
200 return false;
201 }
202 } catch (SQLException e) {
203 e.printStackTrace();
204 }
205 }
206 return true;
207 }
208}