Code Forge

<?php

/**

*

* @package acm

* @version $Id$

* @copyright (c) 2005 phpBB Group

* @license http://opensource.org/licenses/gpl-license.php GNU Public License

*

*/

/**

* @ignore

*/

if (!defined('IN_PHPBB'))

{

        exit;

}

/**

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

* @package acm

*/

class cache extends acm

{

        /**

        * Get config values

        */

        function obtain_config()

        {

                global $db;

                if (($config = $this->get('config')) !== false)

                {

                        $sql = 'SELECT config_name, config_value

                                FROM ' . CONFIG_TABLE . '

                                WHERE is_dynamic = 1';

                        $result = $db->sql_query($sql);

                        while ($row = $db->sql_fetchrow($result))

                        {

                                $config[$row['config_name']] = $row['config_value'];

                        }

                        $db->sql_freeresult($result);

                }

                else

                {

                        $config = $cached_config = array();

                        $sql = 'SELECT config_name, config_value, is_dynamic

                                FROM ' . CONFIG_TABLE;

                        $result = $db->sql_query($sql);

                        while ($row = $db->sql_fetchrow($result))

                        {

                                if (!$row['is_dynamic'])

                                {

                                        $cached_config[$row['config_name']] = $row['config_value'];

                                }

                                $config[$row['config_name']] = $row['config_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'][] = get_censor_preg_expression($row['word']);

                                $censors['replace'][] = $row['replacement'];

                        }

                        $db->sql_freeresult($result);

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

                }

                return $censors;

        }

        /**

        * Obtain currently listed icons

        */

        function obtain_icons()

        {

                if (($icons = $this->get('_icons')) === false)

                {

                        global $db;

                        // Topic icons

                        $sql = 'SELECT *

                                FROM ' . ICONS_TABLE . '

                                ORDER BY icons_order';

                        $result = $db->sql_query($sql);

                        $icons = array();

                        while ($row = $db->sql_fetchrow($result))

                        {

                                $icons[$row['icons_id']]['img'] = $row['icons_url'];

                                $icons[$row['icons_id']]['width'] = (int) $row['icons_width'];

                                $icons[$row['icons_id']]['height'] = (int) $row['icons_height'];

                                $icons[$row['icons_id']]['display'] = (bool) $row['display_on_posting'];

                        }

                        $db->sql_freeresult($result);

                        $this->put('_icons', $icons);

                }

                return $icons;

        }

        /**

        * Obtain ranks

        */

        function obtain_ranks()

        {

                if (($ranks = $this->get('_ranks')) === false)

                {

                        global $db;

                        $sql = 'SELECT *

                                FROM ' . RANKS_TABLE . '

                                ORDER BY rank_min DESC';

                        $result = $db->sql_query($sql);

                        $ranks = array();

                        while ($row = $db->sql_fetchrow($result))

                        {

                                if ($row['rank_special'])

                                {

                                        $ranks['special'][$row['rank_id']] = array(

                                                'rank_title'        =>        $row['rank_title'],

                                                'rank_image'        =>        $row['rank_image']

                                        );

                                }

                                else

                                {

                                        $ranks['normal'][] = array(

                                                'rank_title'        =>        $row['rank_title'],

                                                'rank_min'                =>        $row['rank_min'],

                                                'rank_image'        =>        $row['rank_image']

                                        );

                                }

                        }

                        $db->sql_freeresult($result);

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

                }

                return $ranks;

        }

        /**

        * Obtain allowed extensions

        *

        * @param mixed $forum_id If false then check for private messaging, if int then check for forum id. If true, then only return extension informations.

        *

        * @return array allowed extensions array.

        */

        function obtain_attach_extensions($forum_id)

        {

                if (($extensions = $this->get('_extensions')) === false)

                {

                        global $db;

                        $extensions = array(

                                '_allowed_post'        => array(),

                                '_allowed_pm'        => array(),

                        );

                        // The rule is to only allow those extensions defined. ;)

                        $sql = 'SELECT e.extension, g.*

                                FROM ' . EXTENSIONS_TABLE . ' e, ' . EXTENSION_GROUPS_TABLE . ' g

                                WHERE e.group_id = g.group_id

                                        AND (g.allow_group = 1 OR g.allow_in_pm = 1)';

                        $result = $db->sql_query($sql);

                        while ($row = $db->sql_fetchrow($result))

                        {

                                $extension = strtolower(trim($row['extension']));

                                $extensions[$extension] = array(

                                        'display_cat'        => (int) $row['cat_id'],

                                        'download_mode'        => (int) $row['download_mode'],

                                        'upload_icon'        => trim($row['upload_icon']),

                                        'max_filesize'        => (int) $row['max_filesize'],

                                        'allow_group'        => $row['allow_group'],

                                        'allow_in_pm'        => $row['allow_in_pm'],

                                );

                                $allowed_forums = ($row['allowed_forums']) ? unserialize(trim($row['allowed_forums'])) : array();

                                // Store allowed extensions forum wise

                                if ($row['allow_group'])

                                {

                                        $extensions['_allowed_post'][$extension] = (!sizeof($allowed_forums)) ? 0 : $allowed_forums;

                                }

                                if ($row['allow_in_pm'])

                                {

                                        $extensions['_allowed_pm'][$extension] = 0;

                                }

                        }

                        $db->sql_freeresult($result);

                        $this->put('_extensions', $extensions);

                }

                // Forum post

                if ($forum_id === false)

                {

                        // We are checking for private messages, therefore we only need to get the pm extensions...

                        $return = array('_allowed_' => array());

                        foreach ($extensions['_allowed_pm'] as $extension => $check)

                        {

                                $return['_allowed_'][$extension] = 0;

                                $return[$extension] = $extensions[$extension];

                        }

                        $extensions = $return;

                }

                else if ($forum_id === true)

                {

                        return $extensions;

                }

                else

                {

                        $forum_id = (int) $forum_id;

                        $return = array('_allowed_' => array());

                        foreach ($extensions['_allowed_post'] as $extension => $check)

                        {

                                // Check for allowed forums

                                if (is_array($check))

                                {

                                        $allowed = (!in_array($forum_id, $check)) ? false : true;

                                }

                                else

                                {

                                        $allowed = true;

                                }

                                if ($allowed)

                                {

                                        $return['_allowed_'][$extension] = 0;

                                        $return[$extension] = $extensions[$extension];

                                }

                        }

                        $extensions = $return;

                }

                if (!isset($extensions['_allowed_']))

                {

                        $extensions['_allowed_'] = array();

                }

                return $extensions;

        }

