"/>

	get_results("SELECT u.id,user_login FROM $wpdb->users u INNER JOIN $this->paied_users_table up ON up.user_id=u.id and up.post_id=$item_id"); if ($users){ foreach($users as $user) { ?>user_login;?>get_results("SELECT u.id,user_login FROM $wpdb->users u WHERE u.id not in (SELECT user_id FROM $this->paied_users_table up WHERE up.post_id=$item_id)"); if ($users){ foreach($users as $user) { ?>user_login;?>

"/>

"/>

get_results("SELECT posts.ID,posts.post_title, items.* FROM $wpdb->posts posts LEFT OUTER JOIN $this->paied_items_table items ON items.post_id=posts.id"); ?> '; } ?> get_results("SELECT users.* FROM . $this->paied_users_table users WHERE (users.post_id='$post_id') AND users.user_id='$user_id' AND (ADDDATE(purchase_date, expire) > CURDATE() OR expire is null OR expire = 0)"); if ($users){ return true; } $item_amount=get_option($this->prefix.'_BlogAmount'); if ($item_amount){ $paypal_response=$wpdb->get_results("SELECT * FROM .$this->paypal_payment_info_table WHERE custom ='$post_id|$user_id' AND mc_gross=$item_amount"); if ($paypal_response){ //Grant access(This is needed to prevent misfunction on price change) $this->PayForItem($post_id,$user_id); $wpdb->query("UPDATE $this->paypal_payment_info_table SET custom='[processed]$post_id|$user_id' WHERE custom ='$post_id|$user_id' AND mc_gross=$item_amount"); return true; } } $post_id=mysql_escape_string($post_id_tmp); $sql = "SELECT items.* FROM $this->paied_items_table items WHERE items.post_id='$post_id'"; $items = $wpdb->get_results($sql); if($items) { $users = $wpdb->get_results("SELECT users.* FROM . $this->paied_users_table users WHERE (users.post_id='$post_id') AND users.user_id='$user_id' AND (ADDDATE(purchase_date, expire) > CURDATE() OR expire is null OR expire = 0)"); if ($users){ return true; } $item_amount=$items[0]->amount; if ($item_amount){ $paypal_response=$wpdb->get_results("SELECT * FROM .$this->paypal_payment_info_table WHERE custom ='$post_id|$user_id' AND mc_gross=$item_amount"); if ($paypal_response){ //Grant access(This is needed to prevent misfunction on price change) $this->PayForItem($post_id,$user_id); $wpdb->query("UPDATE $this->paypal_payment_info_table SET custom='[processed]$post_id|$user_id' WHERE custom ='$post_id|$user_id' AND mc_gross=$item_amount"); return true; } } } $item_amount=get_option($this->prefix.'_BlogAmount'); if ($item_amount){ return false; } } // Create User administration screen function PayForItem($post_id,$user_id){ global $wpdb; $post_id=mysql_escape_string($post_id); $items = $wpdb->get_results("SELECT * FROM . $this->paied_items_table WHERE post_id='$post_id'"); $expire=''; if ($items){ $expire=$items[0]->expire; } if ($post_id=="-1"){ $expire=get_option($this->prefix.'_BlogExpire'); } $user_id=mysql_escape_string($user_id); $users = $wpdb->get_results("SELECT users.* FROM . $this->paied_users_table users WHERE users.post_id='$post_id' AND users.user_id='$user_id'"); if (!$users){ $wpdb->query("INSERT INTO $this->paied_users_table(post_id,user_id,expire) VALUES('$post_id','$user_id','$expire')"); $bonuses = $wpdb->get_results("SELECT post2_id FROM . $this->bonus_posts_table WHERE post1_id='$post_id'"); foreach($bonuses as $bonus) { $this->PayForItem($bonus->post2_id,$user_id); } } } function paypal_buy_now_form($item_name,$item_number,$item_price,$item_currency,$post_id,$user_id){ $paypal_url=$this->paypal_url; $paypal_email = $this->paypal_email; $item_custom = $post_id."|".$user_id; $domain = $_SERVER['HTTP_HOST']; $item_return = "http://" . $domain . $_SERVER['REQUEST_URI']; $result="

$item_price $item_currency

"; return $result; } function add_meta_tags_for_robots(){ echo(''); } } } //instantiate the class if (class_exists('Are_PayPal')) { $Are_PayPal = new Are_PayPal(); } ?>