function show_delete()
{
global $wpdb;
if (isset($_POST['confirm_mass_delete']) and $_POST['confirm_mass_delete'] == 'yes') {
$specific_form = false;
$where = "WHERE 1";
// Configure the Where clause depending on posted data.
if (isset($_POST['date_from']) and isset($_POST['date_to'])) {
$timestamp_from = $this->output_date($_POST['date_from'], false);
$timestamp_to = $this->output_date($_POST['date_to'], true);
$where .= " AND timestamp > '{$timestamp_from}' AND timestamp < '{$timestamp_to}'";
}
if (isset($_POST['form_id']) and $_POST['form_id'] != "" and preg_match('#^[0-9]+$#isU', $_POST['form_id'])) {
$form_id = addslashes(trim($_POST['form_id']));
$specific_form = true;
$where .= " AND form_id = '" . $form_id . "'";
}
if (isset($_POST['form_id']) and $_POST['form_id'] == "orphaned") {
$sql = 'SELECT id FROM ' . FORMBUILDER_TABLE_FORMS . ' ORDER BY name ASC;';
$forms = $wpdb->get_results($sql, ARRAY_A);
$allFormIDs = array();
foreach ($forms as $form) {
$allFormIDs[] = $form['id'];
}
$specific_form = true;
$where .= " AND form_id NOT IN (" . implode(',', $allFormIDs) . ") ";
}
$sql = "DELETE FROM " . FORMBUILDER_TABLE_RESULTS . " {$where};";
$result = $wpdb->query($sql);
if ($result === false) {
formbuilder_admin_alert('Error: For some reason, we were not able to mass delete the selected messages. Tried to run sql code: ' . $sql);
} else {
formbuilder_admin_alert('Successfully deleted ' . $result . ' records.');
}
} elseif (isset($_POST['date_from'])) {
formbuilder_admin_alert('You failed to confirm that you wanted to delete the indicated messages. Mass Delete Aborted.');
return;
}
?>
<?php
formbuilder_admin_nav('formResults');
?>
<fieldset class="options metabox-holder">
<div class="info-box-formbuilder postbox">
<h3 class="info-box-title hndle"><font color="red"><?php
_e('Mass Delete:', 'formbuilder');
?>
</font> </h3>
<div class="fbxml-form-export inside">
<form action='' method='POST'>
<?php
_e('Please select the date range you wish to delete messages from:', 'formbuilder');
?>
<br/><br/>
<?php
_e('From:', 'formbuilder');
?>
<?php
$this->input_date('date_from', date(STD_DATE, time() - 3600 * 24 * 30));
?>
<br/>
<?php
_e('To:', 'formbuilder');
?>
<?php
$this->input_date('date_to', date(STD_DATE, time()));
?>
<br/><br/>
<?php
_e('Select the form(s) from which you would like to delete messages:', 'formbuilder');
?>
<br/>
<select name='form_id'>
<option value=''><?php
_e('All Forms', 'formbuilder');
?>
</option>
<?php
$sql = 'SELECT * FROM ' . FORMBUILDER_TABLE_FORMS . ' ORDER BY name ASC;';
$forms = $wpdb->get_results($sql, ARRAY_A);
$allFormIDs = array();
foreach ($forms as $form) {
$allFormIDs[] = $form['id'];
$selected = "";
if (isset($_GET['form_id']) and $_GET['form_id'] == $form['id']) {
$selected = "selected='selected'";
}
$sql = "SELECT id FROM " . FORMBUILDER_TABLE_RESULTS . " WHERE form_id = '" . $form['id'] . "';";
$result = $wpdb->get_col($sql, ARRAY_A);
$total_rows = count($result);
echo "<option value='" . $form['id'] . "' {$selected}>" . $form['name'] . "(" . $total_rows . ")</option>";
}
// Figure out how many orphaned forms there are.
$selected = "";
if (isset($_GET['form_id']) and $_GET['form_id'] == "orphaned") {
$selected = "selected='selected'";
}
$sql = "SELECT id FROM " . FORMBUILDER_TABLE_RESULTS . " WHERE form_id NOT IN (" . implode(',', $allFormIDs) . ");";
$result = $wpdb->get_col($sql, ARRAY_A);
$total_rows = count($result);
?>
<option value='orphaned' <?php
echo $selected;
?>
><?php
_e('Orphaned Forms', 'formbuilder');
?>
(<?php
echo $total_rows;
?>
)</option>
</select><br/><br/>
<input type="checkbox" name="confirm_mass_delete" value="yes" /> <font color="red"><strong><?php
_e('Check the box to confirm you wish to mass delete the messages indicated above.');
?>
</strong></font><br/><br/>
<input type='submit' name='Submit' value='<?php
_e('Mass Delete', 'formbuilder');
?>
' />
</form>
</div>
</div>
</fieldset>
<?php
}
/**
* Contains the actual code for running the install.
*/
function formbuilder_createTables()
{
global $wpdb;
$charset_collate = formbuilder_getCharSet();
formbuilder_admin_alert('Creating necessary FormBuilder tables.', '');
$error_status = false;
// Run the table creation querys.
$sql = "CREATE TABLE IF NOT EXISTS `" . FORMBUILDER_TABLE_FIELDS . "` (\n `id` bigint(20) NOT NULL auto_increment,\n `form_id` bigint(20) NOT NULL default '0',\n `display_order` int(11) NOT NULL default '0',\n `field_type` varchar(255) NOT NULL default '',\n `field_name` varchar(255) NOT NULL default '',\n `field_value` text NOT NULL,\n `field_label` text NOT NULL,\n `required_data` varchar(255) NOT NULL default '',\n `error_message` text NOT NULL,\n `help_text` text NOT NULL,\n UNIQUE KEY `id` (`id`)\n) {$charset_collate};";
$result = $wpdb->query($sql);
if ($result === false) {
formbuilder_admin_alert("Failed running query: {$sql}");
$error_status = true;
}
$sql = "CREATE TABLE IF NOT EXISTS `" . FORMBUILDER_TABLE_FORMS . "` (\n `id` bigint(20) NOT NULL auto_increment,\n `name` varchar(255) NOT NULL default '',\n `subject` text NOT NULL,\n `recipient` text NOT NULL,\n `method` enum('POST','GET') NOT NULL default 'POST',\n `action` varchar(255) NOT NULL default '',\n `thankyoutext` text NOT NULL,\n `autoresponse` bigint(20) NOT NULL default '0',\n UNIQUE KEY `id` (`id`)\n) {$charset_collate};";
$result = $wpdb->query($sql);
if ($result === false) {
formbuilder_admin_alert("Failed running query: {$sql}");
$error_status = true;
}
$sql = "CREATE TABLE IF NOT EXISTS `" . FORMBUILDER_TABLE_PAGES . "` (\n `id` bigint(20) NOT NULL auto_increment,\n `post_id` bigint(20) NOT NULL default '0',\n `form_id` bigint(20) NOT NULL default '0',\n UNIQUE KEY `id` (`id`)\n) {$charset_collate};";
$result = $wpdb->query($sql);
if ($result === false) {
formbuilder_admin_alert("Failed running query: {$sql}");
$error_status = true;
}
$sql = "CREATE TABLE IF NOT EXISTS `" . FORMBUILDER_TABLE_RESPONSES . "` (\n `id` bigint(20) NOT NULL auto_increment,\n `name` varchar(255) NOT NULL default '',\n `subject` text NOT NULL,\n `message` text NOT NULL,\n `from_name` varchar(255) NOT NULL default '',\n `from_email` varchar(255) NOT NULL default '',\n PRIMARY KEY (`id`)\n) {$charset_collate};";
$result = $wpdb->query($sql);
if ($result === false) {
formbuilder_admin_alert("Failed running query: {$sql}");
$error_status = true;
}
$sql = "CREATE TABLE IF NOT EXISTS `" . FORMBUILDER_TABLE_RESULTS . "` (\n `id` bigint(20) unsigned zerofill NOT NULL auto_increment,\n `form_id` bigint(20) unsigned zerofill NOT NULL default '00000000000000000000',\n `timestamp` bigint(20) unsigned zerofill NOT NULL,\n `xmldata` longtext NOT NULL,\n PRIMARY KEY (`id`),\n KEY `form_id` (`form_id`,`timestamp`)\n) {$charset_collate};";
$result = $wpdb->query($sql);
if ($result === false) {
formbuilder_admin_alert("Failed running query: {$sql}");
$error_status = true;
}
$sql = "CREATE TABLE IF NOT EXISTS `" . FORMBUILDER_TABLE_TAGS . "` (\n `id` bigint(20) NOT NULL AUTO_INCREMENT,\n `form_id` bigint(20) NOT NULL,\n `tag` varchar(255) NOT NULL,\n PRIMARY KEY (`id`),\n KEY `form_id` (`form_id`)\n) {$charset_collate};";
$result = $wpdb->query($sql);
if ($result === false) {
formbuilder_admin_alert("Failed running query: {$sql}");
$error_status = true;
}
return !$error_status;
}
function formbuilder_options_removeResponse($response_id)
{
global $wpdb;
if (!formbuilder_user_can('create')) {
formbuilder_admin_alert('You do not have permission to access this area.');
return;
}
$wpdb->query("DELETE FROM " . FORMBUILDER_TABLE_RESPONSES . " WHERE id = '" . $response_id . "';");
}
function formbuilder_admin_nav($selected = 'forms')
{
global $formbuilder_admin_nav_options;
?>
<?php
if (isset($_GET['fbmsg']) and $_GET['fbmsg'] != "") {
formbuilder_admin_alert(stripslashes($_GET['fbmsg']));
}
?>
<div class="formbuilder-subnav">
<ul class="subsubsub">
<?php
foreach ($formbuilder_admin_nav_options as $key => $value) {
?>
<li><a <?php
if ($selected == $key) {
?>
class="current"<?php
}
?>
href="<?php
echo FB_ADMIN_PLUGIN_PATH;
?>
&fbaction=<?php
echo $key;
?>
"><?php
echo $value;
?>
</a> |</li>
<?php
}
?>
<li><a href="http://truthmedia.com/category/formbuilder/"><?php
_e("Blog", 'formbuilder');
?>
</a> |</li>
<li><a href="http://truthmedia.com/wordpress/formbuilder/documentation"><?php
_e("Documentation", 'formbuilder');
?>
</a></li>
</ul>
</div>
<?php
}
function formbuilder_options_strings()
{
global $wpdb, $formbuilder_admin_nav_options;
if (!formbuilder_user_can('manage')) {
formbuilder_admin_alert('You do not have permission to access this area.');
return;
}
$formBuilderTextStrings = formbuilder_load_strings();
if (isset($_POST['formbuilder_reset_all_text_strings']) and $_POST['formbuilder_reset_all_text_strings'] == 'yes') {
delete_option('formbuilder_text_strings');
$formBuilderTextStrings = formbuilder_load_strings();
} elseif ($_POST) {
foreach ($formBuilderTextStrings as $key => $value) {
if ($_POST[$key]) {
$formBuilderTextStrings[$key] = htmlentities(stripslashes($_POST[$key]), ENT_QUOTES, get_option('blog_charset'));
}
update_option('formbuilder_text_strings', $formBuilderTextStrings);
}
}
$relative_path = FORMBUILDER_PLUGIN_URL;
include FORMBUILDER_PLUGIN_PATH . "html/options_strings.inc.php";
}
<?php
$fb_permissions = get_option('formbuilder_permissions');
if (isset($_POST['permissions_save']) or isset($_POST['formbuilder_permissions'])) {
$p = $_POST['formbuilder_permissions'];
foreach ($fb_permissions as $level => $cap_a) {
foreach ($cap_a as $cap => $value) {
if (isset($p[$level][$cap]) and $p[$level][$cap] == 'yes') {
$fb_permissions[$level][$cap] = 'yes';
} else {
$fb_permissions[$level][$cap] = 'no';
}
}
}
$fb_permissions['level_10']['manage'] = 'yes';
update_option('formbuilder_permissions', $fb_permissions);
formbuilder_admin_alert(__('Saved new permissions settings.'));
}
?>
<h3 class='info-box-title hndle'><?php
_e('Permissions Configuration:', 'formbuilder');
?>
</h3>
<div class="inside">
<p><?php
_e('You can use these controls to determine what user levels are allowed to access various components of FormBuilder.', 'formbuilder');
?>
</p>
<form action="<?php
echo FB_ADMIN_PLUGIN_PATH;
?>
function formbuilder_admin_nav($selected = 'forms')
{
$formbuilder_nav_options = formbuilder_get_admin_nav_options();
?>
<?php
if (isset($_GET['fbmsg']) and $_GET['fbmsg'] != "") {
formbuilder_admin_alert(stripslashes($_GET['fbmsg']));
}
?>
<div class="formbuilder-subnav">
<ul class="subsubsub">
<?php
foreach ($formbuilder_nav_options as $key => $value) {
?>
<li><a <?php
if ($selected == $key) {
?>
class="current"<?php
}
?>
href="<?php
echo FB_ADMIN_PLUGIN_PATH;
?>
&fbaction=<?php
echo $key;
?>
"><?php
echo $value;
?>
</a> |</li>
<?php
}
?>
<?php
do_action('formbuilder_display_nav');
?>
<li><a href="http://www.warkensoft.com/wordpress/formbuilder/documentation"><?php
_e("Documentation", 'formbuilder');
?>
</a></li>
</ul>
</div>
<?php
}
