-
Notifications
You must be signed in to change notification settings - Fork 1
/
fixCharStrings.php
125 lines (95 loc) · 3.17 KB
/
fixCharStrings.php
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
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
<?php
if (php_sapi_name() != "cli") die("Can only be run from command line!");
print("Fixing character strings in build data...\n");
require("/home/uesp/secrets/esobuilddata.secrets");
$db = new mysqli($uespEsoBuildDataWriteDBHost, $uespEsoBuildDataWriteUser, $uespEsoBuildDataWritePW, $uespEsoBuildDataDatabase);
if ($db->connect_error) exit("Could not connect to mysql database!");
$query = "SELECT * FROM characters;";
$result = $db->query($query);
if (!$result) exit("Error loading character data!");
while (($row = $result->fetch_assoc()))
{
$id = $row['id'];
$class = $row['class'];
$race = $row['race'];
$alliance = $row['alliance'];
$newClass = preg_replace("#\^.*#", "", $class);
$newRace = preg_replace("#\^.*#", "", $race);
$newAlliance = preg_replace("#\^.*#", "", $alliance);
//print("$class -- $newClass\n");
$query = "UPDATE characters SET class='$newClass', race='$newRace', alliance='$newAlliance' WHERE id=$id;";
$db->query($query);
}
$query = "SELECT * FROM championPoints;";
$result = $db->query($query);
if (!$result) exit("Error loading CP data!");
while (($row = $result->fetch_assoc()))
{
$id = $row['id'];
$name = $row['name'];
$newName = preg_replace("#\^[a-zA-Z]*#", "", $name);
$query = "UPDATE championPoints SET name='$newName' WHERE id=$id;";
$db->query($query);
}
$query = "SELECT * FROM buffs;";
$result = $db->query($query);
if (!$result) exit("Error loading buff data!");
while (($row = $result->fetch_assoc()))
{
$id = $row['id'];
$name = $row['name'];
$newName = preg_replace("#\^[a-zA-Z]*#", "", $name);
$query = "UPDATE buffs SET name='$newName' WHERE id=$id;";
$db->query($query);
}
$query = "SELECT * FROM skills;";
$result = $db->query($query);
if (!$result) exit("Error loading skill data!");
while (($row = $result->fetch_assoc()))
{
$id = $row['id'];
$name = $row['name'];
$newName = preg_replace("#\^[a-zA-Z]*#", "", $name);
$query = "UPDATE skills SET name='$newName' WHERE id=$id;";
$db->query($query);
}
$query = "SELECT * FROM stats;";
$result = $db->query($query);
if (!$result) exit("Error loading stat data!");
while (($row = $result->fetch_assoc()))
{
$id = $row['id'];
$name = $row['name'];
$newName = preg_replace("#\^[a-zA-Z]*#", "", $name);
$query = "UPDATE stats SET name='$newName' WHERE id=$id;";
$db->query($query);
}
$query = "SELECT * FROM actionBars;";
$result = $db->query($query);
if (!$result) exit("Error loading action bar data!");
while (($row = $result->fetch_assoc()))
{
$id = $row['id'];
$name = $row['name'];
$newName = preg_replace("#\^[a-zA-Z]*#", "", $name);
$query = "UPDATE actionBars SET name='$newName' WHERE id=$id;";
$db->query($query);
}
$query = "SELECT * FROM equipSlots;";
$result = $db->query($query);
if (!$result) exit("Error loading equip slot data!");
while (($row = $result->fetch_assoc()))
{
$id = $row['id'];
$name = $row['name'];
$newName = preg_replace("#\^[a-zA-Z]*#", "", $name);
$query = "UPDATE equipSlots SET name='$newName' WHERE id=$id;";
$db->query($query);
}
//actionBars
//buffs
//championPoints
//equipSlots
//screenshots
//skills
//stats