PinUP Player
PuP-Packs
PinUP Popper (Front-end)
PinUP Software UPDATES
Emulators Info:
Settings:
PinUP Player
PuP-Packs
PinUP Popper (Front-end)
PinUP Software UPDATES
Emulators Info:
Settings:
This is an old revision of the document!
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:
some threads:
https://vpinball.com/forums/topic/sql-playlists/
https://vpinball.com/forums/topic/sql-helper-for-pinballx-users-going-to-pinup-menu/
Here are the some columns for Game Table.
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)
- Based on GameType, list all DMD (and color DMD) games:
SELECT * FROM Games JOIN Emulators on Games.EmuID = emulators.EmuID WHERE (GameType= "DMDc" or GameType= "DMD") ORDER BY GameDisplay
- Using the TAG “ignore” remove certain games from any list:
SELECT * FROM Games JOIN Emulators on Games.EmuID = emulators.EmuID WHERE (GameType= "DMDc" or GameType= "DMD") and tags not like "%ignore%" ORDER BY GameDisplay
- Playlist for Pinsound tables (using field LaunchCustomVar)
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"
- Playlist for adult games:
select * from games JOIN Emulators on Games.EmuID = emulators.EmuID where TAGS LIKE "%adult%" and TAGS NOT LIKE "%ignore%" ORDER BY "GameDisplay"