·
<?php
echo "{$wikilang_uplodaded_by} <a href='/user/" . $linkrow['author'] . "'>" . bd_getUsername($linkrow['author']) . '</a>';
?>
<?php
echo $linkrow['downloads'] . " {$wikilang_downloads} ";
if (bd_userIsModerador()) {
echo "<a href='/dellink.php?linkid=" . $linkrow['linkID'] . "'>" . 'Delete</a>';
}
$query = "select distinct(lang_id) from flangs where subID={$myID} and fversion={$v}";
$lresult = mysql_query($query);
while ($llrow = mysql_fetch_assoc($lresult)) {
$llid = $llrow['lang_id'];
$llname = bd_getLangName($llid);
$llstate = bd_getLangState($myID, $llid, $v);
?>
<?php
echo $llname;
echo '<a href="' . $SCRIPT_PATH . 'downloadlink.php?linkID=' . $linkrow['linkID'] . '&lang=' . $llid . '">';
echo $wikilang_download;
?>
</a>
</td>
</tr>
<?php
}
//linklang
?>
<?php
$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);
$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);
<body>
<?php
include 'header.php';
?>
<table width="90%" border="0" align="center">
<?php
$query = "select distinct (subID),lang_id,fversion from translating";
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
$subID = $row['subID'];
$lang = $row['lang_id'];
$lang_name = bd_getLangName($lang);
$fversion = $row['fversion'];
$state = bd_getLangState($subID, $lang, $fversion);
$title = bd_getTitle($subID);
if ($state == "0.00% {$wikilang_completed}" || $state == "{$wikilang_completed}") {
$query = "delete from translating where subID={$subID} and fversion={$fversion} and lang_id={$lang}";
mysql_query($query);
}
if ($state == "0.00% completed") {
$query = "delete from flangs where subID={$subID} and fversion={$fversion} and lang_id={$lang}";
mysql_query($query);
}
if ($state == "% completed") {
$query = "delete from translating where subID={$subID} and fversion={$fversion} and lang_id={$lang}";
mysql_query($query);
}
echo '<tr>';
$url = bd_getUrl($subID);
function bd_confirmTranslated($id, $fversion, $lang)
{
include_once 'languages.php';
$state = bd_getLangState($id, $fversion, $lang);
if ($state != my_completed) {
$query = "delete from lasttranslated where subID={$id} and fversion={$fversion} and lang_id={$lang}";
mysql_query($query);
}
}
function last_translated($subID, $fversion, $lang)
{
include_once 'includes/languages.php';
$query = "select count(*) from lasttranslated where subID={$subID} and fversion={$fversion} and lang_id={$lang}";
$result = mysql_query($query);
$cuenta = mysql_result($result, 0);
if ($cuenta > 0) {
$state = bd_getLangState($subID, $lang, $fversion);
if ($state != my_completed) {
$query = "delete from lasttranslated where subID={$subID} and fversion={$fversion} and lang_id={$lang}";
mysql_query($query);
}
}
}
}
}
for ($contav = 0; $contav < $nversions; $contav++) {
$v = $version[$contav]['num'];
//*************** languages
$query = "SELECT DISTINCT lang_id from flangs where subID={$myID} and fversion={$v} order by entryID";
//echo $query;
$result = mysql_query($query);
$numlanguages = mysql_affected_rows();
$version[$v]['numlanguages'] = $numlanguages;
for ($c = 0; $c < $numlanguages; $c++) {
$row = mysql_fetch_assoc($result);
$currentLangID = $row['lang_id'];
$langs[$v][$c][0] = $currentLangID;
$langs[$v][$c][1] = bd_getLangName($currentLangID);
$langs[$v][$c][2] = bd_getLangState($myID, $currentLangID, $v);
$langs[$v][$c][3] = bd_countLinesEditedByLang($myID, $currentLangID, $v);
$query = "select count(*) from downloads where subID={$myID} and fversion={$v} and lang={$currentLangID}";
$dresult = mysql_query($query);
$langs[$v][$c][4] = mysql_result($dresult, 0);
}
//********************************
}
$query = "select count(*) from subs where subID={$myID} and version>0";
$result = mysql_query($query);
$nummod = mysql_result($result, 0);
$candel = $nummod < 1 && $nversion == 1;
}
$meID = $_SESSION['userID'];
if (isset($meID)) {
$me = bd_getUsername($meID);
$lang = $lrow['lang_id'];
$langName = bd_getLangName($lang);
?>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td width="4%"><img src="/images/invisible.gif" width="18" height="11" /></td>
<td width="41%" class="language">
<?php
echo $langName;
?>
</td>
<td width="17%">
<?php
echo bd_getLangState($epID, $lang, $cfversion);
?>
</td>
<td><img src="/images/download.png" width=16" height="16" />
<?php
echo '<a href="/updated/' . $lang . '/' . $epID . '/' . $cfversion . '">' . $wikilang_download;
?>
</a>
</td>
</tr>
<?php
}
$query = "select linkID,versionDesc,versionSize from links where subID={$epID} and fversion={$cfversion}";
$mresult = mysql_query($query);
$lnum = mysql_affected_rows();
if ($lnum > 0) {
