if (isset($UNTRUSTED['reset'])) { $query = "SELECT user_id,sessionid,camefrom,firstdepartment FROM livehelp_users WHERE isoperator='N' AND status!='chat'"; $sth = $mydatabase->query($query); while ($row = $sth->fetchRow(DB_FETCHMODE_ORDERED)) { $user_id = $row[0]; $sessionid = $row[1]; $camefrom = $row[2]; $firstdepartment = $old_user[3]; // if not txt-db-api and $CSLH_Config['tracking'] == "Y" insert visitor and referer information: if ($dbtype != "txt-db-api") { if (!empty($camefrom) && $CSLH_Config['reftracking'] == "Y") { archivepage('livehelp_referers_daily', $camefrom, date("Ymd"), $firstdepartment); archivepage('livehelp_referers_monthly', $camefrom, date("Ym"), $firstdepartment); } if ($CSLH_Config['tracking'] == "Y") { archivefootsteps($sessionid); } } archiveuser($sessionid); } print "Database reset..."; print "<SCRIPT type=\"text/javascript\"> window.location.replace(\"live.php\");</script>"; print "<a href=live.php>click here</a>"; exit; } if (!$serversession) { $mydatabase->close_connect(); } ?> <title>Live help admin</title> <frameset rows="52,*,155" border="0" frameborder="0" framespacing="0" spacing="0" NORESIZE=NORESIZE>
/** * Archives off a user: * * @param string SessionID */ function archiveuser($sessionid) { global $mydatabase, $CSLH_Config, $dbtype; //gather users user_id: $sqlquery = "SELECT user_id,isnamed,camefrom,firstdepartment FROM livehelp_users WHERE sessionid='" . filter_sql($sessionid) . "'"; $res = $mydatabase->query($sqlquery); $res_array = $res->fetchRow(DB_FETCHMODE_ORDERED); $user_id = $res_array[0]; $isnamed = $res_array[1]; $camefrom = $res_array[2]; $firstdepartment = $res_array[3]; if ($dbtype != "txt-db-api" && $CSLH_Config['tracking'] == "Y") { archivefootsteps($sessionid); } else { // let get rid of the temp data.. $sqlquery = "DELETE FROM livehelp_visit_track WHERE sessionid='" . filter_sql($sessionid) . "'"; $mydatabase->query($sqlquery); } // identity tracking: if ($isnamed == "Y" && $dbtype != "txt-db-api" && $CSLH_Config['usertracking'] == "Y") { $thismonth = date("Ym"); $thisday = date("Ymd"); archiveidentity('livehelp_identity_daily', $sessionid, $thisday); archiveidentity('livehelp_identity_monthly', $sessionid, $thismonth); } // Keyword tracking: if ($dbtype != "txt-db-api" && $CSLH_Config['keywordtrack'] == "Y") { $thismonth = date("Ym"); $thisday = date("Ymd"); archivekeywords('livehelp_keywords_daily', $camefrom, $thisday, $firstdepartment); archivekeywords('livehelp_keywords_monthly', $camefrom, $thismonth, $firstdepartment); } // delete user $sqlquery = "DELETE FROM livehelp_users WHERE sessionid='" . filter_sql($sessionid) . "'"; $mydatabase->query($sqlquery); $sqlquery = "DELETE FROM livehelp_channels WHERE user_id=" . intval($user_id); $mydatabase->query($sqlquery); }