· 9 years ago · Jan 23, 2017, 07:00 PM
1mysql_tquery(SQL_HANDLE, !"SHOW TABLES LIKE 'factions'", !"OnFactionsTableExist", "");
2
3void OnFactionsTableExist()
4{
5 if(!cache_get_row_count(SQL_HANDLE))
6 {
7 mysql_tquery(SQL_HANDLE,
8 "CREATE TABLE IF NOT EXISTS `factions`(\
9 `ID` int(10) NOT NULL AUTO_INCREMENT, \
10 `FactionName` varchar(32) NOT NULL, \
11 `FColor` int(11) NOT NULL, \
12 `FRank1` varchar(12) NOT NULL, \
13 `FRank2` varchar(12) NOT NULL, \
14 `FRank3` varchar(12) NOT NULL, \
15 `FRank4` varchar(12) NOT NULL, \
16 `FRank5` varchar(12) NOT NULL, \
17 `FRank6` varchar(12) NOT NULL, \
18 `FRank7` varchar(12) NOT NULL, \
19 `FRank8` varchar(12) NOT NULL, \
20 `FRank9` varchar(12) NOT NULL, \
21 `FRank10` varchar(12) NOT NULL, \
22 PRIMARY KEY (`ID`))",
23 "", "");
24 return 1;
25}