Zugg Software :: View topic

Beginner Joined: 27 Feb 2004 Posts: 13

"The Automapper module in zMUD has been rewritten from scratch to use an SQL database engine (using the MDAC database software that comes with Windows). "

Does this mean i can use a MySQL server for the mapper ? and if yes, how? :-)

It would be wonderfull if this worked ... So i can use them to make interactive maps on my webpage

Magician Joined: 17 Oct 2001 Posts: 371 Location: USA

I'm not sure what you mean. If you mean you want to create a SQL server for people to download and update one map on a database server, then no, not at the moment. zExplorer supports this right now, but zMUD and zMapper don't have this built into them yet. Zugg says that eventually zMapper will have all that code, but this is a long way down the road. You can script use very powerful scripting techniques on you local copy of the map, with ADO, and especially if you've got zMapper installed.

Beginner Joined: 27 Feb 2004 Posts: 13

I only have Zmud.

And what i want to do, is have my maps in an sql database
and then make a php class that can display those maps.

So all I want, really, is to be able to have a format from my zmud mapper that I can access in a decent way with php.

And MySQL would have been nice for that.

GURU Joined: 28 Sep 2000 Posts: 434 Location: USA

Unfortunately, what you are asking is not directly possible. zMUD uses a MDAC/Jet combination (Microsoft Access format). There is no way to change this from within zMUD.

However, there are utilities available that will copy the structure and data from any ODBC source. Mascon comes to mind, although I think it is expensive. You could even get down and dirty with zMUD and myODBC (MySQL® Connector/ODBC), and use ADO scripting to synchronize the two.

I have a feeling though, that Charbal may already have a solution for this. You might try politely bugging him for any help he is willing to give.

Wizard Joined: 14 Oct 2000 Posts: 1368

quote:
Originally posted by Carabas

Unfortunately, what you are asking is not directly possible. zMUD uses a MDAC/Jet combination (Microsoft Access format). There is no way to change this from within zMUD.

SQL is a "standard"(that barely anyone follows Smile

) though. Wouldn't it be possible to use Access to export a .SQL file with the table definition/data and then import it to MySQL?

Another method is to simply use ADO with PHP. This could be done using COM support, if the PHP server is running on Windows.

A tool like the one described has already been made though. It does not appear to be avaible for download but here's the link to the post about it(the developer forum):
http://www.zuggsoft.com/forum/topic.asp?TOPIC_ID=13596