$sqlquery = "SELECT * from livehelp_visit_track WHERE sessionid='" . $visitor['sessionid'] . "' Order by whendone DESC";
$page_trail = $mydatabase->query($sqlquery);
$page = $page_trail->fetchRow(DB_FETCHMODE_ASSOC);
$sqlquery = "SELECT * from livehelp_departments WHERE recno='" . $visitor['department'] . "'";
$tmp = $mydatabase->query($sqlquery);
$nameof = $tmp->fetchRow(DB_FETCHMODE_ASSOC);
$nameof = $nameof['nameof'];
$query = "SELECT whendone from livehelp_visit_track WHERE sessionid='" . filter_sql($visitor['sessionid']) . "' Order by whendone LIMIT 1";
$page_tmprow = $mydatabase->query($query);
$tmprow = $page_tmprow->fetchRow(DB_FETCHMODE_ASSOC);
$later = $tmprow['whendone'];
$DIVS .= "<DIV ID=\"info-" . $visitor['username'] . "\" STYLE=\"position: absolute; z-index: 20; visibility: hidden; top: 0px; left: 0px;\">\n<TABLE BORDER=\"0\" WIDTH=\"300\"><TR BGCOLOR=\"#000000\"><TD> \n<TABLE BORDER=\"0\" WIDTH=\"100%\" CELLPADDING=0 CELLSPACING=0 BORDER=0><TR><TD width=1 BGCOLOR=#" . $color_alt2 . "><img src=images/blank.gif width=7 height=120></TD><TD BGCOLOR=\"#" . $color_alt2 . "\" valign=top>\n<FONT COLOR=\"#000000\">\n<b>Referer:</b><br>" . $user_info['camefrom'] . "<br>";
if (empty($page['location'])) {
$page['location'] = "";
}
$DIVS .= "<b>" . $lang['timeonline'] . ":</b>" . secondstoHHmmss(timediff($later, date("YmdHis"))) . "<br> \n<b>" . $lang['txt43'] . ":</b><br>{$nameof}<br>\n<b>url:</b><br>" . $page['location'] . "<br>";
$now = date("YmdHis");
$thediff = $now - $user_info['lastaction'];
$DIVS .= "<b>" . $lang['lastact'] . ":</b><br>{$thediff} " . $lang['Seconds'] . "<br>\n </FONT></TD></TR></TABLE></TD></TR></TABLE></DIV>";
$html .= "</td>";
switch ($visitor['status']) {
case "DHTML":
$html .= "<td>L:<img src=images/invited.gif> ";
break;
case "request":
$html .= "<td>P:<img src=images/invited.gif> ";
break;
case "invited":
$html .= "<td><img src=images/invited2.gif> ";
break;
case "qna":
if (!empty($dataset[1])) {
$fieldid = str_replace("field_", "", $dataset[0]);
$query = "SELECT * FROM livehelp_questions WHERE id=" . intval($fieldid);
$questiondata = $mydatabase->query($query);
$question_row = $questiondata->fetchRow(DB_FETCHMODE_ASSOC);
print "<b> " . $question_row['headertext'] . ":</b> <br><font color=000000>" . urldecode($dataset[1]) . "</font><br>";
}
}
$now = date("YmdHis");
$thediff = $now - $user_info['lastaction'];
print "<b>" . $lang['txt65'] . "</b> {$thediff} sec. <br>";
// time online:
$query = "SELECT whendone from livehelp_visit_track WHERE sessionid='" . filter_sql($user_info['sessionid']) . "' Order by whendone LIMIT 1";
$page_trail = $mydatabase->query($query);
$page = $page_trail->fetchRow(DB_FETCHMODE_ASSOC);
$later = $page['whendone'];
print "<b>Time online:</b>" . secondstoHHmmss(timediff($later, date("YmdHis"))) . "<br>";
print "<b>" . $lang['txt66'] . "</b><br>";
$query = "SELECT * from livehelp_visit_track WHERE sessionid='" . filter_sql($user_info['sessionid']) . "' Order by whendone DESC";
$page_trail = $mydatabase->query($query);
print "<table border=1><tr bgcolor=FFFFFF><td>" . $lang['txt67'] . "</td><td>url</td><td>" . $lang['date'] . "</td></tr>";
while ($page = $page_trail->fetchRow(DB_FETCHMODE_ASSOC)) {
$when = mktime(substr($page['whendone'], 8, 2), substr($page['whendone'], 10, 2), substr($page['whendone'], 12, 2), substr($page['whendone'], 4, 2), substr($page['whendone'], 6, 2), substr($page['whendone'], 0, 4));
print "<tr><td>" . $page['title'] . "</td><td><a href=" . $page['location'] . " target=_blank>" . $page['location'] . "</a></td><td>";
print date("F j, Y, g:i a", $when);
print "</td></tr>";
}
print "</table><br><center><a href=javascript:window.close()>" . $lang['txt40'] . "</a>";
if (!$serversession) {
$mydatabase->close_connect();
}
$OnlineStatus = "N";
$ChatCount = 0;
$UserInfo = "";
$TimeOnline = "";
$CurLocation = "";
while ($visitor = $visitors->fetchRow(DB_FETCHMODE_ASSOC)) {
if ($visitor['isoperator'] == "N") {
if ($visitor['status'] == "chat") {
$ChatCount++;
}
$TrackQuery = "SELECT * FROM livehelp_visit_track WHERE sessionid='" . $visitor['sessionid'] . "'";
$Tracks = $mydatabase->query($TrackQuery);
while ($tracking = $Tracks->fetchRow(DB_FETCHMODE_ASSOC)) {
$CurLocation = $tracking['location'];
$later = $tracking['whendone'];
$TimeOnline = secondstoHHmmss(timediff($later, date("YmdHis")));
}
$UserInfo = $visitor['user_id'] . "::" . $visitor['username'] . "::" . $visitor['ipaddress'] . "::" . $visitor['status'] . "::" . $visitor['camefrom'] . "::" . $TimeOnline . "::" . $CurLocation . ",," . $UserInfo;
}
if ($visitor['username'] == $_GET['username']) {
$OnlineStatus = $visitor['isonline'];
$MyUserID = $visitor['user_id'];
}
}
// get the count of active visitors in the system right now.
$timeof = date("YmdHis");
$prev = mktime(date("H"), date("i") - 4, date("s"), date("m"), date("d"), date("Y"));
$oldtime = date("YmdHis", $prev);
$sqlquery = "SELECT * FROM livehelp_users WHERE lastaction>'{$oldtime}' AND isoperator!='Y' ";
// make list of ignored visitors:
$MyOwnIP = $_SERVER['REMOTE_ADDR'];
function gethtml()
{
global $alertinsite, $alertchat, $insitewav, $soundwav, $hidechatters, $color_alt2, $color_alt4, $color_background, $numchatsnow, $UNTRUSTED, $CSLH_Config, $operators, $operators_array, $ignorelist_array, $ignorelist, $lang, $show_arrival, $mydatabase, $identity, $onload, $myid, $stuffatbottom, $user_alert;
$onload = "";
$DIVS = " ";
$lasthtml = "";
$timeof = rightnowtime();
// update operators timestamp .
$sql = "UPDATE livehelp_users set lastaction='{$timeof}' WHERE sessionid='" . $identity['SESSIONID'] . "' ";
$mydatabase->query($sql);
/// Current Chat Requests: -----------------------------------------------------------
$html = "<table width=100% bgcolor=" . $color_alt2 . "><tr>";
$html .= "<td width=20> </td>";
$html .= "<td><b>" . $lang['txt230'] . "</b></td></tr></table>";
$prev = mktime(date("H"), date("i") - 10, date("s"), date("m"), date("d"), date("Y"));
$oldtime = date("YmdHis", $prev);
$sqlquery = "SELECT * FROM livehelp_users WHERE status='chat' AND isoperator='N' ORDER by showedup";
$chatcheck = $mydatabase->query($sqlquery);
$numchatnow = $chatcheck->numrows();
$html .= "<table width=100%>";
$chatrequests = 0;
while ($visitor = $chatcheck->fetchRow(DB_FETCHMODE_ASSOC)) {
$actionlink = "";
$chatting = "";
// see if we are in the same department as this user..
$sqlquery = "SELECT * FROM livehelp_operator_departments WHERE user_id='{$myid}' AND department='" . $visitor['department'] . "' ";
$data_check = $mydatabase->query($sqlquery);
if ($data_check->numrows() == 0) {
// we are not in the department that this user is chatting in..
} else {
// see if anyone is chatting with this person.
$sqlquery = "SELECT * FROM livehelp_operator_channels WHERE channel='" . $visitor['onchannel'] . "'";
$counting = $mydatabase->query($sqlquery);
$showedup = substr($visitor['showedup'], 8, 2) . ":" . substr($visitor['showedup'], 10, 2);
if ($counting->numrows() == 0) {
$updated_ignore = $ignorelist . "," . $visitor['user_id'];
$chatting = "<img src=images/needaction.gif width=21 height=20 border=0>";
$actionlink = "[<a href=admin_users_refresh.php?hidechatters=" . $hidechatters . "&ignorelist={$ignorelist}&numchats={$numchatsnow}&autoanswer=" . $UNTRUSTED['autoanswer'] . "&operators={$operators}&action=activiate&who=" . $visitor['user_id'] . "&whatchannel=" . $visitor['onchannel'] . "&showvisitors=" . $UNTRUSTED['showvisitors'] . "&needaction=1>" . $lang['Activate'] . "</a>]\n";
if ($UNTRUSTED['autoanswer'] == "Y") {
print "<script>window.location.replace('admin_users_refresh.php?hidechatters=" . $hidechatters . "&ignorelist={$ignorelist}&numchats={$numchatsnow}&autoanswer=" . $UNTRUSTED['autoanswer'] . "&operators={$operators}&action=activiate&who=" . $visitor['user_id'] . "&whatchannel=" . $visitor['onchannel'] . "&showvisitors=" . $UNTRUSTED['showvisitors'] . "&needaction=1');</script>";
}
if (!in_array($visitor['user_id'], $ignorelist_array)) {
$actionlink .= "[<a href=admin_users_refresh.php?hidechatters=" . $hidechatters . "&ignorelist={$updated_ignore}&numchats={$numchatsnow}&autoanswer=" . $UNTRUSTED['autoanswer'] . "&operators={$operators}&showvisitors=" . $UNTRUSTED['showvisitors'] . ">" . $lang['Ignore'] . "</a>]\n";
$onload = " setTimeout(\"tellme(0);\",500); ";
$chatrequests++;
if ($user_alert == "N" || $user_alert == "") {
$soundwav = " <embed src=\"sounds/" . $alertchat . "\" autostart=true loop=false width=1 height=1> ";
$stuffatbottom .= "\n<SCRIPT type=\"text/javascript\">top.status=\"[activate]\";top.status=\"\"; setTimeout(\"tellme(0);\",1500); </SCRIPT>\n";
}
}
if (!in_array($visitor['user_id'], $ignorelist_array)) {
$html .= "<tr><td width=10> {$showedup} </td><td nowrap=nowrap><table><tr><td>{$chatting}</td><td><a href=javascript:seepages(" . $visitor['user_id'] . ") onMouseOver=\"try { hide('visitorsdiv');hide('chattersdiv');show(event, 'info-" . $visitor['username'] . "'); } catch(dam){} return true;\" onMouseOut=\"try { showit('chattersdiv');showit('visitorsdiv');hide('info-" . $visitor['username'] . "'); } catch(dam){} return true;\">" . $visitor['username'] . "</a> {$actionlink} </td></tr></table></td></tr>\n";
} else {
$html .= "<tr bgcolor=#DDDDDD><td width=10> {$showedup} </td><td nowrap=nowrap><table><tr><td>{$chatting}</td><td><a href=javascript:seepages(" . $visitor['user_id'] . ") onMouseOver=\"try { hide('visitorsdiv');hide('chattersdiv');show(event, 'info-" . $visitor['username'] . "');} catch(dam){} return true;\" onMouseOut=\"try { showit('chattersdiv');showit('visitorsdiv');hide('info-" . $visitor['username'] . "'); } catch(dam){} return true;\">" . $visitor['username'] . "</a> {$actionlink} </td></tr></table></td></tr>\n";
}
$chatrequests++;
$sqlquery = "SELECT * from livehelp_users WHERE sessionid='" . $visitor['sessionid'] . "'";
$user_info = $mydatabase->query($sqlquery);
$user_info = $user_info->fetchRow(DB_FETCHMODE_ASSOC);
$sqlquery = "SELECT * from livehelp_visit_track WHERE sessionid='" . $visitor['sessionid'] . "' Order by whendone DESC LIMIT 1";
$page_trail = $mydatabase->query($sqlquery);
$page = $page_trail->fetchRow(DB_FETCHMODE_ASSOC);
$sqlquery = "SELECT * from livehelp_departments WHERE recno='" . $visitor['department'] . "'";
$tmp = $mydatabase->query($sqlquery);
$nameof = $tmp->fetchRow(DB_FETCHMODE_ASSOC);
$nameof = $nameof['nameof'];
$DIVS .= "<DIV ID=\"info-" . $visitor['username'] . "\" STYLE=\"position: absolute; z-index: 20; visibility: hidden; top: 0px; left: 0px;\">\n <TABLE BORDER=\"0\" WIDTH=\"250\"><TR BGCOLOR=\"#000000\"><TD> \n <TABLE BORDER=\"0\" WIDTH=\"248\" CELLPADDING=0 CELLSPACING=0 BORDER=0><TR><TD width=1 BGCOLOR=#" . $color_alt2 . "><img src=images/blank.gif width=7 height=120></TD><TD BGCOLOR=\"#" . $color_alt2 . "\" valign=top>\n <FONT COLOR=\"#000000\">\n <b>" . $lang['referer'] . ":</b><br>" . $user_info['camefrom'] . "<br>\n <b>" . $lang['txt43'] . ":</b><br>{$nameof}<br>\n <b>Url:</b><br><a href=" . $page['location'] . " target=_blank>" . $page['location'] . "</a><br>";
$now = date("YmdHis");
if ($user_info['lastaction'] == "" || $user_info['lastaction'] < 20002020202020) {
$user_info['lastaction'] = $now;
}
$thediff = $now - $user_info['lastaction'];
$DIVS .= "<b>" . $lang['txt65'] . ":</b><br>{$thediff} Seconds ago<br> \n </FONT></TD></TR></TABLE></TD></TR></TABLE></DIV>";
}
}
}
if ($chatrequests == 0) {
$html .= "<tr><td>" . $lang['txt231'] . "</td></tr>";
if ($UNTRUSTED['autoanswer'] == "Y") {
$html .= "<tr><td><i>Auto Answer:</i> <b>ON</b> (<a href=admin_users_refresh.php>Turn OFF</a>)</td></tr>";
if (!empty($UNTRUSTED['notit'])) {
$html .= "<tr bgcolor=FFFFCC><td><i> <b><font color=#990000>NOTE : </font></b> it is recommended you have <b>Typing Alert</b> set to ON so you can be alerted of chats while this is ON . After answering a chat you can turn it OFF.. </td></tr>";
$query = "UPDATE livehelp_users set typing_alert='Y' WHERE sessionid='" . $identity['SESSIONID'] . "'";
$mydatabase->query($query);
print "<script type=\"text/javascript\"> window.parent.rooms.location='admin_rooms.php';</script>";
}
} else {
// used for social panel:
// $html .= "<tr><td><i>Auto Answer:</i> <b>Off</b> (<a href=admin_users_refresh.php?autoanswer=Y¬it=2>Turn ON</a>)</td></tr>";
}
}
$html .= "</table>";
$html .= "<table width=100% bgcolor=" . $color_alt2 . "><tr>";
$sqlquery = "SELECT * FROM livehelp_users WHERE status='chat' AND isoperator='N'";
$chatcheck = $mydatabase->query($sqlquery);
$numchatnow = $chatcheck->numrows();
while ($visitor = $chatcheck->fetchRow(DB_FETCHMODE_ASSOC)) {
$sqlquery = "SELECT * FROM livehelp_operator_channels WHERE channel='" . $visitor['onchannel'] . "'";
$counting = $mydatabase->query($sqlquery);
if ($counting->numrows() == 0 && !in_array($visitor['user_id'], $ignorelist_array)) {
$UNTRUSTED['hidechatters'] = 0;
}
}
if ($UNTRUSTED['hidechatters'] == 1) {
$html .= "<td width=20><a href=admin_users_refresh.php?hidechatters=0&ignorelist={$ignorelist}&numchats={$numchatsnow}&autoanswer=" . $UNTRUSTED['autoanswer'] . "&operators=" . $UNTRUSTED['operators'] . "&hidechatters=0 onclick=\"javascript:shouldireloadbot();\" ><img src=images/plus.gif border=0></a></td>";
} else {
$html .= "<td width=20><a href=admin_users_refresh.php?hidechatters=1&ignorelist={$ignorelist}&numchats={$numchatsnow}&autoanswer=" . $UNTRUSTED['autoanswer'] . "&operators=" . $UNTRUSTED['operators'] . "&hidechatters=1 onclick=\"javascript:shouldireloadbot();\" ><img src=images/minus.gif border=0></a></td>";
}
$html .= "<td><b> " . $lang['chat_text'] . " </b></td></tr></table>";
$prev = mktime(date("H"), date("i") - 4, date("s"), date("m"), date("d"), date("Y"));
$oldtime = date("YmdHis", $prev);
// select out all of the operators that are online chatting:
$sqlquery = "SELECT * FROM livehelp_users WHERE status='chat' ORDER by showedup";
$chatcheck = $mydatabase->query($sqlquery);
$numchatnow = $chatcheck->numrows();
$chatboxes = 0;
$OPhiddennow = 0;
$OPonlinenow = 0;
$html .= "<table width=100% cellpadding=0 cellspacing=0 border=0>";
if ($UNTRUSTED['hidechatters'] != 1) {
$html .= "<tr><td colspan=4 NOWRAP=NOWRAP align=right><b><font color=007700>[OPonlinenow] " . $lang['online'] . "</font> <font color=777777>[OPhiddennow] " . $lang['Hidden'] . "</font></b></td></tr>";
if ($chatcheck->numrows() == 0) {
$html .= "<tr><td>" . $lang['no_chat'] . "</td></tr>";
}
//--List of Chatting users by Operator----------------------------------------------------------------------
$sqlquery = "SELECT * FROM livehelp_users WHERE isonline='Y' and isoperator='Y' ORDER by username";
$chatcheck = $mydatabase->query($sqlquery);
while ($operatorsarray = $chatcheck->fetchRow(DB_FETCHMODE_ASSOC)) {
$actionlink = "";
$chatting = "";
$operatorhtml = "";
$operatorlasthtml = "";
$htmlgray = "";
$lasthtmlgray = "";
$showgray = 0;
// Operators can be on multiple channels so see if one of the channels they are on is one we are on.
$foundcommonchannel = 0;
$sqlquery = "SELECT * FROM livehelp_operator_channels WHERE user_id='" . $operatorsarray['user_id'] . "'";
$mychannels = $mydatabase->query($sqlquery);
while ($rowof = $mychannels->fetchRow(DB_FETCHMODE_ASSOC)) {
$sqlquery = "SELECT * FROM livehelp_operator_channels WHERE user_id='{$myid}' And channel='" . $rowof['channel'] . "'";
$counting = $mydatabase->query($sqlquery);
if ($counting->numrows() != 0) {
$foundcommonchannel = $rowof['channel'];
}
}
// Operators can be on multiple departements so see if this operator is on our department:
$foundcommondepartment = 0;
$sqlquery = "SELECT * FROM livehelp_operator_departments WHERE user_id='" . $operatorsarray['user_id'] . "'";
$mychannels = $mydatabase->query($sqlquery);
while ($rowof = $mychannels->fetchRow(DB_FETCHMODE_ASSOC)) {
$sqlquery = "SELECT * FROM livehelp_operator_departments WHERE user_id='{$myid}' And department='" . $rowof['department'] . "'";
$counting = $mydatabase->query($sqlquery);
if ($counting->numrows() != 0) {
$foundcommondepartment = 1;
}
}
// update the action links acccording to if we are on the same channel or not..
if ($foundcommonchannel == 0) {
$chatting = "<img src=images/noton.gif width=19 height=18 border=0>";
if ($myid != $operatorsarray['user_id']) {
$actionlink = "[<a href=admin_users_refresh.php?hidechatters=" . $hidechatters . "&ignorelist={$ignorelist}&autoanswer=" . $UNTRUSTED['autoanswer'] . "&numchats={$numchatsnow}&operators={$operators}&action=activiate&who=" . $operatorsarray['user_id'] . "&whatchannel=" . $operatorsarray['onchannel'] . "&conferencein=yes&showvisitors=" . $UNTRUSTED['showvisitors'] . "><font color=007700>" . $lang['begin'] . "</font></a>]\n";
} else {
$actionlink = "";
$chatting = "<img src=images/active.gif width=19 height=18 border=0>\n";
}
} else {
$chatting = "<table cellpadding=0 cellspacing=0 border=0 bgcolor=" . $rowof['txtcolor_alt'] . "><tr><td><img src=images/active.gif width=19 height=18 border=0></td></tr></table>\n";
if ($operatorsarray['user_id'] != $myid) {
$actionlink = "[<a href=admin_users_refresh.php?hidechatters=" . $hidechatters . "&ignorelist={$ignorelist}&numchats={$numchatsnow}&autoanswer=" . $UNTRUSTED['autoanswer'] . "&operators={$operators}&action=leave&who=" . $operatorsarray['user_id'] . "&whatchannel={$foundcommonchannel}&clearchannel=N&showvisitors=" . $UNTRUSTED['showvisitors'] . ">" . $lang['stop_chat'] . "</a>]\n";
}
}
// if we are in the same department as this operator show them.. if not show them in gray if and only if
// we have a chatter in common...
if ($foundcommondepartment) {
$OPonlinenow++;
if ($myid != $operatorsarray['user_id']) {
$operatorhtml .= "<tr><td width=21><img src=images/operator.gif width=21 height=20 border=0></td><td colspan=3><table><tr><td>{$chatting}</td><td width=90% align=left> <b>" . $operatorsarray['username'] . "</b> {$actionlink} </td></tr></table></td></tr>\n";
} else {
$operatorlasthtml .= "<tr><td width=21><img src=images/operator.gif width=21 height=20 border=0></td><td colspan=3><table><tr><td>{$chatting}</td><td width=90% align=left> <b>" . $operatorsarray['username'] . "</b> {$actionlink} </td></tr></table></td></tr>\n";
}
} else {
$OPhiddennow++;
if ($myid != $operatorsarray['user_id']) {
$htmlgray .= "<tr><td width=21><img src=images/operator_gray.gif width=21 height=20 border=0></td><td colspan=3><table><tr><td>{$chatting}</td><td width=90% align=left> <b>" . $operatorsarray['username'] . "</b> {$actionlink} </td></tr></table></td></tr>\n";
} else {
$lasthtmlgray .= "<tr><td width=21><img src=images/operator_gray.gif width=21 height=20 border=0></td><td colspan=3><table><tr><td>{$chatting}</td><td width=90% align=left> <b>" . $operatorsarray['username'] . "</b> {$actionlink} </td></tr></table></td></tr>\n";
}
}
// show all of this operators chats:
$q = "SELECT livehelp_users.* FROM livehelp_users,livehelp_operator_channels WHERE livehelp_users.user_id=livehelp_operator_channels.userid AND livehelp_users.status='chat' AND livehelp_operator_channels.user_id=" . $operatorsarray['user_id'] . " ORDER by showedup";
$sth = $mydatabase->query($q);
$showgray = 0;
while ($chatters = $sth->fetchRow(DB_FETCHMODE_ASSOC)) {
$inthedepartment = 1;
$ischattingwith = 0;
// see if we are in the same department as this user..
$sqlquery = "SELECT * FROM livehelp_operator_departments WHERE user_id='{$myid}' AND department='" . $chatters['department'] . "' ";
$data_check = $mydatabase->query($sqlquery);
if ($data_check->numrows() == 0) {
// we are not in the department that this user is chatting in..
$OPhiddennow++;
$inthedepartment = 0;
}
// see if we are chatting with them
$sqlquery = "SELECT * FROM livehelp_operator_channels WHERE user_id='{$myid}' And channel='" . $chatters['onchannel'] . "'";
$counting = $mydatabase->query($sqlquery);
$checkbox = "";
$actionlinkouter = "";
if ($counting->numrows() == 0) {
$chatting = "<img src=images/noton.gif width=19 height=18 border=0>";
$actionlink = "[<a href=admin_users_refresh.php?hidechatters=" . $hidechatters . "&ignorelist={$ignorelist}&numchats={$numchatsnow}&autoanswer=" . $UNTRUSTED['autoanswer'] . "&operators={$operators}&action=activiate&who=" . $chatters['user_id'] . "&whatchannel=" . $chatters['onchannel'] . "&showvisitors=" . $UNTRUSTED['showvisitors'] . "&conferencein=yes><font color=007700>Join Chat</font></a>]\n";
$actionlinkouter = $actionlink;
} else {
$ischattingwith = 1;
$chatboxes++;
$rowof = $counting->fetchRow(DB_FETCHMODE_ASSOC);
$chatting = "<table cellpadding=0 cellspacing=0 border=0 bgcolor=" . $rowof['channelcolor'] . "><tr><td><img src=images/active.gif width=19 height=18 border=0></td></tr></table>\n";
$showgray = 1;
$actionlink = "";
$sqlquery = "SELECT * FROM livehelp_operator_channels WHERE channel='" . $chatters['onchannel'] . "'";
$counting = $mydatabase->query($sqlquery);
if ($counting->numrows() > 1) {
$actionlink = "[<a href=admin_users_refresh.php?hidechatters=" . $hidechatters . "&ignorelist={$ignorelist}&numchats={$numchatsnow}&autoanswer=" . $UNTRUSTED['autoanswer'] . "&operators={$operators}&action=leave&who=" . $chatters['user_id'] . "&whatchannel=" . $chatters['onchannel'] . "&showvisitors=" . $UNTRUSTED['showvisitors'] . ">Un-Conference</a>]\n ";
}
$checkbox = "<input type=checkbox name=session__" . $chatters['user_id'] . " value=" . $chatters['sessionid'] . " border=0>";
$actionlink .= "[<a href=admin_users_refresh.php?hidechatters=" . $hidechatters . "&ignorelist={$ignorelist}&numchats={$numchatsnow}&autoanswer=" . $UNTRUSTED['autoanswer'] . "&operators={$operators}&action=stop&who=" . $chatters['user_id'] . "&whatchannel=" . $chatters['onchannel'] . "&showvisitors=" . $UNTRUSTED['showvisitors'] . "><font color=990000>" . $lang['stop'] . "</font></a>]\n";
}
// see if anyone is chatting with this person.
$sqlquery = "SELECT * FROM livehelp_operator_channels WHERE channel='" . $chatters['onchannel'] . "'";
$counting = $mydatabase->query($sqlquery);
if ($counting->numrows() == 0 && !in_array($chatters['user_id'], $ignorelist_array)) {
// no one is chatting with this person..... they are listed in requested chats...
} else {
$intheuserdepartment = 0;
$sqlquery = "SELECT * FROM livehelp_operator_departments WHERE user_id='{$myid}' And department='" . $chatters['department'] . "'";
$counting = $mydatabase->query($sqlquery);
if ($counting->numrows() != 0) {
$intheuserdepartment = 1;
}
$OPonlinenow++;
if ($myid != $operatorsarray['user_id']) {
if (!($intheuserdepartment == 0 && preg_match("/noton/", $chatting))) {
$operatorhtml .= "<tr bgcolor=#EFEFEF><td> </td><td><img src=images/blank.gif width=5 height=5 border=0></td><td nowrap=nowrap>{$chatting}</td><td width=90% align=left><a href=javascript:seepages(" . $chatters['user_id'] . ") onMouseOver=\" try { hide('visitorsdiv');hide('chattersdiv');show(event, 'info-" . $chatters['username'] . "'); } catch(dam){} return true;\" onMouseOut=\"try { showit('chattersdiv');showit('visitorsdiv');hide('info-" . $chatters['username'] . "');} catch(dam){} return true;\">" . $chatters['username'] . "</a> {$actionlinkouter} </td></tr>\n";
}
} else {
if (!($intheuserdepartment == 0 && preg_match("/noton/", $chatting))) {
$operatorlasthtml .= "<tr bgcolor=#EFEFEF><td> </td><td>{$checkbox}</td><td nowrap=nowrap>{$chatting}</td><td width=90% align=left><a href=javascript:seepages(" . $chatters['user_id'] . ") onMouseOver=\"try { hide('visitorsdiv');hide('chattersdiv');show(event, 'info-" . $chatters['username'] . "'); } catch(dam){} return true;\" onMouseOut=\"try { showit('chattersdiv');showit('visitorsdiv');hide('info-" . $chatters['username'] . "'); } catch(dam){} return true;\">" . $chatters['username'] . "</a> {$actionlink} </td></tr>\n";
}
}
}
$sqlquery = "SELECT * from livehelp_users WHERE sessionid='" . $chatters['sessionid'] . "'";
$user_info = $mydatabase->query($sqlquery);
$user_info = $user_info->fetchRow(DB_FETCHMODE_ASSOC);
$sqlquery = "SELECT * from livehelp_visit_track WHERE sessionid='" . $chatters['sessionid'] . "' Order by whendone DESC LIMIT 1";
$page_trail = $mydatabase->query($sqlquery);
$page = $page_trail->fetchRow(DB_FETCHMODE_ASSOC);
$sqlquery = "SELECT * from livehelp_departments WHERE recno='" . $chatters['department'] . "'";
$tmp = $mydatabase->query($sqlquery);
$nameof = $tmp->fetchRow(DB_FETCHMODE_ASSOC);
$nameof = $nameof['nameof'];
$DIVS .= "<DIV ID=\"info-" . $chatters['username'] . "\" STYLE=\"position: absolute; z-index: 20; visibility: hidden; top: 0px; left: 0px;\">\n<TABLE BORDER=\"0\" WIDTH=\"250\"><TR BGCOLOR=\"#000000\"><TD> \n<TABLE BORDER=\"0\" WIDTH=\"248\" CELLPADDING=0 CELLSPACING=0 BORDER=0><TR><TD width=1 BGCOLOR=#" . $color_alt2 . "><img src=images/blank.gif width=7 height=120></TD><TD BGCOLOR=\"#" . $color_alt2 . "\" valign=top>\n<FONT COLOR=\"#000000\">\n<b>" . $lang['referer'] . ":</b><br>" . $user_info['camefrom'] . "<br>\n<b>" . $lang['txt43'] . ":</b><br>{$nameof}<br>\n<b>Url:</b><br><a href=" . $page['location'] . " target=_blank>" . $page['location'] . "</a><br>";
$now = date("YmdHis");
if ($user_info['lastaction'] == "" || $user_info['lastaction'] < 20002020202020) {
$user_info['lastaction'] = $now;
}
$thediff = $now - $user_info['lastaction'];
$DIVS .= "<b>" . $lang['txt65'] . ":</b><br>{$thediff} " . $lang['Seconds'] . "<br>\n </FONT></TD></TR></TABLE></TD></TR></TABLE></DIV>";
}
if (preg_match("/active/", $operatorhtml)) {
$html .= $htmlgray;
$lasthtml .= $lasthtmlgray;
}
$html .= $operatorhtml;
$lasthtml .= $operatorlasthtml;
}
}
$html = str_replace("[OPonlinenow]", $OPonlinenow, $html);
$html = str_replace("[OPhiddennow]", $OPhiddennow, $html);
$html .= $lasthtml . "</table>";
$html .= "<DIV ID=\"chattersdiv\" STYLE=\"z-index: 2;\">";
if ($UNTRUSTED['hidechatters'] != 1 && $chatboxes > 0) {
$html .= "<table cellpadding=0 cellspacing=0 border=0>";
$html .= "<tr><td><img src=images/blank.gif width=18 height=22 border=0></td><td align=left><img src=images/arrow_ltr.gif width=38 height=22><select name=whattodochat onchange=updatepeople(1)>";
$html .= "<option value=\"\">" . $lang['txt207'] . ":</option>";
$html .= "<option value=stop>" . $lang['stop_chat'] . "</option>";
$html .= "<option value=transfer>" . $lang['transfer_chat'] . "</option>";
$html .= "<option value=conference>" . $lang['conference_chats'] . "</option>";
$html .= "</select> <a href=javascript:updatepeople(1)><img src=images/go.gif border=0 width=20 height=20></a></td></tr>";
$html .= "</table>";
}
$html .= "</DIV>";
///--------------------------------------------------------------------------------------------------
// get the count of active visitors in the system right now.
$timeof = rightnowtime();
$prev = mktime(date("H"), date("i") - 4, date("s"), date("m"), date("d"), date("Y"));
$oldtime = date("YmdHis", $prev);
$sqlquery = "SELECT * FROM livehelp_users WHERE lastaction>'{$oldtime}' AND status!='chat' AND isoperator!='Y' ";
// make list of ignored visitors:
$ipadd = explode(",", $CSLH_Config['ignoreips']);
for ($i = 0; $i < count($ipadd); $i++) {
if (!empty($ipadd[$i])) {
$sqlquery .= " AND ipaddress NOT LIKE '" . $ipadd[$i] . "%' ";
}
}
$sqlquery .= " ORDER by lastaction DESC";
$visitors = $mydatabase->query($sqlquery);
$onlinenow = $visitors->numrows();
$hiddennow = 0;
$html .= "<SCRIPT type=\"text/javascript\">\n \n function stopajax(){\n //document.admin_actions.togglerefresh.SelectedIndex=2;\n // alert(1);\n //document.admin_actions.submit();\n }\n </SCRIPT>";
$html .= "<table width=100% cellpadding=0 cellspacing=0 bgcolor=" . $color_alt2 . "><tr><td>";
if ($UNTRUSTED['showvisitors'] != 3) {
if ($UNTRUSTED['showvisitors'] == 1) {
$html .= "<a href=admin_users_refresh.php?hidechatters=" . $hidechatters . "&ignorelist={$ignorelist}&numchats={$numchatsnow}&autoanswer=" . $UNTRUSTED['autoanswer'] . "&operators=" . $UNTRUSTED['operators'] . "&showvisitors=2 onclick=\"javascript:shouldireloadbot();\" ><img src=images/minus.gif border=0></a>";
} else {
if ($CSLH_Config['admin_refresh'] == "auto") {
$html .= "<a href=admin_users_refresh.php?hidechatters=" . $hidechatters . "&ignorelist={$ignorelist}&numchats={$numchatsnow}&autoanswer=" . $UNTRUSTED['autoanswer'] . "&operators=" . $UNTRUSTED['operators'] . "&showvisitors=3&togglerefresh=AJAX onclick=\"javascript:shouldireloadbot();\" ><img src=images/plus.gif border=0></a>AJAX ";
$html .= "<a href=admin_users_refresh.php?hidechatters=" . $hidechatters . "&ignorelist={$ignorelist}&numchats={$numchatsnow}&autoanswer=" . $UNTRUSTED['autoanswer'] . "&operators=" . $UNTRUSTED['operators'] . "&showvisitors=1 onclick=\"javascript:shouldireloadbot();\" ><img src=images/plus.gif border=0></a>AUTO";
} else {
$html .= "<a href=admin_users_refresh.php?hidechatters=" . $hidechatters . "&ignorelist={$ignorelist}&numchats={$numchatsnow}&autoanswer=" . $UNTRUSTED['autoanswer'] . "&operators=" . $UNTRUSTED['operators'] . "&showvisitors=1 onclick=\"javascript:shouldireloadbot();\" ><img src=images/plus.gif border=0></a>";
}
}
} else {
$html .= "<a href=admin_users_refresh.php?hidechatters=" . $hidechatters . "&ignorelist={$ignorelist}&numchats={$numchatsnow}&autoanswer=" . $UNTRUSTED['autoanswer'] . "&operators=" . $UNTRUSTED['operators'] . "&showvisitors=2&togglerefresh=auto onclick=\"javascript:shouldireloadbot();\" ><img src=images/minus.gif border=0></a>";
}
if ($UNTRUSTED['showvisitors'] == 1) {
$html .= "</td><td><b>" . $lang['visit'] . "</b></td></tr></table>";
$html .= "<table width=100%><tr><td align=right><b><font color=007700>[onlinenow] " . $lang['online'] . "</font> <font color=777777>[hiddennow] " . $lang['Hidden'] . "</font></b></td></tr></table>";
$html .= "<table width=100%><tr bgcolor={$color_background}><td> </td><td><b>ID</b></td><td><b>" . $lang['status'] . ":</b></td><td><b>pg#</b></td>";
if ($CSLH_Config['maxrequests'] < 9999) {
$html .= "<td>rq#</td>";
}
$html .= "</tr>";
$insitewav = "";
while ($visitor = $visitors->fetchRow(DB_FETCHMODE_ASSOC)) {
$chatting = "";
// see if we are in the same department as this user..
$sqlquery = "SELECT * FROM livehelp_operator_departments WHERE user_id='{$myid}' AND department='" . $visitor['department'] . "' ";
$data_check = $mydatabase->query($sqlquery);
if ($visitor['department'] != 0 && $data_check->numrows() == 0) {
$hiddennow++;
$onlinenow--;
} else {
if (empty($visitor['user_alert'])) {
$visitor['user_alert'] = 0;
}
if ($visitor['isoperator'] != "Y" && $visitor['user_alert'] != 1) {
$onload = " setTimeout(\"doorbell();\",700); ";
if ($user_alert == "N" || $user_alert == "") {
if ($show_arrival != "N") {
$insitewav = " <EMBED SRC=sounds/" . $alertinsite . " AUTOSTART=TRUE width=1 height=1 LOOP=FALSE> \n";
}
}
$sql = "UPDATE livehelp_users SET user_alert='1' WHERE user_id='" . $visitor['user_id'] . "' ";
$mydatabase->query($sql);
}
$sqlquery = "SELECT * from livehelp_visit_track WHERE sessionid='" . $visitor['sessionid'] . "'";
$my_count = $mydatabase->query($sqlquery);
$my_count = $my_count->numrows();
$html .= "<tr><td width=10><input type=checkbox name=session__" . $visitor['user_id'] . " value=" . $visitor['sessionid'] . " border=0></td><td>";
$html .= "<a href=javascript:seepages(" . $visitor['user_id'] . ") onMouseOver=\" try { hide('visitorsdiv');hide('chattersdiv');show(event, 'info-" . $visitor['username'] . "'); } catch(dam){} return true;\" onMouseOut=\"try { showit('chattersdiv');showit('visitorsdiv');hide('info-" . $visitor['username'] . "'); } catch(dam){} return true;\">" . $visitor['username'] . "</a>";
$sqlquery = "SELECT * from livehelp_users WHERE user_id='" . $visitor['user_id'] . "'";
$user_info = $mydatabase->query($sqlquery);
$user_info = $user_info->fetchRow(DB_FETCHMODE_ASSOC);
$sqlquery = "SELECT * from livehelp_visit_track WHERE sessionid='" . $visitor['sessionid'] . "' Order by whendone DESC";
$page_trail = $mydatabase->query($sqlquery);
$page = $page_trail->fetchRow(DB_FETCHMODE_ASSOC);
$sqlquery = "SELECT * from livehelp_departments WHERE recno='" . $visitor['department'] . "'";
$tmp = $mydatabase->query($sqlquery);
$nameof = $tmp->fetchRow(DB_FETCHMODE_ASSOC);
$nameof = $nameof['nameof'];
$query = "SELECT whendone from livehelp_visit_track WHERE sessionid='" . filter_sql($visitor['sessionid']) . "' Order by whendone LIMIT 1";
$page_tmprow = $mydatabase->query($query);
$tmprow = $page_tmprow->fetchRow(DB_FETCHMODE_ASSOC);
$later = $tmprow['whendone'];
$DIVS .= "<DIV ID=\"info-" . $visitor['username'] . "\" STYLE=\"position: absolute; z-index: 20; visibility: hidden; top: 0px; left: 0px;\">\n<TABLE BORDER=\"0\" WIDTH=\"300\"><TR BGCOLOR=\"#000000\"><TD> \n<TABLE BORDER=\"0\" WIDTH=\"100%\" CELLPADDING=0 CELLSPACING=0 BORDER=0><TR><TD width=1 BGCOLOR=#" . $color_alt2 . "><img src=images/blank.gif width=7 height=120></TD><TD BGCOLOR=\"#" . $color_alt2 . "\" valign=top>\n<FONT COLOR=\"#000000\">\n<b>Referer:</b><br>" . $user_info['camefrom'] . "<br>";
if (empty($page['location'])) {
$page['location'] = "";
}
$DIVS .= "<b>" . $lang['timeonline'] . ":</b>" . secondstoHHmmss(timediff($later, date("YmdHis"))) . "<br> \n<b>" . $lang['txt43'] . ":</b><br>{$nameof}<br>\n<b>url:</b><br>" . $page['location'] . "<br>";
$now = date("YmdHis");
$thediff = $now - $user_info['lastaction'];
$DIVS .= "<b>" . $lang['lastact'] . ":</b><br>{$thediff} " . $lang['Seconds'] . "<br>\n </FONT></TD></TR></TABLE></TD></TR></TABLE></DIV>";
$html .= "</td>";
switch ($visitor['status']) {
case "DHTML":
$html .= "<td>L:<img src=images/invited.gif> ";
break;
case "request":
$html .= "<td>P:<img src=images/invited.gif> ";
break;
case "invited":
$html .= "<td><img src=images/invited2.gif> ";
break;
case "qna":
$html .= "<td><img src=images/qna.gif>";
break;
case "stopped":
$html .= "<td><img src=images/stopped.gif> {<a href=layer.php?selectedwho=" . $visitor['user_id'] . " target=_blank>RE-" . $lang['invite'] . "</a>}";
break;
case "message":
$html .= "<td><img src=images/message.gif> ";
break;
default:
$html .= "<td><a href=layer.php?selectedwho=" . $visitor['user_id'] . " target=_blank>" . $lang['invite'] . "</a> ";
break;
}
$html .= "</td>";
$html .= "<td>{$my_count}</td>";
if ($CSLH_Config['maxrequests'] < 9999) {
if ($user_info['visits'] > $CSLH_Config['maxrequests'] - 16) {
if ($user_info['visits'] < $CSLH_Config['maxrequests']) {
$html .= "<td><font color=#770000>" . $user_info['visits'] . "</font><br><a href=javascript:resetpages(" . $visitor['user_id'] . ")>reset</a></td>";
} else {
$html .= "<td><font color=#CC0000><b>" . $user_info['visits'] . "</b></font><br><a href=javascript:resetpages(" . $visitor['user_id'] . ")>reset</a></td>";
}
} else {
$html .= "<td>" . $user_info['visits'] . "</td>";
}
}
$html .= "</tr>";
}
}
$html = str_replace("[onlinenow]", $onlinenow, $html);
$html = str_replace("[hiddennow]", $hiddennow, $html);
$html .= "</table>";
$html .= "<DIV ID=\"visitorsdiv\" STYLE=\"z-index: 2;\">";
if ($onlinenow > 0) {
$html .= "<table>";
$html .= "<tr><td><img src=images/arrow_ltr.gif width=38 height=22><select name=whattodo onchange=updatepeople(2)>";
$html .= "<option value=\"\">" . $lang['txt207'] . ":</option>";
$html .= "<option value=DHTML>" . $lang['Invite'] . ":" . $lang['layer'] . "</option>";
$html .= "<option value=pop>" . $lang['Invite'] . ":" . $lang['popup'] . "</option>";
$html .= "<option value=insite>" . $lang['Invite'] . ":" . insite . "</option>";
$html .= "</select> <a href=javascript:updatepeople(2)><img src=images/go.gif border=0 width=20 height=20></a></td></tr>";
$html .= "</table><center><a href=admin_users_refresh.php?hidechatters=" . $hidechatters . "&ignorelist={$ignorelist}&numchats={$numchatsnow}&autoanswer=" . $UNTRUSTED['autoanswer'] . "&operators=" . $UNTRUSTED['operators'] . "&showvisitors=2>" . $lang['txt208'] . "</a><br></center>";
}
$html .= "</DIV>";
} else {
while ($visitor = $visitors->fetchRow(DB_FETCHMODE_ASSOC)) {
$chatting = "";
// see if we are in the same department as this user..
$sqlquery = "SELECT * FROM livehelp_operator_departments WHERE user_id='{$myid}' AND department='" . $visitor['department'] . "' ";
$data_check = $mydatabase->query($sqlquery);
if ($visitor['department'] != 0 && $data_check->numrows() == 0) {
$hiddennow++;
$onlinenow--;
}
}
if ($UNTRUSTED['showvisitors'] == 2) {
$html .= "</td><td><b>" . $lang['visit'];
if ($CSLH_Config['admin_refresh'] == "auto") {
$html .= "<br>";
}
$html .= " <font color=007700>{$onlinenow} " . $lang['online'] . "</font> <font color=777777>{$hiddennow} " . $lang['Hidden'] . "</font> </b></td></tr></table>";
if ($CSLH_Config['admin_refresh'] == "auto") {
$html .= "<table width=100%><tr bgcolor={$color_background}><td colspan=4 align=center><font color=#990000><i>" . $lang['Hidden'] . "</i></a></font><br>To monitor visitors click either:";
$html .= " { <a href=admin_users_refresh.php?hidechatters=" . $hidechatters . "&ignorelist={$ignorelist}&numchats={$numchatsnow}&autoanswer=" . $UNTRUSTED['autoanswer'] . "&operators=" . $UNTRUSTED['operators'] . "&showvisitors=3&togglerefresh=AJAX onclick=\"javascript:shouldireloadbot();\"> AJAX </a> | ";
$html .= "<a href=admin_users_refresh.php?hidechatters=" . $hidechatters . "&ignorelist={$ignorelist}&numchats={$numchatsnow}&autoanswer=" . $UNTRUSTED['autoanswer'] . "&operators=" . $UNTRUSTED['operators'] . "&showvisitors=1 onclick=\"javascript:shouldireloadbot();\"> AUTO</a> }";
} else {
$html .= "<table width=100%><tr bgcolor={$color_background}><td colspan=4 align=center><font color=#990000><i>" . $lang['Hidden'] . "</i></a></font><br><a href=admin_users_refresh.php?hidechatters=" . $hidechatters . "&ignorelist={$ignorelist}&numchats={$numchatsnow}&autoanswer=" . $UNTRUSTED['autoanswer'] . "&operators=" . $UNTRUSTED['operators'] . "&showvisitors=1 onclick=\"javascript:shouldireloadbot();\">" . $lang['txt209'] . "</a>";
}
$html .= "</td></tr></table>";
} else {
$html .= "</td><td><b>" . $lang['visit'] . "</b></td></tr></table>";
$html .= "<DIV id=\"visitorschatdiv\"> ...... Loading ..... </DIV>";
}
}
$html = $html . $DIVS;
return $html;
}
?>
</b></td></tr>
<?php
$query = "SELECT * FROM livehelp_transcripts WHERE endtime>{$whatYm_b} AND endtime<{$whatYm_e} {$whichdepartmentsql} {$keywordssql} order by endtime DESC LIMIT " . intval($UNTRUSTED['offset']) . "," . intval($perpage);
$data = $mydatabase->query($query);
$bgcolor = "{$color_alt2}";
while ($row = $data->fetchRow(DB_FETCHMODE_ASSOC)) {
if ($bgcolor == "{$color_alt2}") {
$bgcolor = "{$color_alt1}";
} else {
$bgcolor = "{$color_alt2}";
}
print "<tr bgcolor={$bgcolor}><td>";
print substr($row['endtime'], 4, 2) . "-" . substr($row['endtime'], 6, 2) . "-" . substr($row['endtime'], 0, 4) . " (" . substr($row['endtime'], 8, 2) . ":" . substr($row['endtime'], 10, 2) . ":" . substr($row['endtime'], 12, 2) . ")";
print "</td>";
$sqlquery = "SELECT * from livehelp_departments WHERE recno='" . $row['department'] . "'";
$tmp = $mydatabase->query($sqlquery);
$nameof = $tmp->fetchRow(DB_FETCHMODE_ASSOC);
$nameof = $nameof['nameof'];
print "<td>{$nameof}</td>";
print "<td>" . listoperators($row['operators']) . "</td>";
print "<td>" . $row['who'] . "</td>";
print "<td NOWRAP=NOWRAP>" . secondstoHHmmss($row['duration']) . "</td>";
print "<td><a href=mailto:\"" . $row['email'] . "\">" . $row['email'] . "</td><td> <a href=view_transcript.php?view=" . $row['recno'] . " target=_blank>VIEW</a> ";
if ($isadminsetting == "Y") {
print " <a href=data.php?tab=" . $UNTRUSTED['tab'] . "&top=" . $UNTRUSTED['top'] . "&remove=" . $row['recno'] . " onClick=\"return confirm('" . $lang['areyousure'] . "')\"><font color=990000>" . $lang['REMOVE'] . "</font></a> ";
}
print "</td></tr>";
}
?>
</table>
print "<td><a href=data.php?tab=" . $UNTRUSTED['tab'] . "&month=" . $UNTRUSTED['month'] . "&year=" . $UNTRUSTED['year'] . "&typeofview=" . $UNTRUSTED['typeofview'] . "&show=" . $UNTRUSTED['show'] . "&expand={$contract}&offset=" . $UNTRUSTED['offset'] . "><img src=images/minus.gif border=0></a></td>";
} else {
print "<td><a href=data.php?tab=" . $UNTRUSTED['tab'] . "&month=" . $UNTRUSTED['month'] . "&year=" . $UNTRUSTED['year'] . "&typeofview=" . $UNTRUSTED['typeofview'] . "&show=" . $UNTRUSTED['show'] . "&expand=" . $UNTRUSTED['expand'] . "," . $id . "&offset=" . $UNTRUSTED['offset'] . "><img src=images/plus.gif border=0></a></td>";
}
print "<td>" . substr($dateof, 4, 2) . "-" . substr($dateof, 0, 4) . "</td><td>" . $username . "</a></td><td>" . $ipaddress . "</td><td>" . $uservisits . "</td><td>" . secondstoHHmmss($seconds) . "</td>";
print "</tr>";
// look for daily records:
if (in_array($id, $expand_array)) {
if ($UNTRUSTED['typeofview'] == "groupusername") {
$query = "SELECT * FROM livehelp_identity_daily WHERE username='******' AND dateof>" . intval($whatYm) . "00 AND dateof<" . intval($whatYm) . "32 ORDER by dateof DESC";
} else {
$query = "SELECT * FROM livehelp_identity_daily WHERE identity='" . $identity . "' AND username='******' AND dateof>" . intval($whatYm) . "00 AND dateof<" . intval($whatYm) . "32 ORDER by dateof DESC";
}
$inner_sth = $mydatabase->query($query);
while ($innerrow = $inner_sth->fetchRow(DB_FETCHMODE_ASSOC)) {
if ($bgcolor == "F7FAFF") {
$bgcolor = "F0F1E1";
} else {
$bgcolor = "F7FAFF";
}
print "<tr bgcolor=" . $bgcolor . "><td> </td><td>" . substr($innerrow['dateof'], 4, 2) . "-" . substr($innerrow['dateof'], 6, 2) . "-" . substr($innerrow['dateof'], 0, 4) . "</td><td>" . $innerrow['username'] . "</a></td><td>" . $innerrow['ipaddress'] . "</td><td>" . $innerrow['uservisits'] . "</td><td>" . secondstoHHmmss($innerrow['seconds']) . "</td></tr>";
}
}
}
print "</table>";
?>
<table width=600><tr><td><?php
echo $lang['txt216'];
?>
</td></tr></table>
function gethtml()
{
global $alertchat, $insitewav, $soundwav, $hidechatters, $color_alt2, $color_alt4, $color_background, $numchatsnow, $UNTRUSTED, $CSLH_Config, $operators, $operators_array, $ignorelist_array, $ignorelist, $lang, $show_arrival, $mydatabase, $identity, $onload, $myid, $stuffatbottom, $user_alert;
$onload = "";
$DIVS = " ";
$lasthtml = "";
$timeof = rightnowtime();
// update operators timestamp .
$sql = "UPDATE livehelp_users set lastaction='{$timeof}' WHERE sessionid='" . $identity['SESSIONID'] . "' ";
$mydatabase->query($sql);
/// Current Chat Requests: -----------------------------------------------------------
$html = "<table width=100% bgcolor=" . $color_alt2 . "><tr>";
$html .= "<td width=20> </td>";
$html .= "<td><b>" . $lang['txt230'] . "</b></td></tr></table>";
$prev = mktime(date("H"), date("i") - 10, date("s"), date("m"), date("d"), date("Y"));
$oldtime = date("YmdHis", $prev);
$sqlquery = "SELECT * FROM livehelp_users WHERE status='chat' AND isoperator='N' ORDER by showedup";
$chatcheck = $mydatabase->query($sqlquery);
$numchatnow = $chatcheck->numrows();
$html .= "<table width=100%>";
$chatrequests = 0;
while ($visitor = $chatcheck->fetchRow(DB_FETCHMODE_ASSOC)) {
$actionlink = "";
$chatting = "";
// see if we are in the same department as this user..
$sqlquery = "SELECT * FROM livehelp_operator_departments WHERE user_id='{$myid}' AND department='" . $visitor['department'] . "' ";
$data_check = $mydatabase->query($sqlquery);
if ($data_check->numrows() == 0) {
// we are not in the department that this user is chatting in..
} else {
// see if anyone is chatting with this person.
$sqlquery = "SELECT * FROM livehelp_operator_channels WHERE channel='" . $visitor['onchannel'] . "'";
$counting = $mydatabase->query($sqlquery);
$showedup = substr($visitor['showedup'], 8, 2) . ":" . substr($visitor['showedup'], 10, 2);
if ($counting->numrows() == 0) {
$updated_ignore = $ignorelist . "," . $visitor['user_id'];
$chatting = "<img src=images/needaction.gif width=21 height=20 border=0>";
$actionlink = "[<a href=admin_users_refresh.php?hidechatters=" . $hidechatters . "&ignorelist={$ignorelist}&numchats={$numchatsnow}&operators={$operators}&action=activiate&who=" . $visitor['user_id'] . "&whatchannel=" . $visitor['onchannel'] . "&showvisitors=" . $UNTRUSTED['showvisitors'] . "&needaction=1>" . $lang['Activate'] . "</a>]\n";
if (!in_array($visitor['user_id'], $ignorelist_array)) {
$actionlink .= "[<a href=admin_users_refresh.php?hidechatters=" . $hidechatters . "&ignorelist={$updated_ignore}&numchats={$numchatsnow}&operators={$operators}&showvisitors=" . $UNTRUSTED['showvisitors'] . ">" . $lang['Ignore'] . "</a>]\n";
$onload = " setTimeout(\"tellme(0);\",500); ";
$chatrequests++;
if ($user_alert == "N" || $user_alert == "") {
$soundwav = "<SCRIPT type=\"text/javascript\">\n";
$soundwav .= "var MSIE=navigator.userAgent.indexOf(\"MSIE\");\n";
$soundwav .= "var NETS=navigator.userAgent.indexOf(\"Netscape\");\n";
$soundwav .= "var OPER=navigator.userAgent.indexOf(\"Opera\");\n";
$soundwav .= "if((MSIE>-1) || (OPER>-1)) {\n";
$soundwav .= "document.write(\"<BGSOUND SRC=sounds/{$alertchat} LOOP=1>\");\n";
$soundwav .= "} else {\n";
$soundwav .= "document.write(\"<EMBED SRC=sounds/{$alertchat} AUTOSTART=TRUE HIDDEN=true VOLUME=100 LOOP=FALSE><noembed><BGSOUND SRC={$alertchat} LOOP=1></noembed>\");\n";
$soundwav .= "}\n";
$soundwav .= "</SCRIPT>\n";
$stuffatbottom .= "\n<SCRIPT type=\"text/javascript\">top.status=\"[activate]\";top.status=\"\"; setTimeout(\"tellme(0);\",1500); </SCRIPT>\n";
}
}
if (!in_array($visitor['user_id'], $ignorelist_array)) {
$html .= "<tr><td width=10> {$showedup} </td><td nowrap=nowrap><table><tr><td>{$chatting}</td><td><a href=javascript:seepages(" . $visitor['user_id'] . ") onMouseOver=\"try { hide('visitorsdiv');hide('chattersdiv');show(event, 'info-" . $visitor['username'] . "'); } catch(dam){} return true;\" onMouseOut=\"try { showit('chattersdiv');showit('visitorsdiv');hide('info-" . $visitor['username'] . "'); } catch(dam){} return true;\">" . $visitor['username'] . "</a> {$actionlink} </td></tr></table></td></tr>\n";
} else {
$html .= "<tr bgcolor=#DDDDDD><td width=10> {$showedup} </td><td nowrap=nowrap><table><tr><td>{$chatting}</td><td><a href=javascript:seepages(" . $visitor['user_id'] . ") onMouseOver=\"try { hide('visitorsdiv');hide('chattersdiv');show(event, 'info-" . $visitor['username'] . "');} catch(dam){} return true;\" onMouseOut=\"try { showit('chattersdiv');showit('visitorsdiv');hide('info-" . $visitor['username'] . "'); } catch(dam){} return true;\">" . $visitor['username'] . "</a> {$actionlink} </td></tr></table></td></tr>\n";
}
$chatrequests++;
$sqlquery = "SELECT * from livehelp_users WHERE sessionid='" . $visitor['sessionid'] . "'";
$user_info = $mydatabase->query($sqlquery);
$user_info = $user_info->fetchRow(DB_FETCHMODE_ASSOC);
$sqlquery = "SELECT * from livehelp_visit_track WHERE sessionid='" . $visitor['sessionid'] . "' Order by whendone DESC LIMIT 1";
$page_trail = $mydatabase->query($sqlquery);
$page = $page_trail->fetchRow(DB_FETCHMODE_ASSOC);
$sqlquery = "SELECT * from livehelp_departments WHERE recno='" . $visitor['department'] . "'";
$tmp = $mydatabase->query($sqlquery);
$nameof = $tmp->fetchRow(DB_FETCHMODE_ASSOC);
$nameof = $nameof['nameof'];
$DIVS .= "<DIV ID=\"info-" . $visitor['username'] . "\" STYLE=\"position: absolute; z-index: 20; visibility: hidden; top: 0px; left: 0px;\">\n <TABLE BORDER=\"0\" WIDTH=\"250\"><TR BGCOLOR=\"#000000\"><TD> \n <TABLE BORDER=\"0\" WIDTH=\"248\" CELLPADDING=0 CELLSPACING=0 BORDER=0><TR><TD width=1 BGCOLOR=#" . $color_alt2 . "><img src=images/blank.gif width=7 height=120></TD><TD BGCOLOR=\"#" . $color_alt2 . "\" valign=top>\n <FONT COLOR=\"#000000\">\n <b>" . $lang['referer'] . ":</b><br>" . $user_info['camefrom'] . "<br>\n <b>" . $lang['txt43'] . ":</b><br>{$nameof}<br>\n <b>Url:</b><br><a href=" . $page['location'] . " target=_blank>" . $page['location'] . "</a><br>";
$now = date("YmdHis");
if ($user_info['lastaction'] == "" || $user_info['lastaction'] < 20002020202020) {
$user_info['lastaction'] = $now;
}
$thediff = $now - $user_info['lastaction'];
$DIVS .= "<b>" . $lang['txt65'] . ":</b><br>{$thediff} Seconds ago<br> \n </FONT></TD></TR></TABLE></TD></TR></TABLE></DIV>";
}
}
}
if ($chatrequests == 0) {
$html .= "<tr><td>" . $lang['txt231'] . "</td></tr>";
}
$html .= "</table>";
//------------------------------------------------------------------------
$html .= "<table width=100% bgcolor=" . $color_alt2 . "><tr>";
$sqlquery = "SELECT * FROM livehelp_users WHERE status='chat' AND isoperator='N'";
$chatcheck = $mydatabase->query($sqlquery);
$numchatnow = $chatcheck->numrows();
while ($visitor = $chatcheck->fetchRow(DB_FETCHMODE_ASSOC)) {
$sqlquery = "SELECT * FROM livehelp_operator_channels WHERE channel='" . $visitor['onchannel'] . "'";
$counting = $mydatabase->query($sqlquery);
if ($counting->numrows() == 0 && !in_array($visitor['user_id'], $ignorelist_array)) {
$UNTRUSTED['hidechatters'] = 0;
}
}
if ($UNTRUSTED['hidechatters'] == 1) {
$html .= "<td width=20><a href=admin_users_refresh.php?hidechatters=0&ignorelist={$ignorelist}&numchats={$numchatsnow}&operators=" . $UNTRUSTED['operators'] . "&hidechatters=0><img src=images/plus.gif border=0></a></td>";
} else {
$html .= "<td width=20><a href=admin_users_refresh.php?hidechatters=1&ignorelist={$ignorelist}&numchats={$numchatsnow}&operators=" . $UNTRUSTED['operators'] . "&hidechatters=1><img src=images/minus.gif border=0></a></td>";
}
$html .= "<td><b> " . $lang['chat_text'] . " </b></td></tr></table>";
$prev = mktime(date("H"), date("i") - 4, date("s"), date("m"), date("d"), date("Y"));
$oldtime = date("YmdHis", $prev);
// select out all of the operators that are online chatting:
$sqlquery = "SELECT * FROM livehelp_users WHERE status='chat' ORDER by showedup";
$chatcheck = $mydatabase->query($sqlquery);
$numchatnow = $chatcheck->numrows();
$chatboxes = 0;
$html .= "<table width=100% cellpadding=0 cellspacing=0 border=0>";
if ($UNTRUSTED['hidechatters'] != 1) {
if ($chatcheck->numrows() == 0) {
$html .= "<tr><td>" . $lang['no_chat'] . "</td></tr>";
}
$sqlquery = "SELECT * FROM livehelp_users WHERE isonline='Y' and isoperator='Y' ORDER by username";
$chatcheck = $mydatabase->query($sqlquery);
while ($operatorsarray = $chatcheck->fetchRow(DB_FETCHMODE_ASSOC)) {
$actionlink = "";
$chatting = "";
// Operators can be on multiple channels so see if one of the channels they are on is one we are on.
$foundcommonchannel = 0;
$sqlquery = "SELECT * FROM livehelp_operator_channels WHERE user_id='" . $operatorsarray['user_id'] . "'";
$mychannels = $mydatabase->query($sqlquery);
while ($rowof = $mychannels->fetchRow(DB_FETCHMODE_ASSOC)) {
$sqlquery = "SELECT * FROM livehelp_operator_channels WHERE user_id='{$myid}' And channel='" . $rowof['channel'] . "'";
$counting = $mydatabase->query($sqlquery);
if ($counting->numrows() != 0) {
$foundcommonchannel = $rowof['channel'];
}
}
if ($foundcommonchannel == 0) {
$chatting = "<img src=images/noton.gif width=19 height=18 border=0>";
if ($myid != $operatorsarray['user_id']) {
$actionlink = "[<a href=admin_users_refresh.php?hidechatters=" . $hidechatters . "&ignorelist={$ignorelist}&numchats={$numchatsnow}&operators={$operators}&action=activiate&who=" . $operatorsarray['user_id'] . "&whatchannel=" . $operatorsarray['onchannel'] . "&conferencein=yes&showvisitors=" . $UNTRUSTED['showvisitors'] . "><font color=007700>" . $lang['begin'] . "</font></a>]\n";
} else {
$actionlink = "";
$chatting = "<img src=images/active.gif width=19 height=18 border=0>\n";
}
} else {
$chatting = "<table cellpadding=0 cellspacing=0 border=0 bgcolor=" . $rowof['txtcolor_alt'] . "><tr><td><img src=images/active.gif width=19 height=18 border=0></td></tr></table>\n";
if ($operatorsarray['user_id'] != $myid) {
$actionlink = "[<a href=admin_users_refresh.php?hidechatters=" . $hidechatters . "&ignorelist={$ignorelist}&numchats={$numchatsnow}&operators={$operators}&action=leave&who=" . $operatorsarray['user_id'] . "&whatchannel={$foundcommonchannel}&clearchannel=N&showvisitors=" . $UNTRUSTED['showvisitors'] . ">" . $lang['stop_chat'] . "</a>]\n";
}
}
if ($myid != $operatorsarray['user_id']) {
$html .= "<tr><td width=21><img src=images/operator.gif width=21 height=20 border=0></td><td colspan=3><table><tr><td>{$chatting}</td><td width=90% align=left> <b>" . $operatorsarray['username'] . "</b> {$actionlink} </td></tr></table></td></tr>\n";
} else {
$lasthtml = "<tr><td width=21><img src=images/operator.gif width=21 height=20 border=0></td><td colspan=3><table><tr><td>{$chatting}</td><td width=90% align=left> <b>" . $operatorsarray['username'] . "</b> {$actionlink} </td></tr></table></td></tr>\n";
}
// show all the operators chats:
$q = "SELECT livehelp_users.* FROM livehelp_users,livehelp_operator_channels WHERE livehelp_users.user_id=livehelp_operator_channels.userid AND livehelp_users.status='chat' AND livehelp_operator_channels.user_id=" . $operatorsarray['user_id'] . " ORDER by showedup";
$sth = $mydatabase->query($q);
while ($chatters = $sth->fetchRow(DB_FETCHMODE_ASSOC)) {
// see if we are in the same department as this user..
$sqlquery = "SELECT * FROM livehelp_operator_departments WHERE user_id='{$myid}' AND department='" . $chatters['department'] . "' ";
$data_check = $mydatabase->query($sqlquery);
if ($data_check->numrows() == 0) {
// we are not in the department that this user is chatting in..
} else {
// see if we are chatting with them
$sqlquery = "SELECT * FROM livehelp_operator_channels WHERE user_id='{$myid}' And channel='" . $chatters['onchannel'] . "'";
$counting = $mydatabase->query($sqlquery);
$checkbox = "";
$actionlinkouter = "";
if ($counting->numrows() == 0) {
$chatting = "<img src=images/noton.gif width=19 height=18 border=0>";
$actionlink = "[<a href=admin_users_refresh.php?hidechatters=" . $hidechatters . "&ignorelist={$ignorelist}&numchats={$numchatsnow}&operators={$operators}&action=activiate&who=" . $chatters['user_id'] . "&whatchannel=" . $chatters['onchannel'] . "&showvisitors=" . $UNTRUSTED['showvisitors'] . "&conferencein=yes><font color=007700>Join Chat</font></a>]\n";
$actionlinkouter = $actionlink;
} else {
$chatboxes++;
$rowof = $counting->fetchRow(DB_FETCHMODE_ASSOC);
$chatting = "<table cellpadding=0 cellspacing=0 border=0 bgcolor=" . $rowof['channelcolor'] . "><tr><td><img src=images/active.gif width=19 height=18 border=0></td></tr></table>\n";
$actionlink = "";
$sqlquery = "SELECT * FROM livehelp_operator_channels WHERE channel='" . $chatters['onchannel'] . "'";
$counting = $mydatabase->query($sqlquery);
if ($counting->numrows() > 1) {
$actionlink = "[<a href=admin_users_refresh.php?hidechatters=" . $hidechatters . "&ignorelist={$ignorelist}&numchats={$numchatsnow}&operators={$operators}&action=leave&who=" . $chatters['user_id'] . "&whatchannel=" . $chatters['onchannel'] . "&showvisitors=" . $UNTRUSTED['showvisitors'] . ">Un-Conference</a>]\n ";
}
$checkbox = "<input type=checkbox name=session__" . $chatters['user_id'] . " value=" . $chatters['sessionid'] . " border=0>";
$actionlink .= "[<a href=admin_users_refresh.php?hidechatters=" . $hidechatters . "&ignorelist={$ignorelist}&numchats={$numchatsnow}&operators={$operators}&action=stop&who=" . $chatters['user_id'] . "&whatchannel=" . $chatters['onchannel'] . "&showvisitors=" . $UNTRUSTED['showvisitors'] . "><font color=990000>" . $lang['stop'] . "</font></a>]\n";
}
// see if anyone is chatting with this person.
$sqlquery = "SELECT * FROM livehelp_operator_channels WHERE channel='" . $chatters['onchannel'] . "'";
$counting = $mydatabase->query($sqlquery);
if ($counting->numrows() == 0 && !in_array($chatters['user_id'], $ignorelist_array)) {
} else {
if ($myid != $operatorsarray['user_id']) {
$html .= "<tr bgcolor=#EFEFEF><td> </td><td><img src=images/blank.gif width=5 height=5 border=0></td><td nowrap=nowrap>{$chatting}</td><td width=90% align=left><a href=javascript:seepages(" . $chatters['user_id'] . ") onMouseOver=\" try { hide('visitorsdiv');hide('chattersdiv');show(event, 'info-" . $chatters['username'] . "'); } catch(dam){} return true;\" onMouseOut=\"try { showit('chattersdiv');showit('visitorsdiv');hide('info-" . $chatters['username'] . "');} catch(dam){} return true;\">" . $chatters['username'] . "</a> {$actionlinkouter} </td></tr>\n";
} else {
$lasthtml .= "<tr bgcolor=#EFEFEF><td> </td><td>{$checkbox}</td><td nowrap=nowrap>{$chatting}</td><td width=90% align=left><a href=javascript:seepages(" . $chatters['user_id'] . ") onMouseOver=\"try { hide('visitorsdiv');hide('chattersdiv');show(event, 'info-" . $chatters['username'] . "'); } catch(dam){} return true;\" onMouseOut=\"try { showit('chattersdiv');showit('visitorsdiv');hide('info-" . $chatters['username'] . "'); } catch(dam){} return true;\">" . $chatters['username'] . "</a> {$actionlink} </td></tr>\n";
}
}
}
$sqlquery = "SELECT * from livehelp_users WHERE sessionid='" . $chatters['sessionid'] . "'";
$user_info = $mydatabase->query($sqlquery);
$user_info = $user_info->fetchRow(DB_FETCHMODE_ASSOC);
$sqlquery = "SELECT * from livehelp_visit_track WHERE sessionid='" . $chatters['sessionid'] . "' Order by whendone DESC LIMIT 1";
$page_trail = $mydatabase->query($sqlquery);
$page = $page_trail->fetchRow(DB_FETCHMODE_ASSOC);
$sqlquery = "SELECT * from livehelp_departments WHERE recno='" . $chatters['department'] . "'";
$tmp = $mydatabase->query($sqlquery);
$nameof = $tmp->fetchRow(DB_FETCHMODE_ASSOC);
$nameof = $nameof['nameof'];
$DIVS .= "<DIV ID=\"info-" . $chatters['username'] . "\" STYLE=\"position: absolute; z-index: 20; visibility: hidden; top: 0px; left: 0px;\">\n<TABLE BORDER=\"0\" WIDTH=\"250\"><TR BGCOLOR=\"#000000\"><TD> \n<TABLE BORDER=\"0\" WIDTH=\"248\" CELLPADDING=0 CELLSPACING=0 BORDER=0><TR><TD width=1 BGCOLOR=#" . $color_alt2 . "><img src=images/blank.gif width=7 height=120></TD><TD BGCOLOR=\"#" . $color_alt2 . "\" valign=top>\n<FONT COLOR=\"#000000\">\n<b>" . $lang['referer'] . ":</b><br>" . $user_info['camefrom'] . "<br>\n<b>" . $lang['txt43'] . ":</b><br>{$nameof}<br>\n<b>Url:</b><br><a href=" . $page['location'] . " target=_blank>" . $page['location'] . "</a><br>";
$now = date("YmdHis");
if ($user_info['lastaction'] == "" || $user_info['lastaction'] < 20002020202020) {
$user_info['lastaction'] = $now;
}
$thediff = $now - $user_info['lastaction'];
$DIVS .= "<b>" . $lang['txt65'] . ":</b><br>{$thediff} " . $lang['Seconds'] . "<br>\n </FONT></TD></TR></TABLE></TD></TR></TABLE></DIV>";
}
}
}
$html .= $lasthtml . "</table>";
$html .= "<DIV ID=\"chattersdiv\" STYLE=\"z-index: 2;\">";
if ($UNTRUSTED['hidechatters'] != 1 && $chatboxes > 0) {
$html .= "<table cellpadding=0 cellspacing=0 border=0>";
$html .= "<tr><td><img src=images/blank.gif width=18 height=22 border=0></td><td align=left><img src=images/arrow_ltr.gif width=38 height=22><select name=whattodochat onchange=updatepeople(1)>";
$html .= "<option value=\"\">" . $lang['txt207'] . ":</option>";
$html .= "<option value=stop>" . $lang['stop_chat'] . "</option>";
$html .= "<option value=transfer>" . $lang['transfer_chat'] . "</option>";
$html .= "<option value=conference>" . $lang['conference_chats'] . "</option>";
$html .= "</select> <a href=javascript:updatepeople(1)><img src=images/go.gif border=0 width=20 height=20></a></td></tr>";
$html .= "</table>";
}
$html .= "</DIV>";
///--------------------------------------------------------------------------------------------------
// get the count of active visitors in the system right now.
$timeof = rightnowtime();
$prev = mktime(date("H"), date("i") - 4, date("s"), date("m"), date("d"), date("Y"));
$oldtime = date("YmdHis", $prev);
$sqlquery = "SELECT * FROM livehelp_users WHERE lastaction>'{$oldtime}' AND status!='chat' AND isoperator!='Y' ";
// make list of ignored visitors:
$ipadd = explode(",", $CSLH_Config['ignoreips']);
for ($i = 0; $i < count($ipadd); $i++) {
if (!empty($ipadd[$i])) {
$sqlquery .= " AND ipaddress NOT LIKE '" . $ipadd[$i] . "%' ";
}
}
$sqlquery .= " ORDER by lastaction DESC";
$visitors = $mydatabase->query($sqlquery);
$onlinenow = $visitors->numrows();
$hiddennow = 0;
$html .= "<table width=100% cellpadding=0 cellspacing=0 bgcolor=" . $color_alt2 . "><tr><td>";
if ($UNTRUSTED['showvisitors'] == 1) {
$html .= "<a href=admin_users_refresh.php?hidechatters=" . $hidechatters . "&ignorelist={$ignorelist}&numchats={$numchatsnow}&operators=" . $UNTRUSTED['operators'] . "&showvisitors=2><img src=images/minus.gif border=0></a>";
} else {
$html .= "<a href=admin_users_refresh.php?hidechatters=" . $hidechatters . "&ignorelist={$ignorelist}&numchats={$numchatsnow}&operators=" . $UNTRUSTED['operators'] . "&showvisitors=1><img src=images/plus.gif border=0></a>";
}
if ($UNTRUSTED['showvisitors'] == 1) {
$html .= "</td><td><b>" . $lang['visit'] . " <font color=007700>[onlinenow] " . $lang['online'] . "</font> <font color=777777>[hiddennow] " . $lang['Hidden'] . "</font> </td></tr></table>";
$html .= "<table width=100%><tr bgcolor={$color_background}><td> </td><td><b>ID</b></td><td><b>" . $lang['status'] . ":</b></td><td><b>pages</b></td>";
if ($CSLH_Config['maxrequests'] < 9999) {
$html .= "<td>rq#</td>";
}
$html .= "</tr>";
while ($visitor = $visitors->fetchRow(DB_FETCHMODE_ASSOC)) {
$chatting = "";
// see if we are in the same department as this user..
$sqlquery = "SELECT * FROM livehelp_operator_departments WHERE user_id='{$myid}' AND department='" . $visitor['department'] . "' ";
$data_check = $mydatabase->query($sqlquery);
if ($visitor['department'] != 0 && $data_check->numrows() == 0) {
$hiddennow++;
$onlinenow--;
} else {
if (empty($visitor['user_alert'])) {
$visitor['user_alert'] = 0;
}
if ($visitor['isoperator'] != "Y" && $visitor['user_alert'] != 1) {
$onload = " setTimeout(\"doorbell();\",700); ";
if ($user_alert == "N" || $user_alert == "") {
if ($show_arrival != "N") {
$insitewav = "<SCRIPT type=\"text/javascript\">\n";
$insitewav .= "var MSIE=navigator.userAgent.indexOf(\"MSIE\");\n";
$insitewav .= "var NETS=navigator.userAgent.indexOf(\"Netscape\");\n";
$insitewav .= "var OPER=navigator.userAgent.indexOf(\"Opera\");\n";
$insitewav .= "if((MSIE>-1) || (OPER>-1)) {\n";
$insitewav .= "document.write(\"<BGSOUND SRC=sounds/" . $alertinsite . " LOOP=1>\");\n";
$insitewav .= "} else {\n";
$insitewav .= "document.write(\"<EMBED SRC=sounds/" . $alertinsite . " AUTOSTART=TRUE HIDDEN=true VOLUME=100 LOOP=FALSE><noembed><BGSOUND SRC=" . $alertinsite . " LOOP=1></noembed>\");\n";
$insitewav .= "}\n";
$insitewav .= "</SCRIPT>\n";
}
}
$sql = "UPDATE livehelp_users SET user_alert='1' WHERE user_id='" . $visitor['user_id'] . "' ";
$mydatabase->query($sql);
}
$sqlquery = "SELECT * from livehelp_visit_track WHERE sessionid='" . $visitor['sessionid'] . "'";
$my_count = $mydatabase->query($sqlquery);
$my_count = $my_count->numrows();
$html .= "<tr><td width=10><input type=checkbox name=session__" . $visitor['user_id'] . " value=" . $visitor['sessionid'] . " border=0></td><td>";
$html .= "<a href=javascript:seepages(" . $visitor['user_id'] . ") onMouseOver=\" try { hide('visitorsdiv');hide('chattersdiv');show(event, 'info-" . $visitor['username'] . "'); } catch(dam){} return true;\" onMouseOut=\"try { showit('chattersdiv');showit('visitorsdiv');hide('info-" . $visitor['username'] . "'); } catch(dam){} return true;\">" . $visitor['username'] . "</a>";
$sqlquery = "SELECT * from livehelp_users WHERE user_id='" . $visitor['user_id'] . "'";
$user_info = $mydatabase->query($sqlquery);
$user_info = $user_info->fetchRow(DB_FETCHMODE_ASSOC);
$sqlquery = "SELECT * from livehelp_visit_track WHERE sessionid='" . $visitor['sessionid'] . "' Order by whendone DESC";
$page_trail = $mydatabase->query($sqlquery);
$page = $page_trail->fetchRow(DB_FETCHMODE_ASSOC);
$sqlquery = "SELECT * from livehelp_departments WHERE recno='" . $visitor['department'] . "'";
$tmp = $mydatabase->query($sqlquery);
$nameof = $tmp->fetchRow(DB_FETCHMODE_ASSOC);
$nameof = $nameof['nameof'];
$query = "SELECT whendone from livehelp_visit_track WHERE sessionid='" . filter_sql($visitor['sessionid']) . "' Order by whendone LIMIT 1";
$page_tmprow = $mydatabase->query($query);
$tmprow = $page_tmprow->fetchRow(DB_FETCHMODE_ASSOC);
$later = $tmprow['whendone'];
$DIVS .= "<DIV ID=\"info-" . $visitor['username'] . "\" STYLE=\"position: absolute; z-index: 20; visibility: hidden; top: 0px; left: 0px;\">\n<TABLE BORDER=\"0\" WIDTH=\"300\"><TR BGCOLOR=\"#000000\"><TD> \n<TABLE BORDER=\"0\" WIDTH=\"100%\" CELLPADDING=0 CELLSPACING=0 BORDER=0><TR><TD width=1 BGCOLOR=#" . $color_alt2 . "><img src=images/blank.gif width=7 height=120></TD><TD BGCOLOR=\"#" . $color_alt2 . "\" valign=top>\n<FONT COLOR=\"#000000\">\n<b>Referer:</b><br>" . $user_info['camefrom'] . "<br>";
if (empty($page['location'])) {
$page['location'] = "";
}
$DIVS .= "<b>" . $lang['timeonline'] . ":</b>" . secondstoHHmmss(timediff($later, date("YmdHis"))) . "<br> \n<b>" . $lang['txt43'] . ":</b><br>{$nameof}<br>\n<b>url:</b><br>" . $page['location'] . "<br>";
$now = date("YmdHis");
$thediff = $now - $user_info['lastaction'];
$DIVS .= "<b>" . $lang['lastact'] . ":</b><br>{$thediff} " . $lang['Seconds'] . "<br>\n </FONT></TD></TR></TABLE></TD></TR></TABLE></DIV>";
$html .= "</td>";
switch ($visitor['status']) {
case "DHTML":
$html .= "<td>L:<img src=images/invited.gif> ";
break;
case "request":
$html .= "<td>P:<img src=images/invited.gif> ";
break;
case "invited":
$html .= "<td><img src=images/invited2.gif> ";
break;
case "qna":
$html .= "<td><img src=images/qna.gif>";
break;
case "stopped":
$html .= "<td><img src=images/stopped.gif> ";
break;
case "message":
$html .= "<td><img src=images/message.gif> ";
break;
default:
$html .= "<td><a href=layer.php?selectedwho=" . $visitor['user_id'] . " target=_blank>" . $lang['invite'] . "</a> ";
break;
}
$html .= "</td>";
$html .= "<td>{$my_count}</td>";
if ($CSLH_Config['maxrequests'] < 9999) {
if ($user_info['visits'] > $CSLH_Config['maxrequests'] - 16) {
if ($user_info['visits'] < $CSLH_Config['maxrequests']) {
$html .= "<td><font color=#770000>" . $user_info['visits'] . "</font><br><a href=javascript:resetpages(" . $visitor['user_id'] . ")>reset</a></td>";
} else {
$html .= "<td><font color=#CC0000><b>" . $user_info['visits'] . "</b></font><br><a href=javascript:resetpages(" . $visitor['user_id'] . ")>reset</a></td>";
}
} else {
$html .= "<td>" . $user_info['visits'] . "</td>";
}
}
$html .= "</tr>";
}
}
$html = str_replace("[onlinenow]", $onlinenow, $html);
$html = str_replace("[hiddennow]", $hiddennow, $html);
$html .= "</table>";
$html .= "<DIV ID=\"visitorsdiv\" STYLE=\"z-index: 2;\">";
if ($onlinenow > 0) {
$html .= "<table>";
$html .= "<tr><td><img src=images/arrow_ltr.gif width=38 height=22><select name=whattodo onchange=updatepeople(2)>";
$html .= "<option value=\"\">" . $lang['txt207'] . ":</option>";
$html .= "<option value=DHTML>" . $lang['Invite'] . ":" . $lang['layer'] . "</option>";
$html .= "<option value=pop>" . $lang['Invite'] . ":" . $lang['popup'] . "</option>";
$html .= "</select> <a href=javascript:updatepeople(2)><img src=images/go.gif border=0 width=20 height=20></a></td></tr>";
$html .= "</table><center><a href=admin_users_refresh.php?hidechatters=" . $hidechatters . "&ignorelist={$ignorelist}&numchats={$numchatsnow}&operators=" . $UNTRUSTED['operators'] . "&showvisitors=2>" . $lang['txt208'] . "</a><br></center>";
}
$html .= "</DIV>";
} else {
while ($visitor = $visitors->fetchRow(DB_FETCHMODE_ASSOC)) {
$chatting = "";
// see if we are in the same department as this user..
$sqlquery = "SELECT * FROM livehelp_operator_departments WHERE user_id='{$myid}' AND department='" . $visitor['department'] . "' ";
$data_check = $mydatabase->query($sqlquery);
if ($visitor['department'] != 0 && $data_check->numrows() == 0) {
$hiddennow++;
$onlinenow--;
}
}
$html .= "</td><td><b>" . $lang['visit'] . " <font color=007700>{$onlinenow} " . $lang['online'] . "</font> <font color=777777>{$hiddennow} " . $lang['Hidden'] . "</font></b></td></tr></table>";
$html .= "<table width=100%><tr bgcolor={$color_background}><td colspan=4 align=center><font color=#990000><i>" . $lang['Hidden'] . "</i></a></font><br><a href=admin_users_refresh.php?hidechatters=" . $hidechatters . "&ignorelist={$ignorelist}&numchats={$numchatsnow}&operators=" . $UNTRUSTED['operators'] . "&showvisitors=1>" . $lang['txt209'] . "</a></td></tr></table>";
}
$html = $html . $DIVS;
return $html;
}
><td><b>Total Time Online:</b></td><td><?php
echo secondstoHHmmss($totalonline);
?>
</td></tr>
<tr bgcolor=<?php
echo $color_background;
?>
><td><b>Total Time Monitoring Traffic:</b></td><td><?php
echo secondstoHHmmss($totalmono);
?>
</td></tr>
<tr bgcolor=<?php
echo $color_background;
?>
><td><b>Total Time Chatting:</b></td><td><?php
echo secondstoHHmmss($totalchat);
?>
</td></tr>
</table>
<hr>
<table width=450><tr><td>
Note: Total Time Online/Monitoring Traffic and Chattings is calculated when the operator logs out so does not include current active session.
</td></tr></table>
</FORM>
<?php
if ($isadminsetting == "Y") {
?>
<br><br><br><br>
<table bgcolor=DDDDDD width=600><tr><td>
