memberliste med online og offline funktion

mine to table

først login ::

CREATE TABLE `login` (
  `ID` int(11) NOT NULL auto_increment,
  `user` varchar(50) NOT NULL default '',
  `pass` varchar(16) NOT NULL default '',
  `ip` varchar(15) NOT NULL default '',
  `navn` varchar(51) NOT NULL default 'Ikke oplyst',
  `email` varchar(50) NOT NULL default '',
  `alder` char(2) NOT NULL default '0',
  `profiltekst` longtext NOT NULL,
  `fil` varchar(50) NOT NULL default '',
  `bopael` varchar(50) NOT NULL default '',
  `tlf` varchar(50) NOT NULL default '',
  `tid` varchar(50) NOT NULL default '',
  `hp` varchar(50) NOT NULL default 'Ikke oplyst',
  `status` char(1) NOT NULL default '',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `idx_brugere` (`user`),
  FULLTEXT KEY `profiltekst` (`profiltekst`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=1 ;

derefter memberlist  :::

CREATE TABLE memberlist (
  timestamp int(11) NOT NULL default '0',
  ip varchar(40) NOT NULL default '',
  username varchar(30) NOT NULL default '',
  PRIMARY KEY  (timestamp,ip),
  KEY timestamp (timestamp),
  KEY ip (ip)
) TYPE=MyISAM;

mit script der skulle finde udaf hvem der er online eller offline
men der kommer ikke rigtigt noget frem mmmm.

hjælp søges

<?
mysql_connect("localhost", "bruger", "kode");
mysql_select_db("db");

function doUsersOnline() {
    global $REMOTE_ADDR;

    $db = new db;
    $auth = new authenticate;
    $now = time();
    $expire = $now - 600;
    $query = "DELETE FROM memberlist WHERE timestamp < $expire";
    $db->db_query($query);
    if($auth->checkLogin()) {
        $username = $auth->getName();
    } else {
        $username = "-1";
    }

    $query = "SELECT ip,user FROM login WHERE ip='$REMOTE_ADDR'";
    $result = $db->db_query($query);
    if(($db->db_numrows($result)) == 0) {
        $query = "INSERT memberlist (timestamp,ip,user) VALUES ($now,'$REMOTE_ADDR','$username')";
        $db->db_query($query);
    } else {
        $row = $db->db_fetch_array($result);
        if ($row['username'] != $username) {
        $query = "UPDATE memberlist SET username='".$user."' WHERE ip='".$REMOTE_ADDR."'";
        $db->db_query($query);}
    }
    $query = "SELECT timestamp FROM memberlist WHERE username='-1'";
    $result = $db->db_query($query);
    $guests = $db->db_numrows($result);
    $query = "SELECT username FROM memberlist WHERE username <> '-1'";
    $result = $db->db_query($query);
    $members = $db->db_numrows($result);
    for($i=0;$i < $members;$i++) {
        $row = $db->db_fetch_array($result);
        $membernames[$i] = $row['user'];
    }
    $returnarray = array($guests,$members,$membernames);
    return $returnarray;
}
?>