Zugg Software :: View topic - LOOPDB, FORALL

Newbie Joined: 02 Jan 2007 Posts: 8

I've searched around here and unfortunately am not finding what I think I'm looking for.

Basically what I've done is taken an idea along the lines of something "Private" posted here, where he wants to someday write a script that can automatically update/correct DB entries for mob names, area names, and room names. I'm starting completely from scratch and my coding experience is very primitive in comparison to others I read here, so bare with me.

So far I've written a very effective script that takes the output of "mobdeaths 1 1 evil", and dumps the proper data I'm looking for into a nice and neat DB, all sorted properly, etc.

Which leads me to my current problem. Some of the mob names and area names are cut short at the end by the MUD's output. So, I want to create an alias that sorts through my entire DB and corrects things like the shortened area names by changing the value to the correct, full name of the area.

Here is my code thus far:

#FORALL @AreaNames {#IF (%db(test,Area)=%i) {#ADDKEY %rec Area "Blah Blah Blah"} {}}

Where @AreaNames is a standard variable list in my script that contains all the incorrect area names. "Blah Blah Blah" is what I want it to change the DB key value to if it encounters @AreaNames in the DB.

The above code works "somewhat", in that it changes the current DB record to "Blah Blah Blah", regardless of if it matches @AreaNames or not. *sigh* I don't want it to do that.

My second problem with it, once I get the first corrected, is how to use LOOPDB to go through my entire database, record by record, and change each key value that matches @AreaNames to "Blah Blah Blah".

Any help is appreciated, thanks.

Newbie Joined: 02 Jan 2007 Posts: 8

Ok well, I've discovered another way of doing this...to basically have it make the corrections on it's own while it's adding entries into the database. Any advice on making my syntax a bit more efficient? I'm not happy with how it looks, even though it is working properly the way I want it to.

Newbie Joined: 02 Jan 2007 Posts: 8

OK this is where I'm at so far (still looking for a little guidance here, folks).

I issue the command "mobdeaths 1 1 evil" to display all the mobs of level 1, evil alignment, their area name, and how many times they've been killed.

The output from the MUD looks like this:

Magician Joined: 17 Apr 2005 Posts: 496

One possible problem I see is that keys in db variables don't work well with spaces. This is not a problem if your area names never have spaces, but I'm guessing that they do.. also it doesn't seem to be a problem with the way you're doing it, but using, for example, @{AreaNames.@AreaName1} which wouldn't require looping, -would- have problems with spaces.

Edit: How about a combination of %match() and %right() on your variable storing the name of the mob?

Newbie Joined: 02 Jan 2007 Posts: 8

Magician Joined: 17 Apr 2005 Posts: 496

Yeah, I did something like that for an item parser once, however I was using the @{var.key} way of accessing it which was breaking with spaces. The looping looks like a nice work-around, if I ever try writing that script again I'll probably try it that way. Did you try %match yet to get the last word for your mobs?

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

Multi-word datarecord keys work perfectly fine in ZMud. Just not with the @var.key syntax, you have to use %db() any time you want to access that key.

Magician Joined: 23 Nov 2004 Posts: 364

use %lower(%item(list var,%numwords(listvar))) to get the last word of the mob you want, so a fire newt would go to newt, ect.