PHP dbDeleteNS Examples

Example #1

File: backend.php Project: ratmir-by/icms-calendar

    if (isset($_REQUEST['item_id'])) {
        $item_id = (int) $_REQUEST['item_id'];
        //DELETE POSTS WITH ALL DATA
        $sql = "SELECT p.*, f.icon as f_icon\r\n\t\t\t\t\tFROM cms_forum_posts p, cms_forum_threads t, cms_forums f\r\n\t\t\t\t\tWHERE p.thread_id = t.id AND t.forum_id = f.id AND f.id = '{$item_id}'";
        $rs = dbQuery($sql);
        if (mysql_num_rows($rs)) {
            while ($post = mysql_fetch_assoc($rs)) {
                uploadDeletePost(0, $post['id']);
                $inCore->deleteUploadImages($post['id'], 'forum');
            }
        }
        $f_icon = $inDB->get_field('cms_forums', "id = '{$item_id}'", 'icon');
        //DELETE THREADS
        dbQuery("DELETE FROM cms_forum_threads WHERE forum_id = '{$item_id}'");
        //DELETE FORUM
        dbDeleteNS('cms_forums', $item_id);
        if (file_exists(PATH . '/upload/forum/cat_icons/' . $f_icon)) {
            @chmod(PATH . '/upload/forum/cat_icons/' . $f_icon, 0777);
            @unlink(PATH . '/upload/forum/cat_icons/' . $f_icon);
        }
    }
    $inCore->redirect('?view=components&do=config&id=' . $id . '&opt=list_forums');
}
if ($opt == 'config') {
    require '../includes/jwtabs.php';
    $GLOBALS['cp_page_head'][] = jwHeader();
    ?>
        <form action="index.php?view=components&amp;do=config&amp;id=<?php 
    echo $id;
    ?>
" method="post" name="addform" target="_self" id="form1" style="margin-top:10px">

Example #2

File: backend.php Project: ratmir-by/icms-calendar

    header('location:?view=components&do=config&id=' . (int) $_REQUEST['id'] . '&opt=list_cats');
}
if ($opt == 'delete_cat') {
    if (isset($_REQUEST['item_id'])) {
        $id = (int) $_REQUEST['item_id'];
        $sql = "SELECT id, file FROM cms_board_items WHERE category_id = {$id}";
        $result = dbQuery($sql);
        //DELETE ALL PHOTOS IN ALBUM
        if (mysql_num_rows($result)) {
            while ($photo = mysql_fetch_assoc($result)) {
                $model->deleteRecord($photo['id']);
            }
        }
        $f_icon = $inDB->get_field('cms_board_cats', "id = '{$id}'", 'icon');
        //DELETE ALBUM
        dbDeleteNS('cms_board_cats', $id);
        if (file_exists(PATH . '/upload/board/cat_icons/' . $f_icon)) {
            @chmod(PATH . '/upload/board/cat_icons/' . $f_icon, 0777);
            @unlink(PATH . '/upload/board/cat_icons/' . $f_icon);
        }
    }
    header('location:?view=components&do=config&id=' . (int) $_REQUEST['id'] . '&opt=list_cats');
}
if ($opt == 'update_cat') {
    if (isset($_REQUEST['item_id'])) {
        $id = (int) $_REQUEST['item_id'];
        $sql = "SELECT * FROM cms_board_cats WHERE id = '{$id}' LIMIT 1";
        $result = dbQuery($sql);
        if (mysql_num_rows($result)) {
            $mod = mysql_fetch_assoc($result);
            $mod['icon'] = $mod['icon'] == 'folder_grey.png' ? '' : $mod['icon'];