?
Solved

developer.paypal.com login ids

Posted on 2009-12-16
8
Medium Priority
?
710 Views
Last Modified: 2013-11-29
is there a 32 digit alphanumeric number that is a "key"

what is a "key"
0
Comment
Question by:rgb192
  • 3
  • 3
  • 2
8 Comments
 
LVL 111

Expert Comment

by:Ray Paseur
ID: 26066056
In what context do you find the term used?
0
 
LVL 111

Expert Comment

by:Ray Paseur
ID: 26067146
Just looking at this again, please let me offer a suggestion that will help you get better answers faster when you post here at EE.  Give us more information to go on.  In this case, it would have been helpful for you to give us a link to the page you were talking about - something that would give us some context.  I tried "developer.paypal.com" but the word "key" is not on that page anywhere.

A "key" could be most anything that acts as a password.  When it is 32 characters, it is typically a message digest like md5()
0
 

Author Comment

by:rgb192
ID: 26067511
i am using a code editor that has
debugger
local values


key is in this php file
<?php
ob_start();
ini_set("display_errors", 1);
error_reporting( E_ALL );
require_once('inc/common.php');
intiateAC();
 
/*
	select top 100 *
	from payments p, paymentupdates pu
	where pu.transactionid = p.number
	and p.orderid = 0
	order by p.dateentered desc
*/
 
//Sanitize the action
if(isset($_GET['a'])) {
	$action = sanitize_str($_GET['a']);
} else if(isset($_POST['a'])) {
	$action = sanitize_str($_POST['a']);
} else {
	$action = "";
}
 
