<?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;

    // Lag en liste over de mest besøkte bloggene
        $blogs_sql = $dbname->get_results("SELECT `url_site_id` AS blogg_id, COUNT( * ) AS treff
                    FROM `wp_firestats_hits`
                    WHERE `timestamp` >= DATE_SUB(NOW(),INTERVAL 7 DAY)
                    GROUP BY `url_site_id`
                    ORDER BY `treff` DESC
                    LIMIT 10
                    ");
    $blogs = $wpdb->get_results($blogs_sql);
    if ($blogs) {
        echo '<div class="toppliste">';
        foreach ($blogs as $blog) {
            // hent _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_sql);
            print_r($options);
                echo '<li class="blogger"><a href="'.$options[0]->option_value.'">'.$options[1]->option_value.'-' .$blog[1].'treff</a></li>';
        }
    echo '</div>';
    }
}
?>
<?php toplist(); ?>
        </div><!-- #content -->
    </div><!-- #container -->
<?php get_sidebar(); ?>
<?php get_footer(); ?>