Zugg Software :: View topic - Setting up a database for additional room information

Novice Joined: 26 Nov 2008 Posts: 33

I want to be able to store the following information against a roomkey: a shrine if present, a shrine type (major, minor, etc), quest item(s), denizen(s). A record would only exist in this database if one or more of these objects were in this room.

I could do this with individual database variables, but thought a proper database might be easier to maintain and would provide views, etc.

I've never used the 'objects in the room' facility on Room Properties - is this where I would sync the mapper database and a separate room objects database? Are there hidden fields on the mapper room record for this information.

I would be interested to read how others approached this functional design.

I've been through the Help file and I must be missing something as it's not leaping out at me. By the way, where are these templates that are referenced in the help file?

Thanks in advance

Posted: Sat Dec 20, 2008 11:10 pm

The database templates seems to have been lost somewhere along the way... I submitted a bug report to Zugg. Not sure when it happened as most of the Beta testers probably had our DBs already or manually created them.

There is no way to automatically sync your separate database and the roomobjects list. This is just a string list managed by %roomcontents.

The stringlist or full DB approach will both work, the latter being a bit cleaner, and the former being easier to implement. The real question is how you plan to use the data? Will you be manually looking at it? Programmatically? How often? Are the shrines, denizens etc foreign keys into other DBs?

Novice Joined: 26 Nov 2008 Posts: 33

Thanks for the reply. I ended up using the dbvar approach to store shrine information by %roomkey(). I was thinking about reporting shrines by zone where I would draw the %roomname in. If I decide to do this, I will probably create and load a proper database from the dbvar where I could use views. I wouldn't be using programmatic lookups.

I appreciate your explanation of what is really there. It was hard for me to follow the help file discussions.