Código PHP:
<?php
require_once("include.php");
require_once("include_admin.php");
require_once("config.php");
if ($c == 0) $c = 1;
if ($s == 0) $s = 1;
$n = 10;
?>
<HTML>
<HEAD>
<TITLE>Control Panel</TITLE>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=utf-8">
<STYLE>
BODY {font-family: Arial; font-size: 12px; color: #666666; margin: 5% 12%}
H1 {font-size: 22px; color: #666699; padding-bottom: 10px; border-bottom: 1px solid}
A:link {color: #666699}
A:visited {color: #666699}
A:hover {color: #9999CC}
FORM {margin: 0px}
INPUT {width: 300px; font-family: Arial; font-size: 12px; color: #666666; background: white; padding: 1px 3px 0px; margin-right: 10px}
SELECT {width: 300px; font-family: Arial; font-size: 12px; color: #666666; margin: 1px 0px; margin-right: 10px}
TEXTAREA {width: 300px; height: 70px; font-family: Arial; font-size: 12px; color: #666666; padding: 1px 3px 0px; margin-right: 10px}
P {margin-top: 15px}
HR {height: 1px; color: #DDDDDD; margin: 10px 0px}
.BUTTON {width: auto; background: #dddddd}
</STYLE>
<BODY>
<H1>Control Panel</H1>
<A HREF="<?php echo $dir?>">Index</A> > Control Panel
<?php
flush();
$bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password);
mysql_select_db($mysql_database, $bd);
$sql = mysql_query("SELECT COUNT(*) FROM {$prefix}pages WHERE accepted = 'n'");
if (mysql_result($sql,0) > 0){
$pending_pages = true;
};
$sql = mysql_query("SELECT COUNT(*) FROM {$prefix}banned");
if (mysql_result($sql,0) > 0){
$banned = true;
};
if ($pending_pages || $banned){
echo '<HR SIZE=1 COLOR="#DDDDDD">'."\r\n";
if ($pending_pages){
echo '<A HREF="admin_edit_pending.php"><FONT COLOR="#FF3333">(pending submissions)</FONT></A>'."\r\n";
};
if ($banned){
echo '<A HREF="admin_edit_banned.php" ONCLICK="return confirm(\'ban?\')">(banned)</A>'."\r\n";
};
};
flush();
echo '<HR SIZE=1 COLOR="#DDDDDD">'."\r\n";;
$last_category = false;
$ref = $c;
while(!$last_category){
$n_parent_categories += 1;
$sql = mysql_query("SELECT id, name, ref FROM {$prefix}categories WHERE id = $ref");
$parent_categories[$n_parent_categories-1] = array_map("parse_output",mysql_fetch_array($sql, MYSQL_ASSOC));
if ($parent_categories[$n_parent_categories-1]["ref"] == 0){
$last_category = true;
}else{
$ref = $parent_categories[$n_parent_categories-1]["ref"];
};
};
for ($x = $n_parent_categories-1; $x >= 0; $x--){
if ($x != $n_parent_categories-1) echo ' > ';
if ($x == 0){
echo '<B>'.$parent_categories[$x]["name"].'</B>';
}else{
echo '<A HREF="admin_edit.php?c='.$parent_categories[$x]["id"].'"><B>'.$parent_categories[$x]["name"].'</B></A>';
};
};
echo '<BR>'."\r\n";
flush();
$sql = mysql_query("SELECT name, pages, ref FROM {$prefix}categories WHERE id = $c");
$current_category = array_map("parse_output",mysql_fetch_array($sql, MYSQL_ASSOC));
if ($c != 1){
echo '<A HREF="admin_edit_category_delete.php?c='.$c.'&u='.urlencode("{$dir}admin_edit.php?c=".$current_category["ref"]).'" ONCLICK="return confirm(\'delete?\')">(delete)</A>'."\r\n";
};
?>
<A HREF="admin_edit_category.php?c=<?php echo $c."&u=".urlencode("http://".$_SERVER["HTTP_HOST"].$_SERVER["REQUEST_URI"])?>">(edit)</A>
<?php
if ($c != 1){
echo '<A HREF="admin_edit_category_move.php?a='.$c.'&r='.$current_category["ref"].'&c='.$current_category["ref"].'&u='.urlencode("http://".$_SERVER["HTTP_HOST"].$_SERVER["REQUEST_URI"]).'">(move)</A>'."\r\n";
};
?>
<A HREF="admin_edit_category_add.php?c=<?php echo $c?>">(add subcategory)</A>
<?php
if ($current_category["pages"] == "y"){
echo '<A HREF="admin_edit_page_add.php?c='.$c.'">(add page)</A>'."\r\n";
};
?>
<HR SIZE=1 COLOR="#DDDDDD">
<FORM METHOD="get" ACTION="admin_search.php">
<INPUT TYPE="text" NAME="q" MAXLENGTH=100>
<INPUT TYPE="submit" VALUE="Search" CLASS="BUTTON">
</FORM>
<?php
flush();
$sql = mysql_query("SELECT id, name FROM {$prefix}categories WHERE ref = $c ORDER BY name");
$n_subcategories = mysql_num_rows($sql);
for ($x = 0; $x < $n_subcategories; $x++){
$subcategories[$x] = array_map("parse_output",mysql_fetch_array($sql, MYSQL_ASSOC));
};
if ($n_subcategories > 0){
echo '<P>'."\r\n";
echo $n_subcategories.' subcategories found:<P>'."\r\n";
for ($x = 0; $x < $n_subcategories; $x++){
echo '<LI><A HREF="admin_edit.php?c='.$subcategories[$x]["id"].'"><B>'.$subcategories[$x]["name"].'</B></A>'."\r\n";
echo '<A HREF="admin_edit_category_delete.php?c='.$subcategories[$x]["id"].'&u='.urlencode("http://".$_SERVER["HTTP_HOST"].$_SERVER["REQUEST_URI"]).'" ONCLICK="return confirm(\'delete?\')">(delete)</A>'."\r\n";
echo '<A HREF="admin_edit_category.php?c='.$subcategories[$x]["id"].'&u='.urlencode("http://".$_SERVER["HTTP_HOST"].$_SERVER["REQUEST_URI"]).'">(edit)</A>'."\r\n";
echo '<A HREF="admin_edit_category_move.php?a='.$subcategories[$x]["id"].'&r='.$c.'&c='.$c.'&u='.urlencode("http://".$_SERVER["HTTP_HOST"].$_SERVER["REQUEST_URI"]).'">(move)</A>'."\r\n";
};
};
flush();
$sql = mysql_query("SELECT COUNT(*) AS total_pages FROM {$prefix}pages WHERE category = $c");
$total_pages = mysql_result($sql,0,"total_pages");
if ($total_pages > 0){
$sql = mysql_query("SELECT id, url, title, description, keywords, reciproco, accepted, ip FROM {$prefix}pages WHERE category = $c ORDER BY id LIMIT ".($s-1).",$n");
$n_pages = mysql_num_rows($sql);
for ($x = 0; $x < $n_pages; $x++){
$pages[$x] = array_map("parse_output",mysql_fetch_array($sql, MYSQL_ASSOC));
};
};
$e = min($s + $n - 1, $s + $n_pages - 1);
if ($n_pages > 0){
echo '<HR SIZE=1 COLOR="#DDDDDD">'."\r\n";
echo 'Pages '.$s.' - '.$e.' of '.$total_pages.' found:'."\r\n";
for ($x = 0; $x < $n_pages; $x++){
echo '<P><A HREF="'.$pages[$x]["url"].'" TARGET="_blank"><B>'.$pages[$x]["title"].'</B></A>'."\r\n";
if ($pages[$x]["accepted"] == "y"){
echo '<A HREF="admin_edit_page_pending.php?p='.$pages[$x]["id"].'&u='.urlencode("http://".$_SERVER["HTTP_HOST"].$_SERVER["REQUEST_URI"]).'">(pending)</A>'."\r\n";
echo '<A HREF="admin_edit_page_delete.php?p='.$pages[$x]["id"].'&u='.urlencode("http://".$_SERVER["HTTP_HOST"].$_SERVER["REQUEST_URI"]).'" ONCLICK="return confirm(\'delete?\')">(delete)</A>'."\r\n";
}else{
echo '<A HREF="admin_edit_page_accept.php?p='.$pages[$x]["id"].'&u='.urlencode("http://".$_SERVER["HTTP_HOST"].$_SERVER["REQUEST_URI"]).'"><FONT COLOR="#FF3333">(accept)</FONT></A>'."\r\n";
echo '<A HREF="admin_edit_page_delete.php?p='.$pages[$x]["id"].'&u='.urlencode("http://".$_SERVER["HTTP_HOST"].$_SERVER["REQUEST_URI"]).'" ONCLICK="return confirm(\'reject?\')">(reject)</A>'."\r\n";
};
echo '<A HREF="admin_edit_page.php?p='.$pages[$x]["id"].'&c='.$c.'&u='.urlencode("http://".$_SERVER["HTTP_HOST"].$_SERVER["REQUEST_URI"]).'">(edit)</A>'."\r\n";
echo '<A HREF="admin_edit_page_move.php?p='.$pages[$x]["id"].'&r='.$c.'&c='.$c.'&u='.urlencode("http://".$_SERVER["HTTP_HOST"].$_SERVER["REQUEST_URI"]).'">(move)</A>'."\r\n";
if ($pages[$x]["ip"]){
echo '<A HREF="admin_edit_banned_ban.php?i='.$pages[$x]["ip"].'&u='.urlencode("http://".$_SERVER["HTTP_HOST"].$_SERVER["REQUEST_URI"]).'" ONCLICK="return confirm(\'ban?\')">(ban '.$pages[$x]["ip"].')</A>'."\r\n";
};
echo '<BR>'.$pages[$x]["description"]."\r\n";
echo '<BR>Keywords: '.$pages[$x]["keywords"]."\r\n";
echo '<BR>'.$pages[$x]["url"]."\r\n";
echo '<BR>'.$pages[$x]["reciproco"]."\r\n";
};
};
if ($s != 1 || $e != $total_pages){
echo '<P>'."\r\n";
if ($s != 1){
$previous = $s - $n;
echo '<A HREF="'.$dir.'admin_edit.php?c='.$c.'&s='.$previous.'">Previous</A>'."\r\n";
};
for ($x = 1; $x <= ceil($total_pages/$n); $x++){
$current = ($x-1) * $n + 1;
if ($current == $s){
echo $x."\r\n";
}else{
echo '<A HREF="'.$dir.'admin_edit.php?c='.$c.'&s='.$current.'">'.$x.'</A>'."\r\n";
};
};
if ($e < $total_pages){
$next = $s + $n;
echo '<A HREF="'.$dir.'admin_edit.php?c='.$c.'&s='.$next.'">Next</A>'."\r\n";
};
};
?>
<HR SIZE=1 COLOR="#DDDDDD">
<A HREF="admin_uninstall.php" ONCLICK="return confirm('uninstall directory?')">(uninstall directory)</A>
<A HREF="exit.php">(exit)</A>
</BODY>
</HTML>