From aa365c418c88ad97ed0e9f0ffa4405fcda717715 Mon Sep 17 00:00:00 2001
From: root <root@angantyr.pwhost.de>
Date: Thu, 19 Nov 2015 17:17:13 -0500
Subject: [PATCH] fixed sql-syntax
---
interface/lib/classes/plugin_backuplist_mail.inc.php | 13 +++----------
1 files changed, 3 insertions(+), 10 deletions(-)
diff --git a/interface/lib/classes/plugin_backuplist_mail.inc.php b/interface/lib/classes/plugin_backuplist_mail.inc.php
index 91e7ee1..2c3e7a3 100644
--- a/interface/lib/classes/plugin_backuplist_mail.inc.php
+++ b/interface/lib/classes/plugin_backuplist_mail.inc.php
@@ -62,7 +62,7 @@
if($tmp['number'] == 0) {
$message .= $wb['restore_info_txt'];
$sql = "INSERT INTO sys_remoteaction (server_id, tstamp, action_type, action_param, action_state, response) " .
- "VALUES (?, ? 'backup_restore_mail', ?, 'pending','')";
+ "VALUES (?, ?, 'backup_restore_mail', ?, 'pending','')";
$app->db->query($sql, $this->form->dataRecord['server_id'], time(), $backup_id);
} else {
$error .= $wb['restore_pending_txt'];
@@ -75,15 +75,8 @@
if($tmp['number'] == 0) {
$message .= $wb['delete_info_txt'];
$sql = "INSERT INTO sys_remoteaction (server_id, tstamp, action_type, action_param, action_state, response) " .
- "VALUES (".
- (int)$this->form->dataRecord['server_id'] . ", " .
- time() . ", " .
- "'backup_delete_mail', " .
- "'".$backup_id."', " .
- "'pending', " .
- "''" .
- ")";
- $app->db->query($sql);
+ "VALUES (?, ?, 'backup_delete_mail, ?, 'pending', '')";
+ $app->db->query($sql, $this->form->dataRecord['server_id'], time(), $backup_id);
} else {
$error .= $wb['delete_pending_txt'];
}
--
Gitblit v1.9.1