Changeset 310

Timestamp:

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

Author:

MDMAN

Message:

BugFixes?

Location:

application.register

Files:

• files/lib/action/DisableApplicationRegisterNotificationsAction.class.php (modified) (1 diff)
• files/lib/system/event/listener/ApplicationRegisterFillInListener.class.php (modified) (1 diff)
• install.sql (modified) (1 diff)
• update.sql (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);
         }
 }

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

@@ -20 +20 @@
                 //hier wird die Tabelle group_application_notification mit der AppID und die userID DES BEWERBERS gefÃŒllt
                 $sql = "INSERT INTO     wcf".WCF_N."_group_application_notification
-                                                                (applicationID, userID)
-                                VALUES                  ('".$eventObj->applicationID."', '".WCF::getUser()->userID."')
+                                                                (applicationID, groupID)
+                                VALUES                  ('".$eventObj->applicationID."', '".$eventObj->groupID."')
                                 ";
                 WCF::getDB()->sendQuery($sql);  

application.register/install.sql

@@ -11 +11 @@
 CREATE TABLE wcf1_group_application_notification (
   applicationID int(11) unsigned NOT NULL,
-  userID int(10) unsigned NOT NULL,
+  groupID int(10) unsigned NOT NULL,
   PRIMARY KEY (applicationID,userID)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

application.register/update.sql

@@ -11 +11 @@
 CREATE TABLE IF NOT EXISTS wcf1_group_application_notification (
   applicationID int(11) unsigned NOT NULL,
-  userID int(10) unsigned NOT NULL,
+  groupID int(10) unsigned NOT NULL,
   PRIMARY KEY (applicationID,userID)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;