Amxmodx.lt

Code: Select all

    SQL_ThreadQuery(g_SqlTuple, "OnUpdateTop", "SELECT pName, pSkill FROM pMain JOIN pStats ON pMain.pIp=pStats.pIp ORDER BY pStats.pSkill DESC"); 

Code: Select all

public OnUpdateTop(failState, Handle:query, error[], errorCode){    if (errorCode)        set_fail_state(error);     new szName[33], szSkill;     while (SQL_MoreResults(query))    {        SQL_ReadResult(query, 0, szName, charsmax(szName));        szSkill = SQL_ReadResult(query, 1)        TrieSetCell(Tops, szName);                SQL_NextRow(query);    }}

Code: Select all

#define MAX_TOP 5 enum _:TOP{    TOP_NAME[32],    TOP_SKILL}; new Array:Top; public plugin_init()    Top = ArrayCreate(TOP);

Code: Select all

 ArrayClear(Top); new top[TOP]; while (SQL_MoreResults(query)){    SQL_ReadResult(query, 0, steamId, charsmax(steamId));    TrieSetCell(Positions, steamId, Entries++);     if (Entries <= MAX_TOP)    {        // Cia su salyga kad select'ini tokiu principu: SteamID, Nick, Skill        SQL_ReadResult(query, 1, top[TOP_NAME], charsmax(top[TOP_NAME]));         top[TOP_SKILL] = SQL_ReadResult(query, 2);         ArrayPushArray(Top, top);    }         SQL_NextRow(query);}

Code: Select all

new top[TOP];ArrayGetArray(Top, 0, top); // 0 - tai pirmas top'eclient_print(0, print_chat, "* Pirmas tope yra %s su %d skill'u.", top[TOP_NAME], top[TOP_SKILL]);

Code: Select all

SQL_ThreadQuery(g_SqlTuple, "OnUpdateRank", "SELECT pIp, pName, pSkill FROM pMain LEFT JOIN pStats ON pMain.pIp=pStats.pIp ORDER BY pStats.pSkill DESC");