[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?