8,756
edits
User:Teamtoto: Difference between revisions
Jump to navigation
Jump to search
m
→TODO:
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. | |||