ChronoFormsAdmin::copy_form(); break; case "add": case "edit": ChronoFormsAdmin::edit_form(); break; case "save": case "apply": ChronoFormsAdmin::save_form($task); break; case "create_table": case "save_table": ChronoFormsAdmin::create_table($task); break; case "list_data": ChronoFormsAdmin::list_data($task); break; case "show_data": ChronoFormsAdmin::show_data($task); break; case "delete_data": ChronoFormsAdmin::delete_data($task); break; case "publish": case "unpublish": ChronoFormsAdmin::publish($task); break; case "validatelicense": ChronoFormsAdminVersion::validatelicense($task); break; case "backup_forms":
function delete_data() { $mainframe =& JFactory::getApplication(); $database =& JFactory::getDBO(); if (isset($_POST['table_name']) && !empty($_POST['table_name']) || isset($_GET['table_name']) && !empty($_GET['table_name'])) { $table_name = isset($_POST['table_name']) ? $_POST['table_name'] : $_GET['table_name']; //load some table data $result = $database->getTableFields(array($table_name), false); $table_fields = $result[$table_name]; $primary = ''; foreach ($table_fields as $table_field => $field_data) { if ($field_data->Key == 'PRI') { $primary = $table_field; } } if (empty($primary)) { JError::raiseWarning(100, "No table key found."); $mainframe->redirect("index.php?option=com_chronoforms"); } //delete the form with all its actions if (isset($_POST['cb']) && !empty($_POST['cb'])) { foreach ($_POST['cb'] as $r_id) { $database->setQuery("DELETE FROM " . $table_name . " WHERE `" . $primary . "` = '" . $r_id . "'"); if (!$database->query()) { JError::raiseWarning(100, $database->getErrorMsg()); $mainframe->redirect("index.php?option=com_chronoforms"); } } } } else { JError::raiseWarning(100, "Table doesn't exist!"); $mainframe->redirect("index.php?option=com_chronoforms"); } unset($_POST['cb']); ChronoFormsAdmin::list_data(); //$mainframe->redirect("index.php?option=com_chronoforms&task=list_data&table_name=".$table_name, "Deleted successfully."); }