diff options
| author | David M <davidmj@users.sourceforge.net> | 2006-10-01 08:48:32 +0000 |
|---|---|---|
| committer | David M <davidmj@users.sourceforge.net> | 2006-10-01 08:48:32 +0000 |
| commit | bc15445b58403c92ebca9e23ef3d9a59fbdccc92 (patch) | |
| tree | 46880b44be1949f01ada2f29e7f3f42ab4123c1b /phpBB/includes/mcp | |
| parent | bc770de9b93973a359a46ef39838e89f18e685ae (diff) | |
| download | forums-bc15445b58403c92ebca9e23ef3d9a59fbdccc92.tar forums-bc15445b58403c92ebca9e23ef3d9a59fbdccc92.tar.gz forums-bc15445b58403c92ebca9e23ef3d9a59fbdccc92.tar.bz2 forums-bc15445b58403c92ebca9e23ef3d9a59fbdccc92.tar.xz forums-bc15445b58403c92ebca9e23ef3d9a59fbdccc92.zip | |
- forgot to make the same change to the ODBC driver
- MySQL 3.x works now
- FirebirdSQL is now on the same level as MySQL and PostgreSQL, zero hacks exist inside the core code now
git-svn-id: file:///svn/phpbb/trunk@6422 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/includes/mcp')
| -rw-r--r-- | phpBB/includes/mcp/mcp_post.php | 25 |
1 files changed, 5 insertions, 20 deletions
diff --git a/phpBB/includes/mcp/mcp_post.php b/phpBB/includes/mcp/mcp_post.php index 4e931d2d9c..10f7ad5811 100644 --- a/phpBB/includes/mcp/mcp_post.php +++ b/phpBB/includes/mcp/mcp_post.php @@ -280,26 +280,11 @@ function mcp_post_details($id, $mode, $action) // but the extra size is only valuable if there are persons having more than a thousands posts. // This is better left to the really really big forums. - // Firebird does not support ORDER BY on aliased columns - // MySQL does not support ORDER BY on functions - switch (SQL_LAYER) - { - case 'firebird': - $sql = 'SELECT poster_ip, COUNT(poster_ip) AS postings - FROM ' . POSTS_TABLE . ' - WHERE poster_id = ' . $post_info['poster_id'] . ' - GROUP BY poster_ip - ORDER BY COUNT(poster_ip) DESC'; - break; - - default: - $sql = 'SELECT poster_ip, COUNT(poster_ip) AS postings - FROM ' . POSTS_TABLE . ' - WHERE poster_id = ' . $post_info['poster_id'] . ' - GROUP BY poster_ip - ORDER BY postings DESC'; - break; - } + $sql = 'SELECT poster_ip, COUNT(poster_ip) AS postings + FROM ' . POSTS_TABLE . ' + WHERE poster_id = ' . $post_info['poster_id'] . ' + GROUP BY poster_ip + ORDER BY postings DESC'; $result = $db->sql_query($sql); while ($row = $db->sql_fetchrow($result)) |