db_process_query("select",$btnTbl,"*","none","none","none"); $sRsltSet_btn = $db_CMS->dbRsltSet; while($sCurRow_btn=$db_CMS->db_fetch_array($sRsltSet_btn)) $grp_access[$sCurRow_btn["item"]] = ""; // generate group-listings for each menuitem & save listing to the db while (list($key, $val) = each($vars_array)) { // forget about $val, its not necessary (and empty anyway) list($btn_fld,$grp) = split(':',$key); // Query groups database for grpID according to $grp... $db_CMS->db_process_query("select",$grpTbl,"*","none","grpname=\"$grp\"","none"); $sRsltSet_grp = $db_CMS->dbRsltSet; $sCurRow_grp=$db_CMS->db_fetch_array($sRsltSet_grp); if($grp_access[$btn_fld] == "") $grp_access[$btn_fld]=$sCurRow_grp["grpID"]; else $grp_access[$btn_fld] .= ",".$sCurRow_grp["grpID"]; } while(list($item) = each($grp_access)) $db_CMS->db_process_query("update",$btnTbl,"grp_access_code","=\"$grp_access[$item]\"","item=\"$item\"","none"); print("Saved changes.
"); ?>