Bug #3268 » 3268.patch
| components/com_comprofiler/plugin/user/plug_cbmamboauthortab/cb.authortab.php | ||
|---|---|---|
|
|
||
|
$return = '';
|
||
|
|
||
|
$now = date( 'Y-m-d H:i:s', $_CB_framework->now() + $_CB_framework->getCfg( 'offset' ) * 60 * 60 );
|
||
|
if ( $jVer < 2 ) {
|
||
|
$now = date( 'Y-m-d H:i:s', $_CB_framework->now() + $_CB_framework->getCfg( 'offset' ) * 60 * 60 );
|
||
|
} else {
|
||
|
$now = JFactory::getDate()->toSql();
|
||
|
}
|
||
|
$query = "SELECT a.id, a.catid, a.title, a.hits,a.created, ROUND( r.rating_sum / r.rating_count ) AS rating,r.rating_count";
|
||
|
if ( $jVer >= 1 ) {
|
||
|
$query .= ', CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(\':\', a.id, a.alias) ELSE a.id END as slug,'
|
||