switch ($action) {
	case 'tester':
		$params = array();
		$sql = "SELECT * FROM paypaldata WHERE ppdata LIKE '%$tranid%' order by ppdate desc";
		foreach (dbquery($sql) as $key => $value) {
			//print_r($value);
			$d = (unserialize($value['ppdata2']));
			foreach ($d as $key => $value) {
				$params[] = $key;
			}
		}
		print_r(array_unique($params));
		break;
	case 'viewpayment':
		//txn_id
 
		$pid = sanitize_int($_GET['pid']);
		$paymentdata = dbfetchsingle("select top 100 * from payments p, paymentupdates pu where pu.transactionid = p.number and p.orderid = 0 and paymentid = '$pid'"); 
		$d = unserialize($paymentdata['data']);
		echo '<div align="center" style="padding:0 0 0 5px;"><div align="center" style="width:95%;background:#FFFFFF;padding:10px 0 0 10px;">
			<h2>Details for '.$d['txn_id'].'</h2><br><a href="#" id="closelink">close</a><br>';
		echo '<table>';
		if(isset($d['address_city'])) {
			echo '<tr><td>address_city</td><td>' . $d['address_city'] . '</td></tr>';
		}
		if(isset($d['address_country'])) { echo '<tr><td>address_country</td><td>' . $d['address_country'] . '</td></tr>'; }
		if(isset($d['address_country_code'])) { echo '<tr><td>address_country_code</td><td>' . $d['address_country_code'] . '</td></tr>'; }
		if(isset($d['address_name'])) { echo '<tr><td>address_name</td><td>' . $d['address_name'] . '</td></tr>'; }
		if(isset($d['address_state'])) { echo '<tr><td>address_state</td><td>' . $d['address_state'] . '</td></tr>'; }
		if(isset($d['address_status'])) { echo '<tr><td>address_status</td><td>' . $d['address_status'] . '</td></tr>'; }
		if(isset($d['address_street'])) { echo '<tr><td>address_street</td><td>' . $d['address_street'] . '</td></tr>'; }
		if(isset($d['address_zip'])) { echo '<tr><td>address_zip</td><td>' . $d['address_zip'] . '</td></tr>'; }
		if(isset($d['auction_buyer_id'])) { echo '<tr><td>auction_buyer_id</td><td>' . $d['auction_buyer_id'] . '</td></tr>'; }
		if(isset($d['auction_closing_date'])) { echo '<tr><td>auction_closing_date</td><td>' . $d['auction_closing_date'] . '</td></tr>'; }
		if(isset($d['business'])) { echo '<tr><td>business</td><td>' . $d['business'] . '</td></tr>'; }
		if(isset($d['case_creation_date'])) { echo '<tr><td>case_creation_date</td><td>' . $d['case_creation_date'] . '</td></tr>'; }
		if(isset($d['case_id'])) { echo '<tr><td>case_id</td><td>' . $d['case_id'] . '</td></tr>'; }
		if(isset($d['case_type'])) { echo '<tr><td>case_type</td><td>' . $d['case_type'] . '</td></tr>'; }
		if(isset($d['charset'])) { echo '<tr><td>charset</td><td>' . $d['charset'] . '</td></tr>'; }
		if(isset($d['contact_phone'])) { echo '<tr><td>contact_phone</td><td>' . $d['contact_phone'] . '</td></tr>'; }
		if(isset($d['custom'])) { echo '<tr><td>custom</td><td>' . $d['custom'] . '</td></tr>'; }
		if(isset($d['first_name'])) { echo '<tr><td>first_name</td><td>' . $d['first_name'] . '</td></tr>'; }
		if(isset($d['for_auction'])) { echo '<tr><td>for_auction</td><td>' . $d['for_auction'] . '</td></tr>'; }
		if(isset($d['item_name'])) { echo '<tr><td>item_name</td><td>' . $d['item_name'] . '</td></tr>'; }
		if(isset($d['item_name1'])) { echo '<tr><td>item_name1</td><td>' . $d['item_name1'] . '</td></tr>'; }
		if(isset($d['item_number'])) { echo '<tr><td>item_number</td><td>' . $d['item_number'] . '</td></tr>'; }
		if(isset($d['item_number1'])) { echo '<tr><td>item_number1</td><td>' . $d['item_number1'] . '</td></tr>'; }
		if(isset($d['last_name'])) { echo '<tr><td>last_name</td><td>' . $d['last_name'] . '</td></tr>'; }
		if(isset($d['mc_currency'])) { echo '<tr><td>mc_currency</td><td>' . $d['mc_currency'] . '</td></tr>'; }
		if(isset($d['mc_fee'])) { echo '<tr><td>mc_fee</td><td>' . $d['mc_fee'] . '</td></tr>'; }
		if(isset($d['mc_gross'])) { echo '<tr><td>mc_gross</td><td>' . $d['mc_gross'] . '</td></tr>'; }
		if(isset($d['memo'])) { echo '<tr><td>memo</td><td>' . $d['memo'] . '</td></tr>'; }
		if(isset($d['notify_version'])) { echo '<tr><td>notify_version</td><td>' . $d['notify_version'] . '</td></tr>'; }
		if(isset($d['num_cart_items'])) { echo '<tr><td>num_cart_items</td><td>' . $d['num_cart_items'] . '</td></tr>'; }
		if(isset($d['parent_txn_id'])) { echo '<tr><td>parent_txn_id</td><td>' . $d['parent_txn_id'] . '</td></tr>'; }
		if(isset($d['payer_business_name'])) { echo '<tr><td>payer_business_name</td><td>' . $d['payer_business_name'] . '</td></tr>'; }
		if(isset($d['payer_email'])) { echo '<tr><td>payer_email</td><td>' . $d['payer_email'] . '</td></tr>'; }
		if(isset($d['payer_id'])) { echo '<tr><td>payer_id</td><td>' . $d['payer_id'] . '</td></tr>'; }
		if(isset($d['payer_status'])) { echo '<tr><td>payer_status</td><td>' . $d['payer_status'] . '</td></tr>'; }
		if(isset($d['payment_date'])) { echo '<tr><td>payment_date</td><td>' . $d['payment_date'] . '</td></tr>'; }
		if(isset($d['payment_fee'])) { echo '<tr><td>payment_fee</td><td>' . $d['payment_fee'] . '</td></tr>'; }
		if(isset($d['payment_gross'])) { echo '<tr><td>payment_gross</td><td>' . $d['payment_gross'] . '</td></tr>'; }
		if(isset($d['payment_status'])) { echo '<tr><td>payment_status</td><td>' . $d['payment_status'] . '</td></tr>'; }
		if(isset($d['payment_type'])) { echo '<tr><td>payment_type</td><td>' . $d['payment_type'] . '</td></tr>'; }
		if(isset($d['pending_reason'])) { echo '<tr><td>pending_reason</td><td>' . $d['pending_reason'] . '</td></tr>'; }
		if(isset($d['quantity'])) { echo '<tr><td>quantity</td><td>' . $d['quantity'] . '</td></tr>'; }
		if(isset($d['quantity1'])) { echo '<tr><td>quantity1</td><td>' . $d['quantity1'] . '</td></tr>'; }
		if(isset($d['reason_code'])) { echo '<tr><td>reason_code</td><td>' . $d['reason_code'] . '</td></tr>'; }
		if(isset($d['receipt_id'])) { echo '<tr><td>receipt_id</td><td>' . $d['receipt_id'] . '</td></tr>'; }
		if(isset($d['receiver_email'])) { echo '<tr><td>receiver_email</td><td>' . $d['receiver_email'] . '</td></tr>'; }
		if(isset($d['receiver_id'])) { echo '<tr><td>receiver_id</td><td>' . $d['receiver_id'] . '</td></tr>'; }
		if(isset($d['residence_country'])) { echo '<tr><td>residence_country</td><td>' . $d['residence_country'] . '</td></tr>'; }
		if(isset($d['shipping'])) { echo '<tr><td>shipping</td><td>' . $d['shipping'] . '</td></tr>'; }
		if(isset($d['tax'])) { echo '<tr><td>tax</td><td>' . $d['tax'] . '</td></tr>'; }
		if(isset($d['txn_id'])) { echo '<tr><td>txn_id</td><td>' . $d['txn_id'] . '</td></tr>'; }
		if(isset($d['txn_type'])) { echo '<tr><td>txn_type</td><td>' . $d['txn_type'] . '</td></tr>'; }
		//if(isset($d['verify_sign'])) { echo '<tr><td>verify_sign</td><td>' . $d['verify_sign'] . '</td></tr>'; }
		echo '</table>';
		echo '
			<br>
			<form id="setorderid">
			<input type="hidden" name="pid" value="'.$pid.'">
			<input type="hidden" name="a" value="updateorderid">
			<input type="text" name="neworderid" >&nbsp;&nbsp;
			<input type="submit" value="Set Order ID">
			<br><br>
			<a href="#" id="closelink2">close</a>
			<br><br>
			</form>
			<script type="text/javascript">
				$("form#setorderid").submit(function() {
					jQuery.ajax({
						url: "paypal.php",
						type: "GET",
						data: $("form#setorderid").serialize(),
						dataType: "HTML",
						timeout: 2000,
						error: function() {
							alert("Failed to update payment");
						},
						success: function(r) {
							window.location.reload(false);
						}
					});
					return false;
				});
				
				$("#closelink").click(function(){
					tb_remove();
					return false;
				});
				
				$("#closelink2").click(function(){
					tb_remove();
					return false;
				});
			</script>
			</div></div>';
		break;
	case 'updateorderid':
		//print_r($_GET);
		$pid = sanitize_int($_GET['pid']);
		$orderid = sanitize_int($_GET['neworderid']);
		dbquery("UPDATE payments SET orderid = '$orderid' WHERE paymentid = '$pid'");
		$url = OW_URL . 'paypal.php';
		echo '
			<script type="text/javascript">
			<!--
			//window.location = "'.$url.'"
			//-->
			</script>';
		break;
	case 'viewpaypalnoid':
		displayHeader("jquery", "orange","Paypal Payments without order IDs");
		echo '<div style="width:90%">';
		echo '<h1>Payments</h1>';
		$payments = dbfetcharray("SELECT top 100 * FROM payments WHERE orderid = 0 ORDER BY dateentered DESC");
		echo '<div class="roundedbox datatable"><table id="orderstable" style="width:90%;"><thead><tr><th class="header">Date</td><th class="header">Transaction ID</td><th class="header">Status</td><th class="header">Amout</td><th class="header">Actions</td></tr></thead><tbody>';
		foreach($payments as $p) {
			//displayandstring($p);
			$d = date('M d, Y g:i A', strtotime($p['dateentered']));
			$m = money_round_usd($p['debit']);
			//http://72.32.178.3/om/order.php?orderid=1232104&a=sendemailform&modal=true&width=335&height=415
			echo '<tr><td>' . $d . '</td><td>' . $p['number'] . '</td><td>' . $p['resultcode'] . '</td><td>$ ' . $m .'</td><td><a href="paypal.php?a=viewpayment&modal=true&width=500&height=500&pid='.$p['paymentid'].'" class="thickbox">View Details</a></td></tr>';
		}
		echo '</tbody></table></div></div>
			<script>
			//Setup Table Sorter
			$(document).ready(function() { 
				$("#orderstable").tablesorter({ 
					// sort on the first column and third column, order asc 
					sortList: [[0,1]]
				});
			});
			</script>';
		displayFooter();
		break;
	case 'searchbytransactionid':
		displayHeader("jquery", "orange","Paypal Payments without order IDs");
		echo '<h1>Payments</h1>';
		$tranid = sanitize_str($_GET['tranid']);
		$payments = dbfetcharray("SELECT top 50 * FROM paypaldata WHERE ppdata LIKE '%$tranid%' order by ppdate desc");
		foreach ($payments as $p) {
			$data = unserialize($p['ppdata2']);
			displayandstring($data);
		}
		break;
	case 'viewreportbydates':
		displayHeader("jquery", "orange","Paypal Payments without order IDs");
		$startdate = sanitize_str($_POST['startdate']);
		$enddate = sanitize_str($_POST['enddate']);
		
		$company = sanitize_int($_POST['seller']);
		
		$kstartdate = date('m/d/y', strtotime($startdate));
		$kenddate = date('m/d/y', strtotime($enddate));
		
		switch ($company) {
			case '1':
				$title = "Paypal $kstartdate to $kenddate for Sunshine";
				$companyrange = "'sun','dsn'";
				break;
			default:
				$title = "Paypal $kstartdate to $kenddate for Pyxis";
				$companyrange = "'pyxis'";
				break;
		}
		
		$data = dbfetcharray("SELECT orderid, dateentered, number, debit, resultcode, (SELECT TOP 1 data FROM paymentupdates WHERE transactionid = p.number ORDER BY paymentupdateid DESC) as data FROM payments p WHERE type = 'Paypal' AND dateentered between '$startdate 00:00:00.000' AND '$enddate 23:59:00.000' and (SELECT company FROM orders WHERE orderid = p.orderid) in ($companyrange) ORDER BY dateentered DESC");
		
		echo '<h2>' . $title . '</h2><br>';
		echo '<a href="paypal.php">Back</a><br><br>';
		echo '<table>
				<thead><tr>
					<th>Date</th>
					<th>Gross</th>
					<th>Name/Email</th>
					<th>Transaction ID</th>
					<th>Status (Paypal / OW)</th>
					<th>Ok to ship&nbsp;&nbsp;&nbsp;<a href="#" id="oktoshipinfo">Info</a></th>
				</tr></thead><tbody>';
				
		foreach ($data as $r) {
			$d = date( 'm/d/y', strtotime($r['dateentered']));
			$pp = unserialize($r['data']);
			echo '<tr><td>' . $d . '</td><td>' . money_round_usd($r['debit']) . '</td><td>' . $pp['address_name'] . '</td><td><a href="http://ow.pyxiscamera.com/order.php?orderid='.$r['orderid'].'">' . $r['number'] . '</a></td><td>'.$pp['payment_status'].' / ' . $r['resultcode'] . '</td><td><span class="printhide">';
			if($pp['protection_eligibility'] == 'Eligible') {
				echo '<img src="inc/img/fff/accept.png">';
			} else if($pp['protection_eligibility'] == 'Ineligible') {
				echo '<img src="inc/img/fff/exclamation.png">';
			} else {
				echo '<img src="inc/img/fff/sport_tennis.png">';				
			}
			
			echo '</span>&nbsp;' . $pp['protection_eligibility'] . '</td></tr>';
		}
		echo '</tbody></table>';
		echo '
				<style type="text/css" media="print">
					.printhide {
						display:none;
					}
				</style>
				';
		echo '
				<script type="text/javascript">
					$("#oktoshipinfo").click(function(){
						alert(\'A item is marked as Ok to ship if its eligible or partially eligible for seller protection\');
						return false;
					});
				</script>';
		break;
	default:
		displayHeader("jquery", "orange","Paypal Payments without order IDs");
		echo '<h1>Payments</h1>';
		echo '
				<div class="span-18">
				<form action="paypal.php" method="POST">
					<input type="hidden" name="a" value="viewreportbydates" >
					<b>Seller:</b>&nbsp;&nbsp;
					<select name="seller" style="width:110px;">
						<option value="1">Sunshine</option>
						<option value="2">Pyxis</option>
					</select>	
					<b>Start:</b>	&nbsp;<input type="text" name="startdate" value="" class="ppreportdate">&nbsp;<img src="inc/img/fff/date.png" style="vertical-align:middle;">
					<b>End:</b>		&nbsp;<input type="text" name="enddate" value="" class="ppreportdate">&nbsp;<img src="inc/img/fff/date.png" style="vertical-align:middle;">
					<input type="submit" value="View Report">
				</form>
				<script type="text/javascript" src="inc/js/jquery/ui.datepicker.js"></script>
				<script>
					$(document).ready(function() {
						$(\'.ppreportdate\').datepicker({dateFormat: "yy-mm-dd"});
					});
				</script>
				</div>
				<div class="span-10 last">
		';
		echo '<form action="paypal.php" method="GET"><input type="hidden" name="a" value="searchbytransactionid"><input type="text" name="tranid" value=""><input type="submit" value="Search"></div>';
		echo '</form><br><br><div id="redirectplaceholder">&nbsp;</div>';
		$payments = dbfetcharray("SELECT top 100 * FROM payments WHERE orderid = 0 ORDER BY dateentered DESC");
		echo '<div class="roundedbox datatable"><table id="orderstable" style="width:100%;"><thead><tr><th class="header">Date</td><th class="header">Transaction ID</td><th class="header">Status</td><th class="header">Amout</td><th class="header">Actions</td></tr></thead><tbody>';
		foreach($payments as $p) {
			//displayandstring($p);
			$d = date('M d, Y g:i A', strtotime($p['dateentered']));
			$m = money_round_usd($p['debit']);
			//http://72.32.178.3/om/order.php?orderid=1232104&a=sendemailform&modal=true&width=335&height=415
			echo '<tr><td>' . $d . '</td><td>' . $p['number'] . '</td><td>' . $p['resultcode'] . '</td><td>$ ' . $m .'</td><td><a href="paypal.php?a=viewpayment&modal=true&width=800&height=500&pid='.$p['paymentid'].'" class="thickbox">View Details</a></td></tr>';
		}
		echo '</tbody></table></div>
			<script>
			//Setup Table Sorter
			$(document).ready(function() { 
				$("#orderstable").tablesorter({ 
					// sort on the first column and third column, order asc 
					sortList: [[0,1]]
				});
			});
			</script>';
		displayFooter();
		break;
		/*
		displayHeader("jquery", "orange","Order $orderid");
		echo '<h1>Payments</h1>';
		echo '<a href="paypal.php?a=viewpaypalnoid">View PayPal Payments withouot a ID</a>&nbsp;&nbsp;|&nbsp;&nbsp;<br><br>';
		echo '<form action="paypal.php" method="GET"><input type="hidden" name="a" value="searchbytransactionid"><input type="text" name="tranid" value=""><input type="submit" value="Search">';
				
		echo '</form>';
		$payments = dbfetcharray("SELECT top 50 * FROM paypaldata WHERE ppdata LIKE '%0X2788091X527094S%' order by ppdate desc");
		$payment_type = array();
		$txn_type = array();
		$address_status = array();
		$charset = array();
		$notify_version = array();
		$payment_status = array();
 
		foreach ($payments as $p) {
			$data = unserialize($p['ppdata2']);
			displayandstring($data);
		//	echo '<br>';
		//	echo $data['payment_type'];
			$payment_type[] = $data['payment_type'];
			$txn_type[] = $data['txn_type'];
			$address_status[] = $data['address_status'];
			$charset[] = $data['charset'];
			$notify_version[] = $data['notify_version'];
			$payment_status[] = $data['payment_status'];
		}
		
		echo '<pre>';
		echo 'payment type<br>';
		print_r(array_unique($payment_type));
		echo 'txn_type<br>';
		print_r(array_unique($txn_type));
		echo 'address_status<br>';
		print_r(array_unique($address_status));
		echo 'charset<br>';
		print_r(array_unique($charset));
		echo 'notify_version<br>';
		print_r(array_unique($notify_version));
		echo 'payment_status<br>';
		print_r(array_unique($payment_status));
		echo 'address_status<br>';
		print_r(array_unique($address_status));
 
		echo '</pre>';
 
		echo '<br><br>';
		*/
		
		break;
}
 
function displayandstring($data) {
	echo '<pre>';
	print_r($data);
	echo '</pre>';	
}
 
 
 
echo "<pre>\n";
var_dump($_POST);
echo "</pre>\n";
$post = ob_get_contents();
echo $post;
mail('You@Your.org', 'POST VARS', $post);
?>

Open in new window

0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 8

Accepted Solution

by:
biztiger earned 2000 total points
ID: 26068485
Do you mean the $key variable in the following line:-
foreach (dbquery($sql) as $key => $value) {

That line simply generates the variables(with value) from your sql query. That key is not related to paypal transaction.


0
 

Author Comment

by:rgb192
ID: 26069020
on developer.paypal.com
does someone register for a
username
or
authorization key
or
api key
0
 
LVL 8

Expert Comment

by:biztiger
ID: 26069078
On developer.paypal.com when you register, you will get a username(your email) and password. Now, with your base developer account you can create multiple dummy paypal account with fake email.

To use paypal api read this:-
https://cms.paypal.com/us/cgi-bin/?cmd=_render-content&content_ID=developer/e_howto_api_NVPAPIBasics
0
 
LVL 111

Expert Comment

by:Ray Paseur
ID: 26071473
You might want to look at line 370 of the code snippet posted above.  Where it says You @ Your.org - that is supposed to be an email address.  Preferably YOUR email address.  That way you can see the information that was sent in by the POST to this script, as well as any messages generated by the script.

Best of luck with it, ~Ray
0
 

Author Closing Comment

by:rgb192
ID: 31666916
ok
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

WooCommerce is becoming the most powerful e-commerce plugin for Wordpress. And why not. The platform comprises of numerous core plugins that may come in handy, powerful options to make your website development task much easier.
The Internet has made sending and receiving information online a breeze. But there is also the threat of unauthorized viewing, data tampering, and phoney messages. Surprisingly, a lot of business owners do not fully understand how to use security t…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.
Suggested Courses
Course of the Month13 days, 19 hours left to enroll

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question