1
spacejoee
Protector, how to make it run faster
  • 2007/7/31 12:32

  • spacejoee

  • Not too shy to talk

  • Posts: 106

  • Since: 2004/7/25


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.

2
Dave_L
Re: Protector, how to make it run faster
  • 2007/7/31 13:57

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


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

3
kurak_bu
Re: Protector, how to make it run faster
  • 2007/7/31 14:14

  • kurak_bu

  • Quite a regular

  • Posts: 342

  • Since: 2005/9/5 1


I sent him email

Login

Username:
Password:

Lost Password? Register now!

Who's Online

119 user(s) are online (76 user(s) are browsing Support Forums)


Members: 0


Guests: 119


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Jun 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits