Skip to main content ↑ ↓

Notice

Please note that most of the software linked on this forum is likely to be safe to use. If you are unsure, feel free to ask in the relevant topics, or send a private message to an administrator or moderator. To help curb the problems of false positives, or in the event that you do find actual malware, you can contribute through the article linked here.
Topic: foo_playcount_sql (Read 96650 times) previous topic - next topic
0 Members and 1 Guest are viewing this topic.

foo_playcount_sql

Reply #75 –
I find next bug.

On first start foobar2000 with foo_playcount_sql  sql database is created. I create autoplaylist  with next criteria: last_played_sql MISSING. This playlist is empty.
After restarting foobar2000 this playlist already not empty.

My media library contained ~ 4600 items and number of items without last_played_sql is ~ 100.

Number of repeating this situation by me is 3 or 4. The results is  equal.

Then I moved to the media library to another folder, leaving it only the files that were previously created autoplaylist. In this case autoplaylist  after creating sql database and restarting foobar2000  is empty.

I am using the following method of placing files in media library \\shared_resurs\audio$

foo_playcount_sql

Reply #76 –
This component only uses the %artist% %album% and %title% tags

Quote from: boombaard on
Will this component create different entries for different performances of the same classical work (ie. beethoven's 9th symphony by (%conductor%/%ensemble%=)Abbado/BPO or Furtwängler/BPO)?

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 #77 –
Sorry, but i didn't seem to understand the problem, can you try to explain?

Quote from: pIv on
I find next bug.

On first start foobar2000 with foo_playcount_sql  sql database is created. I create autoplaylist  with next criteria: last_played_sql MISSING. This playlist is empty.
After restarting foobar2000 this playlist already not empty.

My media library contained ~ 4600 items and number of items without last_played_sql is ~ 100.

Number of repeating this situation by me is 3 or 4. The results is  equal.

Then I moved to the media library to another folder, leaving it only the files that were previously created autoplaylist. In this case autoplaylist  after creating sql database and restarting foobar2000  is empty.

I am using the following method of placing files in media library \\shared_resurs\audio$

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 #78 –
All files in my media library have play_count and last_played tags.
After I create sql database all files in my media library also have play_count_sql and last_played_sql tags.
But when I restart foobar2000 (close foobar and start it again) ~ 100 files in media library (number of it's items ~4600 files) don't have play_count_sql and last_played_sql tags.

Why?

foo_playcount_sql

Reply #79 –
Interesting, can you detect a pattern with the files which seems to miss play_count_sql information?

Quote from: pIv on
All files in my media library have play_count and last_played tags.
After I create sql database all files in my media library also have play_count_sql and last_played_sql tags.
But when I restart foobar2000 (close foobar and start it again) ~ 100 files in media library (number of it's items ~4600 files) don't have play_count_sql and last_played_sql tags.

Why?

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 #80 –
Great plugin, the best one back end wise (always had problems with the other play count plugins). Just a quick request : would it be possible to only update tracks that are in the foobar database ?

Thanks for your hard work !

foo_playcount_sql

Reply #81 –
jsheridan

I deleted all the files from the library, except for those who have not received play_count_sql tag in the previous attempt.

Then repeat the whole procedure again. After completion of the experiment files without play_count_sql was not.

As you requested, untagged file are:

\\adm-035\audio$\Russian\ÄÊ Remastered\Ãîëûå íîãè\19 ß òåáÿ íå ëþáëþ.mpc (full folder)

\\adm-035\audio$\Classical\Denis_Matsuev\2008 - Unknown Rachmaninoff\05. Sonata ¹2, Op.36 Allegro Agitato.apl

and many other files.

foo_playcount_sql

Reply #82 –
Just a thought, do those files have proper artist / album/ title tags?

Quote from: pIv on
jsheridan

I deleted all the files from the library, except for those who have not received play_count_sql tag in the previous attempt.

Then repeat the whole procedure again. After completion of the experiment files without play_count_sql was not.

As you requested, untagged file are:

\\adm-035\audio$\Russian\ÄÊ Remastered\Ãîëûå íîãè\19 ß òåáÿ íå ëþáëþ.mpc (full folder)

\\adm-035\audio$\Classical\Denis_Matsuev\2008 - Unknown Rachmaninoff\05. Sonata ¹2, Op.36 Allegro Agitato.apl

and many other files.

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 #83 –
Quote
Just a thought, do those files have proper artist / album/ title tags?


Of course, I taged all my files very carefully.
This is sample:
http://www.onlinedisk.ru/image/103991/01.jpg

foo_playcount_sql

Reply #84 –
Please try to see what happends when you try to play one of those files (that failed importing). Does it get new play_count_sql information?

Quote from: pIv on
Quote
Just a thought, do those files have proper artist / album/ title tags?


Of course, I taged all my files very carefully.
This is sample:
http://www.onlinedisk.ru/image/103991/01.jpg

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 #85 –
I repeat my experinet
This picture - screen after scan media library  and creating sqk database.


Then I restart foobar2000 and I put all items from media library without last_played_sql in "default" playlist


Now I have 337 item in this playlist, but 8 hours ago I have ~ 150 items.

foo_playcount_sql

Reply #86 –
I've watched the screen shot you posted, and i've noticed one important thing.
I can't see the official playcount stats at the properties window for the track with the missing data. Is it because from some reason, the playcount exists inside the files, but not at the official plugin playbackstatistics.dat file?

Here is what i would expect:


I suggest trying "Import statistics from file tags" at the above files, and see if that helps to show the official statistics at the properties window. Only if it does, i suggest then you try again to import it to foo_playcount_sql

Quote from: pIv on
I repeat my experinet
This picture - screen after scan media library  and creating sqk database.


Then I restart foobar2000 and I put all items from media library without last_played_sql in "default" playlist


Now I have 337 item in this playlist, but 8 hours ago I have ~ 150 items.

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 #87 –
Suggestion for the Library-> Playback Statistics SQL menu.
Most played Artist
Most played Album
Most played Tracks
elevatorladylevitateme

foo_playcount_sql

Reply #88 –
Quote from: jsheridan on
I've watched the screen shot you posted, and i've noticed one important thing.
I can't see the official playcount stats at the properties window for the track with the missing data. Is it because from some reason, the playcount exists inside the files, but not at the official plugin playbackstatistics.dat file?


Yes, I use foo_playback_custom.dll for writing next tags into files: last_played, first_played and play_count. On this PC I don't use official foo_playcount.dl and not have PlaybackStatistics.dat file.

foo_playcount_sql

Reply #89 –
I have a question, would it be possible to hard code the rating stars so it wouldn't be font depended?

foo_playcount_sql

Reply #90 –
A second attempt.  Please add tag %added%, and official foo_playcount will be removed. Now get two components make statistics.

foo_playcount_sql

Reply #91 –
Quote from: grounder on
Please add tag %added%

%added% doesn't make any sense in the context of this component, since playcounts are not even being kept track of per file.
elevatorladylevitateme

foo_playcount_sql

Reply #92 –
Is it somehow possible to remove "dead entries"?
I re-tagged some files from an album (made some typos) and now the infos from the files before re-tagging are still counted in the album/artist infos.
(And the "old" track infos are of course no longer available for the re-tagged file...)

foo_playcount_sql

Reply #93 –
@tedgo

ATM, it’s only possible to do that by editing the SQL Database directly. However leaving the dead entries should have no visible effect on usage.

@ grounder

%added% within the context of this component is confusing concept. Since, it will reflect the first time artist/album/title combo is recognized by fb2k, and will obviously not consider file moves, adding the files again, and other physical changes. I might add it in the future, but as shakey_snake stated, it makes more sense on a per_file context.

@ TuNk77

I just copied the official playcount behavior, I still didn't understand what is the problem related to the font.

@ shakey_snake

Most 'x' screens are coming for the next version.

@ pIv

1. This component only supports the importing of data from the official playcount plug-in. My guess is that _custom uses %play_counter% instead of %play_count% and that is not recognized.
2. The ability to assign shortcuts to _sql functions (ratings too), will be fixed for the next version.

@mitchmalibu

Once this plugin will have a configuration screen, i'll add the option to tag only media library items, but for now, i prefer to count everything by default
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 #94 –
Quote from: jsheridan on
@ pIv

1. This component only supports the importing of data from the official playcount plug-in. My guess is that _custom uses %play_counter% instead of %play_count% and that is not recognized.


In foo_custom propeties you can define which tags correspond to the first playing, the last playing and play counts.

I define next tags: first_played, last_played and play_count. This tags correctly displayed in playlists and correctly writed into all files in media library.  As the official play_count tags value are available via %first_played%, %last_played% and %play_count%.

foo_playcount_sql

Reply #95 –
Quote
@ TuNk77

I just copied the official playcount behavior, I still didn't understand what is the problem related to the font.


I use a font that does not support stars symbols, so it displays just five boxes, please take a look at the screen shot:

foo_playcount_sql

Reply #96 –
Version 1.50 posted, changes includes:
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

Because the DB is upgraded, i suggest backing up playcount.sdf
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 #97 –
Upgraded succesfully! Thanks for the new GUI!

foo_playcount_sql

Reply #98 –
Thanks!

Small correction:
In Most Played Items: Size of playcount column too small (only two digits, I need three)
Fixed size of last played and first played columns.
EDIT: Fixed size for all columns not "Auto Scale Columns with Window size"

foo_playcount_sql

Reply #99 –
Quote from: grimes on
Small correction:
In Most Played Items: Size of playcount column too small (only two digits, I need three)

Works fine for me.
FB2K 0.9.6.4b2 on Vista Home Premium 32