root/racing.league/files/lib/action/RacingLeagueDeleteRaceAction.class.php @ 707

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

/**
 * Löscht ein Rennen
 *
 * @author              Markus Gerdelmann
 * @copyright   2007/2008 MDMAN
 * @license     GNU Lesser General Public License <http://opensource.org/licenses/lgpl-license.php>
 * @package             de.mdman.racing.league
 */

class RacingLeagueDeleteRaceAction extends AbstractAction {
        
        public $raceID = 0;
        public $ID = 0;

        public function execute() {
        parent::execute();
        
                if (isset($_REQUEST["raceID"])) $this->raceID = intval($_REQUEST["raceID"]);

                // hier wird ein Rennen inklusive dessen Ergebnisse gelöscht
                if ($this->raceID > 0) {
                        $sql = "DELETE FROM `wcf".WCF_N."_racing_races`
                                WHERE `raceID` = '".escapeString($this->raceID)."'
                                        ";                      
                        $res = WCF::getDB()->sendQuery($sql);
                        $row = WCF::getDB()->getAffectedRows($res);

                        $sql = "DELETE FROM `wcf".WCF_N."_racing_results`
                                WHERE `raceID` = '".escapeString($this->raceID)."'
                                        ";                      
                        WCF::getDB()->sendQuery($sql);
                        
                        $sql = "DELETE FROM `wcf".WCF_N."_racing_results_team`
                                WHERE `raceID` = '".escapeString($this->raceID)."'
                                        ";                      
                        WCF::getDB()->sendQuery($sql);
                        
                        // hier werden auch Strafen fÌr das gelöschte Rennen gelöscht                        
                        $sql = "DELETE FROM `wcf".WCF_N."_racing_punish`
                                WHERE `raceID` = '".escapeString($this->raceID)."'
                                        ";                      
                        WCF::getDB()->sendQuery($sql);
                        
                        if ($row > 0) {                         
                                WCF::getTPL()->append('userMessages', WCF::getTPL()->fetch('racingLeagueDeleteSuccess'));
                        }
                        else {
                                WCF::getTPL()->append('userMessages', WCF::getTPL()->fetch('racingLeagueDeleteError'));
                        }
                }
                                                
                $this->executed();
                
                HeaderUtil::redirect('index.php?form=RacingLeagueRaces'.SID_ARG_2ND_NOT_ENCODED);
                exit;
        }
}
?>