Changeset 400

Timestamp:

04/06/08 13:07:57 (5 years ago)

Author:

d0nut

Message:

improved mysql 4 compatiblities (maybe)

Location:

buddyloo/files/lib/system/event/listener

Files:

• BuddylooRealnameRecipientsListener.class.php (modified) (1 diff)
• BuddylooUserPageListener.class.php (modified) (2 diffs)
• BuddylooUserSuggestPageListener.class.php (modified) (1 diff)

buddyloo/files/lib/system/event/listener/BuddylooRealnameRecipientsListener.class.php

@@ -36 +36 @@
                         NATURAL JOIN    wcf".WCF_N."_user user
                         WHERE           {$realname} IN ('".implode("','", $recipientArray)."')
-                        AND             userID != ".WCF::getUser()->userID."
+                        AND             user.userID != ".WCF::getUser()->userID."
                         AND     (
                                                 {$shareRealname} = 0

buddyloo/files/lib/system/event/listener/BuddylooUserPageListener.class.php

@@ -113 +113 @@
                 $connections[] = new UserProfile(WCF::getUser()->userID);
                 
-                $sql = "SELECT          user_option.userOption".User::getUserOptionID('invisible').", user.userID, user.username, user.lastActivityTime
+                $sql = "SELECT          user_option.userOption".User::getUserOptionID('invisible').", 
+                                        user.userID, 
+                                        user.username, 
+                                        user.lastActivityTime
                         FROM            wcf".WCF_N."_user_whitelist buddy2
                         JOIN            wcf".WCF_N."_user user
@@ -129 +132 @@
                 
                 if($i == 0) {
-                        $sql = "SELECT          user_option.userOption".User::getUserOptionID('invisible').", user.userID, user.username, user.lastActivityTime
+                        $sql = "SELECT          user_option.userOption".User::getUserOptionID('invisible').", 
+                                                user.userID, 
+                                                user.username, 
+                                                user.lastActivityTime
                                 FROM            wcf".WCF_N."_user_whitelist buddy1
                                 JOIN            wcf".WCF_N."_user_whitelist buddy2

buddyloo/files/lib/system/event/listener/BuddylooUserSuggestPageListener.class.php

@@ -39 +39 @@
                                 FROM            wcf".WCF_N."_user_option_value value
                                 WHERE           {$realname} LIKE '".escapeString($this->eventObj->query)."%'
-                                AND             userID != ".WCF::getUser()->userID."
+                                AND             value.userID != ".WCF::getUser()->userID."
                                 AND     (
                                                         {$shareRealname} = 0