function dofixParentClname()
{
$var = parse_sql_data();
foreach ($var as $table => $content) {
$__db = new Sqlite(null, $table);
if ($table === 'ticket') {
$list = array("parent_clname", "made_by", "sent_to");
} else {
if ($table === 'smessage') {
$list = array("parent_clname", "made_by");
} else {
if ($table === 'kloxolicense') {
$list = array("parent_clname", "created_by");
} else {
if ($table === 'hypervmlicense') {
$list = array("parent_clname", "created_by");
} else {
$list = array("parent_clname");
}
}
}
}
$get = lx_array_merge(array(array('nname'), $list));
$res = $__db->getTable($get);
if (!$res) {
continue;
}
foreach ($res as $r) {
foreach ($list as $l) {
$v = fix_getParentNameAndClass($r[$l]);
if (!$v) {
continue;
}
list($parentclass, $parentname) = $v;
$npcl = "{$parentclass}-{$parentname}";
$__db->rawQuery("update {$table} set {$l} = '{$npcl}' where nname = '{$r['nname']}'");
}
$spl = array('notification', 'serverweb', 'lxbackup', 'phpini');
if (csb($table, "sp_") || array_search_bool($table, $spl)) {
$v = fix_getParentNameAndClass($r['nname']);
if (!$v) {
continue;
}
list($parentclass, $parentname) = $v;
$npcl = "{$parentclass}-{$parentname}";
$__db->rawQuery("update {$table} set nname = '{$npcl}' where nname = '{$r['nname']}'");
}
}
}
}
function fixIndividualParentName()
{
$plist = array('notification', 'serverweb', 'lxbackup');
if (csb($this->getClass(), "sp_") || array_search_bool($this->getClass(), $plist)) {
$v = fix_getParentNameAndClass($this->nname);
if ($v) {
list($pcl, $pcn) = $v;
$this->nname = "{$pcl}-{$pcn}";
}
}
$v = fix_getParentNameAndClass($this->parent_clname);
if ($v) {
list($pcl, $pcn) = $v;
$this->parent_clname = "{$pcl}-{$pcn}";
}
}
