summaryrefslogtreecommitdiff
path: root/modules
diff options
context:
space:
mode:
authorBharat Mediratta <bharat@menalto.com>2009-06-23 14:23:11 -0700
committerBharat Mediratta <bharat@menalto.com>2009-06-23 14:23:11 -0700
commit4e3b84eb391de177d94fd1c4189d456280fd7fdd (patch)
tree5ec2b701e723ed112ada3c483913430967076251 /modules
parentd5ee5741f2afa0e4a2d6406828cdad01bc8c3f2e (diff)
Escape {$this->sort_column} in get_position()
Diffstat (limited to 'modules')
-rw-r--r--modules/gallery/models/item.php4
1 files changed, 2 insertions, 2 deletions
diff --git a/modules/gallery/models/item.php b/modules/gallery/models/item.php
index 7dce9e51..07c305d8 100644
--- a/modules/gallery/models/item.php
+++ b/modules/gallery/models/item.php
@@ -381,9 +381,9 @@ class Item_Model extends ORM_MPTT {
$result = Database::instance()->query("
SELECT COUNT(*) AS position FROM {items}
WHERE parent_id = {$this->id}
- AND {$this->sort_column} <= (SELECT {$this->sort_column}
+ AND `{$this->sort_column}` <= (SELECT `{$this->sort_column}`
FROM {items} WHERE id = $child_id)
- ORDER BY {$this->sort_column} {$this->sort_order}");
+ ORDER BY `{$this->sort_column}` {$this->sort_order}");
return $result->current()->position;
}