Advertisement
Guest User

Untitled

a guest
May 14th, 2017
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.56 KB | None | 0 0
  1. <?php
  2. /*
  3. Template Name: Toppliste
  4. */
  5. ?>
  6. <?php get_header() ?>
  7.  
  8.  
  9. <?php
  10. $dbhost = 'bloggbyen.com:3306';
  11. $dbuser = 'dittnett_stats';
  12. $dbpass = '14homlepong';
  13. $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Houston we have a problem!');
  14. $dbname = 'dittnett_firestat';
  15. mysql_select_db($dbname);
  16.  
  17.  
  18. function toplist() {
  19.     global $wpdb, $wpmuBaseTablePrefix;
  20.     // hent en liste over alle blogger
  21.     $blogs = $wpdb->get_col("SELECT blog_id FROM " . $wpdb->blogs .
  22.         "AND public = '1' ".
  23.         "AND archived = '0' ".
  24.         "AND mature = '0' ".
  25.         "AND spam = '0' ".
  26.         "AND deleted = '0'";       
  27.     if ($blogs) {
  28.         foreach ($blogs as $blog) {
  29.             // hent _posts og _options tabellene for å få dette til å virke
  30.             $blogOptionsTable = $wpmuBaseTablePrefix.$blog."_options";
  31.            
  32.             $options = $wpdb->get_results("SELECT option_value FROM
  33.                 $blogOptionsTable WHERE option_name IN ('siteurl','blogname')
  34.                 ORDER BY option_name DESC");
  35.                // så henter vi informasjonen fra statistikken
  36.                $stats = $dbname->get_results("
  37.                     SELECT COUNT( * ) AS treff, `url_site_id` AS blogger
  38.                     FROM `wp_firestats_hits`
  39.                     WHERE `timestamp` >= DATE_SUB(NOW(),INTERVAL 7 DAY)
  40.                     GROUP BY `url_site_id`
  41.                     ORDER BY `treff` DESC
  42.                     ");
  43.    
  44.         // hvis det er funnet noe så legges det inn under
  45.             if $stats{
  46.                 echo '<div class="toppliste">';
  47.                 echo '<li class="blogger"><a href="'.$options[0]->option_value.'">'.$options[1]->option_value. .$stats[0]->treff.'</a></li>';
  48.                 echo '</div>';
  49.             }
  50.     }
  51. }
  52.  
  53. ?>
  54.  
  55. <?php get_sidebar() ?>
  56. <?php get_footer() ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement