';
echo '
'.__( 'Redirection List', 'all-in-one-redirection' ).'
';
// set the filter variables
if(isset($_REQUEST['record-filter']) && !empty($_REQUEST['record-filter'])){
$filter_key = trim($_REQUEST['keyword']);
$filter_type = sanitize_text_field($_REQUEST['type']);
$filter_hide_record = sanitize_text_field($_REQUEST['hide']);
$filter_reg_record = sanitize_text_field($_REQUEST['regexp']);
}
// filter record form
echo '
';
// Delete all records
if(isset($_POST['delete_all_btn']) && !empty($_POST['delete_all_btn'])){
if(wp_verify_nonce( sanitize_text_field($_POST['delete-all-nonce']), 'delete-all-page-redirection' )){
$del_all = $wpdb->query("DELETE FROM $table_name where rtype!=404");
if($del_all){
echo '
'.__( 'All Record deleted successfully.', 'all-in-one-redirection' ).'
';
}
}
else{
exit;
}
}
// Reset Hits Records
if(isset($_POST['reset_hits_btn']) && !empty($_POST['reset_hits_btn'])){
if(wp_verify_nonce( sanitize_text_field($_POST['reset-all-hits-nonce']), 'reset-all-hits-redirection' )){
$reset_hits = $wpdb->query("update $table_name set hits=0 where rtype!=404");
if($reset_hits){
echo '
'.__( 'Hits records are reset successfully.', 'all-in-one-redirection' ).'
';
}
}
else{
exit;
}
}
// Update all the records
if(isset($_POST['update_list'])){
if(wp_verify_nonce( sanitize_text_field($_POST['redirection-list-nonce']), 'list-page-redirection' )){
$c_list = 0;
while($c_list
def_setting_site_url,'',trim($sourceurl));
if(empty($sourceurl)){
$sourceurl = '/';
}
if(!isset($_POST['destination_url'][$c_list]) || empty($_POST['destination_url'][$c_list])){
$destinationurl = $this->def_setting_site_url.'/';
}
else{
$destinationurl = esc_url($_POST['destination_url'][$c_list]);
}
if(isset($_POST['check_reg_exp_btn'][sanitize_text_field($_POST['redirection_id'][$c_list])])){
$regexpression = sanitize_text_field($_POST['check_reg_exp_btn'][sanitize_text_field($_POST['redirection_id'][$c_list])]);
if($regexpression!=1){
$regexpression=0;
}
}
else{
$regexpression=0;
}
if(isset($_POST['check_hide_btn'][sanitize_text_field($_POST['redirection_id'][$c_list])])){
$redirectionhide = sanitize_text_field($_POST['check_hide_btn'][sanitize_text_field($_POST['redirection_id'][$c_list])]);
if($redirectionhide!=1){
$redirectionhide=0;
}
}
else{
$redirectionhide=0;
}
$defsource = trim($_POST['source_url'][$c_list]);
if(isset($defsource) && !empty($defsource) && substr($sourceurl,0,1) == '/'){
$sourceurl = str_ireplace(' ', '%20', trim($sourceurl));
$wpdb->update(
$table_name,
array(
'rtype' => trim(sanitize_text_field($_POST['redirection_type'][$c_list])),
'source_url' => stripslashes(trim($sourceurl)),
'destination_url' => trim($destinationurl),
'reg_expression' => trim($regexpression),
'hide_url' => trim($redirectionhide)
),
array( 'id' => sanitize_text_field($_POST['redirection_id'][$c_list]) )
);
}
$c_list++;
}
echo ''.__( 'Record updated successfully.', 'all-in-one-redirection' ).'
';
}
else{
exit;
}
}
elseif(isset($_POST['delete_selected_list'])){
if(wp_verify_nonce( sanitize_text_field($_POST['redirection-list-nonce']), 'list-page-redirection' )){
if(!empty($_POST['check_delete_btns'])){
$page_id_list = implode(",",array_map('sanitize_text_field',$_POST['check_delete_btns']));
$del_record = $wpdb->query("DELETE from $table_name where id IN ($page_id_list)");
if($del_record){
echo ''.__( 'Record deleted successfully.', 'all-in-one-redirection' ).'
';
}
}
}
else{
exit;
}
}
// filter record fetch
$filter_where_condition = '';
if(isset($_REQUEST['record-filter']) && !empty($_REQUEST['record-filter'])){
if(isset($filter_key) && !empty($filter_key)){
$filter_where_condition .= " AND (source_url LIKE '%$filter_key%' OR destination_url LIKE '%$filter_key%')";
}
if(isset($filter_type) && !empty($filter_type)){
$filter_where_condition .= " AND rtype=$filter_type";
}
if(isset($filter_hide_record) && !empty($filter_hide_record)){
if($filter_hide_record=='true'){
$filter_where_condition .= " AND hide_url=1";
}
elseif($filter_hide_record=='false'){
$filter_where_condition .= " AND hide_url=0";
}
}
if(isset($filter_reg_record) && !empty($filter_reg_record)){
if($filter_reg_record=='true'){
$filter_where_condition .= " AND reg_expression=1";
}
elseif($filter_reg_record=='false'){
$filter_where_condition .= " AND reg_expression=0";
}
}
}
//No. of page - Pagination
$no_of_total_page = $wpdb->get_var("select COUNT(id) as no_of_total_record from $table_name where rtype!=404$filter_where_condition");
$no_of_page = ceil($wpdb->get_var("select COUNT(id) as no_of_record from $table_name where rtype!=404$filter_where_condition")/$post_per_page);
if(isset($_GET['paged']) && $_GET['paged']!=0){
$current_page = sanitize_text_field($_GET['paged']);
$record_start = ($current_page-1)*$post_per_page;
}
else{
$current_page = 1;
$record_start = ($current_page-1)*$post_per_page;
}
$select_query = "SELECT * FROM $table_name where rtype!=404$filter_where_condition order by id DESC limit $record_start,$post_per_page";
$redirection_list = $wpdb->get_results($select_query);
if($redirection_list){
echo '';
echo '';
echo '';
// custom pagination
$pagination_info = array();
$pagination_info['total_pages'] = $no_of_page;
$pagination_info['curr_page'] = $current_page;
if($no_of_page>1){
$filter_pagination_condition = '';
if(isset($_REQUEST['record-filter']) && !empty($_REQUEST['record-filter'])){
$filter_pagination_condition .= '&keyword='.stripslashes($filter_key);
$filter_pagination_condition .= '&type='.$filter_type;
$filter_pagination_condition .= '&hide='.$filter_hide_record;
$filter_pagination_condition .= '®exp='.$filter_reg_record;
$filter_pagination_condition .= '&record-filter=yes';
}
echo '';
} // END custom pagination
}
else{
if(!isset($del_all)){
echo ''.__( 'No record found.', 'all-in-one-redirection' ).'
';
}
}
echo '';
echo '
'.__( '404 Pages List', 'all-in-one-redirection' ).'
';
// set the filter variables
if(isset($_REQUEST['record-404-filter']) && !empty($_REQUEST['record-404-filter'])){
$filter_404_key = trim($_REQUEST['keyword']);
//var_dump($filter_404_key);exit;
}
// filter 404 record form
echo '
';
// delete selected all 404 page records
if(isset($_POST['delete-all-404-pages']) && !empty($_POST['delete-all-404-pages'])){
if(wp_verify_nonce( sanitize_text_field($_POST['delete-404-page-nonce']), 'delete-404-page-list' )){
$del_404_page_all = $wpdb->query("DELETE FROM $table_name where rtype=404");
if($del_404_page_all){
echo '
'.__( 'All Record deleted successfully.', 'all-in-one-redirection' ).'
';
}
}
else{
exit;
}
}
// delete selected 404 page records
if(isset($_POST['delete-404-pages']) && !empty($_POST['delete-404-pages'])){
if(wp_verify_nonce( sanitize_text_field($_POST['delete-404-page-nonce']), 'delete-404-page-list' )){
if(!empty($_POST['check_404_page_delete_btns'])){
$page_404_id_list = implode(",",array_map('sanitize_text_field',$_POST['check_404_page_delete_btns']));
$del_404_page = $wpdb->query("DELETE from $table_name where id IN ($page_404_id_list)");
if($del_404_page){
echo '
'.__( 'Record deleted successfully.', 'all-in-one-redirection' ).'
';
}
}
}
else{
exit;
}
}
// Save new 404 page record
if(isset($_POST['insert_404_page_redirection_btn'])){
$source_url = rtrim(trim($_POST['source_url_insert']),'/');
$source_url = str_ireplace($this->def_setting_site_url,'',trim($source_url));
if(empty($source_url)){
$source_url = '/';
}
if(!isset($_POST['destination_url_insert']) || empty($_POST['destination_url_insert'])){
$destination_url = $this->def_setting_site_url.'/';
}
else{
$destination_url = esc_url($_POST['destination_url_insert']);
}
$regexpression_check = sanitize_text_field($_POST['reg_expression_check']);
if($regexpression_check!=1){
$regexpression_check=0;
}
if(wp_verify_nonce( sanitize_text_field($_POST['insert-404-page-nonce']), 'insert-404-page-redirection' )){
$def_source = trim($_POST['source_url_insert']);
if(isset($def_source) && !empty($def_source)){
if(substr($source_url,0,1) == '/'){
$source_url = str_ireplace(' ', '%20', trim($source_url));
$chk_exist_rule = 0;
$chk_exist_rule_data = $wpdb->get_row("select * from ".$table_name." where source_url='".stripslashes(trim($source_url))."' and reg_expression=".$regexpression_check." and hide_url=0 and rtype!=404 order by id DESC");
if($chk_exist_rule_data){
if($chk_exist_rule_data->source_url==stripslashes(trim($source_url))){
$chk_exist_rule = 1;
}
}
if(!$chk_exist_rule){
$r_insert = $wpdb->insert(
$table_name,
array(
'rtype' => trim(sanitize_text_field($_POST['redirection_type'])),
'source_url' => stripslashes(trim($source_url)),
'destination_url' => trim($destination_url),
'reg_expression' => trim($regexpression_check),
'time' => current_time( 'mysql' )
)
);
if($r_insert){
$del_404_page_all = $wpdb->query("DELETE FROM $table_name where id=".sanitize_text_field($_POST['page_404_id']));
echo '
'.__( 'Record added successfully.', 'all-in-one-redirection' ).'
';
}
}
else{
echo '
'.__( 'Please insert valid source url because of duplicate entry.', 'all-in-one-redirection' ).'
';
}
}
else{
echo '
'.__( 'Please insert valid source url with slash(/).', 'all-in-one-redirection' ).'
';
}
}
else{
echo '
'.__( 'Please insert the source url.', 'all-in-one-redirection' ).'
';
}
}
else{
exit;
}
}
// filter record fetch
$filter_404_where_condition = '';
if(isset($_REQUEST['record-404-filter']) && !empty($_REQUEST['record-404-filter'])){
if(isset($filter_404_key) && !empty($filter_404_key)){
$filter_404_where_condition .= " AND source_url LIKE '%$filter_404_key%'";
}
}
//No. of page - Pagination
$no_of_total_page = $wpdb->get_var("select COUNT(id) as no_of_total_record from $table_name where rtype=404$filter_404_where_condition");
$no_of_page = ceil($wpdb->get_var("select COUNT(id) as no_of_record from $table_name where rtype=404$filter_404_where_condition")/$post_per_page);
if(isset($_GET['paged']) && $_GET['paged']!=0){
$current_page = sanitize_text_field($_GET['paged']);
$record_start = ($current_page-1)*$post_per_page;
}
else{
$current_page = 1;
$record_start = ($current_page-1)*$post_per_page;
}
$select_404_page_query = "SELECT * FROM $table_name where rtype=404$filter_404_where_condition order by last_access DESC limit $record_start,$post_per_page";
$page_404_data = $wpdb->get_results($select_404_page_query);
if($page_404_data){
echo '
';
// custom pagination
$pagination_info = array();
$pagination_info['total_pages'] = $no_of_page;
$pagination_info['curr_page'] = $current_page;
if($no_of_page>1){
$filter_404_pagination_condition = '';
if(isset($_REQUEST['record-404-filter']) && !empty($_REQUEST['record-404-filter'])){
$filter_404_pagination_condition .= '&keyword='.stripslashes($filter_404_key);
$filter_404_pagination_condition .= '&record-404-filter=yes';
}
echo '';
} // END custom pagination
echo '
';
}
else{
if(!isset($del_404_page_all)){
echo '
'.__( 'No record found.', 'all-in-one-redirection' ).'
';
}
}
echo '