[yllo]

Hi

The player positions get saved correctly in the Mysql server, but for some odd reason it does not like loading them back to where they were, instead just loads them to a default position. I have even checked with the "/save" command. OnPlayerRequestClass also has the setspawninfo to see if that would change anything, but it did not.

Here is my saving script(for position):

PHP код:

stock SavePlayerPos(playerid)
{
    new query[500], Float:posX, Float:posY, Float:posZ;
    GetPlayerPos(playerid, posX, posY, posZ);
    format(query, sizeof(query), "UPDATE `accounts` SET `playerX` = '%f', `playerY` = '%f', `playerZ` = '%f' WHERE `playerName` = '%s'", posX, posY, posZ, playerInfo[playerid][playerName]);
    mysql_tquery(Database, query);
} 


Here is the loading script:

PHP код:

stock LoadPlayerStats(playerid)
{
        new query[200], name[24];
        GetPlayerName(playerid, name, 24);
        format(query, sizeof(query), "SELECT * FROM `accounts` WHERE `playerName` = '%e' LIMIT 1", name);
          mysql_tquery(Database, query);
          cache_get_value_int(0, "playerAdmin", playerInfo[playerid][playerAdmin]);
        cache_get_value_int(0, "playerMod", playerInfo[playerid][playerMod]);
        cache_get_value_int(0, "playerHelper", playerInfo[playerid][playerHelper]);
        cache_get_value_int(0, "playerLevel", playerInfo[playerid][playerLevel]);
        cache_get_value_int(0, "playerCash", playerInfo[playerid][playerCash]);
        cache_get_value_name_float(0, "playerX", playerInfo[playerid][playerX]);
        cache_get_value_name_float(0, "playerY", playerInfo[playerid][playerY]);
        cache_get_value_name_float(0, "playerZ", playerInfo[playerid][playerZ]);
          
          SetPlayerScore(playerid, playerInfo[playerid][playerLevel]);
          GivePlayerMoney(playerid, playerInfo[playerid][playerCash]);
        SetSpawnInfo(playerid, 0,0,playerInfo[playerid][playerX],playerInfo[playerid][playerY], playerInfo[playerid][playerZ], 0, 0, 0, 0, 0,0,0);
        printf("player loaded.");
} 


[yllo]

So I realised that it was not selecting the players username as it was using the %e statement. I changed it to %s and it now selects it however still does not load their positions. And yes they are saved as floats.

PHP код:

[12:31:31] [join] yllo has joined the server (0:127.0.0.1)
[12:31:31] player loaded.
[12:31:31] SELECT * FROM `accounts` WHERE `playerName` = 'yllo' LIMIT 1
[12:31:46] Player saved.
[12:31:46] [part] yllo has left the server (0:1) 


[Banditul18]

Quote:

Originally Posted by GRiMMREAPER You should also free the query results with mysql_free_result().

mysql_free_result() its deleted for so long time, thats from old times, also seems he use mysql_tquery which no need to free the result, result will be freed automatic

PHP код:

 stock LoadPlayerStats(playerid) 
{ 
        new query[200], name[24], Cache: result; 
        GetPlayerName(playerid, name, 24); 
        format(query, sizeof(query), "SELECT * FROM `accounts` WHERE `playerName` = '%e' LIMIT 1", name); 
        result = mysql_query(Database, query); 
        if(cache_num_rows())
        {
            cache_get_value_int(0, "playerAdmin", playerInfo[playerid][playerAdmin]); 
            cache_get_value_int(0, "playerMod", playerInfo[playerid][playerMod]); 
            cache_get_value_int(0, "playerHelper", playerInfo[playerid][playerHelper]); 
            cache_get_value_int(0, "playerLevel", playerInfo[playerid][playerLevel]); 
            cache_get_value_int(0, "playerCash", playerInfo[playerid][playerCash]); 
            cache_get_value_name_float(0, "playerX", playerInfo[playerid][playerX]); 
            cache_get_value_name_float(0, "playerY", playerInfo[playerid][playerY]); 
            cache_get_value_name_float(0, "playerZ", playerInfo[playerid][playerZ]); 
        }
           
        SetPlayerScore(playerid, playerInfo[playerid][playerLevel]); 
        GivePlayerMoney(playerid, playerInfo[playerid][playerCash]); 
        SetSpawnInfo(playerid, 0,0,playerInfo[playerid][playerX],playerInfo[playerid][playerY], playerInfo[playerid][playerZ], 0, 0, 0, 0, 0,0,0); 
        cache_delete(result);
        printf("player loaded."); 
} 


This is if you want the result from the select query in same function(unless you gonna use mysql_tquery_inline). mysql_tquery send a threaded query so the mysql_tquery require a callback in which you gonna load the data recived from the select query