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();
$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> </tr>';
<?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();
<?php include 'includes/includes.php'; $ep = $_GET['ep']; $div1 = split('-', $ep); $showID = $div1[0]; $div2 = split('x', $div1[1]); $season = $div2[0]; $epnumber = $div2[1]; $_SESSION['quicksearch_epID'] = $ep; $query = "select subID from files where is_episode=1 and showID={$showID} and season={$season} and season_number={$epnumber} limit 1"; $result = mysql_query($query); if (!mysql_affected_rows()) { location('/index.php'); exit; } $url = bd_getUrl(mysql_result($result, 0)); location($url); bbdd_close();
<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(); ?>
<?php include 'includes/includes.php'; $linkID = $_GET['linkid']; $subID = bd_link_getSubID($linkID); if (!bd_userIsModerador()) { bbdd_close(); location(bd_getUrl($subID)); exit; } $query = "delete from links_data where linkID={$linkID}"; mysql_query($query); $query = "delete from links where linkID={$linkID}"; mysql_query($query); log_insert(LOG_deleteLink, bd_link_getFversion($linkID), $_SESSION['userID'], $subID, bd_userIsModerador()); location(bd_getUrl($subID)); bbdd_close();
$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>"; echo '</tr>'; } ?> </table> <?php include 'footer.php'; bbdd_close(); ?> </body> </html>
</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;
?> <br /> <table border="0" align="center" width="90%"> <?php $query = "select entryID,subID from flangs where state>=100 and original=0 and merged=0 and subID != ANY (select subID from lasttranslated)"; $result = mysql_query($query); while ($row = mysql_fetch_assoc($result)) { $id = $row['subID']; $entry = $row['entryID']; $query = "select count(*) from lasttranslated where subID={$id}"; $tresult = mysql_query($query); $count = mysql_result($tresult, 0); if ($count < 1) { $title = bd_getTitle($id); $icon = bd_getIcon($id); $link = bd_getUrl($id); echo '<tr>'; echo "<td>{$icon}</td>"; echo "<td>{$id}</td>"; echo "<td><a href=\"{$link}\">{$title}</a></td>"; echo '</tr>'; } } ?> </table> <?php include 'footer.php'; bbdd_close(); ?> </body>
$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") { echo "<big><a href=\"" . bd_getUrl($subID) . "\">"; } echo $title; if ($mode != "news") { echo '</a></big>'; } echo "</td>"; echo "<td><big>{$info}</big></td>"; echo "<td><big>" . obtenerFecha($date) . "</big></td>"; echo '</tr>'; } echo '<tr><td colspan=4></td></tr>'; echo '<tr>'; echo '<td>'; if ($page != 1) { $ant = $page - 1;
$query = "select subID,title from files where is_episode=1 and showID={$showID} and season={$season} order by season_number"; $result = mysql_query($query); while ($row = mysql_fetch_assoc($result)) { $epID = $row['subID']; $title = stripslashes($row['title']); ?> <h1>いただけるなら、</h1> <table width="80%" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="17%"> </td> <td width="1%" class="NewsTitle"> </td> <td colspan="5" class="NewsTitle"><img src="/images/package.png" /> <?php $url = '/' . bd_getUrl($epID); echo "<a href='{$url}'>{$title}</a>"; ?> </td> </tr> <?php $vquery = "select distinct(fversion),versionDesc from fversions where subID={$epID} order by fversion"; $vresult = mysql_query($vquery); while ($vrow = mysql_fetch_assoc($vresult)) { $cfversion = $vrow['fversion']; $versionDesc = $vrow['versionDesc']; ?> <tr> <td> </td> <td> </td> <td width="1%" class="newsClaro"> </td>
$newstime = $date; list($date, $hours) = split(' ', $newstime); list($year, $month, $day) = split('-', $date); list($hour, $min, $sec) = split(':', $hours); $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>';