Problema comanda /opencase

Sniper88 · April 14, 2018

Am bagat comanda /opencase cu tot cu keys.

Si primesc 26 de erori ca nu sunt definite : pCase , pCasex , pCaseKeyx , pCaseKeyx ...dupa ce le definesc tot nu se rezolva...nimic..imi da tot undefined symbol sau apoi invalid expression , ce e de facut?Cum sa creez ?Trebuie adaugate variabile?

valivaly96 · April 14, 2018

Acum 11 minute, Sniper88 a spus:

Am bagat comanda /opencase cu tot cu keys.

Si primesc 26 de erori ca nu sunt definite : pCase , pCasex , pCaseKeyx , pCaseKeyx ...dupa ce le definesc tot nu se rezolva...nimic..imi da tot undefined symbol sau apoi invalid expression , ce e de facut?Cum sa creez ?Trebuie adaugate variabile?

pcase il pui la enum pinfo si restu le definesti langa pcashx etc

Sniper88 · April 14, 2018

CMD:opencase(playerid, params[])
{
if(gPlayerLogged[playerid] == 0) return SendClientMessage(playerid, COLOR_LIGHTRED, "You need to login first.");
if(PlayerInfo[playerid][pKeys] == 0 && PlayerInfo[playerid][pCases] == 0)return SCM(playerid, COLOR_LIGHTRED, "Nu detii nici un key sau case!");
if(PlayerInfo[playerid][pKeys] > 0 && PlayerInfo[playerid][pCases] == 0)return SCM(playerid, COLOR_LIGHTRED, "Ai nevoie de un case pe care sa folosesti key-ul!");
if(PlayerInfo[playerid][pKeys] == 0 && PlayerInfo[playerid][pCases] > 0)return SCM(playerid, COLOR_LIGHTRED, "Ai nevoie de un key pentru a deschide case-ul!");
   PlayerInfo[playerid][pCases] -= 1;
   PlayerInfo[playerid][pKeys] -= 1;
   Update(playerid, pCasesx);
   Update(playerid, pKeysx);
   TextDrawShowForPlayer(playerid, OpenCase[0]);
   TextDrawShowForPlayer(playerid, OpenCase[1]);
   TextDrawShowForPlayer(playerid, OpenCase[2]);
   TextDrawShowForPlayer(playerid, OpenCase[3]);
   PlayerTextDrawShow(playerid, PlayerOpenCase[playerid][0]);
   PlayerTextDrawShow(playerid, PlayerOpenCase[playerid][1]);
   PlayerTextDrawShow(playerid, PlayerOpenCase[playerid][2]);
   SelectTextDraw(playerid, 0x00FF00FF);
return 1;
}

