Skip to main content

Topic: foo_playcount_sql (Read 67132 times) previous topic - next topic

0 Members and 1 Guest are viewing this topic.
  • jsheridan
  • [*][*][*]
  • Developer
foo_playcount_sql
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:
  • Last Edit: 10 May, 2009, 02:56:18 PM by jsheridan
You can fool some of the people all of the time, and all of the people some of the time, but you can not fool all of the people all of the time.

- Abraham Lincoln

foo_playcount_sql
Reply #1
Very nice idea.

I have some questions.

1. Will it be possible to import current statistics, because of not starting again at the beginning?
2. Will you implemement a %rating_sql% tag?

I ask, because of the possibility to get average rating value for artist and album. I'm current using Playlist Tree Mod for this and it is calculating for ages to do this.

foo_playcount_sql
Reply #2
Thats great, thank you very much. as above though, would there be a way to imprt the current play stats from the standard plugin to this?

Finally, i can rename folders without losing playcounts!

  • mpioner
  • [*]
foo_playcount_sql
Reply #3
maybe you will use FooID, Song fingerprinting, than unique combinations of artist/album/title items 
  • Last Edit: 10 March, 2009, 09:46:07 AM by mpioner

  • jsheridan
  • [*][*][*]
  • Developer
foo_playcount_sql
Reply #4
1. Importing file based statistics (from official playcount) will be implemented for the next version.
2. rating_sql, i'll might add it in the future, but not for the next version.
3. foo_id idea, since this method is based on heuristics, i prefer not to use it atm, and keep things simple.
  • Last Edit: 10 March, 2009, 09:56:17 AM by jsheridan
You can fool some of the people all of the time, and all of the people some of the time, but you can not fool all of the people all of the time.

- Abraham Lincoln

  • Galleon
  • [*]
foo_playcount_sql
Reply #5
Hello, do this plugin works with foobar 0.9.6.3 and Vista ? I had an error when i just started foobar

  • jsheridan
  • [*][*][*]
  • Developer
foo_playcount_sql
Reply #6
Hello, do this plugin works with foobar 0.9.6.3 and Vista ? I had an error when i just started foobar


Did you install of the required libraries as specified by the original post?
If so, please post a screenshot of the error.
You can fool some of the people all of the time, and all of the people some of the time, but you can not fool all of the people all of the time.

- Abraham Lincoln

foo_playcount_sql
Reply #7
1. Importing file based statistics (from official playcount) will be implemented for the next version.



Can you tell me how can I show the playcount statistics for Artist and Album in Album List, please?

Quote
2. rating_sql, i'll might add it in the future, but not for the next version.

If you will add it, will there be a possibility for statistic calculations (Rating (Artist), Rating (Album))?

I'm asking so penetrant cause this would be a killer feature.
  • Last Edit: 10 March, 2009, 10:21:20 AM by bubi jackson

  • Galleon
  • [*]
foo_playcount_sql
Reply #8
Yes, All libraries installed.
Code: [Select]
Illegal operation:
Code: E0434F4Dh, flags: 00000001h, address: 773942EBh
Call path:
entry=>initquit::on_init
Code bytes (773942EBh):
773942ABh:  C0 39 45 14 89 45 B8 C7 45 BC 93 42 39 77 0F 84
773942BBh:  A8 4F FD FF 8B 45 10 83 F8 0F 0F 87 70 25 02 00
773942CBh:  89 45 C0 C1 E0 02 50 FF 75 14 8D 45 C4 50 E8 D2
773942DBh:  80 00 00 83 C4 0C 8D 45 B0 50 FF 15 14 17 35 77
773942EBh:  C9 C2 10 00 90 90 90 90 90 6A 10 68 80 43 39 77
773942FBh:  E8 A0 7F 00 00 8B 45 0C 83 F8 F4 0F 84 6B 37 01
7739430Bh:  00 83 F8 F5 0F 84 4E 37 01 00 83 F8 F6 0F 84 31
7739431Bh:  37 01 00 83 65 0C 00 8B C8 81 E1 03 00 00 10 83
Stack (0022F494h):
0022F474h:  00000000 00000000 00000000 00000000
0022F484h:  00000000 00000000 00000000 00000000
0022F494h:  E0434F4D 00000001 00000000 773942EB
0022F4A4h:  00000001 80131501 02000038 0022F4C0
0022F4B4h:  6B870024 0022F4C8 02000038 0022F4CC
0022F4C4h:  6B870687 6A4D0BA0 0022F4DC 6B8CA76F
0022F4D4h:  12827B64 0000012F 0022F4EC 6B8CA796
0022F4E4h:  0022F544 6B8CA91C E0434F4D 00000001
0022F4F4h:  00000001 0022F51C DA82D51A 107AF5CC
0022F504h:  0CE91060 00000000 00133000 00041EBD
0022F514h:  00000001 0CE91060 80131501 0022F0A4
0022F524h:  00000001 00000001 0022F4FC 0022F0A4
0022F534h:  0022F5FC 6B9808A2 B12C8966 00000000
0022F544h:  0022F608 6B9A4868 107AF5CC 00000000
0022F554h:  00000000 DA82D656 107A9514 0022F664
0022F564h:  107A5E64 DA98F1EF 6B8620D0 FFFFFFFF
0022F574h:  00000000 00000001 0022F58C 00000000
0022F584h:  0CE91060 00000000 0022F55C 107A9514
0022F594h:  0022F560 0022F664 0022F564 107A5E64
0022F5A4h:  0022F608 0022F610 0022F610 0022F60C
Registers:
EAX: 0022F494, EBX: E0434F4D, ECX: 00000001, EDX: 00000000
ESI: 0022F51C, EDI: 0CE91060, EBP: 0022F4E4, ESP: 0022F494
Crash location: "kernel32", loaded at 77350000h - 7742B000h
Symbol: "RaiseException" (+00000058h)

Loaded modules:
foobar2000   loaded at 00A60000h - 00B9B000h
ntdll loaded at 77430000h - 77557000h
kernel32 loaded at 77350000h - 7742B000h
COMCTL32 loaded at 74A40000h - 74BDE000h
msvcrt   loaded at 762E0000h - 7638A000h
ADVAPI32 loaded at 76210000h - 762D6000h
RPCRT4   loaded at 76140000h - 76203000h
GDI32 loaded at 775C0000h - 7760B000h
USER32   loaded at 76670000h - 7670D000h
SHLWAPI   loaded at 77560000h - 775B8000h
SHELL32   loaded at 76710000h - 7721F000h
ole32 loaded at 763C0000h - 76504000h
shared   loaded at 10000000h - 1002A000h
UxTheme   loaded at 747E0000h - 7481F000h
COMDLG32 loaded at 76560000h - 765D3000h
IMM32 loaded at 76110000h - 7612E000h
MSCTF loaded at 75D40000h - 75E08000h
LPK   loaded at 76130000h - 76139000h
USP10 loaded at 77610000h - 7768D000h
foo_cwbowron loaded at 00290000h - 002BA000h
gdiplus   loaded at 74170000h - 7431B000h
foo_cdda loaded at 00970000h - 009B0000h
foo_scrobblecharts   loaded at 009B0000h - 009E3000h
WININET   loaded at 75E10000h - 75EDF000h
Normaliz loaded at 76070000h - 76073000h
iertutil loaded at 760C0000h - 76105000h
foo_dockable_panels   loaded at 009F0000h - 00A23000h
foo_uie_playlists_dropdown   loaded at 01C40000h - 01C79000h
foo_lastfm_radio loaded at 01C80000h - 01CC5000h
foo_uie_graphical_browser loaded at 6C2E0000h - 6C374000h
MSIMG32   loaded at 749C0000h - 749C5000h
foo_exvar loaded at 01D10000h - 01D38000h
foo_audioscrobbler   loaded at 01D40000h - 01D70000h
WS2_32   loaded at 76390000h - 763BD000h
NSI   loaded at 76080000h - 76086000h
foo_converter loaded at 01E30000h - 01E9C000h
foo_playlist_manager loaded at 02000000h - 02044000h
foo_playback_custom   loaded at 02160000h - 021A5000h
WINSPOOL loaded at 735D0000h - 73612000h
OLEAUT32 loaded at 765E0000h - 7666D000h
foo_runcmd   loaded at 01EA0000h - 01ED4000h
foo_uie_vis_peakmeter_spectrum  loaded at 022D0000h - 0230F000h
foo_comserver2   loaded at 024F0000h - 02546000h
foo_uie_albumart loaded at 025E0000h - 0261D000h
foo_albumlist loaded at 02620000h - 0268B000h
foo_uie_explorer loaded at 027D0000h - 0281E000h
CLBCatQ   loaded at 75CB0000h - 75D34000h
WindowsCodecs loaded at 73C90000h - 73D43000h
apphelp   loaded at 75AE0000h - 75B0C000h
cscui loaded at 72230000h - 722C5000h
PROPSYS   loaded at 746C0000h - 7477A000h
CSCDLL   loaded at 72330000h - 72339000h
CSCAPI   loaded at 73050000h - 7305B000h
foo_dbsearch_api_demo loaded at 028A0000h - 028C1000h
foo_uie_tabs loaded at 028E0000h - 02908000h
foo_masstag   loaded at 02C80000h - 02CC3000h
foo_dsp_bs2b loaded at 6F1B0000h - 6F1D0000h
foo_dbsearch loaded at 02CD0000h - 02D40000h
foo_uie_lyrics   loaded at 02D40000h - 02D9D000h
WINMM loaded at 73F20000h - 73F52000h
OLEACC   loaded at 73EE0000h - 73F19000h
foo_rgscan   loaded at 02DB0000h - 02E0B000h
foo_menu_addons   loaded at 02F50000h - 02F8C000h
foo_facets   loaded at 03250000h - 032D1000h
foo_uie_elplaylist   loaded at 02FB0000h - 03019000h
foo_uie_vis_channel_spectrum loaded at 03140000h - 0317D000h
foo_uie_albumlist loaded at 031C0000h - 031FD000h
foo_chronflow loaded at 032E0000h - 03341000h
OPENGL32 loaded at 6DC20000h - 6DCEB000h
GLU32 loaded at 6F0C0000h - 6F0E3000h
DDRAW loaded at 68EF0000h - 68FD5000h
DCIMAN32 loaded at 73FA0000h - 73FA6000h
SETUPAPI loaded at 75EE0000h - 7606A000h
dwmapi   loaded at 72FC0000h - 72FCC000h
foo_dsp_std   loaded at 03490000h - 034D8000h
foo_playcount_sql loaded at 6F190000h - 6F1AF000h
mscoree   loaded at 6F6B0000h - 6F6F6000h
MSVCP90   loaded at 6CE10000h - 6CE9E000h
MSVCR90   loaded at 6BFB0000h - 6C053000h
msvcm90   loaded at 6DB90000h - 6DBD3000h
foo_uie_panel_splitter   loaded at 034E0000h - 0352F000h
foo_uie_quicksearch   loaded at 036C0000h - 03706000h
foo_run   loaded at 03720000h - 0374E000h
foo_ui_columns   loaded at 03CF0000h - 03E56000h
foo_browser   loaded at 03760000h - 03799000h
foo_lyricsgrabber loaded at 6C280000h - 6C2D2000h
foo_skip loaded at 6FEF0000h - 6FF0D000h
foo_winamp_spam   loaded at 03800000h - 03830000h
foo_uie_trackinfo loaded at 03830000h - 03855000h
foo_input_std loaded at 042C0000h - 04400000h
foo_utils loaded at 6CCB0000h - 6CCF4000h
foo_ui_std   loaded at 04080000h - 04154000h
foo_uie_trackinfo_mod loaded at 03950000h - 039A6000h
MSVCP80   loaded at 6CB50000h - 6CBD7000h
MSVCR80   loaded at 6CAB0000h - 6CB4B000h
foo_uie_wsh_panel loaded at 6CFF0000h - 6D01F000h
pshook.dll   loaded at 038F0000h - 038F8000h
SXS   loaded at 75A20000h - 75A7F000h
jscript   loaded at 691B0000h - 6922D000h
rsaenh   loaded at 75240000h - 7527B000h
mscorwks loaded at 6B860000h - 6BDF0000h
mscorlib.ni   loaded at 6A260000h - 6AD57000h
mscorjit loaded at 6CEA0000h - 6CEFB000h
mscorsec loaded at 64020000h - 64033000h
WINTRUST loaded at 74BF0000h - 74C1D000h
CRYPT32   loaded at 755F0000h - 756E1000h
MSASN1   loaded at 75770000h - 75782000h
USERENV   loaded at 75B60000h - 75B7E000h
Secur32   loaded at 75B40000h - 75B54000h
imagehlp loaded at 76090000h - 760B9000h
psapi loaded at 75C10000h - 75C17000h
ncrypt   loaded at 75470000h - 754A5000h
BCRYPT   loaded at 75420000h - 75465000h
NTMARTA   loaded at 75010000h - 75031000h
WLDAP32   loaded at 76510000h - 7655A000h
SAMLIB   loaded at 75A90000h - 75AA1000h
GPAPI loaded at 75280000h - 75295000h
slc   loaded at 755B0000h - 755EA000h
cryptnet loaded at 6F160000h - 6F17B000h
SensApi   loaded at 733F0000h - 733F6000h
NETAPI32 loaded at 757E0000h - 75855000h
Cabinet   loaded at 74E40000h - 74E55000h
System.Data.SqlServerCe   loaded at 69260000h - 692A4000h
System.ni loaded at 69AD0000h - 6A255000h
System.Data.ni   loaded at 66140000h - 66792000h
System.Data   loaded at 64E70000h - 65144000h
System.Transactions.ni   loaded at 67500000h - 6759C000h
System.Transactions   loaded at 67AA0000h - 67AE3000h
sqlceme35 loaded at 7D350000h - 7D360000h
sqlceer35RU   loaded at 12C30000h - 12C57000h
sqlcese35 loaded at 7D550000h - 7D5A8000h
dbghelp   loaded at 725A0000h - 7267C000h

