Righto, so I've got the database plugin that Nick made all hacked up and mutilated to suit my perverted whims. It handles sql entry and queries just great, but now I'm stumped about how I want to go about entering all the data that comes from the endless and often random information one might try to collect about a mud. What follows are three examples of stats you might see from an identify:
Object 'leather armor' is type armor, material leather.
Extra flags: none.
Weight is 5, value is 220, level is 22.
Armor class is 7 pierce, 7 bash, 7 slash, and 0 vs. magic.
Object 'two-handed two sword' is type weapon, material steel.
Extra flags: magic antievil.
Weight is 24, value is 3300, level is 26.
Weapon type is two-handed sword.
Damage is 2d12 (average 13).
Affects damroll by 3.
Affects hitroll by 2.
Object 'stolen ring' is type jewelry, material gold.
Extra flags: glow.
Weight is 2, value is 5000, level is 30.
Affects con by 1.
Affects damroll by 1.
Affects hitroll by 1.
From these sorts of lists I've setup a few trigers that capture stats and add them into the database. After a few hours and about 20 triggers I'm starting to get a little nervious about the size of the project I've taken on. Is there something I can do besides setting up dozens of fire-once triggers? Triggers that get activated by the 'type' and etc? Even then I'm running into problems where items like the 'stolen ring' are actually named 'Nice looking ring.'
Object 'leather armor' is type armor, material leather.
Extra flags: none.
Weight is 5, value is 220, level is 22.
Armor class is 7 pierce, 7 bash, 7 slash, and 0 vs. magic.
Object 'two-handed two sword' is type weapon, material steel.
Extra flags: magic antievil.
Weight is 24, value is 3300, level is 26.
Weapon type is two-handed sword.
Damage is 2d12 (average 13).
Affects damroll by 3.
Affects hitroll by 2.
Object 'stolen ring' is type jewelry, material gold.
Extra flags: glow.
Weight is 2, value is 5000, level is 30.
Affects con by 1.
Affects damroll by 1.
Affects hitroll by 1.
From these sorts of lists I've setup a few trigers that capture stats and add them into the database. After a few hours and about 20 triggers I'm starting to get a little nervious about the size of the project I've taken on. Is there something I can do besides setting up dozens of fire-once triggers? Triggers that get activated by the 'type' and etc? Even then I'm running into problems where items like the 'stolen ring' are actually named 'Nice looking ring.'