problèmes conenction avec une autre base de donné

Code PHP :
<?php
/**
 * MyBB 1.6
 * Copyright 2010 MyBB Group, All Rights Reserved
 *
 * Website: http://mybb.com
 * License: http://mybb.com/about/license
 *
 * $Id: member.php 5126 2010-07-27 07:48:04Z RyanGordon $
 */

define("IN_MYBB", 1);
define('THIS_SCRIPT', 'member.php');
define("ALLOWABLE_PAGE", "register,do_register,login,do_login,logout,lostpw,do_lostpw,activate,resendactivation,do_resendactivation,resetpassword");

$nosession['avatar'] = 1;
$templatelist = "member_register,error_nousername,error_nopassword,error_passwordmismatch,error_invalidemail,error_usernametaken,error_emailmismatch,error_noemail,redirect_registered";
$templatelist .= ",redirect_loggedout,login,redirect_loggedin,error_invalidusername,error_invalidpassword,member_profile_email,member_profile_offline,member_profile_reputation,member_profile_warn,member_profile_warninglevel,member_profile_customfields_field,member_profile_customfields,member_profile_adminoptions,member_profile,member_login,member_profile_online,member_profile_modoptions,member_profile_signature,member_profile_groupimage,member_profile_referrals";
require_once "./global.php";

require_once MYBB_ROOT."inc/functions_post.php";
require_once MYBB_ROOT."inc/functions_user.php";
require_once MYBB_ROOT."inc/class_parser.php";
$parser = new postParser;

// Load global language phrases
$lang->load("member");

// Make navigation
switch($mybb->input['action'])
{
    case "register":
    case "do_register":
        add_breadcrumb($lang->nav_register);
        break;
    case "activate":
        add_breadcrumb($lang->nav_activate);
        break;
    case "resendactivation":
        add_breadcrumb($lang->nav_resendactivation);
        break;
    case "lostpw":
        add_breadcrumb($lang->nav_lostpw);
        break;
    case "resetpassword":
        add_breadcrumb($lang->nav_resetpassword);
        break;
    case "login":
        add_breadcrumb($lang->nav_login);
        break;
    case "emailuser":
        add_breadcrumb($lang->nav_emailuser);
        break;
}

if(($mybb->input['action'] == "register" || $mybb->input['action'] == "do_register") && $mybb->usergroup['cancp'] != 1)
{
    if($mybb->settings['disableregs'] == 1)
    {
        error($lang->registrations_disabled);
    }
    if($mybb->user['regdate'])
    {
        error($lang->error_alreadyregistered);
    }
    if($mybb->settings['betweenregstime'] && $mybb->settings['maxregsbetweentime'])
    {
        $time = TIME_NOW;
        $datecut = $time-(60*60*$mybb->settings['betweenregstime']);
        $query = $db->simple_select("accounts", "*", "regip='".$db->escape_string($session->ipaddress)."' AND regdate > '$datecut'");
        $regcount = $db->num_rows($query);
        if($regcount >= $mybb->settings['maxregsbetweentime'])
        {
            $lang->error_alreadyregisteredtime = $lang->sprintf($lang->error_alreadyregisteredtime, $regcount, $mybb->settings['betweenregstime']);
            error($lang->error_alreadyregisteredtime);
        }
    }
}

