paypal_requests_table";
if ($_REQUEST["action"] == "details"){
$RequestID = $_REQUEST["RequestID"];
$sql .= " where RequestID='$RequestID'";
}
$requests=$wpdb->get_results($sql);
if(count($requests) > 0) {
?>
RequestID;
$fields=$wpdb->get_results("select * from $this->paypal_fields_table where RequestID='$RequestID'");
if(count($fields) > 0) {
foreach($fields as $field) {
?>
Name;?>
Value;?>
Name=="custom"){
list($post_id,$user_id) = explode("|",$field->Value);
$user_id=mysql_escape_string($user_id);
$post_id=mysql_escape_string($post_id);
$login=$wpdb->get_results("SELECT user_login FROM $wpdb->users where ID='$user_id'");
?>
user_login;?>
get_results("SELECT post_title FROM $wpdb->posts where ID='$post_id'");
?>
post_title;?>
RequestID;
$fields=$wpdb->get_results("select * from $this->paypal_fields_table where RequestID='$RequestID'");
if(count($fields) > 0) {
?>
%TYPE%
%EMAIL%
%AMOUNT%
%LOGIN%
%TITLE%
";
foreach($fields as $field) {
switch ($field->Name) {
case "txn_type":
$rowTemplate=str_replace('%TYPE%',$field->Value,$rowTemplate);
break;
case "payer_email":
$rowTemplate=str_replace('%EMAIL%',$field->Value,$rowTemplate);
break;
case "mc_gross":
$rowTemplate=str_replace('%AMOUNT%',$field->Value,$rowTemplate);
break;
case "mc_amount3":
$rowTemplate=str_replace('%AMOUNT%',$field->Value,$rowTemplate);
break;
case "custom":
list($post_id,$user_id) = explode("|",$field->Value);
$user_id=mysql_escape_string($user_id);
$post_id=mysql_escape_string($post_id);
$login=$wpdb->get_results("SELECT user_login FROM $wpdb->users where ID='$user_id'");
$post=$wpdb->get_results("SELECT post_title FROM $wpdb->posts where ID='$post_id'");
$rowTemplate=str_replace('%LOGIN%',$login[0]->user_login,$rowTemplate);
$rowTemplate=str_replace('%TITLE%',$post[0]->post_title,$rowTemplate);
break;
}
}
$rowTemplate=str_replace('%AMOUNT%','',$rowTemplate);
echo($rowTemplate);
?>
>"){
$item_purchaser=$_GET["available_users"];
$wpdb->query("INSERT INTO $this->paied_users_table(post_id,user_id) VALUES($post_id,$item_purchaser)");
$LastAction = __("Added successfully ...");
}else{
$item_purchaser=$_GET["paied_users"];
$wpdb->query("DELETE FROM $this->paied_users_table WHERE post_id=$post_id AND user_id=$item_purchaser");
$LastAction = __("Removed successfully ...");
}
}
if (($action=="purchasers")&&($post_id)){
if(!empty($LastAction)) { echo '
'.$LastAction.'
'; }
$items = $wpdb->get_results("SELECT posts.ID,posts.post_title FROM $wpdb->posts posts WHERE posts.id='$post_id'");
if($items || $post_id==-1) {
if ($post_id==-1){
$item_id=-1;
$item_title="Entire blog ...";
}else{
$item=$items[0];
$item_id=$item->ID;
$item_title=$item->post_title;
}
?>
>"){
$post2_id=$_GET["post_to_package"];
$wpdb->query("INSERT INTO $this->bonus_posts_table VALUES($post_id,$post2_id)");
$wpdb->query("INSERT INTO $this->bonus_posts_table VALUES($post2_id,$post_id)");
$LastAction = __("Added successfully ...");
}else{
$post2_id=$_GET["post_in_package"];
$wpdb->query("DELETE FROM $this->bonus_posts_table WHERE post1_id=$post_id AND post2_id=$post2_id");
$wpdb->query("DELETE FROM $this->bonus_posts_table WHERE post1_id=$post2_id AND post2_id=$post_id");
$LastAction = __("Removed successfully ...");
}
}
if (($action=="delete")&&($post_id)){
$wpdb->query("DELETE FROM $this->paied_items_table WHERE post_id=$post_id");
$wpdb->query("DELETE FROM $this->paied_users_table WHERE post_id=$post_id");
$LastAction = __("Deleted successfully ...");
}
if (($action=="write")&&($post_id)){
$items = $wpdb->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 WHERE posts.id='$post_id'");
$item=$items[0];
$item_id=$item->ID;
$item_amount=mysql_escape_string($_GET["amount"]);
$item_currency=mysql_escape_string($_GET["currency"]);
$item_name=mysql_escape_string($_GET["name"]);
$item_number=mysql_escape_string($_GET["number"]);
$item_expire=$_GET["expire"];
if ($item->post_id){
//UPDATE
$sql="UPDATE $this->paied_items_table SET name='$item_name',number='$item_number',amount='$item_amount',currency='$item_currency',expire='$item_expire' WHERE post_id=$item_id";
$LastAction = __("Updated successfully ...");
}else{
//INSERT
$sql="INSERT INTO $this->paied_items_table (name,number,amount,currency, post_id,expire) VALUES('$item_name','$item_number','$item_amount','$item_currency','$item_id','$item_expire')";
$LastAction = __("Inserted successfully ...");
}
$wpdb->query($sql);
}
if (($action=="purchasers")&&($post_id)){
$this->ManagePurchasers($action,$post_id);
}
elseif (($action=="bonus")&&($post_id)){
$items = $wpdb->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 WHERE posts.id='$post_id' AND $this->post_type_clause");
if($items) {
$item=$items[0];
$item_id=$item->ID;
$item_title=$item->post_title;
$item_amount=$item->amount;
$item_currency=$item->currency;
$item_expire=$item->expire;
$item_name=$item->name;
$item_number=$item->number;
if(!empty($LastAction)) { echo '
'.$LastAction.'
'; } ?>
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 WHERE posts.id='$post_id'");
if($items) {
$item=$items[0];
$item_id=$item->ID;
$item_title=$item->post_title;
$item_amount=$item->amount;
$item_currency=$item->currency;
$item_expire=$item->expire;
$item_name=$item->name;
$item_number=$item->number;
?>
'.$LastAction.'
'; } ?>
posts posts LEFT OUTER JOIN $this->paied_items_table items ON items.post_id=posts.id WHERE posts.post_content LIKE '%$this->start_delimiter%' AND $this->post_type_clause";
$items = $wpdb->get_results($sql);
if(!empty($LastAction)) { echo '
";
$users = $wpdb->get_results("SELECT 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 AND (ADDDATE(up.purchase_date, up.expire) > CURDATE() OR up.expire is null OR up.expire = 0)");
foreach($users as $user) {
echo $user->user_login;
echo " ";
}
echo "
\n";
echo "
$item_name
\n";
echo "
$item_number
\n";
echo "
$item_amount
\n";
echo "
$item_currency
\n";
echo "
$item_expire
\n";
?>
post_id){
?> | | |
';
$i++;
}
} else {
echo '
'.__('No Posts Found').'
';
}
?>
IsPostPurchasedSql("-1",$user_id)){return true;}
if ($this->IsPostPurchasedSql($post_id,$user_id)){return true;}
return false;
}
function IsPostPurchasedSql($post_id,$user_id){
global $wpdb;
$sql="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)";
$users = $wpdb->get_results($sql);
if ($users){
return true;
}
return false;
}
function paypal_buy_now_form($item_name,$item_number,$item_price,$item_currency,$post_id,$user_id,$item_expiration){
$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'];
$textExplanation =stripslashes(get_option($this->prefix.'_TextToShowIfNotPurchased'));
$templateName=$this->prefix."_RecurentPaymentTemplate";
if (!$item_expiration) {$templateName=$this->prefix."_InstantPaymentTemplate";}
$result=stripslashes(get_option($templateName));
$result=str_replace('%EXPLANATION%',$textExplanation,$result);
$result=str_replace('%PAYPALURL%',$paypal_url,$result);
$result=str_replace('%ITEMNAME%',$item_name,$result);
$result=str_replace('%ITEMNUMBER%',$item_number,$result);
$result=str_replace('%ITEMPRICE%',$item_price,$result);
$result=str_replace('%ITEMCURRENCY%',$item_currency,$result);
$result=str_replace('%BONUSLIST%',$this->BonusPostsList($post_id),$result);
$result=str_replace('%PAYPALEMAIL%',$paypal_email,$result);
$result=str_replace('%ITEMRETURN%',$item_return,$result);
$result=str_replace('%ITEMCUSTOM%',$item_custom,$result);
$result=str_replace('%EXPIRATIONINDAYS%',$item_expiration,$result);
$result=str_replace('%BUTTONALT%','',$result);
return $result;
}
function BonusPostsList($post_id){
global $wpdb;
$post_id=mysql_escape_string($post_id);
$sql="select posts.post_title,posts.id from $this->bonus_posts_table bonuses INNER JOIN $wpdb->posts posts ON posts.id=bonuses.post2_id WHERE bonuses.post1_id='$post_id'";
$bonuses=$wpdb->get_results($sql);
$result="";
if ($bonuses){
$result.="
".__("Purchasing current content you will also get access for posts below")."
";
}
return $result;
}
function add_html_headers(){
echo('');
echo('');
}
}
}
//instantiate the class
if (class_exists('Are_PayPal')) {
$Are_PayPal = new Are_PayPal();
}
?>