-<?php\r
-/*\r
- * Nucleus: PHP/MySQL Weblog CMS (http://nucleuscms.org/)\r
- * Copyright (C) 2002-2009 The Nucleus Group\r
- *\r
- * This program is free software; you can redistribute it and/or\r
- * modify it under the terms of the GNU General Public License\r
- * as published by the Free Software Foundation; either version 2\r
- * of the License, or (at your option) any later version.\r
- * (see nucleus/documentation/index.html#license for more info)\r
- */\r
-/**\r
- * Actionlog class for Nucleus\r
- *\r
- * @license http://nucleuscms.org/license.txt GNU General Public License\r
- * @copyright Copyright (C) 2002-2009 The Nucleus Group\r
- * @version $Id: ACTIONLOG.php 1470 2010-11-29 22:10:16Z ftruscot $\r
- */\r
-define('ERROR',1); // only errors\r
-define('WARNING',2); // errors and warnings\r
-define('INFO',3); // info, errors and warnings\r
-define('DEBUG',4); // everything\r
-$CONF['LogLevel'] = INFO;\r
-\r
-class ACTIONLOG\r
-{\r
- /**\r
- * ACTIONLOG::add()\r
- * Method to add a message to the action log\r
- * \r
- * @static\r
- * @param Integer $level log level\r
- * @param String $message log message\r
- * @return \r
- * \r
- */\r
- function add($level, $message)\r
- {\r
- global $member, $CONF;\r
- \r
- if ( $CONF['LogLevel'] < $level )\r
- {\r
- return;\r
- }\r
- \r
- if ( $member && $member->isLoggedIn() )\r
- {\r
- $message = "[" . $member->getDisplayName() . "] " . $message;\r
- }\r
- \r
- $message = sql_real_escape_string($message); // add slashes\r
- $timestamp = date("Y-m-d H:i:s",time()); // format timestamp\r
- $query = "INSERT INTO %s (timestamp, message) VALUES ('%s', '%s')";\r
- $query = sprintf($query, sql_table('actionlog'), $timestamp, $message);\r
- sql_query($query);\r
- \r
- self::trimLog();\r
- return;\r
- }\r
- \r
- /**\r
- * (Static) Method to clear the whole action log\r
- */\r
- function clear() {\r
- global $manager;\r
-\r
- $query = 'DELETE FROM ' . sql_table('actionlog');\r
-\r
- $manager->notify('ActionLogCleared',array());\r
-\r
- return sql_query($query);\r
- }\r
-\r
- /**\r
- * (Static) Method to trim the action log (from over 500 back to 250 entries)\r
- */\r
- function trimLog() {\r
- static $checked = 0;\r
-\r
- // only check once per run\r
- if ($checked) return;\r
-\r
- // trim\r
- $checked = 1;\r
-\r
- $iTotal = quickQuery('SELECT COUNT(*) AS result FROM ' . sql_table('actionlog'));\r
-\r
- // if size > 500, drop back to about 250\r
- $iMaxSize = 500;\r
- $iDropSize = 250;\r
- if ($iTotal > $iMaxSize) {\r
- $tsChop = quickQuery('SELECT timestamp as result FROM ' . sql_table('actionlog') . ' ORDER BY timestamp DESC LIMIT '.$iDropSize.',1');\r
- sql_query('DELETE FROM ' . sql_table('actionlog') . ' WHERE timestamp < \'' . $tsChop . '\'');\r
- }\r
-\r
- }\r
-\r
-}\r
-\r
-?>\r
+<?php
+/*
+ * Nucleus: PHP/MySQL Weblog CMS (http://nucleuscms.org/)
+ * Copyright (C) 2002-2009 The Nucleus Group
+ *
+ * This program is free software; you can redistribute it and/or
+ * modify it under the terms of the GNU General Public License
+ * as published by the Free Software Foundation; either version 2
+ * of the License, or (at your option) any later version.
+ * (see nucleus/documentation/index.html#license for more info)
+ */
+/**
+ * Actionlog class for Nucleus
+ *
+ * @license http://nucleuscms.org/license.txt GNU General Public License
+ * @copyright Copyright (C) 2002-2009 The Nucleus Group
+ * @version $Id: ACTIONLOG.php 1822 2012-05-04 13:47:22Z sakamocchi $
+ */
+define('ERROR',1); // only errors
+define('WARNING',2); // errors and warnings
+define('INFO',3); // info, errors and warnings
+define('DEBUG',4); // everything
+$CONF['LogLevel'] = INFO;
+
+class ActionLog
+{
+ /**
+ * ActionLog::add()
+ * Method to add a message to the action log
+ *
+ * @static
+ * @param Integer $level log level
+ * @param String $message log message
+ * @return
+ *
+ */
+ function add($level, $message)
+ {
+ global $member, $CONF;
+
+ if ( $CONF['LogLevel'] < $level )
+ {
+ return;
+ }
+
+ if ( $member && $member->isLoggedIn() )
+ {
+ $message = "[" . $member->getDisplayName() . "] " . $message;
+ }
+
+ $query = "INSERT INTO %s (timestamp, message) VALUES (%s, %s)";
+ $query = sprintf($query, sql_table('actionlog'), DB::formatDateTime(), DB::quoteValue($message));
+ DB::execute($query);
+
+ self::trimLog();
+ return;
+ }
+
+ /**
+ * (Static) Method to clear the whole action log
+ */
+ function clear() {
+ global $manager;
+
+ $query = sprintf('DELETE FROM %s', sql_table('actionlog'));
+
+ $manager->notify('ActionLogCleared',array());
+
+ return DB::execute($query) !== FALSE;
+ }
+
+ /**
+ * (Static) Method to trim the action log (from over 500 back to 250 entries)
+ */
+ function trimLog() {
+ static $checked = 0;
+
+ // only check once per run
+ if ($checked) return;
+
+ // trim
+ $checked = 1;
+
+ $query = sprintf('SELECT COUNT(*) AS result FROM %s', sql_table('actionlog'));
+ $iTotal = DB::getValue($query);
+
+ // if size > 500, drop back to about 250
+ $iMaxSize = 500;
+ $iDropSize = 250;
+ if ($iTotal > $iMaxSize) {
+ $query = sprintf('SELECT timestamp as result FROM %s ORDER BY timestamp DESC LIMIT %d,1',
+ sql_table('actionlog'), intval($iDropSize));
+ $tsChop = DB::getValue($query);
+ $query = sprintf("DELETE FROM %s WHERE timestamp < '%s'", sql_table('actionlog'), $tsChop);
+ DB::execute($query);
+ }
+
+ }
+
+}
+
+?>
\ No newline at end of file
OSDN Git Service
