Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function lr_approve_ad_sale($approved, $id) {
- global $wpdb, $current_user;
- $purchase = $wpdb->get_row("SELECT * FROM lr_ad_purchases WHERE id = " . $id . " AND seller = " . $current_user->ID);
- if($approved) {
- $wpdb->query("UPDATE lr_ad_purchases SET datetime = " . date('u') . ", status = 2 WHERE id = " . $id . " AND seller = " . $current_user->ID);
- $site = $wpdb->get_row("SELECT * FROM lr_site_data WHERE id = " . $purchase->site_id . " AND owner_id = " . $purchase->seller);
- $ad = $wpdb->get_row("SELECT * FROM lr_ads WHERE id = " . $purchase->ad_id . " AND owner_id = " . $purchase->buyer . " AND site_id = " . $site->id);
- $meh = array (
- 'headers' => null,
- 'body' => array(
- 'hash' => md5($site->serial . $ad->type . $ad->title . $ad->url . $purchase->block_id)
- )
- );
- wp_remote_post($site->url, $meh);
- }
- else {
- if($purchase) {
- if($wpdb->query("DELETE FROM lr_ad_purchases WHERE id = " . $id . " AND seller = " . $current_user->ID)) {
- $wpdb->query("UPDATE lr_user_data SET credits = credits + " . $purchase->cost . " WHERE user_id = " . $purchase->buyer);
- }
- }
- }
- }
Add Comment
Please, Sign In to add comment