public OnPlayerClickPlayerTextDraw(playerid, PlayerText:playertextid)
{
   if(playertextid == PlayerOpenCase[playerid][0] || playertextid == PlayerOpenCase[playerid][1] || playertextid == PlayerOpenCase[playerid][2])
   {
   if(AntiSpamPrize[playerid] == 1)return SCM(playerid, COLOR_GREY, "Wait 5 seconds!");
       new prize = random(99) + 1, won_text[128];
       new randompp = random(9)+1;
       new random_money = 100000;
       random_money += random(250000);
       if(prize > 0 && prize < 10)
       {
       PlayerInfo[playerid][pPremiumPoints] += randompp;
       Update(playerid, pPremiumPointsx);
       format(won_text, sizeof(won_text), "You won %d premium points!", randompp);
       }
       if(prize >= 10 && prize < 30)
       {
       PlayerInfo[playerid][pExp] += randompp;
           Update(playerid, pRPx);
           format(won_text, sizeof(won_text), "You won %d respect points!", randompp);
       }
       if(prize >= 30 && prize < 35)
       {
           if(PlayerInfo[playerid][pPremiumAccount] == 1)
           {
           PlayerInfo[playerid][pCash] += random_money;
           Update(playerid, pCashx);
           GivePlayerCash(playerid, random_money);
           format(won_text, sizeof(won_text), "You won %s money in cash!", FormatNumber(random_money));
           }
           else
           {
           PlayerInfo[playerid][pPremiumAccount] = 1;
           Update(playerid, pPremiumAccountx);
           format(won_text, sizeof(won_text), "You won a premium account!");
           }

       }
       if(prize >= 35 && prize < 38)
       {
       if(PlayerInfo[playerid][pPcarkey] != 0 && PlayerInfo[playerid][pmotokey] != 0 && PlayerInfo[playerid][phelikey] != 0 && PlayerInfo[playerid][pprcarkey] != 0 && PlayerInfo[playerid][pprcarkey2] != 0 && PlayerInfo[playerid][pPPluscarkey2] != 0 && PlayerInfo[playerid][pPPluscarkey] != 0)
{
               PlayerInfo[playerid][pCash] += random_money;
               Update(playerid, pCashx);
               GivePlayerCash(playerid, random_money);
               format(won_text, sizeof(won_text), "You won %s money in cash!", FormatNumber(random_money));
}
else if(PlayerInfo[playerid][pPcarkey] != 0 && PlayerInfo[playerid][pmotokey] != 0 && PlayerInfo[playerid][phelikey] != 0 && PlayerInfo[playerid][pprcarkey] != 0 && PlayerInfo[playerid][pprcarkey2] != 0 && PlayerInfo[playerid][pPlusSlot2] == 0 && PlayerInfo[playerid][pPlusSlot1] == 0)
{
PlayerInfo[playerid][pCash] += random_money;
               Update(playerid, pCashx);
               GivePlayerCash(playerid, random_money);
               format(won_text, sizeof(won_text), "You won %s money in cash!", FormatNumber(random_money));
}
else if(PlayerInfo[playerid][pPcarkey] != 0 && PlayerInfo[playerid][pmotokey] != 0 && PlayerInfo[playerid][phelikey] != 0 && PlayerInfo[playerid][pprcarkey] != 0 && PlayerInfo[playerid][pprcarkey2] != 0 && PlayerInfo[playerid][pPlusSlot2] == 0 && PlayerInfo[playerid][pPPluscarkey] != 0)
{
PlayerInfo[playerid][pCash] += random_money;
               Update(playerid, pCashx);
               GivePlayerCash(playerid, random_money);
               format(won_text, sizeof(won_text), "You won %s money in cash!", FormatNumber(random_money));
}
else if(PlayerInfo[playerid][pPcarkey] != 0 && PlayerInfo[playerid][pmotokey] != 0 && PlayerInfo[playerid][phelikey] != 0 && PlayerInfo[playerid][pprcarkey] != 0 && PlayerInfo[playerid][pprcarkey2] != 0 && PlayerInfo[playerid][pPPluscarkey2] != 0 && PlayerInfo[playerid][pPlusSlot1] != 0)
{
PlayerInfo[playerid][pCash] += random_money;
               Update(playerid, pCashx);
               GivePlayerCash(playerid, random_money);
               format(won_text, sizeof(won_text), "You won %s money in cash!", FormatNumber(random_money));
}
else if(PlayerInfo[playerid][pPcarkey] != 0 && PlayerInfo[playerid][pmotokey] != 0 && PlayerInfo[playerid][pPremiumAccount] == 0 && PlayerInfo[playerid][pPlusSlot2] == 0 && PlayerInfo[playerid][pPlusSlot1] == 0)
{
PlayerInfo[playerid][pCash] += random_money;
               Update(playerid, pCashx);
               GivePlayerCash(playerid, random_money);
               format(won_text, sizeof(won_text), "You won %s money in cash!", FormatNumber(random_money));
}
else
{
               InsertPCar(playerid,522,0,"NRG-500",1, 0);
   format(won_text, sizeof(won_text), "You won a NRG-500!");
           }
       }
       if(prize >= 38 && prize < 48)
       {
PlayerInfo[playerid][pHiddenColor] += 1;
Update(playerid, pHiddenColorx);
format(won_text, sizeof(won_text), "You won a hidden color");
       }
       if(prize >= 48 && prize <= 100)
       {
       PlayerInfo[playerid][pCash] += random_money;
       Update(playerid, pCashx);
       GivePlayerCash(playerid, random_money);
       format(won_text, sizeof(won_text), "You won %s money in cash!", FormatNumber(random_money));
       }
       SCM(playerid, COLOR_YELLOW, won_text);
       PlayerTextDrawHide(playerid, PlayerOpenCase[playerid][0]);
       PlayerTextDrawHide(playerid, PlayerOpenCase[playerid][1]);
       PlayerTextDrawHide(playerid, PlayerOpenCase[playerid][2]);
       TextDrawHideForPlayer(playerid, OpenCase[0]);
       TextDrawHideForPlayer(playerid, OpenCase[1]);
       TextDrawHideForPlayer(playerid, OpenCase[2]);
       TextDrawHideForPlayer(playerid, OpenCase[3]);
       CancelSelectTextDraw(playerid);
       AntiSpamPrize[playerid] = 1;
       SetTimerEx("GoCaseNow", 5000, false, "i", playerid);
   }
   return 1;
}
forward GoCaseNow(playerid);
public GoCaseNow(playerid)
{
   if(AntiSpamPrize[playerid] == 1)
   {
   AntiSpamPrize[playerid] = 0;
   SCM(playerid, COLOR_GREY, "You can now open an other case.");
   }
   return 1;
}

Sniper88 · April 14, 2018

Errors : undefined symbol pCases

pKeys (11 erori )ce fac?

AlexxAdv · April 14, 2018

