- A - B - C - D - E - F - G - H - I - J - K - L - M - N - O - P - Q - R - S - T - U - V - W - X - Y - Z -
Other
| .:. SHOW |
SHOW (Prototype Search with WHERE) Syntax: show rooms <zone> show mobs <zone> show objs <zone> show shops [<shopvnum>|.] (existing behavior) New (SQL-ish filters): show rooms where <expr> show mobs where <expr> show objs where <expr> show shops where <expr> show rooms <zone> where <expr> show mobs <zone> where <expr> show objs <zone> where <expr> Price breakdown: show price <objvnum> [shopvnum] Notes: - These commands list *prototypes* (vnums). They do not require the object/mob/room to be present. - Zone form is still supported exactly as before; WHERE is optional after a zone. - Disambiguation: * If the token after the entity is "where", it is treated as WHERE (no zone prefilter). * If the token after the entity is a number, it is treated as a zone, and an optional "where" may follow. - If you do not specify a zone, you must provide a WHERE clause (to avoid dumping the entire world table). Expression language: - Keywords (case-insensitive): where, and, or, between, in, like, is, null, not - Operators: field = value field != value field < value field <= value field > value field >= value field between a and b field in (a, b, c) field like "pattern" field is null field is not null - Parentheses are supported for grouping: (a or b) and c Strings: - Use single or double quotes: name like "%tar valon%" name = 'a long torch' Function: has(field, value) - Used for bitset-like fields (ex: wear flags, extra flags). - Example: show objs where has(wear, take) and has(flag, glow) |
| :: Beginning |