Activity Stream for vb3

[BirdOPrey5]

I haven't had time to revisit this... with Vb5 now coming out sooner than I expected not sure it even makes sense anymore.

But for anyone who wants to build on it I have the mod file attached. You will need to manually create 2 database tables and insert default data into one table.


Table 1 Create:

CREATE TABLE IF NOT EXISTS `bop5astype3` (
  `typeid` int(10) unsigned NOT NULL auto_increment,
  `packageid` int(10) unsigned NOT NULL,
  `section` char(25) NOT NULL default '',
  `type` char(25) NOT NULL default '',
  `enabled` smallint(6) NOT NULL default '1',
  PRIMARY KEY  (`typeid`),
  UNIQUE KEY `section` (`section`,`type`)
) AUTO_INCREMENT=17 ;

Table 1 Insert Default Data:

INSERT INTO `bop5astype3` (`typeid`, `packageid`, `section`, `type`, `enabled`) VALUES
(1, 1, 'album', 'album', 1),
(2, 1, 'album', 'comment', 1),
(3, 1, 'album', 'photo', 1),
(4, 1, 'calendar', 'event', 1),
(5, 1, 'forum', 'post', 1),
(6, 1, 'forum', 'thread', 1),
(7, 1, 'forum', 'visitormessage', 1),
(8, 1, 'socialgroup', 'discussion', 1),
(9, 1, 'socialgroup', 'group', 1),
(10, 1, 'socialgroup', 'groupmessage', 1),
(11, 1, 'socialgroup', 'photo', 1),
(12, 1, 'socialgroup', 'photocomment', 1),
(13, 2, 'blog', 'entry', 1),
(14, 2, 'blog', 'comment', 1),
(15, 3, 'cms', 'article', 1),
(16, 3, 'cms', 'comment', 1);

Table # 2:

CREATE TABLE IF NOT EXISTS `bop5as3` (
  `activitystreamid` int(11) NOT NULL auto_increment,
  `userid` int(11) NOT NULL,
  `dateline` int(11) NOT NULL,
  `contentid` int(11) NOT NULL,
  `typeid` int(11) NOT NULL,
  PRIMARY KEY  (`activitystreamid`)
) AUTO_INCREMENT=1 ;

THIS IS RE-USABLE CODE. :up: