13.05.2013, 22:12
Hello, i've been converting one of my old scripts from Djson to MySQL and all seems fine but when I log in, then disconnect, it's suppose to save my stuff, but the only thing I can get it to save is the SQLid username and the password which is hashed. I can't seem to point out the problem I am having, any help would be much appreciated, I will display my saving code below. Please excuse any stupid errors as I am fairly new to MySQL, thanks.
Just incase you need THREAD_NO_RESULT, I will display it below.
If you would like anymore code if you could not point out any errors on why this is happening feel free to ask me for some more of my code.
pawn Код:
stock savePlayer(playerid)
{
new
szQuery[3000];
GetPlayerPos(playerid, PlayerInfo[playerid][pPos][0], PlayerInfo[playerid][pPos][1], PlayerInfo[playerid][pPos][2]);
GetPlayerFacingAngle(playerid, PlayerInfo[playerid][pPos][3]);
PlayerInfo[playerid][pInt] = GetPlayerInterior(playerid);
PlayerInfo[playerid][pWorld] = GetPlayerVirtualWorld(playerid);
GetPlayerHealth(playerid, PlayerInfo[playerid][pHealth]);
GetPlayerHealth(playerid, PlayerInfo[playerid][pSHealth]);
GetPlayerArmour(playerid, PlayerInfo[playerid][pArmour]);
GetPlayerPCash(playerid, PlayerInfo[playerid][pCash]);
format(szQuery, sizeof(szQuery), "UPDATE Accounts SET Health = '%f', Armour = '%f', sHealth = '%f', PosX = '%f', PosY = '%f', PosZ = '%f', PosR = '%f'", PlayerInfo[playerid][pHealth], PlayerInfo[playerid][pArmour], PlayerInfo[playerid][pSHealth], PlayerInfo[playerid][pPos][0], PlayerInfo[playerid][pPos][1], PlayerInfo[playerid][pPos][2], PlayerInfo[playerid][pPos][3]);
format(szQuery, sizeof(szQuery), "%s, Interior = %d, Model = %d WHERE ID = %d, Cash = %d, Account = %d, Admin = %d, Level = %d, Exp = %d, Upgrade = %d, Kills = %d", szQuery, PlayerInfo[playerid][pInt], PlayerInfo[playerid][pModel], PlayerInfo[playerid][pSQLid], PlayerInfo[playerid][pCash], PlayerInfo[playerid][pAccount], PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pExp], PlayerInfo[playerid][gPupgrade], PlayerInfo[playerid][pKills]);
format(szQuery, sizeof(szQuery), "%s, ReqBackup = %d, Gun = %d, Ammo = %d, Stored = %d, Local = %d, Team = %d, ModelNormal = %d, Pnumber = %d, HouseRenting = %d", szQuery, PlayerInfo[playerid][pRequestingBackup], PlayerInfo[playerid][pGun], PlayerInfo[playerid][pAmmo], PlayerInfo[playerid][pStored], PlayerInfo[playerid][pLocal], PlayerInfo[playerid][pTeam], PlayerInfo[playerid][pModelNormal], PlayerInfo[playerid][pPnumber], PlayerInfo[playerid][pHouseRenting]);
format(szQuery, sizeof(szQuery), "%s, HouseOwned = %d, HRentingStatus = %d, Banned = %d, LockTime = %d, FightSkill = %d, FightGear = %d, Sex = %d, Age = %d, Tut = %d", szQuery, PlayerInfo[playerid][pHouseOwned], PlayerInfo[playerid][pHouseRentingStatus], PlayerInfo[playerid][pBanned], PlayerInfo[playerid][pLockTime], PlayerInfo[playerid][pFightSkill], PlayerInfo[playerid][pFightGear], PlayerInfo[playerid][pSex], PlayerInfo[playerid][pAge], PlayerInfo[playerid][pTut]);
format(szQuery, sizeof(szQuery), "%s, Seeds = %d, Dead = %d, Milked = %d, Member = %d, Rank = %d, Div = %d, Crashed = %d, CrashArmour = 'f', CrashHealth = 'f'", szQuery, PlayerInfo[playerid][pSeeds], PlayerInfo[playerid][pDead], PlayerInfo[playerid][pMilked], PlayerInfo[playerid][pMember], PlayerInfo[playerid][pRank], PlayerInfo[playerid][pDiv], PlayerInfo[playerid][pCrashed], PlayerInfo[playerid][pCrashArmour], PlayerInfo[playerid][pCrashHealth]);
format(szQuery, sizeof(szQuery), "%s, Job = %d, Paycheck = %d, Payday = %d, DonateRank = %d, Planted = %d, DonatePoints = %d, Connecttime = %d, Donatetime = %d", szQuery, PlayerInfo[playerid][pJob], PlayerInfo[playerid][pPayCheck], PlayerInfo[playerid][pPayDay], PlayerInfo[playerid][pDonateRank], PlayerInfo[playerid][pPlanted], PlayerInfo[playerid][pDonatePoints], PlayerInfo[playerid][pConnectTime], PlayerInfo[playerid][pDonateTime]);
format(szQuery, sizeof(szQuery), "%s, Jailed = %d, JailTime = %d, JailReason = %s, Drugs = %d, Mats = %d, VaultOwned = %d, VaultDrugs = %d, VaultMats = %d, Watch = %d", szQuery, PlayerInfo[playerid][pJailed], PlayerInfo[playerid][pJailTime], PlayerInfo[playerid][pJailReason], PlayerInfo[playerid][pDrugs], PlayerInfo[playerid][pMats], PlayerInfo[playerid][pVaultOwned], PlayerInfo[playerid][pVaultDrugs], PlayerInfo[playerid][pVaultMats], PlayerInfo[playerid][pWatch]);
format(szQuery, sizeof(szQuery), "%s, PhoneBook = %d, Mask = %d, MaskUse = %d, DrivLic = %d, Married = %d, MarriedTo = %s, Helper = %d, GunLic = %d, Arrested = %d, Crimes = %d", szQuery, PlayerInfo[playerid][pPhoneBook], PlayerInfo[playerid][pMask], PlayerInfo[playerid][pMaskUse], PlayerInfo[playerid][pDrivLic], PlayerInfo[playerid][pMarried], PlayerInfo[playerid][pMarriedTo], PlayerInfo[playerid][pHelper], PlayerInfo[playerid][pGunLic], PlayerInfo[playerid][pArrested], PlayerInfo[playerid][pCrimes]);
format(szQuery, sizeof(szQuery), "%s, Taunt = %s, InvWeapon = %d, InvAmmo = %d, InvBeer = %d, InvWine = %d, InvCiggy = %d, Hidden = %d, Walkie = %d, WalkieFreq = %d, Lighter = %d", szQuery, PlayerInfo[playerid][pTaunt], PlayerInfo[playerid][pInvWeapon], PlayerInfo[playerid][pInvAmmo], PlayerInfo[playerid][pInvBeer],PlayerInfo[playerid][pInvWine],PlayerInfo[playerid][pInvCiggy],PlayerInfo[playerid][pHidden],PlayerInfo[playerid][pWalkie],PlayerInfo[playerid][pWalkieFreq],PlayerInfo[playerid][pLighter]);
format(szQuery, sizeof(szQuery), "%s, Cigs = %d, BanReason = %s, Fish = %d, Note1 = %s, Note1s = %d, Note2 = %s, Note2s = %d, Note3 = %s, Note3s = %d, Note4 = %s",szQuery,PlayerInfo[playerid][pCigs],PlayerInfo[playerid][pBanReason],PlayerInfo[playerid][pFish],PlayerInfo[playerid][pNote1],PlayerInfo[playerid][pNote1s],PlayerInfo[playerid][pNote2],PlayerInfo[playerid][pNote2s],PlayerInfo[playerid][pNote3],PlayerInfo[playerid][pNote3s],PlayerInfo[playerid][pNote4]);
format(szQuery, sizeof(szQuery), "%s, Note4s = %d, Note5 = %s, Note5s = %d, Accent = %s, Voted = %d, AdmName = %s, HeadValue = %d, Hiddennum = %d, PmMsg = %s, clothesx = 'f'", szQuery, PlayerInfo[playerid][pNote4s], PlayerInfo[playerid][pNote5], PlayerInfo[playerid][pNote5s], PlayerInfo[playerid][pAccent], PlayerInfo[playerid][pVoted], PlayerInfo[playerid][pAdmName], PlayerInfo[playerid][pHeadValue], PlayerInfo[playerid][pHiddenNum], PlayerInfo[playerid][pPmMsg], PlayerInfo[playerid][Clothesx]);
format(szQuery, sizeof(szQuery), "%s, clothesy = 'f', clothesz = 'f', Clothesw = %d, Clothesi = %d, Clothesent = %d, Radio = %d, Ticket = %d, TicketReason0 = %s, TicketReason1 = %s", szQuery, PlayerInfo[playerid][Clothesy], PlayerInfo[playerid][Clothesz], PlayerInfo[playerid][Clothesw], PlayerInfo[playerid][Clothesi], PlayerInfo[playerid][Clothesent], PlayerInfo[playerid][pRadio], PlayerInfo[playerid][pTicket], PlayerInfo[playerid][pTicketReason0], PlayerInfo[playerid][pTicketReason1]);
format(szQuery, sizeof(szQuery), "%s, TicketReason2 = %s, TicketReason3 = %s, TicketReason4 = %s, TicketDate0 = %d, TicketDate1 = %d, TicketDate2 = %d, TicketDate3 = %d, TicketDate4 = %d", szQuery, PlayerInfo[playerid][pTicketReason2], PlayerInfo[playerid][pTicketReason3], PlayerInfo[playerid][pTicketReason4], PlayerInfo[playerid][pTicketDate0], PlayerInfo[playerid][pTicketDate1], PlayerInfo[playerid][pTicketDate2], PlayerInfo[playerid][pTicketDate3], PlayerInfo[playerid][pTicketDate4]);
format(szQuery, sizeof(szQuery), "%s, App = %d, Skate = %d, Speaker = %d, Changes = %d, AdminPass = %d, FamNum = %d, Cellphone = %d, DonerGate1 = %d, CalledTutSay = %d",szQuery,PlayerInfo[playerid][pApp],PlayerInfo[playerid][pSkate],PlayerInfo[playerid][pSpeaker],PlayerInfo[playerid][pChanges],PlayerInfo[playerid][pAdminPass],PlayerInfo[playerid][pFamNum],PlayerInfo[playerid][pCellphone],PlayerInfo[playerid][pDonerGate1],PlayerInfo[playerid][pCalledTutSay]);
format(szQuery, sizeof(szQuery), "%s, DonatorCarDate = %d, AdPending = %d, PendingAdText = %s, Warrant = %d, WarrantReason = %s, WakeMsgSend = %s, FactionIden = %d", szQuery, PlayerInfo[playerid][pDonatorCarDate], PlayerInfo[playerid][pAdPending], PlayerInfo[playerid][pPendingAdText], PlayerInfo[playerid][pWarrant], PlayerInfo[playerid][pWarrantReason], PlayerInfo[playerid][pWakeMsgSend], PlayerInfo[playerid][pFactionIden]);
format(szQuery, sizeof(szQuery), "%s, WeaponData = %d, WeaponAmmo = %d, LagTimer = %d, GasCan = %d, GPS = %d, WantedLevel = %d, Arrival = %d, Origin = %d, Laptop = %d", szQuery, PlayerInfo[playerid][pWeaponData], PlayerInfo[playerid][pWeaponAmmo], PlayerInfo[playerid][pLagTimer], PlayerInfo[playerid][pGasCan], PlayerInfo[playerid][pGPS], PlayerInfo[playerid][pWantedLevel], PlayerInfo[playerid][pArrival], PlayerInfo[playerid][pOrigin], PlayerInfo[playerid][pLaptop]);
format(szQuery, sizeof(szQuery), "%s, LaptopWorks = %d, Internet = %d, Email = %d, Inbox1 = %s, Inbox2 = %s, Inbox3 = %s, Inbox4 = %s, Inbox5 = %s, World = %d", szQuery, PlayerInfo[playerid][pLaptopWorks], PlayerInfo[playerid][pInternet], PlayerInfo[playerid][pEmail], PlayerInfo[playerid][pInbox1], PlayerInfo[playerid][pInbox2], PlayerInfo[playerid][pInbox3], PlayerInfo[playerid][pInbox4], PlayerInfo[playerid][pInbox5], PlayerInfo[playerid][pWorld]);
mysql_query(szQuery, THREAD_NO_RESULT, playerid, iConnectionHandle);
return 1;
}
pawn Код:
case THREAD_NO_RESULT:
{
printf("(MySQL) Query: %s | ResultID: %d ", query, resultid);
}