diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2002-02-13 00:03:18 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2002-02-13 00:03:18 +0000 |
| commit | 6cecda3ea7176b30a7d646d01ef29855267a588c (patch) | |
| tree | 92ad1e94d4e998af761b756ff133ca21a5da702f /phpBB/admin/index.php | |
| parent | bd60a4e7f4c3b038bae20aedd194d07cddc5caf4 (diff) | |
| download | forums-6cecda3ea7176b30a7d646d01ef29855267a588c.tar forums-6cecda3ea7176b30a7d646d01ef29855267a588c.tar.gz forums-6cecda3ea7176b30a7d646d01ef29855267a588c.tar.bz2 forums-6cecda3ea7176b30a7d646d01ef29855267a588c.tar.xz forums-6cecda3ea7176b30a7d646d01ef29855267a588c.zip | |
Updated MSSQL dbsize query suggested by SirSir
git-svn-id: file:///svn/phpbb/trunk@2120 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/admin/index.php')
| -rw-r--r-- | phpBB/admin/index.php | 7 |
1 files changed, 2 insertions, 5 deletions
diff --git a/phpBB/admin/index.php b/phpBB/admin/index.php index f02802db1e..aba2f3f06c 100644 --- a/phpBB/admin/index.php +++ b/phpBB/admin/index.php @@ -271,11 +271,8 @@ elseif( isset($HTTP_GET_VARS['pane']) && $HTTP_GET_VARS['pane'] == 'right' ) } 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'"; + $sql = "SELECT ((SUM(size) * 8) * 1024) as dbsize + FROM sysfiles"; if( $result = $db->sql_query($sql) ) { $dbsize = ( $row = $db->sql_fetchrow($result) ) ? intval($row['dbsize']) : $lang['Not_available']; |