[Release] Simple Register Page for the orginal Database

I made this simple register page for the orginal database. [it wont work with the older databases]

How to use:
1> Download it.
2> Place the files in your root folder.

1. For wamp is that c:\wamp\www
2. For xampp is that c:\xampp\htdocs

3> Edit the config.php to your settings.
Run it and have fun with it

If there is an error..

• Make sure your mssql is enabled
• Make sure you have the right settings in the config.php
• Make sure that your webserver and mssql_server are running

It free to edit to what ever you want...

UPDATE: for ODBC Connection.

Code:

---

<?
$DBHost = 'GunzDB'; //The DNSname of your DB (I.E: GunzDB)
$DBUser = 'game'; //Your DB User
$DBPass = 'test'; //Your DB Password
$conn = odbc_connect($DBHost, $DBUser, $DBPass);
?>

---

delete all in the config.php and pleace this in the config.php

nice man.
But I dont know what is the age of my DB lol.

Quote:

---

Originally Posted by phpbb88

nice man.
But I dont know what is the age of my DB lol.

---

The age of your Database?? I think you mean the age on the registerpage. Thats how old you are...

Rotana i always wonder why you're not getting a moderator or whatever, you give soooo much stuff to the GunZ community!

thank you for all you do! great release

Quote:

---

Originally Posted by kochon

Rotana i always wonder why you're not getting a moderator or whatever, you give soooo much stuff to the GunZ community!

thank you for all you do! great release

---

Maybe someone can suggest me to the owner or other mods?

Nothing against Rotana. It's just that we already have 3 mods (But two are inactive -_-) and the Gunz section is easy enough to handle with just one. HAving 4 wouldn't make any sense.

Quote:

---

Originally Posted by RepublicOfAstra

Nothing against Rotana. It's just that we already have 3 mods (But two are inactive -_-) and the Gunz section is easy enough to handle with just one. HAving 4 wouldn't make any sense.

---

I know but when its needed...

Rotana. Great work, your one of my top tutorial givers. I have a problem:


Fatal error: Call to undefined function: mssql_connect() in c:\appserv\www\config.php on line 9


uhm.... what? o.o



heres my stuff:


<?
$Title = 'Gunz';
$Title2 = 'Full items, premiums for free and all modes';
$DBHost = '*Server*';
$DBUser = '*name*';
$DBPass = '*password*';
$DB = 'GunzDB';

$conn = mssql_connect($DBHost, $DBUser, $DBPass);
mssql_select_db($DB);
?>

i blocked out the things i didnt want anyone to see/know.

I think you dont have the mssql enabled in the php.ini..

I personally prefer Xampp, i dont have alot of trouble with it. And the mssql is already enabled. Only it needs an newer version of the ntwdblib.dll

I have it enabled as far as i know. I guess ill try Xampp. Also Rotana since you know a lot, can you post in my other thread? I need some help with a Qesting problem and no one will post. I have 2, one a moderator closed and then a new one with my mlog.xml in it. Please i really want it up and running.

Thanks again

-A Fan of your work, Khanna

im gettin an error

Quote:

---

Fatal error: Call to undefined function mssql_select_db() in C:\wamp\www\register.php on line 3

---

Quote:

---

Originally Posted by UkRaiNeR

im gettin an error

---

You probelly dont have the mssql enabled in your php.ini..

SQL Server Browser = Stopped
SQL Server (SQLEXPRESS) = Running

should i turn the SQL Server Browser too?

EDIT: ps i cant turn it on

nvm... i switch to xampp, it worked but when actually register user it doesn't go to database i think, because in gunz i cant login :/ its says "check user & pas"

http://img404.imageshack.us/img404/1696/capture2gh1.jpg
http://img236.imageshack.us/img236/5403/capture3xl6.jpg

Herman does this still work if my SQL is not in sa mode?

Yes also worksfine without username and pass for sql. Then leave them blank in the config.php

Quote:

---

Originally Posted by Rotana

Yes also worksfine without username and pass for sql. Then leave them blank in the config.php

---

Ok got it.

Quote:

---

Originally Posted by UkRaiNeR

nvm... i switch to xampp, it worked but when actually register user it doesn't go to database i think, because in gunz i cant login :/ its says "check user & pas"

http://img404.imageshack.us/img404/1696/capture2gh1.jpg
http://img236.imageshack.us/img236/5403/capture3xl6.jpg

---

i got this error too

plz help fix

original means BR right?

EDIT: FIXED WAMP SUCK AND XAMPP FTW

