Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 21:39

  • 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,555
Received Thanks: 2,426
[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 01/03/2012, 14:58   #2
 
elite*gold: 0
Join Date: Jun 2011
Posts: 82
Received Thanks: 11
thx againe


qaaah is offline  
Old 01/03/2012, 15:55   #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 01/03/2012, 16:39   #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 01/04/2012, 15:10   #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 01/04/2012, 16:35   #6
 
elite*gold: 0
Join Date: Oct 2010
Posts: 2,555
Received Thanks: 2,426
It's a notice not an error. Furthermore you can disable this error by Googling PHP Disable Notices...
ismokedrow is offline  
Old 01/04/2012, 21:02   #7
 
elite*gold: 0
Join Date: Mar 2009
Posts: 190
Received Thanks: 35
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 01/05/2012, 16:17   #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 01/05/2012, 20:03   #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 01/06/2012, 14:57   #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 01/16/2012, 20:18   #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 01/17/2012, 00:59   #12
 
elite*gold: 0
Join Date: Jun 2011
Posts: 680
Received Thanks: 309
Rent one.
s0ul37 is offline  
Old 01/17/2012, 10:49   #13
 
elite*gold: 0
Join Date: Feb 2011
Posts: 131
Received Thanks: 39
Not Free?
Gold.D.Marko is offline  
Old 01/17/2012, 11:00   #14
You're the one who died



 
elite*gold: 0
Join Date: May 2011
Posts: 5,016
Received Thanks: 3,333
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 01/17/2012, 18:13   #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



« New Omegas 8.1 | Skills crash »

Similar Threads
Help Web Registration Script
12/18/2011 - Shaiya Private Server - 1 Replies
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 This error occurs when I try to be a member. You must have the php_mssql library for Apache...
Registration script
07/08/2011 - Rappelz - 5 Replies
Hi all i want to ask any guide help to make Registration page ? please help from professional In this topic thanks all :)
[release] Advanced register script
05/10/2011 - EO PServer Hosting - 9 Replies
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 or with a single database ( i wrote it for 2 databases) what does it do ?? let the user...
[AC Tool] Advanced Cooking Script
08/14/2009 - General Gaming Discussion - 0 Replies
// 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 script is currently set up to cook bass, cod, trout, salmon, scroll down twice, then cook swordfish...
Advanced WALKER Script question.
02/15/2009 - Lineage 2 - 2 Replies
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; CharStatus(CHP|CMP|HP|MP|WEIGHT|LV|STAND,>=|>|==|!=|<|<= ,Number) Can we get more information? Like P....



All times are GMT +2. The time now is 21:39.


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

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