function update_record($id, $data) { $old = load_record($id); $omit = array('lat', 'lon', 'fullname', 'id', 'updated', 'created', 'ts'); foreach ($old as $k => $v) { if (in_array($k, $omit)) { continue; } if (@$data[$k] != $v) { @log_update($id, $k, $v, $data[$k]); } } $data = _prepare_data($data); if (!isset($data['firstname'])) { $data['firstname'] = ''; } if (!isset($data['lastname'])) { $data['lastname'] = ''; } if (!isset($data['fullname'])) { $data['fullname'] = ''; } if (!isset($data['age'])) { $data['age'] = ''; } if (!isset($data['gender'])) { $data['gender'] = ''; } if (!isset($data['city'])) { $data['city'] = ''; } if (!isset($data['department'])) { $data['department'] = ''; } if (!isset($data['status'])) { $data['status'] = ''; } if (!isset($data['current_location'])) { $data['current_location'] = ''; } if (!isset($data['address'])) { $data['address'] = ''; } if (!isset($data['lat'])) { $data['lat'] = ''; } if (!isset($data['lon'])) { $data['lon'] = ''; } if (!isset($data['current_contact_information'])) { $data['current_contact_information'] = ''; } if (!isset($data['aid_type'])) { $data['aid_type'] = ''; } if (!isset($data['notes'])) { $data['notes'] = ''; } if (!isset($data['url_link_back'])) { $data['url_link_back'] = ''; } if (!isset($data['fromsms'])) { $data['fromsms'] = ''; } mysql_query(sprintf("UPDATE person SET firstname = '%s', lastname = '%s', fullname = '%s', age = %d, gender = '%s', city = '%s', department = '%s',\n\t\t\tstatus = '%s', current_location = '%s', address = '%s', lat = %d, lon = %d, current_contact_information = '%s', \n\t\t\tupdated = %d, aid_type = '%s', notes = '%s'\n\t\t\tWHERE id = %d", $data['firstname'], $data['lastname'], $data['fullname'], $data['age'], $data['gender'], $data['city'], $data['department'], $data['status'], $data['current_location'], $data['address'], $data['lat'], $data['lon'], $data['current_contact_information'], time(), mysql_real_escape_string($id), $data['aid_type'], $data['notes'])); broadcast_raw($data, $id); if (!empty($data['my_phone'])) { handle_searcher($id, $data); } }
require_once 'db.php'; // this is a person. if (count($_POST) != 0) { if (isset($_POST['action']) && $_POST['action'] == 'comment') { add_comment($_GET['id'], $_POST); } elseif (isset($_POST['action']) && $_POST['action'] == 'photo') { handle_upload($_GET['id']); } else { update_record($_GET['id'], $_POST); } } if (!isset($_GET['id'])) { header('Location: /'); exit; } $person = load_record($_GET['id']); if (empty($person)) { header('Location: /'); exit; } $updates = get_updates($_GET['id']); $comments = get_comments($_GET['id']); $photos = get_photos($_GET['id']); $searcher = get_searcher($_GET['id']); $title = $person['fullname']; //$title = msg('People'); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head>