Author Topic: authors order  (Read 5851 times)

mago78

  • Guest
authors order
« on: 19 July 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

authors order
« on: 19 July 2011, 12:50:30 »

Offline federica

  • Amministratore
  • Delfino
  • *****
  • Posts: 1.069
  • Karma: +2/-0
Re: authors order
« Reply #1 on: 20 July 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.
Al mondo ci sono 10 tipi di persone, quelli che hanno capito il codice binario e quelli che non l'hanno capito.
http://www.antivirushelp.it
stacca la spina!

Vox Populi(x) forum

Re: authors order
« Reply #1 on: 20 July 2011, 20:36:14 »

mago78

  • Guest
Re: authors order
« Reply #2 on: 21 July 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???

Offline federica

  • Amministratore
  • Delfino
  • *****
  • Posts: 1.069
  • Karma: +2/-0
Re: authors order
« Reply #3 on: 25 July 2011, 15:34:51 »
Ok, I understand!
Edit the file <your_site>/component/com_abook/models/category.php and change the row 65
from
Code: [Select]
$query = "SELECT a.*, GROUP_CONCAT(bb.name SEPARATOR ', ') AS author, "to
Code: [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
Code: [Select]
' WHERE b.idbook = '. (int) $this->_id ;to
Code: [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
Code: [Select]
$query = " SELECT a.*, a.title AS booktitle, cat.title AS cattitle, GROUP_CONCAT(bb.name SEPARATOR ', ') AS author,  "to
Code: [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.
« Last Edit: 25 July 2011, 15:36:53 by federica »
Al mondo ci sono 10 tipi di persone, quelli che hanno capito il codice binario e quelli che non l'hanno capito.
http://www.antivirushelp.it
stacca la spina!

Vox Populi(x) forum

Re: authors order
« Reply #3 on: 25 July 2011, 15:34:51 »