wp-stats / wp-stats.php

wp-stats.php in WP-Stats 2.03, at wp-stats.php

284 lines 10.0 KB

Raw Download Zip

1	<?php
2	/*
3	+----------------------------------------------------------------+
4	\| \|
5	\| WordPress 2.0 Plugin: WP-Stats 2.03 \|
6	\| Copyright (c) 2005 Lester "GaMerZ" Chan \|
7	\| \|
8	\| File Written By: \|
9	\| - Lester "GaMerZ" Chan \|
10	\| - http://www.lesterchan.net \|
11	\| \|
12	\| File Information: \|
13	\| - WordPress Statistics \|
14	\| - wp-stats.php \|
15	\| \|
16	+----------------------------------------------------------------+
17	*/
18
19
20	### Require WordPress Header
21	require(dirname(__FILE__).'/wp-blog-header.php');
22
23	### Variables Variables Variables
24	$comment_author = urldecode(strip_tags(stripslashes(trim($_GET['author']))));
25	$page = intval($_GET['page']);
26	?>
27	<?php get_header(); ?>
28	<div id="content" class="narrowcolumn">
29	<?php
30	### Default wp-stats.php Page
31	if(empty($comment_author)) {
32	?>
33	<!-- General Stats -->
34	<h2 class="pagetitle">General Stats</h2>
35	<ul>
36	<li><b><?php get_totalauthors(); ?></b> Authors To This Blog.</li>
37	<li><b><?php get_totalposts(); ?></b> Posts Were Posted.</li>
38	<li><b><?php get_totalpages(); ?></b> Pages Were Created.</li>
39	<li><b><?php get_totalcomments(); ?></b> Comments Were Posted.</li>
40	<li><b><?php get_totalcommentposters(); ?></b> Different Nicks Were Represented In The Comments.</li>
41	<li><b><?php get_totallinks(); ?></b> Links Were Added.</li>
42	</ul>
43
44	<!-- Plugin Stats -->
45	<h2 class="pagetitle">Plugins Stats</h2>
46	<ul>
47	<!-- WP-EMail Stats -->
48	<?php if(function_exists('wp_email')): ?>
49	<li><b>WP-EMail</b></li>
50	<ul>
51	<li><b><?php get_emails(); ?></b> Emails Were Sent.</li>
52	<li><b><?php get_emails_success(); ?></b> Emails Were Sent Successfully.</li>
53	<li><b><?php get_emails_failed(); ?></b> Emails Failed To Send.</li>
54	</ul>
55	<br />
56	<?php endif; ?>
57	<!-- WP-Polls Stats -->
58	<?php if(function_exists('get_poll')): ?>
59	<li><b>WP-Polls</b></li>
60	<ul>
61	<li><b><?php get_pollquestions(); ?></b> Polls Were Created.</li>
62	<li><b><?php get_pollanswers(); ?></b> Polls' Answers Were Given.</li>
63	<li><b><?php get_pollvotes(); ?></b> Votes Were Casted.</li>
64	</ul>
65	<br />
66	<?php endif; ?>
67	<!-- WP-PostRatings Stats -->
68	<?php if(function_exists('the_ratings')): ?>
69	<li><b>WP-PostRatings</b></li>
70	<ul>
71	<li><b><?php get_ratings_votes(); ?></b> Votes Were Casted.</li>
72	<li><b><?php get_ratings_users(); ?></b> Users Casted Their Vote.</li>
73	</ul>
74	<br />
75	<?php endif; ?>
76	<!-- WP-PostViews Stats -->
77	<?php if(function_exists('the_views')): ?>
78	<li><b>WP-PostViews</b></li>
79	<ul>
80	<li><b><?php get_totalviews(); ?></b> Views Were Generated.</li>
81	</ul>
82	<br />
83	<?php endif; ?>
84	<!-- WP-UserOnline Stats -->
85	<?php if(function_exists('useronline')): ?>
86	<li><b>WP-UserOnline</b></li>
87	<ul>
88	<li><?php get_useronline(); ?> Now.</li>
89	<li>Most users ever online was <b><?php get_most_useronline(); ?></b>.</li>
90	<li>On <b><?php get_most_useronline_date(); ?></b>.</li>
91	</ul>
92	<br />
93	<?php endif; ?>
94	</ul>
95
96	<!-- Top 10 Stats-->
97	<h2 class="pagetitle">Top 10 Stats</h2>
98	<ul>
99	<!-- 10 Recent Posts -->
100	<li><b>10 Recent Posts</b></li>
101	<ul>
102	<?php get_recentposts(); ?>
103	</ul>
104	<br />
105	<!-- 10 Recent Comments -->
106	<li><b>10 Recent Comments</b></li>
107	<ul>
108	<?php get_recentcomments(); ?>
109	</ul>
110	<br />
111	<!-- 10 Most Commented Post -->
112	<li><b>10 Most Commented Post</b></li>
113	<ul>
114	<?php get_mostcommented(); ?>
115	</ul>
116	<br />
117	<!-- WP-EMail (10 Most EMailed Post) -->
118	<?php if(function_exists('wp_email')): ?>
119	<li><b>10 Most Emailed Post</b></li>
120	<ul>
121	<?php get_mostemailed(); ?>
122	</ul>
123	<br />
124	<?php endif; ?>
125	<!-- WP-PostRatings (10 Most Rated Post) -->
126	<?php if(function_exists('the_ratings')): ?>
127	<li><b>10 Most Rated Post</b></li>
128	<ul>
129	<?php get_highest_rated(); ?>
130	</ul>
131	<br />
132	<?php endif; ?>
133	<!-- WP-PostViews (10 Most Viewed Post) -->
134	<?php if(function_exists('the_views')): ?>
135	<li><b>10 Most Viewed Post</b></li>
136	<ul><?php get_most_viewed(); ?></ul>
137	<br />
138	<?php endif; ?>
139	</ul>
140
141	<!-- Author Stats -->
142	<h2 class="pagetitle">Authors Stats</h2>
143	<ol>
144	<?php get_authorsstats(); ?>
145	</ol>
146
147	<!-- Comments' Members Stats -->
148	<h2 class="pagetitle">Comments' Members Stats</h2>
149	<ol>
150	<?php get_commentmembersstats(); ?>
151	</ol>
152
153	<!-- Misc Stats -->
154	<h2 class="pagetitle">Misc Stats</h2>
155	<ul>
156	<!-- Post Categories -->
157	<li><b>Post Categories</b></li>
158	<ul>
159	<?php list_cats(1,'All','name','asc','',true,0,1,0,1,true,0,0,0,'','','',true); ?>
160	</ul>
161	<br />
162	<!-- Link Categories -->
163	<li><b>Link Categories</b></li>
164	<ul>
165	<?php get_linkcats(); ?>
166	</ul>
167	</ul>
168	<?php
169	### Displaying Comments Posted By User
170	} else {
171	// Number Of Comments Per Page
172	$perpage = 10;
173	// Comment Author Link
174	$comment_author_link = urlencode($comment_author);
175	// Comment Author SQL
176	$comment_author_sql = $wpdb->escape($comment_author);
177	// Total Comments Posted By User
178	$totalcomments = $wpdb->get_var("SELECT COUNT(comment_ID) FROM $wpdb->comments WHERE comment_author='$comment_author_sql'");
179	// Checking $page and $offset
180	if (empty($page) \|\| $page == 0) { $page = 1; }
181	if (empty($offset)) { $offset = 0; }
182	// Determin $offset
183	$offset = ($page-1) * $perpage;
184	// Some Comments Stats
185	if(($offset + $perpage) > $totalcomments) { $maxonpage = $totalcomments ; } else { $maxonpage = ($offset+$perpage); }
186	if (($offset + 1) > ($totalcomments)) { $displayonpage = $totalcomments ; } else { $displayonpage = ($offset+1); }
187	// Count Total Pages
188	$totalpages = ceil($totalcomments/$perpage);
189	// Getting The Comments
190	$gmz_comments = $wpdb->get_results("SELECT $wpdb->posts.ID, comment_author, comment_date, comment_content, ID, comment_ID, post_date, post_title, post_name, post_password FROM $wpdb->comments INNER JOIN $wpdb->posts ON $wpdb->comments.comment_post_ID = $wpdb->posts.ID WHERE comment_author = '$comment_author_sql' AND comment_approved = '1' AND post_date < '".current_time('mysql')."' AND (post_status = 'publish' OR post_status = 'static') ORDER BY comment_post_ID DESC, comment_date DESC LIMIT $offset, $perpage");
191	?>
192	<h2 class="pagetitle">Comments Posted By <?php echo $comment_author; ?></h2>
193	<p>Displaying <b><?php echo $displayonpage; ?></b> To <b><?php echo $maxonpage; ?></b> Of <b><?php echo $totalcomments; ?></b> Comments</p>
194	<?php
195	// Get Comments
196	if($gmz_comments) {
197	foreach($gmz_comments as $post) {
198	$comment_id = intval($post-> comment_ID);
199	$comment_author2 = htmlspecialchars(stripslashes($post->comment_author));
200	$comment_date = mysql2date('d.m.Y @ H:i', $post->comment_date);
201	$comment_content = wpautop(stripslashes($post->comment_content));
202	$post_date = mysql2date('d.m.Y @ H:i', $post->post_date);
203	$post_title = htmlspecialchars(stripslashes($post->post_title));
204
205	// Check For Password Protected Post
206	if(!empty($post->post_password) && stripslashes($_COOKIE['wp-postpass_'.COOKIEHASH]) != $post->post_password) {
207	// If New Title, Print It Out
208	if($post_title != $cache_post_title) {
209	echo "<p><b><a href=\"".get_permalink()."\" title=\"Posted On $post_date\">Protected: $post_title</a></b></p>\n";
210	echo "<blockquote>Comments Protected</blockquote>\n";
211	}
212	} else {
213	// If New Title, Print It Out
214	if($post_title != $cache_post_title) {
215	echo "<p><b><a href=\"".get_permalink()."\" title=\"Posted On $post_date\">$post_title</a></b></p>\n";
216	}
217	echo "<blockquote>$comment_content <a href=\"".get_permalink()."#comment-$comment_id\">Comment</a> Posted By <b>$comment_author2</b> On $comment_date</blockquote>\n";
218	}
219	$cache_post_title = $post_title;
220	}
221	} else {
222	echo "<p>$comment_author has not made any comments yet.</p>\n";
223	}
224
225	// If Total Pages Is More Than 1, Display Page Navigation
226	if($totalpages > 1) {
227	?>
228	<p>
229	<span style="float: left">
230	<?php
231	if($page > 1 && ((($page*$perpage)-($perpage-1)) < $totalcomments)) {
232	echo '<p><b>«</b> <a href="wp-stats.php?author='.$comment_author_link.'&page='.($page-1).'">Previous Page</a></p>';
233	} else {
234	echo '<p> </p>';
235	}
236	?>
237	</span>
238	<span style="float: right">
239	<?php
240	if($page >= 1 && ((($page*$perpage)+1) < $totalcomments)) {
241	echo '<p><a href="wp-stats.php?author='.$comment_author_link.'&page='.($page+1).'">Next page</a> <b>»</b></p>';
242	} else {
243	echo '<p> </p>';
244	}
245	?>
246	</span>
247	</p>
248	<br style="clear: both">
249	<p align="center">
250	Pages (<?php echo $totalpages; ?>):
251	<?php
252	if ($page >= 4) {
253	echo "<a href=\"wp-stats.php?author=$comment_author_link\">« First</a> ... ";
254	}
255	if($page > 1) {
256	echo " <a href=\"wp-stats.php?author=$comment_author_link&page=".($page-1)."\">«</a> ";
257	}
258	for($i = $page - 2 ; $i <= $page +2; $i++) {
259	if ($i >= 1 && $i <= $totalpages) {
260	if($i == $page) {
261	echo " [$i] ";
262	} else {
263	echo "<a href=\"wp-stats.php?author=$comment_author_link&page=$i\">$i</a> ";
264	}
265	}
266	}
267	if($page < $totalpages) {
268	echo " <a href=\"wp-stats.php?author=$comment_author_link&page=".($page+1)."\">»</a> ";
269	}
270	if (($page+2) < $totalpages) {
271	echo " ... <a href=\"wp-stats.php?author=$comment_author_link&page=$totalpages\">Last »</a>";
272	}
273	?>
274	</p>
275	<?php
276	}
277	?>
278	<p><b>««</b> <a href="<?php get_settings('home'); ?>/wp-stats.php">Back To Stats Page</a></p>
279	<?php
280	} // End If
281	?>
282	</div>
283	<?php get_sidebar(); ?>
284	<?php get_footer(); ?>