//ADDED CODE TO SHOW STATISTICS

// Featured Link Counter
$stat_featured = $db->GetOne("SELECT COUNT(*) FROM `{$tables['link']['name']}` WHERE `STATUS` = 2 AND `FEATURED` = 1 ");
$tpl->assign('stat_featured', $stat_featured);
// End

// Total Links Counter
$total_links = $db->GetOne("SELECT COUNT(*) FROM `{$tables['link']['name']}` WHERE `STATUS` = 2");
$tpl->assign('total_links', $total_links);
//End

//Links NOT active Counter
$unverified = $db->GetOne("SELECT COUNT(*) FROM `{$tables['link']['name']}` WHERE `STATUS` = 0");
$tpl->assign('unverified', $unverified);
//End

// Awaiting Admin Review Counter
$pending_links = $db->GetOne("SELECT COUNT(*) FROM `{$tables['link']['name']}` WHERE `STATUS` = 1");
$tpl->assign('pending_links', $pending_links);
//End

// Links submitted today counter
$today_links = $db->GetOne("SELECT COUNT(*) FROM `{$tables['link']['name']}` WHERE `DATE_ADDED` >= CURRENT_DATE");
$tpl->assign('today_links', $today_links);
//End

//Total categories counter
$categorys = $db->GetOne("SELECT COUNT(*) FROM `{$tables['category']['name']}` WHERE `PARENT_ID` = 0 ");
$tpl->assign('categorys', $categorys);
//End

//Sub categories Counter
$subcategorys = $db->GetOne("SELECT COUNT(*) FROM `{$tables['category']['name']}` WHERE `PARENT_ID` > 0 ");
$tpl->assign('subcategorys', $subcategorys);
//End

//Total Articles Counter
$articlecount = $db->GetOne("SELECT COUNT(*) FROM `{$tables['article']['name']}` WHERE `STATUS` = 2");
$tpl->assign('articlecount', $articlecount);
//End

//Total Members counter
$members = $db->GetOne("SELECT COUNT(*) FROM `{$tables['user']['name']}` WHERE `ACTIVE` = 1");
$tpl->assign('members', $members);
//End

//Total Images counter (for those with image mod)
$imagecount = $db->GetOne("SELECT COUNT(*) FROM `{$tables['image']['name']}` WHERE `STATUS` = 2");
$tpl->assign('imagecount', $imagecount);
//End

//Links yesterday counter
$yes = time()-86400;
$yesterday = date("Ymd",$yes);
$yesterday_links = $db->GetOne("SELECT COUNT(*) FROM `{$tables['link']['name']}` WHERE `DATE_ADDED` < CURRENT_DATE AND `DATE_ADDED` >= ".$yesterday);
$tpl->assign('yesterday_links', $yesterday_links);
//End

//Last 7 days counter
$week = time()-604800;
$this_week = date("Ymd",$week);
$this_weeks_links = $db->GetOne("SELECT COUNT(*) FROM `{$tables['link']['name']}` WHERE `DATE_ADDED` >= ".$this_week);
$tpl->assign('this_weeks_links', $this_weeks_links);
//End

//Referred Traffic counter (traffic out)
$traffic = $db->GetOne("SELECT SUM(HITS) FROM {$tables['link']['name']} WHERE STATUS = 2");
$tpl->assign('traffic', $traffic);
//EndIn your template file put each of these anywhere

{$stat_featured}
{$total_links}
{$unverified}
{$pending_links}
{$today_links}
{$categorys}
{$subcategorys}
{$articlecount}
{$members}
{$imagecount}
{$yesterday_links}
{$this_weeks_links}
{$traffic}