From 5586395f75df8c3e634368917aa3e799746871d6 Mon Sep 17 00:00:00 2001
From: paca70 <paca70>
Date: Thu, 26 Aug 2004 18:50:08 +0000
Subject: [PATCH] Postgresql wants  'as' be used.

---
 mod/dialogue/lib.php | 2 +-
 mod/exercise/lib.php | 2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/mod/dialogue/lib.php b/mod/dialogue/lib.php
index fc36fbfab1..2057bac50e 100644
--- a/mod/dialogue/lib.php
+++ b/mod/dialogue/lib.php
@@ -433,7 +433,7 @@ function dialogue_get_open_conversations($course) {
     if (empty($USER->id)) {
         return false;
     }
-    if ($conversations = get_records_sql("SELECT d.name dialoguename, c.id, c.dialogueid, c.timemodified, c.lastid
+    if ($conversations = get_records_sql("SELECT d.name as dialoguename, c.id, c.dialogueid, c.timemodified, c.lastid
                             FROM {$CFG->prefix}dialogue d, {$CFG->prefix}dialogue_conversations c
                             WHERE d.course = $course->id
                                 AND c.dialogueid = d.id
diff --git a/mod/exercise/lib.php b/mod/exercise/lib.php
index ff18872310..32c3cb37ab 100644
--- a/mod/exercise/lib.php
+++ b/mod/exercise/lib.php
@@ -625,7 +625,7 @@ function exercise_get_submit_logs($course, $timestart) {
     global $CFG, $USER;
     
     $timethen = time() - $CFG->maxeditingtime;
-    return get_records_sql("SELECT l.time, l.url, u.firstname, u.lastname, l.info exerciseid, e.name
+    return get_records_sql("SELECT l.time, l.url, u.firstname, u.lastname, l.info as exerciseid, e.name
                              FROM {$CFG->prefix}log l,
                                 {$CFG->prefix}exercise e, 
                                 {$CFG->prefix}user u
-- 
2.39.5