MYSQL Position not saving.
#1

The positions, money, ranks of players aren't saving at all, but when i look at phpmyadmin and specific players it has saved a some data.





PHP Code:
stock Saveplayersdata(playeridregisteredloggedclosemysql 0)
{
    new 
query[1000], weaponidammops GetPlayerState(playerid);
    if(
Info[playerid][Logged] == && ps != PLAYER_STATE_WASTED && ps != PLAYER_STATE_SPECTATING)
    {
        new 
Float:pxFloat:pyFloat:pzFloat:xHPFloat:xArmour;
        
GetPlayerPos(playeridpxpypz);
        
GetPlayerHealth(playeridxHP);
        
GetPlayerArmour(playeridxArmour);
        
GetPlayerIp(playeridInfo[playerid][IP], 16);
        
Info[playerid][PlayerTeam] = pTeam[playerid];
        
Info[playerid][Money] = GetPlayerCash(playerid);
        
Info[playerid][FightStyle] = GetPlayerFightingStyle(playerid);
        
Info[playerid][Skin] = GetPlayerSkin(playerid);
        
Info[playerid][Interior] = GetPlayerInterior(playerid);
        
Info[playerid][pHealth] = xHP;
        
Info[playerid][pArmour] = xArmour;
        if(
Info[playerid][InDM] == || InEvent[playerid] == || InDerby[playerid] == || InTDM[playerid] == || InParkour[playerid] == || InSkydive[playerid] == || InDuel[playerid] == 1)
        {
            
Info[playerid][PosX] = LastPosX[playerid];
            
Info[playerid][PosY] = LastPosY[playerid];
            
Info[playerid][PosZ] = LastPosZ[playerid];
            
Info[playerid][pHealth] = LastHealth[playerid];
            
Info[playerid][pArmour] = LastArmour[playerid];
            
Info[playerid][Interior] = LastInterior[playerid];
        }
        if(
Info[playerid][InDM] == && InEvent[playerid] == && InDerby[playerid] == && InTDM[playerid] == && InParkour[playerid] == && InSkydive[playerid] == && InDuel[playerid] == 0)
        {
            
Info[playerid][PosX] = px;
            
Info[playerid][PosY] = py;
            
Info[playerid][PosZ] = pz;
        }
        if(
Info[playerid][InDM] == && InEvent[playerid] == && InDerby[playerid] == && InTDM[playerid] == && InParkour[playerid] == && InSkydive[playerid] == && InDuel[playerid] == 0)
        {
            for(new 
i13i++)
            {
                
GetPlayerWeaponData(playeridiweaponidammo); 
                if(!
weaponid) continue;
                
mysql_format(mysqlquerysizeof(query), "INSERT INTO `Weapons` (ID, Weapon, Ammo) VALUES (%d, %d, %d) ON DUPLICATE KEY UPDATE `Ammo` = %d"Info[playerid][ID], weaponidammoammo);
                
mysql_tquery(mysqlquery);
            }
        }
        
mysql_format(mysqlquerysizeof(query), "UPDATE `playersdata` SET `LastSeen` = UNIX_TIMESTAMP(), `IP` = '%e', `AutoLogin` = %i, `Level` = %i, `Money` = %i, `Tokens` = %i, `Kills` = %i,\
        `Deaths` = %i, `Suicides` = %i, `Hours` = %i, `Minutes` = %i, `Seconds` = %i, `Marijuana` = %i, `Seeds` = %i, `Cocaine` = %i, `Premium` = %i, `PremiumExpires` = %i, `FightStyle` = %i,\
        `xLevel` = %i, `XP` = %i, `Muted` = %i, `Hitman` = %i, `gSkills` = %i, `bSkills` = %i, `vSkills` = %i, `aSkills` = %i, `rSkills` = %i, `tSkills` = %i, `mSkills` = %i, `dSkills` = %i,\
        `PlayerTeam` = %i, `MoneyBags` = %i, `Skin` = %i, `PosX` = %f, `PosY` = %f, `PosZ` = %f, `Interior` = %i, `Health` = %f, `Armour` = %f, `Jetpack` = %i, `JetpackExpire` = %i,\
        `Friends` = %i, `Vehicles` = %i, `InHouse` = %i, `PlayerColor` = '%e', `TextColor` = '%e', `MapHide` = %i  WHERE `ID` = %d"
,
        
Info[playerid][IP], Info[playerid][AutoLogin], Info[playerid][Level], Info[playerid][Money], Info[playerid][Tokens], Info[playerid][Kills], Info[playerid][Deaths], Info[playerid][Suicides], Info[playerid][Hours],
        
Info[playerid][Minutes], Info[playerid][Seconds], Info[playerid][Marijuana], Info[playerid][Seeds], Info[playerid][Cocaine], Info[playerid][Premium], Info[playerid][PremiumExpires], Info[playerid][FightStyle], 
        
Info[playerid][xLevel], Info[playerid][XP], MuteCounter[playerid], Info[playerid][Hitman], Info[playerid][Skills][GROVE], Info[playerid][Skills][BALLAS], Info[playerid][Skills][VAGOS], Info[playerid][Skills][AZTECAS], 
        
Info[playerid][Skills][BIKERS], Info[playerid][Skills][TRIADS], Info[playerid][Skills][MAFIA], Info[playerid][Skills][NANG], Info[playerid][PlayerTeam], Info[playerid][MoneyBags], Info[playerid][Skin], Info[playerid][PosX],
        
Info[playerid][PosY], Info[playerid][PosZ], Info[playerid][Interior], Info[playerid][pHealth], Info[playerid][pArmour], Info[playerid][Jetpack], Info[playerid][JetpackExpire], Info[playerid][Friends], Info[playerid][vehLimit], 
        
InHouse[playerid], Info[playerid][playerColor], Info[playerid][textColor], Info[playerid][MapHide], Info[playerid][ID]);
        
mysql_tquery(mysqlquery);
        
Info[playerid][Registered] = registered;
        
Info[playerid][Logged] = logged;
    }
    if(
closemysql == 1mysql_close(mysql);
    return 
true;

Reply
#2

If the database shows that some data has saved, doesn't this indicate a problem with loading said data, rather than the saving?

Look at your mySQL logs to see if the query had any errors.
Reply
#3

I got it fixed, i created new database. The problem was on MYSQL side. Thanks anyways!
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)