<?php

// this is the old file from Alertpay. 
// I want a new file to work with coinpayments.net 
// and execute the same mysql as below




	$ipn_data = array();         /* array to hold POST values from AlertPay IPN */

	include "config.php";

	/* check the security code sent with the post to ensure that the post came from AlertPay */

	$ap_sec_code = $_POST['ap_securitycode'];

	
	include "config.php";
	

	if ($seccode == $ap_sec_code){

		$amount = $_POST['ap_amount'];

		$userid = $_POST['apc_1'];

		$item = $_POST['ap_itemname'];

		$query = "select * from members where userid='".$userid."'";

		$result = mysql_query ($query)

		           		or die ("Query failed");

		$numrows = @ mysql_num_rows($result);

		if ($numrows == 1) {

			$info = mysql_fetch_array(result);

		
		// comment by dorin
		
		include "config.php";

			if($item == $sitename." One-Time Offer") {

				mysql_query("INSERT INTO transactions VALUES ('".$userid."','Alertpay payment - OTO','".time()."','$amount\$')");

				$sql = mysql_query("SELECT * FROM oto LIMIT 1");

				$oto = mysql_fetch_array($sql);


				if($oto['banner_num'] AND $oto['banner_views']) {

				

					$count = $oto['banner_num'];

					while($count > 0) {

						mysql_query("INSERT INTO memberbanner (userid,position,max) VALUES ('".$userid."','both','".$oto['banner_views']."')");

						$count--;

					}

				}


			if($oto['premiumads'] AND $oto['premiumads_days']) {
			
				$count = $oto['premiumads'];
				while($count > 0) {
					mysql_query("INSERT INTO `premiumads` (`userid`,`days`)VALUES ('$userid','".$oto['premiumads_days']."')");
					$count--;
				}
			}			

				

				if($oto['upgrade_pro']) {

					upgrade_pro($userid);

				}

			} elseif($item == $sitename." Membership ".$userid) {

				mysql_query("INSERT INTO transactions VALUES ('".$userid."','Alertpay payment - Pro Upgrade','".time()."','$amount\$')");

				upgrade_pro($userid);

			} elseif($item == $sitename." Top Banner ".$userid) {

				mysql_query("INSERT INTO transactions VALUES ('".$userid."','Alertpay payment - Top Banner','".time()."','$amount\$')");

				mysql_query("INSERT INTO memberbanner (userid,position,max) VALUES ('".$userid."','top','1000')");
				
			} elseif($item == $sitename." Bottom Banner ".$userid) {

				mysql_query("INSERT INTO transactions VALUES ('".$userid."','Alertpay payment - BottomBanner','".time()."','$amount\$')");

				mysql_query("INSERT INTO memberbanner (userid,position,max) VALUES ('".$userid."','bottom','1000')");				

			} elseif($item == $sitename." Premium Ads ".$userid) {

				mysql_query("INSERT INTO transactions VALUES ('".$userid."','Alertpay payment - Premium Ads','".time()."','$amount\$')");

				mysql_query("insert into premiumads (userid,days) values('$userid','$premiumdays')");					

			} elseif($item == $sitename." Special Offer") {

				mysql_query("INSERT INTO transactions VALUES ('".$userid."','Alertpay payment - Special Offer','".time()."','$amount\$')");

				$sql = mysql_query("SELECT * FROM offerpage LIMIT 1");

				$offer = mysql_fetch_array($sql);


				if($offer['banner_num'] AND $offer['banner_views']) {

				

					$count = $offer['banner_num'];

					while($count > 0) {

						mysql_query("INSERT INTO memberbanner (userid,position,max) VALUES ('".$userid."','both','".$offer['banner_views']."')");

						$count--;

					}

				}
	

					if($offer['premiumads'] AND $offer['premiumads_days']) {
					
						$count = $offer['premiumads'];
						while($count > 0) {
							mysql_query("INSERT INTO `premiumads` (`userid`,`days`)VALUES ('$userid','".$offer['premiumads_days']."')");
							$count--;
						}
					}	
	
				if($offer['upgrade_pro']) {

					upgrade_pro($userid);

				}

			

			}

		

		

		}

		

		

   	}

	else{

		/* Security code doesn't match. POST IS NOT FROM ALERTPAY.

		 * Ignore post, or do whatever fraud catching that you would like.

		 */

	}

?>