From 009b2dcf6ac4d6dabdb0ccec16319fa2901fbc48 Mon Sep 17 00:00:00 2001
From: Sergio Cambra <sergio@programatica.es>
Date: Tue, 08 Jul 2014 07:54:02 -0400
Subject: [PATCH] check reseller quota on mailbox edit
---
interface/web/tools/resync.php | 59 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 59 insertions(+), 0 deletions(-)
diff --git a/interface/web/tools/resync.php b/interface/web/tools/resync.php
index a02ac9f..4e5f206 100644
--- a/interface/web/tools/resync.php
+++ b/interface/web/tools/resync.php
@@ -106,6 +106,16 @@
//* Resyncing Databases
if(isset($_POST['resync_db']) && $_POST['resync_db'] == 1) {
+ $db_table = 'web_database_user';
+ $index_field = 'database_user_id';
+ $sql = "SELECT * FROM ".$db_table." WHERE 1";
+ $records = $app->db->queryAllRecords($sql);
+ if(is_array($records)) {
+ foreach($records as $rec) {
+ $app->db->datalogUpdate($db_table, $rec, $index_field, $rec[$index_field], true);
+ $msg .= "Resynced Database user: ".$rec['database_user'].'<br />';
+ }
+ }
$db_table = 'web_database';
$index_field = 'database_id';
$sql = "SELECT * FROM ".$db_table." WHERE active = 'y'";
@@ -144,6 +154,30 @@
$msg .= "Resynced Mailbox: ".$rec['email'].'<br />';
}
}
+ $db_table = 'mail_forwarding';
+ $index_field = 'forwarding_id';
+ $sql = "SELECT * FROM ".$db_table;
+ $records = $app->db->queryAllRecords($sql);
+ if(is_array($records)) {
+ foreach($records as $rec) {
+ $app->db->datalogUpdate($db_table, $rec, $index_field, $rec[$index_field], true);
+ $msg .= "Resynced Alias: ".$rec['source'].'<br />';
+ }
+ }
+}
+
+//* Resyncing DKIM-Keys
+if(isset($_POST['resync_dkim']) && $_POST['resync_dkim'] == 1) {
+ $db_table = 'mail_domain';
+ $index_field = 'domain_id';
+ $sql = "SELECT * FROM ".$db_table." WHERE active = 'y' AND dkim = 'y'";
+ $records = $app->db->queryAllRecords($sql);
+ if(is_array($records)) {
+ foreach($records as $rec) {
+ $app->db->datalogUpdate($db_table, $rec, $index_field, $rec[$index_field], true);
+ $msg .= "Resynced DKIM-Key: ".$rec['domain'].'<br />';
+ }
+ }
}
//* Resyncing dns zones
@@ -169,6 +203,31 @@
}
+//* Resyncing Clients
+if(isset($_POST['resync_client']) && $_POST['resync_client'] == 1) {
+ $tform_def_file = "form/client.tform.php";
+ $app->uses('tpl,tform,tform_actions');
+ $app->load('tform_actions');
+
+ $db_table = 'client';
+ $index_field = 'client_id';
+ $sql = "SELECT * FROM ".$db_table;
+ $records = $app->db->queryAllRecords($sql);
+ if(is_array($records)) {
+ foreach($records as $rec) {
+ $app->db->datalogUpdate($db_table, $rec, $index_field, $rec[$index_field], true);
+ $tmp = new tform_actions;
+ $tmp->id = $rec[$index_field];
+ $tmp->dataRecord = $rec;
+ $tmp->oldDataRecord = $rec;
+ $app->plugin->raiseEvent('client:client:on_after_update', $tmp);
+ $msg .= "Resynced Client: ".$rec['contact_name'].'<br />';
+ unset($tmp);
+ }
+ }
+}
+
+
$app->tpl->setVar('msg', $msg);
$app->tpl->setVar('error', $error);
--
Gitblit v1.9.1