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/07/27 23:31]
A User Not Logged in
playlists_sql_examples [2018/10/09 14:09]
pinupadmin
Line 5: Line 5:
 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:
  
-- Based on GameType, list all DMD (and color DMD) games:+some threads:
  
-''​SELECT * FROM Games JOIN Emulators on Games.EmuID = emulators.EmuID WHERE (GameType= "​DMDc"​ or GameType= "DMD"ORDER BY GameDisplay''​+[[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 Games 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>​ <​code>​
playlists_sql_examples.txt · Last modified: 2020/05/11 21:20 by pinupadmin