/**
* Generate Recent Trackbacks List
*
* @return string
*/
public function getRecentTrackbacks()
{
global $pathToIndex, $lang;
$this->getModuleLanguage('trackback');
$trackbackList = '';
$sql = 'SELECT ' . 'id, blog_id, title, name, date ' . 'FROM ' . TRACKBACK_TABLE . ' ' . 'ORDER BY ' . 'date DESC ' . 'LIMIT ' . self::$config['recent_trackback_max'];
$stmt = $this->db->prepare($sql);
$res = $stmt->execute();
if ($res) {
while ($row = $stmt->fetch()) {
if (!in_array($row['blog_id'], $this->getDraftLogIdArray())) {
$trackbackTitle = htmlspecialchars(stripslashes($row['title']));
$trackbackList .= '<li>' . '<a href="' . $pathToIndex . '/index.php?id=' . $row['blog_id'] . '#tb' . $row['id'] . '" title=""' . $trackbackTitle . '"">' . 'From ' . htmlspecialchars(stripslashes($row['name'])) . '<br />' . date('y/m/d H:i', strtotime($row['date'])) . '</a>' . "</li>\n";
}
}
}
if ($trackbackList == '') {
$trackbackList = '<li>' . $lang['trackback']['default_message'] . '</li>';
}
return $trackbackList;
}
}
// Create a recent trackbacks list object
$recentTrackbacks = new Loggix_Module_Trackback();
$module['LM']['trackback']['recent'] = $recentTrackbacks->getRecentTrackbacks();
