php registration

I've done some work based on this script, it's avaliable at ftp://ftp.betaforce.com:2140/char.php if anyone wants to play around with it. There's a few bugs that I've fixed in my live version that aren't in that version, and I'll be uploading it soon, but basically the features it has: add account, change password, get characters for account, get a list of online characters (sorted however you want), get list of GMs including online/offline status, amongst other things. I'll post the updated one soon... Many thanks to rstrst for the l2pass file. :)

angelofanarchy: edit php.ini to make mssql module work
PhysalisGP: any errors??

Quote:

---

Originally Posted by rstrst

angelofanarchy: edit php.ini to make mssql module work
PhysalisGP: any errors??

---

No errors, it just stops right there.

does it stops loading the page??? if browser continues to load and freezes to continue, then i dunno, coz there is no cycles it can freeze in.
if browser stops, then there is some errors, but php setup is not to show them... enable error reporting in php.ini

Quote:

---

Originally Posted by xion

Fatal error: Call to undefined function: mssql_connect() in /home/xxx/public_html/reg.php on line 50

please help

---

This does happen when you enable the lib mssql in php.ini, but when using it with apache ( not sure about iis ) you need to recompile your apache with php -with mssql. I had the same problem with this along time ago what I did was to get a new version of php configure it ( and make sure you have the dll for mssql most releases come standard with it ) and install it with apache.

Take Care

Hmm This script doesnt seem to work for me. Im running the aybss web server and php is enabled.
It returns this line on error $con = mssql_connect ("127.0.0.1", "user", "password") Line 52.
Id really like to get this working because im good and sick of Asp. Anyway im sort of stuck here. Is this line correct? if not any help id really be thankfull for any help.

Also Thanks for makeing a Php reg page
Asp is a nightmare that ill be thankfull to live without.

Sinsfulsoulz: php doesn't care of web server... Edit php.ini and enable mssql extension....
plz i can't repeat it for everyone

if you have enabled the mssql.dll extention but it still dosnt work, you also need to add this in find the line that says "; Directory in which the loadable extensions (modules) reside."
and change the directory to were your php moduel dlls actualy are.. Example

; Directory in which the loadable extensions (modules) reside.
extension_dir = "C:\PHP\extensions"

then this should fix the phps

Hmm ive done all that ...

post exact error plz... maybe you run mssql on different port? (not defalt one)
or something wrong with your ip, login and pass

awesome.. thanx alot m8 :D

please help me
[11-Nov-2004 12:32:11] PHP Warning: mssql_connect() [C:\apache2triad\php\manual\function.mssql-connect.html]: message: Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection. (severity 14) in C:\apache2triad\htdocs\reg\reg.php on line 51

[11-Nov-2004 12:32:11] PHP Warning: mssql_connect() [C:\apache2triad\php\manual\function.mssql-connect.html]: Unable to connect to server: 192.168.1.101 in C:\apache2triad\htdocs\reg\reg.php on line 51

[11-Nov-2004 12:32:17] PHP Warning: mssql_select_db() [C:\apache2triad\php\manual\function.mssql-select-db.html]: Unable to connect to server: (null) in C:\apache2triad\htdocs\reg\reg.php on line 53

[11-Nov-2004 12:32:17] PHP Warning: mssql_select_db() [C:\apache2triad\php\manual\function.mssql-select-db.html]: A link to the server could not be established in C:\apache2triad\htdocs\reg\reg.php on line 53

[11-Nov-2004 12:32:23] PHP Warning: mssql_query() [C:\apache2triad\php\manual\function.mssql-query.html]: Unable to connect to server: (null) in C:\apache2triad\htdocs\reg\reg.php on line 66

[11-Nov-2004 12:32:23] PHP Warning: mssql_query() [C:\apache2triad\php\manual\function.mssql-query.html]: A link to the server could not be established in C:\apache2triad\htdocs\reg\reg.php on line 66

[11-Nov-2004 12:32:23] PHP Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in C:\apache2triad\htdocs\reg\reg.php on line 67

[11-Nov-2004 12:32:29] PHP Warning: mssql_query() [C:\apache2triad\php\manual\function.mssql-query.html]: Unable to connect to server: (null) in C:\apache2triad\htdocs\reg\reg.php on line 71

[11-Nov-2004 12:32:29] PHP Warning: mssql_query() [C:\apache2triad\php\manual\function.mssql-query.html]: A link to the server could not be established in C:\apache2triad\htdocs\reg\reg.php on line 71

[11-Nov-2004 12:32:35] PHP Warning: mssql_query() [C:\apache2triad\php\manual\function.mssql-query.html]: Unable to connect to server: (null) in C:\apache2triad\htdocs\reg\reg.php on line 72

