Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /* */ package me.bildung.main;
- /* */
- /* */ import java.io.File;
- /* */ import java.io.PrintStream;
- /* */ import java.sql.Connection;
- /* */ import java.sql.DriverManager;
- /* */ import java.sql.ResultSet;
- /* */ import java.sql.SQLException;
- /* */ import java.sql.Statement;
- /* */ import java.util.UUID;
- /* */ import org.bukkit.Bukkit;
- /* */ import org.bukkit.OfflinePlayer;
- /* */ import org.bukkit.configuration.file.YamlConfiguration;
- /* */ import org.bukkit.entity.Player;
- /* */
- /* */
- /* */
- /* */ public class MySQL
- /* */ {
- /* */ public static Connection con;
- /* 22 */ public static File file = new File("plugins//PvPShine//MySQL.yml");
- /* 23 */ public static File path = new File("plugins//PvPShine");
- /* 24 */ public static YamlConfiguration cfg = YamlConfiguration.loadConfiguration(file);
- /* */
- /* */ static String host;
- /* */ static String db;
- /* */ static String user;
- /* */ static String pass;
- /* */
- /* */ public static void connect()
- /* */ {
- /* 33 */ host = cfg.getString("HOST");
- /* 34 */ db = cfg.getString("DB");
- /* 35 */ user = cfg.getString("USER");
- /* 36 */ pass = cfg.getString("PASS");
- /* */ try
- /* */ {
- /* 39 */ con = DriverManager.getConnection("jdbc:mysql://" + host + ":3306/" + db + "?autoReconnect=true", user, pass);
- /* */
- /* 41 */ System.out.println("|#####################################################|");
- /* 42 */ System.out.println("| Plugin Coded by BildungIstSuper |");
- /* 43 */ System.out.println("| KrasserJunge.net |");
- /* 44 */ System.out.println("| Verbindung zum MySQL Server aufgebaut. |");
- /* 45 */ System.out.println("|#####################################################|");
- /* */ Player[] arrayOfPlayer;
- /* 47 */ int j = (arrayOfPlayer = Bukkit.getOnlinePlayers()).length; for (int i = 0; i < j; i++) { Player all = arrayOfPlayer[i];
- /* 48 */ if (all.isOp()) {
- /* 49 */ all.sendMessage("Connected.");
- /* */ }
- /* */ }
- /* */
- /* 53 */ Update("CREATE TABLE IF NOT EXISTS `User_AMS` (`Player` text,`Spawnercount` text,`Mode` text,`Money` text) ENGINE=InnoDB DEFAULT CHARSET=utf8;");
- /* 54 */ Update("CREATE TABLE IF NOT EXISTS `User_Stats` (`Player` text,`Kills` text,`Deaths` text) ENGINE=InnoDB DEFAULT CHARSET=utf8;");
- /* 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;");
- /* 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;");
- /* 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;");
- /* 58 */ Update("CREATE TABLE IF NOT EXISTS `User_Money` (`Player` text,`Money` text) ENGINE=InnoDB DEFAULT CHARSET=utf8;");
- /* 59 */ Update("CREATE TABLE IF NOT EXISTS `User_Killstreak` (`Player` text,`Killstreak` text) ENGINE=InnoDB DEFAULT CHARSET=utf8;");
- /* 60 */ Update("CREATE TABLE IF NOT EXISTS `User_Killstreak2` (`Player` text,`Killstreak` text) ENGINE=InnoDB DEFAULT CHARSET=utf8;");
- /* 61 */ Update("CREATE TABLE IF NOT EXISTS `User_Killstreak0` (UUID VARCHAR(100), Killstreak INT)");
- /* 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;");
- /* 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;");
- /* 64 */ Update("CREATE TABLE IF NOT EXISTS `Jackpotz` (`Player` text,`Mode` text,`in` text) ENGINE=InnoDB DEFAULT CHARSET=utf8;");
- /* 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;");
- /* 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;");
- /* */
- /* */ }
- /* */ catch (SQLException e)
- /* */ {
- /* */
- /* 72 */ System.err.println(e);
- /* 73 */ System.out.println("| Verbindung zum MySQL Server Fehlgeschlagen! |");
- /* */ }
- /* */ }
- /* */
- /* */
- /* */ public static boolean hasConnection()
- /* */ {
- /* 80 */ return con != null;
- /* */ }
- /* */
- /* */ public static void close() {
- /* */ try {
- /* 85 */ if (con != null) {
- /* 86 */ con.close();
- /* 87 */ con = null;
- /* 88 */ System.out.println("| Verbindung zum MySQL Server getrennt. |");
- /* */ }
- /* */ } catch (Exception e) {
- /* 91 */ System.err.println(e);
- /* */ }
- /* */ }
- /* */
- /* */ public static void Update(String qry) {
- /* */ try {
- /* 97 */ Statement stmt = con.createStatement();
- /* 98 */ stmt.executeUpdate(qry);
- /* */ } catch (Exception e) {
- /* 100 */ e.printStackTrace();
- /* */ }
- /* */ }
- /* */
- /* */ public static ResultSet Query(String stCheck) throws SQLException {
- /* 105 */ Statement statement = con.createStatement();
- /* 106 */ return statement.executeQuery(stCheck);
- /* */ }
- /* */
- /* */ public static void prepareClan(Player p, String s) {
- /* */ try {
- /* 111 */ ResultSet rs = Query("SELECT * FROM `Clans` WHERE `Clan` = '" + s + "'");
- /* 112 */ if (!rs.next()) {
- /* 113 */ Update("INSERT INTO `Clans` (`Clan`, `Kills`, `Deaths`, `Base`, `Money`, `Owner`) VALUES ('" + s + "','" + "0" + "','" + "0" + "','" + "0" + "','" + "0" + "','" + p.getUniqueId().toString() + "')");
- /* 114 */ p.sendMessage(Main.pre + "§7Der Clan §e" + s + "§7 wurde erstellt.");
- /* */ } else {
- /* 116 */ p.sendMessage(Main.pre + "§cDer Clan existiert bereits.");
- /* */ }
- /* */ } catch (SQLException e) {
- /* 119 */ e.printStackTrace();
- /* */ }
- /* */ }
- /* */
- /* */ public static void preparePlayer10(Player p) {
- /* 124 */ try { ResultSet rs = Query("SELECT * FROM `ClanPlayer` WHERE `Player` = '" + p.getUniqueId().toString() + "'");
- /* 125 */ if (!rs.next()) {
- /* 126 */ Update("INSERT INTO `ClanPlayer` (`Player`, `Clan`, `Rank`, `clear`, `clear2`, `clear3`) VALUES ('" + p.getUniqueId().toString() + "','" + "0" + "','" + "0" + "','" + "0" + "','" + "0" + "','" + "0" + "')");
- /* */ }
- /* */ } catch (SQLException e) {
- /* 129 */ e.printStackTrace();
- /* */ }
- /* */ }
- /* */
- /* */ public static void preparePlayer9(Player p) {
- /* 134 */ try { ResultSet rs = Query("SELECT * FROM `Jackpotz` WHERE `Player` = '" + p.getName() + "'");
- /* 135 */ if (!rs.next()) {
- /* 136 */ Update("INSERT INTO `Jackpotz` (`Player`, `Mode`, `in`) VALUES ('" + p.getName() + "','" + "0" + "','" + "0" + "')");
- /* */ }
- /* */ } catch (SQLException e) {
- /* 139 */ e.printStackTrace();
- /* */ }
- /* */ }
- /* */
- /* */ public static void prepareOfflinePlayer8(OfflinePlayer p) {
- /* 144 */ try { ResultSet rs =
- /* 145 */ Query("SELECT * FROM `Jackpot0` WHERE `Player` = '" + p.getUniqueId().toString() + "'");
- /* 146 */ if (!rs.next()) {
- /* 147 */ Update(
- /* 148 */ "INSERT INTO `Jackpot0` (`Player`, `Mode`, `Max`, `Color`, `Moneyin`, `Black`, `Red`) VALUES ('" + p.getUniqueId().toString() + "','" + "OFF" + "','" + "0" + "','" + "NO" + "','" + "0" + "','" + "0" + "','" + "0" + "')");
- /* */ }
- /* */ } catch (SQLException e) {
- /* 151 */ e.printStackTrace();
- /* */ }
- /* */ }
- /* */
- /* */ public static void prepareOfflinePlayer7(OfflinePlayer p) {
- /* 156 */ try { ResultSet rs =
- /* 157 */ Query("SELECT * FROM `User_Delay` WHERE `Player` = '" + p.getUniqueId().toString() + "'");
- /* 158 */ if (!rs.next()) {
- /* 159 */ Update(
- /* 160 */ "INSERT INTO `User_Delay` (`Player`, `KitDelay`, `KitDelay2`, `KitDelay3`, `KitDelay4`, `TempbanDelay`) VALUES ('" + p.getUniqueId().toString() + "','" + "§7" + "','" + "0" + "','" + "0" + "','" + "0" + "','" + "0" + "')");
- /* */ }
- /* */ } catch (SQLException e) {
- /* 163 */ e.printStackTrace();
- /* */ }
- /* */ }
- /* */
- /* */ public static void preparePlayer7(Player p) {
- /* 168 */ try { ResultSet rs =
- /* 169 */ Query("SELECT * FROM `User_Delay` WHERE `Player` = '" + p.getUniqueId().toString() + "'");
- /* 170 */ if (!rs.next()) {
- /* 171 */ Update(
- /* 172 */ "INSERT INTO `User_Delay` (`Player`, `KitDelay`, `KitDelay2`, `KitDelay3`, `KitDelay4`, `TempbanDelay`) VALUES ('" + p.getUniqueId().toString() + "','" + "§7" + "','" + "0" + "','" + "0" + "','" + "0" + "','" + "0" + "')");
- /* */ }
- /* */ } catch (SQLException e) {
- /* 175 */ e.printStackTrace();
- /* */ }
- /* */ }
- /* */
- /* */ public static void prepareOfflinePlayer6(OfflinePlayer p) {
- /* 180 */ try { ResultSet rs =
- /* 181 */ Query("SELECT * FROM `User_Killstreak2` WHERE `Player` = '" + p.getUniqueId().toString() + "'");
- /* 182 */ if (!rs.next()) {
- /* 183 */ Update(
- /* 184 */ "INSERT INTO `User_Killstreak2` (`Player`, `Killstreak`) VALUES ('" + p.getUniqueId().toString() + "','" + "0" + "')");
- /* */ }
- /* */ } catch (SQLException e) {
- /* 187 */ e.printStackTrace();
- /* */ }
- /* */ }
- /* */
- /* */ public static void preparePlayer6(Player p) {
- /* 192 */ try { ResultSet rs =
- /* 193 */ Query("SELECT * FROM `User_Killstreak2` WHERE `Player` = '" + p.getUniqueId().toString() + "'");
- /* 194 */ if (!rs.next()) {
- /* 195 */ Update(
- /* 196 */ "INSERT INTO `User_Killstreak2` (`Player`, `Killstreak`) VALUES ('" + p.getUniqueId().toString() + "','" + "0" + "')");
- /* */ }
- /* */ } catch (SQLException e) {
- /* 199 */ e.printStackTrace();
- /* */ }
- /* */ }
- /* */
- /* */ public static void preparePlayer5(Player p) {
- /* 204 */ try { ResultSet rs =
- /* 205 */ Query("SELECT * FROM `User_Killstreak` WHERE `Player` = '" + p.getUniqueId().toString() + "'");
- /* 206 */ if (!rs.next()) {
- /* 207 */ Update(
- /* 208 */ "INSERT INTO `User_Killstreak` (`Player`, `Killstreak`) VALUES ('" + p.getUniqueId().toString() + "','" + "0" + "')");
- /* */ }
- /* */ } catch (SQLException e) {
- /* 211 */ e.printStackTrace();
- /* */ }
- /* */ }
- /* */
- /* */ public static void prepareOfflinePlayer4(OfflinePlayer p) {
- /* 216 */ try { ResultSet rs =
- /* 217 */ Query("SELECT * FROM `User_Money` WHERE `Player` = '" + p.getUniqueId().toString() + "'");
- /* 218 */ if (!rs.next()) {
- /* 219 */ Update(
- /* 220 */ "INSERT INTO `User_Money` (`Player`, `Money`) VALUES ('" + p.getUniqueId().toString() + "','" + "0" + "')");
- /* */ }
- /* */ } catch (SQLException e) {
- /* 223 */ e.printStackTrace();
- /* */ }
- /* */ }
- /* */
- /* */ public static void preparePlayer4(OfflinePlayer p) {
- /* 228 */ try { ResultSet rs =
- /* 229 */ Query("SELECT * FROM `User_Money` WHERE `Player` = '" + p.getUniqueId().toString() + "'");
- /* 230 */ if (!rs.next()) {
- /* 231 */ Update(
- /* 232 */ "INSERT INTO `User_Money` (`Player`, `Money`) VALUES ('" + p.getUniqueId().toString() + "','" + "0" + "')");
- /* */ }
- /* */ } catch (SQLException e) {
- /* 235 */ e.printStackTrace();
- /* */ }
- /* */ }
- /* */
- /* */ public static void prepareOfflinePlayer3(OfflinePlayer p) {
- /* */ try {
- /* 241 */ ResultSet rs =
- /* 242 */ Query("SELECT * FROM `User_BanInfo` WHERE `Player` = '" + p.getUniqueId().toString() + "'");
- /* 243 */ if (!rs.next()) {
- /* 244 */ Update(
- /* */
- /* */
- /* 247 */ "INSERT INTO `User_BanInfo` (`Player`, `Warns`, `Ban`, `BanReason`, `BanTime`, `Banner`) VALUES ('" + p.getUniqueId().toString() + "','" + "0" + "','" + "NO" + "','" + "NONE" + "','" + "NONE" + "','" + "NONE" + "')");
- /* */ }
- /* */ } catch (SQLException e) {
- /* 250 */ e.printStackTrace();
- /* */ }
- /* */ }
- /* */
- /* */ public static void preparePlayer3(Player p) {
- /* */ try {
- /* 256 */ ResultSet rs =
- /* 257 */ Query("SELECT * FROM `User_BanInfo` WHERE `Player` = '" + p.getUniqueId().toString() + "'");
- /* 258 */ if (!rs.next()) {
- /* 259 */ Update(
- /* */
- /* */
- /* 262 */ "INSERT INTO `User_BanInfo` (`Player`, `Warns`, `Ban`, `BanReason`, `BanTime`, `Banner`) VALUES ('" + p.getUniqueId().toString() + "','" + "0" + "','" + "NO" + "','" + "NONE" + "','" + "NONE" + "','" + "NONE" + "')");
- /* */ }
- /* */ } catch (SQLException e) {
- /* 265 */ e.printStackTrace();
- /* */ }
- /* */ }
- /* */
- /* */ public static void prepareOfflinePlayer2(OfflinePlayer p) {
- /* */ try {
- /* 271 */ ResultSet rs =
- /* 272 */ Query("SELECT * FROM `User_Stats` WHERE `Player` = '" + p.getUniqueId().toString() + "'");
- /* 273 */ if (!rs.next()) {
- /* 274 */ Update(
- /* 275 */ "INSERT INTO `User_Stats` (`Player`, `Kills`, `Deaths`) VALUES ('" + p.getUniqueId().toString() + "','" + "0" + "','" + "0" + "')");
- /* */ }
- /* */ } catch (SQLException e) {
- /* 278 */ e.printStackTrace();
- /* */ }
- /* */ }
- /* */
- /* */ public static void preparePlayer2(Player p) {
- /* 283 */ try { ResultSet rs =
- /* 284 */ Query("SELECT * FROM `User_Stats` WHERE `Player` = '" + p.getUniqueId().toString() + "'");
- /* 285 */ if (!rs.next()) {
- /* 286 */ Update(
- /* 287 */ "INSERT INTO `User_Stats` (`Player`, `Kills`, `Deaths`) VALUES ('" + p.getUniqueId().toString() + "','" + "0" + "','" + "0" + "')");
- /* */ }
- /* */ } catch (SQLException e) {
- /* 290 */ e.printStackTrace();
- /* */ }
- /* */ }
- /* */
- /* */ public static void prepareOfflinePlayer(OfflinePlayer p) {
- /* */ try {
- /* 296 */ ResultSet rs =
- /* 297 */ Query("SELECT * FROM `User_AMS` WHERE `Player` = '" + p.getUniqueId().toString() + "'");
- /* 298 */ if (!rs.next()) {
- /* 299 */ Update(
- /* 300 */ "INSERT INTO `User_AMS` (`Player`, `Spawnercount`, `Mode`, `Money`) VALUES ('" + p.getUniqueId().toString() + "','" + "0" + "','" + "NORMAL" + "','" + "0" + "')");
- /* */ }
- /* */ } catch (SQLException e) {
- /* 303 */ e.printStackTrace();
- /* */ }
- /* */ }
- /* */
- /* */ public static void preparePlayer(Player p) {
- /* 308 */ try { ResultSet rs =
- /* 309 */ Query("SELECT * FROM `User_AMS` WHERE `Player` = '" + p.getUniqueId().toString() + "'");
- /* 310 */ if (!rs.next()) {
- /* 311 */ Update(
- /* 312 */ "INSERT INTO `User_AMS` (`Player`, `Spawnercount`, `Mode`, `Money`) VALUES ('" + p.getUniqueId().toString() + "','" + "0" + "','" + "NORMAL" + "','" + "0" + "')");
- /* */ }
- /* */ } catch (SQLException e) {
- /* 315 */ e.printStackTrace();
- /* */ }
- /* */ }
- /* */ }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement