function show_mw_trackbacks()
{
global $xoopsModule, $xoopsSecurity;
$id = rmc_server_var($_GET, 'id', 0);
$db = XoopsDatabaseFactory::getDatabaseConnection();
$sql = "SELECT COUNT(*) FROM " . $db->prefix("mw_trackbacks");
if ($id > 0) {
$sql .= "WHERE post={$id}";
}
list($num) = $db->fetchRow($db->query($sql));
$page = rmc_server_var($_GET, 'page', 1);
$limit = isset($limit) && $limit > 0 ? $limit : 15;
$tpages = ceil($num / $limit);
$page = $page > $tpages ? $tpages : $page;
$start = $num <= 0 ? 0 : ($page - 1) * $limit;
$nav = new RMPageNav($num, $limit, $page, 5);
$nav->target_url('trackbacks.php?page={PAGE_NUM}' . ($id > 0 ? '&id=' . $id : ''));
$sql = str_replace("COUNT(*)", '*', $sql);
$sql .= " ORDER BY `date` LIMIT {$start},{$limit}";
$result = $db->query($sql);
$posts = array();
// posts cache
$trackbacks = array();
// Get trackbacks data
while ($row = $db->fetchArray($result)) {
$trac = new MWTrackbackObject();
$trac->assignVars($row);
$posts[$trac->getVar('post')] = isset($posts[$trac->getVar('post')]) ? $posts[$trac->getVar('post')] : new MWPost($trac->getVar('post'));
$trackbacks[] = array('tb' => $trac, 'post' => array('title' => $posts[$trac->getVar('post')]->getVar('title'), 'link' => $posts[$trac->getVar('post')]->isNew() ? '' : $posts[$trac->getVar('post')]->permalink()));
}
// Event
$trackbacks = RMEvents::get()->run_event("mywords.trackbacks.list", $trackbacks);
MWFunctions::include_required_files();
RMTemplate::get()->add_script(RMCURL . '/include/js/jquery.checkboxes.js');
RMTemplate::get()->add_script(XOOPS_URL . '/modules/mywords/include/js/scripts.php?file=trackbacks.js');
xoops_cp_header();
xoops_cp_location('<a href="' . XOOPS_URL . '/modules/mywords/admin/">' . $xoopsModule->getVar('name') . '</a> » ' . __('Trackbacks', 'mywords'));
include RMTemplate::get()->get_template('admin/mywords_trackbacks.php', 'module', 'mywords');
xoops_cp_footer();
}
