8,756
edits
Teamtoto
Joined 25 July 2021
m
→TODO:
m (→QBE TODO) |
m (→TODO:) |
||
| (33 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{qud time}} | |||
<div style="float:right;"> | <div style="float:right;"> | ||
{{Color Table}} | {{Color Table}} | ||
| Line 4: | Line 5: | ||
{| style="padding:1em;" | {| style="padding:1em;" | ||
|[[/Sandbox]] | |[[/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== | ==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 | |||
==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. | |||