diff options
| author | damosoft <damosoft> | 2006-03-27 21:50:09 +0000 |
|---|---|---|
| committer | damosoft <damosoft> | 2006-03-27 21:50:09 +0000 |
| commit | 16832cc3fe24dad2eee4b67163e38bd53563fc7a (patch) | |
| tree | 951eb18bb7008286d59e17f426517aa79cba0d02 | |
| parent | c72a13c0ddc7798fdb48727a0ec21c57fe8a5ff4 (diff) | |
| download | messages-16832cc3fe24dad2eee4b67163e38bd53563fc7a.tar.gz messages-16832cc3fe24dad2eee4b67163e38bd53563fc7a.tar.bz2 messages-16832cc3fe24dad2eee4b67163e38bd53563fc7a.zip | |
Seems the field name needed to me escaped, plus * wasnt working anyway, changed to msg_id as the count
| -rw-r--r-- | messages_lib.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/messages_lib.php b/messages_lib.php index 16bbc22..7331f32 100644 --- a/messages_lib.php +++ b/messages_lib.php @@ -3,7 +3,7 @@ * message package modules * * @author -* @version $Revision: 1.6 $ +* @version $Revision: 1.7 $ * @package messages */ @@ -175,7 +175,7 @@ class Messages extends BitBase { WHERE mm.`to_user_id` = ? AND mm.`group_id` IN (SELECT `group_id` FROM `".BIT_DB_PREFIX."users_groups_map` WHERE `user_id` = ?) $mid ORDER BY ".$this->mDb->convert_sortmode($sort_mode).",".$this->mDb->convert_sortmode("mm.msg_id_desc"); - $query_cant = "SELECT COUNT(mm.*) + $query_cant = "SELECT COUNT(mm.`msg_id`) FROM `".BIT_DB_PREFIX."messages` mm LEFT OUTER JOIN `".BIT_DB_PREFIX."messages_system_map` msm ON (mm.`msg_id` = msm.`msg_id` AND msm.`to_user_id` = ?) WHERE mm.`to_user_id` = ? AND mm.`group_id` IN (SELECT `group_id` FROM `".BIT_DB_PREFIX."users_groups_map` WHERE `user_id` = ?) $mid"; |