?>
·
<?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
?>
exit;
}
$id = $_GET['id'];
$fversion = $_GET['fversion'];
$lang = $_GET['lang'];
$query = "delete from flangs where subID={$id} and fversion={$fversion} and lang_id={$lang}";
mysql_query($query);
$query = "delete from subs where subID={$id} and fversion={$fversion} and lang_id={$lang}";
mysql_query($query);
$query = "select count(*) from flangs where subID={$id} and fversion={$fversion}";
$result = mysql_query($query);
if (mysql_result($result, 0) < 1) {
$query = "delete from fversions where subID={$id} and fversion={$fversion}";
mysql_query($query);
$query = "delete from translating where subID={$id} and fversion={$fversion}";
mysql_query($query);
$query = "select max(fversion) from fversions where subID={$id}";
$result = mysql_query($query);
if (mysql_result($result, 0) > $fversion) {
$query = "update fversions set fversion = fversion -1 where subID={$id} and fversion>{$fversion}";
mysql_query($query);
$query = "update flangs set fversion = fversion -1 where subID={$id} and fversion>{$fversion}";
mysql_query($query);
$query = "update subs set fversion = fversion -1 where subID={$id} and fversion>{$fversion}";
mysql_query($query);
}
}
log_insert(LOG_deleteLanguage, bd_getLangName($lang), $_SESSION['userID'], $id, bd_userIsModerador());
$url = bd_getUrl($id);
location($url);
bbdd_close();
$langName1 = bd_getLangName($lang1);
$url1 = bd_getUrl($id1);
$image1 = bd_getIcon($id1);
if ($row = mysql_fetch_assoc($lastedited_result)) {
$id2 = $row['subID'];
$titulo2 = bd_getTitle($id2);
$lang2 = $row['lang_id'];
$langName2 = bd_getLangName($lang2);
$url2 = bd_getUrl($id2);
$image2 = bd_getIcon($id2);
}
if ($row = mysql_fetch_assoc($lastedited_result)) {
$id3 = $row['subID'];
$titulo3 = bd_getTitle($id3);
$lang3 = $row['lang_id'];
$langName3 = bd_getLangName($lang3);
$url3 = bd_getUrl($id3);
$image3 = bd_getIcon($id3);
}
echo '<tr>
<td>' . $image1 . '</td>
<td><big><a href="' . $url1 . '">' . $titulo1 . '</a></big><small>' . $langName1 . '</small></td>
</tr>
<tr>
<td>' . $image2 . '</td>
<td><big><a href="' . $url2 . '">' . $titulo2 . '</a></big><small>' . $langName2 . '</small></td>
</tr>
<tr>
<td>' . $image3 . '</td>
<td><big><a href="' . $url3 . '">' . $titulo3 . '</a></big><small>' . $langName3 . '</small></td>
</tr>';
include 'includes/includes.php';
$linkID = $_GET['linkID'];
$lang = $_GET['lang'];
$mysubID = bd_link_getSubID($linkID);
$fversion = bd_link_getFversion($linkID);
$query = "select count(*) from files where subID={$mysubID}";
$result = mysql_query($query);
$mycount = mysql_result($result, 0);
if ($mycount < 1) {
header("Location: /index.php");
exit;
}
$title = bd_getTitle($mysubID);
bd_increaseDownloads($mysubID);
$langname = bd_getLangName($lang);
$title .= " ({$langname}).srt";
header('Content type: text/srt');
header("Content-Disposition: attachment; filename=\"{$title}\"");
$query = "select text,sequence from subs where subID={$mysubID} and lang_id={$lang} and last=1 and fversion={$fversion} order by edited_seq";
$result = mysql_query($query);
$numresults = mysql_affected_rows();
$orlang = bd_getOriginalLang($mysubID, $fversion);
if ($numresults > 0) {
for ($c = 0; $c < $numresults; $c++) {
$row = mysql_fetch_assoc($result);
$secuencia = $row['sequence'];
$text = $row['text'];
$text = stripcslashes($text);
if (!bd_isUTF($mysubID, $fversion, $orlang)) {
$text = utf8_decode($text);
echo $total . " {$wikilang_downloads}";
?>
</div>
<br />
<table align="center" width="70%" border="0">
<?php
while ($row = mysql_fetch_assoc($dresult)) {
echo '<tr>';
echo '<td class="newsDate">' . obtenerFecha($row['cuando']) . '</td>';
echo '<td><img src="images/download.png" border="0" width="16" height="16" />';
echo ' <a href="updated/' . $row['lang'] . '/' . $row['subID'] . '/' . $row['fversion'] . '">' . $wikilang_download . '</a>';
echo '</td>';
echo '<td>' . bd_getIcon($row['subID']);
echo '<a href="' . bd_getUrl($row['subID']) . '">' . bd_getTitle($row['subID']) . '</a> ';
echo ' ' . $wikilang_version . ' ' . bd_getFVersion($row['subID'], $row['fversion']) . ', ' . bd_getFVersionSize($row['subID'], $row['fversion']) . ' MBs ';
echo ' ' . $wikilang_language . ' ' . bd_getLangName($row['lang']) . '';
echo '</td>';
echo '</tr>';
}
?>
</table>
<?php
$numpaginas = ceil($total / $max);
$pagactual = floor($offset / $max);
echo "{$wikilang_pages} ";
for ($c = 1; $c <= $numpaginas; $c++) {
$mystart = ($c - 1) * $max;
$newpage = floor($mystart / $max);
$plus = $newpage + 1;
$myfunc = "/mydownloads.php?page={$plus}";
if ($newpage != $pagactual) {
$author = $_GET['user'];
$slang = $langfrom;
$squery = "select authorID,version,original,locked,text,lang_id,edited_seq,last,estart_time,estart_time_fraction,eend_time,eend_time_fraction,fversion from subs ";
$query = "where subID={$id} and fversion={$fversion}";
$query .= " and lang_id={$langfrom}";
if ($untranslated) {
$query .= " and edited_seq= ANY (select sequence from translating where subID={$id} and fversion={$fversion} and lang_id={$langto})";
}
$query .= " and last=1 order by edited_seq,version";
$fquery .= " limit {$start},{$MAX_PAGE}";
$finalresult = mysql_query($squery . $query . $fquery);
$countquery = "select count(*) from subs " . $query;
$result2 = mysql_query($countquery);
$total = mysql_result($result2, 0);
$langtoName = bd_getLangName($langto);
$langfromName = bd_getLangName($langfrom);
$state = bd_getLangState($id, $langto, $fversion);
echo " {$wikilang_translation_state} <b><span id=\"current_state\">{$state}</span></b> ";
if ($untranslated) {
echo '<input name="unt" type="checkbox" id="unt" value="true" onclick="untraslated();" checked/>';
} else {
echo '<input name="unt" type="checkbox" id="unt" value="true" onclick="untraslated();"/>';
}
echo $wikilang_view_untraslated;
//comentarios
?>
<div id="content">
<table class="translation">
<thead>
</div></td>
<td class="NewsTitle"><div align="center"><?php
echo $wikilang_state;
?>
</div></td>
<td class="NewsTitle"><div align="center"><?php
echo $wikilang_author;
?>
</div></td>
<td class="NewsTitle"><div align="center"><?php
echo $wikilang_times;
?>
</div></td>
<?php
if (isset($slang)) {
echo '<td class="NewsTitle">' . $wikilang_secondary_language . ' (' . bd_getLangName($slang) . ')</td>';
}
?>
<td class="NewsTitle"><?php
echo $wikilang_text;
?>
</td>
</tr>
<?php
$last_authorID = 0;
while ($row = mysql_fetch_assoc($finalresult)) {
if ($row['last'] == '1') {
$class = 'originalText';
} else {
$class = 'quotedText';
}
$contav++;
}
}
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)) {
if ($mode == "episodes") {
$title = stripslashes($row['title']);
$date = $row['end_date'];
$info = bd_getLangName(bd_getOriginalLang($subID, 0));
} elseif ($mode == "movies") {
$title = stripslashes($row['title']);
$date = $row['end_date'];
$info = bd_getLangName(bd_getOriginalLang($subID, 0));
} elseif ($mode == "downloaded") {
$title = stripslashes($row['title']);
$date = $row['end_date'];
$info = $row['downloads'] . ' ' . $wikilang_downloads;
} elseif ($mode == "translated") {
$title = bd_getTitle($row['subID']);
$date = $row['date'];
$info = bd_getLangName($row['lang_id']);
} elseif ($mode == "versions") {
$title = bd_getTitle($row['subID']);
$date = $row['indate'];
$info = bd_getFVersion($subID, $row['fversion']) . ', ' . bd_getFVersionSize($subID, $row['fversion']);
} elseif ($mode == "news") {
$title = stripslashes($row['text']);
$date = $row['date'];
$info = '';
}
echo '<tr>';
echo '<td>';
if ($mode != "news") {
echo bd_getIcon($subID);
}
echo '</td>';
<td colspan="2"> </td>
</tr>
<?php
$lquery = "select distinct(lang_id) from flangs where subID={$epID} and fversion={$cfversion} order by original DESC";
$llresult = mysql_query($lquery);
while ($llrow = mysql_fetch_assoc($llresult)) {
?>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td class="language">
<?php
echo bd_getLangName($llrow['lang_id']);
?>
</td>
<td><img src="/images/download.png" width="16"" height="16" />
<?php
echo '<a href="/downloadlink.php?linkID=' . $lrow['linkID'] . '&lang=' . $llrow['lang_id'] . '">';
?>
Download</a>
</td>
</tr>
<?php
}
}
}
}
?>
$date = date(r, mktime($hour, $min, $sec, $month, $day, $year));
$salida .= '<item>';
$title = str_ireplace('&', '&', $title);
$salida .= '<title>' . $title . '</title>';
if (!$ids) {
$salida .= '<link>http://wikisubtitles.net' . bd_getUrl($row['subID']) . '</link>';
} else {
$salida .= '<link>http://wikisubtitles.net/sub/' . $row['subID'] . '</link>';
}
$salida .= '<pubDate>' . $date . '</pubDate>';
if (!$ids) {
$salida .= '<guid>http://wikisubtitles.net' . bd_getUrl($row['subID']);
} else {
$salida .= '<guid>http://wikisubtitles.net/sub/' . $row['subID'];
}
if ($mode == 'versions') {
$salida .= $row['fversion'];
}
$salida .= '</guid>';
if ($mode == "translated") {
$langname = utf8_decode(bd_getLangName($row['lang_id']));
$description = "translated to {$langname}";
} else {
$decription = $comment;
}
$salida .= '<description>' . $description . '</description>';
$salida .= '</item>';
}
$salida .= '</channel></rss>';
echo utf8_encode($salida);
bbdd_close();
