Web Marketing Tool
Reseller
Chris B.
Database Details
Login

Membership Software Database Table Details


Below is a technical reference for the membership software database.

Usage Details

/ Folder: include("dbconn.php");     /admin Folder: include("../dbconn.php");
Gives You: $mysqli     exa: $res = $mysqli->query("SELECT * FROM members");

Most Used Tables

members
contacts
page

List of Database Tables



Click the table to view column details and usage examples.
addtlnotify
Additional emails to send notification messages to.
adminsettings
Settings for the website. DO NOT update directly.
arthirdparty
Third party autoresponders (such as Aweber, GetResponse, etc).
contactfields
Contact fields (variables).
contactgroupassign
Assigns a contact to a contact group.
contactgroups
Contact groups. Used for sorting contacts and autoresponder messages.
contactnotes
Notes that members add to a contact.
contactnotify
New contact notification email that is sent to the member.
contactpointlog
A log of points a contact has earned. Contact points are displayed on the contact scoreboard and increase the contact's score.
contactpointsettings
Contact point amounts that are added to the contact's score when they perform specific actions.
contacts
Contacts (leads) belonging to members.
contactsync
For tracking changes to contacts for synchronizing 3rd party apps (like a mobile app, or downloaded desktop app).
contentgroupassign
Assign content (pages, banners, etc) to a specific content group.
contentgroups
Content groups that content (pages, banners, etc) can be added to.
cprequiredfields
Capture page required fields (name, email, etc).
doccategories
Document Categories
documents
Documents are html pages that are used for a wide range of items such as training section, grouping quizzes, and more.
documentsubcat
Sub-Categories that documents can be assigned to.
domainassign
Assigns a web page to a domain.
domains
Domains that a member has either purchased from the site or imported. By default domains are hosted with the site.
doubleoptin
Double optin settings for each member that specifies if new contacts (optins) must click a confirmation link to confirm their email before becoming active.
editablecontent
Used for storing text/html content that is used throughout the members area or used for notification emails.
files
Files uploaded by members to tasks or designs or other entities that allow members to upload files for internal purposes.
freesignup
A list of emails that can join without making payment.
ipblock
IPs that are blocked from viewing the site.
language
Translation values for specific words/phrases for each language.
languageassign
Assigns a word/phrase to a specific page in the member's area.
languages
A list of available languages for the member's area.
login
Login records for members.
membernotes
Member notes added by the admin and only seen by the admin.
membernotifyemail
Email notification for member
members
Member (Affiliate)
membershipassign
Assign a piece of content to a specific membership so only members of that membership can see it.
membershipbump
Membership bump to automatically upgrade a member to a higher membership for referring other members.
membershipgroups
group packages
membershipnotify
The notification email a member is sent when they join under a specific membership.
membershipqualify
package qualify
memberships
Memberships that members can belong to. A member can only belong to one membership at a time.
membervar
Member variable. The values of the member variables that each member has stored.
membervars
Member variables. A list of all the types of member variables.
menuitem
An item in the navigation menu in the member's area.
notes
Internal notes left by members on entities (exa: task notes).
page
A page for the site (capture page or landing page. Not members area pages). This is the primary table for pages and all tables that start with the title capurepage are related to this one.
pagecontent
A section of editable content on a page.
pagedynamic
A dynamic page (meaning not having it's own php file).
primarypage
A member's primary page seen when visiting domain.com/username
privacypolicy
A custom privacy policy page for a member.
resourcecategories
Resource categories for grouping resources.
resources
Resources (member's area pages).
restore
Restoration details for items that have been deleted (like a trash can). Items over 3 days old are purged nightly.
sfileaccess
File Access. Specifies which members or memberships are able to access a file. If no record exists for a page then only the admin is able to view the page.
signups
Statistics of optins (visitors that have filled out a capture page form).
sms
SMS notification settings for each member.
stats
Statistics of page views.
usernamechange
A que of username changes that is processed by the server to update email accounts. Each member has an email account on the domain on the site that matches their username.
Tool: Commission Tracking
affholdings
holding payments to members
Tool: Commission Tracking
affprogram
Affiliate/member Tier and payment
Tool: Commission Tracking
commission
Commissions earned by members.
Tool: Commission Tracking
commissiontier
Commission tiers (levels).
Tool: Commission Tracking
membershipbonuses
Membership Bonuses
Tool: Commission Tracking
membershipupgrade
Tool: Commission Tracking
payouts
A log of payouts of commission earned made to members.
Tool: Member Showcase
showcase
A member showcase.
Tool: Affiliate Programs
affiliateprograminfo
Affiliate programs. A list of all the affiliate programs.
Tool: Affiliate Programs
affiliateprograms
Affiliate program. The values of the affiliate programs that each member has stored.
Tool: News
news
A news item for news for members. Also used for a RSS feed.
Tool: External Billing
externalbilling
external billing
Tool: External Billing
externalcategoryassign
Tool: External Billing
externalgenealogy
Member genealogy (referral information) for a specific external billing product.
Tool: External Billing
externalpayments
A payment that was made for an external billing product.
Tool: External Billing
externalproductcategory
Tool: External Billing
externalproductimages
Tool: External Billing
externalproductprice
The reseller/distributor's price of an external billing product.
Tool: External Billing
externalproducts
external products
Tool: External Billing
externalpromocode
external promocode
Tool: External Billing
externaltiers
Commission tiers for an external billing product.
Tool: External Billing
externalvars
external vars
Tool: External Billing
externalvarvalues
external var values
Tool: External Billing
invoice
An invoice.
Tool: External Billing
invoicecart
Tool: External Billing
invoiceitems
A line item assigned to an invoice.
Tool: External Billing
productpackage
Assigns an external billing product to a package. A package is an external billing product that has many products assigned to it so when paying the one price for the product all the other products assigned to it are included with it.
Tool: External Billing
shoppingcart
Items in a member's shopping cart.
Tool: Live Chat
chatmessages
Chat messages between contacts and members in a live chat.
Tool: Live Chat
chatsettings
Live chat settings for a specific member.
Tool: Live Chat
meetingattendee
Assigns members as attendees of specific meetings.
Tool: Live Chat
meetingchats
Messages sent by a member inside of a meeting.
Tool: Live Chat
meetings
Meetings
Tool: SMS/Voice Marketing
smsar
SMS/Voice autoresponder.
Tool: SMS/Voice Marketing
smscredits
SMS/Voice credits used when sending an SMS message or voice message to a contact's phone.
Tool: SMS/Voice Marketing
smsque
A que of SMS/Voice messages to be sent.
Tool: SMS/Voice Marketing
smsusage
A history of SMS/Voice messages sent by a member to a contact.
Tool: Social Marketing
facebookvideo
Facebook Video Plugin
Tool: Social Marketing
googlecalendar
Google Calendar
Tool: Social Marketing
socialapisettings
Global settings for the importer/inviter (social) inviter plugin.
Tool: Social Marketing
socialconnect
Social Connect
Tool: Social Marketing
socialconnections
Social Connections
Tool: Social Marketing
socialcontacts
Social Contacts
Tool: Social Marketing
socialcontent
Social Content
Tool: Social Marketing
socialcontentassign
Assign social content to a social account
Tool: Social Marketing
socialcontenttypes
Social Content Types
Tool: Social Marketing
socialprofile
Social Profile
Tool: Social Marketing
socialprofiletypes
Social Profile Types
Tool: Social Marketing
socialprofilevars
Social Profile Variables
Tool: Social Marketing
socialque
Social content que
Tool: Social Marketing
socialsettings
Tool: Social Marketing
socialsites
Social Sites
Tool: Social Marketing
socialstats
Social Stats
Tool: Social Marketing
socialvars
Tool: Social Marketing
socialvarstemplate
Social Variables Template
Tool: Social Marketing
socialvarstemplatevar
Social Template variables
Tool: Form Templates
formtemplate
An optin form template.
Tool: Form Templates
formtemplatecustom
An editable section of a form template that members can customize.
Tool: Page Funnel
funnelactivity
Funnel activity
Tool: Page Funnel
funnelpages
Assigns a page to a marketing funnel.
Tool: Page Funnel
funnels
A marketing funnel (funnel of pages visited in a specific order).
Tool: Blog
blog
Blogs created by members.
Tool: Blog
blogcomments
Comments by visitors that are assigned to a blog entry.
Tool: Blog
blogentry
A blog entry.
Tool: Blog
blogtemplates
blog templates
Tool: Blog
blogvar
Blog Variable
Tool: Blog
blogvardata
Tool: Blog
blogvargroup
Tool: Blog
blogvargroups
Tool: Blog
blogvars
Blog Variables
Tool: Postal
postal
Postal
Tool: Postal
postalbroadcast
Broadcast messages that are mailed to contacts through the post office.
Tool: Postal
postalcredits
Credits assigned to a member that can be used for sending mail to contacts through the post office.
Tool: Postal
postalque
Messages that are in que to be mailed through the post office.
Tool: Postal
postalsettings
Global settings for the postal plugin.
Tool: Postal
postalusage
A log of each postal message sent from a member to a contact.
Tool: Slider
slider
Settings for an image slider that rotates between images.
Tool: Slider
sliderimage
Images that are assigned to an image slider.
Tool: Ad Coop
adcoop
An ad coop that members can purchase shares of.
Tool: Ad Coop
adcoopshare
An ad coop share that is assigned to a member.
Tool: Survey
survey
Survey
Tool: Survey
surveyanswers
Answer choices for a survey.
Tool: Survey
surveyquestions
Questions assigned to a survey.
Tool: Survey
surveyresult
Answers given by survey takers.
Tool: Survey
surveyuser
Assigns a contact as having taken a specific survey.
Tool: Forum
forumauth
forum auth
Tool: Forum
forumposts
forum posts
Tool: Forum
forums
forums
Tool: Forum
forumthreads
forumthreads
Tool: Sport Leagues
sportgames
A match between 2 teams.
Tool: Sport Leagues
sportleagues
Sport Leagues
Tool: Sport Leagues
sportleagueteams
Assigns a sports team to a league/season.
Tool: Sport Leagues
sportpositions
Sport positions that players belong to (exa: forward, guard, etc).
Tool: Sport Leagues
sportstats
Game statistics for players.
Tool: Sport Leagues
sportstattypes
Types of sports stats (exa: Foul, Rebound, Assist, etc)
Tool: Sport Leagues
sportteamplayer
Assigns a member as a player of a specific team (sportsleagueteam).
Tool: Sport Leagues
sportteams
Sport teams that can be assigned to leagues/seasons.
Tool: Legal Contracts
legalcontracts
Legal Contracts
Tool: Legal Contracts
legalcontractsign
Sign Legal Contracts
Tool: Banner Creator
bannercreatorfields
Banner Creator Fields
Tool: Banner Creator
bannercreatortemplate
Banner Creater Template
Tool: Banner Creator
slidebanner
Slide Banner
Tool: Banner Creator
slidebannerstyle
Slide Banner Style
Tool: URL Shortener
urlshortner
Tool: URL Shortener
urlshortnerstats
Statistics of visits through a URL shortner.
Tool: Video Library
videolibrary
Tool: Video Library
videolibraryrating
A rating by a member of a video in a video library.
Tool: Question and Answer
documentqna
Assigns a question to a specific document. Used for grouping questions in the knowledge base as well as for creating quizzes.
Tool: Question and Answer
qna
Questions and Answers
Tool: Question and Answer
qnaaccess
Questions and Answers Access
Tool: Question and Answer
qnacategory
Questions and Answers Categories
Tool: Question and Answer
qnakeywordassign
Assigns a keyword to a question.
Tool: Question and Answer
qnakeywords
Keywords for questions and answers.
Tool: Question and Answer
qnasearch
A history of searches of the question knowledge base or where people have asked a new question.
Tool: Events
event
Events or reservations for services, products, rentals, etc. Basically, anything where a purchase or RSVP is made for something for a specific date (hotel reservation, concert ticket, car rental, etc.)
Tool: Events
eventdiscount
Tool: Events
eventextra
Tool: Events
eventprice
The price of a ticket to attend an event.
Tool: Events
eventrecur
Tool: Events
eventrecurremove
Tool: Events
eventsettings
Global event settings for events where tickets are sold to the event.
Tool: Events
eventticket
A ticket that has been purchased for a specific event.
Tool: Events
eventtypes
A type of event (exa: concert, game, etc).
Tool: Design Management
design
A design purchased by a member.
Tool: Design Management
designnotes
Notes added to a design by a member indicating revision requests.
Tool: Design Management
designphotos
Photos selected by members for their design.
Tool: Design Management
designrevisions
Revisions to a design.
Tool: Design Management
designtemplates
Design templates for specifying what information to collect from a member to use for the copy for their design when they purchase this type of design.
Tool: Design Management
designtypes
Types of designs available for sale.
Tool: Design Management
setupdesign
Tool: Quran
qeword
Tool: Quran
xlations
Tool: Quiz
quiz
A quiz question that a member or contact can take.
Tool: Quiz
quizanswers
Possible answers of a quiz question.
Tool: Quiz
quizque
Questions in que for a member/contact to answer.
Tool: Quiz
quizresponse
An answer given by a contact or member to a quiz question.
Tool: SEO
articlesites
Article sites used by the submission tool.
Tool: SEO
onewaylinks
Tool: SEO
seodata
SEO metadata for a site.
Tool: Task Management
supportrequest
Support requests awaiting approval.
Tool: Task Management
taskclientrating
A rating by a member on how well the task was performed by an employee.
Tool: Task Management
taskgroups
Tool: Task Management
taskissues
Issues with a task (items not complete or done wrong by the worker). For internal use, not seen by non employees.
Tool: Task Management
tasklevel
Tool: Task Management
tasklist
Tool: Task Management
taskrecur
Tool: Task Management
tasks
Tool: Task Management
taskskills
Assigns skills (employee skills) to a task.
Tool: Task Management
tasktimesheet
A timesheet of time spent working on a specific task.
Tool: Accounting
expensecategories
Tool: Accounting
expenses
Tool: Accounting
moneyaccountfile
A file (pdf or image) that is attached to a money account (exa: A bank statement).
Tool: Accounting
moneyaccounts
Money accounts, such as cash, checking accounts, PayPal, foreign currency, etc.
Tool: Accounting
moneyprojects
Tool: Accounting
moneytransfer
Tool: Accounting
moneytransferother
Tool: Accounting
vendor
Tool: Employee Management
employeebonus
Bonuses given to employees.
Tool: Employee Management
employees
Additional metadata for members that are employees.
Tool: Employee Management
employeeschedule
Tool: Employee Management
managerscores
Scores of client managers generated hourly based off open tasks, emails, and other indicators of their performance.
Tool: Employee Management
monitorimage
A history of screenshots taken of an employee's screen (monitor) while they are timed in.
Tool: Employee Management
nudge
A short, high priority message sent to an employee.
Tool: Employee Management
schedule
Tool: Employee Management
skillassign
Assigns a skill to a member.
Tool: Employee Management
skills
Skills that can be assigned to employees.
Tool: Employee Management
timesheet
A history of when an employee worked.
Tool: Study
dictionary
Dictionary of language definitions for increasing vocabulary.
Tool: Study
documentdict
Assigns a dictionary item (for vocabulary) to a document.
Tool: Study
gameplay
Tool: Study
games
Tool: Study
gamevars
Tool: Study
mymath
Math ranking scores for members used for the math quiz.
Tool: Study
studyhistory
A history of items that a member has read or used the memorize tool with.
Tool: Study
studylesson
A study lesson which is a collection of assignments for a member or contact to complete.
Tool: Study
studylessonassign
An assignment for a study lesson.
Tool: Study
studylessondone
A log of study lesson assignments completed by members or contacts.
Tool: Study
vocabulary
Vocabulary items for reference and that can be used with the vocabulary quiz.
Tool: Billing
billing
Billing options for being a member of the site.
Tool: Billing
cancellations
Cancellation requests by members cancelling their membership.
Tool: Billing
nextbill
The next date that a member will be billed for their membership. Only used under certain circumstances. Typically billing is handled by the payment processor.
Tool: Billing
payment
Payments made by members for their membership to the site.
Tool: Rank
rankassign
Assigns a member to a rank.
Tool: Rank
rankbadgeassign
Assigns a rank badge to a member.
Tool: Rank
rankbadges
Badges that members can earn.
Tool: Rank
ranklock
Assigns content that is unlocked by this rank.
Tool: Rank
rankpoints
Experience points earned by members by performing actions.
Tool: Rank
rankpointtypes
Types of experience points that members are able to earn.
Tool: Rank
rankqualify
Specifies qualifications a member needs to be assigned to a specific rank.
Tool: Rank
ranks
Ranks that members can belong to.
Tool: Email Marketing
autoresponder
Email autoresponder messages.
Tool: Email Marketing
broadcastque
A que of broadcast emails to be sent.
Tool: Email Marketing
emailque
A que of emails to be sent. All follow up and broadcast messages are sent through emailque.
Tool: Email Marketing
emailssent
A record of all emails that have been sent.
Tool: Email Marketing
emailtemplates
Email templates which can be used when sending emails or creating autoresponder messages.
Tool: Email Marketing
linkclick
History of each time a contact clicks on a link in an email.
Tool: Email Marketing
removear
Disables an autoresponder message for a specific member.
Tool: Email Marketing
signature
A member's signature (name, phone, etc) that will appear at the bottom of every email they send.
Tool: Downloads
downloads
Downloads that can be downloaded from the members area (secure downloads) or can be made public for anyone to download.
Tool: Banners
banners
Banners for promoting the site.
Tool: Page Creator
mobilecredits
Credits assigned to members that they can use to convert web pages to mobile friendly pages.
Tool: Page Creator
mobileusage
A history of usage where members converted a web page (or set of pages) to mobile friendly pages.
Tool: Page Creator
pagecurl
A notification that is sent to a URL when someone opts into the specified page.
Tool: Page Creator
pageexitpopup
Page exit popup seen when someone tries to leave the page.
Tool: Page Creator
pageform
Capture page form fields. Each record is a field in the form.
Tool: Page Creator
pageformsettings
capture page form settings
Tool: Page Creator
pagepassword
Password protection for a page
Tool: Page Creator
pagerecommend
A recommendation by a member of a page that was created by that member asking the admin to include the page in the site for all members to be able to use.
Tool: Page Creator
scheduledvar
Scheduled values (content) belonging to a scheduled variable.
Tool: Page Creator
scheduledvars
Scheduled variables that can have multiple time triggered values (content) assigned to it.
Tool: Page Creator
tracking
Tracking campaigns for tracking page performance and split testing.
Tool: Page Creator
trackingassign
Assigns a page to a specific tracking campaign.
Tool: Calendar
calendar
Member Calendar
Tool: Calendar
calendarschedule



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