Difference between revisions of "Nats4 Post URL Variables"
From TMM Wiki
Jump to navigationJump to searchTmmStephen (talk | contribs) (New page: {{NATS4 Manual | show_skins_and_templates_admin_section = true }} Most post URLs use the same variables, but the ''posttype'' field changes depending on which post URL you are using. Note...) |
|||
(7 intermediate revisions by 6 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 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 | ||
* identid | * identid | ||
Line 39: | 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