Custom Options

[fakingdeath]

Playing with the custom options today and came across something I couldn’t quite figure out do

 

If I use the NoSysLists I lose them everywhere and honestly like them. How could I hide them from showing in other playlists but still on the ‘home list’

 

For example my son has a playlist for “kids/cartoon” tables and I would like to exclude him being to click on most played or recently played for certain reasons but don’t necessarily want to pass code them

 

 

You need to login in order to like this post: click here

[fakingdeath]

Or if I want my random active sql playlist to only have the tables and the go back but no recently played?

You need to login in order to like this post: click here

[NailBuster]

if you hide the system ones, you’ll just have to create your own ‘custom’ playlists (which can do the same thing) by using active sql list.

somone on the FB groups posted a “global recently played” and “global favs” active playlist.

you can then on your custom lists add a passcode.

you only enter your passcode once if all ‘locked’ playlists have the same passcode.

Let me know if that makes sense….

You need to login in order to like this post: click here

1 user thanked author for this post.

fakingdeath

[NailBuster]

from lian:

FYI for people, I *think* this gives you a global “Most Played” playlist…

SELECT *
FROM Games t1
LEFT JOIN
(SELECT GameID, SUM(NumPlayed) as TotalPlayed FROM Playlistdetails GROUP BY GameID) t2
ON t2.GameID = t1.GameID
ORDER BY t2.TotalPlayed DESC LIMIT(15)

 

“last played”

SELECT *
FROM Games t1
LEFT JOIN
(SELECT GameID, MAX(LastPlayed) as Date FROM Playlistdetails GROUP BY GameID ORDER BY Date) t2
ON t2.GameID = t1.GameID
ORDER BY t2.Date DESC LIMIT(15)

You need to login in order to like this post: click here

1 user thanked author for this post.

fakingdeath

[fakingdeath]

Hmm, I follow, that makes sense. Thank you!

You need to login in order to like this post: click here

[Author]

Posts