enum pInfo {

pCases,

pKeys,

adaugi pcases si pkeys la enum pinfo

valivaly96 · April 14, 2018

Acum 3 ore, Sniper88 a spus:

Errors : undefined symbol pCases

pKeys (11 erori )ce fac?

Ti.am mai spus si mai sus Adaugi la enum pinfo --> pCases si Pkeys si cele cu x la final le definesti langa celelate cu #define daca vrei sa folosesti functia Update

Sniper88 · April 14, 2018

Am facut ce ai zis.Am mai ramas cu 4 erori :

si anume : invalid expression assumed zero,

invalid expression assumed zero,

expected token ";" but found "]",

fatal error:to many erros on this line

Liniile erori : PlayerInfo[playerid][pKeys] -= 1;
Update(playerid, pCasesx);
Update(playerid, pKeysx);
TextDrawShowForPlayer(playerid, OpenCase[0]);
TextDrawShowForPlayer(playerid, OpenCase[1]);
TextDrawShowForPlayer(playerid, OpenCase[2]);
TextDrawShowForPlayer(playerid, OpenCase[3]); CE SA FIE GRESIT?

custura · April 14, 2018

Acum 37 minute, Sniper88 a spus:

Am facut ce ai zis.Am mai ramas cu 4 erori :

si anume : invalid expression assumed zero,

invalid expression assumed zero,

expected token ";" but found "]",

fatal error:to many erros on this line

Liniile erori : PlayerInfo[playerid][pKeys] -= 1;
Update(playerid, pCasesx);
Update(playerid, pKeysx);
TextDrawShowForPlayer(playerid, OpenCase[0]);
TextDrawShowForPlayer(playerid, OpenCase[1]);
TextDrawShowForPlayer(playerid, OpenCase[2]);
TextDrawShowForPlayer(playerid, OpenCase[3]); CE SA FIE GRESIT?

Da toata functia, nu doar la ce ai erori, sau cel putin pune linia de deasupra la:PlayerInfo[playerid][pKeys] -= 1;

Sniper88 · April 14, 2018

Chiar acum, custura a spus:

Da toata functia, nu doar la ce ai erori, sau cel putin pune linia de deasupra la:PlayerInfo[playerid][pKeys] -= 1;

CMD:opencase(playerid, params[])
{
if(gPlayerLogged[playerid] == 0) return SendClientMessage(playerid, COLOR_LIGHTRED, "You need to login first.");
if(PlayerInfo[playerid][pKeys] == 0 && PlayerInfo[playerid][pCases] == 0)return SCM(playerid, COLOR_LIGHTRED, "Nu detii nici un key sau case!");
if(PlayerInfo[playerid][pKeys] > 0 && PlayerInfo[playerid][pCases] == 0)return SCM(playerid, COLOR_LIGHTRED, "Ai nevoie de un case pe care sa folosesti key-ul!");
if(PlayerInfo[playerid][pKeys] == 0 && PlayerInfo[playerid][pCases] > 0)return SCM(playerid, COLOR_LIGHTRED, "Ai nevoie de un key pentru a deschide case-ul!");
   PlayerInfo[playerid][pCases] -= 1;
   PlayerInfo[playerid][pKeys] -= 1;
   Update(playerid, pCasesx);
   Update(playerid, pKeysx);
   TextDrawShowForPlayer(playerid, OpenCase[0]);
   TextDrawShowForPlayer(playerid, OpenCase[1]);
   TextDrawShowForPlayer(playerid, OpenCase[2]);
   TextDrawShowForPlayer(playerid, OpenCase[3]);
   PlayerTextDrawShow(playerid, PlayerOpenCase[playerid][0]);
   PlayerTextDrawShow(playerid, PlayerOpenCase[playerid][1]);
   PlayerTextDrawShow(playerid, PlayerOpenCase[playerid][2]);
   SelectTextDraw(playerid, 0x00FF00FF);
return 1;
}

public OnPlayerClickPlayerTextDraw(playerid, PlayerText:playertextid)
{
   if(playertextid == PlayerOpenCase[playerid][0] || playertextid == PlayerOpenCase[playerid][1] || playertextid == PlayerOpenCase[playerid][2])
   {
   if(AntiSpamPrize[playerid] == 1)return SCM(playerid, COLOR_GREY, "Wait 5 seconds!");
       new prize = random(99) + 1, won_text[128];
       new randompp = random(9)+1;
       new random_money = 100000;
       random_money += random(250000);
       if(prize > 0 && prize < 10)
       {
       PlayerInfo[playerid][pPremiumPoints] += randompp;
       Update(playerid, pPremiumPointsx);
       format(won_text, sizeof(won_text), "You won %d premium points!", randompp);
       }
       if(prize >= 10 && prize < 30)
       {
       PlayerInfo[playerid][pExp] += randompp;
           Update(playerid, pRPx);
           format(won_text, sizeof(won_text), "You won %d respect points!", randompp);
       }
       if(prize >= 30 && prize < 35)
       {
           if(PlayerInfo[playerid][pPremiumAccount] == 1)
           {
           PlayerInfo[playerid][pCash] += random_money;
           Update(playerid, pCashx);
           GivePlayerCash(playerid, random_money);
           format(won_text, sizeof(won_text), "You won %s money in cash!", FormatNumber(random_money));
           }
           else
           {
           PlayerInfo[playerid][pPremiumAccount] = 1;
           Update(playerid, pPremiumAccountx);
           format(won_text, sizeof(won_text), "You won a premium account!");
           }

       }
       if(prize >= 35 && prize < 38)
       {
       if(PlayerInfo[playerid][pPcarkey] != 0 && PlayerInfo[playerid][pmotokey] != 0 && PlayerInfo[playerid][phelikey] != 0 && PlayerInfo[playerid][pprcarkey] != 0 && PlayerInfo[playerid][pprcarkey2] != 0 && PlayerInfo[playerid][pPPluscarkey2] != 0 && PlayerInfo[playerid][pPPluscarkey] != 0)
{
               PlayerInfo[playerid][pCash] += random_money;
               Update(playerid, pCashx);
               GivePlayerCash(playerid, random_money);
               format(won_text, sizeof(won_text), "You won %s money in cash!", FormatNumber(random_money));
}
else if(PlayerInfo[playerid][pPcarkey] != 0 && PlayerInfo[playerid][pmotokey] != 0 && PlayerInfo[playerid][phelikey] != 0 && PlayerInfo[playerid][pprcarkey] != 0 && PlayerInfo[playerid][pprcarkey2] != 0 && PlayerInfo[playerid][pPlusSlot2] == 0 && PlayerInfo[playerid][pPlusSlot1] == 0)
{
PlayerInfo[playerid][pCash] += random_money;
               Update(playerid, pCashx);
               GivePlayerCash(playerid, random_money);
               format(won_text, sizeof(won_text), "You won %s money in cash!", FormatNumber(random_money));
}
else if(PlayerInfo[playerid][pPcarkey] != 0 && PlayerInfo[playerid][pmotokey] != 0 && PlayerInfo[playerid][phelikey] != 0 && PlayerInfo[playerid][pprcarkey] != 0 && PlayerInfo[playerid][pprcarkey2] != 0 && PlayerInfo[playerid][pPlusSlot2] == 0 && PlayerInfo[playerid][pPPluscarkey] != 0)
{
PlayerInfo[playerid][pCash] += random_money;
               Update(playerid, pCashx);
               GivePlayerCash(playerid, random_money);
               format(won_text, sizeof(won_text), "You won %s money in cash!", FormatNumber(random_money));
}
else if(PlayerInfo[playerid][pPcarkey] != 0 && PlayerInfo[playerid][pmotokey] != 0 && PlayerInfo[playerid][phelikey] != 0 && PlayerInfo[playerid][pprcarkey] != 0 && PlayerInfo[playerid][pprcarkey2] != 0 && PlayerInfo[playerid][pPPluscarkey2] != 0 && PlayerInfo[playerid][pPlusSlot1] != 0)
{
PlayerInfo[playerid][pCash] += random_money;
               Update(playerid, pCashx);
               GivePlayerCash(playerid, random_money);
               format(won_text, sizeof(won_text), "You won %s money in cash!", FormatNumber(random_money));
}
else if(PlayerInfo[playerid][pPcarkey] != 0 && PlayerInfo[playerid][pmotokey] != 0 && PlayerInfo[playerid][pPremiumAccount] == 0 && PlayerInfo[playerid][pPlusSlot2] == 0 && PlayerInfo[playerid][pPlusSlot1] == 0)
{
PlayerInfo[playerid][pCash] += random_money;
               Update(playerid, pCashx);
               GivePlayerCash(playerid, random_money);
               format(won_text, sizeof(won_text), "You won %s money in cash!", FormatNumber(random_money));
}
else
{
               InsertPCar(playerid,522,0,"NRG-500",1, 0);
   format(won_text, sizeof(won_text), "You won a NRG-500!");
           }
       }
       if(prize >= 38 && prize < 48)
       {
PlayerInfo[playerid][pHiddenColor] += 1;
Update(playerid, pHiddenColorx);
format(won_text, sizeof(won_text), "You won a hidden color");
       }
       if(prize >= 48 && prize <= 100)
       {
       PlayerInfo[playerid][pCash] += random_money;
       Update(playerid, pCashx);
       GivePlayerCash(playerid, random_money);
       format(won_text, sizeof(won_text), "You won %s money in cash!", FormatNumber(random_money));
       }
       SCM(playerid, COLOR_YELLOW, won_text);
       PlayerTextDrawHide(playerid, PlayerOpenCase[playerid][0]);
       PlayerTextDrawHide(playerid, PlayerOpenCase[playerid][1]);
       PlayerTextDrawHide(playerid, PlayerOpenCase[playerid][2]);
       TextDrawHideForPlayer(playerid, OpenCase[0]);
       TextDrawHideForPlayer(playerid, OpenCase[1]);
       TextDrawHideForPlayer(playerid, OpenCase[2]);
       TextDrawHideForPlayer(playerid, OpenCase[3]);
       CancelSelectTextDraw(playerid);
       AntiSpamPrize[playerid] = 1;
       SetTimerEx("GoCaseNow", 5000, false, "i", playerid);
   }
   return 1;
}
forward GoCaseNow(playerid);
public GoCaseNow(playerid)
{
   if(AntiSpamPrize[playerid] == 1)
   {
   AntiSpamPrize[playerid] = 0;
   SCM(playerid, COLOR_GREY, "You can now open an other case.");
   }
   return 1;
}

valivaly96 · April 14, 2018

Acum 43 minute, Sniper88 a spus:

Am facut ce ai zis.Am mai ramas cu 4 erori :

si anume : invalid expression assumed zero,

invalid expression assumed zero,

expected token ";" but found "]",

fatal error:to many erros on this line

Liniile erori : PlayerInfo[playerid][pKeys] -= 1;
Update(playerid, pCasesx);
Update(playerid, pKeysx);
TextDrawShowForPlayer(playerid, OpenCase[0]);
TextDrawShowForPlayer(playerid, OpenCase[1]);
TextDrawShowForPlayer(playerid, OpenCase[2]);
TextDrawShowForPlayer(playerid, OpenCase[3]); CE SA FIE GRESIT?

functia update este in gm sau include?

Sniper88 · April 14, 2018

Chiar acum, valivaly96 a spus:

functia update este in gm sau include?

in include sigur nu este , in gm ma uit , trebuie sa fie adaugata?daca da , cum o adaug?

custura · April 14, 2018

Chiar acum, Sniper88 a spus:

in include sigur nu este , in gm ma uit , trebuie sa fie adaugata?daca da , cum o adaug?

Daca nu era adaugata, iti dadea eroare, sigur o ai asa: public Update(playerid, type)

pt ca toate gm-urile de pe net is asa, copy/paste unul cu altul, dar vezi cum e facut la tine public Update

Daca e cum l-am scris eu mai sus

Sniper88 · April 14, 2018

Acum 1 minut, custura a spus:

Daca nu era adaugata, iti dadea eroare, sigur o ai asa: public Update(playerid, type)

pt ca toate gm-urile de pe net is asa, copy/paste unul cu altul, dar vezi cum e facut la tine public Update

Daca e cum l-am scris eu mai sus

Da asa o am

custura · April 14, 2018

PlayerInfo[playerid][pCases] -= 1;
PlayerInfo[playerid][pKeys] -= 1;
Update(playerid, pCasesx);
Update(playerid, pKeysx);

pCases la enum pInfo sau cum ai tu e scris exact asa? acelasi lucru si la pKeys

Verifica la functia Update daca ai facut pasi pt update la pCasesx si la pKeys

Cam asta ar putea fi problema.

Poti lasa functia Update aici sa o verific

Edited April 14, 2018 by custura
Pune functia update

Sniper88 · April 14, 2018

Acum 1 minut, custura a spus:

PlayerInfo[playerid][pCases] -= 1;
PlayerInfo[playerid][pKeys] -= 1;
Update(playerid, pCasesx);
Update(playerid, pKeysx);

pCases la enum pInfo sau cum ai tu e scris exact asa? acelasi lucru si la pKeys

Verifica la functia Update daca ai facut pasi pt update la pCasesx si la pKeys

Cam asta ar putea fi problema.

la enum pInfo e pus asa : pCases,

pKeys .....

la functia update nu am facut pasii ...trb acolo?

Sniper88 · April 14, 2018

Acum 3 minute, custura a spus:

PlayerInfo[playerid][pCases] -= 1;
PlayerInfo[playerid][pKeys] -= 1;
Update(playerid, pCasesx);
Update(playerid, pKeysx);

pCases la enum pInfo sau cum ai tu e scris exact asa? acelasi lucru si la pKeys

Verifica la functia Update daca ai facut pasi pt update la pCasesx si la pKeys

Cam asta ar putea fi problema.

Poti lasa functia Update aici sa o verific

public Update(playerid, type)
{
   if(IsPlayerConnected(playerid))
   {
       new var[356];
       {
           switch(type)
           {
               case pCashx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Money`='%d' WHERE `name`='%s'",GetPlayerCash(playerid), PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pRP:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Respect`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pExp], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pBank:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Bank`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pAccount], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pCarLicTx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `CarLicT`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pCarLicT], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pCarLicSuspendx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `CarLicSuspend`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pCarLicSuspend], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pGunLicSuspendx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `GunLicSuspend`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pGunLicSuspend], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pFlyLicTx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `FlyLicT`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pFlyLicT], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pBoatLicTx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `BoatLicT`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pBoatLicT], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pGunLicTx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `GunLicT`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pGunLicT], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pRobx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Rob`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pRob], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pFpunishx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `FPunish`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pFpunish], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pLawyerx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Acceptpoints`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pLawyer], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pConnectTimex:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `ConnectedTime`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pConnectTime], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pPayDayx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `PayDay`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPayDay], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pPayCheckx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Paycheck`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPayCheck], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pPhousekeyx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `House`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPhousekey], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pJailedx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Jailed`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pJailed], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pJailTimex:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `JailTime`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pJailTime], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pWantedLevelx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `WantedLevel`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pWantedLevel], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pPhonex:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Phone`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPhone], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pMatsx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Materials`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pMats], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pFishesx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Fishes`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pFishes], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pFishSkillx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `FishSkill`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pFishSkill], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pSpawnChangex:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `SpawnChange`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pSpawnChange], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pRobSkillx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `RobSkill`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pRobSkill], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pTruckSkillx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `TruckSkill`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pTruckSkill], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pTruckTimesx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `TruckTimes`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pTruckTimes], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pTruckRemx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `TruckRem`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pTruckRem], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pPizzaSkillx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `PizzaSkill`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPizzaSkill], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pPizzaTimesx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `PizzaTimes`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPizzaTimes], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pPizzaRemx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `PizzaRem`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPizzaRem], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pArmsSkillx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `ArmsSkill`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pArmsSkill], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pArmsTimesx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `ArmsTimes`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pArmsTimes], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pArmsRemx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `ArmsRem`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pArmsRem], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pBusSkillx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `BusSkill`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pBusSkill], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pBusTimesx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `BusTimes`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pBusTimes], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pBusRemx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `BusRem`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pBusRem], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pFarmSkillx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `FarmSkill`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pFarmSkill], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }

custura · April 14, 2018

Acum 6 minute, Sniper88 a spus:

public Update(playerid, type)
{
   if(IsPlayerConnected(playerid))
   {
       new var[356];
       {
           switch(type)
           {
               case pCashx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Money`='%d' WHERE `name`='%s'",GetPlayerCash(playerid), PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pRP:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Respect`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pExp], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pBank:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Bank`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pAccount], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pCarLicTx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `CarLicT`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pCarLicT], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pCarLicSuspendx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `CarLicSuspend`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pCarLicSuspend], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pGunLicSuspendx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `GunLicSuspend`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pGunLicSuspend], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pFlyLicTx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `FlyLicT`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pFlyLicT], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pBoatLicTx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `BoatLicT`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pBoatLicT], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pGunLicTx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `GunLicT`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pGunLicT], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pRobx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Rob`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pRob], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pFpunishx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `FPunish`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pFpunish], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pLawyerx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Acceptpoints`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pLawyer], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pConnectTimex:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `ConnectedTime`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pConnectTime], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pPayDayx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `PayDay`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPayDay], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pPayCheckx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Paycheck`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPayCheck], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pPhousekeyx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `House`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPhousekey], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pJailedx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Jailed`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pJailed], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pJailTimex:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `JailTime`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pJailTime], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pWantedLevelx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `WantedLevel`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pWantedLevel], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pPhonex:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Phone`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPhone], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pMatsx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Materials`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pMats], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pFishesx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Fishes`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pFishes], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pFishSkillx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `FishSkill`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pFishSkill], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pSpawnChangex:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `SpawnChange`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pSpawnChange], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pRobSkillx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `RobSkill`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pRobSkill], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pTruckSkillx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `TruckSkill`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pTruckSkill], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pTruckTimesx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `TruckTimes`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pTruckTimes], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pTruckRemx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `TruckRem`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pTruckRem], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pPizzaSkillx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `PizzaSkill`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPizzaSkill], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pPizzaTimesx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `PizzaTimes`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPizzaTimes], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pPizzaRemx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `PizzaRem`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPizzaRem], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pArmsSkillx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `ArmsSkill`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pArmsSkill], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pArmsTimesx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `ArmsTimes`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pArmsTimes], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pArmsRemx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `ArmsRem`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pArmsRem], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pBusSkillx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `BusSkill`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pBusSkill], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pBusTimesx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `BusTimes`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pBusTimes], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pBusRemx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `BusRem`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pBusRem], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }
               case pFarmSkillx:
               {
                   mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `FarmSkill`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pFarmSkill], PlayerInfo[playerid][pNormalName]);
                   mysql_tquery(SQL,var,"","");
               }