Stack dump analysis:
Address: 773942EBh, location: "kernel32", loaded at 77350000h - 7742B000h
Symbol: "RaiseException" (+00000058h)
Address: 6B870024h, location: "mscorwks", loaded at 6B860000h - 6BDF0000h
Symbol: "DllUnregisterServerInternal" (+00004008h)
Address: 6B870687h, location: "mscorwks", loaded at 6B860000h - 6BDF0000h
Symbol: "DllUnregisterServerInternal" (+0000466Bh)
Address: 6A4D0BA0h, location: "mscorlib.ni", loaded at 6A260000h - 6AD57000h
Address: 6B8CA76Fh, location: "mscorwks", loaded at 6B860000h - 6BDF0000h
Symbol: "GetMetaDataInternalInterface" (+000082FCh)
Address: 6B8CA796h, location: "mscorwks", loaded at 6B860000h - 6BDF0000h
Symbol: "GetMetaDataInternalInterface" (+00008323h)
Address: 6B8CA91Ch, location: "mscorwks", loaded at 6B860000h - 6BDF0000h
Symbol: "GetMetaDataInternalInterface" (+000084A9h)
Address: 6B9808A2h, location: "mscorwks", loaded at 6B860000h - 6BDF0000h
Symbol: "CreateApplicationContext" (+0000A4C2h)
Address: 6B9A4868h, location: "mscorwks", loaded at 6B860000h - 6BDF0000h
Symbol: "StrongNameErrorInfo" (+000103DCh)
Address: 6B8620D0h, location: "mscorwks", loaded at 6B860000h - 6BDF0000h
Address: 6B9A47BDh, location: "mscorwks", loaded at 6B860000h - 6BDF0000h
Symbol: "StrongNameErrorInfo" (+00010331h)
Address: 6B9A4869h, location: "mscorwks", loaded at 6B860000h - 6BDF0000h
Symbol: "StrongNameErrorInfo" (+000103DDh)
Address: 6BD0A330h, location: "mscorwks", loaded at 6B860000h - 6BDF0000h
Symbol: "GetHistoryFileDirectory" (+0005792Ch)
Address: 6B869D00h, location: "mscorwks", loaded at 6B860000h - 6BDF0000h
Address: 6B86F6F2h, location: "mscorwks", loaded at 6B860000h - 6BDF0000h
Symbol: "DllUnregisterServerInternal" (+000036D6h)
Address: 6B87759Bh, location: "mscorwks", loaded at 6B860000h - 6BDF0000h
Symbol: "DllUnregisterServerInternal" (+0000B57Fh)
Address: 77495883h, location: "ntdll", loaded at 77430000h - 77557000h
Symbol: "RtlFreeHeap" (+0000007Ah)
Address: 7739C56Fh, location: "kernel32", loaded at 77350000h - 7742B000h
Symbol: "HeapFree" (+00000014h)
Address: 6B86A186h, location: "mscorwks", loaded at 6B860000h - 6BDF0000h
Address: 6B86A1A2h, location: "mscorwks", loaded at 6B860000h - 6BDF0000h
Address: 6BD2AA20h, location: "mscorwks", loaded at 6B860000h - 6BDF0000h
Symbol: "GetHistoryFileDirectory" (+0007801Ch)
Address: 6B86A1A2h, location: "mscorwks", loaded at 6B860000h - 6BDF0000h
Address: 6B86A1C1h, location: "mscorwks", loaded at 6B860000h - 6BDF0000h
Address: 6B86A14Ah, location: "mscorwks", loaded at 6B860000h - 6BDF0000h
Address: 6B86A15Bh, location: "mscorwks", loaded at 6B860000h - 6BDF0000h
Address: 6BD516E8h, location: "mscorwks", loaded at 6B860000h - 6BDF0000h
Symbol: "GetHistoryFileDirectory" (+0009ECE4h)
Address: 6B86A15Bh, location: "mscorwks", loaded at 6B860000h - 6BDF0000h
Address: 6B878C8Ah, location: "mscorwks", loaded at 6B860000h - 6BDF0000h
Symbol: "DllUnregisterServerInternal" (+0000CC6Eh)
Address: 6B877251h, location: "mscorwks", loaded at 6B860000h - 6BDF0000h
Symbol: "DllUnregisterServerInternal" (+0000B235h)
Address: 6B87B51Ch, location: "mscorwks", loaded at 6B860000h - 6BDF0000h
Symbol: "DllUnregisterServerInternal" (+0000F500h)
Address: 6B871220h, location: "mscorwks", loaded at 6B860000h - 6BDF0000h
Symbol: "DllUnregisterServerInternal" (+00005204h)
Address: 6B871235h, location: "mscorwks", loaded at 6B860000h - 6BDF0000h
Symbol: "DllUnregisterServerInternal" (+00005219h)
Address: 6B87139Ch, location: "mscorwks", loaded at 6B860000h - 6BDF0000h
Symbol: "DllUnregisterServerInternal" (+00005380h)
Address: 6B8713A4h, location: "mscorwks", loaded at 6B860000h - 6BDF0000h
Symbol: "DllUnregisterServerInternal" (+00005388h)
Address: 6B8CEF78h, location: "mscorwks", loaded at 6B860000h - 6BDF0000h
Symbol: "GetMetaDataInternalInterface" (+0000CB05h)
Address: 6B8713A4h, location: "mscorwks", loaded at 6B860000h - 6BDF0000h
Symbol: "DllUnregisterServerInternal" (+00005388h)
Address: 6B9FA2E7h, location: "mscorwks", loaded at 6B860000h - 6BDF0000h
Symbol: "Ordinal24" (+000031ACh)
Address: 6F191513h, location: "foo_playcount_sql", loaded at 6F190000h - 6F1AF000h
Address: 6F19B48Dh, location: "foo_playcount_sql", loaded at 6F190000h - 6F1AF000h
Symbol: "foobar2000_get_interface" (+0000414Dh)
Address: 6F1952FDh, location: "foo_playcount_sql", loaded at 6F190000h - 6F1AF000h
Address: 6F19B57Bh, location: "foo_playcount_sql", loaded at 6F190000h - 6F1AF000h
Symbol: "foobar2000_get_interface" (+0000423Bh)
Address: 00A9A2CDh, location: "foobar2000", loaded at 00A60000h - 00B9B000h
Address: 00B39D8Bh, location: "foobar2000", loaded at 00A60000h - 00B9B000h
Address: 00B4A0D4h, location: "foobar2000", loaded at 00A60000h - 00B9B000h
Address: 6F1AA0C4h, location: "foo_playcount_sql", loaded at 6F190000h - 6F1AF000h
Symbol: "foobar2000_get_interface" (+00012D84h)
Address: 00A9A293h, location: "foobar2000", loaded at 00A60000h - 00B9B000h
Address: 00B229B2h, location: "foobar2000", loaded at 00A60000h - 00B9B000h
Address: 00A9B0FAh, location: "foobar2000", loaded at 00A60000h - 00B9B000h
Address: 77550501h, location: "ntdll", loaded at 77430000h - 77557000h
Symbol: "fltused" (+000571F5h)
Address: 00B39DF4h, location: "foobar2000", loaded at 00A60000h - 00B9B000h
Address: 00B4A0D4h, location: "foobar2000", loaded at 00A60000h - 00B9B000h
Address: 77495B87h, location: "ntdll", loaded at 77430000h - 77557000h
Symbol: "RtlAllocateHeap" (+000002E1h)
Address: 77495955h, location: "ntdll", loaded at 77430000h - 77557000h
Symbol: "RtlAllocateHeap" (+000000AFh)
Address: 00B4A0D4h, location: "foobar2000", loaded at 00A60000h - 00B9B000h
Address: 00A60000h, location: "foobar2000", loaded at 00A60000h - 00B9B000h
Address: 77490001h, location: "ntdll", loaded at 77430000h - 77557000h
Symbol: "RtlDeactivateActivationContextUnsafeFast" (+00005F10h)
Address: 00A6B8E2h, location: "foobar2000", loaded at 00A60000h - 00B9B000h
Address: 00A65194h, location: "foobar2000", loaded at 00A60000h - 00B9B000h
Address: 00B16FB3h, location: "foobar2000", loaded at 00A60000h - 00B9B000h
Address: 00B11650h, location: "foobar2000", loaded at 00A60000h - 00B9B000h
Address: 00B16FB3h, location: "foobar2000", loaded at 00A60000h - 00B9B000h
Address: 00B15408h, location: "foobar2000", loaded at 00A60000h - 00B9B000h
Address: 03000300h, location: "foo_uie_elplaylist", loaded at 02FB0000h - 03019000h
Symbol: "foobar2000_get_interface" (+0003CAF0h)
Address: 1000258Fh, location: "shared", loaded at 10000000h - 1002A000h
Symbol: "uPrintCrashInfo_SetDumpPath" (+000000C8h)
Address: 00B4075Ch, location: "foobar2000", loaded at 00A60000h - 00B9B000h
Address: 00B2B0C1h, location: "foobar2000", loaded at 00A60000h - 00B9B000h
Address: 00B4075Ch, location: "foobar2000", loaded at 00A60000h - 00B9B000h
Address: 00A9B426h, location: "foobar2000", loaded at 00A60000h - 00B9B000h
Address: 00A60000h, location: "foobar2000", loaded at 00A60000h - 00B9B000h
Address: 00B0F9C1h, location: "foobar2000", loaded at 00A60000h - 00B9B000h
Address: 00B0F9BBh, location: "foobar2000", loaded at 00A60000h - 00B9B000h
Address: 00B31BC0h, location: "foobar2000", loaded at 00A60000h - 00B9B000h
Address: 00B2FD20h, location: "foobar2000", loaded at 00A60000h - 00B9B000h
Address: 00B11650h, location: "foobar2000", loaded at 00A60000h - 00B9B000h
Address: 00B0F9BBh, location: "foobar2000", loaded at 00A60000h - 00B9B000h
Address: 00B0F9CFh, location: "foobar2000", loaded at 00A60000h - 00B9B000h
Address: 00B2FD20h, location: "foobar2000", loaded at 00A60000h - 00B9B000h
Address: 00B2B24Dh, location: "foobar2000", loaded at 00A60000h - 00B9B000h
Address: 00B1151Ah, location: "foobar2000", loaded at 00A60000h - 00B9B000h
Address: 00A60000h, location: "foobar2000", loaded at 00A60000h - 00B9B000h
Address: 00B19446h, location: "foobar2000", loaded at 00A60000h - 00B9B000h
Address: 00B11650h, location: "foobar2000", loaded at 00A60000h - 00B9B000h
Address: 77394911h, location: "kernel32", loaded at 77350000h - 7742B000h
Symbol: "BaseThreadInitThunk" (+00000012h)
Address: 7746E4B6h, location: "ntdll", loaded at 77430000h - 77557000h
Symbol: "RtlInitializeExceptionChain" (+00000063h)
Address: 77550329h, location: "ntdll", loaded at 77430000h - 77557000h
Symbol: "fltused" (+0005701Dh)
Address: 773EF389h, location: "kernel32", loaded at 77350000h - 7742B000h
Symbol: "UnhandledExceptionFilter" (+00000000h)
Address: 773EF389h, location: "kernel32", loaded at 77350000h - 7742B000h
Symbol: "UnhandledExceptionFilter" (+00000000h)
Address: 77439834h, location: "ntdll", loaded at 77430000h - 77557000h
Symbol: "RtlUpdateTimer" (+00000605h)
Address: 7746E489h, location: "ntdll", loaded at 77430000h - 77557000h
Symbol: "RtlInitializeExceptionChain" (+00000036h)
Address: 00B11585h, location: "foobar2000", loaded at 00A60000h - 00B9B000h
Address: 00B11585h, location: "foobar2000", loaded at 00A60000h - 00B9B000h

