mcramer
2013-06-14 c8aacf1e99399d21cd5076cd8912c74f4d51e52f
- 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/

1 files modified
2 ■■■ changed files
interface/web/client/client_template_edit.php 2 ●●● patch | view | raw | blame | history
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)){