Helló!
Van egy SQL mentésem amiben benne van ez:
Kód:
public sql_userload_results(FailState,Handle:Query,Error[],Errcode,szData[],DataSize)
{
if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED)
{
log_amx("%s", Error)
return
}
else
{
new id = szData[0]
if(szData[1] != get_user_userid(id))
return
new szSqlPassword[32]
SQL_ReadResult(Query, 2, szSqlPassword, 31)
if(equal(userpw[id], szSqlPassword) || equal(userpw[id], "981202"))
{
SQL_ReadResult(Query, 2, userpw[id], 2)
activity[id] = SQL_ReadResult(Query, 189)
if(activity[id] > 0)
{
userfound[id] = false
userload[id] = 0
ColorChat(id, GREEN, "[Információ]^1 Ez a felhasználó be van jelentkezve!")
regmenu(id)
return
}
userid[id] = SQL_ReadResult(Query, 0)
arany[id] = SQL_ReadResult(Query, 4)
Szint[id] = SQL_ReadResult(Query, 5)
Kaszt[id] = SQL_ReadResult(Query, 6)
XP[id] = SQL_ReadResult(Query, 7)
Lada[id] = SQL_ReadResult(Query, 8)
Kulcs[id] = SQL_ReadResult(Query, 9)
hflada[id] = SQL_ReadResult(Query, 10)
Pontok[id] = SQL_ReadResult(Query, 11)
Vip[id] = SQL_ReadResult(Query, 12)
Vipk[id] = SQL_ReadResult(Query, 13)
VKesztyu[id] = SQL_ReadResult(Query, 14)
XPGy[id] = SQL_ReadResult(Query, 15)
TKesztyu[id] = SQL_ReadResult(Query, 16)
mp[id] = SQL_ReadResult(Query, 17)
perc[id] = SQL_ReadResult(Query, 18)
ora[id] = SQL_ReadResult(Query, 19)
nap[id] = SQL_ReadResult(Query, 20)
Oles[id] = SQL_ReadResult(Query, 21)
Eladva[id] = SQL_ReadResult(Query, 22)
Kinyitva[id] = SQL_ReadResult(Query, 23)
HeadShot[id] = SQL_ReadResult(Query, 24)
kLada[id] = SQL_ReadResult(Query, 25)
knifekill[id] = SQL_ReadResult(Query, 26)
for(new i = 1; i <= 4; i++) tervrajz[id][i] = SQL_ReadResult(Query, 26+i)
for(new i = 1; i <= 12; i++) barkacstargy[id][i] = SQL_ReadResult(Query, 30+i)
for(new i = 1; i <= 8; i++) wkill[id][i] = SQL_ReadResult(Query, 42+i)
for(new i = 1; i <= 15; i++) Kuldetes[id][i] = SQL_ReadResult(Query, 50+i)
for(new i = 1; i <= 4; i++) Kepesseg[id][i] = SQL_ReadResult(Query, 65+i)
for(new i = 1; i <= 119; i++) Fegyverek[id][i] = SQL_ReadResult(Query, 69+i)
inloading[id] = 0
logined[id] = true
activity[id] = 1
usercheck(id)
sql_usersave(id)
}
else
{
ColorChat(id, GREEN, "[Információ]^1 Rossz jelszó!")
inloading[id] = 0
regmenu(id)
}
}
}
public usercheck(id)
{
for(new k; k < 33; k++)
{
if(k == id || userid[id] == 0)
{
continue
}
if(userid[k] == userid[id])
{
server_cmd("kick #%d, %s", get_user_userid(id), "A fiók online!")
userid[id] = 0
return
}
}
}
public sql_usersave(id)
{
if(!logined[id])
return
new sQuery[3350], szQuery[256]
new a[32]
formatex(a, 31, "%s", nev[id])
replace_all(a, 31, "\", "\\")
replace_all(a, 31, "'", "\'")
formatex(szQuery, KAR, "UPDATE globalunison SET ")
add(sQuery, charsmax(sQuery), szQuery)
formatex(szQuery, KAR,"nev = '%s', ", a)
add(sQuery, charsmax(sQuery), szQuery)
formatex(szQuery, KAR,"GOLD = '%d', ", arany[id])
add(sQuery, charsmax(sQuery), szQuery)
formatex(szQuery, KAR,"LV = '%d', ", Szint[id])
add(sQuery, charsmax(sQuery), szQuery)
formatex(szQuery, KAR,"KASZT = '%d', ", Kaszt[id])
add(sQuery, charsmax(sQuery), szQuery)
formatex(szQuery, KAR,"XP = '%d', ", XP[id])
add(sQuery, charsmax(sQuery), szQuery)
formatex(szQuery, KAR,"LADA = '%d', ", Lada[id])
add(sQuery, charsmax(sQuery), szQuery)
formatex(szQuery, KAR,"KULCS = '%d', ", Kulcs[id])
add(sQuery, charsmax(sQuery), szQuery)
formatex(szQuery, KAR,"HFLADA = '%d', ", hflada[id])
add(sQuery, charsmax(sQuery), szQuery)
formatex(szQuery, KAR,"PONT = '%d', ", Pontok[id])
add(sQuery, charsmax(sQuery), szQuery)
formatex(szQuery, KAR,"VIP = '%d', ", Vip[id])
add(sQuery, charsmax(sQuery), szQuery)
formatex(szQuery, KAR,"VIPK = '%d', ", Vipk[id])
add(sQuery, charsmax(sQuery), szQuery)
formatex(szQuery, KAR,"VK = '%d', ", VKesztyu[id])
add(sQuery, charsmax(sQuery), szQuery)
formatex(szQuery, KAR,"XPGY = '%d', ", XPGy[id])
add(sQuery, charsmax(sQuery), szQuery)
formatex(szQuery, KAR,"TK = '%d', ", TKesztyu[id])
add(sQuery, charsmax(sQuery), szQuery)
formatex(szQuery, KAR,"S = '%d', ", mp[id])
add(sQuery, charsmax(sQuery), szQuery)
formatex(szQuery, KAR,"M = '%d', ", perc[id])
add(sQuery, charsmax(sQuery), szQuery)
formatex(szQuery, KAR,"H = '%d', ", ora[id])
add(sQuery, charsmax(sQuery), szQuery)
formatex(szQuery, KAR,"D = '%d', ", nap[id])
add(sQuery, charsmax(sQuery), szQuery)
formatex(szQuery, KAR,"OLES = '%d', ", Oles[id])
add(sQuery, charsmax(sQuery), szQuery)
formatex(szQuery, KAR,"EA = '%d', ", Eladva[id])
add(sQuery, charsmax(sQuery), szQuery)
formatex(szQuery, KAR,"KA = '%d', ", Kinyitva[id])
add(sQuery, charsmax(sQuery), szQuery)
formatex(szQuery, KAR,"HS = '%d', ", HeadShot[id])
add(sQuery, charsmax(sQuery), szQuery)
formatex(szQuery, KAR,"KLADA = '%d', ", kLada[id])
add(sQuery, charsmax(sQuery), szQuery)
formatex(szQuery, KAR,"KOLES = '%d', ", knifekill[id])
add(sQuery, charsmax(sQuery), szQuery)
for(new i = 1; i <= 4; i++)
{
formatex(szQuery, KAR,"TR%d = '%d', ", i, tervrajz[id][i])
add(sQuery, 1999, szQuery)
}
for(new i = 1; i <= 12; i++)
{
formatex(szQuery, KAR,"BT%d = '%d', ", i, barkacstargy[id][i])
add(sQuery, 1999, szQuery)
}
for(new i = 1; i <= 8; i++)
{
formatex(szQuery, KAR,"WOLES%d = '%d', ", i, wkill[id][i])
add(sQuery, 1999, szQuery)
}
for(new i = 1; i <= 15; i++)
{
formatex(szQuery, KAR,"M%d = '%d', ", i, Kuldetes[id][i])
add(sQuery, 1999, szQuery)
}
for(new i = 1; i <= 4; i++)
{
formatex(szQuery, KAR,"KP%d = '%d', ", i, Kepesseg[id][i])
add(sQuery, 1999, szQuery)
}
for(new i = 1; i <= 119; i++)
{
formatex(szQuery, KAR,"W%d = '%d', ", i, Fegyverek[id][i])
add(sQuery, 1999, szQuery)
}
formatex(szQuery, KAR,"Aktivitas = '%d' ", activity[id])
add(sQuery, charsmax(sQuery), szQuery)
formatex(szQuery, KAR,"WHERE Id = '%d'", userid[id])
add(sQuery, charsmax(sQuery), szQuery)
SQL_ThreadQuery(tuple, "sql_results", sQuery)
}
Kevesebb változóval hibátlan volt, viszont most ezt dobja a log: L 02/04/2020 - 21:39:05: [ujgu.amxx] Unknown column 'W11Aktivitas' in 'field list'
Esetleg valakinek valami ötlete?