Page 3 of 6

Re: Collection of most useful/wanted Magic Nodes masks [MM2+3]

Posted: Wed Jul 02, 2008 7:45 am
by sommo
Hey!
Could someone help me write one for this?

I have a a few tracks like this, where the album name is the artist name and the wold single that the end!

I can do this much

__TEST |Filter:<Album> = <Artist>\<Album>

but then I need to add on 'Single' or singles at the end...

Re: Collection of most useful/wanted Magic Nodes masks [MM2+3]

Posted: Wed Jul 02, 2008 8:12 am
by ZvezdanD
sommo wrote:I need to add on 'Single' or singles at the end...

Code: Select all

__TEST |Filter:<Album> Like <Artist> || ' Single_'\<Album>

Re: Collection of most useful/wanted Magic Nodes masks [MM2+3]

Posted: Wed Jul 02, 2008 8:33 am
by sommo
Thank you ZvezdanD
I ended up using this :)

Code: Select all

Album call singles |Filter:<Album> Like <Artist> || ' Singles'\<Album>

Re: Collection of most useful/wanted Magic Nodes masks [MM2+3]

Posted: Wed Jul 02, 2008 9:20 am
by sommo
Is there a script for this...

Songs:
Track 1 - AlbumName - Artist
Track 2 - AlbumName - Artist
Track 3 - AlbumName - Artist
Track 4 - AlbumName - Artist
Track 5 - AlbumName - Artist
Track 6 - AlbumName - Artist
Track 7 - AlbumName - Artist
Track 2 - Singles - Artist

Display:
Track 2 - AlbumName - Artist
Track 2 - Singles - Artist

Scan "Artist" to see if there is "Title" is dup, and if one of the "albumname" is call "Singles"

Re: Collection of most useful/wanted Magic Nodes masks [MM2+3]

Posted: Wed Jul 02, 2008 10:06 am
by ZvezdanD
sommo wrote:Thank you ZvezdanD
I ended up using this :)

Code: Select all

Album call singles |Filter:<Album> Like <Artist> || ' Singles'\<Album>
If you have one fixed string to compare it is better to use "=" instead of "Like". I added "Like" to my mask because you said that you have two strings to compare - "Single" and "singles" (the underline is replacement for any character, same as ? in MS Jet).

Re: Collection of most useful/wanted Magic Nodes masks [MM2+3]

Posted: Wed Jul 02, 2008 10:08 am
by ZvezdanD
sommo wrote:Is there a script for this...
Sorry, but I don't understand you. Could you be a more specific?

Re: Collection of most useful/wanted Magic Nodes masks [MM2+3]

Posted: Fri Jul 04, 2008 3:44 am
by sommo
ZvezdanD wrote:
sommo wrote:Is there a script for this...
Sorry, but I don't understand you. Could you be a more specific?
Scan "Artist" to see if there is "Title" is dupicated, and if there is, is there one of the "AlbumName" is call "Singles", then display it!

Re: Collection of most useful/wanted Magic Nodes masks [MM2+3]

Posted: Fri Jul 04, 2008 6:19 am
by ZvezdanD
sommo wrote:Scan "Artist" to see if there is "Title" is dupicated, and if there is, is there one of the "AlbumName" is call "Singles", then display it!
You didn't said nothing new to the previous post. Anyway, you could try the next mask:

Code: Select all

Tracks with same Name from same Artists when one Album has name "Singles"|Icon:Top level|SQL Filter: Songs.SongTitle || '@#$' || Songs.Artist IN (SELECT SongTitle || '@#$' || Artist FROM Songs WHERE Length(SongTitle) > 0 GROUP BY SongTitle, Artist HAVING Count(*) > 1 AND Count(DISTINCT Artist) = 1 AND '#$^' || replace(group_concat(Album, '#$^'), '#$^ ', '#$^') || '#$^' Like '%#$^Singles#$^%')\<Title|Trim:1>\<Title>\<Artist>

Re: Collection of most useful/wanted Magic Nodes masks [MM2+3]

Posted: Fri Jul 04, 2008 9:38 am
by sommo
@ZvezdanD
That is perfect!
Thank you soooo much :D :D :D

Re: Collection of most useful/wanted Magic Nodes masks [MM2+3]

Posted: Mon Sep 01, 2008 10:09 am
by MusicBringer
Hello folks, I would like a Magic Node Script, please :)
I am not a programmer and my brain does not understand code :-?

