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 [2018/10/09 14:08]
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 Game 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,
Line 48: Line 54:
     GAMEVER         VARCHAR (100),     GAMEVER         VARCHAR (100),
     ALTEXE          VARCHAR (250),     ALTEXE          VARCHAR (250),
-    IPDBNum         VARCHAR (100)+    IPDBNum         VARCHAR (100), 
 +    DateUpdated     DATETIME, 
 +    DateFileUpdated DATETIME, 
 +    AutoRecFlag     INTEGER        DEFAULT 0, 
 +    AltRunMode      VARCHAR (250), 
 +    WebLinkURL      VARCHAR (1000), 
 +    DesignedBy      VARCHAR (200)
 </code> </code>
  
playlists_sql_examples.1539108535.txt.gz · Last modified: 2018/10/09 14:08 by pinupadmin