/** * This file is a part of MyWebSQL package * * @file: modules/dbbatch.php * @author Samnan ur Rehman * @copyright (c) 2008-2014 Samnan ur Rehman * @web http://mywebsql.net * @license http://mywebsql.net/license */ function processRequest(&$db) { if (v($_REQUEST["id"]) == 'batch') { $stats = array(); $commands = array(); if (v($_POST['skip_fkey']) == "on") { $db->set_constraint('fkey', false); } // generate commands first before doing drop operations if (v($_POST['command']) != '') { $commands = generate_commands($db, v($_POST['command'])); } if (v($_POST['dropcmd']) == 'on') { $stats['drop'] = drop_objects($db); } else { if (v($_POST['old_prefix']) != '') { $stats['delprefix'] = remove_prefix($db, v($_POST['old_prefix'])); } if (v($_POST['new_prefix']) != '') { $stats['addprefix'] = add_prefix($db, v($_POST['new_prefix'])); } } $replace = array(); $data = array('stats' => $stats, 'queries' => $commands); echo view('dbbatch_results', $replace, $data); } else { $object_list = $db->getObjectList(); $replace = array(); $folder = $db->name(); echo view(array($folder . '/dbbatch', 'dbbatch'), $replace, $object_list); } }
/** * This file is a part of MyWebSQL package * * @file: modules/databases.php * @author Samnan ur Rehman * @copyright (c) 2008-2012 Samnan ur Rehman * @web http://mywebsql.net * @license http://mywebsql.net/license */ function processRequest(&$db) { $folder = Session::get('db', 'driver'); $data = array(); if (v($_REQUEST["id"]) == 'batch') { $stats = array(); $stats['drop'] = drop_objects($db); $replace = array(); $data['stats'] = $stats; $data['objects'] = $db->getDatabases(); echo view(array($folder . '/databases', 'databases'), $replace, $data); } else { $replace = array(); $data['objects'] = $db->getDatabases(); echo view(array($folder . '/databases', 'databases'), $replace, $data); } }