Difference between revisions of "User:Aemony"
m (removed unnecessary link) |
m (added Cargo + SQL LIKE woes) |
||
Line 20: | Line 20: | ||
==Editing notes== | ==Editing notes== | ||
+ | |||
+ | |||
+ | ===Cargo + SQL LIKE woes=== | ||
+ | <pre> | ||
+ | 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 | ||
+ | </pre> | ||
+ | |||
+ | This means that '''HOLDS LIKE''' performs substitution for the underscore {{Code|_}} character. Specifically, it's because the [https://www.w3schools.com/sql/sql_ref_like.asp '''SQL LIKE''' keyword] interprets {{Code|_}} as a wildcard representing a single character. This means that while {{Code|Id_Software}} matches {{Code|id Software}}, it would also match {{Code|iddSoftware}}, {{Code|IdoSoftware}}, and so on. | ||
Revision as of 17:14, 18 September 2022
- 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
Editing notes
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). | ||
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. | |||
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). | ||
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. | ||
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). | ||
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