5kubVnnm

1# toolsplugin #
2
3    protected boolean registerDatabase() {
4        switch (StoreMode.getByName(Settings.DATABASE_MODE)) {
5            case MYSQL: {
6                ToolsPlugin.store = new StoreMySQL(Settings.DATABASE_MYSQL_HOST, Settings.DATABASE_MYSQL_PORT, Settings.DATABASE_MYSQL_USER, Settings.DATABASE_MYSQL_PASS, Settings.DATABASE_MYSQL_NAME, Settings.DATABASE_TABLEPREFIX);
7                break;
8            }
9            case SQLITE: {
10                ToolsPlugin.store = new StoreSQLITE(Settings.DATABASE_SQLITE_NAME, Settings.DATABASE_TABLEPREFIX);
11                break;
12            }
13            default: {
14                Logger.warning("Value of databse mode is not valid! Using SQLITE as database!");
15                ToolsPlugin.store = new StoreSQLITE(Settings.DATABASE_SQLITE_NAME, Settings.DATABASE_TABLEPREFIX);
16                break;
17            }
18        }
19        final boolean conn = ToolsPlugin.store.connect();
20        if (conn) {
21            ToolsPlugin.store.update(true, "CREATE TABLE IF NOT EXISTS `{P}users` (" + ((ToolsPlugin.store.getStoreMode() == StoreMode.MYSQL) ? "`id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT," : "`id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,") + "`name` varchar(32) NOT NULL,  `uid` text NOT NULL, `firstIP` varchar(64) NOT NULL, `lastIP` varchar(64) NOT NULL, `kit_gracz` bigint(64) NOT NULL, `kit_vip` bigint(64) NOT NULL, `kit_svip` bigint(64) NOT NULL, `kit_sponsor` bigint(64) NOT NULL, `kit_frix` bigint(64) NOT NULL, `kit_tnt` bigint(64) NOT NULL, `kit_steak` bigint(64) NOT NULL, `kit_enderchest` bigint(64) NOT NULL, `kit_drewno` bigint(64) NOT NULL, home` varchar(255) NOT NULL);");
22            ToolsPlugin.store.update(true, "CREATE TABLE IF NOT EXISTS `{P}warp` (" + ((ToolsPlugin.store.getStoreMode() == StoreMode.MYSQL) ? "`id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT," : "`id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,") + "`name` varchar(32) NOT NULL,`location` text NOT NULL, `group` varchar(32) NOT NULL NOT NULL);");
23            return conn;
24        }
25        return conn;
26    }
27
28
29##uesrs##
30
31
32    public void setHome(final Location home) {
33        this.home = SethomeUtil.locToString(home);
34        ToolsPlugin.getStore().update(false, "UPDATE `{P}users` SET `home` ='" + this.getHome() + "' WHERE `name` ='" + this.getName() + "'");
35    }
36
37    private void insert() {
38        ToolsPlugin.getStore().update(false, "INSERT INTO `{P}users`(`id`, `name`, `uid`, `firstIP`, `lastIP`, `kit_gracz`, `kit_vip`, `kit_svip`, `kit_sponsor`, `kit_frix`, `kit_tnt`, `kit_steak`, `kit_enderchest`, `kit_drewno`, `home`) VALUES (NULL, '" + this.getName() + "','" + this.getUid() + "','" + this.getFirstIP() + "','" + this.getLastIP() + "','" + this.getKit_gracz() + "','" + this.getKit_vip() + "','" + this.getKit_svip() + "','" + this.getKit_sponsor() +  "','" + this.getKit_frix() + "','" + this.getKit_tnt() + "','" + "','" + this.getKit_steak() + "','" + this.getKit_enderchest() + "','" + this.getKit_drewno() + this.getHome() + "');");
39    }
40
41    public void save() {
42        ToolsPlugin.getStore().update(false, "UPDATE `{P}users` SET `uid` = '" + this.getUid() + "', `firstIP` = '" + this.getFirstIP() + "', `lastIP` = '" + this.getLastIP() + "', `kit_gracz` = '" + this.getKit_gracz() + "', `kit_vip` = '" + this.getKit_vip() + "', `kit_svip` = '" + this.getKit_svip() + "', `kit_sponsor` = '" + this.getKit_sponsor() + "', `kit_frix` = '" + this.getKit_frix() + "',  `kit_tnt` = '" + this.getKit_tnt() + "', `kit_steak` = '" + this.getKit_steak() + "', `kit_enderchest` = '" + this.getKit_enderchest() + "', `kit_drewno` = '" + this.getKit_drewno() + "', `home` = '" + this.getHome() + "' WHERE `name` ='" + this.getName() + "';");