"; } $text =""; //$LOGO_X=$pref['sport_league_logo_w_menu']; //$LOGO_Y=$pref['sport_league_logo_h_menu']; $LOGO_X="70"; $LOGO_Y="70"; $TAX=$LOGO_X; $COLS=2; /////////////////////////////////// $expand_autohide = "display:none; "; if(e_QUERY) { list($Saison, $liga, $from) = explode(".", e_QUERY); $Saison = intval($Saison); $liga = intval($liga); $from = intval($from); unset($tmp); } if(!$Saison) { $Saison=$pref['league_my_saison']; } $qry1=" SELECT a.*, ae.* FROM ".MPREFIX."league_saison AS a LEFT JOIN ".MPREFIX."league_leagues AS ae ON ae.league_saison_id=a.saison_id WHERE a.saison_id='".$Saison."' "; if($liga) { $qry1.=" AND ae.league_id='".$liga."' LIMIT 1"; } $sql->db_Select_gen($qry1); $saisoncount=0; while($row = $sql-> db_Fetch()) { $SAISON[$saisoncount]['league_name']=$row['league_name']; $SAISON[$saisoncount]['saison_name']=$row['saison_name']; $SAISON[$saisoncount]['saison_id']=$row['saison_id']; $SAISON[$saisoncount]['league_id']=$row['league_id']; $saisoncount++; } if($saisoncount > 0) { for($JS=0; $JS < $saisoncount;$JS++ ) { if(ADMIN){ $Ligatext =" ".$SAISON[$JS]['league_name']." (".$SAISON[$JS]['saison_name'].")"; } else{ $Ligatext ="".$SAISON[$JS]['league_name']." (".$SAISON[$JS]['saison_name'].")"; } $sql -> db_Select("league_leagueteams", "*","leagueteam_league_id='".$SAISON[$JS]['league_id']."'"); $count[$JS]=0; while($row = $sql-> db_Fetch()) { $TEAM[$JS][0][$count[$JS]]=$row['leagueteam_team_id']; $TEAM[$JS][26][$count[$JS]]=$row['leagueteam_id']; $TEAM[$JS][27][$count[$JS]]=$row['leagueteam_my_team']; $count[$JS]++; } for($i=0;$i < $count[$JS]; $i++){ $sql -> db_Select("league_teams", "*","team_id='".$TEAM[$JS][0][$i]."' LIMIT 1"); while($row = $sql-> db_Fetch()) { $TEAM[$JS][25][$i]=$row['team_id']; $TEAM[$JS][1][$i]=$row['team_icon']; $TEAM[$JS][2][$i]=$row['team_url']; $TEAM[$JS][24][$i]=$row['team_name']; if($pref['sport_league_teamname_menu']==2){$TEAM[$JS][3][$i]=$row['team_kurzname'];} else{$TEAM[$JS][3][$i]=$row['team_name'];} } } /////////////-------//////////////////////////// for($i=0;$i < $count[$JS]; $i++){ $TEAM[$JS][4][$i]= 0; ///ET Home $TEAM[$JS][5][$i]= 0; ///GT Home $TEAM[$JS][6][$i]= 0; ///Points $TEAM[$JS][7][$i]= 0; ///ET Gast $TEAM[$JS][8][$i]= 0; ///GT Gast $TEAM[$JS][9][$i]= 0; ///ET $TEAM[$JS][10][$i]= 0; ///GT $TEAM[$JS][11][$i]= 0; ///Diff $TEAM[$JS][12][$i]= 0; ///Anzahl Games Home $TEAM[$JS][13][$i]= 0; ///Anzahl Games Gast $TEAM[$JS][14][$i]= 0; ///Games $TEAM[$JS][15][$i]= 0; ///Win Home $TEAM[$JS][16][$i]= 0; ///Lost Home $TEAM[$JS][17][$i]= 0; ///Un Home $TEAM[$JS][18][$i]= 0; ///Win Gast $TEAM[$JS][19][$i]= 0; ///Lost Gast $TEAM[$JS][20][$i]= 0; ///Un Gast $TEAM[$JS][21][$i]= 0; ///Win $TEAM[$JS][22][$i]= 0; ///Lost $TEAM[$JS][23][$i]= 0; ///Un $TEAM[$JS][28][$i]= 0; ///P G $TEAM[$JS][29][$i]= 0; ///P H } ////////////////////// Punkte Rechnen ///////////////////////////////////// for($i=0;$i<($count[$JS]);$i++) { $sql -> db_Select("league_games","*","game_enable=1 and game_home_id=".$TEAM[$JS][26][$i].""); while($row = $sql-> db_Fetch()) { $TEAM[$JS][4][$i]=$TEAM[$JS][4][$i]+$row['game_goals_home']; $TEAM[$JS][5][$i]=$TEAM[$JS][5][$i]+$row['game_goals_gast']; $TEAM[$JS][12][$i]=$TEAM[$JS][12][$i]+1; if($row['game_goals_home']> $row['game_goals_gast']) { if($row['game_un']==true) { $TEAM[$JS][6][$i]=$TEAM[$JS][6][$i]+$pref['sport_league_points_winer2']; /// Points $TEAM[$JS][29][$i]=$TEAM[$JS][29][$i]+$pref['sport_league_points_winer2']; //$TEAM[$JS][15][$i]=$TEAM[$JS][15][$i]+1; $TEAM[$JS][17][$i]=$TEAM[$JS][17][$i]+1; //Un Home } else { $TEAM[$JS][6][$i]=$TEAM[$JS][6][$i]+$pref['sport_league_points_winer']; $TEAM[$JS][29][$i]=$TEAM[$JS][29][$i]+$pref['sport_league_points_winer']; $TEAM[$JS][15][$i]=$TEAM[$JS][15][$i]+1; } } elseif($row['game_goals_gast']==$row['game_goals_home']) { $TEAM[$JS][6][$i]=$TEAM[$JS][6][$i]+$pref['sport_league_game_unistun']; $TEAM[$JS][29][$i]=$TEAM[$JS][29][$i]+$pref['sport_league_game_unistun']; $TEAM[$JS][17][$i]=$TEAM[$JS][17][$i]+1; } else { if($row['game_un']==true) { $TEAM[$JS][6][$i]=$TEAM[$JS][6][$i]+$pref['sport_league_points_louser2']; $TEAM[$JS][29][$i]=$TEAM[$JS][29][$i]+$pref['sport_league_points_louser2']; //$TEAM[$JS][16][$i]=$TEAM[$JS][16][$i]+1; $TEAM[$JS][17][$i]=$TEAM[$JS][17][$i]+1; } else { $TEAM[$JS][6][$i]=$TEAM[$JS][6][$i]+$pref['sport_league_points_louser']; $TEAM[$JS][29][$i]=$TEAM[$JS][29][$i]+$pref['sport_league_points_louser']; $TEAM[$JS][16][$i]=$TEAM[$JS][16][$i]+1; } } } $sql -> db_Select("league_games","*","game_enable=1 and game_gast_id=".$TEAM[$JS][26][$i].""); while($row = $sql-> db_Fetch()) { $TEAM[$JS][7][$i]=$TEAM[$JS][7][$i]+$row['game_goals_gast']; $TEAM[$JS][8][$i]=$TEAM[$JS][8][$i]+$row['game_goals_home']; $TEAM[$JS][13][$i]=$TEAM[$JS][13][$i]+1; if($row['game_goals_gast']> $row['game_goals_home']) { if($row['game_un']==true) { $TEAM[$JS][6][$i]=$TEAM[$JS][6][$i]+$pref['sport_league_points_winer2']; $TEAM[$JS][28][$i]=$TEAM[$JS][28][$i]+$pref['sport_league_points_winer2']; //$TEAM[$JS][18][$i]=$TEAM[$JS][18][$i]+1; $TEAM[$JS][20][$i]=$TEAM[$JS][20][$i]+1; } else { $TEAM[$JS][6][$i]=$TEAM[$JS][6][$i]+$pref['sport_league_points_winer']; $TEAM[$JS][28][$i]=$TEAM[$JS][28][$i]+$pref['sport_league_points_winer']; $TEAM[$JS][18][$i]=$TEAM[$JS][18][$i]+1; } } elseif($row['game_goals_gast']==$row['game_goals_home']) { $TEAM[$JS][6][$i]=$TEAM[$JS][6][$i]+$pref['sport_league_game_unistun']; $TEAM[$JS][28][$i]=$TEAM[$JS][28][$i]+$pref['sport_league_game_unistun']; $TEAM[$JS][20][$i]=$TEAM[$JS][20][$i]+1; } else { if($row['game_un']==true) { $TEAM[$JS][6][$i]=$TEAM[$JS][6][$i]+$pref['sport_league_points_louser2']; $TEAM[$JS][28][$i]=$TEAM[$JS][28][$i]+$pref['sport_league_points_louser2']; //$TEAM[$JS][19][$i]=$TEAM[$JS][19][$i]+1; $TEAM[$JS][20][$i]=$TEAM[$JS][20][$i]+1; } else { $TEAM[$JS][6][$i]=$TEAM[$JS][6][$i]+$pref['sport_league_points_louser']; $TEAM[$JS][28][$i]=$TEAM[$JS][28][$i]+$pref['sport_league_points_louser']; $TEAM[$JS][19][$i]=$TEAM[$JS][19][$i]+1; } } } } /////////////Eigen/Gegen- Tore und Spiele und Diff Ausrechnen ///////////////// for($i=0;$i<($count[$JS]);$i++) { $TEAM[$JS][9][$i]= $TEAM[$JS][4][$i]+$TEAM[$JS][7][$i]; ///ET Total $TEAM[$JS][10][$i]= $TEAM[$JS][5][$i]+$TEAM[$JS][8][$i]; ///GT Total $TEAM[$JS][14][$i]= $TEAM[$JS][12][$i]+$TEAM[$JS][13][$i]; ///Anzahl Games Total $TEAM[$JS][11][$i]= $TEAM[$JS][9][$i]-$TEAM[$JS][10][$i]; ///Dif Total $TEAM[$JS][21][$i]= $TEAM[$JS][15][$i]+$TEAM[$JS][18][$i]; ///Wins Total $TEAM[$JS][23][$i]= $TEAM[$JS][17][$i]+$TEAM[$JS][20][$i]; ///Un Total $TEAM[$JS][22][$i]= $TEAM[$JS][16][$i]+$TEAM[$JS][19][$i]; ///Lost Total $TEAM[$JS][30][$i]= $TEAM[$JS][4][$i]-$TEAM[$JS][5][$i]; ///Dif Home $TEAM[$JS][31][$i]= $TEAM[$JS][7][$i]-$TEAM[$JS][8][$i]; ///Dif Gast } /////////////////////////////////// $text .="
".$Ligatext."
  ".LAN_LEAGUE_TABLE_27."
  ".LAN_LEAGUE_TABLE_26."
  ".LAN_LEAGUE_TABLE_23."
  ".LAN_LEAGUE_TABLE_25."
"; $text .=""; for($i=0; $i < $count[$JS]; $i++) { $text .=""; if(($i+1)%($COLS)==0){$text .="";} } $text .="
"; $text .=team_data($TEAM[$JS][26][$i], $TEAM[$JS][3][$i], $SAISON[$JS]['league_id'], $TEAM[$JS][1][$i], $LOGO_Y, $LOGO_X, $TEAM[$JS][2][$i]); $text .="
"; $text .="
"; } } /// Respektiere fremde Arbeit und lasse diesen Text mit dem Link auf die Seite der Entwickler. /// Denn nicht nur Du solltest von diese Arbeit profitieren, mach diese Arbeit Bekannt. /// Nur so kann eine vernünftige und stabile Entwicklung/Support aufgebaut werden! Danke!!! $text .=powered_by(); /// ========================================================================================= $text .=""; $title = LAN_LEAGUE_TABLE_22; $title .= $SAISON[0]['saison_name']; $From="league_table.php?1.1"; $ns -> tablerender($title, $text); // ========= End of the BODY =================================================== require_once(FOOTERF); ?>