Beiträge von malo.conny

<?php
#Script: XML-Reader
#Copyright: y0y.de, erweitert: bueltge.de
#Variablendefinition
$url = "../rss.xml"; //URL zum XML-Feed
$number = 20; //Anzahl der angezeigten News


# code
$file_content = @file_get_contents($url);


#Items auslesen
$items = preg_match_all("/<item[ ]?.*>(.*)<\/item>/Uis", $file_content, $array_items);
$array_items = $array_items[1];
if(!empty($array_items)) { //Nur wenn es Items gibt, soll auch was angezeigt werden
if ($number>sizeof($array_items)) $number=sizeof($array_items);
    for($n=0;$n<$number;$n++) { //Nur die angegebene Anzahl der News soll angezeigt werden
    preg_match("/<link>(.*)<\/link>/Uis", $array_items[$n], $array_link); //URLs auslesen
    preg_match("/<title>(.*)<\/title>/Uis", $array_items[$n], $array_title); //Titel auslesen
    preg_match("/<description>(.*)<\/description>/Uis", $array_items[$n], $array_description); //Beschreibung auslesen
?>


<span class="ueberschrift1">
<?
    echo "




$array_title[1]


"; //Titel darstellen
?>
</span>


<?
    echo "$array_description[1]"; //Ausgabe der Beschreibung
    echo ""; //Leerzeichen vor dem Link
	echo "<a href=\"$array_link[1]\" title=\"Click f&uuml;r mehr Informationen\">... mehr</a>"; //Link
	}
}
?>

.narrowcolumn {
	float: left;
	padding: 0 0 20px 45px;
	margin: 0px 0 0;
	width: 470px;
	}


.widecolumn {
	padding: 10px 0 20px 0;
	margin: 5px 0 0 150px;
	width: 450px;
	}

<?php /*
Template Name: Statistik
*/






/*
 * Statistics Plugin For WordPress
 *	- wp-stats.php
 *
 * Copyright © 2004-2005 Lester "GaMerZ" Chan
*/




// Require WordPress Header
require('wp-blog-header.php');


// Variables
$comment_author = htmlspecialchars(stripslashes(trim($_GET['author'])));
$page = intval($_GET['page']);


// Get Total Posts
function get_totalposts() {
	global $wpdb;
	$totalposts = $wpdb->get_var("SELECT COUNT(ID) FROM $wpdb->posts WHERE post_status = 'publish'");
	return $totalposts;
}


// Get Total Comments
function get_totalcomments() {
	global $wpdb;
	$totalcomments = $wpdb->get_var("SELECT COUNT(comment_ID) FROM $wpdb->comments WHERE comment_approved = '1'");
	return $totalcomments;
}


// Get Total Comments Poster
function get_totalcommentposters() {
	global $wpdb;
	$totalcommentposters = $wpdb->get_var("SELECT COUNT(DISTINCT comment_author) FROM $wpdb->comments WHERE comment_approved = '1'");
	
	return $totalcommentposters;
}


// Get Total Links
function get_totallinks() {
	global $wpdb;
	$totallinks = $wpdb->get_var("SELECT COUNT(link_id) FROM $wpdb->links");
	
	return $totallinks;
}


// Get Recent Posts
function get_recentposts($limit = 10) {
    global $wpdb, $post;
    $recentposts = $wpdb->get_results("SELECT $wpdb->posts.ID, post_title, post_name, post_date, user_nickname FROM $wpdb->posts LEFT JOIN $wpdb->users ON $wpdb->users.ID = $wpdb->posts.post_author WHERE post_date_gmt < '".gmdate("Y-m-d H:i:s")."' AND post_status = 'publish' AND post_password = '' ORDER  BY post_date DESC LIMIT $limit");
    foreach ($recentposts as $post) {
			$post_title = htmlspecialchars(stripslashes($post->post_title));
			$post_date = mysql2date('d.m.Y', $post->post_date);
			$user_nickname = htmlspecialchars(stripslashes($post->user_nickname));
			echo "[*]$post_date - <a href=\"".get_permalink()."\">$post_title</a> ($user_nickname)";
    }
}


