Update of /cvsroot/phpbt/phpbt/inc/db
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv26965/inc/db
Modified Files:
mssql.php mysql.php mysqli.php oci8.php pgsql.php
Log Message:
Bug #1328267 - resolutions not sorted by sort_order on home page
Added "order by sort_order" to 'index-projsummary-5' in inc/db/*.php
Index: mssql.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/db/mssql.php,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -r1.7 -r1.8
--- mssql.php 2 Oct 2005 20:50:11 -0000 1.7
+++ mssql.php 18 Oct 2005 18:45:10 -0000 1.8
@@ -394,7 +394,8 @@
'index-projsummary-4' =>
"' then 1 else 0 end) as \"'",
'index-projsummary-5' =>
- " from ".TBL_RESOLUTION,
+ " from ".TBL_RESOLUTION.
+ " order by sort_order",
'index-projsummary-6' =>
'%s, count(bug_id) as "Total" '.
'from '.TBL_BUG.' b '.
Index: mysql.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/db/mysql.php,v
retrieving revision 1.30
retrieving revision 1.31
diff -u -r1.30 -r1.31
--- mysql.php 2 Oct 2005 20:50:11 -0000 1.30
+++ mysql.php 18 Oct 2005 18:45:10 -0000 1.31
@@ -393,7 +393,8 @@
'index-projsummary-4' =>
"' then 1 else 0 end) as \"'",
'index-projsummary-5' =>
- " from ".TBL_RESOLUTION,
+ " from ".TBL_RESOLUTION.
+ " order by sort_order",
'index-projsummary-6' =>
'%s, count(bug_id) as "Total" '.
'from '.TBL_BUG.' b '.
Index: mysqli.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/db/mysqli.php,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -r1.4 -r1.5
--- mysqli.php 2 Oct 2005 20:50:11 -0000 1.4
+++ mysqli.php 18 Oct 2005 18:45:10 -0000 1.5
@@ -393,7 +393,8 @@
'index-projsummary-4' =>
"' then 1 else 0 end) as \"'",
'index-projsummary-5' =>
- " from ".TBL_RESOLUTION,
+ " from ".TBL_RESOLUTION.
+ " order by sort_order",
'index-projsummary-6' =>
'%s, count(bug_id) as "Total" '.
'from '.TBL_BUG.' b '.
Index: oci8.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/db/oci8.php,v
retrieving revision 1.23
retrieving revision 1.24
diff -u -r1.23 -r1.24
--- oci8.php 2 Oct 2005 20:50:11 -0000 1.23
+++ oci8.php 18 Oct 2005 18:45:10 -0000 1.24
@@ -440,7 +440,8 @@
'index-projsummary-4' =>
"', 1, 0)) as \"'",
'index-projsummary-5' =>
- "from ".TBL_RESOLUTION." b",
+ "from ".TBL_RESOLUTION." b".
+ " order by b.sort_order",
'index-projsummary-6' =>
"%s, count(bug_id) as \"Total\" ".
'from '.TBL_BUG.' b, '.TBL_PROJECT.' p '.
Index: pgsql.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/db/pgsql.php,v
retrieving revision 1.31
retrieving revision 1.32
diff -u -r1.31 -r1.32
--- pgsql.php 2 Oct 2005 20:50:11 -0000 1.31
+++ pgsql.php 18 Oct 2005 18:45:10 -0000 1.32
@@ -393,7 +393,8 @@
'index-projsummary-4' =>
"' then 1 else 0 end) as \"'",
'index-projsummary-5' =>
- " from ".TBL_RESOLUTION,
+ " from ".TBL_RESOLUTION.
+ " order by sort_order",
'index-projsummary-6' =>
'%s, count(bug_id) as "Total" '.
'from '.TBL_BUG.' b '.
|