public Update(playerid, type)
{
if(IsPlayerConnected(playerid))
{
new var[356];
{
switch(type)
{
case pCashx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Money`='%d' WHERE `name`='%s'",GetPlayerCash(playerid), PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pRP:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Respect`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pExp], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}

               case pCasesx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Cases`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pCases], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}

               case pKeysx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Keys`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pKeys], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}

case pBank:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Bank`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pAccount], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pCarLicTx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `CarLicT`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pCarLicT], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pCarLicSuspendx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `CarLicSuspend`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pCarLicSuspend], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pGunLicSuspendx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `GunLicSuspend`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pGunLicSuspend], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pFlyLicTx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `FlyLicT`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pFlyLicT], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pBoatLicTx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `BoatLicT`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pBoatLicT], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pGunLicTx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `GunLicT`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pGunLicT], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pRobx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Rob`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pRob], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pFpunishx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `FPunish`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pFpunish], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pLawyerx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Acceptpoints`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pLawyer], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pConnectTimex:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `ConnectedTime`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pConnectTime], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pPayDayx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `PayDay`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPayDay], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pPayCheckx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Paycheck`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPayCheck], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pPhousekeyx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `House`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPhousekey], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pJailedx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Jailed`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pJailed], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pJailTimex:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `JailTime`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pJailTime], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pWantedLevelx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `WantedLevel`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pWantedLevel], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pPhonex:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Phone`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPhone], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pMatsx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Materials`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pMats], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pFishesx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Fishes`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pFishes], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pFishSkillx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `FishSkill`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pFishSkill], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pSpawnChangex:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `SpawnChange`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pSpawnChange], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pRobSkillx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `RobSkill`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pRobSkill], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pTruckSkillx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `TruckSkill`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pTruckSkill], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pTruckTimesx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `TruckTimes`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pTruckTimes], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pTruckRemx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `TruckRem`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pTruckRem], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pPizzaSkillx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `PizzaSkill`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPizzaSkill], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pPizzaTimesx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `PizzaTimes`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPizzaTimes], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pPizzaRemx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `PizzaRem`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPizzaRem], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pArmsSkillx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `ArmsSkill`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pArmsSkill], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pArmsTimesx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `ArmsTimes`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pArmsTimes], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pArmsRemx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `ArmsRem`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pArmsRem], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pBusSkillx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `BusSkill`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pBusSkill], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pBusTimesx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `BusTimes`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pBusTimes], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pBusRemx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `BusRem`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pBusRem], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pFarmSkillx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `FarmSkill`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pFarmSkill], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}

