require_once "condb.inc";
echo implode("", $javascript);
if ($_SERVER['REQUEST_METHOD'] == "POST") {
$ca =& current($postobjs['ca']);
$ca->save();
if ($_SESSION['ca_pic']['dirty']) {
if ($_SESSION['ca_pic']['in_db']) {
$GLOBALS['db']->query("UPDATE pictures SET picture = '" . $GLOBALS['db']->escape($_SESSION['ca_pic']['data']) . "' WHERE id = {$ca->obj_id}");
} else {
$GLOBALS['db']->query("INSERT INTO pictures(picture, id) VALUES('" . $GLOBALS['db']->escape($_SESSION['ca_pic']['data']) . "', {$ca->obj_id})");
}
}
} elseif (isset($_GET['ca_id'])) {
$ca = new ca($_GET['ca_id']);
} else {
$ca = new ca();
}
if (isset($_SESSION['ca_id']) && $_SESSION['ca_id'] != $ca->obj_id) {
unset($_SESSION['ca_pic']);
}
$_SESSION['ca_id'] = $ca->obj_id;
?>
<script type="text/javascript">
function currentAddress() {
var addrdivs = document.getElementById("addrEdit").getElementsByTagName("div");
var cur = -2;
for (x=0; x<addrdivs.length; x++) if (addrdivs[x].style.display != "none") cur = x;
return cur;
}
function selectAddress(target) {
echo "<h4>Merge steps:</h4>\n";
echo "<pre>";
runandprint("UPDATE addresses SET ca = {$_POST['source_ca']} WHERE ca = {$_POST['target_ca']}");
foreach (array_keys($_POST, "keepthisaddr") as $addrid) {
runandprint("UPDATE addresses SET ca = {$_POST['target_ca']} WHERE id = {$addrid}");
}
runandprint("UPDATE many SET toid = {$_POST['target_ca']} WHERE totable = 'CAs' AND toid = {$_POST['source_ca']}");
runandprint("UPDATE many SET fromid = {$_POST['target_ca']} WHERE fromtable = 'CAs' AND fromid = {$_POST['source_ca']}");
foreach ($_SESSION['classes'] as &$class) {
if (in_array("ca", $GLOBALS['db']->get_fields($class['table']))) {
runandprint("UPDATE {$class['table']} SET ca = {$_POST['target_ca']} WHERE ca = {$_POST['source_ca']}");
}
}
runandprint("DELETE FROM addresses WHERE ca = {$_POST['source_ca']}");
runandprint("DELETE FROM pictures WHERE id = {$_POST['source_ca']}");
runandprint("DELETE FROM CAs WHERE id = {$_POST['source_ca']}");
echo "</pre><h4>Final CA Fields:</h4><pre>\n";
$updca = new ca($_POST['target_ca']);
foreach ($updca->fields as $fieldname => &$field) {
if (isset($_POST[$fieldname])) {
$field = $_POST[$fieldname];
}
}
print_r($updca->fields);
$updca->save();
echo "</pre>\n<a href=\"camerge.php\">9-10, Start Over Again!</a>\n";
}
?>
</body>
</html>
