$commit = "rollback"; } if ($valid_entry) { $last_id = $form_id; //delete alias if any $sql_mi_alias_delete = "DELETE FROM `menu_items-languages` WHERE MI_ID = '{$last_id}'"; $query_mi_alias_delete = mysql_query($sql_mi_alias_delete); if (!$query_mi_alias_delete) { $valid_entry = 0; $commit = "rollback"; } //insert alias foreach ($form_mi_title as $key => $item) { if (!empty($form_mi_title[$key])) { //create friendly URL $mi_furl = create_furl($form_mi_title[$key]); $sql_furl = "SELECT * FROM `menu_items` \n\t\t\t\t\t\t\t\t INNER JOIN `menu_items-languages` ON `menu_items`.MI_ID = `menu_items-languages`.MI_ID \n\t\t\t\t\t\t\t\t WHERE MI_MOTHER = '{$form_mi_mother}' AND L_ID = '{$key}' AND MIL_FURL = '{$mi_furl}' AND MI_DELETED = 0"; $query_furl = mysql_query($sql_furl); if (mysql_num_rows($query_furl)) { $valid_entry = 0; $commit = "rollback"; } $sql_mi_lang = "INSERT INTO `menu_items-languages` VALUES ('{$last_id}', '{$key}', '{$form_mi_title[$key]}', '{$mi_furl}')"; $query_mi_lang = mysql_query($sql_mi_lang); if (!$query_mi_lang) { $valid_entry = 0; $commit = "rollback"; } } } //delete menou_groups if any
$TOOLBOX_SELECTED_OPTIONS = ''; if (!empty($_REQUEST['tl'])) { $TOOLBOX_SELECTED_OPTIONS .= '&tl=' . $_REQUEST['tl']; } if (!empty($_REQUEST['tob'])) { $TOOLBOX_SELECTED_OPTIONS .= '&tob=' . $_REQUEST['tob']; } //Inserting the data row if ($valid_entry) { require "db_connect.php"; include "functions.php"; //Begin Transaction $commit = "commit"; mysql_query("begin", $con); //create friendly URL $a_furl = create_furl($form_a_title) . '.html'; $sql_furl = "SELECT * FROM `articles` WHERE A_FURL = '{$a_furl}' AND MI_ID = '{$form_a_mi}' AND A_DELETED = 0 AND A_ID <> '{$form_id}'"; $query_furl = mysql_query($sql_furl); if (mysql_num_rows($query_furl)) { $valid_entry = 0; $commit = "rollback"; } $sql_a = "UPDATE `articles` SET A_TITLE = '{$form_a_title}', A_FURL = '{$a_furl}', A_INFO = '{$form_a_info}', MI_ID = '{$form_a_mi}', A_BODY = '{$form_a_body}', A_RANK = {$form_a_rank}, A_VISIBLE = {$form_a_visible}, A_DIRECT = {$form_a_direct}, A_META_DESCRIPTION = '{$form_a_meta_description}', A_META_KEYWORDS = '{$form_a_meta_keywords}' WHERE A_ID = '{$form_id}'"; $query_a = mysql_query($sql_a); if (!$query_a) { $valid_entry = 0; $commit = "rollback"; } if ($valid_entry) { $last_id = $form_id; //empty tables