foo_playcount_sql, a metadata based playcount Options

[jsheridan]

Hi,

I've developed a proof-of-concept playcount plugin that is based on metadata instead of the file location. The plugin tracks unique combinations of artist/album/title items into a SqlServerCe local database.

In order not to interfere with the file based counters, the data is exposed in a different section at the properties window, and %play_count_sql%, %first_played_sql%, %last_played_sql% tags.

In addition, since the plugin tracks metadata, different named files, or duplicate items that have the same artist/album/title combo, will all get the same playcount information. Currently, it will not detect metadata renames, so they will count as different tracks once renamed.

The playcount database is saved at the user's foobar APPData folder in a file named "PlayCount.sdf"

Version 1.5.4 is available here

History:

Version 1.5.4
1. Tried to fix some rare statup bug

Version 1.5.3
1. Fixed some issue with columns_ui

Version 1.5.2
1. Fixed an issue with the keyboard shortcuts

Version 1.5.1
1. Fixed a bug not tracking tracks with only artist/title, but missing album.

Version 1.5.0
1. New 'most played' GUI screen
2. %album artist% support
3. Now remembers GUI window positions
4. Made context menu shortcuts available from keyboard shortcuts

The following libraries must be installed prior of running:
Microsoft Visual C++ 2008 SP1 Redistributable Package (x86)
Microsoft SQL Server Compact 3.5 Service Pack 1

Screenshot of the properties window:


This post has been edited by jsheridan: May 10 2009, 19:56

[Onkel Andy]

Thanks for the cool work.. Now, the thing would be really brilliant if it worked with an online databse. You know, to track the playcounts no matter whether you are in the office, at home or elsewhere.. Any intentions to include such a functionality?

Thanks alot.

[odyssey]

Thanks for the cool work.. Now, the thing would be really brilliant if it worked with an online databse. You know, to track the playcounts no matter whether you are in the office, at home or elsewhere.. Any intentions to include such a functionality?

You mean like last.fm?

[Onkel Andy]

Thanks for the cool work.. Now, the thing would be really brilliant if it worked with an online databse. You know, to track the playcounts no matter whether you are in the office, at home or elsewhere.. Any intentions to include such a functionality?

You mean like last.fm?

Yep, something like that. The problem is there is no tool to fetch the playcount from lastfm (and write that to the m3-tag)... so that sql-stuff would be a solution