Exemplo n.º 1
0
function getstatvars_forumstat($fid)
{
    global $_G;
    $xml = "<chart>\n";
    $statvars = array();
    $monthdays = array('31', '29', '31', '30', '31', '30', '31', '31', '30', '31', '30', '31');
    if (!$fid) {
        $query = C::t('forum_forum')->fetch_all_fids();
        $forums = array();
        foreach ($query as $val) {
            $forums[] = array('fid' => $val['fid'], 'type' => $val['type'], 'name' => $val['name'], 'posts' => $val['posts']);
        }
        $statvars['forums'] = $forums;
    } else {
        $foruminfo = C::t('forum_forum')->fetch($fid);
        $statvars['foruminfo'] = array('fid' => $foruminfo['fid'], 'name' => $foruminfo['name'], 'posts' => $foruminfo['posts'], 'threads' => $foruminfo['threads'], 'todayposts' => $foruminfo['todayposts']);
        $current_date = $end_date = date('Y-m-d');
        $current_month = $end_month = date('Y-m');
        $current_month_start = $end_month_start = $current_month . '-01';
        if ($_GET['month']) {
            $end_month = trim($_GET['month']);
            $month = substr($end_month, strpos($end_month, '-') + 1);
            $end_date = $end_month . '-' . $monthdays[$month - 1];
            $end_month_start = $end_month . '-' . '01';
        }
        $statvars['month'] = $end_month;
        $logs = array();
        $xml .= "<xaxis>\n";
        $xmlvalue = '';
        $xaxisindex = 0;
        foreach (C::t('forum_statlog')->fetch_all_by_logdate($end_month_start, $end_date, $fid) as $log) {
            $logs[] = $log;
            list($yyyy, $mm, $dd) = explode('-', $log['logdate']);
            $xaxisindex++;
            $xml .= "<value xid=\"{$xaxisindex}\">{$mm}{$dd}</value>\n";
            $xmlvalue .= "<value xid=\"{$xaxisindex}\">{$log['value']}</value>\n";
        }
        $xml .= "</xaxis>\n";
        $xml .= "<graphs>\n";
        $xml .= "<graph gid=\"0\" title=\"" . diconv(lang('spacecp', 'do_stat_post_number'), CHARSET, 'UTF-8') . "\">\n";
        $xml .= $xmlvalue;
        $xml .= "</graph>\n";
        $xml .= "</graphs>\n";
        $xml .= "</chart>\n";
        if ($_GET['xml']) {
            @header("Expires: -1");
            @header("Cache-Control: no-store, private, post-check=0, pre-check=0, max-age=0", FALSE);
            @header("Pragma: no-cache");
            @header("Content-type: application/xml; charset=utf-8");
            echo $xml;
            exit;
        }
        $statvars['logs'] = $logs;
        $mindate = C::t('forum_statlog')->fetch_min_logdate_by_fid($fid);
        list($minyear, $minmonth, $minday) = explode('-', $mindate);
        $minmonth = $minyear . '-' . $minmonth;
        $month = $minmonth;
        $monthlist = array();
        while (datecompare($month, $current_month) <= 0) {
            $monthlist[] = $month;
            $month = getnextmonth($month);
        }
        $statvars['monthlist'] = $monthlist;
        $monthposts = array();
        foreach (C::t('forum_statlog')->fetch_all_by_fid_type($fid) as $data) {
            list($year, $month, $day) = explode('-', $data['logdate']);
            if (isset($monthposts[$year . '-' . $month])) {
                $monthposts[$year . '-' . $month] += $data['value'];
            } else {
                $monthposts[$year . '-' . $month] = $data['value'];
            }
        }
        $statvars['monthposts'] = $monthposts;
    }
    $statvars['statuspara'] = "path=&settings_file=data/stat_setting.xml&data_file=" . urlencode("misc.php?mod=stat&op=forumstat&fid={$fid}&month={$_GET['month']}&xml=1");
    return $statvars;
}
Exemplo n.º 2
0
function getstatvars_forumstat($fid)
{
    global $_G;
    $xml = "<chart>\n";
    $statvars = array();
    $monthdays = array('31', '28', '31', '30', '31', '30', '31', '31', '30', '31', '30', '31');
    if (!$fid) {
        $query = DB::query("SELECT fid, name, posts FROM " . DB::table('forum_forum') . " WHERE status<>'3' AND type<>'group'");
        $forums = array();
        while ($forum = DB::fetch($query)) {
            $forums[] = $forum;
        }
        $statvars['forums'] = $forums;
    } else {
        $foruminfo = DB::fetch_first("SELECT fid, name, posts, threads, todayposts FROM " . DB::table('forum_forum') . " WHERE fid='{$fid}'");
        $statvars['foruminfo'] = $foruminfo;
        $current_date = $end_date = date('Y-m-d');
        $current_month = $end_month = date('Y-m');
        $current_month_start = $end_month_start = $current_month . '-01';
        if ($_G['gp_month']) {
            $end_month = trim($_G['gp_month']);
            $month = substr($end_month, strpos($end_month, '-') + 1);
            $end_date = $end_month . '-' . $monthdays[$month - 1];
            $end_month_start = $end_month . '-' . '01';
        }
        $statvars['month'] = $end_month;
        $query = DB::query("SELECT logdate, fid, value\r\n\t\t\tFROM " . DB::table('forum_statlog') . "\r\n\t\t\tWHERE logdate>='{$end_month_start}' AND logdate<='{$end_date}' AND type='1' AND fid='{$fid}'\r\n\t\t\tORDER BY logdate ASC");
        $logs = array();
        $xml .= "<xaxis>\n";
        $xmlvalue = '';
        $xaxisindex = 0;
        while ($log = DB::fetch($query)) {
            $logs[] = $log;
            list($yyyy, $mm, $dd) = explode('-', $log['logdate']);
            $xaxisindex++;
            $xml .= "<value xid=\"{$xaxisindex}\">{$mm}{$dd}</value>\n";
            $xmlvalue .= "<value xid=\"{$xaxisindex}\">{$log['value']}</value>\n";
        }
        $xml .= "</xaxis>\n";
        $xml .= "<graphs>\n";
        $xml .= "<graph gid=\"0\" title=\"" . diconv(lang('spacecp', 'do_stat_post_number'), CHARSET, 'UTF-8') . "\">\n";
        $xml .= $xmlvalue;
        $xml .= "</graph>\n";
        $xml .= "</graphs>\n";
        $xml .= "</chart>\n";
        if ($_G['gp_xml']) {
            @header("Expires: -1");
            @header("Cache-Control: no-store, private, post-check=0, pre-check=0, max-age=0", FALSE);
            @header("Pragma: no-cache");
            @header("Content-type: application/xml; charset=utf-8");
            echo $xml;
            exit;
        }
        $statvars['logs'] = $logs;
        $mindate = DB::result_first("SELECT MIN(logdate) FROM " . DB::table('forum_statlog') . " WHERE fid='{$fid}'");
        list($minyear, $minmonth, $minday) = explode('-', $mindate);
        $minmonth = $minyear . '-' . $minmonth;
        $month = $minmonth;
        $monthlist = array();
        while (datecompare($month, $current_month) <= 0) {
            $monthlist[] = $month;
            $month = getnextmonth($month);
        }
        $statvars['monthlist'] = $monthlist;
        $query = DB::query("SELECT logdate, `value` FROM " . DB::table('forum_statlog') . " WHERE fid='{$fid}' AND type='1'");
        $monthposts = array();
        while ($data = DB::fetch($query)) {
            list($year, $month, $day) = explode('-', $data['logdate']);
            if (isset($monthposts[$year . '-' . $month])) {
                $monthposts[$year . '-' . $month] += $data['value'];
            } else {
                $monthposts[$year . '-' . $month] = $data['value'];
            }
        }
        $statvars['monthposts'] = $monthposts;
    }
    $statvars['statuspara'] = "path=&settings_file=data/stat_setting.xml&data_file=" . urlencode("misc.php?mod=stat&op=forumstat&fid={$fid}&month={$_G['gp_month']}&xml=1");
    return $statvars;
}