· 8 years ago · Dec 03, 2017, 03:32 PM
1 }
2 public plugin_cfg()
3 {
4 g_SqlTuple = SQL_MakeDbTuple(SQLINFO[0], SQLINFO[1], SQLINFO[2], SQLINFO[3]);
5
6 static Query[10048];
7 new Len;
8
9 Len += formatex(Query[Len], charsmax(Query), "CREATE TABLE IF NOT EXISTS `derbyawp`");
10 Len += formatex(Query[Len], charsmax(Query)-Len, "(`Nev` varchar(32) NOT NULL, ");
11 Len += formatex(Query[Len], charsmax(Query)-Len, "`Felhasznalonev` varchar(32) NOT NULL,");
12 Len += formatex(Query[Len], charsmax(Query)-Len, "`Jelszo` varchar(32) NOT NULL,");
13 Len += formatex(Query[Len], charsmax(Query)-Len, "`Regisztralt` int(11) NOT NULL,");
14 Len += formatex(Query[Len], charsmax(Query)-Len, "`Masodpercek` int(11) NOT NULL,");
15 Len += formatex(Query[Len], charsmax(Query)-Len, "`Dollar` int(11) NOT NULL,");
16 Len += formatex(Query[Len], charsmax(Query)-Len, "`Szint` int(11) NOT NULL,");
17 Len += formatex(Query[Len], charsmax(Query)-Len, "`Oles` int(11) NOT NULL,");
18 Len += formatex(Query[Len], charsmax(Query)-Len, "`DropOles` int(11) NOT NULL,");
19
20 for(new i;i < MAX; i++)
21 Len += formatex(Query[Len], charsmax(Query)-Len, "`F%d` int(11) NOT NULL,", i);
22 for(new i;i < LADA; i++)
23 Len += formatex(Query[Len], charsmax(Query)-Len, "`L%d` int(11) NOT NULL,", i);
24 for(new i;i < 2; i++)
25 Len += formatex(Query[Len], charsmax(Query)-Len, "`S%d` int(11) NOT NULL,", i);
26
27 Len += formatex(Query[Len], charsmax(Query)-Len, "`Kulcs` int(11) NOT NULL, `id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY)");
28
29 SQL_ThreadQuery(g_SqlTuple, "createTableThread", Query);
30 }
31 public Load(id) {
32 static Query[10048];
33 new Data[1], Name[32];
34 get_user_name(id, Name, 31);
35 Data[0] = id;
36
37 formatex(Query, charsmax(Query), "SELECT * FROM `derbyawp` WHERE Nev = ^"%s^";", name[id]);
38 SQL_ThreadQuery(g_SqlTuple, "QuerySelectData", Query, Data, 1);
39 }
40 public QuerySelectData(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) {
41 if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED) {
42 log_amx("%s", Error);
43 return;
44 }
45 else {
46 new id = Data[0];
47
48 if(SQL_NumRows(Query) > 0) {
49 Rang[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Szint"));
50 Dollar[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Dollar"));
51 Oles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Oles"));
52 D_Oles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "DropOles"));
53 Masodpercek[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Masodpercek"));
54 SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Felhasznalonev"), regFh[id], charsmax(regFh[]));
55 SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Jelszo"), regJelszo[id], charsmax(regJelszo[]));
56 Regisztralt[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Regisztralt"));
57 gid[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "id"));
58
59 for(new i;i < MAX; i++)
60 {
61 new String[64];
62 formatex(String, charsmax(String), "F%d", i);
63 OsszesSkin[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String));
64 }
65 for(new i;i < LADA; i++)
66 {
67 new String[64];
68 formatex(String, charsmax(String), "L%d", i);
69 Lada[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String));
70 }
71 for(new i;i < 2; i++)
72 {
73 new String[64];
74 formatex(String, charsmax(String), "S%d", i);
75 Skin[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String));
76 }
77
78 Kulcs[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Kulcs"));
79 }
80 else
81 {
82 Save(id);
83 }
84 }
85 }
86 public Save(id)
87 {
88 static Query[256];
89
90 formatex(Query, charsmax(Query), "INSERT INTO `derbyawp` (`Nev`) VALUES (^"%s^");", name[id]);
91 SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query);
92 }
93 public SQL_Update_Reg(id)
94 {
95 static Query[10048];
96 new Len;
97
98 Len += formatex(Query[Len], charsmax(Query), "UPDATE `derbyawp` SET Felhasznalonev = ^"%s^", ", regFh[id]);
99 Len += formatex(Query[Len], charsmax(Query)-Len, "Jelszo = ^"%s^", ", regJelszo[id]);
100 Len += formatex(Query[Len], charsmax(Query)-Len, "Regisztralt = ^"%i^" WHERE Nev = ^"%s^";", Regisztralt[id], name[id]);
101
102 SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query);
103 }
104 public Update(id)
105 {
106 static Query[10048];
107 new Len;
108
109 Len += formatex(Query[Len], charsmax(Query), "UPDATE `derbyawp` SET Dollar = ^"%i^", ",Dollar[id]);
110 Len += formatex(Query[Len], charsmax(Query)-Len, "Szint = ^"%i^", ", Rang[id]);
111 Len += formatex(Query[Len], charsmax(Query)-Len, "Oles = ^"%i^", ", Oles[id]);
112 Len += formatex(Query[Len], charsmax(Query)-Len, "DropOles = ^"%i^", ", D_Oles[id]);
113 Len += formatex(Query[Len], charsmax(Query)-Len, "Masodpercek = ^"%i^", ", Masodpercek[id]+get_user_time(id));
114
115 for(new i=0;i < MAX; i++)
116 Len += formatex(Query[Len], charsmax(Query)-Len, "F%d = ^"%i^", ", i, OsszesSkin[i][id]);
117
118 for(new i;i < LADA; i++)
119 Len += formatex(Query[Len], charsmax(Query)-Len, "L%d = ^"%i^", ", i, Lada[i][id]);
120
121 for(new i;i < 2; i++)
122 Len += formatex(Query[Len], charsmax(Query)-Len, "S%d = ^"%i^", ", i, Skin[i][id]);
123
124 Len += formatex(Query[Len], charsmax(Query)-Len, "Kulcs = ^"%i^" WHERE Nev = ^"%s^";", Kulcs[id], name[id]);
125
126 SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query);
127 }
128 public createTableThread(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) {
129 if(FailState == TQUERY_CONNECT_FAILED)
130 set_fail_state("[HIBA*] NEM TUDTAM CSATLAKOZNI AZ ADATBAZISHOZ!");
131 else if(FailState == TQUERY_QUERY_FAILED)
132 set_fail_state("Query Error");
133 if(Errcode)
134 log_amx("[HIBA*] HIBAT DOBTAM: %s",Error);
135 }
136 public QuerySetData(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) {
137 if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED) {
138 log_amx("%s", Error);
139 return;
140 }
141 }
142 public plugin_end() {
143 SQL_FreeHandle(g_SqlTuple);
144 }