From 1604a0fc2bd96b753b9f04af1d110d9e47a6dd76 Mon Sep 17 00:00:00 2001
From: mjollnir_ <mjollnir_>
Date: Tue, 23 Nov 2004 02:05:47 +0000
Subject: [PATCH] Merged from MOODLE_14_STABLE: More small sql tweaks to avoid
 invalid postgres sql

---
 lib/datalib.php     | 8 ++++----
 mod/chat/report.php | 4 ++--
 2 files changed, 6 insertions(+), 6 deletions(-)

diff --git a/lib/datalib.php b/lib/datalib.php
index dc57516936..cb4ee14668 100644
--- a/lib/datalib.php
+++ b/lib/datalib.php
@@ -2648,10 +2648,10 @@ function get_logs_usercourse($userid, $courseid, $coursestart) {
         $courseselect = '';
     }
 
-    return get_records_sql("SELECT floor((`time` - $coursestart)/". DAYSECS .") as day, count(*) as num
+    return get_records_sql("SELECT floor((time - $coursestart)/". DAYSECS .") as day, count(*) as num
                             FROM {$CFG->prefix}log
                            WHERE userid = '$userid'
-                             AND `time` > '$coursestart' $courseselect
+                             AND time > '$coursestart' $courseselect
                         GROUP BY day ");
 }
 
@@ -2675,10 +2675,10 @@ function get_logs_userday($userid, $courseid, $daystart) {
         $courseselect = '';
     }
 
-    return get_records_sql("SELECT floor((`time` - $daystart)/". HOURSECS .") as hour, count(*) as num
+    return get_records_sql("SELECT floor((time - $daystart)/". HOURSECS .") as hour, count(*) as num
                             FROM {$CFG->prefix}log
                            WHERE userid = '$userid'
-                             AND `time` > '$daystart' $courseselect
+                             AND time > '$daystart' $courseselect
                         GROUP BY hour ");
 }
 
diff --git a/mod/chat/report.php b/mod/chat/report.php
index ddbc516bc1..4c2c77b241 100644
--- a/mod/chat/report.php
+++ b/mod/chat/report.php
@@ -44,7 +44,7 @@
 
     if ($start and $end and !$confirmdelete) {   // Show a full transcript
 
-        if ($groupid) {
+        if (!empty($groupid)) {
             $groupselect = " AND groupid = '$currentgroup'";
             $groupparam = "&amp;groupid=$currentgroup";
         } else {
@@ -106,7 +106,7 @@
         $currentgroup = false;
     }
 
-    if ($currentgroup) {
+    if (!empty($currentgroup)) {
         $groupselect = " AND groupid = '$currentgroup'";
         $groupparam = "&amp;groupid=$currentgroup";
     } else {
-- 
2.39.5