function display_form_lists() { global $wpdb; $where = ''; $sort["custom_style"] = ""; $sort["1_or_2"] = ""; $order = ""; $sort["default_style"] = ""; $sort["sortid_by"] = ''; if (isset($_POST['page_number'])) { if ($_POST['asc_or_desc']) { $sort["sortid_by"] = $wpdb->escape($_POST['order_by']); if ($_POST['asc_or_desc'] == 1) { $sort["custom_style"] = "manage-column column-title sorted asc"; $sort["1_or_2"] = "2"; $order = "ORDER BY " . $sort["sortid_by"] . " ASC"; } else { $sort["custom_style"] = "manage-column column-title sorted desc"; $sort["1_or_2"] = "1"; $order = "ORDER BY " . $sort["sortid_by"] . " DESC"; } } if ($_POST['page_number']) { $limit = ((int) $_POST['page_number'] - 1) * 20; } else { $limit = 0; } } else { $limit = 0; } if (isset($_POST['search_events_by_title'])) { $search_tag = esc_html($_POST['search_events_by_title']); } else { $search_tag = ""; } if ($search_tag) { $where = ' WHERE title LIKE "%' . $search_tag . '%"'; $where .= " AND `id` NOT IN(" . get_option('contact_form_forms', 0) . ")"; } else { $where = " WHERE `id` NOT IN(" . get_option('contact_form_forms', 0) . ")"; } // Get the total number of records. $query = "SELECT COUNT(*) FROM " . $wpdb->prefix . "formmaker" . $where; $total = $wpdb->get_var($query); $pageNav['total'] = $total; $pageNav['limit'] = $limit / 20 + 1; $query = "SELECT * FROM " . $wpdb->prefix . "formmaker" . $where . " " . $order . " " . " LIMIT " . $limit . ",20"; $rows = $wpdb->get_results($query); $old_version = FALSE; foreach ($rows as $row) { if (strpos($row->form, "wdform_table1") === FALSE) { $old_version = TRUE; break; } } $can_update_form = TRUE; if ($old_version) { $old_n = 0; foreach ($rows as $row) { $count_words_in_form = count(explode("_element_section", $row->form)) - count(explode("and_element_section", $row->form)); if (!(strpos($row->form, "type_map") === FALSE)) { $can_update_form = FALSE; break; } if (!(strpos($row->form, "type_file") === FALSE)) { $can_update_form = FALSE; break; } if ($count_words_in_form > 5) { $can_update_form = FALSE; break; } if (strpos($row->form, "wdform_table1") === FALSE) { $old_n++; } } @session_start(); $_SESSION['all_updates'] = $old_n; $_SESSION['current_updates'] = 0; } html_display_form_lists($rows, $pageNav, $sort, $old_version, $can_update_form); }
function display_form_lists() { global $wpdb; $sort["default_style"] = "manage-column column-autor sortable desc"; $sort["sortid_by"] = ""; if (isset($_POST['page_number'])) { if ($_POST['asc_or_desc']) { $sort["sortid_by"] = $wpdb->escape($_POST['order_by']); if ($_POST['asc_or_desc'] == 1) { $sort["custom_style"] = "manage-column column-title sorted asc"; $sort["1_or_2"] = "2"; $order = "ORDER BY " . $sort["sortid_by"] . " ASC"; } else { $sort["custom_style"] = "manage-column column-title sorted desc"; $sort["1_or_2"] = "1"; $order = "ORDER BY " . $sort["sortid_by"] . " DESC"; } } else { $order = ""; } if ($_POST['page_number']) { $limit = ((int) $_POST['page_number'] - 1) * 20; } else { $limit = 0; } } else { $order = ""; $limit = 0; } if (isset($_POST['search_events_by_title'])) { $search_tag = esc_html($_POST['search_events_by_title']); } else { $search_tag = ""; } if ($search_tag) { $where = ' WHERE title LIKE "%' . $search_tag . '%"'; } else { $where = ""; } get_option('contact_form_forms'); if (get_option('contact_form_forms') != '') { if ($where) { $where .= ' AND `id` IN (' . get_option('contact_form_forms') . ')'; } else { $where .= ' WHERE `id` IN (' . get_option('contact_form_forms') . ')'; } } else { if ($where) { $where .= ' AND `id` IN (0)'; } else { $where .= ' WHERE `id` IN (0)'; } } // get the total number of records $query = "SELECT COUNT(*) FROM " . $wpdb->prefix . "formmaker" . $where; $total = $wpdb->get_var($query); $pageNav['total'] = $total; $pageNav['limit'] = $limit / 20 + 1; $query = "SELECT * FROM " . $wpdb->prefix . "formmaker" . $where . " " . $order . " " . " LIMIT " . $limit . ",20"; $rows = $wpdb->get_results($query); $old_version = false; foreach ($rows as $row) { if (strpos($row->form, "wdform_table1") === false) { $old_version = true; break; } } if ($old_version) { $old_n = 0; foreach ($rows as $row) { if (strpos($row->form, "wdform_table1") === false) { $old_n++; } } @session_start(); $_SESSION['all_updates'] = $old_n; $_SESSION['current_updates'] = 0; } html_display_form_lists($rows, $pageNav, $sort, $old_version); }