aboutsummaryrefslogtreecommitdiffstats
path: root/config/postfix/postfix.widget.php
diff options
context:
space:
mode:
authormarcelloc <marcellocoutinho@gmail.com>2011-12-01 13:36:59 -0200
committermarcelloc <marcellocoutinho@gmail.com>2011-12-01 13:36:59 -0200
commit1536d3590d52e56a67f3443df9aa3dfe378c3c18 (patch)
tree5cb97c85f5e752f00be45f9d2a78c7a6a6df0782 /config/postfix/postfix.widget.php
parentd4c84dfdbad19306d1ef2827fcb4fc436b908106 (diff)
downloadpfsense-packages-1536d3590d52e56a67f3443df9aa3dfe378c3c18.tar.gz
pfsense-packages-1536d3590d52e56a67f3443df9aa3dfe378c3c18.tar.bz2
pfsense-packages-1536d3590d52e56a67f3443df9aa3dfe378c3c18.zip
postfix - package version 2.3
Diffstat (limited to 'config/postfix/postfix.widget.php')
-rwxr-xr-xconfig/postfix/postfix.widget.php75
1 files changed, 46 insertions, 29 deletions
diff --git a/config/postfix/postfix.widget.php b/config/postfix/postfix.widget.php
index dd43afa4..4c0c2b45 100755
--- a/config/postfix/postfix.widget.php
+++ b/config/postfix/postfix.widget.php
@@ -45,10 +45,22 @@ $img['Healthy']="<img src ='/themes/{$g['theme']}/images/icons/icon_interface_up
#var_dump($pfb_table);
#exit;
?><div id='postfix'><?php
+global $config;
+
+$size=$config['installedpackages']['postfix']['config'][0]['widget_size'];
+if (preg_match('/\d+/',$config['installedpackages']['postfix']['config'][0]['widget_days']))
+ $days=$config['installedpackages']['postfix']['config'][0]['widget_days'] * -1;
+else
+ $days=-3;
+if (preg_match('/\d+/',$config['installedpackages']['postfix']['config'][0]['widget_size']))
+ $size=$config['installedpackages']['postfix']['config'][0]['widget_size'];
+else
+ $size='100000000';#100mb
+
$postfix_dir="/var/db/postfix/";
$curr_time = time();
-for ($z = 0; $z > -3; $z--){
+for ($z = 0; $z > $days; $z--){
if ($z==0)
$postfix_db=date("Y-m-d");
@@ -56,39 +68,45 @@ else
$postfix_db=date("Y-m-d",strtotime("$z day",$curr_time));
if (file_exists($postfix_dir.'/'.$postfix_db.".db")){
- $dbhandle = sqlite_open($postfix_dir.'/'.$postfix_db.".db", 0666, $error);
#noqueue
open_table();
print "<td class=\"vncellt\"><strong><center>$postfix_db</center></strong></td>";
close_table();
open_table();
- $stm="select count(*) as total from mail_noqueue";
- $result = sqlite_query($dbhandle, $stm);
- $row_noqueue = sqlite_fetch_array($result, SQLITE_ASSOC);
-
- #queue
- $result = sqlite_query($dbhandle, $stm);
- $stm="select status,count(*) as total from mail_queue group by status order by status";
- $result = sqlite_query($dbhandle, $stm);
- $reader="";
- $count="";
- for ($i = 1; $i <= 15; $i++) {
- $row = sqlite_fetch_array($result, SQLITE_ASSOC);
- if (is_array($row)){
- if (preg_match("/\w+/",$row['status'])){
- $reader.="<td class=\"listlr\"width=50%><strong>".ucfirst($row['status'])."</strong></td>\n";
- if ($row['status']=="reject")
- $row['total']=+$row_noqueue['total'];
- $count.="<td class=\"listlr\">".$row['total']."</td>\n";
- }
- }
- }
- print "<tr>".$reader."</tr>";
- print "<tr>".$count."</tr>";
+ if (@filesize($postfix_dir.'/'.$postfix_db.".db")< $size){
+ $dbhandle = sqlite_open($postfix_dir.'/'.$postfix_db.".db", 0666, $error);
+ $stm="select count(*) as total from mail_noqueue";
+ $result = sqlite_query($dbhandle, $stm);
+ $row_noqueue = sqlite_fetch_array($result, SQLITE_ASSOC);
+
+ #queue
+ $result = sqlite_query($dbhandle, $stm);
+ $stm="select mail_status.info as status,count(*) as total from mail_to,mail_status where mail_to.status=mail_status.id group by status order by mail_status.info";
+ $result = sqlite_query($dbhandle, $stm);
+ $reader="";
+ $count="";
+ for ($i = 1; $i <= 15; $i++) {
+ $row = sqlite_fetch_array($result, SQLITE_ASSOC);
+ if (is_array($row)){
+ if (preg_match("/\w+/",$row['status'])){
+ $reader.="<td class=\"listlr\"width=50%><strong>".ucfirst($row['status'])."</strong></td>\n";
+ if ($row['status']=="reject")
+ $row['total']=+$row_noqueue['total'];
+ $count.="<td class=\"listlr\">".$row['total']."</td>\n";
+ }
+ }
+ }
+ print "<tr>".$reader."</tr>";
+ print "<tr>".$count."</tr>";
+ $result = sqlite_query($dbhandle, $stm);
+ sqlite_close($dbhandle);
+ }
+ else{
+ print "<td class=\"listlr\"width=100%><center>File size is too large.</center></td>";
+ }
close_table();
echo "<br>";
- $result = sqlite_query($dbhandle, $stm);
- sqlite_close($dbhandle);
+
}
}
echo" </tr>";
@@ -107,11 +125,10 @@ echo"</table></div>";
parameters: pars,
onComplete: activitycallback_postfix
});
- //I know it's ugly but works.
- setTimeout('getstatus_postfix()', 60000);
}
function activitycallback_postfix(transport) {
$('postfix').innerHTML = transport.responseText;
+ setTimeout('getstatus_postfix()', 60000);
}
getstatus_postfix();
</script>