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

Download and get help for different MediaMonkey Addons.

Moderators: Peke, Gurus

ZvezdanD
Posts: 3112
Joined: Thu Jun 08, 2006 7:40 pm

Re: Magic Nodes 2.4 w/ 170+ masks & real GUI (2009-02-20)[MM2+3]

Post by ZvezdanD »

Weatherman wrote:"Error executing SQL "Select Count(*) As Count_ Unknown FROM Songs WHERE (Songs.lyrics = ") AND Songs.Id = Memos.Idsongs AND Memos.MemoType = 20000)
": No such column: Memos.MemoType (1, 1)
This SQL query is a strange combination of the code for MM2 and MM3. Which versions of MediaMonkey and Magic Nodes are you using?
Magic Nodes 4.3.3 / 5.2 RegExp Find & Replace 4.4.9 / 5.2  Invert Selection/Select None 1.5.1  Export/Create Playlists for Child Nodes 4.1.1 / 5.4.1  Expand Child Nodes/Expand All 1.1.2  Event Logger 2.7  Filtered Statistics Report 1.6  Track Redirection & Synchronization 3.4.2  Restore/Synchronize Database 3.1.8 / 4.0.1  Find Currently Playing Track 1.3.2  Queue List 1.2.1  Add to Library on Play 1.0.1  Tree Report for Child Nodes 1.1.1  Update Location of Files in Database 1.4.5 / 2.3  Inherit Child Playlists 1.0.3  Add Currently Playing/Selected Track(s) to Playlist 1.2
Weatherman
Posts: 154
Joined: Sun Nov 19, 2006 11:08 am
Contact:

Re: Magic Nodes 2.4 w/ 170+ masks & real GUI (2009-02-20)[MM2+3]

Post by Weatherman »

Hi again.

I am using MM3 version 3.1.0.1209 (Gold Lifetime) and Magic Nodes 2.4
Jim
Bex
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden
Contact:

Re: Magic Nodes 2.4 w/ 170+ masks & real GUI (2009-02-20)[MM2+3]

Post by Bex »

I'm not sure it will help in this case but you're using a very old beta of MM 3.1. Download the latest (currently 1235) from the last post here:
http://www.mediamonkey.com/forum/viewto ... =6&t=34522
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
Weatherman
Posts: 154
Joined: Sun Nov 19, 2006 11:08 am
Contact:

Re: Magic Nodes 2.4 w/ 170+ masks & real GUI (2009-02-20)[MM2+3]

Post by Weatherman »

Thanks for your help. I will try this. I didn't realise my version was so old...I was hanging on till the next release.
I'm very grateful for your help.
Jim
ZvezdanD
Posts: 3112
Joined: Thu Jun 08, 2006 7:40 pm

Re: Magic Nodes 2.4 w/ 170+ masks & real GUI (2009-02-20)[MM2+3]

Post by ZvezdanD »

Well, it is not so old. I will try to install exactly that version to see if I could reproduce a problem.
Magic Nodes 4.3.3 / 5.2 RegExp Find & Replace 4.4.9 / 5.2  Invert Selection/Select None 1.5.1  Export/Create Playlists for Child Nodes 4.1.1 / 5.4.1  Expand Child Nodes/Expand All 1.1.2  Event Logger 2.7  Filtered Statistics Report 1.6  Track Redirection & Synchronization 3.4.2  Restore/Synchronize Database 3.1.8 / 4.0.1  Find Currently Playing Track 1.3.2  Queue List 1.2.1  Add to Library on Play 1.0.1  Tree Report for Child Nodes 1.1.1  Update Location of Files in Database 1.4.5 / 2.3  Inherit Child Playlists 1.0.3  Add Currently Playing/Selected Track(s) to Playlist 1.2
ZvezdanD
Posts: 3112
Joined: Thu Jun 08, 2006 7:40 pm

Re: Magic Nodes 2.4 w/ 170+ masks & real GUI (2009-02-20)[MM2+3]

Post by ZvezdanD »

Just tried and as I supposed this old MM version works as it should. Only thing which comes to my mind is that you have old Pablos's version of the script (with the 1.3 version number in the filename) together in same Auto folder as the new version of the script.
Magic Nodes 4.3.3 / 5.2 RegExp Find & Replace 4.4.9 / 5.2  Invert Selection/Select None 1.5.1  Export/Create Playlists for Child Nodes 4.1.1 / 5.4.1  Expand Child Nodes/Expand All 1.1.2  Event Logger 2.7  Filtered Statistics Report 1.6  Track Redirection & Synchronization 3.4.2  Restore/Synchronize Database 3.1.8 / 4.0.1  Find Currently Playing Track 1.3.2  Queue List 1.2.1  Add to Library on Play 1.0.1  Tree Report for Child Nodes 1.1.1  Update Location of Files in Database 1.4.5 / 2.3  Inherit Child Playlists 1.0.3  Add Currently Playing/Selected Track(s) to Playlist 1.2
Weatherman
Posts: 154
Joined: Sun Nov 19, 2006 11:08 am
Contact:

Re: Magic Nodes 2.4 w/ 170+ masks & real GUI (2009-02-20)[MM2+3]

Post by Weatherman »

I just upgraded to latest version of MM. I removed all magic nodes reference files and reinstalled magic nodes (I had exported my favourite nodes).

It all works perfectly.

Many thanks. Much appreciated.
happy easter.
Jim
raybeau528
Posts: 401
Joined: Thu Sep 27, 2007 4:19 pm
Location: Connecticut
Contact:

Re: Magic Nodes 2.4 w/ 170+ masks & real GUI (2009-02-20)[MM2+3]

Post by raybeau528 »

ZvezdadD,

I have many Audiobooks (in MP3) and wrote this Magic Nodes mask to display just the Audiobooks by Album name. Makes it easy to find/select a book and its chapters.

Code: Select all

AudioBooks|Icon:Top level|Filter:<Genre> = "AudioBook"\<Genre|Statistic:Count(Album)>\<Album|Statistic:Count(All)>\<Artist>
Thanks for this great tool!

Ray
nynaevelan
Posts: 5559
Joined: Wed Feb 07, 2007 11:07 pm
Location: New Jersey, USA
Contact:

Re: Magic Nodes 2.4 w/ 170+ masks & real GUI (2009-02-20)[MM2+3]

Post by nynaevelan »

It's your favorite SQL PITA again, I want to make a Magic Node that lists the name of playlists for playlists which are in the DeviceTracks table and have the IDDevice of 67 but I am having trouble. This is what I came up with but it isn't working. Can you help me?

Code: Select all

<Group|Name:Played>\<Group|Name:Playlist Info>\X-Fi Playlist Sync List|Icon:Top level|SQL filter: Songs.ID IN (SELECT IDTrack FROM DeviceTracks) AND IDDevice = 67\<Artist>\<Title>\<Playlist|Unknown:No>
Be gentle, you know I do not know anything about SQL. :wink:

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
ZvezdanD
Posts: 3112
Joined: Thu Jun 08, 2006 7:40 pm

Re: Magic Nodes 2.4 w/ 170+ masks & real GUI (2009-02-20)[MM2+3]

Post by ZvezdanD »

nynaevelan wrote:I want to make a Magic Node that lists the name of playlists for playlists which are in the DeviceTracks table and have the IDDevice of 67
I don't understand that "playlists" part and I am not sure if this will work, but you could try:

Code: Select all

<Group|Name:Played>\<Group|Name:Playlist Info>\X-Fi Playlist Sync List|Icon:Top level|SQL filter: Songs.ID IN (SELECT IDTrack FROM DeviceTracks WHERE IDDevice = 67)\<Artist>\<Title>\<Playlist|Unknown:No>
nynaevelan wrote:Be gentle, you know I do not know anything about SQL. :wink:
:D Why are you telling this? Is there somebody who haven't been gentle to you? :) By the way, I do not agree that you don't know anything about SQL. You are much better than many.
Magic Nodes 4.3.3 / 5.2 RegExp Find & Replace 4.4.9 / 5.2  Invert Selection/Select None 1.5.1  Export/Create Playlists for Child Nodes 4.1.1 / 5.4.1  Expand Child Nodes/Expand All 1.1.2  Event Logger 2.7  Filtered Statistics Report 1.6  Track Redirection & Synchronization 3.4.2  Restore/Synchronize Database 3.1.8 / 4.0.1  Find Currently Playing Track 1.3.2  Queue List 1.2.1  Add to Library on Play 1.0.1  Tree Report for Child Nodes 1.1.1  Update Location of Files in Database 1.4.5 / 2.3  Inherit Child Playlists 1.0.3  Add Currently Playing/Selected Track(s) to Playlist 1.2
nynaevelan
Posts: 5559
Joined: Wed Feb 07, 2007 11:07 pm
Location: New Jersey, USA
Contact:

Re: Magic Nodes 2.4 w/ 170+ masks & real GUI (2009-02-20)[MM2+3]

Post by nynaevelan »

ZvezdanD wrote:
nynaevelan wrote:I want to make a Magic Node that lists the name of playlists for playlists which are in the DeviceTracks table and have the IDDevice of 67
I don't understand that "playlists" part and I am not sure if this will work, but you could try:

Code: Select all

<Group|Name:Played>\<Group|Name:Playlist Info>\X-Fi Playlist Sync List|Icon:Top level|SQL filter: Songs.ID IN (SELECT IDTrack FROM DeviceTracks WHERE IDDevice = 67)\<Artist>\<Title>\<Playlist|Unknown:No>
Thanks, the SQL works the way I want I just have to tweak it to list the actual playlist names, but I've been a little busy with something else so will test it in the next day or two.
ZvezdanD wrote:
nynaevelan wrote:Be gentle, you know I do not know anything about SQL. :wink:
:D Why are you telling this? Is there somebody who haven't been gentle to you? :) By the way, I do not agree that you don't know anything about SQL. You are much better than many.
:lol: If I am better than some than it is through no skill of mine, it is due to the assistance of you SQL experts, especially you, Bex and SBondi. Half the time I do not understand what I am looking at but I "think" I am pretty good at explaining what it is I want. I just hope I do not nag you all too much because without you my MM would be very plain and unorganized. :wink:

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
Big Isch
Posts: 112
Joined: Mon Mar 12, 2007 8:34 am
Location: Austria
Contact:

Re: Magic Nodes 2.4 w/ 170+ masks & real GUI (2009-02-20)[MM2+3]

Post by Big Isch »

Hi,
by using the simple Node:

Code: Select all

My Artist\<Artist|Statistic:Count(Items)>\<Album|Statistic:Count(Tracks)>
In MM 3.0.3.1148, the nodes dispalyed show e.g. "(12 Albums)" and "(144 tracks)",
but with MM 3.0.7.1191 nodes show "(12 Albums)" and "(144)" without "tracks".

Anyone any idea ? :roll:
aprzybylo
Posts: 301
Joined: Tue Aug 21, 2007 2:58 pm
Location: Ottawa, Canada
Contact:

Re: Magic Nodes 2.4 w/ 170+ masks & real GUI (2009-02-20)[MM2+3]

Post by aprzybylo »

Hello,
I have the problem with ratings. I created magic node where I display albums based on total of songs ratings. If I rate all songs then the total is correct. Also if I use bomb the total is correct (bomb being counter as 0). However if I leave one tract without rating my album disappears from the list (not sure if it is completely out or just no rating is counted as some negetive number and album is much lower in the list). Any idea how could I correct this without using "bomb" as 0 rating?
ZvezdanD
Posts: 3112
Joined: Thu Jun 08, 2006 7:40 pm

Re: Magic Nodes 2.4 w/ 170+ masks & real GUI (2009-02-20)[MM2+3]

Post by ZvezdanD »

Big Isch wrote:In MM 3.0.3.1148, the nodes dispalyed show e.g. "(12 Albums)" and "(144 tracks)",
but with MM 3.0.7.1191 nodes show "(12 Albums)" and "(144)" without "tracks".
This should not happen, especially should not have anything related to the version of MM. I just have installed mentioned MM version and everything is fine. You haven't mentioned which version of the script you are using, but I don't remember that any version had such behavior.

By the way, if you are using MM3 and MN 1.8 or up, it is better (faster) to use Count(Album) than Count(Items).
Magic Nodes 4.3.3 / 5.2 RegExp Find & Replace 4.4.9 / 5.2  Invert Selection/Select None 1.5.1  Export/Create Playlists for Child Nodes 4.1.1 / 5.4.1  Expand Child Nodes/Expand All 1.1.2  Event Logger 2.7  Filtered Statistics Report 1.6  Track Redirection & Synchronization 3.4.2  Restore/Synchronize Database 3.1.8 / 4.0.1  Find Currently Playing Track 1.3.2  Queue List 1.2.1  Add to Library on Play 1.0.1  Tree Report for Child Nodes 1.1.1  Update Location of Files in Database 1.4.5 / 2.3  Inherit Child Playlists 1.0.3  Add Currently Playing/Selected Track(s) to Playlist 1.2
ZvezdanD
Posts: 3112
Joined: Thu Jun 08, 2006 7:40 pm

Re: Magic Nodes 2.4 w/ 170+ masks & real GUI (2009-02-20)[MM2+3]

Post by ZvezdanD »

aprzybylo wrote:if I leave one tract without rating my album disappears from the list
Have you tried to turn off the option Tools / Options / Magic Nodes Settings / Display sorting/statistic results only if all values are defined?
Magic Nodes 4.3.3 / 5.2 RegExp Find & Replace 4.4.9 / 5.2  Invert Selection/Select None 1.5.1  Export/Create Playlists for Child Nodes 4.1.1 / 5.4.1  Expand Child Nodes/Expand All 1.1.2  Event Logger 2.7  Filtered Statistics Report 1.6  Track Redirection & Synchronization 3.4.2  Restore/Synchronize Database 3.1.8 / 4.0.1  Find Currently Playing Track 1.3.2  Queue List 1.2.1  Add to Library on Play 1.0.1  Tree Report for Child Nodes 1.1.1  Update Location of Files in Database 1.4.5 / 2.3  Inherit Child Playlists 1.0.3  Add Currently Playing/Selected Track(s) to Playlist 1.2
Post Reply