GetName - Printable Version

GetName - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: GetName (/showthread.php?tid=598758)

GetName - StreetRP - 16.01.2016

Hello ..
I get a bug ..This code don't get the name .
.

PHP код:



NameMysql(playerid)

{

    

    new nameR[MAX_PLAYER_NAME+1];



    static query[60], DBResult:db_result;


    

    format(query, sizeof query, "SELECT `name` FROM `users` WHERE `id` = '%d'", playerid);


    

    db_result = db_query(mysql, query);



    if(db_num_rows(db_result))

    {


    cache_get_field_content(db_result, "name", nameR, mysql, sizeof nameR);

    }



    db_free_result(db_result);


    

    return nameR;

}

Are is a error ?

Thanks for you'r help !

Re: GetName - StreetRP - 16.01.2016

Resolved !

PHP код:



NameMysql(playerid)

{


    new nameR[MAX_PLAYER_NAME+1];

    static query[60], Cache:result;

    format(query, sizeof query, "SELECT `name` FROM `users` WHERE `id` = '%d'", playerid);

    result = mysql_query(mysql, query);

    cache_get_field_content(0, "name", nameR, mysql, sizeof nameR);

    cache_delete(result);

    return nameR;

}