root/de.wbb-security.database.additionalrating/files/lib/system/event/listener/DatabaseAdditionalRatingAddListener.class.php @ 941

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

/**
 * Shows the additonalRatings in the Webdisk-Item
 * 
 * @author              Markus Gerdelmann
 * @copyright   2005-2009
 * @package             de.wbb-security.database
 */
class DatabaseAdditionalRatingAddListener implements EventListener {

    public $itemID = 0;
    public $catID = 0;
    public $fields = array();
   

    /**
    * @see EventListener::execute()
    */
    public function execute($eventObj, $className, $eventName){
    
            if (MODULE_DATABASE_ADDITIONALRATING == 1) {

                // Hier wird geschaut, welches ITEM aktuell angezeigt wird.
                if(isset($_REQUEST['id']))      $this->itemID = intval($_REQUEST['id']);
                
                // Nun wird die aktuelle Kategorie ermittelt
                if($this->itemID > 0) {
                
                        $sql = "SELECT categoryID
                                        FROM wcf".WCF_N."_database_item
                                        WHERE itemID = ".$this->itemID;
                
                        $result = WCF::getDB()->sendQuery($sql);
                        while ($row = WCF::getDB()->fetchArray($result)) {
                                $this->catID = $row['categoryID'];      
                        }
                }
                     
                // Hier wird geschaut, ob der User die Bewertung machen darf.
                if (WCF::getUser()->getPermission('user.database.canAddAdditionalRating') == 1 && $this->catID > 0) {
                        // Hier werden alle zusaetzlichen Felder ermittelt
                        $sql = "SELECT `a`.*, `b`.`ipAddress`, `b`.`userID`, `b`.`itemID`,
                            IFNULL(`b`.`rating`, '0') AS `rating`
                            FROM `wcf".WCF_N."_database_additionalrating` AS `a`
                            LEFT JOIN (
                                 SELECT *
                                 FROM `wcf".WCF_N."_database_additionalrating_ratings`
                                 WHERE `itemID` = '".$this->itemID."'
                                 AND `userID` = '".WCF::getUser()->userID."'
                            ) AS `b`
                            ON (`a`.`ratingID` = `b`.`ratingID`)
                            WHERE `a`.`catID` = '".$this->catID."'
                            GROUP BY `ratingID`
                            ORDER BY `a`.`sortOrder` ASC
                            ";
        
        
                                $result = WCF::getDB()->sendQuery($sql);
                                while ($row = WCF::getDB()->fetchArray($result)) {
                                        $this->fields[] = $row;
                                }
                                
                                //Hier werden die Variablen in den Template-Variabeln registriert
                        WCF::getTPL()->assign(array(
                        'fields' => $this->fields,
                        'itemID' => $this->itemID
                        ));
        
                                //Hier wird das Template in den Platzhalter der databaseItem.tpl geladen
                                if(!defined("DATABASE_ADDITIONAL_RATING_ADD_TPL")) { 
                                        WCF::getTPL()->append('additionalFields2', WCF::getTPL()->fetch('databaseAdditionalRatingAdd'));   
                                        define("DATABASE_ADDITIONAL_RATING_ADD_TPL",1);
                                }
                }
                }
    }
}
?>