by thefaceman » Tue May 28, 2013 10:35 am
I have another Magic Node editing request.
I have Magic Node script that currently is OK, but I want to add a 'field' exception.
The script finds a list of all of the 'weird characters' i do not want in my titles, but there are a few 'exceptions' to this rule. So in order to ID them I have put 'zzOK' in the Genre field, so that I know the
'weird value' is OK. But I would rather that once I put the value zzOK in the Genre field it will no longer appear in the Magic Node search. So I tried to ad an exemption, but I got an error.
Here is the working script
<Group|Name:Title WEIRD Chars...|Show tracks:No>\Featuring WEIRD Chars In title|Icon:Top level\<Title|Unknown:No|Statistic:Count(All)|Ex Right of: feat. | FT |featuring |acoustic) (demo|okay|vs. |w/|w/ |,,| ,|/|duet |feat |feat.|0,|,0|n' |' | '|"|~|!|`|´|@|#|$|%|^|&|*|=|_|+|?|()| )|( |]|[|}|{|À|Á|Â|Ã|Ä|Å|Æ|Ç|È|É|Ê|Ë|Ì|Í|Î|Ï|Ñ|Ò|Ó|Ô|Õ|à|ã|ä|å|è|é|ð|ñ|ò|ó|ô|õ|ö|ù|ú|ü|°|presents >
Here is what I tried by adding an SQL query to the script above but it created an error. I do not know how to edit it correctly
Here is my 'error' script
<Group|Name:Title WEIRD Chars...|Show tracks:No>\Featuring WEIRD Chars In title|Icon:Top level|Filter:AND Genres.GenreName <> 'zzOk' AND Songs.ID = GenresSongs.IDSong AND GenresSongs.IDGenre = Genres.IDGenre\<Title|Unknown:No|Statistic:Count(All)|Ex Right of: feat. | FT |featuring |acoustic) (demo|okay|vs. |w/|w/ |,,| ,|/|duet |feat |feat.|0,|,0|n' |' | '|"|~|!|`|´|@|#|$|%|^|&|*|=|_|+|?|()| )|( |]|[|}|{|À|Á|Â|Ã|Ä|Å|Æ|Ç|È|É|Ê|Ë|Ì|Í|Î|Ï|Ñ|Ò|Ó|Ô|Õ|à|ã|ä|å|è|é|ð|ñ|ò|ó|ô|õ|ö|ù|ú|ü|°|presents >
I am also still looking for help with my other Magic Node request two posts above
I have another Magic Node editing request.
I have Magic Node script that currently is OK, but I want to add a 'field' exception.
The script finds a list of all of the 'weird characters' i do not want in my titles, but there are a few 'exceptions' to this rule. So in order to ID them I have put 'zzOK' in the Genre field, so that I know the
'weird value' is OK. But I would rather that once I put the value zzOK in the Genre field it will no longer appear in the Magic Node search. So I tried to ad an exemption, but I got an error.
Here is the working script
<Group|Name:Title WEIRD Chars...|Show tracks:No>\Featuring WEIRD Chars In title|Icon:Top level\<Title|Unknown:No|Statistic:Count(All)|Ex Right of: feat. | FT |featuring |acoustic) (demo|okay|vs. |w/|w/ |,,| ,|/|duet |feat |feat.|0,|,0|n' |' | '|"|~|!|`|´|@|#|$|%|^|&|*|=|_|+|?|()| )|( |]|[|}|{|À|Á|Â|Ã|Ä|Å|Æ|Ç|È|É|Ê|Ë|Ì|Í|Î|Ï|Ñ|Ò|Ó|Ô|Õ|à|ã|ä|å|è|é|ð|ñ|ò|ó|ô|õ|ö|ù|ú|ü|°|presents >
Here is what I tried by adding an SQL query to the script above but it created an error. I do not know how to edit it correctly
Here is my 'error' script
<Group|Name:Title WEIRD Chars...|Show tracks:No>\Featuring WEIRD Chars In title|Icon:Top level|Filter:AND Genres.GenreName <> 'zzOk' AND Songs.ID = GenresSongs.IDSong AND GenresSongs.IDGenre = Genres.IDGenre\<Title|Unknown:No|Statistic:Count(All)|Ex Right of: feat. | FT |featuring |acoustic) (demo|okay|vs. |w/|w/ |,,| ,|/|duet |feat |feat.|0,|,0|n' |' | '|"|~|!|`|´|@|#|$|%|^|&|*|=|_|+|?|()| )|( |]|[|}|{|À|Á|Â|Ã|Ä|Å|Æ|Ç|È|É|Ê|Ë|Ì|Í|Î|Ï|Ñ|Ò|Ó|Ô|Õ|à|ã|ä|å|è|é|ð|ñ|ò|ó|ô|õ|ö|ù|ú|ü|°|presents >
I am also still looking for help with my other Magic Node request two posts above