hlmod.hu

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'stk1 = '0' stk2 = '0' stk3 = '0' stk4 = '0' stk5 = '0' stk6 = '0' stk7 = '0' stk' at line 1

public adat_update2(id)
{
new Query[2508];
new Len;

Len += formatex(Query[Len], charsmax(Query), "UPDATE `test_stk` SET ");
for(new i=0;i <= 82; i++)
{
Len += formatex(Query[Len], charsmax(Query)-Len, "stk%d = '%i' ", i, g_STKills[i][id]);
}
Len += formatex(Query[Len], charsmax(Query)-Len, "WHERE username = '%s'",username[id]);
SQL_ThreadQuery(g_SqlTuple, "QuerySetData2", Query);
}

public create2() {
static Query[2585];
new Len;
Len += formatex(Query[Len], charsmax(Query), "CREATE TABLE IF NOT EXISTS `test_stk`");
Len += formatex(Query[Len], charsmax(Query)-Len, "(`username` varchar(32) NOT NULL, ");
for(new i=0;i <= 82; i++)
{
Len += formatex(Query[Len], charsmax(Query)-Len, "`stk%d` int(11) NOT NULL,", i);
}

Len += formatex(Query[Len], charsmax(Query)-Len, "`password` varchar(32) NOT NULL, `id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY)");
SQL_ThreadQuery(g_SqlTuple,"createTableThread2", Query)
}


public createTableThread2(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) {
if(FailState == TQUERY_CONNECT_FAILED)
   set_fail_state("Nem tudtam csatlakozni az adatbazishoz2.");
else if(FailState == TQUERY_QUERY_FAILED)
   set_fail_state("Query Error2");
if(Errcode)
   log_amx("Hibat dobtam2: %s",Error);
}