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