Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- /*
- Template Name: Toppliste
- */
- ?>
- <?php get_header() ?>
- <?php
- $dbhost = 'bloggbyen.com:3306';
- $dbuser = 'dittnett_stats';
- $dbpass = '14homlepong';
- $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Houston we have a problem!');
- $dbname = 'dittnett_firestat';
- mysql_select_db($dbname);
- function toplist() {
- global $wpdb, $wpmuBaseTablePrefix;
- // hent en liste over alle blogger
- $blogs_sql = "SELECT blog_id FROM" .$wpdb->blogs. "WHERE public = '1' AND archived = '0' AND mature = '0' AND spam = '0' AND deleted = '0'";
- $blogs = $wpdb->get_col($blogs_sql);
- if ($blogs) {
- echo '<div class="toppliste">';
- foreach ($blogs as $blog) {
- // hent _posts og _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_url);
- // så henter vi informasjonen fra statistikken
- $stats = $dbname->get_results("
- SELECT COUNT( * ) AS treff, `url_site_id` AS blogger
- FROM `wp_firestats_hits`
- WHERE `timestamp` >= DATE_SUB(NOW(),INTERVAL 7 DAY)
- GROUP BY `url_site_id`
- ORDER BY `treff` DESC
- ");
- // hvis det er funnet noe så legges det inn under
- if($stats) {
- echo '<li class="blogger"><a href="'.$options[0]->option_value.'">'.$options[1]->option_value .$stats[0]->treff.'</a></li>';
- }
- }
- echo '</div>';
- }
- ?>
- <?php get_sidebar(); ?>
- <?php get_footer(); ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement