Register to post in forums, or Log in to your existing account
 

Play RetroMUD
Post new topic  Reply to topic     Home » Forums » CMUD General Discussion
Mondor
Novice


Joined: 26 Nov 2008
Posts: 33

PostPosted: Wed Dec 10, 2008 12:34 am   

Setting up a database for additional room information
 
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
Reply with quote
Tech
GURU


Joined: 18 Oct 2000
Posts: 2733
Location: Atlanta, USA

PostPosted: 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?
_________________
Asati di tempari!
Reply with quote
Mondor
Novice


Joined: 26 Nov 2008
Posts: 33

PostPosted: Mon Dec 22, 2008 4:12 pm   
 
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.
Reply with quote
Display posts from previous:   
Post new topic   Reply to topic     Home » Forums » CMUD General Discussion All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

© 2009 Zugg Software. Hosted by Wolfpaw.net