developer.paypal.com login ids

is there a 32 digit alphanumeric number that is a "key"

what is a "key"
LVL 1
rgb192Asked:
Who is Participating?
 
biztigerConnect With a Mentor Commented:
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
 
Ray PaseurCommented:
In what context do you find the term used?
0
 
Ray PaseurCommented:
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
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
rgb192Author Commented:
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
 
rgb192Author Commented:
on developer.paypal.com
does someone register for a
username
or
authorization key
or
api key
0
 
biztigerCommented:
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
 
Ray PaseurCommented:
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
 
rgb192Author Commented:
ok
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.