if (!$ds->query($query)) { CAppUI::setMsg("Erreur lors de la remise à zéro des champs booléens (" . $ds->error() . ")", UI_MSG_WARNING); } else { CAppUI::setMsg($ds->affectedRows() . " champs mis à jour", UI_MSG_OK); } $query = "\r\n UPDATE `ex_concept`\r\n SET\r\n `prop` = REPLACE(`prop`, ' default|0', ''),\r\n `prop` = REPLACE(`prop`, ' default|1', ''),\r\n `prop` = REPLACE(`prop`, ' default|', '')\r\n WHERE `prop` LIKE 'bool %';"; if (!$ds->query($query)) { CAppUI::setMsg("Erreur lors de la remise à zéro des concepts booléens (" . $ds->error() . ")", UI_MSG_WARNING); } else { CAppUI::setMsg($ds->affectedRows() . " concepts mis à jour", UI_MSG_OK); } break; case "str_to_text": $where = array("prop" => "LIKE 'str%'"); $concept = new CExConcept(); $str_concepts = $concept->loadList($where); foreach ($str_concepts as $_concept) { $_concept->prop = preg_replace("/^(str)/", "text", $_concept->prop); if ($msg = $_concept->store()) { CAppUI::setMsg($msg, UI_MSG_WARNING); } else { CAppUI::setMsg("Concept modifié", UI_MSG_OK); } } if (count($str_concepts) == 0) { CAppUI::setMsg("Aucun concept modifié", UI_MSG_OK); } $ex_field = new CExClassField(); $str_fields = $ex_field->loadList($where); foreach ($str_fields as $_field) { $_field->prop = preg_replace("/^(str)/", "text", $_field->prop);