· <?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) {