Web Marketing Tool
Reseller
Chris B.
members
Login

Table: members

Member (Affiliate)

Associated Objects: Members, Member

Fields

member INT UNSIGNED NOT NULL AUTO_INCREMENT v5
The id of the member
firstname VARCHAR(50) v3.21
The first name of the member
parent INT UNSIGNED DEFAULT 1 v5
The id of the member's current parent (aka Sponsor, aka Referrer)
lastname VARCHAR(50) v3.21
The last name of the member
email VARCHAR(100) v3.21
The email of the member
username VARCHAR(25) v3.21
The username of the member
url VARCHAR(255) v3.21
The member's default redirect URL. The redirect URL is the URL of the page a person is redirected to after they optin to a capture page.
phone VARCHAR(20) v3.21
The phone number of the member.
password VARCHAR(50) v3.21
The password of the member. Stored with md5 encryption.
approved TINYINT DEFAULT 0 v3.21
The status of the member. If the value is 0 it means the member is inactive/suspended. If the value is greater than 0 it means the member is active. With a team system if the value of this field is 2 then it means the member belongs to the rotator.
added INT UNSIGNED DEFAULT 0 v3.21
The timestamp of the date/time the member was created
address VARCHAR(70) v3.21
The postal street address of the member
city VARCHAR(30) v3.21
The city the member lives in
state VARCHAR(25) v3.21
The state the member lives in
zipcode VARCHAR(12) v3.21
The postal zipcode the member lives in
country VARCHAR(30) v3.21
The country the member lives in
lastbroadcast INT UNSIGNED DEFAULT 0 v3.21
The timestamp of the date on which the member sent his last broadcast email
originalparent INT UNSIGNED DEFAULT 1 v5
The id of the member's original parent (aka Original Sponsor). The oparentid and parentid may contain different values when using a passup system or a matrix where a person's parent is not always the person that referred them.
failedlogins TINYINT DEFAULT 0 v3.21
The amount consecutive failed login attempts the member has made.
signupip VARCHAR(20) v3.21
The IP belonging to the member when they initially created their account
doubleoptinsettings BIT(1) DEFAULT 0 v5
Specifies whether or not the members capture pages require double optin where a new contact has to confirm their email before joining the mailing list. If set to 0 then they do not require double optin confirmation. If set to 1 they do require double op
contentgroup SMALLINT UNSIGNED DEFAULT 1 v5
The id of the primary Content Group for this member
membership SMALLINT UNSIGNED DEFAULT 1 v3.21
The id of the membership which the member belongs to
nextbilldate INT UNSIGNED v3.21
Timestamp of the date which the member should perform his next payment. This is for internal purposes only and if manually modified it will not cause the payment to be made on the date specified.
apikey VARCHAR(30) v3.21
The API key for the member to use to access their own API (v5.0)
contactnotify BIT(1) DEFAULT 1 v3.21
Set to 1 when the member wants to receive new contact notifications. If set to 0 the member will not receive new contact notifications.
language SMALLINT UNSIGNED DEFAULT 1 v3.21
The id of the language that the members area is translated into when the member is logged in.
shoppergd VARCHAR(25) v4.3
The GoDaddy shopper id used when purchasing domain names.
timezone VARCHAR(50) DEFAULT 'America/New_York' v4.93
appkey VARCHAR(32) v4.94
amountpaid FLOAT DEFAULT 0 v5
adminpaid BIT(1) DEFAULT 0 v5
testpayment BIT(1) DEFAULT 0 v5
alwaysqualify BIT(1) DEFAULT 0 v5
bipos BIT(1) DEFAULT 0 v5
bipref SMALLINT DEFAULT 1 v5


Example PHP Usage

The following php example is designed for the main folder: /


Other Tables

adminpageaccess     adminsettings     alerts     contactfields     contactgroupassign     contactgroups     contactnotes     contactnotify     contactpointlogs     contactpointsettings     contacts     contactsync     contentgroupassign     contentgroups     cprequiredfields     cronlogs     designtemplatefields     doccategories     documents     documentsubcat     domainassign     domains     doubleoptinsettings     editablecontent     files     freesignups     ipblocks     languageassign     languages     languagevalues     login     memberdetails     memberemails     membermobilenumbers     membernotes     membernotifyemails     members     membersareapagesettings     membershipassign     membershipbumps     membershipgroups     membershipnotify     membershipqualifications     memberships     memberstepcomplete     membersteps     membervars     membervarvalues     menuitems     mobileoptinbuttons     notes     pagecontents     pagedynamic     pages     pageviews     primarypages     privacypolicies     pushnotificationkeys     pushnotifications     resourcecategories     resources     restore     signups     sms     smsinbox     stats     statsma     thirdpartyautoresponders     thirdpartyautorespondervalues     useragents     usernamechanges     visit     visitors    



webmarketingtool.com Webutation DMCA.com Protection Status Authorize.net GoDaddy
Valid HTML! Valid CSS!


SUBSCRIPTION PRICES
Reseller: Chris Brevig
|
PRODUCT PRICES
Login
(502) 225-3237