[cristian20042]

Hello! I would really like to know how I can make a plugin that is a top 10 players in order of a value selected by me from my database. Example: I write !top and it says the top 10 players with the most points on my server.

!top

1. Player1 - 10000 points
2. Player2 - 9953 points

[Neuro Toxin]

Use your MySQL query to sort your data. Not sourcepawn!

An example query.

SELECT * FROM `table` ORDER BY `pointscolumn` DESC LIMIT 1,10

[mug1wara]

PHP Code:

SELECT * FROM table ORDER BY table_points DESC 


@Neuro Toxin
I wouldn't set a LIMIT + 1,10 won't work...

@cristian20042
Using my example of course requires you to have the right columns (name, points, etc... you know the drill).

PHP Code:

public void SQL_Top(Database hDatabase, DBResultSet hResults, const char[] sError, int iData)
{
    if (hResults == null)
        ThrowError(sError);
    
    int iClient = GetClientOfUserId(iData);
    
    int iRank, iPoints;
    
    char sName[256];
    
    while (hResults.FetchRow())
    {
        if (++iRank > THE_AMOUNT_OF_PLAYERS_TO_ORDER)
            continue;
        
        iPoints = hResults.FetchInt(YOUR_COLUMN_NUMBER);
        
        hResults.FetchString(YOUR_COLUMN_NUMBER, sName, 256);
        
        PrintToChat(iClient, "%d %s %d", iRank, sName, iPoints);
    }
} 


[cristian20042]

Thanks! What about creating a menu that shows you that? What should I do?

[headline]

Originally Posted by cristian20042 Thanks! What about creating a menu that shows you that? What should I do?

something along the lines of
https://github.com/Headline/Gangs/bl...gangs.sp#L2274

[mug1wara]

or just like this :p

PHP Code:

public void SQL_Top(Database hDatabase, DBResultSet hResults, const char[] sError, int iData)
{
    if (hResults == null)
        ThrowError(sError);
    
    int iClient = GetClientOfUserId(iData);
    
    int iRank, iPoints;
    
    char sName[256], sMenuContent[256];
    
    Menu hMenu = new Menu(Menu_Handler);
    
    while (hResults.FetchRow())
    {
        if (++iRank > THE_AMOUNT_OF_PLAYERS_TO_ORDER)
            continue;
        
        iPoints = hResults.FetchInt(YOUR_COLUMN_NUMBER);
        
        hResults.FetchString(YOUR_COLUMN_NUMBER, sName, 256);
        
        Format(sMenuContent, sizeof(sMenuContent), "%s %d", sName, iPoints);
        hMenu.AddItem("", sMenuContent, ITEMDRAW_DISABLED);
    }
    
    hMenu.Display(iClient, MENU_TIME_FOREVER);
} 


[cristian20042]

Originally Posted by mug1wara or just like this :p PHP Code: public void SQL_Top(Database hDatabase, DBResultSet hResults, const char[] sError, int iData) {     if (hResults == null)         ThrowError(sError);          int iClient = GetClientOfUserId(iData);          int iRank, iPoints;          char sName[256], sMenuContent[256];          Menu hMenu = new Menu(Menu_Handler);          while (hResults.FetchRow())     {         if (++iRank > THE_AMOUNT_OF_PLAYERS_TO_ORDER)             continue;                  iPoints = hResults.FetchInt(YOUR_COLUMN_NUMBER);                  hResults.FetchString(YOUR_COLUMN_NUMBER, sName, 256);                  Format(sMenuContent, sizeof(sMenuContent), "%s %d", sName, iPoints);         hMenu.AddItem("", sMenuContent, ITEMDRAW_DISABLED);     }          hMenu.Display(iClient, MENU_TIME_FOREVER); }

top.sp(51) : error 017: undefined symbol "Menu_Handler"

PHP Code:

Menu hMenu = new Menu(Menu_Handler); 


[cristian20042]

All right, can someone good enough make an example plugin please?

[mug1wara]

Did you just call me bad?

I thought you were going to do the menu callback at least. :/

[Addicted.]

Originally Posted by mug1wara Did you just call me bad? I thought you were going to do the menu callback at least. :/

Some people don’t know how to take help when it’s given