Exemple #1
0
 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;
 }
Exemple #2
0
 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');
 }
Exemple #4
0
 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] = '&nbsp;';
                             }
                         } 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 : '&nbsp;';
                                 } else {
                                     $ext_pl[$mj] = $extr->fvalue ? $extr->fvalue : "&nbsp;";
                                 }
                             }
                         }
                         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] = '&nbsp;';
                         }
                         $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;
 }