Zugg Software :: View topic - Searching/Using Spreadsheet View -- Coloring Many Rooms

Beginner Joined: 20 Jun 2006 Posts: 24

So, the MUD I play lists its room names like so:

A Field Before the Mountains [Field]

I would like to parse the existing database, and color rooms based on the [Terrain] value after each room name.

I don't want to do this by hand because it's a pain in the ass.

I don't want to do it using the "Nearby" feature because my map is huge and the terrain types are distributed evenly across the world.

What I want to be able to do:

Search the entire database for rooms containing a particular terrain field, like 'Swampland' and select all of those rooms at once so I can choose their color.

Is there any way to to this simply?

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

Without going to all the trouble myself of writing a script to do this for you, my advice is to use the results from a %mapquery and pass the room number and desired color to %roomcol, using #noop to "eat" the return value of the %roomcol function.

Beginner Joined: 20 Jun 2006 Posts: 24

Beginner Joined: 20 Jun 2006 Posts: 24

Okay, just one question.

#mapquery ( "[Name] LIKE '%Field%'" )

Gives me too many results, including areas that are actually [Mountain] but with names like "Mountains Near a Field" or whatever.

#mapquery ( "[Name] LIKE '%[Field]%'" ) doesn't work because [] are special characters. How can I specify them so they're recognized as the characters and not part of the query? \ was my best guess but that didn't work.

Enchanter Joined: 10 Oct 2000 Posts: 698

Use the quote character. By default it is a tilde(~).

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

Use %mapquery instead of #mapquery, too. You can then store the results of %mapquery and loop through all the rooms to change their colors. And, sorry, but I will not write the whole script for you. :P

Magician Joined: 29 Nov 2005 Posts: 482

%mapquery ( "[Name] LIKE '%~[Field~]%'" )

??