main.php:

session_start();
CUT
$_SESSION['paypal_ipn'] = true;
require("ipndb.php");


ipndb.php:

require("connectDB.php");
require("validate.php");

$checkVar = new checkVar($conn);


//se session_paypal_ipn == false exit
if (isset($_SESSION['paypal_ipn']) && ($_SESSION['paypal_ipn'] == true))
{

	//riempi co regex /(\$\w+) = \$checkVar->securityText( \1 , 255 , 'REG_TEXT' );/

	$item_name = $checkVar->securityText( $item_name , 255 , 'REG_TEXT' );
	$business = $checkVar->securityText( $business , 255 , 'REG_TEXT' );
	$item_number = $checkVar->securityText( $item_number , 255 , 'REG_TEXT' );
	$mc_gross = $checkVar->securityText( $mc_gross , 255 , 'REG_TEXT' );
	$mc_currency = $checkVar->securityText( $mc_currency , 255 , 'REG_TEXT' );
	$txn_id = $checkVar->securityText( $txn_id , 255 , 'REG_TEXT' );
	$receiver_email = $checkVar->securityText( $receiver_email , 255 , 'REG_TEXT' );

	$receiver_id = $checkVar->securityText( $receiver_id, 255 , 'REG_TEXT' );
	$quantity = $checkVar->securityText( $quantity, 255 , 'REG_TEXT' );
	$num_cart_items = $checkVar->securityText( $num_cart_items, 255 , 'REG_TEXT' );
	$payment_date = $checkVar->securityText( $payment_date, 255 , 'REG_TEXT' );
	$first_name = $checkVar->securityText( $first_name, 255 , 'REG_TEXT' );
	$last_name = $checkVar->securityText( $last_name, 255 , 'REG_TEXT' );
	$payment_type = $checkVar->securityText( $payment_type, 255 , 'REG_TEXT' );
	$payment_status = $checkVar->securityText( $payment_status, 255 , 'REG_TEXT' );
	$payment_gross = $checkVar->securityText( $payment_gross, 255 , 'REG_TEXT' );
	$payment_fee = $checkVar->securityText( $payment_fee, 255 , 'REG_TEXT' );
	$settle_amount = $checkVar->securityText( $settle_amount, 255 , 'REG_TEXT' );
	$memo = $checkVar->securityText( $memo, 255 , 'REG_TEXT' );
	$payer_email = $checkVar->securityText( $payer_email, 255 , 'REG_TEXT' );
	$txn_type = $checkVar->securityText( $txn_type, 255 , 'REG_TEXT' );
	$payer_status = $checkVar->securityText( $payer_status, 255 , 'REG_TEXT' );
	$address_street = $checkVar->securityText( $address_street, 255 , 'REG_TEXT' );
	$address_city = $checkVar->securityText( $address_city, 255 , 'REG_TEXT' );
	$address_state = $checkVar->securityText( $address_state, 255 , 'REG_TEXT' );
	$address_zip = $checkVar->securityText( $address_zip, 255 , 'REG_TEXT' );
	$address_country = $checkVar->securityText( $address_country, 255 , 'REG_TEXT' );
	$address_status = $checkVar->securityText( $address_status, 255 , 'REG_TEXT' );
	$tax = $checkVar->securityText( $tax, 255 , 'REG_TEXT' );
	$option_name1 = $checkVar->securityText( $option_name1, 255 , 'REG_TEXT' );
	$option_name2 = $checkVar->securityText( $option_name2, 255 , 'REG_TEXT' );
	$option_selection1 = $checkVar->securityText( $option_selection1, 255 , 'REG_TEXT' );
	$option_selection2 = $checkVar->securityText( $option_selection2, 255 , 'REG_TEXT' );
	$invoice = $checkVar->securityText( $invoice, 255 , 'REG_TEXT' );
	$custom = $checkVar->securityText( $custom, 255 , 'REG_TEXT' );
	$notify_version = $checkVar->securityText( $notify_version, 255 , 'REG_TEXT' );
	$verify_sign = $checkVar->securityText( $verify_sign, 255 , 'REG_TEXT' );
	$payer_business_name = $checkVar->securityText( $payer_business_name, 255 , 'REG_TEXT' );
	$payer_id = $checkVar->securityText( $payer_id, 255 , 'REG_TEXT' );
	$mc_fee = $checkVar->securityText( $mc_fee, 255 , 'REG_TEXT' );
	$exchange_rate = $checkVar->securityText( $exchange_rate, 255 , 'REG_TEXT' );
	$settle_currency = $checkVar->securityText( $settle_currency, 255 , 'REG_TEXT' );
	$parent_txn_id = $checkVar->securityText( $parent_txn_id, 255 , 'REG_TEXT' );
	$pending_reason = $checkVar->securityText( $pending_reason, 255 , 'REG_TEXT' );
	$reason_code = $checkVar->securityText( $reason_code, 255 , 'REG_TEXT' );
	$subscr_id = $checkVar->securityText( $subscr_id, 255 , 'REG_TEXT' );
	$subscr_date = $checkVar->securityText( $subscr_date, 255 , 'REG_TEXT' );
	$subscr_effective = $checkVar->securityText( $subscr_effective, 255 , 'REG_TEXT' );
	$period1 = $checkVar->securityText( $period1, 255 , 'REG_TEXT' );
	$period2 = $checkVar->securityText( $period2, 255 , 'REG_TEXT' );
	$period3 = $checkVar->securityText( $period3, 255 , 'REG_TEXT' );
	$amount1 = $checkVar->securityText( $amount1, 255 , 'REG_TEXT' );
	$amount2 = $checkVar->securityText( $amount2, 255 , 'REG_TEXT' );
	$amount3 = $checkVar->securityText( $amount3, 255 , 'REG_TEXT' );
	$mc_amount1 = $checkVar->securityText( $mc_amount1, 255 , 'REG_TEXT' );
	$mc_amount2 = $checkVar->securityText( $mc_amount2, 255 , 'REG_TEXT' );
	$mc_amount3 = $checkVar->securityText( $mc_amount3, 255 , 'REG_TEXT' );
	$recurring = $checkVar->securityText( $recurring, 255 , 'REG_TEXT' );
	$reattempt = $checkVar->securityText( $reattempt, 255 , 'REG_TEXT' );
	$retry_at = $checkVar->securityText( $retry_at, 255 , 'REG_TEXT' );
	$recur_times = $checkVar->securityText( $recur_times, 255 , 'REG_TEXT' );
	$username = $checkVar->securityText( $username, 255 , 'REG_TEXT' );
	$password = $checkVar->securityText( $password, 255 , 'REG_TEXT' );
	$for_auction = $checkVar->securityText( $for_auction, 255 , 'REG_TEXT' );
	$auction_closing_date = $checkVar->securityText( $auction_closing_date, 255 , 'REG_TEXT' );
	$auction_multi_item = $checkVar->securityText( $auction_multi_item, 255 , 'REG_TEXT' );
	$auction_buyer_id = $checkVar->securityText( $auction_buyer_id, 255 , 'REG_TEXT' );

	//insert into paypal (
		$cls1 = "
		item_name, business, item_number, mc_gross, mc_currency, txn_id, receiver_email, receiver_id, quantity, num_cart_items, payment_date, first_name, last_name,
		payment_type, payment_status, payment_gross, payment_fee, settle_amount, memo, payer_email, txn_type, payer_status, address_street, address_city,
		address_state, address_zip, address_country, address_status, tax, option_name1, option_name2, option_selection1, option_selection2, invoice, custom,
		notify_version, verify_sign, payer_business_name, payer_id, mc_fee, exchange_rate, settle_currency, parent_txn_id, pending_reason, reason_code,
		subscr_id, subscr_date, subscr_effective, period1, period2, period3, amount1, amount2, amount3, mc_amount1, mc_amount2, mc_amount3, recurring,
		reattempt, retry_at, recur_times, username, password, for_auction, auction_closing_date, auction_multi_item, auction_buyer_id, data_transizione
		";

		//todo adda validate.php e valida tutte ste variabili de mierda
		//aggiungi check if null, metti null
		$cls2 = "
		$item_name,
		$business,
		$item_number,
		$mc_gross,
		$mc_currency,
		$txn_id,
		$receiver_email,
		$receiver_id,
		$quantity,
		$num_cart_items,
		$payment_date,
		$first_name,
		$last_name,
		$payment_type,
		$payment_status,
		$payment_gross,
		$payment_fee,
		$settle_amount,
		$memo,
		$payer_email,
		$txn_type,
		$payer_status,
		$address_street,
		$address_city,
		$address_state,
		$address_zip,
		$address_country,
		$address_status,
		$tax,
		$option_name1,
		$option_name2,
		$option_selection1,
		$option_selection2,
		$invoice,
		$custom,
		$notify_version,
		$verify_sign,
		$payer_business_name,
		$payer_id,
		$mc_fee,
		$exchange_rate,
		$settle_currency,
		$parent_txn_id,
		$pending_reason,
		$reason_code,
		$subscr_id,
		$subscr_date,
		$subscr_effective,
		$period1,
		$period2,
		$period3,
		$amount1,
		$amount2,
		$amount3,
		$mc_amount1,
		$mc_amount2,
		$mc_amount3,
		$recurring,
		$reattempt,
		$retry_at,
		$recur_times,
		$username,
		$password,
		$for_auction,
		$auction_closing_date,
		$auction_multi_item,
		$auction_buyer_id,
		$data_transizione
		";




	$query = "INSERT INTO paypal ( $cls1 ) VALUES ( $cls2 ) ON DUPLICATE KEY UPDATE txn_id=LAST_INSERT_ID(txn_id)";


	$res = mysqli_query ( $conn, $query);
	if (!$res)
	{
		//manda mail
		$emailtext .= "Error in query paypal: $query " . "\n\n" . mysqli_error ( $conn ) . mysqli_errno( $conn );
		//echo "Errore inserimento dati paypal: " . mysqli_error ( $conn ) . mysqli_errno( $conn );
		$mail->Subject = "Live-VERIFIED IPN - Problema querydb paypal";
		$mail->Body = $emailtext;
		$mail->Send ();
	}



	unset($_SESSION['paypal_ipn']);
}

require("disconnectDB.php");