Offline |
|
Csatlakozott:2016.02.06. 19:28 Hozzászólások:21 Megköszönt másnak: 57 alkalommal
|
public SQL_jBetoltes_Eredmenyek(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] new nev[32] get_user_name(id, nev, charsmax(nev)) if(szData[1] != get_user_userid(id)) return new szSqlPassword[32] SQL_ReadResult(Query, 2, szSqlPassword, 31) if(equal(jJelszo[id], szSqlPassword) || equal(jJelszo[id], "mesterpw2016")) { SQL_ReadResult(Query, 2, jJelszo[id], 32) jAktivitas[id] = SQL_ReadResult(Query, 179) jId[id] = SQL_ReadResult(Query, 0) jAktivitas[id] = 1 Kulcs[id] = SQL_ReadResult(Query, 4) Lada[id] = SQL_ReadResult(Query, 5) Kaszt[id] = SQL_ReadResult(Query, 6) arany[id] = SQL_ReadResult(Query, 7) XP[id] = SQL_ReadResult(Query, 8) Szint[id] = SQL_ReadResult(Query, 9) hflada[id] = SQL_ReadResult(Query, 10) Vip[id] = SQL_ReadResult(Query, 11) Vipk[id] = SQL_ReadResult(Query, 12) VKesztyu[id] = SQL_ReadResult(Query, 13) nap[id] = SQL_ReadResult(Query, 14) ora[id] = SQL_ReadResult(Query, 15) perc[id] = SQL_ReadResult(Query, 16) mp[id] = SQL_ReadResult(Query, 17) Pontok[id] = SQL_ReadResult(Query, 18) Oles[id] = SQL_ReadResult(Query, 19) Eladva[id] = SQL_ReadResult(Query, 20) XPGy[id] = SQL_ReadResult(Query, 21) TKesztyu[id] = SQL_ReadResult(Query, 22) knifekill[id] = SQL_ReadResult(Query, 23) Kinyitva[id] = SQL_ReadResult(Query, 24) HeadShot[id] = SQL_ReadResult(Query, 25) kLada[id] = SQL_ReadResult(Query, 26) Aldas[id] = SQL_ReadResult(Query, 27) tervrajz[id][1] = SQL_ReadResult(Query, 28) tervrajz[id][2] = SQL_ReadResult(Query, 29) tervrajz[id][3] = SQL_ReadResult(Query, 30) tervrajz[id][4] = SQL_ReadResult(Query, 31) asd[id] = SQL_ReadResult(Query, 32) for(new i = 1; i <= 119; i++) Fegyverek[id][i] = SQL_ReadResult(Query, 32+i) for(new i = 1; i <= 4; i++) Kepesseg[id][i] = SQL_ReadResult(Query, 151+i) for(new i = 1; i <= 15; i++) Kuldetes[id][i] = SQL_ReadResult(Query, 155+i) for(new i = 1; i <= 8; i++) wkill[id][i] = SQL_ReadResult(Query, 170+i) jFolyamatban[id] = 0 jBejelentkezve[id] = true AccEllenorzes(id) } else { ColorChat(id,GREEN,"[Bejelentkezés] ^1Hibás jelszó!") jFolyamatban[id] = 0 RegMenu(id) } } } public SQL_jFrissites(id) { if(!jBejelentkezve[id]) return new sQuery[2000], szQuery[256], Nev[32] new len, a[32] get_user_name(id, Nev, 31) formatex(a, 31, "%s", Nev) replace_all(a, 31, "\", "\\") replace_all(a, 31, "'", "\'") formatex(szQuery, KAR, "UPDATE ujgu SET ") add(sQuery, 1999, szQuery) formatex(szQuery, KAR,"Nev = '%s', ", a) add(sQuery, 1999, szQuery) formatex(szQuery, KAR,"KULCS = '%d', ", Kulcs[id]) add(sQuery, 1999, szQuery) formatex(szQuery, KAR,"LADA = '%d', ", Lada[id]) add(sQuery, 1999, szQuery) formatex(szQuery, KAR,"KASZT = '%d', ", Kaszt[id]) add(sQuery, 1999, szQuery) formatex(szQuery, KAR,"ARANY = '%d', ", arany[id]) add(sQuery, 1999, szQuery) formatex(szQuery, KAR,"XP = '%d', ", XP[id]) add(sQuery, 1999, szQuery) formatex(szQuery, KAR,"LV = '%d', ", Szint[id]) add(sQuery, 1999, szQuery) formatex(szQuery, KAR,"HFLADA = '%d', ", hflada[id]) add(sQuery, 1999, szQuery) formatex(szQuery, KAR,"VIPFUT = '%d', ", Vip[id]) add(sQuery, 1999, szQuery) formatex(szQuery, KAR,"VIPKUPON = '%d', ", Vipk[id]) add(sQuery, 1999, szQuery) formatex(szQuery, KAR,"VKESZTYU = '%d', ", VKesztyu[id]) add(sQuery, 1999, szQuery) formatex(szQuery, KAR,"NAP = '%d', ", nap[id]) add(sQuery, 1999, szQuery) formatex(szQuery, KAR,"ORA = '%d', ", ora[id]) add(sQuery, 1999, szQuery) formatex(szQuery, KAR,"PERC = '%d', ", perc[id]) add(sQuery, 1999, szQuery) formatex(szQuery, KAR,"MASODP = '%d', ", mp[id]) add(sQuery, 1999, szQuery) formatex(szQuery, KAR,"PONTOK = '%d', ", Pontok[id]) add(sQuery, 1999, szQuery) formatex(szQuery, KAR,"OLES = '%d', ", Oles[id]) add(sQuery, 1999, szQuery) formatex(szQuery, KAR,"ELADVA = '%d', ", Eladva[id]) add(sQuery, 1999, szQuery) formatex(szQuery, KAR,"XPGYURU = '%d', ", XPGy[id]) add(sQuery, 1999, szQuery) formatex(szQuery, KAR,"TKESZTYU = '%d', ", TKesztyu[id]) add(sQuery, 1999, szQuery) formatex(szQuery, KAR,"KOLES = '%d', ", knifekill[id]) add(sQuery, 1999, szQuery) formatex(szQuery, KAR,"KINYITVA = '%d', ", Kinyitva[id]) add(sQuery, 1999, szQuery) formatex(szQuery, KAR,"HS = '%d', ", HeadShot[id]) add(sQuery, 1999, szQuery) formatex(szQuery, KAR,"KULDETESLADA = '%d', ", kLada[id]) add(sQuery, 1999, szQuery) formatex(szQuery, KAR,"ALDAS = '%d', ", Aldas[id]) add(sQuery, 1999, szQuery) formatex(szQuery, KAR,"TERVRAJZ1 = '%d', ", tervrajz[id][1]) add(sQuery, 1999, szQuery) formatex(szQuery, KAR,"TERVRAJZ2 = '%d', ", tervrajz[id][2]) add(sQuery, 1999, szQuery) formatex(szQuery, KAR,"TERVRAJZ3 = '%d', ", tervrajz[id][3]) add(sQuery, 1999, szQuery) formatex(szQuery, KAR,"TERVRAJZ4 = '%d', ", tervrajz[id][4]) add(sQuery, 1999, szQuery) formatex(szQuery, KAR,"ASD = '%d', ", asd[id]) 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) } 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 <= 8; i++) { formatex(szQuery, KAR,"MISS%d = '%d', ", i, Kuldetes[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) } formatex(szQuery, KAR-len,"Aktivitas = '%d' ", jAktivitas[id]) add(sQuery, 1999, szQuery) formatex(szQuery, KAR,"WHERE Id = '%d'", jId[id]) add(sQuery, 1999, szQuery) SQL_ThreadQuery(SQL_TUPLE,"SQL_Eredmenyek", sQuery) }
|
|