User Tools

Site Tools


playlists_sql_examples

Differences

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

Link to this comparison view

Next revision
Previous revision
Next revision Both sides next revision
playlists_sql_examples [2018/07/27 20:53]
A User Not Logged in created
playlists_sql_examples [2018/10/09 14:08]
pinupadmin
Line 1: Line 1:
 ====== PlayLists Active SQL Examples ====== ====== PlayLists Active SQL Examples ======
  
-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.
  
 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:
 +
 +some threads:
 +
 +[[https://​vpinball.com/​forums/​topic/​sql-playlists/​|https://​vpinball.com/​forums/​topic/​sql-playlists/​]]
 +
 +[[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.
 +
 +<​code>​
 +    GameID ​         INTEGER
 +    EMUID           ​INTEGER,​
 +    GameName ​       VARCHAR (200)
 +    GameFileName ​   VARCHAR (250)
 +    GameDisplay ​    ​VARCHAR (200)
 +    UseEmuDefaults ​ INTEGER,
 +    Visible ​        ​INTEGER ​      ​DEFAULT (1),
 +    Notes           TEXT,
 +    DateAdded ​      ​DATETIME,​
 +    GameYear ​       INTEGER,
 +    ROM             ​VARCHAR (100),
 +    Manufact ​       VARCHAR (200),
 +    NumPlayers ​     INTEGER,
 +    ResolutionX ​    ​INTEGER,​
 +    ResolutionY ​    ​INTEGER,​
 +    OutputScreen ​   INTEGER,
 +    ThemeColor ​     INTEGER,
 +    GameType ​       VARCHAR (50),
 +    TAGS            VARCHAR (200),
 +    Category ​       VARCHAR (200),
 +    Author ​         VARCHAR (200),
 +    LaunchCustomVar VARCHAR (200),
 +    GKeepDisplays ​  ​VARCHAR (50),
 +    GameTheme ​      ​VARCHAR (100),
 +    GameRating ​     INTEGER,
 +    Special ​        TEXT,
 +    sysVolume ​      ​INTEGER,​
 +    DOFStuff ​       VARCHAR (250),
 +    MediaSearch ​    ​VARCHAR (100),
 +    AudioChannels ​  ​VARCHAR (50),
 +    CUSTOM2 ​        ​VARCHAR (100),
 +    CUSTOM3 ​        ​VARCHAR (100),
 +    GAMEVER ​        ​VARCHAR (100),
 +    ALTEXE ​         VARCHAR (250),
 +    IPDBNum ​        ​VARCHAR (100)
 +</​code>​
 +
 +- Based on GameType, list all DMD (and color DMD) games:
 +
 +<​code>​
 +SELECT * FROM Games JOIN Emulators on Games.EmuID = emulators.EmuID WHERE (GameType= "​DMDc"​ or GameType= "​DMD"​) ORDER BY GameDisplay
 +</​code>​
 +
 +- Using the TAG "​ignore"​ remove certain games from any list:
 +
 +<​code>​
 +SELECT * FROM Games JOIN Emulators on Games.EmuID = emulators.EmuID WHERE (GameType= "​DMDc"​ or GameType= "​DMD"​) and tags not like "​%ignore%"​ ORDER BY GameDisplay
 +</​code>​
 +
 +- Playlist for Pinsound tables (using field LaunchCustomVar)
 +
 +<​code>​
 +SELECT * FROM Games JOIN Emulators on Games.EmuID = emulators.EmuID WHERE ( LaunchCustomVar LIKE "​%pinsound%"​ or LaunchCustomVar LIKE "​%altsound%"​) and TAGS NOT LIKE "​%ignore%"​ ORDER BY "​GameDisplay"​
 +</​code>​
 +
 +- Playlist for adult games:
 +
 +<​code>​
 +select * from games JOIN Emulators on Games.EmuID = emulators.EmuID where TAGS LIKE "​%adult%"​ and TAGS NOT LIKE "​%ignore%"​ ORDER BY "​GameDisplay"​
 +</​code>​
  
  
playlists_sql_examples.txt ยท Last modified: 2020/05/11 21:20 by pinupadmin