JohnV Posted October 5, 2014 Share Posted October 5, 2014 I am a new user of SAM Broadcaster and I am experimenting with the automation. This is my 3 playlist rotation programming idea: I have one playlist called "TOP 20" that has my Top 20 newest and best songs. I have a second playlist called "Top 40" that has my Top 40 songs. (Those that have exhausted the Top 20 and/or are not the "BEST of the BEST") I have a third playlist called "GOLD" that has 1200 great songs. I want SAM to play one song from the 1st playlist, then one song from the 2nd playlist, then one song from the third playlist. Without repeating any songs until the playlists are each exhausted. Essentially estimating it will repeat songs from the 1st playlist more (every 4 hours EST) 2nd playlist (every 8 hours) and from the third every few days or weeks. etc. So I have it set to play least played and do not repeat accordingly. Is this the correct way to accomplish this? I feel I am doing something wrong. The problem arises when I add any new music. I would have to reset the play counts or else it will screw up the rotation. Your input would be greatly appreciated. Thanks. Link to comment Share on other sites More sharing options...
SlamminTunes Posted October 9, 2014 Share Posted October 9, 2014 Your logic seems spot on with the rotation. You can create a simple clockwheel to pull from each category and to load liners Like everything this is NOT set and forget and will require maintenance so when adding new tracks you will have to reset counts and balances. Are you using MySQL or firebird? I highly recommend MySQL Link to comment Share on other sites More sharing options...
JohnV Posted October 10, 2014 Author Share Posted October 10, 2014 Your logic seems spot on with the rotation. You can create a simple clockwheel to pull from each category and to load liners Like everything this is NOT set and forget and will require maintenance so when adding new tracks you will have to reset counts and balances. Are you using MySQL or firebird? I highly recommend MySQL Thanks for the answer. I am using Firebird. MySQL was giving me errors. I heard that MySQL was better if you have 10,000+ songs. Have you tried to accomplish any time-based automation on SAM? For example: One playlist from midnight-6am, one playlist for 6am-noon etc. ??? thanks again for the help Link to comment Share on other sites More sharing options...
JohnV Posted October 10, 2014 Author Share Posted October 10, 2014 I can't find where to reset the play counts? Link to comment Share on other sites More sharing options...
shoutcaststreaming Posted October 10, 2014 Share Posted October 10, 2014 Both of your questions can be handled by a PAL script. If you need help writing them, you can contact http://www.palscripts.com SCS - Dedicated Bandwidth Servers Shoutcast / Icecast / Windows Media Transcoding - Auto DJ - Mobile Radio - FLASH Players - Auto DJ Broadcasting World's Stream Host of the Month Link to comment Share on other sites More sharing options...
SlamminTunes Posted October 10, 2014 Share Posted October 10, 2014 I have SAM running multiple playlists daily based on specific time slots. I'm sure there are some people out there that would freak out and tell me that I'm swapping out my playlists the wrong way but its the fastest and most reliable way I've discovered so far. Everything can be accomplished via a PAL script or the Event scheduler to complete these kinds of tasks. I would highly recommend MySQL over Firebird especially if you plan to have a PAL script directly modify the database as there are command compatibility issues with Firebird. Link to comment Share on other sites More sharing options...
SlamminTunes Posted October 10, 2014 Share Posted October 10, 2014 DO NOT USE THESE AS POSTED IT WILL SURELY SCREW UP YOUR SAM BROADCASTER!!!! YOU HAVE TO KNOW THE CATEGORY NUMBERS AND BACK UP THE DATABASE BEFORE YOU ATTEMPT TO USE THIS!!!! For example I use something like this to swap my the music around. ExecSQL('UPDATE categorylist SET categoryID = 3 where categoryID = 4',[]); ExecSQL('UPDATE categorylist, songlist set songlist.songtype = "S" where categorylist.songID = songlist.ID and categorylist.categoryID = 3',[]); ExecSQL('UPDATE categorylist SET categoryID = 2 where categoryID = 1',[]); ExecSQL('UPDATE categorylist, songlist set songlist.songtype = "C" where categorylist.songID = songlist.ID and categorylist.categoryID = 2',[]); Category 1 is MusicVisible Category 2 is MusicHidden Category 3 is NewPlaylistVisible Category 4 is NewPlaylistHidden the visible folders are under the MusicALL category the hiddle folders are in the OtherALL category by reassigning the songtype to c and moving the tracks from the visible folder to the hidden folder those tracks are no longer picked up by SAM and are no longer request-able via the php SAM files by moving the tracks the back to the visible folder and assigning the S songtype they become playable and request-able again. This whole operation takes just milliseconds to accomplish and has never froze up my broadcaster PC. To reverse the whole operation you would use something like this ExecSQL('UPDATE categorylist SET categoryID = 4 where categoryID = 3',[]); ExecSQL('UPDATE categorylist, songlist set songlist.songtype = "C" where categorylist.songID = songlist.ID and categorylist.categoryID = 4',[]); ExecSQL('UPDATE categorylist SET categoryID = 1 where categoryID = 2',[]); ExecSQL('UPDATE categorylist, songlist set songlist.songtype = "S" where categorylist.songID = songlist.ID and categorylist.categoryID = 1',[]); DO NOT USE THESE AS POSTED IT WILL SURELY SCREW UP YOUR SAM BROADCASTER!!!! YOU HAVE TO KNOW THE CATEGORY NUMBERS AND BACK UP THE DATABASE BEFORE YOU ATTEMPT TO USE THIS!!!! Link to comment Share on other sites More sharing options...
JohnV Posted October 10, 2014 Author Share Posted October 10, 2014 Thanks for all your help. I'll experiment with these recommendations. Cheers. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.