Author: r
...@vanmelick.com
Date: Mon Jul 21 14:24:59 2008
New Revision: 2947
Modified:
development/4.0/textpattern/include/txp_category.php
Log:
fix [2929] MySQL operator precedence was a bit different than expected
Modified: development/4.0/textpattern/include/txp_category.php
=========================================================================== ===
--- development/4.0/textpattern/include/txp_category.php (original)
+++ development/4.0/textpattern/include/txp_category.php Mon Jul 21
14:24:59 2008
@@ -179,7 +179,7 @@
$used = safe_column('DISTINCT category', 'txp_'.$type, '1=1');
}
- $rs = safe_rows('id, name', 'txp_category', "id IN (".join(',',
$things).") AND type='".$type."' AND rgt - lft = 1 AND NOT name IN
('".join("','", doSlash($used))."')");
+ $rs = safe_rows('id, name', 'txp_category', "id IN (".join(',',
$things).") AND type='".$type."' AND rgt - lft = 1 AND name NOT IN
('".join("','", doSlash($used))."')");
if ($rs)
{
