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