//insert $selected_categs
deleteFieldWhere('mm_categs_sesizari', 'sesizare_id', $_ID);
for ($i = 0; $i < count($selected_categs); $i++) {
insertIntoTable("INSERT INTO mm_categs_sesizari SET sesizare_id = " . $_ID . ", categ_id = " . intval($selected_categs[$i]) . " ");
}
//endfor $selected_categs
//insert $linkuri_sursa
deleteFieldWhere('mm_sesizari_linkuri', 'sesizare_id', $_ID);
for ($i = 0; $i < count($linkuri_sursa); $i++) {
if (strlen(trim($linkuri_sursa[$i]))) {
insertIntoTable("INSERT INTO mm_sesizari_linkuri SET sesizare_id = " . $_ID . ", link_sursa = '" . $linkuri_sursa[$i] . "' ");
}
}
//endfor $linkuri_sursa
//insert $embed_sursa
deleteFieldWhere('mm_sesizari_embeds', 'sesizare_id', $_ID);
for ($i = 0; $i < count($embed_sursa); $i++) {
if (strlen(trim($embed_sursa[$i]))) {
insertIntoTable("INSERT INTO mm_sesizari_embeds SET sesizare_id = " . $_ID . ", embed_sursa = '" . $embed_sursa[$i] . "' ");
}
}
//endfor $embed_sursa
//////////////////////////////////////////////////////////////////////////////////////////////////////////
$insertLog = "INSERT INTO log SET " . "data = NOW(), " . "obs = 'ADAUGARE SESIZARE - DUPA AUTENTIFICARE', " . "ip = '" . get_ip_address() . "', " . "query = '" . mysql_real_escape_string($insertSesizareStr) . "' " . "";
if (!mysql_query($insertLog, $configArray['dbcnx'])) {
$insertErr = 1;
echo $insertLog . ' eroare la adaugare 2';
} else {
echo '';
}
if (!$insertErr) {
$error['selected_categs'] = 'Cel putin o categorie.';
$submitOK = false;
}
}
// endif post submit
if ($submitOK && $configArray['rightWrite']) {
$updateAlertaStr = "UPDATE alerte SET " . "alerta_nume = '" . mysql_escape_string($alerta_nume) . "', " . "alerta_email = '" . mysql_escape_string($alerta_email) . "', " . "modified_at = '" . date("Y-m-d H:i:s") . "' " . "WHERE alerta_id = " . $_ID . "";
//echo $updateAlertaStr;
$insertErr = 0;
if (!mysql_query($updateAlertaStr, $configArray['dbcnx'])) {
$insertErr = 1;
echo ' eroare la update 1: [' . mysql_error() . ']';
} else {
}
//insert $selected_categs
deleteFieldWhere('mm_categs_alerte', 'alerta_id', $_ID);
for ($i = 0; $i < count($selected_categs); $i++) {
insertIntoTable("INSERT INTO mm_categs_alerte SET alerta_id = " . $_ID . ", categ_id = " . intval($selected_categs[$i]) . " ");
}
//endfor $selected_categs
//////////////////////////////////////////////////////////////////////////////////////////////////////////
$insertLog = "INSERT INTO log SET " . "data = NOW(), " . "obs = 'ACTUALIZARE SESIZARE - DUPA AUTENTIFICARE', " . "ip = '" . get_ip_address() . "', " . "query = '" . mysql_real_escape_string($updateAlertaStr) . "' " . "";
if (!mysql_query($insertLog, $configArray['dbcnx'])) {
$insertErr = 1;
echo $insertLog . ' eroare la adaugare 2';
} else {
echo '';
}
if (!$insertErr) {
echo '<br />Modificarea fost facuta cu succes!<br /><br />';
}
