<?php
require_once "includes/session.php";
//For creating a session, we don't use cookies "for better security"
require_once "includes/functions.php";
//Functions files
require_once "includes/db_connection.php";
//Including the database connection file
confirm_logged_in();
$contact = contact_info();
if (isset($_POST['submit'])) {
// Process the form
if (empty($errors)) {
// Perform Update
$email = mysql_prep($_POST["email"]);
$mobile = mysql_prep($_POST["mobile"]);
$facebook = mysql_prep($_POST["facebook"]);
$linkedin = mysql_prep($_POST["linkedin"]);
$query = "UPDATE contact SET ";
$query .= "email = '{$email}', ";
$query .= "mobile = '{$mobile}', ";
$query .= "facebook = '{$facebook}', ";
$query .= "linkedin = '{$linkedin}' ";
$query .= "WHERE id = '1' ";
$query .= "LIMIT 1";
$result = mysqli_query($connection, $query);
if ($result && mysqli_affected_rows($connection) == 1) {
// Success
$_SESSION["message"] = "Contact Info updated.";
redirect_to("contact.php?id=8");
} else {
$uresult = mysql_query($usql);
if (mysql_error()) {
trigger_error("MySQL Query Error " . mysql_error(), E_USER_WARNING);
}
$update = mysql_fetch_object($uresult);
$asql = "SELECT COUNT(*) FROM `{$dbLinks}` WHERE linktype = 5 AND direction = 'left' AND origcolref = {$incoming->updateid}";
$aresult = mysql_query($asql);
if (mysql_error()) {
trigger_error("MySQL Query Error " . mysql_error(), E_USER_WARNING);
}
list($num_attachments) = mysql_fetch_row($aresult);
}
echo "<tr class='{$shade}' onclick='trow(event);'>";
echo "<td>" . html_checkbox('selected[]', FALSE, $incoming->id);
echo "</td>";
echo "<td>" . contact_info($incoming->contactid, $incoming->from, $incoming->emailfrom) . "</td>";
echo "</td>";
// Subject
echo "<td>";
if ($incoming->locked != $sit[2] && $incoming->locked > 0) {
echo sprintf($strLockedByX, user_realname($update->locked, TRUE));
} else {
// TODO option for popup or not (Mantis 619)
// $url = "javascript:incident_details_window('{$incoming->id}','incomingview');";
// $url = "incident_details.php?id={$incoming->id}&win=incomingview";
$url = "inbox.php?id={$incoming->id}";
echo "<a href=\"{$url}\" id='update{$incoming->updateid}' class='info'";
echo " title='{$strViewAndLockHeldEmail}'>";
if (!empty($incoming->incident_id)) {
echo icon('support', 16) . ' ';
}
