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


Warning for game developers: PCGamingWiki staff members will only ever reach out to you using the official press@pcgamingwiki.com mail address.
Be aware of scammers claiming to be representatives or affiliates of PCGamingWiki who promise a PCGW page for a game key.

Difference between revisions of "Template:Assignment/checkAvailable"

From PCGamingWiki, the wiki about fixing PC games
m (changed WHERE to use {{PAGEID}} instead)
m (updated template to compare against new column)
 
(3 intermediate revisions by the same user not shown)
Line 2: Line 2:
 
tables=Assignments
 
tables=Assignments
 
|fields=Game
 
|fields=Game
|where=PageID="{{PAGEID}}" AND Status = "available"
+
|where=EncodedName="{{urlencode:{{PAGENAME}}|PATH}}" AND Status = "available"
 
|limit=1
 
|limit=1
 
|format=template
 
|format=template

Latest revision as of 09:10, 20 July 2020