<?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 som potensielt kan vises
    $blogs_krav_sql = "SELECT blog_id FROM " .$wpdb->blogs. " WHERE public = '1' AND archived = '0' AND mature = '0' AND spam = '0' AND deleted = '0'";
        $blogs_krav_array = $wpdb->get_col($blogs_krav_sql);
        $blogs_krav = "(";
            foreach ($blogs_krav_array as $blog){
                $blogs_krav .= $blog[0] . ", ";
            }
        $blogs_krav .= ")";

        $stats_sql = "SELECT COUNT( * ) AS treff, `url_site_id` AS blog_id
                    FROM `wp_firestats_hits`
                    WHERE `timestamp` >= DATE_SUB(NOW(),INTERVAL 7 DAY)
                    AND blog_id in ". $blogs_krav ."
                    GROUP BY blog_id
                    ORDER BY treff DESC
                    LIMIT 10";
        echo $stats_sql;
    $blogs = mysql_query($stats_sql);
    print_r($blogs);
    if (mysql_num_rows($blogs) > 0) {
        echo '<div class="toppliste">';
        while($blog = mysql_fetch_array($blogs)) {
            // hent _options tabellene for å få dette til å virke
            $blogOptionsTable = $wpmuBaseTablePrefix.$blog[0]."_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.'-' .$stats[0].'treff</a></li>';
        }
        echo '</div>';
    }
}
?>
<?php toplist(); ?>
        </div><!-- #content -->
    </div><!-- #container -->
<?php get_sidebar(); ?>
<?php get_footer(); ?>