Hi all.
Our website Casafree.com is using XOOPS since 2004. Recently we installed the XOOPS protector module.
This module is really great, but it takes too many MySQL queries not using index. Wich overload the server.

If you are having this same problem, you just have to edit /class/protector.php

$result = @mysql_query( "SELECT conf_name,conf_value FROM ".XOOPS_DB_PREFIX."_config WHERE conf_title like '".$constpref."%'" , $this->_conn ) ;


by

$result = @mysql_query( "SELECT conf_name,conf_value FROM ".XOOPS_DB_PREFIX."_config WHERE conf_modid = XXX" , $this->_conn ) ;

You can find the XXX conf_modid value of your XOOPS protector in you phpmyadmin panel, in the xoops_config table.


Wish this will help you taking the best of this module.

Have you suggested this change to GIJOE at http://xoops.peak.ne.jp/ ?

I sent him email