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
Next revision Both sides next revision
playlists_sql_examples [2018/10/09 14:09]
pinupadmin
playlists_sql_examples [2020/03/27 13:48]
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
  
 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. +Here are the some columns for Games Table.<code>
- +
-<code>+
     GameID          INTEGER     GameID          INTEGER
     EMUID           INTEGER,     EMUID           INTEGER,
Line 48: Line 48:
     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