AutoRateAccurate - Looking for Developers!

This forum is for questions / discussions regarding development of addons / tweaks for MediaMonkey.

Moderator: Gurus

Big_Berny
Posts: 1784
Joined: Mon Nov 28, 2005 11:55 am
Location: Switzerland
Contact:

AutoRateAccurate - Looking for Developers!

Post by Big_Berny » Fri Dec 09, 2011 5:04 am

Hey guys
as you maybe know (if you already were member some years ago) I developed the script AutoRateAccurate: http://www.mediamonkey.com/forum/viewto ... =2&t=24126
Unfortunately I don't have time anymore to update and fix the bugs since I started my own company and still have to finish my studies.

Is there maybe someone who is willing to continue the development on it? It basically works with MM4 it just has one problem with creating a filter called AutoRateAccurate. So it would be no big deal to fix it. And SkipDetection could be removed as MM4 already has that feature IMHO, right?

It would really be great if someone could pick up the script as a lot users seem to like it. Surely I'll help if you'd have any problems with it.

Big_Berny
Image
Scripts in use: Genre Finder / Last.fm DJ / Magic Nodes / AutoRateAccurate / Last.FM Node
Skins in use: ZuneSkin SP / Eclipse SP
AutoRateAccurate 3.0.0 (New) - Rates all your songs in less than 5 seconds!
About me: icoaching - internet | marketing | design

ZvezdanD
Posts: 3084
Joined: Thu Jun 08, 2006 7:40 pm

Re: AutoRateAccurate - Looking for Developers!

Post by ZvezdanD » Fri Dec 09, 2011 1:34 pm

Here is a quick fix for the filter bug. In line 79 instead of:

Code: Select all

            SDB.DataBase.ExecSQL("INSERT INTO Filters (Pos,Name,Cond,View,Player,ContentType) VALUES((SELECT Max(Pos) FROM Filters)+1,'AutoRateAccurate','" & Cond & "','" & View & "',0,0)")
you should write:

Code: Select all

            If SDB.VersionHi < 4 Then
                SDB.DataBase.ExecSQL("INSERT INTO Filters (Pos,Name,Cond,View,Player,ContentType) VALUES((SELECT Max(Pos) FROM Filters)+1,'AutoRateAccurate','" & Cond & "','" & View & "',0,0)")
            Else
                If SDB.Database.OpenSQL("SELECT Count(*) FROM Views WHERE Name='AutoRateAccurate'").ValueByIndex(0) = 0 Then
                    SDB.DataBase.ExecSQL("INSERT INTO Views (Name, View) VALUES('AutoRateAccurate', '" & View & "')")
                End If
                SDB.DataBase.ExecSQL("INSERT INTO Filters (Pos,Name,Cond,IDView,VisibleInMainTree) VALUES((SELECT Max(Pos) FROM Filters)+1,'AutoRateAccurate','" & Cond & "', (SELECT ID FROM Views WHERE Name = 'AutoRateAccurate'), 0)")
            End If
I don't use this script, so I didn't test it if there is some another problem related to the filters. After quick look at the source code I think that you could also have some problems because of changed date/time format in MM4: http://www.mediamonkey.com/forum/viewto ... 19&t=58987. DateDiff and julianday function with 'localtime' argument is first to look at.
Magic Nodes 4.3.3 / 5.2 RegExp Find & Replace 4.4.9 / 5.2  Invert Selection/Select None 1.5.1  Export/Create Playlists for Child Nodes 4.1 / 5.4  Expand Child Nodes/Expand All 1.1.2  Event Logger 2.7  Filtered Statistics Report 1.6  Track Redirection & Synchronization 3.4.2  Restore/Synchronize Database 3.1.7 / 4.0  Find Currently Playing Track 1.3.2  Queue List 1.2.1  Add to Library on Play 1.0.1  Tree Report for Child Nodes 1.1.1  Update Location of Files in Database 1.4.3 / 2.2.2  Inherit Child Playlists 1.0.2  Add Currently Playing/Selected Track(s) to Playlist 1.1.2

Big_Berny
Posts: 1784
Joined: Mon Nov 28, 2005 11:55 am
Location: Switzerland
Contact:

Re: AutoRateAccurate - Looking for Developers!

Post by Big_Berny » Sat Dec 10, 2011 10:41 am

Thanks for your help! I'll try to fix it.
Image
Scripts in use: Genre Finder / Last.fm DJ / Magic Nodes / AutoRateAccurate / Last.FM Node
Skins in use: ZuneSkin SP / Eclipse SP
AutoRateAccurate 3.0.0 (New) - Rates all your songs in less than 5 seconds!
About me: icoaching - internet | marketing | design

Big_Berny
Posts: 1784
Joined: Mon Nov 28, 2005 11:55 am
Location: Switzerland
Contact:

Re: AutoRateAccurate - Looking for Developers!

Post by Big_Berny » Sun Dec 11, 2011 8:15 am

Hey ZvezdanD
as you seem to be an SQL crack I wanted to ask how I can find out when (date) a song with a given ID has been played the first time. Do you have an idea? AFAIK this informtion is stored in the database, right?

Thanks :)
Image
Scripts in use: Genre Finder / Last.fm DJ / Magic Nodes / AutoRateAccurate / Last.FM Node
Skins in use: ZuneSkin SP / Eclipse SP
AutoRateAccurate 3.0.0 (New) - Rates all your songs in less than 5 seconds!
About me: icoaching - internet | marketing | design

ZvezdanD
Posts: 3084
Joined: Thu Jun 08, 2006 7:40 pm

Re: AutoRateAccurate - Looking for Developers!

Post by ZvezdanD » Sun Dec 11, 2011 8:49 am

Big_Berny wrote:how I can find out when (date) a song with a given ID has been played the first time.

Code: Select all

SELECT Min(PlayDate) FROM Played WHERE IDSong = xxx
Magic Nodes 4.3.3 / 5.2 RegExp Find & Replace 4.4.9 / 5.2  Invert Selection/Select None 1.5.1  Export/Create Playlists for Child Nodes 4.1 / 5.4  Expand Child Nodes/Expand All 1.1.2  Event Logger 2.7  Filtered Statistics Report 1.6  Track Redirection & Synchronization 3.4.2  Restore/Synchronize Database 3.1.7 / 4.0  Find Currently Playing Track 1.3.2  Queue List 1.2.1  Add to Library on Play 1.0.1  Tree Report for Child Nodes 1.1.1  Update Location of Files in Database 1.4.3 / 2.2.2  Inherit Child Playlists 1.0.2  Add Currently Playing/Selected Track(s) to Playlist 1.1.2

Big_Berny
Posts: 1784
Joined: Mon Nov 28, 2005 11:55 am
Location: Switzerland
Contact:

Re: AutoRateAccurate - Looking for Developers!

Post by Big_Berny » Sun Dec 11, 2011 8:57 am

Thanks a lot! :)

I'll try it the next days.
Image
Scripts in use: Genre Finder / Last.fm DJ / Magic Nodes / AutoRateAccurate / Last.FM Node
Skins in use: ZuneSkin SP / Eclipse SP
AutoRateAccurate 3.0.0 (New) - Rates all your songs in less than 5 seconds!
About me: icoaching - internet | marketing | design

Post Reply