/** * @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';