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

[ZvezdanD]

Is it also possible to sort these results by order of play on that day one year ago?

Sorry, this is not possible because this information is not included in MN fields. Well, theoretically you could do that by manual modifying of the SQL query adding different sort order then that generated by the script, but you shoud do that every time when you click on that node which I suppose is not what you want.

[Onweerwolf]

Okay, that's too bad but thanks for explaining.

Maybe something for a future update? I don't know how difficult it would be to code such a thing though..

[ZvezdanD]

Maybe something for a future update? I don't know how difficult it would be to code such a thing though..

Maybe But, after some more thinking I got to conclusion that this is not so simple, because the information that you want is not uniform. Some track could have several records about played date, even during one day, instead of the last played date which is unique for each track. So, if you display tracks played on some day, which playing date/time you want to take for sorting, (the last one, the first one...)? But first of all, you should tell me on what sorting do you mean. You know, there are sorting of nodes in the tree panel and sorting of tracks in the tracklist.

[Onweerwolf]

Maybe something for a future update? I don't know how difficult it would be to code such a thing though..

Maybe But, after some more thinking I got to conclusion that this is not so simple, because the information that you want is not uniform. Some track could have several records about played date, even during one day, instead of the last played date which is unique for each track. So, if you display tracks played on some day, which playing date/time you want to take for sorting, (the last one, the first one...)? But first of all, you should tell me on what sorting do you mean. You know, there are sorting of nodes in the tree panel and sorting of tracks in the tracklist.

True about the multiple plays on one day. Personally I would like to see a list of tracks that reflect all plays on that certain date, meaning that if one track was played more than once it should also be listed more than once in the tracklist that results from the mask.

As for the sorting: I'm mostly interested in the correct order being displayed in the tracklist not so much in the tree panel.

What I want is be able to click once on the node and then have an exact list of every track that was played exactly one year ago, in the order in which they were played (which should obviously update when a new day begins at midnight).

[Bex]

Such nodes will be implemented in my PlayhIstory script when I get the time. I've been thinking about implementing it a long time now but I never get the time.

[Big_Berny]

Really great your UI! I'm working on one of my scripts and got remebered again how much time (and thinking) it needs to get it good!

[ZvezdanD]

Thanks I spent too much time on it, indeed.

[Bex]

Really nice work indeed! And yes, it does take forever to code a good working GUI especially if you provide various savable defaults etc...

[Teknojnky]

Hi ZvezdanD, not sure if your working on/with 3.1 beta's, but here is a list of the default magic nodes which do not seem to be functional with 3.1 (1208) & MN 2.0.4.

- album artist [a-z], album (by year) (tracklist works, expanding node does not: syntax error)
- One-Hit Wonders (tracklist works, expanding node does not: syntax error)
- High PlayCount or Rating Few Tracks (tracklist works, expanding node does not: syntax error)
- Artist does not equal Original Artist (tracklist works, expanding node does not: syntax error)
- Artists with more than 5 words in the name (tracklist works, expanding node does not: syntax error)
- Artists with more than 30 characters in the name (tracklist works, expanding node does not: syntax error)
- artists with more than one album (tracklist works, expanding node does not: syntax error)
- artists with different genres (tracklist works, expanding: syntax error)
- multi-item tracks\multi-artists (tracklist works, expanding: syntax error)

I can post screens of each of the errors later if you need, but I assume they should be easily reproducable and probably all related to the same error (expanding a node syntax error).

here is the first one screenshot

[ZvezdanD]

here is a list of the default magic nodes which do not seem to be functional with 3.1 (1208) & MN 2.0.4.

Sorry, but I cannot reproduce this problem. They work fine with 3.1.0.1208 for me. Have you tried with the restart of MM? Could you turn on the "Allow editing of SQL queries" and "Allow editing of SQL queries for the Unknown node" options and post SQL query of the first node (album artist [a-z], album (by year))?

[Bex]

I think i see why this happens. There is a single quote which isn't escaped. I guess it has to do with that you read the config in MM to get the "Ignore Prefixes" and tekno has configured a ' there, which actually is pretty smart.

[Teknojnky]

I think i see why this happens. There is a single quote which isn't escaped. I guess it has to do with that you read the config in MM to get the "Ignore Prefixes" and tekno has configured a ' there, which actually is pretty smart.

Ah yeah thats probly it.

I am ignoring

the,dj,",(,[,',!

[ZvezdanD]

There is a new revision (2.0.5) with removed this bug, thanks for the report. But, I suppose you still wouldn't get correct display and/or sorting order, because I am checking specified string with added one space character. It works with The, A, An, ... but it couldn't work with ', (, [... where you don't have a space character after it.

By the way, this bug has nothing with the latest beta versions of MM. It existed from the same begin, but nobody used such characters as prefixes until now

[danhackley]

Glad to see the excellent work here continuing. Have a script request - would there be a code that would list the last 1000 tracks played?
Many thanks!

[ZvezdanD]

would there be a code that would list the last 1000 tracks played?!

Code: Select all

Last 1000 played tracks|Filter:Songs.ID IN (SELECT ID FROM Songs ORDER BY LastTimePlayed DESC LIMIT 1000)\<Months since last played>\<Title>

Code: Select all

Tracks which played latest 1000 times|Filter:Songs.ID IN (SELECT ID FROM Songs INNER JOIN Played ON ID = IDSong ORDER BY PlayDate DESC LIMIT 1000)\<Months since last played>\<Title>