root/include/class.cache.php

<?php
/**</span>
<span class="code-comment">*
* @package acm
* @version $Id: cache.php,v 1.7 2007/01/26 16:05:14 acydburn Exp $
* @copyright (c) 2005 phpBB Group
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
*/

/**
*/

/**
* Class for grabbing/handling cached entries, extends acm_file or acm_db depending on the setup
* @package acm
*/

$cache_type = ( isset($cache_type) && !empty($cache_type) ? $cache_type : 'filecache' );</span>
<span class="code-lang">require_once($root_path . 'include/class.' . $cache_type . '.php');

class cache extends adv_cache
{</span>
<span class="code-keyword">
    /**
    * Ceck if a given sql query exist in cache
    */
    function sql_exists($query_id)
    {
        return isset($this->sql_rowset[$query_id]);
    }

    /**
    * Fetch row from cache (database)
    */
    function sql_fetchrow($query_id)
    {
        if ($this->sql_row_pointer[$query_id] < sizeof($this->sql_rowset[$query_id]))
        {
            return $this->sql_rowset[$query_id][$this->sql_row_pointer[$query_id]++];
        }

        return false;
    }

    /**
    * Fetch a field from the current row of a cached database result (database)
    */
    function sql_fetchfield($query_id, $field)
    {
        if ($this->sql_row_pointer[$query_id] < sizeof($this->sql_rowset[$query_id]))
        {
            return (isset($this->sql_rowset[$query_id][$this->sql_row_pointer[$query_id]][$field])) ? $this->sql_rowset[$query_id][$this->sql_row_pointer[$query_id]][$field] : false;
        }

        return false;
    }

    /**
    * Seek a specific row in an a cached database result (database)
    */
    function sql_rowseek($rownum, $query_id)
    {
        if ($rownum >= sizeof($this->sql_rowset[$query_id]))
        {
            return false;
        }

        $this->sql_row_pointer[$query_id] = $rownum;
        return true;
    }

    /**
    * Free memory used for a cached database result (database)
    */
    function sql_freeresult($query_id)
    {
        if (!isset($this->sql_rowset[$query_id]))
        {
            return false;
        }

        unset($this->sql_rowset[$query_id]);
        unset($this->sql_row_pointer[$query_id]);

        return true;
    }

    /**
    * Get config values
    */
    function obtain_config()
    {
        global $db;
        if (($config = $this->get('config')) !== false)
        {
            if ( !defined('IN_ANNOUNCE') ) {
                $sql = 'SELECT name, value
                    FROM ' . CONFIG_TABLE . '
                    WHERE is_dynamic = 1';
                $result = $db->sql_query($sql);

                while ($row = $db->sql_fetchrow($result))
                {
                    $config[$row['name']] = $row['value'];
                }
                $db->sql_freeresult($result);
            }
        }
        else
        {
            $config = $cached_config = array();

            $sql = 'SELECT name, value, is_dynamic
                FROM ' . CONFIG_TABLE;
            $result = $db->sql_query($sql);

            while ($row = $db->sql_fetchrow($result))
            {
                if (!$row['is_dynamic'])
                {
                    $cached_config[$row['name']] = $row['value'];
                }

                $config[$row['name']] = $row['value'];
            }
            $db->sql_freeresult($result);

            $this->put('config', $cached_config);
        }

        return $config;
    }

    /**
    * Obtain list of naughty words and build preg style replacement arrays for use by the
    * calling script
    */
    function obtain_word_list()
    {
        global $db;

        if (($censors = $this->get('_word_censors')) === false)
        {
            $sql = 'SELECT word, replacement
                FROM ' . WORDS_TABLE;
            $result = $db->sql_query($sql);

            $censors = array();
            while ($row = $db->sql_fetchrow($result))
            {
                $censors['match'][] = '#(?<!\w)(' . str_replace('\*', '\w*?', preg_quote($row['word'], '#')) . ')(?!\w)#i';
                $censors['replace'][] = $row['replacement'];
            }
            $db->sql_freeresult($result);

            $this->put('_word_censors', $censors);
        }

        return $censors;
    }

    function obtain_smilies()
    {
        if (($smilies = $this->get('_smilies')) === false)
        {
            global $db;

            $sql = 'SELECT * FROM ' . SMILIES_TABLE;
            $result = $db->sql_query($sql);

            $smilies = array();
            while ($row = $db->sql_fetchrow($result))
            {
                $smilies[$row['smilies_id']] = $row;
            }
            $db->sql_freeresult($result);

            $this->put('_smilies', $smilies);
        }

        return $smilies;
    }

    function obtain_ranks()
    {
        global $db;

        if (($ranks = $this->get('_ranks')) === false)
        {
            $sql = 'SELECT *
                FROM ' . RANKS_TABLE . ' ORDER BY rank_points';
            $result = $db->sql_query($sql);

            $ranks = array();
            while ($row = $db->sql_fetchrow($result))
            {
                $ranks[$row['rank_id']] = $row;
            }
            $db->sql_freeresult($result);

            $this->put('_ranks', $ranks);
        }

        return $ranks;
    }

    function obtain_cats()
    {
        global $db;

        if (($cats = $this->get('_cats')) === false)
        {
            $sql = 'SELECT id AS cat_id, name AS cat_name, image AS cat_pic, cat_parent_id AS cat_parent, torrents_limit, anonymous_view, allow_upload
                    FROM ' . CATEGORIES_TABLE . ' ORDER BY name';
            $result = $db->sql_query($sql);

            $cats = array();
            while ($row = $db->sql_fetchrow($result))
            {
                $cats[$row['cat_id']] = $row;
            }
            $db->sql_freeresult($result);

            $this->put('_cats', $cats);
        }

        return $cats;
    }

    function obtainForumCats()
    {
        global $db;

        if (($cats = $this->get('_forumCats')) === false)
        {
            $sql = 'SELECT *
            FROM ' . FORUM_CATEGORIES_TABLE . ' c
            ORDER BY c.cat_order';
            $result = $db->sql_query($sql);

            $cats = array();
            while ($row = $db->sql_fetchrow($result))
            {
                $cats[$row['cat_id']] = $row;
            }
            $db->sql_freeresult($result);

            $this->put('_forumCats', $cats);
        }

        return $cats;
    }

    function obtainForums()
    {
        global $db;

        $forums_parent = $this->get('_forumsParent');
        $forums = $this->get('_forums');

        if ( !$forums_parent || !$forums )
        {
            $sql = 'SELECT *
            FROM ' . FORUMS_TABLE;
            $result = $db->sql_query($sql);

            $forums = $forums_parent = array();
            while ($row = $db->sql_fetchrow($result))
            {
                $forums[$row['forum_id']] = $row;
            $forums_parent[$row['forum_parent']] = $row;
            }
            $db->sql_freeresult($result);

            $this->put('_forums', $forums);
            $this->put('_forumsParent', $forums_parent);
        }

        return array($forums, $forums_parent);
    }

}
?>