Файл: forum/count.php
Строк: 10
<?php
$count = mysql_fetch_assoc(query("SELECT * FROM (
SELECT COUNT( * ) AS forum_posts FROM `forum_posts`) AS q1, (
SELECT COUNT( * ) AS forum_posts_new FROM `forum_posts` WHERE `time` > '".(time()-60*60*24)."') AS q2, (
SELECT COUNT( * ) AS forum_themes FROM `forum_themes`) AS q3, (
SELECT COUNT( * ) AS forum_themes_new FROM `forum_themes` WHERE `time` > '".(time()-60*60*24)."') AS q4
"));
echo $count['forum_posts'].'/+'.$count['forum_posts_new'].' | '.$count['forum_themes'].'/+'.$count['forum_themes_new'];
?>