Amxmodx.lt

Code: Select all

SET @rownum := 0;SELECT * FROM (SELECT @rownum := @rownum+1 AS POSITION, Kills, SteamID FROM `lentele` ORDER BY `Kills` DESC) AS `lentele` WHERE `SteamID` = 'zaidejo_steamid';

Code: Select all

new pozicija[33], isviso; SaveTimeMysql(id){    new Handle:Query = SQL_PrepareQuery(SqlConnection, "SELECT * FROM `lentele`");        if(SQL_Execute(Query))        isviso = SQL_NumResults(Query);            uzkraunam(id);    set_task(0.1, "to_chat", id);   } uzkraunam(id){    static szQuery[ 128 ], iData[ 1 ];     SQL_PrepareQuery(SqlConnection, "SET @rownum := 0");    formatex(szQuery, 127, "SELECT * FROM (SELECT @rownum := @rownum+1 AS POSITION, Kills, SteamID FROM `lentele` ORDER BY `Kills` DESC) AS `lentele` WHERE `SteamID` = '%s'", SteamID);        iData[ 0 ] = id;    SQL_ThreadQuery( g_hTuple, "paimam", szQuery, iData, 1 );} public paimam(iFailState, Handle:hQuery, szError[ ], iError, iData[ ], iDataSize, Float:fQueueTime) {     if(iFailState == TQUERY_CONNECT_FAILED || iFailState == TQUERY_QUERY_FAILED) { log_amx("%s", szError); return; }     else     {         new id = iData[ 0 ];                new ColPos = SQL_FieldNameToNum(hQuery, "POSITION")                 while (SQL_MoreResults(hQuery))        {            pozicija[id] = SQL_ReadResult(hQuery, ColPos);              SQL_NextRow(hQuery)        }    } } public to_chat(id)    client_print(id, print_chat, "Tu esi %d is %d.", pozicija[id], isviso);