function bd_clear_ALLFlangs()
{
$query = "select distinct(subID) from flangs";
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
$id = $row['subID'];
bd_clear_flang($id);
}
}
function tn_check($subID, $fversion, $originalLangID, $targetLangID)
{
bd_clear_flang($subID);
cleanTranslated();
last_translated($subID, $fversion, $targetLangID);
$query = "select edited_seq from subs where subID={$subID} and fversion={$fversion} and lang_id={$originalLangID} and last=1 order by edited_seq";
$tresult = mysql_query($query);
$numresults = mysql_affected_rows();
while ($row = mysql_fetch_assoc($tresult)) {
$c = $row['edited_seq'];
$contadores[$c] = 0;
}
$query = "select edited_seq from subs where subID={$subID} and fversion={$fversion} and lang_id={$targetLangID} and last=1 order by edited_seq";
$uresult = mysql_query($query);
$unumresults = mysql_affected_rows();
while ($row = mysql_fetch_assoc($uresult)) {
$c = $row['edited_seq'];
$contadores[$c]++;
}
mysql_data_seek($tresult, 0);
$counter = 0;
while ($row = mysql_fetch_assoc($tresult)) {
$c = $row['edited_seq'];
$count = $contadores[$c];
$counter++;
if ($count < 1) {
$query = "select count(*) from translating where subID={$subID} and fversion={$fversion} and lang_id={$targetLangID} and sequence={$c}";
$result = mysql_query($query);
$ccount = mysql_result($result, 0);
if ($ccount < 1) {
$query = "insert into translating(subID,fversion,lang_id,sequence) values({$subID},{$fversion},{$targetLangID},{$c})";
mysql_query($query);
}
} elseif ($count > 1) {
$mycount = $count - 1;
$query = "delete from subs where subID={$subID} and lang_id={$targetLangID} and fversion={$fversion} and edited_seq={$c} and last=1 order by entryID limit {$mycount}";
mysql_query($query);
} elseif ($count == 1) {
$query = "delete from translating where subID={$subID} and lang_id={$targetLangID} and fversion={$fversion} and sequence={$c}";
mysql_query($query);
}
}
//cuenta de lineas manual
$query = "select count(*) from subs where subID={$subID} and fversion={$fversion} and lang_id={$targetLangID} and last=1";
$result = mysql_query($query);
$l0count = mysql_result($result, 0);
$query = "select count(*) from subs where subID={$subID} and fversion={$fversion} and lang_id={$targetLangID}";
$result = mysql_query($query);
$lcount = mysql_result($result, 0);
$query = "update flangs set totalseq={$lcount},totalVersion0={$l0count} where subID={$subID} and fversion={$fversion} and lang_id={$targetLangID}";
mysql_query($query);
//manual get lang State
$moriginal = bd_langVersion0Count($subID, $originalLangID, $fversion);
$new = bd_langVersion0Count($subID, $targetLangID, $fversion);
$percent = number_format($new / $moriginal * 100, 2);
$query = "update flangs set state={$percent} where subID={$subID} and fversion={$fversion} and lang_id={$targetLangID}";
mysql_query($query);
$state = bd_getLangState($subID, $targetLangID, $fversion);
if ($state == my_completed) {
//borra comentarios de traduccion
$query = "delete from translating where subID={$subID} and lang_id={$targetLangID} fversion={$fversion}";
mysql_query($query);
$query = "select count(*) from lasttranslated where subID={$subID} and fversion={$fversion} and lang_id={$targetLangID}";
$result = mysql_query($query);
if (mysql_result($result, 0) < 1) {
$query = "insert into lasttranslated(subID,fversion,lang_id,date) values({$subID}, {$fversion}, {$targetLangID}, NOW())";
mysql_query($query);
}
}
cleanTranslated();
last_translated($subID, $fversion, $targetLangID);
}
