User:Aemony
- Need to contact me? Do so on the PCGamingWiki Discord.
- This is my user page, written and intended for myself – don't mind the random and confusing nonsense that is displayed here.
- Quick links
- User: CSS JavaScript
- Global: CSS Javascript
- Watchlist
- Contributions
- Sandbox
- Subpages
- Maintenance stuff
Admin notes
Matching user ID to username through MediaWiki's API (useful when resolving account conflicts and such):
- By username: https://www.pcgamingwiki.com/wiki/Special:ApiSandbox#action=query&format=json&list=users&ususers=aemony
- By user ID: https://www.pcgamingwiki.com/wiki/Special:ApiSandbox#action=query&format=json&list=users&ususerids=14846
Editing notes
Cargo column/value ambiguity
Cargo seems to prefer replacing parts of the query that matches an existing table column with a reference to said column without validating if it is actually appropriate to do so. This means that string values used as part of the query will fail if the string in question also happens to match the name of a column of the Cargo table.
Broken query:
{{#cargo_query: tables=Infobox_game |fields=_pageName,Genres |where=Genres HOLDS "Sports" |format=table |default= }} For a table diagram of Infobox_game.Genres: List of String Infobox_game.Sports: List of String Expected output: A list of games which has "Sports" listed in their Genres column. Actual output: Error: operator for the virtual field 'Infobox_game.Sports' must be 'HOLDS', 'HOLDS NOT', 'HOLDS LIKE' or 'HOLDS NOT LIKE'.
In the above query, we are trying to retrieve all games of which their Genres column includes the "Sports" string value, however Cargo mistakenly interprets the "Sports" value as a reference to the Infobox_game.Sports column, and throws an error that the query does not match the expected structure.
The only way to work around this issue is by actually splitting up the "Sports" string in the input, so this replacement step that fails does not even detect that a replacement is necessary. This can be done by e.g. using the CONCAT
SQL function (e.g. CONCAT('Spo', 'rts')
to have the underlying SQL engine itself combine the two parts of the word into one. For lists/HOLDS queries, that approach cannot be used but instead HOLDS LIKE can be exploited with SQL's wildcard characters (e.g. HOLDS LIKE "Sp_rts"
or HOLDS LIKE "Spo%rts"
).
_
means a single (1) random character, and is the preferred solution as it would only match 6-letter words that start with "Sp" and ends with "rts".%
means none or more (0+) random characters at the specific position, and is not recommended since it would match all words of any length that starts with "Spo" and ends with "rts".
Cargo + SQL LIKE woes
When given "Id_Software" as the {{#var:pageName}} : Works : {{#arraymap:{{#var:pageName}},{{{formernames|}}}|,|€€€€€|Publishers HOLDS LIKE "Company:€€€€€"|\sOR\s}} Broken: {{#arraymap:{{#var:pageName}},{{{formernames|}}}|,|€€€€€|Developer="Company:€€€€€"|\sOR\s}} For a table diagram of Publishers: List of Page Developer : Page
This means that HOLDS LIKE performs substitution for the underscore _
character. Specifically, it's because the SQL LIKE keyword interprets _
as a wildcard representing a single character. This means that while Id_Software
matches id Software
, it would also match iddSoftware
, IdoSoftware
, and so on.
Numbered lists + Preformatted text
Wiki markup hates preformatted text blocks in numbered lists. Specifically the newlines in the preformatted text blocks interferes with the wiki markup for the numbered lists so that a new list is created underneath the preformatted text block. Use pure HTML instead[1] since it's much easier to work with and gets the job done the right way.
{{PAGENAME}} conundrums
- Related to PAGENAME encoding.
- The below code is based on Death end re;Quest 2.
Death end re;Quest 2 # Death end re;Quest 2 {{PAGENAME}} # Death end re;Quest 2 {{#ifeq: Death end re;Quest 2 | {{PAGENAME}} | true | false }} # false {{urlencode:Death end re;Quest 2|PATH}} # Death%20end%20re%3BQuest%202 {{urlencode:{{PAGENAME}}|PATH}} # Death%20end%20re%26%2359%3BQuest%202 {{#ifeq: {{urlencode:Death end re;Quest 2|PATH}} | {{urlencode:{{PAGENAME}}|PATH}} | true | false }} # false {{urlencode:{{PAGENAME:Death end re;Quest 2}}|PATH}} # Death%20end%20re%26%2359%3BQuest%202 {{#ifeq: {{urlencode:{{PAGENAME:Death end re;Quest 2}}|PATH}} | {{urlencode:{{PAGENAME}}|PATH}} | true | false }} # true
Essentially {{PAGENAME}}
performs some additional character encoding or whatever that otherwise would not be made. So checking a Cargo table for a column with the value of {{PAGENAME}}
will not find a match if the column value was added through basic text input like Death end re;Quest 2
despite both technically being rendered on the page identically as Death end re;Quest 2
. Hence it is important to retrieve the actual {{PAGENAME}}
value for the page by using {{PAGENAME|Death end re;Quest 2}}
before using that value instead in subsequent operations and checks.
Assignments
In progress
Game | Release Date | Applied | Completion Date | Assigned | Notes | ||
---|---|---|---|---|---|---|---|
No results |
Upcoming
Game | Release Date | Applied | Completion Date | Assigned | Notes | ||
---|---|---|---|---|---|---|---|
No results |
Applied
Game | Release Date | Applied | Completion Date | Assigned | Notes | ||
---|---|---|---|---|---|---|---|
No results |
Complete
Game | Release Date | Applied | Completion Date | Assigned | Notes | ||
---|---|---|---|---|---|---|---|
Martha Is Dead | February 24, 2022 | Aemony (t|c|a) | February 25, 2022 | Aemony (t|c|a) | Requested February 15, 2022. (Renaissance, Wired). Received February 15, 2022. Assigned February 24, 2022. | ||
Sifu | February 8, 2022 | Aemony (t|c|a) | February 14, 2022 | Aemony (t|c|a) | Review code requested February 6, 2022 (Tinsley). Received and assigned February 7, 2022. | ||
Star Wars: Squadrons | October 2, 2020 | Aemony (t|c|a) | October 4, 2020 | Aemony (t|c|a) | Review code requested October 1, 2020 (EA, fortyseven), received October 2. | ||
Summer in Mara | June 16, 2020 | Aemony (t|c|a) Expack3 (t|c|a) |
June 21, 2020 | Expack3 (t|c|a) Aemony (t|c|a) |
Two review codes requested (Evolve), received June 3, 2020. | ||
Saints Row: The Third Remastered | May 22, 2020 | Aemony (t|c|a) Timo654 (t|c|a) |
May 22, 2020 | Aemony (t|c|a) | Review code requested May 12, 2020 (Koch Media), received May 14, 2020. | ||
MotoGP 20 | April 23, 2020 | Aemony (t|c|a) | April 23, 2020 | Aemony (t|c|a) | Review code requested April 15, 2020 (Koch Media), received April 16, 2020. | ||
Resident Evil 3 (2020) | April 3, 2020 | Unavailable (t|c|a) Fayaine (t|c|a) |
April 4, 2020 | Fayaine (t|c|a) Aemony (t|c|a) |
Review code requested March 29, 2020 (Capcom Europe, fortyseven). Purchased using Gamesplanet funds April 2. Code received April 6. Completed by Fayaine. | ||
One Step from Eden | March 26, 2020 | Aemony (t|c|a) | Aemony (t|c|a) | Review code requested March 13, 2020 (Humble Bundle). Two review codes received March 16, 2020. | |||
Halo: The Master Chief Collection | December 3, 2019 | Aemony (t|c|a) | Aemony (t|c|a) | Purchased using PCGamingWiki funds on November 15, 2019 (transferred March 11, 2019). | |||
Star Wars Jedi: Fallen Order | November 15, 2019 | Aemony (t|c|a) Unavailable (t|c|a) |
Aemony (t|c|a) | Review code requested November 13, 2019 (FortySeven). Purchased using PCGamingWiki funds on November 15, 2019. | |||
The Outer Worlds | October 25, 2019 | Expack3 (t|c|a) Aemony (t|c|a) |
October 30, 2019 | Expack3 (t|c|a) Aemony (t|c|a) |
Review code requested October 16, 2019 (Renaissance), two codes received October 24, 2019. | ||
Postal 4: No Regerts | October 14, 2019 | Aemony (t|c|a) | November 15, 2019 | Aemony (t|c|a) | Early access. Review code requested October 14, 2019 (Running With Scissors), received October 18, 2019. | ||
The Surge 2 | September 24, 2019 | Aemony (t|c|a) | September 24, 2019 | Aemony (t|c|a) | Review code requested August 19, 2019 (Focus Home, Koch Media), received September 19, 2019, embargo until September 24. | ||
Warhammer 40,000: Inquisitor - Prophecy | July 30, 2019 | Aemony (t|c|a) | September 3, 2019 | Aemony (t|c|a) | Delayed two months to July 30, 2019. Merged with Martyr. Requested August 16, 2019 (Neocore Games), received August 28, 2019. | ||
Sea of Solitude | July 5, 2019 | Aemony (t|c|a) | Aemony (t|c|a) | Review code requested July 5, 2019 via Twitter. | |||
Warhammer 40,000: Inquisitor - Martyr | June 20, 2019 | Aemony (t|c|a) | Aemony (t|c|a) | Review coded received (Neocore Games). Update 2.0 have been delayed to June 20, 2019. | |||
198X | June 20, 2019 | Aemony (t|c|a) | Aemony (t|c|a) | Review code requested June 6, 2019 (Hi-Bit Studios). | |||
Journey | June 6, 2019 | Aemony (t|c|a) Rose (t|c|a) Expack3 (t|c|a) |
June 7, 2019 | Aemony (t|c|a) Rose (t|c|a) |
Review code requested (Annapurna Interactive). Purchased x2 copies on Epic Games Store June 5, 2019. | ||
Super Cane Magic ZERO | May 30, 2019 | Aemony (t|c|a) | Aemony (t|c|a) | Review code received (Dead Good). | |||
Void Bastards | May 29, 2019 | Aemony (t|c|a) | May 30, 2019 | Aemony (t|c|a) | Review code received (Humble). | ||
Vambrace: Cold Soul | May 28, 2019 | Aemony (t|c|a) | Aemony (t|c|a) | Review code received (Headup Games). | |||
SpellForce 3: Soul Harvest | May 28, 2019 | Aemony (t|c|a) | May 28, 2019 | Aemony (t|c|a) | Review code received (Dead Good). | ||
Draugen | May 28, 2019 | June 6, 2019 | Baronsmoki (t|c|a) Rose (t|c|a) Expack3 (t|c|a) Aemony (t|c|a) |
GOG.com Enhancement Project. | |||
A Plague Tale: Innocence | May 14, 2019 | Aemony (t|c|a) Expack3 (t|c|a) |
May 19, 2019 | Aemony (t|c|a) | Review code received (Koch Media). | ||
RAGE 2 | May 14, 2019 | Anthraksi (t|c|a) Aemony (t|c|a) Expack3 (t|c|a) |
May 14, 2019 | Anthraksi (t|c|a) Aemony (t|c|a) Expack3 (t|c|a) |
Purchased using Gamesplanet funds. | ||
Yakuza Kiwami 2 | May 9, 2019 | Aemony (t|c|a) | May 9, 2019 | Aemony (t|c|a) | Purchased using Gamesplanet funds. | ||
Mordhau | April 29, 2019 | Expack3 (t|c|a) | May 6, 2019 | Expack3 (t|c|a) Aemony (t|c|a) |
Purchased from funds, review key received after release from developer. | ||
Imperator: Rome | April 25, 2019 | Aemony (t|c|a) | May 5, 2019 | Aemony (t|c|a) | Review key received (Paradox). | ||
Train Valley 2 | April 15, 2019 | Aemony (t|c|a) | Aemony (t|c|a) | Review key received (Jaleo PR). | |||
Feather | April 5, 2019 | Aemony (t|c|a) | Aemony (t|c|a) | Review key received (Super Indie Games). | |||
Photographs | April 3, 2019 | Aemony (t|c|a) | April 11, 2019 | Aemony (t|c|a) | Review key received (Landfall). | ||
Generation Zero | March 26, 2019 | Aemony (t|c|a) | March 29, 2019 | Aemony (t|c|a) | Review code received (Dead Good). |
Pages
- All random child pages below my user page.
- Design changes
- Monitor
- Sandbox
- Sandbox/API
- Sandbox/AskFiltered
- Sandbox/AskFilteredMap
- Sandbox/Assignment/Total
- Sandbox/Assignments
- Sandbox/Assignments/row
- Sandbox/Availability
- Sandbox/Availability/row
- Sandbox/Bot2
- Sandbox/Bot3
- Sandbox/Bot4
- Sandbox/Bot5
- Sandbox/CargoBug
- Sandbox/CargoOverview
- Sandbox/CargoOverviewLua
- Sandbox/Categorybox
- Sandbox/Categorybox/row
- Sandbox/D3D10
- Sandbox/D3D11Freeware
- Sandbox/DLC
- Sandbox/Editing guide/Article formatting
- Sandbox/Engine
- Sandbox/FeatureTemplate
- Sandbox/Game data
- Sandbox/Game data/config
- Sandbox/Game list/row
- Sandbox/Game list/row/series
- Sandbox/Home
- Sandbox/Infobox company
- Sandbox/Infobox console
- Sandbox/Infobox console/row/controller
- Sandbox/Infobox controller
- Sandbox/Infobox engine
- Sandbox/Infobox engine/t
- Sandbox/Infobox engine/ti
- Sandbox/Infobox game
- Sandbox/Infobox game/row/link
- Sandbox/Infobox game/row/taxonomy/control
- Sandbox/Infobox game/row/taxonomy/genre
- Sandbox/Infobox game/row/taxonomy/mode
- Sandbox/Infobox game/row/taxonomy/pacing
- Sandbox/Infobox game/row/taxonomy/perspective
- Sandbox/Infobox game/row/taxonomy/series
- Sandbox/Infobox game/row/taxonomy/theme
- Sandbox/Input settings
- Sandbox/L10n/row
- Sandbox/List
- Sandbox/LocalizedPath
- Sandbox/News/displayonly
- Sandbox/Nier Automata
- Sandbox/Note
- Sandbox/OpenGLFreeware
- Sandbox/Path
- Sandbox/PlatformTemplate
- Sandbox/Platform features
- Sandbox/Query
- Sandbox/Refurl
- Sandbox/Resident Evil Resistance
- Sandbox/ScummVM
- Sandbox/Series
- Sandbox/Seriesbox
- Sandbox/Template/AOTD/t
- Sandbox/Template/Seriesbox
- Sandbox/TemplateIntro
- Sandbox/TemplateRow
- Sandbox/TemplateRowFanTranslation
- Sandbox/Test
- Sandbox/Unity
- Sandbox/ValueRankTemplate
- Sandbox/Video settings
- Sandbox/bot
- Sandbox/date
- Sandbox/derp
- Sandbox/path unix
- Sandbox/path windows
- Sandbox/redirectSource
- Sandbox/switch
- common.css
- common.js