mantisbt print_bugnote_inc.php,1.33,1.34 print_bug_page.php,1.54,1.55 print_all_bug_page_word.php,1.57,1.58 print_all_bug_page_excel.php,1.44,1.45 manage_user_page.php,1.56,1.57 bugnote_view_inc.php,1.24,1.25

Update of /cvsroot/mantisbt/mantisbt
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv11137

Modified Files:
        print_bugnote_inc.php print_bug_page.php 
        print_all_bug_page_word.php print_all_bug_page_excel.php 
        manage_user_page.php bugnote_view_inc.php 
Log Message:
fix for 0005382: Ambiguous SQL - manage_user_page.php (and others)


Index: print_bugnote_inc.php
===================================================================
RCS file: /cvsroot/mantisbt/mantisbt/print_bugnote_inc.php,v
retrieving revision 1.33
retrieving revision 1.34
diff -u -d -r1.33 -r1.34
--- print_bugnote_inc.php       28 Feb 2005 00:30:39 -0000      1.33
+++ print_bugnote_inc.php       26 Mar 2005 18:27:17 -0000      1.34
@@ -37,7 +37,7 @@
        # get the bugnote data
        $t_bugnote_order = current_user_get_pref( 'bugnote_order' );
 
-       $query = "SELECT *,date_submitted
+       $query = "SELECT *
                        FROM $t_bugnote_table
                        WHERE bug_id='$c_bug_id' $t_restriction
                        ORDER BY date_submitted $t_bugnote_order";

Index: bugnote_view_inc.php
===================================================================
RCS file: /cvsroot/mantisbt/mantisbt/bugnote_view_inc.php,v
retrieving revision 1.24
retrieving revision 1.25
diff -u -d -r1.24 -r1.25
--- bugnote_view_inc.php        30 Nov 2004 12:17:03 -0000      1.24
+++ bugnote_view_inc.php        26 Mar 2005 18:27:18 -0000      1.25
@@ -33,7 +33,7 @@
        $t_bugnote_order                = current_user_get_pref( 
'bugnote_order' );
 
        # get the bugnote data
-       $query = "SELECT *,date_submitted
+       $query = "SELECT *
                        FROM $t_bugnote_table
                        WHERE bug_id='$f_bug_id' $t_restriction
                        ORDER BY date_submitted $t_bugnote_order";

Index: print_all_bug_page_word.php
===================================================================
RCS file: /cvsroot/mantisbt/mantisbt/print_all_bug_page_word.php,v
retrieving revision 1.57
retrieving revision 1.58
diff -u -d -r1.57 -r1.58
--- print_all_bug_page_word.php 28 Feb 2005 00:30:39 -0000      1.57
+++ print_all_bug_page_word.php 26 Mar 2005 18:27:17 -0000      1.58
@@ -400,7 +400,7 @@
        $t_bugnote_text_table   = config_get( 'mantis_bugnote_text_table' );
        $t_bugnote_order = current_user_get_pref( 'bugnote_order' );
 
-       $query6 = "SELECT *, date_submitted
+       $query6 = "SELECT *
                        FROM $t_bugnote_table
                        WHERE bug_id='$v_id' $t_restriction
                        ORDER BY date_submitted $t_bugnote_order";

Index: print_bug_page.php
===================================================================
RCS file: /cvsroot/mantisbt/mantisbt/print_bug_page.php,v
retrieving revision 1.54
retrieving revision 1.55
diff -u -d -r1.54 -r1.55
--- print_bug_page.php  28 Feb 2005 00:30:39 -0000      1.54
+++ print_bug_page.php  26 Mar 2005 18:27:17 -0000      1.55
@@ -31,7 +31,7 @@
        $c_bug_id = (integer)$f_bug_id;
 
        $t_bug_table = config_get( 'mantis_bug_table' );
-       $query = "SELECT *, date_submitted, last_updated
+       $query = "SELECT *
                        FROM $t_bug_table
                        WHERE id='$c_bug_id'";
        $result = db_query( $query );

Index: print_all_bug_page_excel.php
===================================================================
RCS file: /cvsroot/mantisbt/mantisbt/print_all_bug_page_excel.php,v
retrieving revision 1.44
retrieving revision 1.45
diff -u -d -r1.44 -r1.45
--- print_all_bug_page_excel.php        28 Feb 2005 00:30:39 -0000      1.44
+++ print_all_bug_page_excel.php        26 Mar 2005 18:27:18 -0000      1.45
@@ -118,7 +118,7 @@
                        $t_bug_arr_sort[$index]=1;
                }
        }
-
+var_dump($t_field_name_arr);
        for( $i=0; $i < $row_count; $i++ ) {
 
                # prefix bug data with v_
@@ -350,7 +350,7 @@
                                        PRINT '<br />';
                                }
                                else {
-                                       PRINT '&nbsp';
+                                       PRINT ' ';
                                } #if
                        } #for loop
 
@@ -372,7 +372,7 @@
                $t_bugnote_text_table   = config_get( 
'mantis_bugnote_text_table' );
                $t_bugnote_order = current_user_get_pref( 'bugnote_order' );
 
-               $query6 = "SELECT *,date_submitted
+               $query6 = "SELECT *
                                FROM $t_bugnote_table
                                WHERE bug_id='$v_id' $t_restriction
                                ORDER BY date_submitted $t_bugnote_order";

Index: manage_user_page.php
===================================================================
RCS file: /cvsroot/mantisbt/mantisbt/manage_user_page.php,v
retrieving revision 1.56
retrieving revision 1.57
diff -u -d -r1.56 -r1.57
--- manage_user_page.php        8 Dec 2004 12:52:59 -0000       1.56
+++ manage_user_page.php        26 Mar 2005 18:27:18 -0000      1.57
@@ -179,12 +179,12 @@
 
        # Get the user data in $c_sort order
        if ( 0 == $c_hide ) {
-               $query = "SELECT *, date_created, last_visit
+               $query = "SELECT *
                                FROM $t_user_table
                                WHERE $t_where
                                ORDER BY $c_sort $c_dir";
        } else {
-               $query = "SELECT *, date_created, last_visit
+               $query = "SELECT *
                                FROM $t_user_table
                                WHERE (" . 
db_helper_compare_days(db_now(),"last_visit","< '$days_old'") . ") AND $t_where
                                ORDER BY $c_sort $c_dir";



-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click