Zugg Software :: View topic

Newbie Joined: 07 Feb 2002 Posts: 6 Location: USA

i work with databases, and of course the ones in zmud have a unique key index, when in a view you see it .. example is 20eq this is the 20th item added to the eq db

now my dilema is i herb on my mud herbs looks alike, examples :
red berry (hawthorn)
red berry (cherry)
red berry (suranie)
red berry (holly)

now until the herb is identified, it's a red berry nothing else, i have these 4 records in the database with no name the specific instance of each one found in different rooms is flagged as a room content now when i go back to the place i can ID the herb, herb 1 was a holly, so i manually go into the db to 1hb and set it to holly

what i'm asking is how to return the actual unique record ID in the db .. like here's what happens when i find an herb :

You found a red berry!

i'm doing the trigger in multiline cause of the mess it's made of

trigger pattern is : "You found {a|an} (*)!"

commands :
#QUERY (&Apperance="%1") Herbs 1
ex %1
open @eq_var_herb_container
put %1 in @eq_var_herb_container
close @eq_var_herb_container
#WAIT 10000 ( this is to give me time to select the correct line in the DB to flag and for the mud response of the berry examination)

what i want here is to be able to select the correct record from the DB by clicking it, then it prompt me for the herb name, i cant trigger it off examination of the herb cause there's like 400 herbs in this mud, and the descriptions have very unsimilar formatting

this is where i need the actual record ID to be able to do a :

#DBPUT ???? Name=%prompt(%rec.name,"Herb name?") Herbs

the ???? is pulling the correct line currently selected from the DB as in 20hb

Thanks, i've looked all over the help files cant find other than %query(appearance="red berry",herbs) to be able to return that but it will only return the first one and not all red berry's are the first one

.*^*. If at first you dont succeed, your sky diving days are over .*^*.