Update of /cvsroot/mantisbt/mantisbt/core
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv25123
Modified Files:
custom_field_api.php
Log Message:
Fix: 0004897: SQL standardization in custom_field_api.php
Index: custom_field_api.php
===================================================================
RCS file: /cvsroot/mantisbt/mantisbt/core/custom_field_api.php,v
retrieving revision 1.43
retrieving revision 1.44
diff -u -d -r1.43 -r1.44
--- custom_field_api.php 17 Nov 2004 20:01:34 -0000 1.43
+++ custom_field_api.php 15 Dec 2004 11:08:32 -0000 1.44
@@ -751,12 +751,13 @@
$t_custom_field_string_table = config_get(
'mantis_custom_field_string_table' );
$query = "SELECT f.name, f.type, f.access_level_r,
f.default_value, f.type, s.value
- FROM $t_custom_field_project_table AS
p, $t_custom_field_table AS f
+ FROM $t_custom_field_project_table AS p
INNER JOIN $t_custom_field_table AS f
+ ON p.field_id = f.id
LEFT JOIN $t_custom_field_string_table
AS s
ON p.field_id=s.field_id AND
s.bug_id='$c_bug_id'
- WHERE p.project_id = '$c_project_id'
AND p.field_id = f.id
+ WHERE p.project_id = '$c_project_id'
ORDER BY p.sequence ASC, f.name ASC";
-
+
$result = db_query( $query );
$t_row_count = db_num_rows( $result );
-------------------------------------------------------
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://productguide.itmanagersjournal.com/
|
