$oldtime = date("YmdHis", $prev); $query = "SELECT user_id,lastaction,sessionid FROM livehelp_users WHERE isoperator='Y' AND authenticated='Y' AND (ismobile='Y' OR ismobile='P') AND lastaction<'{$oldtime}'"; $data2 = $mydatabase->query($query); while ($row = $data2->fetchRow(DB_FETCHMODE_ASSOC)) { $opid = $row['user_id']; $lastaction = $row['lastaction']; $sessionid = $row['sessionid']; // get when they logged in and how many seconds they have been online: $query = "SELECT dateof FROM livehelp_operator_history WHERE opid={$opid} AND action='login' ORDER by dateof DESC LIMIT 1"; $data3 = $mydatabase->query($query); $row3 = $data3->fetchRow(DB_FETCHMODE_ASSOC); $seconds = timediff($lastaction, $row3['dateof']); // update history for operator to show login: $query = "INSERT INTO livehelp_operator_history (opid,action,dateof,sessionid,totaltime) VALUES ({$opid},'Logout','{$lastaction}','{$sessionid}',{$seconds})"; $mydatabase->query($query); // log them off: $query = "UPDATE livehelp_users set authenticated='N',isonline='N',status='offline' WHERE user_id={$opid}"; $mydatabase->query($query); } } // chatters who closed their chat window timeout after a minute of inactivity..: $aminute = mktime(date("H"), date("i") - 1, date("s") - 30, date("m"), date("d"), date("Y")); $oldchat = date("YmdHis", $aminute); $sqlquery = "SELECT sessionid,user_id FROM livehelp_users WHERE status='chat' AND isoperator='N' AND chataction<{$oldchat}"; $old_people = $mydatabase->query($sqlquery); while ($old_chat = $old_people->fetchRow(DB_FETCHMODE_ORDERED)) { $sessionid = $old_chat[0]; $user_id = $old_chat[1]; stopchat($sessionid); } // end of old chats where user closed chat window.
// -------------------------------------------------------------------------- // LICENSE: // This program is free software; you can redistribute it and/or // modify it under the terms of the GNU General Public License // as published by the Free Software Foundation; // This program is distributed in the hope that it will be useful, // but WITHOUT ANY WARRANTY; without even the implied warranty of // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the // GNU General Public License for more details. // // You should have received a copy of the GNU General Public License // along with this program in a file named LICENSE.txt . //=========================================================================== require_once "visitor_common.php"; // stop chat. stopchat($identity['SESSIONID']); // get department information... $where = ""; if ($UNTRUSTED['department'] != 0) { $where = " WHERE recno=" . intval($UNTRUSTED['department']); } $sqlquery = "SELECT * FROM livehelp_departments {$where} "; $data_d = $mydatabase->query($sqlquery); $department_a = $data_d->fetchRow(DB_FETCHMODE_ASSOC); $department = $department_a['recno']; $topframeheight = $department_a['topframeheight']; $topbackground = $department_a['topbackground']; $botbackcolor = $department_a['botbackcolor']; $botbackground = $department_a['botbackground']; $midbackcolor = $department_a['midbackcolor']; $midbackground = $department_a['midbackground'];