Установить hook на запросы к БД - Разработка расширений для Joomla 1.5

$db =& JFactory::getDBO();
$query = 'SELECT greeting FROM #__hello';
$db->setQuery( $query );
$greeting = $db->loadResult();

$query = 'SELECT greeting FROM #__hello';
$db->setQuery( $query );
$greeting = $db->loadResult();

$oldDB =& JFactory::getDBO();
$newDB =& new ProxyDB($oldDB);
$oldDB = $newDB;

defined( '_JEXEC' ) or die( 'Restricted access' ); 

class ProxyDB extends JDatabase {
    function __construct( ) {
        $conf =& JFactory::getConfig();
        $host         = $conf->getValue('config.host');
        $user         = $conf->getValue('config.user');
        $password     = $conf->getValue('config.password');
        $db           = $conf->getValue('config.db');
        $dbprefix     = $conf->getValue('config.dbprefix');
        $dbtype     = $conf->getValue('config.dbtype');
        $debug         = $conf->getValue('config.debug');
        $driver     = $conf->getValue('config.dbtype');
        $options = array("driver"=>$driver, "host"=>$host, "user"=>$user, "password"=>$password, "database"=>$db, "prefix"=>$dbprefix,"select"=>true);
        parent::__construct( $options );
    }
    
    function setQuery( $sql, $offset = 0, $limit = 0, $prefix='#__' )
    {
        parent::setQuery( $sql, $offset = 0, $limit = 0, $prefix='#__'  );
    }
}

class plgSystemTCache extends JPlugin {
    
    function plgSystemTCache(& $subject, $config)
    {
        parent::__construct($subject, $config);
    }
    
    function onAfterInitialise()
    {
        $db = & JFactory::getDBO();
        $db = new ProxyDB();
        $GLOBALS['database'] = $db;
    }
} 

<?php

defined( '_JEXEC' ) or die( 'Restricted access' ); 

if($mainframe->isAdmin()) {
    return;
}

class interceptDB extends JDatabaseMySQL {

    /**
     * This special constructor reuses the existing resource from the existing db connecton
     *
     * @param unknown_type $options
     */
    function __construct($options){
        $db = & JFactory::getDBO();

        $select        = array_key_exists('select', $options)    ? $options['select']    : true;
        $database    = array_key_exists('database',$options)    ? $options['database']    : '';

        // perform a number of fatality checks, then return gracefully
        if (!function_exists( 'mysql_connect' )) {
            $this->_errorNum = 1;
            $this->_errorMsg = 'The MySQL adapter "mysql" is not available.';
            return;
        }

        // connect to the server
        $this->_resource = & $db->_resource;

        // finalize initialization
        JDatabase::__construct($options);

        // select the database
        if ( $select ) {
            $this->select($database);
        }

    }
    
}


class JFDatabase extends interceptDB {

    /** Constructor
    */
    function JFDatabase( $options) {
        parent::__construct($options );
    }
    
    function setQuery( $sql, $offset = 0, $limit = 0, $prefix='#__' )
    {
        parent::setQuery( $sql, $offset = 0, $limit = 0, $prefix='#__' );
    }

    /**
     * Returns a reference to the global Database object, only creating it
     * if it doesn't already exist. And keeps sure that there is only one
     * instace for a specific combination of the JDatabase signature
     *
     * @param string  Database driver
     * @param string Database host
     * @param string Database user name
     * @param string Database user password
     * @param string Database name
     * @param string Common prefix for all tables
     * @return database A database object
     * @since 1.5
    */
    function &getInstance( $driver='mysql', $host='localhost', $user, $pass, $db='', $table_prefix='' )
    {
        $signature = serialize(array($driver, $host, $user, $pass, $db, $table_prefix));
        $database = JDatabase::_getStaticInstance($signature,'JFDatabase',true);
        return $database;
    }


    /**
     * The following methods are not yet implemented in JoomFish (or may not be possible)
     */
    // function queryBatch( $abort_on_error=true, $p_transaction_safe = false)
}
   
 
class plgSystemTCache extends JPlugin {
 
    function plgSystemTCache(& $subject, $config)
    {
        parent::__construct($subject, $config);
    }
 
