Auto..Weekly top of charts list script

Download and get help for different MediaMonkey Addons.

Moderators: Peke, Gurus

DiddeLeeDoo
Posts: 1017
Joined: Wed Mar 01, 2006 1:09 am
Location: In a jungle down under
Contact:

Post by DiddeLeeDoo » Sat Apr 29, 2006 8:50 am

Must admit that sounds like a well organized setting, and yes, you're just thought me the value of playlists! I look forward to see where this goes..
Image

rovingcowboy
Posts: 14153
Joined: Sat Oct 25, 2003 7:57 am
Location: (Texas)
Contact:

Post by rovingcowboy » Sat Apr 29, 2006 8:59 am

your welcome am glad to have paid back for the scripting.

8)
roving cowboy / keith hall. My skins http://www.mediamonkey.com/forum/viewto ... =9&t=16724 for some help check on Monkey's helpful messages at http://www.mediamonkey.com/forum/viewto ... 4008#44008 MY SYSTEMS.1.Jukebox WinXp pro sp 3 version 3.5 gigabyte mb. 281 GHz amd athlon x2 240 built by me.) 2.WinXP pro sp3, vers 2.5.5 and vers 3.5 backup storage, shuttle 32a mb,734 MHz amd athlon put together by me.) 3.Dell demension, winxp pro sp3, mm3.5 spare jukebox.) 4.WinXp pro sp3, vers 3.5, dad's computer bought from computer store. )5. Samsung Galaxy 5 Android 5) 6. Proscan tablet Android 4.3 ) 7. amd a8-5600 apu 3.60ghz mm version 4 windows 7 pro bought from computer store.

rovingcowboy
Posts: 14153
Joined: Sat Oct 25, 2003 7:57 am
Location: (Texas)
Contact:

Post by rovingcowboy » Sat Apr 29, 2006 9:38 am

i will clear it up in one message for ease of reading.


until some one combines all the following into one script if possible. this is how to get the automatic top 40 playlist working.

in windows98 this code works with out any error it also works in winXp. with out any error.
copy and paste this in to notepad then save notepad as clear playcount.vbs then put it in a place you don't click on all the time.
set a task schedule to run it or just double click on the vbs file it will
clear all the visable playcounts back to zero.

Code: Select all


' Roving Cowboy's Sunday Morning Script :) 
' By DiddeLeeDoo on 28 April 2006 
Option Explicit 
Dim SDB 
Set SDB = CreateObject("SongsDB.SDBApplication") 
SDB.Database.ExecSQL("UPDATE Songs SET PlayCounter=0") 
SDB.MainTracksWindow.Refresh

now you need to use the above codes once a week in order to get a correct play count for that time line, if you want a longer time line of a month then set it up for a month.

i use the task scheduler to run it after i have played the top of the charts list to set them to zero for the next week.
all they do is change the visible playcount in the list's and do not mess with the history play counts.
you should use a task scheduler task to run it so you wont forget to do it.

now you need to get the code for the playlists and put in the database for media monkey if you do not have the gold version?
for the gold version just set up an autoplaylist and tell it to check only sort by the last date played, and check only 7 days back if you want a weekly playlist.

for the free version you will need to know how to install a program to open the database and then install the code all that can be found in this other message thread.

http://www.mediamonkey.com/forum/viewto ... 2644#42644

that links to the message reply with the code i use. check the whole message on what programs to open the database with and how to do it.

once you have the playlists set up you can then use Pekes windows scheduler playlist scripts to start your auto playlist anytime you want from the task scheduler. here is the link to the new version of them.

http://www.mediamonkey.com/forum/viewtopic.php?t=6042

you can find the first version posted in replys to some messages in the forum here they are fairly easy to find them but the first version is for only one playlist per script. the new version handles all the playlists you can put in one script.

that is all you need for a top of the charts playlist to run automaticly.

for a weekly report to print as a hard copy use the script by diddeleedoo it is on the first page of this thread. and has a link to it in the all scripts thread. but here is the link again.

http://www.mediamonkey.com/forum/viewto ... 4824#44824

if you want to keep your ratings also correct then get the auto ratings script and set it to work on the same time line as your top of the charts list or set it to check for the last 3 to 5 years but only go back as far as your database goes other wise the auto ratings script errors out..

here is the link to the auto ratings script.

http://www.mediamonkey.com/forum/viewto ... 3798#43798

if you go back that far with the script you should set up a new playcount code for it which i have done already and posted at this reply in that thread.

http://www.mediamonkey.com/forum/viewto ... 4673#44673

you can see it is simple to change your play counts in that script Diddeleedoo makes it easy for us to change to fit our wants.

that is what i use and do for the top of the charts list i use now on a weekly time line.

