Location: PHPKode > scripts > Event Registration > event-registration/payments/evr_admin_payments-update.php
<?php
function evr_admin_payment_update(){
    global $wpdb;
   
   

    $payment_id = $_REQUEST['payment_id'];
                $payer_id = $_REQUEST['attendee_id'];
                //$event_id = $_REQUEST['event_id'];
                (is_numeric($_REQUEST['event_id'])) ? $event_id = $_REQUEST['event_id'] : $event_id = "0";
                $first_name = $_REQUEST['first_name'];
                $last_name = $_REQUEST['last_name'];
                $payer_email = $_REQUEST['payer_email'];
                $txn_id = $_REQUEST['txn_id'];
                $payment_type = $_REQUEST['payment_type'];
                $item_name = $_REQUEST['item_name'];
                $item_number = $_REQUEST['item_number'];
                $quantity = $_REQUEST['quantity'];
                $payment_amount = $row['amt_pd'];
				$payer_status = $_REQUEST['payer_status'];
                $payment_status = $_REQUEST['payment_status'];
                $txn_type = $_REQUEST['txn_type'];
                $mc_currency = $_REQUEST['mc_currency'];
                $currency_format =$_REQUEST['mc_currency'];
				$memo = $_REQUEST['memo'];
                $payment_date = $_REQUEST['payment_date'];
                if (isset($_REQUEST['mc_gross'])){
				    $amount_pd = $_REQUEST['mc_gross'];
                    }else{
				    $amount_pd = $_REQUEST['payment_gross'];
   					}
     			$mc_gross=$amount_pd;
     			$address_name = $_REQUEST['address_name'];
     			$address_street = $_REQUEST['address_street'];
     			$address_city = $_REQUEST['address_city'];
     			$address_state = $_REQUEST['address_state'];
     			$address_zip = $_REQUEST['address_zip'];
     			$address_country = $_REQUEST['address_country'];
     			$address_status = $_REQUEST['address_status'];
     			$payer_business_name = $_REQUEST['payer_business_name'];
     			$pending_reason = $_REQUEST['pending_reason'];
     			$reason_code = $_REQUEST['reason_code'];
                
                
                $send_payment_rec = $_REQUEST['send_payment_rec'];                
                
                $sql=array('payer_id'=>$payer_id, 'event_id'=>$event_id, 'payment_date'=>$payment_date, 'txn_id'=>$txn_id, 
                            'first_name'=>$first_name, 'last_name'=>$last_name, 'payer_email'=>$payer_email, 'payer_status'=>$payer_status,
                            'payment_type'=>$payment_type, 'memo'=>$memo, 'item_name'=>$item_name, 'item_number'=>$item_number,
                            'quantity'=>$quantity, 'mc_gross'=>$mc_gross, 'mc_currency'=>$mc_currency, 'address_name'=>$address_name,
                            'address_street'=>$address_street, 'address_city'=>$address_city, 'address_state'=>$address_state, 'address_zip'=>$address_zip,
                            'address_country'=>$address_country, 'address_status'=>$address_status, 'payer_business_name'=>$payer_business_name, 'payment_status'=>$payment_status,
                            'pending_reason'=>$pending_reason, 'reason_code'=>$reason_code, 'txn_type'=>$txn_type);
                            
                 $payment_dtl=array('payer_id'=>$payer_id, 'event_id'=>$event_id, 'payment_date'=>$payment_date, 'txn_id'=>$txn_id, 
                            'first_name'=>$first_name, 'last_name'=>$last_name, 'payer_email'=>$payer_email, 'payer_status'=>$payer_status,
                            'payment_type'=>$payment_type, 'memo'=>$memo, 'item_name'=>$item_name, 'item_number'=>$item_number,
                            'quantity'=>$quantity, 'mc_gross'=>$mc_gross, 'mc_currency'=>$mc_currency, 'address_name'=>$address_name,
                            'address_street'=>$address_street, 'address_city'=>$address_city, 'address_state'=>$address_state, 'address_zip'=>$address_zip,
                            'address_country'=>$address_country, 'address_status'=>$address_status, 'payer_business_name'=>$payer_business_name, 'payment_status'=>$payment_status,
                            'pending_reason'=>$pending_reason, 'reason_code'=>$reason_code, 'txn_type'=>$txn_type);              
					  
	   
        		
     $sql_data = array('%s','%s','%s','%s','%s','%s','%s','%s','%s',
                        '%s','%s','%s','%s','%s','%s','%s','%s','%s',
                       '%s','%s','%s','%s','%s','%s','%s','%s','%s');
        	
        $update_id = array('id'=> $payment_id);
            
            if ($wpdb->update( get_option('evr_payment'), $sql, $update_id, $sql_data, array( '%d' ) )){?>
    
        	         	<div id="message" class="updated fade"><p><strong><?php _e('The payment has been updated.','evr_language');?> </strong></p></div>
                
                <?php }else { ?>
        		<div id="message" class="error"><p><strong><?php _e('There was an error in your submission, please try again. The payment was not updated!','evr_language');?><?php print mysql_error() ?>.</strong></p>
                <p><strong><?php _e(' . . .Now returning you to the payment section . . ','evr_language');?><meta http-equiv="Refresh" content="3; url=admin.php?page=payments&action=view_payments&event_id=<?php echo $event_id;?>"></strong></p>
                </div>
                <?php } 
    			
   
   
   	if ($send_payment_rec == "Y") {	
 		 
					$company_options = get_option('evr_company_settings');
                    
                    $sql = "SELECT * FROM " . get_option('evr_attendee') . " WHERE id ='$payer_id'";
					$result = mysql_query ( $sql );
					$attendee_dtl = mysql_fetch_assoc ( $result );
					
                    $sql= "SELECT * FROM ". get_option('evr_event')." WHERE id=".$event_id; 
                    $result = mysql_query ( $sql );
                    $event_dtl = mysql_fetch_assoc ($result);  
				
					//get return URL
                                       
					$payment_link = evr_permalink($company_options['return_url']). "id=".$payment_dtl['payer_id']."&fname=".$payment_dtl['first_name'];
                    
					$subject = "Updated " .$company_options['payment_subj'];
					$distro = $email;              
					$message = html_entity_decode(nl2br($company_options['payment_message']));
                    //search and replace tags
                    $SearchValues = array("[id]","[fname]","[lname]","[payer_email]","[event_name]", "[contact]",
                        "[payment_url]", "[amnt_pd]","[txn_id]","[txn_type]","[address_street]","[address_city]",
                        "[address_state]","[address_zip]","[address_country]","
                        [start_date]","[start_time]","[end_date]","[end_time]" );
                    $ReplaceValues = array($payment_dtl['payer_id'], $payment_dtl['first_name'],$payment_dtl['last_name'],$payment_dtl['payer_email'],stripslashes($event_dtl['event_name']), $company_options['company_email'], 
                       $payment_link, $payment_dtl['mc_gross'], $payment_dtl['txn_id'], $payment_dtl['txn_type'],$payment_dtl['address_street'], $payment_dtl['address_city'], 
                       $payment_dtl['address_state'],$payment_dtl['address_zip'],$payment_dtl['address_country'], 
                       $event_dtl['start_date'], $event_dtl['start_time'],$event_dtl['end_date'],$event_dtl['end_time'], );     
                
                    $email_content = str_replace($SearchValues, $ReplaceValues, $message);
                    $message_top = "<html><body>"; 
                    $message_bottom = "</html></body>";
                    $email_body = $message_top.$email_content.$message_bottom;
                            
                    $headers = "MIME-Version: 1.0\r\n";
                    $headers .= "Content-type: text/html; charset=UTF-8\r\n";
                    $headers .= 'From: "' . $company_options['company'] . '" <' . $company_options['company_email'] . ">\r\n";
                    
                    wp_mail($attendee_dtl['email'], $subject, html_entity_decode($email_body), $headers);
                    
                   ?>
				<div id="message" class="updated fade"><p><strong><?php _e('Payment Received Notification sent.','evr_language');?> </strong></p></div>
                <?php
				}
   
		
			
            ?>

            <META HTTP-EQUIV="refresh" content="3;URL=admin.php?page=payments&action=view_payments&event_id=<?php echo $event_id;?>">
            <?php
        
}
?>
Return current item: Event Registration