/** * Get results */ public function latest_results($cat = 0, $c = 0, $limit = 0) { if ($c <= 0) { $champ = self::current_championship(); } else { $champ = new MCHChampionship($c); } if (!is_object($champ)) { $champ = self::last_championship(); } $db = XoopsDatabaseFactory::getDatabaseConnection(); $tbr = $db->prefix("mch_role"); $tbs = $db->prefix("mch_score"); $sql = "SELECT a.*, s.item, s.local as loc, s.visitor as vis, s.win, s.champ FROM {$tbr} as a, {$tbs} as s WHERE a.champ='" . $champ->id() . "' AND a.time<" . time(); if ($cat > 0) { $sql .= " AND a.category='" . $cat . "'"; } $sql .= " AND s.item=a.id_role ORDER BY a.time DESC LIMIT 0, {$limit}"; $result = $db->query($sql); $tf = new RMTimeFormatter(); while ($row = $db->fetchArray($result)) { $local = new MCHTeam($row['local']); $visitor = new MCHTeam($row['visitor']); $category = new MCHCategory($row['category']); $field = new MCHField($row['field']); $data[] = array('local' => array('id' => $local->id(), 'name' => $local->getVar('name'), 'logo' => XOOPS_UPLOAD_URL . '/teams/' . $local->getVar('logo'), 'score' => $row['loc']), 'visitor' => array('id' => $visitor->id(), 'name' => $visitor->getVar('name'), 'logo' => XOOPS_UPLOAD_URL . '/teams/' . $visitor->getVar('logo'), 'score' => $row['vis']), 'day' => $tf->format($row['time'], __('%M% %d%', 'match')), 'hour' => $tf->format($row['time'], __('%h%:%i%', 'match')), 'category' => array('name' => $category->getVar('name'), 'link' => $category->permalink()), 'field' => $field->getVar('name'), 'win' => $row['win']); } return $data; }
function m_delete_fields() { global $xoopsModule, $xoopsSecurity; $ids = rmc_server_var($_POST, 'ids', array()); //Verificamos que nos hayan proporcionado una categoría para eliminar if (empty($ids)) { redirectMsg('./fields.php', __('No fields selected!', 'match'), 1); die; } if (!$xoopsSecurity->check()) { redirectMsg('./fields.php', __('Session token expired!', 'match'), 1); die; } $db = XoopsDatabaseFactory::getDatabaseConnection(); $errors = ''; foreach ($ids as $k) { //Verificamos si la categoría es válida if ($k <= 0) { $errors .= sprintf(__('Field id "%s" is not valid!', 'match'), $k); continue; } //Verificamos si la categoría existe $field = new MCHField($k); if ($field->isNew()) { $errors .= sprintf(__('Field "%s" does not exists!', 'match'), $k); continue; } RMEvents::get()->run_event('match.delete.field', $field); if (!$field->delete()) { $errors .= sprintf(__('Field "%s" could not be deleted!', 'match'), $field->getVar('name')); } } if ($errors != '') { redirectMsg('./fields.php', __('Errors ocurred while trying to delete fields', 'match') . '<br />' . $errors, 1); die; } else { redirectMsg('./fields.php', __('Database updated successfully!', 'match'), 0); die; } }