Zugg Software :: View topic - Find room trigger working till now :|

Novice Joined: 01 Jun 2005 Posts: 47

Hey!

I have been using this trigger to find my rooms with perfect results untill now, but the mud implemented some rooms with the high coma, so it does not work with them! im sure there must be an easy and fast correction to do...
Thankyou!!

Here is the trigger:

#CALL %mapfilter(%concat("(Name LIKE '",The wolf hiding place,"') AND (ZoneID = ",%zonenum( @zona ),")")))
#LOOP 1,%numrooms( ) {#ADDITEM salastestborrar {%mapvnum( %i)}}
#CALL %mapfilter("")

With that worked perfectly, but:

#CALL %mapfilter(%concat("(Name LIKE '",Somewhere'buggy,"') AND (ZoneID = ",%zonenum( @zona ),")")))
#LOOP 1,%numrooms( ) {#ADDITEM salastestborrar {%mapvnum( %i)}}
#CALL %mapfilter("")

With that qwerry for "Somewhere'buggy" it will return all the rooms on the list :(

Wizard Joined: 25 Mar 2003 Posts: 1113 Location: USA

Try replacing your ' with '' instead (two single quotes, not a double quote). I suspect the single quote is confusing the function's underlying search query statement.

Novice Joined: 01 Jun 2005 Posts: 47

Mhm didnt work Sad

I simplified the problem, just being this one now:

#CALL %mapfilter(Name LIKE 'Al oeste de Miden'nir') AND (ZoneID = 62))))

There is the problem of the script.

I tryed several things, such as putting the room between {} , changing the initial and ending ' with '' as u suggested, but nothing...

Any ideas? (and thanks 4 the attention so far! :D)

Wizard Joined: 11 Jul 2002 Posts: 1265 Location: USA

You need to remove the ' completely What I do is %subchar("Al oeste de Miden'nir","'","%")

I THINK Vijilante found a way around this in his toolbox but if I remember correctly he hooked directly into the database...

Wizard Joined: 25 Mar 2003 Posts: 1113 Location: USA

Actually, I wasn't suggesting you change the initial or ending quote. I was suggesting you change the one in the middle. Most SQL systems (which this is) will work when your query uses two single quotes to represent one single quote in your search string.

Besides that, you've got your parentheses out of whack in your most recent example and you're using LIKE with no wildcard, which is no different from just using = instead (although perhaps less efficient).

Novice Joined: 01 Jun 2005 Posts: 47

Phew, after some work i could addapt that, thankyou, worked perfectly!!

(the double single comma did the job)

Hope there r no future conflicts with possible doubled comma roomz... ^_^

Thanks again!

Wizard Joined: 11 Jul 2002 Posts: 1265 Location: USA

Sweet! Now I'm going to change my stuff too.

Thanks Larkin.
That was suggested somewhere else too but we didn't understand what was meant. Or at least I didn't.