cFvxtpw5

1    private void initMySQL() {
2        if (!(this.getConfig().contains("mysql.hostname"))) {
3            this.getConfig().set("mysql.hostname", "localhost");
4            this.getConfig().set("mysql.port", 3306);
5            this.getConfig().set("mysql.user", "root");
6            this.getConfig().set("mysql.password", "1234");
7            this.getConfig().set("mysql.database", "lobbygadgets");
8            this.saveConfig();
9            this.reloadConfig();
10        }
11        mySQL = new MySQL(this.getConfig().getString("mysql.hostname"),
12                this.getConfig().getInt("mysql.port"),
13                this.getConfig().getString("mysql.database"),
14                this.getConfig().getString("mysql.user"),
15                this.getConfig().getString("mysql.password"));
16
17        mySQL.connect();
18        // Create tables
19        mySQL.update("CREATE TABLE IF NOT EXISTS lg_players (uuid VARCHAR(37) NOT NULL PRIMARY KEY DEFAULT '0', playername TEXT, boughtGadgets TEXT, selectedParticle TEXT, selectedGadget TEXT, selectedPet TEXT, selectedPetName TEXT, selectedWing TEXT, hide TEXT); ");
20        mySQL.update("CREATE TABLE IF NOT EXISTS lg_settings (name VARCHAR(37) NOT NULL PRIMARY KEY DEFAULT '0', value TEXT); ");
21        mySQL.update("CREATE TABLE IF NOT EXISTS lg_reward (uuid VARCHAR(37) NOT NULL PRIMARY KEY DEFAULT '0', name TEXT, streak int, premiStreak int, lastReceived TEXT, lastReceivedPremi TEXT, voteReward TEXT); ");
22        mySQL.update("CREATE TABLE IF NOT EXISTS ts_verify (uuid VARCHAR(37) NOT NULL PRIMARY KEY DEFAULT '0', userName TEXT, uid TEXT); ");
23        SQLData.createSettings();
24        SQLData.loadSettings();
25    }