Zugg Software :: View topic

Newbie Joined: 17 Aug 2006 Posts: 9

I'm sure someone has already done this. I want to capture information on items in Materia Magica and store it (I'm happy to shove it all into a text file for later processing, however if someone has already written it to grab it all and shove it in an Access DB all the better)

Format is something like:

Item 'a friar's lantern' is type light, alignment 0, made of unknown-alloy,
has keywords 'friar lantern'.
This item weighs 0 stones and 20 pebbles, and is valued at 500 gp.
This level 5 item has the attributes: identified
A friar's lantern is in excellent condition.
This light source will last for another 50 minutes.
*This item may be repaired 7 more times.

Format changes for each item.

Any assistance welcomed.

Magician Joined: 29 Nov 2005 Posts: 482

THis has been done and you are better off using the zmud database already included with the software or writing it to text file although you can export it to and ODBC source.

There are ways to export it into a database i already do this automatically with my rooting scripts and 95% of my other scripts for administrative functions for the clan system.

This is an example of the ship location tracking system i use in the game to track everyones ships. It merely requires you to setup an ODBC connection to your mysql server or access file etc. basically anything. Mines for mysql. This is just to give you an idea.

You will need to research and develop your own system. A few of us in game have item loggers and use them for our websites to track the auction channel and autoadd anything new. However each format is a bit different as you said because the format changes for each item. This locator will give you a basic example of taking data from MM and adding it to a mysql database.

*** NOTE REALIZE THAT IF YOUR DB OR ACCESS FILE DIES IT WILL ERROR OUT ALL OVER THE PLACE AND YOU WONT BE ABLE TO PLAY UNTIL YOU RECREATE IT OR DISABLE IT SO I RECOMMEND MAKING AN ON OFF SWITCH FOR THE CLASS***

FOR MYSQL ODBC you will need a connector

http://dev.mysql.com/get/Downloads/MyODBC3/mysql-connector-odbc-3.51.12-win32.msi/from/http://www.stathy.com/mysql/

Root counter and adjustments - http://mminfo.homeip.net/misc.php?action=roots (I cant show you the administrative view because its well admin protected but this will give you an idea what we do here)

i.e. ship locator - Example output ( http://mminfo.homeip.net/maploc.php ) green - moving red-anchored and grey - inactive within last 10 minutes or so.