not saving correctly [MYSQL]
#3

Quote:
Originally Posted by trablon
Посмотреть сообщение
E-MAIL must not be integer, as we can see; email contains string.So make it string.( '%d' to '%s')
EDIT: String..I mean; varchar, of course!
Also, are you using this code when player disconnects?
The disconnect
PHP код:
SavePlayer(playerid)
{
    if(
pInfo[playerid][Logged] == 1)
    {
        new 
Query[500];
        
format(Query500"UPDATE `playerdata` SET `age` = %d, `gender` = %d, `skin` = %d, `country` = %d, `email` = %d, `admin` = %d, `helper` = %d, `moderator` = %d, `score` = %d, `money` = %d, `gold` = %d, `kills` = %d, `deaths` = %d, `experiencepoints` = %d, `experiencepointsneeded` = %d, `kicks` = %d, `bans` = %d, `banned` = %d, `playinghours`= %d, `secondslogged` = %d, `adminhelp` = %d WHERE `id` = %d",
        
pInfo[playerid][Age],
        
pInfo[playerid][Gender],
        
pInfo[playerid][Skin],
        
pInfo[playerid][Country],
        
pInfo[playerid][Email],
        
pInfo[playerid][pAdmin],
        
pInfo[playerid][pHelper],
        
pInfo[playerid][pMod],
        
pInfo[playerid][pScore],
        
pInfo[playerid][pMoney],
        
pInfo[playerid][Gold],
        
pInfo[playerid][pKills],
        
pInfo[playerid][pDeaths],
        
pInfo[playerid][ExperiencePoints],
        
pInfo[playerid][ExperiencePointsNeeded],
        
pInfo[playerid][kicks],
        
pInfo[playerid][bans],
        
pInfo[playerid][pBanned],
        
pInfo[playerid][PlayingHours],
        
pInfo[playerid][SecondsLoggedIn],
        
pInfo[playerid][AdminHelp],
        
pInfo[playerid][ID]);
          
mysql_query(Query);
    }

Reply


Messages In This Thread
not saving correctly [MYSQL] - by lulo356 - 23.07.2015, 22:40
Re: not saving correctly [MYSQL] - by trablon - 23.07.2015, 22:45
Re: not saving correctly [MYSQL] - by lulo356 - 23.07.2015, 23:26
Re: not saving correctly [MYSQL] - by trablon - 23.07.2015, 23:32
Re: not saving correctly [MYSQL] - by M4D - 23.07.2015, 23:37
Re: not saving correctly [MYSQL] - by JaydenJason - 23.07.2015, 23:40
Re: not saving correctly [MYSQL] - by trablon - 23.07.2015, 23:43

Forum Jump:


Users browsing this thread: 2 Guest(s)