Just List Albums 2.1 - Updated 17/03/2013

Download and get help for different MediaMonkey Addons.

Moderators: Peke, Gurus

Postby dubmassacre » Sun Mar 30, 2008 3:37 pm

Thanks for this great script. How could I add album's 'Comment' field below the 'Artist - Album name' line?
thanks
dubmassacre
 
Posts: 13
Joined: Sat Apr 22, 2006 4:48 am

Postby trixmoto » Sun Mar 30, 2008 4:02 pm

Well the mask would need to be something like...
Code: Select all
Dim Mask : Mask = "<Artist> - <Album> (<Tot>/<Max>)"&Chr(13)&"<Comment>"

Around line 101 you'd need to do an SQL statement to get the comment and put it in variable "comm". Finally around line 112 you'd need to add the line...
Code: Select all
str = Replace(str,"<Comment>",SDB.toAscii(comm))
Download my scripts at trixmoto.net.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
Send me BTC: 34VQPVsf9mCeR4nfhFvvBYZqQ7LkqNZ8Mn
Send me LTC: 3P1mzrfbyscdhbxRpXLgKz7tufGAU3SrEG
Send me DOGE: 9xPpYSqgF7P5yQiqvE1VqWb4UjxVCCLFJ6
Check out these great cryptocurrency faucets... BTC / LTC / DOGE
trixmoto
 
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Barton, UK

Postby dubmassacre » Mon Mar 31, 2008 4:21 pm

Thank you for the reply.

Since I'm no coder I can't figure out how to execute the SQL query. I opened the MM database and I managed to spot that by saying 'comment' I meant the MemoText field of Memos table. The script query is based on IDAlbum, so I assume that I have to use Memos' IdSong field to get the MemoText values. I 'improvised' a little bit with SQL and script code. No success. :( I'm afraid it's too difficult for me. Is it something like this?

Code: Select all
SELECT MemoText AS comm FROM Memos WHERE IDSong=...


I use 1.2 script version and MM is 2.5.5.998. Thank you again.
dubmassacre
 
Posts: 13
Joined: Sat Apr 22, 2006 4:48 am

Postby trixmoto » Tue Apr 01, 2008 3:12 am

I've not got an MM2 database here to check but I'm pretty sure the album level comments are on the albums table, so something like...
Code: Select all
SELECT Comment FROM Albums WHERE IDAlbum = "&itm.Album.ID

I assume it was this comment you wanted? If you wanted track comments then are you just taking the first track from the album, or appending them all together, or what?
Download my scripts at trixmoto.net.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
Send me BTC: 34VQPVsf9mCeR4nfhFvvBYZqQ7LkqNZ8Mn
Send me LTC: 3P1mzrfbyscdhbxRpXLgKz7tufGAU3SrEG
Send me DOGE: 9xPpYSqgF7P5yQiqvE1VqWb4UjxVCCLFJ6
Check out these great cryptocurrency faucets... BTC / LTC / DOGE
trixmoto
 
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Barton, UK

Postby dubmassacre » Fri Apr 04, 2008 6:14 pm

I was wrong about the 'album comment'. I realized that I want the track comment and not the album comment but I don't have the skills to add a single line in your script. If you have time I'd appreciate to post a 'how-to'.
thank you.
dubmassacre
 
Posts: 13
Joined: Sat Apr 22, 2006 4:48 am

Postby trixmoto » Sat Apr 05, 2008 3:01 am

Which track comment do you want, the comment of every track on a new line or just the comment of the first track of the album at the beginning?
Download my scripts at trixmoto.net.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
Send me BTC: 34VQPVsf9mCeR4nfhFvvBYZqQ7LkqNZ8Mn
Send me LTC: 3P1mzrfbyscdhbxRpXLgKz7tufGAU3SrEG
Send me DOGE: 9xPpYSqgF7P5yQiqvE1VqWb4UjxVCCLFJ6
Check out these great cryptocurrency faucets... BTC / LTC / DOGE
trixmoto
 
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Barton, UK

Compilation

Postby hans123 » Sat Apr 05, 2008 9:55 am

I have downloaded today the latest version of this script. In support of previous posts: The Compilation processing in the script is not fully working. I would expect each <Artist> to show up in the list, but only the first one (in the alphabet, e.g. Albert King in a Chess compilation) shows up, the next one (e.g. Bo Diddley) does not.
I have marked each song entry for compilation albums in their properties with 'various' for <Album Artist> and have changed your script to Dim TrackMask : TrackMask = "" to skip the Track Titles.

Thanks.
hans123
 
Posts: 16
Joined: Tue Feb 19, 2008 7:45 am

Postby dubmassacre » Sat Apr 05, 2008 10:04 am

trixmoto wrote:Which track comment do you want, the comment of every track on a new line or just the comment of the first track of the album at the beginning?


the comment of the first track of the album. :)
dubmassacre
 
Posts: 13
Joined: Sat Apr 22, 2006 4:48 am

Postby trixmoto » Sat Apr 05, 2008 10:36 am

