· 5 years ago · Oct 20, 2020, 05:08 PM
1public plugin_cfg() {
2 g_SqlTuple = SQL_MakeDbTuple(sql_csatlakozas[0], sql_csatlakozas[1], sql_csatlakozas[2], sql_csatlakozas[3]);
3 MainTableCreate();
4 tabla_2();
5 tabla_3();
6 tabla_4();
7 tabla_5();
8 tabla_7();
9 tabla_8();
10 VipTable();
11}
12public MainTableCreate(){
13 new Len;
14 static Query[10048];
15
16 Len += formatex(Query[Len], charsmax(Query), "CREATE TABLE IF NOT EXISTS 'shedimod'");
17 Len += formatex(Query[Len], charsmax(Query)-Len, "( ");
18 Len += formatex(Query[Len], charsmax(Query)-Len, "`User_Id` INT(11) NOT NULL,");
19 Len += formatex(Query[Len], charsmax(Query)-Len, "`Dollars` float(32) NOT NULL,");
20 Len += formatex(Query[Len], charsmax(Query)-Len, "`fejloves` INT(11) NOT NULL,");
21 Len += formatex(Query[Len], charsmax(Query)-Len, "`Ajandek` INT(11) NOT NULL,");
22 Len += formatex(Query[Len], charsmax(Query)-Len, "`halal` INT(11) NOT NULL,");
23 Len += formatex(Query[Len], charsmax(Query)-Len, "`oles` INT(11) NOT NULL,");
24 Len += formatex(Query[Len], charsmax(Query)-Len, "`Jatszottido` INT(11) NOT NULL,");
25 Len += formatex(Query[Len], charsmax(Query)-Len, "`battlepass_szint` INT(11) NOT NULL,");
26 Len += formatex(Query[Len], charsmax(Query)-Len, "`premiumpont` INT(11) NOT NULL,");
27 Len += formatex(Query[Len], charsmax(Query)-Len, "`SzinesFomenu` INT(11) NOT NULL,");
28 Len += formatex(Query[Len], charsmax(Query)-Len, "`VipIdo` INT(11) NOT NULL,");
29 Len += formatex(Query[Len], charsmax(Query)-Len, "`Kulcs` INT(11) NOT NULL,");
30 Len += formatex(Query[Len], charsmax(Query)-Len, "`Nevcedula` INT(11) NOT NULL,");
31 Len += formatex(Query[Len], charsmax(Query)-Len, "`STTool` INT(11) NOT NULL,");
32 Len += formatex(Query[Len], charsmax(Query)-Len, "`KSzint` INT(11) NOT NULL,");
33 Len += formatex(Query[Len], charsmax(Query)-Len, "`Exp` float(32) NOT NULL,");
34
35 Len += formatex(Query[Len], charsmax(Query)-Len, "`moneydrop` INT(11) NOT NULL,");
36 Len += formatex(Query[Len], charsmax(Query)-Len, "`casedrop` INT(11) NOT NULL,");
37 Len += formatex(Query[Len], charsmax(Query)-Len, "`keydrop` INT(11) NOT NULL,");
38
39 Len += formatex(Query[Len], charsmax(Query)-Len, "`Elhasznalva1` INT(11) NOT NULL,");
40 Len += formatex(Query[Len], charsmax(Query)-Len, "`Elhasznalva2` INT(11) NOT NULL,");
41 Len += formatex(Query[Len], charsmax(Query)-Len, "`Elhasznalva3` INT(11) NOT NULL,");
42 Len += formatex(Query[Len], charsmax(Query)-Len, "`Elhasznalva4` INT(11) NOT NULL,");
43 Len += formatex(Query[Len], charsmax(Query)-Len, "`Elhasznalva5` INT(11) NOT NULL,");
44
45 Len += formatex(Query[Len], charsmax(Query)-Len, "`Id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,");
46
47 for(new i;i < LADASZAM; i++)
48 Len += formatex(Query[Len], charsmax(Query)-Len, "`Case%i` INT(11) NOT NULL,", i);
49
50 for(new i;i < 5; i++)
51 Len += formatex(Query[Len], charsmax(Query)-Len, "`Skin%i` INT(11) NOT NULL,", i);
52
53 Len += formatex(Query[Len], charsmax(Query)-Len, "`Admin_Szint` INT(1) NOT NULL)");
54
55 SQL_ThreadQuery(g_SqlTuple, "createMainTableThr", Query);
56}
57public CreateMainTableThr(FailState, Handle:Query, Error[], Errcode, Data[])
58{
59 if(FailState == TQUERY_CONNECT_FAILED)
60 set_fail_state("[HIBA] Nem lehet csatlakozni az adatbazishoz!");
61 else if(FailState == TQUERY_QUERY_FAILED)
62 set_fail_state("Query Error");
63 if(Errcode)
64 log_amx("[HIBA] Hiba: %s",Error);
65}
66public LoadMainTableData(id)
67{
68 new Data[1];
69 Data[0] = id;
70 static Query[10048];
71
72 formatex(Query, charsmax(Query), "SELECT * FROM `shedimod` WHERE User_Id = %i;", ska_get_user_id(id));
73 SQL_ThreadQuery(g_SqlTuple, "LoadMainTableDataThr", Query, Data, 1);
74 xBetoltesFolyamatban[id] = 0;
75 fegyvermenu(id);
76}
77public LoadMainTableDataThr(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime)
78{
79 if(FailState == TQUERY_CONNECT_FAILED)
80 set_fail_state("[*HIBA*] NEM LEHET KAPCSOLODNI AZ ADATBAZISHOZ!");
81 else if(FailState == TQUERY_QUERY_FAILED)
82 set_fail_state("[*HIBA*] A LEKERDEZES MEGSZAKADT!");
83 if(Errcode)
84 log_amx("[*HIBA*] PROBLEMA A LEKERDEZESNEL! ( %s )",Error);
85
86 new id = Data[0];
87
88 if(SQL_NumRows(Query) > 0)
89 {
90 SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Dollars"), g_dollar[id]);
91 hs[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "fejloves"));
92 Ajandekcsomag[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Ajandek"));
93 hl[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "halal"));
94 oles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "oles"));
95 masodpercek[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Jatszottido"));
96 battlepass_szint[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "battlepass_szint"));
97 premiumpont[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "premiumpont"));
98 szinesmenu[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "SzinesFomenu"));
99 g_VipTime[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "VipIdo"));
100 Kulcs[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Kulcs"));
101 g_Tools[1][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Nevcedula"));
102 g_Tools[0][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "STTool"));
103 Player[id][SSzint] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "KSzint"));
104 SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Exp"), Player[id][EXP]);
105
106 Player_Vip[id][v_moneydrop] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "moneydrop"));
107 Player_Vip[id][v_casedrop] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "casedrop"));
108 Player_Vip[id][v_keydrop] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "keydrop"));
109
110 Elhasznal[0][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Elhasznalva1"));
111 Elhasznal[1][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Elhasznalva2"));
112 Elhasznal[2][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Elhasznalva3"));
113 Elhasznal[3][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Elhasznalva4"));
114 Elhasznal[4][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Elhasznalva5"));
115
116 for(new i;i < LADASZAM; i++)
117 {
118 new String[64];
119 formatex(String, charsmax(String), "Case%d", i);
120 Lada[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String));
121 }
122 for(new i;i < LADASZAM; i++)
123 {
124 new String[64];
125 formatex(String, charsmax(String), "Keys%d", i);
126 LadaK[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String));
127 }
128
129 g_Admin_Level[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Admin_Szint"));
130 Set_Permissions(id);
131 }
132 else
133 {
134 InsertMainTable(id);
135 }
136}
137public InsertMainTable(id)
138{
139 new Len;
140 static Query[10048];
141 new Data[2];
142
143 Data[0] = id;
144 Data[1] = get_user_userid(id);
145
146 formatex(Query, charsmax(Query), "INSERT INTO `shedimod` (`User_Id`, `gamename`) VALUES (%d, ^"%s^");", ska_get_user_id(id), name[id]);
147 SQL_ThreadQuery(g_SqlTuple, "InsertMainTableThr", Query, Data, 2);
148}
149public InsertMainTableThr(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime)
150{
151 if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED ){
152 log_amx("%s", Error);
153 return;
154 }
155 else
156 {
157 new id = Data[0];
158
159 if(Data[1] != get_user_userid(id))
160 return;
161 }
162}
163public UpdateMainTable(id)
164{
165 static Query[10048];
166 new Len;
167
168 Len += formatex(Query[Len], charsmax(Query), "UPDATE `shedimod` SET ");
169 Len += formatex(Query[Len], charsmax(Query)-Len, "Dollars = ^"%.2f^", ", g_dollar[id]);
170 Len += formatex(Query[Len], charsmax(Query)-Len, "fejloves = ^"%i^", ", hs[id]);
171 Len += formatex(Query[Len], charsmax(Query)-Len, "Ajandek = ^"%i^", ", Ajandekcsomag[id]);
172 Len += formatex(Query[Len], charsmax(Query)-Len, "halal = ^"%i^", ", hl[id]);
173 Len += formatex(Query[Len], charsmax(Query)-Len, "oles = ^"%i^", ", oles[id]);
174 Len += formatex(Query[Len], charsmax(Query)-Len, "Jatszottido = ^"%i^", ", masodpercek[id]+get_user_time(id));
175 Len += formatex(Query[Len], charsmax(Query)-Len, "battlepass_szint = ^"%i^", ", battlepass_szint[id]);
176 Len += formatex(Query[Len], charsmax(Query)-Len, "premiumpont = ^"%i^", ", premiumpont[id])
177 Len += formatex(Query[Len], charsmax(Query)-Len, "SzinesFomenu = ^"%i^", ", szinesmenu[id]);
178 Len += formatex(Query[Len], charsmax(Query)-Len, "VipIdo = ^"%i^", ", g_VipTime[id]);
179 Len += formatex(Query[Len], charsmax(Query)-Len, "Kulcs = ^"%i^", ", Kulcs[id]);
180 Len += formatex(Query[Len], charsmax(Query)-Len, "Nevcedula = ^"%i^", ", g_Tools[1][id]);
181 Len += formatex(Query[Len], charsmax(Query)-Len, "STTool = ^"%i^", ", g_Tools[0][id]);
182 Len += formatex(Query[Len], charsmax(Query)-Len, "KSzint = '%i', ", Player[id][SSzint]);
183 Len += formatex(Query[Len], charsmax(Query)-Len, "Exp = ^"%.2f^", ", Player[id][EXP]);
184 Len += formatex(Query[Len], charsmax(Query)-Len, "moneydrop = ^"%i^", ", Player_Vip[id][v_moneydrop]);
185 Len += formatex(Query[Len], charsmax(Query)-Len, "casedrop = ^"%i^", ", Player_Vip[id][v_casedrop]);
186 Len += formatex(Query[Len], charsmax(Query)-Len, "keydrop = ^"%i^", ", Player_Vip[id][v_keydrop]);
187
188
189 Len += formatex(Query[Len], charsmax(Query)-Len, "Elhasznalva1 = ^"%i^", ", Elhasznal[0][id]);
190 Len += formatex(Query[Len], charsmax(Query)-Len, "Elhasznalva2 = ^"%i^", ", Elhasznal[1][id]);
191 Len += formatex(Query[Len], charsmax(Query)-Len, "Elhasznalva3 = ^"%i^", ", Elhasznal[2][id]);
192 Len += formatex(Query[Len], charsmax(Query)-Len, "Elhasznalva4 = ^"%i^", ", Elhasznal[3][id]);
193 Len += formatex(Query[Len], charsmax(Query)-Len, "Elhasznalva5 = ^"%i^", ", Elhasznal[4][id]);
194
195 for(new i;i < LADASZAM; i++)
196 Len += formatex(Query[Len], charsmax(Query)-Len, "Case%d = ^"%i^", ", i, Lada[i][id]);
197
198 for(new i;i < LADASZAM; i++)
199 Len += formatex(Query[Len], charsmax(Query)-Len, "Keys%d = ^"%i^", ", i, LadaK[i][id]);
200
201 Len += formatex(Query[Len], charsmax(Query)-Len, "Admin_Szint = ^"%i^" WHERE `User_Id` = %d;", g_Admin_Level[id], ska_get_user_id(id));
202
203 SQL_ThreadQuery(g_SqlTuple, "UpdateMainTableThr", Query);
204 Update_Skin(id);
205}
206public UpdateMainTableThr(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime)
207{
208 if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED)
209 {
210 log_amx("%s", Error);
211 return;
212 }
213}