<?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) . ' '; }