?> · <?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();