Most post URLs use the same variables, but the posttype field changes depending on which post URL you are using. Note:
the Denial and Expire posts may only use columns in the 'members' table.
Note: this information is sent to your post url through GET (script.php?username=foo&password=bar) not POST (such as with a form).
- loginid
- amount
- transid ($billername.':'.transactionid)
- posttype (approval , denial , rebill, credit, chargeback , expire)
- all the columns in the 'members' table
- memberid => bigint(20)
- status => tinyint(4)
- trial => tinyint(3)
- memberidx => varchar(128)
- joined => datetime
- expires => datetime
- last_login => datetime
- stamp => timestamp
- siteid => int(10)
- tourid => int(10)
- campaignid => int(10)
- programid => int(10)
- rebills => int(10)
- spent => int(10)
- refunded => int(10)
- cost => int(10)
- cost_charge => int(10)
- username => varchar(32)
- password => varchar(16)
- cryptpass => varchar(32)
- billerid => tinyint(3)
- cascade_name => varchar(16)
- optionid => int(10)
- subid1 => int(10)
- subid2 => int(10)
- adid => int(10)
- ip => bigint(20)
- firstname => varchar(64)
- lastname => varchar(64)
- email => varchar(255)
- address1 => varchar(128)
- address2 => varchar(128)
- zip => varchar(16)
- city => varchar(32)
- country => char(2)
- state => char(2)
- urlref => varchar(128)
- session => varchar(32)
- mailok => tinyint(4)
- custom1 => varchar(255)
- custom2 => varchar(255)
- ptype => varchar(16)
- charges => int(10)
- flat_price => int(10)
- shipping_firstname => varchar(64)
- shipping_lastname => varchar(64)
- shipping_address1 => varchar(128)
- shipping_address2 => varchar(128)
- shipping_zip => varchar(16)
- shipping_city => varchar(32)
- shipping_country => char(2)
- shipping_state => varchar(32)
- nextrebill => datetime
- phone => varchar(16)
- cchash => varchar(32)
- first_login => datetime
- verify_amount => int(10)
- verify_hash => tinyint(3)
- verify_is_active => tinyint(3)
- verify_needed => tinyint(3)
- xsell_success => tinyint(1)
- xsell_message => varchar(128)
- third_party_partner_id => tinyint(3)
- previous_memberid => int(12)
- upgradeid => varchar(128)
- natsform_optionid => int(10)
- cascade_step => tinyint(1)
- custom3 => varchar(255)
- custom4 => varchar(255)
- custom5 => varchar(255)
- cancelid => varchar(128)
- gateway_token => varchar(128)
