diff options
| author | Meik Sievertsen <acydburn@phpbb.com> | 2003-10-10 15:59:45 +0000 |
|---|---|---|
| committer | Meik Sievertsen <acydburn@phpbb.com> | 2003-10-10 15:59:45 +0000 |
| commit | 508b94ee1290589c1eed466d529feeb166270d02 (patch) | |
| tree | aeeffa9379330c8bdca186be1d2f22c20425e7b5 /phpBB/includes/functions_posting.php | |
| parent | 2094094b766114f327defc1987e20d0d826eaa88 (diff) | |
| download | forums-508b94ee1290589c1eed466d529feeb166270d02.tar forums-508b94ee1290589c1eed466d529feeb166270d02.tar.gz forums-508b94ee1290589c1eed466d529feeb166270d02.tar.bz2 forums-508b94ee1290589c1eed466d529feeb166270d02.tar.xz forums-508b94ee1290589c1eed466d529feeb166270d02.zip | |
ok, but now, really group by. :)
git-svn-id: file:///svn/phpbb/trunk@4549 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/includes/functions_posting.php')
| -rw-r--r-- | phpBB/includes/functions_posting.php | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/phpBB/includes/functions_posting.php b/phpBB/includes/functions_posting.php index b106799c7b..52fc9d90fd 100644 --- a/phpBB/includes/functions_posting.php +++ b/phpBB/includes/functions_posting.php @@ -43,7 +43,8 @@ function generate_smilies($mode, $forum_id) if ($mode == 'inline') { $sql = 'SELECT COUNT(*) as num_smilies - FROM ' . SMILIES_TABLE; + FROM ' . SMILIES_TABLE . ' + GROUP BY smile_url'; $result = $db->sql_query_limit($sql, 1, 0, 3600); $row = $db->sql_fetchrow($result); $num_smilies = (int) $row['num_smilies']; |