root/taggingreloaded/optionals/de.easy-coding.wbb.taggingreloaded/files/lib/system/cache/CacheBuilderTaggingReloadedBoards.class.php @ 804

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

// Tagging imports
require_once(WCF_DIR.'lib/util/TaggingReloadedUtil.class.php');
require_once(WBB_DIR.'lib/data/board/BoardListTaggingReloaded.class.php');

// seo imports
require_once(WBB_DIR.'lib/page/PublicSEORewriterTagging.class.php');

/**
 * cache
 * 
 * @author      Torben Brodt
 * @package     de.easy-coding.wbb.taggingreloaded
 * @license     GNU General Public License <http://opensource.org/licenses/gpl-3.0.html>
 */
class CacheBuilderTaggingReloadedBoards implements CacheBuilder {
        protected $rewriter;

        /**
         * @see CacheBuilder::getData()
         */
        public function getData($cacheResource) {
                $this->rewriter = new PublicSEORewriterTagging();
                $tmp = explode(".",$cacheResource['cache']);
                $boardIDs = substr($cacheResource['cache'], strrpos($cacheResource['cache'],".")+1);

                // order by weight and cut
                $sql = "SELECT          tag,
                                        SUM(weight) AS weight
                        FROM            wcf".WCF_N."_taggingreloaded wcf
                        NATURAL JOIN    wbb".WBB_N."_taggingreloaded wbb
                        JOIN            wbb".WBB_N."_post p
                        ON              wbb.postID = p.postID
                        JOIN            wbb".WBB_N."_thread t
                        ON              p.threadID = t.threadID
                        WHERE           t.boardID IN (".$boardIDs.")
                        GROUP BY        tag
                        ORDER BY        weight DESC
                        LIMIT           50";

                return $this->query($sql);
        }
        
        /**
         *
         * @param sql
         */
        protected function query($sql) {
                $data = array();

                // 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)) {
                        $data[$row['tag']] = array(
                                        'weight'=> $row['weight'],
                                        'color'=> 0,
                                        'size'=> 0,
                                        'url' => $this->rewriter->publicParseTagURLs($row['tag'])
                                        
                                );
                }
                
                $data = TaggingReloadedUtil::beautify($data);

                return $data;
        }
}
?>