i get a shitload of errors and mysql is enabled, config is correct, i configured it the same way i did with the older DB's

Code:

---

Warning: mssql_select_db() [function.mssql-select-db]: Unable to select database: in C:\wamp\www\register.php on line 3
Warning: mssql_query() [function.mssql-query]: message: Invalid object name 'Account'. (severity 16) in C:\wamp\www\register.php on line 367

Warning: mssql_query() [function.mssql-query]: Query failed in C:\wamp\www\register.php on line 367

Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in C:\wamp\www\register.php on line 368
Number Accounts:

Warning: mssql_query() [function.mssql-query]: message: Invalid object name 'Character'. (severity 16) in C:\wamp\www\register.php on line 370

Warning: mssql_query() [function.mssql-query]: Query failed in C:\wamp\www\register.php on line 370

Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in C:\wamp\www\register.php on line 371
There are characters made

---

i keep on getting this error
http://i167.photobucket.com/albums/u...untitled-2.jpg

[i put black paint so no one wuold c the server]

Rotana can you help me with the register page pleaseeeeeeeeeeeeee

i really need it and im am fast learner, remote assistance!

Nice release , Rotana ! You rocks !

i get http://5.72.37.180/


ImageShack - Hosting :: pageerordf4.png

Quote:

---

Originally Posted by Mikeez

i get http://5.72.37.180/


ImageShack - Hosting :: pageerordf4.png

---

You probelly uses the oldere database.

OFFTOPIC:

Everyone that needs me on msn.... Sorry but i cannot get on it for now... Some private things first.... :police:

Well ive had this issue one's I made sure that the Server host was
Ex . BLAH\SQLEXPRESS . And that Fixed all of my Issues.

Sorry for bumping this old topic but i need help on it.

Im getting this error : Fatal error: Call to undefined function: mssql_connect() in c:\appserv\www\index.php on line 47

Which is on the same line as the MSQL stuff.

Here is part of my index.php :

Code:

---

<?php
$srvip = "Hamachi IP/my ip";
$srvport = "6000";
$mssql_user = "my mssqul user";
$mssql_pass = "";
$mssql_database = "GunzDB"; 
$mssql_host = "machine name\SQLEXPRESS";
$conn = mssql_connect($mssql_user, $mssql_pass, $mssql_host);
mssql_select_db($mssql_database);
?>

---

Im useing BR files and also useing xampp but still giving me stuff from appserv

Full items, premiums for free and all modes
Create New Account
User ID:
Password:
Retype Password:
Email:
Name:
Age:
Country: Country... Afghanistan Albania Algeria American Samoa Andorra Angola Anguilla Antigua & Barbuda Argentina Armenia Aruba Australia Austria Azerbaijan Bahamas Bahrain Bangladesh Barbados Belarus Belgium Belize Benin Bermuda Bhutan Bolivia Bonaire Bosnia & Herzegovina Botswana Brazil British Indian Ocean Ter Brunei Bulgaria Burkina Faso Burundi Cambodia Cameroon Canada Canary Islands Cape Verde Cayman Islands Central African Republic Chad Channel Islands Chile China Christmas Island Cocos Island Columbia Comoros Congo Cook Islands Costa Rica Cote D'Ivoire Croatia Cuba Curacao Cyprus Czech Republic Denmark Djibouti Dominica Dominican Republic East Timor Ecuador Egypt El Salvador Equatorial Guinea Eritrea Estonia Ethiopia Falkland Islands Faroe Islands Fiji Finland France French Guiana French Polynesia French Southern Ter Gabon Gambia Georgia Germany Ghana Gibraltar Great Britain Greece Greenland Grenada Guadeloupe Guam Guatemala Guinea Guyana Haiti Hawaii Honduras Hong Kong Hungary Iceland India Indonesia Iran Iraq Ireland Isle of Man Israel Italy Jamaica Japan Jordan Kazakhstan Kenya Kiribati Korea North Korea South Kuwait Kyrgyzstan Laos Latvia Lebanon Lesotho Liberia Libya Liechtenstein Lithuania Luxembourg Macau Macedonia Madagascar Malaysia Malawi Maldives Mali Malta Marshall Islands Martinique Mauritania Mauritius Mayotte Mexico Midway Islands Moldova Monaco Mongolia Montserrat Morocco Mozambique Myanmar Nambia Nauru Nepal Netherland Antilles Netherlands Nevis New Caledonia New Zealand Nicaragua Niger Nigeria Niue Norfolk Island Norway Oman Pakistan Palau Island Palestine Panama Papua New Guinea Paraguay Peru Philippines Pitcairn Island Poland Portugal Puerto Rico Qatar Reunion Romania Russia Rwanda St Barthelemy St Eustatius St Helena St Kitts-Nevis St Lucia St Maarten St Pierre & Miquelon St Vincent & Grenadines Saipan Samoa Samoa American San Marino Sao Tome & Principe Saudi Arabia Senegal Seychelles Serbia & Montenegro Sierra Leone Singapore Slovakia Slovenia Solomon Islands Somalia South Africa Spain Sri Lanka Sudan Suriname Swaziland Sweden Switzerland Syria Tahiti Taiwan Tajikistan Tanzania Thailand Togo Tokelau Tonga Trinidad & Tobago Tunisia Turkey Turkmenistan Turks & Caicos Is Tuvalu Uganda Ukraine United Arab Emirates United Kingdom United States of America Uruguay Uzbekistan Vanuatu Vatican City State Venezuela Vietnam Virgin Islands (Brit) Virgin Islands (USA) Wake Island Wallis & Futana Is Yemen Zaire Zambia Zimbabwe
Sex: Male Female



