<?php get_header(); while (have_posts()) { the_post(); $transaction_id = isset($_REQUEST['tx']) ? esc_attr($_REQUEST['tx']) : ''; $payment_array = ''; if ($transaction_id != '') { global $wpdb; $table_name = $wpdb->prefix . "imic_payment_transaction"; $payment_array = imic_validate_payment($transaction_id); $st = isset($_REQUEST['st']) ? esc_attr($_REQUEST['st']) : ''; $user_id = isset($_REQUEST['item_number']) ? esc_attr($_REQUEST['item_number']) : ''; $cause_id = strstr($user_id, '-', true); $cause_name = get_the_title($cause_id); if (!empty($transaction_id)) { $sql_select = $wpdb->get_var($wpdb->prepare("select transaction_id from {$table_name} WHERE `transaction_id` = '{$transaction_id}'")); $data = $wpdb->get_results($sql_select, ARRAY_A) or print mysql_error(); if (empty($data)) { $amt = isset($_REQUEST['amt']) ? esc_attr($_REQUEST['amt']) : ''; $received_amount = get_post_meta($cause_id, 'imic_cause_amount_received', true); $updated_amount = $received_amount + $amt; //if($st=='Completed') { update_post_meta($cause_id, 'imic_cause_amount_received', $updated_amount); //} $sql = $wpdb->update($table_name, array('transaction_id' => $transaction_id, 'status' => $st), array('cause_id' => $user_id)); require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta($sql); } else { } }
if ($valid_with_plan == 1) { $start_date = date('Y-m-d', $key); $listing_date = strtotime(date("Y-m-d", strtotime($start_date)) . " +" . $plan_validity_number . " " . $plan_type); $listing_date = date('Y-m-d', $listing_date); } if ($listing_date > date('Y-m-d')) { $eligible_listing = 1; } } } } } if ($opt_plans == 1) { $transaction_id = isset($_REQUEST['tx']) ? esc_attr($_REQUEST['tx']) : ''; if ($transaction_id != '') { $paypal_details = imic_validate_payment($transaction_id); //Code to update plan information for user //Added next to v1.6 //Start if ($plan_type != "0") { $plan_id = isset($_REQUEST['item_number']) ? esc_attr($_REQUEST['item_number']) : ''; $post_type = get_post_type($plan_id); $plan_price = ''; if ($post_type == 'plan') { $plan_price = get_post_meta($plan_id, 'imic_plan_price', true); $plan_price = floor($plan_price); $plan_listings_count = get_post_meta($plan_id, 'imic_plan_validity_listings', true); $plan_listings_count = esc_attr($plan_listings_count); } if (!empty($paypal_details)) { $st = $paypal_details['payment_status'];
get_header(); get_query_var('login') ? wp_enqueue_script('imic_event_pay') : ''; imic_sidebar_position_module(); $options = get_option('imic_options'); include_once ABSPATH . 'wp-admin/includes/plugin.php'; while (have_posts()) { the_post(); $transaction_id = isset($_REQUEST['tx']) ? esc_attr($_REQUEST['tx']) : ''; if ($transaction_id != '') { wp_enqueue_script('imic_print_ticket'); if ($transaction_id != 'free') { global $wpdb; $table_name = $wpdb->prefix . "imic_payment_transaction"; $paypal_payment = get_option('paypal_payment_option'); $payment_array = imic_validate_payment($transaction_id, $paypal_payment); $st = $payment_array['payment_status']; $user_id = isset($_REQUEST['item_number']) ? esc_attr($_REQUEST['item_number']) : ''; $cause_id = strstr($user_id, '-', true); $cause_name = get_the_title($cause_id); if (!empty($transaction_id) && !empty($st)) { $sql_select = $wpdb->get_var($wpdb->prepare("select transaction_id from {$table_name} WHERE `transaction_id` = '{$transaction_id}'")); $data = $wpdb->get_results($sql_select, ARRAY_A) or print mysql_error(); if (empty($data)) { $amt = isset($_REQUEST['amt']) ? esc_attr($_REQUEST['amt']) : ''; $sql = $wpdb->update($table_name, array('transaction_id' => $transaction_id, 'status' => $st), array('cause_id' => $user_id)); require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta($sql); } else { } }
function imic_contact_site_plans() { $tx = isset($_POST['transaction']) ? $_POST['transaction'] : ''; $message = isset($_POST['message']) ? $_POST['message'] : ''; $plan_id = isset($_POST['plan']) ? $_POST['plan'] : ''; if ($tx != '') { $paypal_details = imic_validate_payment($tx); if (!empty($paypal_details)) { $st = $paypal_details['payment_status']; $payment_gross = $paypal_details['payment_gross']; global $current_user; get_currentuserinfo(); $user_id = get_current_user_id(); $current_user = wp_get_current_user(); $user_info_id = get_user_meta($user_id, 'imic_user_info_id', true); $site_manager_email = get_option('admin_email'); $manager_email = esc_attr($site_manager_email); $dealer_name = get_the_title($user_info_id); $e_subject = __('Payment Related Query', 'framework'); $e_body = __("You have been contacted by {$dealer_name} ", "framework") . PHP_EOL . PHP_EOL; $e_content = ''; $e_content .= __("Name: ", "framework") . $dealer_name . PHP_EOL . PHP_EOL; $e_content .= __("Email: ", "framework") . $current_user->user_email . PHP_EOL . PHP_EOL; $e_content .= __("Plan: ", "framework") . get_the_title($plan_id) . PHP_EOL . PHP_EOL; $e_content .= __("Transaction ID: ", "framework") . $paypal_details['txn_id'] . PHP_EOL . PHP_EOL; $e_content .= __("Payment Status: ", "framework") . $paypal_details['payment_status'] . PHP_EOL . PHP_EOL; $e_content .= __("Message: ", "framework") . $message . PHP_EOL . PHP_EOL; $e_reply = __("You can contact ", "framework") . $dealer_name . __(" via email, ", "framework") . $current_user->user_email; $msg = wordwrap($e_body . $e_content . $e_reply, 70); $headers = __("From: ", "framework") . $current_user->user_email . PHP_EOL; $headers .= __("Reply-To: ", "framework") . $current_user->user_email . PHP_EOL; $headers .= "MIME-Version: 1.0" . PHP_EOL; $headers .= "Content-type: text/plain; charset=utf-8" . PHP_EOL; $headers .= "Content-Transfer-Encoding: quoted-printable" . PHP_EOL; if (mail($manager_email, $e_subject, $msg, $headers)) { echo "<div class=\"alert alert-success\">" . __('Thank you', 'framework') . " <strong>{$dealer_name}</strong>, " . __('your message has been submitted to us.', 'framework') . "</div>"; } else { echo '<div class="alert alert-error">ERROR!</div>'; } } } die; }