<?php

/**
 * MyBBIntegrator - The integration class for MyBB and your website
 *
 * The MyBBIntegrator is a useful collection of variables and functions for easy MyBB integration
 * into the own website
 *
 * @author: David Olah (aka PHPDave - http://phpdave.com)
 * @version 1.3.1
 * @date July 2010
 * @copyright Copyright (c) 2009, David Olah
 *
 *
 *
 *  This program is free software: you can redistribute it and/or modify
 *  it under the terms of the GNU General Public License as published by
 *  the Free Software Foundation, either version 3 of the License, or
 *  (at your option) any later version.

 *  This program is distributed in the hope that it will be useful,
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *  GNU General Public License for more details.

 *  You should have received a copy of the GNU General Public License
 *  along with this program.  If not, see <http://www.gnu.org/licenses/>.

*/

class MyBBIntegrator
{
    /**
     * Cache Handler of MyBB
     *
     * @var object
    */
    var $cache;

    /**
     * Config Data of MyBB
     *
     * @var array
    */
    var $config;

    /**
     * Database Handler of MyBB
     *
     * @var object
    */
    var $db;

    /**
     * MyBB Super Variable containing a whole lot of information
     *
     * @var object
    */
    var $mybb;

    /**
     * MyBB's Post Parser
     *
     * @var object
    */
    var $parser;

    /**
     * Shows a message for errors occuring in this class.
     * Afterwards it stops the script
     *
     * @param string $message The error message
    */
    function _errorAndDie($message)
    {
        echo '<div style="width:92%; margin:4px auto; border:1px #DDD solid; background:#F1F1F1; padding:5px; color:#C00; font-weight:bold;">An error occured during script run.<br />'.$message.'</div>';
        die;
    }

    /**
     * Let's see if the correct password is given for a forum!
     * Possible Todo: Pass passowrds in an array for defining passwords for parent categories (so far this only works when parent foums have same pass)
     *
     * @param integer $forum_id ID of Forum
     * @param string $password Wow, what might this be??
     * @return boolean
    */
    function checkForumPassword($forum_id, $password = '', $pid = 0)
    {
        global $forum_cache;

        if(!is_array($forum_cache))
        {
            $forum_cache = cache_forums();
            if(!$forum_cache)
            {
                return false;
            }
        }

        // Loop through each of parent forums to ensure we have a password for them too
        $parents = explode(',', $forum_cache[$fid]['parentlist']);
        rsort($parents);
        if(!empty($parents))
        {
            foreach($parents as $parent_id)
            {
                if($parent_id == $forum_id || $parent_id == $pid)
                {
                    continue;
                }

                if($forum_cache[$parent_id]['password'] != "")
                {
                    if (!$this->checkForumPassword($parent_id, $password))
                    {
                        return false;
                    }
                }

            }
        }

        $forum_password = $forum_cache[$forum_id]['password'];

        // A password is required
        if ($forum_password)
        {
            if (empty($password))
            {
                if (!$this->mybb->cookies['forumpass'][$forum_id] || ($this->mybb->cookies['forumpass'][$forum_id] && md5($this->mybb->user['uid'].$forum_password) != $this->mybb->cookies['forumpass'][$forum_id]))
                {
                    return false;
                }
                else
                {
                    return true;
                }
            }
            else
            {
                if ($forum_password == $password)
                {
                    $this->setCookie('forumpass['.$forum_id.']', md5($this->mybb->user['uid'].$password), NULL, true);
                    return true;
                }
                else
                {
                    return false;
                }
            }
        }
        else
        {
            return true;
        }
    }

    /**
     * Enables you to close one or more threads
     * One thread: $thread_id is int
     * More threads: $thread_id is array with ints
     *
     * @param integer|array $thread_id See above
     * @param integer $forum_id This can be filled for a nice moderator log!
     * @return boolean
    */
    function closeThread($thread_id, $forum_id = 0)
    {
        if (!is_moderator($fid, "canopenclosethreads"))
        {
            return false;
        }

        $this->lang->load('moderation');

        $this->MyBBIntegratorClassObject('moderation', 'Moderation', MYBB_ROOT.'/inc/class_moderation.php');

        $this->moderation->close_threads($thread_id);

        $modlogdata['fid'] = $forum_id;

        $this->logModeratorAction($modlogdata, $this->lang->mod_process);

        return true;
    }

    /**
     * Insert a new Category into Database
     *
     * @param array $data Array with keys according to database layout, which holds the data of the forum
     * @param array $permissions Array with Permission entries (structure: array( 'canview' => array( 'usergroupid' => 1 ) )) (an example)
     * @param array $default_permissions Array which defines, if default permissions shall be used (structure: array( usergroupid => 0 / 1 )
     *                                   Can be left empty, then this function will take care of it
     * @return $data with more values, like fid and parentlist
    */
    function createCategory($data, $permissions = array(), $default_permissions = array())
    {
        require_once MYBB_ADMIN_DIR.'inc/functions.php';

        if (!isset($data['name']))
        {
            $this->_errorAndDie('A new forum needs to have a name and a type');
        }

        $data['type'] = 'c';

        // Let's leave the parentlist creation to the script and let's not trust the dev :)
        if ($data['parentlist'] != '')
        {
            $data['parentlist'] = '';
        }

        // If there is no defined Parent ID, parent ID will be set to 0
        if (!isset($data['pid']) || $data['pid'] < 0)
        {
            $data['pid'] = 0;
        }
        else
        {
            $data['pid'] = intval($data['pid']);
        }

        if (!empty($permissions))
        {
            if (
                (!isset($permissions['canview']) || empty($permissions['canview'])) ||
                (!isset($permissions['canpostthreads']) || empty($permissions['canpostthreads'])) ||
                (!isset($permissions['canpostreplys']) || empty($permissions['canpostreplys'])) ||
                (!isset($permissions['canpostpolls']) || empty($permissions['canpostpolls'])) ||
                (!isset($permissions['canpostattachments']) || empty($permissions['canpostattachments']))
               )
            {
                $this->_errorAndDie('The $permissions Parameter does not have the correct format. It requires following keys: <i>canview, canpostthreads, canpostreplys, canpostpolls and canpostattachments</i>');
            }

            /**
             * If no default permissions are given, we will initiate them, default: yes
             * Since there is the possibility of additional usergroups, we will get the usergroups from the permissions array!
             * The structure of the inherit array is: keys = groupid
             * If the value of an inherit array item is 1, this means that the default_permissions shall be used
            */
            if (empty($default_permissions))
            {
                foreach ($permissions['canview'] as $gid)
                {
                    $default_permissions[$gid] = 1;
                }
            }
        }

        $data['fid'] = $this->db->insert_query("forums", $data);

        $data['parentlist'] = make_parent_list($data['fid']);
        $this->db->update_query("forums", array("parentlist" => $data['parentlist']), 'fid=\''.$data['fid'].'\'');

        $this->cache->update_forums();

        if (!empty($permissions))
        {
            $inherit = $default_permissions;

            /**
             * $permissions['canview'][1] = 1 OR $permissions['canview'][1] = 0
             * --> $permissions[$name][$gid] = yes / no
            */

            $canview = $permissions['canview'];
            $canpostthreads = $permissions['canpostthreads'];
            $canpostpolls = $permissions['canpostpolls'];
            $canpostattachments = $permissions['canpostattachments'];
            $canpostreplies = $permissions['canpostreplys'];
            save_quick_perms($data['fid']);
        }

        return $data;
    }

    /**
     * Insert a new Forum into Database
     *
     * @param array $data Array with keys according to database layout, which holds the data of the forum
     * @param array $permissions Array with Permission entries (structure: array( 'canview' => array( 'usergroupid' => 1 ) )) (an example)
     * @param array $default_permissions Array which defines, if default permissions shall be used (structure: array( usergroupid => 0 / 1 )
     *                                   Can be left empty, then this function will take care of it
     * @return $data with more values, like fid and parentlist
    */
    function createForum($data, $permissions = array(), $default_permissions = array())
    {
        require_once MYBB_ADMIN_DIR.'inc/functions.php';

        if (!isset($data['name']))
        {
            $this->_errorAndDie('A new forum needs to have a name and a type');
        }

        $data['type'] = 'f';

        // Let's leave the parentlist creation to the script and let's not trust the dev :)
        if ($data['parentlist'] != '')
        {
            $data['parentlist'] = '';
        }

        // If there is no defined Parent ID, parent ID will be set to 0
        if (!isset($data['pid']) || $data['pid'] < 0)
        {
            $data['pid'] = 0;
        }
        else
        {
            $data['pid'] = intval($data['pid']);
        }

        if (!empty($permissions))
        {
            if (
                (!isset($permissions['canview']) || empty($permissions['canview'])) ||
                (!isset($permissions['canpostthreads']) || empty($permissions['canpostthreads'])) ||
                (!isset($permissions['canpostreplys']) || empty($permissions['canpostreplys'])) ||
                (!isset($permissions['canpostpolls']) || empty($permissions['canpostpolls'])) ||
                (!isset($permissions['canpostattachments']) || empty($permissions['canpostattachments']))
               )
            {
                $this->_errorAndDie('The $permissions Parameter does not have the correct format. It requires following keys: <i>canview, canpostthreads, canpostreplys, canpostpolls and canpostattachments</i>');
            }

            /**
             * If no default permissions are given, we will initiate them, default: yes
             * Since there is the possibility of additional usergroups, we will get the usergroups from the permissions array!
             * The structure of the inherit array is: keys = groupid
             * If the value of an inherit array item is 1, this means that the default_permissions shall be used
            */
            if (empty($default_permissions))
            {
                foreach ($permissions['canview'] as $gid)
                {
                    $default_permissions[$gid] = 1;
                }
            }
        }

        $data['fid'] = $this->db->insert_query("forums", $data);

        $data['parentlist'] = make_parent_list($data['fid']);
        $this->db->update_query("forums", array("parentlist" => $data['parentlist']), 'fid=\''.$data['fid'].'\'');

        $this->cache->update_forums();

        if (!empty($permissions))
        {
            $inherit = $default_permissions;

            /**
             * $permissions['canview'][1] = 1 OR $permissions['canview'][1] = 0
             * --> $permissions[$name][$gid] = yes / no
            */

            $canview = $permissions['canview'];
            $canpostthreads = $permissions['canpostthreads'];
            $canpostpolls = $permissions['canpostpolls'];
            $canpostattachments = $permissions['canpostattachments'];
            $canpostreplies = $permissions['canpostreplys'];
            save_quick_perms($data['fid']);
        }

        return $data;
    }

    /**
     * Create a new poll and assign it to a thread
     * Taken frm polls.php
     *
     * @param integer $thread_id ID of Thread where the poll should be assigned to
     * @param array $data The Data
    */
    function createPoll($thread_id, $data)
    {
        // Required keys in data array: options, question
        if (!isset($data['options']) || !isset($data['question']))
        {
            $this->_errorAndDie('One or more required array keys in parameter <i>$data</i> missing. Required keys are: <i>options</i>, <i>question</i>');
        }

        $this->lang->load('polls');

        $this->plugins->run_hooks("polls_do_newpoll_start");

        $query = $this->db->simple_select("threads", "*", "tid='".(int) $thread_id."'");
        $thread = $this->db->fetch_array($query);
        $fid = $thread['fid'];
        $forumpermissions = forum_permissions($fid);

        if (!$thread['tid'])
        {
            return $this->lang->error_invalidthread;
        }
        // No permission if: Not thread author; not moderator; no forum perms to view, post threads, post polls
        if (($thread['uid'] != $this->mybb->user['uid'] && !is_moderator($fid)) || ($forumpermissions['canview'] == 0 || $forumpermissions['canpostthreads'] == 0 || $forumpermissions['canpostpolls'] == 0))
        {
            return false;
        }

        if ($thread['poll'])
        {
            return $this->lang->error_pollalready;
        }

        $polloptions = count($data['options']);
        if($this->mybb->settings['maxpolloptions'] && $polloptions > $this->mybb->settings['maxpolloptions'])
        {
            $polloptions = $this->mybb->settings['maxpolloptions'];
        }

        if (!isset($data['postoptions']))
        {
            $data['postoptions'] = array('multiple', 'public');
        }

        $postoptions = $data['postoptions'];

        if ($postoptions['multiple'] != '1')
        {
            $postoptions['multiple'] = 0;
        }

        if ($postoptions['public'] != '1')
        {
            $postoptions['public'] = 0;
        }

        if ($polloptions < 2)
        {
            $polloptions = "2";
        }

        $optioncount = "0";

        $options = $data['options'];

        for($i = 0; $i < $polloptions; ++$i)
        {
            if (trim($options[$i]) != "")
            {
                $optioncount++;
            }

            if (my_strlen($options[$i]) > $this->mybb->settings['polloptionlimit'] && $this->mybb->settings['polloptionlimit'] != 0)
            {
                $lengtherror = 1;
                break;
            }
        }

        if ($lengtherror)
        {
            return $this->lang->error_polloptiontoolong;
        }

        if (empty($data['question']) || $optioncount < 2)
        {
            return $this->lang->error_noquestionoptions;
        }

        $optionslist = '';
        $voteslist = '';
        for($i = 0; $i < $optioncount; ++$i)
        {
            if(trim($options[$i]) != '')
            {
                if($i > 0)
                {
                    $optionslist .= '||~|~||';
                    $voteslist .= '||~|~||';
                }
                $optionslist .= $options[$i];
                $voteslist .= '0';
            }
        }

        if (!isset($data['timeout']))
        {
            $data['timeout'] = 0;
        }

        if($data['timeout'] > 0)
        {
            $timeout = intval($data['timeout']);
        }
        else
        {
            $timeout = 0;
        }

        $newpoll = array(
            "tid" => $thread['tid'],
            "question" => $this->db->escape_string($data['question']),
            "dateline" => TIME_NOW,
            "options" => $this->db->escape_string($optionslist),
            "votes" => $this->db->escape_string($voteslist),
            "numoptions" => intval($optioncount),
            "numvotes" => 0,
            "timeout" => $timeout,
            "closed" => 0,
            "multiple" => $postoptions['multiple'],
            "public" => $postoptions['public']
        );

        $this->plugins->run_hooks("polls_do_newpoll_process");

        $pid = $this->db->insert_query("polls", $newpoll);

        $this->db->update_query("threads", array('poll' => $pid), "tid='".$thread['tid']."'");

        $this->plugins->run_hooks("polls_do_newpoll_end");

        return true;
    }

