From 1b6ab8924f702412e0396a5392f3f00a51660db0 Mon Sep 17 00:00:00 2001 From: David Mudrak Date: Fri, 25 Dec 2009 17:18:52 +0000 Subject: [PATCH] MDL-21190 Re-fixing a regression in dependency calculation Sorry for the last commit. This should be the proper way. The problem was with the question mark within quotes - it was not considered as a placeholder. --- lib/grade/grade_item.php | 5 ++--- 1 file changed, 2 insertions(+), 3 deletions(-) diff --git a/lib/grade/grade_item.php b/lib/grade/grade_item.php index d0989b7cba..5c2be297f9 100644 --- a/lib/grade/grade_item.php +++ b/lib/grade/grade_item.php @@ -1331,7 +1331,7 @@ class grade_item extends grade_object { if ($grade_category->aggregatesubcats) { // return all children excluding category items - $params[] = $grade_category->id; + $params[] = '%/' . $grade_category->id . '/%'; $sql = "SELECT gi.id FROM {grade_items} gi WHERE $gtypes @@ -1339,8 +1339,7 @@ class grade_item extends grade_object { AND gi.categoryid IN ( SELECT gc.id FROM {grade_categories} gc - WHERE gc.path LIKE '%/?/%')"; - + WHERE gc.path LIKE ?)"; } else { $params[] = $grade_category->id; $params[] = $grade_category->id; -- 2.39.5