MySQL Syntax Error
#10

Quote:
Originally Posted by rymax99
Посмотреть сообщение
Код:
[05:13:41] UPDATE `accs` SET `pName` = Test_Account, `pSecKey` = 0, `pLevel` = 0, `pRespect` = 0, `pSkin` = 0, `pIP` = 255.255.255.255, `pAdmin` = 0, `pVIP` = 0, `pMoney` = 0, `pGender` = 0, `pAge` = 0, `pBank` = 0, `pBanned` = 0, `pBans` = 0, `pBannedBy` = , `pBanReason` = , `pBanDate` = , `pBanTime` = , `pBanAppealable` = 0, `pFaction` = 0, `pRank` = 0, `pFacSkin` = 0, `pTester` = 0, `pTutStep` = 0, `pFinishedTut` = 0, `pMuted` = 1125808864, `pPosX` = -80.625, `pPosY` = 1.578, `pPosZ` = 132.06, `pPosA` = 7.006e-45 WHERE `pID` =
pName and pIP aren't integers, they're strings. You'll need to use quotes.

Also, it doesn't look like you're passing anything for pID?

Is the integer for pID being defined and passed or is it just being cut off? Your string might not be big enough for the query if so.
pName might not be in integer, but it does save, so I doubt it's anything with pname, also


pIP shows the correct ip to me


Код:
pData[playerid][pID] = cache_get_field_content_int(0, "pID");
Everything is fine with the pID.

My string is big enough..
Tables get updated

Testing with quotes right now, will get back to this in a sec.


Using IP as a integer just makes it "50"
Reply


Messages In This Thread
MySQL Syntax Error - by JaydenJason - 04.07.2015, 12:14
Re: MySQL Syntax Error - by rymax99 - 04.07.2015, 12:25
Re: MySQL Syntax Error - by prineside - 04.07.2015, 12:26
Re: MySQL Syntax Error - by Prokill911 - 04.07.2015, 12:30
Re: MySQL Syntax Error - by JaydenJason - 04.07.2015, 12:32
Re: MySQL Syntax Error - by Prokill911 - 04.07.2015, 12:34
Re: MySQL Syntax Error - by rymax99 - 04.07.2015, 12:34
Re: MySQL Syntax Error - by Prokill911 - 04.07.2015, 12:37
Re: MySQL Syntax Error - by rymax99 - 04.07.2015, 12:38
Re: MySQL Syntax Error - by JaydenJason - 04.07.2015, 12:45

Forum Jump:


Users browsing this thread: 1 Guest(s)