echo '</td><td v>';
$heute1 = mktime(0, 0, 0, date('m'), date('d') - 1, date('Y'));
$anzheute = db_result(db_query("SELECT COUNT(*) FROM `prefix_posts` WHERE `time` >= " . $heute1 . " AND `time` <= " . $heute), 0, 0);
echo 'Gesamt Posts gestern: ' . $anzheute . '<br /><hr>';
// aktivsten user
$sql = "SELECT COUNT(*) as `kk` , `erst` as `vv` FROM `prefix_posts` WHERE `time` >= " . $heute1 . " AND `time` <= " . $heute . " GROUP BY `vv` ORDER BY `kk` DESC LIMIT 10";
echo '<b>Aktivsten User gestern</b><br />';
forum_statistic_show($sql, $anzheute);
// aktivsten themen
$sql = "SELECT COUNT(*) as `kk` , `name` as `vv` FROM `prefix_topics` LEFT JOIN `prefix_posts` ON `prefix_posts`.`tid` = `prefix_topics`.`id` WHERE `time` >= " . $heute1 . " AND `time` <= " . $heute . " GROUP BY `vv` ORDER BY `kk` DESC LIMIT 10";
echo '<hr><b>Aktivsten Themen gestern</b><br />';
forum_statistic_show($sql, $anzheute);
// aktivsten foren
$sql = "SELECT COUNT(*) as `kk` , `prefix_forums`.`name` as `vv` FROM `prefix_topics` LEFT JOIN `prefix_forums` ON `prefix_forums`.`id` = `prefix_topics`.`fid` LEFT JOIN `prefix_posts` ON `prefix_posts`.`tid` = `prefix_topics`.`id` WHERE `time` >= " . $heute1 . " AND `time` <= " . $heute . " GROUP BY `vv` ORDER BY `kk` DESC LIMIT 10";
echo '<hr><b>Aktivsten Foren gestern</b><br />';
forum_statistic_show($sql, $anzheute);
// neue user heute
$gsh = db_result(db_query("SELECT COUNT(*) FROM `prefix_user` WHERE `regist` >= " . $heute1 . " AND `regist` <= " . $heute), 0, 0);
$sql = "SELECT COUNT(*) as `kk` , `name` as `vv` FROM `prefix_user` WHERE `regist` >= " . $heute1 . " AND `regist` <= " . $heute . " GROUP BY `vv` ORDER BY `kk` DESC LIMIT 10";
echo '<hr><b>Neue User gestern</b><br />';
forum_statistic_show($sql, $gsh);
echo '</td></tr></table>';
// meist besuchte Seiten
$gsh = db_result(db_query("SELECT COUNT(*) FROM `prefix_stats_content` ORDER BY counter DESC LIMIT 25"), 0, 0);
$sql = "SELECT counter, content FROM `prefix_stats_content` ORDER BY counter DESC LIMIT 25";
echo '<hr><b>meist besuchter Content</b><br />';
forum_statistic_show($sql, $anzheute);
// #########################################
break;
}
$design->footer();
$gsh = db_result(db_query("SELECT COUNT(*) FROM prefix_user WHERE regist >= " . $heute), 0, 0);
$sql = "SELECT COUNT(*) as kk , name as vv FROM prefix_user WHERE regist >= " . $heute . " GROUP BY vv ORDER BY kk DESC LIMIT 10";
echo '<hr><b>Neue User heute</b><br />';
forum_statistic_show($sql, $gsh);
echo '</td><td valign="top">';
$heute1 = mktime(0, 0, 0, date('m'), date('d') - 1, date('Y'));
$anzheute = db_result(db_query("SELECT COUNT(*) FROM prefix_posts WHERE time >= " . $heute1 . " AND time <= " . $heute), 0, 0);
echo 'Gesamt Posts gestern: ' . $anzheute . '<br /><hr>';
# aktivsten user
$sql = "SELECT COUNT(*) as kk , erst as vv FROM prefix_posts WHERE time >= " . $heute1 . " AND time <= " . $heute . " GROUP BY vv ORDER BY kk DESC LIMIT 10";
echo '<b>Aktivsten User gestern</b><br />';
forum_statistic_show($sql, $anzheute);
# aktivsten themen
$sql = "SELECT COUNT(*) as kk , name as vv FROM prefix_topics LEFT JOIN prefix_posts ON prefix_posts.tid = prefix_topics.id WHERE time >= " . $heute1 . " AND time <= " . $heute . " GROUP BY vv ORDER BY kk DESC LIMIT 10";
echo '<hr><b>Aktivsten Themen gestern</b><br />';
forum_statistic_show($sql, $anzheute);
# aktivsten foren
$sql = "SELECT COUNT(*) as kk , prefix_forums.name as vv FROM prefix_topics LEFT JOIN prefix_forums ON prefix_forums.id = prefix_topics.fid LEFT JOIN prefix_posts ON prefix_posts.tid = prefix_topics.id WHERE time >= " . $heute1 . " AND time <= " . $heute . " GROUP BY vv ORDER BY kk DESC LIMIT 10";
echo '<hr><b>Aktivsten Foren gestern</b><br />';
forum_statistic_show($sql, $anzheute);
# neue user heute
$gsh = db_result(db_query("SELECT COUNT(*) FROM prefix_user WHERE regist >= " . $heute1 . " AND regist <= " . $heute), 0, 0);
$sql = "SELECT COUNT(*) as kk , name as vv FROM prefix_user WHERE regist >= " . $heute1 . " AND regist <= " . $heute . " GROUP BY vv ORDER BY kk DESC LIMIT 10";
echo '<hr><b>Neue User gestern</b><br />';
forum_statistic_show($sql, $gsh);
echo '</td></tr></table>';
echo '<h1>Es ist ganz ehrlich noch mehr geplant :P</h1>';
##########################################
break;
}
$design->footer();
