select(); foreach ($sceneList as $sv){ $groupSet = json_decode($sv["group_set"], true); if(count($groupSet) == 0) continue; $isUp = false; foreach ($groupSet as &$gv){ if(isset($gv["color_mode"])) continue; $isUp = true; $gv["color_x"] = 1; $gv["color_y"] = 1; $gv["color_mode"] = 1; $gv["color_fine"] = 0; } if($isUp) sqlite("scenes")->where(["id"=>$sv["id"]])->update(["group_set"=>json_encode($groupSet)]); } $zoneList = sqlite("zones")->where(["days"=>"null"])->select(); foreach ($zoneList as $zv){ sqlite("zones")->where(["id"=>$zv["id"]])->update(["days"=>""]); }