root/application.register/files/lib/action/DisableApplicationRegisterNotificationsAction.class.php @ 501

<?php
require_once(WCF_DIR.'lib/action/AbstractAction.class.php');

/**
 * UnterdrÌckt die Info-Box fÌr das Bewerbungshinweis Benutzergruppen - PlugIn durch einen Eintrag in die Datenbank.
 *
 * @author              Markus Gerdelmann
 * @copyright   2007/2008 MDMAN
 * @license     GNU Lesser General Public License <http://opensource.org/licenses/lgpl-license.php>
 * @package             de.mdman.application.register
 */

class DisableApplicationRegisterNotificationsAction extends AbstractAction {

        public function execute() {
        parent::execute();

        
                $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::getDB()->fetchArray($res)){
                        $sql = "INSERT INTO wcf".WCF_N."_group_application_notification
                                        SET applicationID =  '".$row["applicationID"]."',
                                        userID =  '".WCF::getUser()->userID."'";
                        WCF::getDB()->sendQuery($sql);
                }
        }
}
?>