//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 />'; }