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';
function saveCategory($edit = 0) { global $db, $xoopsSecurity; $nameid = ''; foreach ($_POST as $k => $v) { ${$k} = $v; } if (!$xoopsSecurity->check()) { redirectMsg('cats.php' . ($edit ? "?op=edit&id={$id}" : "?op=new"), __('¡El identificador de sesión ha expirado!', 'admin_team'), 1); break; } if ($edit) { $id = TCFunctions::post('id'); if ($id <= 0) { redirectMsg('cats.php', __('Id no válido', 'admin_team'), 1); die; } $cat = new TCCategory($id); if ($cat->isNew()) { redirectMsg('cats.php', __('No existe la categoría especificada', 'admin_team'), 1); die; } $i = 0; do { $nameid = $nameid != '' && $i == 0 ? $nameid : $util->sweetstring($name) . ($i > 0 ? $i : ''); $sql = "SELECT COUNT(*) FROM " . $db->prefix("coach_categos") . " WHERE nameid='{$nameid}' AND id_cat<>'" . $cat->id() . "'"; list($num) = $db->fetchRow($db->query($sql)); $i++; } while ($num > 0); $sql = "SELECT COUNT(*) FROM " . $db->prefix("coach_categos") . " WHERE name='{$name}' AND id_cat<>'" . $cat->id() . "'"; list($num) = $db->fetchRow($db->query($sql)); if ($num > 0) { redirectMsg('cats.php?op=edit&id=' . $cat->id(), __('Ya existe una categoría con el mismo nombre', 'admin_team'), 1); die; } } else { $cat = new TCCategory(); $i = 0; do { $nameid = TextCleaner::getInstance()->sweetstring($name) . ($i > 0 ? $i : ''); $sql = "SELECT COUNT(*) FROM " . $db->prefix("coach_categos") . " WHERE nameid='{$nameid}'"; list($num) = $db->fetchRow($db->query($sql)); $i++; } while ($num > 0); $sql = "SELECT COUNT(*) FROM " . $db->prefix("coach_categos") . " WHERE name='{$name}'"; list($num) = $db->fetchRow($db->query($sql)); if ($num > 0) { redirectMsg('cats.php?op=new&id=' . $cat->id(), __('Ya existe una categoría con el mismo nombre', 'admin_team'), 1); die; } } $cat->setVar('name', $name); $cat->setVar('nameid', $nameid); $cat->setVar('desc', $desc); if ($cat->save()) { redirectMsg('cats.php', __('Base de datos actualizada correctamente', 'admin_team'), 0); } else { redirectMsg('cats.php', __('No se pudo actualizar la base de datos', 'admin_team') . "<br />" . $cat->errors(), 1); } }