Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 07:48

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

 

[ADVANCED] Registration Script / SQLSRV

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Oct 2010
Posts: 2,557
Received Thanks: 2,415
[ADVANCED] Registration Script / SQLSRV

-- Forewarning --

The following is in no way shape or form intended for the use of beginners and requires basic and intermediate skill levels to apply and use.

-- Features --
  • 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)

-- Why do I need SQLSRV? --

MSSQL was dropped in PHP v5.3 -- the old registration scripts first put out in this community are designed to use the MSSQL_connect or MSSQL api. This can negatively impact the over-all performance of your website and is an inconvience. The SQLSRV Api was created as a replacement of the archaic MSSQL api, the syntax does not very all that greatly but did take a great deal of rewriting.

-- What do I need? --

To use this script your machine must be running PHP v5.3.8 (The Newest Version of XAMPP uses this version of PHP) and you must have SQLSRV 2.0 Installed.

!!XAMPP!! !!WARNING!! - Do NOT install in C:\Program Files or C:\Program Files (x86) install in C:\

You can get the latest version of XAMPP:

!!WARNING!!

SQLSRV2 requires that MS SQL Server Native Client 2008 R2 also be installed.

You can get this from Here

-- Installing SQLSRV 2.0 + Configuring your PHP.INI --

Download the requires DLL's + PHP.ini:

You will need to copy the PHP.ini to your XAMPP's PHP folder (Please overwrite if asked)

Move the other two files into your XAMPPS PHP\Ext folder, reload your server.

-- Configuring the Registration Script --

Download the SQLSRV Registration Script:

Copy 'index.php' to your web root e.g. 'htdocs' for XAMPP

Copy the 'function' folder into your web root as-well.

Open index.php and scroll down to:

Code:
function connect(){
						$serverName = "serverName\instanceName"; // Replace with your Computer Name \ Instance Name e.g. localhost\SQLEXPRESS
						$usr="username"; // Replace 'Username' with the SQL User Name for your Account Database
						$pwd="password"; // Replace 'Password' with the SQL Password for your Account Database
						$db="server_name"; // Replace 'server_name' with the name of your account database e.g. Auth
						$connectionInfo = array("UID" => $usr, "PWD" => $pwd, "Database" => $db);
						$conn = sqlsrv_connect($serverName, $connectionInfo);
						 if( $conn )
						 {
						 echo "Connection established.\n";
						 }
						 else
						 {
						 echo "Connection could not be established.\n";
						 die( print_r( sqlsrv_errors(), true));
						 } 
						 return $conn;
}
Change the username, password and server_name with the details of your server. Save.

Open the conf.php in your 'function' folder edit the information you desire, save.

Restart your web server to ensure the changes have taken place.

-- Credits --

This script was originally designed by Demonroro.
This script was rewritten, optimized and converted to SQLSRV by iSmokeDrow
This script has been tested and confirmed functional.

Enjoy,
iSmokeDrow

If you found this post useful or enjoy my work be a sport and press the "Thanks" button.



ismokedrow is offline  
Thanks
46 Users
Old   #2
 
elite*gold: 0
Join Date: Jun 2011
Posts: 82
Received Thanks: 11
thx againe


qaaah is offline  
Old   #3
 
elite*gold: 0
Join Date: Nov 2010
Posts: 3
Received Thanks: 0
thanx you very much you are the best ^_^
montah2050 is offline  
Old   #4
 
elite*gold: 0
Join Date: Oct 2011
Posts: 7
Received Thanks: 0
thank you very much you made a nice effort


AndrioX9 is offline  
Old   #5
 
elite*gold: 0
Join Date: Nov 2010
Posts: 7
Received Thanks: 1
in zeile 35 wo drine steht :"$do = $_POST['do'];"
hatter ein fehler ...
wo kann das problem liegen ?
KillerBeet is offline  
Old   #6
 
elite*gold: 0
Join Date: Oct 2010
Posts: 2,557
Received Thanks: 2,415
It's a notice not an error. Furthermore you can disable this error by Googling PHP Disable Notices...
ismokedrow is offline  
Old   #7
 
elite*gold: 0
Join Date: Mar 2009
Posts: 167
Received Thanks: 29
Fatal error: Call to undefined function mssql_connect() in C:\xampp\htdocs\index.php on line 25

line 25 is = $connect = mssql_connect($sql_host, $sql_user, $sql_password);


whats is wrong -.-
Makenci is offline  
Old   #8
 
elite*gold: 0
Join Date: Jun 2011
Posts: 82
Received Thanks: 6
pls held habe den fehler in zeile 35 auch :"$do = $_POST['do'];"
wie beseitige ihn den denn .
mcartur009 is offline  
Old   #9
 
elite*gold: 0
Join Date: Jan 2010
Posts: 22
Received Thanks: 1
Quote:
Originally Posted by Makenci View Post
Fatal error: Call to undefined function mssql_connect() in C:\xampp\htdocs\index.php on line 25

line 25 is = $connect = mssql_connect($sql_host, $sql_user, $sql_password);


whats is wrong -.-
Did you change the config file and enter your information? $sql_host should be YOURPCNAME\SQLExpress $sql_user should be sa and $sql_password should be whatever you set the password for your 'sa' user.
OtakuTxie is offline  
Old   #10
 
elite*gold: 0
Join Date: Jan 2008
Posts: 70
Received Thanks: 7
Quote:
Originally Posted by Makenci View Post
Fatal error: Call to undefined function mssql_connect() in C:\xampp\htdocs\index.php on line 25

line 25 is = $connect = mssql_connect($sql_host, $sql_user, $sql_password);


whats is wrong -.-
That cant be right, shut be sqlsrv_connect Not mssql_connect.
Or youre not running the right script.
elco2100 is offline  
Old   #11
 
elite*gold: 0
Join Date: Feb 2011
Posts: 131
Received Thanks: 39
Thank You But Were I Get Web Root?
Copy the 'function' folder into your web root as-well.
Gold.D.Marko is offline  
Old   #12
 
elite*gold: 0
Join Date: Jun 2011
Posts: 670
Received Thanks: 309
Rent one.
s0ul37 is offline  
Old   #13
 
elite*gold: 0
Join Date: Feb 2011
Posts: 131
Received Thanks: 39
Not Free?
Gold.D.Marko is offline  
Old   #14


 
elite*gold: 0
Join Date: May 2011
Posts: 4,805
Received Thanks: 3,187
Sure, you just hadn't look at all of this page.

There is a Root-Server with 64gb ram, 16 chip processor, 1000mbit/s, no traffic-limit, 24/7 direct support, just 1 person for you, also 3 serveradmins which will sit next to your root, so it always stays online.

No, rootserver aren't free.... -_-
Xijezu is offline  
Thanks
1 User
Old   #15
 
elite*gold: 0
Join Date: Jan 2011
Posts: 134
Received Thanks: 61
Thanks, but i don't press the "Confirm" button :/


bwr_62 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 +1. The time now is 07:48.


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

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