[RELEASE]PHP 5.4/PHP Driver 3.0(SQLSRV) Account Registration Module

[omaremil9]

Originally Posted by thndr

Try the name of the SQL server connection you connect to instead of the address.

I tried replacing 127.0.0.1 with MRX-PC\SQLEXPRESS which is the "server name" displayed when I access my sql db manager. Didn't change a thing. Also tried localhost\SQLEXPRESS which some people suggested on other posts. No luck.

Originally Posted by ismokedrow

First we really need to figure out are you using Default or Named Instance when you installed your SQL server?

I am using default everything. I followed this guide 100% to the letter.

This is what my db manager looks like if it helps at all.

[ismokedrow]

Do this, in your SSMS application try to connect to your database with 127.0.0.1 and Mixed Authentication (using the test account you mentioned)

Edit: I noticed in that guide that they tell you to install as named instance. If you did indeed install as named instance then you will be able to login with Server Name: MRX-PC\SQLEXPRESS and Mixed Authentication (using your mentioned test account)

[omaremil9]

Originally Posted by ismokedrow

Do this, in your SSMS application try to connect to your database with 127.0.0.1 and Mixed Authenticate (using the test account you mentioned)

It worked. Here's an image of the db successfully logged in.

[ismokedrow]

Originally Posted by omaremil9

It worked. Here's an image of the db successfully logged in.

then in db_config replace 127.0.0.1 with MRX-PC\SQLEXPRESS and use the account details you desire. It should login as-well

[omaremil9]

Originally Posted by ismokedrow

then in db_config replace 127.0.0.1 with MRX-PC\SQLEXPRESS and use the account details you desire. It should login as-well

Here is the new db_config file with the password omitted.

 Spoiler

PHP Code:

<?php
##################################
##################################
#######Rappelz Registration#######
######DB Configuration File#######
######Coded by: iSmokeDrow########
##################################
##################################
##Database Connection Information
##Define Account Connection Info
$acc_database_name = "MRX-PC\SQLEXPRESS";   #Account Database Host IP
$acc_database_user = "Test"; #DO NOT USE SA
$acc_database_pass = "*******"; #Use a complex password!
##Define DB Names
$auth_name = "Auth"; #Your auth database name, typically "auth"
#Define SQL Error
$sql_error_acc = "The database connection to the Game has failed!1";
#Define Account Connection Info
$connectionInfo_acc = array( "Database"=>"$auth_name", "UID"=>"$acc_database_user", "PWD"=>"$acc_database_pass");
$connect_acc = sqlsrv_connect( $acc_database_name, $connectionInfo_acc) or die($sql_error_acc);
##################################
##Define Server Connection Info    
##Note: You can define multiple servers, by just copying the below section and filling it out per server!
##Game001 Config:
$sql_error_Game001 = "The database connection to the Game has failed!2 ";
$Game001_game = "Telecaster";
$Game001_db_name = "127.0.0.1";
$Game001_db_user = "telecaster_username";
$Game001_db_pass = "telecaster_userpass";
$connectionInfo_Game001 = array( "Database"=>"$Game001_game", "UID"=>"$Game001_db_user", "PWD"=>"$Game001_db_pass");
$connect_Game001 = sqlsrv_connect( $Game001_db_name, $connectionInfo_Game001) or die($sql_error_Game001);
##################################
##################################
##Game002 Config:
$sql_error_game002 = "The database connection to the Game has failed!3";
$Game001_game = "telecaster";
$Game001_db_name = "127.0.0.1";
$Game001_db_user = "telecaster_username";
$Game001_db_pass = "telecaster_userpass";
$connectionInfo_game002 = array( "Database"=>"$game002_game", "UID"=>"$game002_db_user", "PWD"=>"$game002_db_pass");
$connect_game002 = sqlsrv_connect( $game002_db_name, $connectionInfo_game002) or die($sql_error_game002);
##################################
##################################
##Vote Shop Config:
$sql_error_vote_shop = "The database connection to the Vote Shop has failed!4";
$vote_shop = "vote_shop_dbname";
$Game001_db_name = "127.0.0.1";
$Game001_db_user = "vote_username";
$Game001_db_pass = "vote_userpass";
$connectionInfo_vote = array( "Database"=>"$vote_shop", "UID"=>"$vote_db_user", "PWD"=>"$vote_db_pass");
$connect_vote = sqlsrv_connect( $vote_db_name, $connectionInfo_vote) OR die($sql_error_vote_shop);
?>

It's still stuck at error #1 which indicates problems logging into the databse according to the script.

Link to the website: nulled

Any ideas? I followed your advice and it still will not work. I've tried re-installing everything from scratch, opening ports, using different versions of php. I tried using both wamp and xamp which seem to be the exact same thing. No idea why it won't work :/

[ismokedrow]

Sorry for long response, please contact me via skype ()

[omaremil9]

Originally Posted by ismokedrow

Sorry for long response, please contact me via skype ()

Don't worry, I'm thankful to even get a response. I've added you. The name should be somewhat obvious. Not trying to post it on the forum lol.

[Sycheras]

i know this Thread is old but need help pls

Fatal error: Call to undefined function sqlsrv_connect() in C:\xampp\htdocs\config\db_config.php on line 20

[ThunderNikk]

Sounds like the function sqlsrv_connect()

Is called in line 20 of that file but your function is never defined.

Maybe you missed some step in the configuration setting up your connection strings?