From c8aacf1e99399d21cd5076cd8912c74f4d51e52f Mon Sep 17 00:00:00 2001
From: mcramer <m.cramer@pixcept.de>
Date: Fri, 14 Jun 2013 03:56:56 -0400
Subject: [PATCH] - Fixed: changing a client template might not update all clients using this template client additional_template column might contain something like 15/20/211 instead of /15/20/211/
---
interface/web/client/client_template_edit.php | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/interface/web/client/client_template_edit.php b/interface/web/client/client_template_edit.php
index 35f0c2d..a683800 100644
--- a/interface/web/client/client_template_edit.php
+++ b/interface/web/client/client_template_edit.php
@@ -81,7 +81,7 @@
if ($this->dataRecord["template_type"] == 'm'){
$sql = "SELECT client_id FROM client WHERE template_master = " . $this->id;
} else {
- $sql = "SELECT client_id FROM client WHERE template_additional LIKE '%/" . $this->id . "/%'";
+ $sql = "SELECT client_id FROM client WHERE template_additional LIKE '%/" . $this->id . "/%' OR template_additional LIKE '" . $this->id . "/%' OR template_additional LIKE '%/" . $this->id . "'";
}
$clients = $app->db->queryAllRecords($sql);
if (is_array($clients)){
--
Gitblit v1.9.1