root/taggingreloaded/files/lib/page/TaggingPage.class.php @ 53

<?php
require_once(WCF_DIR.'lib/page/AbstractPage.class.php');

/**
 * tagging page (extendable by mods)
 *
 * @author      Torben Brodt
 * @package     de.easy-coding.wcf.taggingreloaded
 * @license     GNU Lesser General Public License <http://opensource.org/licenses/lgpl-license.php>
 */
class TaggingPage extends AbstractPage {
        public $templateName = 'taggingReloaded'; 
        protected $tag;
        protected $tags = array();
        
        /**
         * @see Page::readParameters()
         */
        public function readParameters() {
                parent::readParameters();
                
                if(isset($_GET['tag'])) $this->tag = $_GET['tag'];
        }
        
        /**
         * @see Page::readData()
         */
        public function readData() {
                parent::readData();
                
                if(empty($this->tag)) {
                        // order by weight and cut
                        $sql = "SELECT          tag,
                                                SUM(weight) AS weight
                                FROM            wcf".WCF_N."_taggingreloaded wcf
                                GROUP BY        tag
                                ORDER BY        weight DESC
                                LIMIT           100";
                        //      SUM( weight ) * IF(COUNT(tag), 1.2, 1 )

                        // order by tag
                        $sql = "SELECT tag,weight FROM ($sql) A ORDER BY tag ASC";
                        
                        // query
                        $result = WCF::getDB()->sendQuery($sql);
                        while ($row = WCF::getDB()->fetchArray($result)) {
                                $this->tags[$row['tag']] = array(
                                                'weight'=> $row['weight'],
                                                'color'=> 0,
                                                'size'=> 0
                                        );
                        }
                        
                        $this->tags = TaggingReloadedUtil::beautify($this->tags);
                }
        }
        
        /**
         * @see Page::assignVariables()
         */
        public function assignVariables() {
                parent::assignVariables();
                
                if(empty($this->tag)) {
                        $title = WCF::getLanguage()->get('wcf.header.menu.tagging');
                        $headline = WCF::getLanguage()->get('wcf.taggingreloaded.tagging');
                        $desc = WCF::getLanguage()->get('wcf.taggingreloaded.description');
                } else {
                        $title = $this->tag . ' - ' . WCF::getLanguage()->get('wcf.header.menu.tagging');
                        $headline = $this->tag;
                        $desc = WCF::getLanguage()->get('wcf.taggingreloaded.tagging');
                }

                WCF::getTPL()->assign(array(
                        'title' => $title,
                        'headline' => $headline,
                        'desc' => $desc,
                        'tags' => $this->tags,
                        'specialStyles' => '<link rel="stylesheet" type="text/css" href="'.RELATIVE_WCF_DIR.'style/taggingreloaded.css" />',
                        'allowSpidersToIndexThisPage' => true
                        ));
                
                WCF::getTPL()->append('additionalTaggingContents', WCF::getTPL()->fetch('taggingCloud'));
        }
        
        /**
         * @see Page::show()
         */
        public function show() {
                // set active header menu item
                require_once(WCF_DIR.'lib/page/util/menu/HeaderMenu.class.php');
                HeaderMenu::setActiveMenuItem('wcf.header.menu.tagging');

                parent::show();
        }
}
?>