MYSQL Saving system[Help + rep]
#3

Quote:
Originally Posted by AndreT
Посмотреть сообщение
You are missing field separators in your UPDATE query as far as I can see.
Invalid: UPDATE playerdata SET score= '%d', money= '%d' Faction= '%d' FactionLeader= '%d' Adminlvl= '%d' WHERE user='%s'
Valid: UPDATE playerdata SET score= '%d', money= '%d', Faction= '%d', FactionLeader= '%d', Adminlvl= '%d' WHERE user='%s'

Additionally, you don't need to use single quotes around integer/decimal values, so the code can easily become:
UPDATE playerdata SET score = %d, money = %d, Faction = %d, FactionLeader = %d, Adminlvl = %d WHERE user = '%s'
Didn`t fix the problem when i reconnect it still says i am not registered.
Reply


Messages In This Thread
MYSQL Saving system[Help + rep] - by demonarn - 10.03.2012, 13:10
Re: MYSQL Saving system[Help + rep] - by AndreT - 10.03.2012, 13:13
Re: MYSQL Saving system[Help + rep] - by demonarn - 10.03.2012, 13:25

Forum Jump:


Users browsing this thread: 2 Guest(s)