PDA

Zobacz pełną wersję : Joomgallery tytul toplista



deos
30-03-2010, 18:01
Chcialbym tak zrobic aby w toplistach wyswietlana byla tylko kategoria w ktorej znajduje sie zdjecie. Bez tytulu zdjecia. Da sie tak zrobic ?

dexter77
31-03-2010, 14:56
da sie, szukaj w konfiguracji, nie pamietam dokladnie gdzie

deos
31-03-2010, 15:03
jestes pewien?

deos
11-04-2010, 00:41
Nie ma w opcjach. Musi byc gdzie tu ale nie umiem znalezc




//Parameter
$sorting = trim(Joom_mosGetParam('sorting', ''));

//Suche
$sstring = trim(Joom_mosGetParam('sstring', '', 'post'));
if($sstring == '')
{
$sstring = trim(Joom_mosGetParam('sstring', ''));
}

function strtolower_utf8($inputstring)
{
$outputString = utf8_decode($inputstring);
$outputString = strtolower($outputString);
$outputString = utf8_encode($outputString);
return $outputString;
}

switch($sorting)
{
case 'find':
$searchstring = trim(strtolower_utf8($sstring)) ;
$searchstring2 = htmlentities(trim(strtolower_utf8($sstring )), ENT_QUOTES, 'UTF-8');

$query1=" SELECT
a.*,
a.owner AS owner,
u.username,
ca.name AS name
FROM
#__joomgallery AS a,
#__joomgallery_catg AS ca,
#__users AS u
WHERE
a.catid = ca.cid
AND a.owner = u.id
AND (u.username LIKE '%$searchstring%'

OR a.imgtext LIKE '%$searchstring2%')
AND a.published = '1'
AND ca.published = '1'
AND a.approved = '1'
AND ca.access <= ".$user->get('aid')."
GROUP BY
a.id
ORDER BY
a.id DESC
";
$tl_title = JText::_('JGS_SEARCH_RESULTS')."<b> $sstring</b>";
break;

case 'lastcomment':
$query1 = " SELECT
a.*,
cc.*,
ca.*,
u.username,
a.owner AS owner
FROM
#__joomgallery AS a,
#__joomgallery_catg AS ca,
#__joomgallery_comments AS cc
LEFT JOIN
#__users AS u on cc.userid = u.id
WHERE
a.id = cc.cmtpic
AND a.catid = ca.cid
AND a.published = '1'
AND a.approved = '1'
AND cc.published = '1'
AND ca.published = '1'
AND cc.approved = '1'
AND ca.access <= ".$user->get('aid')."
ORDER BY
cc.cmtdate DESC
LIMIT ".$config->jg_toplist;
$tl_title = JText::_('JGS_TOP').' '.$config->jg_toplist.' '.JText::_('JGS_LAST_COMMENTED_PICTURE');
break;

case 'lastadd':
$query1 = " SELECT
*,
a.owner AS owner
FROM
#__joomgallery As a,
#__joomgallery_catg AS ca
WHERE
a.catid = ca.cid
AND a.published = '1'
AND a.approved = '1'
AND ca.published = '1'
AND ca.access <= ".$user->get('aid')."
ORDER BY
a.id DESC
LIMIT ".$config->jg_toplist;
$tl_title = JText::_('JGS_TOP').' '.$config->jg_toplist.' '.JText::_('JGS_LAST_ADDED_PICTURE');
break;

case 'rating':
$query1 = " SELECT
*,
a.owner AS owner,
ROUND(imgvotesum/imgvotes, 2) AS rating
FROM
#__joomgallery AS a,
#__joomgallery_catg AS ca
WHERE
a.catid = ca.cid
AND a.imgvotes > '0'
AND a.published = '1'
AND a.approved = '1'
AND ca.published = '1'
AND ca.access <= ".$user->get('aid')."
ORDER BY
rating DESC,
imgvotesum DESC
LIMIT ".$config->jg_toplist;
$tl_title = JText::_('JGS_TOP').' '.$config->jg_toplist.' '.JText::_('JGS_BEST_RATED_PICTURE');
break;

default:
$query1 = " SELECT
*,
a.owner AS owner
FROM
#__joomgallery AS a,
#__joomgallery_catg AS ca
WHERE
a.imgcounter > 0
AND a.catid = ca.cid
AND a.published = '1'
AND a.approved = '1'
AND ca.published = '1'
AND ca.access <= ".$user->get('aid')."
ORDER BY
imgcounter DESC
LIMIT ".$config->jg_toplist;
$tl_title = JText::_('JGS_TOP').' '.$config->jg_toplist.' '.JText::_('JGS_MOST_VIEWED_PICTURE');
break;
}

# Database Query
$database->setQuery($query1);
$rows = $database->loadObjectList();

HTML_Joom_Specials::Joom_ShowSpecials_HTML($tl_tit le, $rows, $sorting);

?>

headge
11-04-2010, 08:09
Otwórz includes/html/joom.viewspecial.html.php i mniej więcej w linii 72 skasuj <b><?php echo $row1->imgtitle; ?></b>

deos
11-04-2010, 11:21
Super, dzieki !