Zugg Software :: View topic

Sorcerer Joined: 10 Oct 2000 Posts: 706 Location: USA

Is there a way to match to a database key? I don't see a way to do it. I know you can match the database value, but I want to match the key.
Database Variable named: Words

Apprentice Joined: 12 Apr 2004 Posts: 134 Location: USA

This command works for me.

#show %match(@drMobs,"A giant centipede is here.")

@drMods is the name of the data record variable that holds the desired information
"A giant centipede is here." is the first member of that list.

The above command returns 1, indicating it is the first member

The second member of that list is "A large crystal eagle swoops by."

so the command

#show %match(@drMobs,"A large crystal eagle swoops by.")

returns 2.

Is that what you were looking for?

Sorcerer Joined: 10 Oct 2000 Posts: 706 Location: USA

Apprentice Joined: 12 Apr 2004 Posts: 134 Location: USA

Weird, considering the type is Database record. Oh well sorry.

Sorcerer Joined: 10 Oct 2000 Posts: 706 Location: USA

I think I need to look at what I am doing a little differently. I am still working on a package the changes the speech of the character. I got a few done and now I am working on converting a sentence to Old English. But I think I need to look at it differently then the other ones I've changed and fixed.
Again here is an example sentence that will get converted:

Apprentice Joined: 22 Mar 2009 Posts: 149

To get this to work the way you'd like it to, I believe you'd need to loop through the record @word and construct a local variable with all of the keys combined in to a list. An easier method might be having two lists with items that match up, according to their positions in their respective lists.

ie.

Sorcerer Joined: 10 Oct 2000 Posts: 706 Location: USA

That totally doesn't make sense. First I don't have a global variable called word. Second you have the word "you" hardcoded in your if statement which I am NOT going to do. Third why would I have two separate variables
when I have a database variable which does that. The key is New English and the value is Old English.

Apprentice Joined: 22 Mar 2009 Posts: 149

Calm thyself, grasshopper. I hoped you could take that snippet of code and adapt it appropriately to work within your alias. The instance of "you" was taken from your first post.

Since thinking about it a little more, I've realized there's a much simpler way to go about it.

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

Actually, there's an even simpler way to do it: %dbkeys(). This function returns a stringlist of all the keys in a datarecord. If it's a trigger pattern, you can also just use the stringlist pattern (I seem to recall it being the same thing, but I typically don't use it for anything but actual stringlists).)

Sorcerer Joined: 10 Oct 2000 Posts: 706 Location: USA

Matt. I tried the %dbkeys(), but that doesn't work. I might not be using it correctly though.

Posted: Sun Oct 24, 2010 5:20 am

Here's a rough copy of a script I just wrote for this situation:

Apprentice Joined: 05 Apr 2008 Posts: 121

Not sure this would be the way to go about it but what about
#loopdb?

ie
#loopdb @words {
#if (%1 = %key) {etc}}

Sorcerer Joined: 10 Oct 2000 Posts: 706 Location: USA

Sorcerer Joined: 10 Oct 2000 Posts: 706 Location: USA

Continuing onto this.... I did the change like Charneus suggested to get the Old English converstion to work and I noticed now when I do a stutter from the function sometimes the NewSentence doesn't display.
I can't figure this one out. I've put #print all over it to look at it and turned on the debug and the debug doesn't show up anything.
Here is the function:

Wizard Joined: 22 Mar 2007 Posts: 2320

Sorry I'm late, but did you actually try Complex's idea? %match works just like a trigger pattern.
Using a database variable in a trigger pattern matches against the _keys_ of the variable, as if it were a stringlist.
So, Complex's method should work, and is much simpler than any of the other ideas.

Sorcerer Joined: 10 Oct 2000 Posts: 706 Location: USA

Wizard Joined: 22 Mar 2007 Posts: 2320

Does the problem happen only with stuttering (@speech=2), or only with Old English (@speech=3), or both?
The %match() statements for 2 and 3 are not equivalent. 2 has an asterisk in it to catch any punctuation or other stuff at the end of the word.
Actually, I would change that asterisk to %q, which specifically matches any punctuation or the end of the line.

Sorcerer Joined: 10 Oct 2000 Posts: 706 Location: USA

Hurray!!! I fixed my script!! I think I will be posting the updated script to the package library in a few days! Now I need to do a hissing for serpent characters.

If anyone has any suggestions on more speech types just PM me!