PHP rek_db_deleteの例

コード例 #1

ファイル: delete_cat.php プロジェクト: dev4me/Foldergallery

    // no module language file exists for the language set by the user, include default module language file DE.php
    require_once WB_PATH . '/modules/foldergallery/languages/DE.php';
} else {
    // a module language file exists for the language defined by the user, load it
    require_once WB_PATH . '/modules/foldergallery/languages/' . LANGUAGE . '.php';
}
// Files includen
require_once WB_PATH . '/modules/foldergallery/info.php';
require_once WB_PATH . '/modules/foldergallery/scripts/backend.functions.php';
if (isset($_GET['page_id']) && is_numeric($_GET['page_id'])) {
    $page_id = $_GET['page_id'];
}
if (isset($_GET['section_id']) && is_numeric($_GET['section_id'])) {
    $section_id = $_GET['section_id'];
}
if (isset($_GET['cat_id']) && is_numeric($_GET['cat_id'])) {
    $cat_id = $_GET['cat_id'];
    $sql = 'SELECT categorie, parent, has_child FROM ' . TABLE_PREFIX . 'mod_foldergallery_categories WHERE id=' . $cat_id . ';';
    $query = $database->query($sql);
    if ($result = $query->fetchRow()) {
        // Dateien löschen
        $settings = getSettings($section_id);
        $delete_path = $path . $settings['root_dir'] . $result['parent'] . '/' . $result['categorie'];
        // DB Einträge löschen
        rek_db_delete($cat_id);
        $admin->print_success($TEXT['SUCCESS'], ADMIN_URL . '/pages/modify.php?page_id=' . $page_id . '&section_id=' . $section_id);
    } else {
        $admin->print_error($MOD_FOLDERGALLERY['ERROR_MESSAGE'], ADMIN_URL . '/pages/modify.php?page_id=' . $page_id . '&section_id=' . $section_id);
    }
}
$admin->print_footer();

コード例 #2

ファイル: backend.functions.php プロジェクト: dev4me/Foldergallery

function rek_db_delete($cat_id)
{
    global $database;
    $sql = 'SELECT section_id, categorie, parent, has_child FROM ' . TABLE_PREFIX . 'mod_foldergallery_categories WHERE id=' . $cat_id . ';';
    $query = $database->query($sql);
    if ($result = $query->fetchRow()) {
        $parent = $result['parent'] . '/' . $result['categorie'];
        $delete_file_sql = 'DELETE FROM ' . TABLE_PREFIX . 'mod_foldergallery_files WHERE parent_id="' . $cat_id . '";';
        $database->query($delete_file_sql);
        if ($result['has_child']) {
            $select_sql = 'SELECT id FROM ' . TABLE_PREFIX . 'mod_foldergallery_categories WHERE parent_id=' . $cat_id . ';';
            $query = $database->query($select_sql);
            while ($select_result = $query->fetchRow()) {
                rek_db_delete($select_result['id']);
            }
        }
    }
    $deletesql = 'DELETE FROM ' . TABLE_PREFIX . 'mod_foldergallery_categories WHERE id=' . $cat_id;
    $database->query($deletesql);
}