[Release][TUT]Register page With IPBAN script( 100%Working )

I released this because alot people need a good register page and i redesigned it abit deleted couple collums putted new one's.
hope u guy's like the register page it is for the 100%DB and BrgunzDB.
i included a ipban script for the register page for if people are hacking on ur server and u don't know how to ip ban them ingame then u can go in dbo.login and search there loginid and after that there's someting called LastIP there u can search for the ip of them and then put the ip in the chk_ban.php script and it will ban them, And yes u can put it on other php pages.

How to get ur register page working, First u need to do all the gunz stuff to set up a server when u done that if u have a router portforward port 80 tcp / upd.
then download Appserv from here

Code:

---

http://prdownloads.sourceforge.net/appserv/appserv-win32-2.5.9.exe?download

---

If u downloaded that install it and chek all the options u can choose and put the mssql stuff u want and when ur done installing there will be 2boxes that asks to start appserv directly unchek them and click finish. and download the ntwdblib.rar from the attachment extract it and replace it with the one in from the map php5, And also put it in Apache2.2/bin if u did that
press start, Run, type php.ini and delete ; from the line

Code:

---

;extension=php_mssql.dll

---

if u did that it would look like this

Code:

---

extension=php_mssql.dll

---

and save it, Then extract the RegisterPage.rar and put all the files in the www folder and put all ur stuff at config.php and if u done that save it and then go to C:\AppServ\Apache2.2\bin and click on ApacheMonitor.exe and turn it on and then open ur internet explorer and type

Code:

---

http://www.whatismyip.org

---

and it will say ur wanip and put that ip in the internetexplorer and voilla ur registerpage works.

And to let ur ipban script work on ur register page follow this.

in the extracted file's there is a php file called chk_ban in there u see this line.

Code:

---

$msg_ban = "This ip is banned ur not restricted to this page ~ Rodi for more contact us at skygamerz@live.com";

---

That is the line that u will get if u are ipbanned from the register page.
just change the line between the " " to change the line it would look like this.
[code]$msg_ban = "Between this";[code]
if u did that u are done with the ipban message.

Now how to ipban people from ur registerpage.

in this line

Code:

---

//Put here the ip's that u wanna ban
$ipadr[0] = "";
$ipadr[1] = "";
$ipadr[2] = "";
$ipadr[3] = "";
$ipadr[4] = "";
$ipadr[5] = "";
$ipadr[6] = "";
$ipadr[7] = "";

---

the numbers meens how much times u can ipban someone there are only 7 of those but u can make more just put others like

Code:

---

$ipadr[8] = "";

---

etc
To ban people u gotta put there ip between the " " tags and save it.
and u can put the ban script on more php pages just put this line above all the pages u want it will ban don't worry that u gotta make more chk_ban all will redirect to the one u extracted if its in same folder.

Code:

---

<?
include('chk_ban.php');
//Page underthis
?>

---

put that above all pages u want those ip's cant go on and save it and if u have a html page just open it with frontpage ur someting and save it as .php and then put it above then it works to i hope i helped u guy's the credits goes to me for redesigning things and putting new collum's and collours cell's etc, But i redesigned it out of the simple php script from Rotana so credits goes to him to, And sorry for my english i know it sucks but i tried my best so don't flame me please just wanted to help.

Here for images.

http://img291.imageshack.us/img291/3927/banpageat2.png

http://img149.imageshack.us/img149/8...terpagejv5.png

nice !

Yet again a failing guide..

Its not a failing guide it works :/ when u installed appserv did u unchek the 2 boxes at the end so it wont start apache ? and replaced the dll thingie in php5 and in bin ? and then started apachemonitor it should work:/ and dont say its a failing guide i putted everything in it didnt see u make a guide:/

umm.. try..

this:

Code:

---

$dns="GunzDB";
$user="sa";
$pass="password";
$connect=odbc_connect($dns, $user, $pass) or die ("Couldn't connect to the database, we're sorry...");
odbc_exec($connect,"use GunzDB");

---

much more compable, you dont need to install any think more, and its sported by MSSQL program

Thanks, it works with XAMPP too

Quote:

---

Originally Posted by rodanio14

Its not a failing guide it works :/ when u installed appserv did u unchek the 2 boxes at the end so it wont start apache ? and replaced the dll thingie in php5 and in bin ? and then started apachemonitor it should work:/ and dont say its a failing guide i putted everything in it didnt see u make a guide:/

---

To be honest.. no

not everything is there , YOU DIDNT EVEN MENTION TO EDIT CONFIG.PHP !!!!!

I did replace all the things.. mite not of dun the 2 boxes, but i didnt run apachemonitor

Quote:

---

Originally Posted by MAXTRAXv3

umm.. try..

this:

Code:
$dns="GunzDB";
$user="sa";
$pass="password";
$connect=odbc_connect($dns, $user, $pass) or die ("Couldn't connect to the database, we're sorry...");
odbc_exec($connect,"use GunzDB");much more compable, you dont need to install any think more, and its sported by MSSQL program

---

Was that aimed at me ? And do you want me to change sa and password ?

also sa = ??? what ???

Why dont you use the Database for Gunz , to get your IP bans - instead of having to manually input them.

Nice release.

Quote:

---

Originally Posted by Jaycub

To be honest.. no

not everything is there , YOU DIDNT EVEN MENTION TO EDIT CONFIG.PHP !!!!!

I did replace all the things.. mite not of dun the 2 boxes, but i didnt run apachemonitor



Was that aimed at me ? And do you want me to change sa and password ?

also sa = ??? what ???

---

Sorry i already told my english isnt that pro but i putted it

Quote:

---

Then extract the RegisterPage.rar and put all the files in the www folder and put all ur stuff at config.php and if u done that save it

---

And sa is when u choose at mssql install mixedmode with a password then it will automaticaly make a userid with the name sa and the password u putted at the mixedmode.

Why not use a MSSQL or (better) a MySQL table with the IP's in it ?

Quote:

---

Originally Posted by rodanio14

And sa is when u choose at mssql install mixedmode with a password then it will automaticaly make a userid with the name sa and the password u putted at the mixedmode.

---

Sorry : (

Tat makes NOOOO Sense to me !

:poster_je

Quote:

---

Originally Posted by Antv912

Why dont you use the Database for Gunz , to get your IP bans - instead of having to manually input them.

---

I have this too. It prevents people from even registering an account, good against spammers.

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

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

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


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

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

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

that happens to me what am i doing wrong?

Quote:

---

Originally Posted by Wizkidje

Why not use a MSSQL or (better) a MySQL table with the IP's in it ?

---

thats why..

Quote:

---

Originally Posted by xXPointBlankxXx

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

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

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


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

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

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

that happens to me what am i doing wrong?

---