[Phpbb-checkins] CVS: phpBB2/admin index.php,1.35,1.36

[Paul S. O. <ps...@us...>]

Update of /cvsroot/phpbb/phpBB2/admin
In directory usw-pr-cvs1:/tmp/cvs-serv12254/admin

Modified Files:
	index.php 
Log Message:
Updated MSSQL dbsize query suggested by SirSir

Index: index.php
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/admin/index.php,v
retrieving revision 1.35
retrieving revision 1.36
diff -C2 -r1.35 -r1.36
*** index.php	12 Feb 2002 03:06:17 -0000	1.35
--- index.php	13 Feb 2002 00:03:18 -0000	1.36
***************
*** 272,280 ****
  	else if( preg_match("/^mssql/", SQL_LAYER) )
  	{
! 		$sql = "SELECT ( SELECT SUM(reserved) 
! 				FROM sysindexes where indid in(0,1,255)) 
! 			* low AS dbsize 
! 			FROM master.dbo.spt_values 
! 			WHERE number = 1 AND type = 'E'"; 
  		if( $result = $db->sql_query($sql) )
  		{
--- 272,277 ----
  	else if( preg_match("/^mssql/", SQL_LAYER) )
  	{
! 		$sql = "SELECT ((SUM(size) * 8) * 1024) as dbsize 
! 			FROM sysfiles"; 
  		if( $result = $db->sql_query($sql) )
  		{