Exemplo n.º 1
0
            $result = DB_query("SELECT COUNT(*) AS num_pages FROM {$temp_table['name']} WHERE DAYOFMONTH( date ) = {$day}");
            $row = DB_fetchArray($result, FALSE);
            $pages += $row['num_pages'];
            $T->set_var('pages', $row['num_pages']);
            $date_compare = GUS_get_date_comparison('date', $year, $month, $day);
            $result = DB_query("SELECT COUNT(*) AS num_stories FROM {$_TABLES['stories']} WHERE {$date_compare}");
            $row = DB_fetchArray($result, FALSE);
            $stories += $row['num_stories'];
            $T->set_var('stories', $row['num_stories']);
            $result = DB_query("SELECT COUNT(*) AS num_comments FROM {$_TABLES['comments']} WHERE {$date_compare}");
            $row = DB_fetchArray($result, FALSE);
            $comments += $row['num_comments'];
            $T->set_var('comments', $row['num_comments']);
            $result = DB_query("SELECT COUNT(*) AS num_links FROM {$temp_table['name']}\n\t\t\t\t\t\t\t\tWHERE page LIKE '%portal.php' AND query_string <> '' AND DAYOFMONTH( date ) = {$day}");
            $row = DB_fetchArray($result, FALSE);
            $linksf += $row['num_links'];
            $T->set_var('linksf', $row['num_links']);
            $T->Parse('ABlock', 'ROW', TRUE);
        }
    }
    $T->set_var(array('period' => $LANG_GUS00['total'], 'anon' => $anon, 'reg' => $reg, 'pages' => $pages, 'stories' => $stories, 'comments' => $comments, 'linksf' => $linksf, 'google_paging' => $navlinks));
    $title = date('F Y - ', mktime(0, 0, 0, $month, 1, $year)) . $LANG_GUS00['daily_title'];
    $display = GUS_template_finish($T, $title);
    if ($_GUS_cache and date('Yn') !== $year . $month) {
        GUS_writecache($display);
    }
    GUS_remove_temp_table($temp_table);
}
echo COM_siteHeader($_GUS_CONF['show_left_blocks']);
echo $display;
echo COM_siteFooter($_GUS_CONF['show_right_blocks']);
Exemplo n.º 2
0
            } else {
                $result = DB_query("SELECT COUNT(*) AS num_links FROM {$temp_table['name']} WHERE page='phplinks/out_frame.php'");
                $row = DB_fetchArray($result, FALSE);
                $linksf += $row['num_links'];
            }
        } else {
            $result = DB_query("SELECT COUNT(*) AS num_links FROM {$temp_table['name']}\n\t\t\t\t\t\t\t\tWHERE page LIKE '%portal.php' AND query_string <> ''");
            $row = DB_fetchArray($result, FALSE);
            $linksf += $row['num_links'];
        }
        $T->set_var(array('linksf' => $row['num_links'], 'byhour' => 'X'));
        $result = DB_query("SELECT COUNT(*) AS num_referrers FROM {$temp_table['name']}\n\t\t\t\t\t\t\tWHERE referer <> ''");
        $row = DB_fetchArray($result, FALSE);
        $referers += $row['num_referrers'];
        $T->set_var('referer', $row['num_referrers']);
        $rec1 = DB_query("SELECT RIGHT( host, INSTR( REVERSE( host ), '.' ) - 1 ) AS country\n\t\t\t\tFROM {$temp_table['name']} WHERE host <> 'localhost' AND ASCII( REVERSE( host ) ) > 64 GROUP BY country");
        $num_rows = DB_numRows($rec1);
        $countries += $num_rows;
        $T->set_var(array('country' => $num_rows, 'browser' => 'X', 'platform' => 'X'));
        $T->parse('ABlock', 'MONTH', TRUE);
        GUS_remove_temp_table($temp_table);
    }
    $T->set_var(array('display_month' => $LANG_GUS00['total'], 'anon' => $anon, 'reg' => $reg, 'pages' => $pages, 'stories' => $stories, 'comments' => $comments, 'linksf' => $linksf, 'byhour' => 'NA', 'referer' => $referers, 'country' => $countries, 'browser' => 'NA', 'platform' => 'NA', 'google_paging' => $navlinks));
    $display = GUS_template_finish($T, $LANG_GUS00['monthly_title']);
    if ($_GUS_cache and $curpage != $num_pages) {
        GUS_writecache($display);
    }
}
echo COM_siteHeader($_GUS_CONF['show_left_blocks']);
echo $display;
echo COM_siteFooter($_GUS_CONF['show_right_blocks']);