Postponed
Project:
Hidden
Version:
6.x-2.x-dev
Component:
Code
Priority:
Normal
Category:
Support request
Assigned:
Unassigned
Reporter:
Created:
30 Jun 2012 at 23:14 UTC
Updated:
4 Jul 2012 at 01:30 UTC
Jump to comment: Most recent, Most recent file
Comments
Comment #1
hongpong commentedfor documentation here are the table structures we are working with -- due to auto_increment your mileage may vary.
CREATE TABLE `hidden_comment` (
`hid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`nid` int(10) unsigned NOT NULL DEFAULT '0',
`cid` int(10) unsigned NOT NULL DEFAULT '0',
`created` int(10) unsigned NOT NULL DEFAULT '0',
`rid` int(4) unsigned NOT NULL DEFAULT '0',
`publicnote` text NOT NULL,
`privatenote` text NOT NULL,
`uid` int(10) unsigned NOT NULL DEFAULT '0',
`delay` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`hid`,`nid`,`cid`)
) ENGINE=MyISAM AUTO_INCREMENT=850 DEFAULT CHARSET=utf8;
CREATE TABLE `hidden_filter_reasons` (
`hfid` int(10) unsigned NOT NULL,
`title` varchar(255) NOT NULL,
`rid` int(4) unsigned NOT NULL DEFAULT '0',
`publicnote` text NOT NULL,
`privatenote` text NOT NULL,
`uid` int(10) unsigned NOT NULL DEFAULT '0',
`delay` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`hfid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `hidden_filters` (
`hfid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`filter` varchar(255) NOT NULL,
`type` tinyint(2) unsigned NOT NULL DEFAULT '1',
`hits` int(10) unsigned NOT NULL DEFAULT '0',
`lasthit` int(10) unsigned NOT NULL DEFAULT '0',
`enabled` tinyint(2) NOT NULL DEFAULT '1',
`weight` int(10) NOT NULL DEFAULT '0',
PRIMARY KEY (`hfid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
CREATE TABLE `hidden_log` (
`hidetime` int(10) unsigned NOT NULL DEFAULT '0',
`action` int(4) unsigned NOT NULL DEFAULT '0',
`description` text NOT NULL,
`ids` text NOT NULL,
`uid` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`hidetime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `hidden_node` (
`hid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`nid` int(10) unsigned NOT NULL DEFAULT '0',
`created` int(10) unsigned NOT NULL DEFAULT '0',
`rid` int(4) unsigned NOT NULL DEFAULT '0',
`publicnote` text NOT NULL,
`privatenote` text NOT NULL,
`uid` int(10) unsigned NOT NULL DEFAULT '0',
`delay` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`hid`,`nid`)
) ENGINE=MyISAM AUTO_INCREMENT=289 DEFAULT CHARSET=utf8;
CREATE TABLE `hidden_reasons` (
`rid` int(4) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL DEFAULT '',
`description` text,
`enabled` tinyint(2) NOT NULL DEFAULT '1',
PRIMARY KEY (`rid`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
CREATE TABLE `hidden_reported_comment` (
`repid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`nid` int(10) unsigned NOT NULL DEFAULT '0',
`cid` int(10) unsigned NOT NULL DEFAULT '0',
`created` int(10) unsigned NOT NULL DEFAULT '0',
`rid` int(4) unsigned NOT NULL DEFAULT '0',
`publicnote` text NOT NULL,
`privatenote` text NOT NULL,
`uid` int(10) unsigned NOT NULL DEFAULT '0',
`seen` tinyint(2) unsigned DEFAULT NULL,
`suid` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`repid`,`nid`,`cid`)
) ENGINE=MyISAM AUTO_INCREMENT=79 DEFAULT CHARSET=utf8;
CREATE TABLE `hidden_reported_node` (
`repid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`nid` int(10) unsigned NOT NULL DEFAULT '0',
`created` int(10) unsigned NOT NULL DEFAULT '0',
`rid` int(4) unsigned NOT NULL DEFAULT '0',
`publicnote` text NOT NULL,
`privatenote` text NOT NULL,
`uid` int(10) unsigned NOT NULL DEFAULT '0',
`seen` tinyint(2) unsigned DEFAULT NULL,
`suid` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`repid`,`nid`)
) ENGINE=MyISAM AUTO_INCREMENT=53 DEFAULT CHARSET=utf8;
Comment #2
hongpong commentedI ran D6>D7 coder upgrade on the module. Here's the result of that.
Comment #3
Anonymous (not verified) commenteda d7 version of hidden with much less features and not tested yet: https://drupal.org/sandbox/mcp/1373402
Comment #4
hongpong commentedThank you!! This worked well enough for us to get by. Marking as postponed - but i think it would be worthy of releasing as dev & closing, as it performs its main function perfectly well.