- 01
- 02
- 03
- 04
- 05
- 06
- 07
- 08
- 09
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
// what version of MySQL
$mysql = $db->query_first("SELECT VERSION() AS version");
$mysql = $mysql['version'];
// Post count
$posts = $db->query_first("SELECT COUNT(*) AS total FROM " . TABLE_PREFIX . "post");
$posts = $posts['total'];
// User Count
$users = $db->query_first("SELECT COUNT(*) AS total FROM " . TABLE_PREFIX . "user");
$users = $users['total'];
// Forum Count
$forums = $db->query_first("SELECT COUNT(*) AS total FROM " . TABLE_PREFIX . "forum");
$forums = $forums['total'];
// Usergroup Count
$usergroups = $db->query_first("SELECT COUNT(*) AS total FROM " . TABLE_PREFIX . "usergroup");
$usergroups = $usergroups['total'];
// First Forum Post
$firstpost = $db->query_first("SELECT MIN(dateline) AS firstpost FROM " . TABLE_PREFIX . "post");
$firstpost = $firstpost['firstpost'];
// Last upgrade performed
$lastupgrade = $db->query_first("SELECT MAX(dateline) AS lastdate FROM " . TABLE_PREFIX . "upgradelog");
$lastupgrade = $lastupgrade['lastdate'];
sectus 22.02.2011 04:48 # 0
Vasiliy 22.02.2011 07:41 # 0
sectus 22.02.2011 08:28 # 0
istem 22.02.2011 12:14 # 0
хотя если каунты, да мин максы, то быстро пробежится...
sectus 22.02.2011 12:29 # +1