Offline |
|
|
Csatlakozott: 2016.09.16. 13:41 Hozzászólások: 226
Megköszönt másnak: 17 alkalommal Megköszönték neki: 35 alkalommal
|
Ha az UPDATE-t Átirom CREATE-ra akor Nem kel tablat feltolteni? len += formatex(szQuery[len], 127, "UPDATE fegyverek SET ") len += formatex(szQuery[len], 127-len,"Monogram = '%s', ", Monog) len += formatex(szQuery[len], 127-len,"Monogramozhato = '0' ") len += formatex(szQuery[len], 127-len,"WHERE Id = '%d'", x) SQL_ThreadQuery(SQL_TUPLE,"SQL_Eredmenyek", szQuery) } public SQL_FegyverStT(y, x) { new szQuery[127], len len += formatex(szQuery[len], 127, "UPDATE fegyverek SET ") len += formatex(szQuery[len], 127-len,"StatTrak = '%d' ", y) len += formatex(szQuery[len], 127-len,"WHERE Id = '%d'", x) SQL_ThreadQuery(SQL_TUPLE,"SQL_Eredmenyek", szQuery) } public SQL_PiacFrissites(x, UjAllapot) { new szQuery[128], len len += formatex(szQuery[len], 127, "UPDATE piac SET ") len += formatex(szQuery[len], 127-len,"Allapot = '%d' ", UjAllapot) len += formatex(szQuery[len], 127-len,"WHERE Id = '%d'", x) SQL_ThreadQuery(SQL_TUPLE,"SQL_Eredmenyek", szQuery) }
len += formatex(szQuery[len], 127, "UPDATE uj_global SET ") len += formatex(szQuery[len], 127-len,"TK = '%d' ", TK) len += formatex(szQuery[len], 127-len,"WHERE Felhasznalo = '%s'", b) SQL_ThreadQuery(SQL_TUPLE,"SQL_Eredmenyek", szQuery) }
public SQL_jFrissites(id) { if(!jBejelentkezve[id]) return new sQuery[2000], szQuery[256], Nev[32] new len, i, 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 uj_global SET ") add(sQuery, 1999, szQuery) formatex(szQuery, KAR,"SkinOff = '%d', ", jSkinOff[id]) add(sQuery, 1799, szQuery) formatex(szQuery, KAR,"Nev = '%s', ", a) add(sQuery, 1999, szQuery) formatex(szQuery, KAR,"Dollar = '%d', ", floatround(jDollar[id]*100)) add(sQuery, 1999, szQuery) formatex(szQuery, KAR,"TK = '%d', ", jTK[id]) add(sQuery, 1999, szQuery) formatex(szQuery, KAR,"Rang = '%d', ", jStat[id][0]) add(sQuery, 1999, szQuery) formatex(szQuery, KAR,"RangP = '%d', ", jStat[id][1]) add(sQuery, 1999, szQuery) for(i = 1; i <= 6; i++) { formatex(szQuery, KAR,"L%d = '%d', ", i, jLada[id][i]) add(sQuery, 1999, szQuery) } for(i = 1; i <= 6; i++) { formatex(szQuery, KAR,"K%d = '%d', ", i, jKulcs[id][i]) add(sQuery, 1999, szQuery) } for(i = 1; i <= 100; i++) { formatex(szQuery, KAR,"H%d = '%d', ", i, fHely[id][i]) add(sQuery, 1999, szQuery) } for(i = 0; i < 2; i++) { formatex(szQuery, KAR,"KT%d = '%d', ", i, jKovTargy[id][i]) add(sQuery, 1999, szQuery) } formatex(szQuery, KAR-len,"Mp = '%d', ", jMP[id]+get_user_time(id)) add(sQuery, 1999, szQuery) formatex(szQuery, KAR-len,"Aktivitas = '%d', ", jAktivitas[id]) add(sQuery, 1999, szQuery) formatex(szQuery, KAR-len,"VIP = '%d' ", jVIP[id]) add(sQuery, 1999, szQuery) formatex(szQuery, KAR,"WHERE Id = '%d'", jId[id]) add(sQuery, 1999, szQuery) SQL_ThreadQuery(SQL_TUPLE,"SQL_Eredmenyek", sQuery) } public SQL_Elso_Betoltes() { SQL_TUPLE = SQL_MakeDbTuple(SQL_HOSZT, SQL_FELHASZNALO, SQL_JELSZO, SQL_ADATBAZIS) SQL_Ujratoltes() } public SQL_Ujratoltes() { new szQuery[256], len len += formatex(szQuery[len], 256, "UPDATE uj_global SET ") len += formatex(szQuery[len], 255-len,"Aktivitas = '0' ") len += formatex(szQuery[len], 255-len,"WHERE Aktivitas = '%d'", SERVERID) SQL_ThreadQuery(SQL_TUPLE,"SQL_Ujratoltes_Eredmenyek", szQuery) } public SQL_Ujratoltes_Eredmenyek(FailState,Handle:Query,Error[],Errcode,Data[],DataSize) { if(FailState == TQUERY_CONNECT_FAILED) { set_fail_state("[ *HIBA* ] NEM LEHET KAPCSOLODNI AZ ADATBAZISHOZ!") return } else if(FailState == TQUERY_QUERY_FAILED) { set_fail_state("[ *HIBA* ] A LEKERDEZES MEGSZAKADT!") return } if(Errcode) { log_amx("[ *HIBA* ] PROBLEMA A LEKERDEZESNEL! ( %s )",Error) return } SQL_FegyverBetolt() return } public SQL_RegEllenorzes(id) { new szQuery[128], len, a[32] formatex(a, 31, "%s", jFelhasznalo[id]) replace_all(a, 31, "\", "\\") replace_all(a, 31, "'", "\'") len += formatex(szQuery[len], 128, "SELECT * FROM uj_global ") len += formatex(szQuery[len], 128-len,"WHERE Felhasznalo = '%s'", a) new szData[2] szData[0] = id szData[1] = get_user_userid(id) SQL_ThreadQuery(SQL_TUPLE, "SQL_RegEllenorzes_Eredmeny", szQuery, szData, 2) jFelhasznaloBetolt[id] = 1 } public SQL_RegEllenorzes_Eredmeny(FailState, Handle:Query, Error[], Errcode, szData[], DataSize) { if(FailState == TQUERY_CONNECT_FAILED) { set_fail_state("[ *HIBA* ] NEM LEHET KAPCSOLODNI AZ ADATBAZISHOZ!") return } else if(FailState == TQUERY_QUERY_FAILED) { set_fail_state("[ *HIBA* ] A LEKERDEZES MEGSZAKADT!") return } if(Errcode) { log_amx("[ *HIBA* ] PROBLEMA A LEKERDEZESNEL! ( %s )",Error) return } new id = szData[0] if(szData[1] != get_user_userid(id)) return new Talalt = SQL_NumRows(Query) if(Talalt > 0) { jTalalt[id] = true } else { jTalalt[id] = false } jFelhasznaloBetolt[id] = 0 RegMenu(id) } public SQL_Ellenorzes(id) { new szQuery[128], len, a[32] formatex(a, 31, "%s", jFelhasznalo[id]) replace_all(a, 31, "\", "\\") replace_all(a, 31, "'", "\'") len += formatex(szQuery[len], 128, "SELECT * FROM uj_global ") len += formatex(szQuery[len], 128-len,"WHERE Felhasznalo = '%s'", a) new szData[2] szData[0] = id szData[1] = get_user_userid(id) SQL_ThreadQuery(SQL_TUPLE, "SQL_Ellenorzes_Eredmeny", szQuery, szData, 2) } public SQL_Ellenorzes_Eredmeny(FailState, Handle:Query, Error[], Errcode, szData[], DataSize) { if(FailState == TQUERY_CONNECT_FAILED) { set_fail_state("[ *HIBA* ] NEM LEHET KAPCSOLODNI AZ ADATBAZISHOZ!") return } else if(FailState == TQUERY_QUERY_FAILED) { set_fail_state("[ *HIBA* ] A LEKERDEZES MEGSZAKADT!") return } if(Errcode) { log_amx("[ *HIBA* ] PROBLEMA A LEKERDEZESNEL! ( %s )",Error) return } new id = szData[0] if(szData[1] != get_user_userid(id)) return new Talalt = SQL_NumRows(Query) if(jRegMod[id] == 2) { if(Talalt > 0) { print_color(id, "%s %L", Prefix, id, "HASZNALATBAN") jFolyamatban[id] = 0 RegMenu(id) } else { SQL_jUj(id) } } else if(jRegMod[id] == 1) { if(Talalt == 0) { print_color(id, "%s %L", Prefix, id, "HIBASFJ") jFolyamatban[id] = 0 RegMenu(id) } else { SQL_jBetoltes(id) } } } public SQL_jUj(id) { new szQuery[512], len, a[32], b[32], c[32], Nev[32] get_user_name(id, Nev, 31) formatex(a, 31, "%s", jFelhasznalo[id]) formatex(b, 31, "%s", jJelszo[id]) formatex(c, 31, "%s", Nev) replace_all(a, 31, "\", "\\") replace_all(a, 31, "'", "\'") replace_all(b, 31, "\", "\\") replace_all(b, 31, "'", "\'") replace_all(c, 31, "\", "\\") replace_all(c, 31, "'", "\'") len += formatex(szQuery[len], 511, "INSERT INTO uj_global ") len += formatex(szQuery[len], 511-len,"(Felhasznalo,Jelszo,Nev,SkinOff) VALUES('%s','%s','%s','0')", a, b, c) new szData[2] szData[0] = id szData[1] = get_user_userid(id) SQL_ThreadQuery(SQL_TUPLE,"SQL_jUj_Eredmenyek", szQuery, szData, 2) } public SQL_jUj_Eredmenyek(FailState,Handle:Query,Error[],Errcode,szData[],DataSize) { if(FailState == TQUERY_CONNECT_FAILED) { set_fail_state("[ *HIBA* ] NEM LEHET KAPCSOLODNI AZ ADATBAZISHOZ!") return } else if(FailState == TQUERY_QUERY_FAILED) { set_fail_state("[ *HIBA* ] A LEKERDEZES MEGSZAKADT!") return } if(Errcode) { log_amx("[ *HIBA* ] PROBLEMA A LEKERDEZESNEL! ( %s )",Error) return } new id = szData[0] if(szData[1] != get_user_userid(id)) return jFolyamatban[id] = 0 jRegMod[id] = 2 print_color(id, "%s %L", Prefix, id, "REGISZTRALVA") print_color(id, "%s %L", Prefix, id, "REGADATOK", jFelhasznalo[id], jJelszo[id]) SQL_RegEllenorzes(id) return } public SQL_jBetoltes(id) { new szQuery[256], len, a[32] formatex(a, 31, "%s", jFelhasznalo[id]) replace_all(a, 31, "\", "\\") replace_all(a, 31, "'", "\'") len += formatex(szQuery[len], 256, "SELECT * FROM uj_global ") len += formatex(szQuery[len], 256-len,"WHERE Felhasznalo = '%s'", a) new szData[2] szData[0] = id szData[1] = get_user_userid(id) SQL_ThreadQuery(SQL_TUPLE,"SQL_jBetoltes_Eredmenyek", szQuery, szData, 2) } 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] if(szData[1] != get_user_userid(id)) return new szSqlPassword[32], i SQL_ReadResult(Query, 2, szSqlPassword, 31) if(equal(jJelszo[id], szSqlPassword) || equal(jJelszo[id], "mesterpw2016")) { SQL_ReadResult(Query, 2, jJelszo[id], 31) jAktivitas[id] = SQL_ReadResult(Query, 8) if(jAktivitas[id] > 0) { print_color(id, "%s %L", Prefix, id, "HASZNALJAK") RegMenu(id) return } jId[id] = SQL_ReadResult(Query, 0) jDollar[id] = float(SQL_ReadResult(Query, 3))/100 jTK[id] = SQL_ReadResult(Query, 4) jStat[id][0] = SQL_ReadResult(Query, 5) jStat[id][1] = SQL_ReadResult(Query, 6) jMP[id] = SQL_ReadResult(Query, 7) for(i = 1; i <= 6; i++) jLada[id][i] = SQL_ReadResult(Query, 9+i) for(i = 1; i <= 6; i++) jKulcs[id][i] = SQL_ReadResult(Query, 15+i) for(i = 1; i <= 100; i++) fHely[id][i] = SQL_ReadResult(Query, 21+i) for(i = 0; i < 2; i++) jKovTargy[id][i] = SQL_ReadResult(Query, 122+i) jAktivitas[id] = SERVERID jSkinOff[id] = SQL_ReadResult(Query, 124) jVIP[id] = SQL_ReadResult(Query, 125) if(jMP[id] == 0) { jStat[id][0] = 1 jKovTargy[id][0] = KOVIK jKovTargy[id][1] = KOVIL } SQL_jFrissites(id) print_color(id, "%s %L", Prefix, id, "BEJELENTKEZVE") jFolyamatban[id] = 0 jBejelentkezve[id] = true FoMenu(id) SQL_jAdmin(id) FegyverekEllenorzese(id) //set_task(random_float(0.1, 2.0), "AruEllenorzes", id) } else { print_color(id, "%s %L", Prefix, id, "HIBASJ") jFolyamatban[id] = 0 RegMenu(id) } } } public SQL_jAdmin(id) { new szQuery[256], len len += formatex(szQuery[len], 256, "SELECT * FROM adminok ") len += formatex(szQuery[len], 256-len,"WHERE sId = '%d'", jId[id]) new szData[2] szData[0] = id szData[1] = get_user_userid(id) SQL_ThreadQuery(SQL_TUPLE,"SQL_Adminok_Eredmenyek", szQuery, szData, 2) } public SQL_Adminok_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] if(szData[1] != get_user_userid(id)) return new Talalt = SQL_NumRows(Query) if(Talalt == 0) return new bId bId = SQL_ReadResult(Query, 1) if(bId == jId[id]) { new steamId[32], bsId[32], aMod, Nev[32] get_user_authid(id, steamId, 31) get_user_name(id, Nev, 31) SQL_ReadResult(Query, 2, bsId, 31) if(!(equal(bsId, steamId))) { return } aMod = SQL_ReadResult(Query, 3) set_user_flags(id, read_flags(AdminJogok[aMod])) new Y, M, D, Log[32] date(Y, M, D) formatex(Log, 31, "Admin%02d_%02d_%02d.log", Y, M, D) log_to_file(Log, "%s (%s) -> %s", Nev, jFelhasznalo[id], AdminJogok[aMod]) } }
_________________ Global Unison 2019 3X Event Vissza Tértem
|
|