Add/Remove PlayStat 1.3.1 (2012-09-03)

Download and get help for different MediaMonkey Addons.

Moderators: Peke, Gurus

nynaevelan
Posts: 5559
Joined: Wed Feb 07, 2007 11:07 pm
Location: New Jersey, USA
Contact:

Re: Add/Remove PlayStat 1.1 (2008-10-07) [MM3]

Post by nynaevelan » Tue Oct 07, 2008 5:52 pm

Bex wrote:Ok Nyn, you'll have an update which consider this by the weekend. (It'll take some time to implement it, I think.) :)
Take your time, I'm just thrilled you would implement it. :D

Nyn
3.2x - Win7 Ultimate (Zen Touch 2 16 GB/Zen 8GB)
Link to Favorite Scripts/Skins

Join Dropbox, the online site to share your files

MoDementia
Posts: 1321
Joined: Thu Jun 15, 2006 3:26 pm
Location: Geelong, Victoria, Australia

Re: Add/Remove PlayStat 1.1 (2008-10-07) [MM3]

Post by MoDementia » Tue Oct 07, 2008 6:50 pm

While you are at it :P

There is a field in devicetracks table called UploadTime
Could you add this to Add Plays option as a start date
You might need a dropdown for the device ID (for multiple players) before displaying the date/time

[EDIT] another button to add the dates as the end date would be good too
i.e.
Last History = StartDate
Last Played = End Date

[EDIT AGAIN]
I just wrote a little piece of code (specifically for how an iPod Syncs)
Which will fix the Played table for 99% of the songs played
Would love to have this as an option rather than my mickey mouse script.
Add Played for Missing Last Played Date

Code: Select all

Sub CheckPlaycountVSPlayed
  xCounter = 0
  Set iter = SDB.DataBase.OpenSQL("SELECT ID,LastTimePlayed FROM Songs LEFT JOIN Played ON Songs.ID=Played.IDSong WHERE PlayCounter>0 GROUP BY Songs.ID HAVING PlayCounter>COUNT(IDSong)")
  Do While NOT iter.EOF
    ID = iter.ValueByIndex(0)
    LastTimePlayed = iter.StringByIndex(1)
    PlayedCount = SDB.DataBase.OpenSQL("SELECT COUNT(*) FROM Played WHERE IDSong=" & ID & " AND Playdate=" & LastTimePlayed).ValueByIndex(0)
    If PlayedCount = 0 Then
      SDB.DataBase.ExecSQL("INSERT INTO Played (IDSong,PlayDate) VALUES(" & ID & "," & LastTimePlayed & ")")
    End If
    xCounter = xCounter + 1
  iter.next
  Loop
End Sub

Bex
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Re: Add/Remove PlayStat 1.1 (2008-10-07) [MM3]

Post by Bex » Wed Oct 08, 2008 3:02 am

I'll have have a look and try to squeeze it in! :)
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!

All My Scripts

Bex
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Re: Add/Remove PlayStat 1.1.1 (2008-10-09) [MM3]

Post by Bex » Thu Oct 09, 2008 5:37 pm

Script is updated
Ver 1.1.1 (2007-10-09[MM3]
- Added possibility to displays plays for selected tracks only, in "Remove all Plays In Period"

@Mo,
Sorry, but I haven't yet done your request :(


Enjoy
/Bex
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!

All My Scripts

nynaevelan
Posts: 5559
Joined: Wed Feb 07, 2007 11:07 pm
Location: New Jersey, USA
Contact:

Re: Add/Remove PlayStat 1.1.1 (2008-10-09) [MM3]

Post by nynaevelan » Thu Oct 09, 2008 6:49 pm

Bex wrote: - Added possibility to displays plays for selected tracks only, in "Remove all Plays In Period"

Enjoy
/Bex
Thank you :D :D this is going to be a feature of ARPS that I will be using frequently. Of all the scripts which I use, this one is a part of my Top 5.

Nyn
3.2x - Win7 Ultimate (Zen Touch 2 16 GB/Zen 8GB)
Link to Favorite Scripts/Skins

Join Dropbox, the online site to share your files

Bex
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Re: Add/Remove PlayStat 1.1.1 (2008-10-09) [MM3]

Post by Bex » Thu Oct 09, 2008 6:54 pm

Thanks Nyn, that was nice to hear! :D
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!

All My Scripts

mm luver

Re: Add/Remove PlayStat 1.1.1 (2008-10-09) [MM3]

Post by mm luver » Mon Oct 13, 2008 9:37 am

hi
i got a little problem with your great script.
if i try to use the "add one play timestamp x option" i get an error that the selected tracks got a later dateadded then the playdate.
can i change the timestamp because its about 40 minutes wrong.

sorry for that bad language, i hope you get it.

Bex
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Re: Add/Remove PlayStat 1.1.1 (2008-10-09) [MM3]

Post by Bex » Mon Oct 13, 2008 2:03 pm

Yes, I understand what you mean. But you can't add a PlayHistory Date which is before the song was Added to the library, that will never be possible with this script. just wait 40 minutes and then try again and it'll be just fine! :)
Last edited by Bex on Tue Oct 14, 2008 5:09 pm, edited 1 time in total.
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!

All My Scripts

Bex
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Re: Add/Remove PlayStat 1.1.1 (2008-10-09) [MM3]

Post by Bex » Mon Oct 13, 2008 2:04 pm

