[geeklog-cvs] geeklog-1.3/system/classes search.class.php,1.31,1.32

[dhaun at iowaoutdoors.org]

Update of /var/cvs/geeklog-1.3/system/classes
In directory www:/tmp/cvs-serv3999

Modified Files:
	search.class.php 
Log Message:
Fixed SQL errors caused by extra ORs


Index: search.class.php
===================================================================
RCS file: /var/cvs/geeklog-1.3/system/classes/search.class.php,v
retrieving revision 1.31
retrieving revision 1.32
diff -C2 -d -r1.31 -r1.32
*** search.class.php	24 Jan 2005 10:35:55 -0000	1.31
--- search.class.php	1 Feb 2005 19:20:31 -0000	1.32
***************
*** 328,332 ****
                  $stwhere .= "({$_TABLES['stories']}.owner_id IS NOT NULL AND {$_TABLES['stories']}.perm_owner IS NOT NULL) OR ";
                  $stwhere .= "({$_TABLES['stories']}.group_id IS NOT NULL AND {$_TABLES['stories']}.perm_group IS NOT NULL) OR ";
!                 $stwhere .= "({$_TABLES['stories']}.perm_members IS NOT NULL) OR ";
              }
  
--- 328,332 ----
                  $stwhere .= "({$_TABLES['stories']}.owner_id IS NOT NULL AND {$_TABLES['stories']}.perm_owner IS NOT NULL) OR ";
                  $stwhere .= "({$_TABLES['stories']}.group_id IS NOT NULL AND {$_TABLES['stories']}.perm_group IS NOT NULL) OR ";
!                 $stwhere .= "({$_TABLES['stories']}.perm_members IS NOT NULL)";
              }
  
***************
*** 338,342 ****
                  $powhere .= "({$_TABLES['pollquestions']}.owner_id IS NOT NULL AND {$_TABLES['pollquestions']}.perm_owner IS NOT NULL) OR ";
                  $powhere .= "({$_TABLES['pollquestions']}.group_id IS NOT NULL AND {$_TABLES['pollquestions']}.perm_group IS NOT NULL) OR ";
!                 $powhere .= "({$_TABLES['pollquestions']}.perm_members IS NOT NULL) OR ";
              }
  
--- 338,342 ----
                  $powhere .= "({$_TABLES['pollquestions']}.owner_id IS NOT NULL AND {$_TABLES['pollquestions']}.perm_owner IS NOT NULL) OR ";
                  $powhere .= "({$_TABLES['pollquestions']}.group_id IS NOT NULL AND {$_TABLES['pollquestions']}.perm_group IS NOT NULL) OR ";
!                 $powhere .= "({$_TABLES['pollquestions']}.perm_members IS NOT NULL)";
              }