if some one combines all this in to one massive script i might change and use it. but as you can see it involves several large scripts already so to get them all working as one would almost be an new program?

:o 8)
Last edited by rovingcowboy on Mon Dec 10, 2007 11:41 pm, edited 4 times in total.
roving cowboy / keith hall. My skins http://www.mediamonkey.com/forum/viewto ... =9&t=16724 for some help check on Monkey's helpful messages at http://www.mediamonkey.com/forum/viewto ... 4008#44008 MY SYSTEMS.1.Jukebox WinXp pro sp 3 version 3.5 gigabyte mb. 281 GHz amd athlon x2 240 built by me.) 2.WinXP pro sp3, vers 2.5.5 and vers 3.5 backup storage, shuttle 32a mb,734 MHz amd athlon put together by me.) 3.Dell demension, winxp pro sp3, mm3.5 spare jukebox.) 4.WinXp pro sp3, vers 3.5, dad's computer bought from computer store. )5. Samsung Galaxy 5 Android 5) 6. Proscan tablet Android 4.3 ) 7. amd a8-5600 apu 3.60ghz mm version 4 windows 7 pro bought from computer store.

agentsmart

Post by agentsmart » Sat Apr 29, 2006 1:01 pm

wholee cow :o boy
next time i'll ask for a revised edition? :P :P

but atleast it is all listed in one spot now thanks :)

DiddeLeeDoo
Posts: 1017
Joined: Wed Mar 01, 2006 1:09 am
Location: In a jungle down under
Contact:

Post by DiddeLeeDoo » Sat Apr 29, 2006 11:27 pm

I like your revised version above.

May I just add that the current AutoRate system is a 'Keep Updated' System.

The BIG MAMA, the Catch-Up With Ratings script is in the works, and is currently functional. However, I work on some optimizing issues, that I'd like to solve before sharing it.
Image

confused

Post by confused » Sun Apr 30, 2006 1:01 am

wow is right this post is so much more then the reply you gave me.
of course then you were not finished with it like you are now.

and agentsmart diddeleedoo is correct
this is cowboy's revised edtion, it is only one page and not 10 pages :roll:

rovingcowboy
Posts: 14153
Joined: Sat Oct 25, 2003 7:57 am
Location: (Texas)
Contact:

Post by rovingcowboy » Sun Apr 30, 2006 2:56 pm

sorry agentsmart and confused?

i just tried to give you all the info you needed just like you asked for?

i know it is a lot to digest but it is simple when you see what is going on

with the scripts. 8) :D
roving cowboy / keith hall. My skins http://www.mediamonkey.com/forum/viewto ... =9&t=16724 for some help check on Monkey's helpful messages at http://www.mediamonkey.com/forum/viewto ... 4008#44008 MY SYSTEMS.1.Jukebox WinXp pro sp 3 version 3.5 gigabyte mb. 281 GHz amd athlon x2 240 built by me.) 2.WinXP pro sp3, vers 2.5.5 and vers 3.5 backup storage, shuttle 32a mb,734 MHz amd athlon put together by me.) 3.Dell demension, winxp pro sp3, mm3.5 spare jukebox.) 4.WinXp pro sp3, vers 3.5, dad's computer bought from computer store. )5. Samsung Galaxy 5 Android 5) 6. Proscan tablet Android 4.3 ) 7. amd a8-5600 apu 3.60ghz mm version 4 windows 7 pro bought from computer store.

Diabolic-Destiny
Posts: 223
Joined: Sun Apr 29, 2007 9:45 pm

Post by Diabolic-Destiny » Tue May 22, 2007 6:16 pm

so where exactly is the latest version of this script im kinda confused..
Image
Image

rovingcowboy
Posts: 14153
Joined: Sat Oct 25, 2003 7:57 am
Location: (Texas)
Contact:

Post by rovingcowboy » Tue May 22, 2007 9:16 pm

as i said in the all scripts thread its not one script but a group
of scripts used to create it.

they are at the links above in my post dated as of this date.

Sat Apr 29, 2006 9:38 am

the way to do this is explained for the free version of mm2.

that is why i say to edit the access database to make the playlist. but you can set up a playlist that does the same thing in the gold version with the auto playlists.

you just need to do the steps involving the code above in order to get playcount to revert back to zero. i change it back every 7 days. by use of the task scheduler timer.

the auto playlist is set up to show the most played songs
for a certian number of days.

in order of the most played at the top.
and it is set up to only show enough songs to fit what ever time limit you want..

i use one hour this gives me a weekly top of the charts list.
because i run the media monkey program all day every day with just a few hours off for maintance. so the songs are played and the count goes up for a week then the auto playlist
is set to play by timer, then the code above is set to run after the playlist is finished in one hour, thus changing all the playcounts back to zero and starting over.