Warning: mssql_query() [function.mssql-query]: message: Invalid object name 'Account'. (severity 16) in C:\AppServ\www\Registro2\register.php on line 367

Warning: mssql_query() [function.mssql-query]: Query failed in C:\AppServ\www\Registro2\register.php on line 367

Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in C:\AppServ\www\Registro2\register.php on line 368
Number Accounts:
There are 640 characters made

Quote:

---

Originally Posted by Mikeez

i get http://5.72.37.180/


ImageShack - Hosting :: pageerordf4.png

---

dude i have exactly the same errors ,u know how to fix it?

I already fixed it U will need to rename ur database to "account" and not accounts
Then this register will work perfect check: stogunz.no-ip.org

Bumpty Bump .
Rotana .
Does This Work With Your June Db ?
It Dosent For Me .
Am I Doing Sothing Wrong ?
I Get .

Code:

---

Warning: mssql_select_db() [function.mssql-select-db]: Unable to select database: in C:\xampp\htdocs\register.php on line 3
Create New Account
 User ID:       
 Password:         
 Retype Password:         
 Email:         
Name:       
Age:       
Country:       
Sex:       

Warning: mssql_query() [function.mssql-query]: message: Invalid object name 'Account'. (severity 16) in C:\xampp\htdocs\register.php on line 367

Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\register.php on line 367

Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in C:\xampp\htdocs\register.php on line 368
Number Accounts:

Warning: mssql_query() [function.mssql-query]: message: Invalid object name 'Character'. (severity 16) in C:\xampp\htdocs\register.php on line 370

Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\register.php on line 370

Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in C:\xampp\htdocs\register.php on line 371
There are characters made

---

Hmm ?

I think you dont have the right settings in the config.

How Is It Supposed To Be Set Up ?
It Confuses Mee .

I think you better use ODBC connection, coz ntwdlib is out of the time and not supported by Microsoft anymore.

Code:

---

<?
$DBHost = 'GunzDB'; //The DNSname of your DB (I.E: GunzDB)
$DBUser = 'game'; //Your DB User
$DBPass = 'test'; //Your DB Password
$conn = odbc_connect($DBHost, $DBUser, $DBPass);
?>

---

delete all in the config.php and pleace this in the config.php

Don't work.

First you must add a System-DSN.

Howto: (dutch windows, but just click at the right place in yours)

Start > Run, type odbcad32 and press Ok.

http://i260.photobucket.com/albums/ii6/wtkids/odbc.jpg

Then click on System-DSN and click Add.
Choose SQL-Server and click Finish.
http://i260.photobucket.com/albums/ii6/wtkids/odbc1.jpg
Name = GunzDB
Description = Fill something, doesn't matter
Server: Your sql server, COMPUNAME\SQLEXPRESS.

http://i260.photobucket.com/albums/ii6/wtkids/odbc2.jpg

Choose SQL Server verification and NOT windows verification and fill your username/password from the MSSQL.

http://i260.photobucket.com/albums/ii6/wtkids/odbc3.jpg

Click next, change nothing, click next again and click Finish.

That's it !

Then use the following regpage: (credz to Rotana for the script)

Filebeam - Free Fast File Hosting

This is good stuff, I don't know what Rotana eats everyday :).

Okay It Works Now .
But When I Portfoward .
How Are People Supposed To Register ?
I Used Type My Lan Ip And It Comes Up .
I Type My Wan Ip It Gets 404 Error .
So Give People My Lan Ip To Register ?
Also .
Since I Have A Router .
Am I Supposed To Put My Lan Ip Instead Of Wan ?
Because My Wan Ip Dosent Port Foward .
I Tried Everything .

