diff options
| author | def <dennis@felsin9.de> | 2016-06-20 17:40:05 +0200 |
|---|---|---|
| committer | def <dennis@felsin9.de> | 2016-06-20 17:40:05 +0200 |
| commit | 64f77f818a112766dd0cbeb686c5e5b72c9e2654 (patch) | |
| tree | 2df2d7071990e9fe74958a16470646f4f812a7c1 /src | |
| parent | 946cbe202f574a592d040606809e10fe7d70f7ac (diff) | |
| download | zcatch-64f77f818a112766dd0cbeb686c5e5b72c9e2654.tar.gz zcatch-64f77f818a112766dd0cbeb686c5e5b72c9e2654.zip | |
Fix SQL queries on MariaDB 10
Diffstat (limited to 'src')
| -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); |