<?php
/* Short and sweet */
require('/home/dittnett/public_html/wp-blog-header.php');

/*
Usage:
<?php if (function_exists('toplist')) { toplist(); } ?>
Endre linje 64 til :
echo '<li class="blogger"><a href="'.$options[0]->option_value.'">'.$options[1]->option_value.' - ' .$blog[0].' treff</a></li>';
echo '<li class="blogger"><a href="'.$options[0]->option_value.'">'.$options[1]->option_value.'</a>  ' .$blog[0].' treff</li>';

for å vise antall treff
for å skjule treff bruk denne:
echo '<li class="blogger"><a href="'.$options[0]->option_value.'">'.$options[1]->option_value.'</a></li>';

*/

$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);

$file= 'toplist-content.php';

function toplist_write(); {
		global $file;
        file_put_contents($file, toplist_generate());
}


function toplist(); {
		global $file;
        return file_get_contents($file);
}


function toplist_generate(); {
        ob_start();
	global $wpdb, $wpmuBaseTablePrefix;
	// hent en liste over alle blogger som potensielt kan vises
	$blogs_krav_sql = "SELECT DISTINCT(blog_id) FROM " .$wpdb->blogs. " WHERE public = '1' AND archived = '0' AND mature = '0' AND spam = '0' AND deleted = '0' ORDER BY blog_id";


        $blogs_krav_array = $wpdb->get_col($blogs_krav_sql);
        $blogs_krav = "(";
            foreach ($blogs_krav_array as $blog_id){
                $blogs_krav .= $blog_id . ", ";
            }
        $blogs_krav .= "0)";
        $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 url_site_id NOT IN (1,2)
					AND url_site_id in ". $blogs_krav ."
					GROUP BY blog_id
					ORDER BY treff DESC
					LIMIT 30";

	$blogs = mysql_query($stats_sql);

	if (mysql_num_rows($blogs) > 0) {
		echo '<ol>';
		while($blog = mysql_fetch_array($blogs)) {
			// hent _options tabellene for å få dette til å virke
			$blogOptionsTable = $wpmuBaseTablePrefix.$blog['blog_id']."_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);
			echo '<li><a href="'.$options[0]->option_value.'">'.$options[1]->option_value.'</a></li>';
		}
		echo '</ol>';
	}
        return ob_get_flush();
}

?>