<script type="text/javascript">
$(document).ready(function() {
var min_chars = 3;
var pass_chars = 6;
var login_error = \'<span class="checknotok">The login must contain at least 3 characters.</span>\';
var email_error =\'Your email seems to be incorrect or too short. You need a valid email.\';
var pass_error =\'<span class="checknotok">The password has to be 6 characters long.</span>\'
var pass_decent=\'<span class="checkok">Your password is long enough, but it could be trickier to guess!</span>\';
var checking_html = \'Checking...\';
$(\'#reg_login\').keyup(function(){
var current_login = $(this).attr(\'id\');
if($(\'#reg_login\').val().length < min_chars){
$(\'#login_availability\').html(login_error);
}else{
check_availability(current_login);
}
});
$(\'#reg_alias\').keyup(function(){
var current_alias = $(this).attr(\'id\');
if($(\'#reg_alias\').val().length < min_chars){
$(\'#alias_availability\').html(login_error);
}else{
check_availability(current_alias);
}
});
$(\'#reg_email\').keyup(function(){
var current_email = $(this).attr(\'id\');
if($(\'#reg_email\').val().length < pass_chars){
$(\'#email_availability\').html(email_error);
}else{
check_availability(current_email);
}
});
$(\'#reg_plaintext_passwd\').keyup(function(){
if($(\'#reg_plaintext_passwd\').val().length < pass_chars){
$(\'#passwd_availability\').html(pass_error);
} else {
$(\'#passwd_availability\').html(pass_decent);
}
});
});
function check_availability(a){
var field = $(\'#\'+ a).val();
var a = a.replace("reg_","");
var dat = a+"="+field;
$.ajax({
dataType: "json",
url: "{FULL_ROOT}include/checkreg.php",
data: dat,
success: function(result){
if(!result){
$(\'#\'+a+\'_availability\').html(\'<span class="checkok">\'+ field + \' is available</span>\');
}else{
$(\'#\'+a+\'_availability\').html(\'<span class="checknotok">\'+ field + \' is not available</span>\');
}
}
})
}
</script>
<?php
// GET FUDforum globals
include '../GLOBALS.php';
// Connect to database.
$db = mysql_connect($DBHOST, $DBHOST_USER, $DBHOST_PASSWORD);
mysql_select_db($DBHOST_DBNAME, $db);
// Dig out the key used in our GET.
$regtype = array_keys($_GET);
// Use the first key as SQL field.
$reg = mysql_real_escape_string($regtype[0]);
// Convert the array value to lowercase.
$field = strtolower(mysql_real_escape_string($_GET[$reg]));
// Compare the lowercase login with lowercase from database.
$sql = "SELECT ".$reg." FROM ".$DBHOST_TBL_PREFIX."users WHERE lower(".$reg.") = '".$field."'";
$result = mysql_query($sql);
// Convert the result to an object for JSON.
$result = mysql_fetch_object($result);
// encode the object into JSON, will echo false on empty result
echo json_encode($result);
?>
.checkok {color: green;padding-right:20px;background:url({THEME_IMAGE_ROOT}/checkbuttons2.png) no-repeat right top;display:block;height:16px}
.checknotok {color: red;padding-right:20px;background:url({THEME_IMAGE_ROOT}/checkbuttons2.png) no-repeat right -16px;display:block;height:16px}
#login_availability{display:inline-block}
#alias_availability{display:inline-block}
#passwd_availability{display:inline-block}
#email_availability{display:inline-block}