echo $duration;
echo $downloads;
?>
</small></h2>
</div>
<?php
for ($contav = 0; $contav < $nversions; $contav++) {
$versionname = $version[$contav]['name'];
$v = $version[$contav]['num'];
$vauthor = $version[$contav]['authorID'];
$vauthorName = $version[$contav]['authorName'];
$size = $version[$contav]['size'];
$vcomment = $version[$contav]['comment'];
$voriginalLang = bd_getOriginalLang($myID, $contav);
$vdowns = $version[$contav]['downloads'];
if (!isset($mylastv)) {
$mylastv = $v;
}
?>
<div id="content-listados">
<div class="sub-profile">
<table class="table-universal traducciones">
<caption><?php
echo "{$wikilang_version} {$versionname}, {$size} MBs";
echo "<em>by <a href='/user/{$vauthor}'>{$vauthorName}</a>";
echo "" . obtenerFecha($version[$contav]['date']);
}
}
$type = $_POST['type'];
$is_episode = $type == "ep";
$season = $_POST['season'];
$epnumber = $_POST['epnumber'];
$eptitle = $_POST['eptitle'];
$movietitle = addslashes($_POST['movietitle']);
$year = $_POST['year'];
$comment = addslashes(strip_tags($_POST["comment"]));
$version = $_POST['version'];
$size = $_POST['fsize'];
$lang = $_POST['lang'];
$query = "update fversions set versionDesc='{$version}',size='{$size}',comment='{$comment}' where subID={$id} and fversion={$rversion}";
mysql_query($query);
$prev_lang = bd_getOriginalLang($id, $rversion);
if ($lang != $prev_lang) {
$query = "update subs set lang_id={$lang} where subID={$id} and fversion={$rversion} and lang_id={$prev_lang}";
mysql_query($query);
$query = "update flangs set lang_id={$lang} where subID={$id} and fversion={$rversion} and lang_id={$prev_lang}";
mysql_query($query);
}
if (!isset($fversion)) {
if ($is_episode) {
$showname = bd_getShowTitle($showID);
if (strlen($season) < 2) {
$season = '0' . $season;
}
if (strlen($epnumber) < 2) {
$epnumber = '0' . $epnumber;
}
$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);
}
$query = "select * from links_data where linkID={$linkID} and sequence={$secuencia}";
$lresult = mysql_query($query);
$lrow = mysql_fetch_assoc($lresult);
$start_time = $lrow['start_time'];
$start_time_fraction = $lrow['start_time_fraction'];
$end_time = $lrow['end_time'];
}
$query .= " limit 1";
$result = mysql_query($query);
$author = mysql_result($result, 0);
$query = "select title,is_episode,showID,season,season_number from files where subID={$id}";
$result = mysql_query($query);
$row = mysql_fetch_assoc($result);
$title = stripslashes($row['title']);
$is_episode = $row['is_episode'];
$showID = $row['showID'];
$season = $row['season'];
$epnumber = $row['season_number'];
if (isset($fversion)) {
$lang = bd_getOriginalLang($id, $fversion);
} else {
$lang = bd_getOriginalLang($id, 0);
}
$query = "select versionDesc,size,comment from fversions where subID={$id} and fversion=";
if (isset($fversion)) {
$query .= $fversion;
} else {
$query .= '0';
}
$result = mysql_query($query);
$row = mysql_fetch_assoc($result);
$vDesc = $row['versionDesc'];
$size = $row['size'];
$comment = stripslashes($row['comment']);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
$url1 = bd_getUrl($id1);
if ($row = mysql_fetch_assoc($lastcompleted_result)) {
$id2 = $row['subID'];
$titulo2 = stripslashes($row['title']);
$autor2 = $row['author'];
$autorName2 = bd_getUsername($autor2);
$lang2 = bd_getOriginalLang($id2, 0);
$langName2 = bd_getLangName($lang2);
$url2 = bd_getUrl($id2);
}
if ($row = mysql_fetch_assoc($lastcompleted_result)) {
$id3 = $row['subID'];
$titulo3 = stripslashes($row['title']);
$autor3 = $row['author'];
$autorName3 = bd_getUsername($autor3);
$lang3 = bd_getOriginalLang($id3, 0);
$langName3 = bd_getLangName($lang3);
$url3 = bd_getUrl($id3);
}
echo '<tr>
<td><em class="ico imovie">Movie</td>
<td><big><a href="' . $url1 . '">' . $titulo1 . '</a></big> <small>' . $langName1 . ' · ' . $wikilang_uplodaded_by . ' <strong><a href="' . $SCRIPT_PATH . 'user/' . $autor1 . '">' . $autorName1 . '</a></strong></small></td>
</tr>
<tr>
<td><em class="ico imovie">Movie</td>
<td><big><a href="' . $url2 . '">' . $titulo2 . '</a></big> <small>' . $langName2 . ' · ' . $wikilang_uplodaded_by . ' <strong><a href="' . $SCRIPT_PATH . 'user/' . $autor2 . '">' . $autorName2 . '</a></strong></small></td>
</tr>
<tr>
<td><em class="ico imovie">Movie</td>
<td><big><a href="' . $url3 . '">' . $titulo3 . '</a></big> <small>' . $langName3 . ' · ' . $wikilang_uplodaded_by . ' <strong><a href="' . $SCRIPT_PATH . 'user/' . $autor3 . '">' . $autorName3 . '</a></strong></small></td>
</tr>';
}
}
$newduration = $tiempos[1];
$novalido = !isset($newduration) || $newduration == '';
if ($novalido) {
$error = true;
$errordesc = "{$wikilang_error_wrongformat}";
}
$query = "select count(*) from links_data where linkID={$newLinkID}";
$result = mysql_query($query);
$count = mysql_result($result, 0);
if ($count < 5) {
$error = true;
$errordesc = $wikilang_error_less5;
}
$olang = bd_getOriginalLang($subID, $fversion);
$original_count = bd_getLastSequence($subID, $olang, $fversion);
//$secuencia--;
if ($original_count != $secuencia) {
$error = true;
$errordesc = $wikilang_error_sequences;
}
}
if ($error) {
$query = "delete from links_data where linkID={$newLinkID}";
mysql_query($query);
$query = "delete from links where linkID={$newLinkID}";
mysql_query($query);
} else {
$query = "update links set enabled=1 where linkID={$newLinkID}";
mysql_query($query);
<?php
include 'includes/includes.php';
include 'translate_fns.php';
$id = $_GET['id'];
$fversion = $_GET['fversion'];
$langto = $_GET['lang'];
$langfrom = bd_getOriginalLang($id, $fversion);
if ($langfrom != $langto) {
tn_check($id, $fversion, $langfrom, $langto);
}
$url = bd_getUrl($id);
location($url);
bbdd_close();
while ($numresults > 0) {
$query = "select entryID,edited_seq,version from subs where subID={$id} and fversion={$fversion} and lang_id={$lang} and authorID={$author} and last=1";
$result = mysql_query($query);
$numresults = mysql_affected_rows();
while ($row = mysql_fetch_assoc($result)) {
$entry = $row['entryID'];
$seq = $row['edited_seq'];
$version = $row['version'];
if (!$notoriginal) {
$query = "delete from subs where entryID={$entry}";
mysql_query($query);
}
if ($version > 0) {
if ($notoriginal) {
$query = "delete from subs where entryID={$entry}";
mysql_query($query);
}
$minver = $version - 1;
$query = "update subs set last=1 where subID={$id} and fversion={$fversion} and lang_id={$lang} and edited_seq={$seq} and version={$minver}";
mysql_query($query);
}
}
}
if (bd_getOriginalLang($id, $fversion) != $lang && !bd_isMerged($id, $fversion, $lang)) {
tn_check($id, $fversion, bd_getOriginalLang($id, $fversion), $lang);
bd_confirmTranslated($id, $fversion, $lang);
}
$authorName = bd_getUsername($authorName);
log_insert(LOG_troll, "User {$authorname}", $_SESSION['userID'], $id, bd_userIsModerador());
location("/antitroll.php?id={$id}&fversion={$fversion}&lang={$lang}");
bbdd_close();
function bd_testAll()
{
$query = "select subID,fversion,lang_id from flangs where state<=100";
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
$subID = $row['subID'];
$fversion = $row['fversion'];
$lang = $row['lang_id'];
$original = bd_getOriginalLang($subID, $fversion);
$title = bd_getTitle($subID);
echo $title . '<br />';
tn_check($subID, $fversion, $original, $lang);
}
}
function tn_super_test($subID, $fversion, $lang)
{
$original = bd_getOriginalLang($subID, $fversion);
tn_check($subID, $fversion, $original, $lang);
tn_start($subID, $fversion, $original, $lang);
//tn_check($subID, $fversion, $original, $lang);
}
if ($offset < 1) {
$offset = 0;
}
$query .= " limit {$offset},{$max}";
$result = mysql_query($query);
$numresults = mysql_affected_rows();
while ($row = mysql_fetch_assoc($result)) {
$subID = $row['subID'];
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'];
<?php
include 'includes/includes.php';
if (!isset($_SESSION['userID'])) {
location('/login.php');
exit;
}
$id = $_GET['id'];
$fversion = $_GET['fversion'];
$title = bd_getTitle($id);
$olang = bd_getOriginalLang($id, $fversion);
$totalseq = bd_getLastSequence($id, $olang, $fversion);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>
<?php
echo "{$wikilang_link_version} {$title} - wikisubtitles";
?>
</title>
<link href="/css/wikisubtitles.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="/js/mootools.v1.11.js"></script>
</head>
<body>
<?php
include 'header.php';
?>
<div align="center" class="titulo">
<img src="images/link.png" border="0" height="16" width="16"><?php
