How to make your register page work!

[IAmMe]

here's my little guide how to make your registration page work:

First of all let's start with the files:

you need to download:

Appserv:

To view the content, you need to sign in or register

Registration files:

To view the content, you need to sign in or register

Ok after we got those 2 files we can make our registration site.

First let's start with your ip...

If you want to mask your ip to make it for example
your-ryl.ath.cx or my-ryl.no-ip.org

Pick 1 of dns sites:

To view the content, you need to sign in or register

or

To view the content, you need to sign in or register

Make an account go to Services press on add dns(choose what you want, depends on your ip Statis or dynamic).

Let's start installing:

Run appserv installation...

1.press next->next(or change directory)->Next
2.Here's what you need to do:

3.next and it will start installing..


go to your windows folder:
c:/Windows/ and find a ini file called php....

Inside it you should find something like that:

Remove the ; from extension=php_mssql.dll

REstart comp...

Put the register files(eryl_basic) to appserv/www/

Open config edit it with your ip and Database info and your site is set up after that check it...

To view the content, you need to sign in or register

if doesn't work....
go to start ->all programes->appserv->appache control server->Appache monitor...

it will go on the tray....

after the window will open Press on restart on a right side...

try agian going to

To view the content, you need to sign in or register

if doesn't work you did something wrong try remaking all from begining.

Guide Written By Me (Style/IAmMe [RaGEZONE Forum])

Enjoy.

 

[rzryl2]

lol fun
I love AppServ.. alot easier to install.. normally i would use Apache and PHP 'n everything
Good choice and good job on the tutorial

Edit:
tested, works perfectly

 

[IAmMe]

thanks, altho wasted 1 hour posting that.. but witha hope think it will help some ppl!

 

[SpraxX]

I get this error

Warning: mssql_select_db(): message: Could not locate entry in sysdatabases for database 'RYLauth'. No entry found with that name. Make sure that the name is entered correctly. (severity 16) in c:\appserv\www\config.php on line 67

Warning: mssql_select_db(): Unable to select database: RYLauth in c:\appserv\www\config.php on line 67

What did i do wrong?

 

[rzryl2]

I get this error

Warning: mssql_select_db(): message: Could not locate entry in sysdatabases for database 'RYLauth'. No entry found with that name. Make sure that the name is entered correctly. (severity 16) in c:\appserv\www\config.php on line 67

Warning: mssql_select_db(): Unable to select database: RYLauth in c:\appserv\www\config.php on line 67

What did i do wrong?

What in the world does that have to do with the registration page?
Oh, and dont double post... I answered you in '[DEV] Risk Your Life server' thread

 

[IncOpk]

Stealthy17 it is a file error with REGISTRATION PAGE...

 

[rzryl2]

Stealthy17 it is a file error with REGISTRATION PAGE...

Hahah rofl yea now i see, next time i should read better xD

Line 67 is:

$msdb=mssql_select_db("$db",$msconnect);

Did you edit PHP.ini and restart the Apache server?

 

[yotga]

LOL i go like the setup they said but its DONT WORK!!!

 

[rzryl2]

LOL i go like the setup they said but its DONT WORK!!!

Define 'DONT WORK' people cant smell what's wrong you know?
First of all your DNS name give me a time-out so, OR you are not running the webserver...
OR you make it translate to the wrong IP, OR you got a firewall, OR you are behind a router and you didnt configure it.

To many options... Be more clear about your problems and dont type

'ned help plx dont know why no working'

People cant do shit with that...

 

[yotga]

yotga

look (we are 2 ppl... im the smart one), my friend doesn't have a router, he follow the guide, i must be something wrong with the no-ip... or with his firewall...

but the problem is with the connection to SQL... he has SQL 2000.. is that ok?

 

[rzryl2]

look (we are 2 ppl... im the smart one), my friend doesn't have a router, he follow the guide, i must be something wrong with the no-ip... or with his firewall...

but the problem is with the connection to SQL... he has SQL 2000.. is that ok?

SQL2k is perfect...
But i'm helping a friend, he's having the same symptoms yotga is having, so far i didnt found the reason (also with Authserver not going 'blue' and the game servers)

 

[Krov]

Hi, I'm Krov...and yeah i read each and every step you put in there...i notice there some bug that i don't get. for one i got a thing that said this

."Warning: mssql_connect() [function.mssql-connect]: message: Login failed for user 'db_user'. (severity 14) in c:\AppServ\www\config.php on line 369"

and i dont know how to fix that...other then that i did it..my Apache runs well and i got some errors with that but at a higher number such as 32 to 341, between those actually...Do you know how to fix it?

