Zugg Software :: View topic

Beginner Joined: 18 Sep 2002 Posts: 15

Ok so I was toying around with the example scripts everyone has posted and they all work really well, I have it set up with triggers that capture name, type, damage, saves, blah blah blah. The problem is, my database just has too many darn fields...what I'd like to have is 3 fields 1)Name 2)ID 3)Zone. Is it possible to capture the whole block of text from the ID and store that into a memo field?

Here is a sample ID:
Object 'shield crested' is type armor, material steel.
Extra flags: none.
Weight is 20, value is 10, level is 25.
Armor class is 8 pierce, 8 bash, 8 slash, and 3 vs. magic.
Affects savingmaled by -1.
Affects savingaffl by -4.
Affects con by 1.
Rare item.

And This is How I want the Database:
Name: shield crested
ID: Object 'shield crested' is type armor, material steel.
Extra flags: none.
Weight is 20, value is 10, level is 25.
Armor class is 8 pierce, 8 bash, 8 slash, and 3 vs. magic.
Affects savingmaled by -1.
Affects savingaffl by -4.
Affects con by 1.
Rare item.
Zone: Dragon Tower

The name is captured from the ID, and the zone would be inputed manually. Is there a way to keep the variable storing data, which would be turned off by #trigger ^$, at the end of the ID?

Any help is appreciated

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

#TR {Object '(*)' is type} {#VAR dbase2 {};#T+ Database;#ADDK dbase1 Name {%1}}
#CLASS {Database} {disable}
#TR {Zone: (*)} {#ADDK dbase1 Zone {%1}}
#TR {(*)} {#IF %len( @dbase2) {#VAR dbase2 {@dbase2%{crlf}%1}} {#VAR dbase2 {%1}}}
#TR {^$} {#T- Database;#ADDK dbase1 ID {@dbase2};#IF %query( &Name = @dbase1.Name) {} {#NEW All @dbase2}}
#CLASS 0

Don't forget that the database must be open already.

Beginner Joined: 18 Sep 2002 Posts: 15

That is exactly what I needed, works great!
As always LightBulb, YOU DA MAN!!