[ADVANCED] Registration Script / SQLSRV

[Exterminator-[Fury]]

I did evrything in the guide ..
but after perssing create nothing happens?

what do i have to do ?

[arkano666]

Dll+php ini and registration script links are broken. Can u please reupload it?
Thanks.

[konamimoto]

Multiupload.com isn't working could you Upload the requires DLL's + PHP.ini & SQLSRV Registration Script in another website , please.
Thank you for your Hard Work

[pesokow]

PHP Code:

<?php

require_once('recaptchalib.config.php');
require_once('recaptchalib.php');
require_once('db.config.php');

$user_ip = $_SERVER['REMOTE_ADDR'];
$username = isset($_POST['username']) ? mssql_escape_string(trim($_POST['username'])) : '';
$password = isset($_POST['password']) ? mssql_escape_string(trim($_POST['password'])) : '';
$password2 = isset($_POST['password2']) ? mssql_escape_string(trim($_POST['password2'])) : '';
//$conn=mssql_connect('sql id','sql user id','sql user password');
//$db = mssql_select_db('PS_UserData',$conn) or die("MSSQL Conection Error!");
$errors = array();
$success = false;
if(isset($_POST) && !empty($_POST)){
require_once('db.php');

// Validate user name.
$checkquery = ("SELECT UserID FROM PS_UserData.dbo.Users_Master WHERE UserID = '${username}'");
$result = sqlsrv_query( $conn, $checkquery);
        $num = sqlsrv_num_rows($result);
       
        if ($num > 0) {
            $errors[] = '<font color="red">The username you have chosen has already been taken, please try again.</font>';
        };

if(empty($username)){
$errors[] = 'Please provide a user name.';
}else if(strlen($username) < 3 || strlen($username) > 16){
$errors[] = 'User name must be between 3 and 16 characters in length.';
}else if(ctype_alnum($username) === false){
$errors[] = 'User name must consist of numbers and letters only.';
}else if(sqlsrv_num_rows($result)){
$errors[] = 'User name already exists, please choose a different user name.';
}
// Validate user password.
if(empty($password)){
$errors[] = 'Please provide a password.';
}else if(strlen($password) < 3 || strlen($password) > 16){
$errors[] = 'Password must be between 3 and 16 characters in length.';
}else if($password != $password2){
$errors[] = 'Passwords do not match.';
}
// Validate reCAPTCHA. This is to prevent someone botting account creation.
$response = recaptcha_check_answer($recaptcha_private_key,$_SERVER['REMOTE_ADDR'],$_POST['recaptcha_challenge_field'],$_POST['recaptcha_response_field']);
if(!$response->is_valid){
if($response->error == 'incorrect-captcha-sol'){
$errors['recaptcha'] = 'Incorrect answer to reCAPTCHA';
}else{
$errors['recaptcha'] = $response->error;
}
}
// Persist the new account to the database if no previous errors occured.
if(count($errors) == 0){
$checkuseruid = "SELECT Max(UserUID) AS max FROM PS_UserData.dbo.Users_Master";
$resultado = sqlsrv_query( $conn, $checkuseruid);
$captura = sqlsrv_fetch_array($resultado);
$UserUID = $captura["max"]+1;
$sql = "INSERT INTO PS_UserData.dbo.Users_Master
(UserUID,UserID,Pw,JoinDate,Admin,AdminLevel,UseQueue,Status,Leave,LeaveDate,UserType,Point,EnPassword,UserIp)
VALUES ('${UserUID}','{$username}','{$password}',GETDATE( ),0,0,0,0,0,GETDATE(),'N',0,'','{$user_ip}')";

// Remove the @ symbol here to see what the SQL error message is when running the above query in $sql.
if($result = @sqlsrv_query($conn , $sql)){
$success = "Account {$username} successfully created!";
}else{
// This means the insert statement is probably not valid for your database. Fix the query or fix your database, your choice 
$errors[] = 'Failed to create a new account, please try again later';
}
}
}
// Determine which view to show.
if($success === false){
require_once('register.view.php');
}else{
require_once('success.view.php');
}
?>

When I run this 'Register.php' everything works except it doesn't check whether the username exists or not. It adds it into the database regardless. What am I missing in the coding?

[OyunPozitifRappelz]

link catlak

[ghostD99]

Originally Posted by ismokedrow

It's a notice not an error. Furthermore you can disable this error by Googling PHP Disable Notices...

mediafire miror plz on tutorial cause multiaupload link is dead on registration Script
thk you ill appreciate that!

[said200]

Link down

[liamknight24]

Can no one mirror?

[sagaroth]

The link is deaaaaad U_u

[marekrndr]

hi i get error plz halp meay

[5405045]

Reupload Plz

[ismokedrow]

I am going to write a new one guys, just wait for the thread

[5405045]

Thax fot the new one,,
but is'nt this an advanced version and the new is a simple version o_O ??
plz reupload this one

[Mslolita]

can you reupload this script? it would be very usefull with these options in it

your link is broken.


Username Check
Password Confirm
Password MD5 Encryption
Age Field (For Server using; Adult Server)
Email Field (Useful for Verifying Accounts / Blocking Dual Accounts)
Email Check (Cuts down on Dual Accounters)
IP Post (Posts the users IP to the IP field in the Accounts Database upon Account Creation) [Invisible to User]
IP Check (Cuts down on Dual Accounters)

[PriusAnima]

New thread?