Bonjour roadster31
Si on laisse le CSS :
$chat = new Chat();
$query = "select * from $chat->table where statut = 0 group by ip_internaute";
$resul = mysql_query($query) OR die('Pas de tchat disponible'); ;
$num = mysql_num_rows($resul);
Sinon sans le style, voila listing.php :
<?php
include_once(realpath(dirname(__FILE__)) . "/../../../fonctions/authplugins.php");
autorisation("chat");
include_once(realpath(dirname(__FILE__)) . "/Chat.class.php");
?>
<html lang="fr">
<head>
<?php if(!isset($page)) $page=0; ?>
</head>
<body>
<div class="row-fluid">
<div class="span12">
<h3><?php echo trad('Configuration', 'admin'); ?></h3>
<div class="span12 bigtable" id="contenu_int">
<div id="contenu_int">
<p align="left"><span class="lien04"><a href="accueil.php" class="lien04">Accueil</a></span> <img src="gfx/suivant.gif" width="12" height="9" border="0" /><a href="module_liste.php" class="lien04">Modules</a> <img src="gfx/suivant.gif" width="12" height="9" border="0" /><a href="#" class="lien04"> Gestion des chats</a></p>
<div class="entete_liste_chat_encours">
<div class="titre">LISTE DES CHATS EN COURS</div>
</div>
<ul id="Nav">
<li style="height:25px; width:147px; border-left:1px solid #96A8B5;">Nom - IP</li>
<li style="height:25px; width:147px; border-left:1px solid #96A8B5;">Date - Heure Début</li>
<li style="height:25px; width:147px; border-left:1px solid #96A8B5;">Date - Heure Fin</li>
<li style="height:25px; width:117px; border-left:1px solid #96A8B5;">Nbr conversations</li>
<li style="height:25px; width:127px; border-left:1px solid #96A8B5;">Admin</li>
<li style="height:25px; width:47px; border-left:1px solid #96A8B5;">Statut</li>
<li style="height:25px; width:78px; border-left:1px solid #96A8B5;">Visualiser</li>
<li style="height:25px; width:44px; border-left:1px solid #96A8B5;">Lu</li>
<li style="height:25px; width:14px; border-left:1px solid #96A8B5;">Suppr.</li>
</ul>
<div class="bordure_bottom" id="resul">
<?php
if($page=="") $page=1;
$chat = new Chat();
$query = "select * from $chat->table where statut = 0 group by ip_internaute";
$resul = mysql_query($query) OR die('Pas de tchat disponible'); ;
$num = mysql_num_rows($resul);
$nbpage = 20;
$totnbpage = ceil($num/20);
$debut = ($page-1) * 20;
if($page>1) $pageprec=$page-1;
else $pageprec=$page;
if($page<$totnbpage) $pagesuiv=$page+1;
else $pagesuiv=$page;
if(isset($classement) && $classement != "") $ordclassement = "order by ".$classement;
else $ordclassement = "order by nom asc";
$chat = new Chat();
$query = "select * from $chat->table where statut = 0 group by ip_internaute limit $debut,20";
$resul = mysql_query($query,$chat->link);
$i=0;
while($row = mysql_fetch_object($resul)){
$ip_internaute = $row->ip_internaute;
$id_conversation = $row->id_conversation;
$query2 = "select count(ip_internaute) from $chat->table where ip_internaute = '$ip_internaute' and id_conversation = '$id_conversation '";
$resul2 = mysql_query($query2,$chat->link);
$count = mysql_fetch_row($resul2);
$query3 = "select date_time from $chat->table where ip_internaute = '$ip_internaute' and id_conversation = '$id_conversation ' order by date_time desc limit 0, 1";
$resul3 = mysql_query($query3,$chat->link);
$derniere_conversation = mysql_fetch_row($resul3);
$query4 = "select distinct reponse_admin from $chat->table where reponse_admin > 0 and id_conversation = '$id_conversation '";
$resul4 = mysql_query($query4,$chat->link);
$admin_id = "";
while($row_admin = mysql_fetch_object($resul4)){
$admin_id[]= $row_admin->reponse_admin;
}
$count_admin = count($admin_id);
$admins = "";
for($i=0 ; $i<$count_admin; $i++) {
$query5 = "select prenom from administrateur where id = '$admin_id[$i]' ";
$resul5 = mysql_query($query5,$chat->link);
$admin_prenom= mysql_fetch_row($resul5);
$admins .= $admin_prenom[0];
if($i != $count_admin-1){
$admins .= ",";
}
}
if(!($i%2)) $fond="ligne_claire_rub";
else $fond="ligne_fonce_rub";
$i++;
?>
<ul class="<?php echo($fond); ?>">
<li style="width:140px;">
<?php
if($row->id_client != "0"){ ?><a href="client_visualiser.php?ref=<?php echo $row->id_client; ?>"><?php echo $row->name.'
</a> - '.$row->ip_internaute; }
else {
echo 'Client - '.$row->ip_internaute;
}
?>
</li>
<li style="width:140px;"><?php echo $row->date_time; ?></li>
<li style="width:140px;"><?php echo $derniere_conversation[0]; ?></li>
<li style="width:110px;"><?php echo $count[0]; ?></li>
<li style="width:120px;">
<?php
if($admins == "" && $row->statut == 0){
echo "Chat non pris en charge par un admin";
}
echo $admins;
?>
</li>
<li style="width:40px;"><?php echo $row->statut; ?></li>
<li style="width:71px;"><a href="module.php?nom=chat&vue=view&ip_internaute=<?php echo $row->ip_internaute; ?>&id_conversation=<?php echo $row->id_conversation; ?>">Visualiser</a></li>
<li style="width:37px;"><?php if($row->lu) echo "oui"; else echo "non"; ?></li>
<li style="width:37px; text-align:center;"><a href="modules.php?nom=chat&action=supprimer&id=<?php echo $row->id; ?>"><img src="gfx/supprimer.gif" width="9" height="9" border="0" /></a></li>
</ul>
<?php
}
?>
</div>
<div class="entete_liste_chat_cloturer">
<div class="titre">LISTE DES CHATS CLOTURES</div>
</div>
<ul id="Nav">
<li style="height:25px; width:147px; border-left:1px solid #96A8B5;">Nom - IP</li>
<li style="height:25px; width:147px; border-left:1px solid #96A8B5;">Date - Heure Début</li>
<li style="height:25px; width:147px; border-left:1px solid #96A8B5;">Date - Heure Fin</li>
<li style="height:25px; width:117px; border-left:1px solid #96A8B5;">Nbr conversations</li>
<li style="height:25px; width:127px; border-left:1px solid #96A8B5;">Admin</li>
<li style="height:25px; width:47px; border-left:1px solid #96A8B5;">Statut</li>
<li style="height:25px; width:78px; border-left:1px solid #96A8B5;">Visualiser</li>
<li style="height:25px; width:44px; border-left:1px solid #96A8B5;">Lu</li>
<li style="height:25px; width:14px; border-left:1px solid #96A8B5;">Suppr.</li>
</ul>
<div class="bordure_bottom" id="resul">
<?php
if($page=="") $page=1;
$chat = new Chat();
$query = "select * from $chat->table where statut > '0' group by id_conversation";
$resul = mysql_query($query);
$num = mysql_num_rows($resul);
$nbpage = 10;
$totnbpage = ceil($num/10);
$debut = ($page-1) * 10;
if($page>1) $pageprec=$page-1;
else $pageprec=$page;
if($page<$totnbpage) $pagesuiv=$page+1;
else $pagesuiv=$page;
if(isset($classement) && $classement != "") $ordclassement = "order by ".$classement;
else $ordclassement = "order by nom asc";
$chat = new Chat();
$query = "select * from $chat->table where statut > '0' group by id_conversation order by id_conversation desc limit $debut,10";
$resul = mysql_query($query,$chat->link);
while($row = mysql_fetch_object($resul)){
if(!($j%2)) $fond="ligne_claire_rub";
else $fond="ligne_fonce_rub";
$j++;
$ip_internaute = $row->ip_internaute;
$id_conversation = $row->id_conversation;
$query2 = "select count(ip_internaute) from $chat->table where ip_internaute = '$ip_internaute' and id_conversation = '$id_conversation '";
$resul2 = mysql_query($query2,$chat->link);
$count = mysql_fetch_row($resul2);
$query3 = "select date_time from $chat->table where ip_internaute = '$ip_internaute' and id_conversation = '$id_conversation ' order by date_time desc limit 0, 1";
$resul3 = mysql_query($query3,$chat->link);
$derniere_conversation = mysql_fetch_row($resul3);
$query4 = "select distinct reponse_admin from $chat->table where reponse_admin > 0 and id_conversation = '$id_conversation '";
$resul4 = mysql_query($query4,$chat->link);
$admin_id = "";
while($row_admin = mysql_fetch_object($resul4)){
$admin_id[]= $row_admin->reponse_admin;
}
$count_admin = count($admin_id);
$admins = "";
for($i=0 ; $i<$count_admin; $i++) {
$query5 = "select prenom from administrateur where id = '$admin_id[$i]' ";
$resul5 = mysql_query($query5,$chat->link);
$admin_prenom= mysql_fetch_row($resul5);
$admins .= $admin_prenom[0];
if($i != $count_admin-1){
$admins .= ",";
}
}
?>
<ul class="<?php echo($fond); ?>">
<li style="width:140px;">
<?php
if($row->id_client != "0"){ ?><a href="client_visualiser.php?ref=<?php echo $row->id_client; ?>"><?php echo $row->name.'
</a> - '.$row->ip_internaute; }
else {
echo 'Client - '.$row->ip_internaute;
}
?>
</li>
<li style="width:140px;"><?php echo $row->date_time; ?></li>
<li style="width:140px;"><?php echo $derniere_conversation[0]; ?></li>
<li style="width:110px;"><?php echo $count[0]; ?></li>
<li style="width:120px;">
<?php
if($admins == "" && $row->statut == 1){
echo "Chat non pris en charge par un admin";
}
echo $admins;
?>
</li>
<li style="width:40px;"><?php echo $row->statut; ?></li>
<li style="width:71px;"><a href="module.php?nom=chat&vue=view_finish&ip_internaute=<?php echo $row->ip_internaute; ?>&id_conversation=<?php echo $row->id_conversation; ?>">Visualiser</a></li>
<li style="width:37px;"><?php if($row->lu) echo "oui"; else echo "non"; ?></li>
<li style="width:37px; text-align:center;"><a href="modules.php?nom=chat&action=supprimer&id=<?php echo $row->id; ?>"><img src="gfx/supprimer.gif" width="9" height="9" border="0" /></a></li>
</ul>
<?php
}
?>
<p id="pages">
<?php if($page>1){ ?>
<a href="<?php echo($_SERVER['PHP_SELF']); ?>?nom=chat&page=<?php echo($pageprec); ?>">Page précédente</a> |
<?php } ?>
<?php if($totnbpage > $nbpage){?>
<?php if($page>1) {?><a href="<?php echo($_SERVER['PHP_SELF']); ?>?nom=chat&page=1">...</a> | <?php } ?>
<?php if($page+$nbpage-1 > $totnbpage){ $max = $totnbpage; $min = $totnbpage-$nbpage;} else{$min = $page-1; $max=$page+$nbpage-1; }?>
<?php for($i=$min; $i<$max; $i++){ ?>
<?php if($page != $i+1){ ?>
<a href="<?php echo($_SERVER['PHP_SELF']); ?>?nom=chat&=<?php echo($i+1); ?>&classement=<?php echo($classement); ?>"><?php echo($i+1); ?></a> |
<?php } else {?>
<span class="selected"><?php echo($i+1); ?></span>
|
<?php } ?>
<?php } ?>
<?php if($page < $totnbpage){?><a href="<?php echo($_SERVER['PHP_SELF']); ?>?nom=chat&page=<?php echo $totnbpage; ?>">...</a> | <?php } ?>
<?php }
else{
for($i=0; $i<$totnbpage; $i++){ ?>
<?php if($page != $i+1){ ?>
<a href="<?php echo($_SERVER['PHP_SELF']); ?>?nom=chat&page=<?php echo($i+1); ?>&classement=<?php echo($classement); ?><?php echo $lien_voir; ?>"><?php echo($i+1); ?></a> |
<?php } else {?>
<span class="selected"><?php echo($i+1); ?></span>
|
<?php } ?>
<?php } ?>
<?php } ?>
<?php if($page < $totnbpage){ ?>
<a href="<?php echo($_SERVER['PHP_SELF']); ?>?nom=chat&page=<?php echo($pagesuiv); ?>">Page suivante</a></p>
<?php } ?>
</div>
</div>
</div>
</div>
</body>
</html>