Changeset:
56f7c586fcd9
https://sourceforge.net/p/mrbs/hg-code/ci/56f7c586fcd91c5db896bc86f52b614e52f4f471
Author:
Campbell Morrison <[email protected]>
Date:
Mon Sep 26 13:48:00 2016 +0100
Log message:
Paremeterised another query
diffstat:
web/mrbs_sql.inc | 16 +++++++++-------
1 files changed, 9 insertions(+), 7 deletions(-)
diffs (28 lines):
diff -r e7cb8d0d5281 -r 56f7c586fcd9 web/mrbs_sql.inc
--- a/web/mrbs_sql.inc Mon Sep 26 13:18:39 2016 +0100
+++ b/web/mrbs_sql.inc Mon Sep 26 13:48:00 2016 +0100
@@ -180,15 +180,17 @@
if (!isset($existing[$location][$interval_type][$interval_start]))
{
- $sql_params = array();
$sql = "SELECT COUNT(*)
FROM $tbl_entry E, $tbl_room R
- WHERE E.start_time<$interval_end
- AND E.end_time>$interval_start
- AND E.create_by=?
- AND E.room_id=R.id
- AND R.disabled=0";
- $sql_params[] = $booking['create_by'];
+ WHERE E.start_time < ?
+ AND E.end_time > ?
+ AND E.create_by = ?
+ AND E.room_id = R.id
+ AND R.disabled = 0";
+
+ $sql_params = array($interval_end,
+ $interval_start,
+ $booking['create_by']);
if ($only_area)
{
------------------------------------------------------------------------------
_______________________________________________
Mrbs-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mrbs-commits
