function show_ad($adid,$option)
{
global $database,$my,$mainframe,$total;
$itemid = intval( mosGetParam( $_GET, 'Itemid', 0 ));
//Кол-во объявлений пользователя AlexSims
$database->setQuery( "SELECT a.id FROM #__adsmanager_ads as a WHERE a.userid =".$ad->userid);
$total = count($database->loadObjectList());
//Кол объяв AlexSims
// get configuration
$database->setQuery( "SELECT * FROM #__adsmanager_config");
$database->loadObject($conf);
if ($database -> getErrorNum()) {
echo $database -> stderr();
return false;
}
if($conf->display_fullname == 1)
{
$name = "u.name";
}
else
{
$name = "u.username";
}
$database->setQuery("SELECT a.*, p.name as parent, p.id as parentid, c.name as cat, c.id as catid, $name as user ".
"FROM #__adsmanager_ads as a ".
"LEFT JOIN #__users as u ON a.userid = u.id ".
"LEFT JOIN #__adsmanager_categories as c ON a.category = c.id ".
"LEFT JOIN #__adsmanager_categories as p ON c.parent = p.id ".
"WHERE a.id=$adid and c.published");
$database->loadObject($ad);
//Dynamic Page Title
$mainframe->SetPageTitle( ADSMANAGER_PAGE_TITLE . " - " . $ad->cat . " - ". $ad->ad_headline );
//Dynamic Page Meta Discription by Devon "Stupid Ram"
$mainframe->prependMetaTag( "description", $ad->ad_headline );
//Dynamic Page Meta Keywords вставил
$mainframe->prependMetaTag( "keywords", $ad->ad_headline ." ". $ad->ad_text );
//PathWay
$database->setQuery( "SELECT c.* FROM #__adsmanager_categories as c ".
"WHERE c.published = 1 ORDER BY c.parent,c.ordering");
$listcats = $database->loadObjectList();
getPathList($listcats,$ad->category,$ad->cat,$paths,$itemid,$option,0,0);
$nb =count($paths);
$paths[$nb]->text =ADSMANAGER_ROOT_TITLE;
$paths[$nb]->link = sefRelToAbs('index.php?option='.$option.'&page=show_all&Itemid='.$itemid);
adsmanager_html::show_pathway($paths,$option);
//Show Ad
if (($conf->show_contact == 1)&&($my->id == "0"))
$show_contact = 0;
else
$show_contact = 1;
$database->setQuery( "SELECT * FROM #__adsmanager_positions WHERE 1 " );
$positions = $database->loadObjectList();
if ($database->getErrorNum()) {
echo $database->stderr();
return;
}
$database->setQuery( "SELECT f.* FROM #__adsmanager_fields AS f ".
"WHERE f.pos != -1 AND f.published = 1 ORDER by f.posorder" );
$fields = $database->loadObjectList();
if ($database->getErrorNum()) {
echo $database->stderr();
return;
}
//get value fields
$database->setQuery( "SELECT * FROM #__adsmanager_field_values ORDER by ordering ");
$fieldvalues = $database->loadObjectList();
if ($database -> getErrorNum()) {
echo $database -> stderr();
return;
}
$field_values = array();
// first pass - collect children
if (isset($fieldvalues))
{
foreach ($fieldvalues as $v ) {
$pt = $v->fieldid;
$list = @$field_values[$pt] ? $field_values[$pt] : array();
array_push( $list, $v );
$field_values[$pt] = $list;
}
}
// establish the hierarchy of the menu
$fDisplay = array();
// first pass - collect children
if (isset($fields))
{
foreach ($fields as $f ) {
$pt = $f->pos;
$list = @$fDisplay[$pt] ? $fDisplay[$pt] : array();
array_push( $list, $f );
$fDisplay[$pt] = $list;
}
}
adsmanager_html::show_html_ad($ad,$show_contact,$option,$itemid,$positions,$fDisplay,$field_values,$conf,1,0);
return $ad->id;
}