image
Et en fait j'aimerai que mon tableau sois constitué simplement d'une seul ligne avec pseudo mail age..... mais j'ai fais quelque tentative mais je n'arrive pas a trouver ou cela se regles voila le code de la page
<?php require_once('../Connections/connection.php'); ?>
<?php
session_start();
$MM_authorizedUsers = "membre,admin";
$MM_donotCheckaccess = "false";
function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) {
$isValid = False;
if (!empty($UserName)) {
$arrUsers = Explode(",", $strUsers);
$arrGroups = Explode(",", $strGroups);
if (in_array($UserName, $arrUsers)) {
$isValid = true;
}
if (in_array($UserGroup, $arrGroups)) {
$isValid = true;
}
if (($strUsers == "") && false) {
$isValid = true; } } return $isValid; }
$MM_restrictGoTo = "http://mondelendill.free.fr/index.php";
if (!((isset($_SESSION['MM_Username'])) && (isAuthorized("",$MM_authorizedUsers, $_SESSION['MM_Username'], $_SESSION['MM_UserGroup'])))) {
$MM_qsChar = "?";
$MM_referrer = $_SERVER['PHP_SELF'];
if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = "&";
if (isset($QUERY_STRING) && strlen($QUERY_STRING) > 0)
$MM_referrer .= "?" . $QUERY_STRING;
$MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" . urlencode($MM_referrer);
header("Location: ". $MM_restrictGoTo);
exit;
}
?>
<?php
//initialize the session
session_start();
// ** Logout the current user. **
$logoutAction = $_SERVER['PHP_SELF']."?doLogout=true";
if ((isset($_SERVER['QUERY_STRING'])) && ($_SERVER['QUERY_STRING'] != "")){
$logoutAction .="&". htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_GET['doLogout'])) &&($_GET['doLogout']=="true")){
//to fully log out a visitor we need to clear the session varialbles
session_unregister('MM_Username');
session_unregister('MM_UserGroup');
$logoutGoTo = "../index.php";
if ($logoutGoTo) {
header("Location: $logoutGoTo");
exit;
}
}
?>
<?php
$currentPage = $_SERVER["PHP_SELF"];
$SSAdv_colors1 = array("#CCCCCC","#999999");
$SSAdv_k1 = 0;
$SSAdv_m1 = 0;
$SSAdv_change_every1 = 1;
$maxRows_Recordset1 = 40;
$pageNum_Recordset1 = 0;
if (isset($_GET['pageNum_Recordset1'])) {
$pageNum_Recordset1 = $_GET['pageNum_Recordset1'];
}
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;
mysql_select_db($database_connection, $connection);
$query_Recordset1 = "SELECT mailmembre, pseudo, iscptdate, statut, site, idmembre, dn, loc FROM ep_membres WHERE statut = 'membre'||statut='admin' ORDER BY pseudo ASC";
$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1, $connection) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
if (isset($_GET['totalRows_Recordset1'])) {
$totalRows_Recordset1 = $_GET['totalRows_Recordset1'];
} else {
$all_Recordset1 = mysql_query($query_Recordset1);
$totalRows_Recordset1 = mysql_num_rows($all_Recordset1);
}
$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;
$queryString_Recordset1 = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_Recordset1") == false &&
stristr($param, "totalRows_Recordset1") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_Recordset1 = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_Recordset1 = sprintf("&totalRows_Recordset1=%d%s", $totalRows_Recordset1, $queryString_Recordset1);
?>
<html>
<head>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_openBrWindow(theURL,winName,features) { //v2.0
window.open(theURL,winName,features);
}
//-->
</script>
<title>Espace Membre</title>
</head>
<body background="http://mondelendill.free.fr/fond.jpg" text="white" alink="red" vlink="red" link="red" >
<style type="text/css">
<!--
body { background: url('http://mondelendill.free.fr/fond.jpg') no-repeat fixed }
-->
</style>
<center>
<table border="0" width="800" cellpadding="0" cellspacing="0">
<tr>
<td width="800" colspan="3" align="center">
<img src="http://mondelendill.free.fr/banniere.jpg">
</td>
</tr>
<tr height=20>
</tr>
<tr>
<td width="100" valign="top" align="center">
<table align="center" border="1" width="150" cellpadding="0" cellspacing="0">
<tr>
<td bgcolor="#666666">
<center>Le Serveur est</center>
</td>
</tr>
<tr>
<td align="center" bgcolor="#000000">
<script type="text/javascript" src="http://www.rpg-paradize.com/online.php?site=751"></script>
</td>
</tr>
</table><br>
<table align="center" border="1" width="150" cellpadding="0" cellspacing="0">
<tr>
<td bgcolor="#666666">
<center>Menu</center>
</td>
</tr>
<tr>
<td align="center" bgcolor="#000000"><br>
<a href="http://mondelendill.free.fr/index2.php" style="text-DECORATION:none"><font onMouseOver="this.style.color='#ffffff'" onMouseOut="this.style.color='red'" face="Arial, Helvetica, sans-serif" size="2"><b>News</b></font></a><br>
<a href="http://elendill.heavenforum.com" style="text-decoration:none"><font onmouseover="this.style.color='#ffffff'" onmouseout="this.style.color='red'" face="Arial, Helvetica, sans-serif" size="2"><b>Forum</b></font></a><br>
<a href="http://mondelendill.free.fr/telechargment.php" style="text-decoration:none"><font onmouseover="this.style.color='#ffffff'" onmouseout="this.style.color='red'" face="Arial, Helvetica, sans-serif" size="2"><b>Téléchargement</b></font></a><br>
<a href="http://mondelendill.free.fr/membres/tousmembres.php" style="text-DECORATION:none"><font onMouseOver="this.style.color='#ffffff'" onMouseOut="this.style.color='red'" face="Arial, Helvetica, sans-serif" size="2"><b>Membres</b></font></a><br>
<a href="http://mondelendill.free.fr/ts.php" style="text-decoration:none"><font onmouseover="this.style.color='#ffffff'" onmouseout="this.style.color='red'" face="Arial, Helvetica, sans-serif" size="2"><b>Team Speak</b></font></a><br>
<a href="http://mondelendill.free.fr/tchat.php" style="text-decoration:none"><font onmouseover="this.style.color='#ffffff'" onmouseout="this.style.color='red'" face="Arial, Helvetica, sans-serif" size="2"><b>Tchat</b></font></a><br>
<a href="http://mondelendill.free.fr/radio.php" style="text-decoration:none"><font onmouseover="this.style.color='#ffffff'" onmouseout="this.style.color='red'" face="Arial, Helvetica, sans-serif" size="2"><b>Radio</b></font></a><br>
<a href="mailto:[email protected]" style="text-DECORATION:none"><font onMouseOver="this.style.color='#ffffff'" onMouseOut="this.style.color='red'" face="Arial, Helvetica, sans-serif" size="2"><b>Contact</b></font></a><br>
<a href="http://mondelendill.free.fr/membres/index.php" style="text-decoration:none"><font onmouseover="this.style.color='#ffffff'" onmouseout="this.style.color='green'" color="green" face="Arial, Helvetica, sans-serif" size="2"><b>Compte</b></font></a><br>
<a href="#" style="text-decoration:none"><font onmouseover="this.style.color='#ffffff'" onmouseout="this.style.color='green'" color="green" face="Arial, Helvetica, sans-serif" size="2"><b>Joueur en ligne</b></font></a><br><br>
</td>
</tr>
</table><br>
<table align="center" border="1" width="150" cellpadding="0" cellspacing="0">
<tr>
<td align="center" bgcolor="#666666">
<center>Guide</center>
</td>
</tr>
<tr>
<td align="center" bgcolor="#000000"><br>
<a href="http://mondelendill.free.fr/installation.php" style="text-DECORATION:none"><font onMouseOver="this.style.color='#ffffff'" onMouseOut="this.style.color='red'" face="Arial, Helvetica, sans-serif" size="2"><b>Installation</b></font></a><br>
<a href="http://mondelendill.free.fr/elendill.php" style="text-decoration:none"><font onmouseover="this.style.color='#ffffff'" onmouseout="this.style.color='red'" face="Arial, Helvetica, sans-serif" size="2"><b>Le Monde d'Elendill</b></font></a><br>
<a href="http://mondelendill.free.fr/commandes.php" style="text-decoration:none"><font onmouseover="this.style.color='#ffffff'" onmouseout="this.style.color='red'" face="Arial, Helvetica, sans-serif" size="2"><b>Commandes</b></font></a><br>
<a href="http://mondelendill.free.fr/raccourcis.php" style="text-DECORATION:none"><font onMouseOver="this.style.color='#ffffff'" onMouseOut="this.style.color='red'" face="Arial, Helvetica, sans-serif" size="2"><b>Raccourcis</b></font></a><br>
<a href="http://mondelendill.free.fr/classe.php" style="text-decoration:none"><font onmouseover="this.style.color='#ffffff'" onmouseout="this.style.color='red'" face="Arial, Helvetica, sans-serif" size="2"><b>Classe/Skill</b></font></a><br>
<a href="http://mondelendill.free.fr/race.php" style="text-decoration:none"><font onmouseover="this.style.color='#ffffff'" onmouseout="this.style.color='red'" face="Arial, Helvetica, sans-serif" size="2"><b>Race</b></font></a><br>
<a href="http://mondelendill.free.fr/quetes.php" style="text-decoration:none"><font onmouseover="this.style.color='#ffffff'" onmouseout="this.style.color='red'" face="Arial, Helvetica, sans-serif" size="2"><b>Quêtes (Lvl 20/40/62)</b></font></a><br>
<a href="http://mondelendill.free.fr/maps.php" style="text-decoration:none"><font onmouseover="this.style.color='#ffffff'" onmouseout="this.style.color='red'" face="Arial, Helvetica, sans-serif" size="2"><b>Maps</b></font></a><br><br>
</td>
</tr>
</table><br>
<table align="center" border="1" width="150" cellpadding="0" cellspacing="0">
<tr>
<td bgcolor="#666666">
<center>Drop Calculator</center>
</td>
</tr>
<tr>
<td align="center" bgcolor="#000000">
<br>
<?php
include ('../config.inc.php');
echo $msg;
echo'<form method="post" action="../recherche.php">
<table border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="center">
<input name="recherche" value="Arme" type="text" size="15">
</td>
</tr>
<tr>
<td align="center"><input type="submit" name="Submit" value="Chercher"> </td>
</tr>
</table>
</form>';
?>
</td>
</tr>
</table><br>
<table align="center" border="1" width="150" cellpadding="0" cellspacing="0">
<tr>
<td bgcolor="#666666">
<center>Vote</center>
</td>
</tr>
<tr>
<td align="center" bgcolor="#000000">
<br>
<!-- Start of the topsite code -->
<a href="http://www.root-top.com/topsite/top20/in.php?ID=8"><img src="http://img91.imageshack.us/img91/4194/sanstitretruecolor02sp2.png" border="0"></a><br>
<!-- End of the topsite code -->
<br>
<!-- Start of the topsite code -->
<a href="http://www.root-top.com/topsite/krick/in.php?ID=241"><img src="http://grossistes-web.ifrance.com/lineage2.gif" border="0"></a><br>
<!-- End of the topsite code -->
<br>
<a href="http://www.rpg-paradize.com/index.php?page=vote&vote=751" target=_blank>
<img src="http://www.rpg-paradize.com/vote.gif" border=0>
</a>
</td>
</tr>
</table>
</td>
<td width="700" align="right" valign="top">
<table width="620" cellpadding="0" cellspacing="0" border="1">
<tr>
<td align="center">
<div align="center">
<table align="center" cellspacing="10" width="100%" border="0" bgcolor="#000000">
<tr>
<td align="center" bgcolor="#000000">
<a href="http://mondelendill.free.fr/index2.php" style="text-DECORATION:none"><font onMouseOver="this.style.color='#ffffff'" onMouseOut="this.style.color='red'" face="Arial, Helvetica, sans-serif" size="2">Acceuil</font></a> -
<a href="index.php"style="text-DECORATION:none"><font onMouseOver="this.style.color='#ffffff'" onMouseOut="this.style.color='red'" face="Arial, Helvetica, sans-serif" size="2"> Infos</font></a> -
<a href="fiche.php"style="text-DECORATION:none"><font onMouseOver="this.style.color='#ffffff'" onMouseOut="this.style.color='red'" face="Arial, Helvetica, sans-serif" size="2"> Profil</font></a> -
<a href="tousmembres.php"style="text-DECORATION:none"><font onMouseOver="this.style.color='#ffffff'" onMouseOut="this.style.color='red'" face="Arial, Helvetica, sans-serif" size="2"> Les membres</font></a> -
<a href="<?php echo $logoutAction ?>"style="text-DECORATION:none"><font onMouseOver="this.style.color='#ffffff'" onMouseOut="this.style.color='red'" face="Arial, Helvetica, sans-serif" size="2"> Deconnexion</font></a>
</td>
</tr>
</table>
<font face="Arial, Helvetica, sans-serif" size="2"><?php if ($totalRows_Recordset1 > 0) { // Show if recordset not empty ?>
<?php do { ?><br></font>
<table width="95%" border="0" cellpadding="1" cellspacing="1">
<tr bgcolor="#000033">
<td align="center">
<font face="Arial, Helvetica, sans-serif" size="2">Pseudo</font>
</td>
<td align="center">
<font face="Arial, Helvetica, sans-serif" size="2">Mail</font>
</td>
<td align="center">
<font face="Arial, Helvetica, sans-serif" size="2">Age</font>
</td>
<td align="center">
<font face="Arial, Helvetica, sans-serif" size="2">Site web</font>
</td>
<td align="center">
<font face="Arial, Helvetica, sans-serif" size="2">Statut</font>
</td>
<td align="center">
<font face="Arial, Helvetica, sans-serif" size="2">Acces Fiche</font>
</td>
</tr>
<tr bgcolor="#000000">
<td align="center"><font face="Arial, Helvetica, sans-serif" size="2"><?php echo $row_Recordset1['pseudo']; ?></font></td>
<td align="center"><font face="Arial, Helvetica, sans-serif" size="2"><a href="mailto:<?php echo $row_Recordset1['mailmembre']; ?>"><?php echo $row_Recordset1['mailmembre']; ?></a></font></td>
<td align="center"><font face="Arial, Helvetica, sans-serif" size="2"><?php echo $row_Recordset1['dn']; ?> Ans </font></td>
<td align="center"><font face="Arial, Helvetica, sans-serif" size="2"><a href="<?php echo $row_Recordset1['site']; ?>"><?php echo $row_Recordset1['site']; ?></a></font></td>
<td align="center"><font face="Arial, Helvetica, sans-serif" size="2"><?php echo $row_Recordset1['statut']; ?><font face="Arial, Helvetica, sans-serif" size="2"></td>
<td align="center" onClick="MM_openBrWindow('../fichemembre.php?pseudo=<?php echo $row_Recordset1['pseudo']; ?> ','','menubar=yes,scrollbars=yes,resizable=yes,width=500,height=500')"><font face="Arial, Helvetica, sans-serif" size="2"><a href="#">fiche</a> <font face="Arial, Helvetica, sans-serif" size="2"></td>
</tr>
</table>
<font face="Arial, Helvetica, sans-serif" size="2"><?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?></font>
<br>
<table border="0" width="50%" align="center">
<tr>
<td width="23%" align="center">
<font face="Arial, Helvetica, sans-serif" size="2"><?php if ($pageNum_Recordset1 > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, 0, $queryString_Recordset1); ?>">Premier</a></font>
<?php } // Show if not first page ?>
</td>
<td width="31%" align="center">
<font face="Arial, Helvetica, sans-serif" size="2"><?php if ($pageNum_Recordset1 > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, max(0, $pageNum_Recordset1 - 1), $queryString_Recordset1); ?>">Précédent</a>
<?php } // Show if not first page ?></font>
</td>
<td width="23%" align="center">
<font face="Arial, Helvetica, sans-serif" size="2"><?php if ($pageNum_Recordset1 < $totalPages_Recordset1) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, min($totalPages_Recordset1, $pageNum_Recordset1 + 1), $queryString_Recordset1); ?>">Suivant</a>
<?php } // Show if not last page ?></font>
</td>
<td width="23%" align="center">
<font face="Arial, Helvetica, sans-serif" size="2"><?php if ($pageNum_Recordset1 < $totalPages_Recordset1) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, $totalPages_Recordset1, $queryString_Recordset1); ?>">Dernier</a>
<?php } // Show if not last page ?></font>
</td>
</tr>
</table>
<font face="Arial, Helvetica, sans-serif" size="2"><?php } // Show if recordset not empty ?></font>
</div>
</td>
</tr>
</table>
</td>
</tr>
</table>
</center>
</body>
</html>
<?php
mysql_free_result($Recordset1);
?>
