r2yfwjrk

1		} else if (StorageManager.useMySQL) {
2			String checkEntry = "SELECT bending FROM bending_language WHERE player ='"
3					+ player.getName() + "'";
4			ResultSet rs = this.MySql.select(checkEntry);
5			try {
6				if (rs.next()) {
7					String updateEntry = "UPDATE bending_language SET language = "
8							+ language
9							+ " WHERE player ='"
10							+ player.getName()
11							+ "'";
12					this.MySql.update(updateEntry);
13				} else {
14					String insertEntry = "INSERT INTO bending_language VALUES('"
15							+ player.getName() + "','" + language + "')";
16					this.MySql.insert(insertEntry);
17				}
18			} catch (SQLException e) {
19				// TODO Auto-generated catch block
20				e.printStackTrace();
21			}
22		}
23
24
25
26[...]
27	public void initialize(File file) {
28		StorageManager.useMySQL = ConfigManager.useMySQL;
29		StorageManager.useFlatFile = !ConfigManager.useMySQL;
30		if (StorageManager.useMySQL) {
31			this.MySql = new MySQL(ConfigManager.dbHost, ConfigManager.dbUser,
32					ConfigManager.dbPass, ConfigManager.dbDB,
33					ConfigManager.dbPort);
34			if (this.MySql.initialize()) {
35				String createTable1 = "CREATE TABLE IF NOT EXISTS bending_element(player TEXT NOT NULL, bending TEXT NOT NULL)";
36				String createTable2 = "CREATE TABLE IF NOT EXISTS bending_ability(player TEXT NOT NULL, setter TEXT NOT NULL, ability TEXT NOT NULL)";
37                                String createTable3 = "CREATE TABLE IF NOT EXISTS bending_language(player TEXT NOT NULL, language TEXT NOT NULL)";
38				MySql.execute(createTable1);
39				MySql.execute(createTable2);
40				MySql.execute(createTable3);
41			} else {
42				this.MySql = null;
43				this.config = new BendingPlayers(file);
44				StorageManager.useMySQL = false;
45				StorageManager.useFlatFile = true;
46			}
47		} else if (StorageManager.useFlatFile) {
48			this.config = new BendingPlayers(file);
49		}
50		// Tools.verbose(StorageManager.useFlatFile ? "Flat" : "MySQL");
51	}