query($wpdb->prepare($sql)); //Send Payment Recieved Email if ($_REQUEST['send_payment_rec'] == "send_message"){ $sql = "SELECT * FROM " . $events_attendee_tbl . " WHERE id ='$id'"; $result = mysql_query($sql); while ($row = mysql_fetch_assoc ($result)){ $id = $row['id']; $lname = $row['lname']; $fname = $row['fname']; $address = $row['address']; $city = $row['city']; $state = $row['state']; $zip = $row['zip']; $email = $row['email']; $phone = $row['phone']; $date = $row['date']; $payment_status = $row['payment_status']; $txn_type = $row['txn_type']; $txn_id = $row['txn_id']; $amount_pd = $row['amount_pd']; $quantity = $row['quantity']; $payment_date = $row['payment_date']; $event_id = $row['event_id']; $custom1 = $row['custom_1']; $custom2 = $row['custom_2']; $custom3 = $row['custom_3']; $custom4 = $row['custom_4']; } $org_options = get_option('events_organization_settings'); $return_url = $org_options['return_url']; $payment_link = $return_url."?id=".$id; //$payment_link = get_option('siteurl') . "/?page_id=" . $return_url . "&id=".$id; $subject = "Event Payment Received"; $distro=$email; $message=("***This Is An Automated Response*** \r\n\nThank You $fname $lname. We have received a payment in the amount of $".$amount_pd." for your event registration."); wp_mail($distro, $subject, $message); } } $id = $_REQUEST['id']; $sql = "SELECT * FROM " . $events_attendee_tbl . " WHERE id ='$id'"; $result = mysql_query($sql); while ($row = mysql_fetch_assoc ($result)) { $id = $row['id']; $lname = $row['lname']; $fname = $row['fname']; $address = $row['address']; $city = $row['city']; $state = $row['state']; $zip = $row['zip']; $email = $row['email']; $phone = $row['phone']; $date = $row['date']; $payment_status = $row['payment_status']; $txn_type = $row['txn_type']; $txn_id = $row['txn_id']; $amount_pd = $row['amount_pd']; $quantity = $row['quantity']; $payment_date = $row['payment_date']; $event_id = $row['event_id']; $custom1 = $row['custom_1']; $custom2 = $row['custom_2']; $custom3 = $row['custom_3']; $custom4 = $row['custom_4']; } $sql = "SELECT * FROM ". $events_detail_tbl . " WHERE id='".$event_id."'"; $result = mysql_query($sql); while ($row = mysql_fetch_assoc ($result)){ $event_id = $row['id']; $event_name = $row['event_name']; $event_desc = $row['event_desc']; $event_description = $row['event_desc']; $event_identifier = $row['event_identifier']; $cost = $row['event_cost']; $active = $row['is_active']; } ?>

Edit Attendee Payment Record

Payment details saved for . Payment notification has been sent.

Attendee # | Name: | Registered For:

  • Payment Status:
  • Transaction Type:
  • Transaction ID:
  • Amount Paid:
  • How Many People:
  • Date Paid: " />
  • Do you want to send a payment recieved notice to registrant? Yes No