Version info:
foobar2000 v0.9.6.3
UNICODE
Windows 6.0


Additional info:
Startup Actions 0.0.2 [Jul 23 2007 - 08:27:55]  (foo_cwbowron)
foobar2000 core 0.9.6.3  (Core)
Audioscrobbler 1.3.16  (foo_audioscrobbler)
Chronial's Coverflow 0.3.0  (foo_chronflow)
Run services 0.3.4  (foo_run)
Album Art Browser 0.0.5 [Jul 23 2007 - 08:27:55]  (foo_cwbowron)
Playback statistics SQL 1.0.0.0  (foo_playcount_sql)
Standard Input Array 1.0  (foo_input_std)
CD Audio Decoder 2.1.4  (foo_cdda)
Tabbed Panel Modified 0.2.7  (foo_uie_tabs)
Album Art Panel 0.2.7.1  (foo_uie_albumart)
Winamp API Emulator 0.96  (foo_winamp_spam)
Run Command 1.0 beta 3  (foo_runcmd)
COM Automation server 0.7 alpha 6  (foo_comserver2)
Skip Track 0.4  (foo_skip)
Masstagger 1.7.1  (foo_masstag)
Database Search 1.4  (foo_dbsearch)
ELPlaylist 0.6.4.2(beta)  (foo_uie_elplaylist)
Columns UI 0.3.6.7  (foo_ui_columns)
Track info panel 0.8  (foo_uie_trackinfo)
Converter 1.2  (foo_converter)
Explorer Tree 1.04.7b  (foo_uie_explorer)
Extended Variables 0.3.1  (foo_exvar)
bs2b 2.1.1  (foo_dsp_bs2b)
Track info panel mod 0.8.0 beta [Jan  5 2007 - 13:36:12]  (foo_uie_trackinfo_mod)
Facets 2008-02-25  (foo_facets)
Album List 4.3  (foo_albumlist)
Lyric Show Panel 0.3.3.9 [Dec 12 2008 - 17:39:01]  (foo_uie_lyrics)
Dockable Panels 1.0.7b [Mar 28 2007 - 09:18:48]  (foo_dockable_panels)
Quick Search Toolbar 2.8l  (foo_uie_quicksearch)
Music Browser 1.2.3b [Mar 23 2007 - 16:52:56]  (foo_browser)
Album list panel 0.3.3  (foo_uie_albumlist)
Graphical Browser rev015  (foo_uie_graphical_browser)
Database Search Toolbar Demo 1.0  (foo_dbsearch_api_demo)
Channel Spectrum panel 0.17.2  (foo_uie_vis_channel_spectrum)
Last.fm Radio 0.5.2  (foo_lastfm_radio)
Last.fm Chart Player 0.2.3  (foo_scrobblecharts)
Playlist Manager 1.0.2  (foo_playlist_manager)
ReplayGain Scanner 2.0.8  (foo_rgscan)
WSH Panel (uie) 0.7.2  (foo_uie_wsh_panel)
Panel Stack Splitter 0.3.6.2(alpha)  (foo_uie_panel_splitter)
Playback Statistics Custom 1.4.3  (foo_playback_custom)
Menu Addons 0.4.1 (SSE)  (foo_menu_addons)
Standard DSP Array 1.0  (foo_dsp_std)
Playlist Tools 0.6.2 beta 6  (foo_utils)
Peakmeter Spectrum Visualisation 0.2.0.0 beta  (foo_uie_vis_peakmeter_spectrum)
Playlists Dropdown 0.6 alpha 4  (foo_uie_playlists_dropdown)
Default User Interface 0.9.5  (foo_ui_std)
Lyrics Grabber 0.2.6.2 Beta  (foo_lyricsgrabber)
  • Last Edit: 10 March, 2009, 10:23:56 AM by Canar

  • wojtek
  • [*][*][*][*]
foo_playcount_sql
Reply #9
1. An option to import playback / rating data from file tags? (and maybe sync it back to files, i know it would take more resources)
2. Option to identify separate files as one with only same artist/title (i.e. on different albums/compilations/soundtracks)

Basically - ability to sync playback/rating data between many files, and those data don't necesery need to be generated by foo_playcount_sql, I'm ok with foo_playback_custom. But if there would be some sort of configuration and ability to save data *also* to files I won't mind dropping playback_custom (;
http://foobar2000.pl/ :: unofficial polish forum

  • odyssey
  • [*][*][*][*][*]