    /**
     * Insert a new post into Database
     *
     * @param array $data Post Data
     * @return array|string When true it will return an array with postID and status of being visible - false = error array or inline string
    */
    function createPost($data, $inline_errors = true)
    {
        require_once MYBB_ROOT.'inc/functions_post.php';
        require_once MYBB_ROOT.'/inc/datahandlers/post.php';
        $posthandler = new PostDataHandler('insert');

        $this->plugins->run_hooks('newreply_do_newreply_start');

        $posthandler->set_data($data);

        if (!$posthandler->validate_post())
        {
            $errors = $posthandler->get_friendly_errors();
            return ($inline_errors === true) ? inline_error($errors) : $errors;
        }

        $this->plugins->run_hooks('newreply_do_newreply_end');

        return $posthandler->insert_post();
    }

    /**
     * Inserts a thread into the database
     *
     * @param array $data Thread data
     * @param boolean $inline_errors Defines if we want a formatted error string or an array
     * @return array|string
     * @return array|string When true it will return an array with threadID, postID and status of being visible - false = error array or inline string
    */
    function createThread($data, $inline_errors = true)
    {
        require_once MYBB_ROOT.'inc/functions_post.php';
        require_once MYBB_ROOT.'/inc/datahandlers/post.php';
        $posthandler = new PostDataHandler('insert');
        $posthandler->action = 'thread';
        $posthandler->set_data($data);
        if (!$posthandler->validate_thread())
        {
            $errors = $posthandler->get_friendly_errors();
            return ($inline_errors === true) ? inline_error($errors) : $errors;
        }
        return $posthandler->insert_thread();
    }

    /**
     * Insert a new user into Database
     *
     * @param array $data User data
     * @param boolean $inline_errors Defines if we want a formatted error string or an array
     * @return array|string When true it will return an array with some user data - false = error array or inline string
    */
    function createUser($data, $inline_errors = true)
    {
        require_once MYBB_ROOT.'inc/functions_user.php';
        require_once MYBB_ROOT.'/inc/datahandlers/user.php';
        $userhandler = new UserDataHandler('insert');

        $this->plugins->run_hooks('admin_user_users_add');

        $userhandler->set_data($data);

        if (!$userhandler->validate_user())
        {
            $errors = $userhandler->get_friendly_errors();
            return ($inline_errors === true) ? inline_error($errors) : $errors;
        }

        $this->plugins->run_hooks('admin_user_users_add_commit');

        return $userhandler->insert_user();
    }

    /**
     * Escapes a value for DB usage
     *
     * @param mixed $value Any value to use with the database
     * @return string
    */
    function dbEscape($value)
    {
        return $this->db->escape_string($value);
    }

    /**
     * Remove a poll
     * Taken from moderation.php
     *
     * @param integer $poll_id ID of Poll to be deleted
     * @return boolean|string
    */
    function deletePoll($poll_id)
    {
        $this->lang->load('moderation');

        $this->MyBBIntegratorClassObject('moderation', 'Moderation', MYBB_ROOT.'/inc/class_moderation.php');

        $query = $this->db->simple_select("polls", "*", "pid='$poll_id'");
        $poll = $this->db->fetch_array($query);
        if(!$poll['pid'])
        {
            return $this->lang->error_invalidpoll;
        }

        $thread = $this->getThread($poll['tid']);

        if(!is_moderator($thread['fid'], "candeleteposts"))
        {
            if($permissions['candeletethreads'] != 1 || $this->mybb->user['uid'] != $thread['uid'])
            {
                return false;
            }
        }

        $modlogdata = array();
        $modlogdata['tid'] = $poll['tid'];

        $this->plugins->run_hooks("moderation_do_deletepoll");

        $this->lang->poll_deleted = $this->lang->sprintf($this->lang->poll_deleted, $thread['subject']);
        $this->logModeratorAction($modlogdata, $this->lang->poll_deleted);

        $this->moderation->delete_poll($poll['pid']);

        return true;
    }

    /**
     * Delete the poll of a thread
     * Taken from moderation.php
     *
     * @param integer $thread_id Thread-ID where the poll is located
     * @return boolean|string
    */
    function deletePollOfThread($thread_id)
    {
        $this->lang->load('polls');
        $this->lang->load('moderation');

        $this->MyBBIntegratorClassObject('moderation', 'Moderation', MYBB_ROOT.'/inc/class_moderation.php');

        $thread = $this->getThread($thread_id);
        $permissions = forum_permissions($thread['fid']);

        if (!is_moderator($thread['fid'], "candeleteposts"))
        {
            if($permissions['candeletethreads'] != 1 || $this->mybb->user['uid'] != $thread['uid'])
            {
                return false;
            }
        }

        $query = $this->db->simple_select("polls", "*", "tid='$thread_id'");
        $poll = $this->db->fetch_array($query);
        if(!$poll['pid'])
        {
            return $this->lang->error_invalidpoll;
        }

        $modlogdata = array();
        $modlogdata['tid'] = $poll['tid'];

        $this->plugins->run_hooks("moderation_do_deletepoll");

        $this->lang->poll_deleted = $this->lang->sprintf($this->lang->poll_deleted, $thread['subject']);
        $this->logModeratorAction($modlogdata, $this->lang->poll_deleted);

        $this->moderation->delete_poll($poll['pid']);

        return true;
    }

    /**
     * Flag private messages as deleted
     *
     * @param integer|array $pm_id ID(s) of Private Messages (many IDs require an array)
    */
    function deletePrivateMessage($pm_id)
    {
        require_once MYBB_ROOT.'inc/functions_user.php';

        $this->plugins->run_hooks('private_delete_start');

        $data = array(
            'folder' => 4,
            'deletetime' => TIME_NOW
        );

        if (is_array($pm_id))
        {
            $this->db->update_query('privatemessages', $data, 'pmid IN ('.implode(',', array_map('intval', $pm_id)).')');
        }
        else
        {
            $this->db->update_query('privatemessages', $data, 'pmid = '.intval($pm_id));
        }

        update_pm_count();

        $this->plugins->run_hooks('private_delete_end');

    }

    /**
     * Flag all private messages of a user as deleted
     * It is also possible to flag pms as deleted of multiple users, when paramater is an array with IDs
     *
     * @param integer|array $pm_id ID(s) of User IDs (many IDs require an array)
    */
    function deletePrivateMessagesOfUser($user_id)
    {
        require_once MYBB_ROOT.'inc/functions_user.php';

        $this->plugins->run_hooks('private_delete_start');

        $data = array(
            'folder' => 4,
            'deletetime' => TIME_NOW
        );

        if (is_array($user_id))
        {
            $this->db->update_query('privatemessages', $data, 'uid IN ('.implode(',', array_map('intval', $user_id)).')');
        }
        else
        {
            $this->db->update_query('privatemessages', $data, 'uid = '.intval($user_id));
        }

        update_pm_count();

        $this->plugins->run_hooks('private_delete_end');
    }

    /**
     * Generates a Captcha
     *
     * @return array
    */
    function generateCaptcha()
    {
        $randomstr = random_str(5);
        $imagehash = md5(random_str(12));
        $imagearray = array(
            "imagehash" => $imagehash,
            "imagestring" => $randomstr,
            "dateline" => TIME_NOW
        );
        $this->db->insert_query("captcha", $imagearray);
        return array_merge($imagearray, array(
            'captcha' => '<img src="'.$this->mybb->settings['bburl'].'/captcha.php?imagehash='.$imagehash.'" />'
        ));
    }

    /**
     * Generates a posthash
     *
     * @param integer $user_id User-ID
     * @return string MD5
    */
    function generatePosthash($user_id = 0)
    {
        mt_srand((double) microtime() * 1000000);
        if ($user_id == 0)
        {
            return md5($this->mybb->user['uid'].mt_rand());
        }
        else
        {
            return md5($user_id.mt_rand());
        }
    }

