[EvanChrispie]

Hello,

How would I go about getting the number from the tier column to then print out the map name in a menu. For example if there was a menu to show all tier 1 maps, how could that be done?
Example:

Spoiler

[Weetabix]

Connect to a database defined in the databases.cfg file via SQL_Connect.

Prepare a query to select all items in the database where "tier" is equal to a number. Use SQL_Query

Loop through all rows and fetch the string.

An example of an Sql query:

PHP Code:

char SQL_SomeQuery[]    = "SELECT srv_group FROM sb_admins WHERE authid == 'CONSOLE'" 


svr_group being the collum, sb_admins being the table and after that is basically filters.

[xines]

Originally Posted by Weetabix Use SQL_Query

cough cough SQL_TQuery

[Weetabix]

Originally Posted by xines cough cough SQL_TQuery

Yep, that's more efficient for this I guess.

Use https://sm.alliedmods.net/new-api/dbi if you get confused.

[headline]

Originally Posted by Weetabix Yep, that's more efficient for this I guess. Use https://sm.alliedmods.net/new-api/dbi if you get confused.

It's not a matter of efficiency, but rather one which prevents your game server from freezing while the query is being executed...

[sdz]

something like this.

Spoiler

PHP Code:

public Action command_MapsOfTier(int client, int args)
{
    if(args != 1)
    {
        ReplyToCommand(client, "[Surf] Invalid Syntax: sm_mapsoftier <tier>");
        return Plugin_Handled;
    }

    char arg[32];
    GetCmdArg(1, arg, sizeof(arg));

    LoadMapOfTier(StringToInt(arg), GetClientUserId(client));
    ReplyToCommand(client, "[Surf] Displaying all maps of tier: %i", StringToInt(arg));
    return Plugin_Handled;
}

void LoadMapOfTier(int tier, int clientsend = 0)
{
    char loadQuery[256];
    char formatData[128];

    if(clientsend > 0) Format(formatData, sizeof(formatData), "%i-%i", tier, clientsend);
    else Format(formatData, sizeof(formatData), "%i-0", tier);

    Format(loadQuery, sizeof(loadQuery), "SELECT mapname FROM surf_maps WHERE tier = %i;", tier);
    SQL_TQuery(g_Database, sql_LoadMapOfTier, loadQuery, tier);
}


public void sql_LoadMapOfTier(Handle owner, Handle results, const char[] error, any data)
{
    //Failed Connection:
    if(results == INVALID_HANDLE)
    {
        PrintToServer("[Surf] SQL LoadMapOfTier Query Error: %s", error);
        //Optional, I use this for INITAL loading (map data, player spawns, player stats, etc..) --> SetFailState("[Surf] SQL LoadMapOfTier Query Error: %s", error);
        delete results;
    }

    int count = 0;
    char countStr[16];
    char mapData[128]; strcopy(mapData, sizeof(mapData), data);
    char mapExpl[2][64];
    ExplodeString(mapData, "-", mapExpl, 2, 64);

    int client = GetClientOfUserId(StringToInt(mapExpl[1]));
    int mapTier = StringToInt(mapExpl[0]);

    Menu mapMenu = new Menu(mapHandler);

    while(SQL_FetchRow(results))
    {        
        count++;
        IntToString(count, countStr, sizeof(countStr));

        char mapName[PLATFORM_MAX_PATH];
        int mapField;
        SQL_FieldNameToNum(results, "mapname", mapField);
        SQL_FetchString(results, mapField, mapName, sizeof(mapName));

        mapMenu.AddItem(countStr, mapName);

        PrintToServer("[Surf] Loaded %i Unique Maps from LoadMapOfTier", count);
    }

    mapMenu.SetTitle("Maps of Tier: %i", mapTier);
    mapMenu.Pagination = 7;
    mapMenu.Display(client, 30);
}

int mapHandler(Menu mapMenu, MenuAction action, int client, int selection)
{
    if (action == MenuAction_Select)
    {
        delete mapMenu;
        return 1;
    }
    else if (action == MenuAction_End)
    {
        delete mapMenu;
        return 1;
    }
    return 1;
} 


If you need a dedicated developer, send me a PM.