· 9 years ago · Dec 26, 2016, 04:52 PM
1public plugin_cfg()
2{
3 g_SqlTuple = SQL_MakeDbTuple(SQLINFO[0], SQLINFO[1], SQLINFO[2], SQLINFO[3]);
4
5 static Query[10048];
6 new Len;
7
8 Len += formatex(Query[Len], charsmax(Query), "CREATE TABLE IF NOT EXISTS `teszt`");
9 Len += formatex(Query[Len], charsmax(Query)-Len, "(`Nev` varchar(32) NOT NULL, ");
10 Len += formatex(Query[Len], charsmax(Query)-Len, "`Felhasznalonev` varchar(32) NOT NULL,");
11 Len += formatex(Query[Len], charsmax(Query)-Len, "`Jelszo` varchar(32) NOT NULL,");
12 Len += formatex(Query[Len], charsmax(Query)-Len, "`Masodpercek` int(11) NOT NULL,");
13 Len += formatex(Query[Len], charsmax(Query)-Len, "`AutoB` int(11) NOT NULL,");
14 Len += formatex(Query[Len], charsmax(Query)-Len, "`Dollars` int(11) NOT NULL,");
15 Len += formatex(Query[Len], charsmax(Query)-Len, "`Szint` int(11) NOT NULL,");
16 Len += formatex(Query[Len], charsmax(Query)-Len, "`Oles` int(11) NOT NULL,");
17 Len += formatex(Query[Len], charsmax(Query)-Len, "`Regisztralt` int(11) NOT NULL,");
18 Len += formatex(Query[Len], charsmax(Query)-Len, "`Erteke` int(11) NOT NULL,");
19 Len += formatex(Query[Len], charsmax(Query)-Len, "`Kicucc` int(11) NOT NULL,");
20 Len += formatex(Query[Len], charsmax(Query)-Len, "`Kirakva` int(11) NOT NULL,");
21
22 for(new i;i < FEGYO; i++)
23 Len += formatex(Query[Len], charsmax(Query)-Len, "`F%d` int(11) NOT NULL,", i);
24
25 for(new i;i < LADA; i++)
26 Len += formatex(Query[Len], charsmax(Query)-Len, "`L%d` int(11) NOT NULL,", i);
27
28 for(new i;i < STK; i++)
29 Len += formatex(Query[Len], charsmax(Query)-Len, "`St%d` int(11) NOT NULL,", i);
30
31 for(new i;i < 14; i++)
32 Len += formatex(Query[Len], charsmax(Query)-Len, "`Skin%d` int(11) NOT NULL,", i);
33
34 Len += formatex(Query[Len], charsmax(Query)-Len, "`Kulcs` int(11) NOT NULL,");
35
36 Len += formatex(Query[Len], charsmax(Query)-Len, "`SMS` int(11) NOT NULL, `id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY)");
37
38 SQL_ThreadQuery(g_SqlTuple, "createTableThread", Query);
39}