Zugg Software :: View topic - Returning a specific field in a database entry

Wanderer Joined: 20 Oct 2006 Posts: 51

I am looking for a way to return only a specific field for a database entry. I have a database of all of the mobs for my MUD, and I want to be able to search for a mob name and have it return only a specific requested cell, like this:

Database entry:
799 Security guard of Blain 220211 Hor Yes No

First number is the record, second is the XP value of the mob, the Hor, Yes and No aren't relevant. What I would like to do is something like this:

#FIND {security guard} XP

return:

220211

Is this achievable with CMUD's database?

Thank you for your time.

Posted: Wed Jan 05, 2011 10:49 am

assuming the full name is used as the key....

$key=Security guard of Blain
$keyXP=@{databaseName.$key.xp}
#SAY $keyXP

Wanderer Joined: 20 Oct 2006 Posts: 51

Thank you very much for your reply. I gave it a shot as it was, and didn't find success yet. I'm probably doing something wrong. Here's what I did:

Made an alias (mobsearch), defined as:

$key=%1
$keyXP=@{MobList.$key.xp}
#SAY $keyXP

then "mobsearch Security guard of Blain"

just returns ".Security guard of Blain.xp"

Tried multiple variations, with brackets and without. I am unfamiliar with the $ operator in CMUD, maybe its purpose eluding me is causing my lack of understanding.

Posted: Sat Jan 08, 2011 3:12 pm

the $ is the local variable operator
the problem in this scenario i think is because you are using an actual database instead of a DBvar, and I am not so good with those.

GURU Joined: 23 Dec 2000 Posts: 4834 Location: USA

Posted: Sat Jan 08, 2011 9:24 pm

This really isn't all that hard to do. If each mob in your db has a unique name, and you will be searching with a string that will limit the result to only one record. Below is a picture of a sample db I created and an alias that when used with the unique name will return the exp value only. Given the format you listed in the first post it looks as if you have the name as the first field so that's how I set the alias up. The alias uses a temp trigger to return the value of the exp field, so if there is a chance that more than one record will be returned you will need to do a bit of modification, but this should be a good starting point.

Alias:

Wanderer Joined: 20 Oct 2006 Posts: 51

This actually worked perfectly! Thank you very much for your time!

My end goal in using the database is to be able to keep a record of the number of times I have killed each mob, and the average exp they've given for those kills, since the mobs in my MUD give a different amount of exp each kill. Occasionally, the mobs can be 'turbo', which makes them worth a much larger amount and much harder to kill - I want CMUD to be able to recognize a turbo version of a mob and flag it as such. Is there any reason this won't be doable with the CMUD DB?