· 5 years ago · Nov 22, 2020, 03:54 PM
1public plugin_cfg()
2{
3 g_iSqlTuple = SQL_MakeDbTuple(g_iSqlInfo[0], g_iSqlInfo[1], g_iSqlInfo[2], g_iSqlInfo[3]);
4
5 new iLen;
6 static Lekerdezes[10048];
7
8 iLen += formatex(Lekerdezes[iLen], charsmax(Lekerdezes), "CREATE TABLE IF NOT EXISTS `teszt`");
9 iLen += formatex(Lekerdezes[iLen], charsmax(Lekerdezes) - iLen, "(`JatekosNev` varchar(32) NOT NULL, ");
10 iLen += formatex(Lekerdezes[iLen], charsmax(Lekerdezes) - iLen, "`Ezust` int(11) NOT NULL,");
11 iLen += formatex(Lekerdezes[iLen], charsmax(Lekerdezes) - iLen, "`Tapasztalat` int(11) NOT NULL,");
12 iLen += formatex(Lekerdezes[iLen], charsmax(Lekerdezes) - iLen, "`Oles` int(11) NOT NULL,");
13 iLen += formatex(Lekerdezes[iLen], charsmax(Lekerdezes) - iLen, "`Fejloves` int(11) NOT NULL,");
14 iLen += formatex(Lekerdezes[iLen], charsmax(Lekerdezes) - iLen, "`Halal` int(11) NOT NULL,");
15
16 for(new i = 0; i < KinezetSzam; i++)
17 iLen += formatex(Lekerdezes[iLen], charsmax(Lekerdezes) - iLen, "`F_%d` int(11) NOT NULL,", i);
18
19 for(new i = 0; i < 2; i ++)
20 iLen += formatex(Lekerdezes[iLen], charsmax(Lekerdezes) - iLen, "`Skin%d` int(11) NOT NULL,", i);
21
22 iLen += formatex(Lekerdezes[iLen], charsmax(Lekerdezes) - iLen, "`Szint` int(11) NOT NULL, `Id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY)");
23
24 SQL_ThreadQuery(g_iSqlTuple, "createTableThread", Lekerdezes);
25}
26public createTableThread(FailState, Handle: Lekerdezes, Error[], Errcode, Data[], DataSize, Float: Queuetime)
27{
28 if(FailState == TQUERY_CONNECT_FAILED)
29 set_fail_state("Nem tudtam Csatlakozni a(z) Adatbazishoz!");
30 else
31 if(FailState == TQUERY_QUERY_FAILED)
32 set_fail_state("Lekerdezesi Hiba!");
33 if(Errcode)
34 log_amx("Hiba Uzenet: %s", Error);
35}
36public Betoltes(iId)
37{
38 new Data[1];
39 static Lekerdezes[10048];
40 Data[0] = iId;
41
42 formatex(Lekerdezes, charsmax(Lekerdezes), "SELECT * FROM `teszt` WHERE JatekosNev = ^"%s^";", g_iJatekosNev[iId]);
43
44 SQL_ThreadQuery(g_iSqlTuple, "QuerySelectData", Lekerdezes, Data, 1);
45}
46public QuerySelectData(FailState, Handle: Lekerdezes, Error[], Errcode, Data[], DataSize, Float: Queuetime)
47{
48 if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED)
49 {
50 log_amx("%s", Error);
51 return;
52 }
53 else
54 {
55 new iId = Data[0];
56
57 if(SQL_NumRows(Lekerdezes) > 0)
58 {
59 g_iEzust[iId] = SQL_ReadResult(Lekerdezes, SQL_FieldNameToNum(Lekerdezes, "Ezust"));
60 g_iTapasztalat[iId] = SQL_ReadResult(Lekerdezes, SQL_FieldNameToNum(Lekerdezes, "Tapasztalat"));
61 g_iOles[iId] = SQL_ReadResult(Lekerdezes, SQL_FieldNameToNum(Lekerdezes, "Oles"));
62 g_iFejloves[iId] = SQL_ReadResult(Lekerdezes, SQL_FieldNameToNum(Lekerdezes, "Fejloves"));
63 g_iHalal[iId] = SQL_ReadResult(Lekerdezes, SQL_FieldNameToNum(Lekerdezes, "Halal"));
64
65 for(new i = 0; i < KinezetSzam; i ++)
66 {
67 new String[64];
68 formatex(String, charsmax(String), "F_%d", i);
69 OsszesKinezet[i][iId] = SQL_ReadResult(Lekerdezes, SQL_FieldNameToNum(Lekerdezes, String));
70 }
71
72 for(new i = 0; i < 2; i ++)
73 {
74 new String[64];
75 formatex(String, charsmax(String), "Skin%d", i);
76 Kinezet[i][iId] = SQL_ReadResult(Lekerdezes, SQL_FieldNameToNum(Lekerdezes, String));
77 }
78
79 g_iSzint[iId] = SQL_ReadResult(Lekerdezes, SQL_FieldNameToNum(Lekerdezes, "Szint"));
80 }
81 else
82 {
83 Mentes(iId);
84 }
85 }
86}
87public Mentes(iId)
88{
89 static Lekerdezes[256];
90
91 formatex(Lekerdezes, charsmax(Lekerdezes), "INSERT INTO `teszt` (`JatekosNev`) VALUES (^"%s^");", g_iJatekosNev[iId]);
92
93 SQL_ThreadQuery(g_iSqlTuple, "QuerySetData", Lekerdezes);
94}
95public QuerySetData(FailState, Handle: Lekerdezes, Error[], Errcode, Data[], DataSize, Float: Queuetime)
96{
97 if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED)
98 {
99 log_amx("%s", Error);
100 return;
101 }
102}
103public Frissites(iId)
104{
105 new iLen;
106 static Lekerdezes[10048];
107
108 iLen += formatex(Lekerdezes[iLen], charsmax(Lekerdezes), "UPDATE `teszt` SET Ezust = ^"%d^", ", g_iEzust[iId]);
109 iLen += formatex(Lekerdezes[iLen], charsmax(Lekerdezes) - iLen, "Tapasztalat = ^"%d^", ", g_iTapasztalat[iId]);
110 iLen += formatex(Lekerdezes[iLen], charsmax(Lekerdezes) - iLen, "Oles = ^"%d^", ", g_iOles[iId]);
111 iLen += formatex(Lekerdezes[iLen], charsmax(Lekerdezes) - iLen, "Fejloves = ^"%d^", ", g_iFejloves[iId]);
112 iLen += formatex(Lekerdezes[iLen], charsmax(Lekerdezes) - iLen, "Halal = ^"%d^", ", g_iHalal[iId]);
113
114 for(new i = 0; i < KinezetSzam; i ++)
115 iLen += formatex(Lekerdezes[iLen], charsmax(Lekerdezes) - iLen, "F_%d = ^"%i^", ", i, OsszesKinezet[i][iId]);
116
117 for(new i = 0; i < 2; i ++)
118 iLen += formatex(Lekerdezes[iLen], charsmax(Lekerdezes) - iLen, "Skin%d = ^"%i^", ", i, Kinezet[i][iId]);
119
120 iLen += formatex(Lekerdezes[iLen], charsmax(Lekerdezes) - iLen, "Szint = ^"%d^" WHERE JatekosNev = ^"%s^";", g_iSzint[iId], g_iJatekosNev[iId]);
121
122 SQL_ThreadQuery(g_iSqlTuple, "QuerySetData", Lekerdezes);
123}