Changeset 1064

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/

Location:

trunk

Files:

• common/db/smf.php (modified) (1 diff)
• www/views/sitewide.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;
+}
 ?>

trunk/www/views/sitewide.php

@@ -84 +84 @@
     <li>
         <?= getattr($pre, 'pm') ?>
-        <?= format_link(url_forum() . "?action=pm", "mesaje") ?>
+        <?php
+        $new_pm_count = smf_get_pm_count($identity_user['username']);
+        if ($new_pm_count) { ?>
+            <?= format_link(url_forum() . "?action=pm", "<b>mesaje (".$new_pm_count.")</b>", false) ?>
+        <?php } else { ?>
+            <?= format_link(url_forum() . "?action=pm", "mesaje") ?>
+        <?php } ?>
         <?= getattr($post, 'pm') ?>
     </li>