Changeset 501

Timestamp:

05/09/08 21:11:13 (5 years ago)

Author:

MDMAN

Message:

bugfixes

Location:

application.register/files/lib

Files:

• action/DisableApplicationRegisterNotificationsAction.class.php (modified) (2 diffs)
• system/event/listener/DeleteApplicationRegisterNotificationListener.class.php (modified) (1 diff)

application.register/files/lib/action/DisableApplicationRegisterNotificationsAction.class.php

@@ -3 +3 @@
 
 /**
- * UnterdrÃŒckt die Info-Box fÃŒr das Bewerbungshinweis Benutzergruppen - PlugIn durch einen Eintrag in die Datenbank.
+ * UnterdrÌckt die Info-Box fÌr das Bewerbungshinweis Benutzergruppen - PlugIn durch einen Eintrag in die Datenbank.
  *
  * @author              Markus Gerdelmann
@@ -16 +16 @@
         parent::execute();
 
-                $sql = "SELECT  applicationID, groupID
-                                FROM    wcf".WCF_N."_group_application
-                                WHERE   groupID IN (
-                                        SELECT  groupID
-                                        FROM    wcf".WCF_N."_group_leader
-                                        WHERE   userID = ".WCF::getUser()->userID."
-                                        )
+        
+                $sql = "SELECT wcf".WCF_N."_group_application.* FROM wcf".WCF_N."_group_application
+                                LEFT JOIN wcf".WCF_N."_group_application_notification
+                                ON wcf".WCF_N."_group_application.applicationID = wcf".WCF_N."_group_application_notification.applicationID
+                                AND wcf".WCF_N."_group_application_notification.userID = ".WCF::getUser()->userID."
+                                WHERE wcf".WCF_N."_group_application_notification.applicationID IS NULL
+                                AND wcf".WCF_N."_group_application.groupID IN (
+                                                                SELECT  groupID
+                                                                FROM    wcf".WCF_N."_group_leader
+                                                                WHERE   userID = ".WCF::getUser()->userID."
+                                                                )
+                        AND wcf".WCF_N."_group_application.applicationStatus = 0
                         ";
 
                 $res = WCF::getDB()->sendQuery($sql);
-                while ($row = WCF::getUser()->fetchArray($res)){
-                        $sql = "INSERT INTO     wcf".WCF_N."_group_application_notification
-                                                (userID, applicationID)
-                                VALUES          ('".WCF::getUser()->userID."', '".$row['applicationID']."')";
+                while ($row = WCF::getDB()->fetchArray($res)){
+                        $sql = "INSERT INTO wcf".WCF_N."_group_application_notification
+                                        SET applicationID =  '".$row["applicationID"]."',
+                                        userID =  '".WCF::getUser()->userID."'";
                         WCF::getDB()->sendQuery($sql);
                 }
-
         }
 }

application.register/files/lib/system/event/listener/DeleteApplicationRegisterNotificationListener.class.php

@@ -16 +16 @@
 
                 if (count($this->applicationIDs)) {
-                $sql = "DELETE FROM wcf".WCF_N."_group_application_notification WHERE applicationID IN (".implode(',', $this->applicationIDs).")";
+                $sql = "DELETE FROM wcf".WCF_N."_group_application_notification
+                                WHERE applicationID IN (".implode(',', $this->applicationIDs).")
+                                ";
                 WCF::getDB()->sendQuery($sql);
                 }