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