Hydrogenaudio Forums > Play Counter

Zoominee

Nov 26 2004, 15:26

QUOTE(jesusxl @ Nov 21 2004, 07:41 PM)

Just to be sure: this plugin extends ID3 tags with three new fields?
If so, is it possible to easily remove these tags again after you've used them?

easiest way toremove these fields is:
1. put all your music into one playlist
2. check foobar setup to find out what the fields are called in Play Count.
3. highlight the entire playlist and use Show file info (multiple items).
4. select the fields that Play Count plugin has created, and remove them. Hit update.
(might take a while, if you have a lot of music)

crazee_canuck

Dec 4 2004, 12:56

QUOTE(Zoominee @ Nov 26 2004, 05:26 PM)

QUOTE(jesusxl @ Nov 21 2004, 07:41 PM)

Just to be sure: this plugin extends ID3 tags with three new fields?
If so, is it possible to easily remove these tags again after you've used them?

easiest way toremove these fields is:
1. put all your music into one playlist
2. check foobar setup to find out what the fields are called in Play Count.
3. highlight the entire playlist and use Show file info (multiple items).
4. select the fields that Play Count plugin has created, and remove them. Hit update.
(might take a while, if you have a lot of music)

I'd say it'd probably be easier to create a playlist that only consists of files with only the counter metadata tags, instead of adding all of the files to the playlist.

Go into the Extended Playlist Generator
Enter the query NOT %play_counter% MISSING
Click RUN
Click Create Playlist
Then continue with step 3 above.

lav-chan

Dec 13 2004, 12:00

QUOTE(studentism @ Jun 25 2004, 05:09 PM)

Uh, I don't know if this is a problem for anyone else, it could be just me, but if foobar isn't the window in focus, the playcount doesn't update itself. It isn't a major issue, just a minor inconvenience. Thanks.

Actually, i'm also getting this. I don't know why and i JUST NOW noticed the problem, so i haven't really tried testing it, but i'm getting something like that, it seems. I do know that whenever i'm actually paying attention to foobar (when the window is in focus), it does update, but the console just kind of stops showing updates after a while if it's in the tray. Don't know if that's a coincidence or not.

grindlestone

Dec 30 2004, 06:04

Would someone here be kind enough to give me some code to make play_date not display "?" for tracks that have not been played (see below)? And also to add a "-" between the D,M, Y as in 30-12-04 instead of 301204 ?

The current code for this column is the simple "%play_date%"

Thanks.

user posted image

anza

Dec 30 2004, 06:21

Make the code this: [%play_date%]

upNorth

Dec 30 2004, 16:20

QUOTE(grindlestone @ Dec 30 2004, 02:04 PM)

Would someone here be kind enough to give me some code to make play_date not display "?" for tracks that have not been played (see below)? And also to add a "-" between the D,M, Y as in 30-12-04 instead of 301204 ?

CODE

[$left(%play_date%,2)-$substr(%play_date%,3,4)-$right(%play_date%,2)]

grindlestone

Dec 30 2004, 17:21

Wow! Thanks so much for this both of you. My setup is perfect now.

Thanks heaps.

topdownjimmy

Jan 2 2005, 16:19

Once we're capable of storing playcount metadata in the db only, might it be a good idea to keep track of EVERY time a song is played? This would come in handy if, say, I wanted to generate a playlist of the 25 songs I listened to most in July of 2004 (i.e., the ones with the most occurences of xx0704 in their extended play_date field).

If there's some other way to do this that already exists, please let me know...thanks!

tboehrer

Jan 2 2005, 23:35

QUOTE(topdownjimmy @ Jan 2 2005, 05:19 PM)

Once we're capable of storing playcount metadata in the db only, might it be a good idea to keep track of EVERY time a song is played? This would come in handy if, say, I wanted to generate a playlist of the 25 songs I listened to most in July of 2004 (i.e., the ones with the most occurences of xx0704 in their extended play_date field).

If there's some other way to do this that already exists, please let me know...thanks!

I'm not sure I follow completely. The plugin already can keep track of every song. As far as generating a playlist... there is the Extended Playlist generator that can create this sort of thing for you.

Silverbolt

