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); }