- rewrite of sql queries to new form

Marius Cramer

2015-04-07 cc7a82756b4f4d7ab18e928527c37489adbaf564

 interface/web/mail/mail_user_del.php

@@ -54,10 +54,10 @@
   function onBeforeDelete() {
      global $app; $conf;

      $tmp_user = $app->db->queryOneRecord("SELECT id FROM spamfilter_users WHERE email = '".$app->db->quote($this->dataRecord["email"])."'");
      $tmp_user = $app->db->queryOneRecord("SELECT id FROM spamfilter_users WHERE email = ?", $this->dataRecord["email"]);
      $app->db->datalogDelete('spamfilter_users', 'id', $tmp_user["id"]);

      $tmp_filters = $app->db->queryAllRecords("SELECT filter_id FROM mail_user_filter WHERE mailuser_id = '".$this->id."'");
      $tmp_filters = $app->db->queryAllRecords("SELECT filter_id FROM mail_user_filter WHERE mailuser_id = ?", $this->id);
      if(is_array($tmp_filters)) {
         foreach($tmp_filters as $tmp) {
            $app->db->datalogDelete('mail_user_filter', 'filter_id', $tmp["filter_id"]);