Heres The Link To See

192.168.15.2 <-- Lan

Check It Out Please .

It works fine i see.

Btw, remove your WAN IP, hackers loves it

Which Ip Did You Use ?
So Does That Mean I Fowarded Ports Right ?

Your external, your internal is only available in your network.

And yes, your ports are correctly forwarded (port 80)

Thanks Very Muchos .
Okay When I Wanna Play With Them .
I Cant Connect With My Wan .
So In My Client Folder I Put My Lan In My System.mrs ?

Some routers block that indeed.

Insert 127.0.0.1 in your system.xml.

Note that if you use a launcher you must bypass him yourself otherwise he will update it to your WAN IP.

I need a script that generates an ip published
since the web server is a server on another machine gunz

Please i need help! I got this error :/

http://img219.imageshack.us/img219/2808/errorxz3.jpg

Erm sry for double post :S

Use the script dat i wrote. It's in this topic.

Ehhe its better but still get error... Help ^^ Do i need upload my Database?

http://img212.imageshack.us/img212/3817/errornq3.jpg

Remove the email in the script or change your database so it can store emails.

Quote:

---

Originally Posted by Wizkidje

Remove the email in the script or change your database so it can store emails.

---

Ok i try tnx :P

when i put on my website its just a blank site....

I tryed Freewebs hosting but that failed to when ever you click register it just says :

Ooops page not found on a freewebs page and is hard to fit coding into it.

Any1 got any good hosters ?

try Free Web Space Inc. offers free and cheap web hosting packages.

"; $query1 = mssql_query("SELECT CID From Character"); $num_rows2 = mssql_num_rows($query1); echo "There are $num_rows2 characters made
"; // Funo Anti Injection function anti_injection($sql) { $sql = preg_replace(sql_regcase("/(from|select|insert|delete|where|drop table|show tables|#|\*|--|\\\\)/"),"",$sql); $sql = trim($sql); $sql = strip_tags($sql); $sql = addslashes($sql); return $sql; } // Verificar Campos Vazios function valida($campos){ foreach($campos as $c){ if(empty($c)){ echo ":: All fields needed ::
"; return false; }else{ return true; } } } ?>

Thats what i get from that 150m.com site.

i dun get how to use ti coz it dusnt let you use .php files so i had to convert it too .html

dunno if that is causing that problem

also whenever you do click create Account it takes me too :

File Not Found!

The file you are searching for is not located on our servers. Please check your spelling. File names may be case sensitive. Please verify the URL as this is the most common reason for this error.

Impossible to run at other hosting, you must run it at your own pc.

(Except the other hosting accepts ODBC or mssql connections)

well when i put on my website its just a blank page??? any help

Wizkidje or anyone..

could sum1

a ) give me hostign website to put the files onto.
b ) tell me why them errors occured ( ABOVE ) when it was on my laptop which was where the files are being hosted.

c ) Thanks in forwarding

BUMP

Ahh, i guess not working cus i dont got php program can someone tell me download link..?
this is kinda stupied cus im new...xD
got error:
"Fatal error: Call to undefined function mssql_select_db() in C:\wamp\www\register.php on line 3"
need help to fix it i need php program how i can get it dunno. need help..

worked but now new error:
Warning: mssql_select_db() [function.mssql-select-db]: Unable to connect to server: (null) in C:\wamp\www\register.php on line 3

Warning: mssql_select_db() [function.mssql-select-db]: A link to the server could not be established in C:\wamp\www\register.php on line 3

