<?php
//This script and site designed and built by Mark O'Russa, Mark Pro Audio Inc. Copyright 2008-2013.
require_once 'siteAdmin.php';
$fileInfo = array('fileName' => 'includes/payPalMethods.php');
$debug->newFile($fileInfo['fileName']);
$success = false;
if (MODE == 'buildIpn') {
buildIpn();
} elseif (MODE == 'buildIpnErrors') {
buildIpnErrors();
} elseif (MODE == 'buildPdt') {
buildIpnErrors();
} elseif (MODE == 'buildPdtErrors') {
buildIpnErrors();
} else {
$debug->add('No matching mode in ' . $fileInfo['fileName'] . '.');
}
function buildIpn()
{
global $debug, $message, $success, $Dbc;
$output = '';
try {
$ipnQueryStart = "SELECT\n\tipnId AS 'ipnId',\n\ttime AS 'time',\n\ttxn_id AS 'txn_id',\n\ttxn_type AS 'txn_type',\n\tpayment_status AS 'payment_status',\n\tqueryString AS 'queryString',\n\trequest AS 'request'\nFROM\n\tipnListener";
if (!empty($_POST['searchVal'])) {
$search = true;
$searchVal = '%' . trim($_POST['searchVal']) . '%';
$debug->add('$searchVal: ' . "{$searchVal}.");
$ipnQuery = $ipnQueryStart . "\nWHERE\n\tipnId LIKE ? OR\n\ttxn_id LIKE ? OR\n\ttxn_type LIKE ? OR\n\tpayment_status LIKE ? OR\n\tqueryString LIKE ? OR\n\trequest LIKE ?\nORDER BY\n\tipnId DESC";
$ipnStmt = $Dbc->prepare($ipnQuery);
$ipnParams = array($searchVal, $searchVal, $searchVal, $searchVal, $searchVal, $searchVal);
<li class="sectionTitle">PayPal IPN (Instant Payment Notification) Transactions</li>
</ul>
</div>
<div class="textLeft" id="ipnHolder">
', buildIpn(), '
</div>
<div class="break relative">
<div class="absolute" style="right:5px">
', buildSearch('buildIpnErrors', 'IPN Errors'), '
</div>
<ul>
<li class="sectionTitle">IPN Errors</li>
</ul>
</div>
<div class="textLeft" id="ipnErrorsHolder">
', buildIpnErrors(), '
</div>
<div class="break relative">
<div class="absolute" style="right:5px">
', buildSearch('buildPdt', 'PDT Transactions'), '
</div>
<ul>
<li class="sectionTitle">PayPal PDT (Payment Data Transfer) Transactions</li>
</ul>
</div>
<div class="textLeft" id="pdtHolder">
', buildPdt(), '
</div>
<div class="break relative">
<div class="absolute" style="right:5px">
', buildSearch('buildPdtErrors', 'PDT Errors'), '