    function onAfterInitialise()
    {
        $conf =& JFactory::getConfig();
        $host         = $conf->getValue('config.host');
        $user         = $conf->getValue('config.user');
        $password     = $conf->getValue('config.password');
        $db           = $conf->getValue('config.db');
        $dbprefix     = $conf->getValue('config.dbprefix');
        $dbtype     = $conf->getValue('config.dbtype');
        $debug         = $conf->getValue('config.debug');
        $driver     = $conf->getValue('config.dbtype');

        $options = array("driver"=>$driver, "host"=>$host, "user"=>$user, "password"=>$password, "database"=>$db, "prefix"=>$dbprefix,"select"=>true);

        $db = & JFactory::getDBO();
        $db = new JFDatabase($options);
        $debug = $conf->getValue('config.debug');
        $db->debug($debug);

        if ($db->getErrorNum() > 2) {
            JError::raiseError('joomla.library:'.$db->getErrorNum(), 'JDatabase::getInstance: Could not connect to database <br/>' . $db->getErrorMsg() );
        }
    }
}
?>

090903 13:14:09	     38 Connect     joomla@localhost on 
		     38 Query       set names cp1251
		     38 Query       SET NAMES 'utf8'
		     38 Init DB     joomla
		     38 Query       SET sql_mode = 'MYSQL40'
		     38 Query       SELECT * FROM jos_session WHERE session_id = '5a2bfbaed29474f6dcbbe9e1b9aa2b48'
		     38 Query       DELETE FROM jos_session WHERE ( time < '1251968349' )
		     38 Query       SELECT * FROM jos_session WHERE session_id = '5a2bfbaed29474f6dcbbe9e1b9aa2b48'
		     38 Query       UPDATE `jos_session` SET `time`='1251969249',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:8:{s:15:\"session.counter\";i:31;s:19:\"session.timer.start\";i:1251968538;s:18:\"session.timer.last\";i:1251969144;s:17:\"session.timer.now\";i:1251969159;s:22:\"session.client.browser\";s:47:\"Opera/9.64 (Windows NT 5.1; U; ru) Presto/2.1.1\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:58:\"W:\\home\\joomla\\www\\libraries\\joomla\\html\\parameter\\element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:13:\"session.token\";s:32:\"a5f9b8f7865533bd0eaa640f062c911d\";}' WHERE session_id='5a2bfbaed29474f6dcbbe9e1b9aa2b48'
		     38 Query       SELECT * FROM jos_components WHERE parent = 0
		     38 Query       SELECT folder AS type, element AS name, params FROM jos_plugins WHERE published >= 1 AND access <= 0 ORDER BY ordering
		     38 Query       SET NAMES 'utf8'
		     38 Init DB     joomla
		     38 Query       SET sql_mode = 'MYSQL40'
		     38 Query       SELECT m.*, c.`option` as component FROM jos_menu AS m LEFT JOIN jos_components AS c ON m.componentid = c.id WHERE m.published = 1 ORDER BY m.sublevel, m.parent, m.ordering
		     38 Query       SELECT template FROM jos_templates_menu WHERE client_id = 0 AND (menuid = 0 OR menuid = 1) ORDER BY menuid DESC
		     38 Query       SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email as author_email, cc.title AS category, s.title AS section, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering FROM jos_content AS a INNER JOIN jos_content_frontpage AS f ON f.content_id = a.id LEFT JOIN jos_categories AS cc ON cc.id = a.catid LEFT JOIN jos_sections AS s ON s.id = a.sectionid LEFT JOIN jos_users AS u ON u.id = a.created_by LEFT JOIN jos_groups AS g ON a.access = g.id WHERE 1 AND a.access <= 0 AND a.state = 1 AND (( cc.published = 1 AND s.published = 1 ) OR ( a.catid = 0 AND a.sectionid = 0 ) ) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2009-09-03 09:14:09' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-09-03 09:14:09' ) ORDER BY  f.ordering
		     38 Query       SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email as author_email, cc.title AS category, s.title AS section, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering FROM jos_content AS a INNER JOIN jos_content_frontpage AS f ON f.content_id = a.id LEFT JOIN jos_categories AS cc ON cc.id = a.catid LEFT JOIN jos_sections AS s ON s.id = a.sectionid LEFT JOIN jos_users AS u ON u.id = a.created_by LEFT JOIN jos_groups AS g ON a.access = g.id WHERE 1 AND a.access <= 0 AND a.state = 1 AND (( cc.published = 1 AND s.published = 1 ) OR ( a.catid = 0 AND a.sectionid = 0 ) ) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2009-09-03 09:14:09' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-09-03 09:14:09' ) ORDER BY  f.ordering
		     38 Query       SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 0 AND ( mm.menuid = 1 OR mm.menuid = 0 ) ORDER BY position, ordering
		     38 Query       SELECT id, title, CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END as slug  FROM jos_polls WHERE id = 14 AND published = 1
		     38 Query       SELECT id, text FROM jos_poll_data WHERE pollid = 14 AND text <> "" ORDER BY id
		     38 Query       SELECT guest, usertype, client_id FROM jos_session WHERE client_id = 0
		     38 Query       SELECT * FROM jos_banner WHERE showBanner = 1 AND (imptotal = 0 OR impmade < imptotal) AND catid = 14 ORDER BY sticky DESC, ordering
		     38 Query       UPDATE jos_banner SET impmade = impmade + 1 WHERE bid = 3
		     38 Query       UPDATE jos_banner SET impmade = impmade + 1 WHERE bid = 4
		     38 Query       UPDATE jos_banner SET impmade = impmade + 1 WHERE bid = 5
		     38 Query       UPDATE jos_banner SET impmade = impmade + 1 WHERE bid = 6
		     38 Query       SELECT *, RAND() AS ordering FROM jos_banner WHERE showBanner = 1 AND (imptotal = 0 OR impmade < imptotal) AND cid = 1 AND catid = 33 ORDER BY sticky DESC, ordering
		     38 Query       UPDATE jos_banner SET impmade = impmade + 1 WHERE bid = 8
		     38 Query       UPDATE jos_banner SET impmade = impmade + 1 WHERE bid = 7
		     38 Query       SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug FROM jos_content AS a LEFT JOIN jos_content_frontpage AS f ON f.content_id = a.id INNER JOIN jos_categories AS cc ON cc.id = a.catid INNER JOIN jos_sections AS s ON s.id = a.sectionid WHERE ( a.state = 1 AND s.id > 0 ) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2009-09-03 09:14:09' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-09-03 09:14:09' ) AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0 AND s.published = 1 AND cc.published = 1 ORDER BY a.hits DESC
