MySQL GunZ

[Exiled Hero]

Wasn't exactly planned to release this but since it's Christmas. I'll be nice.

Before anyone says that GunZ doesn't work with MySQL. I tell you now, it does.

Converted
-Tables
-Functions
-Procedures

Other
-Added some views
-Automatically added test account
-Server statues already filled out
-Removed the web procedures

Installation

1. Download any MySQL GUI and import the SQL script.
2. Download and install the MySQl ODBC driver which can be found here
3. Do the odbcad32 crap like you do with Mssql but with the MySQl ODBC

Known Issue

There is one issue that has been bugging me but I haven't properly looked into.

The locator runs perfectly with MySQL but it doesn't open up a server.

If you find a fix for that, congratulations.

Download

MySQL database for 2007 files
MySQL FR2010 database (Final Revolution 2010)

[MentaL]

[Itachi6972]

Nice release Paul.

[RodiSR]

First response well i really this is a great christmas present thanks =] its a nice release thanks for releasing it btw.

Woops damn itachi your fast 0.o btw are you itachi that worked for epicgamers?

[Ricky Blaze]

Nice Paul.

[Lambda]

Is this done 100% by you?, i ask because i had a DB for GunZ in MySQL for the first release of herogamers a long time ago and i gave it to OWS for his emulator, but the servers was lagging out of the hell when the server was with 500-600 players, that's the reason because we've switched back to MSSQL.

[Exiled Hero]

Is this done 100% by you?, i ask because i had a DB for GunZ in MySQL for the first release of herogamers a long time ago and i gave it to OWS for his emulator, but the servers was lagging out of the hell when the server was with 500-600 players, that's the reason because we've switched back to MSSQL.

Yes it's 100% done by me. I don't even have OWS added.

[Lambda]

Yes it's 100% done by me. I don't even have OWS added.

Ok, fine, notice that i dont really care if it was my db it was just curiosity :) i have lost it a long time ago.

[Exiled Hero]

Ok, fine, notice that i dont really care if it was my db it was just curiosity :) i have lost it a long time ago.

even if I did have OWS added, he would of most likely lost it. x]

[Touchwise]

@ lambda : wasn't your db the one released before because i remember there was a MYSQL DB released before i saw it some time ago again when i was going through all the pages of the gunz section..

@ Pau: : Great release i will have a look in to it..

[KillerStefan]

Sorry for not responding on MSN, I was AFK.
Anyway good job.
Now if someone finishes Phail's emu, I see new possibilities

[alfredao]

Very nice, thanks :D

[Military]

can you do the one with the Fr2010 Database?

[Exiled Hero]

can you do the one with the Fr2010 Database?

Fr2010 database?

Link me and I'll get right on it. =)

If people still use iGunz server files I'll do that as well.

[Military]

http://forum.ragezone.com/f245/final...dition-625828/

[Exiled Hero]

http://forum.ragezone.com/f245/final...dition-625828/

I'll have it done in a couple of hours or for boxing Day.

As from tomorrow, I have a three day Christmas dinner.