AutoRateAccurate - Looking for Developers!

[Big_Berny]

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

[ZvezdanD]

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.

[Big_Berny]

Thanks for your help! I'll try to fix it.

[Big_Berny]

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

[ZvezdanD]

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

[Big_Berny]

Thanks a lot!

I'll try it the next days.