function m_show_championships()
{
global $xoopsModule, $xoopsSecurity;
$page = rmc_server_var($_REQUEST, 'page', 1);
$page = $page <= 0 ? 1 : $page;
$limit = 15;
$db = XoopsDatabaseFactory::getDatabaseConnection();
//Barra de Navegación
$sql = "SELECT COUNT(*) FROM " . $db->prefix('mch_champs');
list($num) = $db->fetchRow($db->query($sql));
$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('champ.php?page={PAGE_NUM}');
$champs = array();
$sql = str_replace('COUNT(*)', '*', $sql);
$sql .= ' ORDER BY start DESC,name ASC';
$result = $db->query($sql);
$timef = new RMTimeFormatter('', "%M% %d%, %Y%");
while ($row = $db->fetchArray($result)) {
$champ = new MCHChampionship();
$champ->assignVars($row);
$champs[] = array('id' => $champ->id(), 'link' => $champ->permalink(), 'name' => $champ->getVar('name'), 'nameid' => $champ->getVar('nameid'), 'start' => $timef->format($champ->getVar('start')), 'end' => $timef->format($champ->getVar('end')), 'description' => $champ->getVar('description'), 'current' => $champ->getVar('current'));
}
$form = new RMForm('', '', '');
$editor = new RMFormEditor('', 'description', '98%', '200px', '', 'html');
$start = new RMFormDate('', 'start', time());
$end = new RMFormDate('', 'end', time());
MCHFunctions::toolbar();
xoops_cp_location('<a href="./">' . $xoopsModule->name() . "</a> » " . __('Championships', 'match'));
RMTemplate::get()->assign('xoops_pagetitle', __('Championships', 'match'));
RMTemplate::get()->add_style('admin.css', 'match');
RMTemplate::get()->add_script(RMCURL . '/include/js/jquery.checkboxes.js');
RMTemplate::get()->add_local_script('admin_match.js', 'match');
RMTemplate::get()->add_head("<script type='text/javascript'>\nvar mch_message='" . __('Do you really want to delete selected championships?', 'match') . "';\n\n var mch_select_message = '" . __('You must select some championships before to execute this action!', 'match') . "';</script>");
xoops_cp_header();
$match_extra_options = RMEvents::get()->run_event('match.more.options');
include RMTemplate::get()->get_template("admin/mch_champs.php", 'module', 'match');
xoops_cp_footer();
}
public function last_championship()
{
$db = XoopsDatabaseFactory::getDatabaseConnection();
$sql = "SELECT * FROM " . $db->prefix("mch_champs") . " ORDER BY id_champ DESC LIMIT 0,1";
$result = $db->query($sql);
if ($db->getRowsNum($result) <= 0) {
return 0;
}
$row = $db->fetchArray($result);
$champ = new MCHChampionship();
$champ->assignVars($row);
return $champ;
}
