Changeset 310 for application.register/files/lib/action/DisableApplicationRegisterNotificationsAction.class.php

Timestamp:

03/10/08 21:40:18 (5 years ago)

Author:

MDMAN

Message:

BugFixes?

Files:

• application.register/files/lib/action/DisableApplicationRegisterNotificationsAction.class.php (modified) (1 diff)

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

@@ -17 +17 @@
                 parent::execute();
                 
-                $sql = "SELECT          *
-                                FROM            wcf".WCF_N."_group_application application
-                                WHERE           application.groupID IN (
+                $sql = "DELETE FROM     wcf".WCF_N."_group_application_notification
+                                WHERE           groupID IN (
                                                         SELECT  groupID
                                                         FROM    wcf".WCF_N."_group_leader
                                                         WHERE   userID = ".WCF::getUser()->userID."
-                                                )
-                                AND                     application.applicationStatus = 0";
-                $res = WCF::getDB()->sendQuery($sql);
-                while ($row = WCF::getDB()->fetchArray($res)){
-                        $sql = "INSERT INTO     wcf".WCF_N."_group_application_notification (applicationID, userID)
-                                        VALUES          ('".$row["applicationID"]."', '".WCF::getUser()->userID."')
-                                        ";
-                        WCF::getDB()->sendQuery($sql);
-                }
+                                                        )";
+                WCF::getDB()->sendQuery($sql);
         }
 }