Vox Populi(x) forum
21 Maggio 2012, 03:07:06 *
   Indice   Aiuto Ricerca Accedi Registrati  
Pagine: [1]
  Stampa  
Autore Discussione: authors order  (Letto 293 volte)
mago78
Coccinella
*

Karma: +0/-0
Scollegato Scollegato

Messaggi: 5


Mostra profilo
« inserita:: 19 Luglio 2011, 12:50:30 »

how at all again how can i set ascending order for the authors now it is in descending and i can't change it

thank at all
Vox Populi(x) forum
« inserita:: 19 Luglio 2011, 12:50:30 »

 
federica
Amministratore
Volpe
*****

Karma: +0/-0
Scollegato Scollegato

Messaggi: 299



Mostra profilo WWW
« Risposta #1 inserita:: 20 Luglio 2011, 20:36:14 »

Hi mago78,
are you talking about a view in the frontend or backend? Send me the link or a print screen.
Vox Populi(x) forum
« Risposta #1 inserita:: 20 Luglio 2011, 20:36:14 »

 
mago78
Coccinella
*

Karma: +0/-0
Scollegato Scollegato

Messaggi: 5


Mostra profilo
« Risposta #2 inserita:: 21 Luglio 2011, 12:54:46 »

Hi i mean that in front hand authors are ordered in descending order and I need when I have a book schede authors have to  be ordered from a to z and i can't do it... Can you help me???
federica
Amministratore
Volpe
*****

Karma: +0/-0
Scollegato Scollegato

Messaggi: 299



Mostra profilo WWW
« Risposta #3 inserita:: 25 Luglio 2011, 15:34:51 »

Ok, I understand!
Edit the file <your_site>/component/com_abook/models/category.php and change the row 65
from
Codice: [Select]
$query = "SELECT a.*, GROUP_CONCAT(bb.name SEPARATOR ', ') AS author, "to
Codice: [Select]
$query = "SELECT a.*, GROUP_CONCAT(bb.name ORDER BY bb.name ASC SEPARATOR ', ') AS author, "
edit the file <your_site>/component/com_abook/models/book.php and change the row 136
from
Codice: [Select]
' WHERE b.idbook = '. (int) $this->_id ;to
Codice: [Select]
' WHERE b.idbook = '. (int) $this->_id .
' ORDER BY author ASC ';

edit the file <your_site>/component/com_abook/models/search.php and change the row 129
from
Codice: [Select]
$query = " SELECT a.*, a.title AS booktitle, cat.title AS cattitle, GROUP_CONCAT(bb.name SEPARATOR ', ') AS author,  "to
Codice: [Select]
$query = " SELECT a.*, a.title AS booktitle, cat.title AS cattitle, GROUP_CONCAT(bb.name ORDER BY bb.name ASC SEPARATOR ', ') AS author,  "
This fix will be included in next version.
Vox Populi(x) forum
« Risposta #3 inserita:: 25 Luglio 2011, 15:34:51 »

 
Pagine: [1]
  Stampa  
 
 

A cura di Neomediatech