Changeset 1301

Timestamp:

08/20/08 11:22:08 (3 months ago)

Author:

_ck_

Message:

statistics update to support bbPress 1.0

Files:

• my-views/trunk/my-views-statistics.php (modified) (5 diffs)

my-views/trunk/my-views-statistics.php

@@ -6 +6 @@
-Author: _ck_
-Author URI: http://bbShowcase.org
-1
+2
-*/ 
-
@@ -43 +43 @@
-$userlimit=10;  // top users 10,15,20 etc.
-
+// SELECT count(*) as posts, count(distinct topic_id) as topics, count(distinct poster_id) as members FROM `bb_posts` WHERE post_status=0
+// SELECT count(*) as posts, count(distinct t1.topic_id) as topics, count(distinct poster_id) as members FROM `bb_posts` as t1  LEFT JOIN `bb_topics` as t2 ON t1.topic_id=t2.topic_id WHERE post_status=0 AND topic_status=0
+
+$results=$bbdb->get_results("SELECT COUNT(*) as forums, SUM(posts)  as posts, SUM(topics) as topics FROM $bbdb->forums");
+$my_views_statistics["total_forums"]=$results[0]->forums;
+$my_views_statistics["total_posts"]=$results[0]->posts;
+$my_views_statistics["total_topics"]=$results[0]->topics;
+
-$my_views_statistics["total_members"]=$bbdb->get_var("SELECT COUNT(*) FROM $bbdb->users");
-
-
+
+
+
+
+
+
-$my_views_statistics["total_topic_views"]= $bbdb->get_var("SELECT SUM(meta_value) FROM $bbdb->topicmeta LEFT JOIN $bbdb->topics ON $bbdb->topicmeta.topic_id = $bbdb->topics.topic_id  WHERE $bbdb->topics.topic_status=0 AND $bbdb->topicmeta.meta_key='views' ");
-$my_views_statistics["total_tags"]=$bbdb->get_var("SELECT COUNT(*) FROM $bbdb->tags");
-
-
+
-
-$my_views_statistics["average_registrations"]=$my_views_statistics["total_members"]/$my_views_statistics["total_days_old"];
@@ -56 +67 @@
-$my_views_statistics["average_topic_views"]=$my_views_statistics["total_topic_views"]/$my_views_statistics["total_days_old"];
-
-$my_views_statistics["total_days_old"]=$my_views_statistics["total_days_old"];
-
-$my_views_statistics["oldest_members"] = $bbdb->get_results("SELECT ID,user_registered FROM $bbdb->users ORDER BY user_registered ASC LIMIT $userlimit");
-$my_views_statistics["newest_members"] = $bbdb->get_results("SELECT ID,user_registered FROM $bbdb->users ORDER BY user_registered DESC LIMIT $userlimit");
-
-
-
+DISTINCT 
+DISTINCT 
-
-$topics=$bbdb->get_results("SELECT * FROM $bbdb->topics WHERE topic_status=0 ORDER BY topic_posts DESC LIMIT $topiclimit");     // topic_id,topic_title,topic_posts
-$my_views_statistics["top_topics_by_posts"] = bb_append_meta( $topics, 'topic' );
-        
+if ($my_views_statistics["total_topic_views"]) {
+        if (bb_get_option('bb_db_version')>1600) { // bbPress 1.0 vs 0.9
+        $most_views = $bbdb->get_results("SELECT object_id as topic_id FROM $bbdb->meta WHERE meta_key='views' AND object_type='bb_topic' ORDER BY cast(meta_value as UNSIGNED) DESC LIMIT $topiclimit");
+        } else {
-        $most_views = $bbdb->get_results("SELECT topic_id FROM $bbdb->topicmeta WHERE meta_key='views' ORDER BY cast(meta_value as UNSIGNED) DESC LIMIT $topiclimit");
+        }
-        foreach (array_keys($most_views) as $i) {$trans[$most_views[$i]->topic_id] =& $most_views[$i];} $ids = join(',', array_keys($trans));
-        $where = apply_filters('get_latest_topics_where',"WHERE topic_status=0 AND topic_id IN ($ids) ");
@@ -73 +87 @@
-        $topics = $bbdb->get_results($topics);
-$my_views_statistics["top_topics_by_views"] = bb_append_meta( $topics, 'topic' );
-
+
-
-?>
@@ -232 +246 @@
-}
-
-function stats_most_views( $view ) {
-global $bbdb, $topics, $view_count;
-if ($view=='most-views')  {$sort="DESC";}
-if ($view=='least-views')  {$sort="ASC";}
-if ($view=='least-views' || $view=='most-views')  {
-$limit = bb_get_option('page_topics');
-$most_views = $bbdb->get_results("SELECT topic_id FROM $bbdb->topicmeta WHERE meta_key='views' ORDER BY cast(meta_value as UNSIGNED) $sort LIMIT $limit");
-foreach (array_keys($most_views) as $i) {$trans[$most_views[$i]->topic_id] =& $most_views[$i];} $ids = join(',', array_keys($trans));
-$where = apply_filters('get_latest_topics_where',"WHERE topic_status=0 AND topic_id IN ($ids) ");
-$topics ="SELECT * FROM $bbdb->topics $where ORDER BY FIELD(topic_id, $ids)";
-$topics = $bbdb->get_results($topics);
-$view_count  = count($topics);
-$topics = bb_append_meta( $topics, 'topic' );   
-}
-// else {do_action( 'bb_custom_view', $view );}
-}
-
-function stats_forums_views_append($forums) {
-if (is_front() || is_forum()) {
-global $bbdb, $forums_views; $sum_meta_value="SUM(meta_value)";
-if (!isset($forums_views)) {
-$forums_views = $bbdb->get_results(" SELECT $sum_meta_value,forum_id FROM $bbdb->topicmeta LEFT JOIN $bbdb->topics ON $bbdb->topicmeta.topic_id = $bbdb->topics.topic_id  WHERE $bbdb->topics.topic_status=0 AND $bbdb->topicmeta.meta_key='views'  GROUP BY $bbdb->topics.forum_id");
-} foreach ($forums_views as $forum_views) {
-// echo " <!-- ".$forum_views->forum_id." - ".$sum_meta_value." -->";  
-if ($forum_views->forum_id) {$forums[$forum_views->forum_id]->views=$forum_views->$sum_meta_value;} 
-}
-}
-return $forums;
-}
-
-// endif;
-?>