Changeset 1064 for trunk/common

Timestamp:

11/26/09 22:50:21 (2 years ago)

Author:

savin.tiberiu@…

Message:

Added the number of unread personal messages to the "mesaje" tab in the navigation bar.

Solved ticket #248.

Review URL: ​http://reviewboard.infoarena.ro/r/78/

File:

• trunk/common/db/smf.php (modified) (1 diff)

trunk/common/db/smf.php

@@ -220 +220 @@
 }
 
+// Counts the number of unread personal messages
+function smf_get_pm_count($username) {
+   $from_cache = mem_cache_get("smf-new-pm-".$username);
+
+    if ($from_cache !== false) {
+        return $from_cache;
+    }
+
+    $user_smf_id = smf_get_member_id($username);
+    $prefix = IA_SMF_DB_PREFIX;
+    $query = "
+        SELECT COUNT(*) FROM {$prefix}pm_recipients
+        WHERE ID_MEMBER = ".$user_smf_id." AND is_read = 0
+    ";
+
+    // Cache value
+    $new_pm_count = db_query_value($query);
+    mem_cache_set("smf-new-pm-".$username, $new_pm_count, 600);
+    return $new_pm_count;
+}
 ?>