Guest
Public paste!

Untitled

By: a guest | Mar 9th, 2010 | Syntax: PHP | Size: 0.61 KB | Hits: 50 | Expires: Never
Copy text to clipboard
  1. <?php
  2. //Mise à jour de ta table des membres connectés
  3. $sql="UPDATE membre SET state=".mysql_escape_string(time())." WHERE (login=\"".mysql_escape_string($pseudo)."\");";
  4. $req=mysql_query($sql,$base) or die((!$DEBUG)?"Erreur SQL...":("Erreur SQL.<br />".$sql."<br />".mysql_error()));
  5.  
  6. //Récupération membres connectés
  7. $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;";
  8. $req=mysql_query($sql,$base) or die((!$DEBUG)?"Erreur SQL...":("Erreur SQL.<br />".$sql."<br />".mysql_error()));
  9. ?>