Difference between revisions of "Nats4 Post URL Variables"
From TMM Wiki
Jump to navigationJump to search| (5 intermediate revisions by 5 users not shown) | |||
| Line 3: | Line 3: | ||
}} | }} | ||
| − | Most post URLs use the same variables, but the ''posttype'' field changes depending on which post URL you are using. Note: | + | Most post URLs use the same variables, but the ''posttype'' field changes depending on which post URL you are using. For other postback examples, please check this article: [[NATS4 Postbacks and Post URLs]] |
| − | the Denial and Expire posts may only use columns in the 'members' table.<br/> | + | |
| + | '''Note''': the Denial and Expire posts may only use columns in the 'members' table.<br/> | ||
| + | |||
'''Note''': this information is sent to your post url through '''GET''' (script.php?username=foo&password=bar) not POST (such as with a form).<br/> | '''Note''': this information is sent to your post url through '''GET''' (script.php?username=foo&password=bar) not POST (such as with a form).<br/> | ||
| − | All the columns in the 'member','member_subscription','member_info' tables | + | |
| + | All of the columns in the 'member', 'member_subscription', and 'member_info' tables include the following variables (run ''describe member'', ''describe member_subscription'', and ''describe member_info'' to get a full list): | ||
* memberid | * memberid | ||
| Line 40: | Line 43: | ||
* memberidx | * memberidx | ||
* billerid | * billerid | ||
| − | * statid | + | * statid |
| − | |||
| − | |||
* cost | * cost | ||
* cost_charge | * cost_charge | ||
| Line 57: | Line 58: | ||
* biller_expires | * biller_expires | ||
* original_optionid | * original_optionid | ||
| − | * created_date | + | * created_date |
| − | |||
* firstname | * firstname | ||
* lastname | * lastname | ||
| Line 82: | Line 82: | ||
* custom3 | * custom3 | ||
* custom4 | * custom4 | ||
| − | * custom5 | + | * custom5 |
| + | * custom6 | ||
| + | * custom7 | ||
| + | * custom8 | ||
| + | * custom9 | ||
| + | * custom10 | ||
* last_modified | * last_modified | ||
* post_time | * post_time | ||
* post_type | * post_type | ||
| + | * passthrough1 | ||
| + | * passthrough2 | ||
| + | * passthrough3 | ||
| + | * passthrough4 | ||
| + | * passthrough5 | ||
[[Category:Also NATS4 Article]] | [[Category:Also NATS4 Article]] | ||
| + | [[Category:NATS4 Skins and Templates]] | ||
Latest revision as of 15:58, 19 May 2020
Most post URLs use the same variables, but the posttype field changes depending on which post URL you are using. For other postback examples, please check this article: NATS4 Postbacks and Post URLs
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).
All of the columns in the 'member', 'member_subscription', and 'member_info' tables include the following variables (run describe member, describe member_subscription, and describe member_info to get a full list):
- memberid
- identid
- loginid
- networkid
- refurl_lookup_id
- status
- trial
- joined
- expired
- last_login
- stamp
- siteid
- username
- password
- cryptpass
- ip
- session
- mailok
- flat_price
- first_login
- third_party_partner_id
- cascadeid
- cascade_item_id
- token
- original_username
- renamed
- marked
- token_hash
- member_subscription_id
- memberidx
- billerid
- statid
- cost
- cost_charge
- spent
- refunded
- charges
- next_rebill
- optionid
- rebills
- active
- upgradeid
- expires
- nats_expires
- biller_expires
- original_optionid
- created_date
- firstname
- lastname
- address1
- address2
- zip
- city
- country
- state
- shipping_firstname
- shipping_lastname
- shipping_address1
- shipping_address2
- shipping_zip
- shipping_city
- shipping_country
- shipping_state
- phone
- xsell_success
- xsell_message
- custom1
- custom2
- custom3
- custom4
- custom5
- custom6
- custom7
- custom8
- custom9
- custom10
- last_modified
- post_time
- post_type
- passthrough1
- passthrough2
- passthrough3
- passthrough4
- passthrough5
