Field; } $sql_page="SELECT n.*, c.category, t.theme, d.summary as description FROM ".$table." AS n ".($_GET['category'] ? "LEFT OUTER JOIN news_description_ok AS d ON (d.id_unique = n.id_category)": "LEFT OUTER JOIN news_description_ok AS d ON (d.id_unique = n.id_theme)")." LEFT OUTER JOIN $table_category AS c ON (c.id_unique = n.id_category) LEFT OUTER JOIN $table_theme AS t ON (t.id_unique = n.id_theme) WHERE n.valid LIKE 'ok' AND (n.lang LIKE '".safe($_GET['lang'])."') ".($_GET['id_place']? "AND (n.id_place ='".$_GET['id_place']."' OR n.id_place=0)" : '')." ".($_GET['id_category']? "AND (n.id_category ='".$_GET['id_category']."')" : '')." ".($_GET['id']? "AND (n.id_unique ='".$_GET['id']."')" : ''); _sql('page',$sql_page,$debug); //pour le theme et la category if ($nb_req_page>0) { mysqli_data_seek($req_page,0); $data = mysqli_fetch_object($req_page); foreach ($data as $key => $value) { ${$key}=stripslashes($value); } } if ($nb_req_page==0) { $error=_t("404",'common'); } else if ($nb_req_page==1 && $_GET['id']) {//enregistrement $link_theme=_link_theme($data); $link_category=_link_category($data); $link=_link($data); } else if (($_GET['id_theme']||$_GET['id_category']) && $nb_req_page!=1 ) { //description theme ou cat _sql('description',"SELECT d.*, t.theme, c.category FROM news_description_ok AS d LEFT OUTER JOIN annu_theme AS t ON (d.id_theme) LEFT OUTER JOIN annu_category AS c ON (c.id_unique=d.id_category) WHERE 1 AND (id_place=".($_GET['id_place']? $_GET['id_place']." OR id_place=0 ":0).") ".($_GET['id_category']? " AND id_category=".safe($_GET['id_category']): ($_GET['id_theme']? " AND id_theme=".safe($_GET['id_theme']):''))." AND (d.lang LIKE '".safe($_GET['lang'])."') GROUP BY d.title", $debug); if ($nb_req_description>0) { $data_description=mysqli_fetch_object($req_description); } } else { //liste $nb_aff=15; if (!$nb_listdeb) { $nb_listdeb=0; } } if ($debug) { echo 'id_theme '.$data_description->id_theme; } $nb_tot=$nb_req_page; //echo $rep_img; //print_r($_GET); //echo $sql.mysqli_num_rows($req); ?>

1) { _sql('acc_img', "SELECT a.* FROM $table AS a WHERE valid LIKE 'ok' AND (a.lang LIKE '".safe($_GET['lang'])."') AND id_place = ".safe($_GET['id_place'])." AND image NOT LIKE '' ORDER BY RANK LIMIT 1"); $data_description= mysqli_fetch_object($req_acc_img); } //IMAGE $image=($data_description->image ?$data_description->image:$data->image); $caption=($data_description->caption ?$data_description->caption:$data->caption); $copyright=($data_description->copyright ?$data_description->copyright:$data->copyright); $infos_img=@getimagesize(getPath($_SERVER['PHP_SELF'],$rep_img).$image); echo '

'; /* echo '';*/ echo ' '.($caption?$caption:$title).' '.$copyright.'

'; //CAPTION COPYRIGHT if ($copyright || $caption) { echo '

'; if ($caption) { echo '

'.strip_tags($caption).'

'; } if ($copyright) { echo '

'.strip_tags($copyright).'

'; } echo '

'; ?>

'; //theme if ($theme) { echo ''.stripslashes(strip_tags($theme)).''; } //category if ($category) { echo ''.stripslashes(strip_tags($category)).''; } //titre echo '

'.preg_replace('%\*%','^✿',strip_tags($title)).'

'; if ($summary!='') { echo '

'.jolitext(strip_tags($summary)).'