this makes all the songs have an even chance of being played.
and stops monkey from playing the songs with the most playcounts all the time, which it seems to do, which makes it possible to have the songs move up to the top of the playlist.

but the only code there is to set up is the one in that message to clear the playcount.

if you have the free version then you have to modify the access database. (they changed the database in mm 3 so i don't know how this will be worked in mm 3 free version.)

but as long as you can set up the auto playlists and timers in the task scheduler then you can use this way of making the top of the charts list. diddeleedoo will fix the code above to work in mm 3 when mm 3 is finally released as stable
roving cowboy / keith hall. My skins http://www.mediamonkey.com/forum/viewto ... =9&t=16724 for some help check on Monkey's helpful messages at http://www.mediamonkey.com/forum/viewto ... 4008#44008 MY SYSTEMS.1.Jukebox WinXp pro sp 3 version 3.5 gigabyte mb. 281 GHz amd athlon x2 240 built by me.) 2.WinXP pro sp3, vers 2.5.5 and vers 3.5 backup storage, shuttle 32a mb,734 MHz amd athlon put together by me.) 3.Dell demension, winxp pro sp3, mm3.5 spare jukebox.) 4.WinXp pro sp3, vers 3.5, dad's computer bought from computer store. )5. Samsung Galaxy 5 Android 5) 6. Proscan tablet Android 4.3 ) 7. amd a8-5600 apu 3.60ghz mm version 4 windows 7 pro bought from computer store.

nynaevelan
Posts: 5559
Joined: Wed Feb 07, 2007 11:07 pm
Location: New Jersey, USA
Contact:

Post by nynaevelan » Mon Dec 10, 2007 9:52 pm

RC:

Is it your intention to update this script for MM3?

Nyn
3.2x - Win7 Ultimate (Zen Touch 2 16 GB/Zen 8GB)
Link to Favorite Scripts/Skins

Join Dropbox, the online site to share your files

rovingcowboy
Posts: 14153
Joined: Sat Oct 25, 2003 7:57 am
Location: (Texas)
Contact:

Post by rovingcowboy » Mon Dec 10, 2007 11:17 pm

the ratings is going to be adjusted for mm 3 by diddeleedoo whom made it.

steegy told me how to get in to the database on mm 2 to find the right table for the timer of last time played.

the clearing of the visable playcount script was made by diddeleedoo, so i hope he can get it working in mm 3 since the database is now sql.

peke made the script i use to start the playlist's he said it should work since it does nothing but start the playlists? if sql database uses the same playlist table then it should still work.

but this is just a collection of scripts used to make one weekly top of the charts. they are the links in the above message and the one script in the message.

  • you need these.
    1. windows scheduler scripts by Peke.

    2. a playlist set up to play songs and automaticly pick them from the times played in the last number of days.
    (either do that with the gold version feature, or go in to the database and make the playlist in the database. the link in my above message takes you to the thread of how to do that in the microsoft access database, i don't know how in the sql database.)

    3. then use the script for clearing the visable playcounts that is in the message of mine above.

    http://www.mediamonkey.com/forum/viewto ... 4983#44983

    set it to run automaticly by the windows task scheduler or just double click it when you want to change the visable playcounts.


i have been in touch with diddeleedoo and he is waiting for the final release of mm 3 before he makes a new re vised version of the ratings script i use. and i there for presume he is also waiting for that before he fix'es any of his other scripts.
but he is busy now with his work this time of year he has to sleep under his desk its that busy, in a few weeks or so he might get some slack and look at the new monkey code but he is busy as a beaver with 30 dam brakes in 8 beaver dams.

but i sure would like this to work in mm 3. if steegy or any one else wants to work a script up to get to the playlist table for last time played in the sql database that would be great.
8)
roving cowboy / keith hall. My skins http://www.mediamonkey.com/forum/viewto ... =9&t=16724 for some help check on Monkey's helpful messages at http://www.mediamonkey.com/forum/viewto ... 4008#44008 MY SYSTEMS.1.Jukebox WinXp pro sp 3 version 3.5 gigabyte mb. 281 GHz amd athlon x2 240 built by me.) 2.WinXP pro sp3, vers 2.5.5 and vers 3.5 backup storage, shuttle 32a mb,734 MHz amd athlon put together by me.) 3.Dell demension, winxp pro sp3, mm3.5 spare jukebox.) 4.WinXp pro sp3, vers 3.5, dad's computer bought from computer store. )5. Samsung Galaxy 5 Android 5) 6. Proscan tablet Android 4.3 ) 7. amd a8-5600 apu 3.60ghz mm version 4 windows 7 pro bought from computer store.

Post Reply