SHOW:
|
|
- or go back to the newest paste.
| 1 | CMD:saveall(playerid,params[]) | |
| 2 | {
| |
| 3 | new string[1000]; | |
| 4 | StartLoop(p) | |
| 5 | {
| |
| 6 | - | format(string,sizeof(string),"UPDATE accounts SET username='%s',password ='%s',secretcode='%s',tag='%s',havetag='%d'" |
| 6 | + | format(string,sizeof(string),"UPDATE accounts SET username='%s',password ='%s',secretcode='%s',tag='%s',havetag='%d' WHERE `userid` = '%s'" |
| 7 | - | ,pInfo[p][pName],pInfo[p][pPassword],pInfo[p][pSecretCode],pInfo[p][pTag],pInfo[p][pHaveTag]); |
| 7 | + | ,pInfo[p][pName],pInfo[p][pPassword],pInfo[p][pSecretCode],pInfo[p][pTag],pInfo[p][pHaveTag],pInfo[p][pUserID]); |
| 8 | mysql_function_query(dbHandle,string,false,"",""); | |
| 9 | ||
| 10 | - | format(string,sizeof(string),"UPDATE accounts SET adminlevel='%d',moneybank='%d',kills='%d',death='%d',level='%d'" |
| 10 | + | format(string,sizeof(string),"UPDATE accounts SET adminlevel='%d',moneybank='%d',kills='%d',death='%d',level='%d' WHERE `userid` = '%s'" |
| 11 | - | ,pInfo[p][pAdminLevel],pInfo[p][pMoneyBank],pInfo[p][pKills],pInfo[p][pDeath],pInfo[p][pLevel]); |
| 11 | + | ,pInfo[p][pAdminLevel],pInfo[p][pMoneyBank],pInfo[p][pKills],pInfo[p][pDeath],pInfo[p][pLevel],pInfo[p][pUserID]); |
| 12 | mysql_function_query(dbHandle,string,false,"",""); | |
| 13 | } | |
| 14 | SendClientMessageToAll(-1,"{ffffff}[{c2ed14}Auto Saved{ffffff}]: ëì äôøèéí ùì ëì äùç÷ðéí ðùîøå àåèîèéú");
| |
| 15 | ||
| 16 | return 1; | |
| 17 | } |
