User:Teamtoto: Difference between revisions
mNo edit summary |
m (→TODO:) |
||
(13 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
{{qud time}} | {{qud time}} | ||
<div style="float:right;"> | <div style="float:right;"> | ||
Line 8: | Line 5: | ||
{| style="padding:1em;" | {| style="padding:1em;" | ||
|[[/Sandbox]] | |[[/Sandbox]] | ||
|[[ | ||[[Special:CargoTables]] | ||
|- | |- | ||
|[[Module:Sandbox/User:Teamtoto/LuaModule|lua sandlot]] | |||
|[[Module:Sandbox/User:Teamtoto/LuaModule]] | |||
|- | |- | ||
|[[ | |[[/Bug Hall of Fame]] | ||
|[[ | |[[Caves_of_Qud/Scrapped_UI]] | ||
|- | |- | ||
|[[ | | [[/Sandbox2]] | ||
| [[/ | |[[/Sandbox3]] | ||
|- | |- | ||
| [[ | |[[MediaWiki:Common.css]] | ||
|} | |} | ||
==Maintenence shortcuts== | ==Maintenence shortcuts== | ||
{| style="padding:1em;text-align:center;" | {| style="padding:1em;text-align:center;" | ||
|[[Special:WantedPages]] | |[[Special:WantedPages]] - {{Special:WantedCategories}} - [[Special:RandomInCategory/Pages_with_no_description|Random page w no desc]] | ||
|} | |} | ||
<categorytree mode="all" showcount="on">Wiki maintenance</categorytree> | <categorytree mode="all" showcount="on">Wiki maintenance</categorytree> | ||
==TODO:== | ==TODO:== | ||
* | DUPE IDS | ||
{{#Cargo_query:table=GeneralData | |||
|fields= ObjectID, COUNT(*)=num | |||
|where=ObjectID <> '' and (_pageNamespace = '0' OR _pageNamespace='10002') | |||
|having=num>1 | |||
|group by=ObjectID}} | |||
{{#cargo_query:tables=GeneralData | |||
|fields=_pageName | |||
|where=ObjectID='Barathrumite Tinker'}} | |||
* qbe grammar stuff | * qbe grammar stuff | ||
Line 38: | Line 39: | ||
*add attribute for holy place? | *add attribute for holy place? | ||
* fix parent faction so if a faction reputation for it already exists, toss it | * fix parent faction so if a faction reputation for it already exists, toss it | ||
==Notes== | ==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=== | ===custom dataspaces=== | ||
Modding is 10000 (modding talk is 10001) | Modding is 10000 (modding talk is 10001) | ||
Line 67: | Line 58: | ||
====Case sensitivity==== | ====Case sensitivity==== | ||
Cargo is case insensitive. Use BINARY instead. Read more [https://www.mediawiki.org/wiki/Extension:Cargo/Common_problems here]. | Cargo is case insensitive. Use BINARY instead. Read more [https://www.mediawiki.org/wiki/Extension:Cargo/Common_problems 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: | |||
<pre>php setCargoPageData.php --replacement</pre> | |||
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: | |||
<pre>php setCargoPageData.php --delete</pre> | |||
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. |
Latest revision as of 02:02, 4 February 2024
Good evening! It is a lovely Waxing Beetle Moon on the 17th of Uulu Ut (Jun 15, 21:25:23 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 |
lua sandlot | |
/Bug Hall of Fame | Caves_of_Qud/Scrapped_UI |
/Sandbox2 | /Sandbox3 |
MediaWiki:Common.css |
Maintenence shortcuts
Special:WantedPages - Special:WantedCategories - Random page w no desc |
TODO:
DUPE IDS No results
- qbe grammar stuff
Faction template
- add attribute for holy place?
- fix parent faction so if a faction reputation for it already exists, toss it
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.
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.