Source for file _hitlist.class.php
Documentation is available at _hitlist.class.php
* This file implements the Hitlist class. * This file is part of the evoCore framework - {@link http://evocore.net/} * See also {@link http://sourceforge.net/projects/evocms/}. * @copyright (c)2003-2010 by Francois PLANQUE - {@link http://fplanque.net/} * Parts of this file are copyright (c)2004-2006 by Daniel HAHLER - {@link http://thequod.de/contact}. * {@internal License choice * - If you have received this file as part of a package, please find the license.txt file in * the same folder or the closest folder above for complete license terms. * - If you have received this file individually (e-g: from http://evocms.cvs.sourceforge.net/) * then you must choose one of the following licenses before using the file: * - GNU General Public License 2 (GPL) - http://www.opensource.org/licenses/gpl-license.php * - Mozilla Public License 1.1 (MPL) - http://www.opensource.org/licenses/mozilla1.1.php * {@internal Open Source relicensing agreement: * Daniel HAHLER grants Francois PLANQUE the right to license * Daniel HAHLER's contributions to this file and the b2evolution project * under any OSI approved OSS license (http://www.opensource.org/licenses/). * {@internal Below is a list of authors who have contributed to design/coding of this file: }} * @author blueyed: Daniel HAHLER. * @author fplanque: Francois PLANQUE. * @version $Id: _hitlist.class.php,v 1.22 2010/02/08 17:53:55 efy-yury Exp $ if( !defined('EVO_MAIN_INIT') ) die( 'Please, do not access this page directly.' ); * A list of hits. Provides functions for maintaining and extraction of Hits. * @param int ID to delete * @return mixed Return value of {@link DB::query()} return $DB->query( "DELETE FROM T_hitlog WHERE hit_ID = $hit_ID", 'Delete a hit' ); * Delete all hits for a specific date * @param int unix timestamp to delete hits for * @return mixed Return value of {@link DB::query()} $iso_date =
date ('Y-m-d', $date); WHERE DATE_FORMAT(hit_datetime,'%Y-%m-%d') = '$iso_date'"; return $DB->query( $sql, 'Prune hits for a specific date' ); * @param int ID to change * @param string new type, must be valid ENUM for hit_referer_type field * @return mixed Return value of {@link DB::query()} SET hit_referer_type = '.
$DB->quote($type).
", hit_datetime = hit_datetime " /* prevent mySQL from updating timestamp */ .
" return $DB->query( $sql, 'Change type for a specific hit' ); * Auto pruning of old stats. * It uses a general setting to store the day of the last prune, avoiding multiple prunes per day. * fplanque>> Check: How much faster is this than DELETING right away with an INDEX on the date field? * Note: we're using {@link $localtimenow} to log hits, so use this for pruning, too. * NOTE: do not call this directly, but only in conjuction with auto_prune_stats_mode. * @return string Empty, if ok. // Prune when $localtime is a NEW day (which will be the 1st request after midnight): $last_prune =
$Settings->get( 'auto_prune_stats_done' ); if( $last_prune >=
date('Y-m-d', $localtimenow) &&
$last_prune <=
date('Y-m-d', $localtimenow+
86400) ) { // Already pruned today (and not more than one day in the future -- which typically never happens) return T_('Pruning has already been done today'); $time_prune_before =
($localtimenow -
($Settings->get('auto_prune_stats') *
86400)); // 1 day = 86400 seconds $rows_affected =
$DB->query( " WHERE hit_datetime < '".
date('Y-m-d', $time_prune_before).
"'", 'Autopruning hit log' ); $Debuglog->add( 'Hitlist::dbprune(): autopruned '.
$rows_affected.
' rows from T_hitlog.', 'request' ); // Prune sessions that have timed out and are older than auto_prune_stats $sess_prune_before =
($localtimenow -
$Settings->get( 'timeout_sessions' )); $smaller_time =
min( $sess_prune_before, $time_prune_before ); // allow plugins to prune session based data $Plugins->trigger_event( 'BeforeSessionsDelete', $temp_array =
array( 'cutoff_timestamp' =>
$smaller_time ) ); $rows_affected =
$DB->query( 'DELETE FROM T_sessions WHERE sess_lastseen < '.
$DB->quote(date('Y-m-d H:i:s', $smaller_time)), 'Autoprune sessions' ); $Debuglog->add( 'Hitlist::dbprune(): autopruned '.
$rows_affected.
' rows from T_sessions.', 'request' ); // Prune non-referrered basedomains (where the according hits got deleted) // BUT only those with unknown dom_type/dom_status, because otherwise this // info is useful when we get hit again. // Note: MySQL server version >= 4 is required for multi-table deletes, but v 4.1 is now a requirement for b2evolution: $rows_affected =
$DB->query( " FROM T_basedomains LEFT JOIN T_hitlog ON hit_referer_dom_ID = dom_ID WHERE hit_referer_dom_ID IS NULL AND dom_status = 'unknown'" ); $Debuglog->add( 'Hitlist::dbprune(): autopruned '.
$rows_affected.
' rows from T_basedomains.', 'request' ); $DB->query('OPTIMIZE TABLE T_hitlog'); $DB->query('OPTIMIZE TABLE T_sessions'); $DB->query('OPTIMIZE TABLE T_basedomains'); $Settings->set( 'auto_prune_stats_done', date('Y-m-d H:i:s', $localtimenow) ); // save exact datetime * $Log: _hitlist.class.php,v $ * Revision 1.22 2010/02/08 17:53:55 efy-yury * Revision 1.21 2009/12/08 22:38:13 fplanque * User agent type is now saved directly into the hits table instead of a costly lookup in user agents table * Revision 1.20 2009/11/30 00:22:05 fplanque * show more timers in view of block caching * Revision 1.19 2009/11/15 19:05:43 fplanque * Revision 1.18 2009/11/11 23:32:27 blueyed * Hitlist::dbprune: also prune if last prune is more than 1 day in the future. * Revision 1.17 2009/09/19 12:57:20 blueyed * Hitlist: Optimize tables after pruning entries. * Revision 1.16 2009/09/19 12:52:54 blueyed * Remove obsolete entries from T_ user agents when pruning hitlog info. * Revision 1.15 2009/09/14 18:37:07 fplanque * Revision 1.14 2009/09/13 21:26:50 blueyed * SQL_NO_CACHE for SELECT queries using T_hitlog * Revision 1.13 2009/07/06 22:55:11 fplanque * Revision 1.12 2009/07/06 12:44:59 yabs * Modifying BeforeSessionsDelete behaviour * Revision 1.11 2009/07/05 00:50:29 fplanque * Revision 1.10 2009/07/04 08:01:49 yabs * Revision 1.9 2009/07/04 01:52:51 fplanque * Revision 1.8 2009/07/02 22:01:15 blueyed * Fix BeforeSessionsDelete: add it to base plugin class, test plugin and implement FPs requirements. * Revision 1.7 2009/07/02 00:01:50 fplanque
