if (!defined('SED_CODE')) { die('Wrong URL.'); }

// empty mask

$plu_empty = $L['None'];

// function to count pages of given category

function sed_get_numbers($c)

{

global $L, $db_pages, $cfg, $sed_cat, $plu_empty;



$mtch = $sed_cat[$c]['path'].".";

$mtchlen = strlen($mtch);

$catsub = array();

$catsub[] = $c;



@reset($sed_cat);

while (list($i,$x) = each($sed_cat) )

{

if (substr($x['path'],0,$mtchlen)==$mtch)

{

$catsub[] = $i;

}

}



$sql = sed_sql_query("SELECT COUNT(*) FROM $db_pages WHERE page_state=0 AND page_cat NOT LIKE 'system' AND page_cat IN ('".implode("','", $catsub)."')");

$res = sed_sql_result($sql,0,"COUNT(*)");

$res = (empty($res)) ? $plu_empty : $res;



return($res);

}

// checks if user has not added any categories in the configuration part of this plugin

if (!empty($cfg['plugin']['sitestats']['categories']))

{

$katigories = explode(',', $cfg['plugin']['sitestats']['categories']);

foreach($katigories as $k => $i)

{

$i = trim($i);

$noumera[$i] = sed_get_numbers($i);

}

}

// count pages site wide

$sqloles = sed_sql_query("SELECT COUNT(*) FROM $db_pages WHERE page_state=0 AND page_cat NOT LIKE 'system'");

$resoles = sed_sql_result($sqloles,0,"COUNT(*)");

$resoles = (empty($resoles)) ? $plu_empty : $resoles;

// count total downloadable files in pages

$sqlarxeia = sed_sql_query("SELECT COUNT(*) FROM $db_pages WHERE page_file=1 AND page_cat NOT LIKE 'system'");

$resarxeia = sed_sql_result($sqlarxeia,0,"COUNT(*)");

$resarxeia = (empty($resarxeia)) ? $plu_empty : $resarxeia;

// count total topics in forums

$olatatopics = sed_sql_rowcount($db_forum_topics);

// count total posts in forums

$olataposts = sed_sql_rowcount($db_forum_posts);

// count total times all downloadable files have been downloaded

$olatadownloads = sed_sql_query("SELECT SUM(page_filecount) FROM $db_pages");

$olatadownloads = sed_sql_result($olatadownloads,0,"SUM(page_filecount)");

// count total users, excluding inactive and banned

$sqlmeli = sed_sql_query("SELECT COUNT(*) FROM $db_users WHERE user_maingrp NOT LIKE 2 AND user_maingrp NOT LIKE 3");

$olatameli = sed_sql_result($sqlmeli,0,"COUNT(*)");

$olatameli = (empty($olatameli)) ? $plu_empty : $olatameli;



// SHOW OUTPUTS

$t-> assign(array(

"NUMBERS_PAGES" => $resoles,

"NUMBERS_CATEGORY" => $noumera,

"NUMBERS_FILES" => $resarxeia,

"NUMBERS_DOWNLOADS" => $olatadownloads,

"NUMBERS_TOPICS" => $olatatopics,

"NUMBERS_POSTS" => $olataposts,

"NUMBERS_TOTAL_USERS" => $olatameli

));



?>