hi Tripmon.
There are no blocks in Protector >= 2.40
Instead, including postcheck is necessary.
Please check mainfile.php or "Security Advisory" in Protecotor
I've just understand what's wrong.
It's a problem of compatibility between 2.2.x and Protector.
OK. I'll fix it.
Try this code.
modules/protector/include/onupdate.inc.php
<?php
if( ! defined( 'XOOPS_ROOT_PATH' ) ) exit ;
global $xoopsDB , $msgs ;
$check_result = $xoopsDB->query( "DELETE FROM ".$xoopsDB->prefix("protector_access") ) ;
if( ! $check_result ) {
$ret = $xoopsDB->queryF( "
CREATE TABLE ".$xoopsDB->prefix("protector_access")." (
ip varchar(255) NOT NULL default '0.0.0.0',
request_uri varchar(255) NOT NULL default '',
expire int NOT NULL default 0,
KEY (ip),
KEY (request_uri),
KEY (expire)
) TYPE=MyISAM
" ) ;
}
if( substr( XOOPS_VERSION , 6 , 3 ) > 2.0 ) {
$block_instance_title = defined( '_MI_PROTECTOR_BNAME1' ) ? _MI_PROTECTOR_BNAME1 : 'Protector' ;
$xoopsDB->query( "DELETE FROM ".$xoopsDB->prefix("block_instance")." WHERE title='".addslashes($block_instance_title)."'" ) ;
}
$xoopsDB->query( "DELETE FROM ".$xoopsDB->prefix("newblocks")." WHERE dirname='protector' AND func_file='protector_block.php' AND show_func='b_protector_show'" ) ;
$xoopsDB->query( "ALTER TABLE ".$xoopsDB->prefix("config")." ADD KEY (conf_title)" ) ;
$xoopsDB->query( "ALTER TABLE ".$xoopsDB->prefix("protector_access")." ADD malicious_actions varchar(255) NOT NULL default '' AFTER request_uri, ADD KEY (malicious_actions), ADD KEY (ip), ADD KEY (request_uri), ADD KEY (expire)" ) ;
?>
After iserting 4 lines, update protector in modules admin.
I think so too, just got finished putting the database back together again... 2.2.4 crashed before I could start the downgrade, so I had to fix the database manually...UGH.
But it is all happy now!