foo_playcount_sql
Reply #10
maybe you will use FooID, Song fingerprinting, than unique combinations of artist/album/title items 

My thought EXACTLY!

Edit/Add: You could probably rely on musicmusic's foo_biometric (that uses fooID and stores it in %FINGERPRINT_FOOID%)

I have MANY dupes in my library for different reasons - Songs in albums also present on soundtracks, singles or compilations. A playcount should (IMO) count on any song that matches regardless of it being an album version/radio edit or even extended cut.
  • Last Edit: 10 March, 2009, 05:43:39 PM by odyssey
Can't wait for a HD-AAC encoder :P

  • odyssey
  • [*][*][*][*][*]
foo_playcount_sql
Reply #11
Why do you rely on a full blown SQL database? There are more lightweight solutions available, like SQLite - A file-based SQL database that requires no installation at all. That would probably also be more in faith to the general foobar2000 terminology.
Can't wait for a HD-AAC encoder :P

  • jsheridan
  • [*][*][*]
  • Developer
foo_playcount_sql
Reply #12
@odyssey :
SQL because, it will allow me to easily access the data from outside utilities, and since relational data is cool.
SqlServerCe was chosen because of great .NET integration tools, and it’s as light weight as SQLite is.

About finger printing, again ATM it doesn't interest me to implement some heuristic method of tracking music, but it might in the future, which in that case, I’ll support it.

@lwiczek:
Import is coming, since it’s easy to implement, and makes sense. Export to files does not make sense, since it will change the actual files whenever a track is played.

The option to use only artist/title (-album) might make sense, and might not (when a different version of the song is played with the same name), for simplicity I choose the 3 keys combo, and it’s not likely to change.

@Galleon:
This crash has also been reported from another user (and other similar cases from other .NET based foobar components) it has something to do with the .NET initialization that happens when I try to initialize the DB. Currently I have no solution for it, since I don't know why that happens. Will try to research it more when I’ll have more time...

@bubi jackson:
You can't observe the artist / album statistics from the Album list since it’s not preserved per track, and calculated dynamically from the SQL Data. I'll test adding %play_count_artist_sql% (and similar tags), and see if it doesn't affect performance too much, and then you'll be able to use it from that context.

As for rating statistics, once I’ll add rating support, rating statistics will follow, but it’s not at high priority atm.
You can fool some of the people all of the time, and all of the people some of the time, but you can not fool all of the people all of the time.

- Abraham Lincoln

foo_playcount_sql
Reply #13
@bubi jackson:
You can't observe the artist / album statistics from the Album list since it's not preserved per track, and calculated dynamically from the SQL Data. I'll test adding %play_count_artist_sql% (and similar tags), and see if it doesn't affect performance too much, and then you'll be able to use it from that context.

Thx

I already tried it with _artist_sql and album_sql -  would be a nice feature too.

Quote
As for rating statistics, once I'll add rating support, rating statistics will follow, but it's not at high priority atm.


  • odyssey
  • [*][*][*][*][*]
foo_playcount_sql
Reply #14
@odyssey :
SQL because, it will allow me to easily access the data from outside utilities, and since relational data is cool.
SqlServerCe was chosen because of great .NET integration tools, and it’s as light weight as SQLite is.

SQLite is still relational SQL, and I perfectly agree with you that it's really cool! However, since it needs to be installed, it's not very portable which is a shame.

About finger printing, again ATM it doesn't interest me to implement some heuristic method of tracking music, but it might in the future, which in that case, I’ll support it.

Why is it of no interrest? I think it's pretty cool to have a better way of determining equal tracks, and since it's already implemented as a library, integration should be easy. You don't have to re-invent the wheel

As for rating statistics, once I’ll add rating support, rating statistics will follow, but it’s not at high priority atm.

A general tag-syncronizing feature that allows user definable tags would be cool. Why limit to playback statistics?
Can't wait for a HD-AAC encoder :P

  • knuck
  • [*]
foo_playcount_sql
Reply #15
Nice. How hard would it be to get it to work with MySQL?

  • shakey_snake
  • [*][*][*][*][*]
  • Moderator
foo_playcount_sql
Reply #16
So how are multiple artists handled, displayed?
elevatorladylevitateme

  • carpman
  • [*][*][*][*][*]
  • Developer
foo_playcount_sql
Reply #17
Glad there's a new playcount component, hopefully it may remedy some of the shortfalls of the official one (i.e. counting a 30 min song played when it has been played for just 1 minute).

Couple of points/suggestions:

1) I agree with Odyssey's post on heuristics and SQLite.
2) If you change the tags would you lose the play stats?
3) How does your component decide when a song is played, i.e. (hopefully) by % played (user defined x %), or is it by some other means?

C.

PC = TAK + LossyWAV  ::  Portable = Lame MP3

  • wojtek
  • [*][*][*][*]
foo_playcount_sql
Reply #18
Quote
Import is coming, since it’s easy to implement, and makes sense. Export to files does not make sense, since it will change the actual files whenever a track is played.


As I said before - I'm currently using foo_playback_custom which is doing exactly that, i.e. writing data to file every time specific amount of song (configurable) has been played. I prefer to have as much of the data in tags because of portability reasons and I'm the only one using those files so there is no need for separate statistics for several persons.

Quote
The option to use only artist/title (-album) might make sense, and might not (when a different version of the song is played with the same name), for simplicity I choose the 3 keys combo, and it’s not likely to change.


