This shows you the differences between two versions of the page.
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 old revision restored (2018/07/27 23:24) |
playlists_sql_examples [2019/06/18 12:55] pinupadmin |
||
---|---|---|---|
Line 4: | Line 4: | ||
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:// | ||
+ | |||
+ | [[https:// | ||
+ | |||
+ | Here are the some columns for Games Table. | ||
+ | |||
+ | < | ||
+ | GameID | ||
+ | EMUID | ||
+ | GameName | ||
+ | GameFileName | ||
+ | GameDisplay | ||
+ | UseEmuDefaults | ||
+ | Visible | ||
+ | Notes TEXT, | ||
+ | DateAdded | ||
+ | GameYear | ||
+ | ROM | ||
+ | Manufact | ||
+ | NumPlayers | ||
+ | ResolutionX | ||
+ | ResolutionY | ||
+ | OutputScreen | ||
+ | ThemeColor | ||
+ | GameType | ||
+ | TAGS VARCHAR (200), | ||
+ | Category | ||
+ | Author | ||
+ | LaunchCustomVar VARCHAR (200), | ||
+ | GKeepDisplays | ||
+ | GameTheme | ||
+ | GameRating | ||
+ | Special | ||
+ | sysVolume | ||
+ | DOFStuff | ||
+ | MediaSearch | ||
+ | AudioChannels | ||
+ | CUSTOM2 | ||
+ | CUSTOM3 | ||
+ | GAMEVER | ||
+ | ALTEXE | ||
+ | IPDBNum | ||
+ | DateUpdated | ||
+ | DateFileUpdated DATETIME, | ||
+ | AutoRecFlag | ||
+ | AltRunMode | ||
+ | WebLinkURL | ||
+ | DesignedBy | ||
+ | </ | ||
- Based on GameType, list all DMD (and color DMD) games: | - Based on GameType, list all DMD (and color DMD) games: |