if (isset($_POST['quote']['market_name'])) {
if (!pb_strcomp($_POST['quote']['market_name'], $_POST['market_name'])) {
$vals['market_id'] = $pdb->GetOne("SELECT id FROM {$tb_prefix}markets WHERE name='" . $_POST['quote']['market_name'] . "'");
} else {
$vals['market_id'] = $pdb->GetOne("SELECT id FROM {$tb_prefix}markets WHERE name='" . $_POST['market_name'] . "'");
}
}
if (isset($_POST['quote']['product_name'])) {
if (!pb_strcomp($_POST['quote']['product_name'], $_POST['product_name'])) {
$vals['product_id'] = $pdb->GetOne("SELECT id FROM {$tb_prefix}products WHERE name='" . $_POST['quote']['product_name'] . "'");
} else {
$vals['product_id'] = $pdb->GetOne("SELECT id FROM {$tb_prefix}products WHERE name='" . $_POST['product_name'] . "'");
}
}
$trend['x'] = PbController::convertTextToArray($_POST['trend_data']['x']);
$trend['y'] = PbController::convertTextToArray($_POST['trend_data']['y']);
$vals['trend_data'] = serialize($trend);
$vals['area_id'] = $vals['area_id3'];
if (!empty($vals['content'])) {
$vals['content'] = stripcslashes($vals['content']);
}
if (!empty($id)) {
$vals['modified'] = $time_stamp;
$result = $marketquotes->save($vals, "update", $id);
} else {
$vals['created'] = $vals['modified'] = $time_stamp;
$result = $marketquotes->save($vals);
}
if (!$result) {
flash();
} else {