OK, I can agree that there might be differences between songs on different albums, but in my case (i know, sooooo egocentric (; ) when there is a case of doubled track in 99% of cases it's the same song just on (yet another) soundtrack.

Again - an configuration with options to set: album to discern tracks, to set amount of song for updating info and a yes/no option to sync data back to tags would be soooooooooo great! (;
http://foobar2000.pl/ :: unofficial polish forum

  • jsheridan
  • [*][*][*]
  • Developer
foo_playcount_sql
Reply #19
Version 1.1 posted, should solve the crash described by Galleon

The .NET Framework is no longer required for this plugin
You can fool some of the people all of the time, and all of the people some of the time, but you can not fool all of the people all of the time.

- Abraham Lincoln

  • jsheridan
  • [*][*][*]
  • Developer
foo_playcount_sql
Reply #20
@ odyssey
1. Sorry, but I’m not going to rewrite in SQLite
2. As for foo_id, again, i want to keep it simple, and based on Meta data (for now)

@ knuck
1. MySQL Support, maybe in the future.

@ shakey_snake
1. Multiple artists/artists/etc are handled for simplicity case with "Artist1, Artist2", it would be complicated to index the database any other way.

@ carpman
1. If you change the tags, you will get new stats (old ones are not erased), since that won't happen too often like moving the files physically, that won't be such a big issue.
2. The foo_playstat_sql decides when a track is played the same way as the official component does, and i quote: "Notification occurs when at least 60s of the track has been played, or the track has reached its end after at least 1/3 of it has been played through"
You can fool some of the people all of the time, and all of the people some of the time, but you can not fool all of the people all of the time.

- Abraham Lincoln

  • Galleon
  • [*]
foo_playcount_sql
Reply #21
Version 1.1 posted, should solve the crash described by Galleon

The .NET Framework is no longer required for this plugin
I'm still have same error 
Code: [Select]
 Illegal operation:
Code: C0000005h, flags: 00000000h, address: 6DC71ED4h
Access violation, operation: read, address: 00000000h
Call path:
entry=>initquit::on_init
Code bytes (6DC71ED4h):
6DC71E94h:  FF 68 08 C6 C7 6D 64 A1 00 00 00 00 50 83 EC 50
6DC71EA4h:  53 56 57 A1 1C 20 C8 6D 33 C5 50 8D 45 F4 64 A3
6DC71EB4h:  00 00 00 00 89 65 F0 8B F1 8D 45 A4 50 E8 3A F1
6DC71EC4h:  FF FF C7 45 FC 00 00 00 00 C6 45 FC 01 8B 4E 0C
6DC71ED4h:  8B 11 8B 52 04 8D 45 A4 50 FF D2 8D 46 58 50 8D
6DC71EE4h:  4D BC 51 E8 54 FD FF FF 8D 56 10 52 8D 45 A4 50
6DC71EF4h:  E8 47 FD FF FF 81 C6 A0 00 00 00 56 8D 4D D4 51
6DC71F04h:  E8 37 FD FF FF 8D 5D A4 E8 4F F1 FF FF 8B 4D F4
Stack (0020FA24h):
0020FA04h:  00000000 00000000 00000000 00000000
0020FA14h:  00000000 00000000 00000000 00000000
0020FA24h:  3D685365 6DC80DA0 03571D50 00000000
0020FA34h:  035710F0 002F003A 0044002F 00000000
0020FA44h:  00000000 00000000 03571100 0420040E
0020FA54h:  042000B1 00000000 00000000 00000000
0020FA64h:  03571110 006F0046 0062006F 00000000
0020FA74h:  00000000 00000000 6DC70000 0020FA24
0020FA84h:  0020FAB8 6DC7C608 00000001 0020FAC4
0020FA94h:  6DC7197B 3D685331 0020FAFC 0020FB84
0020FAA4h:  00000000 0020F2C4 03746FD8 00A53B58
0020FAB4h:  0020FA98 0020FAD8 6DC7C748 00000004
0020FAC4h:  0020FB10 6DC78FAD 03571D50 3D685321
0020FAD4h:  03571D50 0020FB04 6DC7C7CB 00000000
0020FAE4h:  0036A2CD 00409D8B 0041A0D4 00000018
0020FAF4h:  01A93D80 00000005 6DC820FC 0036A293
0020FB04h:  0020FC3C 003F29B2 00000001 0020FC4C
0020FB14h:  0036B0FA FFFFFFFE 00000000 00000000
0020FB24h:  00495955 01A80300 0000001A 00000000
0020FB34h:  7280D701 00409DF4 00000000 00000000
Registers:
EAX: 0020FA34, EBX: 00000000, ECX: 00000000, EDX: 03560048
ESI: 03571D50, EDI: 6DC80DA0, EBP: 0020FA90, ESP: 0020FA24
Crash location: "foo_playcount_sql", loaded at 6DC70000h - 6DC86000h

Loaded modules:
foobar2000                      loaded at 00330000h - 0046B000h
ntdll                            loaded at 77430000h - 77557000h
kernel32                        loaded at 77350000h - 7742B000h
COMCTL32                        loaded at 74A40000h - 74BDE000h
msvcrt                          loaded at 762E0000h - 7638A000h
ADVAPI32                        loaded at 76210000h - 762D6000h
RPCRT4                          loaded at 76140000h - 76203000h
GDI32                            loaded at 775C0000h - 7760B000h
USER32                          loaded at 76670000h - 7670D000h
SHLWAPI                          loaded at 77560000h - 775B8000h
SHELL32                          loaded at 76710000h - 7721F000h
ole32                            loaded at 763C0000h - 76504000h
shared                          loaded at 10000000h - 1002A000h
UxTheme                          loaded at 747E0000h - 7481F000h
COMDLG32                        loaded at 76560000h - 765D3000h
IMM32                            loaded at 76110000h - 7612E000h
MSCTF                            loaded at 75D40000h - 75E08000h
LPK                              loaded at 76130000h - 76139000h
USP10                            loaded at 77610000h - 7768D000h
foo_ui_columns                  loaded at 01D80000h - 01EE6000h
gdiplus                          loaded at 74170000h - 7431B000h
foo_lastfm_radio                loaded at 002E0000h - 00325000h
foo_uie_graphical_browser        loaded at 6D6A0000h - 6D734000h
MSIMG32                          loaded at 749C0000h - 749C5000h
foo_run                          loaded at 000E0000h - 0010E000h
foo_dbsearch                    loaded at 01C10000h - 01C80000h
OLEAUT32                        loaded at 765E0000h - 7666D000h
foo_uie_quicksearch              loaded at 01B80000h - 01BC6000h
foo_dbsearch_api_demo            loaded at 01C80000h - 01CA1000h
foo_input_std                    loaded at 02630000h - 02770000h
foo_ui_std                      loaded at 02540000h - 02614000h
foo_audioscrobbler              loaded at 01CF0000h - 01D20000h
WS2_32                          loaded at 76390000h - 763BD000h
NSI                              loaded at 76080000h - 76086000h
foo_uie_albumart                loaded at 01D30000h - 01D6D000h
foo_cdda                        loaded at 01F00000h - 01F40000h
foo_playlist_manager            loaded at 021A0000h - 021E4000h
foo_uie_lyrics                  loaded at 02260000h - 022BD000h
WINMM                            loaded at 73F20000h - 73F52000h
OLEACC                          loaded at 73EE0000h - 73F19000h
WININET                          loaded at 75E10000h - 75EDF000h
Normaliz                        loaded at 76070000h - 76073000h
iertutil                        loaded at 760C0000h - 76105000h
foo_dsp_bs2b                    loaded at 6DC90000h - 6DCB0000h
foo_uie_elplaylist              loaded at 02770000h - 027D9000h
foo_uie_panel_splitter          loaded at 02910000h - 0295F000h
foo_uie_vis_peakmeter_spectrum  loaded at 02960000h - 0299F000h
foo_uie_vis_channel_spectrum    loaded at 02A10000h - 02A4D000h
foo_uie_playlists_dropdown      loaded at 02A50000h - 02A89000h
foo_albumlist                    loaded at 02DB0000h - 02E1B000h
foo_scrobblecharts              loaded at 02D40000h - 02D73000h
foo_uie_trackinfo                loaded at 029A0000h - 029C5000h
foo_facets                      loaded at 02E30000h - 02EB1000h
foo_converter                    loaded at 02F10000h - 02F7C000h
foo_winamp_spam                  loaded at 02AD0000h - 02B00000h
foo_runcmd                      loaded at 02EC0000h - 02EF4000h
foo_playcount_sql                loaded at 6DC70000h - 6DC86000h
MSVCP90                          loaded at 6DAE0000h - 6DB6E000h
MSVCR90                          loaded at 6D9F0000h - 6DA93000h
foo_uie_albumlist                loaded at 02F90000h - 02FCD000h
foo_exvar                        loaded at 02FD0000h - 02FF8000h
foo_uie_wsh_panel                loaded at 6D990000h - 6D9BF000h
foo_uie_trackinfo_mod            loaded at 03310000h - 03366000h
MSVCP80                          loaded at 6CB50000h - 6CBD7000h
MSVCR80                          loaded at 6CAB0000h - 6CB4B000h
foo_uie_explorer                loaded at 03390000h - 033DE000h
CLBCatQ                          loaded at 75CB0000h - 75D34000h
WindowsCodecs                    loaded at 73C90000h - 73D43000h
apphelp                          loaded at 75AE0000h - 75B0C000h
cscui                            loaded at 72230000h - 722C5000h
PROPSYS                          loaded at 746C0000h - 7477A000h
CSCDLL                          loaded at 72330000h - 72339000h
CSCAPI                          loaded at 73050000h - 7305B000h
foo_rgscan                      loaded at 034B0000h - 0350B000h
foo_uie_tabs                    loaded at 03470000h - 03498000h
foo_dockable_panels              loaded at 03660000h - 03693000h
foo_lyricsgrabber                loaded at 6D5E0000h - 6D632000h
foo_skip                        loaded at 6DC50000h - 6DC6D000h
foo_cwbowron                    loaded at 036C0000h - 036EA000h
foo_comserver2                  loaded at 03750000h - 037A6000h
foo_chronflow                    loaded at 03950000h - 039B1000h
OPENGL32                        loaded at 6C2B0000h - 6C37B000h
GLU32                            loaded at 6D9C0000h - 6D9E3000h
DDRAW                            loaded at 6D3D0000h - 6D4B5000h
DCIMAN32                        loaded at 6FF20000h - 6FF26000h
SETUPAPI                        loaded at 75EE0000h - 7606A000h
dwmapi                          loaded at 72FC0000h - 72FCC000h
foo_utils                        loaded at 6D1C0000h - 6D204000h
foo_masstag                      loaded at 03F40000h - 03F83000h
foo_browser                      loaded at 03F90000h - 03FC9000h
foo_playback_custom              loaded at 03FD0000h - 04015000h
WINSPOOL                        loaded at 735D0000h - 73612000h
foo_menu_addons                  loaded at 043C0000h - 043FC000h
foo_dsp_std                      loaded at 04400000h - 04448000h
pshook.dll                      loaded at 039C0000h - 039C8000h
SXS                              loaded at 75A20000h - 75A7F000h
jscript                          loaded at 6CE20000h - 6CE9D000h
rsaenh                          loaded at 75240000h - 7527B000h
sqlceca35                        loaded at 7D650000h - 7D6A5000h
CRYPT32                          loaded at 755F0000h - 756E1000h
MSASN1                          loaded at 75770000h - 75782000h
USERENV                          loaded at 75B60000h - 75B7E000h
Secur32                          loaded at 75B40000h - 75B54000h
JSProxy                          loaded at 6FF30000h - 6FF3A000h
sqlceer35RU                      loaded at 099C0000h - 099E7000h
NLAapi                          loaded at 74D70000h - 74D7F000h
IPHLPAPI                        loaded at 75550000h - 75569000h
dhcpcsvc                        loaded at 75510000h - 75545000h
DNSAPI                          loaded at 75AB0000h - 75ADC000h
WINNSI                          loaded at 75500000h - 75507000h
dhcpcsvc6                        loaded at 754C0000h - 754E1000h
napinsp                          loaded at 73040000h - 7304F000h
pnrpnsp                          loaded at 73000000h - 73012000h
mswsock                          loaded at 75380000h - 753BB000h
winrnr                          loaded at 73030000h - 73038000h
WLDAP32                          loaded at 76510000h - 7655A000h
PSAPI                            loaded at 75C10000h - 75C17000h
wshbth                          loaded at 73020000h - 7302C000h
sqlceoledb35                    loaded at 7D400000h - 7D42B000h
rasadhlp                        loaded at 73810000h - 73816000h
sqlcese35                        loaded at 7D550000h - 7D5A8000h
wship6                          loaded at 753C0000h - 753C5000h
sqlceqp35                        loaded at 7D750000h - 7D7EE000h
wshtcpip                        loaded at 74F10000h - 74F15000h
imagehlp                        loaded at 76090000h - 760B9000h
dbghelp                          loaded at 725A0000h - 7267C000h

Stack dump analysis:
Address: 6DC80DA0h, location: "foo_playcount_sql", loaded at 6DC70000h - 6DC86000h
Symbol: "foobar2000_get_interface" (+00007480h)
Address: 002F003Ah, location: "foo_lastfm_radio", loaded at 002E0000h - 00325000h
Symbol: "foobar2000_get_interface" (+00002B1Ah)
Address: 0044002Fh, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 6DC70000h, location: "foo_playcount_sql", loaded at 6DC70000h - 6DC86000h
Address: 6DC7C608h, location: "foo_playcount_sql", loaded at 6DC70000h - 6DC86000h
Symbol: "foobar2000_get_interface" (+00002CE8h)
Address: 6DC7197Bh, location: "foo_playcount_sql", loaded at 6DC70000h - 6DC86000h
Address: 6DC7C748h, location: "foo_playcount_sql", loaded at 6DC70000h - 6DC86000h
Symbol: "foobar2000_get_interface" (+00002E28h)
Address: 6DC78FADh, location: "foo_playcount_sql", loaded at 6DC70000h - 6DC86000h
Address: 6DC7C7CBh, location: "foo_playcount_sql", loaded at 6DC70000h - 6DC86000h
Symbol: "foobar2000_get_interface" (+00002EABh)
Address: 0036A2CDh, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 00409D8Bh, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 0041A0D4h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 6DC820FCh, location: "foo_playcount_sql", loaded at 6DC70000h - 6DC86000h
Symbol: "foobar2000_get_interface" (+000087DCh)
Address: 0036A293h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 003F29B2h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 0036B0FAh, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 00409DF4h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 0041A0D4h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 77495B87h, location: "ntdll", loaded at 77430000h - 77557000h
Symbol: "RtlAllocateHeap" (+000002E1h)
Address: 77495955h, location: "ntdll", loaded at 77430000h - 77557000h
Symbol: "RtlAllocateHeap" (+000000AFh)
Address: 0041A0D4h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 003C050Eh, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 00330000h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 77490001h, location: "ntdll", loaded at 77430000h - 77557000h
Symbol: "RtlDeactivateActivationContextUnsafeFast" (+00005F10h)
Address: 0033B8E2h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 00335194h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 003E6FB3h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 003E1650h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 003E6FB3h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 003E5408h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 1000258Fh, location: "shared", loaded at 10000000h - 1002A000h
Symbol: "uPrintCrashInfo_SetDumpPath" (+000000C8h)
Address: 0041075Ch, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 003FB0C1h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 0041075Ch, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 0036B426h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 00330000h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 003DF9C1h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 003DF9BBh, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 00401BC0h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 003FFD20h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 003E1650h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 003DF9BBh, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 003DF9CFh, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 003FFD20h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 003FB24Dh, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 003E151Ah, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 00330000h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 003E9446h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 003E1650h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 77394911h, location: "kernel32", loaded at 77350000h - 7742B000h
Symbol: "BaseThreadInitThunk" (+00000012h)
Address: 7746E4B6h, location: "ntdll", loaded at 77430000h - 77557000h
Symbol: "RtlInitializeExceptionChain" (+00000063h)
Address: 773EF389h, location: "kernel32", loaded at 77350000h - 7742B000h
Symbol: "UnhandledExceptionFilter" (+00000000h)
Address: 773EF389h, location: "kernel32", loaded at 77350000h - 7742B000h
Symbol: "UnhandledExceptionFilter" (+00000000h)
Address: 77439834h, location: "ntdll", loaded at 77430000h - 77557000h
Symbol: "RtlUpdateTimer" (+00000605h)
Address: 7746E489h, location: "ntdll", loaded at 77430000h - 77557000h
Symbol: "RtlInitializeExceptionChain" (+00000036h)
Address: 003E1585h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 003E1585h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 003B0000h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 003C0000h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 01C80003h, location: "foo_dbsearch_api_demo", loaded at 01C80000h - 01CA1000h
Address: 00320001h, location: "foo_lastfm_radio", loaded at 002E0000h - 00325000h
Symbol: "foobar2000_get_interface" (+00032AE1h)
Address: 00320001h, location: "foo_lastfm_radio", loaded at 002E0000h - 00325000h
Symbol: "foobar2000_get_interface" (+00032AE1h)
Address: 00330001h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 00340001h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 00400001h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 00410001h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 00330001h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 00400001h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 00330001h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 000E0001h, location: "foo_run", loaded at 000E0000h - 0010E000h
Address: 00330001h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 00350001h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 00330001h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 00340001h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 00320001h, location: "foo_lastfm_radio", loaded at 002E0000h - 00325000h
Symbol: "foobar2000_get_interface" (+00032AE1h)
Address: 00100001h, location: "foo_run", loaded at 000E0000h - 0010E000h
Symbol: "foobar2000_get_interface" (+00018FB1h)
Address: 00370001h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 00370001h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 003F0001h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 000E0001h, location: "foo_run", loaded at 000E0000h - 0010E000h
Address: 00380001h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 00330001h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 00310001h, location: "foo_lastfm_radio", loaded at 002E0000h - 00325000h
Symbol: "foobar2000_get_interface" (+00022AE1h)
Address: 00340001h, location: "foobar2000", loaded at 00330000h - 0046B000h

Version info:
foobar2000 v0.9.6.3
UNICODE
Windows 6.0


Additional info:
CD Audio Decoder 2.1.4  (foo_cdda)
Peakmeter Spectrum Visualisation 0.2.0.0 beta  (foo_uie_vis_peakmeter_spectrum)
Playlists Dropdown 0.6 alpha 4  (foo_uie_playlists_dropdown)
Run Command 1.0 beta 3  (foo_runcmd)
Standard DSP Array 1.0  (foo_dsp_std)
Converter 1.2  (foo_converter)
Last.fm Radio 0.5.2  (foo_lastfm_radio)
Panel Stack Splitter 0.3.6.2(alpha)  (foo_uie_panel_splitter)
Track info panel 0.8  (foo_uie_trackinfo)
Masstagger 1.7.1  (foo_masstag)
Dockable Panels 1.0.7b [Mar 28 2007 - 09:18:48]  (foo_dockable_panels)
Quick Search Toolbar 2.8l  (foo_uie_quicksearch)
COM Automation server 0.7 alpha 6  (foo_comserver2)
Run services 0.3.4  (foo_run)
Extended Variables 0.3.1  (foo_exvar)
Track info panel mod 0.8.0 beta [Jan  5 2007 - 13:36:12]  (foo_uie_trackinfo_mod)
Chronial's Coverflow 0.3.0  (foo_chronflow)
Database Search 1.4  (foo_dbsearch)
ReplayGain Scanner 2.0.8  (foo_rgscan)
Last.fm Chart Player 0.2.3  (foo_scrobblecharts)
Channel Spectrum panel 0.17.2  (foo_uie_vis_channel_spectrum)
Playlist Manager 1.0.2  (foo_playlist_manager)
Playback statistics SQL 1.1.1.0  (foo_playcount_sql)
Tabbed Panel Modified 0.2.7  (foo_uie_tabs)
Album List 4.3  (foo_albumlist)
Lyric Show Panel 0.3.3.9 [Dec 12 2008 - 17:39:01]  (foo_uie_lyrics)
WSH Panel (uie) 0.7.2  (foo_uie_wsh_panel)
Columns UI 0.3.6.7  (foo_ui_columns)
Album Art Panel 0.2.7.1  (foo_uie_albumart)
Album list panel 0.3.3  (foo_uie_albumlist)
foobar2000 core 0.9.6.3  (Core)
Standard Input Array 1.0  (foo_input_std)
Playlist Tools 0.6.2 beta 6  (foo_utils)
Skip Track 0.4  (foo_skip)
Lyrics Grabber 0.2.6.2 Beta  (foo_lyricsgrabber)
Album Art Browser 0.0.5 [Jul 23 2007 - 08:27:55]  (foo_cwbowron)
ELPlaylist 0.6.4.2(beta)  (foo_uie_elplaylist)
Audioscrobbler 1.3.16  (foo_audioscrobbler)
Playback Statistics Custom 1.4.3  (foo_playback_custom)
Menu Addons 0.4.1 (SSE)  (foo_menu_addons)
Explorer Tree 1.04.7b  (foo_uie_explorer)
Startup Actions 0.0.2 [Jul 23 2007 - 08:27:55]  (foo_cwbowron)
Default User Interface 0.9.5  (foo_ui_std)
Winamp API Emulator 0.96  (foo_winamp_spam)
Database Search Toolbar Demo 1.0  (foo_dbsearch_api_demo)
Graphical Browser rev015  (foo_uie_graphical_browser)
Facets 2008-02-25  (foo_facets)
bs2b 2.1.1  (foo_dsp_bs2b)
Music Browser 1.2.3b [Mar 23 2007 - 16:52:56]  (foo_browser)

  • Last Edit: 11 March, 2009, 01:02:06 PM by Galleon

  • jsheridan
  • [*][*][*]
  • Developer
foo_playcount_sql
Reply #22
If you are using foobar2000 in portable mode, then please redownload, there was a bugfix related to that.

Version 1.1 posted, should solve the crash described by Galleon

The .NET Framework is no longer required for this plugin
I'm still have same error 
Code: [Select]
 Illegal operation:
Code: C0000005h, flags: 00000000h, address: 6DC71ED4h
Access violation, operation: read, address: 00000000h
Call path:
entry=>initquit::on_init
Code bytes (6DC71ED4h):
6DC71E94h:  FF 68 08 C6 C7 6D 64 A1 00 00 00 00 50 83 EC 50
6DC71EA4h:  53 56 57 A1 1C 20 C8 6D 33 C5 50 8D 45 F4 64 A3
6DC71EB4h:  00 00 00 00 89 65 F0 8B F1 8D 45 A4 50 E8 3A F1
6DC71EC4h:  FF FF C7 45 FC 00 00 00 00 C6 45 FC 01 8B 4E 0C
6DC71ED4h:  8B 11 8B 52 04 8D 45 A4 50 FF D2 8D 46 58 50 8D
6DC71EE4h:  4D BC 51 E8 54 FD FF FF 8D 56 10 52 8D 45 A4 50
6DC71EF4h:  E8 47 FD FF FF 81 C6 A0 00 00 00 56 8D 4D D4 51
6DC71F04h:  E8 37 FD FF FF 8D 5D A4 E8 4F F1 FF FF 8B 4D F4
Stack (0020FA24h):
0020FA04h:  00000000 00000000 00000000 00000000
0020FA14h:  00000000 00000000 00000000 00000000
0020FA24h:  3D685365 6DC80DA0 03571D50 00000000
0020FA34h:  035710F0 002F003A 0044002F 00000000
0020FA44h:  00000000 00000000 03571100 0420040E
0020FA54h:  042000B1 00000000 00000000 00000000
0020FA64h:  03571110 006F0046 0062006F 00000000
0020FA74h:  00000000 00000000 6DC70000 0020FA24
0020FA84h:  0020FAB8 6DC7C608 00000001 0020FAC4
0020FA94h:  6DC7197B 3D685331 0020FAFC 0020FB84
0020FAA4h:  00000000 0020F2C4 03746FD8 00A53B58
0020FAB4h:  0020FA98 0020FAD8 6DC7C748 00000004
0020FAC4h:  0020FB10 6DC78FAD 03571D50 3D685321
0020FAD4h:  03571D50 0020FB04 6DC7C7CB 00000000
0020FAE4h:  0036A2CD 00409D8B 0041A0D4 00000018
0020FAF4h:  01A93D80 00000005 6DC820FC 0036A293
0020FB04h:  0020FC3C 003F29B2 00000001 0020FC4C
0020FB14h:  0036B0FA FFFFFFFE 00000000 00000000
0020FB24h:  00495955 01A80300 0000001A 00000000
0020FB34h:  7280D701 00409DF4 00000000 00000000
Registers:
EAX: 0020FA34, EBX: 00000000, ECX: 00000000, EDX: 03560048
ESI: 03571D50, EDI: 6DC80DA0, EBP: 0020FA90, ESP: 0020FA24
Crash location: "foo_playcount_sql", loaded at 6DC70000h - 6DC86000h

Loaded modules:
foobar2000                      loaded at 00330000h - 0046B000h
ntdll                            loaded at 77430000h - 77557000h
kernel32                        loaded at 77350000h - 7742B000h
COMCTL32                        loaded at 74A40000h - 74BDE000h
msvcrt                          loaded at 762E0000h - 7638A000h
ADVAPI32                        loaded at 76210000h - 762D6000h
RPCRT4                          loaded at 76140000h - 76203000h
GDI32                            loaded at 775C0000h - 7760B000h
USER32                          loaded at 76670000h - 7670D000h
SHLWAPI                          loaded at 77560000h - 775B8000h
SHELL32                          loaded at 76710000h - 7721F000h
ole32                            loaded at 763C0000h - 76504000h
shared                          loaded at 10000000h - 1002A000h
UxTheme                          loaded at 747E0000h - 7481F000h
COMDLG32                        loaded at 76560000h - 765D3000h
IMM32                            loaded at 76110000h - 7612E000h
MSCTF                            loaded at 75D40000h - 75E08000h
LPK                              loaded at 76130000h - 76139000h
USP10                            loaded at 77610000h - 7768D000h
foo_ui_columns                  loaded at 01D80000h - 01EE6000h
gdiplus                          loaded at 74170000h - 7431B000h
foo_lastfm_radio                loaded at 002E0000h - 00325000h
foo_uie_graphical_browser        loaded at 6D6A0000h - 6D734000h
MSIMG32                          loaded at 749C0000h - 749C5000h
foo_run                          loaded at 000E0000h - 0010E000h
foo_dbsearch                    loaded at 01C10000h - 01C80000h
OLEAUT32                        loaded at 765E0000h - 7666D000h
foo_uie_quicksearch              loaded at 01B80000h - 01BC6000h
foo_dbsearch_api_demo            loaded at 01C80000h - 01CA1000h
foo_input_std                    loaded at 02630000h - 02770000h
foo_ui_std                      loaded at 02540000h - 02614000h
foo_audioscrobbler              loaded at 01CF0000h - 01D20000h
WS2_32                          loaded at 76390000h - 763BD000h
NSI                              loaded at 76080000h - 76086000h
foo_uie_albumart                loaded at 01D30000h - 01D6D000h
foo_cdda                        loaded at 01F00000h - 01F40000h
foo_playlist_manager            loaded at 021A0000h - 021E4000h
foo_uie_lyrics                  loaded at 02260000h - 022BD000h
WINMM                            loaded at 73F20000h - 73F52000h
OLEACC                          loaded at 73EE0000h - 73F19000h
WININET                          loaded at 75E10000h - 75EDF000h
Normaliz                        loaded at 76070000h - 76073000h
iertutil                        loaded at 760C0000h - 76105000h
foo_dsp_bs2b                    loaded at 6DC90000h - 6DCB0000h
foo_uie_elplaylist              loaded at 02770000h - 027D9000h
foo_uie_panel_splitter          loaded at 02910000h - 0295F000h
foo_uie_vis_peakmeter_spectrum  loaded at 02960000h - 0299F000h
foo_uie_vis_channel_spectrum    loaded at 02A10000h - 02A4D000h
foo_uie_playlists_dropdown      loaded at 02A50000h - 02A89000h
foo_albumlist                    loaded at 02DB0000h - 02E1B000h
foo_scrobblecharts              loaded at 02D40000h - 02D73000h
foo_uie_trackinfo                loaded at 029A0000h - 029C5000h
foo_facets                      loaded at 02E30000h - 02EB1000h
foo_converter                    loaded at 02F10000h - 02F7C000h
foo_winamp_spam                  loaded at 02AD0000h - 02B00000h
foo_runcmd                      loaded at 02EC0000h - 02EF4000h
foo_playcount_sql                loaded at 6DC70000h - 6DC86000h
MSVCP90                          loaded at 6DAE0000h - 6DB6E000h
MSVCR90                          loaded at 6D9F0000h - 6DA93000h
foo_uie_albumlist                loaded at 02F90000h - 02FCD000h
foo_exvar                        loaded at 02FD0000h - 02FF8000h
foo_uie_wsh_panel                loaded at 6D990000h - 6D9BF000h
foo_uie_trackinfo_mod            loaded at 03310000h - 03366000h
MSVCP80                          loaded at 6CB50000h - 6CBD7000h
MSVCR80                          loaded at 6CAB0000h - 6CB4B000h
foo_uie_explorer                loaded at 03390000h - 033DE000h
CLBCatQ                          loaded at 75CB0000h - 75D34000h
WindowsCodecs                    loaded at 73C90000h - 73D43000h
apphelp                          loaded at 75AE0000h - 75B0C000h
cscui                            loaded at 72230000h - 722C5000h
PROPSYS                          loaded at 746C0000h - 7477A000h
CSCDLL                          loaded at 72330000h - 72339000h
CSCAPI                          loaded at 73050000h - 7305B000h
foo_rgscan                      loaded at 034B0000h - 0350B000h
foo_uie_tabs                    loaded at 03470000h - 03498000h
foo_dockable_panels              loaded at 03660000h - 03693000h
foo_lyricsgrabber                loaded at 6D5E0000h - 6D632000h
foo_skip                        loaded at 6DC50000h - 6DC6D000h
foo_cwbowron                    loaded at 036C0000h - 036EA000h
foo_comserver2                  loaded at 03750000h - 037A6000h
foo_chronflow                    loaded at 03950000h - 039B1000h
OPENGL32                        loaded at 6C2B0000h - 6C37B000h
GLU32                            loaded at 6D9C0000h - 6D9E3000h
DDRAW                            loaded at 6D3D0000h - 6D4B5000h
DCIMAN32                        loaded at 6FF20000h - 6FF26000h
SETUPAPI                        loaded at 75EE0000h - 7606A000h
dwmapi                          loaded at 72FC0000h - 72FCC000h
foo_utils                        loaded at 6D1C0000h - 6D204000h
foo_masstag                      loaded at 03F40000h - 03F83000h
foo_browser                      loaded at 03F90000h - 03FC9000h
foo_playback_custom              loaded at 03FD0000h - 04015000h
WINSPOOL                        loaded at 735D0000h - 73612000h
foo_menu_addons                  loaded at 043C0000h - 043FC000h
foo_dsp_std                      loaded at 04400000h - 04448000h
pshook.dll                      loaded at 039C0000h - 039C8000h
SXS                              loaded at 75A20000h - 75A7F000h
jscript                          loaded at 6CE20000h - 6CE9D000h
rsaenh                          loaded at 75240000h - 7527B000h
sqlceca35                        loaded at 7D650000h - 7D6A5000h
CRYPT32                          loaded at 755F0000h - 756E1000h
MSASN1                          loaded at 75770000h - 75782000h
USERENV                          loaded at 75B60000h - 75B7E000h
Secur32                          loaded at 75B40000h - 75B54000h
JSProxy                          loaded at 6FF30000h - 6FF3A000h
sqlceer35RU                      loaded at 099C0000h - 099E7000h
NLAapi                          loaded at 74D70000h - 74D7F000h
IPHLPAPI                        loaded at 75550000h - 75569000h
dhcpcsvc                        loaded at 75510000h - 75545000h
DNSAPI                          loaded at 75AB0000h - 75ADC000h
WINNSI                          loaded at 75500000h - 75507000h
dhcpcsvc6                        loaded at 754C0000h - 754E1000h
napinsp                          loaded at 73040000h - 7304F000h
pnrpnsp                          loaded at 73000000h - 73012000h
mswsock                          loaded at 75380000h - 753BB000h
winrnr                          loaded at 73030000h - 73038000h
WLDAP32                          loaded at 76510000h - 7655A000h
PSAPI                            loaded at 75C10000h - 75C17000h
wshbth                          loaded at 73020000h - 7302C000h
sqlceoledb35                    loaded at 7D400000h - 7D42B000h
rasadhlp                        loaded at 73810000h - 73816000h
sqlcese35                        loaded at 7D550000h - 7D5A8000h
wship6                          loaded at 753C0000h - 753C5000h
sqlceqp35                        loaded at 7D750000h - 7D7EE000h
wshtcpip                        loaded at 74F10000h - 74F15000h
imagehlp                        loaded at 76090000h - 760B9000h
dbghelp                          loaded at 725A0000h - 7267C000h

Stack dump analysis:
Address: 6DC80DA0h, location: "foo_playcount_sql", loaded at 6DC70000h - 6DC86000h
Symbol: "foobar2000_get_interface" (+00007480h)
Address: 002F003Ah, location: "foo_lastfm_radio", loaded at 002E0000h - 00325000h
Symbol: "foobar2000_get_interface" (+00002B1Ah)
Address: 0044002Fh, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 6DC70000h, location: "foo_playcount_sql", loaded at 6DC70000h - 6DC86000h
Address: 6DC7C608h, location: "foo_playcount_sql", loaded at 6DC70000h - 6DC86000h
Symbol: "foobar2000_get_interface" (+00002CE8h)
Address: 6DC7197Bh, location: "foo_playcount_sql", loaded at 6DC70000h - 6DC86000h
Address: 6DC7C748h, location: "foo_playcount_sql", loaded at 6DC70000h - 6DC86000h
Symbol: "foobar2000_get_interface" (+00002E28h)
Address: 6DC78FADh, location: "foo_playcount_sql", loaded at 6DC70000h - 6DC86000h
Address: 6DC7C7CBh, location: "foo_playcount_sql", loaded at 6DC70000h - 6DC86000h
Symbol: "foobar2000_get_interface" (+00002EABh)
Address: 0036A2CDh, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 00409D8Bh, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 0041A0D4h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 6DC820FCh, location: "foo_playcount_sql", loaded at 6DC70000h - 6DC86000h
Symbol: "foobar2000_get_interface" (+000087DCh)
Address: 0036A293h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 003F29B2h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 0036B0FAh, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 00409DF4h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 0041A0D4h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 77495B87h, location: "ntdll", loaded at 77430000h - 77557000h
Symbol: "RtlAllocateHeap" (+000002E1h)
Address: 77495955h, location: "ntdll", loaded at 77430000h - 77557000h
Symbol: "RtlAllocateHeap" (+000000AFh)
Address: 0041A0D4h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 003C050Eh, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 00330000h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 77490001h, location: "ntdll", loaded at 77430000h - 77557000h
Symbol: "RtlDeactivateActivationContextUnsafeFast" (+00005F10h)
Address: 0033B8E2h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 00335194h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 003E6FB3h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 003E1650h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 003E6FB3h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 003E5408h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 1000258Fh, location: "shared", loaded at 10000000h - 1002A000h
Symbol: "uPrintCrashInfo_SetDumpPath" (+000000C8h)
Address: 0041075Ch, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 003FB0C1h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 0041075Ch, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 0036B426h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 00330000h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 003DF9C1h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 003DF9BBh, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 00401BC0h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 003FFD20h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 003E1650h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 003DF9BBh, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 003DF9CFh, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 003FFD20h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 003FB24Dh, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 003E151Ah, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 00330000h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 003E9446h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 003E1650h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 77394911h, location: "kernel32", loaded at 77350000h - 7742B000h
Symbol: "BaseThreadInitThunk" (+00000012h)
Address: 7746E4B6h, location: "ntdll", loaded at 77430000h - 77557000h
Symbol: "RtlInitializeExceptionChain" (+00000063h)
Address: 773EF389h, location: "kernel32", loaded at 77350000h - 7742B000h
Symbol: "UnhandledExceptionFilter" (+00000000h)
Address: 773EF389h, location: "kernel32", loaded at 77350000h - 7742B000h
Symbol: "UnhandledExceptionFilter" (+00000000h)
Address: 77439834h, location: "ntdll", loaded at 77430000h - 77557000h
Symbol: "RtlUpdateTimer" (+00000605h)
Address: 7746E489h, location: "ntdll", loaded at 77430000h - 77557000h
Symbol: "RtlInitializeExceptionChain" (+00000036h)
Address: 003E1585h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 003E1585h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 003B0000h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 003C0000h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 01C80003h, location: "foo_dbsearch_api_demo", loaded at 01C80000h - 01CA1000h
Address: 00320001h, location: "foo_lastfm_radio", loaded at 002E0000h - 00325000h
Symbol: "foobar2000_get_interface" (+00032AE1h)
Address: 00320001h, location: "foo_lastfm_radio", loaded at 002E0000h - 00325000h
Symbol: "foobar2000_get_interface" (+00032AE1h)
Address: 00330001h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 00340001h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 00400001h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 00410001h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 00330001h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 00400001h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 00330001h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 000E0001h, location: "foo_run", loaded at 000E0000h - 0010E000h
Address: 00330001h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 00350001h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 00330001h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 00340001h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 00320001h, location: "foo_lastfm_radio", loaded at 002E0000h - 00325000h
Symbol: "foobar2000_get_interface" (+00032AE1h)
Address: 00100001h, location: "foo_run", loaded at 000E0000h - 0010E000h
Symbol: "foobar2000_get_interface" (+00018FB1h)
Address: 00370001h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 00370001h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 003F0001h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 000E0001h, location: "foo_run", loaded at 000E0000h - 0010E000h
Address: 00380001h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 00330001h, location: "foobar2000", loaded at 00330000h - 0046B000h
Address: 00310001h, location: "foo_lastfm_radio", loaded at 002E0000h - 00325000h
Symbol: "foobar2000_get_interface" (+00022AE1h)
Address: 00340001h, location: "foobar2000", loaded at 00330000h - 0046B000h

Version info:
foobar2000 v0.9.6.3
UNICODE
Windows 6.0


Additional info:
CD Audio Decoder 2.1.4  (foo_cdda)
Peakmeter Spectrum Visualisation 0.2.0.0 beta  (foo_uie_vis_peakmeter_spectrum)
Playlists Dropdown 0.6 alpha 4  (foo_uie_playlists_dropdown)
Run Command 1.0 beta 3  (foo_runcmd)
Standard DSP Array 1.0  (foo_dsp_std)
Converter 1.2  (foo_converter)
Last.fm Radio 0.5.2  (foo_lastfm_radio)
Panel Stack Splitter 0.3.6.2(alpha)  (foo_uie_panel_splitter)
Track info panel 0.8  (foo_uie_trackinfo)
Masstagger 1.7.1  (foo_masstag)
Dockable Panels 1.0.7b [Mar 28 2007 - 09:18:48]  (foo_dockable_panels)
Quick Search Toolbar 2.8l  (foo_uie_quicksearch)
COM Automation server 0.7 alpha 6  (foo_comserver2)
Run services 0.3.4  (foo_run)
Extended Variables 0.3.1  (foo_exvar)
Track info panel mod 0.8.0 beta [Jan  5 2007 - 13:36:12]  (foo_uie_trackinfo_mod)
Chronial's Coverflow 0.3.0  (foo_chronflow)
Database Search 1.4  (foo_dbsearch)
ReplayGain Scanner 2.0.8  (foo_rgscan)
Last.fm Chart Player 0.2.3  (foo_scrobblecharts)
Channel Spectrum panel 0.17.2  (foo_uie_vis_channel_spectrum)
Playlist Manager 1.0.2  (foo_playlist_manager)
Playback statistics SQL 1.1.1.0  (foo_playcount_sql)
Tabbed Panel Modified 0.2.7  (foo_uie_tabs)
Album List 4.3  (foo_albumlist)
Lyric Show Panel 0.3.3.9 [Dec 12 2008 - 17:39:01]  (foo_uie_lyrics)
WSH Panel (uie) 0.7.2  (foo_uie_wsh_panel)
Columns UI 0.3.6.7  (foo_ui_columns)
Album Art Panel 0.2.7.1  (foo_uie_albumart)
Album list panel 0.3.3  (foo_uie_albumlist)
foobar2000 core 0.9.6.3  (Core)
Standard Input Array 1.0  (foo_input_std)
Playlist Tools 0.6.2 beta 6  (foo_utils)
Skip Track 0.4  (foo_skip)
Lyrics Grabber 0.2.6.2 Beta  (foo_lyricsgrabber)
Album Art Browser 0.0.5 [Jul 23 2007 - 08:27:55]  (foo_cwbowron)
ELPlaylist 0.6.4.2(beta)  (foo_uie_elplaylist)
Audioscrobbler 1.3.16  (foo_audioscrobbler)
Playback Statistics Custom 1.4.3  (foo_playback_custom)
Menu Addons 0.4.1 (SSE)  (foo_menu_addons)
Explorer Tree 1.04.7b  (foo_uie_explorer)
Startup Actions 0.0.2 [Jul 23 2007 - 08:27:55]  (foo_cwbowron)
Default User Interface 0.9.5  (foo_ui_std)
Winamp API Emulator 0.96  (foo_winamp_spam)
Database Search Toolbar Demo 1.0  (foo_dbsearch_api_demo)
Graphical Browser rev015  (foo_uie_graphical_browser)
Facets 2008-02-25  (foo_facets)
bs2b 2.1.1  (foo_dsp_bs2b)
Music Browser 1.2.3b [Mar 23 2007 - 16:52:56]  (foo_browser)

You can fool some of the people all of the time, and all of the people some of the time, but you can not fool all of the people all of the time.

- Abraham Lincoln

  • Galleon
  • [*]
foo_playcount_sql
Reply #23
I'm using - Playback statistics SQL 1.1.1.0 (foo_playcount_sql) - it's a right version?
Should I re-install foobar?

  • odyssey
  • [*][*][*][*][*]
foo_playcount_sql
Reply #24
1. Sorry, but I’m not going to rewrite in SQLite

1. MySQL Support, maybe in the future.

So, you might support MySQL but refuses completely on SQLite? Seems to me like a personal hate on SQLite - Just out of curiosity, can you elaborate why this is completely out of question?

I googled around to see the differences between sqlite and mysql and it seem that others agree that sqlite is considered more appropriate for desktop applications and mysql (/server-based databases) is better suited for multi-user solutions. I found this blog discussing it.

Quote
For low load websites, SQLite has worked great in our projects. If you're doing an application in C, its API is simply unbeatable. Perhaps its most distinguishing feature is that it pretty much ignores types. This is, in fact, a "feature", and I have found that it gives it flexibility that is lacking in other situations(although, you have to put your dates in very specific formats to get the sort order to come out right...).

This could seem like a showstopper unless it has been addressed in the meantime (this blog is from 2006). Anyway, it should still be possible to handle such data in some way.

Quote
I also can't express just how great it is for desktop apps though. Its great for 95% of the situations you would need to save data in an application in a "file format" of some variety. It make debugging great(fire up the console on the file your app is writing too and watch inserts as they happen). No configuration at all. No mucking about with binary file formats. No XML parsing.

I believe in your component because it really has great potential even for many other uses I haven't expressed yet, but I really dislike that it relies on a server-side component that are extremely heavy and defeats "portable-mode" completely.

2. As for foo_id, again, i want to keep it simple, and based on Meta data (for now)

I understand this while this is purely a proof-of-concept atm, this is allright. However, if you go all the way with this plugin, I think it could be marvellous! I think you should try to contact musicmusic regarding this potential. He already announced that he didn't really know what to do with this and that an API might be useful.
Can't wait for a HD-AAC encoder :P