Posted on Thursday 21st February 20 at 01:46 AM | |
darklight19 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 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 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 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 Senior Member |
ah ok |
Posted on Thursday 21st February 20 at 11:33 PM | |
darklight19 Active Member |
So, any tips on how to do it? |
Posted on Sunday 24th February 2008 at 07:53 PM | |
darklight19 Active Member |
bump |