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

ZvezdanD · Post by **ZvezdanD** » Tue Sep 04, 2007 3:43 pm

nojac wrote:I had a MagicNode for incomplete albums (Originally from Teknojnky, I think):

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:yes\<Album Artist>\<Album|statistic:count(all)>
It is not working any more in MM3 B1. ("no such column: SONGORDER(1)") Any suggestion for an alternative?

Hmm... It is working for me in beta 1. When I look database in SQLite Spy, there is SongOrder column as well as TrackNumber which mentioned Bex. Difference is in +1 value.

How did you got the database? Did you deleted previous one and created new from the ground, or did you just let program to convert old one during installation?

EDIT: I see now that also there are DiscNo and DiscNumber. Strange.

Bex · Post by **Bex** » Tue Sep 04, 2007 3:51 pm

I don't have any songorder field?

ZvezdanD · Post by **ZvezdanD** » Tue Sep 04, 2007 3:54 pm

How did you got the database?

Bex · Post by **Bex** » Tue Sep 04, 2007 4:00 pm

Renamed the old one so it's a new fresh one! I guess thats the bets way with all these alphas. Oh, and it's converted from MM2 but I don't think that matters.

ZvezdanD · Post by **ZvezdanD** » Tue Sep 04, 2007 4:08 pm

Well, I think it is a catch. In my case program converted old one (MM3A7) during installation.

Bex · Post by **Bex** » Tue Sep 04, 2007 4:16 pm

Actually, I remember now that SQLite can't delete columns. It can only add them to a table. So I guess that's why since you upgraded from a previous version.

danhackley · Post by **danhackley** » Thu Sep 06, 2007 6:55 pm

Can't quite get this code right, maybe somebody can help :

Album Artist|child of:Artist\<album artist|statistic:count(all)>\<album|sort by:max(year)|sort order:asc|statistic:count(all)>

This code lists album artists alphabetically, with the number of tracks for each artist in brackets next to it. Expanding an artist lists the albums in increasing date (2001,2002, etc).

I want the number of albums rather than the number of tracks for each artist in brackets. Also, I would like artists to be grouped by letters (e.g. A-Z). Can anyone help ?

ZvezdanD · Post by **ZvezdanD** » Thu Sep 06, 2007 7:08 pm

danhackley wrote:I want the number of albums rather than the number of tracks for each artist in brackets.

Currently, this is not possible.

danhackley wrote:Also, I would like artists to be grouped by letters (e.g. A-Z).

Like this:

Code: Select all

Album Artist|child of:Artist\<album artist|trim:1>\<album artist|statistic:count(all)>\<album|sort by:max(year)|sort order:asc|statistic:count(all)>

danhackley · Post by **danhackley** » Sat Sep 08, 2007 5:07 am

Thanks, I will try that.

However, just now my Mediamonkey is on hold, as last time I started up I got a "disk read error Press Ctrl + Alt + Del to restart" and I cannot boot my computer up.

As soon as/if I get it fixed, I will try your code, thanks.

danhackley · Post by **danhackley** » Sun Sep 09, 2007 9:38 am

Can somebody help with code for the following - I can't seem to get it right !

I want a genre node to open into <genre> with <number of items>. when i open a genre, I want it to list all albums of that genre, in order of album artist.

Any help appreciated !!

ZvezdanD · Post by **ZvezdanD** » Sun Sep 09, 2007 5:41 pm

I am not sure that I understand what you want. You could try this:

Code: Select all

Genre by Album artist\<genre|statistic:count(all)>\<album and year>

Guest · Post by **Guest** » Sun Sep 09, 2007 6:11 pm

That is almost what I want, thanks !

I would like also the albums with the same album artist to be grouped together (so instead of listing e.g. pink floyd six times, I would like it to list pink floyd once, with the option of expanding that part of the tree by clicking on +).

e.g.

Genre
- Rock
- Pink Floyd (no. of tracks [or if possible, albums])
- Dark Side Of The Moon
- The Wall
- Wish You Were Here, etc

danhackley · Post by **danhackley** » Sun Sep 09, 2007 6:18 pm

Sorry forgot to log in for above.

Ideally my tree structure for genre would be (e.g.):

Genre (no. of tracks/albums)
- Rock (no. of tracks/albums)
- Pink Floyd (no. of tracks [or if possible, albums])
- Dark Side Of The Moon
- The Wall
- Wish You Were Here, etc

ZvezdanD · Post by **ZvezdanD** » Sun Sep 09, 2007 6:52 pm

This is not possible. You could get only this:

Code: Select all

Root
+- Rock (no. of tracks)
   +- Pink Floyd (no. of tracks)
      +- Dark Side Of The Moon
      +- The Wall
      +- Wish You Were Here

With this:

Code: Select all

Genre, Album artist, Album\<genre|statistic:count(all)>\<album artist|statistic:count(all)>\<album>

Big_Berny · Post by **Big_Berny** » Sun Sep 09, 2007 8:16 pm

Hi ZcezdanD,
a little question: It's possible to create a node where all songs must have a rating which is divideable by 10? So 10, 20, 30, 40 and so on?

Regards
Big_Berny