<?PHP
/* ====================
Seditio - Website engine
Copyright Neocrome & Seditio Team
http://www.neocrome.net
http://www.seditio.org
[BEGIN_SED]
File=admin.trashcan.inc.php
Version=175
Updated=2012-dec-31
Type=Core.admin
Author=Neocrome
Description=Trash can
[END_SED]
==================== */
if ( !defined('SED_CODE') || !defined('SED_ADMIN') ) { die('Wrong URL.'); }
list($usr['auth_read'], $usr['auth_write'], $usr['isadmin']) = sed_auth('admin', 'a');
sed_block($usr['isadmin']);
$adminpath[] = array (sed_url("admin", "m=trashcan"), $L['Trashcan']);
$adminhelp = $L['adm_help_trashcan'];
$adminmain = "<h2><img src=\"system/img/admin/trash.png\" alt=\"\" /> ".$L['Trashcan']."</h2>";
$id = sed_import('id','G','INT');
if ($a=='wipe')
{
sed_check_xg();
$sql = sed_sql_query("DELETE FROM $db_trash WHERE tr_id='$id'");
}
elseif ($a=='wipeall')
{
sed_check_xg();
$sql = sed_sql_query("TRUNCATE $db_trash");
}
elseif ($a=='restore')
{
sed_check_xg();
if (sed_trash_restore($id))
{ sed_trash_delete($id); }
}
$sql = sed_sql_query("SELECT t.*, u.user_name FROM $db_trash AS t
LEFT JOIN $db_users AS u ON t.tr_trashedby=u.user_id
WHERE 1 ORDER by tr_id DESC");
$adminmain .= "<ul class=\"arrow_list\"><li><a href=\"".sed_url("admin", "m=config&n=edit&o=core&p=trash")."\">".$L['Configuration']."</a></li><li>";
$adminmain .= $L['Wipeall'].": [<a href=\"".sed_url("admin", "m=trashcan&a=wipeall&".sed_xg())."\">x</a>]</li></ul>";
$adminmain .= "<table class=\"cells striped\"><tr>";
$adminmain .= "<td class=\"coltop\" style=\"width:144px;\">".$L['Date']."</td>";
$adminmain .= "<td class=\"coltop\" style=\"width:144px;\">".$L['Type']."</td>";
$adminmain .= "<td class=\"coltop\">".$L['Title']."</td>";
$adminmain .= "<td class=\"coltop\" style=\"width:96px;\">".$L['adm_setby']."</td>";
$adminmain .= "<td class=\"coltop\" style=\"width:156px;\">".$L['Wipe']."</td>";
$adminmain .= "<td class=\"coltop\" style=\"width:56px;\">".$L['Restore']."</td></tr>";
$ii = 0;
while ($row = sed_sql_fetchassoc($sql))
{
switch ($row['tr_type'])
{
case 'comment':
$icon = "comments.png";
$typestr = $L['Comment'];
break;
case 'forumpost':
$icon = "forums.png";
$typestr = $L['Post'];
break;
case 'forumtopic':
$icon = "forums.png";
$typestr = $L['Topic'];
break;
case 'page':
$icon = "page.png";
$typestr = $L['Page'];
break;
case 'pm':
$icon = "pm.png";
$typestr = $L['Private_Messages'];
break;
case 'user':
$icon = "user.png";
$typestr = $L['User'];
break;
default:
$icon = "tools.png";
$typestr = $row['tr_type'];
break;
}
$adminmain .= "<tr>";
$adminmain .= "<td style=\"text-align:center;\">".sed_build_date($cfg['dateformat'], $row['tr_date'])."</td>";
$adminmain .= "<td><img src=\"system/img/admin/".$icon."\" alt=\"".$typestr."\" /> ".$typestr."</td>";
$adminmain .= "<td>".sed_cc($row['tr_title'])."</td>";
$adminmain .= "<td style=\"text-align:center;\">";
$adminmain .= ($row['tr_trashedby']==0) ? $L['System'] : sed_build_user($row['tr_trashedby'], sed_cc($row['user_name']));
$adminmain .= "</td><td style=\"text-align:center;\">";
$adminmain .= "[<a href=\"".sed_url("admin", "m=trashcan&a=wipe&id=".$row['tr_id']."&".sed_xg())."\">-</a>]</td>";
$adminmain .= "<td style=\"text-align:center;\">";
$adminmain .= "[<a href=\"".sed_url("admin", "m=trashcan&a=restore&id=".$row['tr_id']."&".sed_xg())."\">+</a>]</td></tr>";
$ii++;
}
$adminmain .= "<tr><td colspan=\"6\">".$L['Total']." : ".$ii."</td></tr></table>";
?>