root/application.register/files/lib/system/event/listener/UserGroupApplyMailListener.class.php @ 298

<?php
// WCF includes
require_once(WCF_DIR.'lib/system/event/EventListener.class.php');

/**
 * sends emails to group leaders and places a display notification
 *
 * @author      Markus Gerdelmann, Torben Brodt
 * @package     de.mdman.application.register
 * @license     GNU General Public License <http://opensource.org/licenses/gpl-3.0.html>
 */
class UserGroupApplyMailListener implements EventListener {
        protected $this->eventObj;

        /**
         * @see EventListener::execute()
         */
        public function execute($eventObj, $className, $eventName) {
                $this->eventObj = $eventObj;

                // requires
                require_once(WCF_DIR.'lib/data/mail/Mail.class.php');
                require_once(WCF_DIR.'lib/system/language/Language.class.php');
                
                // send notifications
                $sql = "SELECT          user.*,
                                        displayNotification,
                                        emailNotification
                        FROM            wcf".WCF_N."_group_application_mail
                        NATURAL JOIN    wcf".WCF_N."_user user
                        WHERE           groupID = ".intval($this->eventObj->group->groupID)."
                        AND             emailNotification = 1";
                $result = WCF::getDB()->sendQuery($sql);
                while ($row = WCF::getDB()->fetchArray($result)) {
                        if ($row['userID'] == WCF::getUser()->userID) {
                                continue;
                        }
                        
                        if($row['displayNotification']) {
                                $this->display($row);
                        }
                        if($row['emailNotification']) {
                                $this->email($row);
                        }
                }
                
                // enable user language
                WCF::getLanguage()->setLocale();
        }
        
        /**
         *
         */
        protected function display($row) {
                $sql = "INSERT INTO     wcf".WCF_N."_group_application_notification
                                        (applicationID, userID)
                        VALUES          (".$this->eventObj->applicationID.", ".$row['userID'].")";
                WCF::getDB()->sendQuery($sql);
        }
        
        /**
         *
         */
        protected function email($row) {
                $languages = array();
                $languages[WCF::getLanguage()->getLanguageID()] = WCF::getLanguage();
                $languages[0] = WCF::getLanguage();

                // get language
                if (!isset($languages[$row['languageID']])) {
                        $languages[$row['languageID']] = new Language($row['languageID']);      
                }
        
                // enable language
                $languages[$row['languageID']]->setLocale();

                // send mail
                $subjectData = array(
                        '$author' => WCF::getUser()->username,
                        '$group' => $this->eventObj->group,
                        'PAGE_TITLE' => PAGE_TITLE
                );
                $messageData = array(
                        '$author' => WCF::getUser()->username,
                        '$group' => $this->eventObj->group,
                        'PAGE_TITLE' => PAGE_TITLE,
                        '$pageurl' => FileUtil::addTrailingSlash(PAGE_URL),
                        '$recipient' => $row['username'],
                        '$reason' => isset($this->eventObj->reason) ? $this->eventObj->reason : ''
                );

                $mail = new Mail(array($row['username'] => $row['email']), $languages[$row['languageID']]->get('wcf.groupapplymail.mail.subject.'.$this->eventObj->group->groupType, $subjectData), $languages[$row['languageID']]->get('wcf.groupapplymail.mail.body.'.$this->eventObj->group->groupType, $messageData));
                $mail->send();
        }
}
?>