root/trackback/files/lib/acp/page/TrackbackOutgoingPage.class.php @ 154

<?php
require_once(WCF_DIR.'lib/page/SortablePage.class.php');
require_once(WCF_DIR.'lib/system/event/EventHandler.class.php');

/**
 * acp: outgoing trackbacks
 *
 * @author      Torben Brodt
 * @package     de.easy-coding.wbb.trackback
 * @license     GNU General Public License <http://opensource.org/licenses/gpl-3.0.html>
 */
class TrackbackOutgoingPage extends SortablePage {
        public $templateName = 'trackbackOutgoing';
        public $itemsPerPage = 10;
        public $defaultSortField = 'timestamp';
        public $trackbacks = array();
        
        /**
         * @see Page::readParameters()
         */
        public function readParameters() {
                parent::readParameters();
        }
        
        /**
         * @see Page::SortablePage()
         */
        public function validateSortField() {
                parent::validateSortField();

                switch ($this->sortField) {
                        case 'trackbackLogID':
                        case 'postID':
                        case 'alienURL':
                        case 'timestamp': break;
                        default: $this->sortField = $this->defaultSortField;
                }
        }
        
        /**
         * @see Page::readData()
         */
        public function readData() {
                parent::readData();
                $sql = "SELECT          trackbackLogID,
                                        postID,
                                        alienURL,
                                        timestamp
                        FROM            wbb".WBB_N."_trackbackLog
                        ORDER BY        ".$this->sortField." ".$this->sortOrder."
                        LIMIT           ".$this->itemsPerPage."
                        OFFSET          ".(($this->pageNo - 1) * $this->itemsPerPage);
                $result = WCF::getDB()->sendQuery($sql);
                while ($row = WCF::getDB()->fetchArray($result)) {
                        $this->trackbacks[] = $row;
                }
        }
        
        /**
         * @see Page::assignVariables()
         */
        public function assignVariables() {
                parent::assignVariables();

                WCF::getTPL()->assign(array(
                        'trackbacks' => $this->trackbacks,
                        'trackbackscount' => $this->countItems()
                ));
        }
        
        /**
         * @see Page::show()
         */
        public function show() {
                // enable menu item
                WCFACP::getMenu()->setActiveMenuItem('wcf.acp.menu.link.content.trackback.outgoing');
                
                parent::show();
        }
        
        /**
         * @see Page::countItems()
         */
        public function countItems() {
                $sql = "SELECT          COUNT(trackbackLogID) AS c
                        FROM            wbb".WBB_N."_trackbackLog";
                $row = WCF::getDB()->getFirstRow($sql);

                return $row['c'];
        }
}
?>