";
echo "window.location.href='$web_site_url/".$associate_portal[0]."'";
echo "";
exit;
}
}
}
//--- Capture navigation
$IPAddress = getenv ("REMOTE_ADDR");
$browser = get_browser();
#added by kailash for browser details;
foreach ($browser as $name=>$value) {
$browserdetail .= $name."==".$value."\n";
}
#old query
//$sql= "INSERT INTO clickThrough VALUES (\"\", \"$PortalId\", \"$RegionId\", \"$DirectoryCategory\", \"$DirectorySubCategory\", 'E', \"$IPAddress\", \"".date ("Y-m-d H:i:s")."\", \"".$PHP_SELF."\", \"".$_SERVER["HTTP_USER_AGENT"]."\",\"".$browser."\")";
#query changed by kailash
//$sql= "INSERT INTO clickThrough VALUES (\"\", \"$PortalId\", \"$RegionId\", \"$DirectoryCategory\", \"$DirectorySubCategory\", 'E', \"$IPAddress\", \"".date ("Y-m-d H:i:s")."\", \"".$PHP_SELF."\", \"".$_SERVER["HTTP_USER_AGENT"]."\",\"".$browserdetail."\")";
//--- Create Meta Tags
//$result = mysql_query ( $sql, $DB ) ;
//language implementation for mata tags starts
$ip_ary = $error_array = $meta_array= array();
$in_str="1";
if(!empty($_SESSION['site_lang_id']) && ($_SESSION['site_lang_id']!="1")){
$in_str = "1,".$_SESSION['site_lang_id'];
}
$ip_ary['where_str'] = " WHERE met_lg_id IN (".$in_str.")";
$objLangLib = new LangLib();
$objLangLib ->getLangMetaTitle($ip_ary);
if($objLangLib->isException()){
$error_array=$objLangLib->errorArray;
}
elseif(!empty($objLangLib->resultArray)){
$meta_array=$objLangLib->resultArray;
}
//language implementation for mata tags ends
//meta description
$meta_desc_array = $meta_keyword_array = array();
$md_ip_array = array();
$md_ip_array['where_str'] = " WHERE meta_desc_lg_id IN (".$in_str.")";
$objLangLib = new LangLib();
$objLangLib ->getLangMetaDescription($md_ip_array);
if($objLangLib->isException()){
$error_array=$objLangLib->errorArray;
}
elseif(!empty($objLangLib->resultArray)){
$meta_desc_array=$objLangLib->resultArray;
}
$mk_ip_array = array();
$mk_ip_array['where_str'] = " WHERE meta_keyword_lg_id IN (".$in_str.")";
$objLangLib = new LangLib();
$objLangLib ->getLangMetaKeywords($mk_ip_array);
if($objLangLib->isException()){
$error_array=$objLangLib->errorArray;
}
elseif(!empty($objLangLib->resultArray)){
$meta_keyword_array=$objLangLib->resultArray;
}
//category sub category meta tag keywords implementation
$cat_keyword_info = $category_meta_keyword_str = array();
$sub_cat_keyword_info = $sub_category_meta_keyword_str = array();
if(!empty($DirectoryCategory)){
$cat_keyword_sql = "select * from meta_keywords WHERE ref_type='cat' AND ref_id='$DirectoryCategory'";
$cat_keyword_result=mysql_query($cat_keyword_sql,$DB);
$cat_keyword_info = mysql_fetch_assoc($cat_keyword_result);
if(!empty($cat_keyword_info['keywords'])){
$category_meta_keyword_str = $cat_keyword_info['keywords'];
}
}
if(!empty($DirectorySubCategory)){
$sub_cat_keyword_sql = "select * from meta_keywords WHERE ref_type='subcat' AND ref_id='$DirectorySubCategory'";
$sub_cat_keyword_result=mysql_query($sub_cat_keyword_sql,$DB);
$sub_cat_keyword_info = mysql_fetch_assoc($sub_cat_keyword_result);
if(!empty($sub_cat_keyword_info['keywords'])){
$sub_category_meta_keyword_str = $sub_cat_keyword_info['keywords'];
}
}
$sub_cat_keyword_str="";
if(!empty($sub_category_meta_keyword_str )){
$sub_cat_keyword_str = $sub_category_meta_keyword_str;
}
elseif(!empty($category_meta_keyword_str)){
$sub_cat_keyword_str = $category_meta_keyword_str;
}
if ($DirectorySubCategory > 0 ) {
$queryCategory = "select name from directoryCategory WHERE directoryCategoryId=\"$DirectoryCategory\"";
$qresult=mysql_query($queryCategory,$DB);
if ($qmyrow=mysql_fetch_array($qresult)){
$DirectoryCategoryName = $qmyrow["name"];
}
$queryCategory = "select name from directorySubCategory WHERE directorySubCategoryId=\"$DirectorySubCategory\"";
$qresult=mysql_query($queryCategory,$DB);
if ($qmyrow=mysql_fetch_array($qresult)){
$DirectorySubCategoryName = $qmyrow["name"];
}
$DirectorySubCategoryName = replace ($DirectorySubCategoryName) ;
$DirectorySubCategoryName = html_escape ($DirectorySubCategoryName) ;
} else if ($DirectoryCategory > 0) {
$queryCategory = "select name from directoryCategory WHERE directoryCategoryId=\"$DirectoryCategory\"";
$qresult=mysql_query($queryCategory,$DB);
if ($qmyrow=mysql_fetch_array($qresult)){
$DirectoryCategoryName = $qmyrow["name"];
}
}
if ($DirectorySubCategoryName > "") {
$catsubcat = $DirectorySubCategoryName."";
$catsubcatkey ="$DirectorySubCategoryName,$DirectoryCategoryName,";
// added for new metatag concept 071005
$meta_sub_category_id=$DirectorySubCategory;
$meta_sub_category_name=$DirectorySubCategoryName;
} else if ($DirectoryCategoryName) {
$catsubcat = $DirectoryCategoryName."";
$catsubcatkey ="$DirectoryCategoryName,";
// added for new metatag concept 071005
$meta_category_id=$DirectoryCategory;
$meta_category_name=$DirectoryCategoryName;
}
if ($id && $page == "address") {
$queryCategory = "select name,locality,address1,postcode,telephone,directorySubCategoryId, directoryCategoryId, regionId, portalId from directoryEntry WHERE directoryEntryId=\"$id\"";
$qresult=mysql_query($queryCategory,$DB);
if ($qmyrow=mysql_fetch_array($qresult)){
$CompName = " ".$qmyrow["name"]." , ";
$compkey = $qmyrow["name"].",";
//$metCompanyCity = " ".$qmyrow["locality"]." , ";
$metCompanyCityKey = $qmyrow["locality"];
$metCompanyPostCode = " ".$qmyrow["postcode"];
$metCompanyPostCodeKey = $qmyrow["postcode"].",";
$meta_dir_company_name=$qmyrow["name"];
$meta_dir_location=$qmyrow["locality"];
$meta_dir_addr1=$qmyrow["address1"];
$meta_dir_telephone=$qmyrow["telephone"];
$meta_dir_post_code=$qmyrow["postcode"];
$meta_dir_subcategory=$qmyrow["directorySubCategoryId"];
$meta_dir_category=$qmyrow["directoryCategoryId"];
$meta_dir_region=$qmyrow["directoryCategoryId"];
$meta_dir_portal=$qmyrow["directoryCategoryId"];
$meta_dir_category=$qmyrow["directoryCategoryId"];
}
}
if ( $PortalId != 0 ) #ie., local portal pages
{
//sponsor detail retrieve of a portal
$port_spon_rlst_ary =array();
$port_spon_ary =array();
$objRetSponsorship =new Sponsorship($DB);
$port_spon_rlst_ary =$objRetSponsorship->retrievePortalSponsor($PortalId);
if(empty($port_spon_rlst_ary ['error'])){
if (!empty($port_spon_rlst_ary ['result'])){
$port_spon_ary =$port_spon_rlst_ary ['result'];
}
}
else{
echo $port_spon_rlst_ary ['error'];
}
if($port_spon_ary['varActive']=="Y" && $port_spon_ary['varPaid']=="Y"){
$sponsor_name=$port_spon_ary['varName'];
$sponsor_wsite=$port_spon_ary['varWebsite'];
$sponsor_dir_id=$port_spon_ary['varsponDirId'];
}
else{
if($_GET['test']==1){
echo "
";
echo $sponsor_name;
echo "
";
echo $port_spon_ary['varName'];
echo "
";
print_r($port_spon_ary);
}
}
/*
$lpsql = "SELECT * FROM manager WHERE dateOfCommencement <> \"0000-00-00\" AND RefID = \"$PortalId\" ";
$lpresult=mysql_query($lpsql,$DB);
while($lprow=mysql_fetch_array($lpresult)){
$Lp_TradeName = $lprow["company"];
$isLpartner = "YES";
}
$Lp_TitleHeader = "$PortalName";
$Lp_TitleHeader = "$PortalName";
*/
//$TitleHeader = "/$PortalName" ;
$TitleHeader ="/".$lang_pack['portal'][$PortalId];
if ($catsubcat == ""
||
!empty($_REQUEST['articleId'] )
||
!empty($_REQUEST['pressrelease'])
||
!empty($_REQUEST['story'])
||
!empty($_REQUEST['blog'])
||
!empty($_REQUEST['pic_id'])
){
#if it is an article page then change the title with the article name
if(!empty($_REQUEST['articleId'])){
if(!empty($_REQUEST['acategoryId'])) {
if( ($_REQUEST['acategoryId'] =="10") || ($_REQUEST['acategoryId'] =="11") || ($_REQUEST['acategoryId'] =="12") ){
$articleTitleQry = "SELECT articleName from portalHomeArticle WHERE articleId=\"".$_REQUEST['articleId']."\"";
}
else{
$articleTitleQry = "SELECT articleName from article WHERE articleId=\"".$_REQUEST['articleId']."\"";
}
}
else{
$articleTitleQry = "SELECT articleName from article WHERE articleId=\"".$_REQUEST['articleId']."\"";
}
//$articleTitleQry = "SELECT articleName from article WHERE articleId=\"".$_REQUEST['articleId']."\"";
$articleResult = mysql_query($articleTitleQry);
$articleRow = mysql_fetch_array($articleResult);
$articleTitle = $articleRow['articleName'];
$articleTitle = replace($articleTitle);#replace if any replace str present
if($articleTitle>""){#if article title is found
//$Title = "$articleTitle - $PortalName Directory Magazine" ;
$portal_art_txt = $meta_array['varPortalArtTxt'];
$portal_art_txt=replaceMetaTitle($portal_art_txt);
eval("\$portal_art_txt= \"$portal_art_txt\";");
$Title =$portal_art_txt;
//meta desctiption
$md_portal_art_txt = $meta_desc_array['varMetaDescPortalArtTxt'];
$md_portal_art_txt=replaceMetaDescription($md_portal_art_txt);
eval("\$md_portal_art_txt= \"$md_portal_art_txt\";");
$meta_description_str =$md_portal_art_txt;
$mk_portal_art_txt = $meta_keyword_array['varMetaKeywordPortalArtTxt'];
$mk_portal_art_txt=replaceMetaKeywords($mk_portal_art_txt);
eval("\$mk_portal_art_txt= \"$mk_portal_art_txt\";");
$meta_keyword_str =$mk_portal_art_txt;
}else{#if not found just in case :( set the default Title
//$Title = "$PortalName, $RegionName, Italy - The $PortalName Directory Magazine - Free Advertising, PR Service, Population, Pictures and Dialling Code" ;
$portal_def_art_txt = $meta_array['varPortalDefArtTxt'];
$portal_def_art_txt=replaceMetaTitle($portal_def_art_txt);
eval("\$portal_def_art_txt= \"$portal_def_art_txt\";");
$Title =$portal_def_art_txt;
$md_portal_art_txt = $meta_desc_array['varMetaDescPortalDefArtTxt'];
$md_portal_art_txt=replaceMetaDescription($md_portal_art_txt);
eval("\$md_portal_art_txt= \"$md_portal_art_txt\";");
$meta_description_str =$md_portal_art_txt;
$mk_portal_art_txt = $meta_keyword_array['varMetaKeywordPortalDefArtTxt'];
$mk_portal_art_txt=replaceMetaKeywords($mk_portal_art_txt);
eval("\$mk_portal_art_txt= \"$mk_portal_art_txt\";");
$meta_keyword_str =$mk_portal_art_txt;
}
$metaDesc = "\n";
$metaAbs = "\n";
$metaKeywords = "\n";
}
elseif(!empty($_REQUEST['pressrelease'])){
if($_REQUEST['article']=="PRESS"){
$prqry = "SELECT
pb_article_name AS articleName,
pb_company_name AS companyName,
pb_category AS category,
pb_town AS town
FROM
tbl_press_blog
WHERE
pb_article_status = '1'
AND
pb_id=\"".$_REQUEST['pressrelease']."\"";
//$prqry = "SELECT articleName,companyName,category,town FROM pressArticles WHERE articleActive = 'Y' AND pressArticleId=\"".$_REQUEST['pressrelease']."\"";
}
if($_REQUEST['article']=="HOME"){
$prqry = "SELECT articleName FROM portalHomeArticle WHERE articleActive = 'Y' AND articleId=\"".$_REQUEST['pressrelease']."\"";
//$prresult = mysql_query($prqry, $DB );
//$prrow = mysql_fetch_array($prresult);
}
$prresult = mysql_query($prqry );
$prrow = mysql_fetch_array($prresult);
$articleTitle = $prrow['articleName'];
$articleTitle = replace($articleTitle);#replace if any replace str present
$meta_pr_title=$prrow['articleName'];
$meta_pr_company=$prrow['companyName'];
$meta_pr_category=$prrow['category'];
$meta_pr_location=$prrow['town'];
if($articleTitle>""){#if article title is found
$portal_art_txt = $meta_array['varPortalArtTxt'];
$portal_art_txt=replaceMetaTitle($portal_art_txt);
eval("\$portal_art_txt= \"$portal_art_txt\";");
$Title =$portal_art_txt;
//meta desctiption
$md_portal_art_txt = $meta_desc_array['varMetaDescPortalArtTxt'];
$md_portal_art_txt=replaceMetaDescription($md_portal_art_txt);
eval("\$md_portal_art_txt= \"$md_portal_art_txt\";");
$meta_description_str =$md_portal_art_txt;
$mk_portal_art_txt = $meta_keyword_array['varMetaKeywordPortalArtTxt'];
$mk_portal_art_txt=replaceMetaKeywords($mk_portal_art_txt);
eval("\$mk_portal_art_txt= \"$mk_portal_art_txt\";");
$meta_keyword_str =$mk_portal_art_txt;
}else{#if not found just in case :( set the default Title
$portal_def_art_txt = $meta_array['varPortalDefArtTxt'];
$portal_def_art_txt=replaceMetaTitle($portal_def_art_txt);
eval("\$portal_def_art_txt= \"$portal_def_art_txt\";");
$Title =$portal_def_art_txt;
//meta desctiption
$md_portal_def_art_txt = $meta_desc_array['varMetaDescPortalDefArtTxt'];
$md_portal_def_art_txt=replaceMetaDescription($md_portal_def_art_txt);
eval("\$md_portal_def_art_txt= \"$md_portal_def_art_txt\";");
$meta_description_str =$md_portal_def_art_txt;
$mk_portal_def_art_txt = $meta_keyword_array['varMetaKeywordPortalDefArtTxt'];
$mk_portal_def_art_txt=replaceMetaKeywords($mk_portal_def_art_txt);
eval("\$mk_portal_def_art_txt= \"$mk_portal_def_art_txt\";");
$meta_keyword_str =$mk_portal_def_art_txt;
}
$meta_title = "$meta_pr_title, $meta_pr_company, $meta_pr_location, $PortalName, $meta_pr_category" ;
if($meta_keywords_pr=fn_get_meta_tags("pr",$_REQUEST['pressrelease'])){
$meta_title.=", ".$meta_keywords_pr;
}
$metaDesc = "\n";
$metaAbs = "\n";
$metaKeywords = "\n";
}
elseif(!empty($_REQUEST['blog'])){
$blogquery = " SELECT * From tbl_blog WHERE blog_id=\"".$_REQUEST['blog']."\"";
$blogresult = mysql_query($blogquery);
$blog_row = mysql_fetch_array($blogresult);
$blog_title = $blog_row['blog_name'];
$blog_title = replace($blog_title);#replace if any replace str present
$meta_blog_title=$blog_row['blog_name'];
$meta_blog_location=$blog_row['blog_city'];
if($blog_title>""){#if article title is found
$portal_blog_txt = $meta_array['varPortalArtTxt'];
$portal_blog_txt=replaceMetaTitle($portal_blog_txt);
eval("\$portal_blog_txt= \"$portal_blog_txt\";");
$Title =$portal_blog_txt;
//meta desctiption
$md_portal_blog_txt= $meta_desc_array['varMetaDescPortalArtTxt'];
$md_portal_blog_txt=replaceMetaDescription($md_portal_blog_txt);
eval("\$md_portal_blog_txt= \"$md_portal_blog_txt\";");
$meta_description_str =$md_portal_blog_txt;
$mk_portal_blog_txt= $meta_keyword_array['varMetaKeywordPortalArtTxt'];
$mk_portal_blog_txt=replaceMetaKeywords($mk_portal_blog_txt);
eval("\$mk_portal_blog_txt= \"$mk_portal_blog_txt\";");
$meta_keyword_str =$mk_portal_blog_txt;
}else{#if not found just in case :( set the default Title
$portal_def_art_txt = $meta_array['varPortalDefArtTxt'];
$portal_def_art_txt=replaceMetaTitle($portal_def_art_txt);
eval("\$portal_def_art_txt= \"$portal_def_art_txt\";");
$Title =$portal_def_art_txt;
//meta desctiption
$md_portal_def_art_txt= $meta_desc_array['varMetaDescPortalDefArtTxt'];
$md_portal_def_art_txt=replaceMetaDescription($md_portal_def_art_txt);
eval("\$md_portal_def_art_txt= \"$md_portal_def_art_txt\";");
$meta_description_str =$md_portal_def_art_txt;
$mk_portal_def_art_txt= $meta_keyword_array['varMetaKeywordPortalDefArtTxt'];
$mk_portal_def_art_txt=replaceMetaKeywords($mk_portal_def_art_txt);
eval("\$mk_portal_def_art_txt= \"$mk_portal_def_art_txt\";");
$meta_keyword_str =$mk_portal_def_art_txt;
}
$meta_title = "$meta_blog_title, $meta_blog_location, $PortalName, $meta_pr_category" ;
$metaDesc = "\n";
$metaAbs = "\n";
$metaKeywords = "\n";
}
elseif(!empty($_REQUEST['pic_id'])){
$picturequery = " SELECT * From pic_gallery WHERE pic_id=\"".$_REQUEST['pic_id']."\"";
$pictureresult = mysql_query($picturequery);
$picture_row = mysql_fetch_array($pictureresult);
$picture_title = $picture_row['pic_title'];
$picture_title = replace($picture_title);#replace if any replace str present
$meta_picture_title=$picture_row['picture_name'];
$Title ="".$picture_title." - Pubblica le tue foto sulla Rivista di ".$PortalName."";
$meta_title = "$meta_picture_title, $PortalName" ;
$metaDesc = "\n";
$metaAbs = "\n";
$metaKeywords = "\n";
}
elseif(!empty($_REQUEST['story'])){
if($_REQUEST['article']=="STORY"){
$prqry1 = "SELECT articleName FROM lareaArticles WHERE articleActive = 'Y' AND lareaArticleId=\"".$_REQUEST['story']."\"";
}
if($_REQUEST['article']=="HOME"){
$prqry1 = "SELECT articleName FROM article WHERE articleActive = 'Y' AND articleId=\"".$_REQUEST['story']."\"";
}
$prresult1 = mysql_query($prqry1);
$prrow1 = mysql_fetch_array($prresult1);
$articleTitle = $prrow1['articleName'];
$articleTitle = replace($articleTitle);#replace if any replace str present
if($articleTitle>""){#if article title is found
//$Title = "$articleTitle - $PortalName Local Business Directory Magazine, Italy" ;
$portal_art_txt = $meta_array['varPortalArtTxt'];
$portal_art_txt=replaceMetaTitle($portal_art_txt);
eval("\$portal_art_txt= \"$portal_art_txt\";");
$Title =$portal_art_txt;
//meta desctiption
$md_portal_art_txt= $meta_desc_array['varMetaDescPortalDefArtTxt'];
$md_portal_art_txt=replaceMetaDescription($md_portal_art_txt);
eval("\$md_portal_art_txt= \"$md_portal_art_txt\";");
$meta_description_str =$md_portal_art_txt;
$mk_portal_art_txt= $meta_keyword_array['varMetaKeywordPortalDefArtTxt'];
$mk_portal_art_txt=replaceMetaKeywords($mk_portal_art_txt);
eval("\$mk_portal_art_txt= \"$mk_portal_art_txt\";");
$meta_keyword_str =$mk_portal_art_txt;
}else{#if not found just in case :( set the default Title
//$Title = "$PortalName, $RegionName, Italia, Località rivista di economia - Pubblicità gratuita, Servizio stampa, la popolazione, le immagini e prefisso" ;
$portal_def_story_txt = $meta_array['varPortalDefStoryTxt'];
$portal_def_story_txt=replaceMetaTitle($portal_def_story_txt);
eval("\$portal_def_story_txt= \"$portal_def_story_txt\";");
$Title =$portal_def_story_txt;
//meta desctiption
$md_portal_def_story_txt= $meta_desc_array['varMetaDescPortalDefStoryTxt'];
$md_portal_def_story_txt=replaceMetaDescription($md_portal_def_story_txt);
eval("\$md_portal_def_story_txt= \"$md_portal_def_story_txt\";");
$meta_description_str =$md_portal_def_story_txt;
$mk_portal_def_story_txt= $meta_keyword_array['varMetaKeywordPortalDefStoryTxt'];
$mk_portal_def_story_txt=replaceMetaKeywords($mk_portal_def_story_txt);
eval("\$mk_portal_def_story_txt= \"$mk_portal_def_story_txt\";");
$meta_keyword_str =$mk_portal_def_story_txt;
}
$metaDesc = "\n";
$metaAbs = "\n";
$metaKeywords = "\n";
}
else{
$sql_get_county=mysql_query("SELECT * FROM city where regionId=$RegionId && portalId=$PortalId");
if($data_county=mysql_fetch_array($sql_get_county)){
$meta_county_name=$data_county['city'];
}
//$Title = "$PortalName, $RegionName, Italia, Località rivista di economia - Pubblicità gratuita, Servizio stampa, la popolazione, le immagini e prefisso" ;
$portal_def_story_txt = $meta_array['varPortalDefStoryTxt'];
$portal_def_story_txt=replaceMetaTitle($portal_def_story_txt);
eval("\$portal_def_story_txt= \"$portal_def_story_txt\";");
$Title =$portal_def_story_txt;
//meta desctiption
$md_portal_def_story_txt= $meta_desc_array['varMetaDescPortalDefStoryTxt'];
$md_portal_def_story_txt=replaceMetaDescription($md_portal_def_story_txt);
eval("\$md_portal_def_story_txt= \"$md_portal_def_story_txt\";");
$meta_description_str =$md_portal_def_story_txt;
$mk_portal_def_story_txt= $meta_keyword_array['varMetaKeywordPortalDefStoryTxt'];
$mk_portal_def_story_txt=replaceMetaKeywords($mk_portal_def_story_txt);
eval("\$mk_portal_def_story_txt= \"$mk_portal_def_story_txt\";");
$meta_keyword_str =$mk_portal_def_story_txt;
$meta_title = "$PortalName directory aziende, $PortalName rivista di affari , $PortalName comunicati stampa, $PortalName affari, $PortalName $RegionName italia, $PortalName pubblicità, $PortalName immagini, $PortalName popolazione, $PortalName prefisso telefonico, $PortalName fuso orario, $PortalName blogs, $PortalName rivista e directory";
if($meta_keywords_portal=fn_get_meta_tags("portal",$PortalId)){
$meta_title.=", ".$meta_keywords_portal;
}
$metaDesc = "\n";
$metaAbs = "\n";
$metaKeywords = "\n";
}
} else {
if(!empty($_REQUEST['id']) && !empty($_REQUEST['page']) && $_REQUEST['page']=="address"){
//First check company for keywords.
//If no keywords found, then get the keywords for the subcatgory for that company.
list($subcat_name)=mysql_fetch_array(mysql_query("SELECT name FROM directorySubCategory WHERE directorySubCategoryId=".$meta_dir_subcategory));
list($cat_name)=mysql_fetch_array(mysql_query("SELECT name FROM directoryCategory WHERE directoryCategoryId=".$meta_dir_category));
$meta_title="$meta_dir_company_name $meta_dir_location, $meta_dir_company_name $meta_dir_post_code, $subcat_name $PortalName, $meta_dir_company_name immagini, $meta_dir_company_name blogs, $meta_dir_company_name telefono, $subcat_name $meta_dir_company_name";
if($meta_keywords_directory=fn_get_meta_tags("directory",$_REQUEST['id'])){
$meta_title.=", ".$meta_keywords_directory;
}
else{
if($meta_keywords_directory=fn_get_meta_tags("subcat",$meta_dir_subcategory)){
$meta_title.=", ".$meta_keywords_directory;
}
}
$meta_dir_addr="";
if(!empty($meta_dir_addr1)){
$meta_dir_addr=$meta_dir_addr1;
}
//$Title = "it.clicksconnect.com - $meta_dir_company_name, $meta_sub_category_name, $PortalName, $metCompanyPostCode Italia, Company Blogs & Pictures";
$dir_list_txt = $meta_array['varDirListTxt'];
$dir_list_txt=replaceMetaTitle($dir_list_txt);
eval("\$dir_list_txt= \"$dir_list_txt\";");
$Title =$dir_list_txt;
//meta desctiption
$md_dir_list_txt= $meta_desc_array['varMetaDescDirListTxt'];
$md_dir_list_txt=replaceMetaDescription($md_dir_list_txt);
eval("\$md_dir_list_txt= \"$md_dir_list_txt\";");
$meta_description_str =$md_dir_list_txt;
$mk_dir_list_txt= $meta_keyword_array['varMetaKeywordDirListTxt'];
$mk_dir_list_txt=replaceMetaKeywords($mk_dir_list_txt);
eval("\$mk_dir_list_txt= \"$mk_dir_list_txt\";");
$meta_keyword_str =$mk_dir_list_txt;
//sb title starts
if(($_GET['show']!="latest")&&($_GET['show']!="list")){
$input_array=array();
$blog_array=array();
$input_array['varSbid']=$_GET['show'];
$objSpeedBlog=new SpeedBlog($DB,"get_single",$input_array);
if(empty($objSpeedBlog->errorArray)){
$blog_array=$objSpeedBlog->resultArray;
$blog_name=$blog_array['varSbTitle'];
//$Title ="$blog_name, Speed Blog for $meta_dir_company_name $meta_dir_addr $metCompanyCityKey $metCompanyPostCode, $meta_dir_telephone - International Media Network, $PortalName";
$portal_speed_blog_txt= $meta_array['varPortalSpeedBlogTxt'];
$portal_speed_blog_txt=replaceMetaTitle($portal_speed_blog_txt);
eval("\$portal_speed_blog_txt= \"$portal_speed_blog_txt\";");
$Title =$portal_speed_blog_txt;
//meta desctiption
$md_portal_speed_blog_txt= $meta_desc_array['varMetaDescPortalSpeedBlogTxt'];
$md_portal_speed_blog_txt=replaceMetaDescription($md_portal_speed_blog_txt);
eval("\$md_portal_speed_blog_txt= \"$md_portal_speed_blog_txt\";");
$meta_description_str =$md_portal_speed_blog_txt;
$mk_portal_speed_blog_txt= $meta_keyword_array['varMetaKeywordPortalSpeedBlogTxt'];
$mk_portal_speed_blog_txt=replaceMetaKeywords($mk_portal_speed_blog_txt);
eval("\$mk_portal_speed_blog_txt= \"$mk_portal_speed_blog_txt\";");
$meta_keyword_str =$mk_portal_speed_blog_txt;
}
}
//sb title ands
}
elseif($meta_category_id>0){
$sql_get_subcat="SELECT * FROM directorySubCategory WHERE vissible='Y' AND directoryCategoryId='".$meta_category_id."' ORDER BY name";
$res_get_subcat=mysql_query($sql_get_subcat,$DB);
if(mysql_num_rows($res_get_subcat)>0){
$sub_cat_names="";
while($dat_get_subcat=mysql_fetch_array($res_get_subcat)){
$sub_cat_names.=",".$dat_get_subcat['name'];
}
}
$meta_title="$meta_category_name,$PortalName,$RegionName,Italy$sub_cat_names";
if($meta_keywords_category=fn_get_meta_tags("cat",$meta_category_id)){
$meta_title .=",$meta_keywords_category";
}
//$Title = "$meta_category_name in $PortalName City Directory Magazine for $PortalName, $RegionName, Italy";
$dir_cat_txt= $meta_array['varDirCatTxt'];
$dir_cat_txt=replaceMetaTitle($dir_cat_txt);
eval("\$dir_cat_txt= \"$dir_cat_txt\";");
$Title =$dir_cat_txt;
//meta desctiption
$md_dir_cat_txt= $meta_desc_array['varMetaDescDirCatTxt'];
$md_dir_cat_txt=replaceMetaDescription($md_dir_cat_txt);
eval("\$md_dir_cat_txt= \"$md_dir_cat_txt\";");
$meta_description_str =$md_dir_cat_txt;
$mk_dir_cat_txt= $meta_keyword_array['varMetaKeywordDirCatTxt'];
$mk_dir_cat_txt=replaceMetaKeywords($mk_dir_cat_txt);
eval("\$mk_dir_cat_txt= \"$mk_dir_cat_txt\";");
$meta_keyword_str =$mk_dir_cat_txt;
}
elseif($meta_sub_category_id>0){ //For Subcategory
$sql_get_cat="SELECT cat.name as category_name FROM directorySubCategory as subcat,directoryCategory as cat where subcat.directoryCategoryId=cat.directoryCategoryId AND subcat.directorySubCategoryId=$meta_sub_category_id";
$res_get_cat=mysql_query($sql_get_cat,$DB);
if($dat_cat=mysql_fetch_array($res_get_cat)){
$meta_category_name=$dat_cat['category_name'];
}
$meta_title="$meta_sub_category_name di $PortalName, $meta_sub_category_name $meta_category_name $PortalName, $meta_sub_category_name $RegionName Italia";
if($meta_keywords_sub_category=fn_get_meta_tags("subcat",$meta_sub_category_id)){
$meta_title.=",$meta_keywords_sub_category";
}
//$Title = "$meta_sub_category_name in $PortalName, Italy - it.clicksconnect.com, $PortalName City Local $meta_sub_category_name" ;
$dir_sub_cat_txt= $meta_array['varDirSubCatTxt'];
$dir_sub_cat_txt=replaceMetaTitle($dir_sub_cat_txt);
eval("\$dir_sub_cat_txt= \"$dir_sub_cat_txt\";");
$Title =$dir_sub_cat_txt;
//meta desctiption
$md_dir_sub_cat_txt= $meta_desc_array['varMetaDescDirSubCatTxt'];
$md_dir_sub_cat_txt=replaceMetaDescription($md_dir_sub_cat_txt);
eval("\$md_dir_sub_cat_txt= \"$md_dir_sub_cat_txt\";");
$meta_description_str =$md_dir_sub_cat_txt;
$mk_dir_sub_cat_txt= $meta_keyword_array['varMetaKeywordDirSubCatTxt'];
$mk_dir_sub_cat_txt=replaceMetaKeywords($mk_dir_sub_cat_txt);
eval("\$mk_dir_sub_cat_txt= \"$mk_dir_sub_cat_txt\";");
$meta_keyword_str =$mk_dir_sub_cat_txt;
}
$metaDesc = "\n";
$metaAbs = "\n";
$metaKeywords = "\n";
}
}
else if ( $RegionId != 0 ) #ie., regional pages
{
$sql = "SELECT name FROM portal WHERE regionId=\"$RegionId\"";
$result1=mysql_query($sql,$DB);
$countport = 0;
while ($myrow1=mysql_fetch_array($result1)){
if ($countport == 0) {
$PortalNameDisplay .= $myrow1["name"];
} else {
$PortalNameDisplay .= ", ".$myrow1["name"];
}
$countport++;
}
//$TitleHeader = "/$RegionName" ;
$TitleHeader ="/".$lang_pack['cmw'][223]." ".$lang_pack['region'][$RegionId].", Italia";
if ($catsubcat == "" || !empty($_REQUEST['pressrelease'])) {
if(!empty($_REQUEST['pressrelease'])){
if($_REQUEST['article']=="PRESS"){
$prqry = "SELECT
pb_article_name as articleName
FROM
tbl_press_blog
WHERE
pb_article_status = '1'
AND
pb_id=\"".$_REQUEST['pressrelease']."\"";
//$prqry = "SELECT articleName FROM pressArticles WHERE articleActive = 'Y' AND pressArticleId=\"".$_REQUEST['pressrelease']."\"";
}
if($_REQUEST['article']=="HOME"){
$prqry = "SELECT articleName FROM portalHomeArticle WHERE articleActive = 'Y' AND articleId=\"".$_REQUEST['pressrelease']."\"";
//$prresult = mysql_query($prqry, $DB );
//$prrow = mysql_fetch_array($prresult);
}
$prresult = mysql_query($prqry );
$prrow = mysql_fetch_array($prresult);
$articleTitle = $prrow['articleName'];
$articleTitle = replace($articleTitle);#replace if any replace str present
if($articleTitle>""){#if article title is found
//$Title = "$articleTitle; Business Directory Magazines of $RegionName, Italy " ;
$reg_article_txt = $meta_array['varRegArticleTxt'];
$reg_def_txt=replaceMetaTitle($reg_article_txt);
eval("\$reg_article_txt= \"$reg_article_txt\";");
$Title =$reg_article_txt;
//meta desctiption
$md_reg_article_txt= $meta_desc_array['varMetaDescRegArticleTxt'];
$md_reg_article_txt=replaceMetaDescription($md_reg_article_txt);
eval("\$md_reg_article_txt= \"$md_reg_article_txt\";");
$meta_description_str =$md_reg_article_txt;
$mk_reg_article_txt= $meta_keyword_array['varMetaKeywordRegArticleTxt'];
$mk_reg_article_txt=replaceMetaKeywords($mk_reg_article_txt);
eval("\$mk_reg_article_txt= \"$mk_reg_article_txt\";");
$meta_keyword_str =$mk_reg_article_txt;
}
else{#if not found just in case :( set the default Title
//$Title = "Riviste e directory del $RegionName, Italia, Pubblicità gratuita, Mezzi di informazione multilingue rete, Free Advertising" ;
$reg_def_txt = $meta_array['varRegDefTxt'];
$reg_def_txt=replaceMetaTitle($reg_def_txt);
eval("\$reg_def_txt= \"$reg_def_txt\";");
$Title =$reg_def_txt;
//meta desctiption
$md_reg_def_txt= $meta_desc_array['varMetaDescRegDefTxt'];
$md_reg_def_txt=replaceMetaDescription($md_reg_def_txt);
eval("\$md_reg_def_txt= \"$md_reg_def_txt\";");
$meta_description_str =$md_reg_def_txt;
$mk_reg_def_txt= $meta_keyword_array['varMetaKeywordRegDefTxt'];
$mk_reg_def_txt=replaceMetaKeywords($mk_reg_def_txt);
eval("\$mk_reg_def_txt= \"$mk_reg_def_txt\";");
$meta_keyword_str =$mk_reg_def_txt;
}
$metaDesc = "\n";
$metaAbs = "\n";
$metaKeywords = "\n";
}
else{
//$Title = "Riviste e directory del $RegionName, Italia, Pubblicità gratuita, Mezzi di informazione multilingue rete, Free Advertising" ;
$reg_def_txt = $meta_array['varRegDefTxt'];
$reg_def_txt=replaceMetaTitle($reg_def_txt);
eval("\$reg_def_txt= \"$reg_def_txt\";");
$Title =$reg_def_txt;
//meta desctiption
$md_reg_def_txt= $meta_desc_array['varMetaDescRegDefTxt'];
$md_reg_def_txt=replaceMetaDescription($md_reg_def_txt);
eval("\$md_reg_def_txt= \"$md_reg_def_txt\";");
$meta_description_str =$md_reg_def_txt;
$mk_reg_def_txt= $meta_keyword_array['varMetaKeywordRegDefTxt'];
$mk_reg_def_txt=replaceMetaKeywords($mk_reg_def_txt);
eval("\$mk_reg_def_txt= \"$mk_reg_def_txt\";");
$meta_keyword_str =$mk_reg_def_txt;
$metaDesc = "\n";
$metaAbs = "\n";
$metaKeywords = "\n";
}
}
else {
//$Title = "$catsubcat the Cities of $RegionName Region, Italy - International Media Network" ;
$reg_cat_sub_cat_txt= $meta_array['varRegCatSubcatTxt'];
$reg_cat_sub_cat_txt=replaceMetaTitle($reg_cat_sub_cat_txt);
eval("\$reg_cat_sub_cat_txt= \"$reg_cat_sub_cat_txt\";");
$Title =$reg_cat_sub_cat_txt;
//meta desctiption
$md_reg_cat_sub_cat_txt= $meta_desc_array['varMetaDescRegCatSubcatTxt'];
$md_reg_cat_sub_cat_txt=replaceMetaDescription($md_reg_cat_sub_cat_txt);
eval("\$md_reg_cat_sub_cat_txt= \"$md_reg_cat_sub_cat_txt\";");
$meta_description_str =$md_reg_cat_sub_cat_txt;
$mk_reg_cat_sub_cat_txt= $meta_keyword_array['varMetaKeywordRegCatSubcatTxt'];
$mk_reg_cat_sub_cat_txt=replaceMetaKeywords($mk_reg_cat_sub_cat_txt);
eval("\$mk_reg_cat_sub_cat_txt= \"$mk_reg_cat_sub_cat_txt\";");
$meta_keyword_str =$mk_reg_cat_sub_cat_txt;
$metaDesc = "\n";
$metaAbs = "\n";
$metaKeywords = "\n";
}
}
else
{
$TitleHeader = "" ;
if ($catsubcat == "" || !empty($_REQUEST['pressrelease']) ) {
if(!empty($_REQUEST['pressrelease'])){
if($_REQUEST['article']=="PRESS"){
$prqry = "SELECT
pb_article_name as articleName
FROM
tbl_press_blog
WHERE
pb_article_status = '1'
AND
pb_id=\"".$_REQUEST['pressrelease']."\"";
//$prqry = "SELECT articleName FROM pressArticles WHERE articleActive = 'Y' AND pressArticleId=\"".$_REQUEST['pressrelease']."\"";
}
if($_REQUEST['article']=="HOME"){
$prqry = "SELECT articleName FROM portalHomeArticle WHERE articleActive = 'Y' AND articleId=\"".$_REQUEST['pressrelease']."\"";
//$prresult = mysql_query($prqry, $DB );
//$prrow = mysql_fetch_array($prresult);
}
$prresult = mysql_query($prqry );
$prrow = mysql_fetch_array($prresult);
$articleTitle = $prrow['articleName'];
$articleTitle = replace($articleTitle);#replace if any replace str present
if($articleTitle>""){#if article title is found
//$Title = "$articleTitle, Business Directory Magazines of Italy" ;
$nat_article_txt = $meta_array['varNatArticleTxt'];
$nat_article_txt=replaceMetaTitle($nat_article_txt);
eval("\$nat_article_txt= \"$nat_article_txt\";");
$Title =$nat_article_txt;
//meta desctiption
$md_nat_article_txt = $meta_desc_array['varMetaDescNatArticleTxt'];
$md_nat_article_txt=replaceMetaDescription($md_nat_article_txt);
eval("\$md_nat_article_txt= \"$md_nat_article_txt\";");
$meta_description_str =$md_nat_article_txt;
$mk_nat_article_txt = $meta_keyword_array['varMetaKeywordNatArticleTxt'];
$mk_nat_article_txt=replaceMetaKeywords($mk_nat_article_txt);
eval("\$mk_nat_article_txt= \"$mk_nat_article_txt\";");
$meta_keyword_str =$mk_nat_article_txt;
}
else{#if not found just in case :( set the default Title
//$Title = "Città e Regioni in Italia, Pubblicità gratuita, Mezzi di informazione multilingue rete, Free Advertising" ;
$nat_cat_def_txt = $meta_array['varNatDefTxt'];
$nat_cat_def_txt=replaceMetaTitle($nat_cat_def_txt);
eval("\$nat_cat_def_txt= \"$nat_cat_def_txt\";");
$Title =$nat_cat_def_txt;
//meta desctiption
$md_nat_cat_def_txt = $meta_desc_array['varMetaDescNatDefTxt'];
$md_nat_cat_def_txt=replaceMetaDescription($md_nat_cat_def_txt);
eval("\$md_nat_cat_def_txt= \"$md_nat_cat_def_txt\";");
$meta_description_str =$md_nat_cat_def_txt;
$mk_nat_cat_def_txt = $meta_keyword_array['varMetaKeywordNatDefTxt'];
$mk_nat_cat_def_txt=replaceMetaKeywords($mk_nat_cat_def_txt);
eval("\$mk_nat_cat_def_txt= \"$mk_nat_cat_def_txt\";");
$meta_keyword_str =$mk_nat_cat_def_txt;
}
$metaDesc = "\n";
$metaAbs = "\n";
$metaKeywords = "\n";
}
else{
//$Title = "Città e Regioni in Italia, Pubblicità gratuita, Mezzi di informazione multilingue rete, Free Advertising" ;
$nat_cat_def_txt = $meta_array['varNatDefTxt'];
$nat_cat_def_txt=replaceMetaTitle($nat_cat_def_txt);
eval("\$nat_cat_def_txt= \"$nat_cat_def_txt\";");
$Title =$nat_cat_def_txt;
//meta desctiption
$md_nat_cat_def_txt = $meta_desc_array['varMetaDescNatDefTxt'];
$md_nat_cat_def_txt=replaceMetaDescription($md_nat_cat_def_txt);
eval("\$md_nat_cat_def_txt= \"$md_nat_cat_def_txt\";");
$meta_description_str =$md_nat_cat_def_txt;
$mk_nat_cat_def_txt = $meta_keyword_array['varMetaKeywordNatDefTxt'];
$mk_nat_cat_def_txt=replaceMetaKeywords($mk_nat_cat_def_txt);
eval("\$mk_nat_cat_def_txt= \"$mk_nat_cat_def_txt\";");
$meta_keyword_str =$mk_nat_cat_def_txt;
//$metaDesc = "\n";
$metaDesc = "\n";
$metaAbs = "\n";
$metaKeywords = "\n";
}
}
else {
//$Title = "$catsubcat Cities across Italy - Città e Regioni in Italia" ;
$nat_cat_txt = $meta_array['varNatCatTxt'];
$nat_cat_txt=replaceMetaTitle($nat_cat_txt);
eval("\$nat_cat_txt= \"$nat_cat_txt\";");
$Title =$nat_cat_txt;
//meta desctiption
$md_nat_cat_txt = $meta_desc_array['varMetaDescNatCatTxt'];
$md_nat_cat_txt=replaceMetaDescription($md_nat_cat_txt);
eval("\$md_nat_cat_txt= \"$md_nat_cat_txt\";");
$meta_description_str =$md_nat_cat_txt;
$mk_nat_cat_txt = $meta_keyword_array['varMetaKeywordNatCatTxt'];
$mk_nat_cat_txt=replaceMetaKeywords($mk_nat_cat_txt);
eval("\$mk_nat_cat_txt= \"$mk_nat_cat_txt\";");
$meta_keyword_str =$mk_nat_cat_txt;
$metaDesc = "\n";
$metaAbs = "\n";
$metaKeywords = "\n";
}
}
$page = explode("/",$PHP_SELF);
$counter = count($page)-2;
$bpage = $page[$counter];
?>
<?=$Title;?>
