<?php
/********************************************************************************/ 
/*  Wap-2-Go Mobile Phone Nuke-Addon                                            */
/*          bringing the Advanced Content Management System to Mobile Format    */
/*  =========================================================================== */
/*                                              powered by Nuke SQL Database    */
/*                                                                              */
/* Copyright (c) 2007 by Philip Marsh   -   http://wap2go.co.uk                 */
/*                                                                              */
/*  FILE DETAILS and EXPLANATION:                                               */
/*  functions.php - Specific Functions for Module                               */
/********************************************************************************/ 
// Include the Module's Functions
include_once "functions.php";

// Module Content

// DISPLAY SITE STATISTICS
        $dbi = sql_connect($dbhost, $dbuname, $dbpass, $dbname);
        $result = $db->sql_query("select title, sid from $prefix"._stories." order by sid DESC limit 0,10");
        $row = $db->sql_fetchrow($result);
        $result = $db->sql_query("select count(*) C from ".$prefix."_session where guest=0");       
        $members = $db->sql_fetchrow($result);      
        $result = $db->sql_query("select count(*) C from ".$prefix."_users");
        $tmembers = $db->sql_fetchrow($result);
        $result = $db->sql_query("select count(*) C from ".$prefix."_session where guest=1");
        $guests = $db->sql_fetchrow($result);
        $num_rev = $db->sql_numrows($db->sql_query("SELECT * from ".$prefix."_reviews"));

        $articles   = $db->sql_numrows($db->sql_query("select * from $prefix"._stories.""));
        $links      = $db->sql_numrows($db->sql_query("select * from $prefix"._links_links.""));
        $downloads  = $db->sql_numrows($db->sql_query("select * from $prefix"._downloads_downloads.""));    
        
        $date=date("j.n.Y");
        $d = explode(".", $date);
        $day = $d[0];
        $month = $d[1];
        $year = $d[2];
        $result = $db->sql_query("select hits from $prefix"._stats_date." where date = '$day' and month= '$month' and year = '$year'");
        $row = $db->sql_fetchrow($result);
        $valtoday = $row["hits"];

        $result = $db->sql_query("select count from $prefix"._counter." order by count desc");
        $clicks = $db->sql_fetchrow($result);       
        $content    =   _CURRENTLY." ".$guests[C]." "._GUESTS." ".$members[C]." "._MEMBERS._BR;
        $content    .=  ""._REGUSERS." ".$tmembers[C]._BR;
        $content    .=  ""._STORIESPUBLISHED." ".$articles._BR;
        $content    .=  ""._LINKSINLINKS." ".$links._BR;
        $content    .=  ""._UDOWNLOADS.": ".$downloads._BR;
        $content    .=  "Visits Today: ".$valtoday._BR;
        $content    .=  ""._WERECEIVED." ".$clicks[count]." "._PAGESVIEWS." ".$startdate."";
        $title      =   ""._STATS."";       
OpenTable();
    $title = ""._STATS."";
    $title   = char_dec($title);
    $content = char_dec($content);
    Title($title);
    echo _P_CENTER.$content._P_END;
CloseTable();
?>