Difference between revisions of "Nats4 Post URL Variables"
From TMM Wiki
Jump to navigationJump to searchTMMStephenY2 (talk | contribs) |
|||
| 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. |
| − | 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 | ||
Revision as of 16:36, 3 August 2010
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).
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
- last_modified
- post_time
- post_type
