Total de visitas: 10229
|
bate papo
/******
SET UP MYSQL LIKE THIS!!
create table YOURTABLE (
SID varchar(100) NOT NULL,
time varchar(15) NOT NULL,
day varchar (3) NOT NULL);
*****
$Session_name = ’Your_session’; // The Sessions name, write ’default’ for default name
$host = ’localhost’; // Your host
$username = ’username’; // Your MySQL username
$password = ’password’; // Your MySQL password
$database = ’database’; // Your Database of choice
$table = ’table’; // Your Table of choice, ex. ’online_users’
/**
Não mexe nesse código abaixo se você não tem certeza do que está fazendo
**/
// Starts Session
if ($Session_name == ’default’) {
session_start();
}
else
session_name(’$Session_name’);
session_start(’$Session_name’);
}
$SID = session_id();
$time = time();
$dag = date(’z’);
$nu = time()-900;
//This connects to the MySQL server
mysql_connect ($host, $username, $password) OR DIE (’Could not connect to MySQL’);
mysql_select_db($database) OR DIE (’Cannot select database.’);
// Check to see if the session_id is already registerd
$sidcheck = mysql_query(’SELECT count(*) FROM $table WHERE SID="$SID"’);
$sid_check = mysql_result($sidcheck,0);
if ($sid_check == ’0’) {
// If not, the session_id will be stored in MySQL
mysql_query(’INSERT INTO $table VALUES ("$SID","$time","$dag")’);
} else {
// If it is, it will register a new time to the session.
mysql_query(’UPDATE $table SET time="$time" WHERE SID="$SID"’);
}
// This is it, this counts the users currently online
$count_users = mysql_query(’SELECT count(*) FROM $table WHERE time>$nu AND day=$dag’);
$users_online = mysql_result($count_users,0);
// This deletes old ids, so your db will not get overloaded.
mysql_query(’DELETE FROM $table WHERE time<$nu’);
mysql_query(’DELETE FROM $table WHERE day != $dag’);
mysql_close();
if ($users_online == ’1’) {
echo ’You are alone to view this page right now. ’;
else
echo ’There"s $users_online people viewing this page right now. ’;
}
?>
|
|
