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>';
