_( 'Color setting'), 'second' => _( 'AHAbook option') ); $page = wp_unslash($_SERVER['QUERY_STRING']); echo $setting->aha_menu_tab($_GET , $tabs, $page) ; $categories= $setting->aha_main_cruls(); $price_paypal= $setting->aha_price(); $getTab = isset($_GET['tab']) ? sanitize_text_field($_GET['tab']) : NULL; $checkboxG3Post = isset($_POST['checkboxG3']) ? wp_unslash($_POST['checkboxG3']) : NULL; $categoriesPost = isset($_POST['categories']) ? wp_unslash($_POST['categories']) : NULL; $end_of_ahaPost = isset($_POST['end_of_aha']) ? sanitize_text_field($_POST['end_of_aha']) : NULL; $updatePost = isset($_POST['Update']) ? sanitize_text_field($_POST['Update']) : NULL; $tex_id = isset($_GET['tex_id']) ? intval($_GET['tex_id']) : NULL; $id = isset($_GET['id']) ? sanitize_text_field($_GET['id']) : NULL; $get = (isset($getTab) && $getTab != '' ? $getTab : 'first' ); global $wpdb; $prefix = $wpdb->prefix; if($tex_id != NULL){ $wpdb->update($prefix.'aha_stg', array('show_powered' => 1), array('id_wid'=>$id)); $wpdb->update($prefix.'aha_key', array('payment_txid' => $tex_id), array('id'=>$id)); } $check_payment = $wpdb->get_results( 'SELECT `payment_txid` FROM '.$prefix.'aha_key WHERE id=1'); $resultz = $wpdb->get_results( 'SELECT * FROM '.$prefix.'aha_api WHERE id='.$id); if(!empty($resultz)){ $key = ($resultz[0]->api_key != '' ? $resultz[0]->api_key : '' ); } $data = $wpdb->get_results( "SELECT * FROM ".$prefix."aha_color WHERE id_wid = '".$id."'" ); $data_aha = $wpdb->get_results( "SELECT * FROM ".$prefix."aha_stg WHERE id_wid = '".$id."'" ); if($tex_id != NULL){ $wpdb->update($prefix.'aha_stg', array('show_powered' => 1), array('id_wid'=>$id)); } $nonce = isset($_REQUEST['submit_aha_setting']) ? sanitize_text_field($_REQUEST['submit_aha_setting']) : ''; if(wp_verify_nonce($nonce, 'action_aha_setting')) { if($data == NULL){ $aha_post_b_color = isset($_POST['b_color']) ? sanitize_text_field($_POST['b_color']) : NULL; if(isset($aha_post_b_color) && $aha_post_b_color != NULL){ $wpdb->insert($prefix.'aha_color' ,array( 'id_wid' => $id, 'b_color' => $aha_post_b_color, 't_color' => sanitize_text_field($_POST['t_color']), 'text_color' => sanitize_text_field($_POST['text_color']), 's_color' => sanitize_text_field($_POST['s_color']), 'button_color' => sanitize_text_field($_POST['button_color']), 'active' => sanitize_text_field($_POST['active']) )); } $widthPost = isset($_POST['width']) ? sanitize_text_field($_POST['width']) : NULL; if(isset($widthPost) && $widthPost != NULL){ $wpdb->insert($prefix.'aha_color' ,array( 'id_wid' => $id, 'width' => $widthPost, 'height' => sanitize_text_field($_POST['height']), 'font' => sanitize_text_field($_POST['font']), 'share_btn' => sanitize_text_field($_POST['share_btn']), 'power_btn' => sanitize_text_field($_POST['power_btn']), 'next_pre' => sanitize_text_field($_POST['next_pre']), 'active_s' => sanitize_text_field($_POST['active_s']), 'position' => sanitize_text_field($_POST['position']) )); $updatePost = sanitize_text_field($_POST['Update']); if( isset($updatePost) && $updatePost == 'Update'){ ?> update($prefix.'aha_color', $datass, array('id_wid'=>$id)); } if(isset($widthPost) && $widthPost != NULL){ $wpdb->update($prefix.'aha_color', $datass, array('id_wid'=>$id)); } if( isset($updatePost) && $updatePost == 'Update'){ ?> categories) ; $cats_lab = isset($categoriesPost) ? $categoriesPost : $checkboxG3 ; $cats_lab = json_encode($cats_lab); if($_POST['end_of_aha'] != NULL){ $wpdb->insert($prefix.'aha_stg' ,array( 'id_wid' => $id, 'end_of_aha' => $end_of_ahaPost, 'categories' => $cats_lab, 'end_book' => sanitize_text_field($_POST['end_book']), 'show_powered' => sanitize_text_field($_POST['show_powered']), 'maximum_share' => sanitize_text_field($_POST['maximum_share']), 'max_count' => sanitize_text_field($_POST['maximum_share']), 'shows' => sanitize_text_field($_POST['shows']), 'limit_a' => sanitize_text_field($_POST['limit_a']), 'limit_c' => sanitize_text_field($_POST['limit_c']), 'limit_l' => sanitize_text_field($_POST['limit_l']) )); } if( isset($updatePost) && $updatePost == 'Update'){ ?> categories) ; $cats_lab = isset($categoriesPost) ? $categoriesPost : $checkboxG3 ; $cats_lab = json_encode($cats_lab); $wpdb->update($prefix.'aha_stg', array( 'end_of_aha' => $end_of_ahaPost, 'categories' => $cats_lab, 'show_powered' => sanitize_text_field($_POST['show_powered']), 'end_book' => intval($_POST['end_book']), 'maximum_share' => intval($_POST['maximum_share']), 'limit_a' => intval($_POST['limit_a']), 'limit_c' => intval($_POST['limit_c']), 'limit_l' => intval($_POST['limit_l']), 'shows' => sanitize_text_field($_POST['shows'])), array('id_wid'=>$id) ); if( isset($updatePost) && $updatePost == 'Update'){ ?>