escape(sanitizeData(trim($_REQUEST['new_status']),'xss_clean')) : ''; if($update_status=='Update' && $new_status!="") { if($check_approve_profile_status->setting_status=='Y') { // if Profile approve status is Y then Profile Automatically Approved. $wpdb->query("UPDATE $dsp_user_profiles SET my_status= '$new_status' WHERE user_id = $current_user->ID"); $status_approval_message=language_code('DSP_UPDATE_STATUS_MESSAGE'); dsp_add_news_feed($current_user->ID,'status'); dsp_add_notification($current_user->ID,0,'status'); } else { $wpdb->query("UPDATE $dsp_user_profiles SET my_status= '$new_status' ,status_id=0 WHERE user_id = $current_user->ID"); $status_approval_message=language_code('DSP_STATUS_UPDATE_IN_HOURS_MSG'); } } ///////////////////////////end status update/////////////////////// if(isset($_REQUEST['Action']) && $_REQUEST['Action'] == 'update') { $stealth_mode_id=isset($_REQUEST['smid']) ? $_REQUEST['smid'] : ''; $smode=isset($_REQUEST['smode']) ? $_REQUEST['smode'] : ''; if($smode == 'Y') { $wpdb->query("UPDATE $dsp_user_profiles SET stealth_mode= 'N' WHERE user_id = $stealth_mode_id"); }else { $wpdb->query("UPDATE $dsp_user_profiles SET stealth_mode= 'Y' WHERE user_id = $stealth_mode_id"); } } $exist_profile_details = $wpdb->get_row("SELECT * FROM $dsp_user_profiles WHERE user_id = '$current_user->ID'"); $profile_user_id=$exist_profile_details->user_id; $count_online_member=$wpdb->get_var("SELECT COUNT(distinct oln.user_id) FROM $tbl_name oln INNER JOIN $dsp_user_profiles usr ON ( usr.user_id = oln.user_id ) WHERE oln.status = 'Y' AND usr.country_id !=0 AND usr.stealth_mode = 'N'"); ?>
    get_row("SELECT * FROM $dsp_payments_table WHERE pay_user_id=$user_id"); $count_payment_row=count($payment_row); if($count_payment_row>0){ $now = time(); // or your date as well $your_date = strtotime($payment_row->expiration_date); $datediff = $your_date - $now; $days=floor($datediff/(60*60*24)); ?>
get_var("SELECT COUNT(*) FROM $dsp_user_profiles WHERE user_id=$current_user->ID"); if($num_rows!=0){?>
setting_status=='Y'){?>
get_row("SELECT * FROM $dsp_payments_table WHERE pay_user_id=$user_id"); $count_payment_row=count($payment_row); if($count_payment_row>0){ ?>
    • " />pay_plan_name;?>
    • pay_plan_name;?>
    • expiration_date));?>
    • 6,'pagetitle'=>'upgrade_account'), $root_link);?>"' class="button" value="Upgrade Now!" />
setting_status=='Y'){?>
    • get_var("select no_of_credits from $dsp_credits_usage_table where user_id='$user_id'"); if(count($no_of_credits)==0) $no_of_credits=count($no_of_credits);?>
    • 6,'pagetitle'=>'upgrade_account'), $root_link);?>"' class="button" value="" />
  • Happening This Week
    [No canvas support]
    setting_status=='Y') { ?> setting_status=='Y') { ?>
stealth_mode; if($stealth_mode != ''){ ?>  
"; include("wp-content/plugins/dsp_dating/headers/email_template_header.php"); // INCLUDE EMAIL TEMPLATES HEADER } //------------------------------------------------------------------------------------------------------------// // --------------------------------------------------------------------------------------------------------- // ?>
prefix .DSP_LANGUAGE_DETAILS_TABLE; $Action=$_GET['Action']; $lang_id=$_GET['lid']; $display_status=$_GET['status']; $url="http://".$_SERVER['HTTP_HOST']."/members/"; if($Action == 'language_status') { if($display_status == '1') { $wpdb->query("UPDATE $dsp_language_detail_table SET display_status='0' where language_id='$lang_id'"); } else { $wpdb->query("UPDATE $dsp_language_detail_table SET display_status='1' where language_id='$lang_id'"); } } $all_languages = $wpdb->get_results("SELECT * FROM $dsp_language_detail_table "); foreach ($all_languages as $lang) { $add_code_language_id=$lang->language_id; $ckk_row=$wpdb->get_var("select count(*) from $dsp_language_detail_table where display_status='1' and language_id='$add_code_language_id'"); $imagePath=get_bloginfo('url').'/wp-content/plugins/dsp_dating/flags/'.$lang->flag_image; if($ckk_row==0){ ?>