I would like to know which albums contain just one or two tracks.

Perhaps it would look similar to the existing Node "Album Ratings".
It would list the Album, the Artist, followed by the number of tracks therein.
For example:
The White Album (The Beatles) (2 tracks)
Echoes (Pink Floyd) (1 track)

If the Artist Name cannot be displayed, then just show the Album and number of tracks.
Such as:
The White Album (2 tracks)
Echoes (1 track)

Thanks,

Re: Collection of most useful/wanted Magic Nodes masks [MM2+3]

Posted: Mon Sep 01, 2008 12:07 pm
by ZvezdanD
MusicBringer wrote:I would like to know which albums contain just one or two tracks.
It would list the Album, the Artist, followed by the number of tracks therein.
If you want to display only album names without artist names, it could be very simple - just edit the sample mask "One-hit wonders" and replace 5 with desired number. But if you want to display artist names as well, you should use something like this:

Code: Select all

Albums with one or two tracks|Icon:Top level|SQL filter: Songs.IDAlbum IN (SELECT IDAlbum FROM Songs GROUP BY IDAlbum HAVING Count(TrackNumber) <= 2)\<Album with Album Artist|Statistic:Count(Tracks)>

Re: Collection of most useful/wanted Magic Nodes masks [MM2+3]

Posted: Mon Sep 01, 2008 12:50 pm
by MusicBringer
ZvezdanD, you're wonderful..!!
Thank you so much.
Just what I wanted.
I am very happy :D

Re: Collection of most useful/wanted Magic Nodes masks [MM2+3]

Posted: Tue Sep 02, 2008 4:07 am
by tatoosh
I've a problem in finding long track - longer than 30min (like DJ Mixes).
SQL Statement works: SELECT IDAlbum FROM Songs where SongLength >= 1800000
MM3 Statement: Mixe|SQL Filter: Songs.IDAlbum IN (SELECT IDAlbum FROM Songs where SongLength >= 1800000)\<Album>

whats wrong in my MM3 Statement?? i don't got an skript or sql error but in my list are also files with a length about 30sec or 5min. whats wrong !?

2nd:
I want to get this done:
New Tracks in the last 90days - but only who had never played (like PlayCounter=0 or LastTimePlayed=0)
where is the date saved ine the DB at which date the new files were added.

90 Days with SQL i found in the forum:
AddedLastMonth|SQL filter:(julianday(date('now', 'localtime')) - julianday('1899-12-30 12:00') - julianday(date(Songs.DateAdded))) < 90\<date added|sort order:desc>\<Album>
how to add PlayCounter = 0 ??

is this correct?

Code: Select all

AddedLastMonth|SQL filter:(julianday(date('now', 'localtime')) - julianday('1899-12-30 12:00') - julianday(date(Songs.DateAdded))) < 90 and PlayCounter = 0\<date added|sort order:desc>\<Album>

Re: Collection of most useful/wanted Magic Nodes masks [MM2+3]

Posted: Tue Sep 02, 2008 8:15 am
by ZvezdanD
tatoosh wrote:I've a problem in finding long track - longer than 30min (like DJ Mixes).
You should write:

Code: Select all

Mixe|SQL Filter:Songs.SongLength >= 1800000\<Album>
or just:

Code: Select all

Mixe|Filter:<Length> >= 1800000\<Album>
tatoosh wrote:is this correct?

Code: Select all

AddedLastMonth|SQL filter:(julianday(date('now', 'localtime')) - julianday('1899-12-30 12:00') - julianday(date(Songs.DateAdded))) < 90 and PlayCounter = 0\<date added|sort order:desc>\<Album>
Well, I suppose it is correct, but again there is shorter mask:

Code: Select all

AddedLastMonth|Filter:<Days since added> < 90 and <Played> = 0\<date added|sort order:desc>\<Album>

Re: Collection of most useful/wanted Magic Nodes masks [MM2+3]

Posted: Tue Sep 02, 2008 8:26 am
by tatoosh
Mixe|Filter:<Length> >= 1800000\<Album>
that works fine. thanks a lot.
AddedLastMonth|Filter:<Days since added> < 90 and <Played> = 0\<date added|sort order:desc>\<Album>
thx. is this only shorter and easier to understand or is there a speed advantage/disadvantage, too?