Changeset 296

Timestamp:

03/08/08 18:26:41 (5 years ago)

Author:

MDMAN

Message:

some modified SQL query in Action and Listener File

Location:

application.register/files/lib

Files:

• action/DisableApplicationRegisterNotificationsAction.class.php (modified) (1 diff)
• system/event/listener/ApplicationRegisterListener.class.php (modified) (1 diff)

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

@@ -16 +16 @@
         parent::execute();
                 
-                $sql = "UPDATE          wcf".WCF_N."_group_application_notification
-                                SET             disableNotification = '1'
-                                WHERE           groupID IN (
-                                                        SELECT  groupID
-                                                        FROM    wcf".WCF_N."_group_leader
-                                                        WHERE   userID = '".WCF::getUser()->userID."'
-                                                        )
-                                AND             userID = '".WCF::getUser()->userID."'                           
+                $sql = "SELECT FROM wcf".WCF_N."_group_application applicationID, userID
+                                WHERE userID = ".WCF::getUser()->userID."";
+                $res = WCF::getDB()->sendQuery($sql);
+                while ($row = WCF::getDB()->fetchArray($res)){
+                        $daten[]=$row;
+                }
+                
+                while ($daten){
+                $sql = "INSERT INTO     wcf".WCF_N."_group_application_notification
+                                SET             userID = ".$daten["userID"].",
+                                                        applicationID = ".$daten["applicationID"].",
+                                                        disableNotifications = '1'                              
                                 ";
                 WCF::getDB()->sendQuery($sql);
+                }
         }
 }

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

@@ -32 +32 @@
                                                 )
                                 AND             (application_notification.disableNotification != '1'
-                                                        AND aplication_notification.userID = ".WCF::getDB()->userID.")
+                                                        AND application_notification.userID = ".WCF::getDB()->userID."
+                                                )
                                 AND     application.applicationStatus = '0'                             
                                 ";