<?php
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)) {
<?php
include 'includes/includes.php';
$show = $_GET['show'];
$epnumber = $_GET['epnumber'];
$season = $_GET['season'];
$query = "select subID from files where is_episode=1 and showID={$show} and season={$season} and season_number={$epnumber}";
$result = mysql_query($query);
if (mysql_affected_rows() > 0) {
$sID = mysql_result($result, 0);
$showName = bd_getShowTitle($show);
$title = bd_getTitle($sID);
$url = bd_getUrl($sID);
echo '<a href="' . $url . '">' . $title . '</a> ';
echo "{$wikilang_ep_already_exists}";
} else {
echo '' . $wikilang_ep_not_exists . '';
}
bbdd_close();
for ($c = 0; $c < $MAX_CATEGORY / 3 && ($row = mysql_fetch_assoc($lastedited_result)); $c++) {
$id1 = $row['subID'];
$titulo1 = bd_getTitle($id1);
$url1 = bd_getUrl($id1);
$image1 = bd_getIcon($id1);
$downs1 = $row['cuenta'];
if ($row = mysql_fetch_assoc($lastedited_result)) {
$id2 = $row['subID'];
$titulo2 = bd_getTitle($id2);
$url2 = bd_getUrl($id2);
$image2 = bd_getIcon($id2);
$downs2 = $row['cuenta'];
}
if ($row = mysql_fetch_assoc($lastedited_result)) {
$id3 = $row['subID'];
$titulo3 = bd_getTitle($id3);
$url3 = bd_getUrl($id3);
$image3 = bd_getIcon($id3);
$downs3 = $row['cuenta'];
}
echo '<tr>
<th><a href="' . $url1 . '">' . $titulo1 . ' </a></th>
<td><strong>' . $downs1 . '</strong></td>
</tr>
<tr>
<th><a href="' . $url2 . '">' . $titulo2 . ' </a></th>
<td><strong>' . $downs2 . '</strong></td>
</tr>
<tr>
<th><a href="' . $url3 . '">' . $titulo3 . ' </a></th>
<td><strong>' . $downs3 . '</strong></td>
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;
}
$title = $showname . ' - ' . $season . 'x' . $epnumber . ' - ' . $eptitle;
$title = addslashes($title);
$query = "update files set is_episode=1,title='{$title}',season={$season},season_number={$epnumber} where subID={$id}";
mysql_query($query);
} else {
$title = $movietitle . " ({$year})";
$tile = addslashes($title);
$query = "update files set is_episode=0,title='{$title}' where subID={$id}";
mysql_query($query);
}
}
$title = bd_getTitle($id);
log_insert(LOG_updateprop, '', $userID, $id, bd_userIsModerador());
$url = bd_getUrl($id);
location("{$url}");
bbdd_close();
<?php
include 'includes/includes.php';
if (!isset($_SESSION['userID'])) {
header("Location: /login.php");
exit;
}
$id = $_GET['id'];
$fversion = $_GET['fversion'];
$lang = $_GET['lang'];
$titulo = bd_getTitle($id);
$query = "select * from languages where langID=ANY (select lang_id from flangs where subID={$id} and fversion={$fversion} and lang_id!={$lang});";
$rresult = mysql_query($query);
$numresults = mysql_affected_rows();
?>
<!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_join_translation} {$title} - wikisubtitles";
?>
</title>
<link href="/css/wikisubtitles.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="/js/mootools.v1.11.js"></script>
<script type="text/javascript">
function enviar()
{
$("myform").submit();
}
<tr>
<td ><img src="/images/invisible.gif" width="50" height="5"/></td>
<td class="NewsTitle"><?php
echo $wikilang_files_edited;
?>
</td>
<td><?php
echo "{$total_created}";
?>
</td>
<td> </td>
</tr>
<?php
while ($row = mysql_fetch_assoc($result)) {
$myID = $row['subID'];
$titulo = bd_getTitle($myID);
$url = bd_getUrl($myID);
echo '<tr>
<td ><img src="' . $SCRIPT_PATH . 'images/invisible.gif" width="50" height="5"/></td>
<td> </td>
<td><img src="' . $SCRIPT_PATH . 'images/package.png" width="16" height="16"/> <a href="' . $url . '">' . $titulo . '</a></td>
<td> </td>
</tr>';
}
?>
</table>
<?php
include 'footer.php';
bbdd_close();
<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);
echo "<td>{$subID}</td><td><a href=\"{$url}\">{$title}</a></td><td>{$lang_name}</td><td>{$state}</td>";
</div><div class="newsDate" align="center">
<?php
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;
<?php
include 'includes/includes.php';
$mysubID = $_GET['id'];
$fversion = $_GET['fversion'];
if (!isset($fversion)) {
$fversion = 0;
}
$title = bd_getTitle($mysubID) . '.srt';
bd_increaseDownloads($mysubID);
$orlang = bd_getOriginalLang($mysubID, $fversion);
header('Content type: text/srt');
header("Content-Disposition: attachment; filename=\"{$title}\"");
$query = "select * from subs where subID={$mysubID} and original=1 and fversion={$fversion} order by sequence";
$result = mysql_query($query);
$numresults = mysql_affected_rows();
if ($numresults > 0) {
for ($c = 0; $c < $numresults; $c++) {
$row = mysql_fetch_assoc($result);
$secuencia = $row['sequence'];
$start_time = $row['start_time'];
$end_time = $row['end_time'];
$start_time_fraction = $row['start_time_fraction'];
$end_time_fraction = $row['end_time_fraction'];
$text = stripslashes($row['text']);
if (!bd_isUTF($mysubID, $fversion, $orlang)) {
$text = utf8_decode($text);
}
echo "{$secuencia}\r\n";
echo "{$start_time},{$start_time_fraction} --> {$end_time},{$end_time_fraction}\r\n";
$text = str_replace("\n", "\r\n", $text);
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);
}
}
$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>';
echo "<td>";
if ($mode != "news") {
