Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $result = mysql_query("SELECT transactionid
- FROM log") or die(mysql_error());
- $existing = array();
- echo "<b>Getting existing ids</b>:<br />";
- while ($row = mysql_fetch_assoc($result)) {
- $existing[] = $row['transactionid'];
- echo " " . $row['transactionid'] . "<br />";
- }
- echo "<br /><b>Fetching latest transactions</b><br />";
- foreach ($results = getLast() as $key => $value) {
- if (!in_array($results[$key]['L_TRANSACTIONID'], $existing, true)) {
- echo $results[$key]['L_TRANSACTIONID'] . " does not exist<br />";
- foreach(getTransaction($results[$key]['L_TRANSACTIONID']) as $field => $val) {
- $data[$field] = $val;
- //echo $field . ' => ' . $val . "<br />";
- }
- if (!empty($data['L_SEVERITYCODE0']) || $data['L_ERRORCODE0'] == 'Error') {
- echo "An error occurred fetching details<br />" . urldecode($data['L_SHORTMESSAGE0']) . "<br />" . urldecode($data['L_LONGMESSAGE0']) . "<br /><br />";
- }
- else if (!empty($data['PAYMENTSTATUS']) && $data['PAYMENTSTATUS'] == 'Pending') {
- echo "This transaction is pending<br /><br />";
- }
- else {
- foreach ($data as $field => $val) {
- $afields[] = '`' . strtolower($field) . '`';
- if (strpos_arr(strtolower($field), array('time', 'date')) !== false) {
- $avalues[] = "'" . strtotime(urldecode($val)) . "'";
- }
- else {
- $avalues[] = "'" . urldecode($val) . "'";
- }
- }
- echo "Double checking " . $data['TRANSACTIONID'] . "<br />";
- if (!in_array($data['TRANSACTIONID'], $existing, true)) {
- echo "<b>Inserting " . $data['TRANSACTIONID'] . "</b><br/ ><br/ >";
- mysql_query('INSERT INTO log (' . implode(', ', $afields) . ') VALUES (' . implode(', ', $avalues) . ')') or die(mysql_error());
- }
- else {
- echo $data['TRANSACTIONID'] . ' exists!<br /><br />';
- }
- }
- unset($afields, $avalues, $data);
- }
- else {
- echo $results[$key]['L_TRANSACTIONID'] . " exists!<br /><br />";
- }
- }
Add Comment
Please, Sign In to add comment