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

Maintenance stuff

Admin notes

Matching user ID to username through MediaWiki's API (useful when resolving account conflicts and such):

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.

References

↑ Code block in numbered list (Wiki syntax) - Stack Overflow

[1] Code block in numbered list (Wiki syntax) - Stack Overflow

[1]