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

Play RetroMUD
Post new topic  Reply to topic     Home » Forums » zMUD General Discussion
Skaphia
Beginner


Joined: 18 Dec 2002
Posts: 27
Location: USA

PostPosted: Sun Apr 20, 2003 5:39 pm   

Database trigger for an auction
 
I want to make a Database of information on the equipment that exists in our mud (Realms of Despair). We have an auction channel that people auction off equipment on. I wanted to know if it was possible for a trigger to save an item's statistics into the database in zmud from simply looking at the auctioned item's definition. An example of one item:

Current bid on this item is 300,000,000 gold.
Object 'circle of mists'...
It is a level 50 armor, weight 2.
Locations it can be worn: waist
Special properties: dark
Races allowed: Half-Orc Gith Drow
Classes allowed: none
Genres allowed: rogue fighter aberrant shaman
Alignments allowed: evil good
This armor has a gold value of 5000000.
Armor class is 14.
Affects damage roll by 4.
Affects hit roll by 1.
Affects hp by 35.
Affects save vs poison by -4.
Affects intelligence by -3.
Affects wisdom by -3.
Affects dexterity by 2.

Okay now obviously there is a lot of information that needs to be recorded. If this is possible please help me out I would be most thankful. The most important part of this trigger though is I am curious if one item can replace another if the level is lower. For example the item above is level 50. If a level 49 version of the same item appeared on auction I would like the database to record that the item is level 49 and not level 50. Is this possible? Thanks for any help you can give me.

Skaphia
(realms.game.org 4000)
Reply with quote
Skaphia
Beginner


Joined: 18 Dec 2002
Posts: 27
Location: USA

PostPosted: Mon Apr 21, 2003 1:06 pm   
 
Nobody has any information on how to do something like this ? :((((
Reply with quote
LightBulb
MASTER


Joined: 28 Nov 2000
Posts: 4817
Location: USA

PostPosted: Mon Apr 21, 2003 2:28 pm   
 
You can find numerous entries on "database script" with a search. For instance, this one in the Finished Scripts forum:
Realms of Despair -- Equipment Database Script

LightBulb
Advanced Member
Reply with quote
Skaphia
Beginner


Joined: 18 Dec 2002
Posts: 27
Location: USA

PostPosted: Mon Apr 21, 2003 9:38 pm   
 
ahh thank you indeed.. I never knew you could search back for past scripts.. I of course checked their first to no avail. Once again you save my game playing experience.
Reply with quote
Display posts from previous:   
Post new topic   Reply to topic     Home » Forums » zMUD 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