hello

what's your Music Collection order ID? you don't appear on our system as a customer...

thanks!

GErmi

Has a mod to address this been released? With so many other filters automatically sorting alphabetically you would think genres would as well. Can someone provide the file names and code to make this change, please?

*Yes, I have a paid license.

Thank you for any assistance.

[edit] Then again, the tags feature is rather useless for my site so perhaps I'll edit the language files and change "tags" to "genres" then code out the genre sections from the album/artist edit pages. Considering I can remove genres from the search options and that the tags field can be set for multi-select, this may work better anyway. Problem solved!

ok! so no need for the code, then?

The sorting code for genres would be much better but my solution works for now. Using the genres field would be better though because the charts modules allow filtering per genre.

How would we sort the Genre list to be alphabetical? We have not figured out a solution either.

in which page?

In the main area itself and on all pages. For example we wanted the genre list to show alphabetically both in the front end of Joomla and in admin side. This would make it easier for users when entering new artists/material or just searching by genre. We wanted to find a way to sort the genre listing alphabetically to make it easier for users. when a user selects it either in the front or even when adding new material they would be able to select a genre from the list that would be sorted alphabetically.

hopefully that answers your question. Thanks for your time.

Degarrin

ok, I see. well the thing is that you need to modify a few MySQL queries in a few files. are you comfortable with modifying MySQL code?
for instance, in /models/artist.php line 483 you have to add the statement

ORDER BY genre_name

to have it sorted alphabetically. do you know what I mean?

So using your example of /models/artist.php line 483, the SQL would go from this:

' SELECT * FROM #__muscol_genres '.
' WHERE parents = "0" '


to this:

' SELECT * FROM #__muscol_genres '.
' WHERE parents = "0" '
' ORDER BY genre_name '


Is that correct? I am pretty new to SQL, but if you tell me which files I need to update, then yes, I am comfortable enough to go in and modify the SQL.

Thank You
Degarrin

yes! that's correct. basically you need to do that in artists.php, albums.php and song.php

Actually, you left out the period at the end of the second line. Should be

' SELECT * FROM #__muscol_genres '.
' WHERE parents = "0" '.
' ORDER BY genre_name '

Also, in front-end files I believe you should do this to the helpers.php file not song.php. In the back-end (admin side), the files will be the same as Germi provided.



To also sort sub-genres, edit the same files by changing:

' OR parents LIKE "'.$genre->id.'" ) '

to:

' OR parents LIKE "'.$genre->id.'" ) '.
' ORDER BY genre_name '

Ah, thank you both. I got pulled off to work on something else, so I haven't had a chance to focus back on this yet, but when I do this information will make things much easier. :cheer:

so I am working on the same thing I have found the line in artists.php and changed it, and its alphabetical now.
But I dont have the albums.php just album.php withou this line in it.. and also song.php doesn't have that line..?
Dit the location chanced in the last MC?

TIA

Appie

[b]sorry.. which is the question? this thread is 4 years old...

I want to get my genre's alphabetical sorted, but cant find the file albums.php which I need to chance to get my genre sorted.
And the file song.php doesnt have the line:

' SELECT * FROM #__muscol_genres '.
' WHERE parents = "0" '.
' ORDER BY genre_name '

So maybe because its indeed an old thread the files got chanced or replaced in later updates from MC?

Should I make a new topic for it?

Appie

Thanks solved it by editing the helpers.php..

Appie