Jan 2 2005, 23:50

QUOTE(tboehrer @ Jan 2 2005, 10:35 PM)

I'm not sure I follow completely. The plugin already can keep track of every song. As far as generating a playlist... there is the Extended Playlist generator that can create this sort of thing for you.

I think topdownjimmy meant saving an individual play_stamp/etc. for every single time a track was played. If this were the case, then you wouldn't really even need a play_count(er), as it would just be the total amount of timestamps.

jokull

Jan 3 2005, 08:19

I second the play_stamp method. More logical. I also would like to see the play_stamps stored in a separate DB file.

tboehrer

Jan 3 2005, 08:59

QUOTE(jokull @ Jan 3 2005, 09:19 AM)

I second the play_stamp method. More logical. I also would like to see the play_stamps stored in a separate DB file.

kode54 has a version that stores the info in an external DB. You'll have to do a search to find it.

Lycox

Jan 15 2005, 10:05

Oh, I need a little bit help, because foo_count doesn't work for me.

I put the dll in the components folder and fb2k shows the dll in the components list but it didn't work.

Help pleez...

Lycox

PlazzTT

Jan 22 2005, 18:03

QUOTE(Lycox @ Jan 15 2005, 04:05 PM)

Oh, I need a little bit help, because foo_count doesn't work for me.

I put the dll in the components folder and fb2k shows the dll in the components list but it didn't work.

Help pleez...

Lycox

What do you mean by "it didn't work"? Do you mean that a column isn't appearing in your foobar showing the play count? If so, then installing the plugin in the components folder isn't enough, you still need to create a new column in your Columns UI config to show the play count.

Is the foo_count plugin creating new tags on your MP3s? (view file info on an MP3)

khiloa

Jan 22 2005, 22:29

If I install this I will find that I play about 100 songs over and over and over for sure!

Looks like everyones doing a fine job on this plugin.

anykey

Jan 27 2005, 14:08

QUOTE(Neksus @ Apr 17 2004, 08:06 PM)

You can add this at the end of you code or where ever you want it!!

CODE

$if(%play_counter%,
$repeat('0',$sub($len2(1000),$len2(%play_counter%)))%play_counter%,0000)

WOW Thank You.

Im a bit new to all this. Been searching the forum for most of the afternoon and now I've found it. Thank you Neksus for this code. Works a treat

Now I need to ensure I have the latest version of play counter.

topdownjimmy

Jan 27 2005, 18:36

QUOTE(jokull @ Jan 3 2005, 09:19 AM)

I second the play_stamp method. More logical. I also would like to see the play_stamps stored in a separate DB file.

Could you add an "append" option to foo_playcount? Then you could do a string search on the play_date field to find every song played on a specific date. A play_date field might look something like this with the append option selected:

20050101,20050102,20050119

Or something other than a comma as a delimiter.

jkwarras

Jan 28 2005, 02:41

QUOTE(topdownjimmy @ Jan 27 2005, 04:36 PM)

Could you add an "append" option to foo_playcount? Then you could do a string search on the play_date field to find every song played on a specific date. A play_date field might look something like this with the append option selected:

20050101,20050102,20050119

Or something other than a comma as a delimiter.

Yeah, that would be great. Infact that would be the only way to achieve i.e. 'Most played tracks this month'

t0m

Jan 28 2005, 08:47

I just can't believe it, the **** plugin changed my tags!!!!!!!!! and now my tag checksums are *****ed!

jkwarras

Jan 28 2005, 09:22

QUOTE(t0m @ Jan 28 2005, 06:47 AM)

I just can't believe it, the **** plugin changed my tags!!!!!!!!! and now my tag checksums are *****ed!

Hmmm...if you read this thread you'll notice that it add a play_counter and play_time tag, and tag means...tag the file

I believe that if you remove all the playcount tags you'll checksum will get back as they were before the tagging.

topdownjimmy

Jan 28 2005, 15:11

QUOTE(jkwarras @ Jan 28 2005, 03:41 AM)

QUOTE(topdownjimmy @ Jan 27 2005, 04:36 PM)