if($mybb->input['action'] == "do_register" && $mybb->request_method == "post")
{
    $plugins->run_hooks("member_do_register_start");

    if($mybb->settings['regtype'] == "randompass")
    {
        $mybb->input['pass'] = random_str();
        $mybb->input['pass2'] = $mybb->input['pass'];
    }

    if($mybb->settings['regtype'] == "verify" || $mybb->settings['regtype'] == "admin" || $mybb->input['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(
        "account" => $mybb->input['account'],
        "pass" => $mybb->input['pass'],
        "password2" => $mybb->input['password2'],
        "email" => $mybb->input['email'],
        "email2" => $mybb->input['email2'],
        "usergroup" => $usergroup,
        "referrer" => $mybb->input['referrername'],
        "timezone" => $mybb->input['timezoneoffset'],
        "language" => $mybb->input['language'],
        "profile_fields" => $mybb->input['profile_fields'],
        "regip" => $session->ipaddress,
        "longregip" => my_ip2long($session->ipaddress),
        "coppa_user" => intval($mybb->cookies['coppauser']),
    );
    
    if(isset($mybb->input['regcheck1']) && isset($mybb->input['regcheck2']))
    {
        $user['regcheck1'] = $mybb->input['regcheck1'];
        $user['regcheck2'] = $mybb->input['regcheck2'];
    }

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

    $user['options'] = array(
        "allownotices" => $mybb->input['allownotices'],
        "hideemail" => $mybb->input['hideemail'],
        "subscriptionmethod" => $mybb->input['subscriptionmethod'],
        "receivepms" => $mybb->input['receivepms'],
        "pmnotice" => $mybb->input['pmnotice'],
        "emailpmnotify" => $mybb->input['emailpmnotify'],
        "invisible" => $mybb->input['invisible'],
        "dstcorrection" => $mybb->input['dstcorrection']
    );

    $userhandler->set_data($user);

    $errors = "";

    if(!$userhandler->validate_user())
    {
        $errors = $userhandler->get_friendly_errors();
    }

    if($mybb->settings['captchaimage'] == 1 && function_exists("imagecreatefrompng"))
    {
        $imagehash = $db->escape_string($mybb->input['imagehash']);
        $imagestring = $db->escape_string(my_strtolower($mybb->input['imagestring']));
        $query = $db->simple_select("captcha", "*", "imagehash='$imagehash' AND LOWER(imagestring)='$imagestring'");
        $imgcheck = $db->fetch_array($query);
        if(!$imgcheck['dateline'])
        {
            $errors[]  = $lang->error_regimageinvalid;
        }
        $db->delete_query("captcha", "imagehash='$imagehash'");
    }

    if(is_array($errors))
    {
        $account = htmlspecialchars_uni($mybb->input['account']);
        $email = htmlspecialchars_uni($mybb->input['email']);
        $email2 = htmlspecialchars_uni($mybb->input['email']);
        $referrername = htmlspecialchars_uni($mybb->input['referrername']);

        if($mybb->input['allownotices'] == 1)
        {
            $allownoticescheck = "checked=\"checked\"";
        }

        if($mybb->input['hideemail'] == 1)
        {
            $hideemailcheck = "checked=\"checked\"";
        }

        if($mybb->input['subscriptionmethod'] == 1)
        {
            $no_email_subscribe_selected = "selected=\"selected\"";
        }
        else if($mybb->input['subscriptionmethod'] == 2)
        {
            $instant_email_subscribe_selected = "selected=\"selected\"";
        }
        else
        {
            $no_subscribe_selected = "selected=\"selected\"";
        }

        if($mybb->input['receivepms'] == 1)
        {
            $receivepmscheck = "checked=\"checked\"";
        }

        if($mybb->input['pmnotice'] == 1)
        {
            $pmnoticecheck = " checked=\"checked\"";
        }

        if($mybb->input['emailpmnotify'] == 1)
        {
            $emailpmnotifycheck = "checked=\"checked\"";
        }

        if($mybb->input['invisible'] == 1)
        {
            $invisiblecheck = "checked=\"checked\"";
        }

        if($mybb->input['dstcorrection'] == 2)
        {
            $dst_auto_selected = "selected=\"selected\"";
        }
        else if($mybb->input['dstcorrection'] == 1)
        {
            $dst_enabled_selected = "selected=\"selected\"";
        }
        else
        {
            $dst_disabled_selected = "selected=\"selected\"";
        }

        $regerrors = inline_error($errors);
        $mybb->input['action'] = "register";
        $fromreg = 1;
    }
    else
    {
        $user_info = $userhandler->insert_user();

        if($mybb->settings['regtype'] != "randompass" && !$mybb->cookies['coppauser'])
        {
            // Log them in
            my_setcookie("mybbuser", $user_info['guid']."_".$user_info['loginkey'], null, true);
        }

        if($mybb->cookies['coppauser'])
        {
            $lang->redirect_registered_coppa_activate = $lang->sprintf($lang->redirect_registered_coppa_activate, $mybb->settings['bbname'], $user_info['account']);
            my_unsetcookie("coppauser");
            my_unsetcookie("coppadob");
            $plugins->run_hooks("member_do_register_end");
            error($lang->redirect_registered_coppa_activate);
        }
        else if($mybb->settings['regtype'] == "verify")
        {
            $activationcode = random_str();
            $now = TIME_NOW;
            $activationarray = array(
                "guid" => $user_info['guid'],
                "dateline" => TIME_NOW,
                "code" => $activationcode,
                "type" => "r"
            );
            $db->insert_query("awaitingactivation", $activationarray);
            $emailsubject = $lang->sprintf($lang->emailsubject_activateaccount, $mybb->settings['bbname']);
            $emailmessage = $lang->sprintf($lang->email_activateaccount, $user_info['account'], $mybb->settings['bbname'], $mybb->settings['bburl'], $user_info['guid'], $activationcode);
            my_mail($user_info['email'], $emailsubject, $emailmessage);
            
            $lang->redirect_registered_activation = $lang->sprintf($lang->redirect_registered_activation, $mybb->settings['bbname'], $user_info['account']);

            $plugins->run_hooks("member_do_register_end");

            error($lang->redirect_registered_activation);
        }
        else if($mybb->settings['regtype'] == "randompass")
        {
            $emailsubject = $lang->sprintf($lang->emailsubject_randompassword, $mybb->settings['bbname']);
            $emailmessage = $lang->sprintf($lang->email_randompassword, $user['account'], $mybb->settings['bbname'], $user_info['account'], $user_info['pass']);
            my_mail($user_info['email'], $emailsubject, $emailmessage);

            $plugins->run_hooks("member_do_register_end");

            error($lang->redirect_registered_passwordsent);
        }
        else if($mybb->settings['regtype'] == "admin")
        {
            $lang->redirect_registered_admin_activate = $lang->sprintf($lang->redirect_registered_admin_activate, $mybb->settings['bbname'], $user_info['account']);

            $plugins->run_hooks("member_do_register_end");

            error($lang->redirect_registered_admin_activate);
        }
        else
        {
            $lang->redirect_registered = $lang->sprintf($lang->redirect_registered, $mybb->settings['bbname'], $user_info['account']);

            $plugins->run_hooks("member_do_register_end");

            redirect("index.php", $lang->redirect_registered);
        }
    }
}

if($mybb->input['action'] == "coppa_form")
{
    if(!$mybb->settings['faxno'])
    {
        $mybb->settings['faxno'] = "&nbsp;";
    }
    
    eval("\$coppa_form = \"".$templates->get("member_coppa_form")."\";");
    output_page($coppa_form);
}

if($mybb->input['action'] == "register")
{
    $bdaysel = '';
    if($mybb->settings['coppa'] == "disabled")
    {
        $bdaysel = $bday2blank = "<option value=\"\">&nbsp;</option>";
    }
    for($i = 1; $i <= 31; ++$i)
    {
        if($mybb->input['bday1'] == $i)
        {
            $bdaysel .= "<option value=\"$i\" selected=\"selected\">$i</option>\n";
        }
        else
        {
            $bdaysel .= "<option value=\"$i\">$i</option>\n";
        }
    }

    $bdaymonthsel[$mybb->input['bday2']] = "selected=\"selected\"";
    $mybb->input['bday3'] = intval($mybb->input['bday3']);

    if($mybb->input['bday3'] == 0) $mybb->input['bday3'] = "";

    // Is COPPA checking enabled?
    if($mybb->settings['coppa'] != "disabled" && !$mybb->input['step'])
    {
        // Just selected DOB, we check
        if($mybb->input['bday1'] && $mybb->input['bday2'] && $mybb->input['bday3'])
        {
            my_unsetcookie("coppauser");
            
            $bdaytime = @mktime(0, 0, 0, $mybb->input['bday2'], $mybb->input['bday1'], $mybb->input['bday3']);
            
            // Store DOB in cookie so we can save it with the registration
            my_setcookie("coppadob", "{$mybb->input['bday1']}-{$mybb->input['bday2']}-{$mybb->input['bday3']}", -1);

            // User is <= 13, we mark as a coppa user
            if($bdaytime >= mktime(0, 0, 0, my_date('n'), my_date('d'), my_date('Y')-13))
            {
                my_setcookie("coppauser", 1, -0);
                $under_thirteen = true;
            }
            $mybb->request_method = "";
        }
        // Show DOB select form
        else
        {
            $plugins->run_hooks("member_register_coppa");
            
            my_unsetcookie("coppauser");
            
            eval("\$coppa = \"".$templates->get("member_register_coppa")."\";");
            output_page($coppa);
            exit;
        }
    }

    if((!isset($mybb->input['agree']) && !isset($mybb->input['regsubmit'])) || $mybb->request_method != "post")
    {
        // Is this user a COPPA user? We need to show the COPPA agreement too
        if($mybb->settings['coppa'] != "disabled" && ($mybb->cookies['coppauser'] == 1 || $under_thirteen))
        {
            if($mybb->settings['coppa'] == "deny")
            {
                error($lang->error_need_to_be_thirteen);
            }
            $lang->coppa_agreement_1 = $lang->sprintf($lang->coppa_agreement_1, $mybb->settings['bbname']);
            eval("\$coppa_agreement = \"".$templates->get("member_register_agreement_coppa")."\";");
        }

        $plugins->run_hooks("member_register_agreement");

        eval("\$agreement = \"".$templates->get("member_register_agreement")."\";");
        output_page($agreement);
    }
    else
    {
        $plugins->run_hooks("member_register_start");
        
        $validator_extra = '';

        if(isset($mybb->input['timezoneoffset']))
        {
            $timezoneoffset = $mybb->input['timezoneoffset'];
        }
        else
        {
            $timezoneoffset = $mybb->settings['timezoneoffset'];
        }
        $tzselect = build_timezone_select("timezoneoffset", $timezoneoffset, true);

        $stylelist = build_theme_select("style");

        if($mybb->settings['usertppoptions'])
        {
            $tppoptions = '';
            $explodedtpp = explode(",", $mybb->settings['usertppoptions']);
            if(is_array($explodedtpp))
            {
                foreach($explodedtpp as $val)
                {
                    $val = trim($val);
                    $tppoptions .= "<option value=\"$val\">".$lang->sprintf($lang->tpp_option, $val)."</option>\n";
                }
            }
            eval("\$tppselect = \"".$templates->get("usercp_options_tppselect")."\";");
        }
        if($mybb->settings['userpppoptions'])
        {
            $pppoptions = '';
            $explodedppp = explode(",", $mybb->settings['userpppoptions']);
            if(is_array($explodedppp))
            {
                foreach($explodedppp as $val)
                {
                    $val = trim($val);
                    $pppoptions .= "<option value=\"$val\">".$lang->sprintf($lang->ppp_option, $val)."</option>\n";
                }
            }
            eval("\$pppselect = \"".$templates->get("usercp_options_pppselect")."\";");
        }
        if($mybb->settings['usereferrals'] == 1 && !$mybb->user['guid'])
        {
            if($mybb->cookies['mybb']['referrer'])
            {
                $query = $db->simple_select("accounts", "guid,account", "guid='".$db->escape_string($mybb->cookies['mybb']['referrer'])."'");
                $ref = $db->fetch_array($query);
                $referrername = $ref['account'];
            }
            elseif($referrer)
            {
                $query = $db->simple_select("accounts", "account", "guid='".intval($referrer['guid'])."'");
                $ref = $db->fetch_array($query);
                $referrername = $ref['account'];
            }
            elseif($referrername)
            {
                $query = $db->simple_select("accounts", "guid", "LOWER(account)='".$db->escape_string(my_strtolower($referrername))."'");
                $ref = $db->fetch_array($query);
                if(!$ref['guid'])
                {
                    $errors[] = $lang->error_badreferrer;
                }
            }
            if($quickreg)
            {
                $refbg = "trow1";
            }
            else
            {
                $refbg = "trow2";
            }
            // JS validator extra
            $validator_extra .= "\tregValidator.register('referrer', 'ajax', {url:'xmlhttp.php?action=username_exists', loading_message:'{$lang->js_validator_checking_referrer}'});\n";

            eval("\$referrer = \"".$templates->get("member_register_referrer")."\";");
        }
        else
        {
            $referrer = '';
        }
        // Custom profile fields baby!
        $altbg = "trow1";
        $query = $db->simple_select("profilefields", "*", "editable=1", array('order_by' => 'disporder'));
        while($profilefield = $db->fetch_array($query))
        {
            $profilefield['type'] = htmlspecialchars_uni($profilefield['type']);
            $thing = explode("\n", $profilefield['type'], "2");
            $type = trim($thing[0]);
            $options = $thing[1];
            $select = '';
            $field = "fid{$profilefield['fid']}";
            if($errors)
            {
                $userfield = $mybb->input['profile_fields'][$field];
            }
            else
            {
                $userfield = '';
            }
            if($type == "multiselect")
            {
                if($errors)
                {
                    $useropts = $userfield;
                }
                else
                {
                    $useropts = explode("\n", $userfield);
                }
                if(is_array($useropts))
                {        
                    foreach($useropts as $key => $val)
                    {
                        $seloptions[$val] = $val;
                    }
                }
                $expoptions = explode("\n", $options);
                if(is_array($expoptions)) 
                {
                    foreach($expoptions as $key => $val)
                    {
                        $val = trim($val);
                        $val = str_replace("\n", "\\n", $val);

                        $sel = "";
                        if($val == $seloptions[$val])
                        {
                            $sel = "selected=\"selected\"";
                        }
                        $select .= "<option value=\"$val\" $sel>$val</option>\n";
                    }
                    if(!$profilefield['length'])
                    {
                        $profilefield['length'] = 3;
                    }
                    $code = "<select name=\"profile_fields[$field][]\" id=\"{$field}\" size=\"{$profilefield['length']}\" multiple=\"multiple\">$select</select>";
                }
            }
            elseif($type == "select")
            {
                $expoptions = explode("\n", $options);
                if(is_array($expoptions))
                {
                    foreach($expoptions as $key => $val)
                    {
                        $val = trim($val);
                        $val = str_replace("\n", "\\n", $val);
                        $sel = "";
                        if($val == $userfield)
                        {
                            $sel = "selected=\"selected\"";
                        }
                        $select .= "<option value=\"$val\" $sel>$val</option>";
                    }
                    if(!$profilefield['length'])
                    {
                        $profilefield['length'] = 1;
                    }
                    $code = "<select name=\"profile_fields[$field]\" id=\"{$field}\" size=\"{$profilefield['length']}\">$select</select>";
                }
            }
            elseif($type == "radio")
            {
                $expoptions = explode("\n", $options);
                if(is_array($expoptions))
                {
                    foreach($expoptions as $key => $val)
                    {
                        $checked = "";
                        if($val == $userfield)
                        {
                            $checked = "checked=\"checked\"";
                        }
                        $code .= "<input type=\"radio\" class=\"radio\" name=\"profile_fields[$field]\" id=\"{$field}{$key}\" value=\"$val\" $checked /> <span class=\"smalltext\">$val</span><br />";
                    }
                }
            }
            elseif($type == "checkbox")
            {
                if($errors)
                {
                    $useropts = $userfield;
                }
                else
                {
                    $useropts = explode("\n", $userfield);
                }
                if(is_array($useropts))
                {
                    foreach($useropts as $key => $val)
                    {
                        $seloptions[$val] = $val;
                    }
                }
                $expoptions = explode("\n", $options);
                if(is_array($expoptions)) 
                {
                    foreach($expoptions as $key => $val)
                    {
                        $checked = "";
                        if($val == $seloptions[$val])
                        {
                            $checked = "checked=\"checked\"";
                        }
                        $code .= "<input type=\"checkbox\" class=\"checkbox\" name=\"profile_fields[$field][]\" id=\"{$field}{$key}\" value=\"$val\" $checked /> <span class=\"smalltext\">$val</span><br />";
                    }
                }
            }
            elseif($type == "textarea")
            {
                $value = htmlspecialchars_uni($userfield);
                $code = "<textarea name=\"profile_fields[$field]\" id=\"{$field}\" rows=\"6\" cols=\"30\" style=\"width: 95%\">$value</textarea>";
            }
            else
            {
                $value = htmlspecialchars_uni($userfield);
                $maxlength = "";
                if($profilefield['maxlength'] > 0)
                {
                    $maxlength = " maxlength=\"{$profilefield['maxlength']}\"";
                }
                $code = "<input type=\"text\" name=\"profile_fields[$field]\" id=\"{$field}\" class=\"textbox\" size=\"{$profilefield['length']}\"{$maxlength} value=\"$value\" />";
            }
            if($profilefield['required'] == 1)
            {
                // JS validator extra
                if($type == "checkbox" || $type == "radio")
                {
                    $id = "{$field}0";
                }
                else
                {
                    $id = "fid{$profilefield['fid']}";
                }
                $validator_extra .= "\tregValidator.register('{$id}', 'notEmpty', {failure_message:'{$lang->js_validator_not_empty}'});\n";
                
                eval("\$requiredfields .= \"".$templates->get("member_register_customfield")."\";");
            }
            $code = '';
            $select = '';
            $val = '';
            $options = '';
            $expoptions = '';
            $useropts = '';
            $seloptions = '';
        }
        if($requiredfields)
        {
            eval("\$requiredfields = \"".$templates->get("member_register_requiredfields")."\";");
        }
        if(!$fromreg)
        {
            $allownoticescheck = "checked=\"checked\"";
            $hideemailcheck = '';
            $emailnotifycheck = '';
            $receivepmscheck = "checked=\"checked\"";
            $pmnoticecheck = " checked=\"checked\"";
            $emailpmnotifycheck = '';
            $invisiblecheck = '';
            if($mybb->settings['dstcorrection'] == 1)
            {
                $enabledstcheck = "checked=\"checked\"";
            }
            
        }
        // Spambot registration image thingy
        if($mybb->settings['captchaimage'] == 1 && function_exists("imagecreatefrompng"))
        {
            $randomstr = random_str(5);
            $imagehash = md5(random_str(12));
            $regimagearray = array(
                "imagehash" => $imagehash,
                "imagestring" => $randomstr,
                "dateline" => TIME_NOW
            );
            $db->insert_query("captcha", $regimagearray);
            eval("\$regimage = \"".$templates->get("member_register_regimage")."\";");

            // JS validator extra
            $validator_extra .= "\tregValidator.register('imagestring', 'ajax', {url:'xmlhttp.php?action=validate_captcha', extra_body: 'imagehash', loading_message:'{$lang->js_validator_captcha_valid}', failure_message:'{$lang->js_validator_no_image_text}'});\n";
        }
        if($mybb->settings['regtype'] != "randompass")
        {
            // JS validator extra
            $lang->js_validator_password_length = $lang->sprintf($lang->js_validator_password_length, $mybb->settings['minpasswordlength']);
            $validator_extra .= "\tregValidator.register('pass', 'length', {match_field:'password2', min: {$mybb->settings['minpasswordlength']}, failure_message:'{$lang->js_validator_password_length}'});\n";

            // See if the board has "require complex passwords" enabled.
            if($mybb->settings['requirecomplexpasswords'] == 1)
            {
                $lang->pass = $lang->complex_pass = $lang->sprintf($lang->complex_pass, $mybb->settings['minpasswordlength']);
                $validator_extra .= "\tregValidator.register('pass', 'ajax', {url:'xmlhttp.php?action=complex_password', loading_message:'{$lang->js_validator_password_complexity}'});\n";
            }
            $validator_extra .= "\tregValidator.register('pass2', 'matches', {match_field:'pass', status_field:'password_status', failure_message:'{$lang->js_validator_password_matches}'});\n";

            eval("\$passboxes = \"".$templates->get("member_register_password")."\";");
        }

        // JS validator extra
        if($mybb->settings['maxnamelength'] > 0 && $mybb->settings['minnamelength'] > 0)
        {
            $lang->js_validator_username_length = $lang->sprintf($lang->js_validator_username_length, $mybb->settings['minnamelength'], $mybb->settings['maxnamelength']);
            $validator_extra .= "\tregValidator.register('account', 'length', {min: {$mybb->settings['minnamelength']}, max: {$mybb->settings['maxnamelength']}, failure_message:'{$lang->js_validator_username_length}'});\n";
        }

        $languages = $lang->get_languages();
        $langoptions = '';
        foreach($languages as $lname => $language)
        {
            $language = htmlspecialchars_uni($language);
            if($user['language'] == $lname)
            {
                $langoptions .= "<option value=\"$lname\" selected=\"selected\">$language</option>\n";
            }
            else
            {
                $langoptions .= "<option value=\"$lname\">$language</option>\n";
            }
        }

        $plugins->run_hooks("member_register_end");

        eval("\$registration = \"".$templates->get("member_register")."\";");
        output_page($registration);
    }
}

if($mybb->input['action'] == "activate")
{
    $plugins->run_hooks("member_activate_start");

    if($mybb->input['account'])
    {
        $query = $db->simple_select("accounts", "*", "LOWER(account)='".$db->escape_string(my_strtolower($mybb->input['account']))."'", array('limit' => 1));
        $user = $db->fetch_array($query);
        if(!$accouts['account'])
        {
            error($lang->error_invalidpworusername);
        }
        $guid = $user['guid'];
    }
    else
    {
        $query = $db->simple_select("accounts", "*", "guid='".intval($mybb->input['guid'])."'");
        $user = $db->fetch_array($query);
    }
    if($mybb->input['code'] && $user['guid'])
    {
        $mybb->settings['awaitingusergroup'] = "5";
        $query = $db->simple_select("awaitingactivation", "*", "guid='".$user['guid']."' AND (type='r' OR type='e')");
        $activation = $db->fetch_array($query);
        if(!$activation['guid'])
        {
            error($lang->error_alreadyactivated);
        }
        if($activation['code'] != $mybb->input['code'])
        {
            error($lang->error_badactivationcode);
        }
        $db->delete_query("awaitingactivation", "guid='".$user['guid']."' AND (type='r' OR type='e')");
        if($user['usergroup'] == 5 && $activation['type'] != "e")
        {
            $db->update_query("accounts", array("usergroup" => 2), "guid='".$user['guid']."'");
        }
        if($activation['type'] == "e")
        {
            $newemail = array(
                "email" => $db->escape_string($activation['misc']),
                );
            $db->update_query("accounts", $newemail, "guid='".$user['guid']."'");
            $plugins->run_hooks("member_activate_emailupdated");

            redirect("usercp.php", $lang->redirect_emailupdated);
        }
        else
        {
            $plugins->run_hooks("member_activate_accountactivated");

            redirect("index.php", $lang->redirect_accountactivated);
        }
    }
    else
    {
        $plugins->run_hooks("member_activate_form");

        eval("\$activate = \"".$templates->get("member_activate")."\";");
        output_page($activate);
    }
}

if($mybb->input['action'] == "resendactivation")
{
    $plugins->run_hooks("member_resendactivation");

    if($mybb->settings['regtype'] == "admin")
    {
        error($lang->error_activated_by_admin);
    }

    eval("\$activate = \"".$templates->get("member_resendactivation")."\";");
    output_page($activate);
}

if($mybb->input['action'] == "do_resendactivation" && $mybb->request_method == "post")
{
    $plugins->run_hooks("member_do_resendactivation_start");

    if($mybb->settings['regtype'] == "admin")
    {
        error($lang->error_activated_by_admin);
    }

    $query = $db->query("
        SELECT u.guid, u.account, u.usergroup, u.email, a.code
        FROM ".TABLE_PREFIX."accounts u
        LEFT JOIN ".TABLE_PREFIX."awaitingactivation a ON (a.guid=u.guid AND a.type='r')
        WHERE u.email='".$db->escape_string($mybb->input['email'])."'
    ");
    $numusers = $db->num_rows($query);
    if($numusers < 1)
    {
        error($lang->error_invalidemail);
    }
    else
    {
        while($user = $db->fetch_array($query))
        {
            if($user['usergroup'] == 5)
            {
                if(!$user['code'])
                {
                    $user['code'] = random_str();
                    $now = TIME_NOW;
                    $guid = $user['guid'];
                    $awaitingarray = array(
                        "guid" => $guid,
                        "dateline" => TIME_NOW,
                        "code" => $user['code'],
                        "type" => "r"
                    );
                    $db->insert_query("awaitingactivation", $awaitingarray);
                }
                $account= $user['account'];
                $email = $user['email'];
                $activationcode = $user['code'];
                $emailsubject = $lang->sprintf($lang->emailsubject_activateaccount, $mybb->settings['bbname']);
                $emailmessage = $lang->sprintf($lang->email_activateaccount, $user['account'], $mybb->settings['bbname'], $mybb->settings['bburl'], $user['guid'], $activationcode);
                my_mail($email, $emailsubject, $emailmessage);
            }
        }
        $plugins->run_hooks("member_do_resendactivation_end");

        redirect("index.php", $lang->redirect_activationresent);
    }
}

if($mybb->input['action'] == "lostpw")
{
    $plugins->run_hooks("member_lostpw");

    eval("\$lostpw = \"".$templates->get("member_lostpw")."\";");
    output_page($lostpw);
}

if($mybb->input['action'] == "do_lostpw" && $mybb->request_method == "post")
{
    $plugins->run_hooks("member_do_lostpw_start");

    $email = $db->escape_string($email);
    $query = $db->simple_select("accounts", "*", "email='".$db->escape_string($mybb->input['email'])."'");
    $numusers = $db->num_rows($query);
    if($numusers < 1)
    {
        error($lang->error_invalidemail);
    }
    else
    {
        while($user = $db->fetch_array($query))
        {
            $db->delete_query("awaitingactivation", "guid='{$user['guid']}' AND type='p'");
            $user['activationcode'] = random_str();
            $now = TIME_NOW;
            $guid = $user['guid'];
            $awaitingarray = array(
                "guid" => $user['guid'],
                "dateline" => TIME_NOW,
                "code" => $user['activationcode'],
                "type" => "p"
            );
            $db->insert_query("awaitingactivation", $awaitingarray);
            $account = $user['account'];
            $email = $user['email'];
            $activationcode = $user['activationcode'];
            $emailsubject = $lang->sprintf($lang->emailsubject_lostpw, $mybb->settings['bbname']);
            $emailmessage = $lang->sprintf($lang->email_lostpw, $account, $mybb->settings['bbname'], $mybb->settings['bburl'], $guid, $activationcode);
            my_mail($email, $emailsubject, $emailmessage);
        }
    }
    $plugins->run_hooks("member_do_lostpw_end");

    redirect("index.php", $lang->redirect_lostpwsent);
}

if($mybb->input['action'] == "resetpassword")
{
    $plugins->run_hooks("member_resetpassword_start");

    if($mybb->input['account'])
    {
        $query = $db->simple_select("accounts", "*", "LOWER(account)='".$db->escape_string(my_strtolower($mybb->input['account']))."'");
        $user = $db->fetch_array($query);
        if(!$user['guid'])
        {
            error($lang->error_invalidpworusername);
        }
    }
    else
    {
        $query = $db->simple_select("accounts", "*", "guid='".intval($mybb->input['guid'])."'");
        $user = $db->fetch_array($query);
    }
    if($mybb->input['code'] && $user['guid'])
    {
        $query = $db->simple_select("awaitingactivation", "*", "guid='".$user['guid']."' AND type='p'");
        $activation = $db->fetch_array($query);
        $now = TIME_NOW;
        if($activation['code'] != $mybb->input['code'])
        {
            error($lang->error_badlostpwcode);
        }
        $db->delete_query("awaitingactivation", "guid='".$user['guid']."' AND type='p'");
        $account= $user['account'];

        // Generate a new pass, then update it
        $pass = random_str();
        $logindetails = update_password($user['guid'], md5($pass), $user['salt']);

        $email = $user['email'];

        $plugins->run_hooks("member_resetpassword_process");

        $emailsubject = $lang->sprintf($lang->emailsubject_passwordreset, $mybb->settings['bbname']);
        $emailmessage = $lang->sprintf($lang->email_passwordreset, $account, $mybb->settings['bbname'], $pass);
        my_mail($email, $emailsubject, $emailmessage);

        $plugins->run_hooks("member_resetpassword_reset");

        error($lang->redirect_passwordreset);
    }
    else
    {
        $plugins->run_hooks("member_resetpassword_form");

        eval("\$activate = \"".$templates->get("member_resetpassword")."\";");
        output_page($activate);
    }
}

$do_captcha = $correct = false;
$inline_errors = "";
if($mybb->input['action'] == "do_login" && $mybb->request_method == "post")
{
    $plugins->run_hooks("member_do_login_start");
    
    // Checks to make sure the user can login; they haven't had too many tries at logging in.
    // Is a fatal call if user has had too many tries
    $logins = login_attempt_check();
    $login_text = '';
    
    // Did we come from the quick login form
    if($mybb->input['quick_login'] == "1" && $mybb->input['quick_password'] && $mybb->input['quick_username'])
    {
        $mybb->input['pass'] = $mybb->input['quick_password'];
        $mybb->input['account'] = $mybb->input['quick_username'];
        $mybb->input['remember'] = $mybb->input['quick_remember'];
    }

    if(!username_exists($mybb->input['account']))
    {
        my_setcookie('loginattempts', $logins + 1);
        error($lang->error_invalidpworusername.$login_text);
    }
    
    $query = $db->simple_select("accounts", "loginattempts", "LOWER(account)='".$db->escape_string(my_strtolower($mybb->input['account']))."'", array('limit' => 1));
    $loginattempts = $db->fetch_field($query, "loginattempts");
    
    $errors = array();
    
    $user = validate_password_from_username($mybb->input['account'], $mybb->input['pass']);
    if(!$user['guid'])
    {
        my_setcookie('loginattempts', $logins + 1);
        $db->update_query("accounts", array('loginattempts' => 'loginattempts+1'), "LOWER(account) = '".$db->escape_string(my_strtolower($mybb->input['account']))."'", 1, true);
        
        $mybb->input['action'] = "login";
        $mybb->input['request_method'] = "get";
        
        if($mybb->settings['failedlogincount'] != 0 && $mybb->settings['failedlogintext'] == 1)
        {
            $login_text = $lang->sprintf($lang->failed_login_again, $mybb->settings['failedlogincount'] - $logins);
        }
        
        $errors[] = $lang->error_invalidpworusername.$login_text;
    }
    else
    {
        $correct = true;
    }
    
    if($mybb->settings['failedcaptchalogincount'] > 0 && ($loginattempts > $mybb->settings['failedcaptchalogincount'] || intval($mybb->cookies['loginattempts']) > $mybb->settings['failedcaptchalogincount']))
    {        
        // Show captcha image if enabled
        if($mybb->settings['captchaimage'] == 1 && function_exists("imagepng"))
        {
            // Check their current captcha input - if correct, hide the captcha input area
            if($mybb->input['imagestring'])
            {
                $imagehash = $db->escape_string($mybb->input['imagehash']);
                $imagestring = $db->escape_string($mybb->input['imagestring']);
                $query = $db->simple_select("captcha", "*", "imagehash='{$imagehash}' AND imagestring='{$imagestring}'");
                $imgcheck = $db->fetch_array($query);
                if($imgcheck['dateline'] > 0)
                {
                    $correct = true;
                }
                else
                {
                    $db->delete_query("captcha", "imagehash='{$imagehash}'");
                    $errors[] = $lang->error_regimageinvalid;
                }
            }
            else if($mybb->input['quick_login'] == 1 && $mybb->input['quick_password'] && $mybb->input['quick_username'])
            {
                $errors[] = $lang->error_regimagerequired;
            }
            else
            {
                $errors[] = $lang->error_regimagerequired;
            }
        }
        
        $do_captcha = true;
    }
    
    if(!empty($errors))
    {
        $mybb->input['action'] = "login";
        $mybb->input['request_method'] = "get";
        
        $inline_errors = inline_error($errors);
    }
    else if($correct)
    {        
        if($user['coppauser'])
        {
            error($lang->error_awaitingcoppa);
        }
        
        my_setcookie('loginattempts', 1);
        $db->delete_query("sessions", "ip='".$db->escape_string($session->ipaddress)."' AND sid != '".$session->sid."'");
        $newsession = array(
            "guid" => $user['guid'],
        );
        $db->update_query("sessions", $newsession, "sid='".$session->sid."'");
        
        $db->update_query("accounts", array("loginattempts" => 1), "guid='{$user['guid']}'");
        
        if($mybb->input['remember'] != "yes")
        {
            $remember = -1;
        }
        else
        {
            $remember = null;
        }
        my_setcookie("mybbuser", $user['guid']."_".$user['loginkey'], $remember, true);
        my_setcookie("sid", $session->sid, -1, true);
        
        $plugins->run_hooks("member_do_login_end");
        
        if($mybb->input['url'] != "" && my_strpos(basename($mybb->input['url']), 'member.php') === false)
        {
            if((my_strpos(basename($mybb->input['url']), 'newthread.php') !== false || my_strpos(basename($mybb->input['url']), 'newreply.php') !== false) && my_strpos($mybb->input['url'], '&processed=1') !== false)
            {
                $mybb->input['url'] = str_replace('&processed=1', '', $mybb->input['url']);
            }
            
            $mybb->input['url'] = str_replace('&amp;', '&', $mybb->input['url']);
            
            // Redirect to the URL if it is not member.php
            redirect(htmlentities($mybb->input['url']), $lang->redirect_loggedin);
        }
        else
        {
            redirect("index.php", $lang->redirect_loggedin);
        }
    }
    else
    {
        $mybb->input['action'] = "login";
        $mybb->input['request_method'] = "get";
    }
    
    $plugins->run_hooks("member_do_login_end");
}

if($mybb->input['action'] == "login")
{
    $plugins->run_hooks("member_login");
    
    $member_loggedin_notice = "";
    if($mybb->user['guid'] != 0)
    {
        $lang->already_logged_in = $lang->sprintf($lang->already_logged_in, build_profile_link($mybb->user['account'], $mybb->user['guid']));
        eval("\$member_loggedin_notice = \"".$templates->get("member_loggedin_notice")."\";");
    }

    // Checks to make sure the user can login; they haven't had too many tries at logging in.
    // Is a fatal call if user has had too many tries
    login_attempt_check();

    // Redirect to the page where the user came from, but not if that was the login page.
    if($mybb->input['url'] && !preg_match("/action=login/i", $mybb->input['url']))
    {
        $redirect_url = htmlentities($mybb->input['url']);
    }
    elseif($_SERVER['HTTP_REFERER'])
    {
        $redirect_url = htmlentities($_SERVER['HTTP_REFERER']);
    }
        
    $captcha = "";
    // Show captcha image for guests if enabled
    if($mybb->settings['captchaimage'] == 1 && function_exists("imagepng") && $do_captcha == true)
    {
        $randomstr = random_str(5);
        $imagehash = md5(random_str(12));
        $imagearray = array(
            "imagehash" => $imagehash,
            "imagestring" => $randomstr,
            "dateline" => TIME_NOW
        );
        $db->insert_query("captcha", $imagearray);
        eval("\$captcha = \"".$templates->get("post_captcha")."\";");
    }
    
    $account = "";
    $pass = "";
    if($mybb->input['account'] && $mybb->request_method == "post")
    {
        $account= htmlspecialchars_uni($mybb->input['account']);
    }
    
    if($mybb->input['pass'] && $mybb->request_method == "post")
    {
        $pass = htmlspecialchars_uni($mybb->input['pass']);
    }

    eval("\$login = \"".$templates->get("member_login")."\";");
    output_page($login);
}

if($mybb->input['action'] == "logout")
{
    $plugins->run_hooks("member_logout_start");

    if(!$mybb->user['guid'])
    {
        redirect("index.php", $lang->redirect_alreadyloggedout);
    }

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

    my_unsetcookie("mybbuser");
    my_unsetcookie("sid");
    if($mybb->user['guid'])
    {
        $time = TIME_NOW;
        $lastvisit = array(
            "lastactive" => $time-900,
            "lastvisit" => $time,
        );
        $db->update_query("accounts", $lastvisit, "guid='".$mybb->user['guid']."'");
        $db->delete_query("sessions", "sid='".$session->sid."'");
    }
    $plugins->run_hooks("member_logout_end");
    redirect("index.php", $lang->redirect_loggedout);
}

if($mybb->input['action'] == "profile")
{
    $plugins->run_hooks("member_profile_start");

    if($mybb->usergroup['canviewprofiles'] == 0)
    {
        error_no_permission();
    }
    if($mybb->input['guid'] == "lastposter")
    {
        if($mybb->input['tid'])
        {
            $query = $db->simple_select("posts", "guid", "tid='".intval($mybb->input['tid'])."' AND visible = 1", array('order_by' => 'dateline', 'order_dir' => 'DESC', 'limit' => '1'));
            $post = $db->fetch_array($query);
            $guid = $post['guid'];
        }
        elseif($mybb->input['fid'])
        {
            $flist = '';
            switch($db->type)
            {
                case "pgsql":
                case "sqlite":
                    $query = $db->simple_select("forums", "fid", "INSTR(','||parentlist||',',',".intval($mybb->input['fid']).",') > 0");
                    break;
                default:
                    $query = $db->simple_select("forums", "fid", "INSTR(CONCAT(',',parentlist,','),',".intval($mybb->input['fid']).",') > 0");
            }
            
            while($forum = $db->fetch_array($query))
            {
                if($forum['fid'] == $mybb->input['fid'])
                {
                    $theforum = $forum;
                }
                $flist .= ",".$forum['fid'];
            }
            $query = $db->simple_select("threads", "tid", "fid IN (0$flist) AND visible = 1", array('order_by' => 'lastpost', 'order_dir' => 'DESC', 'limit' => '1'));
            $thread = $db->fetch_array($query);
            $tid = $thread['tid'];
            $query = $db->simple_select("posts", "guid", "tid='$tid' AND visible = 1", array('order_by' => 'dateline', 'order_dir' => 'DESC', 'limit' => '1'));
            $post = $db->fetch_array($query);
            $guid = $post['guid'];
        }
    }
    else
    {
        if($mybb->input['guid'])
        {
            $gguid = intval($mybb->input['guid']);
        }
        else
        {
            $guid = $mybb->user['guid'];
        }
    }
    
    if($mybb->user['guid'] != $guid)
    {
        $query = $db->simple_select("accounts", "*", "guid='$guid'");
        $memprofile = $db->fetch_array($query);
    }
    else
    {
        $memprofile = $mybb->user;
    }
    
    $lang->profile = $lang->sprintf($lang->profile, $memprofile['account']);

    if(!$memprofile['guid'])
    {
        error($lang->error_nomember);
    }

    // Get member's permissions
    $memperms = user_permissions($memprofile['guid']);

    $lang->nav_profile = $lang->sprintf($lang->nav_profile, $memprofile['account']);
    add_breadcrumb($lang->nav_profile);

    $lang->users_forum_info = $lang->sprintf($lang->users_forum_info, $memprofile['account']);
    $lang->users_contact_details = $lang->sprintf($lang->users_contact_details, $memprofile['account']);

    if($mybb->settings['enablepms'] != 0 && $memprofile['receivepms'] != 0 && $memperms['canusepms'] != 0 && my_strpos(",".$memprofile['ignorelist'].",", ",".$mybb->user['guid'].",") === false)
    {
        $lang->send_pm = $lang->sprintf($lang->send_pm, $memprofile['account']);
    }
    else
    {
        $lang->send_pm = '';
    }
    $lang->away_note = $lang->sprintf($lang->away_note, $memprofile['account']);
    $lang->users_additional_info = $lang->sprintf($lang->users_additional_info, $memprofile['account']);
    $lang->users_signature = $lang->sprintf($lang->users_signature, $memprofile['account']);
    $lang->send_user_email = $lang->sprintf($lang->send_user_email, $memprofile['account']);

    if($memprofile['avatar'])
    {
        $memprofile['avatar'] = htmlspecialchars_uni($memprofile['avatar']);
        $avatar_dimensions = explode("|", $memprofile['avatardimensions']);
        if($avatar_dimensions[0] && $avatar_dimensions[1])
        {
            $avatar_width_height = "width=\"{$avatar_dimensions[0]}\" height=\"{$avatar_dimensions[1]}\"";
        }
        $avatar = "<img src=\"{$memprofile['avatar']}\" alt=\"\" $avatar_width_height />";
    }
    else
    {
        $avatar = '';
    }

    if($memprofile['hideemail'] != 1)
    {
        eval("\$sendemail = \"".$templates->get("member_profile_email")."\";");
    }
    else
    {
        $alttrow = "trow1"; // To properly sort the contact details below
        $sendemail = '';
    }

    // Clean alt_trow for the contact details
    $cat_array = array(
        "pm",
        "icq",
        "aim",
        "yahoo",
        "msn",
    );

    $bgcolors = array();
    foreach($cat_array as $cat)
    {
        $bgcolors[$cat] = alt_trow();
    }

    if($memprofile['website'])
    {
        $memprofile['website'] = htmlspecialchars_uni($memprofile['website']);
        $website = "<a href=\"{$memprofile['website']}\" target=\"_blank\">{$memprofile['website']}</a>";
    }
    else
    {
        $website = '';
    }

    if($memprofile['signature'] && ($memprofile['suspendsignature'] == 0 || $memprofile['suspendsigtime'] < TIME_NOW))
    {
        $sig_parser = array(
            "allow_html" => $mybb->settings['sightml'],
            "allow_mycode" => $mybb->settings['sigmycode'],
            "allow_smilies" => $mybb->settings['sigsmilies'],
            "allow_imgcode" => $mybb->settings['sigimgcode'],
            "me_username" => $memprofile['account']
        );

        $memprofile['signature'] = $parser->parse_message($memprofile['signature'], $sig_parser);
        eval("\$signature = \"".$templates->get("member_profile_signature")."\";");
    }

    $daysreg = (TIME_NOW - $memprofile['regdate']) / (24*3600);
    $ppd = $memprofile['postnum'] / $daysreg;
    $ppd = round($ppd, 2);
    if($ppd > $memprofile['postnum'])
    {
        $ppd = $memprofile['postnum'];
    }
    $stats = $cache->read("stats");
    $numposts = $stats['numposts'];
    if($numposts == 0)
    {
        $percent = "0";
    }
    else
    {
        $percent = $memprofile['postnum']*100/$numposts;
        $percent = round($percent, 2);
    }
    
    if($percent > 100)
    {
        $percent = 100;
    }

    if(!empty($memprofile['icq']))
    {
        $memprofile['icq'] = intval($memprofile['icq']);
    }
    else
    {
        $memprofile['icq'] = '';
    }

    if($memprofile['away'] == 1 && $mybb->settings['allowaway'] != 0)
    {
        $lang->away_note = $lang->sprintf($lang->away_note, $memprofile['account']);
        $awaydate = my_date($mybb->settings['dateformat'], $memprofile['awaydate']);
        if(!empty($memprofile['awayreason']))
        {
            $awayreason = htmlspecialchars_uni($memprofile['awayreason']);
        }
        else
        {
            $awayreason = $lang->away_no_reason;
        }
        if($memprofile['returndate'] == '')
        {
            $returndate = "$lang->unknown";
        }
        else
        {
            $returnhome = explode("-", $memprofile['returndate']);
            if($returnhome[2] >= 2038)
            {
                require_once MYBB_ROOT."inc/functions_time.php";
                $returnmkdate = adodb_mktime(0, 0, 0, $returnhome[1], $returnhome[0], $returnhome[2]);
                $returndate = my_date($mybb->settings['dateformat'], $returnmkdate, "", 1, true);
            }
            else
            {
                $returnmkdate = mktime(0, 0, 0, $returnhome[1], $returnhome[0], $returnhome[2]);
                $returndate = my_date($mybb->settings['dateformat'], $returnmkdate);
            }
        }
        eval("\$awaybit = \"".$templates->get("member_profile_away")."\";");
    }
    if($memprofile['dst'] == 1)
    {
        $memprofile['timezone']++;
        if(my_substr($memprofile['timezone'], 0, 1) != "-")
        {
            $memprofile['timezone'] = "+{$memprofile['timezone']}";
        }
    }
    $memregdate = my_date($mybb->settings['dateformat'], $memprofile['regdate']);
    $memlocaldate = gmdate($mybb->settings['dateformat'], TIME_NOW + ($memprofile['timezone'] * 3600));
    $memlocaltime = gmdate($mybb->settings['timeformat'], TIME_NOW + ($memprofile['timezone'] * 3600));

    $localtime = $lang->sprintf($lang->local_time_format, $memlocaldate, $memlocaltime);

    if($memprofile['lastactive'])
    {
        $memlastvisitdate = my_date($mybb->settings['dateformat'], $memprofile['lastactive']);
        $memlastvisitsep = $lang->comma;
        $memlastvisittime = my_date($mybb->settings['timeformat'], $memprofile['lastactive']);
    }
    else
    {
        $memlastvisitdate = $lang->lastvisit_never;
        $memlastvisitsep = '';
        $memlastvisittime = '';
    }

    if($memprofile['birthday'])
    {
        $membday = explode("-", $memprofile['birthday']);
        
        if($memprofile['birthdayprivacy'] != 'none')
        {
            if($membday[2])
            {
                $lang->membdayage = $lang->sprintf($lang->membdayage, get_age($memprofile['birthday']));
                
                if($membday[2] >= 1970)
                {
                    $w_day = date("l", mktime(0, 0, 0, $membday[1], $membday[0], $membday[2]));
                    $membday = format_bdays($mybb->settings['dateformat'], $membday[1], $membday[0], $membday[2], $w_day);
                }
                else
                {
                    $bdayformat = fix_mktime($mybb->settings['dateformat'], $membday[2]);
                    $membday = mktime(0, 0, 0, $membday[1], $membday[0], $membday[2]);
                    $membday = date($bdayformat, $membday);
                }
                $membdayage = $lang->membdayage;
            }
            else
            {
                $membday = mktime(0, 0, 0, $membday[1], $membday[0], 0);
                $membday = date("F j", $membday);
                $membdayage = '';
            }
        }
        
        if($memprofile['birthdayprivacy'] == 'age')
        {
            $membday = $lang->birthdayhidden;
        }
        else if($memprofile['birthdayprivacy'] == 'none')
        {
            $membday = $lang->birthdayhidden;
            $membdayage = '';
        }
    }
    else
    {
        $membday = $lang->not_specified;
        $membdayage = '';
    }
    
    if(!$memprofile['displaygroup'])
    {
        $memprofile['displaygroup'] = $memprofile['usergroup'];
    }

    // Grab the following fields from the user's displaygroup
    $displaygroupfields = array(
        "title",
        "usertitle",
        "stars",
        "starimage",
        "image",
        "usereputationsystem"
    );
    $displaygroup = usergroup_displaygroup($memprofile['displaygroup']);

    // Get the user title for this user
    unset($usertitle);
    unset($stars);
    if(trim($memprofile['usertitle']) != '')
    {
        // User has custom user title
        $usertitle = $memprofile['usertitle'];
    }
    elseif(trim($displaygroup['usertitle']) != '')
    {
        // User has group title
        $usertitle = $displaygroup['usertitle'];
    }
    else
    {
        // No usergroup title so get a default one
        $query = $db->simple_select("usertitles", "*", "", array('order_by' => 'posts', 'order_dir' => 'DESC'));
        while($title = $db->fetch_array($query))
        {
            if($memprofile['postnum'] >= $title['posts'])
            {
                $usertitle = $title['title'];
                $stars = $title['stars'];
                $starimage = $title['starimage'];
                break;
            }
        }
    }
    
    if($displaygroup['stars'] || $displaygroup['usertitle'])
    {
        // Set the number of stars if display group has constant number of stars
        $stars = $displaygroup['stars'];
    }
    elseif(!$stars)
    {
        // This is for cases where the user has a title, but the group has no defined number of stars (use number of stars as per default usergroups)
        $query = $db->simple_select("usertitles", "*", "", array('order_by' => 'posts', 'order_dir' => 'DESC'));
        while($title = $db->fetch_array($query))
        {
            if($memprofile['postnum'] >= $title['posts'])
            {
                $stars = $title['stars'];
                $starimage = $title['starimage'];
                break;
            }
        }
    }

    if(!empty($displaygroup['image']))
    {
        if(!empty($mybb->user['language']))
        {
            $language = $mybb->user['language'];
        }
        else
        {
            $language = $mybb->settings['bblanguage'];
        }
        $displaygroup['image'] = str_replace("{lang}", $language, $displaygroup['image']);
        $displaygroup['image'] = str_replace("{theme}", $theme['imgdir'], $displaygroup['image']);
        eval("\$groupimage = \"".$templates->get("member_profile_groupimage")."\";");
    }

    if(!$starimage)
    {
        $starimage = $displaygroup['starimage'];
    }

    if($starimage)
    {
        // Only display stars if we have an image to use...
        $starimage = str_replace("{theme}", $theme['imgdir'], $starimage);
        $userstars = '';
        for($i = 0; $i < $stars; ++$i)
        {
            $userstars .= "<img src=\"$starimage\" border=\"0\" alt=\"*\" />";
        }
    }
    
    // User is currently online and this user has permissions to view the user on the WOL
    $timesearch = TIME_NOW - $mybb->settings['wolcutoffmins']*60;
    $query = $db->simple_select("sessions", "location,nopermission", "guid='$guid' AND time>'{$timesearch}'", array('order_by' => 'time', 'order_dir' => 'DESC', 'limit' => 1));
    $session = $db->fetch_array($query);
    
    if(($memprofile['invisible'] != 1 || $mybb->usergroup['canviewwolinvis'] == 1 || $memprofile['guid'] == $mybb->user['guid']) && !empty($session))
    {
        // Fetch their current location
        $lang->load("online");
        require_once MYBB_ROOT."inc/functions_online.php";
        $activity = fetch_wol_activity($session['location'], $session['nopermission']);
        $location = build_friendly_wol_location($activity);
        $location_time = my_date($mybb->settings['timeformat'], $memprofile['lastactive']);

        eval("\$online_status = \"".$templates->get("member_profile_online")."\";");
    }
    // User is offline
    else
    {
        eval("\$online_status = \"".$templates->get("member_profile_offline")."\";");
    }

    // Build Referral
    if($mybb->settings['usereferrals'] == 1)
    {
        // Reset the background colours to keep it inline
        $bg_color = alt_trow(true);

        eval("\$referrals = \"".$templates->get("member_profile_referrals")."\";");
    }
    else
    {
        // Manually set to override colours...
        $alttrow = 'trow2';
    }

    // Fetch the reputation for this user
    if($memperms['usereputationsystem'] == 1 && $displaygroup['usereputationsystem'] == 1 && $mybb->settings['enablereputation'] == 1)
    {
        $bg_color = alt_trow();
        $reputation = get_reputation($memprofile['reputation']);

        // If this user has permission to give reputations show the vote link
        if($mybb->usergroup['cangivereputations'] == 1 && $memprofile['guid'] != $mybb->user['guid'])
        {
            $vote_link = "[<a href=\"javascript:MyBB.reputation({$memprofile['guid']});\">{$lang->reputation_vote}</a>]";
        }

        eval("\$reputation = \"".$templates->get("member_profile_reputation")."\";");
    }

    if($mybb->settings['enablewarningsystem'] != 0 && $memperms['canreceivewarnings'] != 0 && ($mybb->usergroup['canwarnusers'] != 0 || ($mybb->user['guid'] == $memprofile['guid'] && $mybb->settings['canviewownwarning'] != 0)))
    {
        $bg_color = alt_trow();
        $warning_level = round($memprofile['warningpoints']/$mybb->settings['maxwarningpoints']*100);
        if($warning_level > 100)
        {
            $warning_level = 100;
        }
        $warning_level = get_colored_warning_level($warning_level);
        if($mybb->usergroup['canwarnusers'] != 0 && $memprofile['guid'] != $mybb->user['guid'])
        {
            eval("\$warn_user = \"".$templates->get("member_profile_warn")."\";");
            $warning_link = "warnings.php?guid={$memprofile['guid']}";
        }
        else
        {
            $warning_link = "usercp.php";
        }
        eval("\$warning_level = \"".$templates->get("member_profile_warninglevel")."\";");
    }

    $query = $db->simple_select("userfields", "*", "ufid='$guid'");
    $userfields = $db->fetch_array($query);
    $customfields = '';
    $bgcolor = "trow1";
    $alttrow = "trow1";
    // If this user is an Administrator or a Moderator then we wish to show all profile fields
    if($mybb->usergroup['cancp'] == 1 || $mybb->usergroup['issupermod'] == 1 || $mybb->usergroup['canmodcp'] == 1)
    {
        $field_hidden = '1=1';
    }
    else
    {
        $field_hidden = "hidden=0";
    }
    $query = $db->simple_select("profilefields", "*", "{$field_hidden}", array('order_by' => 'disporder'));
    while($customfield = $db->fetch_array($query))
    {
        $thing = explode("\n", $customfield['type'], "2");
        $type = trim($thing[0]);

        $field = "fid{$customfield['fid']}";
        $useropts = explode("\n", $userfields[$field]);
        $customfieldval = $comma = '';
        if(is_array($useropts) && ($type == "multiselect" || $type == "checkbox"))
        {
            foreach($useropts as $val)
            {
                if($val != '')
                {
                    $customfieldval .= "<li style=\"margin-left: 0;\">{$val}</li>";
                }
            }
            if($customfieldval != '')
            {
                $customfieldval = "<ul style=\"margin: 0; padding-left: 15px;\">{$customfieldval}</ul>";
            }
        }
        else
        {
            if($customfield['type'] == "textarea")
            {
                $customfieldval = nl2br(htmlspecialchars_uni($userfields[$field]));
            }
            else
            {
                $customfieldval = htmlspecialchars_uni($userfields[$field]);
            }
        }
        eval("\$customfields .= \"".$templates->get("member_profile_customfields_field")."\";");
        $bgcolor = alt_trow();
    }
    if($customfields)
    {
        eval("\$profilefields = \"".$templates->get("member_profile_customfields")."\";");
    }
    $memprofile['postnum'] = my_number_format($memprofile['postnum']);
    $lang->ppd_percent_total = $lang->sprintf($lang->ppd_percent_total, my_number_format($ppd), $percent);
    $formattedname = format_name($memprofile['account'], $memprofile['usergroup'], $memprofile['displaygroup']);
    if($memprofile['timeonline'] > 0)
    {
        $timeonline = nice_time($memprofile['timeonline']);
    }
    else
    {
        $timeonline = $lang->none_registered;
    }
    
    if($mybb->usergroup['cancp'] == 1 && $mybb->config['hide_admin_links'] != 1)
    {
        eval("\$adminoptions = \"".$templates->get("member_profile_adminoptions")."\";");
    }
    else
    {
        $adminoptions = '';
    }
    
    if($mybb->usergroup['canmodcp'] == 1)
    {
        $memprofile['usernotes'] = nl2br(htmlspecialchars_uni($memprofile['usernotes']));
        
        if(!empty($memprofile['usernotes']))
        {
            if(strlen($memprofile['usernotes']) > 100)
            {
                $memprofile['usernotes'] = my_substr($memprofile['usernotes'], 0, 100).'...';
            }
        }
        else
        {
            $memprofile['usernotes'] = $lang->no_usernotes;
        }
        
        eval("\$modoptions = \"".$templates->get("member_profile_modoptions")."\";");
    }
    else
    {
        $modoptions = '';
    }
    
    $buddy_options = '';
    
    if($mybb->user['guid'] != $mybb->input['guid'] && $mybb->user['guid'] != 0)
    {
        $buddy_list = explode(',', $mybb->user['buddylist']);
        if(in_array($mybb->input['guid'], $buddy_list))
        {
            $buddy_options = "<br /><a href=\"./usercp.php?action=do_editlists&amp;delete={$mybb->input['guid']}&amp;my_post_key={$mybb->post_code}\"><img src=\"{$theme['imgdir']}/remove_buddy.gif\" /> {$lang->remove_from_buddy_list}</a>";
        }
        else
        {
            $buddy_options = "<br /><a href=\"./usercp.php?action=do_editlists&amp;add_username=".urlencode($memprofile['account'])."&amp;my_post_key={$mybb->post_code}\"><img src=\"{$theme['imgdir']}/add_buddy.gif\" /> {$lang->add_to_buddy_list}</a>";
        }
        
        $ignore_list = explode(',', $mybb->user['ignorelist']);
        if(in_array($mybb->input['guid'], $ignore_list))
        {
            $buddy_options .= "<br /><a href=\"./usercp.php?action=do_editlists&amp;manage=ignored&amp;delete={$mybb->input['guid']}&amp;my_post_key={$mybb->post_code}\"><img src=\"{$theme['imgdir']}/remove_ignore.gif\" /> {$lang->remove_from_ignore_list}</a>";
        }
        else
        {
            $buddy_options .= "<br /><a href=\"./usercp.php?action=do_editlists&amp;manage=ignored&amp;add_username=".urlencode($memprofile['account'])."&amp;my_post_key={$mybb->post_code}\"><img src=\"{$theme['imgdir']}/add_ignore.gif\" /> {$lang->add_to_ignore_list}</a>";
        }
    }

    $plugins->run_hooks("member_profile_end");
    
    eval("\$profile = \"".$templates->get("member_profile")."\";");
    output_page($profile);
}

if($mybb->input['action'] == "do_emailuser" && $mybb->request_method == "post")
{
    // Verify incoming POST request
    verify_post_check($mybb->input['my_post_key']);

    $plugins->run_hooks("member_do_emailuser_start");

    // Guests or those without permission can't email other accounts
    if($mybb->usergroup['cansendemail'] == 0 || !$mybb->user['guid'])
    {
        error_no_permission();
    }
    
    // Check group limits
    if($mybb->usergroup['maxemails'] > 0)
    {
        $query = $db->simple_select("maillogs", "COUNT(*) AS sent_count", "fromuid='{$mybb->user['guid']}' AND dateline >= '".(TIME_NOW - (60*60*24))."'");
        $sent_count = $db->fetch_field($query, "sent_count");
        if($sent_count >= $mybb->usergroup['maxemails'])
        {
            $lang->error_max_emails_day = $lang->sprintf($lang->error_max_emails_day, $mybb->usergroup['maxemails']);
            error($lang->error_max_emails_day);
        }
    }
    
    $query = $db->simple_select("accounts", "guid, account, email, hideemail", "guid='".intval($mybb->input['guid'])."'");
    $to_user = $db->fetch_array($query);
    
    if(!$to_user['account'])
    {
        error($lang->error_invalidusername);
    }
    
    if($to_user['hideemail'] != 0)
    {
        error($lang->error_hideemail);
    }
    
    if(empty($mybb->input['subject']))
    {
        $errors[] = $lang->error_no_email_subject;
    }
    
    if(empty($mybb->input['message']))
    {
        $errors[] = $lang->error_no_email_message;
    }

    if(count($errors) == 0)
    {
        if($mybb->settings['mail_handler'] == 'smtp')
        {
            $from = $mybb->user['email'];
        }
        else
        {
            $from = "{$mybb->user['account']} <{$mybb->user['email']}>";
        }
        
        $message = $lang->sprintf($lang->email_emailuser, $to_user['account'], $mybb->user['account'], $mybb->settings['bbname'], $mybb->settings['bburl'], $mybb->input['message']);
        my_mail($to_user['email'], $mybb->input['subject'], $message, $from, "", "", false, "text", "", $mybb->user['email']);
        
        if($mybb->settings['mail_logging'] > 0)
        {
            // Log the message
            $log_entry = array(
                "subject" => $db->escape_string($mybb->input['subject']),
                "message" => $db->escape_string($mybb->input['message']),
                "dateline" => TIME_NOW,
                "fromuid" => $mybb->user['guid'],
                "fromemail" => $db->escape_string($mybb->user['email']),
                "touid" => $to_user['guid'],
                "toemail" => $db->escape_string($to_user['email']),
                "tid" => 0,
                "ipaddress" => $db->escape_string($session->ipaddress)
            );
            $db->insert_query("maillogs", $log_entry);
        }

        $plugins->run_hooks("member_do_emailuser_end");

        redirect(get_profile_link($to_user['guid']), $lang->redirect_emailsent);
    }
    else
    {
        $mybb->input['action'] = "emailuser";
    }
}

if($mybb->input['action'] == "emailuser")
{
    $plugins->run_hooks("member_emailuser_start");

    // Guests or those without permission can't email other accounts
    if($mybb->usergroup['cansendemail'] == 0 || !$mybb->user['guid'])
    {
        error_no_permission();
    }
    
    // Check group limits
    if($mybb->usergroup['maxemails'] > 0)
    {
        $query = $db->simple_select("maillogs", "COUNT(*) AS sent_count", "fromuid='{$mybb->user['guid']}' AND dateline >= '".(TIME_NOW - (60*60*24))."'");
        $sent_count = $db->fetch_field($query, "sent_count");
        if($sent_count > $mybb->usergroup['maxemails'])
        {
            $lang->error_max_emails_day = $lang->sprintf($lang->error_max_emails_day, $mybb->usergroup['maxemails']);
            error($lang->error_max_emails_day);
        }
    }    
    
    $query = $db->simple_select("accounts", "guid, account, email, hideemail", "guid='".intval($mybb->input['guid'])."'");
    $to_user = $db->fetch_array($query);
    
    $lang->email_user = $lang->sprintf($lang->email_user, $to_user['account']);
    
    if(!$to_user['guid'])
    {
        error($lang->error_invaliduser);
    }
    
    if($to_user['hideemail'] != 0)
    {
        error($lang->error_hideemail);
    }
    
    if(count($errors) > 0)
    {
        $errors = inline_error($errors);
        $subject = htmlspecialchars_uni($mybb->input['subject']);
        $message = htmlspecialchars_uni($mybb->input['message']);
    }
    else
    {
        $errors = '';
        $subject = '';
        $message = '';
    }
    
    $plugins->run_hooks("member_emailuser_end");
    
    eval("\$emailuser = \"".$templates->get("member_emailuser")."\";");
    output_page($emailuser);
}

if(!$mybb->input['action'])
{
    header("Location: index.php");
}
?>