Get name frome id [MYSQL] +rep

Get name frome id [MYSQL] +rep - 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: Get name frome id [MYSQL] +rep (/showthread.php?tid=556483)

Get name frome id [MYSQL] +rep - StreetRP - 10.01.2015

Hello i had do this but he doesent work ..

PHP код:



stock GetNameFID(NomFID)

{

    new idName[26];

    F(query, sizeof(query), "SELECT name FROM accountsWHERE id='%d'", playerInfo[NomFID][id]);

    mysql_query(query);

    mysql_store_result();

    if(!mysql_num_rows())

    {

        print("Unable to load");

        mysql_free_result();

        return 0;

    }

    while(mysql_fetch_row(query))

    {

        mysql_get_field("name", idName); F(playerInfo[NomFID][name], 32, "%s", idName);

    }

    mysql_free_result();

    return 1;

}

I wan to get a name frome a id in my MYSQL table

Re: Get name frome id [MYSQL] +rep - bgedition - 10.01.2015

Quote:

Originally Posted by StreetRP

pawn Код:

F(query, sizeof(query), "SELECT name FROM accountsWHERE id='%d'", playerInfo[NomFID][id]);

should be:

pawn Код:

F(query, sizeof(query), "SELECT `name` FROM `accounts` WHERE `id` = '%d'", playerInfo[NomFID][id]);

Re : Get name frome id [MYSQL] +rep - StreetRP - 10.01.2015

Thks but doesen't workd :/

Re : Get name frome id [MYSQL] +rep - StreetRP - 11.01.2015

Anyone ?

Re: Get name frome id [MYSQL] +rep - biker122 - 11.01.2015

Can you show us where you use this stock? (If it's a command, show it fully. Same goes if it's a function)

Re: Get name frome id [MYSQL] +rep - Ironboy - 11.01.2015

Give it a whack

pawn Код:

stock GetNameFID(NomFID)
{
    new idName[26];
    F(query, sizeof(query), "SELECT `name` FROM `accounts` WHERE `id` = '%d'", playerInfo[NomFID][id]);
    mysql_query(query);
    mysql_store_result();
    if(!mysql_num_rows())
    {
        print("Unable to load");
        mysql_free_result();
        return 0;
    }
    else if(mysql_num_rows() != 0)
    {
        while(mysql_fetch_row_format(query, "|"))
        {
            mysql_fetch_field_row(idName, "name"); F(playerInfo[NomFID][name], 32, "%s", idName);
        }
    }
    mysql_free_result();
    return 1;
}

Re: Get name frome id [MYSQL] +rep - ea8de1 - 11.01.2015

pawn Код:

stock GetNameFID(NomFID) 
{ 
    new idName[26]; 
    F(query, sizeof(query), "SELECT name FROM accounts WHERE id='%d'", playerInfo[NomFID][id]); 
    mysql_function_query(1,query,true,"OnGetNameFID", "i",NomFID);
    return 1;
}

forward OnGetNameFID(NomFID);
public OnGetNameFID(NomFID)
{
    mysql_store_result(); 
    if(!mysql_num_rows()) 
    { 
        print("Unable to load"); 
        mysql_free_result(); 
        return 0; 
    } 
    while(mysql_fetch_row(query)) 
    { 
        mysql_get_field("name", idName); F(playerInfo[NomFID][name], 32, "%s", idName); 
    } 
    mysql_free_result(); 
    return 1; 
}

Untested.