Offline |
|
Csatlakozott: 2018.05.05. 18:34 Hozzászólások: 198
Megköszönt másnak: 39 alkalommal Megköszönték neki: 8 alkalommal
|
Sziasztok egy olyan problémám lenne ezzel a mentésel hogy van olyan hogy egyes skinek eltünnek olyankor amikor a szerver be laggol. Logba semmit nem ír a mentésel kapcsolatban. public Save() { new players[32], pnum, id get_players(players, pnum, "chi") for(new i; i<pnum; i++) { id=players[i] if(User[id] == logged_in) { Update_SQL(id) } } } /*========== TABLAK ==========*/ public client_putinserver(id) { arrayset(Skinjei[id], 0, 162) arrayset(StatTrakSkinjei[id], 0, 162) arrayset(StatTrakSzamlalo[id], 0, 162) arrayset(Kulcsok[id], 0, 13) arrayset(Ladak[id], 0, 14) arrayset(chosen[id], 0, 11) Is_M4A4[id] = false Dollarja[id] = 0.0 StatTrakTool[id] = 0 HUD[id] = true get_user_name(id, name[id], charsmax(name[])) rank[id] = 0; static szStats[8],szBHits[8]; get_user_stats(id,szStats,szBHits); while(szStats[0] >= Rangok[rank[id]][Numbers]) { rank[id]++ } Skin[id] = true } public client_disconnect(id) { if((!is_user_bot(id) || !is_user_hltv(id)) && User[id] == logged_in) { Update_SQL(id) } arrayset(Skinjei[id], 0, 162) arrayset(StatTrakSkinjei[id], 0, 162) arrayset(StatTrakSzamlalo[id], 0, 162) arrayset(Kulcsok[id], 0, 13) arrayset(Ladak[id], 0, 14) arrayset(chosen[id], 0, 11) Is_M4A4[id] = false Dollarja[id] = 0.0 StatTrakTool[id] = 0 username[id][0] = EOS; password[id][0] = EOS; password2[id][0] = EOS; User[id] = unknown; Skin[id] = true } public plugin_cfg() { static Query[2048], Len g_SqlTuple = SQL_MakeDbTuple(SQL_INFO[0], SQL_INFO[1], SQL_INFO[2], SQL_INFO[3]) Len += formatex(Query, charsmax(Query), "CREATE TABLE IF NOT EXISTS `GO_Skinek` (`id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,") Len += formatex(Query[Len], charsmax(Query)-Len, " `Username` VARCHAR(64) NOT NULL, `Skinek` TEXT, `StatTrak_Skinek` TEXT, `StatTrak_Olesek` TEXT,") Len += formatex(Query[Len], charsmax(Query)-Len, " `Is_M4A4` INT(2), `Kivalasztva` TEXT)") SQL_ThreadQuery(g_SqlTuple, "CreateSkinTable", Query) set_task(1.0, "CFG_Table") set_task(2.0, "CFG_Market") formatex(Query, charsmax(Query), "CREATE TABLE IF NOT EXISTS `register`(`username` varchar(64) NOT NULL, `password` varchar(32) NOT NULL, `id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY)"); SQL_ThreadQuery(g_SqlTuple, "createTableThread", Query); } public CFG_Table() { static Query[2048], Len Len += formatex(Query, charsmax(Query), "CREATE TABLE IF NOT EXISTS `GO_Egyebek` (`id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,") Len += formatex(Query[Len], charsmax(Query)-Len, " `Username` VARCHAR(64) NOT NULL, `Ladak` TEXT, `Kulcsok` TEXT,") Len += formatex(Query[Len], charsmax(Query)-Len, " `Dollar` FLOAT(11), `StatTrak_Tool` INT(11))") SQL_ThreadQuery(g_SqlTuple, "CreateOtherTable", Query) } public CFG_Market() { static Query[2048], Len Len += formatex(Query, charsmax(Query), "CREATE TABLE IF NOT EXISTS `GO_Piac` (`id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,") Len += formatex(Query[Len], charsmax(Query)-Len, " `Username` VARCHAR(64) NOT NULL, `Item` VARCHAR(8), `Ara` FLOAT(11))") SQL_ThreadQuery(g_SqlTuple, "CreateMarketTable", Query) } public CreateSkinTable(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) { if(FailState == TQUERY_CONNECT_FAILED) set_fail_state("Nem lehet csatlakozni az adatbazishoz [Skin tabla!!!]") else if(FailState == TQUERY_QUERY_FAILED) set_fail_state("Query Error [Skin tabla!!!]") if(Errcode) log_amx("[Skin tabla!!!] Hiba: %s", Error) } public CreateOtherTable(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) { if(FailState == TQUERY_CONNECT_FAILED) set_fail_state("Nem lehet csatlakozni az adatbazishoz [Egyeb tabla!!!]") else if(FailState == TQUERY_QUERY_FAILED) set_fail_state("Query Error [Egyeb tabla!!!]") if(Errcode) log_amx("[Egyeb tabla!!!] Hiba: %s", Error) } public CreateMarketTable(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) { if(FailState == TQUERY_CONNECT_FAILED) set_fail_state("Nem lehet csatlakozni az adatbazishoz [Piac tabla!!!]") else if(FailState == TQUERY_QUERY_FAILED) set_fail_state("Query Error [Piac tabla!!!]") if(Errcode) log_amx("[Piac tabla!!!] Hiba: %s", Error) } /*=============================*/ /*========== BETOLTES =========*/ public Load_Skins(id) { static Query[2048], Data[1] Data[0] = id formatex(Query, charsmax(Query), "SELECT * FROM `GO_Skinek` WHERE Username = '%s';", username[id]) SQL_ThreadQuery(g_SqlTuple, "QueryLoadSkins", Query, Data, 1) } public QueryLoadSkins(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) { if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED) { log_amx("[Skin Betoltes] Hiba: %s", Error) return } else { new id = Data[0] if(SQL_NumRows(Query) > 0) { new Text[1024], Data[8] SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Skinek"), Text, charsmax(Text)) for(new i; i<162; i++) { strtok(Text, Data, charsmax(Data), Text, charsmax(Text), ',', 0) Skinjei[id][i] = str_to_num(Data) Data[0] = EOS } SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "StatTrak_Skinek"), Text, charsmax(Text)) for(new i; i<162; i++) { strtok(Text, Data, charsmax(Data), Text, charsmax(Text), ',', 0) StatTrakSkinjei[id][i] = str_to_num(Data) Data[0] = EOS } SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "StatTrak_Olesek"), Text, charsmax(Text)) for(new i; i<162; i++) { strtok(Text, Data, charsmax(Data), Text, charsmax(Text), ',', 0) StatTrakSzamlalo[id][i] = str_to_num(Data) Data[0] = EOS } SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Kivalasztva"), Text, charsmax(Text)) new Data2[11][8] parse(Text, Data2[0], 7, Data2[1], 7, Data2[2], 7, Data2[3], 7, Data2[4], 7, Data2[5], 7, Data2[6], 7, Data2[7], 7, Data2[8], 7, Data2[9], 7, Data2[10], 7) chosen[id][0] = str_to_num(Data2[0]) Data2[0][0] = EOS chosen[id][1] = str_to_num(Data2[1]) Data2[1][0] = EOS chosen[id][2] = str_to_num(Data2[2]) Data2[2][0] = EOS chosen[id][3] = str_to_num(Data2[3]) Data2[3][0] = EOS chosen[id][4] = str_to_num(Data2[4]) Data2[4][0] = EOS chosen[id][5] = str_to_num(Data2[5]) Data2[5][0] = EOS chosen[id][6] = str_to_num(Data2[6]) Data2[6][0] = EOS chosen[id][7] = str_to_num(Data2[7]) Data2[7][0] = EOS chosen[id][8] = str_to_num(Data2[8]) Data2[8][0] = EOS chosen[id][9] = str_to_num(Data2[9]) Data2[9][0] = EOS chosen[id][10] = str_to_num(Data2[10]) Data2[10][0] = EOS new stg = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Is_M4A4")) switch(stg) { case 0:Is_M4A4[id] = false case 1:Is_M4A4[id] = true } } else Save_Skins(id) } } public Load_Other(TaskID) { static Query[2048], Data[1] Data[0] = TaskID-LOAD_TASK formatex(Query, charsmax(Query), "SELECT * FROM `GO_Egyebek` WHERE Username = '%s';", username[TaskID-LOAD_TASK]) SQL_ThreadQuery(g_SqlTuple, "QueryLoadOther", Query, Data, 1) } public QueryLoadOther(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) { if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED) { log_amx("[Skin Betoltes] Hiba: %s", Error) return } else { new id = Data[0] if(SQL_NumRows(Query) > 0) { new Text[512], Data[14][8] SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Kulcsok"), Text, charsmax(Text)) parse(Text, Data[0], 7, Data[1], 7, Data[2], 7, Data[3], 7, Data[4], 7, Data[5], 7, Data[6], 7, Data[7], 7, Data[8], 7, Data[9], 7, Data[10], 7, Data[11], 7, Data[12], 7, Data[13], 7) Text[0] = EOS Kulcsok[id][0] = str_to_num(Data[0]) Data[0][0] = EOS Kulcsok[id][1] = str_to_num(Data[1]) Data[1][0] = EOS Kulcsok[id][2] = str_to_num(Data[2]) Data[2][0] = EOS Kulcsok[id][3] = str_to_num(Data[3]) Data[3][0] = EOS Kulcsok[id][4] = str_to_num(Data[4]) Data[4][0] = EOS Kulcsok[id][5] = str_to_num(Data[5]) Data[5][0] = EOS Kulcsok[id][6] = str_to_num(Data[6]) Data[6][0] = EOS Kulcsok[id][7] = str_to_num(Data[7]) Data[7][0] = EOS Kulcsok[id][8] = str_to_num(Data[8]) Data[8][0] = EOS Kulcsok[id][9] = str_to_num(Data[9]) Data[9][0] = EOS Kulcsok[id][10] = str_to_num(Data[10]) Data[10][0] = EOS Kulcsok[id][11] = str_to_num(Data[11]) Data[11][0] = EOS Kulcsok[id][12] = str_to_num(Data[12]) Data[12][0] = EOS Kulcsok[id][13] = str_to_num(Data[13]) Data[13][0] = EOS SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Ladak"), Text, charsmax(Text)) parse(Text, Data[0], 7, Data[1], 7, Data[2], 7, Data[3], 7, Data[4], 7, Data[5], 7, Data[6], 7, Data[7], 7, Data[8], 7, Data[9], 7, Data[10], 7, Data[11], 7, Data[12], 7) Text[0] = EOS Ladak[id][0] = str_to_num(Data[0]) Data[0][0] = EOS Ladak[id][1] = str_to_num(Data[1]) Data[1][0] = EOS Ladak[id][2] = str_to_num(Data[2]) Data[2][0] = EOS Ladak[id][3] = str_to_num(Data[3]) Data[3][0] = EOS Ladak[id][4] = str_to_num(Data[4]) Data[4][0] = EOS Ladak[id][5] = str_to_num(Data[5]) Data[5][0] = EOS Ladak[id][6] = str_to_num(Data[6]) Data[6][0] = EOS Ladak[id][7] = str_to_num(Data[7]) Data[7][0] = EOS Ladak[id][8] = str_to_num(Data[8]) Data[8][0] = EOS Ladak[id][9] = str_to_num(Data[9]) Data[9][0] = EOS Ladak[id][10] = str_to_num(Data[10]) Data[10][0] = EOS Ladak[id][11] = str_to_num(Data[11]) Data[11][0] = EOS Ladak[id][12] = str_to_num(Data[12]) Data[12][0] = EOS StatTrakTool[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "StatTrak_Tool")) SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Dollar"), Dollarja[id]) } else Save_Other(id) } } /*==============================*/ /*========== MENTES ===========*/ public Save_Skins(id) { static Query[2048], Len new Text[1024] Len += formatex(Query, charsmax(Query), "INSERT INTO `GO_Skinek`(`Username`, `Skinek`, `StatTrak_Skinek`, `StatTrak_Olesek`, `Is_M4A4`, `Kivalasztva`)") formatex(Text, charsmax(Text), "0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0") Len += formatex(Query[Len], charsmax(Query)-Len, " VALUES ('%s', '%s', '%s', '%s', 0,", username[id], Text, Text, Text) Text[0] = EOS; formatex(Text, charsmax(Text), "0,0,0,0,0,0,0,0,0,0,0") Len += formatex(Query[Len], charsmax(Query)-Len, " '%s');", Text) SQL_ThreadQuery(g_SqlTuple, "QuerySaveSkins", Query) } public QuerySaveSkins(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) { if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED) { log_amx("[Skinek Mentese] Hiba: %s", Error) return } } public Save_Other(id) { static Query[2048], Len new Text[512] Len += formatex(Query, charsmax(Query), "INSERT INTO `GO_Egyebek`(`Username`, `Ladak`, `Kulcsok`, `Dollar`, `StatTrak_Tool`)") formatex(Text, charsmax(Text), "0,0,0,0,0,0,0,0,0,0,0,0,0") Len += formatex(Query[Len], charsmax(Query)-Len, " VALUES ('%s', '%s',", username[id], Text) formatex(Text, charsmax(Text), "0,0,0,0,0,0,0,0,0,0,0,0,0,0") Len += formatex(Query[Len], charsmax(Query)-Len, " '%s', 0, 0);", Text) SQL_ThreadQuery(g_SqlTuple, "QuerySaveOther", Query) } public QuerySaveOther(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) { if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED) { log_amx("[Egyebek Mentese] Hiba: %s", Error) return } } /*=============================*/ /*======== FRISSITES ==========*/ public Update_SQL(id) { static Query[10240], Len; static Text[2048], Hossz; Query[0] = EOS; Len = 0; Len += formatex(Query, charsmax(Query), "UPDATE `GO_Skinek` SET") Hossz+=formatex(Text, charsmax(Text), "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", Skinjei[id][0], Skinjei[id][1], Skinjei[id][2], Skinjei[id][3], Skinjei[id][4], Skinjei[id][5], Skinjei[id][6], Skinjei[id][7], Skinjei[id][8], Skinjei[id][9]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", Skinjei[id][10], Skinjei[id][11], Skinjei[id][12], Skinjei[id][13], Skinjei[id][14], Skinjei[id][15], Skinjei[id][16], Skinjei[id][17], Skinjei[id][18], Skinjei[id][19]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", Skinjei[id][20], Skinjei[id][21], Skinjei[id][22], Skinjei[id][23], Skinjei[id][24], Skinjei[id][25], Skinjei[id][26], Skinjei[id][27], Skinjei[id][28], Skinjei[id][29]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", Skinjei[id][30], Skinjei[id][31], Skinjei[id][32], Skinjei[id][33], Skinjei[id][34], Skinjei[id][35], Skinjei[id][36], Skinjei[id][37], Skinjei[id][38], Skinjei[id][39]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", Skinjei[id][40], Skinjei[id][41], Skinjei[id][42], Skinjei[id][43], Skinjei[id][44], Skinjei[id][45], Skinjei[id][46], Skinjei[id][47], Skinjei[id][48], Skinjei[id][49]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", Skinjei[id][50], Skinjei[id][51], Skinjei[id][52], Skinjei[id][53], Skinjei[id][54], Skinjei[id][55], Skinjei[id][56], Skinjei[id][57], Skinjei[id][58], Skinjei[id][59]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", Skinjei[id][60], Skinjei[id][61], Skinjei[id][62], Skinjei[id][63], Skinjei[id][64], Skinjei[id][65], Skinjei[id][66], Skinjei[id][67], Skinjei[id][68], Skinjei[id][69]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", Skinjei[id][70], Skinjei[id][71], Skinjei[id][72], Skinjei[id][73], Skinjei[id][74], Skinjei[id][75], Skinjei[id][76], Skinjei[id][77], Skinjei[id][78], Skinjei[id][79]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", Skinjei[id][80], Skinjei[id][81], Skinjei[id][82], Skinjei[id][83], Skinjei[id][84], Skinjei[id][85], Skinjei[id][86], Skinjei[id][87], Skinjei[id][88], Skinjei[id][89]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", Skinjei[id][90], Skinjei[id][91], Skinjei[id][92], Skinjei[id][93], Skinjei[id][94], Skinjei[id][95], Skinjei[id][96], Skinjei[id][97], Skinjei[id][98], Skinjei[id][99]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", Skinjei[id][100], Skinjei[id][101], Skinjei[id][102], Skinjei[id][103], Skinjei[id][104], Skinjei[id][105], Skinjei[id][106], Skinjei[id][107], Skinjei[id][108], Skinjei[id][109]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", Skinjei[id][110], Skinjei[id][111], Skinjei[id][112], Skinjei[id][113], Skinjei[id][114], Skinjei[id][115], Skinjei[id][116], Skinjei[id][117], Skinjei[id][118], Skinjei[id][119]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", Skinjei[id][120], Skinjei[id][121], Skinjei[id][122], Skinjei[id][123], Skinjei[id][124], Skinjei[id][125], Skinjei[id][126], Skinjei[id][127], Skinjei[id][128], Skinjei[id][129]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", Skinjei[id][130], Skinjei[id][131], Skinjei[id][132], Skinjei[id][133], Skinjei[id][134], Skinjei[id][135], Skinjei[id][136], Skinjei[id][137], Skinjei[id][138], Skinjei[id][139]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", Skinjei[id][140], Skinjei[id][141], Skinjei[id][142], Skinjei[id][143], Skinjei[id][144], Skinjei[id][145], Skinjei[id][146], Skinjei[id][147], Skinjei[id][148], Skinjei[id][149]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", Skinjei[id][150], Skinjei[id][151], Skinjei[id][152], Skinjei[id][153], Skinjei[id][154], Skinjei[id][155], Skinjei[id][156], Skinjei[id][157], Skinjei[id][158], Skinjei[id][159]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d", Skinjei[id][160], Skinjei[id][161]) Hossz = 0; Len += formatex(Query[Len], charsmax(Query)-Len, "`Skinek` = '%s',", Text) Text[0] = EOS; Hossz+=formatex(Text, charsmax(Text), "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", StatTrakSkinjei[id][0], StatTrakSkinjei[id][1], StatTrakSkinjei[id][2], StatTrakSkinjei[id][3], StatTrakSkinjei[id][4], StatTrakSkinjei[id][5], StatTrakSkinjei[id][6], StatTrakSkinjei[id][7], StatTrakSkinjei[id][8], StatTrakSkinjei[id][9]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", StatTrakSkinjei[id][10], StatTrakSkinjei[id][11], StatTrakSkinjei[id][12], StatTrakSkinjei[id][13], StatTrakSkinjei[id][14], StatTrakSkinjei[id][15], StatTrakSkinjei[id][16], StatTrakSkinjei[id][17], StatTrakSkinjei[id][18], StatTrakSkinjei[id][19]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", StatTrakSkinjei[id][20], StatTrakSkinjei[id][21], StatTrakSkinjei[id][22], StatTrakSkinjei[id][23], StatTrakSkinjei[id][24], StatTrakSkinjei[id][25], StatTrakSkinjei[id][26], StatTrakSkinjei[id][27], StatTrakSkinjei[id][28], StatTrakSkinjei[id][29]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", StatTrakSkinjei[id][30], StatTrakSkinjei[id][31], StatTrakSkinjei[id][32], StatTrakSkinjei[id][33], StatTrakSkinjei[id][34], StatTrakSkinjei[id][35], StatTrakSkinjei[id][36], StatTrakSkinjei[id][37], StatTrakSkinjei[id][38], StatTrakSkinjei[id][39]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", StatTrakSkinjei[id][40], StatTrakSkinjei[id][41], StatTrakSkinjei[id][42], StatTrakSkinjei[id][43], StatTrakSkinjei[id][44], StatTrakSkinjei[id][45], StatTrakSkinjei[id][46], StatTrakSkinjei[id][47], StatTrakSkinjei[id][48], StatTrakSkinjei[id][49]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", StatTrakSkinjei[id][50], StatTrakSkinjei[id][51], StatTrakSkinjei[id][52], StatTrakSkinjei[id][53], StatTrakSkinjei[id][54], StatTrakSkinjei[id][55], StatTrakSkinjei[id][56], StatTrakSkinjei[id][57], StatTrakSkinjei[id][58], StatTrakSkinjei[id][59]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", StatTrakSkinjei[id][60], StatTrakSkinjei[id][61], StatTrakSkinjei[id][62], StatTrakSkinjei[id][63], StatTrakSkinjei[id][64], StatTrakSkinjei[id][65], StatTrakSkinjei[id][66], StatTrakSkinjei[id][67], StatTrakSkinjei[id][68], StatTrakSkinjei[id][69]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", StatTrakSkinjei[id][70], StatTrakSkinjei[id][71], StatTrakSkinjei[id][72], StatTrakSkinjei[id][73], StatTrakSkinjei[id][74], StatTrakSkinjei[id][75], StatTrakSkinjei[id][76], StatTrakSkinjei[id][77], StatTrakSkinjei[id][78], StatTrakSkinjei[id][79]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", StatTrakSkinjei[id][80], StatTrakSkinjei[id][81], StatTrakSkinjei[id][82], StatTrakSkinjei[id][83], StatTrakSkinjei[id][84], StatTrakSkinjei[id][85], StatTrakSkinjei[id][86], StatTrakSkinjei[id][87], StatTrakSkinjei[id][88], StatTrakSkinjei[id][89]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", StatTrakSkinjei[id][90], StatTrakSkinjei[id][91], StatTrakSkinjei[id][92], StatTrakSkinjei[id][93], StatTrakSkinjei[id][94], StatTrakSkinjei[id][95], StatTrakSkinjei[id][96], StatTrakSkinjei[id][97], StatTrakSkinjei[id][98], StatTrakSkinjei[id][99]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", StatTrakSkinjei[id][100], StatTrakSkinjei[id][101], StatTrakSkinjei[id][102], StatTrakSkinjei[id][103], StatTrakSkinjei[id][104], StatTrakSkinjei[id][105], StatTrakSkinjei[id][106], StatTrakSkinjei[id][107], StatTrakSkinjei[id][108], StatTrakSkinjei[id][109]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", StatTrakSkinjei[id][110], StatTrakSkinjei[id][111], StatTrakSkinjei[id][112], StatTrakSkinjei[id][113], StatTrakSkinjei[id][114], StatTrakSkinjei[id][115], StatTrakSkinjei[id][116], StatTrakSkinjei[id][117], StatTrakSkinjei[id][118], StatTrakSkinjei[id][119]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", StatTrakSkinjei[id][120], StatTrakSkinjei[id][121], StatTrakSkinjei[id][122], StatTrakSkinjei[id][123], StatTrakSkinjei[id][124], StatTrakSkinjei[id][125], StatTrakSkinjei[id][126], StatTrakSkinjei[id][127], StatTrakSkinjei[id][128], StatTrakSkinjei[id][129]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", StatTrakSkinjei[id][130], StatTrakSkinjei[id][131], StatTrakSkinjei[id][132], StatTrakSkinjei[id][133], StatTrakSkinjei[id][134], StatTrakSkinjei[id][135], StatTrakSkinjei[id][136], StatTrakSkinjei[id][137], StatTrakSkinjei[id][138], StatTrakSkinjei[id][139]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", StatTrakSkinjei[id][140], StatTrakSkinjei[id][141], StatTrakSkinjei[id][142], StatTrakSkinjei[id][143], StatTrakSkinjei[id][144], StatTrakSkinjei[id][145], StatTrakSkinjei[id][146], StatTrakSkinjei[id][147], StatTrakSkinjei[id][148], StatTrakSkinjei[id][149]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", StatTrakSkinjei[id][150], StatTrakSkinjei[id][151], StatTrakSkinjei[id][152], StatTrakSkinjei[id][153], StatTrakSkinjei[id][154], StatTrakSkinjei[id][155], StatTrakSkinjei[id][156], StatTrakSkinjei[id][157], StatTrakSkinjei[id][158], StatTrakSkinjei[id][159]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d", StatTrakSkinjei[id][160], StatTrakSkinjei[id][161]) Hossz = 0; Len += formatex(Query[Len], charsmax(Query)-Len, "`StatTrak_Skinek` = '%s',", Text) Text[0] = EOS; Hossz+=formatex(Text, charsmax(Text), "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", StatTrakSzamlalo[id][0], StatTrakSzamlalo[id][1], StatTrakSzamlalo[id][2], StatTrakSzamlalo[id][3], StatTrakSzamlalo[id][4], StatTrakSzamlalo[id][5], StatTrakSzamlalo[id][6], StatTrakSzamlalo[id][7], StatTrakSzamlalo[id][8], StatTrakSzamlalo[id][9]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", StatTrakSzamlalo[id][10], StatTrakSzamlalo[id][11], StatTrakSzamlalo[id][12], StatTrakSzamlalo[id][13], StatTrakSzamlalo[id][14], StatTrakSzamlalo[id][15], StatTrakSzamlalo[id][16], StatTrakSzamlalo[id][17], StatTrakSzamlalo[id][18], StatTrakSzamlalo[id][19]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", StatTrakSzamlalo[id][20], StatTrakSzamlalo[id][21], StatTrakSzamlalo[id][22], StatTrakSzamlalo[id][23], StatTrakSzamlalo[id][24], StatTrakSzamlalo[id][25], StatTrakSzamlalo[id][26], StatTrakSzamlalo[id][27], StatTrakSzamlalo[id][28], StatTrakSzamlalo[id][29]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", StatTrakSzamlalo[id][30], StatTrakSzamlalo[id][31], StatTrakSzamlalo[id][32], StatTrakSzamlalo[id][33], StatTrakSzamlalo[id][34], StatTrakSzamlalo[id][35], StatTrakSzamlalo[id][36], StatTrakSzamlalo[id][37], StatTrakSzamlalo[id][38], StatTrakSzamlalo[id][39]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", StatTrakSzamlalo[id][40], StatTrakSzamlalo[id][41], StatTrakSzamlalo[id][42], StatTrakSzamlalo[id][43], StatTrakSzamlalo[id][44], StatTrakSzamlalo[id][45], StatTrakSzamlalo[id][46], StatTrakSzamlalo[id][47], StatTrakSzamlalo[id][48], StatTrakSzamlalo[id][49]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", StatTrakSzamlalo[id][50], StatTrakSzamlalo[id][51], StatTrakSzamlalo[id][52], StatTrakSzamlalo[id][53], StatTrakSzamlalo[id][54], StatTrakSzamlalo[id][55], StatTrakSzamlalo[id][56], StatTrakSzamlalo[id][57], StatTrakSzamlalo[id][58], StatTrakSzamlalo[id][59]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", StatTrakSzamlalo[id][60], StatTrakSzamlalo[id][61], StatTrakSzamlalo[id][62], StatTrakSzamlalo[id][63], StatTrakSzamlalo[id][64], StatTrakSzamlalo[id][65], StatTrakSzamlalo[id][66], StatTrakSzamlalo[id][67], StatTrakSzamlalo[id][68], StatTrakSzamlalo[id][69]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", StatTrakSzamlalo[id][70], StatTrakSzamlalo[id][71], StatTrakSzamlalo[id][72], StatTrakSzamlalo[id][73], StatTrakSzamlalo[id][74], StatTrakSzamlalo[id][75], StatTrakSzamlalo[id][76], StatTrakSzamlalo[id][77], StatTrakSzamlalo[id][78], StatTrakSzamlalo[id][79]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", StatTrakSzamlalo[id][80], StatTrakSzamlalo[id][81], StatTrakSzamlalo[id][82], StatTrakSzamlalo[id][83], StatTrakSzamlalo[id][84], StatTrakSzamlalo[id][85], StatTrakSzamlalo[id][86], StatTrakSzamlalo[id][87], StatTrakSzamlalo[id][88], StatTrakSzamlalo[id][89]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", StatTrakSzamlalo[id][90], StatTrakSzamlalo[id][91], StatTrakSzamlalo[id][92], StatTrakSzamlalo[id][93], StatTrakSzamlalo[id][94], StatTrakSzamlalo[id][95], StatTrakSzamlalo[id][96], StatTrakSzamlalo[id][97], StatTrakSzamlalo[id][98], StatTrakSzamlalo[id][99]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", StatTrakSzamlalo[id][100], StatTrakSzamlalo[id][101], StatTrakSzamlalo[id][102], StatTrakSzamlalo[id][103], StatTrakSzamlalo[id][104], StatTrakSzamlalo[id][105], StatTrakSzamlalo[id][106], StatTrakSzamlalo[id][107], StatTrakSzamlalo[id][108], StatTrakSzamlalo[id][109]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", StatTrakSzamlalo[id][110], StatTrakSzamlalo[id][111], StatTrakSzamlalo[id][112], StatTrakSzamlalo[id][113], StatTrakSzamlalo[id][114], StatTrakSzamlalo[id][115], StatTrakSzamlalo[id][116], StatTrakSzamlalo[id][117], StatTrakSzamlalo[id][118], StatTrakSzamlalo[id][119]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", StatTrakSzamlalo[id][120], StatTrakSzamlalo[id][121], StatTrakSzamlalo[id][122], StatTrakSzamlalo[id][123], StatTrakSzamlalo[id][124], StatTrakSzamlalo[id][125], StatTrakSzamlalo[id][126], StatTrakSzamlalo[id][127], StatTrakSzamlalo[id][128], StatTrakSzamlalo[id][129]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", StatTrakSzamlalo[id][130], StatTrakSzamlalo[id][131], StatTrakSzamlalo[id][132], StatTrakSzamlalo[id][133], StatTrakSzamlalo[id][134], StatTrakSzamlalo[id][135], StatTrakSzamlalo[id][136], StatTrakSzamlalo[id][137], StatTrakSzamlalo[id][138], StatTrakSzamlalo[id][139]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", StatTrakSzamlalo[id][140], StatTrakSzamlalo[id][141], StatTrakSzamlalo[id][142], StatTrakSzamlalo[id][143], StatTrakSzamlalo[id][144], StatTrakSzamlalo[id][145], StatTrakSzamlalo[id][146], StatTrakSzamlalo[id][147], StatTrakSzamlalo[id][148], StatTrakSzamlalo[id][149]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,", StatTrakSzamlalo[id][150], StatTrakSzamlalo[id][151], StatTrakSzamlalo[id][152], StatTrakSzamlalo[id][153], StatTrakSzamlalo[id][154], StatTrakSzamlalo[id][155], StatTrakSzamlalo[id][156], StatTrakSzamlalo[id][157], StatTrakSzamlalo[id][158], StatTrakSzamlalo[id][159]) Hossz+=formatex(Text[Hossz], charsmax(Text)-Hossz, "%d,%d", StatTrakSzamlalo[id][160], StatTrakSzamlalo[id][161]) Hossz = 0; Len += formatex(Query[Len], charsmax(Query)-Len, "`StatTrak_Olesek` = '%s',", Text) Text[0] = EOS; new m4a4; if(Is_M4A4[id]) m4a4 = 1 Len += formatex(Query[Len], charsmax(Query)-Len, "`Is_M4A4` = ^"%i^",", m4a4) Hossz+=formatex(Text, charsmax(Text), "%d %d %d %d %d %d %d %d %d %d %d", chosen[id][0], chosen[id][1], chosen[id][2], chosen[id][3], chosen[id][4], chosen[id][5], chosen[id][6], chosen[id][7], chosen[id][8], chosen[id][9], chosen[id][10]) Hossz = 0; Len += formatex(Query[Len], charsmax(Query)-Len, "`Kivalasztva` = '%s' WHERE `Username` = '%s';", Text, username[id]) SQL_ThreadQuery(g_SqlTuple, "QueryUpdateSkins", Query) Text[0] = EOS; Query[0] = EOS; Len = 0; Len += formatex(Query, charsmax(Query), "UPDATE `GO_Egyebek` SET") formatex(Text, charsmax(Text), "%d %d %d %d %d %d %d %d %d %d %d %d %d", Ladak[id][0], Ladak[id][1], Ladak[id][2], Ladak[id][3], Ladak[id][4], Ladak[id][5], Ladak[id][6], Ladak[id][7], Ladak[id][8], Ladak[id][9], Ladak[id][10], Ladak[id][11], Ladak[id][12]) Len += formatex(Query[Len], charsmax(Query)-Len, "`Ladak` = '%s',", Text) Text[0] = EOS; formatex(Text, charsmax(Text), "%d %d %d %d %d %d %d %d %d %d %d %d %d %d", Kulcsok[id][0], Kulcsok[id][1], Kulcsok[id][2], Kulcsok[id][3], Kulcsok[id][4], Kulcsok[id][5], Kulcsok[id][6], Kulcsok[id][7], Kulcsok[id][8], Kulcsok[id][9], Kulcsok[id][10], Kulcsok[id][11], Kulcsok[id][12], Kulcsok[id][13]) Len += formatex(Query[Len], charsmax(Query)-Len, "`Kulcsok` = '%s',", Text) Text[0] = EOS; new dollar[8]; formatex(dollar, charsmax(dollar), "%.2f", Dollarja[id]) Len += formatex(Query[Len], charsmax(Query)-Len, "`Dollar` = '%s',`StatTrak_Tool` = '%i' WHERE `Username` = '%s';", dollar, StatTrakTool[id], username[id]) SQL_ThreadQuery(g_SqlTuple, "QueryUpdateOther", Query) } public QueryUpdateSkins(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) { if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED) { log_amx("[Skinek Frissitese] Hiba: %s", Error) return } } public QueryUpdateOther(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) { if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED) { log_amx("[Egyebek Frissitese] Hiba: %s", Error) return } }
_________________
|
|