Changeset 294

Timestamp:

03/08/08 17:13:16 (5 years ago)

Author:

MDMAN

Message:

Einige Änderungen der MySQL-Auslesung verändert.

Location:

application.register

Files:

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

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

@@ -16 +16 @@
         parent::execute();
                 
-                $sql = "UPDATE          wcf".WCF_N."_group_application
+                $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."
+                                                        WHERE   userID = '".WCF::getUser()->userID."'
                                                         )
-                                AND             applicationStatus = '0'                         
+                                AND             userID = '".WCF::getUser()->userID."'                           
                                 ";
                 WCF::getDB()->sendQuery($sql);

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

@@ -31 +31 @@
                                                         WHERE   userID = ".WCF::getUser()->userID."
                                                 )
-                                AND             application.disableNotification != '1'
+                                AND             application_notification.disableNotification != '1'
                                 AND     application.applicationStatus = '0'                             
                                 ";

application.register/install.sql

@@ -15 +15 @@
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 DROP TABLE IF NOT EXISTS wcf_group_application_notification;
-CREATE TABLE `wcf1_group_application_notification` (
-`userID` INT( 10 ) NOT NULL ,
-`groupleaderID` INT( 10 ) NOT NULL ,
-`disableNotification` TINYINT( 1 ) NOT NULL
-) ENGINE = MYISAM ;