0
Hello Germi and fellow Music Collectionists!
The ordering in the artist view is currently set to FORMAT but I'm trying to change it to Album title. I've had a go but so far my efforts have been unsuccessful.
How is this done?
Many thanks for any instructions.
The ordering in the artist view is currently set to FORMAT but I'm trying to change it to Album title. I've had a go but so far my efforts have been unsuccessful.
How is this done?
Many thanks for any instructions.
Responses (3)
-
Accepted Answer
-
Accepted Answer
0Sorry Germi, should of specified the version. Using Joomla 2.5!
This is the code to refresh your memory..
function getAlbumsData()
{
if (empty( $this->_albums_data )){
$query = ' SELECT * FROM #__muscol_format '.
' WHERE display_group = 0'.
' ORDER BY order_num ';
$this->_db->setQuery( $query );
$this->_albums_data = $this->_db->loadObjectList();
$types_array = $this->getTypesArray();
for($i=0;$i < count($this->_albums_data); $i++){
$format_id = $this->_albums_data[$i]->id;
$query = ' SELECT f.*,al.*,ar.artist_name,ar.letter,ge.genre_name '.
' FROM #__muscol_albums as al '.
' LEFT JOIN #__muscol_artists as ar ON ar.id = al.artist_id '.
' LEFT JOIN #__muscol_format as f ON f.id = al.format_id '.
' LEFT JOIN #__muscol_genres as ge ON ge.id = al.genre_id '.
' WHERE artist_id = '.$this->_id.
' AND (format_id = '.$format_id.' OR display_group = '.$format_id.')'.
' AND (part_of_set = 0 OR ( part_of_set != 0 AND show_separately = "Y" ) ) ' .
' ORDER BY name ';
-
Accepted Answer
Your Reply
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here.
Register Here »