https://legacy.forums.gravityhelp.com/topic/paypal-and-user-reg-add-ons-how-to-and-where Gravity Support Forums Topic: PayPal and user reg. add ons, how to and where? en-US Sun, 05 Apr 2026 10:47:10 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/paypal-and-user-reg-add-ons-how-to-and-where#post-19532 Mon, 28 Feb 2011 12:04:07 +0000 Alex Cancado 19532@https://legacy.forums.gravityhelp.com/ <p>Here we go.</p> <p>1.<br /> The PayPal transactions are stored in a separate table. It is called wp_rg_paypal_transaction. It keeps all paypal transactions (i.e. payments, refunds, etc...)</p> <p>2.<br /> PayPal transactions are added as notes for that entry, so you can view all transactions by going through the entry notes on the entry detail page.<br /> To output all transactions in a different format, you would have to query the wp_rg_paypal_transaction table and manually output them.</p> <p>You add the "Payment Status", "Payment Amount" and "Payment Date" columns to the entry grid. Simply click the edit link on the top right corner of the entry grid and drag those columns to the active list.</p> <p>3.<br /> There is no easy function for you here, but it is possible to achieve what you need. If the user is logged in when submitting the form, the user_id is stored in the entry table (wp_rg_lead table, created_by column).<br /> If you query the wp_rg_lead table where created_by = user_id, you will get all entries submitted by that user. You can then inspect the payment_status column to determine if the product has been paid and you can determine which product was purchased by the form_id.<br /> If you need to get more information about which specific product was purchased, you can call RGFormsModel::get_lead($lead_id), where lead_id is the the ID column of the wp_rg_lead table. This will give you all the information about that entry.</p> <p>4.<br /> There is no interface in the user profile for this. When a subscription is expired, the entry's payment status will be set to "Expired". You can see that by adding the Payment Status to the entry grid, going to the entry detail page,<br /> or manually querying the wp_rg_lead table for the specific user_id (similar to 3) and inspecting the payment_status column.</p> <p>5.<br /> I have not had long delays with the test IPNs. They usually happen within a minute or two. If you are developing locally, however, the IPN just won't work since PayPal won't be able to reach <a href="http://localhost/..." rel="nofollow">http://localhost/...</a>.</p> <p>I hope this helps. </p> https://legacy.forums.gravityhelp.com/topic/paypal-and-user-reg-add-ons-how-to-and-where#post-19398 Fri, 25 Feb 2011 11:54:27 +0000 obvio 19398@https://legacy.forums.gravityhelp.com/ <p>hi,<br /> I've been playing with both and they're working pretty cool but I have a couple of questions so I'll better understand how this can be applied to my needs:</p> <p>1. where're the paypal transactions are stored? own table or as meta to a form/post submission?</p> <p>2. can I somehow output all the transactions? can the transaction status can be seen as a column in the entries table ui?</p> <p>3. say a registered user bought a product "gold package" (for example: gives him the ability to post 5 listings and mark 2 as "top" listing), how do I get the purchases (and their statuses) associated with this specific user? is there something like:<br /> <code>get_user_purchase_history($user_id)</code> for example?</p> <p>4. similar to 3, if a user bought a monthly subscription product, how do I access that info in relation to the user? how do I make sure it is still valid? is that shown somehow in the interface of the user profile?</p> <p>5. on general: when using ipn on test-mode with paypal test-site, does it take a while to get the confirmation back?</p> <p>I'll be happy to some code samples (or point me to which of the files contains those functions in the plugin).</p> <p>thanks! </p>