// Get Recent Comments
function get_recentcomments($limit = 10) {
    global $wpdb, $post;
    $recentcomments = $wpdb->get_results("SELECT $wpdb->posts.ID, post_title, post_name, comment_author, post_date, comment_date FROM $wpdb->posts INNER JOIN $wpdb->comments ON $wpdb->posts.ID = $wpdb->comments.comment_post_ID WHERE comment_approved = '1' AND post_date_gmt < '".gmdate("Y-m-d H:i:s")."' AND post_status = 'publish' AND post_password = '' ORDER  BY comment_date DESC LIMIT $limit");
    foreach ($recentcomments as $post) {
			$post_title = htmlspecialchars(stripslashes($post->post_title));
			$comment_author = htmlspecialchars(stripslashes($post->comment_author));
			$comment_date = mysql2date('d.m.Y @ H:i', $post->comment_date);
			echo "[*]$comment_date - $comment_author (<a href=\"".get_permalink()."\">$post_title</a>)";
    }
}


// Get Top Commented Posts
function get_mostcommented($limit = 10) {
    global $wpdb, $post;
    $mostcommenteds = $wpdb->get_results("SELECT  $wpdb->posts.ID, post_title, post_name, post_date, COUNT($wpdb->comments.comment_post_ID) AS 'comment_total' FROM $wpdb->posts LEFT JOIN $wpdb->comments ON $wpdb->posts.ID = $wpdb->comments.comment_post_ID WHERE comment_approved = '1' AND post_date_gmt < '".gmdate("Y-m-d H:i:s")."' AND post_status = 'publish' AND post_password = '' GROUP BY $wpdb->comments.comment_post_ID ORDER  BY comment_total DESC LIMIT $limit");
    foreach ($mostcommenteds as $post) {
			$post_title = htmlspecialchars(stripslashes($post->post_title));
			$comment_total = (int) $post->comment_total;
			echo "[*]<a href=\"".get_permalink()."\">$post_title</a> - $comment_total comments";
    }
}


// Get Comments' Members Stats
// Treshhold = Number Of Posts User Must Have Before It Will Display His Name Out
// 5 = Default Treshhold; -1 = Disable Treshhold
function get_commentmembersstats($threshhold = 5) {
	global $wpdb;
	$comments = $wpdb->get_results("SELECT comment_author, COUNT(comment_ID) AS 'comment_total' FROM $wpdb->comments WHERE comment_approved = '1' GROUP BY comment_author ORDER BY comment_total DESC");
    foreach ($comments as $comment) {
			$comment_author = htmlspecialchars(stripslashes($comment->comment_author));
			$comment_total = (int) $comment->comment_total;
			echo "[*]<a href=\"wp-stats.php?author=$comment_author\">$comment_author</a> ($comment_total)";
			// If Total Comments Is Below Threshold
			if($comment_total <= $threshhold && $threshhold != -1) {
				return;
			}
    }
}


// Get Links Categories Stats
function get_linkcats() {
	global $wpdb;
	$linkcats =  $wpdb->get_results("SELECT $wpdb->linkcategories.cat_name, COUNT(*)  AS  'total_links' FROM $wpdb->links INNER JOIN $wpdb->linkcategories ON $wpdb->linkcategories.cat_id = $wpdb->links.link_category GROUP BY $wpdb->linkcategories.cat_id ORDER  BY total_links DESC ");
    foreach ($linkcats as $linkcat) {
			$cat_name = htmlspecialchars(stripslashes($linkcat->cat_name));
			$total_links = intval($linkcat->total_links);
			echo "[*]$cat_name ($total_links)\n";
    }
}
?>
<?php get_header(); ?>
	<div id="content" class="narrowcolumn">
