Changeset 2362 in ExiteCMS for trunk/includes/ajax.response.php

Timestamp:

07/29/10 16:45:09 (22 months ago)

Author:

WanWizard

Message:

implemented new ajax code to fetch the number of unread pm's and forum posts
updated the header templates of all themes to use the new code

File:

• trunk/includes/ajax.response.php (modified) (3 diffs)

trunk/includes/ajax.response.php

@@ -89 +89 @@
         // make sure we have json_encode and json_decode available
         require_once "json_include.php";
+        header("Content-Type:application/json; charset=utf-8");
         if (iMEMBER) {
             // return the user record datastore
@@ -104 +105 @@
             }
         }
+        break;
+    case "counters":
+        if (!iMEMBER) {
+            $pms = $posts = 0;
+            $pmtext = $posttext = "";
+        } else {
+            $pms = dbcount("(pmindex_id)", "pm_index", "pmindex_user_id='".$userdata['user_id']."' AND pmindex_to_id='".$userdata['user_id']."' AND pmindex_read_datestamp = '0'");
+            if ($pms == 1) {
+                $pmtext = sprintf($locale['085'], $pms);
+            } else {
+                $pmtext = sprintf($locale['086'], $pms);
+            }
+            if ($userdata['user_posts_unread']) {
+                $result = dbquery("
+                    SELECT count(*) as unread
+                        FROM ".$db_prefix."posts p
+                            INNER JOIN ".$db_prefix."forums f ON p.forum_id = f.forum_id
+                            INNER JOIN ".$db_prefix."threads_read tr ON p.thread_id = tr.thread_id
+                        WHERE ".groupaccess('f.forum_access')."
+                            AND tr.user_id = '".$userdata['user_id']."'
+                            AND (p.post_datestamp > ".$settings['unread_threshold']." OR p.post_edittime > ".$settings['unread_threshold'].")
+                            AND ((p.post_datestamp > tr.thread_last_read OR p.post_edittime > tr.thread_last_read)
+                                OR (p.post_datestamp < tr.thread_first_read OR (p.post_edittime != 0 AND p.post_edittime < tr.thread_first_read)))"
+                    );
+            } else {
+                $result = dbquery("
+                    SELECT count(*) as unread
+                        FROM ".$db_prefix."posts p
+                            INNER JOIN ".$db_prefix."forums f ON p.forum_id = f.forum_id
+                            INNER JOIN ".$db_prefix."threads_read tr ON p.thread_id = tr.thread_id
+                        WHERE ".groupaccess('f.forum_access')."
+                            AND tr.user_id = '".$userdata['user_id']."'
+                            AND p.post_author != '".$userdata['user_id']."'
+                            AND p.post_edituser != '".$userdata['user_id']."'
+                            AND (p.post_datestamp > ".$settings['unread_threshold']." OR p.post_edittime > ".$settings['unread_threshold'].")
+                            AND ((p.post_datestamp > tr.thread_last_read OR p.post_edittime > tr.thread_last_read)
+                                OR (p.post_datestamp < tr.thread_first_read OR (p.post_edittime != 0 AND p.post_edittime < tr.thread_first_read)))"
+                    );
+            }
+            $posts = ($result ? mysql_result($result, 0) : 0);
+            if ($posts == 1) {
+                $posttext = sprintf($locale['088'], $posts);
+            } else {
+                $posttext = sprintf($locale['089'], $posts);
+            }
+        }
+        // make sure we have json_encode and json_decode available
+        require_once "json_include.php";
+        // send the results back
+        header("Content-Type:application/json; charset=utf-8");
+        echo json_encode(array('pmcount' => $pms, 'pmtext' => $pmtext, 'postcount' => $posts, 'posttext' => $posttext));
         break;
     case "pm":
@@ -211 +263 @@
     mysql_close();
 }
-?>