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...) |
TmmStephen (talk | contribs) |
||
Line 6: | Line 6: | ||
the Denial and Expire posts may only use columns in the 'members' table.<br/> | 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 which include: (run ''describe member'',''describe member_subscription'',''describe member_info'' to get a full list) | |
+ | |||
* memberid | * memberid | ||
* identid | * identid |
Revision as of 14:07, 12 June 2009
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 the columns in the 'member','member_subscription','member_info' tables which include: (run describe member,describe member_subscription,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
- stamp
- joined
- expired
- cost
- cost_charge
- spent
- refunded
- charges
- next_rebill
- optionid
- rebills
- active
- upgradeid
- expires
- nats_expires
- biller_expires
- original_optionid
- created_date
- memberid
- 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