<?php
	// If Author Is Not Specified
	if(empty($comment_author)) {
?>


		<h2>Pulse</h2><?php bstat_pulse($id, 450, 1, 0, 1); ?>


			<?php
			
			$before = "<ul>[*][b]";
			$after = "[/b][/list]";
			$date  = date("Y-m-d");
			
			$request = "SELECT SUM(hits_reads) AS note 
				FROM $bstat_hits_table
				WHERE bstat_date = '$date'
				";
			echo("<h2>Counter heute</h2>" . bstat_reporter($request, $before, $after, 1) . "");
			
			echo("");
			
			$request = "SELECT SUM(hits_reads) AS note FROM $bstat_hits_table
				";
			echo("<h2>Counter (seit dem 3.Aug 2005)</h2>" . bstat_reporter($request, $before, $after, 1) . "");
			
			?>


		<h2>Heute: Popul&auml;rsten Beitr&auml;ge</h2>
			<ul><?php bstat_todaypop(15, "[*]", "\n"); ?>[/list]
			
		<h2>Popul&auml;rsten Beitr&auml;ge</h2>
			<ul><?php bstat_recentpop(15, 31, "[*]", "\n"); ?>[/list]


		<h2>Gesucht</h2>
			<ul><?php bstat_recentrefs(15, 31, "[*]", "\n"); ?>[/list]
	
		<h2 class="pagetitle">Allgemeine Statistik</h2>
			<ul>
				[*][b]<?=get_totalposts()?>[/b] Beitraege
				[*][b]<?=get_totalcomments()?>[/b] Kommentare
				[*][b]<?=get_totalcommentposters()?>[/b] unterschiedliche Einschnitte in den Kommentaren
				[*][b]<?=get_totallinks()?>[/b] Links
			[/list]
		<h2 class="pagetitle">10 letzten Beitr&auml;ge</h2>
			<ul><?php get_recentposts(); ?>[/list]
		<h2 class="pagetitle">10 letzten Kommentare</h2>
			<ul><?php get_recentcomments(); ?>[/list]
		<h2 class="pagetitle">10 meisten Beitraege mit Kommentaren</h2>
			<ul><?php get_mostcommented(); ?>[/list]
		<h2 class="pagetitle">Kommentaruser</h2>
			[list=1]<?php get_commentmembersstats(); ?>[/list]
		<h2 class="pagetitle">Kategorien</h2>
			<ul><?php list_cats(1,'All','name','asc','',true,0,1,0,1,true,0,0,0,'','','',true); ?>[/list]
		<h2 class="pagetitle">Linkkategorien</h2>
			<ul><?php get_linkcats(); ?>[/list]
<?php
	// Displaying Comments Posted By User
	} else {
		// Number Of Comments Per Page
		$perpage = 10;
		// Comment Author Link
		$comment_author_link = urlencode($comment_author);
		// Total Comments Posted By User
		$totalcomments = $wpdb->get_var("SELECT COUNT(comment_ID) FROM $wpdb->comments WHERE comment_author='$comment_author'");
		// Checking $page and $offset
		if (empty($page) || $page == 0) { $page = 1; }
		if (empty($offset)) { $offset = 0; }
		// Determin $offset
		$offset = ($page-1) * $perpage;
		// Some Comments Stats
		if(($offset + $perpage) > $totalcomments) { $maxonpage = $totalcomments ; } else { $maxonpage = ($offset+$perpage); }
		if (($offset + 1) > ($totalcomments)) { $displayonpage = $totalcomments ; } else { $displayonpage = ($offset+1); }
		// Count Total Pages
		$totalpages = ceil($totalcomments/$perpage);
		// Getting The Comments
		$gmz_comments =  $wpdb->get_results("SELECT $wpdb->posts.ID, comment_author, comment_date, comment_content, ID, comment_ID, post_date, post_title, post_name FROM $wpdb->comments INNER  JOIN $wpdb->posts ON $wpdb->comments.comment_post_ID = $wpdb->posts.ID WHERE comment_author =  '$comment_author' AND comment_approved = '1' AND post_date_gmt < '".gmdate("Y-m-d H:i:s")."' AND post_status = 'publish' ORDER  BY comment_post_ID DESC, comment_date DESC  LIMIT $offset, $perpage");
?>
		<h2 class="pagetitle">Comments Posted By <?=$comment_author?></h2>
		


Displaying [b]<?=$displayonpage?>[/b] To [b]<?=$maxonpage?>[/b] Of [b]<?=$totalcomments?>[/b] Comments</p>
		<?php
			foreach($gmz_comments as $post) {
				$comment_id = intval($post-> comment_ID);
				$comment_author2 = htmlspecialchars(stripslashes($post->comment_author));
				$comment_date = mysql2date('d.m.Y @ H:i', $post->comment_date);
				$comment_content = wpautop(stripslashes($post->comment_content));
				$post_date = mysql2date('d.m.Y @ H:i', $post->post_date);
				$post_title = htmlspecialchars(stripslashes($post->post_title));


				// If New Title, Print It Out
				if($post_title != $cache_post_title) {
					echo "


[b]<a href=\"".get_permalink()."\" title=\"Posted On $post_date\">$post_title</a>[/b]</p>";
				}
				echo "<blockquote>$comment_content <a href=\"".get_permalink()."#comment-$comment_id\">Comment</a> Posted By [b]$comment_author2[/b] On $comment_date</blockquote>";


				$cache_post_title = $post_title;
			}
		?>
		<table width="100%" cellspacing="0" cellpadding="0" border="0">
			<tr>
				<td align="left" width="50%">
					


					<?php
						if($page > 1 && ((($page*$perpage)-($perpage-1)) < $totalcomments))
							echo '


[b]&laquo;[/b] [url="wp-stats.php?author='.$comment_author_link.'&amp;page='.($page-1).'"]Previous Page[/url]</p>';
						else
							echo '


</p>';
					?>
				</td>
				<td align="right" width="50%">
					


					<?php
						if($page >= 1 && ((($page*$perpage)+1) <  $totalcomments))
							echo '


[url="wp-stats.php?author='.$comment_author_link.'&amp;page='.($page+1).'"]Next page[/url] [b]&raquo;[/b]</p>';
						else
							echo '


</p>';
					?>
				</td>
			</tr>
			<tr>
				<td colspan="2" align="center">
					


					


Pages (<?=$totalpages?>) :
					<?php
						if ($page >= 4) {
							echo "<a href=\"wp-stats.php?author=$comment_author_link\">&laquo; First</a> ... ";
						}
						if($page > 1) {
							echo " <a href=\"wp-stats.php?author=$comment_author_link&amp;page=".($page-1)."\">&laquo;</a> ";
						}
						for($i = $page - 2 ; $i  <= $page +2; $i++) {
							if ($i >= 1 && $i <= $totalpages) {
								if($i == $page) {
									echo "[$i]";
								} else {
									echo "<a href=\"wp-stats.php?author=$comment_author_link&amp;page=$i\">$i</a> ";
								}
							}
						}
						if($page < $totalpages) {
							echo " <a href=\"wp-stats.php?author=$comment_author_link&amp;page=".($page+1)."\">&raquo;</a> ";
						}
						if (($page+2) < $totalpages) {
							echo " ... <a href=\"wp-stats.php?author=$comment_author_link&amp;page=$totalpages\">Last &raquo;</a>";
						}
					?>
					</p>
				</td>
			</tr>
		</table>	
		


[b]&laquo;&laquo;[/b] [url="wp-stats.php"]Back To Stats Page[/url]</p>
<?php
	} // End If
?>
	</div>
<?php
	get_sidebar();
	get_footer();
?>