User:Teamtoto
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 | █ |
Maintenence shortcuts
Special:WantedPages | Special:WantedCategories |
Hidden categories (empty)
Images needing improvement (empty)
Pages to be merged (empty)
Pages to be moved (empty)
Pages with ID to Name errors (empty)
Pages with inventory errors (empty)
Pages with template errors (empty)
Templates with bad documentation (empty)
Templates with no documentation (empty)
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"
withskill_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.
- The delimiter in this case is
Case sensitivity
Cargo is case insensitive. Use BINARY instead. Read more here.