CODE
CREATE TABLE `zenith_users` (
`uid` int(6) NOT NULL auto_increment,
`username` varchar(32) NOT NULL default '',
`password` varchar(42) NOT NULL default '',
`admin_status` int(1) NOT NULL default '0',
`last_online` int(11) NOT NULL default '0',
PRIMARY KEY (`uid`)
) TYPE=MyISAM
`uid` int(6) NOT NULL auto_increment,
`username` varchar(32) NOT NULL default '',
`password` varchar(42) NOT NULL default '',
`admin_status` int(1) NOT NULL default '0',
`last_online` int(11) NOT NULL default '0',
PRIMARY KEY (`uid`)
) TYPE=MyISAM
Add in head.php, at the end of script, after :
CODE
echo "</table>";
echo "<br></div>";
echo "<br></div>";
CODE
$cookie_name = $config['cookie_prefix'] . 'username';
$cookie_name_trimmed = trim(str_replace(array("|","/","$",":","*","`","?",";"),"", $cookie_name));
if ( isset($_COOKIE[$cookie_name_trimmed]) )
{
$last=time();
mysql_query('UPDATE zenith_users SET last_online = '.$last.' WHERE username = "'.$_COOKIE[$cookie_name_trimmed].'" ');
}
$cookie_name_trimmed = trim(str_replace(array("|","/","$",":","*","`","?",";"),"", $cookie_name));
if ( isset($_COOKIE[$cookie_name_trimmed]) )
{
$last=time();
mysql_query('UPDATE zenith_users SET last_online = '.$last.' WHERE username = "'.$_COOKIE[$cookie_name_trimmed].'" ');
}
and this code where you wish to post the name of connected:
CODE
$dernier=time()-600;
$requete = mysql_query ("SELECT username FROM zenith_users WHERE last_online > $dernier ORDER BY username");
while ($ligne = mysql_fetch_object($requete))
{
print ' '.$ligne->username.' - ';
}
$requete = mysql_query ("SELECT username FROM zenith_users WHERE last_online > $dernier ORDER BY username");
while ($ligne = mysql_fetch_object($requete))
{
print ' '.$ligne->username.' - ';
}
an exemple here :
http://www.e-midge.com/zenith/