User:Teamtoto: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
m (→TODO:) |
||
| (37 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
[[/Sandbox]] [[/Sandbox2]] | {{qud time}} | ||
<div style="float:right;"> | |||
{{Color Table}} | |||
</div> | |||
{| style="padding:1em;" | |||
|[[/Sandbox]] | |||
||[[Special:CargoTables]] | |||
|- | |||
|[[Module:Sandbox/User:Teamtoto/LuaModule|lua sandlot]] | |||
|- | |||
|[[/Bug Hall of Fame]] | |||
|[[Caves_of_Qud/Scrapped_UI]] | |||
|- | |||
| [[/Sandbox2]] | |||
|[[/Sandbox3]] | |||
|- | |||
|[[MediaWiki:Common.css]] | |||
|} | |||
==Maintenence shortcuts== | |||
{| style="padding:1em;text-align:center;" | |||
|[[Special:WantedPages]] - {{Special:WantedCategories}} - [[Special:RandomInCategory/Pages_with_no_description|Random page w no desc]] | |||
|} | |||
<categorytree mode="all" showcount="on">Wiki maintenance</categorytree> | |||
==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 | |||
== | ==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 [https://pathofexile.gamepedia.com/index.php?title=Path_of_Exile_Wiki:Known_issues] | |||
====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 <code>skill_gems.gem_tags HOLDS "Aura"</code> with <code>skill_gems.gem_tags__full LIKE "%Aura%"</code> | |||
* Use [https://dev.mysql.com/doc/refman/5.5/en/regexp.html regexp] for more advanced queries: <code>events.id__FULL REGEXP "(, {{!}}^)SSF Abyss(, {{!}}$)"</code>. | |||
** The delimiter in this case is <code>, </code> | |||
** Replace <code>|</code> with <code><nowiki>{{!}}</nowiki></code> in normal wikitext. | |||
====Case sensitivity==== | |||
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 4th of Ubu Ut (May 3, 23:26:07 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 |
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:
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.