From 9893e01f6de6b225bbc84bff49ec673164035892 Mon Sep 17 00:00:00 2001 From: Marius Cramer <m.cramer@pixcept.de> Date: Mon, 03 Feb 2014 14:11:26 -0500 Subject: [PATCH] Merge remote-tracking branch 'origin/stable-3.0.5' --- interface/web/tools/resync.php | 45 +++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 45 insertions(+), 0 deletions(-) diff --git a/interface/web/tools/resync.php b/interface/web/tools/resync.php index ad716f7..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'"; @@ -142,6 +152,16 @@ foreach($records as $rec) { $app->db->datalogUpdate($db_table, $rec, $index_field, $rec[$index_field], true); $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 />'; } } } @@ -183,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