08.03.2014, 09:41
Код:
public OnPlayerUpdateRL(playerid)
{
if(IsPlayerConnected(playerid))
{
if(gPlayerLogged[playerid] == 1)
{
new sendername[24];
GetPlayerName(playerid,sendername,24);
new src[50],query[2900],playersip[256];
GetPlayerIp(playerid,playersip,sizeof(playersip));
mysql_format(mysql, query, "UPDATE `"TABLE_ACCOUNTS"` SET ");
PlayerInfo[playerid][pCash] = GetSRVMoney(playerid);
format(src,sizeof(src),"`pLevel`= '%d',",PlayerInfo[playerid][pLevel]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pEmail`= '%s',",PlayerInfo[playerid][pEmail]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pAdmin`= '%d',",PlayerInfo[playerid][pAdmin]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pMestoJail`= '%d',",PlayerInfo[playerid][pMestoJail]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pZvonok`= '%d',",PlayerInfo[playerid][pZvonok]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pVoennik`= '%d',",PlayerInfo[playerid][pVoennik]);strcat(query,src,sizeof(query));
//format(src,sizeof(src),"`pIp`= '%s',",PlayerInfo[playerid][pIp]);strcat(query,src,sizeof(query));
//format(src,sizeof(src),"`pvIp`= '%s',",PlayerInfo[playerid][pvIp]);strcat(query,src,sizeof(query));
// format(src,sizeof(src),"`pVig`= '%d',",PlayerInfo[playerid][pVig]);strcat(query,src,sizeof(query));
// format(src,sizeof(src),"`pAVig`= '%d',",PlayerInfo[playerid][pAVig]);strcat(query,src,sizeof(query));
//format(src,sizeof(src),"`pTeam`= '%d',",PlayerInfo[playerid][pTeam]);strcat(query,src,sizeof(query));
//format(src,sizeof(src),"`pIpReg`= '%s',",PlayerInfo[playerid][pIpReg]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pHousecash`= '%d',",PlayerInfo[playerid][pHousecash]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pText`= '%d',",PlayerInfo[playerid][pText]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pHP`= '%d',",PlayerInfo[playerid][pHP]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pDataReg`= '%s',",PlayerInfo[playerid][pDataReg]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pMes`= '%d',",PlayerInfo[playerid][pMes]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pGod`= '%d',",PlayerInfo[playerid][pGod]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pCar`= '%d',",PlayerInfo[playerid][pCar]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pFuelcar`= '%f',",PlayerInfo[playerid][pFuelcar]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pCar`= '%d',",PlayerInfo[playerid][pCar]);strcat(query,src,sizeof(query));
// format(src,sizeof(src),"`pNumbercar`= '%s',",PlayerInfo[playerid][pNumbercar]);strcat(query,src,sizeof(query));
// format(src,sizeof(src),"`pNomerCar`= '%d',",PlayerInfo[playerid][pNomerCar]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pProz`= '%d',",PlayerInfo[playerid][pProz]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pBeg`= '%d',",PlayerInfo[playerid][pProz]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pDonateRank`= '%d',",PlayerInfo[playerid][pDonateRank]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pDonatemoney`= '%d',",PlayerInfo[playerid][pDonatemoney]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pRp`= '%d',",PlayerInfo[playerid][pRp]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pReg`= '%d',",PlayerInfo[playerid][pReg]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pMats`= '%d',",PlayerInfo[playerid][pMats]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSex`= '%d',",PlayerInfo[playerid][pSex]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pArrested`= '%d',",PlayerInfo[playerid][pArrested]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pMuted`= '%d',",PlayerInfo[playerid][pMuted]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pCrimes`= '%d',",PlayerInfo[playerid][pCrimes]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pExp`= '%d',",PlayerInfo[playerid][pExp]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pCash`= '%d',",PlayerInfo[playerid][pCash]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pKills`= '%d',",PlayerInfo[playerid][pKills]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pDeaths`= '%d',",PlayerInfo[playerid][pDeaths]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pWantedDeaths`= '%d',",PlayerInfo[playerid][pWantedDeaths]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pPayCheck`= '%d',",PlayerInfo[playerid][pPayCheck]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pJailed`= '%d',",PlayerInfo[playerid][pJailed]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pJailTime`= '%d',",PlayerInfo[playerid][pJailTime]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pDrugs`= '%d',",PlayerInfo[playerid][pDrugs]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pLeader`= '%d',",PlayerInfo[playerid][pLeader]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pMember`= '%d',",PlayerInfo[playerid][pMember]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pRank`= '%d',",PlayerInfo[playerid][pRank]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pChar`= '%d',",PlayerInfo[playerid][pChar]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pJob`= '%d',",PlayerInfo[playerid][pJob]);strcat(query,src,sizeof(query));
GetPlayerHealth(playerid,PlayerInfo[playerid][pHealth]);
format(src,sizeof(src),"`pHealth`= '%f',",PlayerInfo[playerid][pHealth]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSHealth`= '%f',",PlayerInfo[playerid][pSHealth]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pInt`= '%d',",PlayerInfo[playerid][pInt]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pLocal`= '%d',",PlayerInfo[playerid][pLocal]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pModel`= '%d',",PlayerInfo[playerid][pModel]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pPnumber`= '%d',",PlayerInfo[playerid][pPnumber]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pPhoneBook`= '%d',",PlayerInfo[playerid][pPhoneBook]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pVhoddata`= '%d',",PlayerInfo[playerid][pVhoddata]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pVhodMes`= '%d',",PlayerInfo[playerid][pVhodMes]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pVhodchas`= '%d',",PlayerInfo[playerid][pVhodchas]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pVhodminute`= '%d',",PlayerInfo[playerid][pVhodminute]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pAlcoholPerk`= '%d',",PlayerInfo[playerid][pAlcoholPerk]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pVodPrava`= '%d',",PlayerInfo[playerid][pVodPrava]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pFlyLic`= '%d',",PlayerInfo[playerid][pFlyLic]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pBoatLic`= '%d',",PlayerInfo[playerid][pBoatLic]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pFishLic`= '%d',",PlayerInfo[playerid][pFishLic]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pGunLic`= '%d',",PlayerInfo[playerid][pGunLic]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pBizLic`= '%d',",PlayerInfo[playerid][pBizLic]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pPhousekey`= '%d',",PlayerInfo[playerid][pPhousekey]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pPbiskey`= '%d',",PlayerInfo[playerid][pPbiskey]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pAvtomas`= '%d',",PlayerInfo[playerid][pAvtomas]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pZakonp`= '%d',",PlayerInfo[playerid][pZakonp]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pNarcoZavisimost`= '%d',",PlayerInfo[playerid][pNarcoZavisimost]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pNarcoLomka`= '%d',",PlayerInfo[playerid][pNarcoLomka]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSDPistol`= '%d',",PlayerInfo[playerid][pSDPistol]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pDesertEagle`= '%d',",PlayerInfo[playerid][pDesertEagle]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pShotGun`= '%d',",PlayerInfo[playerid][pShotGun]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pMP5`= '%d',",PlayerInfo[playerid][pMP5]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pAK47`= '%d',",PlayerInfo[playerid][pAK47]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pM4`= '%d',",PlayerInfo[playerid][pM4]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSafe`= '%d',",PlayerInfo[playerid][pSafe]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pAptek`= '%d',",PlayerInfo[playerid][pAptek]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pOchko`= '%d',",PlayerInfo[playerid][pOchko]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pToilet`= '%d',",PlayerInfo[playerid][pToilet]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pBankPass`= '%d',",PlayerInfo[playerid][pBankPass]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pBankKart`= '%d',",PlayerInfo[playerid][pBankKart]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pPayDay`= '%d',",PlayerInfo[playerid][pPayDay]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pPayDayHad`= '%d',",PlayerInfo[playerid][pPayDayHad]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pTut`= '%d',",PlayerInfo[playerid][pTut]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pWarns`= '%d',",PlayerInfo[playerid][pWarns]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`punWarns`= '%d',",PlayerInfo[playerid][punWarns]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`punWarnstime`= '%d',",PlayerInfo[playerid][punWarnstime]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pFuel`= '%d',",PlayerInfo[playerid][pFuel]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pMarried`= '%d',",PlayerInfo[playerid][pMarried]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pMarriedTo`= '%s',",PlayerInfo[playerid][pMarriedTo]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pDrug`= '%s',",PlayerInfo[playerid][pDrug]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pDrugmoney`= '%d',",PlayerInfo[playerid][pDrugmoney]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pMuteTime`= '%d',",PlayerInfo[playerid][pMuteTime]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pBank`= '%d',",PlayerInfo[playerid][pBank]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pDonatechet`= '%d',",PlayerInfo[playerid][pDonatechet]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pMobile`= '%d',",PlayerInfo[playerid][pMobile]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pDostup`= '%d',",PlayerInfo[playerid][pDostup]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pLocked`= '%d',",PlayerInfo[playerid][pLocked]);strcat(query,src,sizeof(query));
// format(src,sizeof(src),"`pBanData1`= '%d',",PlayerInfo[playerid][pBanData1]);strcat(query,src,sizeof(query));
// format(src,sizeof(src),"`pBanTime1`= '%d',",PlayerInfo[playerid][pBanTime1]);strcat(query,src,sizeof(query));
// format(src,sizeof(src),"`pBanKol`= '%d',",PlayerInfo[playerid][pBanKol]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pDolg`= '%d',",PlayerInfo[playerid][pDolg]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pKrisha`= '%d',",PlayerInfo[playerid][pKrisha]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pUseKrisha`= '%d',",PlayerInfo[playerid][pUseKrisha]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pZvezdi`= '%d',",PlayerInfo[playerid][pZvezdi]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSlot1`='%d',",PlayerInfo[playerid][pSlot1]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSlot2`='%d',",PlayerInfo[playerid][pSlot2]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSlot3`='%d',",PlayerInfo[playerid][pSlot3]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSlot4`='%d',",PlayerInfo[playerid][pSlot4]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSlot5`='%d',",PlayerInfo[playerid][pSlot5]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSlot6`='%d',",PlayerInfo[playerid][pSlot6]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSlot7`='%d',",PlayerInfo[playerid][pSlot7]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSlot8`='%d',",PlayerInfo[playerid][pSlot8]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSlot9`='%d',",PlayerInfo[playerid][pSlot9]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSlot10`='%d',",PlayerInfo[playerid][pSlot10]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSlot11`='%d',",PlayerInfo[playerid][pSlot11]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSlotammo1`='%d',",PlayerInfo[playerid][pSlotammo1]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSlotammo2`='%d',",PlayerInfo[playerid][pSlotammo2]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSlotammo3`='%d',",PlayerInfo[playerid][pSlotammo3]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSlotammo4`='%d',",PlayerInfo[playerid][pSlotammo4]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSlotammo5`='%d',",PlayerInfo[playerid][pSlotammo5]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSlotammo6`='%d',",PlayerInfo[playerid][pSlotammo6]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSlotammo7`='%d',",PlayerInfo[playerid][pSlotammo7]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSlotammo8`='%d',",PlayerInfo[playerid][pSlotammo8]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSlotammo9`='%d',",PlayerInfo[playerid][pSlotammo9]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSlotammo10`='%d',",PlayerInfo[playerid][pSlotammo10]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSlotammo11`='%d',",PlayerInfo[playerid][pSlotammo11]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pGun2`='%d',",PlayerInfo[playerid][pGun2]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pGun3`='%d',",PlayerInfo[playerid][pGun3]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pGun4`='%d',",PlayerInfo[playerid][pGun4]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pGun5`='%d',",PlayerInfo[playerid][pGun5]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pGun6`='%d',",PlayerInfo[playerid][pGun6]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pGun7`='%d',",PlayerInfo[playerid][pGun7]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pGun8`='%d',",PlayerInfo[playerid][pGun8]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pGun9`='%d',",PlayerInfo[playerid][pGun9]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pGun10`='%d',",PlayerInfo[playerid][pGun10]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pAmmo1`='%d',",PlayerInfo[playerid][pAmmo1]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pAmmo2`='%d',",PlayerInfo[playerid][pAmmo2]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pAmmo3`='%d',",PlayerInfo[playerid][pAmmo3]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pAmmo4`='%d',",PlayerInfo[playerid][pAmmo4]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pAmmo5`='%d',",PlayerInfo[playerid][pAmmo5]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pAmmo6`='%d',",PlayerInfo[playerid][pAmmo6]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pAmmo7`='%d',",PlayerInfo[playerid][pAmmo7]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pAmmo8`='%d',",PlayerInfo[playerid][pAmmo8]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pAmmo9`='%d',",PlayerInfo[playerid][pAmmo9]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pGunfbiTime`='%d',",PlayerInfo[playerid][pGunfbiTime]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pGun51Time`='%d',",PlayerInfo[playerid][pGun51Time]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pGunlspdTime`='%d',",PlayerInfo[playerid][pGunlspdTime]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pGunaviaTime`='%d',",PlayerInfo[playerid][pGunaviaTime]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pDrugtime`= '%d',",PlayerInfo[playerid][pDrugtime]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pBoxstyle`= '%d',",PlayerInfo[playerid][pBoxstyle]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pKstyle`= '%d',",PlayerInfo[playerid][pKstyle]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pKickstyle`= '%d',",PlayerInfo[playerid][pKickstyle]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pBoxSkill`= '%d',",PlayerInfo[playerid][pBoxSkill]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pKongfuSkill`= '%d',",PlayerInfo[playerid][pKongfuSkill]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pKickboxSkill`= '%d',",PlayerInfo[playerid][pKickboxSkill]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pKolesocar`= '%d',",PlayerInfo[playerid][pKolesocar]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pPokraska`= '%d',",PlayerInfo[playerid][pPokraska]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pHouseInv`= '%d',",PlayerInfo[playerid][pHouseInv]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pHouseWeapon`= '%d',",PlayerInfo[playerid][pHouseWeapon]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pHouseWeaponAmmo`= '%d',",PlayerInfo[playerid][pHouseWeaponAmmo]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pHouseDrugs`= '%d',",PlayerInfo[playerid][pHouseDrugs]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pHouseMats`= '%d',",PlayerInfo[playerid][pHouseMats]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pHouseMoney`= '%d',",PlayerInfo[playerid][pHouseMoney]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSpoiler`= '%d',",PlayerInfo[playerid][pSpoiler]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pBamper1`= '%d',",PlayerInfo[playerid][pBamper1]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pBamper2`= '%d',",PlayerInfo[playerid][pBamper2]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pCvet[0]`= '%d',",PlayerInfo[playerid][pCvet][0]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pCvet[1]`= '%d',",PlayerInfo[playerid][pCvet][1]);strcat(query,src,sizeof(query));
// format(src,sizeof(src),"`pVehcom`= '%d',",PlayerInfo[playerid][pBamper2]);strcat(query,src,sizeof(query));
// format(src,sizeof(src),"`pVehcoms`= '%d',",PlayerInfo[playerid][pBamper2]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pNitro`= '%d',",PlayerInfo[playerid][pNitro]);strcat(query,src,sizeof(query));
//format(src,sizeof(src),"`pGidra`= '%d',",PlayerInfo[playerid][pGidra]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pKazino`= '%d',",PlayerInfo[playerid][pKazino]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pKRank`= '%d',",PlayerInfo[playerid][pKRank]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pKazpay`= '%d',",PlayerInfo[playerid][pKazpay]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pKSex`= '%d',",PlayerInfo[playerid][pKSex]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pKBank`= '%d',",PlayerInfo[playerid][pKBank]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pDonateMoney1`= '%d',",PlayerInfo[playerid][pNitro]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pChat`= '%d',",PlayerInfo[playerid][pChat]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pGolos`= '%d',",PlayerInfo[playerid][pGolos]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSpawnChange`= '%d'",PlayerInfo[playerid][pSpawnChange]);strcat(query,src,sizeof(query));
format(src,sizeof(src)," WHERE `Name`='%s'",sendername);strcat(query,src,sizeof(query));
mysql_function_query(mysql, query, true, "", "i" ,playerid);
}
}
return true;
}
public OnPlayerLogin(playerid,password[])
{
new tmp2[256];
new stringer[512];
new rows, fields;
new playername2[MAX_PLAYER_NAME];
new vresult[11], float:fresult[11];
cache_get_data(rows, fields);
if(rows == 0)
{
if(GetPVarInt(playerid, "wrongPass") == 2) return SendClientMessage(playerid,COLOR_GREY,"Вы кикнуты с сервера за неверный ввод пароля. Пожалуйста попробуйте позже!"), Kick(playerid);
SetPVarInt(playerid, "wrongPass", GetPVarInt(playerid, "wrongPass")+1);
format(stringer, sizeof(stringer), "{FFFFFF}Добро пожаловать на Role Play{FFFFFF}\nДанный аккаунт зарегистрирован{FFFFFF} на нашем сервере\nДля продолжения авторизации укажите пароль Попыток: %i из 3){FFFFFF}\n - пароль должен содержать от 6 до 20 символов\n - пароль чувствителен к регистру", 3 - GetPVarInt(playerid, "wrongPass"));
ShowPlayerDialog(playerid, 1, DIALOG_STYLE_PASSWORD, "Авторизация", stringer, "Вход", "Отмена");
return true;
}
else if(rows==1)
{
cache_get_field_content(0, "pLevel", vresult);PlayerInfo[playerid][pLevel] = strval(vresult);
cache_get_field_content(0, "pEmail", vresult);PlayerInfo[playerid][pEmail] = strval(vresult);
cache_get_field_content(0, "pAdmin", vresult);PlayerInfo[playerid][pAdmin] = strval(vresult);
cache_get_field_content(0, "pMestoJail", vresult);PlayerInfo[playerid][pMestoJail] = strval(vresult);
cache_get_field_content(0, "pZvonok", vresult);PlayerInfo[playerid][pZvonok] = strval(vresult);
cache_get_field_content(0, "pVoennik", vresult);PlayerInfo[playerid][pVoennik] = strval(vresult);
cache_get_field_content(0, "pIp", vresult);PlayerInfo[playerid][pIp] = strval(vresult);
cache_get_field_content(0, "pvIp", vresult);PlayerInfo[playerid][pvIp] = strval(vresult);
// cache_get_field_content(0, "pVig", vresult);PlayerInfo[playerid][pVoennik] = strval(vresult);
// cache_get_field_content(0, "pAVig", vresult);PlayerInfo[playerid][pVoennik] = strval(vresult);
// cache_get_field_content(0, "pTeam", vresult);PlayerInfo[playerid][pVoennik] = strval(vresult);
cache_get_field_content(0, "pIpReg", vresult);PlayerInfo[playerid][pIpReg] = strval(vresult);
cache_get_field_content(0, "pHousecash", vresult);PlayerInfo[playerid][pHousecash] = strval(vresult);
cache_get_field_content(0, "pText", vresult);PlayerInfo[playerid][pText] = strval(vresult);
cache_get_field_content(0, "pHP", vresult);PlayerInfo[playerid][pHP] = strval(vresult);
cache_get_field_content(0, "pDataReg", vresult);PlayerInfo[playerid][pDataReg] = strval(vresult);
cache_get_field_content(0, "pMes", vresult);PlayerInfo[playerid][pMes] = strval(vresult);
cache_get_field_content(0, "pGod", vresult);PlayerInfo[playerid][pGod] = strval(vresult);
cache_get_field_content(0, "pCar", vresult);PlayerInfo[playerid][pCar] = strval(vresult);
cache_get_field_content(0, "pFuelcar", vresult);PlayerInfo[playerid][pFuelcar] = floatstr(fresult);
// cache_get_field_content(0, "pNumbercar", vresult);PlayerInfo[playerid][pNumbercar] = strval(vresult);
// cache_get_field_content(0, "pNomerCar", vresult);PlayerInfo[playerid][pNomerCar] = strval(vresult);
cache_get_field_content(0, "pProz", vresult);PlayerInfo[playerid][pProz] = strval(vresult);
cache_get_field_content(0, "pBeg", vresult);PlayerInfo[playerid][pBeg] = strval(vresult);
cache_get_field_content(0, "pDonateRank", vresult);PlayerInfo[playerid][pDonateRank] = strval(vresult);
cache_get_field_content(0, "pDonatemoney", vresult);PlayerInfo[playerid][pDonatemoney] = strval(vresult);
cache_get_field_content(0, "pRp", vresult);PlayerInfo[playerid][pRp] = strval(vresult);
cache_get_field_content(0, "pReg", vresult);PlayerInfo[playerid][pReg] = strval(vresult);
cache_get_field_content(0, "pMats", vresult);PlayerInfo[playerid][pMats] = strval(vresult);
cache_get_field_content(0, "pSex", vresult);PlayerInfo[playerid][pSex] = strval(vresult);
cache_get_field_content(0, "pArrested", vresult);PlayerInfo[playerid][pArrested] = strval(vresult);
cache_get_field_content(0, "pMuted", vresult);PlayerInfo[playerid][pMuted] = strval(vresult);
cache_get_field_content(0, "pCrimes", vresult);PlayerInfo[playerid][pCrimes] = strval(vresult);
cache_get_field_content(0, "pExp", vresult);PlayerInfo[playerid][pExp] = strval(vresult);
cache_get_field_content(0, "pCash", vresult);PlayerInfo[playerid][pCash] = strval(vresult);
cache_get_field_content(0, "pKills", vresult);PlayerInfo[playerid][pKills] = strval(vresult);
cache_get_field_content(0, "pDeaths", vresult);PlayerInfo[playerid][pDeaths] = strval(vresult);
cache_get_field_content(0, "pWantedDeaths", vresult);PlayerInfo[playerid][pWantedDeaths] = strval(vresult);
cache_get_field_content(0, "pPayCheck", vresult);PlayerInfo[playerid][pPayCheck] = strval(vresult);
cache_get_field_content(0, "pJailed", vresult);PlayerInfo[playerid][pJailed] = strval(vresult);
cache_get_field_content(0, "pJailTime", vresult);PlayerInfo[playerid][pJailTime] = strval(vresult);
cache_get_field_content(0, "pDrugs", vresult);PlayerInfo[playerid][pDrugs] = strval(vresult);
cache_get_field_content(0, "pLeader", vresult);PlayerInfo[playerid][pLeader] = strval(vresult);
cache_get_field_content(0, "pMember", vresult);PlayerInfo[playerid][pMember] = strval(vresult);
cache_get_field_content(0, "pRank", vresult);PlayerInfo[playerid][pRank] = strval(vresult);
cache_get_field_content(0, "pChar", vresult);PlayerInfo[playerid][pChar] = strval(vresult);
cache_get_field_content(0, "pJob", vresult);PlayerInfo[playerid][pJob] = strval(vresult);
cache_get_field_content(0, "pHealth", vresult);PlayerInfo[playerid][pHealth] = floatstr(fresult);
cache_get_field_content(0, "pSHealth", vresult);PlayerInfo[playerid][pSHealth] = floatstr(fresult);
cache_get_field_content(0, "pInt", vresult);PlayerInfo[playerid][pInt] = strval(vresult);
cache_get_field_content(0, "pLocal", vresult);PlayerInfo[playerid][pLocal] = strval(vresult);
cache_get_field_content(0, "pModel", vresult);PlayerInfo[playerid][pModel] = strval(vresult);
cache_get_field_content(0, "pPnumber", vresult);PlayerInfo[playerid][pPnumber] = strval(vresult);
cache_get_field_content(0, "pPhoneBook", vresult);PlayerInfo[playerid][pPhoneBook] = strval(vresult);
cache_get_field_content(0, "pDirectory", vresult);PlayerInfo[playerid][pDirectory] = strval(vresult);
cache_get_field_content(0, "pVhoddata", vresult);PlayerInfo[playerid][pVhoddata] = strval(vresult);
cache_get_field_content(0, "pVhodMes", vresult);PlayerInfo[playerid][pVhodMes] = strval(vresult);
cache_get_field_content(0, "pVhodchas", vresult);PlayerInfo[playerid][pVhodchas] = strval(vresult);
cache_get_field_content(0, "pVhodminute", vresult);PlayerInfo[playerid][pVhodminute] = strval(vresult);
cache_get_field_content(0, "pAlcoholPerk", vresult);PlayerInfo[playerid][pAlcoholPerk] = strval(vresult);
cache_get_field_content(0, "pVodPrava", vresult);PlayerInfo[playerid][pVodPrava] = strval(vresult);
cache_get_field_content(0, "pFlyLic", vresult);PlayerInfo[playerid][pFlyLic] = strval(vresult);
cache_get_field_content(0, "pBoatLic", vresult);PlayerInfo[playerid][pBoatLic] = strval(vresult);
cache_get_field_content(0, "pFishLic", vresult);PlayerInfo[playerid][pFishLic] = strval(vresult);
cache_get_field_content(0, "pGunLic", vresult);PlayerInfo[playerid][pGunLic] = strval(vresult);
cache_get_field_content(0, "pBizLic", vresult);PlayerInfo[playerid][pBizLic] = strval(vresult);
cache_get_field_content(0, "pPhousekey", vresult);PlayerInfo[playerid][pPhousekey] = strval(vresult);
cache_get_field_content(0, "pPbiskey", vresult);PlayerInfo[playerid][pPbiskey] = strval(vresult);
cache_get_field_content(0, "pAvtomas", vresult);PlayerInfo[playerid][pAvtomas] = strval(vresult);
cache_get_field_content(0, "pZakonp", vresult);PlayerInfo[playerid][pZakonp] = strval(vresult);
cache_get_field_content(0, "pNarcoZavisimost", vresult);PlayerInfo[playerid][pNarcoZavisimost] = strval(vresult);
cache_get_field_content(0, "pNarcoLomka", vresult);PlayerInfo[playerid][pNarcoLomka] = strval(vresult);
cache_get_field_content(0, "pSDPistol", vresult);PlayerInfo[playerid][pSDPistol]= strval(vresult);
cache_get_field_content(0, "pDesertEagle", vresult);PlayerInfo[playerid][pDesertEagle] = strval(vresult);
cache_get_field_content(0, "pShotGun", vresult);PlayerInfo[playerid][pShotGun] = strval(vresult);
cache_get_field_content(0, "pMP5", vresult);PlayerInfo[playerid][pMP5] = strval(vresult);
cache_get_field_content(0, "pAK47", vresult);PlayerInfo[playerid][pAK47] = strval(vresult);
cache_get_field_content(0, "pM4", vresult);PlayerInfo[playerid][pM4] = strval(vresult);
cache_get_field_content(0, "pSafe", vresult);PlayerInfo[playerid][pSafe] = strval(vresult);
cache_get_field_content(0, "pAptek", vresult);PlayerInfo[playerid][pAptek] = strval(vresult);
cache_get_field_content(0, "pOchko", vresult);PlayerInfo[playerid][pOchko] = strval(vresult);
cache_get_field_content(0, "pToilet", vresult);PlayerInfo[playerid][pToilet] = strval(vresult);
cache_get_field_content(0, "pBankPass", vresult);PlayerInfo[playerid][pBankPass] = strval(vresult);
cache_get_field_content(0, "pBankKart", vresult);PlayerInfo[playerid][pBankKart] = strval(vresult);
cache_get_field_content(0, "pPayDay", vresult);PlayerInfo[playerid][pPayDay] = strval(vresult);
cache_get_field_content(0, "pPayDayHad", vresult);PlayerInfo[playerid][pPayDayHad] = strval(vresult);
cache_get_field_content(0, "pTut", vresult);PlayerInfo[playerid][pTut] = strval(vresult);
cache_get_field_content(0, "pWarns", vresult);PlayerInfo[playerid][pWarns] = strval(vresult);
cache_get_field_content(0, "punWarns", vresult);PlayerInfo[playerid][punWarns] = strval(vresult);
cache_get_field_content(0, "punWarnstime", vresult);PlayerInfo[playerid][punWarnstime] = strval(vresult);
cache_get_field_content(0, "pFuel", vresult);PlayerInfo[playerid][pFuel] = strval(vresult);
cache_get_field_content(0, "pMarried", vresult);PlayerInfo[playerid][pMarried] = strval(vresult);
cache_get_field_content(0, "pMarriedTo", vresult);PlayerInfo[playerid][pMarriedTo] = strval(vresult);
cache_get_field_content(0, "pDrug", vresult);PlayerInfo[playerid][pDrug] = strval(vresult);
cache_get_field_content(0, "pDrugmoney", vresult);PlayerInfo[playerid][pDrugmoney] = strval(vresult);
cache_get_field_content(0, "pMuteTime", vresult);PlayerInfo[playerid][pMuteTime] = strval(vresult);
cache_get_field_content(0, "pBank", vresult);PlayerInfo[playerid][pBank] = strval(vresult);
cache_get_field_content(0, "pDonatechet", vresult);PlayerInfo[playerid][pDonatechet] = strval(vresult);
cache_get_field_content(0, "pMobile", vresult);PlayerInfo[playerid][pMobile] = strval(vresult);
cache_get_field_content(0, "pDostup", vresult);PlayerInfo[playerid][pDostup] = strval(vresult);
cache_get_field_content(0, "pLocked", vresult);PlayerInfo[playerid][pLocked] = strval(vresult);// pBanData1, pBanTime1, pBanKol,,
// cache_get_field_content(0, "pBanData1", vresult);PlayerInfo[playerid][pBanData1] = strval(vresult);
// cache_get_field_content(0, "pBanTime1", vresult);PlayerInfo[playerid][pBanTime1] = strval(vresult);
// cache_get_field_content(0, "pBanKol", vresult);PlayerInfo[playerid][pBanKol] = strval(vresult);
cache_get_field_content(0, "pDolg", vresult);PlayerInfo[playerid][pDolg] = strval(vresult);
cache_get_field_content(0, "pKrisha", vresult);PlayerInfo[playerid][pKrisha] = strval(vresult);
cache_get_field_content(0, "pUseKrisha", vresult);PlayerInfo[playerid][pUseKrisha] = strval(vresult);
cache_get_field_content(0, "pZvezdi", vresult);PlayerInfo[playerid][pZvezdi] = strval(vresult);
cache_get_field_content(0, "pSlot1", vresult);PlayerInfo[playerid][pSlot1] = strval(vresult);
cache_get_field_content(0, "pSlot2", vresult);PlayerInfo[playerid][pSlot2] = strval(vresult);
cache_get_field_content(0, "pSlot3", vresult);PlayerInfo[playerid][pSlot3] = strval(vresult);
cache_get_field_content(0, "pSlot4", vresult);PlayerInfo[playerid][pSlot4] = strval(vresult);
cache_get_field_content(0, "pSlot5", vresult);PlayerInfo[playerid][pSlot5] = strval(vresult);
cache_get_field_content(0, "pSlot6", vresult);PlayerInfo[playerid][pSlot6] = strval(vresult);
cache_get_field_content(0, "pSlot7", vresult);PlayerInfo[playerid][pSlot7] = strval(vresult);
cache_get_field_content(0, "pSlot8", vresult);PlayerInfo[playerid][pSlot8] = strval(vresult);
cache_get_field_content(0, "pSlot9", vresult);PlayerInfo[playerid][pSlot9] = strval(vresult);
cache_get_field_content(0, "pSlot10", vresult);PlayerInfo[playerid][pSlot10] = strval(vresult);
cache_get_field_content(0, "pSlot11", vresult);PlayerInfo[playerid][pSlot11] = strval(vresult);
cache_get_field_content(0, "pSlotammo1", vresult);PlayerInfo[playerid][pSlotammo2] = strval(vresult);
cache_get_field_content(0, "pSlotammo2", vresult);PlayerInfo[playerid][pSlotammo2] = strval(vresult);
cache_get_field_content(0, "pSlotammo3", vresult);PlayerInfo[playerid][pSlotammo3] = strval(vresult);
cache_get_field_content(0, "pSlotammo4", vresult);PlayerInfo[playerid][pSlotammo4] = strval(vresult);
cache_get_field_content(0, "pSlotammo5", vresult);PlayerInfo[playerid][pSlotammo5] = strval(vresult);
cache_get_field_content(0, "pSlotammo6", vresult);PlayerInfo[playerid][pSlotammo6] = strval(vresult);
cache_get_field_content(0, "pSlotammo7", vresult);PlayerInfo[playerid][pSlotammo7] = strval(vresult);
cache_get_field_content(0, "pSlotammo8", vresult);PlayerInfo[playerid][pSlotammo8] = strval(vresult);
cache_get_field_content(0, "pSlotammo9", vresult);PlayerInfo[playerid][pSlotammo9] = strval(vresult);
cache_get_field_content(0, "pSlotammo10", vresult);PlayerInfo[playerid][pSlotammo10] = strval(vresult);
cache_get_field_content(0, "pSlotammo11", vresult);PlayerInfo[playerid][pSlotammo11] = strval(vresult);
cache_get_field_content(0, "pGun2", vresult);PlayerInfo[playerid][pGun2] = strval(vresult);
cache_get_field_content(0, "pGun3", vresult);PlayerInfo[playerid][pGun3] = strval(vresult);
cache_get_field_content(0, "pGun4", vresult);PlayerInfo[playerid][pGun4] = strval(vresult);
cache_get_field_content(0, "pGun5", vresult);PlayerInfo[playerid][pGun5] = strval(vresult);
cache_get_field_content(0, "pGun6", vresult);PlayerInfo[playerid][pGun6] = strval(vresult);
cache_get_field_content(0, "pGun7", vresult);PlayerInfo[playerid][pGun7] = strval(vresult);
cache_get_field_content(0, "pGun8", vresult);PlayerInfo[playerid][pGun8] = strval(vresult);
cache_get_field_content(0, "pGun9", vresult);PlayerInfo[playerid][pGun9] = strval(vresult);
cache_get_field_content(0, "pGun10", vresult);PlayerInfo[playerid][pGun10] = strval(vresult);
cache_get_field_content(0, "pAmmo1", vresult);PlayerInfo[playerid][pAmmo1] = strval(vresult);
cache_get_field_content(0, "pAmmo2", vresult);PlayerInfo[playerid][pAmmo2] = strval(vresult);
cache_get_field_content(0, "pAmmo3", vresult);PlayerInfo[playerid][pAmmo3] = strval(vresult);
cache_get_field_content(0, "pAmmo4", vresult);PlayerInfo[playerid][pAmmo4] = strval(vresult);
cache_get_field_content(0, "pAmmo5", vresult);PlayerInfo[playerid][pAmmo5] = strval(vresult);
cache_get_field_content(0, "pAmmo6", vresult);PlayerInfo[playerid][pAmmo6] = strval(vresult);
cache_get_field_content(0, "pAmmo7", vresult);PlayerInfo[playerid][pAmmo7] = strval(vresult);
cache_get_field_content(0, "pAmmo8", vresult);PlayerInfo[playerid][pAmmo8] = strval(vresult);
cache_get_field_content(0, "pAmmo9", vresult);PlayerInfo[playerid][pAmmo9] = strval(vresult);
cache_get_field_content(0, "pAmmo10", vresult);PlayerInfo[playerid][pAmmo10] = strval(vresult);
cache_get_field_content(0, "pGunfbiTime", vresult);PlayerInfo[playerid][pGunfbiTime] = strval(vresult);
cache_get_field_content(0, "pGun51Time", vresult);PlayerInfo[playerid][pGun51Time] = strval(vresult);
cache_get_field_content(0, "pGunlspdTime", vresult);PlayerInfo[playerid][pGunlspdTime] = strval(vresult);
cache_get_field_content(0, "pGunaviaTime", vresult);PlayerInfo[playerid][pGunaviaTime] = strval(vresult);
cache_get_field_content(0, "pDrugtime", vresult);PlayerInfo[playerid][pDrugtime] = strval(vresult);
cache_get_field_content(0, "pBoxstyle", vresult);PlayerInfo[playerid][pBoxstyle] = strval(vresult);
cache_get_field_content(0, "pKstyle", vresult);PlayerInfo[playerid][pKstyle] = strval(vresult);
cache_get_field_content(0, "pKickstyle", vresult);PlayerInfo[playerid][pKickstyle] = strval(vresult);
cache_get_field_content(0, "pBoxSkill", vresult);PlayerInfo[playerid][pBoxSkill] = strval(vresult);
cache_get_field_content(0, "pKongfuSkill", vresult);PlayerInfo[playerid][pKongfuSkill] = strval(vresult);
cache_get_field_content(0, "pKickboxSkill", vresult);PlayerInfo[playerid][pKickboxSkill] = strval(vresult);
cache_get_field_content(0, "pKolesocar", vresult);PlayerInfo[playerid][pKolesocar] = strval(vresult);
cache_get_field_content(0, "pPokraska", vresult);PlayerInfo[playerid][pPokraska] = strval(vresult);
cache_get_field_content(0, "pHouseInv", vresult);PlayerInfo[playerid][pHouseInv] = strval(vresult);
cache_get_field_content(0, "pHouseWeapon", vresult);PlayerInfo[playerid][pHouseWeapon] = strval(vresult);
cache_get_field_content(0, "pHouseWeaponAmmo", vresult);PlayerInfo[playerid][pHouseWeaponAmmo] = strval(vresult);
cache_get_field_content(0, "pHouseDrugs", vresult);PlayerInfo[playerid][pHouseDrugs] = strval(vresult);
cache_get_field_content(0, "pHouseMats", vresult);PlayerInfo[playerid][pHouseMats] = strval(vresult);
cache_get_field_content(0, "pHouseMoney", vresult);PlayerInfo[playerid][pHouseMoney] = strval(vresult);
cache_get_field_content(0, "pSpoiler", vresult);PlayerInfo[playerid][pSpoiler] = strval(vresult);
cache_get_field_content(0, "pBamper1", vresult);PlayerInfo[playerid][pBamper1] = strval(vresult);
cache_get_field_content(0, "pBamper2", vresult);PlayerInfo[playerid][pBamper2] = strval(vresult);
cache_get_field_content(0, "pCvet[0]", vresult);PlayerInfo[playerid][pCvet][0] = strval(vresult);
cache_get_field_content(0, "pCvet[1]", vresult);PlayerInfo[playerid][pCvet][1] = strval(vresult);
// cache_get_field_content(0, "pVehcom", vresult);PlayerInfo[playerid][pVehcom] = strval(vresult);
// cache_get_field_content(0, "pVehcoms", vresult);PlayerInfo[playerid][pVehcoms] = strval(vresult);
cache_get_field_content(0, "pNitro", vresult);PlayerInfo[playerid][pNitro] = strval(vresult);
cache_get_field_content(0, "pGidra", vresult);PlayerInfo[playerid][pGidra] = strval(vresult);
cache_get_field_content(0, "pKazino", vresult);PlayerInfo[playerid][pKazino] = strval(vresult);
cache_get_field_content(0, "pKRank", vresult);PlayerInfo[playerid][pKRank] = strval(vresult);
cache_get_field_content(0, "pKazpay", vresult);PlayerInfo[playerid][pKazpay] = strval(vresult);
cache_get_field_content(0, "pKSex", vresult);PlayerInfo[playerid][pKSex] = strval(vresult);
cache_get_field_content(0, "pKBank", vresult);PlayerInfo[playerid][pKBank] = strval(vresult);
cache_get_field_content(0, "pDonateMoney1", vresult);PlayerInfo[playerid][pDonateMoney1] = strval(vresult);
cache_get_field_content(0, "pChat", vresult);PlayerInfo[playerid][pChat] = strval(vresult);
cache_get_field_content(0, "pGolos", vresult);PlayerInfo[playerid][pGolos] = strval(vresult);
cache_get_field_content(0, "pSpawnChange", vresult);PlayerInfo[playerid][pSpawnChange] = strval(vresult);
Код:
[09:44:28] Passing query UPDATE `accounts1` SET `pLevel`= '0',`pEmail`= '',`pAdmin`= '0',`pMestoJail`= '0',`pZvonok`= '0',`pVoennik`= '0',`pHousecash`= '0',`pText`= '0',`pHP`= '100',`pDataReg`= '',`pMes`= '0',`pGod`= '0',`pCar`= '462',`pFuelcar`= '0.000000',`pCar`= '462',`pProz`= '0',`pBeg`= '0',`pDonateRank`= '0',`pDonatemoney`= '0',`pRp`= '0',`pReg`= '0',`pMats`= '0',`pSex`= '1',`pArrested`= '0',`pMuted`= '0',`pCrimes`= '0',`pExp`= '0',`pCash`= '0',`pKills`= '0',`pDeaths`= '0',`pWantedDeaths`= '0',`pPayCheck`= '0',`pJailed`= '0',`pJailTime`= '0',`pDrugs`= '0',`pLeader`= '0',`pMember`= '0',`pRank`= '0',`pChar`= '230',`pJob`= '0',`pHealth`= '100.000000',`pSHealth`= '0.000000',`pInt`= '0',`pLocal`= '0',`pModel`= '230',`pPnumber`= '0',`pPhoneBook`= '0',`pVhoddata`= '0',`pVhodMes`= '0',`pVhodchas`= '0',`pVhodminute`= '0',`pAlcoholPerk`= '0',`pVodPrava`= '0',`pFlyLic`= '0',`pBoatLic`= '0',`pFishLic`= '0',`pGunLic`= '0',`pBizLic`= '0',`pPhousekey`= '0',`pPbiskey`= '0',`pAvtomas`= '0',`pZakonp`= '0',`pNarcoZavisimost`= '0',`pNarcoLomka`= '0',`pSDPistol`= '0',`pDesertEagle`= '0',`pShotGun`= '0',`pMP5`= '0',`pAK47`= '0',`pM4`= '0',`pSafe`= '0',`pAptek`= '0',`pOchko`= '0',`pToilet`= '0',`pBankPass`= '0',`pBankKart`= '0',`pPayDay`= '0',`pPayDayHad`= '0',`pTut`= '1',`pWarns`= '0',`punWarns`= '0',`punWarnstime`= '0',`pFuel`= '0',`pMarried`= '0',`pMarriedTo`= '',`pDrug`= '',`pDrugmoney`= '0',`pMuteTime`= '0',`pBank`= '0',`pDonatechet`= '0',`pMobile`= '0',`pDostup`= '0',`pLocked`= '0',`pDolg`= '0',`pKrisha`= '0',`pUseKrisha`= '0',`pZvezdi`= '0',`pSlot1`='0',`pSlot2`='0',`pSlot3`='0',`pSlot4`='0',`pSlot5`='0',`pSlot6`='0',`pSlot7`='0',`pSlot8`='0',`pSlot9`='0',`pSlot10`='0',`pSlot11`='0',`pSlotammo1`='0',`pSlotammo2`='0',`pSlotammo3`='0',`pSlotammo4`='0',`pSlotammo5`='0',`pSlotammo6`='0',`pSlotammo7`='0',`pSlotammo8`='0',`pSlotammo9`='0',`pSlotammo10`='0',`pSlotammo11`='0',`pGun2`='0',`pGun3`='0',`pGun4`='0',`pGun5`='0',`pGun6`='0',`pGun7`='0',`pGun8`='0',`pGun9`='0',`pGun10`='0',`pAmmo1`='0',`pAmmo2`='0',`pAmmo3`='0',`pAmmo4`='0',`pAmmo5`='0',`pAmmo6`='0',`pAmmo7`='0',`pAmmo8`='0',`pAmmo9`='0',`pGunfbiTime`='0',`pGun51Time`='0',`pGunlspdTime`='0',`pGunaviaTime`='0',`pDrugtime`= '0',`pBoxstyle`= '0',`pKstyle`= '0',`pKickstyle`= '0',`pBoxSkill`= '0',`pKongfuSkill`= '0',`pKickboxSkill`= '0',`pKolesocar`= '0',`pPokraska`= '0',`pHouseInv`= '0',`pHouseWeapon`= '0',`pHouseWeaponAmmo`= '0',`pHouseDrugs`= '0',`pHouseMats`= '0',`pHouseMoney`= '0',`pSpoiler`= '0',`pBamper1`= '0',`pBamper2`= '0',`pCvet[0]`= '0',`pCvet[1]`= '0',`pNitro`= '0',`pKazino`= '0',`pKRank`= '0',`pKazpay`= '0',`pKSex`= '0',`pKBank`= '0',`pDonateMoney1`= '0',`pChat`= '0',`pGolos`= '0',`pSpawnChange`= '0' WHERE `Name`='Albert_Power' | i [09:44:28] ProcessQueryThread() - Query was successful. (UPDATE `accounts1` SET `pLevel`= '0',`pEmail`= '',`pAdmin`= '0',`pMestoJail`= '0',`pZvonok`= '0',`pVoennik`= '0',`pHousecash`= '0',`pText`= '0',`pHP`= '100',`pDataReg`= '',`pMes`= '0',`pGod`= '0',`pCar`= '462',`pFuelcar`= '0.000000',`pCar`= '462',`pProz`= '0',`pBeg`= '0',`pDonateRank`= '0',`pDonatemoney`= '0',`pRp`= '0',`pReg`= '0',`pMats`= '0',`pSex`= '1',`pArrested`= '0',`pMuted`= '0',`pCrimes`= '0',`pExp`= '0',`pCash`= '0',`pKills`= '0',`pDeaths`= '0',`pWantedDeaths`= '0',`pPayCheck`= '0',`pJailed`= '0',`pJailTime`= '0',`pDrugs`= '0',`pLeader`= '0',`pMember`= '0',`pRank`= '0',`pChar`= '230',`pJob`= '0',`pHealth`= '100.000000',`pSHealth`= '0.000000',`pInt`= '0',`pLocal`= '0',`pModel`= '230',`pPnumber`= '0',`pPhoneBook`= '0',`pVhoddata`= '0',`pVhodMes`= '0',`pVhodchas`= '0',`pVhodminute`= '0',`pAlcoholPerk`= '0',`pVodPrava`= '0',`pFlyLic`= '0',`pBoatLic`= '0',`pFishLic`= '0',`pGunLic`= '0',`pBizLic`= '0',`pPhousekey`= '0',`pPbiskey`= '0',`pAvtomas`= '0',`pZakonp`= '0',`pNarcoZavisimost`= '0',`pNarcoLomka`= '0',`pSDPistol`= '0',`pDesertEagle`= '0',`pShotGun`= '0',`pMP5`= '0',`pAK47`= '0',`pM4`= '0',`pSafe`= '0',`pAptek`= '0',`pOchko`= '0',`pToilet`= '0',`pBankPass`= '0',`pBankKart`= '0',`pPayDay`= '0',`pPayDayHad`= '0',`pTut`= '1',`pWarns`= '0',`punWarns`= '0',`punWarnstime`= '0',`pFuel`= '0',`pMarried`= '0',`pMarriedTo`= '',`pDrug`= '',`pDrugmoney`= '0',`pMuteTime`= '0',`pBank`= '0',`pDonatechet`= '0',`pMobile`= '0',`pDostup`= '0',`pLocked`= '0',`pDolg`= '0',`pKrisha`= '0',`pUseKrisha`= '0',`pZvezdi`= '0',`pSlot1`='0',`pSlot2`='0',`pSlot3`='0',`pSlot4`='0',`pSlot5`='0',`pSlot6`='0',`pSlot7`='0',`pSlot8`='0',`pSlot9`='0',`pSlot10`='0',`pSlot11`='0',`pSlotammo1`='0',`pSlotammo2`='0',`pSlotammo3`='0',`pSlotammo4`='0',`pSlotammo5`='0',`pSlotammo6`='0',`pSlotammo7`='0',`pSlotammo8`='0',`pSlotammo9`='0',`pSlotammo10`='0',`pSlotammo11`='0',`pGun2`='0',`pGun3`='0',`pGun4`='0',`pGun5`='0',`pGun6`='0',`pGun7`='0',`pGun8`='0',`pGun9`='0',`pGun10`='0',`pAmmo1`='0',`pAmmo2`='0',`pAmmo3`='0',`pAmmo4`='0',`pAmmo5`='0',`pAmmo6`='0',`pAmmo7`='0',`pAmmo8`='0',`pAmmo9`='0',`pGunfbiTime`='0',`pGun51Time`='0',`pGunlspdTime`='0',`pGunaviaTime`='0',`pDrugtime`= '0',`pBoxstyle`= '0',`pKstyle`= '0',`pKickstyle`= '0',`pBoxSkill`= '0',`pKongfuSkill`= '0',`pKickboxSkill`= '0',`pKolesocar`= '0',`pPokraska`= '0',`pHouseInv`= '0',`pHouseWeapon`= '0',`pHouseWeaponAmmo`= '0',`pHouseDrugs`= '0',`pHouseMats`= '0',`pHouseMoney`= '0',`pSpoiler`= '0',`pBamper1`= '0',`pBamper2`= '0',`pCvet[0]`= '0',`pCvet[1]`= '0',`pNitro`= '0',`pKazino`= '0',`pKRank`= '0',`pKazpay`= '0',`pKSex`= '0',`pKBank`= '0',`pDonateMoney1`= '0',`pChat`= '0',`pGolos`= '0',`pSpawnChange`= '0' WHERE `Name`='Albert_Power') [09:44:28] ProcessQueryThread() - Data caching enabled. [09:44:28] CMySQLHandler::StoreResult() - No data to store. [09:44:28] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick() [09:46:50] >> mysql_format( Connection handle: 1 ) [09:46:50] >> mysql_query_callback( Connection handle: 1 ) [09:46:50] Passing query UPDATE `accounts1` SET `pLevel`= '0',`pEmail`= '',`pAdmin`= '0',`pMestoJail`= '0',`pZvonok`= '0',`pVoennik`= '0',`pHousecash`= '0',`pText`= '0',`pHP`= '100',`pDataReg`= '',`pMes`= '0',`pGod`= '0',`pCar`= '462',`pFuelcar`= '0.000000',`pCar`= '462',`pProz`= '0',`pBeg`= '0',`pDonateRank`= '0',`pDonatemoney`= '0',`pRp`= '0',`pReg`= '0',`pMats`= '0',`pSex`= '1',`pArrested`= '0',`pMuted`= '0',`pCrimes`= '0',`pExp`= '0',`pCash`= '0',`pKills`= '0',`pDeaths`= '0',`pWantedDeaths`= '0',`pPayCheck`= '0',`pJailed`= '0',`pJailTime`= '0',`pDrugs`= '0',`pLeader`= '0',`pMember`= '0',`pRank`= '0',`pChar`= '230',`pJob`= '0',`pHealth`= '100.000000',`pSHealth`= '0.000000',`pInt`= '0',`pLocal`= '0',`pModel`= '230',`pPnumber`= '0',`pPhoneBook`= '0',`pVhoddata`= '0',`pVhodMes`= '0',`pVhodchas`= '0',`pVhodminute`= '0',`pAlcoholPerk`= '0',`pVodPrava`= '0',`pFlyLic`= '0',`pBoatLic`= '0',`pFishLic`= '0',`pGunLic`= '0',`pBizLic`= '0',`pPhousekey`= '0',`pPbiskey`= '0',`pAvtomas`= '0',`pZakonp`= '0',`pNarcoZavisimost`= '0',`pNarcoLomka`= '0',`pSDPistol`= '0',`pDesertEagle`= '0',`pShotGun`= '0',`pMP5`= '0',`pAK47`= '0',`pM4`= '0',`pSafe`= '0',`pAptek`= '0',`pOchko`= '0',`pToilet`= '0',`pBankPass`= '0',`pBankKart`= '0',`pPayDay`= '0',`pPayDayHad`= '0',`pTut`= '1',`pWarns`= '0',`punWarns`= '0',`punWarnstime`= '0',`pFuel`= '0',`pMarried`= '0',`pMarriedTo`= '',`pDrug`= '',`pDrugmoney`= '0',`pMuteTime`= '0',`pBank`= '0',`pDonatechet`= '0',`pMobile`= '0',`pDostup`= '0',`pLocked`= '0',`pDolg`= '0',`pKrisha`= '0',`pUseKrisha`= '0',`pZvezdi`= '0',`pSlot1`='0',`pSlot2`='0',`pSlot3`='0',`pSlot4`='0',`pSlot5`='0',`pSlot6`='0',`pSlot7`='0',`pSlot8`='0',`pSlot9`='0',`pSlot10`='0',`pSlot11`='0',`pSlotammo1`='0',`pSlotammo2`='0',`pSlotammo3`='0',`pSlotammo4`='0',`pSlotammo5`='0',`pSlotammo6`='0',`pSlotammo7`='0',`pSlotammo8`='0',`pSlotammo9`='0',`pSlotammo10`='0',`pSlotammo11`='0',`pGun2`='0',`pGun3`='0',`pGun4`='0',`pGun5`='0',`pGun6`='0',`pGun7`='0',`pGun8`='0',`pGun9`='0',`pGun10`='0',`pAmmo1`='0',`pAmmo2`='0',`pAmmo3`='0',`pAmmo4`='0',`pAmmo5`='0',`pAmmo6`='0',`pAmmo7`='0',`pAmmo8`='0',`pAmmo9`='0',`pGunfbiTime`='0',`pGun51Time`='0',`pGunlspdTime`='0',`pGunaviaTime`='0',`pDrugtime`= '0',`pBoxstyle`= '0',`pKstyle`= '0',`pKickstyle`= '0',`pBoxSkill`= '0',`pKongfuSkill`= '0',`pKickboxSkill`= '0',`pKolesocar`= '0',`pPokraska`= '0',`pHouseInv`= '0',`pHouseWeapon`= '0',`pHouseWeaponAmmo`= '0',`pHouseDrugs`= '0',`pHouseMats`= '0',`pHouseMoney`= '0',`pSpoiler`= '0',`pBamper1`= '0',`pBamper2`= '0',`pCvet[0]`= '0',`pCvet[1]`= '0',`pNitro`= '0',`pKazino`= '0',`pKRank`= '0',`pKazpay`= '0',`pKSex`= '0',`pKBank`= '0',`pDonateMoney1`= '0',`pChat`= '0',`pGolos`= '0',`pSpawnChange`= '0' WHERE `Name`='Albert_Power' | i [09:46:50] ProcessQueryThread() - Query was successful. (UPDATE `accounts1` SET `pLevel`= '0',`pEmail`= '',`pAdmin`= '0',`pMestoJail`= '0',`pZvonok`= '0',`pVoennik`= '0',`pHousecash`= '0',`pText`= '0',`pHP`= '100',`pDataReg`= '',`pMes`= '0',`pGod`= '0',`pCar`= '462',`pFuelcar`= '0.000000',`pCar`= '462',`pProz`= '0',`pBeg`= '0',`pDonateRank`= '0',`pDonatemoney`= '0',`pRp`= '0',`pReg`= '0',`pMats`= '0',`pSex`= '1',`pArrested`= '0',`pMuted`= '0',`pCrimes`= '0',`pExp`= '0',`pCash`= '0',`pKills`= '0',`pDeaths`= '0',`pWantedDeaths`= '0',`pPayCheck`= '0',`pJailed`= '0',`pJailTime`= '0',`pDrugs`= '0',`pLeader`= '0',`pMember`= '0',`pRank`= '0',`pChar`= '230',`pJob`= '0',`pHealth`= '100.000000',`pSHealth`= '0.000000',`pInt`= '0',`pLocal`= '0',`pModel`= '230',`pPnumber`= '0',`pPhoneBook`= '0',`pVhoddata`= '0',`pVhodMes`= '0',`pVhodchas`= '0',`pVhodminute`= '0',`pAlcoholPerk`= '0',`pVodPrava`= '0',`pFlyLic`= '0',`pBoatLic`= '0',`pFishLic`= '0',`pGunLic`= '0',`pBizLic`= '0',`pPhousekey`= '0',`pPbiskey`= '0',`pAvtomas`= '0',`pZakonp`= '0',`pNarcoZavisimost`= '0',`pNarcoLomka`= '0',`pSDPistol`= '0',`pDesertEagle`= '0',`pShotGun`= '0',`pMP5`= '0',`pAK47`= '0',`pM4`= '0',`pSafe`= '0',`pAptek`= '0',`pOchko`= '0',`pToilet`= '0',`pBankPass`= '0',`pBankKart`= '0',`pPayDay`= '0',`pPayDayHad`= '0',`pTut`= '1',`pWarns`= '0',`punWarns`= '0',`punWarnstime`= '0',`pFuel`= '0',`pMarried`= '0',`pMarriedTo`= '',`pDrug`= '',`pDrugmoney`= '0',`pMuteTime`= '0',`pBank`= '0',`pDonatechet`= '0',`pMobile`= '0',`pDostup`= '0',`pLocked`= '0',`pDolg`= '0',`pKrisha`= '0',`pUseKrisha`= '0',`pZvezdi`= '0',`pSlot1`='0',`pSlot2`='0',`pSlot3`='0',`pSlot4`='0',`pSlot5`='0',`pSlot6`='0',`pSlot7`='0',`pSlot8`='0',`pSlot9`='0',`pSlot10`='0',`pSlot11`='0',`pSlotammo1`='0',`pSlotammo2`='0',`pSlotammo3`='0',`pSlotammo4`='0',`pSlotammo5`='0',`pSlotammo6`='0',`pSlotammo7`='0',`pSlotammo8`='0',`pSlotammo9`='0',`pSlotammo10`='0',`pSlotammo11`='0',`pGun2`='0',`pGun3`='0',`pGun4`='0',`pGun5`='0',`pGun6`='0',`pGun7`='0',`pGun8`='0',`pGun9`='0',`pGun10`='0',`pAmmo1`='0',`pAmmo2`='0',`pAmmo3`='0',`pAmmo4`='0',`pAmmo5`='0',`pAmmo6`='0',`pAmmo7`='0',`pAmmo8`='0',`pAmmo9`='0',`pGunfbiTime`='0',`pGun51Time`='0',`pGunlspdTime`='0',`pGunaviaTime`='0',`pDrugtime`= '0',`pBoxstyle`= '0',`pKstyle`= '0',`pKickstyle`= '0',`pBoxSkill`= '0',`pKongfuSkill`= '0',`pKickboxSkill`= '0',`pKolesocar`= '0',`pPokraska`= '0',`pHouseInv`= '0',`pHouseWeapon`= '0',`pHouseWeaponAmmo`= '0',`pHouseDrugs`= '0',`pHouseMats`= '0',`pHouseMoney`= '0',`pSpoiler`= '0',`pBamper1`= '0',`pBamper2`= '0',`pCvet[0]`= '0',`pCvet[1]`= '0',`pNitro`= '0',`pKazino`= '0',`pKRank`= '0',`pKazpay`= '0',`pKSex`= '0',`pKBank`= '0',`pDonateMoney1`= '0',`pChat`= '0',`pGolos`= '0',`pSpawnChange`= '0' WHERE `Name`='Albert_Power')