Could you add an "append" option to foo_playcount? Then you could do a string search on the play_date field to find every song played on a specific date. A play_date field might look something like this with the append option selected:

20050101,20050102,20050119

Or something other than a comma as a delimiter.

Yeah, that would be great. Infact that would be the only way to achieve i.e. 'Most played tracks this month'

What's more, this would eliminate the need to manually add ADDED tags...the first entry in PLAY_DATE would serve the same purpose (more or less).

t0m

Jan 29 2005, 06:54

QUOTE(jkwarras @ Jan 28 2005, 07:22 AM)

QUOTE(t0m @ Jan 28 2005, 06:47 AM)

I just can't believe it, the **** plugin changed my tags!!!!!!!!! and now my tag checksums are *****ed!

Hmmm...if you read this thread you'll notice that it add a play_counter and play_time tag, and tag means...tag the file

I believe that if you remove all the playcount tags you'll checksum will get back as they were before the tagging.

Well, in fact, my id3v2 tags were removed, and "play_counter" & "play_time" were added ... I tried to remove the added tags and add the id3v2 tags, but I just can't find the right checksum .. never mind, only a few albums lost.

I think a feature that change a single bit of a file should be disabled by default in any plugin or player... foobar never changes anything in the file without the user's permission!

Olive

Jan 29 2005, 14:46

You're having a point T0m, perhaps "Db only" should be on by default.

upNorth

Jan 29 2005, 15:07

QUOTE(Olive @ Jan 29 2005, 09:46 PM)

You're having a point T0m, perhaps "Db only" should be on by default.

AFAIK, the problem is that it's impossible, as you simply can't keep only specific tags in DB only. Your only option if you want to use this specific plugin, is to enable "Block tag update operations" (Preferences->Database). The "problem" with that, is that it will disable all tag updates, not only the ones done by this plugin.

Alternatively, you can use kode54's version instead, as it uses an external database.

Olive

Jan 29 2005, 17:04

Are you sure that it's not possible to alter the db and not the tags? There's a "DB Only Mask" checkbox in the plugins config page, which suggests it is possible -)

mazy

Jan 30 2005, 05:57

QUOTE(Olive @ Jan 30 2005, 12:04 AM)

Are you sure that it's not possible to alter the db and not the tags? There's a "DB Only Mask" checkbox in the plugins config page, which suggests it is possible -)

no, it's not. you are confusing two things:

afaik foobar's api makes it possible to prevent tag changes from being written to files at the moment of change (db_only flag in appropriate routines). this info has no effect later on (i.e. it's not being remembered), so these changes could get written to files sooner or later.

'Block tag update operations' option would prevent any writing to files ...

t0m

Jan 30 2005, 06:34

QUOTE(upNorth @ Jan 29 2005, 01:07 PM)

Alternatively, you can use kode54's version instead, as it uses an external database.

Where can I find that version? I think an external database would be the best solution to the problem.

kode54

Jan 30 2005, 06:55

QUOTE(t0m @ Jan 30 2005, 05:34 AM)

QUOTE(upNorth @ Jan 29 2005, 01:07 PM)

Alternatively, you can use kode54's version instead, as it uses an external database.

Where can I find that version? I think an external database would be the best solution to the problem.

*bo om*

Now with rather limited support for either sqlite.dll (only my included version) or libmysql.dll, and thanks to my messy coding, no longer depends on pmysql, but still uses PTypes for some very minor crap because I am lazy.

Fishy Joe

Jan 30 2005, 08:28

QUOTE(mazy @ Jan 30 2005, 10:57 PM)

QUOTE(Olive @ Jan 30 2005, 12:04 AM)

Are you sure that it's not possible to alter the db and not the tags? There's a "DB Only Mask" checkbox in the plugins config page, which suggests it is possible -)

no, it's not. you are confusing two things:

afaik foobar's api makes it possible to prevent tag changes from being written to files at the moment of change (db_only flag in appropriate routines). this info has no effect later on (i.e. it's not being remembered), so these changes could get written to files sooner or later.

'Block tag update operations' option would prevent any writing to files ...

I'm not sure what you mean by this, but I've added all my file types to the "DB Only" config option and it works. All the play count tags are stored in the database and my files remain untouched. I don't have "block tag operations" enabled.

