Get name mysql - Printable Version

Get name mysql - 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 mysql (/showthread.php?tid=424119)

Get name mysql - ancezas - 20.03.2013

i what to fetch player name but i fail code:

pawn Код:

CMD:testukas(playerid, params[])
{
    mysql_query( "SELECT MAX(ID) FROM `vartotojai`" );
    mysql_store_result();
    if (mysql_num_rows())
    {
        new IDD = mysql_fetch_int(),
            string[ 128 ];
        mysql_query( "SELECT `Vardas` FROM `vartotojai` WHERE `ID` = '%i'", IDD);
        mysql_store_result();
        new fetch[ 24 ];
        new Vardukas[ 24 ] = mysql_fetch_field_row(fetch, "Vardas");

        format(string, sizeof(string), "Max ID: %i %s", IDD, Vardukas);
        SendClientMessage(playerid,-1,string);
        mysql_free_result();
    }
    mysql_free_result();
    return 1;
}

Re: Get name mysql - Misiur - 20.03.2013

Read about threaded queries.

pawn Код:

CMD:testukas(playerid, params[])
{
    mysql_query( "SELECT MAX(ID) as mid, `Vardas` FROM `vartotojai` ORDER BY ID DESC LIMIT 0,1" );
    mysql_store_result();
    if (mysql_num_rows())
    {
        new Vardukas[ 24 ], IDD, string[64];
        mysql_fetch_field_row(Vardukas, "Vardas");
        mysql_fetch_field_row(IDD, "mid");
        format(string, sizeof(string), "Max ID: %i %s", IDD, Vardukas);
        SendClientMessage(playerid,-1,string);
    }
    mysql_free_result();
    return 1;
}

Re: Get name mysql - ancezas - 20.03.2013

pawn Код:

(2524) : error 035: argument type mismatch (argument 1)

in line:

pawn Код:

mysql_fetch_field_row(IDD, "mid");

Re: Get name mysql - Misiur - 20.03.2013

pawn Код:

//change
mysql_fetch_field_row(IDD, "mid");

//to
mysql_fetch_field_row(string, "mid");
IDD = strval(string);

Wrong habit activated

Re: Get name mysql - ancezas - 20.03.2013

not working at all your script, in my script i get max ID whit your code i still didint get name and not geting ID