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