grant Posted February 27, 2011 Share Posted February 27, 2011 ok i have this to call back to paypal but when i buy a item its not giveing the users they item or points ? any help plz <?php include "dbcon.php"; function Send_Event ($id, $text){ $timesent = time(); $text = mysql_real_escape_string($text); $result= mysql_query("INSERT INTO `events` (`to`, `timesent`, `text`)". "VALUES ('$id', '$timesent', '$text')"); } function microtime_float() { $time = microtime(); return (double)substr( $time, 11 ) + (double)substr( $time, 0, 8 ); } $time = microtime_float(); // read the post from PayPal system and add 'cmd' $req = 'cmd=_notify-validate'; foreach ($_POST as $key => $value) { $value = urlencode(stripslashes($value)); $req .= "&$key=$value"; } // post back to PayPal system to validate $header .= "POST /cgi-bin/webscr HTTP/1.0\r\n"; $header .= "Content-Type: application/x-www-form-urlencoded\r\n"; $header .= "Content-Length: " . strlen($req) . "\r\n\r\n"; $fp = fsockopen ('www.paypal.com', 80, $errno, $errstr, 30); // assign posted variables to local variables $item_name = $_POST['item_name']; $item_number = $_POST['item_number']; $payment_status = $_POST['payment_status']; $payment_amount = $_POST['mc_gross']; $payment_currency = $_POST['mc_currency']; $txn_id = $_POST['txn_id']; $receiver_email = $_POST['receiver_email']; $payer_email = $_POST['payer_email']; $first = $_POST['first_name']; $last = $_POST['last_name']; $quantity = $_POST['quantity']; $user_id = $_POST['custom']; $result1000 = mysql_query("INSERT INTO `ipn` (`itemname`, `date`, `itemnumber`, `paymentstatus`, `paymentamount`, `currency`, `txnid`, `receiveremail`, `payeremail`, `first`, `last`, `quantity`, `user_id`)"."VALUES ('".$item_name."', '$time', '".$item_number."', '".$payment_status."', '".$payment_amount."', '".$payment_currency."', '".$txn_id."', '".$receiver_email."', '".$payer_email."', '".$first."', '".$last."', '".$quantity."', '".$user_id."')"); $result2 = mysql_query("SELECT*FROM `grpgusers` WHERE `id`='".$user_id."'"); $worked = mysql_fetch_array($result2); if ($item_number == 1 && $payment_status == "Completed"){ $usermoney = $worked['bank'] + 10000; $userpoints = $worked['points'] + 50; $userrmdays = $worked['rmdays'] + 30; $result = mysql_query("UPDATE `grpgusers` SET `rmdays`='".$userrmdays."', `points`='".$userpoints."', `bank`='".$usermoney."' WHERE `id`='".$user_id."'"); Send_Event($user_id, "Your ".$item_name." has just been credited. Transaction id: ".$txn_id." "); } if ($item_number == 2 && $payment_status == "Completed"){ $usermoney = $worked['bank'] + 25000; $userpoints = $worked['points'] + 125; $userrmdays = $worked['rmdays'] + 60; $result = mysql_query("UPDATE `grpgusers` SET `rmdays`='".$userrmdays."', `points`='".$userpoints."', `bank`='".$usermoney."' WHERE `id`='".$user_id."'"); Send_Event($user_id, "Your ".$item_name." has just been credited. Transaction id: ".$txn_id." "); } if ($item_number == 3 && $payment_status == "Completed"){ $usermoney = $worked['bank'] + 75000; $userpoints = $worked['points'] + 300; $userrmdays = $worked['rmdays'] + 90; $result = mysql_query("UPDATE `grpgusers` SET `rmdays`='".$userrmdays."', `points`='".$userpoints."', `bank`='".$usermoney."' WHERE `id`='".$user_id."'"); Send_Event($user_id, "Your ".$item_name." has just been credited. Transaction id: ".$txn_id." "); } if ($item_number == 4 && $payment_status == "Completed"){ $userpoints = $worked['points'] + 250; $result = mysql_query("UPDATE `grpgusers` SET `points`='".$userpoints."' WHERE `id`='".$user_id."'"); Send_Event($user_id, "Your ".$item_name." has just been credited. Transaction id: ".$txn_id." "); } if ($item_number == 5 && $payment_status == "Completed"){ $userpoints = $worked['points'] + 500; $result = mysql_query("UPDATE `grpgusers` SET `points`='".$userpoints."' WHERE `id`='".$user_id."'"); Send_Event($user_id, "Your ".$item_name." has just been credited. Transaction id: ".$txn_id." "); } if ($item_number == 6 && $payment_status == "Completed"){ $userpoints = $worked['points'] + 1000; $result = mysql_query("UPDATE `grpgusers` SET `points`='".$userpoints."' WHERE `id`='".$user_id."'"); Send_Event($user_id, "Your ".$item_name." has just been credited. Transaction id: ".$txn_id." "); } if ($item_number == 7 && $payment_status == "Completed"){ $userpoints = $worked['points'] + 2500; $result = mysql_query("UPDATE `grpgusers` SET `points`='".$userpoints."' WHERE `id`='".$user_id."'"); Send_Event($user_id, "Your ".$item_name." has just been credited. Transaction id: ".$txn_id." "); } if ($item_number == 8 && $payment_status == "Completed"){ $userpoints = $worked['points'] + 5000; $result = mysql_query("UPDATE `grpgusers` SET `points`='".$userpoints."' WHERE `id`='".$user_id."'"); Send_Event($user_id, "Your ".$item_name." has just been credited. Transaction id: ".$txn_id." "); } if ($item_number == 9 && $payment_status == "Completed"){ $userpoints = $worked['points'] + 10000; $result = mysql_query("UPDATE `grpgusers` SET `points`='".$userpoints."' WHERE `id`='".$user_id."'"); Send_Event($user_id, "Your ".$item_name." has just been credited. Transaction id: ".$txn_id." "); } if ($item_number == 10 && $payment_status == "Completed"){ $userpoints = $worked['points'] + 20000; $result = mysql_query("UPDATE `grpgusers` SET `points`='".$userpoints."' WHERE `id`='".$user_id."'"); Send_Event($user_id, "Your ".$item_name." has just been credited. Transaction id: ".$txn_id." "); } if ($item_number == 11 && $payment_status == "Completed"){ $userpoints = $worked['points'] + 30000; $result = mysql_query("UPDATE `grpgusers` SET `points`='".$userpoints."' WHERE `id`='".$user_id."'"); Send_Event($user_id, "Your ".$item_name." has just been credited. Transaction id: ".$txn_id." "); } if ($item_number == 12 && $payment_status == "Completed"){ $userpoints = $worked['points'] + 50000; $result = mysql_query("UPDATE `grpgusers` SET `points`='".$userpoints."' WHERE `id`='".$user_id."'"); Send_Event($user_id, "Your ".$item_name." has just been credited. Transaction id: ".$txn_id." "); } if ($item_number == 13 && $payment_status == "Completed"){ $userpoints = $worked['points'] + 85000; $result = mysql_query("UPDATE `grpgusers` SET `points`='".$userpoints."' WHERE `id`='".$user_id."'"); Send_Event($user_id, "Your ".$item_name." has just been cedited. Transaction id: ".$txn_id." "); } if ($item_number == 14 && $payment_status == "Completed"){ $userpoints = $worked['points'] + 100000; $result = mysql_query("UPDATE `grpgusers` SET `points`='".$userpoints."' WHERE `id`='".$user_id."'"); Send_Event($user_id, "Your ".$item_name." has just been credited. Transaction id: ".$txn_id." "); } if ($item_number == 15 && $payment_status == "Completed"){ $userpoints = $worked['points'] + 250000; $result = mysql_query("UPDATE `grpgusers` SET `points`='".$userpoints."' WHERE `id`='".$user_id."'"); Send_Event($user_id, "Your ".$item_name." has just been credited. Transaction id: ".$txn_id." "); } $result = mysql_query("SELECT * FROM `inventory` WHERE `userid`='".$user_id."' AND `itemid`='42'"); $worked2 = mysql_fetch_array($result); $itemexist = mysql_num_rows($result); if($item_number == 16 && $itemexist == 0 && $payment_status == "Completed"){ $result= mysql_query("INSERT INTO `inventory` (`itemid`, `userid`, `quantity`)"."VALUES ('42', '".$user_id."', '1')"); Send_Event($user_id, "Your ".$item_name." has just been credited. Transaction id: ".$txn_id." "); } if($item_number == 16 && $itemexist > 0 && $payment_status == "Completed"){ $quantity = $worked2['quantity'] + 1; $result = mysql_query("UPDATE `inventory` SET `quantity` = '".$quantity."' WHERE `userid`='".$user_id."' AND `itemid`='42'"); Send_Event($user_id, "Your ".$item_name." has just been credited. Transaction id: ".$txn_id." "); } if($item_number == 17 && $itemexist == 0 && $payment_status == "Completed"){ $result= mysql_query("INSERT INTO `inventory` (`itemid`, `userid`, `quantity`)"."VALUES ('42', '".$user_id."', '5')"); Send_Event($user_id, "Your ".$item_name." has just been credited. Transaction id: ".$txn_id." "); } if($item_number == 17 && $itemexist > 0 && $payment_status == "Completed"){ $quantity = $worked2['quantity'] + 5; $result = mysql_query("UPDATE `inventory` SET `quantity` = '".$quantity."' WHERE `userid`='".$user_id."' AND `itemid`='42'"); Send_Event($user_id, "Your ".$item_name." has just been credited. Transaction id: ".$txn_id." "); } if($item_number == 18 && $itemexist == 0 && $payment_status == "Completed"){ $result= mysql_query("INSERT INTO `inventory` (`itemid`, `userid`, `quantity`)"."VALUES ('42', '".$user_id."', '20')"); Send_Event($user_id, "Your ".$item_name." has just been credited. Transaction id: ".$txn_id." "); } if($item_number > 18 && $itemexist == 0 && $payment_status == "Completed"){ $quantity = $worked2['quantity'] + 25; $result = mysql_query("UPDATE `inventory` SET `quantity` = '".$quantity."' WHERE `userid`='".$user_id."' AND `itemid`='42'"); Send_Event($user_id, "Your ".$item_name." has just been credited. Transaction id: ".$txn_id." "); } if($item_number == 19 && $itemexist == 0 && $payment_status == "Completed"){ $result= mysql_query("INSERT INTO `inventory` (`itemid`, `userid`, `quantity`)"."VALUES ('42', '".$user_id."', '50')"); Send_Event($user_id, "Your ".$item_name." has just been credited. Transaction id: ".$txn_id." "); } if($item_number == 19 && $itemexist > 0 && $payment_status == "Completed"){ $quantity = $worked2['quantity'] + 50; $result = mysql_query("UPDATE `inventory` SET `quantity` = '".$quantity."' WHERE `userid`='".$user_id."' AND `itemid`='42'"); Send_Event($user_id, "Your ".$item_name." has just been credited. Transaction id: ".$txn_id." "); } if($item_number == 20 && $payment_status == "Completed"){ $quantity = $worked['colordays'] + 30; $result = mysql_query("UPDATE `grpgusers` SET `colordays` = '".$quantity."' WHERE `id`='$user_id'"); Send_Event($user_id, "Your 30 name color days has just been credited. Transaction id: ".$txn_id." "); } if($item_number == 21 && $payment_status == "Completed"){ $quantity = $worked['colordays'] + 60; $result = mysql_query("UPDATE `grpgusers` SET `colordays` = '".$quantity."' WHERE `userid`='".$user_id."'"); Send_Event($user_id, "Your 60 name color days has just been credited. Transaction id: ".$txn_id." "); } if($item_number == 22 && $payment_status == "Completed"){ $quantity = $worked['colordays'] + 90; $result = mysql_query("UPDATE `grpgusers` SET `colordays` = '".$quantity."' WHERE `userid`='".$user_id."'"); Send_Event($user_id, "Your 90 name color days has just been credited. Transaction id: ".$txn_id." "); } $result = mysql_query("SELECT * FROM `inventory` WHERE `userid`='".$user_id."' AND `itemid`='81'"); $worked2 = mysql_fetch_array($result); $itemexist = mysql_num_rows($result); if($item_number == 23 && $itemexist == 0 && $payment_status == "Completed"){ $result= mysql_query("INSERT INTO `inventory` (`itemid`, `userid`, `quantity`)"."VALUES ('81', '".$user_id."', '10')"); Send_Event($user_id, "Your ".$item_name." has just been credited. Transaction id: ".$txn_id." "); } if($item_number == 23 && $itemexist > 0 && $payment_status == "Completed"){ $quantity = $worked2['quantity'] + 10; $result = mysql_query("UPDATE `inventory` SET `quantity` = '".$quantity."' WHERE `userid`='".$user_id."' AND `itemid`='81'"); Send_Event($user_id, "Your ".$item_name." has just been credited. Transaction id: ".$txn_id." "); } $result = mysql_query("SELECT * FROM `inventory` WHERE `userid`='".$user_id."' AND `itemid`='82'"); $worked2 = mysql_fetch_array($result); $itemexist = mysql_num_rows($result); if($item_number == 24 && $itemexist == 0 && $payment_status == "Completed"){ $result= mysql_query("INSERT INTO `inventory` (`itemid`, `userid`, `quantity`)"."VALUES ('82', '".$user_id."', '10')"); Send_Event($user_id, "Your ".$item_name." has just been credited. Transaction id: ".$txn_id." "); } if($item_number == 24 && $itemexist > 0 && $payment_status == "Completed"){ $quantity = $worked2['quantity'] + 10; $result = mysql_query("UPDATE `inventory` SET `quantity` = '".$quantity."' WHERE `userid`='".$user_id."' AND `itemid`='82'"); Send_Event($user_id, "Your ".$item_name." has just been credited. Transaction id: ".$txn_id." "); } $result = mysql_query("SELECT * FROM `inventory` WHERE `userid`='".$user_id."' AND `itemid`='83'"); $worked2 = mysql_fetch_array($result); $itemexist = mysql_num_rows($result); if($item_number == 25 && $itemexist == 0 && $payment_status == "Completed"){ $result= mysql_query("INSERT INTO `inventory` (`itemid`, `userid`, `quantity`)"."VALUES ('83', '".$user_id."', '10')"); Send_Event($user_id, "Your ".$item_name." has just been credited. Transaction id: ".$txn_id." "); } if($item_number == 25 && $itemexist > 0 && $payment_status == "Completed"){ $quantity = $worked2['quantity'] + 10; $result = mysql_query("UPDATE `inventory` SET `quantity` = '".$quantity."' WHERE `userid`='".$user_id."' AND `itemid`='83'"); Send_Event($user_id, "Your ".$item_name." has just been credited. Transaction id: ".$txn_id." "); } ?> and this is wot users are buy it from not sure if this is set up wright <table width="100%" border="0" align="center" class="contenthead"> <tr> <td height="21" align="center">[b]Points buy[/b]</td> </tr> </table> <table width="100%" border="0" class="contentcontent"> <tr> <td height="40"><td align="center">3,500 Point Pack</td> <td align="center">3,500</td> <td align="center">$10.00</td> <form action="https://www.paypal.com/cgi-bin/webscr" method="post"> <td align="center"> <input type=hidden name=cmd value=_xclick> <input type="hidden" name="business" value="....my paypal acount...."> <input type="hidden" name="item_name" value="mafia-warriors.net|DP|4|<? echo $user_class->id ?>"> <input type="hidden" name="amount" value="10.00"> <input type="hidden" name="no_shipping" value="1"> <input type="hidden" name="return" value="http://www.mafia-warriors.net/donatordone.php?payment=done"> <input type="hidden" name="cancel_return" value="http://www.mafia-warriors.net/donatordone.php"> <input type="hidden" name="notify_url" value="http://www.mafia-warriors.net/vote.php"> <input type="hidden" name="currency_code" value="USD"> <input type="hidden" name="tax" value="0"> <input type="hidden" name="on0" value="username"> <input type="hidden" name="os0" value="<? echo $user_class->username ?>" maxlength="60" > <input type="image" src="https://www.paypal.com/en_US/i/btn/x-click-but23.gif" width="68" height="23" border="0" name="submit" alt=""> </td> </form> </td> </tr> Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.