[Flow Low]

I'm working on a plug-in and am storing my information of each player in keyvalues like this \/ and i need to know how to go through all of these steam ids and sort them in order by there statpoints

"MyFile"
{
	"STEAM_0:0:7"
	{
		"statpoints"	"758396"
		"kills"		"6474759473"
		"deaths"	"73956395"
	}
}

[noodleboy347]

It would probably be best to use a database and using "ORDER BY". Otherwise just loop though all the keyvalues x times and get the next highest one each time.

[Master53]

wouldn't SQL based saving be better than KV?

[Flow Low]

Probably, looks like im going to have to learn sql

[Master53]

i can give you an example of a your ranking mod.

PHP Code:

    //Handle:
    new Handle:query = SQL_Query(hSQL, buffer);

    //Sql String:
    Format(buffer, sizeof(buffer), "SELECT * FROM `PlayerRank` ORDER BY Points DESC LIMIT 10;");

    //Handle:
    query = SQL_Query(hSQL, buffer);

    //Declare:
    new i = 0;

    //Declare:
    decl TopSteamId[10], String:TopName[10][32];

    //Not Player:
    while (SQL_FetchRow(query))
    {

        //Database Field Loading Intiger:
        TopSteamId[i] = SQL_FetchInt(query, 0);

        //Database Field Loading String:
        SQL_FetchString(query, 1, TopName[i], 32);

        i++;
    }

    //Close:
    CloseHandle(query); 


will fetch database field from a clients steamid.

you can also use a SQL_TQuery but i like to use SQL_Query to fetch database data.

PHP Code:


    //Declare:
    decl String:buffer[256];

    //Format:
    Format(buffer, sizeof(buffer), "SELECT * FROM `PlayerRank` ORDER BY POINTS DESC LIMIT 0,10");

    //Handle:
    SQL_TQuery(db, T_ShowTOP1, buffer, GetClientUserId(Client));


public T_ShowTOP1(Handle:owner, Handle:hndl, const String:error[], any:data)
{

    //Declare:
    decl client;

    /* Make sure the client didn't disconnect while the thread was running */
    if((client = GetClientOfUserId(data)) == 0)
    {

        //Return:
        return;
    }

    if (hndl == INVALID_HANDLE)
    {

        //Log Error:
        LogError("Query failed! %s", error);
    }
    else
    {

        //Declare:
        decl TopSteamId[10], String:TopName[10][32];

        //Declare:
        new i = 1;

        //Not Player:
        while (SQL_FetchRow(hndl))
        {

            //Database Field Loading Intiger:
            TopSteamId[i] = SQL_FetchInt(query, 0);

            //Database Field Loading String:
            SQL_FetchString(query, 1, TopName[i], 32);

            i++;
        }

        //Return:
        return
    }

    //Return:
    return
} 


is an example of using SQL_TQuery.

[Samantha]

Forget everything that was said and read this: http://wiki.alliedmods.net/SQL_%28So...d_Scripting%29

If you've never used mysql before read this http://www.w3schools.com/sql/default.asp

[Dravu]

If you use SQL, please use the threaded version for Sourcemod.