[11-Nov-2004 12:32:35] PHP Warning: mssql_query() [C:\apache2triad\php\manual\function.mssql-query.html]: A link to the server could not be established in C:\apache2triad\htdocs\reg\reg.php on line 72

[11-Nov-2004 12:32:41] PHP Warning: mssql_query() [C:\apache2triad\php\manual\function.mssql-query.html]: Unable to connect to server: (null) in C:\apache2triad\htdocs\reg\reg.php on line 73

[11-Nov-2004 12:32:41] PHP Warning: mssql_query() [C:\apache2triad\php\manual\function.mssql-query.html]: A link to the server could not be established in C:\apache2triad\htdocs\reg\reg.php on line 73

[11-Nov-2004 12:32:41] PHP Fatal error: Maximum execution time of 30 seconds exceeded in C:\apache2triad\htdocs\reg\reg.php on line 73

Quote:

---

Originally Posted by zcloud

please help me
[11-Nov-2004 12:32:11] PHP Warning: mssql_connect() [C:\apache2triad\php\manual\function.mssql-connect.html]: message: Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection. (severity 14) in C:\apache2triad\htdocs\reg\reg.php on line 51

[11-Nov-2004 12:32:11] PHP Warning: mssql_connect() [C:\apache2triad\php\manual\function.mssql-connect.html]: Unable to connect to server: 192.168.1.101 in C:\apache2triad\htdocs\reg\reg.php on line 51

[11-Nov-2004 12:32:17] PHP Warning: mssql_select_db() [C:\apache2triad\php\manual\function.mssql-select-db.html]: Unable to connect to server: (null) in C:\apache2triad\htdocs\reg\reg.php on line 53

[11-Nov-2004 12:32:17] PHP Warning: mssql_select_db() [C:\apache2triad\php\manual\function.mssql-select-db.html]: A link to the server could not be established in C:\apache2triad\htdocs\reg\reg.php on line 53

[11-Nov-2004 12:32:23] PHP Warning: mssql_query() [C:\apache2triad\php\manual\function.mssql-query.html]: Unable to connect to server: (null) in C:\apache2triad\htdocs\reg\reg.php on line 66

[11-Nov-2004 12:32:23] PHP Warning: mssql_query() [C:\apache2triad\php\manual\function.mssql-query.html]: A link to the server could not be established in C:\apache2triad\htdocs\reg\reg.php on line 66

[11-Nov-2004 12:32:23] PHP Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in C:\apache2triad\htdocs\reg\reg.php on line 67

[11-Nov-2004 12:32:29] PHP Warning: mssql_query() [C:\apache2triad\php\manual\function.mssql-query.html]: Unable to connect to server: (null) in C:\apache2triad\htdocs\reg\reg.php on line 71

[11-Nov-2004 12:32:29] PHP Warning: mssql_query() [C:\apache2triad\php\manual\function.mssql-query.html]: A link to the server could not be established in C:\apache2triad\htdocs\reg\reg.php on line 71

[11-Nov-2004 12:32:35] PHP Warning: mssql_query() [C:\apache2triad\php\manual\function.mssql-query.html]: Unable to connect to server: (null) in C:\apache2triad\htdocs\reg\reg.php on line 72

[11-Nov-2004 12:32:35] PHP Warning: mssql_query() [C:\apache2triad\php\manual\function.mssql-query.html]: A link to the server could not be established in C:\apache2triad\htdocs\reg\reg.php on line 72

[11-Nov-2004 12:32:41] PHP Warning: mssql_query() [C:\apache2triad\php\manual\function.mssql-query.html]: Unable to connect to server: (null) in C:\apache2triad\htdocs\reg\reg.php on line 73

[11-Nov-2004 12:32:41] PHP Warning: mssql_query() [C:\apache2triad\php\manual\function.mssql-query.html]: A link to the server could not be established in C:\apache2triad\htdocs\reg\reg.php on line 73

[11-Nov-2004 12:32:41] PHP Fatal error: Maximum execution time of 30 seconds exceeded in C:\apache2triad\htdocs\reg\reg.php on line 73

---

it tells you whats wrong on the first line...
try changeing the security in the sql manager to mixed sql and windows autherisation..

Trying to register account:"test1" with password:"test1"


DB Connection established:Resource id #2


DataBase opened:1


Account successfully created

but when i log in game..i have this problem:
password does not match for this account when i used account test1/test1

Quote:

---

but when i log in game..i have this problem:
password does not match for this account when i used account test1/test1

---

does it works with asp??
check your client dlls version...