Zugg Software :: View topic

Novice Joined: 31 May 2007 Posts: 32

I have a few issues that I would appreciate some pointers on.

1) #find seems to not be finding things in SOME of my views. But it works with other views in a particular database. For example:
I have a Mob database that has mob stats. #Query works on every view and for every column in all the views, but #find only
works here and there. Sometimes it returns all kinds of records, sometimes it can't find anything. The view in particular that
I'm trying to get working is the Area view. In that view I only have Area Name & Mob Name. Here's an example of a record:

122 Smurf's Mystical Forest Smurfette

Now, if I #reset the view and do a #find smurf, it doesn't find anything

If I #reset again and type #find h

I get a large list (but not everything in the view. As you can see, there is NO 'h' in the record (at least in that view)

I have some very interesting results with other things kind of similar to this.

These database records are loaded from scripts, not entered individually.

2) Every once in a while, the first record of whichever database I'm in has some of it's fields overwritten
with another field of that record. Even though I have no scripts that write to those records or what not.
Basically, at this point all my scripts add an entire record or don't do anything. I have nothing that
updates a record already there. Yet it is happening.

Example

Name Keywords Type Position
Achilles' Torc Achilles' Torc Achilles' Torc Achilles' Torc

Where it should be:

Name Keywords Type Position
Achilles' Torc achilles torc Worn Neck

Why is this happening?

Novice Joined: 31 May 2007 Posts: 32

As for the first question:

I discovered something.

The field name and the "column" are somehow getting mixed up. In order to find
"dark" in the area_name field I need to search the number_attacks column.

Basically, if I tell CMUD to search column area_name in any of the views, it isn't
searching what I have defined as area_name, it is searching another column in the view.

So, now the question is, how did this happen and how to I fix it?