Web Marketing Tool
Reseller
Chris B.
contacts
Login

Table: contacts

Contacts (leads) belonging to members.

Associated Objects: Contacts, Contact

Fields

cid INT UNSIGNED NOT NULL AUTO_INCREMENT v3.21
The id of the contact
aid INT(10) UNSIGNED NOT NULL v3.21
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(50) v4.03
The email address of the contact.
added INT(10) 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(4) 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(4) 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(5) 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.


Example PHP Usage

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


Other Tables

addtlnotify     adminsettings     arthirdparty     contactfields     contactgroupassign     contactgroups     contactnotes     contactnotify     contactpointlog     contactpointsettings     contacts     contactsync     contentgroupassign     contentgroups     cprequiredfields     cronlog     doccategories     documents     documentsubcat     domainassign     domains     doubleoptin     editablecontent     files     freesignup     ipblock     language     languageassign     languages     login     memberdetails     membernotes     membernotifyemail     members     membershipassign     membershipbump     membershipgroups     membershipnotify     membershipqualify     memberships     memberstepcomplete     membersteps     membervar     membervars     menuitem     notes     page     pagecontent     pagedynamic     pageviews     primarypage     privacypolicy     pushnotification     pushnotificationkeys     resourcecategories     resources     restore     sfileaccess     signups     sms     stats     statsma     thirdpartyar     useragent     usernamechange     visitor    



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