$bgcolor = "CDCDCD";
 } else {
     $bgcolor = "FEFEFE";
 }
 if ($row['isactive'] == "Y") {
     $isactive = " CHECKED ";
 } else {
     $isactive = " ";
 }
 print "<tr bgcolor={$bgcolor}><td><input type=checkbox name=isactive__" . $row['idnum'] . " value=Y {$isactive}></td><td>";
 print "<table width=100% bgcolor={$color_background}><tr><td> ";
 if ($row['user_id'] != 0) {
     print "<b>If user: </b><font color=000077>" . whatuser($row['user_id']) . "</font><br>";
 }
 if ($row['department'] != 0) {
     print "<b>" . $lang['txt9'] . "</b><font color=000077>" . whatdep($row['department']) . "</font><br>";
 }
 if ($row['page'] != "") {
     print "<b>" . $lang['txt10'] . "</b><font color=000077>" . $row['page'] . "</font><br>";
 }
 if ($row['referer'] != "") {
     print "<b>" . $lang['txt11'] . "</b><font color=000077>" . $row['referer'] . "</font><br>";
 }
 if ($row['visits'] > 1) {
     print "<b>" . $lang['txt12'] . "</b><font color=000077>" . $row['visits'] . "</font><br>";
 }
 if ($row['socialpane'] == "Y") {
     print "<b>shows only in social Pane</b> <br> ";
 }
 if ($row['excludemobile'] == "Y") {
     print "<b>shows only if mobile app is NOT running</b> <br> ";
$query = "SELECT * FROM livehelp_transcripts WHERE sessionid='" . filter_sql($UNTRUSTED['transsessionid']) . "' ORDER by recno DESC";
$transarray = $mydatabase->query($query);
if ($transarray->numrows() == 0) {
    print $lang['txt129'];
} else {
    $transarray = $transarray->fetchRow(DB_FETCHMODE_ASSOC);
    $comments = $transarray['transcript'];
    $department = $transarray['department'];
    $query = "SELECT * FROM livehelp_departments WHERE recno=" . intval($department);
    $data_d = $mydatabase->query($query);
    $department_a = $data_d->fetchRow(DB_FETCHMODE_ASSOC);
    $messageemail = $department_a['messageemail'];
    if (empty($messageemail)) {
        // to avoid relay errors make this do_not_reply@currentdomain.com
        if (!empty($_SERVER['HTTP_HOST'])) {
            $host = str_replace("www.", "", $_SERVER['HTTP_HOST']);
            $messageemail = "do_not_reply@" . $host;
        } else {
            $messageemail = "*****@*****.**";
        }
    }
    $departmentname = whatdep($department);
    if (!send_message($departmentname, $messageemail, "Customer", $UNTRUSTED['sendto'], "Live Help Transcript", $comments, "text/html", $lang['charset'], false)) {
        send_message($departmentname, $messageemail, "Customer", $UNTRUSTED['sendto'], "Live Help Transcript", $comments, "text/html", $lang['charset'], true);
    }
    print "<center><h2>" . $lang['txt130'] . "</h2></center>";
}
print "<br><br><br><br><a href=javascript:window.close()>" . $lang['txt40'] . "</a></center>";
if (!$serversession) {
    $mydatabase->close_connect();
}