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); }