Magic Nodes 4.2 w/ 380 masks & real GUI (2011-07-01)[MM2+]

Post a reply

Visual Confirmation

To prevent automated access and spam, you are required to confirm that you are human. Please place a check mark next to all images of monkeys or apes. If you cannot see any images, please contact the Board Administrator.

Smilies
:D :) :( :o :-? 8) :lol: :x :P :oops: :cry: :evil: :roll: :wink:
BBCode is ON
[img] is ON
[flash] is OFF
[url] is ON
Smilies are ON
Topic review
   

Expand view Topic review: Magic Nodes 4.2 w/ 380 masks & real GUI (2011-07-01)[MM2+]

Re: Magic Nodes 4.2 w/ 380 masks & real GUI (2011-07-01)[MM2

Post by rrfpacker » Mon Sep 29, 2014 12:03 pm

ZvezdanD wrote:The new, donation-only version has improved work with the Magic nodes placed inside of the Playlists branch. I have a plan to fix some issues in the freely available version as well, but I am not sure when that will happen.


Thank you, I'll check out the donation version.

Re: Magic Nodes 4.2 w/ 380 masks & real GUI (2011-07-01)[MM2

Post by ZvezdanD » Sat Sep 27, 2014 6:20 pm

The new, donation-only version has improved work with the Magic nodes placed inside of the Playlists branch. I have a plan to fix some issues in the freely available version as well, but I am not sure when that will happen.

Re: Magic Nodes 4.2 w/ 380 masks & real GUI (2011-07-01)[MM2

Post by rrfpacker » Sat Sep 27, 2014 5:19 pm

First of all, thank you for this script. I don't use it to its full potential as it's very complicated for me, but what I do use is very helpful.

I use this modified Node as a playlist, along with four other variations. Roughly once a month I need to refresh the node to include rerated or new albums and when I right click on the node/playlist the Edit Magic Node, Refresh Magic Node, and Delete Magic Node menu options aren't available for at least one of 6 nodes I have created. I have to then copy one of the other nodes, add a "New" node, make the changes and "add". Does it make any sense that this would happen?


<Group|Name:Album Ratings|Show tracks:No>\xAlbums with avg. track rating >= 3.25 stars with at least 4 songs|Icon:Top level|Filter:Songs.IDAlbum In (SELECT IDAlbum FROM Songs WHERE Rating >= 0 GROUP BY IDAlbum HAVING Avg(Rating) >= 65 AND Count(Rating) >= 4)|Child of:Playlists|Position:Child\<Album|Statistic:Count(All)>

Re: Magic Nodes 4.2 w/ 380 masks & real GUI (2011-07-01)[MM2

Post by willyvds » Tue Sep 16, 2014 5:25 pm

OK! Thanks, Willy

Re: Magic Nodes 4.2 w/ 380 masks & real GUI (2011-07-01)[MM2

Post by ZvezdanD » Tue Sep 16, 2014 3:09 pm

willyvds wrote:I want a magic node with all songs without lyricist.

There are some examples in the Filter Examples folder how to get undefined multi-item fields. Just for you:
Code: Select all
<Multi Lyricist> = ''

Re: Magic Nodes 4.2 w/ 380 masks & real GUI (2011-07-01)[MM2

Post by willyvds » Tue Sep 16, 2014 2:57 pm

I want a magic node with all songs without lyricist. So I have made a filter:
<Lyricist> = ''
But this doesn't give any results. What could be the issue?
Regards, Willy

Re: Magic Nodes 4.2 w/ 380 masks & real GUI (2011-07-01)[MM2

Post by dtsig » Mon Sep 08, 2014 9:51 am

Mr Z you are the best. Looking forward to being more confused than I am now by this powerful pc of sw. Have a great day

Re: Magic Nodes 4.2 w/ 380 masks & real GUI (2011-07-01)[MM2

Post by ZvezdanD » Mon Sep 08, 2014 1:04 am

dtsig wrote:Z .. what is the newest version ofthis plugin?

5.0.1. You will receive it very soon, maybe even today.

Re: Magic Nodes 4.2 w/ 380 masks & real GUI (2011-07-01)[MM2

Post by dtsig » Sun Sep 07, 2014 7:49 pm

Z .. what is the newest version ofthis plugin?

Thanks

Re: Magic Nodes 4.2 w/ 380 masks & real GUI (2011-07-01)[MM2

Post by ZvezdanD » Sun Sep 07, 2014 12:24 pm

meeeoow wrote:this only works for the subnodes, if i click the root node every track shows up. But i want to be able to make a playlist of all top 3 tracks from every albumartist, so i need this in the sub node

The Top qualifier is fixed in the new donation-only version of this add-on. Maybe you could try with this Filter:
Code: Select all
Songs.ID IN (SELECT Songs.ID FROM Songs LEFT JOIN ArtistsAlbums ON Songs.IDAlbum = ArtistsAlbums.IDAlbum LEFT JOIN Artists AS AlbumArtists ON ArtistsAlbums.IDArtist = AlbumArtists.ID CROSS JOIN (SELECT ',' || Group_Concat(Songs.ID) || ',' AS ConcField, Songs.SongTitle || CASE WHEN Songs.Artist || Songs.Album <> '' THEN ' (' || Songs.Artist || CASE WHEN Songs.Artist <> '' AND Songs.Album <> '' THEN ' - ' ELSE '' END || Songs.Album || ')' ELSE '' END COLLATE IUNICODE AS CountField1, IfNull(AlbumArtists.ID, '') AS CountField2 FROM Songs LEFT JOIN ArtistsAlbums ON Songs.IDAlbum = ArtistsAlbums.IDAlbum LEFT JOIN Artists AS AlbumArtists ON ArtistsAlbums.IDArtist = AlbumArtists.ID CROSS JOIN (SELECT ',' || Group_Concat(TopConcField) || ',' AS ConcField, x'0100' || Group_Concat(CountField1, x'0100') || x'0100' AS TopField, CountField2 FROM (SELECT Group_Concat(Songs.ID) AS TopConcField, Songs.SongTitle || CASE WHEN Songs.Artist || Songs.Album <> '' THEN ' (' || Songs.Artist || CASE WHEN Songs.Artist <> '' AND Songs.Album <> '' THEN ' - ' ELSE '' END || Songs.Album || ')' ELSE '' END COLLATE IUNICODE AS CountField1, IfNull(AlbumArtists.ID, '') AS CountField2 FROM Songs LEFT JOIN ArtistsAlbums ON Songs.IDAlbum = ArtistsAlbums.IDAlbum LEFT JOIN Artists AS AlbumArtists ON ArtistsAlbums.IDArtist = AlbumArtists.ID WHERE Songs.SongTitle || CASE WHEN Songs.Artist || Songs.Album <> '' THEN ' (' || Songs.Artist || CASE WHEN Songs.Artist <> '' AND Songs.Album <> '' THEN ' - ' ELSE '' END || Songs.Album || ')' ELSE '' END COLLATE IUNICODE <> '' GROUP BY CountField1, CountField2 ORDER BY CountField2, Sum(<Playcount>) DESC, Songs.SongTitle || CASE WHEN Songs.Artist || Songs.Album <> '' THEN ' (' || Songs.Artist || CASE WHEN Songs.Artist <> '' AND Songs.Album <> '' THEN ' - ' ELSE '' END || Songs.Album || ')' ELSE '' END COLLATE IUNICODE) GROUP BY CountField2) AS CountTable2 ON IfNull(AlbumArtists.ID, '') = CountTable2.CountField2 AND CountTable2.ConcField LIKE '%,' || Songs.ID || ',%' AND InStr(Replace(CountTable2.TopField, Songs.SongTitle || CASE WHEN Songs.Artist || Songs.Album <> '' THEN ' (' || Songs.Artist || CASE WHEN Songs.Artist <> '' AND Songs.Album <> '' THEN ' - ' ELSE '' END || Songs.Album || ')' ELSE '' END COLLATE IUNICODE, x'0200'), x'0100' || x'0200') - Length(Replace(SubStr(CountTable2.TopField, 1, InStr(Replace(CountTable2.TopField, Songs.SongTitle || CASE WHEN Songs.Artist || Songs.Album <> '' THEN ' (' || Songs.Artist || CASE WHEN Songs.Artist <> '' AND Songs.Album <> '' THEN ' - ' ELSE '' END || Songs.Album || ')' ELSE '' END COLLATE IUNICODE, x'0200'), x'0100' || x'0200')), x'0100', '')) BETWEEN 1 AND 3 GROUP BY CountField1, CountField2) AS CountTable2 ON Songs.SongTitle || CASE WHEN Songs.Artist || Songs.Album <> '' THEN ' (' || Songs.Artist || CASE WHEN Songs.Artist <> '' AND Songs.Album <> '' THEN ' - ' ELSE '' END || Songs.Album || ')' ELSE '' END COLLATE IUNICODE = CountTable2.CountField1 AND IfNull(AlbumArtists.ID, '') = CountTable2.CountField2 AND CountTable2.ConcField LIKE '%,' || Songs.ID || ',%')

Re: Magic Nodes 4.2 w/ 380 masks & real GUI (2011-07-01)[MM2

Post by ZvezdanD » Sun Sep 07, 2014 12:05 pm

Just Guessing wrote:I need the album count NOT to include the artist's appearances on compilations!

This mask is already updated in the new donation-only version of this add-on, but it has some specifics that prevents it from using with the older versions. Here is the simplified downward compatible version:

Code: Select all
<Group|Name:Artists...|Show tracks:No>\Artists with at most 2 Albums having at least 5 files|Icon:Top level|Filter:Songs.IDAlbum || '@' || SongArtists.ID IN (SELECT DISTINCT IDAlbum || '@' || T0.IDArtist FROM Songs INNER JOIN ArtistsSongs ON Songs.ID = ArtistsSongs.IDSong AND IfNull(ArtistsSongs.PersonType, 1) = 1 INNER JOIN Artists ON ArtistsSongs.IDArtist = Artists.ID INNER JOIN (SELECT IDArtist, ',' || RTrim(Group_Concat(IDAlbum)) || ',' AS ConcFld FROM Albums INNER JOIN (SELECT IDAlbum, ArtistsSongs.IDArtist, Count(*) AS CountFld1 FROM Songs INNER JOIN ArtistsSongs ON Songs.ID = ArtistsSongs.IDSong AND IfNull(ArtistsSongs.PersonType, 1) = 1 INNER JOIN Artists ON ArtistsSongs.IDArtist = Artists.ID GROUP BY IDAlbum, ArtistsSongs.IDArtist) ON ID = IDAlbum AND Tracks = CountFld1 WHERE Tracks >= 5 AND IDAlbum > 0 GROUP BY IDArtist HAVING Count(*) <= 2) AS T0 ON T0.IDArtist = ArtistsSongs.IDArtist AND T0.ConcFld Like '%,' || Songs.IDAlbum || ',%')\<Artist|Statistic:Count(Album), Count(Tracks)|Show rank:Yes|Unknown:No>\<Album|Statistic:Count(Tracks)|Unknown:No>


If that doesn't work as you want, you could try this:
Code: Select all
<Group|Name:Artists...|Show tracks:No>\Album Artists with at most 2 Albums having at least 5 files|Icon:Top level|Filter:Songs.IDAlbum || '@' || AlbumArtists.ID IN (SELECT DISTINCT Songs.IDAlbum || '@' || T0.IDArtist FROM Songs INNER JOIN ArtistsAlbums ON Songs.IDAlbum = ArtistsAlbums.IDAlbum INNER JOIN Artists ON ArtistsAlbums.IDArtist = Artists.ID INNER JOIN (SELECT IDArtist, ',' || RTrim(Group_Concat(IDAlbum)) || ',' AS ConcFld FROM (SELECT Songs.IDAlbum, ArtistsAlbums.IDArtist, Count(*) AS CountFld1 FROM Songs INNER JOIN ArtistsAlbums ON Songs.IDAlbum = ArtistsAlbums.IDAlbum INNER JOIN Artists ON ArtistsAlbums.IDArtist = Artists.ID GROUP BY Songs.IDAlbum, ArtistsAlbums.IDArtist) INNER JOIN Albums ON ID = IDAlbum AND Tracks = CountFld1 WHERE Tracks >= 5 AND IDAlbum > 0 GROUP BY IDArtist HAVING Count(*) <= 2) AS T0 ON T0.IDArtist = ArtistsAlbums.IDArtist AND T0.ConcFld Like '%,' || Songs.IDAlbum || ',%')\<Album Artist|Statistic:Count(Album), Count(Tracks)|Show rank:Yes|Unknown:No>\<Album|Statistic:Count(Tracks)|Unknown:No>

Re: Magic Nodes 4.2 w/ 380 masks & real GUI (2011-07-01)[MM2

Post by ZvezdanD » Sun Sep 07, 2014 11:57 am

slvbeard wrote:Trying to create a node to filter "Tracks with the Track Number on the begin of the Filename" but no luck, any ideas?

Code: Select all
<Group|Name:Tracks...>\Tracks with the Track number on the begin of the Filename|Filter:Songs.TrackNumber = SubStr(<File name>, 1, Length(Songs.TrackNumber)) AND Length(Songs.TrackNumber)|Icon:Top level\<Title|Trim:1>\<Title with artist>

Re: Magic Nodes 4.2 w/ 380 masks & real GUI (2011-07-01)[MM2

Post by slvbeard » Wed Aug 27, 2014 5:38 pm

Trying to create a node to filter "Tracks with the Track Number on the begin of the Filename" but no luck, any ideas?

Re: Magic Nodes 4.2 w/ 380 masks & real GUI (2011-07-01)[MM2

Post by Just Guessing » Fri Aug 01, 2014 1:25 pm

Forgive me if this is addressed earlier, but 146 pages of posts on this script!!!!!!!!!

I Need help on a tweak to a derived node query from the awesome supplied .ini file: Mask20 (retooled): Artists with LESS than THREE Albums...
Filter:Songs.ID = AArtistsSongs.IDSong ... ...GROUP BY ArtistsSongs.IDArtist HAVING Count(DISTINCT Songs.IDAlbum) <3)

I need the album count NOT to include the artist's appearances on compilations! I want only albums actually by the artist considered in the '<3' count.

I could screen <Album Artist> <> 'Misc" OR <Album Artist> <> 'Various'; but that screening needs to happen in the ALBUM COUNT portion of the filter's 'GROUP BY' only. (And my experimentations prove, unfortunately, that I really don't have much understanding of the query syntax)

elaboration (if helpful):
beneath a genre I want two nodes;
1) 'Superstars' (more than 3 albums, excluding everyone else. Screening is easy by initially not including 'Misc' & 'Various' Album Artist, then counting albums)
2) 'all the rest' - but this filter is harder because the album count for artists appearing on compilations will leave them off the node results. The ALBUM count is necessarily more elaborate - and beyond my skills!

Thanks for any suggestions.

Re: Magic Nodes 4.2 w/ 380 masks & real GUI (2011-07-01)[MM2

Post by ZvezdanD » Sat Jul 19, 2014 12:23 am

popsmike wrote:@Zvezdan

Hey man any news on the release of the updated full version to us who donated that are anticipating its appearance. :D

Keep it up man, those who don't contribute are missing something extra within its workings. :wink:

Don't worry. You will receive the updated version as soon as it is ready.

Top