require ( $_SERVER['DOCUMENT_ROOT'] . '/gestion/admin/.htconf' ) ;
//require ( $_SERVER['DOCUMENT_ROOT'] . '/gestion/admin/.htfonc' ) ;
$conx=mysql_connect($host,$user,$mdp);
$conxok=mysql_select_db($base,$conx);
error_reporting(E_ALL);
$onmouse_div = 'onmouseover="tuemenu();document.getElementById(\'sm5\').style.display=\'block\';"' ;
$onload_div = 'document.getElementById(\'sm5\').style.display=\'block\'';
$carregstyle = 'bloc-g-pratique' ;
$carredstyle = 'bloc-d-pratique' ;
$class_titre_cat = 'titre_cat_bloc-g-pratique' ;
$class_titre_prod = 'titre_cat_bloc-d-pratique' ;
//$_SERVER['PHP_SELF'] = str_replace('dev_','',$_SERVER['PHP_SELF']);
$geturl = trim( $_SERVER['PHP_SELF'] , '/' ) ;
$url = split( '/' , $geturl ) ;
$url[0] = str_replace('.html','',$url[0]);
//echo'
';print_r($url);echo'
';
$contenu_titre_cat = $url_titre_cat = $urltitle_titre_cat = $contenu_titre_cat_4titreart = $contenu_titre_prod_4titreart = null ;
for($i=0;$i'.$nom.'';
$contenu_titre_cat_4titreart .= ' :: ';
}
}
$contenu_titre_cat_4titreart = rtrim( $contenu_titre_cat_4titreart ,': ');
$catidparent0 = @mysql_result( mysql_query( 'select * from ges_cat_desc where nomrep = "'.$url[0].'"' ), 0 , 'idcat');
$catidparent0nom = @mysql_result( mysql_query( 'select * from ges_cat_desc where nomrep = "'.$url[0].'"' ), 0 , 'nom');
$catidparent1 = @mysql_result( mysql_query( 'select * from ges_cat_desc where nomrep = "'.$url[1].'"' ), 0 , 'idcat');
$catidparent1nom = @mysql_result( mysql_query( 'select * from ges_cat_desc where nomrep = "'.$url[1].'"' ), 0 , 'nom');
$catidparent1dyn = @mysql_result( mysql_query( 'select * from ges_cat_desc where nomrep = "'.$url[1].'" and idcat like "'.$catidparent0.'\_%"' ), 0 , 'rubdyn');
//$contenu_titre_cat = stripslashes( $catidparent0nom ) ;
//$contenu_titre_cat .= '
'.stripslashes( $catidparent1nom ) ;
if( empty($catidparent0) ) header( 'Location:/' ) ;
$counturl = count( $url ) ;
$urlfin = $url[$counturl -1] ;
//echo $urlfin.' '.$counturl.' ligne34
';exit;
//echo '0 '.$contenu_titre_cat ;
if( $counturl == 15555 )
{
$prodid2web = '0_1_22';//mysql_result( mysql_query( 'select * from ges_prod_desc where idprod like "'.$catidparent0.'\_%"' ), 0 , 'idprod');
$prodid2webnom = mysql_result( mysql_query( 'select * from ges_prod_desc where idprod ="0_1_22"' ), 0 , 'nom');
$contenu_titre_prod = stripslashes( $prodid2webnom ) ;
//echo $prodid2web .' '.$catidparentfin.' '.$urlfin.' '.$catidparentfinnom.' kkkkkkkkkkkkkkkk';
include( 'index.html' ) ;
}
//if( $counturl > 1 )
//{
if( ereg( '.html' , $urlfin ) )
{
if( ereg( '_', $urlfin ) )
{
$dot_x = strpos( $urlfin , '_' ) ;
$urlfin = substr( $urlfin ,0, $dot_x ).'.html' ;
}
if( $urlfin == 'pageinprogress.html' )
{
$prodid2web = '9999';
include( 'index.html' ) ;
}
$urlfin = str_replace( '.html' , '' , $urlfin) ;
if($counturl > 2 && !ereg( '.html' , $url[2] ) )
{
//echo'21321321';
$urlcatfin = $url[$counturl -2] ;
$catidparentfin = @mysql_result( mysql_query( 'select * from ges_cat_desc where nomrep = "'.$urlcatfin.'" and idcat like "'.$catidparent1.'\_%"' ), 0 , 'idcat');
$catidparentfinnom = @mysql_result( mysql_query( 'select * from ges_cat_desc where nomrep = "'.$urlcatfin.'" and idcat like "'.$catidparent1.'\_%"' ), 0 , 'nom');
$catidparentfindyn = @mysql_result( mysql_query( 'select * from ges_cat_desc where nomrep = "'.$urlcatfin.'" and idcat like "'.$catidparent1.'\_%"' ), 0 , 'rubdyn');
//$contenu_titre_cat .= '
'.stripslashes( $catidparentfinnom ) ;
//echo '1 '.$contenu_titre_cat ;
//echo'21321321 -- '.$counturl.' '.$url[2].' '.$urlcatfin.' '.$catidparentfinnom.' '.$catidparent1nom;
}
else
{
$catidparentfin = $catidparent1;
$catidparentfinnom = $catidparent1nom;
$catidparentfindyn = $catidparent1dyn ;
}
if( isset( $catidparentfindyn ) && $catidparentfindyn == 0 )
{
$prodid2web = mysql_result( mysql_query( 'select * from ges_prod_desc where nomrep = "'.$urlfin.'" and idprod like "'.$catidparentfin.'\_%"' ), 0 , 'idprod');
$prodid2webnom = mysql_result( mysql_query( 'select * from ges_prod_desc where nomrep = "'.$urlfin.'" and idprod like "'.$catidparentfin.'\_%"' ), 0 , 'nom');
$contenu_titre_prod = stripslashes( $prodid2webnom ) ;
$url_titre_prod = $url_titre_cat . '/' . $urlfin .'.html' ;
$urltitle_titre_prod = $urltitle_titre_cat . ' ' . $contenu_titre_prod ;
$contenu_titre_prod = '';
$contenu_titre_prod_4titreart = stripslashes( $prodid2webnom ) ;
$contenu_titre_prod_4titreart = '
';
}
/*
else if( isset( $catidparentfindyn ) && $catidparentfindyn < 900 )
{
$prodid2web = mysql_result( mysql_query( 'select * from stock_aventures where prodnomrep = "'.$urlfin.'" and catid = "'.$catidparentfindyn.'"' ), 0 , 'prodid');
$prodid2webnom = mysql_result( mysql_query( 'select * from stock_aventures where prodnomrep = "'.$urlfin.'" and catid = "'.$catidparentfindyn.'"' ), 0 , 'prodnom');
$contenu_titre_prod = stripslashes( $prodid2webnom ) ;
}
*/
else if( isset( $catidparentfindyn ) && $catidparentfindyn < 900 )
{
//echo $urlfin.' '.$catidparentfin;
$prodid2web = mysql_result( mysql_query( 'select * from ges_prod_desc where nomrep = "'.$urlfin.'" and idprod like "'.$catidparentfin.'\_%"' ), 0 , 'idprod');
$prodid2webdyn = mysql_result( mysql_query( 'select * from ges_prod_desc where nomrep = "'.$urlfin.'" and idprod like "'.$catidparentfin.'\_%"' ), 0 , 'rubdyn');
$prodid2webnom = mysql_result( mysql_query( 'select * from ges_prod_desc where nomrep = "'.$urlfin.'" and idprod like "'.$catidparentfin.'\_%"' ), 0 , 'nom');
$contenu_titre_prod = stripslashes( $prodid2webnom ) ;
$url_titre_prod = $url_titre_cat . '/' . $urlfin .'.html' ;
$urltitle_titre_prod = $urltitle_titre_cat . ' ' . $contenu_titre_prod ;
$contenu_titre_prod = '';
$contenu_titre_prod_4titreart = stripslashes( $prodid2webnom ) ;
$contenu_titre_prod_4titreart = '
';
}
else
{
$prodid2web = mysql_result( mysql_query( 'select * from ges_prod_desc where nomrep = "'.$urlfin.'" and idprod like "'.$catidparentfin.'\_%"' ), 0 , 'idprod');
$prodid2webnom = mysql_result( mysql_query( 'select * from ges_prod_desc where nomrep = "'.$urlfin.'" and idprod like "'.$catidparentfin.'\_%"' ), 0 , 'nom');
$contenu_titre_prod = stripslashes( $prodid2webnom ) ;
$url_titre_prod = $url_titre_cat . '/' . $urlfin .'.html' ;
$urltitle_titre_prod = $urltitle_titre_cat . ' ' . $contenu_titre_prod ;
$contenu_titre_prod = '';
$contenu_titre_prod_4titreart = stripslashes( $prodid2webnom ) ;
$contenu_titre_prod_4titreart = '
';
}
//echo $prodid2web .' 1'.$catidparentfin.' 2'.$urlfin.' 3'.$catidparentfinnom.' 4'.$catidparentfindyn.' kkkkkkkkkkkkkkkk';
include( 'index.html' ) ;
}
else
{
////si pas html urlfin
/////check si cat a contenu
$cat1erparent = @mysql_result( mysql_query( 'select * from ges_cat_desc where nomrep = "'.$url[count($url) -2].'"' ), 0 , 'idcat');
$urlcatfin = $url[count($url) -1];
$catidparentfin = @mysql_result( mysql_query( 'select * from ges_cat_desc where nomrep = "'.$urlcatfin.'" and idcat like "'.$cat1erparent.'\_%"' ), 0 , 'idcat');
if(count($url)==1)
{
$cat1erparent = @mysql_result( mysql_query( 'select * from ges_cat_desc where nomrep = "'.$url[count($url) -1].'"' ), 0 , 'idcat');
$urlcatfin = $url[count($url) -1];
$catidparentfin = $cat1erparent ;
}
//echo $cat1erparent.' '.$urlcatfin.' '.$urlcatfin;
$q = 'select * from ges_cat_desc where idcat = "'.$catidparentfin.'"';
$x = mysql_query($q);
$r= mysql_fetch_array($x);
$textecat=$r['texte'];
if( !empty( $textecat))
{
$catid2web =$catidparentfin;
include( 'index.html' ) ;
}
else if( empty( $textecat) )
{
$catid2webempty =$catidparentfin;
include( 'index.html' ) ;
}
else
{
if($counturl <= 2)
{
$catidparentfin = @mysql_result( mysql_query( 'select * from ges_cat_desc where nomrep = "'.$urlfin.'" and idcat like "'.$catidparent0.'\_%"' ), 0 , 'idcat');
$catidparentfinnom = @mysql_result( mysql_query( 'select * from ges_cat_desc where nomrep = "'.$urlfin.'" and idcat like "'.$catidparent0.'\_%"' ), 0 , 'nom');
$catidparentdyn = @mysql_result( mysql_query( 'select * from ges_cat_desc where nomrep = "'.$urlfin.'" and idcat like "'.$catidparent0.'\_%"' ), 0 , 'rubdyn');
}
else
{
$catidparentfin = @mysql_result( mysql_query( 'select * from ges_cat_desc where nomrep = "'.$urlfin.'" and idcat like "'.$catidparent1.'\_%"' ), 0 , 'idcat');
$catidparentfinnom = @mysql_result( mysql_query( 'select * from ges_cat_desc where nomrep = "'.$urlfin.'" and idcat like "'.$catidparent1.'\_%"' ), 0 , 'nom');
$catidparentdyn = @mysql_result( mysql_query( 'select * from ges_cat_desc where nomrep = "'.$urlfin.'" and idcat like "'.$catidparent1.'\_%"' ), 0 , 'rubdyn');
}
//$contenu_titre_cat .= '
'.stripslashes( $catidparentfinnom ) ;
//echo '2 '.$contenu_titre_cat ;
$catidparentfin = empty($catidparentfin) ? $catidparent0 : $catidparentfin ;
//echo 'idcatparentfin '.$catidparentfin.' '.$catidparentfinnom.' '.$catidparentdyn.'
';//exit;
$getprod = cat2firstprod( $catidparentfin ,null ) ;
//echo $rescat[0].' '.$rescat[1].'
';
if( $rescat[0] <> 333 )
{
$arbo = prod2arbo( $rescat[0] ,null ) ;
//echo 'Location:/'.$resarbo.$rescat[1].'.html';
//header( 'Location:/'.$resarbo.$prodnomrep.'.html?2' ) ;
header( 'Location:/'.$resarbo.$rescat[1].'.html' ) ;
}
/*
else
{
//echo $catidparentfin;
$q = 'select * from ges_cat_desc where idcat = "'.$catidparentfin.'"';
$x = mysql_query($q);
$r= mysql_fetch_array($x);
$textecat=$r['texte'];
if( !empty( $textecat))
{
$catid2web =$catidparentfin;
include( 'index.html' ) ;
}
*/
else header( 'Location:/'.$geturl.'/pageinprogress.html' ) ;
}
//else header( 'Location:/'.$geturl.'/pageinprogress.html' ) ;
}
//}if count url >1
function cat2firstprod($idcat,$resarbo){
global $rescat;
//$rescat=array();
$q2 = 'select * from ges_prod
left join ges_prod_desc using( idprod )
where idcat = "'.$idcat.'" and visu = 1
order by ordre, nom
limit 1
';
$x2 = mysql_query($q2) or die("erreur: $q2");
$n2 = mysql_numrows( $x2 ) ;
if( $n2>0 )
{
while($r2 = mysql_fetch_object($x2))
{
//$rescat = $r2->nomrep.' '.$r2->idprod ;
$rescat[] = $r2->idcat ;
$rescat[] = $r2->nomrep ;
//if( $r2->parent <> "0" )
//cat2prod( $r2->parent,$resarbo) ;
}
}
else
{
$q2 = 'select * from ges_cat
left join ges_cat_desc using( idcat )
where parent = "'.$idcat.'" and visu = 1
order by ordre,nom
limit 1
';
$x2 = mysql_query($q2) or die("erreur: $q2");
$n2 = mysql_numrows( $x2 ) ;
if( $n2>0 )
{
while($r2 = mysql_fetch_object($x2))
{
cat2firstprod($r2->idcat,null);
//$resarbo = $r2->nomrep;//.'/'.$resarbo ;
//if( $r2->parent <> "0" )
//cat2prod( $r2->parent,$resarbo) ;
}
}
else
{
$rescat[]='333';
$rescat[]='333';
}
}
}
function prod2arbo($idcat,$resarbo){
global $resarbo;
$q2 = 'select * from ges_cat
left join ges_cat_desc using( idcat )
where idcat = "'.$idcat.'" and idlang = 1
';
$x2 = mysql_query($q2) or die("erreur: $q2");
while($r2 = mysql_fetch_object($x2))
{
$resarbo = $r2->nomrep.'/'.$resarbo ;
if( $r2->parent <> "0" )
prod2arbo( $r2->parent,$resarbo) ;
}
}
function prod2arbo2($idcat,$resarbo){
global $resarbo;
$q2 = 'select * from stock_aventures_cat
where scatid = "'.$idcat.'"
';
$x2 = mysql_query($q2) or die("erreur: $q2");
while($r2 = mysql_fetch_object($x2))
{
$resarbo = $r2->catnomrep.'/'.$resarbo ;
if( $r2->catid <> "0" )
prod2arbo( $r2->catid,$resarbo) ;
}
}
?>