· 5 years ago · Oct 19, 2020, 09:00 PM
1
2new const Tablename[][] = {"Tabla_Fotabla", "Tabla_Fegyverek", "Tabla_Fegyvernevek", "Tabla_Stattrakolesek", "Tabla_Stattrak", "Tabla_Tester", "Tabla_Kuldetesek", "Tabla_Skintipus" };
3
4public plugin_cfg() {
5 g_SqlTuple = SQL_MakeDbTuple(sql_csatlakozas[0], sql_csatlakozas[1], sql_csatlakozas[2], sql_csatlakozas[3]);
6 tabla_1();
7 tabla_2();
8 tabla_3();
9 tabla_4();
10 tabla_5();
11 tabla_7();
12 tabla_8();
13 VipTable()
14}
15
16public tabla_1(){
17 new Len;
18 static Query[10048];
19
20 Len += formatex(Query[Len], charsmax(Query), "CREATE TABLE IF NOT EXISTS %s ", Tablename[0]);
21 Len += formatex(Query[Len], charsmax(Query)-Len, "( ");
22
23 Len += formatex(Query[Len], charsmax(Query)-Len, "`User_Id` INT(11) NOT NULL,");
24 Len += formatex(Query[Len], charsmax(Query)-Len, "`Dollars` float(32) NOT NULL,");
25 Len += formatex(Query[Len], charsmax(Query)-Len, "`fejloves` INT(11) NOT NULL,");
26 Len += formatex(Query[Len], charsmax(Query)-Len, "`Ajandek` INT(11) NOT NULL,");
27 Len += formatex(Query[Len], charsmax(Query)-Len, "`halal` INT(11) NOT NULL,");
28 Len += formatex(Query[Len], charsmax(Query)-Len, "`oles` INT(11) NOT NULL,");
29 Len += formatex(Query[Len], charsmax(Query)-Len, "`Jatszottido` INT(11) NOT NULL,");
30 Len += formatex(Query[Len], charsmax(Query)-Len, "`battlepass_szint` INT(11) NOT NULL,");
31 Len += formatex(Query[Len], charsmax(Query)-Len, "`premiumpont` INT(11) NOT NULL,");
32 Len += formatex(Query[Len], charsmax(Query)-Len, "`SzinesFomenu` INT(11) NOT NULL,");
33 Len += formatex(Query[Len], charsmax(Query)-Len, "`VipIdo` INT(11) NOT NULL,");
34 Len += formatex(Query[Len], charsmax(Query)-Len, "`Kulcs` INT(11) NOT NULL,");
35 Len += formatex(Query[Len], charsmax(Query)-Len, "`Nevcedula` INT(11) NOT NULL,");
36 Len += formatex(Query[Len], charsmax(Query)-Len, "`STTool` INT(11) NOT NULL,");
37 Len += formatex(Query[Len], charsmax(Query)-Len, "`Admin_Szint` INT(1) NOT NULL,");
38 Len += formatex(Query[Len], charsmax(Query)-Len, "`KSzint` INT(11) NOT NULL,");
39 Len += formatex(Query[Len], charsmax(Query)-Len, "`Exp` float(32) NOT NULL,");
40 Len += formatex(Query[Len], charsmax(Query)-Len, "`moneydrop` INT(11) NOT NULL,");
41 Len += formatex(Query[Len], charsmax(Query)-Len, "`casedrop` INT(11) NOT NULL,");
42 Len += formatex(Query[Len], charsmax(Query)-Len, "`keydrop` INT(11) NOT NULL,");
43 Len += formatex(Query[Len], charsmax(Query)-Len, "`Admin_Szint` INT(1) NOT NULL)");
44
45 for(new i;i < LADASZAM; i++)
46 Len += formatex(Query[Len], charsmax(Query)-Len, "`Case%i` INT(11) NOT NULL,", i);
47
48 for(new i;i < LADASZAM; i++)
49 Len += formatex(Query[Len], charsmax(Query)-Len, "`Keys%i` INT(11) NOT NULL,", i);
50
51
52 Len += formatex(Query[Len], charsmax(Query)-Len, "`Id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,");
53
54 SQL_ThreadQuery(g_SqlTuple, "createTableThread", Query);
55}
56public tabla_2(){
57 new Len;
58 static Query[10048];
59
60 Len += formatex(Query[Len], charsmax(Query), "CREATE TABLE IF NOT EXISTS %s ", Tablename[1]);
61 Len += formatex(Query[Len], charsmax(Query)-Len, "( ");
62 Len += formatex(Query[Len], charsmax(Query)-Len, "`Id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,");
63
64 for(new i;i < 200; i++)
65 Len += formatex(Query[Len], charsmax(Query)-Len, "`F_%i` INT(11) NOT NULL,", i);
66
67 Len += formatex(Query[Len], charsmax(Query)-Len, "`Parameter` INT(11) NOT NULL,");
68 Len += formatex(Query[Len], charsmax(Query)-Len, "`User_Id` INT(11) NOT NULL DEFAULT 0)");
69
70 SQL_ThreadQuery(g_SqlTuple, "createTableThread", Query);
71}
72public createTableThread(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) {
73 if(FailState == TQUERY_CONNECT_FAILED)
74 set_fail_state("[HIBA*] NEM TUDTAM CSATLAKOZNI AZ ADATBAZISHOZ!");
75 else if(FailState == TQUERY_QUERY_FAILED)
76 set_fail_state("Query Error");
77 if(Errcode)
78 log_amx("[HIBA*] HIBAT DOBTAM: %s",Error);
79}
80public tabla_3(){
81 new Len;
82 static Query[10048];
83
84 Len += formatex(Query[Len], charsmax(Query), "CREATE TABLE IF NOT EXISTS %s ", Tablename[2]);
85 Len += formatex(Query[Len], charsmax(Query)-Len, "( ");
86 Len += formatex(Query[Len], charsmax(Query)-Len, "`Id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,");
87
88 for(new i;i < 200; i++)
89 Len += formatex(Query[Len], charsmax(Query)-Len, "`fegyvernev_%i` VARCHAR(32) NOT NULL,", i);
90
91 Len += formatex(Query[Len], charsmax(Query)-Len, "`Parameter` INT(11) NOT NULL DEFAULT 0,");
92 Len += formatex(Query[Len], charsmax(Query)-Len, "`User_Id` INT(11) NOT NULL DEFAULT 0)");
93
94 SQL_ThreadQuery(g_SqlTuple, "createTableThread2", Query);
95}
96public createTableThread2(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) {
97 if(FailState == TQUERY_CONNECT_FAILED)
98 set_fail_state("[HIBA*] NEM TUDTAM CSATLAKOZNI AZ ADATBAZISHOZ!");
99 else if(FailState == TQUERY_QUERY_FAILED)
100 set_fail_state("Query Error");
101 if(Errcode)
102 log_amx("[HIBA*] HIBAT DOBTAM: %s",Error);
103}
104public tabla_4(){
105 new Len;
106 static Query[10048];
107
108 Len += formatex(Query[Len], charsmax(Query), "CREATE TABLE IF NOT EXISTS %s ", Tablename[3]);
109 Len += formatex(Query[Len], charsmax(Query)-Len, "( ");
110 Len += formatex(Query[Len], charsmax(Query)-Len, "`Id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,");
111
112 for(new i;i < 200; i++)
113 Len += formatex(Query[Len], charsmax(Query)-Len, "`stkill_%i` INT(11) NOT NULL,", i);
114
115 Len += formatex(Query[Len], charsmax(Query)-Len, "`Parameter` INT(11) NOT NULL DEFAULT 0,");
116 Len += formatex(Query[Len], charsmax(Query)-Len, "`User_Id` INT(11) NOT NULL DEFAULT 0)");
117
118 SQL_ThreadQuery(g_SqlTuple, "createTableThread", Query);
119}
120public tabla_5(){
121 new Len;
122 static Query[10048];
123
124 Len += formatex(Query[Len], charsmax(Query), "CREATE TABLE IF NOT EXISTS %s ", Tablename[4]);
125 Len += formatex(Query[Len], charsmax(Query)-Len, "( ");
126 Len += formatex(Query[Len], charsmax(Query)-Len, "`Id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,");
127
128 for(new i;i < 200; i++)
129 Len += formatex(Query[Len], charsmax(Query)-Len, "`st_%i` INT(11) NOT NULL,", i);
130
131 Len += formatex(Query[Len], charsmax(Query)-Len, "`Parameter` INT(11) NOT NULL DEFAULT 0,");
132 Len += formatex(Query[Len], charsmax(Query)-Len, "`User_Id` INT(11) NOT NULL DEFAULT 0)");
133
134 SQL_ThreadQuery(g_SqlTuple, "createTableThread", Query);
135}
136public tabla_6(){
137 new Len;
138 static Query[10048];
139
140 Len += formatex(Query[Len], charsmax(Query), "CREATE TABLE IF NOT EXISTS %s ", Tablename[5]);
141 Len += formatex(Query[Len], charsmax(Query)-Len, "( ");
142 Len += formatex(Query[Len], charsmax(Query)-Len, "`Id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,");
143 Len += formatex(Query[Len], charsmax(Query)-Len, "`Name` VARCHAR(32) NOT NULL,");
144 Len += formatex(Query[Len], charsmax(Query)-Len, "`Parameter` INT(11) NOT NULL,");
145 Len += formatex(Query[Len], charsmax(Query)-Len, "`User_Id` INT(11) NOT NULL DEFAULT 0)");
146
147 SQL_ThreadQuery(g_SqlTuple, "createTableThread", Query);
148}
149public tabla_7(){
150 new Len;
151 static Query[10048];
152
153 Len += formatex(Query[Len], charsmax(Query), "CREATE TABLE IF NOT EXISTS %s ", Tablename[6]);
154 Len += formatex(Query[Len], charsmax(Query)-Len, "( ");
155 Len += formatex(Query[Len], charsmax(Query)-Len, "`Id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,");
156 Len += formatex(Query[Len], charsmax(Query)-Len, "`QuestH1` int(11) NOT NULL,");
157 Len += formatex(Query[Len], charsmax(Query)-Len, "`QuestMVP1` int(11) NOT NULL,");
158 Len += formatex(Query[Len], charsmax(Query)-Len, "`QuestNeed1` int(11) NOT NULL,");
159 Len += formatex(Query[Len], charsmax(Query)-Len, "`QuestHave1` int(11) NOT NULL,");
160 Len += formatex(Query[Len], charsmax(Query)-Len, "`QuestWeap1` int(11) NOT NULL,");
161 Len += formatex(Query[Len], charsmax(Query)-Len, "`QuestHead1` int(11) NOT NULL,");
162 Len += formatex(Query[Len], charsmax(Query)-Len, "`JutLada1` int(11) NOT NULL,");
163 Len += formatex(Query[Len], charsmax(Query)-Len, "`JutKulcs1` int(11) NOT NULL,");
164 Len += formatex(Query[Len], charsmax(Query)-Len, "`JutPont1` int(11) NOT NULL,");
165 Len += formatex(Query[Len], charsmax(Query)-Len, "`JutST` int(11) NOT NULL,");
166 Len += formatex(Query[Len], charsmax(Query)-Len, "`JutNC` int(11) NOT NULL,");
167 Len += formatex(Query[Len], charsmax(Query)-Len, "`JutDoll1` float(32) NOT NULL,");
168 Len += formatex(Query[Len], charsmax(Query)-Len, "`Parameter` INT(11) NOT NULL,");
169 Len += formatex(Query[Len], charsmax(Query)-Len, "`User_Id` INT(11) NOT NULL DEFAULT 0)");
170
171 SQL_ThreadQuery(g_SqlTuple, "createTableThread", Query);
172}
173public tabla_8(){
174 new Len;
175 static Query[10048];
176
177 Len += formatex(Query[Len], charsmax(Query), "CREATE TABLE IF NOT EXISTS %s ", Tablename[7]);
178 Len += formatex(Query[Len], charsmax(Query)-Len, "( ");
179 Len += formatex(Query[Len], charsmax(Query)-Len, "`User_Id` INT(11) NOT NULL,");
180
181 for(new i;i < 5; i++)
182 Len += formatex(Query[Len], charsmax(Query)-Len, "`Skin%i` INT(11) NOT NULL,", i);
183
184 Len += formatex(Query[Len], charsmax(Query)-Len, "`Id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY)");
185
186 SQL_ThreadQuery(g_SqlTuple, "createTableThread", Query);
187}