User:Teamtoto

From Caves of Qud Wiki
Revision as of 03:05, 30 July 2021 by Teamtoto (talk | contribs)
Jump to navigation Jump to search

Good morning! It is a lovely Waning Salt Sun on the 19th of Tuum Ut (Apr 18, 13:18:01 pm UTC).

Code Name Hex
r dark red / crimson #a64a2e
R red / scarlet #d74200
o dark orange #f15f22
O orange #e99f10
w brown #98875f
W gold / yellow #cfc041
g dark green #009403
G green #00c420
b dark blue #0048bd
B blue / azure #0096ff
c dark cyan / teal #40a4b9
C cyan #77bfcf
m dark magenta / purple #b154cf
M magenta #da5bd6
k #0f3b3a
K dark grey / black #155352
y grey #b1c9c3
Y white #ffffff
/Sandbox /Sandbox2
Template:Sandbox/User:Teamtoto/newitem2 Module:Sandbox/User:Teamtoto/LuaModule
Module:GetCreatureStats Form:Simulator_Sandbox
Template:VSSim /Bug Hall of Fame
Template:Simulator Sandbox /Sandbox3

Maintenence shortcuts

Special:WantedPages Special:WantedCategories

TODO:

  • optimize all queries that use favilink
  • decrease query count by removing ID to name / ID to page as much as possible
  • qbe grammar stuff

Faction template

  • add attribute for holy place?
  • fix parent faction so if a faction reputation for it already exists, toss it

QBE TODO

  • what does DynamicObjectsTable:Saltdunes_Creatures:Weight Value=3 do?
  • also DynamicObjectsTable:Snapjaws:Builder

Notes

MAKE SURE THE FIELD THAT YOU'RE GROUPING BY IN A ONE TO MANY QUERY IS ACTUALLY IN THE ONE TO MANY FIELD FIRST

custom dataspaces

Modding is 10000 (modding talk is 10001) Data is 10002 (data talk is 10003)

from [1]

HOLDS doesn't work as expected

Cargo bug. Instead of using HOLDS try, *__full instead. The lists then becomes a ordinary string and can be queried as such.

Example:

  • Replace skill_gems.gem_tags HOLDS "Aura" with skill_gems.gem_tags__full LIKE "%Aura%"
  • Use regexp for more advanced queries: events.id__FULL REGEXP "(, |^)SSF Abyss(, |$)".
    • The delimiter in this case is ,
    • Replace | with {{!}} in normal wikitext.

Case sensitivity

Cargo is case insensitive. Use BINARY instead. Read more here.