-
Last edited by Bex on Tue Oct 14, 2008 5:09 pm, edited 1 time in total.
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!

All My Scripts

nynaevelan
Posts: 5559
Joined: Wed Feb 07, 2007 11:07 pm
Location: New Jersey, USA
Contact:

Re: Add/Remove PlayStat 1.1.1 (2008-10-09) [MM3]

Post by nynaevelan » Tue Oct 14, 2008 9:18 am

Hi Bex:

I have two hopefully small requests:

1. In the Add Plays section would it be possible for the user to set a default for which date should be the start date?
2. Would it be possible to have toolbar buttons for select features?

Nyn
3.2x - Win7 Ultimate (Zen Touch 2 16 GB/Zen 8GB)
Link to Favorite Scripts/Skins

Join Dropbox, the online site to share your files

Bex
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Re: Add/Remove PlayStat 1.1.1 (2008-10-09) [MM3]

Post by Bex » Tue Oct 14, 2008 5:08 pm

Nyn,

1. Good idea, it'll be implemented in the next version. :)

2. Hmm, no promises but I'll see what I can do.
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!

All My Scripts

nynaevelan
Posts: 5559
Joined: Wed Feb 07, 2007 11:07 pm
Location: New Jersey, USA
Contact:

Re: Add/Remove PlayStat 1.1.1 (2008-10-09) [MM3]

Post by nynaevelan » Tue Oct 14, 2008 5:12 pm

Once again, thank you for considering my requests... :D :D

Nyn
3.2x - Win7 Ultimate (Zen Touch 2 16 GB/Zen 8GB)
Link to Favorite Scripts/Skins

Join Dropbox, the online site to share your files

onenonymous
Posts: 374
Joined: Sat Feb 02, 2008 1:09 pm
Location: Texas

Re: Add/Remove PlayStat 1.1.1 (2008-10-09) [MM3]

Post by onenonymous » Tue Oct 14, 2008 9:54 pm

nynaevelan wrote: Would it be possible to have toolbar buttons for select features?
Nyn - add this to your Scripts.ini then you can use RCFS to add buttons anywhere you want... :-)

Code: Select all

[AddRemovePlayStat-AddOne]
Filename=Auto\AddRemovePlaystat.vbs
Procname=AddOnePlayNow
Order=99
DisplayName=Add one play, TimeStamp Now
Description=Add one play, TimeStamp Now
Language=VBScript
ScriptType=99
Icon=1
 
[AddRemovePlayStat-AddOneTimeStamp]
Filename=Auto\AddRemovePlaystat.vbs
Procname=AddOnePlayX
Order=99
DisplayName=Add one play, TimeStamp X
Description=Add one play, TimeStamp X
Language=VBScript
ScriptType=99
Icon=4

[AddRemovePlayStat-AddPlays]
Filename=Auto\AddRemovePlaystat.vbs
Procname=AddPlays
Order=99
DisplayName=Add Plays
Description=Add Plays
Language=VBScript
ScriptType=99
Icon=1

[AddRemovePlayStat-RemovePlays]
Filename=Auto\AddRemovePlaystat.vbs
Procname=RemovePlays
Order=99
DisplayName=Remove Plays
Description=Remove Plays
Language=VBScript
ScriptType=99
Icon=8

[AddRemovePlayStat-RemoveAll]
Filename=Auto\AddRemovePlaystat.vbs
Procname=RemoveInPeriod
Order=99
DisplayName=Remove All Plays In Period
Description=Remove All Plays In Period
Language=VBScript
ScriptType=99
Icon=8

[AddRemovePlayStat-SetLastPlay]
Filename=Auto\AddRemovePlaystat.vbs
Procname=SetLastPlayedDateM
Order=99
DisplayName=Set LastPlayedDate
Description=Set LastPlayedDate
Language=VBScript
ScriptType=99
Icon=59

[AddRemovePlayStat-FixPlayCounter]
Filename=Auto\AddRemovePlaystat.vbs
Procname=FixPlayCounter
Order=99
DisplayName=Adjust Only PlayCounter
Description=Adjust Only PlayCounter
Language=VBScript
ScriptType=99
Icon=73

nynaevelan
Posts: 5559
Joined: Wed Feb 07, 2007 11:07 pm
Location: New Jersey, USA
Contact:

Re: Add/Remove PlayStat 1.1.1 (2008-10-09) [MM3]

Post by nynaevelan » Wed Oct 15, 2008 3:29 am

Thank you, you are turning into my Button King. :wink: :D

Nyn
3.2x - Win7 Ultimate (Zen Touch 2 16 GB/Zen 8GB)
Link to Favorite Scripts/Skins

Join Dropbox, the online site to share your files

nynaevelan
Posts: 5559
Joined: Wed Feb 07, 2007 11:07 pm
Location: New Jersey, USA
Contact:

Re: Add/Remove PlayStat 1.1.1 (2008-10-09) [MM3]

Post by nynaevelan » Mon Oct 20, 2008 7:27 pm

Bex:

Whatever you did to improve the speed in the Add Plays section is ABSOLUTELY fantastic!!!!!! Thank You. :D :D :D :D

Nyn
3.2x - Win7 Ultimate (Zen Touch 2 16 GB/Zen 8GB)
Link to Favorite Scripts/Skins

Join Dropbox, the online site to share your files

Post Reply