090903 13:14:10	     38 Query       SELECT a.*,  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug FROM jos_content AS a INNER JOIN jos_categories AS cc ON cc.id = a.catid INNER JOIN jos_sections AS s ON s.id = a.sectionid WHERE a.state = 1 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2009-09-03 09:14:09' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-09-03 09:14:09' ) AND s.id > 0 AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0 AND s.published = 1 AND cc.published = 1 ORDER BY a.created DESC
		     38 Query       SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug FROM jos_content AS a INNER JOIN jos_categories AS cc ON cc.id = a.catid INNER JOIN jos_sections AS s ON s.id = a.sectionid WHERE a.state = 1  AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2009-09-03 09:14:09' )  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-09-03 09:14:09' ) AND cc.id = 3 AND cc.section = s.id AND cc.published = 1 AND s.published = 1 ORDER BY a.ordering
		     38 Query       SELECT * FROM jos_session WHERE session_id = '5a2bfbaed29474f6dcbbe9e1b9aa2b48'
		     38 Query       UPDATE `jos_session` SET `time`='1251969249',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:8:{s:15:\"session.counter\";i:32;s:19:\"session.timer.start\";i:1251968538;s:18:\"session.timer.last\";i:1251969159;s:17:\"session.timer.now\";i:1251969249;s:22:\"session.client.browser\";s:47:\"Opera/9.64 (Windows NT 5.1; U; ru) Presto/2.1.1\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:58:\"W:\\home\\joomla\\www\\libraries\\joomla\\html\\parameter\\element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:13:\"session.token\";s:32:\"a5f9b8f7865533bd0eaa640f062c911d\";}' WHERE session_id='5a2bfbaed29474f6dcbbe9e1b9aa2b48'
		     38 Quit