$val) { if (substr($k, 0, 5) == "save_") { $r =& unserializeRectangle($val); $map->addRectangle($r); /* Now save the link relationship */ $from = validate_name($_POST['title']); $to = $r->getLink(RECTANGLE_RAW_LINK); // TODO: the from and to links are never removed $sql = sprintf("INSERT INTO `link` SET `from`='%s', `to`='%s'", $from, $to); $result = $DB->query($sql); if (PEAR::isError($result)) { echo 'Standard Message: ' . $result->getMessage() . "\n"; echo 'Standard Code: ' . $result->getCode() . "\n"; echo 'DBMS/User Message: ' . $result->getUserInfo() . "\n"; echo 'DBMS/Debug Message: ' . $result->getDebugInfo() . "\n"; exit; } } } /** Perform sql query */ $validated_title = validate_name($_POST['title']); $sql = sprintf("SELECT COUNT(*) FROM `node` WHERE `title`='%s'", $validated_title); $result = $DB->getOne($sql); if ($result == 0) { $sql = sprintf("INSERT INTO `%s` SET title='%s', map='%s'", 'node', $validated_title, mysql_escape_string($map->serialize())); } else { $sql = sprintf("UPDATE `%s` SET map='%s' WHERE title='%s'", 'node', mysql_escape_string($map->serialize()), $validated_title); } $result = $DB->query($sql); } ?>