@@ -118,27 +118,27 @@ discard block |
||
| 118 | 118 | */ |
| 119 | 119 | function getNewPMs($id_member, $timestamp) |
| 120 | 120 | { |
| 121 | - $db = database(); |
|
| 121 | + $db = database(); |
|
| 122 | 122 | |
| 123 | - if (empty($timestamp)) |
|
| 124 | - { |
|
| 125 | - $result = $db->fetchQuery(' |
|
| 123 | + if (empty($timestamp)) |
|
| 124 | + { |
|
| 125 | + $result = $db->fetchQuery(' |
|
| 126 | 126 | SELECT |
| 127 | 127 | COUNT(*) AS c |
| 128 | 128 | FROM {db_prefix}pm_recipients AS pr |
| 129 | 129 | WHERE pr.id_member = {int:member} |
| 130 | 130 | AND pr.deleted = {int:not_deleted} |
| 131 | 131 | AND (pr.is_read & 1) = {int:is_unread}', |
| 132 | - [ |
|
| 133 | - 'member' => (int) $id_member, |
|
| 134 | - 'not_deleted' => 0, |
|
| 135 | - 'is_unread' => 0, |
|
| 136 | - ] |
|
| 137 | - )->fetch_assoc(); |
|
| 138 | - } |
|
| 139 | - else |
|
| 140 | - { |
|
| 141 | - $result = $db->fetchQuery(' |
|
| 132 | + [ |
|
| 133 | + 'member' => (int) $id_member, |
|
| 134 | + 'not_deleted' => 0, |
|
| 135 | + 'is_unread' => 0, |
|
| 136 | + ] |
|
| 137 | + )->fetch_assoc(); |
|
| 138 | + } |
|
| 139 | + else |
|
| 140 | + { |
|
| 141 | + $result = $db->fetchQuery(' |
|
| 142 | 142 | SELECT |
| 143 | 143 | COUNT(*) AS c |
| 144 | 144 | FROM {db_prefix}pm_recipients AS pr |
@@ -147,16 +147,16 @@ discard block |
||
| 147 | 147 | AND pr.deleted = {int:not_deleted} |
| 148 | 148 | AND (pr.is_read & 1) = {int:is_unread} |
| 149 | 149 | AND pm.msgtime > {int:last_seen}', |
| 150 | - [ |
|
| 151 | - 'member' => (int) $id_member, |
|
| 152 | - 'not_deleted' => 0, |
|
| 153 | - 'is_unread' => 0, |
|
| 154 | - 'last_seen' => (int) $timestamp, |
|
| 155 | - ] |
|
| 156 | - )->fetch_assoc(); |
|
| 157 | - } |
|
| 158 | - |
|
| 159 | - return (int) $result['c']; |
|
| 150 | + [ |
|
| 151 | + 'member' => (int) $id_member, |
|
| 152 | + 'not_deleted' => 0, |
|
| 153 | + 'is_unread' => 0, |
|
| 154 | + 'last_seen' => (int) $timestamp, |
|
| 155 | + ] |
|
| 156 | + )->fetch_assoc(); |
|
| 157 | + } |
|
| 158 | + |
|
| 159 | + return (int) $result['c']; |
|
| 160 | 160 | } |
| 161 | 161 | |
| 162 | 162 | /** |