Favorite Magic Nodes, Nodes

Download and get help for different MediaMonkey Addons.

Moderators: Peke, Gurus

Teknojnky
Posts: 5533
Joined: Tue Sep 06, 2005 11:01 pm
Contact:

Favorite Magic Nodes, Nodes

Post by Teknojnky » Wed Nov 08, 2006 1:04 pm

Because the main magic nodes has grown so huge, I'm starting this thread for listing your favorite magic nodes codes.

Please try to limit discussion to just the basic nodes list and include an explaination if needed for some of the more complicated ones.

Here are mine, I claim nothing about these I did, merely collected them from the forums.

(note these are copied from the mediamonkey.ini file because I am lazy)

Code: Select all

[CustomNodeMasks]
Mask1=Leveling\<leveling>\<format>

Mask2=BPM\<bpm>\<format>

Mask3=Encodings\<format>\<vbr>\<bitrate>

Mask4=One Hit Wonders\<artist|max tracks:5>

Mask5=Collections\<album artist|min tracks:200>\<album>

Mask6=Incomplete Albums|SQL filter: Songs.IDAlbum IN (SELECT IDAlbum FROM Songs GROUP BY IDAlbum HAVING Count(SongOrder) <> (Max(SongOrder+1)) AND Count(SongOrder) > 1)|show tracks:no\<Album Artist>\<Album>

Mask7=Cover types\<cover type>\<album>

Mask8=Cover-Storage|show tracks:no\<Cover Storage>

Mask9=Comments\<comment>

Mask11=Cover-Storage|show tracks:no\<Cover Storage|unknown:no>

Mask0=Multiple Bitrates|SQL Filter:Songs.IDAlbum IN (SELECT Inline1.IDAlbum FROM (SELECT IDAlbum, Bitrate FROM Songs WHERE Songs.VBR=0 GROUP BY IDAlbum, Bitrate HAVING IDAlbum>0) Inline1 GROUP BY Inline1.IDAlbum HAVING Count(Inline1.IDAlbum)>1)\<Album>\<bitrate>

Mask12=Occasion\<occasion>

Mask13=AddedLastWeek|SQL filter:DateDiff('d',Songs.DateAdded,Now)<7\<date added|sort order:desc>\<Album>

Mask14=Missing Genre by Artist\<genre>\<artist>

Mask15=ExtWithUPPERCASE|SQL filter: iif(SongTitle='',0,Asc(Left(IIf(Left(Right(songpath,3),1)='.',Right(songpath,2),IIf(Left(Right(songpath,4),1)='.',Right(songpath,3),IIf(Left(Right(songpath,5),1)='.',Right(songpath,4),IIf(Left(Right(songpath,6),1)='.',Right(songpath,5),Right([songpath],6))))),1))) Between 65 And 90\<Artist>

Mask16=Multiple Bitrates|SQL Filter:Songs.IDAlbum IN (SELECT Inline1.IDAlbum FROM (SELECT IDAlbum, Bitrate FROM Songs WHERE Songs.VBR=0 GROUP BY IDAlbum, Bitrate HAVING IDAlbum>0) Inline1 GROUP BY Inline1.IDAlbum HAVING Count(Inline1.IDAlbum)>1)\<Album>\<bitrate>

Mask17=Multiple Years in Album|SQL Filter:Songs.IDAlbum IN (SELECT Inline1.IDAlbum FROM (SELECT IDAlbum, Year FROM Songs GROUP BY IDAlbum, Year HAVING IDAlbum>0) Inline1 GROUP BY Inline1.IDAlbum HAVING Count(Inline1.IDAlbum)>1)\<Album>

Mask18=Multiple Genres in Artists|SQL Filter:Songs.IDArtist IN (SELECT Inline1.IDArtist FROM (SELECT IDArtist, Genre FROM Songs GROUP BY IDArtist , Genre HAVING IDArtist >0) Inline1 GROUP BY Inline1.IDArtist HAVING Count(Inline1.IDArtist )>1)\<Artist>

Mask19=Multiple Genres in Album|SQL Filter:Songs.IDAlbum IN (SELECT Inline1.IDAlbum FROM (SELECT IDAlbum, Genre FROM Songs GROUP BY IDAlbum, Genre HAVING IDAlbum>0) Inline1 GROUP BY Inline1.IDAlbum HAVING Count(Inline1.IDAlbum)>1)\<Album>
Last edited by Teknojnky on Wed Nov 08, 2006 6:01 pm, edited 1 time in total.

