function m_set_score()
{
global $xoopsSecurity;
$id = rmc_server_var($_POST, 'id', 0);
$token = rmc_server_var($_POST, 'token', 0);
$local = rmc_server_var($_POST, 'local', 0);
$visitor = rmc_server_var($_POST, 'visitor', 0);
$other = rmc_server_var($_POST, 'other', 0);
$comments = rmc_server_var($_POST, 'comments', 0);
$win = rmc_server_var($_POST, 'win', 0);
$champ = rmc_server_var($_POST, 'win', 0);
if ($id <= 0) {
response_error(__('No role item has been specified!', 'match'));
}
if (!$xoopsSecurity->check(true, $token)) {
response_error(__('Session token expired!', 'match'));
}
$item = new MCHRoleItem($id);
if ($item->isNew()) {
response_error(__('Specified role item does not exists', 'match'));
}
$score = new MCHScoreItem();
$score->byRole($item->id());
$score->setVar('item', $id);
$score->setVar('local', $local);
$score->setVar('visitor', $visitor);
$score->setVar('other', $other);
$score->setVar('comments', $comments);
$score->setVar('win', $local > $visitor ? $item->getVar('local') : ($visitor > $local ? $item->getVar('visitor') : $win));
$score->setVAr('champ', $item->getVar('champ'));
if ($score->save()) {
$ret = array('done' => 1);
echo json_encode($ret);
die;
} else {
response_error($score->errors());
}
}
function m_save_roleitem($edit = 0)
{
global $xoopsModule, $xoopsModuleConfig, $xoopsSecurity;
$query = '';
foreach ($_POST as $k => $v) {
${$k} = $v;
if ($k == 'XOOPS_TOKEN_REQUEST' || $k == 'action' || $k == 'sbt') {
continue;
}
$query .= $query == '' ? "{$k}=" . urlencode($v) : "&{$k}=" . urlencode($v);
}
$action = $edit ? '?action=edit&id=' . $id : '?';
if (!$xoopsSecurity->check()) {
redirectMsg('role.php?action=' . ($edit ? 'edit&id=' . $id : 'new') . '&' . $query, __('Session token expired!', 'match'), 1);
die;
}
if ($local <= 0 || $visitor <= 0 || $field <= 0 || $date <= 0) {
redirectMsg('role.php?action=' . ($edit ? 'edit&id=' . $id : 'new') . '&' . $query, __('Please fill all required data!', 'match'), 1);
}
if ($edit) {
if ($id <= 0) {
redirectMsg('./role.php', __('Role item ID not valid!', 'match'), 1);
die;
}
//Verificamos que el trabajo exista
$item = new MCHRoleItem($id);
if ($item->isNew()) {
redirectMsg('./role.php', __('Specified role item does not exists!', 'match'), 1);
die;
}
} else {
$item = new MCHRoleItem();
}
$db = XoopsDatabaseFactory::getDatabaseConnection();
// Check if work exists already
if ($edit) {
$sql = "SELECT COUNT(*) FROM " . $db->prefix("mch_role") . " WHERE time='{$time}' AND champ='" . $champ . "' AND id_role<>'{$id}' AND (local='" . $local . "' OR visitor='" . $visitor . "')";
} else {
$sql = "SELECT COUNT(*) FROM " . $db->prefix("mch_role") . " WHERE time='{$time}' AND champ='" . $champ . "' AND (local='" . $local . "' OR visitor='" . $visitor . "')";
}
list($num) = $db->fetchRow($db->query($sql));
if ($num > 0) {
redirectMsg("fields.php" . $action . $query, __('A field with same name already exists!', 'match'), 1);
die;
}
$item->setVar('local', $local);
$item->setVar('visitor', $visitor);
$item->setVar('time', $date);
$item->setVar('field', $field);
$item->setVar('champ', $champ);
$item->setVar('category', $category);
if (!$item->save()) {
redirectMsg('./role.php' . $action . $query, __('Errors ocurred while trying to update database!', 'match') . $item->errors(), 1);
die;
} else {
redirectMsg('./role.php?champ=' . $champ . '&category=' . $category . '&id=' . $item->id(), __('Role item saved successfully!', 'match'), 0);
die;
}
}
