DatabaseQuery

A simple wiki extension to query database table.

It is used by LibreGameWiki to render the "recently released" ticker on the main page and the New games and releases page.

Database queries are inlucded into a wikipage by using the parser function {{#databasequery}}:

{{#databasequery:recentreleased|tablestyle|Column header template|Row template|count}}
{{#databasequery:gamelist|tablestyle|Column header template|Row template|filter}}

The first parameter is the name of the query. In this alpha version, two queries are hard coded:
- recentreleased
- gamelist

The second parameter define the style for the table. wikitable and sortable are commonly used.

The third parameter is the name of a template that is used to render the column headers.

The fourth parameter is the name of a template that is used for each row. The names of the columns from the result set are used as parameter names.

The meaning of the last parameter depends on the query. For the recentreleased list, it is the number of entries to return. For the gamelist it is a filter on the game name (e. g. A% for a list of all games that start with the letter "A").