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 Ashran » Thu Oct 23, 2014 3:55 am

Hi I have a trouble with a custom node that was working fine until I donated and installed the special donator version of magic nodes.

Here is a screenshot

Image

And here is the error produced:

Image

the actual code is the following:

Code: Select all
Songs.ID = AArtistsSongs.IDSong AND (AArtistsSongs.PersonType = 1 OR AArtistsSongs.PersonType IS NULL) AND AArtistsSongs.IDArtist IN (SELECT ArtistsSongs.IDArtist FROM Songs, ArtistsSongs WHERE Songs.ID = ArtistsSongs.IDSong AND (ArtistsSongs.PersonType = 1 OR ArtistsSongs.PersonType IS NULL) GROUP BY ArtistsSongs.IDArtist HAVING Sum(PlayCounter) = 0) AND Genres.GenreName <> 'podcast'


and the complete mask is the following:

Code: Select all
<Group|Name:Random|Show tracks:No>\600 Random Tracks of never played Artists|Icon:Top level|Filter:Songs.ID = AArtistsSongs.IDSong AND (AArtistsSongs.PersonType = 1 OR AArtistsSongs.PersonType IS NULL) AND AArtistsSongs.IDArtist IN (SELECT ArtistsSongs.IDArtist FROM Songs, ArtistsSongs WHERE Songs.ID = ArtistsSongs.IDSong AND (ArtistsSongs.PersonType = 1 OR ArtistsSongs.PersonType IS NULL) GROUP BY ArtistsSongs.IDArtist HAVING Sum(PlayCounter) = 0) AND Genres.GenreName <> 'podcast' \<Title with artist plus album|Sort order:Random|Top:600|Show rank:Yes>


I don't know why it's not working anymore, could some one help me make it work again ?

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

Post by iain2020 » Tue Oct 14, 2014 6:37 am

I'm having trouble getting a node that does this:

50 random tracks from those having 5.0 Stars.


This is what i've got but it not right

SELECT Songs.ID FROM Songs HAVING (Rating BETWEEN 95.0 AND 100.0) ORDER BY Random() LIMIT 50

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

Post by lostinthought » Fri Oct 03, 2014 2:58 pm

I sent my donation yestarday via Paypal...please send me the addon. Can't wait to play around with the new version.

Thanks!

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>

Top