'; } if ($tarif!='') { echo '

'._t('fromprice','common').' '.$data->tarif.'€ / '._t('night','reservation').'

'; } //content + galleries if (preg_match('%\[album%',$data->content)) { require_once ("include/aff_gallery.php"); echo '

'.(preg_match('%\[album%',$data->content)? preg_replace_callback('%\[album=([0-9]+)\]%','aff_gallery',$data->content) : $data->content).'

'; } else { echo '

'.$data->content.'

'; } //aside echo (trim(strip_tags($aside))!=''&&trim(strip_tags($aside))!=' ' ? '

'.strip_tags($aside, '

').'

' :'') ; //semainier resalys & yelloh if ($ref_booker!='' && $data_init->resa_site!='' && $data_init->date_min > 0 ) { include('include/semainier_'.$data_init->resa_site.'.php'); } //FILE-------------------------------------------------- if ($file) { echo '

'; $ext_file = substr($file,strlen($file)-3,3); echo ''; if (file_exists('images/ico_'.$ext_file.'.gif')) { echo '

'; } echo ($file_label? $file_label : 'le fichier joint').''; echo ' ('.round(@filesize(getPath($_SERVER['PHP_SELF'],$rep_file).$file)/1024).' Ko)'; echo '

'; } /* echo ''; */ echo '

';//fin 2colsLeft //col right echo '

'; //hot topics if ($_GET['id_place'] <99) { include('include/box_topics.php'); } else { include("include/aff_places.php"); } //related include("include/related.php"); echo '

';//fin 1rowRight //CAS PAS DE REPONSE } elseif ($nb_tot==0){ echo $error; } //--------------------------------------------- LISTE else { //if ($_GET['accomodation']) { echo '

'.(_t('accomodation','common')).'

'; } //if ($_GET['id_theme']) { echo '

'.($data_description->title?$data_description->title:$data->theme).'

'; } //if ($_GET['id_category']) { echo '

'.($data_description->category?$data_description->category:$data->category).'

'; } //description du thème ou de la catégorie if (!$_GET['accomodation']) { $array_description=array('titre','resume','content'); foreach($array_description as $desc) { echo ($data_description->$desc?'

'.$data_description->$desc.'

':''); } } //liste echo '

'; //list different categories of this thema _sql('cat',"SELECT DISTINCT n.id_category, c.category, n.lang, d.summary as category_description, n.rank FROM $table AS n LEFT OUTER JOIN annu_theme AS t ON (n.id_theme=t.id_unique) LEFT OUTER JOIN annu_category AS c ON (n.id_category=c.id_unique) LEFT OUTER JOIN news_description_ok AS d ON (n.id_category=d.id_category) WHERE n.valid LIKE 'ok' AND n.id_place=".($_GET['id_place']? $_GET['id_place']:0)." ".($_GET['id_category']? " AND (n.id_category ='".$_GET['id_category']."')" : '')." AND n.lang LIKE '".safe($_GET['lang'])."' GROUP BY n.id_category ORDER BY n.rank",$debug); if ($nb_req_cat>0) { while ($data_cat=mysqli_fetch_object($req_cat)) { echo '

'.preg_replace('%\*%','^✿',strip_tags($data_cat->category)).'

'; echo '

'.$data_cat->category_description.'

'; //list different publications of this category and thema _sql('perm',"SELECT DISTINCT n.* FROM $table AS n WHERE n.valid LIKE 'ok' AND id_place=".($_GET['id_place']? $_GET['id_place']:0) ." AND n.lang LIKE '".safe($_GET['lang'])."'" .(in_array("type_content",$array_rows)?" AND type_content NOT LIKE 'off'":'')." AND n.id_category=".$data_cat->id_category." ORDER BY n.rank",$debug); if ($nb_req_perm>0) { echo '

' .'' .'
'.preg_replace('%\*%','^✿',strip_tags($data->title)).'
' .'
'._t('fromprice','common').' '.$data->tarif.'€ / '._t('night','reservation').'
' .'

'; } } } echo '