- rewrite of sql queries to new form

Marius Cramer

2015-04-07 cc7a82756b4f4d7ab18e928527c37489adbaf564

 interface/lib/plugins/mail_user_filter_plugin.inc.php

@@ -61,7 +61,7 @@
   function mail_user_filter_edit($event_name, $page_form) {
      global $app, $conf;

      $mailuser = $app->db->queryOneRecord("SELECT custom_mailfilter FROM mail_user WHERE mailuser_id = ".$page_form->dataRecord["mailuser_id"]);
      $mailuser = $app->db->queryOneRecord("SELECT custom_mailfilter FROM mail_user WHERE mailuser_id = ?", $page_form->dataRecord["mailuser_id"]);
      $skip = false;
      $lines = explode("\n", $mailuser['custom_mailfilter']);
      $out = '';
@@ -95,7 +95,7 @@
   function mail_user_filter_del($event_name, $page_form) {
      global $app, $conf;

      $mailuser = $app->db->queryOneRecord("SELECT custom_mailfilter FROM mail_user WHERE mailuser_id = ".$page_form->dataRecord["mailuser_id"]);
      $mailuser = $app->db->queryOneRecord("SELECT custom_mailfilter FROM mail_user WHERE mailuser_id = ?", $page_form->dataRecord["mailuser_id"]);
      $skip = false;
      $lines = explode("\n", $mailuser['custom_mailfilter']);
      $out = '';
@@ -124,7 +124,7 @@
      global $app, $conf;

      $app->uses("getconf");
      $mailuser_rec = $app->db->queryOneRecord("SELECT server_id FROM mail_user WHERE mailuser_id = ".$app->functions->intval($page_form->dataRecord["mailuser_id"]));
      $mailuser_rec = $app->db->queryOneRecord("SELECT server_id FROM mail_user WHERE mailuser_id = ?", $page_form->dataRecord["mailuser_id"]);
      $mail_config = $app->getconf->get_server_config($app->functions->intval($mailuser_rec["server_id"]), 'mail');

      if($mail_config['mail_filter_syntax'] == 'sieve') {