';
if ($lang=="ru") $ret[]="
Анонсы готовых бизнес-планов
и маркетинговых исследований за 2014 г.
";
if ($lang=="en") $ret[]="
Announcements of ready business plans
and marketing research for 2014
";
$sql="SELECT id, name, DATE_FORMAT(created,\"%d.%m.%y\") as crdate, elements
FROM jos_zoo_item
where type=\"{$zoo_type}\" and state=1 AND YEAR(`created`) = YEAR(NOW()) {$sql_lang}
order by created desc
limit {$zoo_count}";
$db= &JFactory::getDBO();
$count='';
$db->setQuery($sql, 0, $count);
$rows = $db->loadObjectList();
if (count($rows)<>0)
{
foreach ($rows as $row)
{
$a=json_decode($row->elements,true);
$imgpath=$a['57172c66-27cb-442d-a964-19f64f744a3b']['file'];
$ret[]="
";
}
}
if ($lang=="ru") $ret[]="
Анонсы готовых бизнес-планов
и маркетинговых исследований за 2010-2013 гг.
";
if ($lang=="en") $ret[]="
Announcements of ready business plans
and marketing research for 2010-2013
";
$sql="SELECT id, name, DATE_FORMAT(created,\"%d.%m.%y\") as crdate
FROM jos_zoo_item
where type=\"{$zoo_type}\" and state=1 AND YEAR(`created`) <> YEAR(NOW()) {$sql_lang}
order by created desc
limit {$zoo_count}";
$db= &JFactory::getDBO();
$count='';
$db->setQuery($sql, 0, $count);
$rows = $db->loadObjectList();
if (count($rows)<>0)
{
foreach ($rows as $row)
{
$ret[]="
";
}
}
$ret[]='