[Pseudomizer]

Originally Posted by P.Jackson

what would be the code to get total threads and how many users online?

Users online:

PHP Code:

$onlineusers = $DB_site->query("
                        ## GET ONLINE USERS ##
                        SELECT user.username, (user.options & $_USEROPTIONS[invisible]) AS invisible,
                        user.usergroupid, session.userid, session.lastactivity,
                        IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
                        FROM ".TABLE_PREFIX."session AS session
                        LEFT JOIN ".TABLE_PREFIX."user AS user ON (user.userid = session.userid)
                        WHERE session.lastactivity > $online[datecut]
                        ORDER BY ".iif($permissions['genericpermissions'] & CANSEEHIDDEN, 'invisible ASC, ')."username ASC"); 


Total Threads:

PHP Code:

$totalthreads = $DB_site->query("Select count(threadid) from thread where visible = '1' ); 


Cheers,