1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
|
/*
* This file is part of Kenshins Hide and Seek
*
* Copyright (c) 2022 Tyler Murphy.
*
* Kenshins Hide and Seek free software: you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* he Free Software Foundation version 3.
*
* Kenshins Hide and Seek is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*
*/
package cat.freya.khs.database;
import cat.freya.khs.database.util.LegacyPlayerInfo;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
public class LegacyTable {
private final Database database;
private final boolean exists;
protected LegacyTable(Database database) {
String sql = "SELECT * FROM player_info LIMIT 1;";
boolean check;
try(Connection connection = database.connect(); Statement statement = connection.createStatement()) {
ResultSet resultSet = statement.executeQuery(sql);
check = resultSet.next();
} catch (SQLException e) {
check = false;
}
this.exists = check;
this.database = database;
}
public boolean exists(){
return exists;
}
public boolean copyData(){
String sql = "SELECT * FROM player_info;";
List<LegacyPlayerInfo> legacyPlayerInfoList = new ArrayList<>();
try(Connection connection = database.connect(); Statement statement = connection.createStatement()) {
ResultSet resultSet = statement.executeQuery(sql);
while(resultSet.next()){
legacyPlayerInfoList.add(new LegacyPlayerInfo(
resultSet.getBytes("uuid"),
resultSet.getInt("hider_wins"),
resultSet.getInt("seeker_wins"),
resultSet.getInt("games_played")
));
}
resultSet.close();
} catch (SQLException e) {
e.printStackTrace();
return false;
}
for(LegacyPlayerInfo legacyInfo : legacyPlayerInfoList){
database.getGameData().updateInfo(
legacyInfo.getUniqueId(),
legacyInfo.getHiderWins(),
legacyInfo.getSeekerWins(),
legacyInfo.getGamesPlayer() - legacyInfo.getSeekerWins(),
legacyInfo.getSeekerWins(),
0,
0,
0,
0
);
}
return true;
}
public boolean drop(){
String sql = "DROP table player_info";
try(Connection connection = database.connect(); Statement statement = connection.createStatement()) {
statement.execute(sql);
return true;
} catch (SQLException e) {
e.printStackTrace();
return false;
}
}
}
|
