User:Teamtoto: Difference between revisions

From Caves of Qud Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 5: Line 5:
{| style="padding:1em;"
{| style="padding:1em;"
|[[/Sandbox]]
|[[/Sandbox]]
|[[/Sandbox2]]
||[[Special:CargoTables]]
|-
|-
|[[Template:Sandbox/User:Teamtoto/newitem2]]
|[[Template:Sandbox/User:Teamtoto/newitem2]]

Revision as of 17:57, 17 January 2023

Good evening! It is a lovely Jeweled Dusk on the 4th of Ubu Ut (May 3, 20:25:17 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 Special:CargoTables
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.

Replacing _pageData

https://www.mediawiki.org/wiki/Special:MyLanguage/Extension:Cargo/Storing_data#Storing_page_data To recreate with replacement, add a --replacement flag:

php setCargoPageData.php --replacement

The replacement table can then be switched in normally using the Special:CargoTables interface.

If you want to get rid of this table, call the following instead:

php setCargoPageData.php --delete

You do not need to call the "--delete" option if you are planning to recreate the table; simply calling setCargoPageData.php will delete the previous version.