Looking for the data contained in the apipost table

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Andy
    Senior Member
    • Jan 2002
    • 5886
    • 4.1.x

    Looking for the data contained in the apipost table

    I would like to use the apipost table to indicate when a post is uploaded by a mobile phone. I have my own custom code for mobile phones to upload images to a post.

    Could someone please post just one row from the 'apipost' table so I can see what sort of data is required for the indication to appear below a post indicating it was uploaded by a mobile phone.

    Thank you.
  • Trevor Hannant
    vBulletin Support
    • Aug 2002
    • 24323
    • 5.7.X

    #2
    Here's a couple of entries from mine:

    Code:
    (32, 5, 1, 1234, 'vBMobile', '1.1.2', 'Android', '2.2'),
    (33, 1, 1, 1237, 'vB Mobile iOS', '1.1.2', 'iPhone', '4.3.5'),
    For info, here's the query to create the table:

    Code:
    CREATE TABLE IF NOT EXISTS `apipost` (
      `apipostid` int(10) unsigned NOT NULL auto_increment,
      `userid` int(10) unsigned NOT NULL default '0',
      `contenttypeid` int(10) unsigned NOT NULL default '0',
      `contentid` int(10) unsigned NOT NULL default '0',
      `clientname` varchar(250) NOT NULL default '',
      `clientversion` varchar(50) NOT NULL default '',
      `platformname` varchar(250) NOT NULL default '',
      `platformversion` varchar(50) NOT NULL default '',
      PRIMARY KEY  (`apipostid`),
      KEY `contenttypeid` (`contenttypeid`,`contentid`)
    )
    Vote for:

    - Admin Settable Paid Subscription Reminder Timeframe (vB6)
    - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

    Comment

    • Andy
      Senior Member
      • Jan 2002
      • 5886
      • 4.1.x

      #3
      Thank you Trevor.

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...