[lulo356]

PHP код:

savePlayer(playerid)
{
    if(sInfo[playerid][logged]==0)return 1;
    //Speichern level,money
    new query[128];
    format(query,sizeof(query),"UPDATE user SET level='%i',money='%i',adminlevel='%i', admincode='%i' WHERE id='%i'",sInfo[playerid][level],GetPlayerMoney(playerid),sInfo[playerid][Adminlevel],sInfo[playerid][AdminCode], sInfo[playerid][id]);
    mysql_function_query(dbhandle,query,false,"","");
    return 1;
} 


It's not saving the player stats

[shadowdog]

PHP код:

savePlayer(playerid) 
{ 
    if(sInfo[playerid][logged]==0)return 1; 
    //Speichern level,money 
    new query[128]; 
    format(query,sizeof(query),"UPDATE `user` SET level='%i',money='%i',adminlevel='%i', admincode='%i' WHERE id='%i'",sInfo[playerid][level],GetPlayerMoney(playerid),sInfo[playerid][Adminlevel],sInfo[playerid][AdminCode], sInfo[playerid][id]); // add ` marks around your user.
    mysql_function_query(dbhandle,query,false,"",""); 
    return 1; 
} 


[lulo356]

Quote:

Originally Posted by shadowdog PHP код: savePlayer(playerid)  {      if(sInfo[playerid][logged]==0)return 1;      //Speichern level,money      new query[128];      format(query,sizeof(query),"UPDATE `user` SET level='%i',money='%i',adminlevel='%i', admincode='%i' WHERE id='%i'",sInfo[playerid][level],GetPlayerMoney(playerid),sInfo[playerid][Adminlevel],sInfo[playerid][AdminCode], sInfo[playerid][id]); // add ` marks around your user.     mysql_function_query(dbhandle,query,false,"","");      return 1;  }

Well, It's still doesn't save (( kan je me PMen misschien kan ik nog meer vaagjes stellen))

[Sawalha]

check your mysql_log.txt file and post the log here

[lulo356]

Quote:

Originally Posted by Sawalha check your mysql_log.txt file and post the log here

The logs doens't show it, only from last week

[Stanford]

Are you sure that you have created the database properly? (Make sure you have proper variable types);
Moreover, check your loading and when you actually load?

[lulo356]

bumb

[X337]

`level` table is MySQL reserved keyword :
https://dev.mysql.com/doc/refman/5.0/en/keywords.html
U need to escape level to `level`

PHP код:

UPDATE user SET `level`='%i',`money`='%i',`adminlevel`='%i', `admincode`='%i' WHERE id='%i'