Guest User

Untitled

a guest
Sep 24th, 2018
104
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.12 KB | None | 0 0
  1. function lr_approve_ad_sale($approved, $id) {
  2.     global $wpdb, $current_user;
  3.  
  4.     $purchase = $wpdb->get_row("SELECT * FROM lr_ad_purchases WHERE id = " . $id . " AND seller = " . $current_user->ID);
  5.    
  6.     if($approved) {
  7.         $wpdb->query("UPDATE lr_ad_purchases SET datetime = " . date('u') . ", status = 2 WHERE id = " . $id . " AND seller = " . $current_user->ID);
  8.        
  9.         $site = $wpdb->get_row("SELECT * FROM lr_site_data WHERE id = " . $purchase->site_id . " AND owner_id = " . $purchase->seller);
  10.         $ad   = $wpdb->get_row("SELECT * FROM lr_ads WHERE id = " . $purchase->ad_id . " AND owner_id = " . $purchase->buyer . " AND site_id = " . $site->id);
  11.        
  12.         $meh = array (
  13.             'headers'   => null,
  14.             'body'      => array(
  15.                 'hash'  => md5($site->serial . $ad->type . $ad->title . $ad->url . $purchase->block_id)
  16.             )
  17.         );
  18.  
  19.         wp_remote_post($site->url, $meh);
  20.     }
  21.     else {
  22.         if($purchase) {
  23.             if($wpdb->query("DELETE FROM lr_ad_purchases WHERE id = " . $id . " AND seller = " . $current_user->ID)) {
  24.                 $wpdb->query("UPDATE lr_user_data SET credits = credits + " . $purchase->cost . " WHERE user_id = " . $purchase->buyer);
  25.             }
  26.         }
  27.     }
  28. }
Add Comment
Please, Sign In to add comment