Hi, am trying to post the information relating to a successful (as in paid) paypal transaction in membership to another custom global custom table i created
I see in the membership plugin under gateway/paypalexpress.php is the following code to add info to affiliates plugin (line 788)
// Added for affiliate system link do_action('membership_payment_processed', $user_id, $sub_id, $amount, $currency, $_POST['txn_id']); break;
In my case i would like to insert this data into a table with structure
id mediumint(9) NOT NULL AUTO_INCREMENT, user_id bigint(20), invited_email varchar(255) DEFAULT NULL, reference varchar(255) DEFAULT NULL, commission bigint(20) DEFAULT '0', amount decimal(11,2) DEFAULT '0.00', referred bigint(20)DEFAULT NULL, datestamp datetime DEFAULT NULL, PRIMARY KEY (id)
Now before I go and screw things up, would just like to know if i code wpdb->insert after this part of the code (line 789), would it basically write every successful and paid for paypal subscription to my custom table?
What I want this table to store basically are a list of paid signups from the membership system, and any purchases from a woocommerce shop system, the idea is that it would contain a combined list of transactions from two diff systems, that I could query to pull a list of all paid transactions for a particular user, which in turn i could use for reports and calculating commissions from