Changeset 211

Timestamp:

09/20/07 23:46:36 (16 months ago)

Author:

tgenannt

Message:

- Fixed: domain size display in overview

Location:

trunk

Files:

• ChangeLog (modified) (1 diff)
• includes/sites/main.php (modified) (1 diff)

trunk/ChangeLog

@@ -11 +11 @@
         o Fixed: mailgraph link is not working
         o Fixed: sa_learn.pl bogofilter check
+        o Fixed: domain size display in overview
 CpVES 0.09 2007-09-15 - Jonas Genannt - <jonas.genannt@brachium-system.net>
         o Improved: runScripts.sh create_fetchmail.pl should not run on trigger

trunk/includes/sites/main.php

@@ -74 +74 @@
         }
         //display size of all mailboxes
-        $sql=sprintf("SELECT SUM( mb_size ) AS sum FROM `users`WHERE domainid='%d'",
+        $sql=sprintf("SELECT SUM( mb_size ) AS sum FROM users WHERE domainid = %d",
                 $db->escapeSimple($row['id']));
         $res_mb_size=&$db->query($sql);
         $data_mb_size=$res_mb_size->fetchrow(DB_FETCHMODE_ASSOC);
+        if( empty($data_mb_size['sum']) ) $data_mb_size['sum'] = 0;
         array_push($table_data, array(
          'dnsname' => $row['dnsname'],