Web Marketing Tool
Reseller
Chris B.
contacts
Login

Table: contacts

Contacts (leads) belonging to members.

Associated Objects: Contacts, Contact

Fields

id INT UNSIGNED NOT NULL AUTO_INCREMENT v5
The id of the contact
member INT UNSIGNED NOT NULL v5
The id of the member that the contact belongs to
firstname VARCHAR(40) v4.03
The first name of the contact.
lastname VARCHAR(40) v4.03
The last name of the contact.
phone VARCHAR(20) v4.03
The phone number of the contact.
timetocall VARCHAR(100) v4.03
Contact Best time to call
email VARCHAR(100) v4.03
The email address of the contact.
added INT UNSIGNED v3.21
The timestamp of the date/time the contact was added
address VARCHAR(100) v4.03
The postal address of the contact.
city VARCHAR(50) v4.03
Contact City
state VARCHAR(50) v4.03
Contact State
zipcode VARCHAR(10) v4.03
Contact Zipcode
ip VARCHAR(30) v3.21
The IP of the contact when they first opted into a capture page.
status SMALLINT UNSIGNED DEFAULT 1 v3.21
The id of the primary contact group that the contact belongs to. If 0 it means the contact is inactive.
openedmail TINYINT v3.21
Number of times the contact has opened emails
tracking VARCHAR(50) v4.94
Tracking campaign the contact belongs to (if the URL they used to optin had tracking assigned to it).
capturepage VARCHAR(100) v4.94
The Capture Page which the contact used to optin
flag TINYINT v4.03
Number of Flag color(0-none)(1-Red)(2-Blue)(3-Green)(4-Brown)(5-Cyan)(6-Purple)(7-Grey)
password VARCHAR(40) v3.21
The password for the contact to use to login to password protected pages.
points SMALLINT UNSIGNED DEFAULT 0 v3.21
The total amount of points the contact has earned performing misc actions. These points are used for the scoreboard.
lastactive INT UNSIGNED DEFAULT 0 v3.21
A timestamp of the date/time of the last activity performed by the contact.
country CHAR(2) v5
Contact Country


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