From 62a0de6bc4580e5edec002bc803c06d39442012f Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Tue, 12 Jan 2010 11:45:22 +0000 Subject: [PATCH] Rerun --- admin/fiscalyears.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/admin/fiscalyears.php b/admin/fiscalyears.php index 85792f7..6fd36fc 100644 --- a/admin/fiscalyears.php +++ b/admin/fiscalyears.php @@ -370,7 +370,7 @@ function delete_this_fiscalyear($selected_id) $sql = "DELETE FROM ".TB_PREF."audit_trail WHERE gl_date <= '$to'"; db_query($sql, "Could not delete audit trail"); - $sql = "SELECT type, id FROM ".TB_PREF."comments"; + $sql = "SELECT type, id FROM ".TB_PREF."comments WHERE type != ".ST_SALESQUOTE." AND type != ".ST_SALESORDER." AND type != ".ST_PURCHORDER; $result = db_query($sql, "Could not retrieve comments"); while ($row = db_fetch($result)) { @@ -383,7 +383,7 @@ function delete_this_fiscalyear($selected_id) db_query($sql, "Could not delete comments"); } } - $sql = "SELECT type, id FROM ".TB_PREF."refs"; + $sql = "SELECT type, id FROM ".TB_PREF."refs WHERE type != ".ST_SALESQUOTE." AND type != ".ST_SALESORDER." AND type != ".ST_PURCHORDER; $result = db_query($sql, "Could not retrieve refs"); while ($row = db_fetch($result)) { -- 2.30.2