jkwarras

Jan 30 2005, 09:23

QUOTE(Fishy Joe @ Jan 30 2005, 06:28 AM)

I'm not sure what you mean by this, but I've added all my file types to the "DB Only" config option and it works. All the play count tags are stored in the database and my files remain untouched. I don't have "block tag operations" enabled.

I think that when you will update/change your tag files i.e. Artist or whatever, the playcount tags will get tagged into the file. You could try to check it just by open properties of a file that has the playcount tags (that are not written intot he file because you have the 'DB only' option), change a tag (artist or whatever) and hit update file. See if the file has been tagged with playcounter tags

4nt1

Feb 4 2005, 00:54

QUOTE(Giljorak @ Apr 14 2004, 11:58 AM)

Here is the format I used, I added the time stamp to the code that tboehrer provided.

CODE

$if(%play_date%,' '$substr(%play_date%,3,4)
|$left(%play_date%,2)|$right(%play_date%,2)' @ '
$left(%play_time%,2):$substr(%play_time%,3,4),
' ')

CODE

The output looks like this at the end of my playlist:
04|13|04 @ 19:33

for anyone in australia or england or anywhere else that uses the other way of date formatting i have this currently working in my track info panel

CODE

This song was played %play_counter% times so far.
$char(10)
Last played:
$if(%play_date%,' '$left(%play_date%,2)|$substr(%play_date%,3,4)|$right(%play_date%,2)' @ '
$left(%play_time%,2):$substr(%play_time%,3,4),
' ')

this swaps the months and the days around to my preferred way

Zurman

Feb 4 2005, 09:45

Here is the code I use.

CODE

$if(%play_counter%,$get(bleu)Ce morceau a été joué %play_counter%$get(bleu) fois.
$char(10)$get(bleu)Dernière lecture

$puts(total,$add($right(%play_date%,2),$select($substr(%play_date%,3,4), $if($strcmp($left(%play_date%,2),04),0,1),$if($strcmp($left(%play_date%,2),04),3,4),4,0,2,5,0,3,6,1,4,6),6,$left(%play_date%,2)))
$select($add(1,$mod($add($get(total),$div($left(%play_date%,2),4)),7)),Samedi,Dimanche,Lundi,Mardi,Mercredi,Jeudi,Vendredi)

$num($right(%play_date%,2),1)$if($strcmp($right(%play_date%,2),01),er) $select($substr(%play_date%,3,4),Janvier,Février,Mars,Avril,Mai,Juin,Juillet,Août,Septembre,Octobre,Novembre,Décembre) 20$left(%play_date%,2)$char(10)
$get(bleu)à $left(%play_time%,2):$right($left(%play_time%,4),2)
,$get(bleu)Ce morceau n''a jamais été joué)

The date is sored this way : %y%M%D
And the time : $H$M$S

The advantage of storing this way is that I can easily sort according to the date (and hour) when tracks were played

And the date is displayed this way :
Dernière lecture Vendredi 4 Février 2005 à 16:40

It's in French but translation shouldn't be a problem :
Janvier : January, etc...
Samedi : Saturday etc...
Dernière lecture : last time played
Ce morceau n''a jamais été joué : never played

4nt1

Feb 4 2005, 17:29

QUOTE(Zurman @ Feb 5 2005, 01:45 AM)

Here is the code I use.

CODE

$if(%play_counter%,$get(bleu)Ce morceau a été joué %play_counter%$get(bleu) fois.
$char(10)$get(bleu)Dernière lecture

$puts(total,$add($right(%play_date%,2),$select($substr(%play_date%,3,4), $if($strcmp($left(%play_date%,2),04),0,1),$if($strcmp($left(%play_date%,2),04),3,4),4,0,2,5,0,3,6,1,4,6),6,$left(%play_date%,2)))
$select($add(1,$mod($add($get(total),$div($left(%play_date%,2),4)),7)),Samedi,Dimanche,Lundi,Mardi,Mercredi,Jeudi,Vendredi)

$num($right(%play_date%,2),1)$if($strcmp($right(%play_date%,2),01),er) $select($substr(%play_date%,3,4),Janvier,Février,Mars,Avril,Mai,Juin,Juillet,Août,Septembre,Octobre,Novembre,Décembre) 20$left(%play_date%,2)$char(10)
$get(bleu)à $left(%play_time%,2):$right($left(%play_time%,4),2)
,$get(bleu)Ce morceau n''a jamais été joué)

