コード例 #1
0
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>
コード例 #2
0
/**
 * 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);
}