include 'translate_fns.php';
$id = $_GET['id'];
$fversion = $_GET['fversion'];
$langto = $_GET['langto'];
$langfrom = $_GET['langfrom'];
$seq = $_GET['seq'];
$userID = $_SESSION['userID'];
$query = "select count(*) from translating where subID={$id} and fversion={$fversion} and lang_id={$langto}";
$result = mysql_query($query);
$count = mysql_result($result, 0);
if ($count == 0) {
$query = "select count(*) from testing where subID={$id} and fversion={$fversion} and lang_id={$langto}";
$result = mysql_query($query);
$count = mysql_result($result, 0);
if ($count < 1) {
$total = bd_langVersion0Count($id, $langfrom, $fversion);
tn_check($id, $fversion, $langfrom, $langto);
$cstate = bd_getLangState($id, $langto, $fversion);
echo "This subtitles has been tested.<br />Current state:{$cstate}</b> If it is not completed, please <b>reload</b> this page and fill the gaps.";
if ($cstate == "{$wikilang_completed}") {
$query = "select count(*) from lasttranslated where subID={$id} and fversion={$fversion} and lang_id={$langto}";
$result = mysql_query($query);
$count = mysql_result($result, 0);
if ($count < 1) {
$query = "insert into lasttranslated(subID,fversion,lang_id,date) values({$id},{$fversion},{$langto}, NOW())";
mysql_query($query);
}
}
} else {
echo "Current subtitle is being tested. Please check its state in a few seconds";
}
//leer anterior
$query = "select estart_time,estart_time_fraction,eend_time,eend_time_fraction,sequence,edited_seq from subs where subID={$id} and fversion={$fversion} and edited_seq={$seq} and lang_id={$langfrom} and last=1 limit 1";
$result = mysql_query($query);
$row = mysql_fetch_assoc($result);
$authorID = $_SESSION['userID'];
$old_start_time = $row['estart_time'];
$old_start_time_fraction = $row['estart_time_fraction'];
$old_end_time = $row['eend_time'];
$old_end_time_fraction = $row['eend_time_fraction'];
//inserta el nuevo
$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);
function tn_duplicates($subID, $fversion, $lang)
{
$query = "select distinct(edited_seq) as secuencia from subs where subID={$subID} and fversion={$fversion} and lang_id={$lang}";
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
$secuencia = $row['secuencia'];
$query = "select edited_seq,version,count(*) as cuenta from subs where subID={$subID} and fversion={$fversion} and lang_id={$lang} and edited_seq={$secuencia} group by version";
$sresult = mysql_query($query);
$srow = mysql_fetch_assoc($sresult);
$cuenta = $srow['cuenta'];
$version = $srow['version'];
if ($cuenta > 1) {
$cuenta--;
$query = "delete from subs where subID={$subID} and fversion={$fversion} and lang_id={$lang} and edited_seq={$secuencia} and version={$version} order by entryID DESC limit {$cuenta}";
mysql_query($query);
}
}
$version0 = bd_langVersion0Count($subID, $lang, $fversion);
$query = "update flangs set totalVersion0={$version0} where subID={$subID} and fversion={$fversion} and lang_id={$lang}";
mysql_query($query);
}
