Currently, there are 0 users and 0 guests visiting this topic.
Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #87676
    fakingdeath
    Participant
    @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

     

     

    #87678
    fakingdeath
    Participant
    @fakingdeath

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

    #87679
    NailBuster
    Moderator
    @nailbuster
    ModeratorMember

    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….

    1 user thanked author for this post.
    #87680
    NailBuster
    Moderator
    @nailbuster
    ModeratorMember

    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)

    1 user thanked author for this post.
    #87682
    fakingdeath
    Participant
    @fakingdeath

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

Viewing 5 posts - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.

©2021 VPinBall.com

Log in with your credentials

or    

Forgot your details?

Create Account

The Vpinball app

FREE
VIEW