Create New Account
User ID:
Password:
Retype Password:
Email:
Name:
Age:
Country: Country... Afghanistan Albania Algeria American Samoa Andorra Angola Anguilla Antigua & Barbuda Argentina Armenia Aruba Australia Austria Azerbaijan Bahamas Bahrain Bangladesh Barbados Belarus Belgium Belize Benin Bermuda Bhutan Bolivia Bonaire Bosnia & Herzegovina Botswana Brazil British Indian Ocean Ter Brunei Bulgaria Burkina Faso Burundi Cambodia Cameroon Canada Canary Islands Cape Verde Cayman Islands Central African Republic Chad Channel Islands Chile China Christmas Island Cocos Island Columbia Comoros Congo Cook Islands Costa Rica Cote D'Ivoire Croatia Cuba Curacao Cyprus Czech Republic Denmark Djibouti Dominica Dominican Republic East Timor Ecuador Egypt El Salvador Equatorial Guinea Eritrea Estonia Ethiopia Falkland Islands Faroe Islands Fiji Finland France French Guiana French Polynesia French Southern Ter Gabon Gambia Georgia Germany Ghana Gibraltar Great Britain Greece Greenland Grenada Guadeloupe Guam Guatemala Guinea Guyana Haiti Hawaii Honduras Hong Kong Hungary Iceland India Indonesia Iran Iraq Ireland Isle of Man Israel Italy Jamaica Japan Jordan Kazakhstan Kenya Kiribati Korea North Korea South Kuwait Kyrgyzstan Laos Latvia Lebanon Lesotho Liberia Libya Liechtenstein Lithuania Luxembourg Macau Macedonia Madagascar Malaysia Malawi Maldives Mali Malta Marshall Islands Martinique Mauritania Mauritius Mayotte Mexico Midway Islands Moldova Monaco Mongolia Montserrat Morocco Mozambique Myanmar Nambia Nauru Nepal Netherland Antilles Netherlands Nevis New Caledonia New Zealand Nicaragua Niger Nigeria Niue Norfolk Island Norway Oman Pakistan Palau Island Palestine Panama Papua New Guinea Paraguay Peru Philippines Pitcairn Island Poland Portugal Puerto Rico Qatar Reunion Romania Russia Rwanda St Barthelemy St Eustatius St Helena St Kitts-Nevis St Lucia St Maarten St Pierre & Miquelon St Vincent & Grenadines Saipan Samoa Samoa American San Marino Sao Tome & Principe Saudi Arabia Senegal Seychelles Serbia & Montenegro Sierra Leone Singapore Slovakia Slovenia Solomon Islands Somalia South Africa Spain Sri Lanka Sudan Suriname Swaziland Sweden Switzerland Syria Tahiti Taiwan Tajikistan Tanzania Thailand Togo Tokelau Tonga Trinidad & Tobago Tunisia Turkey Turkmenistan Turks & Caicos Is Tuvalu Uganda Ukraine United Arab Emirates United Kingdom United States of America Uruguay Uzbekistan Vanuatu Vatican City State Venezuela Vietnam Virgin Islands (Brit) Virgin Islands (USA) Wake Island Wallis & Futana Is Yemen Zaire Zambia Zimbabwe
Sex: Male Female



Warning: mssql_query() [function.mssql-query]: Unable to connect to server: (null) in C:\wamp\www\register.php on line 320

Warning: mssql_query() [function.mssql-query]: A link to the server could not be established in C:\wamp\www\register.php on line 320

Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in C:\wamp\www\register.php on line 321

Warning: mssql_query() [function.mssql-query]: Unable to connect to server: (null) in C:\wamp\www\register.php on line 324

Warning: mssql_query() [function.mssql-query]: A link to the server could not be established in C:\wamp\www\register.php on line 324

Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in C:\wamp\www\register.php on line 325

Warning: mssql_query() [function.mssql-query]: Unable to connect to server: (null) in C:\wamp\www\register.php on line 328

Warning: mssql_query() [function.mssql-query]: A link to the server could not be established in C:\wamp\www\register.php on line 328
:: Error on account register try later ::

Warning: mssql_query() [function.mssql-query]: Unable to connect to server: (null) in C:\wamp\www\register.php on line 367

Warning: mssql_query() [function.mssql-query]: A link to the server could not be established in C:\wamp\www\register.php on line 367

Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in C:\wamp\www\register.php on line 368
Number Accounts:

Warning: mssql_query() [function.mssql-query]: Unable to connect to server: (null) in C:\wamp\www\register.php on line 370

Warning: mssql_query() [function.mssql-query]: A link to the server could not be established in C:\wamp\www\register.php on line 370

Fatal error: Maximum execution time of 30 seconds exceeded in C:\wamp\www\register.php on line 370

PLS HELP ME i keep getting this error

Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: splitsecond\SQLEXPRESS in C:\xampp\htdocs\config.php on line 9

Warning: mssql_select_db() [function.mssql-select-db]: Unable to connect to server: (null) in C:\xampp\htdocs\config.php on line 10

Warning: mssql_select_db() [function.mssql-select-db]: A link to the server could not be established in C:\xampp\htdocs\config.php on line 10

Full items, premiums for free and all modes
Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: splitsecond\SQLEXPRESS in C:\xampp\htdocs\index.php on line 12
Cannot connect to the Database

Fisrt dont bump old threads, i think you need the newer ntwdblib.dll. That's posted somewhere around search for it.