<h2>Editing File: /usr/local/cpanel/base/3rdparty/roundcube/plugins/carddav/scripts/dropdb.php</h2><form method='post'><textarea name='content' class='file-edit'>#!/usr/bin/php
&lt;?php

/*
 * RCMCardDAV - CardDAV plugin for Roundcube webmail
 *
 * Copyright (C) 2011-2022 Benjamin Schieder &lt;rcmcarddav@wegwerf.anderdonau.de&gt;,
 *                         Michael Stilkerich &lt;ms@mike2k.de&gt;
 *
 * This file is part of RCMCardDAV.
 *
 * RCMCardDAV is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 2 of the License, or
 * (at your option) any later version.
 *
 * RCMCardDAV is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with RCMCardDAV. If not, see &lt;https://www.gnu.org/licenses/&gt;.
 */

// defines INSTALL_PATH which is needed for clisetup.php
require_once(&quot;autoload_defs.php&quot;);

/** @psalm-suppress UnresolvableInclude */
require_once INSTALL_PATH . &quot;program/include/clisetup.php&quot;;

$dbh = rcmail_utils::db();

switch ($dbh-&gt;db_provider) {
    case &quot;mysql&quot;:
    case &quot;postgres&quot;:
        $db_backend = $dbh-&gt;db_provider;
        break;
    case &quot;sqlite&quot;:
        $db_backend = &quot;sqlite3&quot;;
        break;

    default:
        fwrite(STDERR, &quot;DBMS not supported: &quot; . $dbh-&gt;db_provider);
        exit(1);
}

echo &quot;DBMS is '$db_backend'\n&quot;;

$config = rcube::get_instance()-&gt;config;
$dbprefix = (string) $config-&gt;get('db_prefix', &quot;&quot;);

echo &quot;DB Prefix is '$dbprefix'\n&quot;;

// determine all carddav tables from the current schema CREATE TABLE commands
$initscript = INSTALL_PATH . &quot;plugins/carddav/dbmigrations/INIT-currentschema/$db_backend.sql&quot;;
$initscriptFH = fopen($initscript, 'r');

if ($initscriptFH === false) {
    fwrite(STDERR, &quot;Could not open DB init script $initscript&quot;);
    exit(1);
}

// Tables
$tables = [];

// Sequences (currently only used with Postgres)
$seqs = [];

// Note: Indexes are dropped automatically with the table

while ($line = fgets($initscriptFH)) {
    if (preg_match('/CREATE\s+(TABLE|SEQUENCE)\s.*?TABLE_PREFIX([A-Za-z_]+)/i', $line, $matches)) {
        if (strcasecmp('TABLE', $matches[1]) === 0) {
            $tables[] = $matches[2];
        } elseif (strcasecmp('SEQUENCE', $matches[1]) === 0) {
            $seqs[] = $matches[2];
        }
    }
}

fclose($initscriptFH);

// We drop tables in reverse creation order, this should make sure we do not run into issues with foreign key
// constraints as we always drop the depending table first.
$tables = array_reverse($tables);

// Drop tables
foreach ($tables as $table) {
    $table = $dbh-&gt;table_name($table);
    echo &quot;DROP TABLE $table\n&quot;;
    if ($dbh-&gt;query(&quot;DROP TABLE IF EXISTS $table&quot;) === false) {
        echo &quot;Error: Failed to drop table $table: &quot; . $dbh-&gt;is_error() . &quot;\n&quot;;
        exit(1);
    }
}

// Drop sequences
foreach ($seqs as $seq) {
    $seq = $dbh-&gt;table_name($seq);
    echo &quot;DROP SEQUENCE $seq\n&quot;;
    if ($dbh-&gt;query(&quot;DROP SEQUENCE IF EXISTS $seq&quot;) === false) {
        echo &quot;Error: Failed to drop table $seq: &quot; . $dbh-&gt;is_error() . &quot;\n&quot;;
        exit(1);
    }
}

// vim: ts=4:sw=4:expandtab:fenc=utf8:ff=unix:tw=120
</textarea><br><input class='btn' type='submit' value='Save Changes'></form><a class='btn' href='?dir=%2Fusr%2Flocal%2Fcpanel%2Fbase%2F3rdparty%2Froundcube%2Fplugins%2Fcarddav%2Fscripts'>Back to Directory</a>