Difference between revisions of "Nats4 Post URL Variables"
From TMM Wiki
Jump to navigationJump to searchTmmStephen (talk | contribs) |
|||
Line 40: | Line 40: | ||
* memberidx | * memberidx | ||
* billerid | * billerid | ||
− | * statid | + | * statid |
− | |||
* joined | * joined | ||
* expired | * expired |
Revision as of 11:12, 12 April 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 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
- 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