Another thing is that i went and press ctrl+G and type int 369, it took me to this:

//****************************************************DONT EDIT HERE*********************************************************

//=============== NOT EDITABLE AREA ====================
// DEFAULT SETTINGS DO NOT CHANGE
$popup="<A HREF=javascriptopitup('gallery/";
$popup2="')>";
$image="<img src=gallery/";
$image2=" WIDTH='160' BORDER='0' HEIGHT='120'>";
$alogin = $dbuser;
$apass = $dbpasswd;
$db = 'muonline';
$regsubmit = "regform.submit()";
$msconnect=mssql_connect("$host","$alogin","$apass");
$msdb=mssql_select_db("$db",$msconnect);
$ip = $host;
//========================END===========================

So is there anyway you can fix that? thank you for your time to answer my questions...and help me fix these bugs...

 

[IAmMe]

Hi, I'm Krov...and yeah i read each and every step you put in there...i notice there some bug that i don't get. for one i got a thing that said this and i dont know how to fix that...other then that i did it..my Apache runs well and i got some errors with that but at a higher number such as 32 to 341, between those actually...Do you know how to fix it?

Another thing is that i went and press ctrl+G and type int 369, it took me to this:

//****************************************************DONT EDIT HERE*********************************************************




So is there anyway you can fix that? thank you for your time to answer my questions...and help me fix these bugs...

look like you are not writing the MySQl Login right...
Default is sa.

 

[Krov]

yeah, i saw that and i fixed the bug on that...but i just got a new one and i dont even know what to do...and i don't want to touch anything because i might messed up enough to ruin everything that i work so hard for. here what i got from the new errors.

Warning: mssql_query() [function.mssql-query]: message: Syntax error converting the varchar value 'krov' to a column of data type int. (severity 16) in c:\AppServ\www\modules\loginin.php on line 156

Warning: mssql_query() [function.mssql-query]: Query failed in c:\AppServ\www\modules\loginin.php on line 156

Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in c:\AppServ\www\modules\loginin.php on line 157
Error: Only Administrator can do this!

And i checked and it bring me up to this:

$check_code_query = "select adm_check from MEMB_INFO WHERE memb___id='$adm_uss'";
$check_query_result = mssql_query( $check_code_query );
$code_check = mssql_fetch_row( $check_query_result );

$sql_security_check = mssql_query("SELECT security_code FROM MEMB_INFO WHERE security_code='$security' and memb___id='$adm_uss'");
$security_check = mssql_num_rows($sql_security_check);

So, do you know any ways to fix it? i dont see anything wrong with it, but do you see anything wrong? Thank you for taking your time of answering me with all these bugs...but, this is my first time hosting and doing this kind of website.

 

[john_d]

yeah, i saw that and i fixed the bug on that...but i just got a new one and i dont even know what to do...and i don't want to touch anything because i might messed up enough to ruin everything that i work so hard for. here what i got from the new errors.



And i checked and it bring me up to this:



So, do you know any ways to fix it? i dont see anything wrong with it, but do you see anything wrong? Thank you for taking your time of answering me with all these bugs...but, this is my first time hosting and doing this kind of website.

ur not suppose to use ALPHA number on a INT field.. im guess memb___id on the adm_check table is a INT

 

[Krov]

so do you know how to take it out? because i do not want to mess it up...Can you show me a way to take it out and leave whats suppose to be in there?

 

[Tyfix]

Uhm where is this table?

Anyways change your select statement to check for name instead of id.

 

[Krov]

$check_code_query = "select adm_check from MEMB_INFO WHERE memb___id='$adm_uss' ";
$check_query_result = mssql_query( $check_code_query );
$code_check = mssql_fetch_row( $check_query_result );

$sql_security_check = mssql_query("SELECT security_code FROM MEMB_INFO WHERE security_code='$security' and memb___id='$adm_uss' ");

$security_check = mssql_num_rows($sql_security_check);

Thats the part i'm having problems with...do you know how to fix it? thats my table.. and here what it came out on the website of my MU.

Warning: mssql_query() [function.mssql-query]: message: Syntax error converting the varchar value 'Krov' to a column of data type int. (severity 16) in c:\AppServ\www\modules\loginin.php on line 156

Warning: mssql_query() [function.mssql-query]: Query failed in c:\AppServ\www\modules\loginin.php on line 156

Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in c:\AppServ\www\modules\loginin.php on line 157
Error: Only Administrator can do this!

 

[Tyfix]

Well the thing is i don't recognize any of these databases/tables you are writing about.. Maybe im out of the loop hehe

 

[Krov]

its from the modules/loginin.php foulder in the apacheserv folder.