mysql gunz

[CaShiNz]

is it possible to create gunz using mysql... if there is can anyone show me

[MentaL]

[Number12]

you mean the database? And yes it can be done. There is one database that was already released for MySQL

[Exiled Hero]

I released a MySQL database with converted tables and procedures. There are people who had trouble importing it.

I haven't had time to fix it nor have I been home lately. If you fix, you got a nice working GunZ MYSQL.

[Arcelor]

Could you work on fixing it Paul?

[CaShiNz]

yea.. i got the database.. but what about the matchserver? and client... how do you make them connect to the MySQL DB?

[Exiled Hero]

Could you work on fixing it Paul?

Sorry for late reply.

If I'm ever home I will. That will most likely be in a couple of months or even a year. I'm Mr. Portable at the moment.

I can ask a friend to look into it I guess but in the mean time, you may have to look into it yourself.

This error was reported by Millitary.

Script line: 1385	You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"fnGetMin"(v_n1 INT, 
v_n2 INT) RETURNS int(11)
BEGIN
RETURN(CASE WHEN v' at line 1

If anything, you might as well go over to the brainiacs over at the MySQL developer forum. They can fix it in an instant.

yea.. i got the database.. but what about the matchserver? and client... how do you make them connect to the MySQL DB?

1. Download any MySQL GUI and import the SQL script.
2. Download and install the MySQl ODBC driver (Google it)
3. Do the odbcad32 crap like you do with Mssql but with the MySQl ODBC

[Arcelor]

And mssql_connect() is mysql_connect().

[CaShiNz]

the matchserver opens.. but it gets disconnected.. the locator doesnt show up it says this:

MLocatorDBMgr::StartUpLocaterStauts - PROCEDURE gunzdb.spStartUpLocatorStatus does not exist

MLocator::Create - DBÃʱâÈ­ ½ÇÆÐ.

[Exiled Hero]

the matchserver opens.. but it gets disconnected.. the locator doesnt show up it says this:

MLocatorDBMgr::StartUpLocaterStauts - PROCEDURE gunzdb.spStartUpLocatorStatus does not exist

MLocator::Create - DBÃʱâÈ­ ½ÇÆÐ.

It depends what you used to import the MySQL script. If it's PHPMyAdmin, it doesn't import functions or stored procedures.

Navicat or MySQLYog should do the trick.

Also.. make sure you got the GunZ MySQL from here.

http://forum.ragezone.com/f245/mysql-gunz-632451/

[CaShiNz]

um.. what do you mean to import? i use Mysql.. that comes with wamp and this is how i imported the script..
i opend the mysql gunz db on notepad
copyied the script
and then when to SQL and pasted the code and then it createed a mysql GunzDB for me on the tables

[Exiled Hero]

um.. what do you mean to import? i use Mysql.. that comes with wamp and this is how i imported the script..
i opend the mysql gunz db on notepad
copyied the script
and then when to SQL and pasted the code and then it createed a mysql GunzDB for me on the tables

That's where you went wrong. GunZ doesn't just use tables, it uses functions and stored procedures too.

Obviously you are copy and pasting into PHPMyAdmin, which doesn't execute stored procedures or function. That's why I said download Navicat or MySQLYog.

[eele]

I had tried it, I had problems with importing the stored procedures. As Paul said..

You'll need a odbc connection for MySQL you can find it at
http://dev.mysql.com/downloads/connector/odbc/

Do the same with as you did with the original only now for you MySQL server.

I edited the open source locator emulator from RepublicOfAstra for a MySQL connection it connected only servers didn't show up because I didn't had a good database xd

[coole9]

lol your 2nd link dont work paul..

[CaShiNz]

i did all that.. even with Mysqlyog but i get the same error with locator