Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 09:41

  • Please register to post and access all features, it's quick, easy and FREE!

 

[ADVANCED] Registration Script / SQLSRV

Reply
 
Old   #16
 
elite*gold: 0
Join Date: Jul 2010
Posts: 211
Received Thanks: 26
I did evrything in the guide ..
but after perssing create nothing happens?

what do i have to do ?



exter16 is offline  
Old   #17
 
elite*gold: 0
Join Date: May 2008
Posts: 7
Received Thanks: 0
Dll+php ini and registration script links are broken. Can u please reupload it?
Thanks.


arkano666 is offline  
Old   #18
 
elite*gold: 0
Join Date: Mar 2012
Posts: 25
Received Thanks: 5
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
konamimoto is offline  
Old   #19
 
elite*gold: 0
Join Date: Apr 2010
Posts: 10
Received Thanks: 1
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) < || 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) < || 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?


pesokow is offline  
Old   #20
 
elite*gold: 0
Join Date: Dec 2011
Posts: 157
Received Thanks: 5
link catlak
OyunPozitifRappelz is offline  
Old   #21
 
elite*gold: 0
Join Date: Dec 2011
Posts: 6
Received Thanks: 2
Urgent request

Quote:
Originally Posted by ismokedrow View Post
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!
ghostD99 is offline  
Old   #22
 
elite*gold: 0
Join Date: Nov 2010
Posts: 80
Received Thanks: 1
Link down
said200 is offline  
Old   #23
 
elite*gold: 0
Join Date: Apr 2011
Posts: 12
Received Thanks: 0
Can no one mirror?
liamknight24 is offline  
Old   #24
 
elite*gold: 0
Join Date: Nov 2012
Posts: 3
Received Thanks: 1
The link is deaaaaad U_u
sagaroth is offline  
Old   #25
 
elite*gold: 0
Join Date: Aug 2011
Posts: 535
Received Thanks: 231
hi i get error plz halp meay
marekrndr is offline  
Old   #26
 
elite*gold: 0
Join Date: Nov 2011
Posts: 136
Received Thanks: 61
Reupload Plz
5405045 is offline  
Old   #27
 
elite*gold: 0
Join Date: Oct 2010
Posts: 2,557
Received Thanks: 2,411
I am going to write a new one guys, just wait for the thread
ismokedrow is offline  
Old   #28
 
elite*gold: 0
Join Date: Nov 2011
Posts: 136
Received Thanks: 61
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
5405045 is offline  
Old   #29
 
elite*gold: 0
Join Date: Dec 2012
Posts: 102
Received Thanks: 4
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)
Mslolita is offline  
Old   #30
 
elite*gold: 0
Join Date: Dec 2012
Posts: 23
Received Thanks: 0
New thread?


PriusAnima is offline  
Reply



« Previous Thread | Next Thread »

Similar Threads
Help Web Registration Script
hi , To understand this topic I would like to help my English a little bit worse . I installed the files to my site : Registration Page ...
1 Replies - Shaiya Private Server
Registration script
Hi all i want to ask any guide help to make Registration page ? please help from professional In this topic thanks all :)
5 Replies - Rappelz
[release] Advanced register script
hi all time for the second advanced release this is a register script but with email verification the script itself can work with 2 databases...
9 Replies - EO PServer Hosting
[AC Tool] Advanced Cooking Script
// Script created by Mouldy Tacos // This script will cook all of the items in your back pack, close the cooking window, then right click // This...
0 Replies - General Gaming Discussion
Advanced WALKER Script question.
Been reading these threads for a month now, best place I have been to that has info on scripting. I have 2 questions. The Walker command;...
2 Replies - Lineage 2



All times are GMT +2. The time now is 09:41.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy
Copyright ©2017 elitepvpers All Rights Reserved.