package net.wealth_mc.mystery.db;
import java.io.File;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.logging.Level;
import net.wealth_mc.mystery.Mystery;
public class SQLite extends Database{
private String dbname;
public SQLite(Mystery instance){
super(instance);
dbname = "Mystery";
}
public Connection getSQLConnection() {
File dataFolder = new File(plugin.getDataFolder(), dbname+".db");
if (!dataFolder.exists()){
try {
dataFolder.createNewFile();
} catch (IOException e) {
plugin.getLogger().log(Level.SEVERE, "File write error: "+dbname+".db");
}
}
try {
if(connection!=null && !connection.isClosed()){
return connection;
}
Class.forName("org.sqlite.JDBC");
connection = DriverManager.getConnection("jdbc:sqlite:" + dataFolder);
return connection;
} catch (SQLException ex) {
plugin.getLogger().log(Level.SEVERE,"SQLite exception on initialize", ex);
} catch (ClassNotFoundException ex) {
plugin.getLogger().log(Level.SEVERE, "You need the SQLite JBDC library. Google it. Put it in /lib folder.");
}
return null;
}
public void load() {
connection = getSQLConnection();
try {
Statement s = connection.createStatement();
s.executeUpdate("CREATE TABLE IF NOT EXISTS mystery_player_list ("
/* 1*/ + "`uniqueId` TEXT varchar(255) NOT NULL UNIQUE, "
/* 2*/ + "`displayName` TEXT varchar(100) NOT NULL UNIQUE, "
/* 3*/ + "`legacy` TEXT varchar(50) NOT NULL DEFAULT 'VAGUE', "
/* 4*/ + "`legacy_info` TEXT varchar(255), "
/* 5*/ + "`legacy1` TEXT varchar(50) NOT NULL DEFAULT 'VAGUE', "
/* 6*/ + "`legacy_info1` TEXT varchar(255), "
/* 7*/ + "`legacy2` TEXT varchar(50) NOT NULL DEFAULT 'VAGUE', "
/* 8*/ + "`legacy_info2` TEXT varchar(255), "
/* 9*/ + "`legacy3` TEXT varchar(50) NOT NULL DEFAULT 'VAGUE', "
/*10*/ + "`legacy_info3` TEXT varchar(255), "
/*11*/ + "`legacy4` TEXT varchar(50) NOT NULL DEFAULT 'VAGUE', "
/*12*/ + "`legacy_info4` TEXT varchar(255), "
/*13*/ + "`gender` TEXT varchar(50) NOT NULL DEFAULT 'ASEX', "
/*14*/ + "`level` INTEGER, "
/*15*/ + "`timeLevel` INTEGER, "
/*16*/ + "`gamehours` INTEGER, "
/*17*/ + "`killLevel` INTEGER, "
/*18*/ + "`killTheirLegacy` INTEGER, "
/*19*/ + "`killAlienLegacy` INTEGER, "
/*20*/ + "`killNotLegacy` INTEGER, "
/*21*/ + "`IPadress` TEXT varchar(15) NOT NULL, "
/*22*/ + "`nomult` INTEGER, "
/*23*/ + "`register` INTEGER, "
/*24*/ + "`online` INTEGER,"
/*25*/ + "`grp` TEXT,"
/*26*/ + "`family` TEXT varchar(100),"
/*27*/ + "`bal0` TEXT,"
/*28*/ + "`bal1` TEXT,"
/*39*/ + "`bal2` TEXT,"
/*30*/ + "`bal3` TEXT,"
/*31*/ + "`bal4` TEXT,"
/*32*/ + "`bal5` TEXT,"
/*33*/ + "`bal6` TEXT,"
/*34*/ + "`bal7` TEXT,"
/*35*/ + "`bal8` TEXT, PRIMARY KEY (`uniqueId`));");
s.executeUpdate("CREATE TABLE IF NOT EXISTS three_legacy ("
/* 1*/ + "`legacy` TEXT varchar(255) NOT NULL UNIQUE,"
/* 2*/ + "`lord_uniqueId` TEXT varchar(255) NOT NULL UNIQUE,"
/* 3*/ + "`legacyLevel` INTEGER,"
/* 4*/ + "`legacyInteger` INTEGER,"
/* 5*/ + "`legacyInfo`, PRIMARY KEY (`legacy`));");
s.close();
} catch (SQLException e) {
e.printStackTrace();
}
initialize(); // ***************Это строка № 98*************
}
}
