[RELEASE]GunZ Web Evolution 1.0!!! (For 100% DB)

[cyberspeed]

Ok, finally im releasing the web for 100% database, the features:

• Installation wizard, easy install and configure!
• Multi language!
• Very Secure!
• Auto creation of columns needed in installation.!
• My own News System!
• Auto deletion of install files!
• User CP!
• Admin CP!
• Registration Form
• Rankings ordered by XP (Can be changed)
• Download page
• Lost Password
• Password Change
• E-Mail Change

A little turorial
1: Before entering the web, wich will take you to the installation automatically, you MUST restore the db attached here, that db have the config and news of the site and must be called "GunZWeb".
2: You MUST have sql authentication mode enabled, if you dunno what im talking about, you can find two files in the zip: "SQL2000.reg" and "SQL2005.reg", just double click on the one corresponding to your sql version and accept, you can create a user in the Management Studio under security->Logins.
3: Enter the web and follow the installation steps, they are just 2, so dont worry, after that, you'll have your web working

If you typed wrong your config info in the installation, you can fin it in "_inc/config.php"
and the query to add the Code column is this:

ALTER TABLE Login ADD Code char(4) not null default'1234'

remember that after that, all existing users will have Code="1234".
To access the admin area you must be identified on the web with an account with UGradeID>0, means, only admins and GM's allowed, there, you can add,/edit/delete news, change options of the page, and that stuff; if you want a special level you can change it in admin/check.php:

$query = mssql_query ("SELECT AID from Account WHERE UGradeID>'0' and UserID='$Usuario'"); 

for example if you want only admins (users with UGradeID=255) to access, you must change that line to:

$query = mssql_query ("SELECT AID from Account WHERE UGradeID='255' and UserID='$Usuario'"); 

Finally, to edit rules and contact information, edit rules.txt and contact.txt.

THE WEB IS LACKING PORTUGUESE AND DEUSTCH FILES, FOR NOW JUST DONT USE THEM!
Tomorrow, a guy will make portuguese, if you can do deustch, just post it here attached to you message and ill put it here.

URGENT FIX!
Sorry, but i dont really know so much about GunZ, im just web coder, the admin area has a really important error! It lets banned people to enter the admin area!
Open "admin/check.php" and change this line:

$query = mssql_query ("SELECT AID from Account WHERE UGradeID>'0' and UserID='$Usuario'"); 

For this one:

$query = mssql_query ("SELECT AID from Account WHERE UGradeID>'253' and UserID='$Usuario'"); 

ATTACHED SQL QUERY FOR PEOPLE THAT WAS HAVING TROUBLES RESTORING THE DB

[MentaL]

[wesman2232]

good work man, I just dont use botgods DB. I use BR client

[cyberspeed]

thats the one, you use the 100% db?
i guess...
try and you will see

[Mikeez5]

can you remoto assit my computer?

and put ur credit at top of page?

[cyberspeed]

the credits should be on the place they are, why you want remote assistance?

[wesman2232]

ok a few more questions :
1. where to put these files (i have in my C drive)
2. How to open?
or a better question : how to run?

Im a noob at this stuff :P

[cyberspeed]

you need to have a server installed, try wamp, xampp or better, EasyPHP

[wesman2232]

i use xampp, everything runs except for apache

[cyberspeed]

then you have a configuration problem in xampp, try easyphp

[hlcm]

ok this release for BR database

and i found a new bug

change pass don't work , try and see
( password in dbo.login not in dbo.account)

nice release thanks cyberspeed

[own_prox]

it dont work it gets to install step 2 then dosnt load

[hlcm]

it dont work it gets to install step 2 then dosnt load

restart your wamp, it will run

[kekku500]

nice work, finnaly done :),
any pictures?

[Amandy]

For password change you need

$query = mssql_query("INSERT INTO Account Password VALUES ('$pass1') INSERT INTO Login Password VALUES ('$pass1')"); 

I think Thats right

[Jissu]

That db is .BAK file, wich i cant open. .SQL Please!?!?