From: <dwa...@us...> - 2008-04-03 14:34:21
|
Revision: 5153 http://mantisbt.svn.sourceforge.net/mantisbt/?rev=5153&view=rev Author: dwarrine5 Date: 2008-04-03 07:33:35 -0700 (Thu, 03 Apr 2008) Log Message: ----------- Tables were added to the from list as well as the join list. Only the join is needed in these cases. Modified Paths: -------------- trunk/mantisbt/core/filter_api.php Modified: trunk/mantisbt/core/filter_api.php =================================================================== --- trunk/mantisbt/core/filter_api.php 2008-04-01 20:57:48 UTC (rev 5152) +++ trunk/mantisbt/core/filter_api.php 2008-04-03 14:33:35 UTC (rev 5153) @@ -1115,7 +1115,6 @@ if ( !$t_any_found ) { $t_clauses = array(); $t_table_name = 'user_monitor'; - array_push( $t_from_clauses, $t_bug_monitor_table ); array_push( $t_join_clauses, "LEFT JOIN $t_bug_monitor_table $t_table_name ON $t_table_name.bug_id = $t_bug_table.id" ); foreach( $t_filter['user_monitor'] as $t_filter_member ) { @@ -1149,7 +1148,6 @@ $t_comp_type = relationship_get_complementary_type( $c_rel_type ); $t_clauses = array(); $t_table_name = 'relationship'; - array_push( $t_from_clauses, $t_bug_relationship_table ); array_push( $t_join_clauses, "LEFT JOIN $t_bug_relationship_table $t_table_name ON $t_table_name.destination_bug_id = $t_bug_table.id" ); array_push( $t_join_clauses, "LEFT JOIN $t_bug_relationship_table ${t_table_name}2 ON ${t_table_name}2.source_bug_id = $t_bug_table.id" ); // get reverse relationships This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |