[MySQL] Repeating
#10

Quote:
Originally Posted by ScottCFR
Посмотреть сообщение
This is update:
Код:
format(query,sizeof(query),"UPDATE users SET name='%s', password='%s', admin=%d, cash=%d, score=%d WHERE SQLid=%d",name,AccountInfo[playerid][Password],AccountInfo[playerid][AdminLevel],AccountInfo[playerid][Cash],AccountInfo[playerid][Score],AccountInfo[playerid][mglvl],AccountInfo[playerid][SQLid]);
You people are blind, i saw this in the first place:

Код:
format(query,sizeof(query),"UPDATE users SET name='%s', password='%s', admin='%d', cash='%d', score='%d' WHERE name='%s'",name,AccountInfo[playerid][Password],AccountInfo[playerid][AdminLevel],AccountInfo[playerid][Cash],AccountInfo[playerid][Score],AccountInfo[playerid][mglvl],name);
You forgot a lot of '.
Also you'll have to make SQLid an AUTO_INCREMENT.
Also, don't look for SQLid when you update a player, look for he's name.
Reply


Messages In This Thread
[MySQL] Repeating - by ScottCFR - 15.07.2010, 20:02
Re: [MySQL] Repeating - by [HiC]TheKiller - 15.07.2010, 20:07
Re: [MySQL] Repeating - by ScottCFR - 15.07.2010, 20:12
Re: [MySQL] Repeating - by [HiC]TheKiller - 15.07.2010, 20:16
Re: [MySQL] Repeating - by oliverrud - 15.07.2010, 20:17
Re: [MySQL] Repeating - by ScottCFR - 15.07.2010, 20:20
Re: [MySQL] Repeating - by [HiC]TheKiller - 15.07.2010, 20:20
Re: [MySQL] Repeating - by ScottCFR - 15.07.2010, 20:26
Re: [MySQL] Repeating - by [HiC]TheKiller - 15.07.2010, 20:30
Re: [MySQL] Repeating - by WackoX - 16.07.2010, 08:00

Forum Jump:


Users browsing this thread: 1 Guest(s)