Exemplo n.º 1
0
     $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
Exemplo n.º 2
0
$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