<?php
/*
Template Name: Toppliste
*/
?>
<?php get_header() ?>
    <div id="container">
        <div id="content">


<?php
$dbhost = 'localhost:3306';
$dbuser = 'dittnett_stats';
$dbpass = '14homlepong';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Houston we have a problem!' . mysql_error());
$dbname = 'dittnett_firestat';
mysql_select_db($dbname);


function toplist() {
    global $wpdb, $wpmuBaseTablePrefix;
    // hent en liste over alle blogger
    $blogs_sql = "SELECT blog_id FROM" .$wpdb->blogs. "WHERE public = '1' AND archived = '0' AND mature = '0' AND spam = '0' AND deleted = '0'";
    $blogs = $wpdb->get_col($blogs_sql);
    if ($blogs) {
        echo '<div class="toppliste">';
        foreach ($blogs as $blog) {
            // hent _posts og _options tabellene for å få dette til å virke
            $blogOptionsTable = $wpmuBaseTablePrefix.$blog."_options";

            $options_sql = "SELECT option_value FROM ". $blogOptionsTable ." WHERE option_name IN ('siteurl','blogname') ORDER BY option_name DESC";
            $options = $wpdb->get_results($options_url);
               // så henter vi informasjonen fra statistikken
               $stats = $dbname->get_results("
                    SELECT COUNT( * ) AS treff, `url_site_id` AS blogger
                    FROM `wp_firestats_hits`
                    WHERE `timestamp` >= DATE_SUB(NOW(),INTERVAL 7 DAY)
                    GROUP BY `url_site_id`
                    ORDER BY `treff` DESC
                    ");

        // hvis det er funnet noe så legges det inn under
            if($stats) {
                echo '<li class="blogger"><a href="'.$options[0]->option_value.'">'.$options[1]->option_value .$stats[0]->treff.'</a></li>';
            }
    }
    echo '</div>';
}
}
?>
        </div><!-- #content -->
    </div><!-- #container -->
<?php get_sidebar(); ?>
<?php get_footer(); ?>