Lines Matching refs:prefix
20 this->sql->RunQuery("TRUNCATE TABLE " + prefix + "user"); in CheckTables()
21 this->sql->RunQuery("TRUNCATE TABLE " + prefix + "chan"); in CheckTables()
22 this->sql->RunQuery("TRUNCATE TABLE " + prefix + "ison"); in CheckTables()
23 this->sql->RunQuery("UPDATE `" + prefix + "server` SET currentusers=0, online='N'"); in CheckTables()
28 if (GeoIPDB.equals_ci("country") && !this->HasTable(prefix + "geoip_country")) in CheckTables()
30 query = "CREATE TABLE `" + prefix + "geoip_country` (" in CheckTables()
40 if (GeoIPDB.equals_ci("city") && !this->HasTable(prefix + "geoip_city_blocks")) in CheckTables()
42 query = "CREATE TABLE `" + prefix + "geoip_city_blocks` (" in CheckTables()
52 if (GeoIPDB.equals_ci("city") && !this->HasTable(prefix + "geoip_city_location")) in CheckTables()
54 query = "CREATE TABLE `" + prefix + "geoip_city_location` (" in CheckTables()
66 if (GeoIPDB.equals_ci("city") && !this->HasTable(prefix + "geoip_city_region")) in CheckTables()
67 { query = "CREATE TABLE `" + prefix + "geoip_city_region` (" in CheckTables()
75 if (!this->HasTable(prefix + "server")) in CheckTables()
77 query = "CREATE TABLE `" + prefix + "server` (" in CheckTables()
93 if (!this->HasTable(prefix + "chan")) in CheckTables()
95 query = "CREATE TABLE `" + prefix + "chan` (" in CheckTables()
107 if (!this->HasTable(prefix + "user")) in CheckTables()
109 query = "CREATE TABLE `" + prefix + "user` (" in CheckTables()
142 if (!this->HasTable(prefix + "ison")) in CheckTables()
144 query = "CREATE TABLE `" + prefix + "ison` (" in CheckTables()
153 if (!this->HasTable(prefix + "maxusers")) in CheckTables()
155 query = "CREATE TABLE `" + prefix + "maxusers` (" in CheckTables()
164 if (this->HasProcedure(prefix + "UserConnect")) in CheckTables()
165 this->RunQuery(SQL::Query("DROP PROCEDURE " + prefix + "UserConnect")); in CheckTables()
168 geoquery = "UPDATE `" + prefix + "user` AS u " in CheckTables()
170 "FROM `" + prefix + "geoip_country` " in CheckTables()
177 geoquery = "UPDATE `" + prefix + "user` as u " in CheckTables()
178 "JOIN ( SELECT * FROM `" + prefix + "geoip_city_location` " in CheckTables()
180 "FROM `" + prefix + "geoip_city_blocks` " in CheckTables()
189 "FROM `" + prefix + "geoip_city_region` " in CheckTables()
194 query = "CREATE PROCEDURE `" + prefix + "UserConnect`" in CheckTables()
204 "INSERT INTO `" + prefix + "user` " in CheckTables()
216 "UPDATE `" + prefix + "user` as `u`, `" + prefix + "server` as `s`" in CheckTables()
220 "SELECT `currentusers` INTO cur FROM `" + prefix + "server` WHERE name=server_;" in CheckTables()
221 "SELECT `maxusers` INTO max FROM `" + prefix + "maxusers` WHERE name=server_;" in CheckTables()
223 "UPDATE `" + prefix + "maxusers` SET lastused=now() WHERE name=server_;" in CheckTables()
225 "INSERT INTO `" + prefix + "maxusers` (name, maxusers, maxtime, lastused) " in CheckTables()
235 if (this->HasProcedure(prefix + "ServerQuit")) in CheckTables()
236 this->RunQuery(SQL::Query("DROP PROCEDURE " + prefix + "ServerQuit")); in CheckTables()
237 query = "CREATE PROCEDURE " + prefix + "ServerQuit(sname_ varchar(255)) " in CheckTables()
242 "DELETE i FROM `" + prefix + "ison` AS i " in CheckTables()
243 "INNER JOIN `" + prefix + "server` AS s " in CheckTables()
244 "INNER JOIN `" + prefix + "user` AS u " in CheckTables()
252 "DELETE u FROM `" + prefix + "user` AS u " in CheckTables()
253 "INNER JOIN `" + prefix + "server` AS s " in CheckTables()
260 "UPDATE `" + prefix + "server` SET currentusers = 0, split_time = now(), online = 'N' " in CheckTables()
266 if (this->HasProcedure(prefix + "UserQuit")) in CheckTables()
267 this->RunQuery(SQL::Query("DROP PROCEDURE " + prefix + "UserQuit")); in CheckTables()
268 query = "CREATE PROCEDURE `" + prefix + "UserQuit`" in CheckTables()
272 "UPDATE `" + prefix + "user` AS `u`, `" + prefix + "server` AS `s` " in CheckTables()
276 "DELETE i FROM `" + prefix + "ison` AS i " in CheckTables()
277 "INNER JOIN `" + prefix + "user` as u " in CheckTables()
281 "DELETE FROM `" + prefix + "user` WHERE nick = nick_; " in CheckTables()
285 if (this->HasProcedure(prefix + "ShutDown")) in CheckTables()
286 this->RunQuery(SQL::Query("DROP PROCEDURE " + prefix + "ShutDown")); in CheckTables()
287 query = "CREATE PROCEDURE `" + prefix + "ShutDown`()" in CheckTables()
289 "UPDATE `" + prefix + "server` " in CheckTables()
291 "TRUNCATE TABLE `" + prefix + "user`;" in CheckTables()
292 "TRUNCATE TABLE `" + prefix + "chan`;" in CheckTables()
293 "TRUNCATE TABLE `" + prefix + "ison`;" in CheckTables()
297 if (this->HasProcedure(prefix + "JoinUser")) in CheckTables()
298 this->RunQuery(SQL::Query("DROP PROCEDURE " + prefix + "JoinUser")); in CheckTables()
299 query = "CREATE PROCEDURE `"+ prefix + "JoinUser`" in CheckTables()
304 "INSERT INTO `" + prefix + "ison` (nickid, chanid, modes) " in CheckTables()
306 "FROM " + prefix + "user AS u, " + prefix + "chan AS c " in CheckTables()
309 "FROM `" + prefix + "chan` AS c, " + prefix + "ison AS i " in CheckTables()
311 "SELECT `maxusers` INTO max FROM `" + prefix + "maxusers` WHERE name=channel_;" in CheckTables()
313 "UPDATE `" + prefix + "maxusers` SET lastused=now() WHERE name=channel_;" in CheckTables()
315 "INSERT INTO `" + prefix + "maxusers` (name, maxusers, maxtime, lastused) " in CheckTables()
324 if (this->HasProcedure(prefix + "PartUser")) in CheckTables()
325 this->RunQuery(SQL::Query("DROP PROCEDURE " + prefix + "PartUser")); in CheckTables()
326 query = "CREATE PROCEDURE `" + prefix + "PartUser`" in CheckTables()
329 "DELETE i FROM `" + prefix + "ison` AS i " in CheckTables()
330 "INNER JOIN `" + prefix + "user` AS u " in CheckTables()
331 "INNER JOIN `" + prefix + "chan` AS c " in CheckTables()