[ChristolisTV]

I want when a player spawns it sets his/her position from database fields: X, Y, Z, but instead it goes into the center of the map. Here is what I tried.

PHP код:

public OnPlayerSpawn(playerid)
{
    new
        Query[250],
        DBResult: Result,
        pName[250],
        Field[20],
        Float: x,
        Float: y,
        Float: z
    ;
    GetPlayerName(playerid, pName, sizeof(pName));
    
    format(Query, sizeof(Query), "SELECT * FROM `Accounts` WHERE Name = '%s'", pName);
    Result = db_query(Database, Query);
    
    x = db_get_field_assoc(Result, "X", Field, 30);
    y = db_get_field_assoc(Result, "Y", Field, 30);
    z = db_get_field_assoc(Result, "Z", Field, 30);
    
    SetPlayerPos(playerid, x, y, z);
    db_free_result(Result);
     return 1;    
} 


Can you help me please?

[TheDarkBlade]

Try to use printf to print into the console the spawn locations
so add printf("%f,%f,%f",X,Y,Z) or how are your cordonates named

[ChristolisTV]

Quote:

Originally Posted by TheDarkBlade Try to use printf to print into the console the spawn locations so add printf("%f,%f,%f",X,Y,Z) or how are your cordonates named

Do you mean format()? How to put the coordinates on SetPlayerPos()? Can you show me code I want to understand it a little bit.

[Konstantinos]

Is the position saved when a player disconnects? If yes, if a player timeouts/crashes then GetPlayerPos will fail and the coordinates returned will be 0.0 for all x, y and z. A workaround is to check if the reason in OnPlayerDisconnect is 2 and not get the position (their last saved will be used instead).

When a player logins, store the coordinates to a global array and in OnPlayerSpawn you can set the position without executing a query to retrieve them every time. If the value in these coordinates is 0.0, spawn them somewhere else (default position).