make logging configurable; add logging to syslog

[tt-rss.git] / classes / pref / system.php

diff --git a/classes/pref/system.php b/classes/pref/system.php
index 725c337dc99ec0504dd2ab42a3b0e93e2347f146..d2b6cd7461ff8240a4cbfabd87f3670a13204b41 100644 (file)
--- a/classes/pref/system.php
+++ b/classes/pref/system.php
@@ -24,46 +24,53 @@ class Pref_System extends Handler_Protected {
                print "<div dojoType=\"dijit.layout.AccordionContainer\" region=\"center\">";
                print "<div dojoType=\"dijit.layout.AccordionPane\" title=\"".__('Error Log')."\">";
 
-               $result = $this->dbh->query("SELECT errno, errstr, filename, lineno,
-                       created_at, login FROM ttrss_error_log
-                       LEFT JOIN ttrss_users ON (owner_uid = ttrss_users.id)
-                       ORDER BY ttrss_error_log.id DESC
-                       LIMIT 100");
-
-               print "<button dojoType=\"dijit.form.Button\"
-                       onclick=\"updateSystemList()\">".__('Refresh')."</button> ";
-
-               print "<p><table width=\"100%\" cellspacing=\"10\" class=\"prefErrorLog\">";
-
-               print "<tr class=\"title\">
-                       <td width='5%'>".__("Error")."</td>
-                       <td>".__("Filename")."</td>
-                       <td>".__("Message")."</td>
-                       <td width='5%'>".__("User")."</td>
-                       <td width='5%'>".__("Date")."</td>
-                       </tr>";
-
-               while ($line = $this->dbh->fetch_assoc($result)) {
-                       print "<tr class=\"errrow\">";
-
-                       foreach ($line as $k => $v) {
-                               $line[$k] = htmlspecialchars($v);
+               if (LOG_DESTINATION == "sql") {
+
+                       $result = $this->dbh->query("SELECT errno, errstr, filename, lineno,
+                               created_at, login FROM ttrss_error_log
+                               LEFT JOIN ttrss_users ON (owner_uid = ttrss_users.id)
+                               ORDER BY ttrss_error_log.id DESC
+                               LIMIT 100");
+
+                       print "<button dojoType=\"dijit.form.Button\"
+                               onclick=\"updateSystemList()\">".__('Refresh')."</button> ";
+
+                       print "<p><table width=\"100%\" cellspacing=\"10\" class=\"prefErrorLog\">";
+
+                       print "<tr class=\"title\">
+                               <td width='5%'>".__("Error")."</td>
+                               <td>".__("Filename")."</td>
+                               <td>".__("Message")."</td>
+                               <td width='5%'>".__("User")."</td>
+                               <td width='5%'>".__("Date")."</td>
+                               </tr>";
+
+                       while ($line = $this->dbh->fetch_assoc($result)) {
+                               print "<tr class=\"errrow\">";
+
+                               foreach ($line as $k => $v) {
+                                       $line[$k] = htmlspecialchars($v);
+                               }
+
+                               print "<td class='errno'>" . Logger::$errornames[$line["errno"]] . " (" . $line["errno"] . ")</td>";
+                               print "<td class='filename'>" . $line["filename"] . ":" . $line["lineno"] . "</td>";
+                               print "<td class='errstr'>" . $line["errstr"] . "</td>";
+                               print "<td class='login'>" . $line["login"] . "</td>";
+
+                               print "<td class='timestamp'>" .
+                                       make_local_datetime(
+                                       $line["created_at"], false) . "</td>";
+
+                               print "</tr>";
                        }
 
-                       print "<td class='errno'>" . Logger::$errornames[$line["errno"]] . " (" . $line["errno"] . ")</td>";
-                       print "<td class='filename'>" . $line["filename"] . ":" . $line["lineno"] . "</td>";
-                       print "<td class='errstr'>" . $line["errstr"] . "</td>";
-                       print "<td class='login'>" . $line["login"] . "</td>";
+                       print "</table>";
+               } else {
 
-                       print "<td class='timestamp'>" .
-                               make_local_datetime(
-                               $line["created_at"], false) . "</td>";
+                       print_notice("Please set LOG_DESTINATION to 'sql' in config.php to enable database logging.");
 
-                       print "</tr>";
                }
 
-               print "</table>";
-
                print "</div>";
 
                PluginHost::getInstance()->run_hooks(PluginHost::HOOK_PREFS_TAB,