diff options
| -rw-r--r-- | src/game/server/ranking.cpp | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/game/server/ranking.cpp b/src/game/server/ranking.cpp index 9ef6cd87..92da5966 100644 --- a/src/game/server/ranking.cpp +++ b/src/game/server/ranking.cpp @@ -281,7 +281,7 @@ void CRanking::ShowRankingThread(void *pUser){ pData->m_pSqlData->m_pStatement->execute("SET @prev := NULL;"); pData->m_pSqlData->m_pStatement->execute("SET @rank := 1;"); - str_format(aBuf, sizeof(aBuf), "SELECT Wins,Name, rank FROM (SELECT (@pos := @pos+1) pos, (@rank := IF(@prev = Wins,@rank, @pos)) rank, Name, (@prev := Wins) Wins FROM zcatch_ranks ORDER BY Wins DESC) as result WHERE Name='%s';", pData->m_aName); + str_format(aBuf, sizeof(aBuf), "SELECT Wins,Name, rank FROM (SELECT (@pos := @pos+1) pos, (@rank := IF(@prev = Wins,@rank, @pos)) rank, Name, (@prev := Wins) Wins FROM (SELECT Name, Wins FROM zcatch_ranks ORDER BY Wins DESC Limit 18446744073709551615) as a) as b WHERE Name='%s';", pData->m_aName); pData->m_pSqlData->m_pResults = pData->m_pSqlData->m_pStatement->executeQuery(aBuf); if(pData->m_pSqlData->m_pResults->next()) @@ -352,7 +352,7 @@ void CRanking::ShowTop5Thread(void *pUser){ pData->m_pSqlData->m_pStatement->execute("SET @prev := NULL;"); pData->m_pSqlData->m_pStatement->execute("SET @rank := 1;"); - str_format(aBuf, sizeof(aBuf), "SELECT Wins,Name, rank FROM (SELECT (@pos := @pos+1) pos, (@rank := IF(@prev = Wins,@rank, @pos)) rank, Name, (@prev := Wins) Wins FROM zcatch_ranks ORDER BY Wins DESC) as result ORDER BY rank Limit %d,5;", pData->m_Offset); + str_format(aBuf, sizeof(aBuf), "SELECT Wins,Name, rank FROM (SELECT (@pos := @pos+1) pos, (@rank := IF(@prev = Wins,@rank, @pos)) rank, Name, (@prev := Wins) Wins FROM (SELECT Name, Wins FROM zcatch_ranks ORDER BY Wins DESC Limit 18446744073709551615) as a) as b ORDER BY rank Limit %d,5;", pData->m_Offset); pData->m_pSqlData->m_pResults = pData->m_pSqlData->m_pStatement->executeQuery(aBuf); |