[phpBT-dev] CVS: phpbt/inc/db mssql.php,1.7,1.8 mysql.php,1.30,1.31 mysqli.php,1.4,1.5 oci8.php,1.23,1.24 pgsql.php,1.31,1.32

[Ulf E. <ulf...@us...>]

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 '.