#!/usr/local/bin/perl # Drops multiple databases require './mysql-lib.pl'; &ReadParse(); &error_setup($text{'ddrops_err'}); @dbs = split(/\0/, $in{'d'}); @dbs || &error($text{'ddrops_enone'}); $access{'delete'} || &error($text{'ddrops_ecannot'}); foreach $db (@dbs) { &can_edit_db($db) || &error(&text('ddrops_ecannotdb', $db)); } $access{'edonly'} && &error($text{'dbase_ecannot'}); if ($in{'confirm'}) { # Drop the databases foreach $db (@dbs) { &execute_sql_logged($master_db,"drop database "."estr($db)); } &webmin_log("delete", "dbs", scalar(@dbs), \%in); &redirect(""); } else { # Ask the user if he is sure.. &ui_print_header(undef, $text{'ddrops_title'}, ""); $rows = 0; $tables = 0; foreach $db (@dbs) { @tables = &list_tables($db); foreach $t (@tables) { $d = &execute_sql($db, "select count(*) from "."estr($t)); $rows += $d->{'data'}->[0]->[0]; $tables++; } } print "
\n"; print "