public static function getDateFormat() { // static $model; // if (is_null($model)) { // $model = new JSPRO_Models(); // } if (is_null(self::$_dateFormat)) { self::$_dateFormat = getJS_Config('date_format'); } return self::$_dateFormat; }
function getData() { $query = "SELECT s_id FROM #__bl_matchday as md, #__bl_match as m WHERE md.id=m.m_id AND m.id = '" . $this->m_id . "'"; $this->db->setQuery($query); $this->s_id = $this->db->loadResult(); $row = new JTableMatch($this->db); $row->load($this->m_id); $error = $this->db->getErrorMsg(); if ($error) { return JError::raiseError(500, $error); } //get tiurnament type if ($this->s_id != -1) { $tourn = $this->getTournOpt($this->s_id); $this->t_single = $tourn->t_single; $this->t_type = 0; $this->_lists["s_enbl_extra"] = $tourn->s_enbl_extra; } else { $this->t_type = 0; if ($row->m_single == 1) { $this->t_single = 1; } else { $this->t_single = 0; } $this->_lists["s_enbl_extra"] = 0; } $this->_lists["match"] = $this->getMatch(); //title $match = $this->_lists["match"]; $this->p_title = $match->home . ' ' . ($match->m_played ? $match->score1 : '-') . ':' . ($match->m_played ? $match->score2 : '-') . ' ' . $match->away; $this->_params = $this->JS_PageTitle($this->title ? $this->title : $this->p_title); $this->_lists["season_par"] = $this->getSParametrs($this->s_id); $this->getMEvents($match); $query = "SELECT p.ph_name as name,p.id as id,p.ph_filename as filename FROM #__bl_assign_photos as ap, #__bl_photos as p WHERE ap.photo_id = p.id AND cat_type = 3 AND cat_id = " . $this->m_id; $this->db->setQuery($query); $this->_lists["photos"] = $this->db->loadObjectList(); ///--------MAPS--------------/// $query = "SELECT m.*,mp.m_score1,mp.m_score2 FROM #__bl_seas_maps as sm, #__bl_maps as m LEFT JOIN #__bl_mapscore as mp ON m.id=mp.map_id AND mp.m_id=" . $this->m_id . " WHERE m.id=sm.map_id AND sm.season_id=" . $this->s_id . " ORDER BY m.id"; $this->db->setQuery($query); $this->_lists['maps'] = $this->db->loadObjectList(); $this->_lists["enbl_extra"] = 0; if ($this->s_id) { $this->_lists["unable_reg"] = $this->unblSeasonReg(); } $this->_lists["teams_season"] = $this->teamsToModer(); $this->_lists["panel"] = $this->getePanel($this->_lists["teams_season"], @$this->_lists["unable_reg"], $this->s_id, 1, 0, 1); $this->_lists["mcomments"] = $this->getJS_Config("mcomments"); if ($this->_lists["mcomments"]) { $this->getComments(); } ///line up $this->getLineUps($match); //betts if ($this->isBet()) { $this->_lists["betevents"] = $this->getMatchBetEvents($this->m_id); } $this->_lists['sh_name'] = getJS_Config('player_name'); ///-----EXTRAFIELDS---// $this->_lists['ext_fields'] = $this->getAddFields($this->m_id, '2', 'match'); //social buttons $tt = $match->home . ' ' . ($match->m_played ? $match->score1 : '-') . ':' . ($match->m_played ? $match->score2 : '-') . ' ' . $match->away; $this->_lists['socbut'] = $this->getSocialButtons('jsbp_match', $tt, '', htmlspecialchars(strip_tags($match->match_descr))); }
function getData() { if ($this->_user->get('guest')) { $return_url = $_SERVER['REQUEST_URI']; $return_url = base64_encode($return_url); if (getVer() >= '1.6') { $uopt = "com_users"; } else { $uopt = "com_user"; } $return = 'index.php?option=' . $uopt . '&view=login&return=' . $return_url; // Redirect to a login form $this->mainframe->redirect($return, JText::_('BLMESS_NOT_LOGIN')); } //title $tourn = $this->getTournOpt($this->s_id); $this->t_single = $tourn->t_single; $this->_lists['bluid'] = $this->t_single ? $this->regBluid($this->_user->id) : 0; if ($this->pay) { //if(!$this->t_single && $this->reg_team){ // $this->savePayStatus($this->reg_team,$this->_user->id,$this->s_id); //}else{ $this->savePayStatus(0,$this->_user->id,$this->s_id);} $this->savePayStatus($this->reg_team, $this->_user->id, $this->s_id); } $this->_params = $this->JS_PageTitle($tourn->name); $season_par = $this->getSParametrs($this->s_id); $this->_lists["season_par"] = $season_par; $reg_start = mktime(substr($season_par->reg_start, 11, 2), substr($season_par->reg_start, 14, 2), 0, substr($season_par->reg_start, 5, 2), substr($season_par->reg_start, 8, 2), substr($season_par->reg_start, 0, 4)); $reg_end = mktime(substr($season_par->reg_end, 11, 2), substr($season_par->reg_end, 14, 2), 0, substr($season_par->reg_end, 5, 2), substr($season_par->reg_end, 8, 2), substr($season_par->reg_end, 0, 4)); $unable_reg = 0; if ($this->t_single) { $query = "SELECT COUNT(*) FROM #__bl_players as t , #__bl_season_players as st WHERE st.player_id = t.id AND st.season_id = " . $this->s_id; } else { $query = "SELECT COUNT(*) FROM #__bl_teams as t , #__bl_season_teams as st WHERE st.team_id = t.id AND st.season_id = " . $this->s_id; } $this->db->setQuery($query); $part_count = $this->db->loadResult(); $error = $this->db->getErrorMsg(); if ($error) { return JError::raiseError(500, $error); } if ($season_par->s_reg && ($part_count < $season_par->s_participant || $season_par->s_participant == 0) && ($reg_start <= time() && (time() <= $reg_end || $season_par->reg_end == '0000-00-00 00:00:00'))) { $unable_reg = 1; } $this->_lists["part_count"] = $part_count; $this->_lists["unable_reg"] = $unable_reg; $this->getcaplist(); $this->_lists["teams_season"] = $this->teamsToModer(); $this->_lists["panel"] = $this->getePanel($this->_lists["teams_season"], 0, null, 0); //payments $this->options = new StdClass(); $this->options->paypal_email = getJS_Config('paypal_acc'); $this->options->paypalcur_val = getJS_Config('pllist_order'); $this->options->paypalval_val = getJS_Config('paypalval_val'); $this->options->paypalvalleast_val = getJS_Config('paypalvalleast_val'); $this->options->paypal_org = getJS_Config('paypal_org'); $query = "SELECT is_pay FROM #__bl_seasons WHERE published='1' AND s_id = " . $this->s_id; $this->db->setQuery($query); $this->options->paypal_on = $this->db->loadResult(); //$this->options->paypal_on = getJS_Config('paypal_on'); }
function TournTable() { $groups_exists = array(); $table_view = array(); $user = JFactory::getUser(); $teams_your_color = $this->getJS_Config('yteam_color'); $season_par = $this->_lists['season_par']; if ($this->t_single) { $query = "SELECT t.id,bonus_point,t.first_name,t.last_name,'' as t_yteam,t.nick" . " FROM #__bl_season_players as st, #__bl_players as t" . " WHERE t.id = st.player_id AND st.season_id = " . $this->s_id; } else { $query = "SELECT t.id,bonus_point,t.t_yteam,t.t_name,t.t_emblem" . " FROM #__bl_season_teams as st, #__bl_teams as t" . " WHERE t.id = st.team_id AND st.season_id = " . $this->s_id; } $this->db->setQuery($query); $teams = $this->db->loadObjectList(); $error = $this->db->getErrorMsg(); if ($error) { return JError::raiseError(500, $error); } ///////////////ext fld name if (!$this->t_single) { $query = "SELECT ef.name, ef.id FROM #__bl_extra_filds as ef WHERE ef.published=1 AND ef.type = '1' AND ef.e_table_view = '1' AND ef.fdisplay = '1' ORDER BY ef.ordering"; } else { $query = "SELECT ef.name, ef.id FROM #__bl_extra_filds as ef WHERE ef.published=1 AND ef.type = '0' AND ef.e_table_view = '1' AND ef.fdisplay = '1' ORDER BY ef.ordering"; } $this->db->setQuery($query); //$this->_lists["ext_fields_name"] = $this->db->loadObjectList(); $ext_fields_name = $this->db->loadObjectList(); $this->_lists["ext_fields_name"] = $ext_fields_name; // print_r($this->_lists["ext_fields_name"]); //exp $error = $this->db->getErrorMsg(); if ($error) { return JError::raiseError(500, $error); } $bonus_not = array(); for ($i = 0; $i < count($teams); $i++) { $tid = $teams[$i]->id; if ($this->t_single) { $teams_name = $this->selectPlayerName($teams[$i]); } else { $teams_name = $teams[$i]->t_name; } $teams_your = $teams[$i]->t_yteam; if ($this->t_single) { $query = "SELECT p.ph_name as name,p.id as id,p.ph_filename as filename FROM #__bl_assign_photos as ap, #__bl_photos as p WHERE ap.photo_id = p.id AND cat_type = 1 AND cat_id = " . $tid; $this->db->setQuery($query); $photos = $this->db->loadObjectList(); $error = $this->db->getErrorMsg(); if ($error) { return JError::raiseError(500, $error); } $query = "SELECT p.*,c.country,c.ccode FROM #__bl_players as p LEFT JOIN #__bl_countries as c ON c.id=p.country_id WHERE p.id = " . $tid; $this->db->setQuery($query); $players = $this->db->loadObjectList(); $player = $players[0]; $error = $this->db->getErrorMsg(); if ($error) { return JError::raiseError(500, $error); } $emblems = ''; if ($player->def_img) { $query = "SELECT ph_filename FROM #__bl_photos as p WHERE p.id = " . $player->def_img; $this->db->setQuery($query); $emblems = $this->db->loadResult(); } else { if (isset($photos[0])) { $emblems = $photos[0]->filename; } } } else { $emblems = $teams[$i]->t_emblem; } if ($this->t_single) { $query = "SELECT gr.g_id FROM #__bl_season_players as st, #__bl_grteams as gr, #__bl_groups as g WHERE g.s_id = " . $this->s_id . " AND g.id = gr.g_id AND gr.t_id = st.player_id AND st.season_id = " . $this->s_id . " AND st.player_id = " . $tid . " LIMIT 1"; } else { $query = "SELECT gr.g_id FROM #__bl_season_teams as st, #__bl_grteams as gr, #__bl_groups as g WHERE g.s_id = " . $this->s_id . " AND g.id = gr.g_id AND gr.t_id = st.team_id AND st.season_id = " . $this->s_id . " AND st.team_id = " . $tid . " LIMIT 1"; } $this->db->setQuery($query); $group_id = (int) $this->db->loadResult(); $error = $this->db->getErrorMsg(); if ($error) { return JError::raiseError(500, $error); } if (!in_array($group_id, $groups_exists) && $group_id) { if ($this->gr_id && $season_par->s_groups) { if ($this->gr_id == $group_id) { $groups_exists[] = $group_id; } } else { $groups_exists[] = $group_id; } } $this->_lists["gr_id"] = $this->gr_id; $teams[$i]->bonus_point; if ($teams[$i]->bonus_point && $teams[$i]->bonus_point != '0.00') { if (!isset($bonus_not[$group_id]) || !$bonus_not[$group_id]) { $bonus_not[$group_id] = $teams_name . " - " . $teams[$i]->bonus_point . "<br />"; } else { $bonus_not[$group_id] .= $teams_name . " - " . $teams[$i]->bonus_point . "<br />"; } } //var_dump($this->_lists['bonus_not']); // in groups $query = "SELECT t_id FROM #__bl_grteams WHERE t_id != " . $tid; $query .= $group_id ? " AND g_id = " . $group_id : ""; $this->db->setQuery($query); $gtid = $this->db->loadColumn(); //var_dump($gtid); //print_r($season_par->s_groups); if ($season_par->s_groups == 1) { //updt if (count($gtid)) { $query = "SELECT COUNT(*) FROM #__bl_matchday as md, #__bl_match as m WHERE m.m_id = md.id AND md.s_id = " . $this->s_id . " AND m.published = 1 AND ((" . $tid . " = m.team1_id AND m.score1 > m.score2 AND m.team2_id IN (" . implode(",", $gtid) . ")) OR (" . $tid . " = m.team2_id AND m.score1 < m.score2 AND m.team1_id IN (" . implode(",", $gtid) . ")) ) " . ($season_par->s_enbl_extra ? "" : " AND m.is_extra = 0") . " AND m.m_played = 1 AND md.is_playoff = 0 AND md.t_type = 0"; $this->db->setQuery($query); $wins_gr = $this->db->loadResult(); $error = $this->db->getErrorMsg(); if ($error) { return JError::raiseError(500, $error); } $query = "SELECT COUNT(*) FROM #__bl_matchday as md, #__bl_match as m WHERE m.m_id = md.id AND md.s_id = " . $this->s_id . " AND m.published = 1 AND ((" . $tid . " = m.team1_id AND m.score1 = m.score2 AND m.team2_id IN (" . implode(",", $gtid) . ")) OR (" . $tid . " = m.team2_id AND m.score1 = m.score2 AND m.team1_id IN (" . implode(",", $gtid) . ")) ) " . ($season_par->s_enbl_extra ? "" : " AND m.is_extra = 0") . " AND m.m_played = 1 AND md.is_playoff = 0 AND md.t_type = 0"; $this->db->setQuery($query); $draw_gr = $this->db->loadResult(); $error = $this->db->getErrorMsg(); if ($error) { return JError::raiseError(500, $error); } $query = "SELECT COUNT(*) FROM #__bl_matchday as md, #__bl_match as m WHERE m.m_id = md.id AND md.s_id = " . $this->s_id . " AND m.published = 1 AND ((" . $tid . " = m.team1_id AND m.score1 < m.score2 AND m.team2_id IN (" . implode(",", $gtid) . ")) OR (" . $tid . " = m.team2_id AND m.score1 > m.score2 AND m.team1_id IN (" . implode(",", $gtid) . ")) ) " . ($season_par->s_enbl_extra ? "" : " AND m.is_extra = 0") . " AND md.is_playoff = 0 AND m.m_played = 1 AND md.t_type = 0"; $this->db->setQuery($query); $loose_gr = $this->db->loadResult(); $error = $this->db->getErrorMsg(); if ($error) { return JError::raiseError(500, $error); } if ($wins_gr + $loose_gr + $draw_gr > 0) { $table_view[$i]['grwinpr_chk'] = ($wins_gr + $draw_gr / 2) / ($wins_gr + $loose_gr + $draw_gr); } else { $table_view[$i]['grwinpr_chk'] = 0; } } else { $wins_gr = 0; $loose_gr = 0; } } $query = "SELECT SUM(score1) as sc,SUM(score2) as rc FROM #__bl_matchday as md, #__bl_match as m WHERE m.m_id = md.id AND md.s_id = " . $this->s_id . " AND m.published = 1 AND md.is_playoff = 0 AND m.m_played = 1 AND md.t_type = 0 AND m.team1_id = " . $tid; $this->db->setQuery($query); $home = $this->db->loadObjectList(); $error = $this->db->getErrorMsg(); if ($error) { return JError::raiseError(500, $error); } $query = "SELECT SUM(score1) as rc,SUM(score2) as sc FROM #__bl_matchday as md, #__bl_match as m WHERE m.m_id = md.id AND md.s_id = " . $this->s_id . " AND m.published = 1 AND md.is_playoff = 0 AND m.m_played = 1 AND md.t_type = 0 AND m.team2_id = " . $tid; $this->db->setQuery($query); $away = $this->db->loadObjectList(); $error = $this->db->getErrorMsg(); if ($error) { return JError::raiseError(500, $error); } $query = "SELECT COUNT(*) FROM #__bl_matchday as md, #__bl_match as m WHERE m.m_id = md.id AND md.s_id = " . $this->s_id . " AND m.published = 1 AND (" . $tid . " = m.team1_id AND m.score1 > m.score2) AND m.is_extra = 0 AND m.m_played = 1 AND md.is_playoff = 0 AND md.t_type = 0"; $this->db->setQuery($query); $wins = $this->db->loadResult(); $query = "SELECT COUNT(*) FROM #__bl_matchday as md, #__bl_match as m WHERE m.m_id = md.id AND md.s_id = " . $this->s_id . " AND m.published = 1 AND (" . $tid . " = m.team1_id) AND m.score1 = m.score2 AND m.m_played = 1 AND md.is_playoff = 0 AND md.t_type = 0"; $this->db->setQuery($query); $drows = $this->db->loadResult(); $query = "SELECT COUNT(*) FROM #__bl_matchday as md, #__bl_match as m WHERE m.m_id = md.id AND md.s_id = " . $this->s_id . " AND m.published = 1 AND (" . $tid . " = m.team1_id AND m.score1 < m.score2) AND m.is_extra = 0 AND md.is_playoff = 0 AND m.m_played = 1 AND md.t_type = 0"; $this->db->setQuery($query); $loose = $this->db->loadResult(); $query = "SELECT SUM(bonus1) FROM #__bl_matchday as md, #__bl_match as m WHERE m.m_id = md.id AND md.s_id = " . $this->s_id . " AND m.published = 1 AND " . $tid . " = m.team1_id AND md.is_playoff = 0 AND m.m_played = 1 AND md.t_type = 0"; $this->db->setQuery($query); $bonus1 = $this->db->loadResult(); $query = "SELECT SUM(bonus2) FROM #__bl_matchday as md, #__bl_match as m WHERE m.m_id = md.id AND md.s_id = " . $this->s_id . " AND m.published = 1 AND " . $tid . " = m.team2_id AND md.is_playoff = 0 AND m.m_played = 1 AND md.t_type = 0"; $this->db->setQuery($query); $bonus2 = $this->db->loadResult(); $query = "SELECT COUNT(*) FROM #__bl_matchday as md, #__bl_match as m WHERE m.m_id = md.id AND md.s_id = " . $this->s_id . " AND m.published = 1 AND (m.team2_id = " . $tid . " AND m.score2 > m.score1) AND m.is_extra = 0 AND m.m_played = 1 AND md.is_playoff = 0 AND md.t_type = 0"; $this->db->setQuery($query); $wins_away = $this->db->loadResult(); $query = "SELECT COUNT(*) FROM #__bl_matchday as md, #__bl_match as m WHERE m.m_id = md.id AND md.s_id = " . $this->s_id . " AND m.published = 1 AND (" . $tid . " = m.team2_id) AND m.score1 = m.score2 AND m.m_played = 1 AND md.is_playoff = 0 AND md.t_type = 0"; $this->db->setQuery($query); $drows_away = $this->db->loadResult(); $query = "SELECT COUNT(*) FROM #__bl_matchday as md, #__bl_match as m WHERE m.m_id = md.id AND md.s_id = " . $this->s_id . " AND m.published = 1 AND (" . $tid . " = m.team2_id AND m.score2 < m.score1) AND m.is_extra = 0 AND md.is_playoff = 0 AND m.m_played = 1 AND md.t_type = 0"; $this->db->setQuery($query); $loose_away = $this->db->loadResult(); $query = "SELECT SUM(points1) FROM #__bl_matchday as md, #__bl_match as m WHERE m.m_id = md.id AND md.s_id = " . $this->s_id . " AND m.published = 1 AND " . $tid . " = m.team1_id AND md.is_playoff = 0 AND m.m_played = 1 AND m.new_points = '1' AND md.t_type = 0"; $this->db->setQuery($query); $homebonus = $this->db->loadResult(); $query = "SELECT SUM(points2) FROM #__bl_matchday as md, #__bl_match as m WHERE m.m_id = md.id AND md.s_id = " . $this->s_id . " AND m.published = 1 AND " . $tid . " = m.team2_id AND md.is_playoff = 0 AND m.m_played = 1 AND m.new_points = '1' AND md.t_type = 0"; $this->db->setQuery($query); $awabonus = $this->db->loadResult(); //--// $query = "SELECT COUNT(*) FROM #__bl_matchday as md, #__bl_match as m WHERE m.m_id = md.id AND md.s_id = " . $this->s_id . " AND m.published = 1 AND (" . $tid . " = m.team1_id AND m.score1 > m.score2) AND m.m_played = 1 AND m.is_extra = 0 AND md.is_playoff = 0 AND m.new_points = '0' AND md.t_type = 0"; $this->db->setQuery($query); $wins2 = $this->db->loadResult(); $query = "SELECT COUNT(*) FROM #__bl_matchday as md, #__bl_match as m WHERE m.m_id = md.id AND md.s_id = " . $this->s_id . " AND m.published = 1 AND (" . $tid . " = m.team1_id) AND m.score1 = m.score2 AND m.m_played = 1 AND md.is_playoff = 0 AND m.new_points = '0' AND md.t_type = 0"; $this->db->setQuery($query); $drows2 = $this->db->loadResult(); $query = "SELECT COUNT(*) FROM #__bl_matchday as md, #__bl_match as m WHERE m.m_id = md.id AND md.s_id = " . $this->s_id . " AND m.published = 1 AND (" . $tid . " = m.team1_id AND m.score1 < m.score2) AND md.is_playoff = 0 AND m.is_extra = 0 AND m.m_played = 1 AND m.new_points = '0' AND md.t_type = 0"; $this->db->setQuery($query); $loose2 = $this->db->loadResult(); $query = "SELECT COUNT(*) FROM #__bl_matchday as md, #__bl_match as m WHERE m.m_id = md.id AND md.s_id = " . $this->s_id . " AND m.published = 1 AND (m.team2_id = " . $tid . " AND m.score2 > m.score1) AND m.m_played = 1 AND md.is_playoff = 0 AND m.new_points = '0' AND m.is_extra = 0 AND md.t_type = 0"; $this->db->setQuery($query); $wins_away2 = $this->db->loadResult(); $query = "SELECT COUNT(*) FROM #__bl_matchday as md, #__bl_match as m WHERE m.m_id = md.id AND md.s_id = " . $this->s_id . " AND m.published = 1 AND (" . $tid . " = m.team2_id) AND m.score1 = m.score2 AND m.m_played = 1 AND md.is_playoff = 0 AND m.new_points = '0' AND md.t_type = 0"; $this->db->setQuery($query); $drows_away2 = $this->db->loadResult(); $query = "SELECT COUNT(*) FROM #__bl_matchday as md, #__bl_match as m WHERE m.m_id = md.id AND md.s_id = " . $this->s_id . " AND m.published = 1 AND (" . $tid . " = m.team2_id AND m.score2 < m.score1) AND md.is_playoff = 0 AND m.m_played = 1 AND m.new_points = '0' AND m.is_extra = 0 AND md.t_type = 0"; $this->db->setQuery($query); $loose_away2 = $this->db->loadResult(); //--// if ($season_par->s_enbl_extra) { $query = "SELECT COUNT(*) FROM #__bl_matchday as md, #__bl_match as m WHERE m.m_id = md.id AND md.s_id = " . $this->s_id . " AND m.published = 1 AND ((m.team2_id = " . $tid . " AND m.score2 > m.score1) OR (" . $tid . " = m.team1_id AND m.score1 > m.score2)) AND m.is_extra = 1 AND md.is_playoff = 0 AND m.m_played = 1 AND md.t_type = 0"; $this->db->setQuery($query); $wins_ext = $this->db->loadResult(); $query = "SELECT COUNT(*) FROM #__bl_matchday as md, #__bl_match as m WHERE m.m_id = md.id AND md.s_id = " . $this->s_id . " AND m.published = 1 AND ((" . $tid . " = m.team2_id AND m.score2 < m.score1) OR (" . $tid . " = m.team1_id AND m.score1 < m.score2)) AND m.is_extra = 1 AND md.is_playoff = 0 AND m.m_played = 1 AND md.t_type = 0"; $this->db->setQuery($query); $loose_ext = $this->db->loadResult(); } $table_view[$i]['g_id'] = $season_par->s_groups ? $group_id : 0; $table_view[$i]['tid'] = $tid; $table_view[$i]['name'] = $teams_name; $table_view[$i]['played_chk'] = $wins + $drows + $loose + $wins_away + $drows_away + $loose_away + ($season_par->s_enbl_extra ? $wins_ext + $loose_ext : 0); $table_view[$i]['win_chk'] = $wins + $wins_away; $table_view[$i]['draw_chk'] = $drows + $drows_away; $table_view[$i]['lost_chk'] = $loose + $loose_away; if ($season_par->s_enbl_extra) { $table_view[$i]['otwin_chk'] = $wins_ext; $table_view[$i]['otlost_chk'] = $loose_ext; } $table_view[$i]['diff_chk'] = $home[0]->sc + $away[0]->sc . ' - ' . ($home[0]->rc + $away[0]->rc); $table_view[$i]['gd_chk'] = $home[0]->sc + $away[0]->sc - ($home[0]->rc + $away[0]->rc); $table_view[$i]['point_chk'] = $wins2 * $season_par->s_win_point + $wins_away2 * $season_par->s_win_away + ($drows2 * $season_par->s_draw_point + $drows_away2 * $season_par->s_draw_away) + ($loose2 * $season_par->s_lost_point + $loose_away2 * $season_par->s_lost_away) + $homebonus + $awabonus + $bonus1 + $bonus2 + $teams[$i]->bonus_point + ($season_par->s_enbl_extra ? $wins_ext * $season_par->s_extra_win + $loose_ext * $season_par->s_extra_lost : 0); $table_view[$i]['goalscore_chk'] = $home[0]->sc + $away[0]->sc; $table_view[$i]['yteam'] = $teams_your ? $teams_your_color : ''; if ($table_view[$i]['played_chk']) { $table_view[$i]['percent_chk'] = ($wins + $wins_away + ($season_par->s_enbl_extra && isset($wins_ext) ? $wins_ext : 0) + $table_view[$i]['draw_chk'] / 2) / $table_view[$i]['played_chk']; } else { $table_view[$i]['percent_chk'] = 0; } if (!$this->t_single) { $query = "SELECT * FROM #__bl_extra_filds as ef LEFT JOIN #__bl_extra_values as ev ON ef.id=ev.f_id AND ev.uid=" . $tid . " WHERE ef.published=1 AND ef.type = '1' AND ef.e_table_view = '1' AND ef.fdisplay = '1' " . ($user->get('guest') ? " AND ef.faccess='0'" : "") . " AND ((ef.season_related = 0 AND ev.season_id=0) OR (ef.season_related = 1 AND ev.season_id='" . $this->s_id . "' AND ev.season_id != 0)) ORDER BY ef.ordering"; } else { $query = "SELECT * FROM #__bl_extra_filds as ef LEFT JOIN #__bl_extra_values as ev ON ef.id=ev.f_id AND ev.uid=" . $tid . " WHERE ef.published=1 AND ef.type = '0' AND ef.e_table_view = '1' AND ef.fdisplay = '1' " . ($user->get('guest') ? " AND ef.faccess='0'" : "") . " AND ((ef.season_related = 0 AND ev.season_id=0) OR (ef.season_related = 1 AND ev.season_id='" . $this->s_id . "' AND ev.season_id != 0)) ORDER BY ef.ordering"; } // print_r($query); echo "<hr>"; $this->db->setQuery($query); $lists['ext_fields'] = $this->db->loadObjectList(); //print_r($lists['ext_fields']); echo "<hr>"; $error = $this->db->getErrorMsg(); if ($error) { return JError::raiseError(500, $error); } $mj = 0; if (isset($lists['ext_fields'])) { for ($j = 0; $j < count($ext_fields_name); $j++) { foreach ($lists['ext_fields'] as $extr) { if ($ext_fields_name[$j]->id == $extr->id) { if ($extr->field_type == '3') { $query = "SELECT sel_value FROM #__bl_extra_select WHERE id='" . $extr->fvalue . "'"; $this->db->setQuery($query); $selvals = $this->db->loadResult(); if (isset($selvals) && $selvals) { $ext_pl[$mj] = $selvals; } else { $ext_pl[$mj] = ' '; } } else { if ($extr->field_type == '1') { $ext_pl[$mj] = $extr->fvalue ? JText::_("Yes") : JText::_("No"); } else { if ($extr->field_type == '2') { $ext_pl[$mj] = $extr->fvalue_text ? $extr->fvalue_text : ' '; } else { $ext_pl[$mj] = $extr->fvalue ? $extr->fvalue : " "; } } } if ($extr->field_type == '4' && $extr->fvalue) { $ext_pl[$mj] = "<a target='_blank' href='" . (substr($extr->fvalue, 0, 7) == 'http://' ? $extr->fvalue : "http://" . $extr->fvalue) . "'>" . $extr->fvalue . "</a>"; } if ($ext_pl[$mj] == NULL) { $ext_pl[$mj] = ' '; } $table_view[$i]['ext_fields'][$j] = $ext_pl[$mj]; } $mj++; } } } $table_view[$i]['avulka_v'] = ''; $table_view[$i]['avulka_cf'] = ''; $table_view[$i]['avulka_cs'] = ''; $table_view[$i]['avulka_qc'] = ''; $table_view[$i]['t_emblem'] = $emblems; ///2.0.7 $table_view[$i]['goalscore_chk'] = $home[0]->sc + $away[0]->sc; $table_view[$i]['goalconc_chk'] = $home[0]->rc + $away[0]->rc; $table_view[$i]['winhome_chk'] = $wins; $table_view[$i]['drawhome_chk'] = $drows; $table_view[$i]['losthome_chk'] = $loose; $table_view[$i]['winaway_chk'] = $wins_away; $table_view[$i]['drawaway_chk'] = $drows_away; $table_view[$i]['lostaway_chk'] = $loose_away; $table_view[$i]['pointshome_chk'] = $wins2 * $season_par->s_win_point + $drows2 * $season_par->s_draw_point + $loose2 * $season_par->s_lost_point + $homebonus + $bonus1; $table_view[$i]['pointsaway_chk'] = $wins_away2 * $season_par->s_win_away + $drows_away2 * $season_par->s_draw_away + $loose_away2 * $season_par->s_lost_away + $awabonus + $bonus2; ///in groups if ($season_par->s_groups) { $table_view[$i]['grwin_chk'] = $wins_gr; $table_view[$i]['grlost_chk'] = $loose_gr; } //updt //$this->_lists['value_extra'] .= $table_view[$i]['ext_fields']; } //---playeachother---/// $query = "SELECT opt_value FROM #__bl_season_option WHERE s_id = " . $this->s_id . " AND opt_name='equalpts_chk'"; $this->db->setQuery($query); $equalpts_chk = $this->db->loadResult(); if ($equalpts_chk) { $pts_arr = array(); $pts_equal = array(); foreach ($table_view as $tv) { if (!in_array($tv['point_chk'], $pts_arr)) { $pts_arr[] = $tv['point_chk']; } else { if (!in_array($tv['point_chk'], $pts_equal)) { $pts_equal[] = $tv['point_chk']; } } } $k = 0; $team_arr = array(); foreach ($pts_equal as $pts) { foreach ($table_view as $tv) { if ($tv['point_chk'] == $pts) { $team_arr[$k][] = $tv['tid']; } } $k++; } foreach ($team_arr as $tm) { foreach ($tm as $tm_one) { $query = "SELECT COUNT(*) FROM #__bl_matchday as md, #__bl_match as m, #__bl_teams as t1, #__bl_teams as t2 WHERE m.m_id = md.id AND m.published = 1 AND md.s_id=" . $this->s_id . " AND m.team1_id = t1.id AND m.team2_id = t2.id AND m.m_played=1 AND md.t_type = 0 AND ((t1.id = " . $tm_one . " AND m.score1>m.score2 AND t2.id IN (" . implode(',', $tm) . ")) OR (t2.id=" . $tm_one . " AND m.score1<m.score2 AND t1.id IN (" . implode(',', $tm) . ")))"; $this->db->setQuery($query); $matchs_avulsa_win = $this->db->loadResult(); $query = "SELECT COUNT(*) FROM #__bl_matchday as md, #__bl_match as m, #__bl_teams as t1, #__bl_teams as t2 WHERE m.m_id = md.id AND m.published = 1 AND md.s_id=" . $this->s_id . " AND m.team1_id = t1.id AND m.team2_id = t2.id AND m.m_played=1 AND md.t_type = 0 AND ((t1.id = " . $tm_one . " AND m.score1=m.score2 AND t2.id IN (" . implode(',', $tm) . ")) OR (t2.id=" . $tm_one . " AND m.score1=m.score2 AND t1.id IN (" . implode(',', $tm) . ")))"; $this->db->setQuery($query); $matchs_avulsa_win_c = 3 * $matchs_avulsa_win + $this->db->loadResult(); $tm_equal_win = array(); foreach ($tm as $tm_other) { $query = "SELECT COUNT(*) FROM #__bl_matchday as md, #__bl_match as m, #__bl_teams as t1, #__bl_teams as t2 WHERE m.m_id = md.id AND m.published = 1 AND md.s_id=" . $this->s_id . " AND m.team1_id = t1.id AND m.team2_id = t2.id AND m.m_played=1 AND md.t_type = 0 AND ((t1.id = " . $tm_other . " AND m.score1>m.score2 AND t2.id IN (" . implode(',', $tm) . ")) OR (t2.id=" . $tm_other . " AND m.score1<m.score2 AND t1.id IN (" . implode(',', $tm) . ")))"; $this->db->setQuery($query); $matchs_avulsa_win_other = $this->db->loadResult(); if ($matchs_avulsa_win_other == $matchs_avulsa_win) { $tm_equal_win[] = $tm_other; } } $query = "SELECT SUM(score1) as sh,SUM(score2) as sw FROM #__bl_matchday as md, #__bl_match as m, #__bl_teams as t1, #__bl_teams as t2 WHERE m.m_id = md.id AND m.published = 1 AND m.m_played=1 AND md.s_id=" . $this->s_id . " AND m.team1_id = t1.id AND m.team2_id = t2.id AND md.t_type = 0 AND ((t1.id = " . $tm_one . " AND t2.id IN (" . implode(',', $tm_equal_win) . ")))"; $this->db->setQuery($query); $matchs_avulsa_score = $this->db->loadRow(); //var_dump($matchs_avulsa_score); $query = "SELECT SUM(score2) as sh,SUM(score1) as sw FROM #__bl_matchday as md, #__bl_match as m, #__bl_teams as t1, #__bl_teams as t2 WHERE m.m_id = md.id AND m.published = 1 AND m.m_played=1 AND md.s_id=" . $this->s_id . " AND m.team1_id = t1.id AND m.team2_id = t2.id AND md.t_type = 0 AND ((t2.id=" . $tm_one . " AND t1.id IN (" . implode(',', $tm_equal_win) . ")))"; $this->db->setQuery($query); $matchs_avulsa_rec = $this->db->loadRow(); $matchs_avulsa_res = intval($matchs_avulsa_score[0]) + intval($matchs_avulsa_rec[0]); $matchs_avulsa_res2 = intval($matchs_avulsa_score[1]) + intval($matchs_avulsa_rec[1]); for ($b = 0; $b < count($table_view); $b++) { if ($table_view[$b]['tid'] == $tm_one) { $table_view[$b]['avulka_v'] = $matchs_avulsa_win_c; $table_view[$b]['avulka_cf'] = $matchs_avulsa_res; $table_view[$b]['avulka_cs'] = $matchs_avulsa_res2; $table_view[$b]['avulka_qc'] = $matchs_avulsa_res - $matchs_avulsa_res2; } } } } } //--/playeachother---/// $sort_arr = array(); foreach ($table_view as $uniqid => $row) { foreach ($row as $key => $value) { $sort_arr[$key][$uniqid] = $value; } } if (count($groups_exists)) { $query = "SELECT id FROM #__bl_groups WHERE id IN (" . implode(',', $groups_exists) . ") ORDER BY ordering"; $this->db->setQuery($query); $groups_exists = $this->db->loadColumn(); //sort($groups_exists, SORT_NUMERIC); } if (!$season_par->s_groups) { $groups_exists = array(0); } $this->_lists["groups"] = $groups_exists; if (count($sort_arr)) { // sort fields 1-points, 2-wins percent, /*3-if equal between teams*/, 4-goal difference, 5-goal score $query = "SELECT * FROM #__bl_ranksort WHERE seasonid=" . $this->s_id . " ORDER BY ordering"; $this->db->setQuery($query); $savedsort = $this->db->loadObjectList(); $argsort = array(); $argsort_way = array(); if (count($savedsort)) { foreach ($savedsort as $sortop) { switch ($sortop->sort_field) { case '1': $argsort[][0] = $sort_arr['point_chk']; break; case '2': $argsort[][0] = $sort_arr['percent_chk']; break; case '3': $argsort[][0] = $sort_arr['point_chk']; break; /* not used */ /* not used */ case '4': $argsort[][0] = $sort_arr['gd_chk']; break; case '5': $argsort[][0] = $sort_arr['goalscore_chk']; break; case '6': $argsort[][0] = $sort_arr['played_chk']; break; case '7': $argsort[][0] = $sort_arr['win_chk']; break; } $argsort_way[] = $sortop->sort_way; } } //var_dump($argsort); if ($equalpts_chk) { //var_dump($sort_arr['avulka_v']); array_multisort($sort_arr['g_id'], SORT_ASC, $sort_arr['point_chk'], SORT_DESC, $sort_arr['avulka_v'], SORT_DESC, $sort_arr['avulka_qc'], SORT_DESC, $sort_arr['avulka_cf'], SORT_DESC, $sort_arr['gd_chk'], SORT_DESC, $sort_arr['goalscore_chk'], SORT_DESC, $table_view); } else { array_multisort($sort_arr['g_id'], SORT_ASC, isset($argsort[0][0]) ? $argsort[0][0] : $sort_arr['point_chk'], isset($argsort_way[0]) ? $argsort_way[0] ? SORT_ASC : SORT_DESC : SORT_DESC, isset($argsort[1][0]) ? $argsort[1][0] : $sort_arr['gd_chk'], isset($argsort_way[1]) ? $argsort_way[1] ? SORT_ASC : SORT_DESC : SORT_DESC, isset($argsort[2][0]) ? $argsort[2][0] : $sort_arr['goalscore_chk'], isset($argsort_way[2]) ? $argsort_way[2] ? SORT_ASC : SORT_DESC : SORT_DESC, isset($argsort[3][0]) ? $argsort[3][0] : $sort_arr['win_chk'], isset($argsort_way[3]) ? $argsort_way[3] ? SORT_ASC : SORT_DESC : SORT_DESC, $table_view); } } $this->_lists["v_table"] = $table_view; /////playoffs $pln = getJS_Config('player_name'); if ($this->t_single) { $query = "SELECT m.*,m.id as mid," . ($pln ? "IF(t.nick<>'',t.nick,CONCAT(t.first_name,' ',t.last_name))" : "CONCAT(t.first_name,' ',t.last_name)") . " AS home," . " " . ($pln ? "IF(t2.nick<>'',t2.nick,CONCAT(t2.first_name,' ',t2.last_name))" : "CONCAT(t2.first_name,' ',t2.last_name)") . " AS away, md.m_name, m.is_extra " . " FROM #__bl_matchday as md, #__bl_match as m, #__bl_players as t, #__bl_players as t2" . " WHERE m.m_id = md.id AND md.s_id = " . $this->s_id . " AND m.published = 1 AND md.is_playoff = 1 AND t.id = m.team1_id AND t2.id = m.team2_id AND md.t_type = 0" . " ORDER BY md.id,m.id"; } else { $query = "SELECT m.*,m.id as mid,t.t_name as home, t2.t_name as away, md.m_name, m.is_extra, t.t_emblem as emb1,t2.t_emblem as emb2 FROM #__bl_matchday as md, #__bl_match as m, #__bl_teams as t, #__bl_teams as t2 WHERE m.m_id = md.id AND md.s_id = " . $this->s_id . " AND m.published = 1 AND md.is_playoff = 1 AND t.id = m.team1_id AND t2.id = m.team2_id AND md.t_type = 0 ORDER BY md.id,m.id"; } $this->db->setQuery($query); $this->_lists["playoffs"] = $this->db->loadObjectList(); $error = $this->db->getErrorMsg(); if ($error) { return JError::raiseError(500, $error); } //var_dump($groups_exists);die; $query = "SELECT group_name FROM #__bl_groups WHERE id IN(" . (count($groups_exists) ? implode(',', $groups_exists) : "''") . ") ORDER BY ordering"; $this->db->setQuery($query); $this->_lists["groups_name"] = $this->db->loadColumn(); $this->_lists["enbl_gr"] = $season_par->s_groups; $this->_lists["enbl_extra"] = $season_par->s_enbl_extra; /*if(!$this->t_single){ $query = "SELECT ef.name FROM #__bl_extra_filds as ef WHERE ef.published=1 AND ef.type = '1' AND ef.e_table_view = '1' AND ef.fdisplay = '1' ORDER BY ef.ordering"; }else{ $query = "SELECT ef.name FROM #__bl_extra_filds as ef WHERE ef.published=1 AND ef.type = '0' AND ef.e_table_view = '1' AND ef.fdisplay = '1' ORDER BY ef.ordering"; } $this->db->setQuery($query); $this->_lists["ext_fields_name"] = $this->db->loadColumn(); $error = $this->db->getErrorMsg(); if ($error) { return JError::raiseError(500, $error); }*/ $this->_lists['bonus_not'] = isset($bonus_not) ? $bonus_not : ''; //----colors----// $query = "SELECT * FROM #__bl_tblcolors WHERE s_id=" . $this->s_id . " ORDER BY place"; $this->db->setQuery($query); $colors = $this->db->loadObjectList(); $error = $this->db->getErrorMsg(); if ($error) { return JError::raiseError(500, $error); } $color_mass = array(); for ($j = 0; $j < count($colors); $j++) { $tmp_pl = $colors[$j]->place; $color_mass[intval($colors[$j]->place)] = $colors[$j]->color; $tmp_arr = explode(',', $tmp_pl); $tmp_arr2 = explode('-', $tmp_pl); if (count($tmp_arr) > 1) { foreach ($tmp_arr as $arr) { if (intval($arr)) { $color_mass[intval($arr)] = $colors[$j]->color; } } } if (count($tmp_arr2) > 1) { for ($zzz = $tmp_arr2[0]; $zzz < $tmp_arr2[1] + 1; $zzz++) { $color_mass[$zzz] = $colors[$j]->color; } } } $this->_lists["colors"] = $color_mass; }