76 lines
2.1 KiB
PHP
76 lines
2.1 KiB
PHP
|
<?php
|
||
|
|
/**
|
||
|
|
* @version $Id: mod_latest.php 5677 2006-11-07 23:12:11Z friesengeist $
|
||
|
|
* @package Joomla
|
||
|
|
* @copyright Copyright (C) 2005 Open Source Matters. All rights reserved.
|
||
|
|
* @license http://www.gnu.org/copyleft/gpl.html GNU/GPL, see LICENSE.php
|
||
|
|
* Joomla! is free software. This version may have been modified pursuant
|
||
|
|
* to the GNU General Public License, and as distributed it includes or
|
||
|
|
* is derivative of works licensed under the GNU General Public License or
|
||
|
|
* other free or open source software licenses.
|
||
|
|
* See COPYRIGHT.php for copyright notices and details.
|
||
|
|
*/
|
||
|
|
|
||
|
|
// no direct access
|
||
|
|
defined( '_VALID_MOS' ) or die( 'Restricted access' );
|
||
|
|
|
||
|
|
$query = "SELECT a.id, a.sectionid, a.title, a.created, u.name, a.created_by_alias, a.created_by"
|
||
|
|
. "\n FROM #__content AS a"
|
||
|
|
. "\n LEFT JOIN #__users AS u ON u.id = a.created_by"
|
||
|
|
. "\n WHERE a.state != -2"
|
||
|
|
. "\n ORDER BY created DESC"
|
||
|
|
;
|
||
|
|
$database->setQuery( $query, 0, 10 );
|
||
|
|
$rows = $database->loadObjectList();
|
||
|
|
?>
|
||
|
|
|
||
|
|
<table class="adminlist">
|
||
|
|
<tr>
|
||
|
|
<th colspan="3">
|
||
|
|
Most Recently Added Content
|
||
|
|
</th>
|
||
|
|
</tr>
|
||
|
|
<?php
|
||
|
|
foreach ($rows as $row) {
|
||
|
|
if ( $row->sectionid == 0 ) {
|
||
|
|
$link = 'index2.php?option=com_typedcontent&task=edit&hidemainmenu=1&id='. $row->id;
|
||
|
|
} else {
|
||
|
|
$link = 'index2.php?option=com_content&task=edit&hidemainmenu=1&id='. $row->id;
|
||
|
|
}
|
||
|
|
|
||
|
|
if ( $acl->acl_check( 'administration', 'manage', 'users', $my->usertype, 'components', 'com_users' ) ) {
|
||
|
|
if ( $row->created_by_alias ) {
|
||
|
|
$author = $row->created_by_alias;
|
||
|
|
} else {
|
||
|
|
$linkA = 'index2.php?option=com_users&task=editA&hidemainmenu=1&id='. $row->created_by;
|
||
|
|
$author = '<a href="'. $linkA .'" title="Edit User">'. htmlspecialchars( $row->name, ENT_QUOTES ) .'</a>';
|
||
|
|
}
|
||
|
|
} else {
|
||
|
|
if ( $row->created_by_alias ) {
|
||
|
|
$author = $row->created_by_alias;
|
||
|
|
} else {
|
||
|
|
$author = htmlspecialchars( $row->name, ENT_QUOTES );
|
||
|
|
}
|
||
|
|
}
|
||
|
|
?>
|
||
|
|
<tr>
|
||
|
|
<td>
|
||
|
|
<a href="<?php echo $link; ?>">
|
||
|
|
<?php echo htmlspecialchars($row->title, ENT_QUOTES);?>
|
||
|
|
</a>
|
||
|
|
</td>
|
||
|
|
<td>
|
||
|
|
<?php echo $row->created;?>
|
||
|
|
</td>
|
||
|
|
<td>
|
||
|
|
<?php echo $author;?>
|
||
|
|
</td>
|
||
|
|
</tr>
|
||
|
|
<?php
|
||
|
|
}
|
||
|
|
?>
|
||
|
|
<tr>
|
||
|
|
<th colspan="3">
|
||
|
|
</th>
|
||
|
|
</tr>
|
||
|
|
</table>
|