From a99d28dea939abc7eb9fbfcfcc966c40215a94b6 Mon Sep 17 00:00:00 2001 From: redmatrix Date: Fri, 18 Dec 2015 13:46:03 -0800 Subject: sql delete with limit --- include/deliver.php | 2 +- include/zot.php | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) (limited to 'include') diff --git a/include/deliver.php b/include/deliver.php index 60d935d02..7ff0fa125 100644 --- a/include/deliver.php +++ b/include/deliver.php @@ -66,7 +66,7 @@ function deliver_run($argv, $argc) { } } - q("delete from dreport where dreport_queue = '%s' limit 1", + q("delete from dreport where dreport_queue = '%s'", dbesc($argv[$x]) ); } diff --git a/include/zot.php b/include/zot.php index ce3bef783..922637bc1 100644 --- a/include/zot.php +++ b/include/zot.php @@ -1000,7 +1000,7 @@ function zot_process_response($hub, $arr, $outq) { // we have a more descriptive delivery report, so discard the per hub 'queued' report. - q("delete from dreport where dreport_queue = '%s' limit 1", + q("delete from dreport where dreport_queue = '%s' ", dbesc($outq['outq_hash']) ); -- cgit v1.2.3