Vox Populi(x) forum

Alexandria Book Library => Supporto (Support) => Topic started by: BeniaminQB on 07 November 2011, 17:36:48

Title: Authors name saparated by ; in category listing
Post by: BeniaminQB on 07 November 2011, 17:36:48
I would like to have the authors name saparated by ; instead of , in the category listing. I managed to do it in search results, and book details, but not in category listing.

See the image for details

Thanks in advance for your support.
Title: Re: Authors name saparated by ; in category listing
Post by: BeniaminQB on 08 November 2011, 21:35:02
Never mind, solved. I didi it editing separator in /models/ files.
Title: Re: Authors name saparated by ; in category listing
Post by: federica on 11 November 2011, 12:43:39
Hi BeniaminQB,
ok, this is the only one solution.
Title: Re: Authors name saparated by ; in category listing
Post by: cutare on 21 November 2011, 12:22:50
BeniaminQB, how did you do exactly? where and what you changed?
Title: Re: Authors name saparated by ; in category listing
Post by: federica on 13 December 2011, 10:05:05
Hi cutare,
open the file <your_site>/components/com_abook/models/category.php
modify the row n°198 from:
$query = "SELECT idbook, GROUP_CONCAT(name ORDER BY name ASC SEPARATOR ', ') AS author "
to:
$query = "SELECT idbook, GROUP_CONCAT(name ORDER BY name ASC SEPARATOR '; ') AS author "

open the file <your_site>/components/com_abook/models/search.php
modify the row n°193 from:
$query = "SELECT idbook, GROUP_CONCAT(name ORDER BY name ASC SEPARATOR ', ') AS author "
to:
$query = "SELECT idbook, GROUP_CONCAT(name ORDER BY name ASC SEPARATOR '; ') AS author "

open the file <your_site>/components/com_abook/models/author.php
modify the row n°139 from:
$this->_authorname = implode(', ', $this->_authorname);
to:
$this->_authorname = implode('; ', $this->_authorname);