$query = "insert into subs(subID,sequence,authorID,version,original,locked,in_date,start_time,start_time_fraction,end_time,end_time_fraction,text,lang_id,edited_seq,last,estart_time,estart_time_fraction,eend_time,eend_time_fraction, fversion) ";
$query .= "values({$id},{$seq},{$authorID},0,0,0,NOW(),'{$old_start_time}',{$old_start_time_fraction},'{$old_end_time}',{$old_end_time_fraction},'{$mytext}',{$langto},{$seq},1,'{$old_start_time}',{$old_start_time_fraction},'{$old_end_time}',{$old_end_time_fraction},{$fversion})";
mysql_query($query);
//update flangs
$myoriginalLast = bd_langVersion0Count($id, $langfrom, $fversion);
$mylangLast = bd_langVersion0Count($id, $langto, $fversion);
$percent = $mylangLast / $myoriginalLast * 100;
$percent = number_format($percent, 2);
$query = "update flangs set state={$percent},totalseq=totalseq + 1,totalVersion0 = totalVersion0 + 1 where subID={$id} and fversion={$fversion} and lang_id={$langto}";
mysql_query($query);
//borrar de translating
$query = "delete from translating where subID={$id} and fversion={$fversion} and lang_id={$langto} and sequence={$seq}";
mysql_query($query);
$state = bd_getLangState($id, $langto, $fversion);
if ($state == "{$wikilang_completed}") {
tn_start($id, $fversion, $langfrom, $langto);
}
echo '<font color="blue">' . nl2br(stripslashes($text)) . '</font>';
} else {
$query = "select version,sequence,start_time,start_time_fraction,end_time,end_time_fraction,estart_time,estart_time_fraction,eend_time,eend_time_fraction from subs where subID={$id} and lang_id={$langto} and fversion={$fversion} and edited_seq={$seq} order by version DESC limit 1";
$result = mysql_query($query);
$myversion = intval(mysql_result($result, 0, 0));
$original_seq = mysql_result($result, 0, 1);
$start_time = mysql_result($result, 0, 2);
$start_time_fraction = mysql_result($result, 0, 3);
$end_time = mysql_result($result, 0, 4);
$end_time_fraction = mysql_result($result, 0, 5);
$estart_time = mysql_result($result, 0, 6);
$estart_time_fraction = mysql_result($result, 0, 7);
$eend_time = mysql_result($result, 0, 8);
$eend_time_fraction = mysql_result($result, 0, 9);
function tn_super_test($subID, $fversion, $lang)
{
$original = bd_getOriginalLang($subID, $fversion);
tn_check($subID, $fversion, $original, $lang);
tn_start($subID, $fversion, $original, $lang);
//tn_check($subID, $fversion, $original, $lang);
}
