Web Marketing Tool
Reseller
Chris B.
socialstats
Login

Table: socialstats

Social Stats

Tool: Social Marketing

Fields

id INT UNSIGNED NOT NULL AUTO_INCREMENT v5
added INT UNSIGNED NOT NULL v5
The timestamp of the date/time the record was added
member INT UNSIGNED NOT NULL v5
Member ID
ttype INT UNSIGNED NOT NULL v5
Target type. 1 = Post to Feed (Profile), 2 = contact
ttypeid INT UNSIGNED NOT NULL v5
The id of the target based off the target (see ttype). For example, if ttype is 1 then this would be the id of the socialconnect record.
ctype TINYINT UNSIGNED DEFAULT 0 v5
Content type. 1 = socialcontent, 2 = socialmessage
ctypeid INT UNSIGNED NOT NULL v5
The id of the target based off the target (see ttype). For example, if ttype is 1 then this would be the id of the socialcontent record.
likes SMALLINT UNSIGNED DEFAULT 0 v5
Likes Number
comments SMALLINT UNSIGNED DEFAULT 0 v5
Comments number
clicks SMALLINT UNSIGNED DEFAULT 0 v5
Clicks Number
shares SMALLINT UNSIGNED DEFAULT 0 v5
Shares number
socialid VARCHAR(255) v5
Social ID
updated INT UNSIGNED v5
timestamp of date/time a record got updated


Example PHP Usage

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


Other Social Marketing Tables

facebookvideo     googlecalendar     socialapisettings     socialconnect     socialconnections     socialcontacts     socialcontent     socialcontentassign     socialcontenttypes     socialprofile     socialprofiletypes     socialprofilevars     socialque     socialsettings     socialsites     socialstats     socialvars     socialvarstemplate     socialvarstemplatevar    



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


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