ACUM SA ITI PUI TU IN BAZA DE DATE Cases si Keys la users

Edited April 14, 2018 by custura

Sniper88 · April 14, 2018

Acum 7 minute, custura a spus:

public Update(playerid, type)
{
if(IsPlayerConnected(playerid))
{
new var[356];
{
switch(type)
{
case pCashx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Money`='%d' WHERE `name`='%s'",GetPlayerCash(playerid), PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pRP:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Respect`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pExp], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}

               case pCasesx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Cases`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pCases], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}

               case pKeysx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Keys`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pKeys], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}

case pBank:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Bank`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pAccount], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pCarLicTx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `CarLicT`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pCarLicT], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pCarLicSuspendx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `CarLicSuspend`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pCarLicSuspend], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pGunLicSuspendx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `GunLicSuspend`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pGunLicSuspend], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pFlyLicTx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `FlyLicT`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pFlyLicT], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pBoatLicTx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `BoatLicT`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pBoatLicT], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pGunLicTx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `GunLicT`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pGunLicT], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pRobx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Rob`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pRob], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pFpunishx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `FPunish`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pFpunish], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pLawyerx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Acceptpoints`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pLawyer], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pConnectTimex:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `ConnectedTime`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pConnectTime], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pPayDayx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `PayDay`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPayDay], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pPayCheckx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Paycheck`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPayCheck], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pPhousekeyx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `House`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPhousekey], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pJailedx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Jailed`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pJailed], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pJailTimex:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `JailTime`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pJailTime], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pWantedLevelx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `WantedLevel`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pWantedLevel], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pPhonex:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Phone`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPhone], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pMatsx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Materials`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pMats], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pFishesx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Fishes`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pFishes], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pFishSkillx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `FishSkill`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pFishSkill], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pSpawnChangex:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `SpawnChange`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pSpawnChange], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pRobSkillx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `RobSkill`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pRobSkill], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pTruckSkillx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `TruckSkill`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pTruckSkill], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pTruckTimesx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `TruckTimes`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pTruckTimes], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pTruckRemx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `TruckRem`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pTruckRem], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pPizzaSkillx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `PizzaSkill`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPizzaSkill], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pPizzaTimesx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `PizzaTimes`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPizzaTimes], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pPizzaRemx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `PizzaRem`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPizzaRem], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pArmsSkillx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `ArmsSkill`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pArmsSkill], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pArmsTimesx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `ArmsTimes`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pArmsTimes], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pArmsRemx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `ArmsRem`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pArmsRem], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pBusSkillx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `BusSkill`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pBusSkill], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pBusTimesx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `BusTimes`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pBusTimes], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pBusRemx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `BusRem`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pBusRem], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pFarmSkillx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `FarmSkill`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pFarmSkill], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}

