Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- Usage:
- <?php if (function_exists('toplist')) { toplist(); } ?>
- Endre linje 48 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= '/test.toplist.html';
- function toplist_write() {
- $fh = fopen($file, 'w') or die("can't open file");
- fwrite($fh, toplist_generate());
- fclose($fh);
- }
- function toplist() {
- 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();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement