/**
* @desc Muestra la lista de categorías existentes
*/
function showCategories()
{
global $tpl, $xoopsModule, $db, $adminTemplate;
$result = $db->query("SELECT * FROM " . $db->prefix("coach_categos") . " ORDER BY name");
$categos = array();
while ($row = $db->fetchArray($result)) {
$cat = new TCCategory();
$cat->assignVars($row);
$categos[] = array('id' => $cat->id(), 'name' => $cat->getVar('name'), 'teams' => count($cat->teams()));
}
xoops_cp_location("<a href='./'>" . $xoopsModule->name() . "</a> » " . _AS_TC_CATSLOC);
xoops_cp_header();
include RMTemplate::get()->get_template("admin/coach_categories.php", 'module', 'team');
xoops_cp_footer();
}
if ($xoopsDB->getRowsNum($result) == 1) {
$row = $xoopsDB->fetchArray($result);
$link = XOOPS_URL . "/modules/team/" . ($mc['urlmode'] ? "t/{$row['nameid']}/" : "team.php?id={$row['nameid']}");
header('Location: ' . $link);
die;
}
$xoopsOption['template_main'] = "coach_index.html";
include 'header.php';
$tpl->assign('coach_title', _MS_TC_TITLE);
$tpl->assign('lang_comment', _MS_TC_COMMENT);
// Categorías
$tpl->assign('lang_categos', _MS_TC_CATTITLE);
$result = $xoopsDB->query("SELECT * FROM " . $xoopsDB->prefix("coach_categos") . " ORDER BY name");
$cats = array();
while ($row = $xoopsDB->fetchArray($result)) {
$cat = new TCCategory();
$cat->assignVars($row);
$cats[$cat->id()] = $cat;
$link = TC_URL . '/' . ($mc['urlmode'] ? 'cat/' . $cat->nameId() . '/' : 'category.php?id=' . $cat->id());
$tpl->append('categos', array('id' => $cat->id(), 'name' => $cat->name(), 'desc' => $cat->desc(), 'link' => $link));
}
// Equipos
$tpl->assign('lang_teams', _MS_TC_TEAMSTITLE);
$result = $xoopsDB->query("SELECT * FROM " . $xoopsDB->prefix("coach_teams") . " ORDER BY name");
while ($row = $xoopsDB->fetchArray($result)) {
$team = new TCTeam();
$team->assignVars($row);
$link = TC_URL . '/' . ($mc['urlmode'] ? 't/' . $team->nameId() . '/' : 'team.php?id=' . $team->id());
$tpl->append('teams', array('id' => $team->id(), 'name' => $team->name() . " <em>(" . $cats[$team->category(false)]->name() . ")</em>", 'link' => $link));
}
include 'footer.php';
