Page 3 of 14

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

Posted: Tue Oct 07, 2008 5:52 pm
by nynaevelan
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

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

Posted: Tue Oct 07, 2008 6:50 pm
by MoDementia
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

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

Posted: Wed Oct 08, 2008 3:02 am
by Bex
I'll have have a look and try to squeeze it in! :)

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

Posted: Thu Oct 09, 2008 5:37 pm
by Bex
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

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

Posted: Thu Oct 09, 2008 6:49 pm
by nynaevelan
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

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

Posted: Thu Oct 09, 2008 6:54 pm
by Bex
Thanks Nyn, that was nice to hear! :D

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

Posted: Mon Oct 13, 2008 9:37 am
by mm luver
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.

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

Posted: Mon Oct 13, 2008 2:03 pm
by Bex
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! :)

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

Posted: Mon Oct 13, 2008 2:04 pm
by Bex
-

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

Posted: Tue Oct 14, 2008 9:18 am
by nynaevelan
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

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

Posted: Tue Oct 14, 2008 5:08 pm
by Bex
Nyn,

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

2. Hmm, no promises but I'll see what I can do.

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

Posted: Tue Oct 14, 2008 5:12 pm
by nynaevelan
Once again, thank you for considering my requests... :D :D

Nyn

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

Posted: Tue Oct 14, 2008 9:54 pm
by onenonymous
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

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

Posted: Wed Oct 15, 2008 3:29 am
by nynaevelan
Thank you, you are turning into my Button King. :wink: :D

Nyn

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

Posted: Mon Oct 20, 2008 7:27 pm
by nynaevelan
Bex:

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

Nyn