Auto..Weekly top of charts list script

Post a reply

:D :) :( :o :-? 8) :lol: :x :P :oops: :cry: :evil: :roll: :wink:

BBCode is ON
[img] is ON
[flash] is OFF
[url] is ON
Smilies are ON

Topic review

Expand view Topic review: Auto..Weekly top of charts list script

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

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


Is it your intention to update this script for MM3?


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

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

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

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

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:

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.

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 :)

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") 

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

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

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


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

by agentsmart » Sat Apr 29, 2006 7:39 am

okay stop the jokes thats my department to be a smart... :roll:
as you are starting with jokes does this mean that you are able to do what you want now cowboy? because i been wanting that playlist also. so please up date us on what is needed for which computers in order to do this.

thanks. 8)

by rovingcowboy » Sat Apr 29, 2006 7:09 am

:o oh no that is fine i like my weight after all. :P :roll:

at nap time i play soft slow mellow meditation music,

that puts me out like a light if i listen to it. then right after that i play big band and popular music, if sing sing sing comes on it is fairly easy to wake up but if them slow waltz's come on i wake up after a 2 hour nap instead of a 1 hour nap.

i play all the fast rock at 5 am to wake me up in the morning mostly the beatles mixed with elvis the monkees and other good music i really dont like todays rock music it must have falling in a swamp before they play it.

because todays rock music stinks. and rap? don't even think that is music.

mostly country western bluegrass ( big band also inculdes the niteclub singers like nat king cole and dino ) classical with old classic rock

on sundays i play gospel music.

but i don't think i would like that script for weight loss that you suggested.

too much work. :roll:

by DiddeLeeDoo » Sat Apr 29, 2006 6:54 am

I'm sure we can do a script for that too... a weight loss script.. well, let's see, what if we first make sure all the songs with BPM > 180 is played when at nap time... Volume Level 100% and.... and Party Mode active, with hidden password, and not controls to user.... :lol:

If played for 10 minutes, then play Dance Music... for 3 hours... hehe

by rovingcowboy » Sat Apr 29, 2006 6:39 am

well that one looks a lot smaller too 8)

that code just seems to be getting slimmer all the time wish i could lose weight that fast ?