Zugg Software :: View topic - Request : Database Trigger for Characters

Wanderer Joined: 12 Jul 2002 Posts: 73

Hi All,

I have a beginner question.

I looked at some other topics, but they where a litlle beyond my skills so I got lost in trying.

What I would like to do is the following.
I have created a small database of characters and I would like to have some trigger of some kind fill in automatically a new record with the full description in a field.

I will then later manually fill in all the other records (unless I get the hang of it and can add it with triggers ;-)) )

What I have so far.

- a db called characters.db with following fields.

Name - Text
Gender - Single Option
Guild Racial - Single Option
Guild Occupational - Single Option
Guild Layman - Single Option
Description - Short - Text
Description - Full - Memo
Mortal Level - Single Option

So a single record would look like

Name - Pippoz
Gender - Female
Guild Racial - Human
Guild Occupational -
Guild Layman -
Description - Short - ageless friendly female human
Description - Full - Pippoz is an ageless friendly female human, presenting herself as:
Pippoz the Advanced Fistfighter Cadet of Gelan, wanderer, female human.
She has a scar on her forehead.
She has a pierced navel with no ring in it.
She is tall and lean for a human.
She looks ugly.
She seems to be feeling very well.
She is smiling happily.
Her hair is medium length, blue and styled with pigtails.
She has intense deep green eyes.

Mortal Level - Wanderer

When playing I have two options I want to capture

exa goblin - for a goblin who's name i don't know

He is a sulking sad-faced male goblin.
He has scars on his left leg, nose, left arm, right arm, right hand, forehead,
left cheek and right cheek.
He is wielding a black-steel cutlass in his right hand.
He is wearing a crystalline medallion.
He has dark blue eyes.
His hair is shoulder length, platinum blond and swept back.
He is smelling.
He is very tall and of normal width for a goblin.
He looks like the image of perfection.
He seems to be feeling very well.
His right hand is decorated with a tattoo of a green eyed mermaid.
He is gallantly carrying a money-sack over the shoulder, which indicates that
He is an Obscenely Wealthy Member of the Rich Men's Club.

or

exa pipoz

Pippoz is an ageless friendly female human, presenting herself as:
Pippoz the Advanced Fistfighter Cadet of Gelan, wanderer, female human.
She has a scar on her forehead.
She has a pierced navel with no ring in it.
She is tall and lean for a human.
She looks ugly.
She seems to be feeling very well.
She is smiling happily.
Her hair is medium length, blue and styled with pigtails.
She has intense deep green eyes.

So what i would like to do is the following

Set up an alias so I do not store everything in the DB since I will exa people much more as I want to store them in the DB
Get the full description / output stored in field Description - Full

That's basicly it.

But what would be nice if there is a way to do the following.

He is a sulking sad-faced male goblin.
>> put sulking sad-faced male goblin in Name and Description Short

Pippoz is an ageless friendly female human, presenting herself as:
>> put Pipoz in Name and ageless friendly female human in Description - Short

But that is not so important, I would be very gratefull if any of you Gurus could already point me out on the first thing.

Thanks in Advance !!!

Knuff

MASTER Joined: 28 Nov 2000 Posts: 4817 Location: USA

Since it's quite likely that there will be more than one "sulking sad-faced male goblin", I'd recommend against adding characters to the database UNTIL you know their names.

#TR {(%w) is {a|an} (*), presenting herself as:} {#ADDKEY record Name {%1};#ADDKEY record {Description - Short} {%2};#VAR temp %null;#T+ charDB}
#CLASS charDB {disable}
#TR {$} {#T- charDB;#VAR record {Description - Long} {@temp};#NEW All {@record}}
#TR {*} {#VAR temp {{@temp1}{%cr}{%trigger}}
#CLASS 0

I have no idea at all whether you can use carriage-returns (%cr) inside variables. If it doesn't work, just drop the long description.

LightBulb
Senior Member