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
Last revision Both sides next revision
playlists_sql_examples [2018/10/09 14:08]
pinupadmin
playlists_sql_examples [2020/05/11 21:19]
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' playlist and hide them from others ==== 
 + 
 +make a playlist called “special” and set a 4-digit passcode on it in playlist manager. then add those games. should also set the 'hide from attrac' setting for this playlist too. 
 + 
 +also, 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 56:
     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.txt · Last modified: 2020/05/11 21:20 by pinupadmin