From ddfbbd8dbad65a439dfcd25b8fc4e23459c56b1c Mon Sep 17 00:00:00 2001
From: LEVEILLE Cédric <leveille.cedric@oricom.org>
Date: Tue, 19 Jan 2016 13:36:10 -0500
Subject: [PATCH] update sql file for ftp_stats

---
 interface/web/admin/remote_action_osupdate.php |   11 ++---------
 1 files changed, 2 insertions(+), 9 deletions(-)

diff --git a/interface/web/admin/remote_action_osupdate.php b/interface/web/admin/remote_action_osupdate.php
index 0d42308..5e73cdf 100644
--- a/interface/web/admin/remote_action_osupdate.php
+++ b/interface/web/admin/remote_action_osupdate.php
@@ -80,15 +80,8 @@
 	}
 	foreach ($servers as $serverId) {
 		$sql = "INSERT INTO sys_remoteaction (server_id, tstamp, action_type, action_param, action_state, response) " .
-			"VALUES (".
-			$app->functions->intval($serverId) . ", " .
-			time() . ", " .
-			"'os_update', " .
-			"'', " .
-			"'pending', " .
-			"''" .
-			")";
-		$app->db->query($sql);
+			"VALUES (?, UNIX_TIMESTAMP(), 'os_update', '', 'pending', '')";
+		$app->db->query($sql, $serverId);
 	}
 	$msg = $wb['action_scheduled'];
 }

--
Gitblit v1.9.1