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
