Sziasztok, azzal a kérdéssel fordulok hozzátok, hogy van a szerverem amin van egy saját mód és ezzel a saját móddal az a gond, hogy néha pár embernek nem tölt be.. Van olyan hogy a fegyvereket nem tölti be és a lecsatlakozáskor ráupdatel az adott SQL sorra és így az összes fegyverek eltűnnek.. Mi lehet a probléma? Aki tudna segíteni annak megköszönném, és menne a pacsi
Kód: public Load_User_Data(id) { new Data[2]; Data[0] = id; Data[1] = get_user_userid(id);
formatex(Query, charsmax(Query), "SELECT * FROM `shedimod` WHERE `User_Id` = %d;", ska_get_user_id(id)); SQL_ThreadQuery(g_SqlTuple, "QuerySelectData", Query, Data, 2); }
public QuerySelectData(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) { if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED) { log_amx("%s", Error); return; } else { new id = Data[0]; if( Data[1] != get_user_userid(id) ) return; if(SQL_NumRows(Query) > 0) { SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Dollars"), g_dollar[id]); g_Tools[0][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "STTool")); g_Tools[1][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Nevcedula")); Kulcs[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Kulcs")); oles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "oles")); NyOles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "NyOles")); szinesmenu[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "SzinesFomenu")); hl[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "halal")); g_VipTime[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "VipIdo")); SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Exp"), Player[id][EXP]); Player[id][SSzint] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "KSzint"));
hs[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "fejloves")); g_Admin_Level[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Admin_Szint")); Player_Vip[id][v_moneydrop] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "moneydrop")); Player_Vip[id][v_casedrop] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "casedrop")); Player_Vip[id][v_keydrop] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "keydrop")); // VanPrefix[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "vanprefix")); // if(VanPrefix[id] == 1) // { // SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "prefixneve" ), g_Chat_Prefix[id], charsmax(g_Chat_Prefix[])); // } for(new i;i < LADASZAM; i++) { new String[64]; formatex(String, charsmax(String), "Case%d", i); Lada[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String)); }
// Selectedgun[AK47][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Skin0")); // Selectedgun[M4A1][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Skin1")); // Selectedgun[AWP][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Skin2")); // Selectedgun[DEAGLE][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Skin3")); // Selectedgun[KNIFE][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Skin4"));
//Selectedgun[AK47][id] = SelectedStatTrak[0][id] //Selectedgun[M4A1][id] = SelectedStatTrak[1][id] //Selectedgun[AWP][id] = SelectedStatTrak[2][id] //Selectedgun[DEAGLE][id] = SelectedStatTrak[3][id] //Selectedgun[KNIFE][id] = SelectedStatTrak[4][id]
Set_Permissions(id);
//sql_account_load_nametag(id) sql_account_load_wea(id); //sql_account_load_st(id) sql_account_load_kuldik(id); //sql_account_load_teszters(id); //sql_account_load_stk(id) } else { Save_Profile(id); sql_create_nametag_row(id); sql_create_weapon_row(id); sql_create_st_row(id) sql_create_stk_row(id) sql_create_kuldik_row(id) } } } public Load_User_Skin(id) { new Data[2]; Data[0] = id; Data[1] = get_user_userid(id);
formatex(Query, charsmax(Query), "SELECT * FROM `shedi_skin` WHERE `User_Id` = %d;", ska_get_user_id(id)); SQL_ThreadQuery(g_SqlTuple, "QuerySelectDataSkin", Query, Data, 2); }
public QuerySelectDataSkin(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) { if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED) { log_amx("%s", Error); return; } else { new id = Data[0]; if( Data[1] != get_user_userid(id) ) return; if(SQL_NumRows(Query) > 0) { Selectedgun[AK47][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Skin0")); Selectedgun[M4A1][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Skin1")); Selectedgun[AWP][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Skin2")); Selectedgun[DEAGLE][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Skin3")); Selectedgun[KNIFE][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Skin4")); } else sql_create_skin_row(id); } } public sql_create_skin_row(id){ formatex(Query, charsmax(Query), "INSERT INTO `shedi_skin` (`User_Id`) VALUES (%d);", ska_get_user_id(id)); SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query); } public sql_account_load_nametag(id) { new len = 0 len += format(Query[len], 2048, "SELECT * FROM shedi_nevcedula ") len += format(Query[len], 2048-len,"WHERE User_Id = '%d'", ska_get_user_id(id)) new szData[2]; szData[0] = id; szData[1] = get_user_userid(id);
SQL_ThreadQuery(g_SqlTuple,"sql_account_load_name_thread", Query, szData, 2) } public sql_account_load_name_thread(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 ; if(SQL_NumRows(Query)){ for(new i;i < FEGYO; i++) { new String[64]; formatex(String, charsmax(String), "fegyvernev_%d", i); SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String), g_GunNames[i][id], charsmax(g_GunNames[])); } } else sql_create_nametag_row(id)
} } public sql_create_nametag_row(id){ formatex(Query, charsmax(Query), "INSERT INTO `shedi_nevcedula` (`User_Id`) VALUES (%d);", ska_get_user_id(id)); SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query); }
public sql_account_load_wea(id) { new len = 0
len += format(Query[len], 2048, "SELECT * FROM shedi_fegyo ") len += format(Query[len], 2048-len,"WHERE User_Id = '%d'", ska_get_user_id(id)) new szData[2]; szData[0] = id; szData[1] = get_user_userid(id);
SQL_ThreadQuery(g_SqlTuple,"sql_account_load_wea_thread", Query, szData, 2) } public sql_account_load_wea_thread(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 ; if(SQL_NumRows(Query)){ for(new i;i < FEGYO; i++) { new String[64]; formatex(String, charsmax(String), "F_%d", i); g_Weapons[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String)); } } else sql_create_weapon_row(id);
} }
public sql_create_weapon_row(id){ formatex(Query, charsmax(Query), "INSERT INTO `shedi_fegyo` (`User_Id`) VALUES (%d);", ska_get_user_id(id)); SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query); } public sql_create_tester_row(id){ formatex(Query, charsmax(Query), "INSERT INTO `shedi_testers` (`User_Id`,`Name`) VALUES (%d, ^"%s^");", ska_get_user_id(id), name[id]); SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query); } public sql_account_load_st(id) { new len = 0
len += format(Query[len], 2048, "SELECT * FROM shedi_stattrak ") len += format(Query[len], 2048-len,"WHERE User_Id = '%d'", ska_get_user_id(id)) new szData[2]; szData[0] = id; szData[1] = get_user_userid(id);
SQL_ThreadQuery(g_SqlTuple,"sql_account_load_st_thread", Query, szData, 2) } public sql_account_load_st_thread(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 ; if(SQL_NumRows(Query)){ for(new i;i < FEGYO; i++) { new String[64]; formatex(String, charsmax(String), "st_%d", i); g_StatTrak[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String)); } } else sql_create_st_row(id)
} }
public sql_create_st_row(id){ formatex(Query, charsmax(Query), "INSERT INTO `shedi_stattrak` (`User_Id`) VALUES (%d);", ska_get_user_id(id)); SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query); }
public sql_account_load_stk(id) { new len = 0
len += format(Query[len], 2048, "SELECT * FROM shedi_stattrakkills ") len += format(Query[len], 2048-len,"WHERE User_Id = '%d'", ska_get_user_id(id)) new szData[2]; szData[0] = id; szData[1] = get_user_userid(id);
SQL_ThreadQuery(g_SqlTuple,"sql_account_load_stk_thread", Query, szData, 2) } public sql_account_load_stk_thread(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 ; if(SQL_NumRows(Query)){ for(new i;i < FEGYO; i++) { new String[64]; formatex(String, charsmax(String), "stkill_%d", i); g_StatTrakKills[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String)); } } else sql_create_stk_row(id) //Load_User_Vip(id); Load_User_Skin(id); fegyvermenu(id) } } public sql_create_stk_row(id){ formatex(Query, charsmax(Query), "INSERT INTO `shedi_stattrakkills` (`User_Id`) VALUES (%d);", ska_get_user_id(id)); SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query); } public sql_account_load_kuldik(id) { new len = 0
len += format(Query[len], 2048, "SELECT * FROM shedi_kuldik ") len += format(Query[len], 2048-len,"WHERE User_Id = '%d'", ska_get_user_id(id)) new szData[2]; szData[0] = id; szData[1] = get_user_userid(id);
SQL_ThreadQuery(g_SqlTuple,"sql_account_load_kuldi_thread", Query, szData, 2) } public sql_account_load_kuldi_thread(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 ; if(SQL_NumRows(Query)){ g_Quest[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "QuestH1")); g_QuestMVP[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "QuestMVP1")); g_QuestKills[0][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "QuestNeed1")); g_QuestKills[1][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "QuestHave1")); g_QuestWeapon[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "QuestWeap1")); g_QuestHead[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "QuestHead1")); g_Jutalom[0][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "JutLada1")); g_Jutalom[1][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "JutKulcs1")); g_Jutalom[3][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "JutST")); g_Jutalom[4][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "JutNC")); g_Jutalom[2][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "JutPont1")); SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "JutDoll1"), g_dollarjutalom[id]); } else sql_create_kuldik_row(id); } } public sql_create_kuldik_row(id){ formatex(Query, charsmax(Query), "INSERT INTO `shedi_kuldik` (`User_Id`) VALUES (%d);", ska_get_user_id(id)); SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query); } public sql_account_load_teszters(id) { new len = 0
len += format(Query[len], 2048, "SELECT * FROM shedi_testers ") len += format(Query[len], 2048-len,"WHERE User_Id = '%d'", ska_get_user_id(id)) new szData[2]; szData[0] = id; szData[1] = get_user_userid(id);
SQL_ThreadQuery(g_SqlTuple,"sql_account_load_t_thread", Query, szData, 2) } public sql_account_load_t_thread(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 ; if(SQL_NumRows(Query)){ g_tester[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Is_Tested")); }
} } public Update_Vip_Data(id) { new Len; Len += formatex(Query[Len], charsmax(Query), "UPDATE `DangerVip` SET isVip = ^"%i^", ",Player_Vip[id][v_isVip]); Len += formatex(Query[Len], charsmax(Query)-Len, "time = ^"%i^", ", Player_Vip[id][v_time]); Len += formatex(Query[Len], charsmax(Query)-Len, "moneydrop = ^"%i^", ", Player_Vip[id][v_moneydrop]); Len += formatex(Query[Len], charsmax(Query)-Len, "casedrop = ^"%i^", ", Player_Vip[id][v_casedrop]); Len += formatex(Query[Len], charsmax(Query)-Len, "keydrop = ^"%i^" WHERE `User_Id` = %d;", Player_Vip[id][v_keydrop], ska_get_user_id(id));
SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query); } /* public Load_regcucc(id) { new Data[2]; Data[0] = id; Data[1] = get_user_userid(id);
formatex(Query, charsmax(Query), "SELECT * FROM `blacknight_register` WHERE `Id` = %d;", ska_get_user_id(id)); SQL_ThreadQuery(g_SqlTuple, "QuerySelectData1", Query, Data, 2); }
public QuerySelectData1(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) { if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED) { log_amx("%s", Error); return; } else { new id = Data[0]; if( Data[1] != get_user_userid(id) ) return; if(SQL_NumRows(Query) > 0) { SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Registered_Date" ), g_Reg_Ido[id], charsmax(g_Reg_Ido)); SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Registered_IP" ), g_Reg_IP[id], charsmax(g_Reg_IP)); SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Registered_SteamID" ), g_Reg_ID[id], charsmax(g_Reg_ID)); //SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Registered_Name" ), g_Reg_Name[id], charsmax(g_Reg_Name)); //SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Username" ), g_Felhsz[id], charsmax(g_Felhsz)); //SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Last_Login_Name" ), g_LastL[id], charsmax(g_LastL)); }
} } */ public Save_Profile1(id){ new Data[2]; Data[0] = id; Data[1] = get_user_userid(id);
formatex(Query, charsmax(Query), "INSERT INTO `shedi_skin` (`User_Id`) VALUES (%d);", ska_get_user_id(id)); SQL_ThreadQuery(g_SqlTuple, "QuerySetDataProfile", Query, Data, 2); } public Save_Profile(id){ new Data[2]; Data[0] = id; Data[1] = get_user_userid(id);
formatex(Query, charsmax(Query), "INSERT INTO `shedimod` (`User_Id`, `gamename`) VALUES (%d, ^"%s^");", ska_get_user_id(id), name[id]); SQL_ThreadQuery(g_SqlTuple, "QuerySetDataProfile", Query, Data, 2); }
public QuerySetDataProfile(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime){ if( FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED ){ log_amx("%s", Error); return; } else{ new id = Data[0];
if(Data[1] != get_user_userid(id) ) return; } } public Update(id){ new Len; Len += formatex(Query[Len], charsmax(Query), "UPDATE `shedimod` SET "); Len += formatex(Query[Len], charsmax(Query)-Len, "Dollars = ^"%.2f^", ", g_dollar[id]); //Len += formatex(Query[Len], charsmax(Query)-Len, "gamename = ^"%s^", ", name[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "fejloves = ^"%i^", ", hs[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "NyOles = ^"%i^", ", NyOles[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "vanprefix = ^"%i^", ", VanPrefix[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "halal = ^"%i^", ", hl[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "oles = ^"%i^", ", oles[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "SzinesFomenu = ^"%i^", ", szinesmenu[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "VipIdo = ^"%i^", ", g_VipTime[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "Kulcs = ^"%i^", ", Kulcs[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "Nevcedula = ^"%i^", ", g_Tools[1][id]); Len += formatex(Query[Len], charsmax(Query)-Len, "STTool = ^"%i^", ", g_Tools[0][id]); Len += formatex(Query[Len], charsmax(Query)-Len, "Admin_Szint = ^"%i^", ", g_Admin_Level[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "KSzint = '%i', ", Player[id][SSzint]); Len += formatex(Query[Len], charsmax(Query)-Len, "Exp = ^"%.2f^", ", Player[id][EXP]); Len += formatex(Query[Len], charsmax(Query)-Len, "moneydrop = ^"%i^", ", Player_Vip[id][v_moneydrop]); Len += formatex(Query[Len], charsmax(Query)-Len, "casedrop = ^"%i^", ", Player_Vip[id][v_casedrop]); Len += formatex(Query[Len], charsmax(Query)-Len, "keydrop = ^"%i^", ", Player_Vip[id][v_keydrop]); //Len += formatex(Query[Len], charsmax(Query)-Len, "prefixneve = ^"%s^", ", g_Chat_Prefix[id]); for(new i;i < LADASZAM; i++) Len += formatex(Query[Len], charsmax(Query)-Len, "Case%d = ^"%i^", ", i, Lada[i][id]); Len += formatex(Query[Len], charsmax(Query)-Len, "oles = ^"%i^" WHERE `User_Id` = %d;", oles[id], ska_get_user_id(id)); SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query); sql_update_account3(id); Update_Skin(id); } public Load_User_Vip(id) { new Data[2]; Data[0] = id; Data[1] = get_user_userid(id);
formatex(Query, charsmax(Query), "SELECT * FROM `DangerVip` WHERE `User_Id` = %d;", ska_get_user_id(id)); SQL_ThreadQuery(g_SqlTuple, "QuerySelectVip", Query, Data, 2); } public QuerySelectVip(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) { if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED) { log_amx("%s", Error); return; } else { new id = Data[0]; if(SQL_NumRows(Query) > 0) { Player_Vip[id][v_isVip] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "isVip")); Player_Vip[id][v_time] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "time")); Player_Vip[id][v_moneydrop] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "moneydrop")); Player_Vip[id][v_casedrop] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "casedrop")); Player_Vip[id][v_keydrop] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "keydrop")); } else { new text[512]; formatex(text, charsmax(text), "INSERT INTO `DangerVip` (`User_Id`) VALUES (%i);", ska_get_user_id(id)); SQL_ThreadQuery(g_SqlTuple, "QuerySetData", text); } } } public Update_Skin(id){ new Len; Len += formatex(Query[Len], charsmax(Query), "UPDATE `shedi_skin` SET "); Len += formatex(Query[Len], charsmax(Query)-Len, "Skin0 = ^"%i^", ", Selectedgun[AK47][id]); Len += formatex(Query[Len], charsmax(Query)-Len, "Skin1 = ^"%i^", ", Selectedgun[M4A1][id]); Len += formatex(Query[Len], charsmax(Query)-Len, "Skin2 = ^"%i^", ", Selectedgun[AWP][id]); Len += formatex(Query[Len], charsmax(Query)-Len, "Skin3 = ^"%i^", ", Selectedgun[DEAGLE][id]);
Len += formatex(Query[Len], charsmax(Query)-Len, "Skin4 = ^"%i^" WHERE `User_Id` = %d;", Selectedgun[KNIFE][id], ska_get_user_id(id)); SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query); //sql_update_account1(id); //Update_Vip_Data(id); } public sql_update_account4(id){ new Len; Len += formatex(Query[Len], charsmax(Query), "UPDATE `shedi_kuldik` SET "); Len += formatex(Query[Len], charsmax(Query)-Len, "QuestH1 = '%i', ", g_Quest[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "QuestMVP1 = '%i', ", g_QuestMVP[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "QuestNeed1 = '%i', ", g_QuestKills[0][id]); Len += formatex(Query[Len], charsmax(Query)-Len, "QuestHave1 = '%i', ", g_QuestKills[1][id]); Len += formatex(Query[Len], charsmax(Query)-Len, "QuestWeap1 = '%i', ", g_QuestWeapon[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "QuestHead1 = '%i', ", g_QuestHead[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "JutLada1 = '%i', ", g_Jutalom[0][id]); Len += formatex(Query[Len], charsmax(Query)-Len, "JutKulcs1 = '%i', ", g_Jutalom[1][id]); Len += formatex(Query[Len], charsmax(Query)-Len, "JutST = '%i', ", g_Jutalom[3][id]); Len += formatex(Query[Len], charsmax(Query)-Len, "JutNC = '%i', ", g_Jutalom[4][id]); Len += formatex(Query[Len], charsmax(Query)-Len, "JutPont1 = '%i', ", g_Jutalom[2][id]);
Len += formatex(Query[Len], charsmax(Query)-Len, "JutDoll1 = ^"%.2f^" WHERE `User_Id` = %d;", g_dollarjutalom[id], ska_get_user_id(id)); SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query); } public sql_update_account1(id) { new Len; Len += formatex(Query[Len], charsmax(Query), "UPDATE `shedi_stattrak` SET "); for(new i;i < FEGYO; i++) Len += formatex(Query[Len], charsmax(Query)-Len, "st_%d = ^"%i^", ", i, g_StatTrak[i][id]);
Len += format(Query[Len], charsmax(Query)-Len,"Parameter = '0' ") Len += formatex(Query[Len], charsmax(Query)-Len, "WHERE `User_Id` = %d;", ska_get_user_id(id)); SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query); sql_update_account2(id); } public sql_update_account2(id) { new Len; Len += formatex(Query[Len], charsmax(Query), "UPDATE `shedi_stattrakkills` SET "); for(new i;i < FEGYO; i++) Len += formatex(Query[Len], charsmax(Query)-Len, "stkill_%d = ^"%i^", ", i, g_StatTrakKills[i][id]);
Len += format(Query[Len], charsmax(Query)-Len,"Parameter = '0' ") Len += formatex(Query[Len], charsmax(Query)-Len, "WHERE `User_Id` = %d;", ska_get_user_id(id)); SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query); sql_update_account3(id); } public sql_update_account3(id) { new Len; Len += formatex(Query[Len], charsmax(Query), "UPDATE `shedi_fegyo` SET "); for(new i;i < FEGYO; i++) Len += formatex(Query[Len], charsmax(Query)-Len, "F_%d = ^"%i^", ", i, g_Weapons[i][id]);
Len += format(Query[Len], charsmax(Query)-Len,"Parameter = '0' ") Len += formatex(Query[Len], charsmax(Query)-Len, "WHERE `User_Id` = %d;", ska_get_user_id(id)); SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query); //sql_update_account_nametag(id); }
public sql_update_account_nametag(id) { new Len; Len += formatex(Query[Len], charsmax(Query), "UPDATE `shedi_nevcedula` SET "); for(new i;i < FEGYO; i++) Len += formatex(Query[Len], charsmax(Query)-Len, "fegyvernev_%d = ^"%s^", ", i, g_GunNames[i][id]);
Len += format(Query[Len], charsmax(Query)-Len,"Parameter = '0' ") Len += formatex(Query[Len], charsmax(Query)-Len, "WHERE `User_Id` = %d;", ska_get_user_id(id)); SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query); sql_update_account4(id); } public sql_update_account6(id) { new Len; Len += formatex(Query[Len], charsmax(Query), "UPDATE `shedi_testers` SET "); Len += formatex(Query[Len], charsmax(Query)-Len, "Name = ^"%s^", ", name[id]);
Len += format(Query[Len], charsmax(Query)-Len,"Parameter = '0' ") Len += formatex(Query[Len], charsmax(Query)-Len, "WHERE `User_Id` = %d;", ska_get_user_id(id)); SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query); //sql_update_account1(id); }
Sok helyen azért van kivéve a sql_updates rész, mert véletlen se történjen még 1x ilyen amíg nem tudom javítani
|