$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(); }