Well we are working on updating our indymedia site to Drupal 7 and wondering how we can re-apply the data from the Hidden module to continue to hide those nodes - by importing the data to the Flag module, the Published/Unpublished status flag or some other method. Has anyone else done any work with this? Thanks.

CommentFileSizeAuthor
#2 hidden.zip49.77 KBhongpong

Comments

hongpong’s picture

for 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;

hongpong’s picture

StatusFileSize
new49.77 KB

I ran D6>D7 coder upgrade on the module. Here's the result of that.

Anonymous’s picture

a d7 version of hidden with much less features and not tested yet: https://drupal.org/sandbox/mcp/1373402

hongpong’s picture

Status: Active » Postponed

Thank 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.