Payment DB status

—

by

Sethkamlet

Is it possible to query on the DB tables for the payment status?

Can’t seem to see where the “closed” for a payment is via SQL.

Is it in wp_aff_referrals, in the serialized “data” field?

Have a custom display for users and wanted to add a column if the referral has been been paid already.

Posted in

Comments

One response to “Payment DB status”

  1. George Avatar
    George

    Hi Seth,

    It’s the status column which will be marked as closed when you edit the referral and mark it as closed under Affiliates > Referrals or under Affiliates > Totals when you mass-close your recorded referrals.

    Kind regards,
    George

Share