$query = $db->simple_select(TABLE_PREFIX."threads", "COUNT(tid) AS threads", "visible='1' AND closed NOT LIKE 'moved|%'"); $stats['numthreads'] = $db->fetch_field($query, 'threads');
| $query = $db->simple_select(TABLE_PREFIX."forums", "SUM(threads) AS numthreads"); $stats['numthreads'] = $db->fetch_field($query, 'numthreads'); if(!$stats['numthreads']) { $stats['numthreads'] = 0; } $query = $db->simple_select(TABLE_PREFIX."forums", "SUM(posts) AS numposts"); $stats['numposts'] = $db->fetch_field($query, 'numposts'); if(!$stats['numposts']) { $stats['numposts'] = 0; }
|
$query = $db->simple_select(TABLE_PREFIX."users", "COUNT(uid) AS users"); $stats['numusers'] = $db->fetch_field($query, 'users');
|
$query = $db->simple_select(TABLE_PREFIX."users", "COUNT(uid) AS users"); $stats['numusers'] = $db->fetch_field($query, 'users');
|