$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>';
}
include 'header.php';
?>
<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>
?>
</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);
$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") {
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>';
}