Check the new Tutorial subforum with helpfull guides and tutorials for modifications and tweaks.
0 Members and 1 Guest are viewing this topic.
<?php//----------------------------------------------------- //--- Show number of Users ---------------------------- //----------------------------------------------------- $sql = "SELECT COUNT(*) as users FROM ".USERS_TABLE." WHERE user_id <> ".GUEST; $row = $site_db->query_firstrow($sql); $total_users = "".$lang['users']."<B> ".$row['users']."</B>\n"; $site_template->register_vars("total_users", $total_users); unset($total_users); //----------------------------------------------------- //--- Hits -------------------------------------------- //----------------------------------------------------- $sql = "SELECT SUM(image_hits) AS sum FROM ".IMAGES_TABLE; $row = $site_db->query_firstrow($sql); $sum = (isset($row['sum'])) ? $row['sum'] : 0; $total_hits = "".$lang['total_hits']."<B> ".$row['sum']."</B>\n"; $site_template->register_vars("total_hits", $total_hits); unset($total_hits); //----------------------------------------------------- //--- Votes ------------------------------------------- //----------------------------------------------------- $sql = "SELECT SUM(image_votes) AS sum FROM ".IMAGES_TABLE; $row = $site_db->query_firstrow($sql); $sum = (isset($row['sum'])) ? $row['sum'] : 0; $total_votes = "".$lang['total_votes']."<B> ".$row['sum']."</B>\n"; $site_template->register_vars("total_votes", $total_votes); unset($total_votes); //----------------------------------------------------- //--- Downloads --------------------------------------- //----------------------------------------------------- $sql = "SELECT SUM(image_downloads) AS sum FROM ".IMAGES_TABLE; $row = $site_db->query_firstrow($sql); $sum = (isset($row['sum'])) ? $row['sum'] : 0; $total_downloads = "".$lang['total_downloads']."<B> ".$row['sum']."</B>\n"; $site_template->register_vars("total_downloads", $total_downloads); unset($total_downloads); //----------------------------------------------------- //--- Comments ---------------------------------------- //----------------------------------------------------- $sql = "SELECT SUM(image_comments) AS sum FROM ".IMAGES_TABLE; $row = $site_db->query_firstrow($sql); $sum = (isset($row['sum'])) ? $row['sum'] : 0; $total_comments = "".$lang['total_comments']."<B> ".$row['sum']."</B>\n"; $site_template->register_vars("total_comments", $total_comments); unset($total_comments); ?>