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 = $wpdb->get_col("SELECT blog_id FROM " . $wpdb->blogs .
- "AND public = '1' ".
- "AND archived = '0' ".
- "AND mature = '0' ".
- "AND spam = '0' ".
- "AND deleted = '0'";
- if ($blogs) {
- foreach ($blogs as $blog) {
- // hent _posts og _options tabellene for å få dette til å virke
- $blogOptionsTable = $wpmuBaseTablePrefix.$blog."_options";
- $options = $wpdb->get_results("SELECT option_value FROM
- $blogOptionsTable WHERE option_name IN ('siteurl','blogname')
- ORDER BY option_name DESC");
- // 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 '<div class="toppliste">';
- 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