User Tools

Site Tools


playlists_sql_examples

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
playlists_sql_examples [2019/06/18 12:55]
pinupadmin
playlists_sql_examples [2020/05/11 21:20] (current)
pinupadmin
Line 2: Line 2:
  
 Active SQL Playlists are a very flexible way of managing your playlists. They are Playlists that will automatically execute/​update each time you select them giving you ability to filter and grab tables dynamically. Active SQL Playlists are a very flexible way of managing your playlists. They are Playlists that will automatically execute/​update each time you select them giving you ability to filter and grab tables dynamically.
 +
 +Sample Video by user showing example config: [[https://​youtu.be/​-ZwC32AzgIM|https://​youtu.be/​-ZwC32AzgIM]]
  
 Here are some sample of Playlists and the SQL you can set to use them: Here are some sample of Playlists and the SQL you can set to use them:
Line 11: Line 13:
 [[https://​vpinball.com/​forums/​topic/​sql-helper-for-pinballx-users-going-to-pinup-menu/​|https://​vpinball.com/​forums/​topic/​sql-helper-for-pinballx-users-going-to-pinup-menu/​]] [[https://​vpinball.com/​forums/​topic/​sql-helper-for-pinballx-users-going-to-pinup-menu/​|https://​vpinball.com/​forums/​topic/​sql-helper-for-pinballx-users-going-to-pinup-menu/​]]
  
-Here are the some columns for Games Table.+==== How to make a '​mature'​ sql playlist and hide them from others ==== 
 + 
 +You want on each of these '​mature'​ games, ​the first field in game manager is “status'​. set to mature/​hidden. 
 + 
 +Note: if you are using any active sql playlist make sure you filter out and use visible=1 so it doesn'​t pickup any mature games…..
  
-<​code>​+Here are the some columns for Games Table.<​code>​
     GameID ​         INTEGER     GameID ​         INTEGER
     EMUID           ​INTEGER,​     EMUID           ​INTEGER,​
playlists_sql_examples.1560876913.txt.gz · Last modified: 2019/06/18 12:55 by pinupadmin