$response["success"] = true;
if ($result_apply = \db::query($SQL_apply, $params_apply)) {
$response["apply"] = $result_apply[0];
}
if (isset($field_context["is_label"]) && $field_context["is_label"]) {
$SQL_rewrite = 'SELECT `rewrite_id` FROM `{PREFIX}rewrites` ';
$SQL_rewrite .= 'WHERE `reference` = :reference';
$params_rewrite = array(":reference" => $model->reference);
if (!\db::query($SQL_rewrite, $params_rewrite)) {
$SQL_rewrite = <<<SQL
INSERT INTO `{PREFIX}rewrites` (`url`, `resource_uri`, `reference`, `primary`)
VALUES (:url, :resource_uri, :reference, :primary)
SQL;
$resource_uri = $model->class . '/' . $model->table_id;
$ascii = \runner::get_rewrite_url($value, $model->reference, $resource_uri);
$params_rewrite = array(':url' => $ascii, ':resource_uri' => $resource_uri, ':reference' => $model->reference, ':primary' => 1);
\db::insert($SQL_rewrite, $params_rewrite);
}
// save title
$SQL_meta = 'SELECT model_meta_id, title FROM `{PREFIX}model_metas` ';
$SQL_meta .= 'WHERE `reference` = :reference';
$params_meta = array(":reference" => $model->reference);
$result_meta = \db::query($SQL_meta, $params_meta);
$title = '';
$prefixes = \bootstrap::get("pageproperties_prefix");
if ($prefixes && isset($prefixes["title"])) {
$title .= $prefixes["title"];
}
$title .= $value;
if (!$result_meta) {
$SQL_UPDATE = 'DELETE FROM `{PREFIX}rewrites` WHERE ';
$SQL_UPDATE .= implode(" AND ", $condition);
\db::query($SQL_UPDATE, $params);
if ($urls = explode(PHP_EOL, $value)) {
$SQL_UPDATE = 'INSERT INTO `{PREFIX}rewrites` (`url`';
foreach (array_keys($condition) as $insert_field) {
$SQL_UPDATE .= ', `' . $insert_field . '`';
}
$SQL_UPDATE .= ') VALUES (:url';
foreach (array_keys($params) as $param_field) {
$SQL_UPDATE .= ', ' . $param_field;
}
$SQL_UPDATE .= ')';
foreach ($urls as $url) {
if ($url) {
$params[":url"] = \runner::get_rewrite_url($url, $resource["reference"], $resource["resource_uri"]);
\db::query($SQL_UPDATE, $params);
}
}
}
$response["success"] = true;
}
}
if ($response["success"] && ($result_apply = \db::query($SQL_apply, $params_apply))) {
$response["apply"] = $result_apply[0];
}
break;
case "title":
case "keywords":
case "description":
// model_metas table direct column