Forgot Password / Register
Site Statistics
Total Members: 520
Total Tutorials: 242
Newsest User: 8884244477
Todays Unique Hits: 5
0 Users 6 Guests Online
Forum Index » PHP + MySQL » Help...
Posted on Thursday 21st February 20 at 01:46 AM
darklight19
templates/default/images/noavatar.png's Avatar
Active Member
How can I make it so it sets the user to offline? This code don't seem to work.

<?php
$con = mysql_connect(localhost, 'root', '') or die(mysql_error());
$db = mysql_select_db(users, $con);
setOffline();
function setOffline(){
$result = mysql_query("SELECT * FROM users");
while($row = mysql_fetch_array($result))
{
if($row['lastclick'] > time() + (0 * 0 * 15 * 60) && $row['online'] == 1){
echo "User {$row['username']} was logged out.<br>";
mysql_query("UPDATE users SET online='0' WHERE id={$row['id']}")
or die(mysql_error());
// mysql_query("UPDATE users SET forcelogout='1' WHERE id={$row['id']}")
//or die(mysql_error());
}
}
}

?>
Posted on Thursday 21st February 20 at 01:56 AM
ShadowMage
templates/default/images/noavatar.png's Avatar
Senior Member
if your using time(); it will auto log him out here, i'll show ya my scripts:::

my config:
Code

$offline_time = 300;
$current = time();
$offline_math = ($current - $offline_time);
global $offline_time, $current, $offline_math;


then my users online:
Code

<?php
if($logged->username){
$update_online = $MySql->sqlQuery("UPDATE `".DB_PREFIX."users_info` SET `online` = '$current', `useragent` = '".$_SERVER[HTTP_USER_AGENT]."' WHERE `username` = '$logged->username' AND `id` = '$logged->id';");
}else{
$get_ip = $MySql->sqlQuery("SELECT * FROM `".DB_PREFIX."guests` WHERE `ip` = '$ip';");
if($MySql->numRows($get_ip) == 0){
$insert = $MySql->sqlQuery("INSERT INTO `".DB_PREFIX."guests` (`online`,`ip`) VALUES ('$current','$ip');");
}else{
$update = $MySql->sqlQuery("UPDATE `".DB_PREFIX."guests` SET `online` = '$current' WHERE `ip` = '$ip';");
}
}
$get_online_users = $MySql->sqlQuery("SELECT * FROM `".DB_PREFIX."users_info` WHERE `online` >= '$offline_math';");
$get_online_guests = $MySql->sqlQuery("SELECT * FROM `".DB_PREFIX."guests` WHERE `online` >= '$offline_math';");
$total_users_online = $MySql->numRows($get_online_users);
$total_guests_online = $MySql->numRows($get_online_guests);
print "<b>Users Online</b>: $total_users_online<br />
<b>Guests Online</b>: $total_guests_online<br />";
if($total_users_online == 0){
print "No Users Online!";
}else{
$i = 0;
while($users_on = $MySql->fetchArray($get_online_users)){
if(($i >= 1) && ($i != $total_online_users)){
$comma = ", ";
}else{
$comma = "";
}
$browser = $Functions->WhatBrowser($users_on->useragent);
print "$browser<a href=\"http://joe.hrwr.org/members/$users_on->username/\">$users_on->username</a>$comma";
}
}
?>

;)
Posted on Thursday 21st February 20 at 04:14 AM
darklight19
templates/default/images/noavatar.png's Avatar
Active Member
I already made a script for that, what I meant was, when I load that page I want it to set each inactive user to offline, like a cron job ran every 15mins.
Posted on Thursday 21st February 20 at 04:15 AM
darklight19
templates/default/images/noavatar.png's Avatar
Active Member
and im not using the member system from here, i made my own :D
Posted on Thursday 21st February 20 at 08:16 PM
ShadowMage
templates/default/images/noavatar.png's Avatar
Senior Member
ah ok
Posted on Thursday 21st February 20 at 11:33 PM
darklight19
templates/default/images/noavatar.png's Avatar
Active Member
So, any tips on how to do it?
Posted on Sunday 24th February 2008 at 07:53 PM
darklight19
templates/default/images/noavatar.png's Avatar
Active Member
bump