initVar('GroupID', XOBJ_DTYPE_STRING, ''); $this->initVar('NoticeID', XOBJ_DTYPE_STRING, ''); $this->initVar('Timestamp', XOBJ_DTYPE_INT, 0); $this->initVar('FromName', XOBJ_DTYPE_STRING, ''); $this->initVar('Subject', XOBJ_DTYPE_STRING, ''); $this->initVar('Message', XOBJ_DTYPE_STRING, ''); $this->initVar('BinaryBucket', XOBJ_DTYPE_STRING, ''); } } class XoopensimGroupnoticedbHandler extends XoopsObjectGenericHandler { var $mTable = 'xoopensim_group_notice'; var $mPrimary = 'GroupID,NoticeID'; //var $mPrimary = 'NoticeID'; var $mClass = 'XoopensimGroupnoticedbObject'; function XoopensimGroupnoticedbHandler(&$db) { parent::XoopsObjectGenericHandler($db); } } /* CREATE TABLE `{prefix}_{dirname}_group_notice` ( `GroupID` varchar(64) NOT NULL default '', `NoticeID` varchar(64) NOT NULL default '', `Timestamp` int(10) unsigned NOT NULL default '0', `FromName` varchar(255) NOT NULL default '', `Subject` varchar(255) NOT NULL default '', `Message` text NOT NULL, `BinaryBucket` text NOT NULL, PRIMARY KEY (`GroupID`,`NoticeID`), KEY `Timestamp` (`Timestamp`) ) TYPE=MyISAM; */ ?>