Untitled
By: a guest | Mar 9th, 2010 | Syntax:
PHP | Size: 0.61 KB | Hits: 50 | Expires: Never
<?php
//Mise à jour de ta table des membres connectés
$sql="UPDATE membre SET state=".mysql_escape_string(time())." WHERE (login=\"".mysql_escape_string($pseudo)."\");";
$req=mysql_query($sql,$base) or die((!$DEBUG)?"Erreur SQL...":("Erreur SQL.<br />".$sql."<br />".mysql_error()));
//Récupération membres connectés
$sql="SELECT msg_perso,login,avatar FROM membre WHERE (state >= (".mysql_escape_string(time())."-10)) AND (login != \"".mysql_escape_string($pseudo)."\") ORDER BY login ASC;";
$req=mysql_query($sql,$base) or die((!$DEBUG)?"Erreur SQL...":("Erreur SQL.<br />".$sql."<br />".mysql_error()));
?>