--- moodle-clean/moodle/blocks/mrbs/web/view_entry.php 2008-11-26 11:58:24.000000000 +0000 +++ moodle-dev/blocks/mrbs/web/view_entry.php 2009-04-22 10:25:11.000000000 +0100 @@ -75,9 +75,12 @@ ($tbl_entry.end_time - $tbl_entry.start_time), $tbl_entry.start_time, $tbl_entry.end_time, - $tbl_entry.repeat_id + $tbl_entry.repeat_id, + {$CFG->prefix}user.id as userid, + concat({$CFG->prefix}user.firstname,' ',{$CFG->prefix}user.lastname) as fullname, + $tbl_entry.id - FROM $tbl_entry, $tbl_room, $tbl_area + FROM $tbl_entry left join {$CFG->prefix}user on {$CFG->prefix}user.username = $tbl_entry.create_by, $tbl_room, $tbl_area WHERE $tbl_entry.room_id = $tbl_room.id AND $tbl_room.area_id = $tbl_area.id AND $tbl_entry.id=$id @@ -103,7 +106,7 @@ # leave this code alone, please. $name = htmlspecialchars($row[0]); $description = htmlspecialchars($row[1]); -$create_by = htmlspecialchars($row[2]); +$create_by = "".htmlspecialchars($row[13]).''; $room_name = htmlspecialchars($row[3]); $area_name = htmlspecialchars($row[4]); $type = $row[5]; @@ -196,7 +199,22 @@ ?> -
+