<?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);
		}
	}
}
?>