Difference between revisions of "Template:Assignment/checkAvailable"

From PCGamingWiki, the wiki about fixing PC games
m (changed WHERE to use {{PAGEID}} instead)
m (can't be bothered any longer with how cumbersome a rework would be)
Line 2: Line 2:
 
tables=Assignments
 
tables=Assignments
 
|fields=Game
 
|fields=Game
|where=PageID="{{PAGEID}}" AND Status = "available"
+
|where=Game="{{PAGENAME}}" AND Status = "available"
 
|limit=1
 
|limit=1
 
|format=template
 
|format=template

Revision as of 15:55, 15 July 2020