<?php
include 'tiosafe_config.php';
if (postNotEmpty('address_id')) {
$address_id = $_POST['address_id'];
$post_update_list = array('street', 'zip', 'city');
$db_update_list = array('entry_street_address', 'entry_postcode', 'entry_city');
$set_update = create_update_list($post_update_list, $db_update_list);
//If the country is posted, get the id
if (postNotEmpty('country')) {
$countries_id = getCountryId($_POST['country'], $db);
if (empty($set_update)) {
$set_update = 'entry_country_id = ' . $countries_id;
} else {
$set_update .= ', entry_country_id = ' . $countries_id;
}
}
if (!empty($set_update) && !empty($address_id)) {
$query = "UPDATE " . TABLE_ADDRESS_BOOK . " SET {$set_update} WHERE address_book_id = " . $address_id;
echo executeSQL($query, $db);
}
} else {
echo '\\nInvalid query: the parameter address_id is required!';
}
$db->close();
</wp:postmeta> <wp:postmeta> <wp:meta_key>_book_colours</wp:meta_key> <wp:meta_value><![CDATA[field_569398cc9b989]]></wp:meta_value> </wp:postmeta> <wp:postmeta> <wp:meta_key>categories</wp:meta_key> <wp:meta_value><![CDATA[CAT' . $row["cat_id"] . ']]></wp:meta_value> </wp:postmeta> <wp:postmeta> <wp:meta_key>_categories</wp:meta_key> <wp:meta_value><![CDATA[field_56939e989a86b]]></wp:meta_value> </wp:postmeta> <wp:postmeta> <wp:meta_key>countries_published_in</wp:meta_key> <wp:meta_value><![CDATA[' . getCountryId($row["country_id"]) . ']]></wp:meta_value> </wp:postmeta> <wp:postmeta> <wp:meta_key>_countries_published_in</wp:meta_key> <wp:meta_value><![CDATA[field_5693a32a65711]]></wp:meta_value> </wp:postmeta> <wp:postmeta> <wp:meta_key>series</wp:meta_key> <wp:meta_value><![CDATA[SR' . $row["series_id"] . ']]></wp:meta_value> </wp:postmeta> <wp:postmeta> <wp:meta_key>_series</wp:meta_key> <wp:meta_value><![CDATA[field_5693a44e799e5]]></wp:meta_value> </wp:postmeta> <wp:postmeta> <wp:meta_key>publication_year</wp:meta_key>
