public function update_db()
{
global $wpdb;
$id = isset($_POST['current_id']) ? (int) esc_html(stripslashes($_POST['current_id'])) : 0;
$title = isset($_POST['title']) ? esc_html(stripslashes($_POST['title'])) : '';
$css = isset($_POST['css']) ? stripslashes(preg_replace("/(^[\r\n]*|[\r\n]+)[\\s\t]*[\r\n]+/", "\n", $_POST['css'])) : '';
$default = isset($_POST['default']) ? esc_html(stripslashes($_POST['default'])) : 0;
$save = $wpdb->update($wpdb->prefix . 'formmaker_themes', array('title' => $title, 'css' => $css, 'default' => $default), array('id' => $id));
if ($save !== FALSE) {
echo WDW_FMC_Library::message('Item Succesfully Saved.', 'updated');
} else {
echo WDW_FMC_Library::message('Error. Please install plugin again.', 'error');
}
}
public function unblock_ip()
{
global $wpdb;
$flag = FALSE;
$form_id = isset($_POST['form_id']) && esc_html($_POST['form_id']) != '' ? esc_html($_POST['form_id']) : 0;
$cid = isset($_POST['post']) && $_POST['post'] != '' ? $_POST['post'] : NULL;
if (count($cid)) {
array_walk($cid, create_function('&$value', '$value = (int)$value;'));
$cids = implode(',', $cid);
$query = 'SELECT * FROM ' . $wpdb->prefix . 'formmaker_submits WHERE group_id IN ( ' . $cids . ' )';
$rows = $wpdb->get_results($query);
foreach ($rows as $row) {
$flag = TRUE;
$ips = $wpdb->get_var($wpdb->prepare('SELECT ip FROM ' . $wpdb->prefix . 'formmaker_blocked WHERE ip="%s"', $row->ip));
if ($ips) {
$wpdb->query($wpdb->prepare('DELETE FROM ' . $wpdb->prefix . 'formmaker_blocked WHERE ip="%s"', $ips));
}
}
}
if ($flag) {
echo WDW_FMC_Library::message('IPs Succesfully Unblocked.', 'updated');
} else {
echo WDW_FMC_Library::message('You must select at least one item.', 'error');
}
$this->display($form_id);
}