@hans123 - yes I'm aware of this bug and it will be fixed in the next version.

@dubmassacre - I'll see what I can do! :)
Download my scripts at trixmoto.net.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
Send me BTC: 34VQPVsf9mCeR4nfhFvvBYZqQ7LkqNZ8Mn
Send me LTC: 3P1mzrfbyscdhbxRpXLgKz7tufGAU3SrEG
Send me DOGE: 9xPpYSqgF7P5yQiqvE1VqWb4UjxVCCLFJ6
Check out these great cryptocurrency faucets... BTC / LTC / DOGE
trixmoto
 
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Barton, UK

Postby MonkeyBone » Mon Apr 07, 2008 6:06 pm

Hello! :)

Could someone help me, please?


I would really like for the output to be like this;


"AlbumList" (<total_of_albums>)
Artist1 - Album1
Artist1 - Album2
Artist2 - Album1
Artist3 - Album1
Artist3 - Album2
Artist3 - Album3
Artist3 - Album4
..and so on..


Thanks in advance!

And Thanks for all the effort and for a great script! :)
[AMD Athlon 64 FX-60] . [Hiper Type-R 580W] . [Western Digital Raptor X] . [Lian Li PC777B]
[Hightech Excalibur Radeon x1900xtx 512 MB] . [OCZ EB DDR PC-4000 2 GB Pl.Ed. Dual Channel]
[DFI Lanparty UT RDX200 CF-DR] . [Creative SB X-Fi Fatal1ty FPS] . [DELL UltrasSharp 2405 FPW 24"]
3DMark05 : 11043 . 3DMark06 : 5856 . (a non-clocked system) . AudioScrobbler . Xfire . YMDb
MonkeyBone
 
Posts: 66
Joined: Sun Nov 19, 2006 9:39 am

Postby trixmoto » Tue Apr 08, 2008 3:19 am

On line 55 (after the progress bar but before the for loop) add something like this...
Code: Select all
Dim dit : Set dit = SDB.Database.OpenSQL("SELECT Count(*) FROM Albums WHERE Album != ''")
fout.WriteLine """AlbumList"" ("&dit.StringByIndex(0)&")"
Download my scripts at trixmoto.net.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
Send me BTC: 34VQPVsf9mCeR4nfhFvvBYZqQ7LkqNZ8Mn
Send me LTC: 3P1mzrfbyscdhbxRpXLgKz7tufGAU3SrEG
Send me DOGE: 9xPpYSqgF7P5yQiqvE1VqWb4UjxVCCLFJ6
Check out these great cryptocurrency faucets... BTC / LTC / DOGE
trixmoto
 
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Barton, UK

Postby sommo » Tue Apr 15, 2008 10:44 am

thanks for this!
Is there anything you cant do!?
sommo
 
Posts: 122
Joined: Thu Nov 08, 2007 9:48 am

Postby trixmoto » Tue Apr 15, 2008 10:48 am

Almost certainly, but if I find something I resort to Google! :)
Download my scripts at trixmoto.net.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
Send me BTC: 34VQPVsf9mCeR4nfhFvvBYZqQ7LkqNZ8Mn
Send me LTC: 3P1mzrfbyscdhbxRpXLgKz7tufGAU3SrEG
Send me DOGE: 9xPpYSqgF7P5yQiqvE1VqWb4UjxVCCLFJ6
Check out these great cryptocurrency faucets... BTC / LTC / DOGE
trixmoto
 
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Barton, UK

Postby trixmoto » Sun Apr 27, 2008 5:25 pm

New version (1.4) is now available to download from my website. Changes include...

- Fixed <Artist> in Mask and CompMask not referencing album artist
- Added FirstMask for the first track in an album
- Added <Comment> to TrackMask and FirstMask

If you leave "FirstMask" blank then the "TrackMask" will always be used. :)
Download my scripts at trixmoto.net.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
Send me BTC: 34VQPVsf9mCeR4nfhFvvBYZqQ7LkqNZ8Mn
Send me LTC: 3P1mzrfbyscdhbxRpXLgKz7tufGAU3SrEG
Send me DOGE: 9xPpYSqgF7P5yQiqvE1VqWb4UjxVCCLFJ6
Check out these great cryptocurrency faucets... BTC / LTC / DOGE
trixmoto
 
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Barton, UK

Postby nynaevelan » Sun Apr 27, 2008 5:44 pm

trixmoto wrote:New version (1.4) is now available to download from my website. Changes include...

- Fixed <Artist> in Mask and CompMask not referencing album artist
- Added FirstMask for the first track in an album
- Added <Comment> to TrackMask and FirstMask

If you leave "FirstMask" blank then the "TrackMask" will always be used. :)


Trixmoto:

We are in business, thank you. Now I have the fun task of reviewing them to make sure I do not have duplicates when I shouldn't. :P :P

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

PreviousNext

Return to Need Help with Addons?

Who is online

Users browsing this forum: Bing [Bot] and 24 guests