SA-MP Forums Archive
MySQL OnPlayerDisconnect problem ! - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL OnPlayerDisconnect problem ! (/showthread.php?tid=402413)



MySQL OnPlayerDisconnect problem ! - dekciwRO - 26.12.2012

I made new topic ! Please close this.


AW: MySQL OnPlayerDisconnect problem ! - Mellnik - 26.12.2012

Have a look at your mysql log file.


Re: MySQL OnPlayerDisconnect problem ! - BrandyPenguin - 26.12.2012

Any code? I think that saving in OnPlayerDisconnect send wrong value to database


Re: AW: MySQL OnPlayerDisconnect problem ! - dekciwRO - 26.12.2012

Where can I find MySQL log?


Re: MySQL OnPlayerDisconnect problem ! - RedCrossER - 26.12.2012

Post your code , well make sure you give -deposited money to that player.


Re: MySQL OnPlayerDisconnect problem ! - dekciwRO - 26.12.2012

PlayerData[playerid][pAdjustable] = 1;
PlayerData[playerid][pStatus] = 0;
format(string, sizeof(string), "UPDATE players SET Status='%d' WHERE id=%d", PlayerData[playerid][pStatus], PlayerData[playerid][pSQLID]);
mysql_query(string);

That's the code.


Re: MySQL OnPlayerDisconnect problem ! - RedCrossER - 26.12.2012

What is the enum for player cash ? No server sided cash?

Post the MySQL log
And enum value for player cash and bank


Re: MySQL OnPlayerDisconnect problem ! - dekciwRO - 26.12.2012

Quote:

enum pData
{
pSQLID,
pNume[128],
pKey[64],
pLevel,
pAdmin,
pWipe,
pDonateRank,
gPupgrade,
pConnectTime,
pReg,
pSex,
pAge,
pOrigin,
pCK,
pMuted,
pMuteTime,
pExp,
pMoney,
pAccount,
pCrimes,
pKills,
pDeaths,
pArrested,
pWantedLevel,
pWantedPoints,
pWantedDeaths,
pPhoneBook,
pLottoNr,
pFishes,
pBiggestFish,
pSticle,
pJob,
pPayCheck,
pHeadValue,
pJailed,
pJailTime,
pMats,
pDrugs,
pLeader,
pMember,
pFMember,
pRank,
pChar,
pContractTime,
pDetSkill,
pSexSkill,
pBoxSkill,
pLawSkill,
pMechSkill,
pJackSkill,
pCarSkill,
pNewsSkill,
pDrugsSkill,
pCookSkill,
pFishSkill,
pRromSkill,
pPassport,

Sorry , but where I cand find MySQL log? A have hosted server . Tell me exactly please.