The file is straight SQLite database. Maybe the LINQPad has an older version built in? More recent versions of SQLite have an option for storing the database in a slightly different format (for faster access). You can convert to/from this other format. (See my page about SQL I think).
As for the non-unique rooms, they are a pain. In one case I included exits so that hopefully two rooms with the same description have different exits, so that can be used to differentiate.
Thank you Nick, that was very helpful and got me rolling in the right direction so I'm seeing success working with the mapper.
What I need to come up with now is a reliable way to handle the fact that many rooms will have the same name and description. Even simple things like the uneventful portions of streets in the main town, there will be a couple rooms in a row with the same name and description as you travel down the street. I have a "master" version of the game's database in MySQL tables, so with a little legwork it's possible for me to know the guid of any given room. I tried to open the .db file of the mapping database generated by the mapper, but LINQPad with the IQ driver (for SQLite files) said that it was either encrypted or an invalid database.
Any ideas out there for handling non-unique room mapping are most welcome :)
But you could just make up a trigger in the GUI interface, set it to match what you want, then copy it to the clipboard and see what the parameters to the trigger are.
Amended on Thu 23 Feb 2012 07:27 PM (UTC) by Wahnsinn
Message
Hi Nick, I've been reading the posts (and code) for the Materia Magica mapper plugin (http://gammon.com.au/forum/bbshowpost.php?id=10667), brilliant work! It seems to be exactly the kind of thing that most mudders would just love!
Using the latest version of your Materia Magica mapper as a starting point, I'm trying to adjust it to begin mapping for MajorMUD. It should be a positively simple process because there isn't too much difference in the formatting. What's hanging me up right now is a trivial matter, I just haven't been able to find what I need to solve it when searching through the forums. Here's what a simple room looks like:
What's stopping me from getting anywhere is that the color of the room name is different. I've taken a couple guesses, but I can't seem to find a table or reference list for the color codes that you use when telling the triggers to match color. This is the trigger I'm looking at, which it seems finds a bold yellow line of text in Magica that denotes the name of the room:
The dates and times for posts above are shown in Universal Co-ordinated Time (UTC).
To show them in your local time you can join the forum, and then set the 'time correction' field in your profile to the number of hours difference between your location and UTC time.