Advertisement
Tom2565

Untitled

Jan 2nd, 2017
11,581
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 16.04 KB | None | 0 0
  1. /* */ package me.bildung.main;
  2. /* */
  3. /* */ import java.io.File;
  4. /* */ import java.io.PrintStream;
  5. /* */ import java.sql.Connection;
  6. /* */ import java.sql.DriverManager;
  7. /* */ import java.sql.ResultSet;
  8. /* */ import java.sql.SQLException;
  9. /* */ import java.sql.Statement;
  10. /* */ import java.util.UUID;
  11. /* */ import org.bukkit.Bukkit;
  12. /* */ import org.bukkit.OfflinePlayer;
  13. /* */ import org.bukkit.configuration.file.YamlConfiguration;
  14. /* */ import org.bukkit.entity.Player;
  15. /* */
  16. /* */
  17. /* */
  18. /* */ public class MySQL
  19. /* */ {
  20. /* */ public static Connection con;
  21. /* 22 */ public static File file = new File("plugins//PvPShine//MySQL.yml");
  22. /* 23 */ public static File path = new File("plugins//PvPShine");
  23. /* 24 */ public static YamlConfiguration cfg = YamlConfiguration.loadConfiguration(file);
  24. /* */
  25. /* */ static String host;
  26. /* */ static String db;
  27. /* */ static String user;
  28. /* */ static String pass;
  29. /* */
  30. /* */ public static void connect()
  31. /* */ {
  32. /* 33 */ host = cfg.getString("HOST");
  33. /* 34 */ db = cfg.getString("DB");
  34. /* 35 */ user = cfg.getString("USER");
  35. /* 36 */ pass = cfg.getString("PASS");
  36. /* */ try
  37. /* */ {
  38. /* 39 */ con = DriverManager.getConnection("jdbc:mysql://" + host + ":3306/" + db + "?autoReconnect=true", user, pass);
  39. /* */
  40. /* 41 */ System.out.println("|#####################################################|");
  41. /* 42 */ System.out.println("| Plugin Coded by BildungIstSuper |");
  42. /* 43 */ System.out.println("| KrasserJunge.net |");
  43. /* 44 */ System.out.println("| Verbindung zum MySQL Server aufgebaut. |");
  44. /* 45 */ System.out.println("|#####################################################|");
  45. /* */ Player[] arrayOfPlayer;
  46. /* 47 */ int j = (arrayOfPlayer = Bukkit.getOnlinePlayers()).length; for (int i = 0; i < j; i++) { Player all = arrayOfPlayer[i];
  47. /* 48 */ if (all.isOp()) {
  48. /* 49 */ all.sendMessage("Connected.");
  49. /* */ }
  50. /* */ }
  51. /* */
  52. /* 53 */ Update("CREATE TABLE IF NOT EXISTS `User_AMS` (`Player` text,`Spawnercount` text,`Mode` text,`Money` text) ENGINE=InnoDB DEFAULT CHARSET=utf8;");
  53. /* 54 */ Update("CREATE TABLE IF NOT EXISTS `User_Stats` (`Player` text,`Kills` text,`Deaths` text) ENGINE=InnoDB DEFAULT CHARSET=utf8;");
  54. /* 55 */ Update("CREATE TABLE IF NOT EXISTS `User_Ban` (`Player` text,`Warns` text,`Ban` text,`BanReason` text,`BanTime` text,`Banner` text) ENGINE=InnoDB DEFAULT CHARSET=utf8;");
  55. /* 56 */ Update("CREATE TABLE IF NOT EXISTS `User_BanInfo` (`Player` text,`Warns` text,`Ban` text,`BanReason` text,`BanTime` text,`Banner` text) ENGINE=InnoDB DEFAULT CHARSET=utf8;");
  56. /* 57 */ Update("CREATE TABLE IF NOT EXISTS `User_Banned` (`Player` text,`Warns` text,`Ban` text,`BanReason` text,`BanTime` text,`Banner` text) ENGINE=InnoDB DEFAULT CHARSET=utf8;");
  57. /* 58 */ Update("CREATE TABLE IF NOT EXISTS `User_Money` (`Player` text,`Money` text) ENGINE=InnoDB DEFAULT CHARSET=utf8;");
  58. /* 59 */ Update("CREATE TABLE IF NOT EXISTS `User_Killstreak` (`Player` text,`Killstreak` text) ENGINE=InnoDB DEFAULT CHARSET=utf8;");
  59. /* 60 */ Update("CREATE TABLE IF NOT EXISTS `User_Killstreak2` (`Player` text,`Killstreak` text) ENGINE=InnoDB DEFAULT CHARSET=utf8;");
  60. /* 61 */ Update("CREATE TABLE IF NOT EXISTS `User_Killstreak0` (UUID VARCHAR(100), Killstreak INT)");
  61. /* 62 */ Update("CREATE TABLE IF NOT EXISTS `User_Delay` (`Player` text,`KitDelay` text,`KitDelay2` text,`KitDelay3` text,`KitDelay4` text,`TempbanDelay` text) ENGINE=InnoDB DEFAULT CHARSET=utf8;");
  62. /* 63 */ Update("CREATE TABLE IF NOT EXISTS `Jackpot0` (`Player` text,`Mode` text,`Max` text,`Color` text,`Moneyin` text,`Black` text,`Red` text) ENGINE=InnoDB DEFAULT CHARSET=utf8;");
  63. /* 64 */ Update("CREATE TABLE IF NOT EXISTS `Jackpotz` (`Player` text,`Mode` text,`in` text) ENGINE=InnoDB DEFAULT CHARSET=utf8;");
  64. /* 65 */ Update("CREATE TABLE IF NOT EXISTS `Clans` (`Clan` text, `Kills` text, `Deaths` text, `Base` text, `Money` text, `Owner` text) ENGINE=InnoDB DEFAULT CHARSET=utf8;");
  65. /* 66 */ Update("CREATE TABLE IF NOT EXISTS `ClanPlayer` (`Player` text, `Clan` text, `Rank` text, `clear` text, `clear2` text, `clear3` text) ENGINE=InnoDB DEFAULT CHARSET=utf8;");
  66. /* */
  67. /* */ }
  68. /* */ catch (SQLException e)
  69. /* */ {
  70. /* */
  71. /* 72 */ System.err.println(e);
  72. /* 73 */ System.out.println("| Verbindung zum MySQL Server Fehlgeschlagen! |");
  73. /* */ }
  74. /* */ }
  75. /* */
  76. /* */
  77. /* */ public static boolean hasConnection()
  78. /* */ {
  79. /* 80 */ return con != null;
  80. /* */ }
  81. /* */
  82. /* */ public static void close() {
  83. /* */ try {
  84. /* 85 */ if (con != null) {
  85. /* 86 */ con.close();
  86. /* 87 */ con = null;
  87. /* 88 */ System.out.println("| Verbindung zum MySQL Server getrennt. |");
  88. /* */ }
  89. /* */ } catch (Exception e) {
  90. /* 91 */ System.err.println(e);
  91. /* */ }
  92. /* */ }
  93. /* */
  94. /* */ public static void Update(String qry) {
  95. /* */ try {
  96. /* 97 */ Statement stmt = con.createStatement();
  97. /* 98 */ stmt.executeUpdate(qry);
  98. /* */ } catch (Exception e) {
  99. /* 100 */ e.printStackTrace();
  100. /* */ }
  101. /* */ }
  102. /* */
  103. /* */ public static ResultSet Query(String stCheck) throws SQLException {
  104. /* 105 */ Statement statement = con.createStatement();
  105. /* 106 */ return statement.executeQuery(stCheck);
  106. /* */ }
  107. /* */
  108. /* */ public static void prepareClan(Player p, String s) {
  109. /* */ try {
  110. /* 111 */ ResultSet rs = Query("SELECT * FROM `Clans` WHERE `Clan` = '" + s + "'");
  111. /* 112 */ if (!rs.next()) {
  112. /* 113 */ Update("INSERT INTO `Clans` (`Clan`, `Kills`, `Deaths`, `Base`, `Money`, `Owner`) VALUES ('" + s + "','" + "0" + "','" + "0" + "','" + "0" + "','" + "0" + "','" + p.getUniqueId().toString() + "')");
  113. /* 114 */ p.sendMessage(Main.pre + "§7Der Clan §e" + s + "§7 wurde erstellt.");
  114. /* */ } else {
  115. /* 116 */ p.sendMessage(Main.pre + "§cDer Clan existiert bereits.");
  116. /* */ }
  117. /* */ } catch (SQLException e) {
  118. /* 119 */ e.printStackTrace();
  119. /* */ }
  120. /* */ }
  121. /* */
  122. /* */ public static void preparePlayer10(Player p) {
  123. /* 124 */ try { ResultSet rs = Query("SELECT * FROM `ClanPlayer` WHERE `Player` = '" + p.getUniqueId().toString() + "'");
  124. /* 125 */ if (!rs.next()) {
  125. /* 126 */ Update("INSERT INTO `ClanPlayer` (`Player`, `Clan`, `Rank`, `clear`, `clear2`, `clear3`) VALUES ('" + p.getUniqueId().toString() + "','" + "0" + "','" + "0" + "','" + "0" + "','" + "0" + "','" + "0" + "')");
  126. /* */ }
  127. /* */ } catch (SQLException e) {
  128. /* 129 */ e.printStackTrace();
  129. /* */ }
  130. /* */ }
  131. /* */
  132. /* */ public static void preparePlayer9(Player p) {
  133. /* 134 */ try { ResultSet rs = Query("SELECT * FROM `Jackpotz` WHERE `Player` = '" + p.getName() + "'");
  134. /* 135 */ if (!rs.next()) {
  135. /* 136 */ Update("INSERT INTO `Jackpotz` (`Player`, `Mode`, `in`) VALUES ('" + p.getName() + "','" + "0" + "','" + "0" + "')");
  136. /* */ }
  137. /* */ } catch (SQLException e) {
  138. /* 139 */ e.printStackTrace();
  139. /* */ }
  140. /* */ }
  141. /* */
  142. /* */ public static void prepareOfflinePlayer8(OfflinePlayer p) {
  143. /* 144 */ try { ResultSet rs =
  144. /* 145 */ Query("SELECT * FROM `Jackpot0` WHERE `Player` = '" + p.getUniqueId().toString() + "'");
  145. /* 146 */ if (!rs.next()) {
  146. /* 147 */ Update(
  147. /* 148 */ "INSERT INTO `Jackpot0` (`Player`, `Mode`, `Max`, `Color`, `Moneyin`, `Black`, `Red`) VALUES ('" + p.getUniqueId().toString() + "','" + "OFF" + "','" + "0" + "','" + "NO" + "','" + "0" + "','" + "0" + "','" + "0" + "')");
  148. /* */ }
  149. /* */ } catch (SQLException e) {
  150. /* 151 */ e.printStackTrace();
  151. /* */ }
  152. /* */ }
  153. /* */
  154. /* */ public static void prepareOfflinePlayer7(OfflinePlayer p) {
  155. /* 156 */ try { ResultSet rs =
  156. /* 157 */ Query("SELECT * FROM `User_Delay` WHERE `Player` = '" + p.getUniqueId().toString() + "'");
  157. /* 158 */ if (!rs.next()) {
  158. /* 159 */ Update(
  159. /* 160 */ "INSERT INTO `User_Delay` (`Player`, `KitDelay`, `KitDelay2`, `KitDelay3`, `KitDelay4`, `TempbanDelay`) VALUES ('" + p.getUniqueId().toString() + "','" + "§7" + "','" + "0" + "','" + "0" + "','" + "0" + "','" + "0" + "')");
  160. /* */ }
  161. /* */ } catch (SQLException e) {
  162. /* 163 */ e.printStackTrace();
  163. /* */ }
  164. /* */ }
  165. /* */
  166. /* */ public static void preparePlayer7(Player p) {
  167. /* 168 */ try { ResultSet rs =
  168. /* 169 */ Query("SELECT * FROM `User_Delay` WHERE `Player` = '" + p.getUniqueId().toString() + "'");
  169. /* 170 */ if (!rs.next()) {
  170. /* 171 */ Update(
  171. /* 172 */ "INSERT INTO `User_Delay` (`Player`, `KitDelay`, `KitDelay2`, `KitDelay3`, `KitDelay4`, `TempbanDelay`) VALUES ('" + p.getUniqueId().toString() + "','" + "§7" + "','" + "0" + "','" + "0" + "','" + "0" + "','" + "0" + "')");
  172. /* */ }
  173. /* */ } catch (SQLException e) {
  174. /* 175 */ e.printStackTrace();
  175. /* */ }
  176. /* */ }
  177. /* */
  178. /* */ public static void prepareOfflinePlayer6(OfflinePlayer p) {
  179. /* 180 */ try { ResultSet rs =
  180. /* 181 */ Query("SELECT * FROM `User_Killstreak2` WHERE `Player` = '" + p.getUniqueId().toString() + "'");
  181. /* 182 */ if (!rs.next()) {
  182. /* 183 */ Update(
  183. /* 184 */ "INSERT INTO `User_Killstreak2` (`Player`, `Killstreak`) VALUES ('" + p.getUniqueId().toString() + "','" + "0" + "')");
  184. /* */ }
  185. /* */ } catch (SQLException e) {
  186. /* 187 */ e.printStackTrace();
  187. /* */ }
  188. /* */ }
  189. /* */
  190. /* */ public static void preparePlayer6(Player p) {
  191. /* 192 */ try { ResultSet rs =
  192. /* 193 */ Query("SELECT * FROM `User_Killstreak2` WHERE `Player` = '" + p.getUniqueId().toString() + "'");
  193. /* 194 */ if (!rs.next()) {
  194. /* 195 */ Update(
  195. /* 196 */ "INSERT INTO `User_Killstreak2` (`Player`, `Killstreak`) VALUES ('" + p.getUniqueId().toString() + "','" + "0" + "')");
  196. /* */ }
  197. /* */ } catch (SQLException e) {
  198. /* 199 */ e.printStackTrace();
  199. /* */ }
  200. /* */ }
  201. /* */
  202. /* */ public static void preparePlayer5(Player p) {
  203. /* 204 */ try { ResultSet rs =
  204. /* 205 */ Query("SELECT * FROM `User_Killstreak` WHERE `Player` = '" + p.getUniqueId().toString() + "'");
  205. /* 206 */ if (!rs.next()) {
  206. /* 207 */ Update(
  207. /* 208 */ "INSERT INTO `User_Killstreak` (`Player`, `Killstreak`) VALUES ('" + p.getUniqueId().toString() + "','" + "0" + "')");
  208. /* */ }
  209. /* */ } catch (SQLException e) {
  210. /* 211 */ e.printStackTrace();
  211. /* */ }
  212. /* */ }
  213. /* */
  214. /* */ public static void prepareOfflinePlayer4(OfflinePlayer p) {
  215. /* 216 */ try { ResultSet rs =
  216. /* 217 */ Query("SELECT * FROM `User_Money` WHERE `Player` = '" + p.getUniqueId().toString() + "'");
  217. /* 218 */ if (!rs.next()) {
  218. /* 219 */ Update(
  219. /* 220 */ "INSERT INTO `User_Money` (`Player`, `Money`) VALUES ('" + p.getUniqueId().toString() + "','" + "0" + "')");
  220. /* */ }
  221. /* */ } catch (SQLException e) {
  222. /* 223 */ e.printStackTrace();
  223. /* */ }
  224. /* */ }
  225. /* */
  226. /* */ public static void preparePlayer4(OfflinePlayer p) {
  227. /* 228 */ try { ResultSet rs =
  228. /* 229 */ Query("SELECT * FROM `User_Money` WHERE `Player` = '" + p.getUniqueId().toString() + "'");
  229. /* 230 */ if (!rs.next()) {
  230. /* 231 */ Update(
  231. /* 232 */ "INSERT INTO `User_Money` (`Player`, `Money`) VALUES ('" + p.getUniqueId().toString() + "','" + "0" + "')");
  232. /* */ }
  233. /* */ } catch (SQLException e) {
  234. /* 235 */ e.printStackTrace();
  235. /* */ }
  236. /* */ }
  237. /* */
  238. /* */ public static void prepareOfflinePlayer3(OfflinePlayer p) {
  239. /* */ try {
  240. /* 241 */ ResultSet rs =
  241. /* 242 */ Query("SELECT * FROM `User_BanInfo` WHERE `Player` = '" + p.getUniqueId().toString() + "'");
  242. /* 243 */ if (!rs.next()) {
  243. /* 244 */ Update(
  244. /* */
  245. /* */
  246. /* 247 */ "INSERT INTO `User_BanInfo` (`Player`, `Warns`, `Ban`, `BanReason`, `BanTime`, `Banner`) VALUES ('" + p.getUniqueId().toString() + "','" + "0" + "','" + "NO" + "','" + "NONE" + "','" + "NONE" + "','" + "NONE" + "')");
  247. /* */ }
  248. /* */ } catch (SQLException e) {
  249. /* 250 */ e.printStackTrace();
  250. /* */ }
  251. /* */ }
  252. /* */
  253. /* */ public static void preparePlayer3(Player p) {
  254. /* */ try {
  255. /* 256 */ ResultSet rs =
  256. /* 257 */ Query("SELECT * FROM `User_BanInfo` WHERE `Player` = '" + p.getUniqueId().toString() + "'");
  257. /* 258 */ if (!rs.next()) {
  258. /* 259 */ Update(
  259. /* */
  260. /* */
  261. /* 262 */ "INSERT INTO `User_BanInfo` (`Player`, `Warns`, `Ban`, `BanReason`, `BanTime`, `Banner`) VALUES ('" + p.getUniqueId().toString() + "','" + "0" + "','" + "NO" + "','" + "NONE" + "','" + "NONE" + "','" + "NONE" + "')");
  262. /* */ }
  263. /* */ } catch (SQLException e) {
  264. /* 265 */ e.printStackTrace();
  265. /* */ }
  266. /* */ }
  267. /* */
  268. /* */ public static void prepareOfflinePlayer2(OfflinePlayer p) {
  269. /* */ try {
  270. /* 271 */ ResultSet rs =
  271. /* 272 */ Query("SELECT * FROM `User_Stats` WHERE `Player` = '" + p.getUniqueId().toString() + "'");
  272. /* 273 */ if (!rs.next()) {
  273. /* 274 */ Update(
  274. /* 275 */ "INSERT INTO `User_Stats` (`Player`, `Kills`, `Deaths`) VALUES ('" + p.getUniqueId().toString() + "','" + "0" + "','" + "0" + "')");
  275. /* */ }
  276. /* */ } catch (SQLException e) {
  277. /* 278 */ e.printStackTrace();
  278. /* */ }
  279. /* */ }
  280. /* */
  281. /* */ public static void preparePlayer2(Player p) {
  282. /* 283 */ try { ResultSet rs =
  283. /* 284 */ Query("SELECT * FROM `User_Stats` WHERE `Player` = '" + p.getUniqueId().toString() + "'");
  284. /* 285 */ if (!rs.next()) {
  285. /* 286 */ Update(
  286. /* 287 */ "INSERT INTO `User_Stats` (`Player`, `Kills`, `Deaths`) VALUES ('" + p.getUniqueId().toString() + "','" + "0" + "','" + "0" + "')");
  287. /* */ }
  288. /* */ } catch (SQLException e) {
  289. /* 290 */ e.printStackTrace();
  290. /* */ }
  291. /* */ }
  292. /* */
  293. /* */ public static void prepareOfflinePlayer(OfflinePlayer p) {
  294. /* */ try {
  295. /* 296 */ ResultSet rs =
  296. /* 297 */ Query("SELECT * FROM `User_AMS` WHERE `Player` = '" + p.getUniqueId().toString() + "'");
  297. /* 298 */ if (!rs.next()) {
  298. /* 299 */ Update(
  299. /* 300 */ "INSERT INTO `User_AMS` (`Player`, `Spawnercount`, `Mode`, `Money`) VALUES ('" + p.getUniqueId().toString() + "','" + "0" + "','" + "NORMAL" + "','" + "0" + "')");
  300. /* */ }
  301. /* */ } catch (SQLException e) {
  302. /* 303 */ e.printStackTrace();
  303. /* */ }
  304. /* */ }
  305. /* */
  306. /* */ public static void preparePlayer(Player p) {
  307. /* 308 */ try { ResultSet rs =
  308. /* 309 */ Query("SELECT * FROM `User_AMS` WHERE `Player` = '" + p.getUniqueId().toString() + "'");
  309. /* 310 */ if (!rs.next()) {
  310. /* 311 */ Update(
  311. /* 312 */ "INSERT INTO `User_AMS` (`Player`, `Spawnercount`, `Mode`, `Money`) VALUES ('" + p.getUniqueId().toString() + "','" + "0" + "','" + "NORMAL" + "','" + "0" + "')");
  312. /* */ }
  313. /* */ } catch (SQLException e) {
  314. /* 315 */ e.printStackTrace();
  315. /* */ }
  316. /* */ }
  317. /* */ }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement