Gravity Support Forums Topic: Table field data explanation for the paypal add-on

Gravity Support Forums Topic: Table field data explanation for the paypal add-on https://legacy.forums.gravityhelp.com/topic/table-field-data-explanation-for-the-paypal-add-on Gravity Support Forums Topic: Table field data explanation for the paypal add-on en-US Sat, 04 Apr 2026 18:20:08 +0000 http://bbpress.org/?v=1.0.1 <![CDATA[Search]]> q https://legacy.forums.gravityhelp.com/search.php antonv on "Table field data explanation for the paypal add-on" https://legacy.forums.gravityhelp.com/topic/table-field-data-explanation-for-the-paypal-add-on#post-48279 Fri, 03 Feb 2012 13:35:45 +0000 antonv 48279@https://legacy.forums.gravityhelp.com/ Thank you! Alex Cancado on "Table field data explanation for the paypal add-on" https://legacy.forums.gravityhelp.com/topic/table-field-data-explanation-for-the-paypal-add-on#post-48185 Thu, 02 Feb 2012 15:47:36 +0000 Alex Cancado 48185@https://legacy.forums.gravityhelp.com/ Hello Anton, Below are the answers to your questions: I am assuming that the is_active from wp_rg_paypal would have a value of 0 if the subscription is inactive and a value of 1 or any other number when the subscription is active. <blockquote>Yes, that is correct.</blockquote> From the wp_rg_paypal_transaction, would you be able to give me a short description of the data entered in the following fields: transaction_type <blockquote>The type of transaction that was performed. Possible values are: payment -> a payment was made reversal -> a reversal of a payment was made reinstated -> a payment that was previously reversed has been reinstated denied -> a payment was denied pending -> a payment is in the process of being verified by PayPal refund -> a refund has been issued on a payment void -> a payment has been voided processed -> a payment has been accepted. </blockquote> subscription_id <blockquote> If this is a recurring payment, the subscription ID will be added here </blockquote> transaction_id <blockquote> PayPal unique transaction ID </blockquote> parent_transaction_id <blockquote> If this transaction is related to another previously processed transaction, this field will contain the transaction ID of the original transaction. For example, the parent transaction of a refund transaction is the original payment transaction </blockquote> is_renewal <blockquote> Has a value of 1 if this is a renewal payment. 0 if this is a one time payment of if this is the first payment of a subscription. </blockquote> amount <blockquote> Transaction amount </blockquote> date_created <blockquote> The date that this transaction was created </blockquote> Now, the date_created I am assuming that would be the date when the subscription was started. If that is the case, where would I find the renewal date? I need that as during each subscription period, the users would be allowed to create a limited amount of posts. <blockquote> The renewal dates will be in transactions with the same subscription_id and the is_renewal column with a value of 1 </blockquote> And the last question is regarding the user. How can I get the subscription data for the logged in user? I haven't seen any kind of connection to the users table... <blockquote> The best way to do this is to use the User Registration Add-On and configure it to create the user when payment is made. Then, you will be able to get the entry ID via the "entry_id" user meta. With the entry_id, you will be able to get all transactions associated with it, via the entry_id column. </blockquote> antonv on "Table field data explanation for the paypal add-on" https://legacy.forums.gravityhelp.com/topic/table-field-data-explanation-for-the-paypal-add-on#post-47185 Tue, 24 Jan 2012 01:53:26 +0000 antonv 47185@https://legacy.forums.gravityhelp.com/ No ideas? antonv on "Table field data explanation for the paypal add-on" https://legacy.forums.gravityhelp.com/topic/table-field-data-explanation-for-the-paypal-add-on#post-47067 Sat, 21 Jan 2012 21:10:10 +0000 antonv 47067@https://legacy.forums.gravityhelp.com/ Hi guys, I'm starting the planning phase of a custom membership implementation and I would like to use the data collected by GF when a new subscription is created. I've looked at the tables and I see that the 2 tables I need to work with are: wp_rg_paypal and wp_rg_paypal_transaction. I am assuming that the is_active from wp_rg_paypal would have a value of 0 if the subscription is inactive and a value of 1 or any other number when the subscription is active. From the wp_rg_paypal_transaction, would you be able to give me a short description of the data entered in the following fields: transaction_type subscription_id transaction_id parent_transaction_id is_renewal amount date_created Now, the date_created I am assuming that would be the date when the subscription was started. If that is the case, where would I find the renewal date? I need that as during each subscription period, the users would be allowed to create a limited amount of posts. And the last question is regarding the user. How can I get the subscription data for the logged in user? I haven't seen any kind of connection to the users table... Thank you, Anton