The date is sored this way : %y%M%D
And the time : $H$M$S

The advantage of storing this way is that I can easily sort according to the date (and hour) when tracks were played

And the date is displayed this way :
Dernière lecture Vendredi 4 Février 2005 à 16:40

It's in French but translation shouldn't be a problem :
Janvier : January, etc...
Samedi : Saturday etc...
Dernière lecture : last time played
Ce morceau n''a jamais été joué : never played

wow very nice idea indeed, are you using this in your columns or in your track info ?

i would love to be able to sort my colums by most frequently played or last played...

i hope that makes sense

4nt1

Feb 4 2005, 17:39

CODE

$char(10)
$if(%play_counter%,$get(bleu)This song has been played %play_counter%$get(bleu) times.
$char(10)$get(bleu)Last Played

$puts(total,$add($right(%play_date%,2),$select($substr(%play_date%,3,4), $if($strcmp($left(%play_date%,2),04),0,1),$if($strcmp($left(%play_date%,2),04),3,4),4,0,2,5,0,3,6,1,4,6),6,$left(%play_date%,2)))
$select($add(1,$mod($add($get(total),$div($left(%play_date%,2),4)),7)),Saturday,Sunday,Monday,Tuesday,Wednesday,Thursday,Friday)

$num($right(%play_date%,2),1)$if($strcmp($right(%play_date%,2),01),er) $select($substr(%play_date%,3,4),January,February,March,April,May,June,July,August,September,October,November,December) 20$left(%play_date%,2)$get(bleu) at $left(%play_time%,2):$right($left(%play_time%,4),2)
,$get(bleu)Thisis your first time listening to this song.)

here is the translated,

can you tell me what bleu is for?

also i would like to have if the song has only been played once, then instead of it saying this song has been played 1 times it says 1 time. ie singular instead of plural.

also for the daye i would like to have it be on the actual day be 1st, 2nd, 3rd, 4th etc instead of 1,2,3,4

hope you can understand that?

thanks

Zurman

Feb 5 2005, 05:32

QUOTE(4nt1 @ Feb 4 2005, 03:29 PM)

wow very nice idea indeed, are you using this in your columns or in your track info ?

i would love to be able to sort my colums by most frequently played or last played...

i hope that makes sense

I use this in my track info panel

You can easily create a colum with this info, though you dont need one to sort by last played : just select all your playlist (or double clic on status bar) and then sort>sort by> %play_date%, or even better : %play_date% %play_time%

The advantage of having a dedicated column is that this can be done in just one clic

Zurman

Feb 5 2005, 05:43

QUOTE(4nt1 @ Feb 4 2005, 03:39 PM)

CODE

$char(10)
$if(%play_counter%,$get(bleu)This song has been played %play_counter%$get(bleu) time$if($greater(%play_counter%,1),s).
$char(10)$get(bleu)Last Played

$puts(total,$add($right(%play_date%,2),$select($substr(%play_date%,3,4), $if($strcmp($left(%play_date%,2),04),0,1),$if($strcmp($left(%play_date%,2),04),3,4),4,0,2,5,0,3,6,1,4,6),6,$left(%play_date%,2)))
$select($add(1,$mod($add($get(total),$div($left(%play_date%,2),4)),7)),Saturday,Sunday,Monday,Tuesday,Wednesday,Thursday,Friday)

$num($right(%play_date%,2),1)
$select($right(%play_date%,2),st,nd,rd,th,th,th,th,th,th,th,th,th,th,th,th,th,th,th,th,th,st,nd,rd,th,th,th,th,th,th,th,st)
$select($substr(%play_date%,3,4),January,February,March,April,May,June,July,August,September,October,November,December) 20$left(%play_date%,2)$get(bleu) at $left(%play_time%,2):$right($left(%play_time%,4),2)
,$get(bleu)This is your first time listening to this song.)

