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/10/09 14:08] 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/ | Active SQL Playlists are a very flexible way of managing your playlists. They are Playlists that will automatically execute/ | ||
+ | |||
+ | Sample Video by user showing example config: https:// | ||
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:// | [[https:// | ||
- | Here are the some columns for Game Table. | + | Here are the some columns for Games Table.< |
- | + | ||
- | < | + | |
GameID | GameID | ||
EMUID | EMUID | ||
Line 48: | Line 48: | ||
GAMEVER | GAMEVER | ||
ALTEXE | ALTEXE | ||
- | IPDBNum | + | IPDBNum |
+ | DateUpdated | ||
+ | DateFileUpdated DATETIME, | ||
+ | AutoRecFlag | ||
+ | AltRunMode | ||
+ | WebLinkURL | ||
+ | DesignedBy | ||
</ | </ | ||