    /**
     * Get the Hottest Threads within a defined timespan
     *
     * @param integer $timespan The timespan you want to use for fetching the hottest topics (in seconds)
     * @param string $post_sort_order Sort Order to the posts you are fetching (ordered by the dateline)
     * @param string $postamount_sort_order Sort order of the threads (ordered by the amount of posts)
     * @return array
    */
    function getBusyThreadsWithinTimespan($timespan = 86400, $post_sort_order = 'DESC', $postamount_sort_order = 'DESC')
    {
        $threads = array();

        // Make sure the parameters have correct values
        $post_sort_order = ($post_sort_order == 'DESC') ? 'DESC' : 'ASC';
        $postamount_sort_order = ($postamount_sort_order == 'DESC') ? 'DESC' : 'ASC';

        $query = $this->db->query('
            SELECT p.`pid`, p.`message`, p.`uid` as postuid, p.`username` as postusername, p.`dateline`,
                   t.`tid`, t.`fid`, t.`subject`, t.`uid` as threaduid, t.`username` as threadusername, t.`lastpost`, t.`lastposter`, t.`lastposteruid`, t.`views`, t.`replies`
            FROM '.TABLE_PREFIX.'posts p
            INNER JOIN '.TABLE_PREFIX.'threads t ON t.`tid` = p.`tid`
            WHERE p.`dateline` >= '.(TIME_NOW - $timespan).'
            ORDER BY p.`dateline` '.$post_sort_order.'
        ');

        while ($post = $this->db->fetch_array($query))
        {
            /**
             * The return array we are building is being filled with the thread itself, but also with the posts
             * We will later increase the Postamount, so we can sort it
            */
            if (!isset($threads[$post['tid']]))
            {
                $threads[$post['tid']] = array(
                    'tid' => $post['tid'],
                    'fid' => $post['fid'],
                    'subject' => $post['subject'],
                    'uid' => $post['threaduid'],
                    'username' => $post['threadusername'],
                    'lastpost' => $post['lastpost'],
                    'lastposter' => $post['lastposter'],
                    'lastposteruid' => $post['lastposteruid'],
                    'views' => $post['views'],
                    'replies' => $post['replies'],
                    'postamount' => 1,
                    'posts' => array()
                );

                // The first run of one thread also brings a post, so we assign this post
                $threads[$post['tid']]['posts'][] = array(
                    'pid' => $post['pid'],
                    'message' => $post['message'],
                    'uid' => $post['postuid'],
                    'username' => $post['postusername'],
                    'dateline' => $post['dateline']
                );
            }
            else
            {
                // The thread array key exists already, so we increment the postamount and save another post
                $threads[$post['tid']]['postamount']++;
                $threads[$post['tid']]['posts'][] = array(
                    'pid' => $post['pid'],
                    'message' => $post['message'],
                    'uid' => $post['postuid'],
                    'username' => $post['postusername'],
                    'dateline' => $post['dateline']
                );
            }
        }

        // Sort function for ascending posts
        function arraySortByPostamountASC($item1, $item2)
        {
            if ($item1['postamount'] == $item2['postamount'])
            {
                return 0;
            }

            if ($item1['postamount'] > $item2['postamount'])
            {
                return 1;
            }
            else
            {
                return -1;
            }
        }

        // Sort function for descending posts
        function arraySortByPostamountDESC($item1, $item2)
        {
            if ($item1['postamount'] == $item2['postamount'])
            {
                return 0;
            }

            if ($item1['postamount'] > $item2['postamount'])
            {
                return -1;
            }
            else
            {
                return 1;
            }
        }

        // Let's sort the threads now
        usort($threads, 'arraySortByPostamount'.$postamount_sort_order);

        return $threads;
    }

    /**
     * Returns data of a specified forum
     * Refers to: inc/functions.php
     *
     * @param integer $forum_id ID of forum to fetch data from
     * @param integer $active_override If set to 1, will override the active forum status
     * @return array|boolean If unsuccessful, it returns false - Otherwise the Database row
    */
    function getForum($forum_id, $active_override = 0)
    {
        $forum = get_forum($forum_id, $active_override);

        // Do we have permission?
        $forumpermissions = forum_permissions($forum['fid']);
        if ($forumpermissions['canview'] != 1 || $forumpermissions['canviewthreads'] != 1)
        {
            // error_no_permission();
            return false;
        }
        else
        {
            return $forum;
        }
    }

    /**
     * Return members of the board with administrative function
     * Taken from /showteam.php
     *
     * @return array
    */
    function getForumStaff()
    {
        $this->lang->load('showteam');

        $usergroups = array();
        $moderators = array();
        $users = array();

        // Fetch the list of groups which are to be shown on the page
        $query = $this->db->simple_select("usergroups", "gid, title, usertitle", "showforumteam=1", array('order_by' => 'disporder'));

        while($usergroup = $this->db->fetch_array($query))
        {
            $usergroups[$usergroup['gid']] = $usergroup;
        }

        if (empty($usergroups))
        {
            return $this->lang->error_noteamstoshow;
        }

        // Fetch specific forum moderator details
        if ($usergroups[6]['gid'])
        {
            $query = $this->db->query("
                SELECT m.*, f.name
                FROM ".TABLE_PREFIX."moderators m
                LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=m.uid)
                LEFT JOIN ".TABLE_PREFIX."forums f ON (f.fid=m.fid)
                WHERE f.active = 1
                ORDER BY u.username
            ");

            while($moderator = $this->db->fetch_array($query))
            {
                $moderators[$moderator['uid']][] = $moderator;
            }
        }

        // Now query the users of those specific groups
        $groups_in = implode(",", array_keys($usergroups));
        $users_in = implode(",", array_keys($moderators));
        if (!$groups_in)
        {
            $groups_in = 0;
        }
        if (!$users_in)
        {
            $users_in = 0;
        }

        $forum_permissions = forum_permissions();

        $query = $this->db->simple_select("users", "uid, username, displaygroup, usergroup, ignorelist, hideemail, receivepms", "displaygroup IN ($groups_in) OR (displaygroup='0' AND usergroup IN ($groups_in)) OR uid IN ($users_in)", array('order_by' => 'username'));

        while ($user = $this->db->fetch_array($query))
        {
            // If this user is a moderator
            if (isset($moderators[$user['uid']]))
            {
                foreach ($moderators[$user['uid']] as $forum)
                {
                    if ($forum_permissions[$forum['fid']]['canview'] == 1)
                    {
                        $forum_url = get_forum_link($forum['fid']);
                    }
                }
                $usergroups[6]['user_list'][$user['uid']] = $user;
            }

            if ($user['displaygroup'] == '6' || $user['usergroup'] == '6')
            {
                $usergroups[6]['user_list'][$user['uid']] = $user;
            }

            // Are they also in another group which is being shown on the list?
            if ($user['displaygroup'] != 0)
            {
                $group = $user['displaygroup'];
            }
            else
            {
                $group = $user['usergroup'];
            }

            if ($usergroups[$group] && $group != 6)
            {
                $usergroups[$group]['user_list'][$user['uid']] = $user;
            }
        }

        return $usergroups;
    }

    /**
     * Return the latest threads of one forum, where a post has been posted
     *
     * @param integer $forum_id Forum ID to fetch threads from
     * @param integer $limit Amount of threads to get
     * @param boolean $excluse_invisible Shall we also get invisible threads?
     * @return array
    */
    function getLatestActiveThreads($forum_id = 0, $limit = 7, $exclude_invisible = true)
    {
        if ($forum_id == 0)
        {
            $this->_errorAndDie('Specified forum ID cannot be 0!');
        }
        else
        {
            // Do we have permission?
            $forumpermissions = forum_permissions($forum_id);
            if ($forumpermissions['canview'] != 1 || $forumpermissions['canviewthreads'] != 1)
            {
                // error_no_permission();
                return false;
            }
        }

        // This will be the array, where we can save the threads
        $threads = array();

        // We want to get a list of threads, starting with the newest one
        $query_params = array(
            'order_by' => 'lastpost',
            'order_dir' => 'DESC',
            'limit' => intval($limit)
        );

        /**
         * If defined forum id is 0, we do not fetch threads from only one forum,
         * but we fetch the latest threads of all forums
         * Therefore we add the forum_id in the where condition
         * We only fetch visible threads, if there is anything we want to hide ;)
         * However we can also define that we want the invisible threads as well
        */
        $fetch_invisible_threads = ($exclude_invisible == true) ? '1' : '0';
        $condition = ($forum_id != 0) ? ' `visible` = '.$fetch_invisible_threads.' AND `fid` = '.intval($forum_id) : '';

        // Run the Query
        $query = $this->db->simple_select('threads', '*', $condition, $query_params);

        // Now let's iterate through the fetched threads to create the return array
        while ($thread = $this->db->fetch_array($query))
        {
            $threads[] = $thread;
        }

        return $threads;
    }

    /**
     * Return newly created threads, regardless of replies
     *
     * @param integer|array $forum_id Forum ID / Forum IDs to fetch threads from
     * @param string $fields Name of fields if you want to fetch specific fields
     * @param integer $limit Amount of threads to get
     * @param boolean $excluse_invisible Shall we also get invisible threads?
     * @param boolean $join_forums Shall we also get the information from the forums where the threads are located in?
     * @param boolean $join_first_post Shall we get the first post of this thread as well?
     * @return array
    */
    function getLatestThreads($forum_id = 0, $fields = '*', $limit = 7, $exclude_invisible = true, $join_forums = true, $join_first_post = true)
    {
        if ($forum_id != 0)
        {
            // If we have multiple values, we have to check permission for each forum!
            if (is_array($forum_id))
            {
                foreach ($forum_id as $single_forum_id)
                {
                    $forum_permissions = forum_permissions($single_forum_id);
                    if ($forum_permissions['canview'] != 1 || $forum_permissions['canviewthreads'] != 1)
                    {
                        // error_no_permission();
                        return false;
                    }
                }
            }
            else
            {
                // Do we have permission?
                $forumpermissions = forum_permissions($forum_id);
                if ($forumpermissions['canview'] != 1 || $forumpermissions['canviewthreads'] != 1)
                {
                    // error_no_permission();
                    return false;
                }
            }
        }

        // This is what we will be returning
        $threads = array();

        // Do we want to get invisible threads as well?
        $fetch_invisible_threads = ($exclude_invisible == true) ? '1' : '0';
        $condition = 't.`visible` = '.$fetch_invisible_threads;

        // Are we fetching threads from multiple forums?
        if (is_array($forum_id) || is_object($forum_id))
        {
            $condition .= ' AND t.`fid` IN ('.implode(', ', $forum_id).')';

        }
        // Or are we just fetching threads from one forum?
        else
        {
            $condition .= ($forum_id == 0) ? '' : ' AND t.`fid` = '.$forum_id;
        }

        // Do we want to get information of the forum where the thread is located in?
        $forum_join = ($join_forums == true) ? 'INNER JOIN '.TABLE_PREFIX.'forums f ON f.`fid` = t.`fid`' : '';

        // Do we want to get the first post from the thread?
        $first_post_join = ($join_first_post == true) ? 'INNER JOIN '.TABLE_PREFIX.'posts p ON p.`pid` = t.`firstpost`' : '';

        // Run the Query
        $query = $this->db->query('
            SELECT '.$fields.'
            FROM '.TABLE_PREFIX.'threads t
            '.$forum_join.'
            '.$first_post_join.'
            WHERE '.$condition.'
            ORDER BY t.`dateline` DESC
            LIMIT '.intval($limit).'
        ');

        // Iterate through the results and assign it to our returning array
        while ($thread = $this->db->fetch_array($query))
        {
            $threads[] = $thread;
        }

        return $threads;
    }

    /**
     * Return recently posted posts
     *
     * @param integer|array Either a single Thread ID or an array containing thread IDs
     * @param string Fields, which shall be fetched from the posts table
     * @param integer How many posts shall be fetched?
     * @param boolean Shall we also return invisible ones?
     * @return array
    */
    function getLatestPosts($thread_id = 0, $fields = '*', $limit = 7, $exclude_invisible = true)
    {
        // Posts will be stored in this array
        $posts = array();

        // Posts will be returned in descending order, starting with the newest
        $query_params = array(
            'order_by' => 'dateline',
            'order_dir' => 'DESC',
            'limit' => intval($limit)
        );

        // We want to fetch posts from multiple threads
        if (is_array($thread_id) || is_object($thread_id))
        {
            // Multiple threads = IN (...) Operator
            $condition = '`fid` IN ('.implode(', ', $thread_id).')';
        }
        else
        {
            // Single thread = normal WHERE X = Y - if set 0 we fetch posts from all threads
            $condition = ($thread_id == 0) ? '1 = 1' : '`fid` = '.intval($thread_id);
        }

        /**
         * If defined forum id is 0, we do not fetch threads from only one forum,
         * but we fetch the latest threads of all forums
         * Therefore we add the forum_id in the where condition
         * We only fetch visible threads, if there is anything we want to hide ;)
         * However we can also define that we want the invisible threads as well
        */
        $fetch_invisible_threads = ($exclude_invisible == true) ? '1' : '0';
        $condition .= ' AND `visible` = '.$fetch_invisible_threads;

        // Run the Query
        $query = $this->db->simple_select('posts', $fields, $condition, $query_params);

        // Now let's iterate through the fetched posts to create the return array
        while ($post = $this->db->fetch_array($query))
        {
            $posts[] = $post;
        }

        return $posts;
    }

    /**
     * Retrieve member list
     * Ideal to offer a multi-page member list
     *
     * @param array $data Contains data affecting the member query - List of Array keys below
     *                    - orderby: What table column will the member list be sorted by?
     *                    - orderdir: Ascending or Descending order direction
     *                    - perpage: Amount of members to fetch (set 0 for all members)
     *                    - letter: Beginning character of member name
     *                    - username: Searching for a matching username
     *                    - username_match: Set this to "begins" when username shall being with given token - otherwise it goes or "contains"
     *                    - website: String contained in website
     *                    - aim: Search for an AIM
     *                    - icq: Search for an ICQ number
     *                    - msn: Search for a MSN ID
     *                    - yahoo: Search for a Yahoo ID
     *                    - page: Which page of the list will we be retrieving
     * @return array
    */
    function getMembers($data = array())
    {
        /**
         *  Make sure we have initial values in the data array
        */

        $data['orderby'] = (!isset($data['orderby'])) ? 'u.`username`' : $data['orderby'];
        $data['orderdir'] = (!isset($data['orderdir'])) ? 'ASC' : strtoupper($data['orderdir']);
        $data['orderdir'] = ($data['orderdir'] == 'ASC') ? 'ASC' : 'DESC';
        $data['perpage'] = (!isset($data['perpage'])) ? (int) $this->mybb->settings['membersperpage'] : (int) $data['perpage'];
        $data['letter'] = (!isset($data['letter'])) ? '' : $data['letter'];
        $data['username'] = (!isset($data['username'])) ? '' : $data['username'];
        $data['username_match'] = (!isset($data['username_match'])) ? 'begins' : $data['username_match'];
        $data['website'] = (!isset($data['website'])) ? '' : $data['website'];
        $data['aim'] = (!isset($data['aim'])) ? '' : $data['aim'];
        $data['icq'] = (!isset($data['icq'])) ? '' : $data['icq'];
        $data['msn'] = (!isset($data['msn'])) ? '' : $data['msn'];
        $data['yahoo'] = (!isset($data['yahoo'])) ? '' : $data['yahoo'];
        $data['page'] = (!isset($data['page'])) ? 1 : (int) $data['page'];

        /**
         * Let's build the DB query now!
        */

        $sql_where = 'WHERE 1 = 1';

        // Username begins with a letter or number
        if (strlen($data['letter']) == 1)
        {
            $data['letter'] = chr(ord($data['letter']));
            // Letter is 0: Shall start with number
            if ($data['letter'] == '0')
            {
                $sql_where .= " AND u.`username` NOT REGEXP('[a-zA-Z]')";
            }
            // letter is not 0, so it will be fetching names according to first char
            else
            {
                $sql_where .= " AND u.`username` LIKE '".$this->db->escape_string($data['letter'])."%'";
            }
        }

        // Search for matching username
        if (strlen($data['username']) > 0)
        {
            $data['username'] = htmlspecialchars_uni($data['username']);
            if ($data['username_match'] == 'begins')
            {
                $sql_where .= " AND u.`username` LIKE '".$this->db->escape_string_like($data['username'])."%'";
            }
            else
            {
                $sql_where .= " AND u.`username` LIKE '%".$this->db->escape_string_like($data['username'])."%'";
            }
        }

        // Search for website
        if (strlen($data['website']) > 0)
        {
            $data['website'] = trim(htmlspecialchars_uni($data['website']));
            $sql_where .= " AND u.`website` LIKE '%".$this->db->escape_string_like($data['website'])."%'";
        }

        // Search for AIM
        if (strlen($data['aim']) > 0)
        {
            $sql_where .= " AND u.`aim` LIKE '%".$this->db->escape_string_like($data['aim'])."%'";
        }

        // Search for ICQ
        if (strlen($data['icq']) > 0)
        {
            $sql_where .= " AND u.`icq` LIKE '%".$this->db->escape_string_like($data['icq'])."%'";
        }

        // Search for MSN
        if (strlen($data['msn']) > 0)
        {
            $sql_where .= " AND u.`msn` LIKE '%".$this->db->escape_string_like($data['msn'])."%'";
        }

        // Search for Yahoo
        if (strlen($data['yahoo']) > 0)
        {
            $sql_where .= " AND u.`yahoo` LIKE '%".$this->db->escape_string_like($data['yahoo'])."%'";
        }

        // Build the LIMIT-part of the query here
        if ($data['perpage'] == 0)
        {
            $limit_string = '';
        }
        else
        {
            if ($data['page'] > 0)
            {
                $limit_string = 'LIMIT '.(($data['page'] - 1) * $data['perpage']).', '.$data['perpage'];
            }
            else
            {
                $limit_string = 'LIMIT '.$data['perpage'];
            }
        }

        $sql .= '
            SELECT u.*, f.*
            FROM '.TABLE_PREFIX.'users u
            LEFT JOIN '.TABLE_PREFIX.'userfields f ON f.`ufid` = u.`uid`
            '.$sql_where.'
            ORDER BY '.$data['orderby'].' '.$data['orderdir'].'
            '.$limit_string.'
        ';

        $query = $this->db->query($sql);

        $arr = array();

        while ($member = $this->db->fetch_array($query))
        {
            $arr[] = $member;
        }

        return $arr;
    }

    /**
     * Read some info about a poll
     *
     * @param integer $poll_id ID of Poll to fetch infos from
     * @return array
    */
    function getPoll($poll_id)
    {
        if ($poll_id == 0)
        {
            $this->_errorAndDie('Specified poll ID cannot be 0!');
        }

        $query = $this->db->query('
            SELECT *
            FROM '.TABLE_PREFIX.'polls
            WHERE `pid` = '.(int) $poll_id.'
            LIMIT 1
        ');

        $poll = $this->db->fetch_array($query);

        $separator = '||~|~||';

        $poll['optionsarray'] = explode($separator, $poll['options']);
        $poll['votesarray'] = explode($separator, $poll['votes']);

        /**
         * At this point we are doing another query, so it is easier
         * Little Todo: Include an INNER JOIN in the initial Poll-fetching query to save one query
         * YOu have to make sure that columns of "thread" won't override columns of "poll"
         * Therefore the solution right now at hand will be sufficient, until people start to moan :)
        */
        $poll['thread'] = $this->getThread($poll['tid']);

        $poll['whovoted'] = $this->getWhoVoted($poll_id);

        return $poll;
    }

    /**
     * Returns post data of specified post
     * Refers to: inc/functions.php & inc/class_parser.php
     *
     * @param integer $post_id Post ID to fetch data from
     * @param boolean $parsed Shall the Post message be parsed?
     * @param array $parse_options Array of yes/no options - allow_html,filter_badwords,allow_mycode,allow_smilies,nl2br,me_username
     * @param array $override_forum_parse_options Whether parse options should be defined by forum or by the script.
                                                    If they are being overridden, the array will contain the options
     * @return array|boolean: If unsuccessful, it returns false - Otherwise the Database row
    */
    function getPost($post_id, $parsed = false, $override_forum_parse_options = array())
    {
        if ($post_id == 0)
        {
            $this->_errorAndDie('Specified post ID cannot be 0!');
        }

        // Get the Post data
        $post = get_post($post_id);

        // Post not found? --> False
        if (empty($post))
        {
            return false;
        }

        // Do we have permission?
        $forumpermissions = forum_permissions($post['fid']);
        if ($forumpermissions['canview'] != 1 || $forumpermissions['canviewthreads'] != 1)
        {
            // error_no_permission();
            return false;
        }

        // If the post shall not be parsed, we can already return it at this point
        if ($parsed == false || empty($post))
        {
            return $post;
        }

        // So we want to parse the message

        /**
         * We don't want to override the parse options defined by the forum,
         * so we have first to get these options defined for the forum
        */
        if (count($override_forum_parse_options) == 0)
        {
            // Get the Forum data according to the forum id stored with the post
            $forum = $this->getForum($post['fid']);

            // Set up the parser options.
            $parser_options = array(
                "allow_html" => $forum['allowhtml'],
                "allow_mycode" => $forum['allowmycode'],
                "allow_smilies" => $forum['allowsmilies'],
                "allow_imgcode" => $forum['allowimgcode'],
                "filter_badwords" => 1
            );

        }
        else
        {
            // Self-defined options given in the function parameter
            $parser_options = array(
                'allow_html' => (isset($override_forum_parse_options['allow_html']) && $override_forum_parse_options['allow_html'] == 1) ? 1 : 0,
                'allow_mycode' => (isset($override_forum_parse_options['allow_mycode']) && $override_forum_parse_options['allow_mycode'] == 1) ? 1 : 0,
                'allow_smilies' => (isset($override_forum_parse_options['allow_smilies']) && $override_forum_parse_options['allow_smilies'] == 1) ? 1 : 0,
                'allow_imgcode' => (isset($override_forum_parse_options['allow_imgcode']) && $override_forum_parse_options['allow_imgcode'] == 1) ? 1 : 0,
                'filter_badwords' => (isset($override_forum_parse_options['filter_badwords']) && $override_forum_parse_options['filter_badwords'] == 1) ? 1 : 0,
            );
        }

        // Overwrite the message with the parsed message
        $post['message'] = $this->parser->parse_message($post['message'], $parser_options);

        return $post;
    }

    /**
     * Get posts which match the given criteria
     *
     * @param array $params Parameters for the query
     * @return array
    */
    function getPosts($params = array('fields' => '*', 'order_by' => 'dateline', 'order_dir' => 'DESC', 'limit_start' => 0, 'limit' => 0, 'where' => ''))
    {
        // We will store the posts in here
        $posts = array();

        // No matter what parameters will be given, the query starts with the following
        $sql = 'SELECT '.$params['fields'].'
                FROM '.TABLE_PREFIX.'posts';

        // Get all posts or just (hopefully) posts which match certain criteria?
        $sql .= ($params['where'] != '') ? ' WHERE '.$params['where'] : '';

        // Are the posts going to be ordered by a field?
        if ($params['order_by'] != '')
        {
            $sql .= ' ORDER BY '.$params['order_by'];
            if ($params['order_dir'] != '')
            {
                $sql .= ' '.$params['order_dir'];
            }
            else
            {
                $sql .= ' ASC';
            }
        }

        // Get all posts or (hopefully) just a few?
        if ($params['limit'] != 0)
        {
            $sql .= ' LIMIT ';
            if (isset($params['limit_start']))
            {
                $sql .= $params['limit_start'].', '.$params['limit'];
            }
            else
            {
                $sql .= $params['limit'];
            }
        }

        // Run the query
        $query = $this->db->query($sql);

        // Store the returned data in the array we return
        while ($post = $this->db->fetch_array($query))
        {
            $posts[] = $post;
        }

        return $posts;
    }

    /**
     * Get the Posts of a particular thread
     *
     * @param integer $thread_id
     * @param string $fields If you want to fetch certain fields, define them as a string here (separated by comma)
     * @param array $options Options for the query [ array('limit_start', 'limit', 'orderby', 'order_dir') ]
     * @return array
    */
    function getPostsOfThread($thread_id, $fields = '*', $options = array())
    {
        // This is what we will be returning
        $arr = array();

        $query_thread = $this->db->query('SELECT `fid` FROM '.TABLE_PREFIX.'threads WHERE `tid` = '.intval($thread_id).' LIMIT 1');
        $thread_forumid = $this->db->fetch_field($query_thread, 'fid');

        // Do we have permission?
        $forumpermissions = forum_permissions($thread_forumid);
        if ($forumpermissions['canview'] != 1 || $forumpermissions['canviewthreads'] != 1)
        {
            // error_no_permission();
            return false;
        }

        // Let's request the posts from the database
        $query = $this->db->simple_select('posts', $fields, '`tid` = '.intval($thread_id), $options);

        // All we need to do now is to assign them to our returning array
        while ($post = $this->db->fetch_array($query))
        {
            $arr[] = $post;
        }

        return $arr;
    }

    /**
     * Read the messages from database of a user
     *
     * @param integer $user_id ID of user
     * @param array $params Array with options for SQL Query (orderby, sort)
     * @param boolean $translate_folders If the folders should be turned into readable format ŕ la "inbox"
     * @return array
    */
    function getPrivateMessagesOfUser($user_id, $params = array('orderby' => 'pm.dateline', 'sort' => 'DESC'), $translate_folders = true)
    {
        /**
         * This is what we will be returning
         * Structure of the array to return:
         * array(
         *    'Inbox' => array( ... Messages ... )
         * )
         *
         * 'Inbox' is the translated folder of folder #1
        */
        $arr = array();

        // If we want to translate the folder names, we need to include the file which contains the translation function
        if ($translate_folders == true)
        {
            include_once MYBB_ROOT.'inc/functions_user.php';
        }

        // Run the Query for Private Messages
        $query = $this->db->query('
            SELECT pm.*, fu.username AS fromusername, tu.username as tousername
            FROM '.TABLE_PREFIX.'privatemessages pm
            LEFT JOIN '.TABLE_PREFIX.'users fu ON (fu.uid=pm.fromid)
            LEFT JOIN '.TABLE_PREFIX.'users tu ON (tu.uid=pm.toid)
            WHERE pm.uid = '.intval($user_id).'
            ORDER BY '.$params['orderby'].' '.$params['sort'].'
        ');

        // Do we have messages?
        if ($this->db->num_rows($query) > 0)
        {
            // Uhh, let's iterate the messages!
            while ($message = $this->db->fetch_array($query))
            {
                // If we translate the folder names, our array index will be the translated folder name
                if ($translate_folders == true)
                {
                    $arr[get_pm_folder_name($message['folder'])][] = $message;
                }
                // If we don't want translated folder names, our array index will be the folder number
                else
                {
                    $arr[$message['folder']][] = $message;
                }
            }
        }

        return $arr;
    }

    /**
     * Returns data of a specified thread
     * Refers to: inc/functions.php
     *
     * @param integer $thread_id ID of the thread to fetch data from
     * @return array|boolean If unsuccessful, it returns false - Otherwise the Database row
    */
    function getThread($thread_id)
    {
        $thread = get_thread($thread_id);

        // Do we have permission?
        $forumpermissions = forum_permissions($thread['fid']);
        if ($forumpermissions['canview'] != 1 || $forumpermissions['canviewthreads'] != 1)
        {
            // error_no_permission();
            return false;
        }
        else
        {
            return $thread;
        }
    }

    /**
     * Get Threads of one or more forums
     *
     * @param integer $forum_id IDs of Forums to fetch threads from
     * @param string $fields If you want to fetch certain fields, define a string with them
     * @param string $where Additional WHERE constellation if needed
     * @pararm array $query_params Parameters for the Query to run in the database
                                   (order_by, order_dir, limit_start, limit [limit will only be acknowledged if both limit vars are defined])
     * @param boolean $excluse_invisible Shall we get invisible threads too?
     * @param boolean $join_forums Do we also want to get the forum information of where the threads are located?
     * @param boolean $join_first_post Shall we get the first post of the thread? (= initial post)
     * @return array
    */
    function getThreads($forum_id, $fields = '*', $where = '', $query_params = array('order_by' => 't.`subject`', 'order_dir' => 'ASC'), $exclude_invisible = true, $join_forums = false, $join_first_post = false)
    {
        // Do we have permission?
        if (!is_array($forum_id))
        {
            $forumpermissions = forum_permissions($forum_id);
            if ($forumpermissions['canview'] != 1 || $forumpermissions['canviewthreads'] != 1)
            {
                // error_no_permission();
                return false;
            }
        }
        else
        {
            // Check for every single forum
            foreach ($forum_id as $forum_id_single)
            {
                $forumpermissions = forum_permissions($forum_id_single);
                if ($forumpermissions['canview'] != 1 || $forumpermissions['canviewthreads'] != 1)
                {
                    // error_no_permission();
                    return false;
                }
            }
        }

        // This is what we will be returning
        $threads = array();

        // Do we want to get invisible threads as well?
        $fetch_invisible_threads = ($exclude_invisible == true) ? '1' : '0';
        $condition = 't.`visible` = '.$fetch_invisible_threads;

        // Are we fetching threads from multiple forums?
        if (is_array($forum_id))
        {
            $condition .= ' AND t.`fid` IN ('.implode(', ', $forum_id).')';
        }
        // Or are we just fetching threads from one forum?
        else
        {
            $condition .= ($forum_id == 0) ? '' : ' AND t.`fid` = '.$forum_id;
        }

        // An additional WHERE clause has been added
        if ($where != '')
        {
            $condition .= ' AND '.$where;
        }

        // Do we want to get information of the forum where the thread is located in?
        $forum_join = ($join_forums == true) ? 'INNER JOIN '.TABLE_PREFIX.'forums f ON f.`fid` = t.`fid`' : '';

        // Do we want to get the first post from the thread?
        $first_post_join = ($join_first_post == true) ? 'INNER JOIN '.TABLE_PREFIX.'posts p ON p.`pid` = t.`firstpost`' : '';

        // Is a Limit defined?
        $limit = (isset($query_params['limit_start']) && isset($query_params['limit'])) ? 'LIMIT '.intval($query_params['limit_start']).', '.intval($query_params['limit']) : '';

        // Run the Query
        $query = $this->db->query('
            SELECT '.$fields.'
            FROM '.TABLE_PREFIX.'threads t
            '.$forum_join.'
            '.$first_post_join.'
            WHERE '.$condition.'
            ORDER BY '.$query_params['order_by'].' '.$query_params['order_dir'].'
            '.$limit.'
        ');

        // Iterate through the results and assign it to our returning array
        while ($thread = $this->db->fetch_array($query))
        {
            $threads[] = $thread;
        }

        return $threads;
    }

    /**
     * Return array with unread threads of a forum
     *
     * @param integer $forum_id
     * @return array
    */
    function getUnreadThreadsOfForum($forum_id)
    {
        $threads = $this->getThreads($forum_id);
        $tids = array();
        // Thread array keys shall be thread IDs
        foreach ($threads as $key => $thread)
        {
            $tids[] = $thread['tid'];
            $threads[$thread['tid']] = $thread;
            unset($threads[$key]);
        }
        $tids = implode(',', $tids);
        $query = $this->db->simple_select("threadsread", "*", "uid='{$this->mybb->user['uid']}' AND tid IN ({$tids})");
        while ($readthread = $this->db->fetch_array($query))
        {
            // Dateline of checking forum is past of last activity - so we delete the entry in array
            if ($readthread['dateline'] > $threads[$readthread['tid']]['lastpost'])
            {
                unset($threads[$readthread['tid']]);
            }
        }
        return $threads;
    }

    /**
     * Returns data of a user
     * Refers to: inc/functions.php
     *
     * @param integer $user_id ID of User to fetch data from (0 = own user)
     * @return array
    */
    function getUser($user_id = 0)
    {
        // If given user id is 0, we use the own User ID
        if ($user_id == 0)
        {
            return get_user($this->mybb->user['uid']);
        }
        // Otherwise we fetch info from given User ID
        else
        {
            return get_user($user_id);
        }
    }

    /**
     * Fetch the users being online
     * Refers to: index.php
     *
     * @param boolean $colored_usernames Define if we want to return formatted usernames (color)
     * @return array
    */
    function getWhoIsOnline($colored_usernames = true)
    {
        // This is what we are going to return
        $arr = array(
            'bots' => array(),
            'count_anonymous' => 0,
            'count_bots' => 0,
            'count_guests' => 0,
            'count_members' => 0,
            'members' => array()
        );

        // We only fetch the Who's Online list if the setting tells us that we can
        if($this->mybb->settings['showwol'] != 0 && $this->mybb->usergroup['canviewonline'] != 0)
        {
            // Get the online users.
            $timesearch = TIME_NOW - $this->mybb->settings['wolcutoff'];
            $comma = '';
            $query = $this->db->query("
                SELECT s.sid, s.ip, s.uid, s.time, s.location, s.location1, u.username, u.invisible, u.usergroup, u.displaygroup
                FROM ".TABLE_PREFIX."sessions s
                LEFT JOIN ".TABLE_PREFIX."users u ON (s.uid=u.uid)
                WHERE s.time>'$timesearch'
                ORDER BY u.username ASC, s.time DESC
            ");

            // Iterated users will be stored here to prevent double iterating one user
            $doneusers = array();

            // Fetch spiders
            $spiders = $this->cache->read("spiders");

            // Loop through all users.
            while($user = $this->db->fetch_array($query))
            {
                // Create a key to test if this user is a search bot.
                $botkey = my_strtolower(str_replace("bot=", '', $user['sid']));

                // Decide what type of user we are dealing with.
                if($user['uid'] > 0)
                {
                    // The user is registered.
                    if($doneusers[$user['uid']] < $user['time'] || !$doneusers[$user['uid']])
                    {
                        // If the user is logged in anonymously, update the count for that.
                        if($user['invisible'] == 1)
                        {
                            ++$arr['count_anonymous'];
                        }

                        if($user['invisible'] != 1 || $this->mybb->usergroup['canviewwolinvis'] == 1 || $user['uid'] == $this->mybb->user['uid'])
                        {
                            // Maybe we don't want colored usernames
                            if ($colored_usernames == true)
                            {
                                // Properly format the username and assign the template.
                                $user['username'] = format_name($user['username'], $user['usergroup'], $user['displaygroup']);
                            }

                            $user['profilelink'] = build_profile_link($user['username'], $user['uid']);
                        }

                        // This user has been handled.
                        $doneusers[$user['uid']] = $user['time'];

                        // Add the user to the members, since he is registered and logged in
                        $arr['members'][]= $user;

                        // Increase member counter
                        ++$arr['count_members'];
                    }
                }

                // The user is a search bot.
                elseif(my_strpos($user['sid'], "bot=") !== false && $spiders[$botkey])
                {
                    ++$arr['count_bots'];
                    $arr['bots'][] = $spiders[$botkey];
                }

                // The user is a guest
                else
                {
                    ++$arr['count_guests'];
                }
            }
        }

        return $arr;
    }

    /**
     * Return members which have posted in a thread
     *
     * @param integer $thread_id ID of Thread
     * @return array|false
    */
    function getWhoPosted($thread_id, $sort_by_posts = true)
    {
        $thread = $this->getThread($thread_id); // No need to check for permissions, the function already does it
        $forum = $this->getForum($thread['fid']); // No need to check for permissions, the function already does it
        if (!$this->checkForumPassword($forum['fid']))
        {
            return false;
        }
        if($sort_by_posts === true)
        {
            $sort_sql = ' ORDER BY posts DESC';
        }
        else
        {
            $sort_sql = ' ORDER BY p.username ASC';
        }
        $query = $this->db->query('
            SELECT COUNT(p.pid) AS posts, p.username AS postusername, u.uid, u.username, u.usergroup, u.displaygroup
            FROM '.TABLE_PREFIX.'posts p
            LEFT JOIN '.TABLE_PREFIX.'users u ON (u.uid=p.uid)
            WHERE tid='.intval($thread_id).' AND p.visible = 1
            GROUP BY u.uid
            '.$sortsql.'
        ');
        $i = 0;
        $arr = array();
        $arr['total_posts'] = 0;
        while ($poster = $this->db->fetch_array($query))
        {
            if($poster['username'] == '')
            {
                $poster['username'] = $poster['postusername'];
            }
            $poster_name = format_name($poster['username'], $poster['usergroup'], $poster['displaygroup']);
            $arr[$i]['username']= $poster['username'];
            $arr[$i]['profile_link'] = build_profile_link($poster_name, $poster['uid'], '_blank', $onclick);
            $arr[$i]['posts'] = $poster['posts'];
            ++$i;
            $arr['total_posts'] += $poster['posts'];
        }
        return $arr;
    }

    /**
     * Returns users which have voted in a poll
     *
     * @param integer $poll_id ID of Poll
     * @return array
    */
    function getWhoVoted($poll_id)
    {
        if ($poll_id == 0)
        {
            $this->_errorAndDie('Specified post ID cannot be 0!');
        }

        $query = $this->db->query('
            SELECT pv.`vid`, pv.`uid`, pv.`voteoption`, pv.`dateline`,
                   u.`username`, u.`usergroup`, u.`displaygroup`
            FROM '.TABLE_PREFIX.'pollvotes pv
            LEFT JOIN '.TABLE_PREFIX.'users u ON u.`uid` = pv.`uid`
            WHERE pv.`pid` = '.(int) $poll_id.'
        ');

        $arr = array();
        $i = 0;
        while ($voter = $this->db->fetch_array($query))
        {
            $voter_name = format_name($voter['username'], $voter['usergroup'], $voter['displaygroup']);
            $arr[$i] = array(
                'vid' => $voter['vid'],
                'username' => $voter['username'],
                'profile_link' => build_profile_link($voter_name, $voter['uid'], '_blank', $onclick),
                'voteoption' => $voter['voteoption'],
                'dateline' => $voter['dateline']
            );
            ++$i;
        }

        return $arr;
    }

    /**
     * Increases the Amount of Views of a thread
     *
     * @param integer $thread_id ID of Thread
    */
    function incViews($thread_id)
    {
        // All we do here is to run the increment query
        $this->db->query('
            UPDATE '.TABLE_PREFIX.'threads
            SET `views` = `views` + 1
            WHERE `tid` = '.intval($thread_id).'
        ');
    }

    /**
     * Is the user logged in?
     *
     * @return boolean
    */
    function isLoggedIn()
    {
        // If the user is logged in, he has an UID
        return ($this->mybb->user['uid'] != 0) ? true : false;
    }

    /**
     * Is the user a moderator?
     * This function checks if the user has certain rights to perform an action in a forum
     * Refers to: inc/functions.php
     *
     * @param integer $forum_id ID of the forum to check permissions for
     * @param string $action Action which shall be checked for
     * @param integer $user_id ID of User
    */
    function isModerator($forum_id = 0, $action = '', $user_id = 0)
    {
        // If we aren't logged in, we cannot possibly a moderator
        if ($this->isLoggedIn())
        {
            return false;
        }

        // If given user_id is 0 we tak the user_id of the current user --> Check if own user is mod
        return is_moderator($forum_id, $action, ($user_id == 0) ? $this->mybb->user['uid'] : $user_id);
    }

    /**
     * Returns if a user has super admin permission
     * Refers to: inc/functions.php
     *
     * @param integer $user_id User-ID
     * @return boolean
    */
    function isSuperAdmin($user_id = 0)
    {
        // If specified user_id is 0, we want to know if current user is Super Admin
        return is_super_admin(($user_id == 0) ? $this->mybb->user['uid'] : $user_id);
    }

    /**
     * Login procedure for a user + password
     * Possible ToDo: Return error messages / array / whatever
     *
     * @param string $username Username
     * @param string $password Password of User
     * @return boolean
    */
    function login($username, $password, $captcha_hash = '', $captcha_string = '')
    {
        $this->lang->load('member');

        /**
         * If we are already logged in, we do not have to perform the login procedure
         * However, we can make believe that the login did succeed
         * It certainly did a while ago ;)
        */
        if ($this->isLoggedIn())
        {
            return true;
        }

        // by default, login is good!
        $bad_login = false;

        /**
         * Let's see how many logins we have already tried
        */
        $logins = login_attempt_check(NON_FATAL);

        // We need a few functions from the user function collection for the login procedur
        require_once MYBB_ROOT.'inc/functions_user.php';

        // If the username does not exist, login fails
        if (!username_exists($username))
        {
            my_setcookie('loginattempts', $logins + 1);
            return false;
        }

        /**
         * Let's get a database version of the login attempts
         * Previous login attempt call relied on cookies
        */
        $query = $this->db->simple_select("users", "loginattempts", "LOWER(username)='".$this->db->escape_string(my_strtolower($username))."'", array('limit' => 1));
        $loginattempts = $this->db->fetch_field($query, "loginattempts");

        // Let's call the handy MyBB validation function and see if we find a user
        $user = validate_password_from_username($username, $password);
        if (!$user['uid'])
        {
            my_setcookie('loginattempts', $logins + 1);
            $this->db->write_query("UPDATE ".TABLE_PREFIX."users SET `loginattempts` = `loginattempts` + 1 WHERE LOWER(`username`) = '".$this->db->escape_string(my_strtolower($username))."'");
            $bad_login = true;
        }

        /**
         * Possible ToDo:
         * If we have had more than 3 login attemps a captcha is shown in MyBB
         * Maybe provide the same functionality in MyBBIntegrator ?
        */
        if ($loginattempts > 3 || intval($mybb->cookies['loginattempts']) > 3)
        {
            // Captcha input is given, let's validate the captcha and see if we can login
            if (!empty($captcha_hash) && !empty($captcha_string))
            {
                if (!$this->validateCaptcha($captcha_hash, $captcha_string) || $bad_login === true)
                {
                    return $this->generateCaptcha();
                }
            }
            else
            {
                // Show captcha image for guests if enabled
                if ($this->mybb->settings['captchaimage'] == 1 && function_exists("imagepng") && !$this->mybb->user['uid'])
                {
                    return $this->generateCaptcha();
                }
            }
        }
        else
        {
            if ($bad_login === true)
            {
                return false;
            }
        }

        // COPPA users always fail :D
        if ($user['coppauser'])
        {
            return false;
        }

        // Reset both login attempts counter (cookie + database)
        my_setcookie('loginattempts', 1);
        $this->db->update_query("users", array("loginattempts" => 1), "uid='{$user['uid']}'");

        // Delete old session entry
        $this->db->delete_query("sessions", "ip='".$this->db->escape_string($this->mybb->session->ipaddress)."' AND sid != '".$this->mybb->session->sid."'");

        // Create a new session and save it in the database
        $newsession = array(
            "uid" => $user['uid'],
        );
        $this->db->update_query("sessions", $newsession, "sid='".$this->mybb->session->sid."'");

        // Temporarily set the cookie remember option for the login cookies
        $this->mybb->user['remember'] = $user['remember'];

        // Set essential login cookies
        my_setcookie("mybbuser", $user['uid']."_".$user['loginkey'], null, true);
        my_setcookie("sid", $this->mybb->session->sid, -1, true);

        // If there are hooks defined for the end of the login procedure, call them
        $this->plugins->run_hooks("member_do_login_end");

        return true;
    }

    /**
     * Logs an administrator action taking any arguments as log data.
     * Taken from admin/inc/functions.php
     *
     * NEEDS MODULE AND ACTION AS PARAMS! DONT FORGET TO PUT THIS INTO DOCUMENTATION
     */
    function logAdminAction()
    {
        $data = func_get_args();

        if(count($data) == 1 && is_array($data[0]))
        {
            $data = $data[0];
        }

        if(!is_array($data))
        {
            $data = array($data);
        }

        $log_entry = array(
            "uid" => $this->mybb->user['uid'],
            "ipaddress" => $this->db->escape_string(get_ip()),
            "dateline" => TIME_NOW,
            "module" => $this->db->escape_string($this->mybb->input['module']),
            "action" => $this->db->escape_string($this->mybb->input['action']),
            "data" => $this->db->escape_string(@serialize($data))
        );

        $this->db->insert_query("adminlog", $log_entry);
    }

    /**
     * Log an action taken by a user with moderator rights
     *
     * @param array $data Data array with information necessary to pass onto the log
     * @param string $action Name of the action
    */
    function logModeratorAction($data, $action = '')
    {
        // If the fid or tid is not set, set it at 0 so MySQL doesn't choke on it.
        if($data['fid'] == '')
        {
            $fid = 0;
        }
        else
        {
            $fid = $data['fid'];
            unset($data['fid']);
        }

        if($data['tid'] == '')
        {
            $tid = 0;
        }
        else
        {
            $tid = $data['tid'];
            unset($data['tid']);
        }

        // Any remaining extra data - we serialize and insert in to its own column
        if(is_array($data))
        {
            $data = serialize($data);
        }

        $sql_array = array(
            "uid" => $this->mybb->user['uid'],
            "dateline" => TIME_NOW,
            "fid" => $fid,
            "tid" => $tid,
            "action" => $this->db->escape_string($action),
            "data" => $this->db->escape_string($data),
            "ipaddress" => $this->db->escape_string($this->session->ipaddress)
        );
        $this->db->insert_query("moderatorlog", $sql_array);
    }

    /**
     * Logout procedure
     *
     * @return boolean
    */
    function logout()
    {
        // If the user is not logged in at all, we make him believe that the logout procedure workedjust fine
        if (!$this->isLoggedIn())
        {
            return true;
        }

        // Check session ID if we have one
        if($this->mybb->input['sid'] && $this->mybb->input['sid'] != $this->mybb->session->sid)
        {
            return false;
        }
        // Otherwise, check logoutkey
        else if (!$this->mybb->input['sid'] && $this->mybb->input['logoutkey'] != $this->mybb->user['logoutkey'])
        {
            return false;
        }

        // Clear essential login cookies
        my_unsetcookie("mybbuser");
        my_unsetcookie("sid");

        // The logged in user data will be updated
        if($this->mybb->user['uid'])
        {
            $time = TIME_NOW;
            $lastvisit = array(
                "lastactive" => $time-900,
                "lastvisit" => $time,
            );
            $this->db->update_query("users", $lastvisit, "uid='".$this->mybb->user['uid']."'");
            $this->db->delete_query("sessions", "sid='".$this->mybb->session->sid."'");
        }

        // If there are any hooks to run, we call them here
        $this->plugins->run_hooks("member_logout_end");

        return true;
    }

    /**
     * Marks one or more forums read
     *
     * @param integer $forum_id If Forum ID is set to 0 all forums will be marked as read
     * @param string $redirect_url If there should be a redirection afterwards, define the URL here
     * @return boolean Only returns false if it fails, otherwise, if it does not redirect, it returns true
    */
    function markRead($id = 0, $redirect_url = '')
    {
        // "Mark-Read" functions are located in inc/functions_indicators.php
        require_once MYBB_ROOT."/inc/functions_indicators.php";

        // Make sure the ID is a number
        $id = intval($id);

        // If the given Forum ID is 0, it tells us that we shall mark all forums as read
        if ($id == 0)
        {
            mark_all_forums_read();

            // If we want to redirect to an url, we do so
            if ($redirect_url != '')
            {
                redirect($redirect_url, $this->lang->redirect_markforumsread);
            }
        }

        // If a specific ID has been defined, we certainly want to mark ONE forum as read
        else
        {
            // Does the Forum exist?
            $validforum = $this->getForum($id);

            // If the forum is invalid, marking as read failed
            if (!$validforum)
            {
                return false;
            }

            // If we want to redirect to an url, we do so
            if ($redirect_url != '')
            {
                redirect($redirect_url, $this->lang->redirect_markforumsread);
            }
        }

        return true;
    }

    /**
     * Constructor
     * If we include the global.php of MyBB in the constructor,
     * weird error messages popup
     * --> This sounds like a ToDo: Find out why?????? - My guess: Some evil eval() functions
     *
     * @param object $mybb Pass the Super MyBB Object as a reference so we can work with it
     * @param object $db Pass the MyBB Database Handler as a reference so we can work with is
    */
    function MyBBIntegrator(&$mybb, &$db, &$cache, &$plugins, &$lang, &$config)
    {
        $this->mybb =& $mybb;
        $this->db =& $db;
        $this->cache = $cache;
        $this->plugins =& $plugins;
        $this->lang =& $lang;
        $this->config =& $config;

        define('MYBB_ADMIN_DIR', MYBB_ROOT.$this->config['admin_dir'].'/');

        // Some Constants for non-magic-numbers
        define('NON_FATAL', false);

        require_once MYBB_ROOT.'inc/class_parser.php';
        $this->parser = new postParser;
    }

    /**
     * This function creates a class object if it is necessary
     * This is needed, if we want to use classes, which are not included in the init routine of mybb (example: Moderation)
     *
     * @param string $object Name of the class object
     * @param string $class_name Name of the Class
     * @param string $include_path The Path where we can find the class
    */
    function MyBBIntegratorClassObject($object, $class_name, $include_path)
    {
        if (isset($this->{$object}))
        {
            return;
        }
        else
        {
            require_once $include_path;
            $this->{$object} = new $class_name;
        }
    }

    /**
     * Enables you to close one or more threads
     * One thread: $thread_id is int
     * More threads: $thread_id is array with ints
     *
     * @param integer|array $thread_id See above
     * @param integer $forum_id This can be filled for a nice moderator log!
     * @return boolean
    */
    function openThread($thread_id, $forum_id = 0)
    {
        if (!is_moderator($fid, "canopenclosethreads"))
        {
            return false;
        }

        $this->lang->load('moderation');

        $this->MyBBIntegratorClassObject('moderation', 'Moderation', MYBB_ROOT.'/inc/class_moderation.php');

        $this->moderation->open_threads($thread_id);

        $modlogdata['fid'] = $forum_id;

        $this->logModeratorAction($modlogdata, $this->lang->mod_process);

        return true;
    }

    /**
     * Parses a string/message with the MyBB Parser Class
     * Refers to: /inc/class_parser.php
     *
     * @param string $message The String which shall be parsed
     * @param array $options Options the parser can accept: filter_badwords, allow_html, allow_mycode, me_username, allow_smilies, nl2br,
     * @return string Parsed string
    */
    function parseString($message, $options = array())
    {
        // Set base URL for parsing smilies
        $base_url= $this->mybb->settings['bburl'];

        if($base_url!= "")
        {
            if(my_substr($base_url, my_strlen($base_url) -1) != "/")
            {
                $base_url= $base_url."/";
            }
        }

        $message = $this->plugins->run_hooks("parse_message_start", $message);

        // Get rid of cartridge returns for they are the workings of the devil
        $message = str_replace("\r", "", $message);

        // Filter bad words if requested.
        if($options['filter_badwords'])
        {
            $message = $this->parser->parse_badwords($message);
        }

        if($options['allow_html'] != 1)
        {
            $message = $this->parser->parse_html($message);
        }
        else
        {
            while(preg_match("#<script(.*)>(.*)</script(.*)>#is", $message))
            {
                $message = preg_replace("#<script(.*)>(.*)</script(.*)>#is", "&lt;script$1&gt;$2&lt;/script$3&gt;", $message);
            }
            // Remove these completely
            $message = preg_replace("#\s*<base[^>]*>\s*#is", "", $message);
            $message = preg_replace("#\s*<meta[^>]*>\s*#is", "", $message);
            $message = str_replace(array('<?php', '<!--', '-->', '?>', "<br />\n", "<br>\n"), array('&lt;?php', '&lt;!--', '--&gt;', '?&gt;', "\n", "\n"), $message);
        }

        // If MyCode needs to be replaced, first filter out [code] and [php] tags.
        if($options['allow_mycode'])
        {
            // First we split up the contents of code and php tags to ensure they're not parsed.
            preg_match_all("#\[(code|php)\](.*?)\[/\\1\](\r\n?|\n?)#si", $message, $code_matches, PREG_SET_ORDER);
            $message = preg_replace("#\[(code|php)\](.*?)\[/\\1\](\r\n?|\n?)#si", "<mybb-code>\n", $message);
        }

        // Always fix bad Javascript in the message.
        $message = $this->parser->fix_javascript($message);

        // Replace "me" code and slaps if we have a username
        if($options['me_username'])
        {
            $message = preg_replace('#(>|^|\r|\n)/me ([^\r\n<]*)#i', "\\1<span style=\"color: red;\">* {$options['me_username']} \\2</span>", $message);
            $message = preg_replace('#(>|^|\r|\n)/slap ([^\r\n<]*)#i', "\\1<span style=\"color: red;\">* {$options['me_username']} {$this->lang->slaps} \\2 {$this->lang->with_trout}</span>", $message);
        }

        // If we can, parse smilies
        if($options['allow_smilies'])
        {
            $message = $this->parser->parse_smilies($message, $options['allow_html']);
        }

        // Replace MyCode if requested.
        if($options['allow_mycode'])
        {
            $message = $this->parser->parse_mycode($message, $options);
        }

        // Run plugin hooks
        $message = $this->plugins->run_hooks("parse_message", $message);

        if($options['allow_mycode'])
        {
            // Now that we're done, if we split up any code tags, parse them and glue it all back together
            if(count($code_matches) > 0)
            {
                foreach($code_matches as $text)
                {
                    // Fix up HTML inside the code tags so it is clean
                    if($options['allow_html'] != 0)
                    {
                        $text[2] = $this->parser->parse_html($text[2]);
                    }

                    if(my_strtolower($text[1]) == "code")
                    {
                        $code = $this->parser->mycode_parse_code($text[2]);
                    }
                    elseif(my_strtolower($text[1]) == "php")
                    {
                        $code = $this->parser->mycode_parse_php($text[2]);
                    }
                    $message = preg_replace("#\<mybb-code>\n?#", $code, $message, 1);
                }
            }
        }

        if($options['nl2br'] !== 0)
        {
            $message = nl2br($message);
            // Fix up new lines and block level elements
            $message = preg_replace("#(</?(?:html|head|body|div|p|form|table|thead|tbody|tfoot|tr|td|th|ul|ol|li|div|p|blockquote|cite|hr)[^>]*>)\s*<br />#i", "$1", $message);
            $message = preg_replace("#(&nbsp;)+(</?(?:html|head|body|div|p|form|table|thead|tbody|tfoot|tr|td|th|ul|ol|li|div|p|blockquote|cite|hr)[^>]*>)#i", "$2", $message);
        }

        $message = my_wordwrap($message);

        $message = $this->plugins->run_hooks("parse_message_end", $message);

        return $message;
    }

    /**
     * Register procedure
     * Refers to: /member.php
     *
     * @param array $info Contains user information of the User to be registered
     * @return array|string If registration fails, we return an array containing the error message,
     *                      If registration is successful, we return the string, which notifies the user of what will be the next action
    */
    function register($info = array())
    {
        // Load the language phrases we need for the registration
        $this->lang->load('member');

        /**
         * $info contains the given user information for the registration
         * We need to make sure that every possible key is given, so we do not generate ugly E_NOIICE errors
        */
        $possible_info_keys = array(
            'username', 'password', 'password2', 'email', 'email2', 'referrer', 'timezone', 'language',
            'profile_fields', 'allownotices', 'hideemail', 'subscriptionmethod',
            'receivepms', 'pmnotice', 'emailpmnotify', 'invisible', 'dstcorrection'
        );

        // Iterate the possible info keys to create the array entry in $info if it does not exist
        foreach ($possible_info_keys as $possible_info_key)
        {
            if (!isset($info[$possible_info_key]))
            {
                $info[$possible_info_key] = '';
            }
        }

        // Run whatever hook specified at the beginning of the registration
        $this->plugins->run_hooks('member_do_register_start');

        // If register type is random password, we generate one
        if($this->mybb->settings['regtype'] == "randompass")
        {
            $info['password'] = random_str();
            $info['password2'] = $info['password'];
        }

        if($this->mybb->settings['regtype'] == "verify" || $this->mybb->settings['regtype'] == "admin" || $info['coppa'] == 1)
        {
            $usergroup = 5;
        }
        else
        {
            $usergroup = 2;
        }

        // Set up user handler.
        require_once MYBB_ROOT."inc/datahandlers/user.php";
        $userhandler = new UserDataHandler("insert");

        // Set the data for the new user.
        $user = array(
            "username" => $info['username'],
            "password" => $info['password'],
            "password2" => $info['password2'],
            "email" => $info['email'],
            "email2" => $info['email2'],
            "usergroup" => $usergroup,
            "referrer" => $info['referrername'],
            "timezone" => $info['timezone'],
            "language" => $info['language'],
            "profile_fields" => $info['profile_fields'],
            "regip" => $this->mybb->session->ipaddress,
            "longregip" => ip2long($this->mybb->session->ipaddress),
            "coppa_user" => intval($this->mybb->cookies['coppauser']),
        );

        if(isset($info['regcheck1']) && isset($info['regcheck2']))
        {
            $user['regcheck1'] = $info['regcheck1'];
            $user['regcheck2'] = $info['regcheck2'];
        }

        // Do we have a saved COPPA DOB?
        if($this->mybb->cookies['coppadob'])
        {
            list($dob_day, $dob_month, $dob_year) = explode("-", $this->mybb->cookies['coppadob']);
            $user['birthday'] = array(
                "day" => $dob_day,
                "month" => $dob_month,
                "year" => $dob_year
            );
        }

        // Generate the options array of the user
        $user['options'] = array(
            "allownotices" => $info['allownotices'],
            "hideemail" => $info['hideemail'],
            "subscriptionmethod" => $info['subscriptionmethod'],
            "receivepms" => $info['receivepms'],
            "pmnotice" => $info['pmnotice'],
            "emailpmnotify" => $info['emailpmnotify'],
            "invisible" => $info['invisible'],
            "dstcorrection" => $info['dstcorrection']
        );

        // Assign data to the data handler
        $userhandler->set_data($user);

        // If the validation of the user failed, we return nice (friendly) errors
        if(!$userhandler->validate_user())
        {
            $errors = $userhandler->get_friendly_errors();
            return $errors;
        }

        // Create the User in the database
        $user_info = $userhandler->insert_user();

        // We need to set a cookie, if we don't want a random password (and it is no COPPA user), so he is instantly logged in
        if($this->mybb->settings['regtype'] != "randompass" && !$this->mybb->cookies['coppauser'])
        {
            // Log them in
            my_setcookie("mybbuser", $user_info['uid']."_".$user_info['loginkey'], null, true);
        }

        /**
         * Coppa User
         * Nothing special, just return that the coppa user will be redirected
        */
        if($this->mybb->cookies['coppauser'])
        {
            $this->lang->redirect_registered_coppa_activate = $this->lang->sprintf($this->lang->redirect_registered_coppa_activate, $this->mybb->settings['bbname'], $user_info['username']);
            my_unsetcookie("coppauser");
            my_unsetcookie("coppadob");

            // Run whatever hook is defined at the end of a registration
            $this->plugins->run_hooks("member_do_register_end");

            return $this->lang->redirect_registered_coppa_activate;
        }

        /**
         * Register Mode: Email Verification
         * A mail is dispatched containing an activation link.
         * The activation link is a reference to the newly created database entry
        */
        else if($this->mybb->settings['regtype'] == "verify")
        {
            // Generate and save the activation code in the database
            $activationcode = random_str();
            $now = TIME_NOW;
            $activationarray = array(
                "uid" => $user_info['uid'],
                "dateline" => TIME_NOW,
                "code" => $activationcode,
                "type" => "r"
            );
            $this->db->insert_query("awaitingactivation", $activationarray);

            // Generate and send the email
            $emailsubject = $this->lang->sprintf($this->lang->emailsubject_activateaccount, $this->mybb->settings['bbname']);
            $emailmessage = $this->lang->sprintf($this->lang->email_activateaccount, $user_info['username'], $this->mybb->settings['bbname'], $this->mybb->settings['bburl'], $user_info['uid'], $activationcode);
            my_mail($user_info['email'], $emailsubject, $emailmessage);

            // Build the message to return
            $this->lang->redirect_registered_activation = $this->lang->sprintf($this->lang->redirect_registered_activation, $this->mybb->settings['bbname'], $user_info['username']);

            // Run whatever hook is defined at the end of a registration
            $this->plugins->run_hooks("member_do_register_end");

            return $this->lang->redirect_registered_activation;
        }

        /**
         * Register Mode: Send Random Password
         * A mail is dispatched, containing the random password for the user
        */
        else if($this->mybb->settings['regtype'] == "randompass")
        {
            // Generate and send the email
            $emailsubject = $this->lang->sprintf($this->lang->emailsubject_randompassword, $this->mybb->settings['bbname']);
            $emailmessage = $this->lang->sprintf($this->lang->email_randompassword, $user['username'], $this->mybb->settings['bbname'], $user_info['username'], $user_info['password']);
            my_mail($user_info['email'], $emailsubject, $emailmessage);

            // Run whatever hook is defined at the end of a registration
            $this->plugins->run_hooks("member_do_register_end");

            return $this->lang->redirect_registered_passwordsent;
        }

        /**
         * Register Mode: Admin Activation
         * Return the message that the user will need to be authorized by an admin
        */
        else if($this->mybb->settings['regtype'] == "admin")
        {
            // Build the message to return
            $this->lang->redirect_registered_admin_activate = $this->lang->sprintf($this->lang->redirect_registered_admin_activate, $this->mybb->settings['bbname'], $user_info['username']);

            // Run whatever hook is defined at the end of a registration
            $this->plugins->run_hooks("member_do_register_end");

            return $this->lang->redirect_registered_admin_activate;
        }

        /**
         * No activation required whatsoever,
         * directly registered
        */
        else
        {
            // Build the message to return
            $this->lang->redirect_registered = $this->lang->sprintf($this->lang->redirect_registered, $this->mybb->settings['bbname'], $user_info['username']);

            // Run whatever hook is defined at the end of a registration
            $this->plugins->run_hooks('member_do_register_end');

            return $this->lang->redirect_registered;
        }
    }

    /**
     * Will remove a Forum/Category and everything related to it
     * Taken from admin/modules/forum/management.php
     *
     * @param integer $forum_id ID of Forum/Category
     * @return boolean
    */
    function removeForumOrCategory($forum_id)
    {
        $this->plugins->run_hooks("admin_forum_management_delete");

        $query = $this->db->simple_select("forums", "*", "fid='{$forum_id}'");
        $forum = $this->db->fetch_array($query);

        // Does the forum not exist?
        if (!$forum['fid'])
        {
            return false;
        }

        $fid = intval($forum_id);
        $forum_info = $this->getForum($fid);

        // Delete the forum
        $this->db->delete_query("forums", "fid='$fid'");
        switch ($this->db->type)
        {
            case "pgsql":
            case "sqlite3":
            case "sqlite2":
                $query = $this->db->simple_select("forums", "*", "','|| parentlist|| ',' LIKE '%,$fid,%'");
                break;
            default:
                $query = $this->db->simple_select("forums", "*", "CONCAT(',', parentlist, ',') LIKE '%,$fid,%'");
        }
        while ($forum = $this->db->fetch_array($query))
        {
            $fids[$forum['fid']] = $fid;
            $delquery .= " OR fid='{$forum['fid']}'";
        }

        /**
         * This slab of code pulls out the moderators for this forum,
         * checks if they moderate any other forums, and if they don't
         * it moves them back to the registered usergroup
         */

        $query = $this->db->simple_select("moderators", "*", "fid='$fid'");
        while ($mod = $this->db->fetch_array($query))
        {
            $moderators[$mod['uid']] = $mod['uid'];
        }

        if (is_array($moderators))
        {
            $mod_list = implode(",", $moderators);
            $query = $this->db->simple_select("moderators", "*", "fid != '$fid' AND uid IN ($mod_list)");
            while ($mod = $this->db->fetch_array($query))
            {
                unset($moderators[$mod['uid']]);
            }
        }

        if (is_array($moderators))
        {
            $mod_list = implode(",", $moderators);
            if($mod_list)
            {
                $updatequery = array(
                    "usergroup" => "2"
                );
                $this->db->update_query("users", $updatequery, "uid IN ($mod_list) AND usergroup='6'");
            }
        }

        switch($this->db->type)
        {
            case "pgsql":
            case "sqlite3":
            case "sqlite2":
                $this->db->delete_query("forums", "','||parentlist||',' LIKE '%,$fid,%'");
                break;
            default:
                $this->db->delete_query("forums", "CONCAT(',',parentlist,',') LIKE '%,$fid,%'");
        }

        $this->db->delete_query("threads", "fid='{$fid}' {$delquery}");
        $this->db->delete_query("posts", "fid='{$fid}' {$delquery}");
        $this->db->delete_query("moderators", "fid='{$fid}' {$delquery}");
        $this->db->delete_query("forumsubscriptions", "fid='{$fid}' {$delquery}");

        $this->cache->update_forums();
        $this->cache->update_moderators();
        $this->cache->update_forumpermissions();

        // Log admin action - Need to add 2 params in input array so logging contains correct info
        $this->mybb->input['module'] = 'forum/management';
        $this->mybb->input['action'] = 'delete';
        $this->logAdminAction($forum_info['fid'], $forum_info['name']);

        $this->plugins->run_hooks("admin_forum_management_delete_commit");

        return true;
    }

    /**
     * Delete a post
     *
     * @param integer $post_id ID of Post
     * @return ?
    */
    function removePost($post_id)
    {
        require_once MYBB_ROOT."inc/functions_post.php";
        require_once MYBB_ROOT."inc/functions_upload.php";

        $this->lang->load('editpost');

        $post = $this->getPost($post_id);

        $tid = $post['tid'];
        $fid = $post['fid'];
        $pid = $post['pid'];

        $forumpermissions = forum_permissions($fid);

        $this->plugins->run_hooks("editpost_deletepost");

        $query = $this->db->simple_select("posts", "pid", "tid='{$tid}'", array("limit" => 1, "order_by" => "dateline", "order_dir" => "asc"));
        $firstcheck = $this->db->fetch_array($query);
        if ($firstcheck['pid'] == $pid)
        {
            $firstpost = 1;
        }
        else
        {
            $firstpost = 0;
        }

        $modlogdata['fid'] = $fid;
        $modlogdata['tid'] = $tid;

        if ($firstpost)
        {
            if ($forumpermissions['candeletethreads'] == 1 || is_moderator($fid, "candeleteposts"))
            {
                delete_thread($tid);
                mark_reports($tid, "thread");
                $this->logModeratorAction($modlogdata, $this->lang->thread_deleted);
                return true;
            }
            else
            {
                return false;
            }
        }
        else
        {
            if ($forumpermissions['candeleteposts'] == 1 || is_moderator($fid, "candeleteposts"))
            {
                // Select the first post before this
                delete_post($pid, $tid);
                mark_reports($pid, "post");
                $this->logModeratorAction($modlogdata, $this->lang->post_deleted);
                $query = $this->db->simple_select("posts", "pid", "tid='{$tid}' AND dateline <= '{$post['dateline']}'", array("limit" => 1, "order_by" => "dateline", "order_dir" => "desc"));
                $next_post = $this->db->fetch_array($query);
                return true;
            }
            else
            {
                return false;
            }
        }
    }

    /**
     * Delete a user in the database
     *
     * @param integer $thread Thread ID
     * @return boolean
    */
    function removeThread($thread)
    {
        $tid = intval($thread);

        $this->lang->load('editpost');

        $deleted = delete_thread($tid);
        mark_reports($tid, "thread");

        $modlogdata['tid'] = $tid;
        $this->logModeratorAction($modlogdata, $this->lang->thread_deleted);

        return $deleted;
    }

    /**
     * Delete a user in the database
     *
     * @param integer|string $user User ID or username
     * @return boolean
    */
    function removeUser($user)
    {
        // If no ID is given, we check if there is a user with the specified username
        if (!is_numeric($user))
        {
            $query = $this->db->simple_select('users', 'uid', 'username=\''.$this->dbEscape($user).'\'');
            $user_id = $this->db->fetch_field($query, 'uid', 0);

            // User does not exist? --> False
            if (empty($user_id))
            {
                return false;
            }

            $user_id = intval($user_id);
        }
        else
        {
            $user_id = intval($user);
        }

        $this->plugins->run_hooks('admin_user_users_delete');

        // Delete the user
        $this->db->update_query("posts", array('uid' => 0), "uid='{$user_id}'");
        $this->db->delete_query("userfields", "ufid='{$user_id}'");
        $this->db->delete_query("privatemessages", "uid='{$user_id}'");
        $this->db->delete_query("events", "uid='{$user_id}'");
        $this->db->delete_query("moderators", "uid='{$user_id}'");
        $this->db->delete_query("forumsubscriptions", "uid='{$user_id}'");
        $this->db->delete_query("threadsubscriptions", "uid='{$user_id}'");
        $this->db->delete_query("sessions", "uid='{$user_id}'");
        $this->db->delete_query("banned", "uid='{$user_id}'");
        $this->db->delete_query("threadratings", "uid='{$user_id}'");
        $this->db->delete_query("users", "uid='{$user_id}'");
        $this->db->delete_query("joinrequests", "uid='{$user_id}'");
        $this->db->delete_query("warnings", "uid='{$user_id}'");

        // Update forum stats
        update_stats(array('numusers' => '-1'));

        $this->plugins->run_hooks('admin_user_users_delete_commit');

        return true;
    }

    /**
     * Send a private message from someone to someone
    */
    function sendPrivateMessage($data = array())
    {
        // Let's do default values and check if all required data keys are passed
        $default_data = array(
            'fromid' => 0,
            'subject' => '',
            'message' => '',
            'icon' => 0,
            'to_username' => ''
        );

        // Set default values if they are missing!
        foreach ($default_data as $default_data_key => $default_data_val)
        {
            if (!isset($data[$default_data_key]))
            {
                $data[$default_data_key] = $default_data_val;
            }
        }

        $this->lang->load('private');

        $this->plugins->run_hooks('private_send_do_send');

        // Attempt to see if this PM is a duplicate or not
        $time_cutoff = TIME_NOW - (5 * 60 * 60);
        $query = $this->db->query("
            SELECT pm.pmid
            FROM ".TABLE_PREFIX."privatemessages pm
            LEFT JOIN ".TABLE_PREFIX."users u ON(u.uid=pm.toid)
            WHERE u.username='".$this->db->escape_string($data['to_uername'])."' AND pm.dateline > {$time_cutoff} AND pm.fromid='{".$data['fromid']."}' AND pm.subject='".$this->db->escape_string($data['subject'])."' AND pm.message='".$this->db->escape_string($data['message'])."' AND pm.folder!='3'
        ");
        $duplicate_check = $this->db->fetch_field($query, "pmid");
        if ($duplicate_check)
        {
            return $this->lang->error_pm_already_submitted;
        }

        require_once MYBB_ROOT."inc/datahandlers/pm.php";
        $pmhandler = new PMDataHandler();

        // Split up any recipients we have
        $data['to'] = explode(",", $data['to_username']);
        $data['to'] = array_map("trim", $data['to']);
        if (!empty($data['bcc']))
        {
            $data['bcc'] = explode(",", $data['bcc']);
            $data['bcc'] = array_map("trim", $data['bcc']);
        }

        $data['options'] = array(
            "signature" => (isset($data['options']['signature'])) ? $data['options']['signature'] : NULL,
            "disablesmilies" => (isset($data['options']['disablesmilies'])) ? $data['options']['disablesmilies'] : NULL,
            "savecopy" => (isset($data['options']['savecopy'])) ? $data['options']['savecopy'] : NULL,
            "readreceipt" => (isset($data['options']['readreceipt'])) ? $data['options']['readreceipt'] : NULL
        );

        /* Unnecessary
        if($data['saveasdraft'])
        {
            $data['saveasdraft'] = 1;
        } */

        $pmhandler->set_data($data);

        // Now let the pm handler do all the hard work.
        if(!$pmhandler->validate_pm())
        {
            $pm_errors = $pmhandler->get_friendly_errors();
            return inline_error($pm_errors);

        }
        else
        {
            $pminfo = $pmhandler->insert_pm();
            $this->plugins->run_hooks("private_do_send_end");

            if (isset($pminfo['draftsaved']))
            {
                return $this->lang->redirect_pmsaved;
            }
            else
            {
                return $this->lang->redirect_pmsent;
            }
        }
    }

    /**
     * Use built-in set-cookie function of MyBB
     *
     * @param string $name Cookie Name
     * @param mixed $value Cookie Value
     * @param integer $expires Timestamp of Expiry
     * @param boolean Use cookie for HTTP only?
    */
    function setCookie($name, $value = '', $expires = NULL, $httponly = false)
    {
        my_setcookie($name, $value, $expires, $httponly);
    }

    /**
     * Set a new password for a user
     *
     * @param integer User-ID
     * @param string New Password
     * @param boolean Return errors as MyBB array or nicely formated?
     * @return boolean|array
    */
    function updatePasswordOfUser($user_id, $password, $inline_error = true)
    {
        include_once MYBB_ROOT.'inc/functions_user.php';
        require_once MYBB_ROOT.'inc/datahandlers/user.php';
        $userhandler = new UserDataHandler('update');

        $data = array(
            'uid' => intval($user_id),
            'password' => $password
        );

        $userhandler->set_data($data);

        if (!$userhandler->validate_user())
        {
            $errors = $userhandler->get_friendly_errors();
            return ($inline_error === true) ? inline_error($errors) : $errors;
        }

        $userhandler->update_user();

        return true;
    }

    /**
     * Update content and information of a single post
     *
     * @param array $data Post-Data
     * @param boolean|array|string $inline_errors Return arrays as array or string or return bool true when all good
    */
    function updatePost($data, $inline_errors)
    {
        require_once MYBB_ROOT.'inc/functions_post.php';
        require_once MYBB_ROOT.'/inc/datahandlers/post.php';
        $posthandler = new PostDataHandler('update');
        $posthandler->action = 'post';

        $this->plugins->run_hooks('editpost_do_editpost_start');

        $posthandler->set_data($data);

        if (!$posthandler->validate_post())
        {
            $errors = $posthandler->get_friendly_errors();
            return ($inline_errors === true) ? inline_error($errors) : $errors;
        }

        $this->plugins->run_hooks('editpost_do_editpost_end');

        return $posthandler->update_post();
    }

    /**
     * Updates a thread in the database
     *
     * @param array $data Thread data
     * @param boolean $inline_errors Defines if we want a formatted error string or an array
     * @return array|string
     * @return array|string When true it will return an array with threadID, postID and status of being visible - false = error array or inline string
    */
    function updateThread($data, $inline_errors = true)
    {
        if (!isset($data['tid']))
        {
            $this->_errorAndDie('Function <i>updateThread</i>: Must pass thread id in array parameter - Required array key is <i>tid</i>');
        }

        // Posthandler is used for a post, so let's fetch the thread-post
        $thread = $this->getThread($data['tid']);
        $data['pid'] = $thread['firstpost'];

        require_once MYBB_ROOT.'inc/functions_post.php';
        require_once MYBB_ROOT.'/inc/datahandlers/post.php';
        $posthandler = new PostDataHandler('update');
        $posthandler->action = 'post';
        $posthandler->set_data($data);
        if (!$posthandler->validate_post())
        {
            $errors = $posthandler->get_friendly_errors();
            return ($inline_errors === true) ? inline_error($errors) : $errors;
        }
        return $posthandler->update_post();
    }

    /**
     * Updates userdata
     *
     * @param array $userdata Data of the User (uid is required as index)
     * @param boolean Return errors as MyBB array or nicely formated?
     * @return boolean|array
    */
    function updateUser($userdata = array(), $inline_error = true)
    {
        // Userdata Array needs to contain the UserID
        if (!isset($userdata['uid']))
        {
            $this->_errorAndDie('A UserID (Array-Key: <i>uid</i>) is required to update a user');
        }

        require_once MYBB_ROOT.'inc/functions_user.php';
        require_once MYBB_ROOT.'inc/datahandlers/user.php';
        $userhandler = new UserDataHandler('update');
        $userhandler->set_data($userdata);

        if (!$userhandler->validate_user())
        {
            $errors = $userhandler->get_friendly_errors();
            return ($inline_error === true) ? inline_error($errors) : $errors;
        }

        $userhandler->update_user();

        return true;
    }

    /**
     * Checks if given captcha is correct
     *
     * @param string $hash Captcha-Hash
     * @param string $string the Letters of the captcha
     * @return boolean
    */
    function validateCaptcha($hash, $string)
    {
        $imagehash = $this->dbEscape($hash);
        $imagestring = $this->dbEscape($string);
        $query = $this->db->simple_select("captcha", "*", "imagehash='{$imagehash}' AND imagestring='{$imagestring}'");
        $imgcheck = $this->db->fetch_array($query);
        if($imgcheck['dateline'] > 0)
        {
            return true;
        }
        else
        {
            $this->db->delete_query("captcha", "imagehash='{$imagehash}'");
            return false;
        }
    }

    /**
     * Perform a vote in a poll
     *
     * @param integer $poll_id ID of Poll
     * @param integer $user_id ID of User
     * @param integer|array Vote option (basically what you vote!) - if multiple, you can define more options in an array
    */
    function vote($poll_id, $user_id = 0, $option = NULL)
    {
        // Load the Language Phrases
        $this->lang->load('polls');

        // A bit sanitizing...
        $poll_id = (int) $poll_id;
        $user_id = (int) $user_id;

        // Let's fetch infos of the poll
        $query = $this->db->simple_select("polls", "*", "pid='".intval($poll_id)."'");
        $poll = $this->db->fetch_array($query);
        $poll['timeout'] = $poll['timeout']*60*60*24;

        $this->plugins->run_hooks("polls_vote_start");

        // Does the poll exist?
        if (!$poll['pid'])
        {
            return $this->lang->error_invalidpoll;
        }

        // Does the poll exist in a valid thread?
        $query = $this->db->simple_select("threads", "*", "poll='".$poll['pid']."'");
        $thread = $this->db->fetch_array($query);
        if (!$thread['tid'])
        {
            return $this->lang->error_invalidthread;
        }

        // Do we have the permissino to vote?
        $fid = $thread['fid'];
        $forumpermissions = forum_permissions($fid);
        if ($forumpermissions['canvotepolls'] == 0)
        {
            return false;
        }

        // Has the poll expired?
        $expiretime = $poll['dateline'] + $poll['timeout'];
        if ($poll['closed'] == 1 || $thread['closed'] == 1 || ($expiretime < TIME_NOW && $poll['timeout']))
        {
            return $this->lang->error_pollclosed;
        }

        // Did we pass an option to vote for?
        if (empty($option))
        {
            return $this->lang->error_nopolloptions;
        }

        // Check if the user has voted before...
        if ($user_id > 0)
        {
            $query = $this->db->simple_select("pollvotes", "*", "uid='".$user_id."' AND pid='".$poll['pid']."'");
            $votecheck = $this->db->fetch_array($query);
        }

        if ($votecheck['vid'] || $this->mybb->cookies['pollvotes'][$poll['pid']])
        {
            return $this->lang->error_alreadyvoted;
        }
        elseif ($user_id == 0)
        {
            // Give a cookie to guests to inhibit revotes
            my_setcookie("pollvotes[{$poll['pid']}]", '1');
        }

        $votesql = '';
        $votesarray = explode("||~|~||", $poll['votes']);
        $numvotes = $poll['numvotes'];
        if ($poll['multiple'] == 1)
        {
            foreach ($option as $voteoption => $vote)
            {
                if ($vote == 1 && isset($votesarray[$voteoption-1]))
                {
                    if ($votesql)
                    {
                        $votesql .= ",";
                    }
                    $votesql .= "('".$poll['pid']."','".$user_id."','".$this->db->escape_string($voteoption)."', ".TIME_NOW.")";
                    $votesarray[$voteoption-1]++;
                    $numvotes = $numvotes+1;
                }
            }
        }
        else
        {
            if (!isset($votesarray[$option-1]))
            {
                return $this->lang->error_nopolloptions;
            }
            $votesql = "('".$poll['pid']."','".$user_id."','".$this->db->escape_string($option)."', ".TIME_NOW.")";
            $votesarray[$option-1]++;
            $numvotes = $numvotes+1;
        }

        // Save the fact that we voted
        $this->db->write_query("
            INSERT INTO
            ".TABLE_PREFIX."pollvotes (pid,uid,voteoption,dateline)
            VALUES $votesql
        ");
        $voteslist = '';
        for ($i = 1; $i <= $poll['numoptions']; ++$i)
        {
            if ($i > 1)
            {
                $voteslist .= "||~|~||";
            }
            $voteslist .= $votesarray[$i-1];
        }
        $updatedpoll = array(
            "votes" => $this->db->escape_string($voteslist),
            "numvotes" => intval($numvotes),
        );

        $this->plugins->run_hooks("polls_vote_process");

        $this->db->update_query("polls", $updatedpoll, "pid='".$poll['pid']."'");

        $this->plugins->run_hooks("polls_vote_end");

        return true;
    }
}

?>