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
Set SDB = CreateObject("SongsDB.SDBApplication")
SDB.Database.ExecSQL("UPDATE Songs SET PlayCounter=0")
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.
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?