igRegister(1.0) Register and Ranks (SQL 2008)

[CobraCom]

I use these files for my gunz server. It includes Registration and Ranks, since most registration files on ragezone use "odb", which is Spanish to SQL 2008, I discided to make some new ones.
Credits to my gunz server: www.ignition-gaming.net
These should work on SQL 2005 too. (I suggest using Xampp 1.7 as webserver.)
Also you might need this: http://ignition-gaming.net/ntwdblib.rar (put the .dll in .../apache/bin/)

Registration:
- Registration of extra user info.
- Ip Logging (in dbo.ip)

Rankings:
- Advanced rankings for characters.
- Search function.
- Sort by function.
- Ammount of Players online.

Screenshot:


There are some DB edits you need to do to get it working.

Go to your DB => Tables => Right-click Account => Design =>
On the bottom add Password (Culumn Name) varchar(20) (Data Type)

Then go all the way back to your database.
Your DB => Right-click Tables => New Table...
Add the following: (Dont allow NULL on any)

ip nchar(20)
date nchar(20)
fror nchar(20)

Then close it with the "X" and it will ask for a name for the DB. use "ip" as the name.

Then the last edits will be in the files themselves:
==> config.php

edit:

$host = ''; // SQL Name here (...\SQLEXPRESS)
$user = ''; // Admin accont (sa or your computer user)
$pass = ''; // Password

Download here: http://ignition-gaming.net/igGunz1.0reg.rar

Credits:
- Me (Snaps/CobraCom/Juiceh)

Special thanks to:
- Ignition Gaming community for giving suggestions.
- Phail: for making me realise it used to be a crappy security

[MentaL]

[BRAZIL-PAULINHO]

thx first comment
I LOVE U

[katsumi]

thank you it is good

[Demantor]

Thanks, nice

[Joe9099]

Very nice, i might use this

[wesman2232]

very nice though the connect "odb" in your words is actually ODBC which is in odbcad32 program not SQL 2008 :P
love the release though, thanks.

[CobraCom]

yeah, but it doesnt really mather, everyone knows what I mean :P
ODBC is included in 2008, but the PHP compiler doesn't connect to it.

[alfredao]

Very Nice, Thanks!

[bounty-hunter]

Great, now add that ijji web interface to it :D

[CobraCom]

Great, now add that ijji web interface to it :D

I'm not really into the whole, "Let's rip templates"-idea.
But I could do a special ijji template.

[bounty-hunter]

Do it nao!!!!!!

[CobraCom]

Meaby later

[death4u2]

nice i guess i will use it for my server iam bored by using my old crappy ass one XD

[CobraCom]

Some other news, I'm developing a newer version with some extra functions.
Lately I added an auto-link to the clan (if the user has one), clicking the link will show the clan members in that clan.

[Nobody666]

Tried this didn't work >_> this is what went wrong.