        /**

        * Obtain active bots

        */

        function obtain_bots()

        {

                if (($bots = $this->get('_bots')) === false)

                {

                        global $db;

                        switch ($db->sql_layer)

                        {

                                case 'mssql':

                                case 'mssql_odbc':

                                case 'mssqlnative':

                                        $sql = 'SELECT user_id, bot_agent, bot_ip

                                                FROM ' . BOTS_TABLE . '

                                                WHERE bot_active = 1

                                        ORDER BY LEN(bot_agent) DESC';

                                break;

                                case 'firebird':

                                        $sql = 'SELECT user_id, bot_agent, bot_ip

                                                FROM ' . BOTS_TABLE . '

                                                WHERE bot_active = 1

                                        ORDER BY CHAR_LENGTH(bot_agent) DESC';

                                break;

                                // LENGTH supported by MySQL, IBM DB2 and Oracle for sure...

                                default:

                                        $sql = 'SELECT user_id, bot_agent, bot_ip

                                                FROM ' . BOTS_TABLE . '

                                                WHERE bot_active = 1

                                        ORDER BY LENGTH(bot_agent) DESC';

                                break;

                        }

                        $result = $db->sql_query($sql);

                        $bots = array();

                        while ($row = $db->sql_fetchrow($result))

                        {

                                $bots[] = $row;

                        }

                        $db->sql_freeresult($result);

                        $this->put('_bots', $bots);

                }

                return $bots;

        }

        /**

        * Obtain cfg file data

        */

        function obtain_cfg_items($theme)

        {

                global $config, $phpbb_root_path;

                $parsed_items = array(

                        'theme'                => array(),

                        'template'        => array(),

                        'imageset'        => array()

                );

                foreach ($parsed_items as $key => $parsed_array)

                {

                        $parsed_array = $this->get('_cfg_' . $key . '_' . $theme[$key . '_path']);

                        if ($parsed_array === false)

                        {

                                $parsed_array = array();

                        }

                        $reparse = false;

                        $filename = $phpbb_root_path . 'styles/' . $theme[$key . '_path'] . '/' . $key . '/' . $key . '.cfg';

                        if (!file_exists($filename))

                        {

                                continue;

                        }

                        if (!isset($parsed_array['filetime']) || (($config['load_tplcompile'] && @filemtime($filename) > $parsed_array['filetime'])))

                        {

                                $reparse = true;

                        }

                        // Re-parse cfg file

                        if ($reparse)

                        {

                                $parsed_array = parse_cfg_file($filename);

                                $parsed_array['filetime'] = @filemtime($filename);

                                $this->put('_cfg_' . $key . '_' . $theme[$key . '_path'], $parsed_array);

                        }

                        $parsed_items[$key] = $parsed_array;

                }

                return $parsed_items;

        }

        /**

        * Obtain disallowed usernames

        */

        function obtain_disallowed_usernames()

        {

                if (($usernames = $this->get('_disallowed_usernames')) === false)

                {

                        global $db;

                        $sql = 'SELECT disallow_username

                                FROM ' . DISALLOW_TABLE;

                        $result = $db->sql_query($sql);

                        $usernames = array();

                        while ($row = $db->sql_fetchrow($result))

                        {

                                $usernames[] = str_replace('%', '.*?', preg_quote(utf8_clean_string($row['disallow_username']), '#'));

                        }

                        $db->sql_freeresult($result);

                        $this->put('_disallowed_usernames', $usernames);

                }

                return $usernames;

        }

        /**

        * Obtain hooks...

        */

        function obtain_hooks()

        {

                global $phpbb_root_path, $phpEx;

                if (($hook_files = $this->get('_hooks')) === false)

                {

                        $hook_files = array();

                        // Now search for hooks...

                        $dh = @opendir($phpbb_root_path . 'includes/hooks/');

                        if ($dh)

                        {

                                while (($file = readdir($dh)) !== false)

                                {

                                        if (strpos($file, 'hook_') === 0 && substr($file, -(strlen($phpEx) + 1)) === '.' . $phpEx)

                                        {

                                                $hook_files[] = substr($file, 0, -(strlen($phpEx) + 1));

                                        }

                                }

                                closedir($dh);

                        }

                        $this->put('_hooks', $hook_files);

                }

                return $hook_files;

        }

}

?>