here is the translated,

can you tell me what bleu is for?

also i would like to have if the song has only been played once, then instead of it saying this song has been played 1 times it says 1 time. ie singular instead of plural.

also for the daye i would like to have it be on the actual day be 1st, 2nd, 3rd, 4th etc instead of 1,2,3,4

hope you can understand that?

thanks

This should work
"bleu" is just a color, I have "$puts(bleu,918377)" at the begining of the panel, but you can put whatever color you want (bleu means blue in French)

Ooops, this will put you 31th ... Well, let's be "bestial"

4nt1

Feb 6 2005, 08:05

very nice indeed thankyou very much

aliumalik

Feb 7 2005, 05:41

can anyone format this

CODE

$if(%play_counter%,$get(info)Last Played: $get(text) $puts(total,$add($right(%play_date%,2),$select($substr(%play_date%,3,4), $if($strcmp($left(%play_date%,2),04),0,1),$if($strcmp($left(%play_date%,2),04),3,4),4,0,2,5,0,3,6,1,4,6),6,$left(%play_date%,2)))
$select($add(1,$mod($add($get(total),$div($left(%play_date%,2),4)),7)),Saturday,Sunday,Monday,Tuesday,Wednesday,Thursday,Friday) $num($right(%play_date%,2),1)$if($strcmp($right(%play_date%,2),01),er) $select($substr(%play_date%,3,4),January,February,March,April,May,June,July,August,September,October,November,December) 20$left(%play_date%,2) at $left(%play_time%,2):$right($left(%play_time%,4),2)
,$get(info)This is your first time listening to this song.)$char(10)

To show AM PM as well?
Thanks

anykey

Feb 8 2005, 07:20

QUOTE(aliumalik @ Feb 7 2005, 11:41 AM)

can anyone format this

CODE

$if(%play_counter%,$get(info)Last Played: $get(text) $puts(total,$add($right(%play_date%,2),$select($substr(%play_date%,3,4), $if($strcmp($left(%play_date%,2),04),0,1),$if($strcmp($left(%play_date%,2),04),3,4),4,0,2,5,0,3,6,1,4,6),6,$left(%play_date%,2)))
$select($add(1,$mod($add($get(total),$div($left(%play_date%,2),4)),7)),Saturday,Sunday,Monday,Tuesday,Wednesday,Thursday,Friday) $num($right(%play_date%,2),1)$if($strcmp($right(%play_date%,2),01),er) $select($substr(%play_date%,3,4),January,February,March,April,May,June,July,August,September,October,November,December) 20$left(%play_date%,2) at $left(%play_time%,2):$right($left(%play_time%,4),2)
,$get(info)This is your first time listening to this song.)$char(10)

To show AM PM as well?
Thanks

I copied this into my columns, it looks good, however, the year is displayed as 2011, 2018, or sometime in the future.

I should be grateful if you could correct the year for me.

aliumalik

Feb 8 2005, 08:26

just noticed happens with mine too

Olive

Feb 8 2005, 09:04

Because he might be using %y%M%D for PLAY_DATE, eg today is 050208.
Edit: As for AM/PM, it seems to me that at least one or two peeps have already posted their method in the track info pannel topic or somewhere near

topdownjimmy

Feb 8 2005, 13:06

QUOTE(aliumalik @ Feb 7 2005, 06:41 AM)

can anyone format this

CODE

$if(%play_counter%,$get(info)Last Played: $get(text) $puts(total,$add($right(%play_date%,2),$select($substr(%play_date%,3,4), $if($strcmp($left(%play_date%,2),04),0,1),$if($strcmp($left(%play_date%,2),04),3,4),4,0,2,5,0,3,6,1,4,6),6,$left(%play_date%,2)))
$select($add(1,$mod($add($get(total),$div($left(%play_date%,2),4)),7)),Saturday,Sunday,Monday,Tuesday,Wednesday,Thursday,Friday) $num($right(%play_date%,2),1)$if($strcmp($right(%play_date%,2),01),er) $select($substr(%play_date%,3,4),January,February,March,April,May,June,July,August,September,October,November,December) 20$left(%play_date%,2) at $left(%play_time%,2):$right($left(%play_time%,4),2)
,$get(info)This is your first time listening to this song.)$char(10)

