PHP class_db::delete_item Beispiele

Beispiel #1

Datei: admin_bbcodes.php Projekt: ALTUN69/icy_phoenix

            trigger_error($lang['BBCODE_INVALID'], E_USER_WARNING);
        }
        if ($bbcode_id > 0) {
            $class_db->update_item($bbcode_id, $data);
            $message = '<br /><br />' . $lang['BBCODES_DB_UPDATED'];
        } else {
            $class_db->insert_item($data);
            $message = '<br /><br />' . $lang['BBCODES_DB_ADDED'];
        }
        $cache->destroy_datafiles(array('_bbcodes'), MAIN_CACHE_FOLDER, 'data', true);
        $message .= '<br /><br />' . sprintf($lang['BBCODES_DB_CLICK'], '<a href="' . append_sid(THIS_PAGE) . '">', '</a>');
        $message .= '<br /><br />' . sprintf($lang['Click_return_admin_index'], '<a href="' . append_sid('index.' . PHP_EXT . '?pane=right') . '">', '</a>');
        message_die(GENERAL_MESSAGE, $message);
    } elseif ($mode == 'delete') {
        if ($bbcode_id > 0) {
            $class_db->delete_item($bbcode_id);
            $message = '<br /><br />' . $lang['BBCODES_DB_DELETED'];
        } else {
            $message = '<br /><br />' . $lang['BBCODES_NO_BBCODES_SEL'];
        }
        $cache->destroy_datafiles(array('_bbcodes'), MAIN_CACHE_FOLDER, 'data', true);
        $message .= '<br /><br />' . sprintf($lang['BBCODES_DB_CLICK'], '<a href="' . append_sid(THIS_PAGE) . '">', '</a>');
        $message .= '<br /><br />' . sprintf($lang['Click_return_admin_index'], '<a href="' . append_sid('index.' . PHP_EXT . '?pane=right') . '">', '</a>');
        message_die(GENERAL_MESSAGE, $message);
    }
} else {
    $template->set_filenames(array('body' => ADM_TPL . 'bbcodes_list_body.tpl'));
    $sql = "SELECT * FROM " . BBCODES_TABLE . " ORDER BY bbcode_tag ASC";
    $result = $db->sql_query($sql);
    $bbcode_rows = $db->sql_fetchrowset($result);
    $bbcodes_count = sizeof($bbcode_rows);

Beispiel #2

Datei: admin_tickets.php Projekt: ALTUN69/icy_phoenix

        }
        $inputs_array = array('ticket_cat_title' => $ticket_cat_title, 'ticket_cat_des' => $ticket_cat_des, 'ticket_cat_emails' => $ticket_cat_emails);
        if ($ticket_cat_id > 0) {
            $class_db->update_item($ticket_cat_id, $inputs_array);
            $message = '<br /><br />' . $lang['TICKETS_DB_UPDATED'];
        } else {
            $class_db->insert_item($inputs_array);
            $message = '<br /><br />' . $lang['TICKETS_DB_ADDED'];
        }
        $message .= '<br /><br />' . sprintf($lang['TICKETS_DB_CLICK'], '<a href="' . append_sid('admin_tickets.' . PHP_EXT) . '">', '</a>');
        $message .= '<br /><br />' . sprintf($lang['Click_return_admin_index'], '<a href="' . append_sid('index.' . PHP_EXT . '?pane=right') . '">', '</a>');
        message_die(GENERAL_MESSAGE, $message);
    } elseif ($mode == 'delete') {
        $ticket_cat_id = request_var('ticket_cat_id', 0);
        if ($ticket_cat_id > 0) {
            $class_db->delete_item($ticket_cat_id);
            $message = '<br /><br />' . $lang['TICKETS_DB_DELETED'];
        } else {
            $message = '<br /><br />' . $lang['TICKETS_NO_TICKET_SEL'];
        }
        $message .= '<br /><br />' . sprintf($lang['TICKETS_DB_CLICK'], '<a href="' . append_sid('admin_tickets.' . PHP_EXT) . '">', '</a>');
        $message .= '<br /><br />' . sprintf($lang['Click_return_admin_index'], '<a href="' . append_sid('index.' . PHP_EXT . '?pane=right') . '">', '</a>');
        message_die(GENERAL_MESSAGE, $message);
    }
} else {
    $template->set_filenames(array('body' => ADM_TPL . 'tickets_list_body.tpl'));
    $sql = "SELECT * FROM " . TICKETS_CAT_TABLE . " ORDER BY ticket_cat_id ASC";
    $result = $db->sql_query($sql);
    $ticket_rows = $db->sql_fetchrowset($result);
    $tickets_count = sizeof($ticket_rows);
    $db->sql_freeresult($result);