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);
}
}
