/*
-------------------------------------------------------------------------------------------
PROJET : KEO
-------------------------------------------------------------------------------------------
AUTEUR : Herve BONTEMPS - RvG DATE : 24/07/2001
-------------------------------------------------------------------------------------------
DESCRIPTION : - Le script n'est pas optimise car on utilise la brique EDITO
- Ce fichier est la structure de la page KEOMAG
- Les donnees sont tirees de la Base MYSQL
-------------------------------------------------------------------------------------------
MODIFICATION :
-------------------------------------------------------------------------------------------
*/
include ("../includes/inc_template.php");
include ("../../includes/dsn_iwm.php");
include ("../../includes/babellib_db.php");
include ("../../includes/babellib_html.php");
include ("../../includes/babellib_iframelink.php");
//********************************************************************
$boolFCT_NotEof = false; // boolean : enregistrement ou pas
global $db;
$db=new db();
$db->open($database, $host, $user, $password);
$rep=split("/",$PHP_SELF); // si on se trouve en fr, uk, es, etc...
// Template 1 -----------------------++++++++++++++++++++--------------------++++++++++++++++++++++++-------------
function DataTemplate1($strSCR_Path,$db){
$strSQL_Edito2 = "SELECT * From Path,Page,Edito2 " ;
$strSQL_Edito2.= "WHERE Page.FkPath_Page=Path.Id_Path ";
$strSQL_Edito2.= "AND Page.Id_Page=Edito2.FkPage_Edito2 ";
$strSQL_Edito2.= "AND Path_Path = '".$strSCR_Path."' ";
$strSQL_Edito2.= "AND FkDraft_Page<>'' ";
$strSQL_Edito2.= "AND Status_Page=10 ";
$strSQL_Edito2.= "ORDER BY ID_EDITO2 DESC";
$objDB_Edito2=new query_select($db, $strSQL_Edito2);
$intDB_TotRows=$objDB_Edito2->numRows();
if ($objDB_Edito2->getrow()){
$strDB_TitleEdito2 = stripslashes(Trim($objDB_Edito2->field("Title_Edito2")));
$strDB_ChapeauEdito2 = HTML_strSQLtoHTML(Trim($objDB_Edito2->field("Text_Edito2")));
$strDB_VignetteEdito2 = $objDB_Edito2->field("FormatIll2_Edito2");
$intDB_OnlineImgEdito2 = $objDB_Edito2->field("ImgOnLine_Edito2");
$intDB_FkPageEdito2 = $objDB_Edito2->field("FkPage_Edito2");
$strDB_TitlePageEdito2 = $objDB_Edito2->field("Name_Page");
}
$DataTemplate1=$strDB_TitleEdito2."¤".$strDB_ChapeauEdito2."¤".$strDB_VignetteEdito2."¤".$intDB_OnlineImgEdito2."¤".$intDB_FkPageEdito2."¤".$strDB_TitlePageEdito2."¤".$intDB_TotRows;
$DataTemplate1=split("¤",$DataTemplate1);
return $DataTemplate1;
}
// Template 2 -----------------------++++++++++++++++++++--------------------++++++++++++++++++++++++-------------
function DataTemplate2($strSCR_Path,$db){
$strSQL_Edito3 = "SELECT * From Path,Page,Edito3 " ;
$strSQL_Edito3.= "WHERE Page.FkPath_Page=Path.Id_Path ";
$strSQL_Edito3.= "AND Page.Id_Page=Edito3.FkPage_Edito3 ";
$strSQL_Edito3.= "AND Path_Path = '".$strSCR_Path."' ";
$strSQL_Edito3.= "AND FkDraft_Page<>'' ";
$strSQL_Edito3.= "AND Status_Page=10 ";
$strSQL_Edito3.= "ORDER BY ID_EDITO3 DESC";
$objDB_Edito3=new query_select($db, $strSQL_Edito3);
$intDB_TotRows=$objDB_Edito3->numRows();
if ($objDB_Edito3->getrow()){
$strDB_TitleEdito3 = stripslashes(Trim($objDB_Edito3->field("Title_Edito3")));
$strDB_ChapeauEdito3 = HTML_strSQLtoHTML(Trim($objDB_Edito3->field("Text_Edito3")));
$strDB_Vignette1Edito3 = $objDB_Edito3->field("FormatImg12_Edito3");
$intDB_OnlineImg1Edito3 = $objDB_Edito3->field("ImgOnLine1_Edito3");
$strDB_Vignette2Edito3 = $objDB_Edito3->field("FormatImg22_Edito3");
$intDB_OnlineImg2Edito3 = $objDB_Edito3->field("ImgOnLine2_Edito3");
$strDB_Vignette3Edito3 = $objDB_Edito3->field("FormatImg32_Edito3");
$intDB_OnlineImg3Edito3 = $objDB_Edito3->field("ImgOnLine3_Edito3");
$intDB_FkPageEdito3 = $objDB_Edito3->field("FkPage_Edito3");
$strDB_TitlePageEdito3 = $objDB_Edito3->field("Name_Page");
}
$DataTemplate2=$strDB_TitleEdito3."¤".$strDB_ChapeauEdito3."¤".$strDB_Vignette1Edito3."¤".$intDB_OnlineImg1Edito3."¤".$strDB_Vignette2Edito3."¤".$intDB_OnlineImg2Edito3."¤".$strDB_Vignette3Edito3."¤".$intDB_OnlineImg3Edito3."¤".$intDB_FkPageEdito3."¤".$strDB_TitlePageEdito3."¤".$intDB_TotRows;
$DataTemplate2=split("¤",$DataTemplate2);
return $DataTemplate2;
}
$strSCR_Path=$rep[1]."/keomag/";
$strSCR_PathKeomg="../keomag/";
// DATA Template 2 -----------------------++++++++++++++++++++--------------------++++++++++++++++++++++++-------------
$strSCR_PathBis_ExpoConf="expoconf/pages";
$ExpoConf=DataTemplate2($strSCR_Path.$strSCR_PathBis_ExpoConf,$db);
$strSCR_PathBis_ExpoConf=$strSCR_PathKeomg.$strSCR_PathBis_ExpoConf;
// DATA Template 1 -----------------------++++++++++++++++++++--------------------++++++++++++++++++++++++-------------
$strSCR_PathBis_Une="une/pages";
$Une=DataTemplate1($strSCR_Path.$strSCR_PathBis_Une,$db);
$strSCR_PathBis_Une=$strSCR_PathKeomg.$strSCR_PathBis_Une;
$strSCR_PathBis_Edito="edito/pages";
$Edito=DataTemplate1($strSCR_Path.$strSCR_PathBis_Edito,$db);
$strSCR_PathBis_Edito=$strSCR_PathKeomg.$strSCR_PathBis_Edito;
$strSCR_PathBis_Ecole="ecole/pages";
$Ecole=DataTemplate1($strSCR_Path.$strSCR_PathBis_Ecole,$db);
$strSCR_PathBis_Ecole=$strSCR_PathKeomg.$strSCR_PathBis_Ecole;
$strSCR_PathBis_Soutien="ils_soutiennent/pages";
$Soutien=DataTemplate1($strSCR_Path.$strSCR_PathBis_Soutien,$db);
$strSCR_PathBis_Soutien=$strSCR_PathKeomg.$strSCR_PathBis_Soutien;
$strSCR_PathBis_Inattendu="inattendu/pages";
$Inattendu=DataTemplate1($strSCR_Path.$strSCR_PathBis_Inattendu,$db);
$strSCR_PathBis_Inattendu=$strSCR_PathKeomg.$strSCR_PathBis_Inattendu;
$strSCR_PathBis_Initiatives="initiatives_indiv/pages";
$Initiative=DataTemplate1($strSCR_Path.$strSCR_PathBis_Initiatives,$db);
$strSCR_PathBis_Initiatives=$strSCR_PathKeomg.$strSCR_PathBis_Initiatives;
$strSCR_PathBis_Monde="monde/pages";
$Monde=DataTemplate1($strSCR_Path.$strSCR_PathBis_Monde,$db);
$strSCR_PathBis_Monde=$strSCR_PathKeomg.$strSCR_PathBis_Monde;
$strSCR_PathBis_Partenaires="partenaires/pages";
$Partenaire=DataTemplate1($strSCR_Path.$strSCR_PathBis_Partenaires,$db);
$strSCR_PathBis_Partenaires=$strSCR_PathKeomg.$strSCR_PathBis_Partenaires;
$strSCR_PathBis_Reaction="reaction/pages";
$Reaction=DataTemplate1($strSCR_Path.$strSCR_PathBis_Reaction,$db);
$strSCR_PathBis_Reaction=$strSCR_PathKeomg.$strSCR_PathBis_Reaction;
$strSCR_PathBis_Recompenses="recompenses/pages";
$Recompense=DataTemplate1($strSCR_Path.$strSCR_PathBis_Recompenses,$db);
$strSCR_PathBis_Recompenses=$strSCR_PathKeomg.$strSCR_PathBis_Recompenses;
$strSCR_PathBis_Tele="point_presse/tele/pages";
$Tele=DataTemplate1($strSCR_Path.$strSCR_PathBis_Tele,$db);
$strSCR_PathBis_Tele=$strSCR_PathKeomg.$strSCR_PathBis_Tele;
$strSCR_PathBis_Radio="point_presse/radio/pages";
$Radio=DataTemplate1($strSCR_Path.$strSCR_PathBis_Radio,$db);
$strSCR_PathBis_Radio=$strSCR_PathKeomg.$strSCR_PathBis_Radio;
$strSCR_PathBis_Internet="point_presse/internet/pages";
$Internet=DataTemplate1($strSCR_Path.$strSCR_PathBis_Internet,$db);
$strSCR_PathBis_Internet=$strSCR_PathKeomg.$strSCR_PathBis_Internet;
$strSCR_PathBis_Presse="point_presse/presse/pages";
$Presse=DataTemplate1($strSCR_Path.$strSCR_PathBis_Presse,$db);
$strSCR_PathBis_Presse=$strSCR_PathKeomg.$strSCR_PathBis_Presse;
?>
Plan du site