I don't know what is wrong..
PHP код:
//
// Save date mysql. (MySql)
//
#include <a_samp>
forward OnPlayerUpdateReg(playerid);
forward OnPlayerUpdatePayDay(playerid);
forward OnPlayerDateUpdate(playerid);
forward Update(playerid,type);
forward UpdateHouse(houseid,type);
//-----------------------------Players-----------------------------
#define pLevelx 1
#define pAdminx 2
#define pVipx 3
#define pHelperx 4
#define pDonateRankx 5
#define gPupgradex 6
#define pConnectTimex 7
#define pRegx 8
#define pSexx 9
#define pAgex 10
#define pOriginx 11
#define pCKx 12
#define pMutedx 13
#define pMuteTimex 14
#define pExpx 15
#define pCashx 16
#define pAccountx 17
#define pCrimesx 18
#define pKillsx 19
#define pDeathsx 20
#define pArrestedx 21
#define pWantedDeathsx 22
#define pPhoneBookx 23
#define pLottoNrx 24
#define pFishesx 25
#define pBiggestFishx 26
#define pJobx 27
#define pClockx 28
#define pSmokex 29
#define pColorx 30
#define pPaintJobx 31
#define pBeerx 32
#define pRefererx 33
#define pSpawnChangex 34
#define pAdmkicksx 35
#define pAdmbansx 36
#define pAdmwarnsx 37
#define pAdmallcmdsx 38
#define pTowCarRegx 39
#define pSpeedox 40
#define pRobbedx 41
#define pRobbingx 42
#define pCRReportx 43
#define pCRNeedHelpx 44
#define pPayCheckx 45
#define pHeadValuex 46
#define pJailedx 47
#define pJailTimex 48
#define pBlackListx 49
#define pBLTimex 50
#define pMatsx 51
#define pDrugsx 52
#define pLeaderx 53
#define pMemberx 54
#define pRankx 55
#define pCharx 56
#define pContractTimex 57
#define pDetSkillx 58
#define pSexSkillx 59
#define pBoxSkillx 60
#define pLawSkillx 61
#define pMechSkillx 62
#define pJackSkillx 63
#define pCarSkillx 64
#define pNewsSkillx 65
#define pDrugsSkillx 66
#define pFishSkillx 67
#define pSHealthx 68
#define pIntx 69
#define pWorldx 70
#define pLocalx 71
#define pTeamx 72
#define pModelx 73
#define pPnumberx 74
#define pPcarkeyx 75
#define pPhelikeyx 76
#define pPmotokeyx 77
#define pPhousekeyx 78
#define pPbiskeyx 79
#define pCarLicx 80
#define pFlyLicx 81
#define pBoatLicx 82
#define pFishLicx 83
#define pGunLicx 84
#define pFSx 85
#define pCarTimex 86
#define pMotoLicx 87
#define pCDPlayerx 88
#define pWinsx 89
#define pLosesx 90
#define pAlcoholPerkx 91
#define pDrugPerkx 92
#define pMiserPerkx 93
#define pPainPerkx 94
#define pTraderPerkx 95
#define pTutx 96
#define pMissionNrx 97
#define pWarnsx 98
#define pFwarnx 99
#define pAWarnsx 100
#define pFuelx 101
#define pWantedLevelx 102
#define pMarriedx 103
#define pMarriedTox 104
#define pNameChangedx 105
#define pMedicalBillx 106
#define pVipTimex 107
#define pBanTimex 108
#define pFactionTimex 109
#define pLoginTimex 110
#define pPVipx 111
#define pEmailx 112
#define pSocketTimex 113
#define pHelperTimex 114
#define pVipTime2x 115
#define pEmail2x 116
#define pForcePassx 117
#define pUClockx 118
#define pUAdvertisex 119
#define pUPhonex 120
#define pUNewsx 121
#define pUFamilyx 122
#define pUOOCx 123
#define pUWhisperx 124
#define pUFeventx 125
#define pSocketx 126
#define pCandidatx 127
#define pVotatDex 128
#define pAVotatx 129
#define pAdmStatusColorx 131
#define pAdmStatusx 130
#define pArrestNrx 132
#define pRunnerNrx 133
#define pAmenziNrx 134
#define pIsOnlinex 135
#define p10Orex 136
#define p20Orex 137
#define p30Orex 138
#define p40Orex 139
#define p50Orex 140
#define p100Orex 141
#define p150Orex 142
#define p200Orex 143
#define p250Orex 144
#define p300Orex 145
#define p500Orex 146
#define p700Orex 147
#define p1000Orex 148
enum pInfo
{
pKey[128],pLevel,pAdmin,pVip,pHelper,pExamen,pDisabled,pDonateRank,gPupgrade,
pConnectTime,pReg,pSex,pAge,pOrigin,pCK,pMuted,pMuteTime,pExp,pCash,pAccount,
pCrimes,pKills,pDeaths,pArrested,pWantedDeaths,pPhoneBook,pLottoNr,
pFishes,pBiggestFish,pJob,pPayCheck,pHeadValue,pJailed,pJailTime,pBlackList,
pBLTime,pMats,pDrugs,pLeader,pMember,pRank,pChar,Float:pPower,
pRunLevel,pReps,IsUsingRunningMachine,IsUsingWeight,IsUsingBike,pContractTime,
pDetSkill,pSexSkill,pBoxSkill,pLawSkill,pMechSkill,pJackSkill,pCarSkill,pNewsSkill,
pDrugsSkill,pFishSkill,Float:pSHealth,pInt,pWorld,pLocal,pTeam,pModel,pPnumber,
pPhousekey,pPcarkey,pPhelikey,pPmotokey,pPbiskey,pWantedLevel,pCarLic,pFlyLic,
pBoatLic,pFishLic,pGunLic,pCarTime,pMotoLic,pAWarns,pCDPlayer,pWins,pLoses,
pAlcoholPerk,pDrugPerk,pMiserPerk,pPainPerk,pTraderPerk,pTut,pMissionNr,pWarns,
pFwarn,pFuel,pFS,pClock,pSmoke,pColor,pPaintJob,pSpray,pBeer,pReferer,pSpawnChange,
pAdmkicks,pAdmbans,pAdmwarns,pAdmallcmds,pTowCarReg,pSpeedo,pRobbing,pRobbed,
pCRReport,pCRNeedHelp,pMask,pMaskuse,pSaveWalk,pMarried,pMarriedTo[128],
pNameChanged,pMedicalBill,pVipTime,pBanTime,pFactionTime,pLoginTime,pPVip,
pEmail[60],pHelperTime,pVipTime2,pEmail2,pForcePass,pUClock,pUAdvertise,
pUPhone,pUNews,pUFamily,pUOOC,pUWhisper,pUFevent,pSocket,pSocketTime,pCandidat,pVotatDe,pAVotat,
pAdmStatus[256],pAdmStatusColor[8],prDisabled,pArrestNr,pRunnerNr,pAmenziNr,pIsOnline,p10Ore,p20Ore,
p30Ore,p40Ore,p50Ore,p100Ore,p150Ore,p200Ore,p250Ore,p300Ore,p500Ore,p700Ore,p1000Ore
};
new PlayerInfo[MAX_PLAYERS][pInfo];
//-----------------------------Houses-----------------------------
#define MAX_HOUSE 91
#define hEntrancexx 1
#define hEntranceyx 2
#define hEntrancezx 3
#define hExitxx 4
#define hExityx 5
#define hExitzx 6
#define hHealthxx 7
#define hHealthyx 8
#define hHealthzx 9
#define hArmourxx 10
#define hArmouryx 11
#define hArmourzx 12
#define hOwnerx 13
#define hDiscriptionx 14
#define hValuex 15
#define hHelx 16
#define hArmx 17
#define hIntx 18
#define hLockx 19
#define hOwnedx 20
#define hRoomsx 21
#define hRentx 22
#define hRentabilx 23
#define hMoneyx 24
#define hDatex 25
#define hLevelx 26
#define hWorldx 27
#define hMatsx 28
#define hDrugsx 29
enum hInfo
{
Float:hEntrancex,Float:hEntrancey,Float:hEntrancez,Float:hExitx,Float:hExity,Float:hExitz,
hHealthx,hHealthy,hHealthz,hArmourx,hArmoury,hArmourz,hOwner[MAX_PLAYER_NAME],hDiscription[MAX_PLAYER_NAME],
hValue,hHel,hArm,hInt,hLock,hOwned,hRooms,hRent,hRentabil,hMoney,hDate,hLevel,hWorld,hMats,hDrugs
};
new HouseInfo[MAX_HOUSE][hInfo];
public Update(playerid,type)
{
if(IsPlayerConnected(playerid))
{
new var[100];new playerName[MAX_PLAYER_NAME];new var2[256];
GetPlayerName(playerid, playerName, sizeof(playerName));
{
switch(type)
{
case pLevelx:
{
format(var, 100, "UPDATE `players` SET `Level`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pLevel],playerName);
mysql_query(var);
}
case pAdminx:
{
format(var, 100, "UPDATE `players` SET `AdminLevel`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pAdmin],playerName);
mysql_query(var);
}
case pVipx:
{
format(var, 100, "UPDATE `players` SET `VipLevel`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pVip],playerName);
mysql_query(var);
}
case pHelperx:
{
format(var, 100, "UPDATE `players` SET `Helper`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pHelper],playerName);
mysql_query(var);
}
case pDonateRankx:
{
format(var, 100, "UPDATE `players` SET `DonateRank`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pDonateRank],playerName);
mysql_query(var);
}
case gPupgradex:
{
format(var, 100, "UPDATE `players` SET `UpgradePoints`='%d' WHERE `username`='%s'",PlayerInfo[playerid][gPupgrade],playerName);
mysql_query(var);
}
case pConnectTimex:
{
format(var, 100, "UPDATE `players` SET `ConnectedTime`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pConnectTime],playerName);
mysql_query(var);
}
case pRegx:
{
format(var, 100, "UPDATE `players` SET `Registered`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pReg],playerName);
mysql_query(var);
}
case pSexx:
{
format(var, 100, "UPDATE `players` SET `Sex`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pSex],playerName);
mysql_query(var);
}
case pAgex:
{
format(var, 100, "UPDATE `players` SET `Age`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pAge],playerName);
mysql_query(var);
}
case pOriginx:
{
format(var, 100, "UPDATE `players` SET `Origin`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pOrigin],playerName);
mysql_query(var);
}
case pCKx:
{
format(var, 100, "UPDATE `players` SET `CK`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pCK],playerName);
mysql_query(var);
}
case pMutedx:
{
format(var, 100, "UPDATE `players` SET `Muted`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pMuted],playerName);
mysql_query(var);
}
case pMuteTimex:
{
format(var, 100, "UPDATE `players` SET `MuteTime`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pMuteTime],playerName);
mysql_query(var);
}
case pExpx:
{
format(var, 100, "UPDATE `players` SET `Respect`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pExp],playerName);
mysql_query(var);
}
case pCashx:
{
format(var, 100, "UPDATE `players` SET `Money`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pCash],playerName);
mysql_query(var);
}
case pAccountx:
{
format(var, 100, "UPDATE `players` SET `Bank`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pAccount],playerName);
mysql_query(var);
}
case pCrimesx:
{
format(var, 100, "UPDATE `players` SET `Crimes`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pCrimes],playerName);
mysql_query(var);
}
case pKillsx:
{
format(var, 100, "UPDATE `players` SET `Kills`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pKills],playerName);
mysql_query(var);
}
case pDeathsx:
{
format(var, 100, "UPDATE `players` SET `Deaths`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pDeaths],playerName);
mysql_query(var);
}
case pArrestedx:
{
format(var, 100, "UPDATE `players` SET `Arrested`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pArrested],playerName);
mysql_query(var);
}
case pWantedDeathsx:
{
format(var, 100, "UPDATE `players` SET `WantedDeaths`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pWantedDeaths],playerName);
mysql_query(var);
}
case pPhoneBookx:
{
format(var, 100, "UPDATE `players` SET `Phonebook`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pPhoneBook],playerName);
mysql_query(var);
}
case pLottoNrx:
{
format(var, 100, "UPDATE `players` SET `LottoNr`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pLottoNr],playerName);
mysql_query(var);
}
case pFishesx:
{
format(var, 100, "UPDATE `players` SET `Fishes`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pFishes],playerName);
mysql_query(var);
}
case pBiggestFishx:
{
format(var, 100, "UPDATE `players` SET `BiggestFish`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pBiggestFish],playerName);
mysql_query(var);
}
case pJobx:
{
format(var, 100, "UPDATE `players` SET `Job`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pJob],playerName);
mysql_query(var);
}
case pClockx:
{
format(var, 100, "UPDATE `players` SET `Clock`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pClock],playerName);
mysql_query(var);
}
case pSmokex:
{
format(var, 100, "UPDATE `players` SET `Smoke`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pSmoke],playerName);
mysql_query(var);
}
case pColorx:
{
format(var, 100, "UPDATE `players` SET `Color`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pColor],playerName);
mysql_query(var);
}
case pPaintJobx:
{
format(var, 100, "UPDATE `players` SET `PaintJob`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pPaintJob],playerName);
mysql_query(var);
}
case pBeerx:
{
format(var, 100, "UPDATE `players` SET `Beer`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pBeer],playerName);
mysql_query(var);
}
case pRefererx:
{
format(var, 100, "UPDATE `players` SET `Referer`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pReferer],playerName);
mysql_query(var);
}
case pSpawnChangex:
{
format(var, 100, "UPDATE `players` SET `SpawnChange`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pSpawnChange],playerName);
mysql_query(var);
}
case pAdmkicksx:
{
format(var, 100, "UPDATE `players` SET `Admkicks`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pAdmkicks],playerName);
mysql_query(var);
}
case pAdmbansx:
{
format(var, 100, "UPDATE `players` SET `Admbans`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pAdmbans],playerName);
mysql_query(var);
}
case pAdmwarnsx:
{
format(var, 100, "UPDATE `players` SET `Admwarns`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pAdmwarns],playerName);
mysql_query(var);
}
case pAdmallcmdsx:
{
format(var, 100, "UPDATE `players` SET `Admallcmds`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pAdmallcmds],playerName);
mysql_query(var);
}
case pTowCarRegx:
{
format(var, 100, "UPDATE `players` SET `TowCarReg`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pTowCarReg],playerName);
mysql_query(var);
}
case pSpeedox:
{
format(var, 100, "UPDATE `players` SET `Speedo`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pSpeedo],playerName);
mysql_query(var);
}
case pRobbedx:
{
format(var, 100, "UPDATE `players` SET `Robbed`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pRobbed],playerName);
mysql_query(var);
}
case pRobbingx:
{
format(var, 100, "UPDATE `players` SET `Robbing`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pRobbing],playerName);
mysql_query(var);
}
case pCRReportx:
{
format(var, 100, "UPDATE `players` SET `CRReport`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pCRReport],playerName);
mysql_query(var);
}
case pCRNeedHelpx:
{
format(var, 100, "UPDATE `players` SET `CRNeedHelp`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pCRNeedHelp],playerName);
mysql_query(var);
}
case pPayCheckx:
{
format(var, 100, "UPDATE `players` SET `Paycheck`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pPayCheck],playerName);
mysql_query(var);
}
case pHeadValuex:
{
format(var, 100, "UPDATE `players` SET `HeadValue`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pHeadValue],playerName);
mysql_query(var);
}
case pJailedx:
{
format(var, 100, "UPDATE `players` SET `Jailed`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pJailed],playerName);
mysql_query(var);
}
case pJailTimex:
{
format(var, 100, "UPDATE `players` SET `JailTime`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pJailTime],playerName);
mysql_query(var);
}
case pBlackListx:
{
format(var, 100, "UPDATE `players` SET `BlackList`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pBlackList],playerName);
mysql_query(var);
}
case pBLTimex:
{
format(var, 100, "UPDATE `players` SET `BlackListTime`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pBLTime],playerName);
mysql_query(var);
}
case pMatsx:
{
format(var, 100, "UPDATE `players` SET `Materials`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pMats],playerName);
mysql_query(var);
}
case pDrugsx:
{
format(var, 100, "UPDATE `players` SET `Drugs`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pDrugs],playerName);
mysql_query(var);
}
case pLeaderx:
{
format(var, 100, "UPDATE `players` SET `Leader`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pLeader],playerName);
mysql_query(var);
}
case pMemberx:
{
format(var, 100, "UPDATE `players` SET `Member`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pMember],playerName);
mysql_query(var);
}
case pRankx:
{
format(var, 100, "UPDATE `players` SET `Rank`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pRank],playerName);
mysql_query(var);
}
case pCharx:
{
format(var, 100, "UPDATE `players` SET `cChar`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pChar],playerName);
mysql_query(var);
}
case pContractTimex:
{
format(var, 100, "UPDATE `players` SET `ContractTime`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pContractTime],playerName);
mysql_query(var);
}
case pDetSkillx:
{
format(var, 100, "UPDATE `players` SET `DetSkill`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pDetSkill],playerName);
mysql_query(var);
}
case pSexSkillx:
{
format(var, 100, "UPDATE `players` SET `SexSkill`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pSexSkill],playerName);
mysql_query(var);
}
case pBoxSkillx:
{
format(var, 100, "UPDATE `players` SET `BoxSkill`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pBoxSkill],playerName);
mysql_query(var);
}
case pLawSkillx:
{
format(var, 100, "UPDATE `players` SET `LawSkill`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pLawSkill],playerName);
mysql_query(var);
}
case pMechSkillx:
{
format(var, 100, "UPDATE `players` SET `MechSkill`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pMechSkill],playerName);
mysql_query(var);
}
case pJackSkillx:
{
format(var, 100, "UPDATE `players` SET `JackSkill`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pJackSkill],playerName);
mysql_query(var);
}
case pCarSkillx:
{
format(var, 100, "UPDATE `players` SET `CarSkill`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pCarSkill],playerName);
mysql_query(var);
}
case pNewsSkillx:
{
format(var, 100, "UPDATE `players` SET `NewsSkill`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pNewsSkill],playerName);
mysql_query(var);
}
case pDrugsSkillx:
{
format(var, 100, "UPDATE `players` SET `DrugsSkill`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pDrugsSkill],playerName);
mysql_query(var);
}
case pFishSkillx:
{
format(var, 100, "UPDATE `players` SET `FishSkill`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pFishSkill],playerName);
mysql_query(var);
}
case pSHealthx:
{
format(var, 100, "UPDATE `players` SET `pSHealth`='%.1f' WHERE `username`='%s'",PlayerInfo[playerid][pSHealth],playerName);
mysql_query(var);
}
case pIntx:
{
format(var, 100, "UPDATE `players` SET `iInt`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pInt],playerName);
mysql_query(var);
}
case pWorldx:
{
format(var, 100, "UPDATE `players` SET `VWorld`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pWorld],playerName);
mysql_query(var);
}
case pLocalx:
{
format(var, 100, "UPDATE `players` SET `Local`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pLocal],playerName);
mysql_query(var);
}
case pTeamx:
{
format(var, 100, "UPDATE `players` SET `Team`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pTeam],playerName);
mysql_query(var);
}
case pModelx:
{
format(var, 100, "UPDATE `players` SET `Model`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pModel],playerName);
mysql_query(var);
}
case pPnumberx:
{
format(var, 100, "UPDATE `players` SET `PhoneNr`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pPnumber],playerName);
mysql_query(var);
}
case pPcarkeyx:
{
format(var, 100, "UPDATE `players` SET `Car`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pPcarkey],playerName);
mysql_query(var);
}
case pPhelikeyx:
{
format(var, 100, "UPDATE `players` SET `Heli`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pPhelikey],playerName);
mysql_query(var);
}
case pPmotokeyx:
{
format(var, 100, "UPDATE `players` SET `Moto`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pPmotokey],playerName);
mysql_query(var);
}
case pPhousekeyx:
{
format(var, 100, "UPDATE `players` SET `House`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pPhousekey],playerName);
mysql_query(var);
}
case pPbiskeyx:
{
format(var, 100, "UPDATE `players` SET `Bizz`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pPbiskey],playerName);
mysql_query(var);
}
case pWantedLevelx:
{
format(var, 100, "UPDATE `players` SET `WantedLevel`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pWantedLevel],playerName);
mysql_query(var);
}
case pCarLicx:
{
format(var, 100, "UPDATE `players` SET `CarLic`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pCarLic],playerName);
mysql_query(var);
}
case pFlyLicx:
{
format(var, 100, "UPDATE `players` SET `FlyLic`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pFlyLic],playerName);
mysql_query(var);
}
case pBoatLicx:
{
format(var, 100, "UPDATE `players` SET `BoatLic`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pBoatLic],playerName);
mysql_query(var);
}
case pFishLicx:
{
format(var, 100, "UPDATE `players` SET `FishLic`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pFishLic],playerName);
mysql_query(var);
}
case pGunLicx:
{
format(var, 100, "UPDATE `players` SET `GunLic`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pGunLic],playerName);
mysql_query(var);
}
case pFSx:
{
format(var, 100, "UPDATE `players` SET `Fighting`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pFS],playerName);
mysql_query(var);
}
case pCarTimex:
{
format(var, 100, "UPDATE `players` SET `CarTime`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pCarTime],playerName);
mysql_query(var);
}
case pMotoLicx:
{
format(var, 100, "UPDATE `players` SET `MotoLic`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pMotoLic],playerName);
mysql_query(var);
}
case pCDPlayerx:
{
format(var, 100, "UPDATE `players` SET `CDPlayer`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pCDPlayer],playerName);
mysql_query(var);
}
case pWinsx:
{
format(var, 100, "UPDATE `players` SET `Wins`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pWins],playerName);
mysql_query(var);
}
case pLosesx:
{
format(var, 100, "UPDATE `players` SET `Loses`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pLoses],playerName);
mysql_query(var);
}
case pAlcoholPerkx:
{
format(var, 100, "UPDATE `players` SET `AlcoholPerk`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pAlcoholPerk],playerName);
mysql_query(var);
}
case pDrugPerkx:
{
format(var, 100, "UPDATE `players` SET `DrugPerk`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pDrugPerk],playerName);
mysql_query(var);
}
case pMiserPerkx:
{
format(var, 100, "UPDATE `players` SET `MiserPerk`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pMiserPerk],playerName);
mysql_query(var);
}
case pPainPerkx:
{
format(var, 100, "UPDATE `players` SET `PainPerk`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pPainPerk],playerName);
mysql_query(var);
}
case pTraderPerkx:
{
format(var, 100, "UPDATE `players` SET `TraderPerk`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pTraderPerk],playerName);
mysql_query(var);
}
case pTutx:
{
format(var, 100, "UPDATE `players` SET `Tutorial`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pTut],playerName);
mysql_query(var);
}
case pMissionNrx:
{
format(var, 100, "UPDATE `players` SET `Mission`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pMissionNr],playerName);
mysql_query(var);
}
case pWarnsx:
{
format(var, 100, "UPDATE `players` SET `Warnings`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pWarns],playerName);
mysql_query(var);
}
case pFwarnx:
{
format(var, 100, "UPDATE `players` SET `Fwarn`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pFwarn],playerName);
mysql_query(var);
}
case pAWarnsx:
{
format(var, 100, "UPDATE `players` SET `AdminWarnings`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pAWarns],playerName);
mysql_query(var);
}
case pFuelx:
{
format(var, 100, "UPDATE `players` SET `Fuel`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pFuel],playerName);
mysql_query(var);
}
case pMarriedx:
{
format(var, 100, "UPDATE `players` SET `Married`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pMarried],playerName);
mysql_query(var);
}
case pMarriedTox:
{
format(var, 100, "UPDATE `players` SET `MarriedTo`='%s' WHERE `username`='%s'",PlayerInfo[playerid][pMarriedTo],playerName);
mysql_query(var);
}
case pNameChangedx:
{
format(var, 100, "UPDATE `players` SET `NameChanged`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pNameChanged],playerName);
mysql_query(var);
}
case pMedicalBillx:
{
format(var, 100, "UPDATE `players` SET `MedicalBill`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pMedicalBill],playerName);
mysql_query(var);
}
case pVipTimex:
{
format(var, 100, "UPDATE `players` SET `VipTime`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pVipTime],playerName);
mysql_query(var);
}
case pBanTimex:
{
format(var, 100, "UPDATE `players` SET `BanTime`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pBanTime],playerName);
mysql_query(var);
}
case pFactionTimex:
{
format(var, 100, "UPDATE `players` SET `FactionTime`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pFactionTime],playerName);
mysql_query(var);
}
case pLoginTimex:
{
format(var, 100, "UPDATE `players` SET `LoginTime`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pLoginTime],playerName);
mysql_query(var);
}
case pPVipx:
{
format(var, 100, "UPDATE `players` SET `PVip`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pPVip],playerName);
mysql_query(var);
}
case pEmailx:
{
format(var, 100, "UPDATE `players` SET `Email`='%s' WHERE `username`='%s'",PlayerInfo[playerid][pEmail],playerName);
mysql_query(var);
}
case pHelperTimex:
{
format(var, 100, "UPDATE `players` SET `HelperTime`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pHelperTime],playerName);
mysql_query(var);
}
case pVipTime2x:
{
format(var, 100, "UPDATE `players` SET `VipTime2`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pVipTime2],playerName);
mysql_query(var);
}
case pEmail2x:
{
format(var, 100, "UPDATE `players` SET `Email2`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pEmail2],playerName);
mysql_query(var);
}
case pForcePassx:
{
format(var, 100, "UPDATE `players` SET `ForcePass`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pForcePass],playerName);
mysql_query(var);
}
case pUClockx:
{
format(var, 100, "UPDATE `players` SET `UClock`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pUClock],playerName);
mysql_query(var);
}
case pUAdvertisex:
{
format(var, 100, "UPDATE `players` SET `UAdvertise`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pUAdvertise],playerName);
mysql_query(var);
}
case pUPhonex:
{
format(var, 100, "UPDATE `players` SET `UPhone`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pUPhone],playerName);
mysql_query(var);
}
case pUNewsx:
{
format(var, 100, "UPDATE `players` SET `UNews`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pUNews],playerName);
mysql_query(var);
}
case pUFamilyx:
{
format(var, 100, "UPDATE `players` SET `UFamily`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pUFamily],playerName);
mysql_query(var);
}
case pUOOCx:
{
format(var, 100, "UPDATE `players` SET `UOOC`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pUOOC],playerName);
mysql_query(var);
}
case pUWhisperx:
{
format(var, 100, "UPDATE `players` SET `UWhisper`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pUWhisper],playerName);
mysql_query(var);
}
case pUFeventx:
{
format(var, 100, "UPDATE `players` SET `UFevent`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pUFevent],playerName);
mysql_query(var);
}
case pSocketx:
{
format(var, 100, "UPDATE `players` SET `Socket`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pSocket],playerName);
mysql_query(var);
}
case pSocketTimex:
{
format(var, 100, "UPDATE `players` SET `SocketTime`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pSocketTime],playerName);
mysql_query(var);
}
case pCandidatx:
{
format(var, 100, "UPDATE `players` SET `Candidat`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pCandidat],playerName);
mysql_query(var);
}
case pVotatDex:
{
format(var, 100, "UPDATE `players` SET `VotatDe`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pVotatDe],playerName);
mysql_query(var);
}
case pAVotatx:
{
format(var, 100, "UPDATE `players` SET `AVotat`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pAVotat],playerName);
mysql_query(var);
}
case pAdmStatusColorx:
{
format(var2, 256, "UPDATE `players` SET `AdmStatusColor`='%s' WHERE `username`='%s'",PlayerInfo[playerid][pAdmStatusColor],playerName);
mysql_query(var2);
}
case pAdmStatusx:
{
format(var2, 256, "UPDATE `players` SET `AdmStatus`='%s' WHERE `username`='%s'",PlayerInfo[playerid][pAdmStatus],playerName);
mysql_query(var2);
}
case pArrestNrx:
{
format(var, 256, "UPDATE `players` SET `ArrestNr`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pArrestNr],playerName);
mysql_query(var);
}
case pRunnerNrx:
{
format(var, 256, "UPDATE `players` SET `RunnerNr`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pRunnerNr],playerName);
mysql_query(var);
}
case pAmenziNrx:
{
format(var, 256, "UPDATE `players` SET `AmenziNr`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pAmenziNr],playerName);
mysql_query(var);
}
case pIsOnlinex:
{
format(var, 256, "UPDATE `players` SET `IsOnline`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pIsOnline],playerName);
mysql_query(var);
}
case p10Orex:
{
format(var, 100, "UPDATE `players` SET `10Ore`='%d' WHERE `username`='%s'",PlayerInfo[playerid][p10Orex],playerName);
mysql_query(var);
}
case p20Orex:
{
format(var, 100, "UPDATE `players` SET `20Ore`='%d' WHERE `username`='%s'",PlayerInfo[playerid][p20Orex],playerName);
mysql_query(var);
}
case p30Orex:
{
format(var, 100, "UPDATE `players` SET `30Ore`='%d' WHERE `username`='%s'",PlayerInfo[playerid][p30Orex],playerName);
mysql_query(var);
}
case p40Orex:
{
format(var, 100, "UPDATE `players` SET `40Ore`='%d' WHERE `username`='%s'",PlayerInfo[playerid][p40Orex],playerName);
mysql_query(var);
}
case p50Orex:
{
format(var, 100, "UPDATE `players` SET `50Ore`='%d' WHERE `username`='%s'",PlayerInfo[playerid][p50Orex],playerName);
mysql_query(var);
}
case p100Orex:
{
format(var, 100, "UPDATE `players` SET `100Ore`='%d' WHERE `username`='%s'",PlayerInfo[playerid][p100Orex],playerName);
mysql_query(var);
}
case p150Orex:
{
format(var, 100, "UPDATE `players` SET `150Ore`='%d' WHERE `username`='%s'",PlayerInfo[playerid][p150Orex],playerName);
mysql_query(var);
}
case p200Orex:
{
format(var, 100, "UPDATE `players` SET `200Ore`='%d' WHERE `username`='%s'",PlayerInfo[playerid][p200Orex],playerName);
mysql_query(var);
}
case p250Orex:
{
format(var, 100, "UPDATE `players` SET `250Ore`='%d' WHERE `username`='%s'",PlayerInfo[playerid][p250Orex],playerName);
mysql_query(var);
}
case p300Orex:
{
format(var, 100, "UPDATE `players` SET `300Ore`='%d' WHERE `username`='%s'",PlayerInfo[playerid][p300Orex],playerName);
mysql_query(var);
}
case p500Orex:
{
format(var, 100, "UPDATE `players` SET `500Ore`='%d' WHERE `username`='%s'",PlayerInfo[playerid][p500Orex],playerName);
mysql_query(var);
}
case p700Orex:
{
format(var, 100, "UPDATE `players` SET `700Ore`='%d' WHERE `username`='%s'",PlayerInfo[playerid][p700Orex],playerName);
mysql_query(var);
}
case p1000Orex:
{
format(var, 100, "UPDATE `players` SET `1000Ore`='%d' WHERE `username`='%s'",PlayerInfo[playerid][p1000Orex],playerName);
mysql_query(var);
}
}
}
}
return 1;
}
public UpdateHouse(houseid,type)
{
new var[100];
switch(type)
{
case hEntrancexx:
{
format(var, 100, "UPDATE `houses` SET `hEntrancex`='%f' WHERE `id`='%d'",HouseInfo[houseid][hEntrancex],houseid);
mysql_query(var);
}
case hEntranceyx:
{
format(var, 100, "UPDATE `houses` SET `hEntrancey`='%f' WHERE `id`='%d'",HouseInfo[houseid][hEntrancey],houseid);
mysql_query(var);
}
case hEntrancezx:
{
format(var, 100, "UPDATE `houses` SET `hEntrancez`='%f' WHERE `id`='%d'",HouseInfo[houseid][hEntrancez],houseid);
mysql_query(var);
}
case hExitxx:
{
format(var, 100, "UPDATE `houses` SET `hExitx`='%f' WHERE `id`='%d'",HouseInfo[houseid][hExitx],houseid);
mysql_query(var);
}
case hExityx:
{
format(var, 100, "UPDATE `houses` SET `hExity`='%f' WHERE `id`='%d'",HouseInfo[houseid][hExity],houseid);
mysql_query(var);
}
case hExitzx:
{
format(var, 100, "UPDATE `houses` SET `hExitz`='%f' WHERE `id`='%d'",HouseInfo[houseid][hExitz],houseid);
mysql_query(var);
}
case hHealthxx:
{
format(var, 100, "UPDATE `houses` SET `hHealthx`='%d' WHERE `id`='%d'",HouseInfo[houseid][hHealthx],houseid);
mysql_query(var);
}
case hHealthyx:
{
format(var, 100, "UPDATE `houses` SET `hHealthy`='%d' WHERE `id`='%d'",HouseInfo[houseid][hHealthy],houseid);
mysql_query(var);
}
case hHealthzx:
{
format(var, 100, "UPDATE `houses` SET `hHealthz`='%d' WHERE `id`='%d'",HouseInfo[houseid][hHealthz],houseid);
mysql_query(var);
}
case hArmourxx:
{
format(var, 100, "UPDATE `houses` SET `hArmourx`='%d' WHERE `id`='%d'",HouseInfo[houseid][hArmourx],houseid);
mysql_query(var);
}
case hArmouryx:
{
format(var, 100, "UPDATE `houses` SET `hArmoury`='%d' WHERE `id`='%d'",HouseInfo[houseid][hArmoury],houseid);
mysql_query(var);
}
case hArmourzx:
{
format(var, 100, "UPDATE `houses` SET `hArmourz`='%d' WHERE `id`='%d'",HouseInfo[houseid][hArmourz],houseid);
mysql_query(var);
}
case hOwnerx:
{
format(var, 100, "UPDATE `houses` SET `hOwner`='%s' WHERE `id`='%d'",HouseInfo[houseid][hOwner],houseid);
mysql_query(var);
}
case hDiscriptionx:
{
format(var, 100, "UPDATE `houses` SET `hDiscription`='%s' WHERE `id`='%d'",HouseInfo[houseid][hDiscription],houseid);
mysql_query(var);
}
case hValuex:
{
format(var, 100, "UPDATE `houses` SET `hValue`='%d' WHERE `id`='%d'",HouseInfo[houseid][hValue],houseid);
mysql_query(var);
}
case hHelx:
{
format(var, 100, "UPDATE `houses` SET `hHel`='%d' WHERE `id`='%d'",HouseInfo[houseid][hHel],houseid);
mysql_query(var);
}
case hArmx:
{
format(var, 100, "UPDATE `houses` SET `hArm`='%d' WHERE `id`='%d'",HouseInfo[houseid][hArm],houseid);
mysql_query(var);
}
case hIntx:
{
format(var, 100, "UPDATE `houses` SET `hInt`='%d' WHERE `id`='%d'",HouseInfo[houseid][hInt],houseid);
mysql_query(var);
}
case hLockx:
{
format(var, 100, "UPDATE `houses` SET `hLock`='%d' WHERE `id`='%d'",HouseInfo[houseid][hLock],houseid);
mysql_query(var);
}
case hOwnedx:
{
format(var, 100, "UPDATE `houses` SET `hOwned`='%d' WHERE `id`='%d'",HouseInfo[houseid][hOwned],houseid);
mysql_query(var);
}
case hRoomsx:
{
format(var, 100, "UPDATE `houses` SET `hRooms`='%d' WHERE `id`='%d'",HouseInfo[hRoomsx][hRooms],houseid);
mysql_query(var);
}
case hRentx:
{
format(var, 100, "UPDATE `houses` SET `hRent`='%d' WHERE `id`='%d'",HouseInfo[houseid][hRent],houseid);
mysql_query(var);
}
case hRentabilx:
{
format(var, 100, "UPDATE `houses` SET `hRentabil`='%d' WHERE `id`='%d'",HouseInfo[houseid][hRentabil],houseid);
mysql_query(var);
}
case hMoneyx:
{
format(var, 100, "UPDATE `houses` SET `hMoney`='%d' WHERE `id`='%d'",HouseInfo[houseid][hMoney],houseid);
mysql_query(var);
}
case hDatex:
{
format(var, 100, "UPDATE `houses` SET `hDate`='%d' WHERE `id`='%d'",HouseInfo[houseid][hDate],houseid);
mysql_query(var);
}
case hLevelx:
{
format(var, 100, "UPDATE `houses` SET `hLevel`='%d' WHERE `id`='%d'",HouseInfo[houseid][hLevel],houseid);
mysql_query(var);
}
case hWorldx:
{
format(var, 100, "UPDATE `houses` SET `hWorld`='%d' WHERE `id`='%d'",HouseInfo[houseid][hWorld],houseid);
mysql_query(var);
}
case hMatsx:
{
format(var, 100, "UPDATE `houses` SET `hMats`='%d' WHERE `id`='%d'",HouseInfo[houseid][hMats],houseid);
mysql_query(var);
}
case hDrugsx:
{
format(var, 100, "UPDATE `houses` SET `hDrugs`='%d' WHERE `id`='%d'",HouseInfo[houseid][hDrugs],houseid);
mysql_query(var);
}
}
return 1;
}
public OnPlayerUpdateReg(playerid)
{
if(IsPlayerConnected(playerid))
{
new playerName[MAX_PLAYER_NAME];
GetPlayerName(playerid, playerName, sizeof(playerName));
{
new var[256];
format(var, 256, "UPDATE `players` SET `Level`='%d',`PhoneNr`='%d',`Car`='%d',`Heli`='%d',`Moto`='%d',`House`='%d',`Bizz`='%d',`Bank`='%d',`Registered`='%d',`Team`='%d',`Model`='%d' WHERE `username`='%s'",
PlayerInfo[playerid][pLevel],PlayerInfo[playerid][pPnumber],PlayerInfo[playerid][pPcarkey],PlayerInfo[playerid][pPhelikey],PlayerInfo[playerid][pPmotokey],PlayerInfo[playerid][pPhousekey],PlayerInfo[playerid][pPbiskey],PlayerInfo[playerid][pAccount],PlayerInfo[playerid][pReg],PlayerInfo[playerid][pTeam],PlayerInfo[playerid][pModel],playerName);
mysql_query(var);
}
}
return 1;
}
public OnPlayerUpdatePayDay(playerid)
{
if(IsPlayerConnected(playerid))
{
new playerName[MAX_PLAYER_NAME];
GetPlayerName(playerid, playerName, sizeof(playerName));
{
new var[200];
format(var, 200, "UPDATE `players` SET `Bank`='%d',`WantedLevel`='%d',`MedicalBill`='%d',`ConnectedTime`='%d',`Respect`='%d',`House`='%d' WHERE `username`='%s'",
PlayerInfo[playerid][pAccount],PlayerInfo[playerid][pWantedLevel],PlayerInfo[playerid][pMedicalBill],PlayerInfo[playerid][pConnectTime],PlayerInfo[playerid][pExp],PlayerInfo[playerid][pPhousekey],playerName);
mysql_query(var);
}
}
return 1;
}
public OnPlayerDateUpdate(playerid)
{
if(IsPlayerConnected(playerid))
{
new playerName[MAX_PLAYER_NAME];
GetPlayerName(playerid, playerName, sizeof(playerName));
{
new var[350];
format(var, 350, "UPDATE `players` SET `Muted`='%d',`MuteTime`='%d',`Paycheck`='%d',`Jailed`='%d',`JailTime`='%d',`iInt`='%d',`Local`='%d',`Team`='%d',`Model`='%d',`CarTime`='%d',`Mission`='%d' WHERE `username`='%s'",
PlayerInfo[playerid][pMuted],PlayerInfo[playerid][pMuteTime],PlayerInfo[playerid][pPayCheck],PlayerInfo[playerid][pJailed],PlayerInfo[playerid][pJailTime],PlayerInfo[playerid][pInt],PlayerInfo[playerid][pLocal],PlayerInfo[playerid][pTeam],PlayerInfo[playerid][pModel],PlayerInfo[playerid][pCarTime],PlayerInfo[playerid][pMissionNr],playerName);
mysql_query(var);
}
}
return 1;
}
