root/downloadDatabase/files/lib/system/cache/CacheBuilderDLDBData.class.php @ 523

<?php
require_once(WCF_DIR.'lib/system/cache/CacheBuilder.class.php');

/**
 * Cacht Download Database Daten.
 * 
 * @author              Robert "Tatzelwurm" Hempel
 * @copyright   2007/2008 INSIDE das Hrspiel
 * @license     GNU LGPL http://www.gnu.org/licenses/lgpl.txt
 * @package             de.inside.wcf.DownloadDatabase
 */
class CacheBuilderDLDBData implements CacheBuilder {
        /**
         * @see CacheBuilder::getData()
         */
        public function getData($cacheResource) {
                $data = array();
                
                $sql = "SELECT  t1.dataID AS dataID, t1.katID AS katID, t2.name AS katName,
                                                                                t1.name AS name, t1.description AS description,
                                                                                t1.previewIMG AS previewIMG, t1.previewFile AS previewFile,
                                                                                t1.fileName AS fileName, t1.fileExtension AS fileExtension,
                                                                                t1.mimeType AS mimeType, t1.link AS link,
                                                                                t1.groesse AS groesse, t1.downloads AS downloads,
                                                                                t1.userID AS dldbUserID, t1.datum AS datum,
                                                                                t1.thread AS thread, t1.activ AS activ,
                                                                                t2.groupIDs AS groupcheck, t1.sortOrder AS sortOrder, 
                                                                                t1.parseURL AS parseURL, t1.enableSmilies AS enableSmilies,
                                                                                t1.enableHtml AS enableHtml, t1.enableBBCodes AS enableBBCodes,
                                                                                t1.languageID AS languageID,
                                                        (SELECT COUNT(t3.dataID)
                                                        FROM    wcf".WCF_N."_dldb_data as t3
                                                        WHERE   t3.katID = t1.`katID`)
                                                AS allKatData,
                                                        (SELECT username
                                                        FROM wcf".WCF_N."_user
                                                        WHERE `userID` = t1.`userID`)
                                                AS dldbUsername
                                FROM wcf".WCF_N."_dldb_data AS t1 LEFT JOIN
                                         wcf".WCF_N."_dldb_kats AS t2 ON t1.katID = t2.katID
                                ORDER BY t1.`sortOrder` ASC";
                $result = WCF::getDB()->sendQuery($sql);
                while ($row = WCF::getDB()->fetchArray($result)) {
                        $data[] = $row;
                }
                return $data;
        }
}
?>