Node

Post by Node » Wed Nov 08, 2006 1:32 pm

Great initiative.

Well done, Teknojnky :)

Note

Post by Note » Wed Nov 08, 2006 1:59 pm

I will add these:

1.

Code: Select all

Songs with Lyrics|SQL filter: exists (select * from memos where memotype = 20000 and idsong=songs.id)\<Album>
2.

Code: Select all

Songs with No Lyrics|SQL filter: not exists (select * from memos where memotype = 20000 and idsong=songs.id)\<Album>
3.

Code: Select all

Classical|child of:album|icon:bottom level|filter:left(genre,9)='Classical'\<composer>\<artist>\<album>
4.

Code: Select all

When Album Added|icon:top level|show tracks:no\<album|sort by:min(days since added)>\<date added>

All are self explanatory.

Bex
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Post by Bex » Wed Nov 08, 2006 5:42 pm

God idea Tekno!
Here's mine:

Code: Select all

Mask2=LowerCase|SQL filter: iif(SongTitle='',0,Asc(Left(SongTitle,1))) Between 97 And 122\<Artist>
Mask3=TitleStartWithNumber|SQL filter: iif(SongTitle='',0,Asc(Left(SongTitle,1))) Between 48 And 57\<Artist>
Mask4=TitleStartWithVinylNr|SQL filter: SongTitle like '[a-d][0-9]%'\<Artist>
Mask5=TitleStartWithInvalid|SQL filter: SongTitle Not like '[a-z]%' AND SongTitle Not like '[0-9]%'\<Artist>
Mask6=TitleStartWith2Number|SQL filter: SongTitle like '[0-9][0-9][_-]%'\<Artist>
Mask7=TitleStartWithBlank|SQL filter: iif(SongTitle='',0,Asc(Left(SongTitle,1))) = 32\<Artist>
Mask14=FindPresFtVs|SQL filter: IIf(InStr(Artists.Artist,' pres. ')>0 And Asc(Mid(Artists.Artist,(InStr(Artists.Artist,' pres. ')+1),1))=80,1,IIf(InStr(Artists.Artist,' vs. ')>0 And Asc(Mid(Artists.Artist,(InStr(Artists.Artist,' vs. ')+1),1))=86,1,IIf(InStr(Artists.Artist,' ft. ')>0 And Asc(Mid(Artists.Artist,(InStr(Artists.Artist,' ft. ')+1),1))=70,1,0)))=1\<artist>
Mask15=_ In Title Artist Album|SQL filter: (SongTitle like '%[_]%' or Artist like '%[_]%' or Album like '%[_]%')\<Artist>\<Album>
Mask20=Played This week|SQL filter:songs.id in (select idsong from played where Format(PlayDate,'yyyyw')=Format(date(),'yyyyw'))\<artist>
Mask29=Played Last Week|SQL filter: Datevalue(LastTimePlayed) > (date()-7)\<artist>
Mask30=Album Artist Index (Big Files)|sql filter:SongLength>1800000|Child of:Artist\<Album artist>\<album>
I must comment that I recognise a lot of the codes you two posted. :D
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!

All My Scripts

Steegy
Posts: 3452
Joined: Sat Nov 05, 2005 7:17 pm
Location: Belgium
Contact:

Post by Steegy » Sun Nov 12, 2006 9:37 pm

These add genre groups for Rock, Pop and Trance, next to the main Genre node:

Code: Select all

Group Rock|filter: Genre LIKE '%Rock%'|child of:genre|icon:top level\<Genre>\<Album Artist>\<Album>
Group Pop|filter: Genre LIKE '%Pop%'|child of:genre|icon:top level\<Genre>\<Album Artist>\<Album>
Group Trance|filter: Genre LIKE '%Trance%'|child of:genre|icon:top level\<Genre>\<Album Artist>\<Album>
E.g. the "Album Rock", "Indie Rock", "Hard Rock", "Punk Rock", ... genres are all grouped under the "Group Rock" node.
E.g. the "Ambient Pop", "Jangle Pop", "Pop", "Synth Pop", ... genres are all grouped under the "Group Pop" node.
E.g. the "Ambient Trance", "Dream Trance", "Progressive Trance", "Vocal Trance", ... genres are all grouped under the "Group Trance" node.
Extensions: ExternalTools, ExtractFields, SongPreviewer, LinkedTracks, CleanImport, and some other scripts (Need Help with Addons > List of All Scripts).

Post Reply