Anonymous edits have been disabled on the wiki. If you want to contribute please login or create an account.

User:Aemony

From PCGamingWiki, the wiki about fixing PC games
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
Icon overlay.png
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
Epic Games Launcher
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
Icon overlay.png
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
Icon overlay.png
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
Epic Games Launcher
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
Icon overlay.png
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)
Icon overlay.png
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
Icon overlay.png
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
Icon overlay.png
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
Icon overlay.png
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
Epic Games Launcher
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
Icon overlay.png
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
Icon overlay.png
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
Icon overlay.png
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
Origin
July 5, 2019 Aemony (t|c|a) Aemony (t|c|a) Review code requested July 5, 2019 via Twitter.
Warhammer 40,000: Inquisitor - Martyr
Icon overlay.png
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
Icon overlay.png
June 20, 2019 Aemony (t|c|a) Aemony (t|c|a) Review code requested June 6, 2019 (Hi-Bit Studios).
Journey
Epic Games Launcher
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
Icon overlay.png
May 30, 2019 Aemony (t|c|a) Aemony (t|c|a) Review code received (Dead Good).
Void Bastards
Icon overlay.png
May 29, 2019 Aemony (t|c|a) May 30, 2019 Aemony (t|c|a) Review code received (Humble).
Draugen
GOG.com key
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.
Vambrace: Cold Soul
Icon overlay.png
May 28, 2019 Aemony (t|c|a) Aemony (t|c|a) Review code received (Headup Games).
SpellForce 3: Soul Harvest
Icon overlay.png
May 28, 2019 Aemony (t|c|a) May 28, 2019 Aemony (t|c|a) Review code received (Dead Good).
RAGE 2
Bethesda.net Launcher
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.
A Plague Tale: Innocence
Icon overlay.png
May 14, 2019 Aemony (t|c|a)
Expack3 (t|c|a)
May 19, 2019 Aemony (t|c|a) Review code received (Koch Media).
Yakuza Kiwami 2
Icon overlay.png
May 9, 2019 Aemony (t|c|a) May 9, 2019 Aemony (t|c|a) Purchased using Gamesplanet funds.
Mordhau
Icon overlay.png
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
Icon overlay.png
April 25, 2019 Aemony (t|c|a) May 5, 2019 Aemony (t|c|a) Review key received (Paradox).
Train Valley 2
Icon overlay.png
April 15, 2019 Aemony (t|c|a) Aemony (t|c|a) Review key received (Jaleo PR).
Feather
Icon overlay.png
April 5, 2019 Aemony (t|c|a) Aemony (t|c|a) Review key received (Super Indie Games).
Photographs
Icon overlay.png
April 3, 2019 Aemony (t|c|a) April 11, 2019 Aemony (t|c|a) Review key received (Landfall).
Generation Zero
Icon overlay.png
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