COnvert to R33
#1

Hey COuld someone convert this script to mysql r33 please?
pawn Код:
CMD:top(playerid, params[])
{
    new playerData[512], clanname[MAX_PLAYER_NAME], string[512], clankills;
    mysql_query("SELECT `clanname`, `clankills` FROM `clans` ORDER BY `clankills`");
    mysql_store_result();
    while(mysql_retrieve_row())
    {
        mysql_fetch_row(playerData);
        sscanf(playerData, "p<|>s[512]d", clanname, clankills);
        // do something with 'playersName' and 'playersScore'
        format(string, sizeof(string), "%s\n"R"Clan: %s"W"Kills: %d", string, clanname, clankills);
        //SendClientMessage(playerid, ~1, string);
        ShowPlayerDialog( playerid, 1, DIALOG_STYLE_MSGBOX,"Location: Top Clans", string, "(Close)", "");
    }
    mysql_free_result();
    return 1;
}
Reply
#2

This is Urgent
Reply
#3

Check the r33 tutorials and documentation. I'm sure you can do this in less than 30 minutes. Maybe you'll even learn something along the way.
Reply
#4

PHP код:
CMD:top(playeridparams[])
{
    new 
playerData[512], clanname[MAX_PLAYER_NAME], string[512], clankillsMySQL;
    
MySQL mysql_connect("localhost""root""ur_database""");
    
mysql_tquery(MySQL"SELECT `clanname`, `clankills` FROM `clans` ORDER BY `clankills`");
    while(
cache_retrieve_row()))
    {
        
mysql_fetch_row(playerData); // Don't know how to use it, sry
        
sscanf(playerData"p<|>s[512]d"clannameclankills);
        
format(stringsizeof(string), "%s\n"R"Clan: %s"W"Kills: %d"stringclannameclankills);
        
//SendClientMessage(playerid, ~1, string);
        
ShowPlayerDialogplayerid1DIALOG_STYLE_MSGBOX,"Location: Top Clans"string"(Close)""");
    }
    return 
1;

Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)