ACUM SA ITI PUI TU IN BAZA DE DATE Cases si Keys la users

LE PUN DAR DEGEABA !!TOT ACELEASI 4 ERORI!!SI LE-AM ADAUGAT ALEA CE AI ZIS LA PUBLIC UPDATES!

Umbra · April 14, 2018

Cand definesti pcasesx vezi ca dupa el trebuie sa fie un numar

Sniper88 · April 14, 2018

Acum 14 minute, Umbra a spus:

Cand definesti pcasesx vezi ca dupa el trebuie sa fie un numar

Stiu.....am pus numar

Sniper88 · April 14, 2018

Acum 39 minute, custura a spus:

public Update(playerid, type)
{
if(IsPlayerConnected(playerid))
{
new var[356];
{
switch(type)
{
case pCashx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Money`='%d' WHERE `name`='%s'",GetPlayerCash(playerid), PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pRP:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Respect`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pExp], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}

               case pCasesx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Cases`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pCases], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}

               case pKeysx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Keys`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pKeys], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}

case pBank:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Bank`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pAccount], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pCarLicTx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `CarLicT`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pCarLicT], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pCarLicSuspendx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `CarLicSuspend`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pCarLicSuspend], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pGunLicSuspendx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `GunLicSuspend`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pGunLicSuspend], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pFlyLicTx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `FlyLicT`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pFlyLicT], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pBoatLicTx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `BoatLicT`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pBoatLicT], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pGunLicTx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `GunLicT`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pGunLicT], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pRobx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Rob`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pRob], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pFpunishx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `FPunish`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pFpunish], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pLawyerx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Acceptpoints`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pLawyer], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pConnectTimex:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `ConnectedTime`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pConnectTime], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pPayDayx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `PayDay`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPayDay], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pPayCheckx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Paycheck`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPayCheck], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pPhousekeyx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `House`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPhousekey], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pJailedx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Jailed`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pJailed], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pJailTimex:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `JailTime`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pJailTime], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pWantedLevelx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `WantedLevel`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pWantedLevel], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pPhonex:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Phone`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPhone], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pMatsx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Materials`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pMats], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pFishesx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Fishes`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pFishes], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pFishSkillx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `FishSkill`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pFishSkill], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pSpawnChangex:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `SpawnChange`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pSpawnChange], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pRobSkillx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `RobSkill`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pRobSkill], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pTruckSkillx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `TruckSkill`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pTruckSkill], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pTruckTimesx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `TruckTimes`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pTruckTimes], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pTruckRemx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `TruckRem`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pTruckRem], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pPizzaSkillx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `PizzaSkill`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPizzaSkill], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pPizzaTimesx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `PizzaTimes`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPizzaTimes], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pPizzaRemx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `PizzaRem`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPizzaRem], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pArmsSkillx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `ArmsSkill`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pArmsSkill], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pArmsTimesx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `ArmsTimes`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pArmsTimes], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pArmsRemx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `ArmsRem`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pArmsRem], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pBusSkillx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `BusSkill`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pBusSkill], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pBusTimesx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `BusTimes`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pBusTimes], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pBusRemx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `BusRem`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pBusRem], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}
case pFarmSkillx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `FarmSkill`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pFarmSkill], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}

ACUM SA ITI PUI TU IN BAZA DE DATE Cases si Keys la users

Cum se adauga astea doua la users?Unde dau?La noua inserare sau unde?

Umbra · April 15, 2018

case pCasesx:
{
mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Cases`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pCases], PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,var,"","");
}

incearca sa o pui ultima din switch, de acolo de la Update

Sign In

Problema comanda /opencase

Recommended Posts

Sniper88

valivaly96

Sniper88

Sniper88

AlexxAdv

valivaly96

Sniper88

custura

Sniper88

valivaly96

Sniper88

custura

Sniper88

custura

Sniper88

Sniper88

custura

Sniper88

Umbra

Sniper88

Sniper88

Umbra

Create an account or sign in to comment

Create an account

Sign in

Similar Content

problema

Problema burned

problema server / host gamemode etc nustiu la ce se incadreaza

probleme /getgift

Problema Bani

Recently Browsing 0 members

Browse

Activity

Important Information