1. IMPORTANT : Nouvelles mesures de sécurité - 2. Règles pour obtenir de l'aide dans les forums de support - 3. Restrictions des droits pour le groupe "Support suspendu"

Il est obligatoire de respecter les Règles de MyBB.fr : Version abrégée ou Version complète pour obtenir du support sur nos forums.

Les membres ayant un site/forum contrevenant aux règles de MyBB.support seront placés dans le groupe "Support suspendu" et ne bénéficieront plus du support du staff. Nous recommandons aux autres membres d'agir de même. Il ne s'agit pas d'un bannissement, le membre retrouvera son statut "normal" dès que sa situation sera conforme aux règles.

Nouveau : un Wiki en français : plus de détails.
Avant de soumettre votre problème, consultez-le, ainsi que la FAQ, sans oublier le moteur de recherche interne.


Note de ce sujet :
  • Moyenne : 0 (0 vote(s))
  • 1
  • 2
  • 3
  • 4
  • 5
problèmes conenction avec une autre base de donné
Mots-clés » problèmes, conenction, autre, base, donné
17-04-2011, 14:22, (Modification du message : 17-04-2011, 14:31 par lilirageuse.)
#1
problèmes conenction avec une autre base de donné
Bonjour
j'ais décidée de changez le chemin de la connection pour que on puisse se connectée sur le forum > site

jais changez tout les chemin de member.php
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,resendactiv​ation,do_resendactivation,resetpassword");

$nosession['avatar'] = 1;
$templatelist = "member_register,error_nousername,error_nopassword,error_passwordmismatch,error_i​nvalidemail,error_usernametaken,error_emailmismatch,error_noemail,redirect_regis​tered";
$templatelist .= ",redirect_loggedout,login,redirect_loggedin,error_invalidusername,error_invalidp​assword,member_profile_email,member_profile_offline,member_profile_reputation,me​mber_profile_warn,member_profile_warninglevel,member_profile_customfields_field,​member_profile_customfields,member_profile_adminoptions,member_profile,member_lo​gin,member_profile_online,member_profile_modoptions,member_profile_signature,mem​ber_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");
}
?>


Mais quand jesaye de me connectée sa me mais une erreur :

Une erreur inconnue s'est produite.

merci de votre aide, cordialement

Petite information sur le code :

là nouvelle base de donné sapelle : accounts
le chemin de l'indentifiant est account
le chemin du mot de passe et pass Smile
Répondre


Messages dans ce sujet
problèmes conenction avec une autre base de donné - lilirageuse - 17-04-2011, 14:22



Utilisateur(s) parcourant ce sujet :

Contact | MyBB.support | Retourner en haut | Retourner au contenu | Version bas-débit (Archivé) | Syndication RSS
 Utilitaire de traduction fourni par Regentronique