To show AM PM as well?
Thanks

Where do the "info" and "text" variables come from?

aliumalik

Feb 8 2005, 13:46

juet formatting strings

aliumalik

Feb 9 2005, 10:16

I think I fixed the improper display thing

CODE

$if(%play_counter%,$get(info)Last Played: $get(text) $puts(total,$add($left(%play_date%,2),$select($left(%play_date%,2), $if($strcmp($substr(%play_date%,3,4),04),0,1),$if($strcmp($left(%play_date%,2),04),3,4),4,0,2,5,0,3,6,1,4,6),6,$substr(%play_date%,3,4)))
$select($add(1,$mod($add($get(total),$div($substr(%play_date%,3,4),4)),7)),Saturday,Sunday,Monday,Tuesday,Wednesday,Thursday,Friday) $num($left(%play_date%,2),1)$if($strcmp($right(%play_date%,2),01),er) $select($substr(%play_date%,3,4),January,February,March,April,May,June,July,August,September,October,November,December) $right(%play_date%,4) at $left(%play_time%,2):$right($left(%play_time%,4),2)
,$get(info)This is your first time listening to this song.)$char(10)

Can someone tell me what is the default format used "%D%M%Y" or "%M%D%Y"

Now to do AM PM thingy

tboehrer

Feb 9 2005, 10:31

QUOTE(aliumalik @ Feb 9 2005, 11:16 AM)

Can someone tell me what is the default format used "%D%M%Y" or "%M%D%Y"

The default is %D%M%y.

I use %Y%M%D$H$M$S. This gives a combined date + time and allows sorting by last played.

aliumalik

Feb 9 2005, 10:58

Has someone done the AM/PM thing using %play_time% couldnt find in this thread

krazy

Feb 10 2005, 09:27

This is a section of the code I use in my Track Info panel:

CODE

$puts(Last_played,$select(1,
$if($meta_test(PLAY_DATE),
$puts(month,$select($substr($meta(PLAY_DATE),3,4),
'January','February','March','April','May','June','July','August','September','October','November','December',))
$left($meta(PLAY_DATE),2)' '$get(month)' 20'$right($meta(PLAY_DATE),2)', '
),$meta(PLAY_DATE))

$if([$meta(PLAY_TIME)],
$ifgreater($meta(PLAY_TIME),130000,$sub($substr($meta(PLAY_TIME),1,2),12),$ifgreater(1,$substr($meta(PLAY_TIME),1,2),'12',$substr($meta(PLAY_TIME),1,2)))':'$substr($meta(PLAY_TIME),3,4)
//':'$substr($meta(PLAY_TIME),5,6)
$ifgreater($meta(PLAY_TIME),120000,' pm',' am'),'Never'
)
)

Remove the '//' if you want seconds too

aliumalik

Feb 10 2005, 12:37

thanks a lot crazy

Lyx

Feb 16 2005, 18:01

tboehrer:

please give this thread a read and drop in your opinion:
http://www.hydrogenaudio.org/forums/index....showtopic=31530

From looking at the sources, it seems quite easy to change the default to the proposed standard in the above thread. But i guess it would be a better idea (if you want to) when you would officially change the default instead of someone else changing the source and compiling it.

- Lxc

beto

Feb 20 2005, 20:28

QUOTE(kode54 @ Jan 30 2005, 09:55 AM)

QUOTE(t0m @ Jan 30 2005, 05:34 AM)

QUOTE(upNorth @ Jan 29 2005, 01:07 PM)

Alternatively, you can use kode54's version instead, as it uses an external database.

Where can I find that version? I think an external database would be the best solution to the problem.

*bo om*

Now with rather limited support for either sqlite.dll (only my included version) or libmysql.dll, and thanks to my messy coding, no longer depends on pmysql, but still uses PTypes for some very minor crap because I am lazy.

Is this incompatible with mysql under 4.1.x ? I cannot use it with mysql 4.0.23....
I receive the following error when hitting the create tavle button:

user posted image

please, any guidance would be appreciated.