Menu
▾
▴
[xoops-svn] SF.net SVN: xoops:[9127] XoopsModules
|
From: <be...@us...> - 2012-03-14 09:32:58
|
Revision: 9127
http://xoops.svn.sourceforge.net/xoops/?rev=9127&view=rev
Author: beckmi
Date: 2012-03-14 09:32:43 +0000 (Wed, 14 Mar 2012)
Log Message:
-----------
Adding xRoster and TPL League Stats
Added Paths:
-----------
XoopsModules/tplleaguestats/
XoopsModules/tplleaguestats/branches/
XoopsModules/tplleaguestats/releases/
XoopsModules/tplleaguestats/trunk/
XoopsModules/tplleaguestats/trunk/tplleaguestats/
XoopsModules/tplleaguestats/trunk/tplleaguestats/admin/
XoopsModules/tplleaguestats/trunk/tplleaguestats/admin/head.php
XoopsModules/tplleaguestats/trunk/tplleaguestats/admin/index.php
XoopsModules/tplleaguestats/trunk/tplleaguestats/admin/leaguematches.php
XoopsModules/tplleaguestats/trunk/tplleaguestats/admin/menu.php
XoopsModules/tplleaguestats/trunk/tplleaguestats/admin/opponents.php
XoopsModules/tplleaguestats/trunk/tplleaguestats/admin/seasons.php
XoopsModules/tplleaguestats/trunk/tplleaguestats/blocks/
XoopsModules/tplleaguestats/trunk/tplleaguestats/blocks/index.html
XoopsModules/tplleaguestats/trunk/tplleaguestats/blocks/minitable.php
XoopsModules/tplleaguestats/trunk/tplleaguestats/bottom.txt
XoopsModules/tplleaguestats/trunk/tplleaguestats/change.php
XoopsModules/tplleaguestats/trunk/tplleaguestats/docs/
XoopsModules/tplleaguestats/trunk/tplleaguestats/docs/license.txt
XoopsModules/tplleaguestats/trunk/tplleaguestats/docs/manual_eng.txt
XoopsModules/tplleaguestats/trunk/tplleaguestats/docs/manual_ita.txt
XoopsModules/tplleaguestats/trunk/tplleaguestats/docs/readme_eng.txt
XoopsModules/tplleaguestats/trunk/tplleaguestats/docs/readme_ita.txt
XoopsModules/tplleaguestats/trunk/tplleaguestats/headtohead.php
XoopsModules/tplleaguestats/trunk/tplleaguestats/images/
XoopsModules/tplleaguestats/trunk/tplleaguestats/images/empty.gif
XoopsModules/tplleaguestats/trunk/tplleaguestats/images/line.gif
XoopsModules/tplleaguestats/trunk/tplleaguestats/images/tplleague_slogo.png
XoopsModules/tplleaguestats/trunk/tplleaguestats/index.php
XoopsModules/tplleaguestats/trunk/tplleaguestats/language/
XoopsModules/tplleaguestats/trunk/tplleaguestats/language/english/
XoopsModules/tplleaguestats/trunk/tplleaguestats/language/english/admin.php
XoopsModules/tplleaguestats/trunk/tplleaguestats/language/english/blocks.php
XoopsModules/tplleaguestats/trunk/tplleaguestats/language/english/index.html
XoopsModules/tplleaguestats/trunk/tplleaguestats/language/english/main.php
XoopsModules/tplleaguestats/trunk/tplleaguestats/language/english/modinfo.php
XoopsModules/tplleaguestats/trunk/tplleaguestats/language/italian/
XoopsModules/tplleaguestats/trunk/tplleaguestats/language/italian/admin.php
XoopsModules/tplleaguestats/trunk/tplleaguestats/language/italian/blocks.php
XoopsModules/tplleaguestats/trunk/tplleaguestats/language/italian/index.html
XoopsModules/tplleaguestats/trunk/tplleaguestats/language/italian/main.php
XoopsModules/tplleaguestats/trunk/tplleaguestats/language/italian/modinfo.php
XoopsModules/tplleaguestats/trunk/tplleaguestats/notes.txt
XoopsModules/tplleaguestats/trunk/tplleaguestats/season.php
XoopsModules/tplleaguestats/trunk/tplleaguestats/sql/
XoopsModules/tplleaguestats/trunk/tplleaguestats/sql/mysql.sql
XoopsModules/tplleaguestats/trunk/tplleaguestats/xoops_version.php
XoopsModules/xroster/
XoopsModules/xroster/branches/
XoopsModules/xroster/releases/
XoopsModules/xroster/trunk/
XoopsModules/xroster/trunk/xroster/
XoopsModules/xroster/trunk/xroster/admin/
XoopsModules/xroster/trunk/xroster/admin/index.php
XoopsModules/xroster/trunk/xroster/admin/menu.php
XoopsModules/xroster/trunk/xroster/blocks/
XoopsModules/xroster/trunk/xroster/blocks/index.html
XoopsModules/xroster/trunk/xroster/blocks/xroster_blocks.php
XoopsModules/xroster/trunk/xroster/common.inc.php
XoopsModules/xroster/trunk/xroster/images/
XoopsModules/xroster/trunk/xroster/images/SOEagazarian.jpg
XoopsModules/xroster/trunk/xroster/images/Thumbs.db
XoopsModules/xroster/trunk/xroster/images/blank.jpg
XoopsModules/xroster/trunk/xroster/images/index.html
XoopsModules/xroster/trunk/xroster/index.php
XoopsModules/xroster/trunk/xroster/language/
XoopsModules/xroster/trunk/xroster/language/english/
XoopsModules/xroster/trunk/xroster/language/english/index.html
XoopsModules/xroster/trunk/xroster/language/english/main.php
XoopsModules/xroster/trunk/xroster/language/english/modinfo.php
XoopsModules/xroster/trunk/xroster/language/index.html
XoopsModules/xroster/trunk/xroster/sql/
XoopsModules/xroster/trunk/xroster/sql/data.sql
XoopsModules/xroster/trunk/xroster/sql/index.html
XoopsModules/xroster/trunk/xroster/templates/
XoopsModules/xroster/trunk/xroster/templates/blocks/
XoopsModules/xroster/trunk/xroster/templates/blocks/index.html
XoopsModules/xroster/trunk/xroster/templates/blocks/xroster_block_newestmember.html
XoopsModules/xroster/trunk/xroster/templates/index.html
XoopsModules/xroster/trunk/xroster/templates/index_template.html
XoopsModules/xroster/trunk/xroster/xoops_version.php
XoopsModules/xroster/trunk/xroster/xroster.png
Added: XoopsModules/tplleaguestats/trunk/tplleaguestats/admin/head.php
===================================================================
--- XoopsModules/tplleaguestats/trunk/tplleaguestats/admin/head.php (rev 0)
+++ XoopsModules/tplleaguestats/trunk/tplleaguestats/admin/head.php 2012-03-14 09:32:43 UTC (rev 9127)
@@ -0,0 +1,74 @@
+<?php
+/*
+************************************************************
+TPLLeagueStats is a league stats software designed for football (soccer)
+team.
+
+Copyright (C) 2003 Timo Lepp\xE4nen / TPL Design
+email: in...@tp...
+www: www.tpl-design.com/tplleaguestats
+
+This program is free software; you can redistribute it and/or
+modify it under the terms of the GNU General Public License
+as published by the Free Software Foundation; either version 2
+of the License, or (at your option) any later version.
+
+This program is distributed in the hope that it will be useful,
+but WITHOUT ANY WARRANTY; without even the implied warranty of
+MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+GNU General Public License for more details.
+
+You should have received a copy of the GNU General Public License
+along with this program; if not, write to the Free Software
+Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
+
+************************************************************
+Ported to xoops by
+Mythrandir http://www.web-udvikling.dk
+and
+ralf57 http://www.madeinbanzi.it
+
+************************************************************
+*/
+if(!session_is_registered('season_name') || !session_is_registered('season_id'))
+{
+ echo "<form method=\"post\" action=\"leaguematches.php\">";
+ echo '<b><?php echo _AM_CHOSEASON;?></b>';
+ echo '<select name="season_select">';
+ $get_seasons = $xoopsDB->query("SELECT * FROM ".$xoopsDB->prefix("tplls_seasonnames")." ORDER BY SeasonName");
+
+ while($sdata = $xoopsDB->fetchArray($get_seasons))
+ {
+ echo "<option value=\"$sdata[SeasonID]____$sdata[SeasonName]\">$sdata[SeasonName]</option>\n";
+ }
+ echo "</select> <input type=\"submit\" name=\"submit\" value=" ._AM_SEASONGO. "></form>";
+
+
+ mysql_free_result($get_seasons);
+}
+else
+{
+ $season_name = $_SESSION['season_name'];
+ echo "<form method=\"post\" action=\"leaguematches.php\">";
+ echo "<b> "._AM_SEASELECT." $season_name</b><br><br>";
+ echo _AM_SEASELDROP;
+ echo '<select name="season_select">';
+
+ $get_seasons = $xoopsDB->query("SELECT * FROM ".$xoopsDB->prefix("tplls_seasonnames")." ORDER BY SeasonName");
+
+ while($sdata = $xoopsDB->fetchArray($get_seasons))
+ {
+ if($sdata['SeasonID'] == $seasonid)
+ echo "<option value=\"$sdata[SeasonID]____$sdata[SeasonName]\" SELECTED>$sdata[SeasonName]</option>\n";
+ else
+ echo "<option value=\"$sdata[SeasonID]____$sdata[SeasonName]\">$sdata[SeasonName]</option>\n";
+ }
+ echo "</select> <input type=\"submit\" name=\"submit\" value=" ._AM_SEASONGO. "></form>";
+
+ mysql_free_result($get_seasons);
+}
+?>
+
+<hr width="100%">
+
+</center>
\ No newline at end of file
Added: XoopsModules/tplleaguestats/trunk/tplleaguestats/admin/index.php
===================================================================
--- XoopsModules/tplleaguestats/trunk/tplleaguestats/admin/index.php (rev 0)
+++ XoopsModules/tplleaguestats/trunk/tplleaguestats/admin/index.php 2012-03-14 09:32:43 UTC (rev 9127)
@@ -0,0 +1,42 @@
+<?php
+/*
+************************************************************
+TPLLeagueStats is a league stats software designed for football (soccer)
+team.
+
+Copyright (C) 2003 Timo Lepp\xE4nen / TPL Design
+email: in...@tp...
+www: www.tpl-design.com/tplleaguestats
+
+This program is free software; you can redistribute it and/or
+modify it under the terms of the GNU General Public License
+as published by the Free Software Foundation; either version 2
+of the License, or (at your option) any later version.
+
+This program is distributed in the hope that it will be useful,
+but WITHOUT ANY WARRANTY; without even the implied warranty of
+MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+GNU General Public License for more details.
+
+You should have received a copy of the GNU General Public License
+along with this program; if not, write to the Free Software
+Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
+
+************************************************************
+Ported to xoops by
+Mythrandir http://www.web-udvikling.dk
+and
+ralf57 http://www.madeinbanzi.it
+
+************************************************************
+*/
+
+
+include '../../../include/cp_header.php'; //Include file, which checks for permissions and sets navigation
+
+xoops_cp_header();
+
+header("Location:leaguematches.php");
+
+xoops_cp_footer();
+?>
Added: XoopsModules/tplleaguestats/trunk/tplleaguestats/admin/leaguematches.php
===================================================================
--- XoopsModules/tplleaguestats/trunk/tplleaguestats/admin/leaguematches.php (rev 0)
+++ XoopsModules/tplleaguestats/trunk/tplleaguestats/admin/leaguematches.php 2012-03-14 09:32:43 UTC (rev 9127)
@@ -0,0 +1,1028 @@
+<?php
+/*
+************************************************************
+TPLLeagueStats is a league stats software designed for football (soccer)
+team.
+
+Copyright (C) 2003 Timo Lepp\xE4nen / TPL Design
+email: in...@tp...
+www: www.tpl-design.com/tplleaguestats
+
+This program is free software; you can redistribute it and/or
+modify it under the terms of the GNU General Public License
+as published by the Free Software Foundation; either version 2
+of the License, or (at your option) any later version.
+
+This program is distributed in the hope that it will be useful,
+but WITHOUT ANY WARRANTY; without even the implied warranty of
+MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+GNU General Public License for more details.
+
+You should have received a copy of the GNU General Public License
+along with this program; if not, write to the Free Software
+Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
+
+************************************************************
+Ported to xoops by
+Mythrandir http://www.web-udvikling.dk
+and
+ralf57 http://www.madeinbanzi.it
+
+************************************************************
+*/
+
+include '../../../include/cp_header.php'; //Include file, which checks for permissions and sets navigation
+if (isset($_POST['season_select'])) {
+ $season = explode("____",$_POST['season_select']);
+}
+elseif (isset($_POST['seasonid'])) {
+ $season = array ($_POST['seasonid'], $_POST['seasonname']);
+}
+elseif (!isset($_SESSION['season_id'])) {
+ $sql = "SELECT SeasonID, SeasonName FROM ".$xoopsDB->prefix("tplls_seasonnames")." WHERE SeasonDefault=1";
+ $seasonname = $xoopsDB->query($sql);
+ $seasonname = $xoopsDB->fetchArray($seasonname);
+ $season = array($seasonname['SeasonID'], $seasonname['SeasonName']);
+}
+else {
+ $season = array($_SESSION['season_id'], $_SESSION['season_name']);
+}
+$_SESSION['season_id'] = $season[0];
+$_SESSION['season_name'] = $season[1];
+$seasonid = $_SESSION['season_id'];
+$seasonname = $_SESSION['season_name'];
+
+$PHP_SELF = $_SERVER['PHP_SELF'];
+$action = isset($_GET['action']) ? $_GET['action'] : null;
+$action = isset($_POST['action']) ? $_POST['action'] : $action;
+
+$add_submit = isset($_POST['add_submit']) ? $_POST['add_submit'] : false;
+$modify_submit = isset($_POST['modify_submit']) ? $_POST['modify_submit'] : false;
+$delete_submit = isset($_POST['delete_submit']) ? $_POST['delete_submit'] : false;
+$modifyall_submit = isset($_POST['modifyall_submit']) ? $_POST['modifyall_submit']: null;
+
+xoops_cp_header();
+
+?>
+
+<!-- Navigation bar-->
+<table width="560" cellspacing="0" bordercolordark="white" bordercolorlight="black" style="border-collapse:collapse;">
+ <tr>
+ <td align="center" style="padding: 3px;background-color: #FFFFFF; border:1px #000000 dotted;">
+ <a href="seasons.php"><?php echo _AM_NAVSEASONS;?></a></td>
+ <td align="center" style="padding: 3px;background-color: #FFFFFF; border:1px #000000 dotted;">
+ <a href="opponents.php"><?php echo _AM_NAVOPPONENTS;?></a></td>
+ <td align="center" nowrap style="padding: 3px;background-color: #E6E6FF; border:1px #000000 dotted;">
+ <a href="leaguematches.php"><?php echo _AM_NAVLEAGUEMATCHES;?></a></td>
+ <td align="center" style="padding: 3px;background-color: #FFFFFF; border:1px #000000 dotted;">
+ <a href="../index.php" target="_blank"><?php echo _AM_NAVLEAGUETABLE;?></a></td>
+ </tr>
+</table>
+<!-- End Navigation bar-->
+
+<?php
+
+//
+//Exit check, if there are less than 2 teams in database
+//
+$query = $xoopsDB->query("SELECT OpponentID FROM ".$xoopsDB->prefix("tplls_opponents"));
+
+if($xoopsDB->getRowsNum($query) < 2)
+{
+ echo "<br><br>"._AM_ADDTWOTEAMS."<br><br>
+ <a href=\"opponents.php\">" ._AM_ADDTEAMS. "</a>";
+ exit();
+}
+
+if($add_submit)
+{
+ $year = intval($_POST['year']);
+ $month = intval($_POST['month']);
+ $day = intval($_POST['day']);
+ $dateandtime = $year."-".$month."-".$day;
+
+ //
+ //Check the data of the submitted form
+ //
+ $i = 0;
+
+ while($i < 15)
+ {
+ $home = $_POST['home']; //hometeam id
+ $away = $_POST['away']; //awayteam id
+ $home_goals = $_POST['home_goals'];
+ $away_goals = $_POST['away_goals'];
+
+ //
+ //Set the default
+ //
+ $home_winner = -1;
+ $home_loser = -1;
+ $home_tie = -1;
+ $away_winner = -1;
+ $away_loser = -1;
+ $away_tie = -1;
+
+ //
+ //If home and away are not the same
+ //
+ if($home[$i] != $away[$i])
+ {
+ $home[$i] = intval($home[$i]);
+ $away[$i] = intval($away[$i]);
+ $home_goals[$i] = $home_goals[$i] != null ? intval($home_goals[$i]) : null;
+ $away_goals[$i] = $away_goals[$i] != null ? intval($away_goals[$i]) : null;
+ //
+ //Hometeam wins
+ //
+ if($home_goals[$i] > $away_goals[$i])
+ {
+ $home_winner = $home[$i];
+ $away_loser = $away[$i];
+ }
+
+ //
+ //Away win
+ //
+ elseif($home_goals[$i] < $away_goals[$i])
+ {
+ $away_winner = $away[$i];
+ $home_loser = $home[$i];
+ }
+
+ //
+ //Draw
+ //
+ elseif($home_goals[$i] == $away_goals[$i])
+ {
+ $home_tie = $home[$i];
+ $away_tie = $away[$i];
+ }
+
+ //
+ //query to check if homea or away team already exists in the current day
+ //
+ $query = $xoopsDB->query("SELECT LM.LeagueMatchID FROM
+ ".$xoopsDB->prefix("tplls_leaguematches")." LM
+ WHERE
+ (LM.LeagueMatchHomeID = '$home[$i]' OR
+ LM.LeagueMatchAwayID = '$home[$i]' OR
+ LM.LeagueMatchHomeID = '$away[$i]' OR
+ LM.LeagueMatchAwayID = '$away[$i]') AND
+ LM.LeagueMatchDate = '$dateandtime'
+ ")
+ ;
+
+ if($xoopsDB->getRowsNum($query) == 0)
+ {
+ if (($home_goals[$i] !== null) && ($home_goals[$i] !== null)) {
+ $xoopsDB->query("INSERT INTO ".$xoopsDB->prefix("tplls_leaguematches")." SET
+ LeagueMatchSeasonID = '$seasonid',
+ LeagueMatchDate = '$dateandtime',
+ LeagueMatchHomeID = '$home[$i]',
+ LeagueMatchAwayID = '$away[$i]',
+ LeagueMatchHomeWinnerID = '$home_winner',
+ LeagueMatchHomeLoserID = '$home_loser',
+ LeagueMatchAwayWinnerID = '$away_winner',
+ LeagueMatchAwayLoserID = '$away_loser',
+ LeagueMatchHomeTieID = '$home_tie',
+ LeagueMatchAwayTieID = '$away_tie',
+ LeagueMatchHomeGoals = '$home_goals[$i]',
+ LeagueMatchAwayGoals = '$away_goals[$i]',
+ LeagueMatchCreated = ".time()."
+ ");
+ }
+ else {
+ $xoopsDB->query("INSERT INTO ".$xoopsDB->prefix("tplls_leaguematches")." SET
+ LeagueMatchSeasonID = '$seasonid',
+ LeagueMatchDate = '$dateandtime',
+ LeagueMatchHomeID = '$home[$i]',
+ LeagueMatchAwayID = '$away[$i]',
+ LeagueMatchHomeWinnerID = '-1',
+ LeagueMatchHomeLoserID = '-1',
+ LeagueMatchAwayWinnerID = '-1',
+ LeagueMatchAwayLoserID = '-1',
+ LeagueMatchHomeTieID = '-1',
+ LeagueMatchAwayTieID = '-1',
+ LeagueMatchCreated = ".time()."
+ ");
+ }
+
+ }
+
+ }
+ $i++;
+ }
+}
+elseif($modifyall_submit)
+{
+ $year = intval($_POST['year']);
+ $month = intval($_POST['month']);
+ $day = intval($_POST['day']);
+ $dateandtime = $year."-".$month."-".$day;
+ $qty = intval($_POST['qty']);
+
+ //
+ //Delete old data from selected date
+ //
+ $xoopsDB->query("DELETE FROM ".$xoopsDB->prefix("tplls_leaguematches")."
+ WHERE LeagueMatchDate = '$dateandtime'
+ ");
+
+ //
+ //Check the submitted form
+ //
+ $i = 0;
+ $home = $_POST['home']; //hometeam id
+ $away = $_POST['away']; //awayteam id
+ $home_goals = $_POST['home_goals'];
+ $away_goals = $_POST['away_goals'];
+ while($i < $qty)
+ {
+ $home[$i] = intval($home[$i]);
+ $away[$i] = intval($away[$i]);
+ $home_goals[$i] = $home_goals[$i] != null ? intval($home_goals[$i]) : null;
+ $away_goals[$i] = $away_goals[$i] != null ? intval($away_goals[$i]) : null;
+ //
+ //Set default
+ //
+ $home_winner = -1;
+ $home_loser = -1;
+ $home_tie = -1;
+ $away_winner = -1;
+ $away_loser = -1;
+ $away_tie = -1;
+
+ //
+ //Home wins
+ //
+ if($home_goals[$i] > $away_goals[$i])
+ {
+ $home_winner = $home[$i];
+ $away_loser = $away[$i];
+ }
+ //
+ //Away wins
+ //
+ elseif($home_goals[$i] < $away_goals[$i])
+ {
+ $away_winner = $away[$i];
+ $home_loser = $home[$i];
+ }
+ //
+ //Draw
+ //
+ elseif($home_goals[$i] == $away_goals[$i])
+ {
+ $home_tie = $home[$i];
+ $away_tie = $away[$i];
+ }
+ if (($home_goals[$i] !== null) && ($away_goals[$i] !== null)) {
+ $xoopsDB->query("INSERT INTO ".$xoopsDB->prefix("tplls_leaguematches")." SET
+ LeagueMatchSeasonID = '$seasonid',
+ LeagueMatchDate = '$dateandtime',
+ LeagueMatchHomeID = '$home[$i]',
+ LeagueMatchAwayID = '$away[$i]',
+ LeagueMatchHomeWinnerID = '$home_winner',
+ LeagueMatchHomeLoserID = '$home_loser',
+ LeagueMatchAwayWinnerID = '$away_winner',
+ LeagueMatchAwayLoserID = '$away_loser',
+ LeagueMatchHomeTieID = '$home_tie',
+ LeagueMatchAwayTieID = '$away_tie',
+ LeagueMatchHomeGoals = '$home_goals[$i]',
+ LeagueMatchAwayGoals = '$away_goals[$i]',
+ LeagueMatchCreated = ".time()."
+ ");
+ }
+ else {
+ $xoopsDB->query("INSERT INTO ".$xoopsDB->prefix("tplls_leaguematches")." SET
+ LeagueMatchSeasonID = '$seasonid',
+ LeagueMatchDate = '$dateandtime',
+ LeagueMatchHomeID = '$home[$i]',
+ LeagueMatchAwayID = '$away[$i]',
+ LeagueMatchHomeWinnerID = '-1',
+ LeagueMatchHomeLoserID = '-1',
+ LeagueMatchAwayWinnerID = '-1',
+ LeagueMatchAwayLoserID = '-1',
+ LeagueMatchHomeTieID = '-1',
+ LeagueMatchAwayTieID = '-1',
+ LeagueMatchCreated = ".time()."
+ ");
+ }
+ $i++;
+ }
+}
+elseif($modify_submit)
+{
+ $mid = intval($_POST['mid']);
+ $homeid = intval($_POST['homeid']);
+ $awayid = intval($_POST['awayid']);
+ $year = intval($_POST['year']);
+ $month = intval($_POST['month']);
+ $day = intval($_POST['day']);
+ $dateandtime = $year."-".$month."-".$day;
+
+ $home = intval($_POST['home']); //kotijoukkueen id
+ $away = intval($_POST['away']); //vierasjoukkueen id
+ $home_goals = $_POST['home_goals'] != null ? intval($_POST['home_goals']) : null;
+ $away_goals = $_POST['home_goals'] != null ? intval($_POST['away_goals']) : null;
+
+ //
+ //Set default
+ //
+ $home_winner = -1;
+ $home_loser = -1;
+ $home_tie = -1;
+ $away_winner = -1;
+ $away_loser = -1;
+ $away_tie = -1;
+
+ //
+ //Check that home and away are not the same
+ //
+ if($home != $away)
+ {
+ //
+ //Home wins
+ //
+ if($home_goals > $away_goals)
+ {
+ $home_winner = $home;
+ $away_loser = $away;
+ }
+
+ //
+ //Away wins
+ //
+ elseif($home_goals < $away_goals)
+ {
+ $away_winner = $away;
+ $home_loser = $home;
+ }
+
+ //
+ //Draw
+ //
+ elseif($home_goals == $away_goals)
+ {
+ $home_tie = $home;
+ $away_tie = $away;
+ }
+
+ //
+ //query to check if home or away team already exists in the current day
+ //
+ $query = $xoopsDB->query("SELECT LM.LeagueMatchID FROM
+ ".$xoopsDB->prefix("tplls_leaguematches")." LM
+ WHERE
+ (LM.LeagueMatchHomeID = '$home' OR
+ LM.LeagueMatchAwayID = '$home' OR
+ LM.LeagueMatchHomeID = '$homeid' OR
+ LM.LeagueMatchAwayID = '$homeid' OR
+ LM.LeagueMatchHomeID = '$away' OR
+ LM.LeagueMatchAwayID = '$away' OR
+ LM.LeagueMatchHomeID = '$awayid' OR
+ LM.LeagueMatchAwayID = '$awayid') AND
+ LM.LeagueMatchDate = '$dateandtime'
+ ");
+
+ if($xoopsDB->getRowsNum($query) < 2)
+ {
+ if (($home_goals !== null) && ($away_goals !== null)) {
+ $xoopsDB->query("UPDATE ".$xoopsDB->prefix("tplls_leaguematches")." SET
+ LeagueMatchDate = '$dateandtime',
+ LeagueMatchHomeID = '$home',
+ LeagueMatchAwayID = '$away',
+ LeagueMatchHomeWinnerID = '$home_winner',
+ LeagueMatchHomeLoserID = '$home_loser',
+ LeagueMatchAwayWinnerID = '$away_winner',
+ LeagueMatchAwayLoserID = '$away_loser',
+ LeagueMatchHomeTieID = '$home_tie',
+ LeagueMatchAwayTieID = '$away_tie',
+ LeagueMatchHomeGoals = '$home_goals',
+ LeagueMatchAwayGoals = '$away_goals',
+ LeagueMatchCreated = ".time()."
+ WHERE LeagueMatchID = '$mid'
+ LIMIT 1
+ ");
+ }
+ else {
+ $xoopsDB->query("UPDATE ".$xoopsDB->prefix("tplls_leaguematches")." SET
+ LeagueMatchDate = '$dateandtime',
+ LeagueMatchHomeID = '$home',
+ LeagueMatchAwayID = '$away',
+ LeagueMatchHomeWinnerID = '-1',
+ LeagueMatchHomeLoserID = '-1',
+ LeagueMatchAwayWinnerID = '-1',
+ LeagueMatchAwayLoserID = '-1',
+ LeagueMatchHomeTieID = '-1',
+ LeagueMatchAwayTieID = '-1',
+ LeagueMatchHomeGoals = NULL,
+ LeagueMatchAwayGoals = NULL,
+ LeagueMatchCreated = ".time()."
+ WHERE LeagueMatchID = '$mid'
+ LIMIT 1
+ ");
+ }
+ }
+ }
+}
+elseif($delete_submit)
+{
+ $mid = intval($_POST['mid']);
+ $xoopsDB->query("DELETE FROM ".$xoopsDB->prefix("tplls_leaguematches")." WHERE LeagueMatchID = '$mid' LIMIT 1");
+}
+
+ ?>
+
+ <?php
+ include('head.php');
+ ?>
+
+ <table align="center" width="700">
+ <tr>
+ <td align="left" valign="top">
+ <form method="post" action="<?php echo "$PHP_SELF"?>">
+ <?php
+ if(!isset($action))
+ {
+ ?>
+ <h3><?php echo _AM_ADDMATCH;?></h3>
+ <?php echo _AM_ADDMATCHNOTE;?><br><br>
+
+ <?php echo _AM_DATE;?>
+ <select name="day">
+ <?php
+ //print the days
+ for($i = 1 ; $i < 32 ; $i++)
+ {
+ if($i<10)
+ {
+ $i = "0".$i;
+ }
+ if($i == "01")
+ echo "<option value=\"$i\" SELECTED>$i</option>\n";
+ else
+ echo "<option value=\"$i\">$i</option>\n";
+ }
+ ?>
+ </select> /
+
+ <select name="month">
+ <?php
+ //print the months
+ for($i = 1 ; $i < 13 ; $i++)
+ {
+ if($i<10)
+ {
+ $i = "0".$i;
+ }
+ if($i == "01")
+ echo "<option value=\"$i\" SELECTED>$i</option>\n";
+ else
+ echo "<option value=\"$i\">$i</option>\n";
+ }
+ ?>
+ </select> /
+
+ <select name="year">
+ <?php
+ //print the years
+ for($i = 1950 ; $i < 2010 ; $i++)
+ {
+ if($i<10)
+ {
+ $i = "0".$i;
+ }
+ if($i == "2003")
+ echo "<option value=\"$i\" SELECTED>$i</option>\n";
+ else
+ echo "<option value=\"$i\">$i</option>\n";
+ }
+ ?>
+ </select><br><br>
+ <?php echo _AM_ADDMATCHNOTE2;?><br><br>
+
+ <table width="100%" cellspacing="3" cellpadding="3" border="0">
+ <tr>
+
+ <td align="left" valign="middle"><b><?php echo _AM_HOMETEAM;?></b></td>
+ <td align="left" valign="middle"><b><?php echo _AM_AWAYTEAM;?></b></td>
+ <td align="center" valign="middle"><b><?php echo _AM_GOALSHOME;?></b></td>
+ <td align="center" valign="middle"><b><b><?php echo _AM_GOALSAWAY;?></b></td>
+
+ </tr>
+
+ <?php
+
+ //
+ //query to get all the teams
+ //
+ $get_opponents = $xoopsDB->query("SELECT OpponentID AS id,
+ OpponentName AS name
+ FROM ".$xoopsDB->prefix("tplls_opponents")."
+ ORDER BY OpponentName");
+
+ //
+ //Prints 15 forms
+ //
+ $i=0;
+
+ while($i < 15)
+ {
+ //
+ //query back to row 0 if not the first time in the loop
+ //
+ if($i>0)
+ mysql_data_seek($get_opponents, 0);
+
+ echo'
+ <tr>
+ <td align="left" valign="middle">
+ ';
+
+ echo"<select name=\"home[$i]\">";
+
+ while($data = $xoopsDB->fetchArray($get_opponents))
+ {
+ echo"<option value=\"$data[id]\">$data[name]</option>\n";
+ }
+
+ echo'
+ </select>
+ </td>
+ <td align="left" valign="middle">
+ ';
+
+ //
+ //Back to line 0in the query
+ //
+ mysql_data_seek($get_opponents, 0);
+
+ echo"<select name=\"away[$i]\">";
+
+ while($data = $xoopsDB->fetchArray($get_opponents))
+ {
+ echo"<option value=\"$data[id]\">$data[name]</option>\n";
+ }
+
+ echo"
+ </select>
+ </td>
+ <td align=\"center\" valign=\"middle\"><input type=\"text\" name=\"home_goals[$i]\" size=\"2\"></td>
+ <td align=\"center\" valign=\"middle\"><input type=\"text\" name=\"away_goals[$i]\" size=\"2\"></td>
+
+ </tr>
+ ";
+
+
+
+
+ $i++;
+ }
+
+ ?>
+
+ </table><br><br>
+ <input type="hidden" name="seasonid" value="<?php echo $seasonid; ?>">
+ <input type="hidden" name="seasonname" value="<?php echo $seasonname; ?>">
+ <input type="submit" name="add_submit" value="<?php echo _AM_ADDMATCHES;?>">
+ </form>
+ <?php
+ }
+ elseif($action == 'modifyall')
+ {
+ $date = $_REQUEST['date'];
+
+ $get_matches = $xoopsDB->query("SELECT DAYOFMONTH(LM.LeagueMatchDate) AS dayofmonth,
+ MONTH(LM.LeagueMatchDate) AS month,
+ YEAR(LM.LeagueMatchDate) AS year,
+ LM.LeagueMatchHomeID AS homeid,
+ LM.LeagueMatchAwayID AS awayid,
+ LM.LeagueMatchHomeGoals AS homegoals,
+ LM.LeagueMatchAwayGoals AS awaygoals
+ FROM ".$xoopsDB->prefix("tplls_leaguematches")." LM
+ WHERE LM.LeaguematchDate = '$date'
+ ")
+ ;
+
+ //
+ //query to get date
+ //
+ $get_match = $xoopsDB->query("SELECT DAYOFMONTH(LM.LeagueMatchDate) AS dayofmonth,
+ MONTH(LM.LeagueMatchDate) AS month,
+ YEAR(LM.LeagueMatchDate) AS year
+ FROM ".$xoopsDB->prefix("tplls_leaguematches")." LM
+ WHERE LM.LeaguematchDate = '$date'
+ LIMIT 1
+ ")
+ ;
+
+ $datedata = $xoopsDB->fetchArray($get_match);
+
+ //$xoopsDB->freeRecordSet($get_match);
+
+ $get_opponents = $xoopsDB->query("SELECT OpponentID AS id,
+ OpponentName AS name
+ FROM ".$xoopsDB->prefix("tplls_opponents")."
+ ORDER BY OpponentName
+ ")
+ ;
+
+ ?>
+
+ <form method="post" action="<?php echo "$PHP_SELF" ?>">
+ <h3><?php echo _AM_MODMATCHES;?></h3>
+
+ <table width="100%" cellspacing="3" cellpadding="3" border="0">
+
+ <tr>
+ <td align="left" valign="top">
+ <?php echo _AM_DATETIME;?>
+ </td>
+ <td align="left" valign="top">
+
+ <select name="day">
+ <?php
+ //Print the days
+ for($i = 1 ; $i < 32 ; $i++)
+ {
+ if($i<10)
+ {
+ $i = "0".$i;
+ }
+ if($datedata['dayofmonth'] == $i)
+ echo "<option value=\"$i\" SELECTED>$i</option>\n";
+ else
+ echo "<option value=\"$i\">$i</option>\n";
+ }
+ ?>
+ </select> /
+
+ <select name="month">
+ <?php
+ //Print the months
+ for($i = 1 ; $i < 13 ; $i++)
+ {
+ if($i<10)
+ {
+ $i = "0".$i;
+ }
+ if($datedata['month'] == $i)
+ echo "<option value=\"$i\" SELECTED>$i</option>\n";
+ else
+ echo "<option value=\"$i\">$i</option>\n";
+ }
+ ?>
+ </select> /
+
+ <select name="year">
+ <?php
+ //Print the years
+ for($i = 1950 ; $i < 2010 ; $i++)
+ {
+ if($i<10)
+ {
+ $i = "0".$i;
+ }
+ if($datedata['year'] == $i)
+ echo "<option value=\"$i\" SELECTED>$i</option>\n";
+ else
+ echo "<option value=\"$i\">$i</option>\n";
+ }
+ ?>
+ </select>
+ </td>
+ </tr>
+
+ </table>
+
+ <table width="100%" cellspacing="3" cellpadding="3" border="0">
+ <tr>
+
+ <td align="left" valign="middle"><b><?php echo _AM_HOMETEAM;?></b></td>
+ <td align="left" valign="middle"><b><?php echo _AM_AWAYTEAM;?></b></td>
+ <td align="center" valign="middle"><b><?php echo _AM_GOALSHOME;?></b></td>
+ <td align="center" valign="middle"><b><?php echo _AM_GOALSAWAY;?></b></td>
+
+ </tr>
+
+ <?php
+
+ //
+ //Lets get all the matches from selected date to the form
+ //
+ $i = 0;
+ while($matchdata = $xoopsDB->fetchArray($get_matches))
+ {
+ //
+ //Back to line 0 in the query if not the first loop
+ //
+ if($i>0)
+ mysql_data_seek($get_opponents, 0);
+
+ echo'
+ <tr>
+ <td align="left" valign="middle">
+ ';
+
+ echo"<select name=\"home[$i]\">";
+
+ while($data = $xoopsDB->fetchArray($get_opponents))
+ {
+ if($matchdata['homeid'] == $data['id'])
+ echo"<option value=\"$data[id]\" SELECTED>$data[name]</option>\n";
+ }
+
+ echo'
+ </select>
+ </td>
+ <td align="left" valign="middle">
+ ';
+
+ //
+ //Back to line 0 in the query
+ //
+ mysql_data_seek($get_opponents, 0);
+
+ echo"<select name=\"away[$i]\">";
+
+ while($data = $xoopsDB->fetchArray($get_opponents))
+ {
+ if($matchdata['awayid'] == $data['id'])
+ echo"<option value=\"$data[id]\" SELECTED>$data[name]</option>\n";
+ }
+
+ echo"
+ </select>
+ </td>
+ <td align=\"center\" valign=\"middle\"><input type=\"text\" name=\"home_goals[$i]\" size=\"2\" value=\"$matchdata[homegoals]\"></td>
+ <td align=\"center\" valign=\"middle\"><input type=\"text\" name=\"away_goals[$i]\" size=\"2\" value=\"$matchdata[awaygoals]\"></td>
+
+ </tr>
+ ";
+
+
+
+
+ $i++;
+ }
+
+ ?>
+
+ </table>
+
+ <font color="red"><?php echo _AM_MODNOTICE1;?></font><br><br>
+ <input type="hidden" name="qty" value="<?= $i ?>">
+ <input type="hidden" name="seasonname" value="<?php echo $seasonname; ?>">
+ <br><input type="submit" name="modifyall_submit" value="<?php echo _AM_MODINPUT;?>">
+ </form>
+
+ <?php
+ }
+ elseif($action == 'modify')
+ {
+ $id = intval($_REQUEST['id']);
+
+ $get_match = $xoopsDB->query("SELECT DAYOFMONTH(LM.LeagueMatchDate) AS dayofmonth,
+ MONTH(LM.LeagueMatchDate) AS month,
+ YEAR(LM.LeagueMatchDate) AS year,
+ LM.LeagueMatchHomeID AS homeid,
+ LM.LeagueMatchAwayID AS awayid,
+ LM.LeagueMatchHomeGoals AS homegoals,
+ LM.LeagueMatchAwayGoals AS awaygoals
+ FROM ".$xoopsDB->prefix("tplls_leaguematches")." LM
+ WHERE LM.LeaguematchID = '$id'
+ LIMIT 1
+ ")
+ ;
+
+ $get_opponents = $xoopsDB->query("SELECT OpponentID AS id,
+ OpponentName AS name
+ FROM ".$xoopsDB->prefix("tplls_opponents")."
+ ORDER BY OpponentName
+ ")
+ ;
+
+ $matchdata = $xoopsDB->fetchArray($get_match);
+
+ //$xoopsDB->freeRecordSet($get_match);
+
+ ?>
+ <form method="post" action="<?php echo "$PHP_SELF"?>">
+ <h3><?php echo _AM_MODMATCH;?></h3>
+
+ <table width="100%" cellspacing="3" cellpadding="3" border="0">
+
+ <tr>
+ <td align="left" valign="top">
+ <?php echo _AM_DATETIME;?>
+ </td>
+ <td align="left" valign="top">
+
+ <select name="day">
+ <?php
+ //Print the days
+ for($i = 1 ; $i < 32 ; $i++)
+ {
+ if($i<10)
+ {
+ $i = "0".$i;
+ }
+ if($matchdata['dayofmonth'] == $i)
+ echo "<option value=\"$i\" SELECTED>$i</option>\n";
+ else
+ echo "<option value=\"$i\">$i</option>\n";
+ }
+ ?>
+ </select> /
+
+ <select name="month">
+ <?php
+ //Print the months
+ for($i = 1 ; $i < 13 ; $i++)
+ {
+ if($i<10)
+ {
+ $i = "0".$i;
+ }
+ if($matchdata['month'] == $i)
+ echo "<option value=\"$i\" SELECTED>$i</option>\n";
+ else
+ echo "<option value=\"$i\">$i</option>\n";
+ }
+ ?>
+ </select> /
+
+ <select name="year">
+ <?php
+ //Print the years
+ for($i = 1950 ; $i < 2010 ; $i++)
+ {
+ if($i<10)
+ {
+ $i = "0".$i;
+ }
+ if($matchdata['year'] == $i)
+ echo "<option value=\"$i\" SELECTED>$i</option>\n";
+ else
+ echo "<option value=\"$i\">$i</option>\n";
+ }
+ ?>
+ </select>
+ </td>
+ </tr>
+
+ </table>
+
+ <table width="100%" cellspacing="3" cellpadding="3" border="0">
+ <tr>
+
+ <td align="left" valign="middle"><b><?php echo _AM_HOMETEAM;?></b></td>
+ <td align="left" valign="middle"><b><?php echo _AM_AWAYTEAM;?></b></td>
+ <td align="center" valign="middle"><b><?php echo _AM_GOALSHOME;?></b></td>
+ <td align="center" valign="middle"><b><?php echo _AM_GOALSAWAY;?></b></td>
+
+ </tr>
+
+ <tr>
+ <td align="left" valign="middle">
+
+ <select name="home">
+ <?php
+
+ while($data = $xoopsDB->fetchArray($get_opponents))
+ {
+ if($matchdata['homeid'] == $data['id'])
+ echo"<option value=\"$data[id]\" SELECTED>$data[name]</option>\n";
+ else
+ echo"<option value=\"$data[id]\">$data[name]</option>\n";
+ }
+
+ ?>
+ </select>
+ </td>
+ <td align="left" valign="middle">
+
+ <select name="away">
+ <?php
+
+ mysql_data_seek($get_opponents, 0);
+
+ while($data = $xoopsDB->fetchArray($get_opponents))
+ {
+ if($matchdata['awayid'] == $data['id'])
+ echo"<option value=\"$data[id]\" SELECTED>$data[name]</option>\n";
+ else
+ echo"<option value=\"$data[id]\">$data[name]</option>\n";
+ }
+
+ ?>
+ </select>
+ </td>
+ <td align="center" valign="middle"><input type="text" name="home_goals" size="2" value="<?= $matchdata['homegoals'] ?>"></td>
+ <td align="center" valign="middle"><input type="text" name="away_goals" size="2" value="<?= $matchdata['awaygoals'] ?>"></td>
+
+ </tr>
+
+ </table>
+
+
+ <input type="hidden" name="mid" value="<?= $id ?>">
+ <input type="hidden" name="homeid" value="<?= $matchdata['awayid'] ?>">
+ <input type="hidden" name="awayid" value="<?= $matchdata['homeid'] ?>">
+ <br><input type="submit" name="modify_submit" value="<?php echo _AM_MODINPUT2;?>">
+ <input type="hidden" name="seasonid" value="<?php echo $seasonid; ?>">
+ <input type="hidden" name="seasonname" value="<?php echo $seasonname; ?>">
+ <br><br><br><br><br>
+ <input type="submit" name="delete_submit" value="<?php echo _AM_DELINPUT;?>">
+ </form>
+
+ <?php
+ }
+ ?>
+ </td>
+
+ <td align="left" valign="top" width="250">
+
+ <table width="250">
+ <?php
+ $get_matches = $xoopsDB->query("SELECT O.OpponentName AS hometeam,
+ OP.OpponentName AS awayteam,
+ LM.LeagueMatchHomeGoals AS goals_home,
+ LM.LeagueMatchAwayGoals AS goals_away,
+ LM.LeagueMatchID AS id,
+ LM.LeagueMatchDate AS defaultdate,
+ DATE_FORMAT(LM.LeagueMatchDate, '%b %D %Y') AS date
+ FROM ".$xoopsDB->prefix("tplls_leaguematches")." LM, ".$xoopsDB->prefix("tplls_opponents")." O, ".$xoopsDB->prefix("tplls_opponents")." OP
+ WHERE O.OpponentID = LM.LeagueMatchHomeID AND
+ OP.OpponentID = LM.LeagueMatchAwayID AND
+ LeagueMatchSeasonID = '$seasonid'
+ ORDER BY LM.LeagueMatchDate DESC");
+
+ if($xoopsDB->getRowsNum($get_matches) < 1)
+ {
+ echo "<b> "._AM_NOMATCHESYET." <br><u> $seasonname</u> </b>";
+ }
+ else
+ {
+ echo "<b> "._AM_MATCHESYET." <br> <u>$seasonname</u></b><br><br>";
+
+ $i = 0;
+ $temp = '';
+
+ while($data = $xoopsDB->fetchArray($get_matches))
+ {
+ if($i == 0)
+ {
+ echo"
+ <tr>
+ <td align=\"left\" colspan=\"2\">
+ <b><a href=\"$PHP_SELF?action=modifyall&date=$data[defaultdate]\">$data[date]</a></b>
+ </td>
+ </tr>
+ ";
+ }
+
+ if($data['date'] != "$temp" && $i > 0)
+ {
+ echo"
+ <tr>
+ <td align=\"left\" colspan=\"2\">
+ <br><br>
+ <b><a href=\"$PHP_SELF?action=modifyall&date=$data[defaultdate]\">$data[date]</a></b>
+ </td>
+ </tr>
+ ";
+ }
+
+ echo "
+ <tr>
+ <td align=\"left\" valign=\"top\" width=\"230\">
+ <a href=\"$PHP_SELF?action=modify&id=$data[id]\">$data[hometeam] - $data[awayteam]</a>
+ </td>
+ <td align=\"right\" valign=\"top\" width=\"50\">";
+
+ if(!is_null($data['goals_home']))
+ echo"$data[goals_home]-$data[goals_away]";
+ else
+ echo' ';
+
+
+ echo"
+ </td>
+ </tr>";
+
+ $temp = "$data[date]";
+
+ $i++;
+ }
+ }
+ ?>
+ </table>
+ </td>
+ </tr>
+ </table>
+<?php
+xoops_cp_footer();
+?>
\ No newline at end of file
Added: XoopsModules/tplleaguestats/trunk/tplleaguestats/admin/menu.php
===================================================================
--- XoopsModules/tplleaguestats/trunk/tplleaguestats/admin/menu.php (rev 0)
+++ XoopsModules/tplleaguestats/trunk/tplleaguestats/admin/menu.php 2012-03-14 09:32:43 UTC (rev 9127)
@@ -0,0 +1,10 @@
+<?php
+
+$adminmenu[1]['title'] = _MI_TPLLS_ADMENU1;
+$adminmenu[1]['link'] = "admin/seasons.php";
+$adminmenu[2]['title'] = _MI_TPLLS_ADMENU2;
+$adminmenu[2]['link'] = "admin/opponents.php";
+$adminmenu[3]['title'] = _MI_TPLLS_ADMENU3;
+$adminmenu[3]['link'] = "admin/leaguematches.php";
+
+?>
\ No newline at end of file
Added: XoopsModules/tplleaguestats/trunk/tplleaguestats/admin/opponents.php
===================================================================
--- XoopsModules/tplleaguestats/trunk/tplleaguestats/admin/opponents.php (rev 0)
+++ XoopsModules/tplleaguestats/trunk/tplleaguestats/admin/opponents.php 2012-03-14 09:32:43 UTC (rev 9127)
@@ -0,0 +1,383 @@
+<?php
+/*
+************************************************************
+TPLLeagueStats is a league stats software designed for football (soccer)
+team.
+
+Copyright (C) 2003 Timo Lepp\xE4nen / TPL Design
+email: in...@tp...
+www: www.tpl-design.com/tplleaguestats
+
+This program is free software; you can redistribute it and/or
+modify it under the terms of the GNU General Public License
+as published by the Free Software Foundation; either version 2
+of the License, or (at your option) any later version.
+
+This program is distributed in the hope that it will be useful,
+but WITHOUT ANY WARRANTY; without even the implied warranty of
+MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+GNU General Public License for more details.
+
+You should have received a copy of the GNU General Public License
+along with this program; if not, write to the Free Software
+Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
+
+************************************************************
+Ported to xoops by
+Mythrandir http://www.web-udvikling.dk
+and
+ralf57 http://www.madeinbanzi.it
+
+************************************************************
+*/
+
+include '../../../include/cp_header.php'; //Include file, which checks for permissions and sets navigation
+
+if (isset($_POST['season_select'])) {
+ $season = explode("____",$_POST['season_select']);
+}
+elseif (isset($_POST['seasonid'])) {
+ $season = array (intval($_POST['seasonid']), $_POST['seasonname']);
+}
+elseif (!isset($_SESSION['season_id'])) {
+ $sql = "SELECT SeasonID, SeasonName FROM ".$xoopsDB->prefix("tplls_seasonnames")." WHERE SeasonDefault=1";
+ $seasonname = $xoopsDB->query($sql);
+ $seasonname = $xoopsDB->fetchArray($seasonname);
+ $season = array($seasonname['SeasonID'], $seasonname['SeasonName']);
+}
+else {
+ $season = array(intval($_SESSION['season_id']), $_SESSION['season_name']);
+}
+$_SESSION['season_id'] = $season[0];
+$_SESSION['season_name'] = $season[1];
+$seasonid = $_SESSION['season_id'];
+$seasonname = $_SESSION['season_name'];
+
+$PHP_SELF = $_SERVER['PHP_SELF'];
+$action = isset($_GET['action']) ? $_GET['action'] : null;
+$action = isset($_POST['action']) ? $_POST['action'] : $action;
+
+$add_submit = isset($_POST['add_submit']) ? $_POST['add_submit'] : false;
+$modify_submit = isset($_POST['modify_submit']) ? $_POST['modify_submit'] : false;
+$delete_submit = isset($_POST['delete_submit']) ? $_POST['delete_submit'] : false;
+
+$d_points_add = isset($_POST['d_points_add']) ? $_POST['d_points_add'] : null;
+$d_points_modify = isset($_POST['d_points_modify']) ? $_POST['d_points_modify'] : null;
+
+xoops_cp_header();
+
+?>
+
+<!-- Navigation bar-->
+<table width="560" cellspacing="0" bordercolordark="white" bordercolorlight="black" style="border-collapse:collapse;">
+ <tr>
+ <td align="center" style="padding: 3px;background-color: #FFFFFF; border:1px #000000 dotted;">
+ <a href="seasons.php"><?php echo _AM_NAVSEASONS;?></a></td>
+ <td align="center" style="padding: 3px;background-color: #E6E6FF; border:1px #000000 dotted;">
+ <a href="opponents.php"><?php echo _AM_NAVOPPONENTS;?></a></td>
+ <td align="center" nowrap style="padding: 3px;background-color: #FFFFFF; border:1px #000000 dotted;">
+ <a href="leaguematches.php"><?php echo _AM_NAVLEAGUEMATCHES;?></a></td>
+ <td align="center" style="padding: 3px;background-color: #FFFFFF; border:1px #000000 dotted;">
+ <a href="../index.php" target="_blank"><?php echo _AM_NAVLEAGUETABLE;?></a></td>
+ </tr>
+</table>
+<!-- End Navigation bar-->
+
+<?php
+
+//
+//Add
+//
+if($add_submit)
+{
+ $opponent = trim($_POST['opponent']);
+ $opponent = $xoopsDB->quoteString($opponent);
+ //query to check if there are already a team with submitted name
+ $query = $xoopsDB->query("SELECT OpponentName FROM ".$xoopsDB->prefix("tplls_opponents")." WHERE OpponentName = $opponent");
+
+ if($xoopsDB->getRowsNum($query) > 0)
+ {
+ echo "<font color='red'><b>". _AM_TEAMDUPLICATE."</b></font><br><br>";
+ exit();
+ }
+
+ if($opponent != '')
+ {
+ $xoopsDB->query("INSERT INTO ".$xoopsDB->prefix("tplls_opponents")." SET OpponentName = $opponent");
+
+ header("Location: $PHP_SELF");
+ }
+}
+//
+//Modify
+//
+elseif($modify_submit)
+{
+ $opponent = $xoopsDB->quoteString(trim($_POST['opponent']));
+ $opponentid = intval($_POST['opponentid']);
+ $own = $_POST['own'];
+ //
+ //Checked own
+ //
+ if(!isset($own))
+ {
+ $own = 0;
+ }
+
+ if($opponent != '')
+ {
+ //
+ //If own team->delete the own status from the previous one
+ //
+ if($own == 1)
+ {
+ $xoopsDB->query("UPDATE ".$xoopsDB->prefix("tplls_opponents")." SET
+ OpponentOwn = '0'
+ WHERE OpponentOwn = '1'
+ ");
+ }
+
+ $xoopsDB->query("UPDATE ".$xoopsDB->prefix("tplls_opponents")." SET
+ OpponentName = $opponent,
+ OpponentOwn = '$own'
+ WHERE OpponentID = $opponentid");
+ }
+
+ header("Location: $HTTP_REFERER");
+}
+//
+//Delete
+//
+elseif($delete_submit)
+{
+ $opponentid = intval($_POST['opponentid']);
+
+ //
+ //query to check, if team already exists in the leaguetables
+ //
+ $query = $xoopsDB->query("SELECT LeagueMatchID
+ FROM ".$xoopsDB->prefix("tplls_leaguematches")."
+ WHERE LeagueMatchHomeID = $opponentid OR LeagueMatchAwayID = $opponentid");
+
+ if($xoopsDB->getRowsNum($query) == 0)
+ {
+ $xoopsDB->query("DELETE FROM ".$xoopsDB->prefix("tplls_opponents")." WHERE OpponentID = $opponentid");
+
+ header("Location: $PHP_SELF");
+ }
+ else
+ {
+ echo "<font color='red'><b>". _AM_TEAMISINUSE."</b></font><br><br>";
+ exit();
+ }
+}
+//
+//Deducted points
+//
+elseif($d_points_add)
+{
+ $d_points = intval($_POST['d_points']);
+ $teamid = intval($_POST['teamid']);
+ $seasonid = intval($_POST['seasonid']);
+
+ if(is_numeric($d_points) && $d_points != '')
+ {
+ //
+ //Adds
+ //
+ $xoopsDB->query("INSERT INTO ".$xoopsDB->prefix("tplls_deductedpoints")." SET
+ seasonid = $seasonid,
+ teamid = $teamid,
+ points = $d_points");
+ }
+
+ header("Location: $HTTP_REFERER");
+}
+//
+//Modify of deducted points
+//
+elseif($d_points_modify)
+{
+ $d_points = intval($_POST['d_points']);
+ $id = intval($_POST['id']);
+
+ if(is_numeric($d_points) && $d_points != '')
+ {
+ //
+ //Delete deducted points if zero is written
+ //
+ if($d_points == 0)
+ {
+ $xoopsDB->query("DELETE FROM ".$xoopsDB->prefix("tplls_deductedpoints")."
+ WHERE id = $id");
+ }
+ //
+ //Modify if some other number
+ //
+ else
+ {
+ $xoopsDB->query("UPDATE ".$xoopsDB->prefix("tplls_deductedpoints")." SET
+ points = $d_points
+ WHERE id = $id");
+ }
+ }
+
+ header("Location: $HTTP_REFERER");
+}
+
+
+?>
+
+ <?php
+ include('head.php');
+ ?>
+ <table align="center" width="600">
+ <tr>
+ <td align="left" valign="top">
+ <?php
+ if(!isset($action))
+ {
+ ?>
+ <form method="post" action="<?php echo "$PHP_SELF"?>">
+ <h3><?php echo _AM_ADDNEWTEAM;?></h3>
+ <table width="100%" cellspacing="3" cellpadding="3" border="0">
+ <tr>
+ <td align="left" valign="top">
+ <?php echo _AM_TEAMNAME;?>
+ </td>
+ <td align="left" valign="top">
+ <input type="text" name="opponent">
+ </td>
+ </tr>
+ </table>
+ <input type="submit" name="add_submit" value="<?php echo _AM_ADDTEAM;?>">
+ </form>
+ <?php
+ }
+ elseif($action == 'modify')
+ {
+ $opponentid = intval($_REQUEST['opponent']);
+ $get_opponent = $xoopsDB->query("SELECT * FROM ".$xoopsDB->prefix("tplls_opponents")." WHERE OpponentID = $opponentid LIMIT 1");
+ $data = $xoopsDB->fetchArray($get_opponent);
+ ?>
+
+ <form method="post" action="<?php echo "$PHP_SELF"?>">
+ <h3><?php echo _AM_TEAMMODIFYDELETE;?></h3>
+ <table width="100%" cellspacing="3" cellpadding="3" border="0">
+ <tr>
+ <td align="left" valign="top">
+ <?php echo _AM_TEAMNAME;?>
+ </td>
+ <td align="left" valign="top">
+ <input type="text" name="opponent" value="<?php echo $data['OpponentName'] ?>">
+ <input type="hidden" name="opponentid" value="<?php echo $data['OpponentID'] ?>">
+ </td>
+ </tr>
+
+ <tr>
+ <td align="left" valign="top">
+ <?php echo _AM_TEAMISYOURS;?>
+ </td>
+ <td align="left" valign="top">
+ <?php
+
+ if($data['OpponentOwn'] == 1)
+ echo"<input type=\"checkbox\" name=\"own\" value=\"1\" CHECKED>\n";
+ else
+ echo"<input type=\"checkbox\" name=\"own\" value=\"1\">\n";
+
+ ?>
+ </td>
+ </tr>
+
+ </table>
+ <input type="submit" name="modify_submit" value="<?php echo _AM_TEAMMODIFY;?>"> <input type="submit" name="delete_submit" value="<?php echo _AM_TEAMDELETE;?>">
+ </form>
+
+ <a href="<?php echo "$PHP_SELF" ?>"><?php echo _AM_ADDNEWTEAM;?></a>
+
+ <h3><?php echo _AM_DEDPTS;?></h3>
+
+ <?php
+
+ //
+ //Check if there are deducted points
+ //
+
+ echo"<b>$seasonname</b><br><br>";
+
+ $get_deduct = $xoopsDB->query("SELECT points, id
+ FROM ".$xoopsDB->prefix("tplls_deductedpoints")."
+ WHERE seasonid = $seasonid AND teamid = $opponentid
+ LIMIT 1
+ ");
+
+ if($xoopsDB->getRowsNum($get_deduct) == 0)
+ {
+ echo"
+ <form method=\"POST\" action=\"$PHP_SELF\">"
+ ._AM_ADDDEDPTS.
+ "<input type=\"text\" size=\"2\" name=\"d_points\">
+ <input type=\"hidden\" value=\"$opponentid\" name=\"teamid\">
+ <input type=\"hidden\" value=\"$seasonid\" name=\"seasonid\">
+ <input type=\"submit\" value="._AM_ADEDPTS." name=\"d_points_add\">
+ </form>
+ ";
+ }
+ else
+ {
+ $data = $xoopsDB->fetchArray($get_deduct);
+
+ echo"
+ <form method=\"POST\" action=\"$PHP_SELF\">"
+ ._AM_MODDEDPTS.
+ "<input type=\"text\" size=\"2\" name=\"d_points\" value=\"$data[points]\">
+ <input type=\"hidden\" value=\"$data[id]\" name=\"id\">
+ <input type=\"submit\" value="._AM_MDEDPTS." name=\"d_points_modify\">
+ </form>
+ ";
+ }
+
+ mysql_free_result($get_deduct);
+
+ ?>
+
+ <?php
+ mysql_free_result($get_opponent);
+ }
+ ?>
+ </td>
+
+ <td align="left" valign="top">
+ <?php
+ $get_opponents = $xoopsDB->query("SELECT * FROM ".$xoopsDB->prefix("tplls_opponents")." ORDER BY OpponentName");
+
+ if($xoopsDB->getRowsNum($get_opponents) < 1)
+ {
+ echo "<b>". _AM_NOTEAMSAVAILABLE."</b><br><br>";
+ }
+ else
+ {
+ echo "<b>". _AM_TEAMSAVAILABLE."</b><br><br>";
+
+ while($data = $xoopsDB->fetchArray($get_opponents))
+ {
+ echo "<a href=\"$PHP_SELF?action=modify&opponent=$data[OpponentID]\">$data[OpponentName]</a>";
+
+ if($data['OpponentOwn'] == 1)
+ echo " "._AM_YT. "<br>\n";
+ else
+ echo"<br>\n";
+ }
+ }
+
+ ?>
+
+ <br><br>
+ <?php echo _AM_YOURTEAM;?>
+ </td>
+ </tr>
+ </table>
+<?php
+xoops_cp_footer();
+?>
\ No newline at end of file
Added: XoopsModules/tplleaguestats/trunk/tplleaguestats/admin/seasons.php
===================================================================
--- XoopsModules/tplleaguestats/trunk/tplleaguestats/admin/seasons.php (rev 0)
+++ XoopsModules/tplleaguestats/trunk/tplleaguestats/admin/seasons.php 2012-03-14 09:32:43 UTC (rev 9127)
@@ -0,0 +1,307 @@
+<?php
+/*
+************************************************************
+TPLLeagueStats is a league stats software designed for football (soccer)
+team.
+
+Copyright (C) 2003 Timo Lepp\xE4nen / TPL Design
+email: in...@tp...
+www: www.tpl-design.com/tplleaguestats
+
+This program is free software; you can redistribute it and/or
+modify it under the terms of the GNU General Public License
+as published by the Free Software Foundation; either version 2
+of the License, or (at your option) any later version.
+
+This program is distributed in the hope that it will be useful,
+but WITHOUT ANY WARRANTY; without even the implied warranty of
+MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+GNU General Public License for more details.
+
+You should have received a copy of the GNU General Public License
+along with this program; if not, write to the Free Software
+Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
+
+************************************************************
+Ported to xoops by
+Mythrandir http://www.web-udvikling.dk
+and
+ralf57 http://www.madeinbanzi.it
+
+************************************************************
+*/
+
+include '../../../include/cp_header.php'; //Include file, which checks for permissions and sets navigation
+
+$seasonid = isset($_GET['season_id']) ? intval($_GET['season_id']) : 0;
+$seasonname = isset($_GET['season_name']) ? $_GET['season_name'] : "";
+
+$PHP_SELF = $_SERVER['PHP_SELF'];
+$HTTP_REFERER = $_SERVER['HTTP_REFERER'];
+$action = isset($_GET['action']) ? $_GET['action'] : null;
+$action = isset($_POST['action']) ? $_POST['action'] : $action;
+
+$add_submit = isset($_POST['add_submit']) ? $_POST['add_submit'] : false;
+$modify_submit = isset($_POST['modify_submit']) ? $_POST['modify_submit'] : false;
+$delete_submit = isset($_POST['delete_submit']) ? $_POST['delete_submit'] : false;
+
+xoops_cp_header();
+
+?>
+
+<!-- Navigation bar-->
+<table width="560" cellspacing="0" bordercolordark="white" bordercolorlight="black" style="border-collapse:collapse;">
+ <tr>
+ <td align="center" style="padding: 3px;background-color: #E6E6FF; border:1px #000000 dotted;">
+ <a href="seasons.php"><?php echo _AM_NAVSEASONS;?></a></td>
+ <td align="center" style="padding: 3px;background-color: #FFFFFF; border:1px #000000 dotted;">
+ <a href="opponents.php"><?php echo _AM_NAVOPPONENTS;?></a></td>
+ <td align="center" nowrap style="padding: 3px;background-color: #FFFFFF; border:1px #000000 dotted;">
+ <a href="leaguematches.php"><?php echo _AM_NAVLEAGUEMATCHES;?></a></td>
+ <td align="center" style="padding: 3px;background-color: #FFFFFF; border:1px #000000 dotted;">
+ <a href="../index.php" target="_blank"><?php echo _AM_NAVLEAGUETABLE;?></a></td>
+ </tr>
+</table>
+<!-- End Navigation bar-->
+
+
+<?php
+if($add_submit)
+{
+ $name = $xoopsDB->quoteString(trim($_POST['name']));
+ $drawline = trim($_POST['drawline']);
+
+ //Query to check if there are already a submitted season name in the database
+ $query = $xoopsDB->query("SELECT SeasonName FROM ".$xoopsDB->prefix("tplls_seasonnames")." WHERE SeasonName = $name");
+
+ if($xoopsDB->getRowsNum($query) > 0)
+ {
+ echo "<font color='red'><b>". _AM_SEASONDUPLICATE."</b></font><br><br>";
+ exit();
+ }
+
+ mysql_free_result($query);
+
+ if($name != '')
+ {
+ $xoopsDB->query("INSERT INTO ".$xoopsDB->prefix("tplls_seasonnames")." SET
+ SeasonName = $name,
+ SeasonLine = '$drawline',
+ SeasonDefault = '$defseason'");
+
+ header("Location: $PHP_SELF");
+ }
+}
+elseif($modify_submit)
+{
+ $name = $xoopsDB->quoteString(trim($_POST['name']));
+ $drawline = trim($_POST['drawline']);
+ $publish = $_POST['publish'];
+ $seasonid = intval($_POST['seasonid']);
+ $defseason = intval($_POST['defseason']);
+
+ //
+ //If published is checked
+ //
+ if(!isset($publish))
+ {
+ $publish = 0;
+ }
+ if(!isset($defseason))
+ {
+ $defseason = 0;
+ }
+
+ if($name != '')
+ {
+ //
+ //If default season->delete the default status from the previous one
+ //
+ if($defseason == 1)
+ {
+ $xoopsDB->query("UPDATE ".$xoopsDB->prefix("tplls_seasonnames")." SET
+ SeasonDefault = '0'");
+ }
+ $xoopsDB->query("UPDATE ".$xoopsDB->prefix("tplls_seasonnames")." SET
+ SeasonName = $name,
+ SeasonLine = '$drawline',
+ SeasonPublish = '$publish',
+ SeasonDefault = '$defseason'
+ WHERE SeasonID = '$seasonid'");
+ }
+
+ header("Location: $HTTP_REFERER");
+}
+elseif($delete_submit)
+{
+ $seasonid = intval($_POST['seasonid']);
+
+ //
+ //Query to check if there are already matches in the season->can't delete
+ //
+ $query = $xoopsDB->query("SELECT M.LeagueMatchID
+ FROM ".$xoopsDB->prefix("tplls_leaguematches")." M, ".$xoopsDB->prefix("tplls_seasonnames")." S
+ WHERE M.LeagueMatchSeasonID = '$seasonid'");
+
+ if($xoopsDB->getRowsNum($query) == 0)
+ {
+ $xoopsDB->query("DELETE FROM ".$xoopsDB->prefix("tplls_seasonnames")." WHERE SeasonID = '$seasonid'");
+ }
+ else
+ {
+ echo "<font color='red'><b>". _AM_SEASONHASMATCHES."</b></font><br><br>";
+ exit();
+ }
+
+ header("Location: $PHP_SELF");
+}
+
+
+?>
+
+ <?php
+ include('head.php');
+ ?>
+ <table align="center" width="600">
+ <tr>
+ <td>
+ <?php
+ if(!isset($action))
+ {
+ ?>
+ <form method="post" action="<?php echo "$PHP_SELF" ?>">
+ <h3><?php echo _AM_ADDSEASON;?></h3>
+ <table width="100%" cellspacing="3" cellpadding="3" border="0">
+ <tr>
+ <td align="left" valign="top">
+ <?php echo _AM_SEASONNAMEYEARS;?>
+ </td>
+ <td align="left" valign="top">
+ <input type="text" name="name">
+ </td>
+ </tr>
+
+ <tr>
+ <td align="left" valign="top">
+ <?php echo _AM_SEASONDRAWLINE;?>
+ </td>
+ <td align="left" valign="top">
+ <input type="text" name="drawline" value="" size="10">
+ </td>
+ </tr>
+ </table>
+ <input type="submit" name="add_submit" value="<?php echo _AM_SEASONADD;?>">
+ </form>
+ <?php
+ }
+ elseif($action == 'modify')
+ {
+ $seasonid = intval($_REQUEST['season']);
+ $get_season = $xoopsDB->query("SELECT * FROM ".$xoopsDB->prefix("tplls_seasonnames")." WHERE SeasonID = '$seasonid' LIMIT 1");
+ $data = $xoopsDB->fetchArray($get_season);
+ ?>
+
+ <form method="post" action="<?php echo "$PHP_SELF"?>">
+ <h3><?php echo _AM_SEASONMODIFYDELETE;?></h3>
+ <table width="100%" cellspacing="3" cellpadding="3" border="0">
+ <tr>
+ <td align="left" valign="top">
+ <?php echo _AM_SEASONNAMEYEARS;?>
+ </td>
+ <td>
+ <input type="text" name="name" value="<?php echo $data['SeasonName'] ?>">
+ <input type="hidden" name="seasonid" value="<?php echo $data['SeasonID'] ?>">
+ </td>
+ </tr>
+ <tr>
+ <td align="left" valign="top">
+ <?php echo _AM_DEFAULTSEASON;?>
+ </td>
+ <td align="left" valign="top">
+ <?php
+
+ if($data['SeasonDefault'] == 1)
+ echo"<input type=\"checkbox\" name=\"defseason\" value=\"1\" CHECKED>\n";
+ else
+ echo"<input type=\"checkbox\" name=\"defseason\" value=\"1\">\n";
+
+ ?>
+ </td>
+ </tr>
+
+ <tr>
+ <td align="left" valign="top">
+ <?php echo _AM_SEASONDRAWLINE;?>
+ </td>
+ <td align="left" valign="top">
+ <input type="text" name="drawline" value="<?= $data['SeasonLine'] ?>" size="10">
+ </td>
+ </tr>
+
+ <tr>
+ <td align="left" valign="top">
+ <?php echo _AM_SEASONPUBLISHED;?>
+ </td>
+ <td align="left" valign="top">
+ <?php
+ //
+ //If season is published
+ //
+ if($data['SeasonPublish'] == 1)
+ echo'<input type="checkbox" name="publish" value="1" CHECKED>';
+ ...
[truncated message content] |
