Index: admin/database.php =================================================================== --- admin/database.php (revision 9976) +++ admin/database.php (working copy) @@ -927,6 +927,7 @@ //Determine ids by evaluating the hidden field $rows=array(); $codes=array(); + $oldcodes=array(); foreach ($_POST as $postkey=>$postvalue) { $postkey=explode('_',$postkey); @@ -938,6 +939,10 @@ { $codes[$postkey[2]][]=$postvalue; } + if ($postkey[0]=='oldcode') + { + $oldcodes[$postkey[2]][]=$postvalue; + } } $count=0; $invalidCode = 0; @@ -972,6 +977,12 @@ { $query='Update '.db_table_name('questions').' set question_order='.($position+1).', title='.db_quoteall($codes[$scale_id][$position]).', question='.db_quoteall($subquestionvalue).', scale_id='.$scale_id.' where qid='.db_quoteall($subquestionkey).' AND language='.db_quoteall($language); $connect->execute($query); + + if($codes[$scale_id][$position] !== $oldcodes[$scale_id][$position]) { + $query='UPDATE '.db_table_name('conditions').' SET cfieldname="+'.$surveyid.'X'.$gid.'X'.$qid.db_quote($codes[$scale_id][$position]).'" WHERE cfieldname="+'.$surveyid.'X'.$gid.'X'.$qid.db_quote($oldcodes[$scale_id][$position]).'"'; + $connect->execute($query); + } + } else { Index: admin/editsubquestions.php =================================================================== --- admin/editsubquestions.php (revision 9976) +++ admin/editsubquestions.php (working copy) @@ -195,7 +195,7 @@ } elseif ($activated != 'Y' && $first) // If survey is decactivated { - $vasummary .= "";