MySQL issues
#1

It was saving before, but now I'm quiet unsure as to why this is happening.
PHP код:
forward SaveAccountStats(playerid);
public 
SaveAccountStats(playerid)
{
    if(
Logged[playerid] == 1)
    {
        new 
query[1280];
        
mysql_format(mysqlquerysizeof(query), "UPDATE `users` SET `Money`=%d, `Admin`=%d, `Vip`=%d, `Kills`=%d, `Deaths`=%d, `Score`=%d, `Rank`=%d, `Banned`=%d, `Warns`=%d, ",\
        
PlayerInfo[playerid][pMoney], PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pVip], PlayerInfo[playerid][pKills], PlayerInfo[playerid][pDeaths], PlayerInfo[playerid][pScore], PlayerInfo[playerid][pRank], PlayerInfo[playerid][pBanned],\
        
PlayerInfo[playerid][pWarns]);
        
mysql_format(mysqlquerysizeof(query), "%s`VW`=%d, `Interior`=%d, `Min`=%d, `Hours`=%d, `PM`=%d, `Color`=%d, `Turfs`=%d, `Clan`=%d, ",\
         
queryPlayerInfo[playerid][pVW], PlayerInfo[playerid][pInt], PlayerInfo[playerid][pMin], PlayerInfo[playerid][pHour], PlayerInfo[playerid][pPM], PlayerInfo[playerid][pColor], PlayerInfo[playerid][pTurfs], PlayerInfo[playerid][pClan]);
        
mysql_format(mysqlquerysizeof(query), "%s`ClRank`=%d, `ClLeader`=%d, `Invited`=%d, `Inviting`=%d  WHERE `ID`=%d",\
        
queryPlayerInfo[playerid][pClRank], PlayerInfo[playerid][pClLeader], PlayerInfo[playerid][pInvited], PlayerInfo[playerid][pInviting], PlayerInfo[playerid][pID]);
        
mysql_tquery(mysqlquery"""");
        return 
1;
    }
    return 
0;

MySQL error:
PHP код:
[DEBUGCMySQLQuery::Execute[] - no callback specifiedskipping result saving
Reply


Messages In This Thread
MySQL issues - by aoky - 27.08.2017, 21:08
Re: MySQL issues - by Vince - 27.08.2017, 21:26
Re: MySQL issues - by aoky - 27.08.2017, 22:10
Re: MySQL issues - by raydx - 28.08.2017, 07:58
Re: MySQL issues - by Vince - 28.08.2017, 08:25
Re: MySQL issues - by aoky - 29.08.2017, 00:44
Re: MySQL issues - by Dayrion - 29.08.2017, 01:36
Re: MySQL issues - by thegamer355 - 29.08.2017, 05:44
Re: MySQL issues - by aoky - 01.09.2017, 18:33
Re: MySQL issues - by Spmn - 01.09.2017, 18:42

Forum Jump:


Users browsing this thread: 2 Guest(s)