Save into MYSQL
#9

Quote:
Originally Posted by DeathOnaStick
Посмотреть сообщение
Is there a entry in your Database yet? If not you cannot use UPDATE, you need to use INSERT in that case.
Also you could make it more effecient by not always formating the string. Use this:
Код:
UPDATE `playerinfo` SET (`member`,`blabla`,`Blabla2`) VALUES ('%d','%d','%d') WHERE `user` = '%s'
I'm not 100% sure if this works, but i think so.

#edit: i corrected my post
I use this:
Код:
UPDATE `playerinfo` SET `key` = '%s', `level` = '%d',`admin` = '%d' WHERE `user` = '%s'", PlayerInfo[playerid][pKey], PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pAdmin], Escape[0]
Reply


Messages In This Thread
Save into MYSQL - by vection - 25.09.2010, 18:00
Re: Save into MYSQL - by billy4601 - 25.09.2010, 19:04
Re: Save into MYSQL - by DeathOnaStick - 25.09.2010, 19:07
Re: Save into MYSQL - by vection - 25.09.2010, 20:08
Re: Save into MYSQL - by Relixious - 25.09.2010, 20:20
Re: Save into MYSQL - by vection - 25.09.2010, 20:25
Re: Save into MYSQL - by vection - 26.09.2010, 12:32
Re: Save into MYSQL - by vection - 26.09.2010, 12:40
Re: Save into MYSQL - by kurta999 - 26.09.2010, 12:42

Forum Jump:


Users browsing this thread: 2 Guest(s)