function m_show_roster() { global $xoopsModule, $xoopsSecurity; $db = XoopsDatabaseFactory::getDatabaseConnection(); $id = rmc_server_var($_REQUEST, 'id', 0); if ($id > 0) { MCHFunctions::page_from_item($id, 'player'); } $page = rmc_server_var($_REQUEST, 'page', 1); $page = $page <= 0 ? 1 : $page; $limit = 15; $team = rmc_server_var($_REQUEST, 'team', 0); $search = rmc_server_var($_REQUEST, 'search', ''); $filters = false; //Barra de Navegación $sql = "SELECT COUNT(*) FROM " . $db->prefix('mch_coaches'); if ($team > 0 || $search != '') { $sql .= " WHERE "; $filters = true; } $and = false; if ($team > 0) { $sql .= " team={$team}"; $and = true; $t = new MCHTeam($team); if (!$t->isNew()) { $team_data = array('name' => $t->getVar('name')); } unset($t); } if ($search != '') { $sql .= $and ? ' AND ' : ''; $sql .= "(name LIKE '%{$search}%' OR lastname LIKE '%{$search}%' OR surname LIKE '%{$search}%')"; } 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('coaches.php?page={PAGE_NUM}&team=' . $team); $coaches = array(); $sql = str_replace('COUNT(*)', '*', $sql); $sql .= ' ORDER BY ' . ($team > 0 ? 'charge,lastname,surname,name' : 'lastname,surname,name'); $result = $db->query($sql); $cache_team = array(); $timef = new RMTimeFormatter('', "%M% %d%, %Y%"); while ($row = $db->fetchArray($result)) { $coach = new MCHCoach(); $coach->assignVars($row); if (isset($cache_team[$coach->getVar('team')])) { $t = $cache_team[$coach->getVar('team')]; } else { $cache_team[$coach->getVar('team')] = new MCHTeam($coach->getVar('team')); $t = $cache_team[$coach->getVar('team')]; } $coaches[] = array('id' => $coach->id(), 'link' => $coach->permalink(), 'name' => $coach->getVar('name'), 'lastname' => $coach->getVar('lastname'), 'surname' => $coach->getVar('surname'), 'nameid' => $coach->getVar('nameid'), 'created' => $timef->format($coach->getVar('created')), 'charge' => MCHFunctions::charge_name($coach->getVar('charge')), 'team' => array('id' => $t->id(), 'name' => $t->getVar('name'), 'link' => $t->permalink())); } // Categories $teams = MCHFunctions::all_teams(false); // Event $coaches = RMEvents::get()->run_event('match.list.coaches', $coaches); MCHFunctions::toolbar(); xoops_cp_location('<a href="./">' . $xoopsModule->name() . "</a> » " . __('Coaches', 'match')); RMTemplate::get()->assign('xoops_pagetitle', __('Coaches', '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 coaches?', 'match') . "';\n\n var mch_select_message = '" . __('You must select some coach 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_coaches.php", 'module', 'match'); xoops_cp_footer(); }