$NOMPAGE = 'dia-index.php';
include("../lib/dbpagay.php");
include("../lib/pgvisite.php");
if ($Cible != 'photo')
{
//Fonction de remplacement
$nbremax = 0;
$cond = 0;
$SQL = "Select pgcount_val from pgcount where pgcount_id = 'rezog'";
$reqSQL = mysql_query($SQL);
$reqSQLligne = mysql_fetch_array($reqSQL);
$NBCONNREZOG = $reqSQLligne[0];
$requeteetoilecount = 'select count(*) from pgpr ';
$requeteetoilereq = "select pgpr_id, pgpr_spic, '', pgreg_id, pgpr_pseudo, '', pgpr_desc, pgpr_dtmod, pgpr_foto, pgpr_fotomin, pgage_id, pgpr_vis, pgpr_cherche from pgpr ";
if ($MAX == "") {$MAX = 0;}
if ($RECHSIMPL == '' && $RECH == '' && $IDRECH == '')
{if ($SEXE != '') {if ($cond == 0) {$requeteetoile .= ' where ';} else {$requeteetoile .= ' and ';} $cond +=1; $requeteetoile .= "pgpr_sexe = '".$SEXE."' ";$lignesel = "Sexe » ".$SEXE."
";}
if ($REGION != '' && $REGION != '99') {if ($cond == 0) {$requeteetoile .= ' where ';} else {$requeteetoile .= ' and ';} $cond +=1; $reqmax = mysql_query ("select pgreg_nom from pg_reg where pgreg_id = ".$REGION); $lignemax = mysql_fetch_array($reqmax); $lignesel .= "Région » ".$lignemax[0]."
"; if ($REGION > 20) {$requeteetoile .= ' pgpay_id = '.$REGION;} else {$requeteetoile .= ' pgreg_id = '.$REGION;}}
$valurl = '&SEXE='.$SEXE.'®ION='.$REGION;
}
else
{$cond +=1;
include("../pr/prrechprreq.php");}
if ($cond == 0) {$requeteetoile .= ' where ';} else {$requeteetoile .= ' and ';}
$requeteetoile .= " pgpr_etat = 'V'";
$requete = mysql_query ($requeteetoilecount.$requeteetoile);
$requetecount = mysql_fetch_array($requete);
$nbrelignemax = $requetecount[0];
$nbrepage = ceil ($nbrelignemax/10);
$pageencours = ceil ($MAX/10+1);
if ($nbrepage > 0)
{if ($nbrepage > 1 && $pageencours != 1)
{$navig = '<< 1ère page -';}
if ($pageencours > 1 && $pageencours != 2)
{$PAGEPREC = $MAX - 10;
$navig .= ' < Page précédente -';}
$navig .= ' Page '.$pageencours.'/'.$nbrepage.' ';
if ($pageencours != $nbrepage && $nbrepage > 1 && $pageencours != $nbrepage - 1)
{$PAGESUIV = $MAX + 10;
$navig .= ' - Page suivante >';}
if ($pageencours != $nbrepage)
{$NBLETOP = ($nbrepage-1)*10;
$navig .= ' - Dernière page >>';}
}
$requeteetoile .= ' order by pgpr_dtmod desc, pgpr_id desc limit '.$MAX.',10';
$requete = mysql_query ($requeteetoilereq.$requeteetoile);
$nbreligne = mysql_num_rows($requete);
$savnbreligne = $nbreligne;
$apost = "'";
$lignesann = '
';
$bgcolor = 'FFFFFF';
while ($nbremax < 10 )
{if ($nbreligne > 0)
{if ($nbreligne == 5 ) {$lignesann .= ' '.$pubtel.' |
';}
$reqligne = mysql_fetch_array($requete);
$spic = strtolower($reqligne[1]);
if ($spic != '')
{$libcategorie = '
';}
else
{$libcategorie = '';}
$reqmax = mysql_query ("select pgreg_nom from pg_reg where pgreg_id = ".$reqligne[3]);
$lignemax = mysql_fetch_array($reqmax);
$libregion = $lignemax[0];
$reqmax = mysql_query ("select pgage_lib from pg_age where pgage_id = ".$reqligne[10]);
$lignemax = mysql_fetch_array($reqmax);
$libage = $lignemax[0];
$linkopen = "winopen('dia-profil.php?&PROFIL=".$reqligne['pgpr_id']."','profil',840,600,10,10,'no','no','yes'); return false";
$linkann = '';
if ($bgcolor == 'EFEFEF') {$bgcolor = 'FFFFFF';} else {if ($bgcolor == 'FFFFFF') {$bgcolor = 'EFEFEF';}}
$lignesann .= ' |
';
//*$lignesann .= '| '.$libcategorie.' | '.$reqligne['pgpr_pseudo'].' |
|
';
$lignesann .= ' |
';
$lignesann .= '';
if ($reqligne['pgpr_foto'] == 'T')
{$lignesann .= $linkann.' ';}
else
{$lignesann .= $linkann.'Profil n° '.$reqligne['pgpr_id'].'';}
if ($reqligne['pgpr_desc'] == '')
{$lignesann .= ' | | '.$reqligne['pgpr_pseudo'].' | '.$libcategorie.' |
recherche '.substr($reqligne['pgpr_cherche'],0,80).'... |
';}
else
{$lignesann .= '| '.$reqligne['pgpr_pseudo'].' | '.$libcategorie.' |
'.substr($reqligne['pgpr_desc'],0,80).'... | ';}
$lignesann .= '';
$lignesann .= ' '.$linkann.'Voir le profil complet »';
$lignesann .= ' |
 |
';
$lignesann .= '| '.$reqligne['pgpr_dtmod'].' ('.$reqligne['pgpr_vis'].') | '.$libregion.' | '.$libage.' |
| |
';
$nbremax += 1;
$nbreligne -= 1;
$MAX += 1;
if ($nbreligne == 0)
{$nbremax = 15;}
}
else
{$nbremax = 15;}
}
$lignesann .= '
';
if ($lignesel == "
")
{$lignesel = "Aucun critère de sélection";}
$lignenbann = ''.$nbrelignemax.'';
}
else
{
//Fonction de remplacement
$nbremax = 0;
$cond = 0;
$requeteetoilecount = 'select count(*) from pgpr';
$requeteetoilereq = 'select pgpr_id, pgpr_fotomin, pgpr_pseudo from pgpr ';
$requeteetoile .= ' where pgpr_foto = "T" and pgpr_fotomin <> "pgpicx.jpg" and pgpr_etat = "V" ';
if ($REGION != '' && $REGION != '99') {if ($REGION > 20) {$requeteetoile .= ' and pgpay_id = '.$REGION;} else {$requeteetoile .= ' and pgreg_id = '.$REGION;}}
if ($MAX == "")
{$MAX = 0;}
$requete = mysql_query ($requeteetoilecount.$requeteetoile);
$requetecount = mysql_fetch_array($requete);
$nbrelignemax = $requetecount[0];
$nbrepage = ceil ($nbrelignemax/15);
$pageencours = ceil ($MAX/16+1);
if ($nbrepage > 0)
{if ($nbrepage > 1 && $pageencours != 1)
{$navig = '« 1ère page -';}
if ($pageencours > 1 && $pageencours != 2)
{$PAGEPREC = $MAX - 16;
$navig .= ' < Page précédente -';}
$navig .= ' Page '.$pageencours.'/'.$nbrepage.' ';
if ($pageencours != $nbrepage && $nbrepage > 1 && $pageencours != $nbrepage - 1)
{$PAGESUIV = $MAX + 16;
$navig .= ' - Page suivante >';}
if ($pageencours != $nbrepage)
{$NBLETOP = ($nbrepage-1)*16;
$navig .= ' - Dernière page »';}
}
$requeteetoile .= ' order by pgpr_dtmod desc, pgpr_id desc limit '.$MAX.',16';
$requete = mysql_query ($requeteetoilereq.$requeteetoile);
$nbreligne = mysql_num_rows($requete);
$savnbreligne = $nbreligne;
$apost = "'";
$lignesann = '';
$nbremaxligne = 0;
while ($nbremax < 16 )
{$nbremaxligne += 1;
if ($nbremaxligne == 1)
{$lignesann .= '';}
if ($nbreligne > 0)
{$reqligne = mysql_fetch_array($requete);
$linkopen = "winopen('dia-profil.php?&PROFIL=".$reqligne[0]."','profil',840,600,10,10,'no','no','yes'); return false";
$linkann = '';
$lignesann .= ''.$linkann.' | ';
$nbremax += 1;
$nbreligne -= 1;
$MAX += 1;
}
else
{$lignesann .= " | ";
$nbremax += 1;}
if ($nbremaxligne == 4)
{$nbremaxligne = 0;
$lignesann .= '
';}
}
$lignesann .= '
';
if ($REGION != "" && $REGION != "99")
{$reqmax = mysql_query ("select pgreg_nom from pg_reg where pgreg_id = ".$REGION);
$lignemax = mysql_fetch_array($reqmax);
$lignesel .= "
Région » ".$lignemax[0]."
";
}
$lignenbann = ''.$nbrelignemax.'';
}
$NBANN = $lignenbann;
$ANNONCES = $lignesann;
$VALNAVIG = $navig;
$VALSEL = $lignesel;
mysql_close();
?>
PAGAY.com - Petites Annonces GAY :: Les annonces GAY