|
From: <be...@us...> - 2013-03-10 08:52:14
|
Revision: 11187
http://sourceforge.net/p/xoops/svn/11187
Author: beckmi
Date: 2013-03-10 08:52:08 +0000 (Sun, 10 Mar 2013)
Log Message:
-----------
Adding MatchDart and CricketStats
Added Paths:
-----------
XoopsModules/cricketstats/
XoopsModules/cricketstats/branches/
XoopsModules/cricketstats/releases/
XoopsModules/cricketstats/releases/1.1_RC1/
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/admin/
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/admin/head.php
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/admin/index.php
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/admin/leaguehead.php
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/admin/leaguematches.php
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/admin/leagues.php
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/admin/menu.php
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/admin/opponents.php
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/admin/seasons.php
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/blocks/
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/blocks/index.html
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/blocks/minitable.php
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/bottom.txt
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/change.php
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/docs/
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/docs/index.html
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/docs/license.txt
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/docs/manual_eng.txt
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/docs/readme_eng.txt
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/headtohead.php
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/images/
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/images/Thumbs.db
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/images/bg.png
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/images/close12.gif
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/images/cricketstats_slogo.png
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/images/empty.gif
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/images/index.html
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/images/left_both.png
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/images/line.gif
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/images/open12.gif
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/images/right_both.png
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/index.php
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/language/
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/language/english/
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/language/english/admin.php
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/language/english/blocks.php
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/language/english/index.html
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/language/english/main.php
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/language/english/modinfo.php
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/language/index.html
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/league.php
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/notes.txt
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/season.php
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/sql/
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/sql/index.html
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/sql/mysql.sql
XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/xoops_version.php
XoopsModules/cricketstats/trunk/
XoopsModules/cricketstats/trunk/cricketstats/
XoopsModules/cricketstats/trunk/cricketstats/admin/
XoopsModules/cricketstats/trunk/cricketstats/admin/head.php
XoopsModules/cricketstats/trunk/cricketstats/admin/index.php
XoopsModules/cricketstats/trunk/cricketstats/admin/leaguehead.php
XoopsModules/cricketstats/trunk/cricketstats/admin/leaguematches.php
XoopsModules/cricketstats/trunk/cricketstats/admin/leagues.php
XoopsModules/cricketstats/trunk/cricketstats/admin/menu.php
XoopsModules/cricketstats/trunk/cricketstats/admin/opponents.php
XoopsModules/cricketstats/trunk/cricketstats/admin/seasons.php
XoopsModules/cricketstats/trunk/cricketstats/blocks/
XoopsModules/cricketstats/trunk/cricketstats/blocks/index.html
XoopsModules/cricketstats/trunk/cricketstats/blocks/minitable.php
XoopsModules/cricketstats/trunk/cricketstats/bottom.txt
XoopsModules/cricketstats/trunk/cricketstats/change.php
XoopsModules/cricketstats/trunk/cricketstats/docs/
XoopsModules/cricketstats/trunk/cricketstats/docs/index.html
XoopsModules/cricketstats/trunk/cricketstats/docs/license.txt
XoopsModules/cricketstats/trunk/cricketstats/docs/manual_eng.txt
XoopsModules/cricketstats/trunk/cricketstats/docs/readme_eng.txt
XoopsModules/cricketstats/trunk/cricketstats/headtohead.php
XoopsModules/cricketstats/trunk/cricketstats/images/
XoopsModules/cricketstats/trunk/cricketstats/images/Thumbs.db
XoopsModules/cricketstats/trunk/cricketstats/images/bg.png
XoopsModules/cricketstats/trunk/cricketstats/images/close12.gif
XoopsModules/cricketstats/trunk/cricketstats/images/cricketstats_slogo.png
XoopsModules/cricketstats/trunk/cricketstats/images/empty.gif
XoopsModules/cricketstats/trunk/cricketstats/images/index.html
XoopsModules/cricketstats/trunk/cricketstats/images/left_both.png
XoopsModules/cricketstats/trunk/cricketstats/images/line.gif
XoopsModules/cricketstats/trunk/cricketstats/images/open12.gif
XoopsModules/cricketstats/trunk/cricketstats/images/right_both.png
XoopsModules/cricketstats/trunk/cricketstats/index.php
XoopsModules/cricketstats/trunk/cricketstats/language/
XoopsModules/cricketstats/trunk/cricketstats/language/english/
XoopsModules/cricketstats/trunk/cricketstats/language/english/admin.php
XoopsModules/cricketstats/trunk/cricketstats/language/english/blocks.php
XoopsModules/cricketstats/trunk/cricketstats/language/english/index.html
XoopsModules/cricketstats/trunk/cricketstats/language/english/main.php
XoopsModules/cricketstats/trunk/cricketstats/language/english/modinfo.php
XoopsModules/cricketstats/trunk/cricketstats/language/index.html
XoopsModules/cricketstats/trunk/cricketstats/league.php
XoopsModules/cricketstats/trunk/cricketstats/notes.txt
XoopsModules/cricketstats/trunk/cricketstats/season.php
XoopsModules/cricketstats/trunk/cricketstats/sql/
XoopsModules/cricketstats/trunk/cricketstats/sql/index.html
XoopsModules/cricketstats/trunk/cricketstats/sql/mysql.sql
XoopsModules/cricketstats/trunk/cricketstats/xoops_version.php
XoopsModules/matchdart/
XoopsModules/matchdart/branches/
XoopsModules/matchdart/releases/
XoopsModules/matchdart/releases/1.50/
XoopsModules/matchdart/releases/1.50/matchdart/
XoopsModules/matchdart/releases/1.50/matchdart/admin/
XoopsModules/matchdart/releases/1.50/matchdart/admin/about.php
XoopsModules/matchdart/releases/1.50/matchdart/admin/eventhead.php
XoopsModules/matchdart/releases/1.50/matchdart/admin/eventmatches.php
XoopsModules/matchdart/releases/1.50/matchdart/admin/events.php
XoopsModules/matchdart/releases/1.50/matchdart/admin/head.php
XoopsModules/matchdart/releases/1.50/matchdart/admin/index.php
XoopsModules/matchdart/releases/1.50/matchdart/admin/menu.php
XoopsModules/matchdart/releases/1.50/matchdart/admin/navbar.php
XoopsModules/matchdart/releases/1.50/matchdart/admin/permissions.php
XoopsModules/matchdart/releases/1.50/matchdart/admin/players.php
XoopsModules/matchdart/releases/1.50/matchdart/admin/seasons.php
XoopsModules/matchdart/releases/1.50/matchdart/admin/update.php
XoopsModules/matchdart/releases/1.50/matchdart/blocks/
XoopsModules/matchdart/releases/1.50/matchdart/blocks/index.html
XoopsModules/matchdart/releases/1.50/matchdart/blocks/minitable.php
XoopsModules/matchdart/releases/1.50/matchdart/changelog.txt
XoopsModules/matchdart/releases/1.50/matchdart/gpl.txt
XoopsModules/matchdart/releases/1.50/matchdart/images/
XoopsModules/matchdart/releases/1.50/matchdart/images/Screenshot.jpg
XoopsModules/matchdart/releases/1.50/matchdart/images/btn_delete.png
XoopsModules/matchdart/releases/1.50/matchdart/images/btn_modify.png
XoopsModules/matchdart/releases/1.50/matchdart/images/english/
XoopsModules/matchdart/releases/1.50/matchdart/images/english/btn_addnew.gif
XoopsModules/matchdart/releases/1.50/matchdart/images/german/
XoopsModules/matchdart/releases/1.50/matchdart/images/german/btn_addnew.gif
XoopsModules/matchdart/releases/1.50/matchdart/images/index.html
XoopsModules/matchdart/releases/1.50/matchdart/images/line.gif
XoopsModules/matchdart/releases/1.50/matchdart/images/matchdart_slogo.png
XoopsModules/matchdart/releases/1.50/matchdart/include/
XoopsModules/matchdart/releases/1.50/matchdart/include/functions.php
XoopsModules/matchdart/releases/1.50/matchdart/include/header.php
XoopsModules/matchdart/releases/1.50/matchdart/index.php
XoopsModules/matchdart/releases/1.50/matchdart/language/
XoopsModules/matchdart/releases/1.50/matchdart/language/english/
XoopsModules/matchdart/releases/1.50/matchdart/language/english/admin.php
XoopsModules/matchdart/releases/1.50/matchdart/language/english/blocks.php
XoopsModules/matchdart/releases/1.50/matchdart/language/english/index.html
XoopsModules/matchdart/releases/1.50/matchdart/language/english/main.php
XoopsModules/matchdart/releases/1.50/matchdart/language/english/modinfo.php
XoopsModules/matchdart/releases/1.50/matchdart/language/german/
XoopsModules/matchdart/releases/1.50/matchdart/language/german/admin.php
XoopsModules/matchdart/releases/1.50/matchdart/language/german/blocks.php
XoopsModules/matchdart/releases/1.50/matchdart/language/german/index.html
XoopsModules/matchdart/releases/1.50/matchdart/language/german/main.php
XoopsModules/matchdart/releases/1.50/matchdart/language/german/modinfo.php
XoopsModules/matchdart/releases/1.50/matchdart/language/index.html
XoopsModules/matchdart/releases/1.50/matchdart/license.txt
XoopsModules/matchdart/releases/1.50/matchdart/manual.txt
XoopsModules/matchdart/releases/1.50/matchdart/matches.php
XoopsModules/matchdart/releases/1.50/matchdart/pvp.php
XoopsModules/matchdart/releases/1.50/matchdart/readme.txt
XoopsModules/matchdart/releases/1.50/matchdart/sql/
XoopsModules/matchdart/releases/1.50/matchdart/sql/index.html
XoopsModules/matchdart/releases/1.50/matchdart/sql/mysql.sql
XoopsModules/matchdart/releases/1.50/matchdart/stats.php
XoopsModules/matchdart/releases/1.50/matchdart/templates/
XoopsModules/matchdart/releases/1.50/matchdart/templates/blocks/
XoopsModules/matchdart/releases/1.50/matchdart/templates/blocks/xd_block_minitable.html
XoopsModules/matchdart/releases/1.50/matchdart/templates/index.html
XoopsModules/matchdart/releases/1.50/matchdart/templates/xd_index.html
XoopsModules/matchdart/releases/1.50/matchdart/templates/xd_matches_form.html
XoopsModules/matchdart/releases/1.50/matchdart/templates/xd_matches_main.html
XoopsModules/matchdart/releases/1.50/matchdart/templates/xd_pvp.html
XoopsModules/matchdart/releases/1.50/matchdart/templates/xd_select_header.html
XoopsModules/matchdart/releases/1.50/matchdart/templates/xd_stats.html
XoopsModules/matchdart/releases/1.50/matchdart/xoops_version.php
XoopsModules/matchdart/trunk/
XoopsModules/matchdart/trunk/matchdart/
XoopsModules/matchdart/trunk/matchdart/admin/
XoopsModules/matchdart/trunk/matchdart/admin/about.php
XoopsModules/matchdart/trunk/matchdart/admin/eventhead.php
XoopsModules/matchdart/trunk/matchdart/admin/eventmatches.php
XoopsModules/matchdart/trunk/matchdart/admin/events.php
XoopsModules/matchdart/trunk/matchdart/admin/head.php
XoopsModules/matchdart/trunk/matchdart/admin/index.php
XoopsModules/matchdart/trunk/matchdart/admin/menu.php
XoopsModules/matchdart/trunk/matchdart/admin/navbar.php
XoopsModules/matchdart/trunk/matchdart/admin/permissions.php
XoopsModules/matchdart/trunk/matchdart/admin/players.php
XoopsModules/matchdart/trunk/matchdart/admin/seasons.php
XoopsModules/matchdart/trunk/matchdart/admin/update.php
XoopsModules/matchdart/trunk/matchdart/blocks/
XoopsModules/matchdart/trunk/matchdart/blocks/index.html
XoopsModules/matchdart/trunk/matchdart/blocks/minitable.php
XoopsModules/matchdart/trunk/matchdart/changelog.txt
XoopsModules/matchdart/trunk/matchdart/gpl.txt
XoopsModules/matchdart/trunk/matchdart/images/
XoopsModules/matchdart/trunk/matchdart/images/Screenshot.jpg
XoopsModules/matchdart/trunk/matchdart/images/btn_delete.png
XoopsModules/matchdart/trunk/matchdart/images/btn_modify.png
XoopsModules/matchdart/trunk/matchdart/images/english/
XoopsModules/matchdart/trunk/matchdart/images/english/btn_addnew.gif
XoopsModules/matchdart/trunk/matchdart/images/german/
XoopsModules/matchdart/trunk/matchdart/images/german/btn_addnew.gif
XoopsModules/matchdart/trunk/matchdart/images/index.html
XoopsModules/matchdart/trunk/matchdart/images/line.gif
XoopsModules/matchdart/trunk/matchdart/images/matchdart_slogo.png
XoopsModules/matchdart/trunk/matchdart/include/
XoopsModules/matchdart/trunk/matchdart/include/functions.php
XoopsModules/matchdart/trunk/matchdart/include/header.php
XoopsModules/matchdart/trunk/matchdart/index.php
XoopsModules/matchdart/trunk/matchdart/language/
XoopsModules/matchdart/trunk/matchdart/language/english/
XoopsModules/matchdart/trunk/matchdart/language/english/admin.php
XoopsModules/matchdart/trunk/matchdart/language/english/blocks.php
XoopsModules/matchdart/trunk/matchdart/language/english/index.html
XoopsModules/matchdart/trunk/matchdart/language/english/main.php
XoopsModules/matchdart/trunk/matchdart/language/english/modinfo.php
XoopsModules/matchdart/trunk/matchdart/language/german/
XoopsModules/matchdart/trunk/matchdart/language/german/admin.php
XoopsModules/matchdart/trunk/matchdart/language/german/blocks.php
XoopsModules/matchdart/trunk/matchdart/language/german/index.html
XoopsModules/matchdart/trunk/matchdart/language/german/main.php
XoopsModules/matchdart/trunk/matchdart/language/german/modinfo.php
XoopsModules/matchdart/trunk/matchdart/language/index.html
XoopsModules/matchdart/trunk/matchdart/license.txt
XoopsModules/matchdart/trunk/matchdart/manual.txt
XoopsModules/matchdart/trunk/matchdart/matches.php
XoopsModules/matchdart/trunk/matchdart/pvp.php
XoopsModules/matchdart/trunk/matchdart/readme.txt
XoopsModules/matchdart/trunk/matchdart/sql/
XoopsModules/matchdart/trunk/matchdart/sql/index.html
XoopsModules/matchdart/trunk/matchdart/sql/mysql.sql
XoopsModules/matchdart/trunk/matchdart/stats.php
XoopsModules/matchdart/trunk/matchdart/templates/
XoopsModules/matchdart/trunk/matchdart/templates/blocks/
XoopsModules/matchdart/trunk/matchdart/templates/blocks/xd_block_minitable.html
XoopsModules/matchdart/trunk/matchdart/templates/index.html
XoopsModules/matchdart/trunk/matchdart/templates/xd_index.html
XoopsModules/matchdart/trunk/matchdart/templates/xd_matches_form.html
XoopsModules/matchdart/trunk/matchdart/templates/xd_matches_main.html
XoopsModules/matchdart/trunk/matchdart/templates/xd_pvp.html
XoopsModules/matchdart/trunk/matchdart/templates/xd_select_header.html
XoopsModules/matchdart/trunk/matchdart/templates/xd_stats.html
XoopsModules/matchdart/trunk/matchdart/xoops_version.php
Added: XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/admin/head.php
===================================================================
--- XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/admin/head.php (rev 0)
+++ XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/admin/head.php 2013-03-10 08:52:08 UTC (rev 11187)
@@ -0,0 +1,77 @@
+<?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
+
+Cricket League Version & Modifications by M0nty <vau...@gm...>
+
+************************************************************
+*/
+if(!session_is_registered('season_name') || !session_is_registered('season_id'))
+{
+ echo "<form method=\"post\" action=\"leaguematches.php\">";
+ echo '<b><?php echo _AM_CRICK_CHOSEASON;?></b>';
+ echo '<select name="season_select">';
+ $cricket_get_seasons = $xoopsDB->query("SELECT * FROM ".$xoopsDB->prefix("cricket_seasonnames")." ORDER BY SeasonName");
+
+ while($cricket_sdata = $xoopsDB->fetchArray($cricket_get_seasons))
+ {
+ echo "<option value=\"$cricket_sdata[SeasonID]____$cricket_sdata[SeasonName]\">$cricket_sdata[SeasonName]</option>\n";
+ }
+ echo "</select> <input type=\"submit\" name=\"submit\" value=" ._AM_CRICK_SEASONGO. "></form>";
+
+
+ mysql_free_result($cricket_get_seasons);
+}
+else
+{
+ $cricket_season_name = $_SESSION['season_name'];
+ echo "<form method=\"post\" action=\"leaguematches.php\">";
+ echo "<b> "._AM_CRICK_SEASELECT." $cricket_season_name</b><br><br>";
+ echo _AM_CRICK_SEASELDROP;
+ echo '<select name="season_select">';
+
+ $cricket_get_seasons = $xoopsDB->query("SELECT * FROM ".$xoopsDB->prefix("cricket_seasonnames")." ORDER BY SeasonName");
+
+ while($cricket_sdata = $xoopsDB->fetchArray($cricket_get_seasons))
+ {
+ if($cricket_sdata['SeasonID'] == $cricket_seasonid)
+ echo "<option value=\"$cricket_sdata[SeasonID]____$cricket_sdata[SeasonName]\" SELECTED>$cricket_sdata[SeasonName]</option>\n";
+ else
+ echo "<option value=\"$cricket_sdata[SeasonID]____$cricket_sdata[SeasonName]\">$cricket_sdata[SeasonName]</option>\n";
+ }
+ echo "</select> <input type=\"submit\" name=\"submit\" value=" ._AM_CRICK_SEASONGO. "></form>";
+
+ mysql_free_result($cricket_get_seasons);
+}
+
+?>
+
+<hr width="100%">
+
+</center>
\ No newline at end of file
Added: XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/admin/index.php
===================================================================
--- XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/admin/index.php (rev 0)
+++ XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/admin/index.php 2013-03-10 08:52:08 UTC (rev 11187)
@@ -0,0 +1,44 @@
+<?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
+
+Cricket League Version & Modifications by M0nty <vau...@gm...>
+
+************************************************************
+*/
+
+
+include '../../../include/cp_header.php'; //Include file, which checks for permissions and sets navigation
+
+xoops_cp_header();
+
+header("Location:leaguematches.php");
+
+xoops_cp_footer();
+?>
\ No newline at end of file
Added: XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/admin/leaguehead.php
===================================================================
--- XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/admin/leaguehead.php (rev 0)
+++ XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/admin/leaguehead.php 2013-03-10 08:52:08 UTC (rev 11187)
@@ -0,0 +1,76 @@
+<?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
+
+Cricket League Version & Modifications by M0nty <vau...@gm...>
+
+************************************************************
+*/
+if(!session_is_registered('league_name') || !session_is_registered('league_id'))
+{
+ echo "<form method=\"post\" action=\"leaguematches.php\">";
+ echo '<b><?php echo _AM_CRICK_CHOLEAGUE;?></b>';
+ echo '<select name="league_select">';
+ $cricket_get_leagues = $xoopsDB->query("SELECT * FROM ".$xoopsDB->prefix("cricket_leaguenames")." ORDER BY LeagueName");
+
+ while($cricket_sdata = $xoopsDB->fetchArray($cricket_get_leagues))
+ {
+ echo "<option value=\"$cricket_sdata[LeagueID]____$cricket_sdata[LeagueName]\">$cricket_sdata[LeagueName]</option>\n";
+ }
+ echo "</select> <input type=\"submit\" name=\"submit1\" value=" ._AM_CRICK_LEAGUEGO. "></form>";
+
+
+ mysql_free_result($cricket_get_leagues);
+}
+else
+{
+ $cricket_league_name = $_SESSION['league_name'];
+ echo "<form method=\"post\" action=\"leaguematches.php\">";
+ echo "<b> "._AM_CRICK_LEAGUESELECT." $cricket_league_name</b><br><br>";
+ echo _AM_CRICK_LEAGUESELDROP;
+ echo '<select name="league_select">';
+
+ $cricket_get_leagues = $xoopsDB->query("SELECT * FROM ".$xoopsDB->prefix("cricket_leaguenames")." ORDER BY LeagueName");
+
+ while($cricket_sdata = $xoopsDB->fetchArray($cricket_get_leagues))
+ {
+ if($cricket_sdata['LeagueID'] == $cricket_leagueid)
+ echo "<option value=\"$cricket_sdata[LeagueID]____$cricket_sdata[LeagueName]\" SELECTED>$cricket_sdata[LeagueName]</option>\n";
+ else
+ echo "<option value=\"$cricket_sdata[LeagueID]____$cricket_sdata[LeagueName]\">$cricket_sdata[LeagueName]</option>\n";
+ }
+ echo "</select> <input type=\"submit\" name=\"submit1\" value=" ._AM_CRICK_LEAGUEGO. "></form>";
+
+ mysql_free_result($cricket_get_leagues);
+}
+?>
+
+<hr width="100%">
+
+</center>
\ No newline at end of file
Added: XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/admin/leaguematches.php
===================================================================
--- XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/admin/leaguematches.php (rev 0)
+++ XoopsModules/cricketstats/releases/1.1_RC1/cricketstats/admin/leaguematches.php 2013-03-10 08:52:08 UTC (rev 11187)
@@ -0,0 +1,1107 @@
+<?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
+
+Cricket League Version & Modifications by M0nty <vau...@gm...>
+
+************************************************************
+*/
+
+//Include file, which checks for permissions and sets navigation
+include '../../../include/cp_header.php';
+
+if (isset($_POST['season_select'])) {
+ $cricket_season = explode("____",$_POST['season_select']);
+}
+elseif (isset($_POST['seasonid'])) {
+ $cricket_season = array ($_POST['seasonid'], $_POST['seasonname']);
+}
+elseif (!isset($_SESSION['season_id'])) {
+ $sql = "SELECT SeasonID, SeasonName FROM ".$xoopsDB->prefix("cricket_seasonnames")." WHERE SeasonDefault=1";
+ $cricket_seasonname = $xoopsDB->query($sql);
+ $cricket_seasonname = $xoopsDB->fetchArray($cricket_seasonname);
+ $cricket_season = array($cricket_seasonname['SeasonID'], $cricket_seasonname['SeasonName']);
+}
+else {
+ $cricket_season = array($_SESSION['season_id'], $_SESSION['season_name']);
+}
+
+if (isset($_POST['league_select'])) {
+ $cricket_league = explode("____",$_POST['league_select']);
+}
+elseif (isset($_POST['leagueid'])) {
+ $cricket_league = array ($_POST['leagueid'], $_POST['leaguename']);
+}
+elseif (!isset($_SESSION['league_id'])) {
+ $sql2 = "SELECT LeagueID, LeagueName FROM ".$xoopsDB->prefix("cricket_leaguenames")." WHERE LeagueDefault=1";
+ $cricket_leaguename = $xoopsDB->query($sql2);
+ $cricket_leaguename = $xoopsDB->fetchArray($cricket_leaguename);
+ $cricket_league = array($cricket_leaguename['LeagueID'], $cricket_leaguename['LeagueName']);
+}
+else {
+ $cricket_league = array($_SESSION['league_id'], $_SESSION['league_name']);
+}
+
+$_SESSION['season_id'] = $cricket_season[0];
+$_SESSION['season_name'] = $cricket_season[1];
+$cricket_seasonid = $_SESSION['season_id'];
+$cricket_seasonname = $_SESSION['season_name'];
+$_SESSION['league_id'] = $cricket_league[0];
+$_SESSION['league_name'] = $cricket_league[1];
+$cricket_leagueid = $_SESSION['league_id'];
+$cricket_leaguename = $_SESSION['league_name'];
+
+$PHP_SELF = $_SERVER['PHP_SELF'];
+$cricket_action = isset($_GET['action']) ? $_GET['action'] : null;
+$cricket_action = isset($_POST['action']) ? $_POST['action'] : $cricket_action;
+
+$cricket_add_submit = isset($_POST['add_submit']) ? $_POST['add_submit'] : false;
+$cricket_modify_submit = isset($_POST['modify_submit']) ? $_POST['modify_submit'] : false;
+$cricket_delete_submit = isset($_POST['delete_submit']) ? $_POST['delete_submit'] : false;
+$cricket_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_CRICK_NAVSEASONS;?></a></td>
+ <td align="center" style="padding: 3px;background-color: #FFFFFF; border:1px #000000 dotted;">
+ <a href="leagues.php"><?php echo _AM_CRICK_NAVLEAGUES;?></a></td>
+ <td align="center" style="padding: 3px;background-color: #FFFFFF; border:1px #000000 dotted;">
+ <a href="opponents.php"><?php echo _AM_CRICK_NAVOPPONENTS;?></a></td>
+ <td align="center" nowrap style="padding: 3px;background-color: #E6E6FF; border:1px #000000 dotted;">
+ <a href="leaguematches.php"><?php echo _AM_CRICK_NAVLEAGUEMATCHES;?></a></td>
+ <td align="center" style="padding: 3px;background-color: #FFFFFF; border:1px #000000 dotted;">
+ <a href="../index.php"><?php echo _AM_CRICK_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("cricket_opponents")." WHERE OpponentLeagueID = $cricket_leagueid AND OpponentSeasonID = $cricket_seasonid");
+
+if($xoopsDB->getRowsNum($query) < 2)
+{
+ echo "<br><br>"._AM_CRICK_ADDTWOTEAMS."<br><br>
+ <a href=\"opponents.php\">" ._AM_CRICK_ADDTEAMS. "</a>";
+ exit();
+}
+
+if($cricket_add_submit)
+{
+ $year = $cricket_seasonname;
+ $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']; //home team id
+ $away = $_POST['away']; //away team id
+ $home_bpoints = $_POST['home_bpoints']; //home team bonus points
+ $away_bpoints = $_POST['away_bpoints']; //home team bonus points
+ $home_runs = $_POST['home_runs'];
+ $home_wickets = $_POST['home_wickets'];
+ $away_runs = $_POST['away_runs'];
+ $away_wickets = $_POST['away_wickets'];
+
+ //Set the default
+ $home_bonus = -1;
+ $away_bonus = -1;
+ $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_bpoints[$i] = $home_bpoints[$i] != null ? intval($home_bpoints[$i]) : null;
+ $away_bpoints[$i] = $away_bpoints[$i] != null ? intval($away_bpoints[$i]) : null;
+ $home_runs[$i] = $home_runs[$i] != null ? intval($home_runs[$i]) : null;
+ $home_wickets[$i] = $home_wickets[$i] != null ? intval($home_wickets[$i]) : null;
+ $away_runs[$i] = $away_runs[$i] != null ? intval($away_runs[$i]) : null;
+ $away_wickets[$i] = $away_wickets[$i] != null ? intval($away_wickets[$i]) : null;
+
+ //Home team wins
+ if($home_runs[$i] > $away_runs[$i])
+ {
+ $home_winner = $home[$i];
+ $away_loser = $away[$i];
+ $home_bonus = $home_bpoints[$i];
+ $away_bonus = $away_bpoints[$i];
+ }
+
+ //Away win
+ elseif($home_runs[$i] < $away_runs[$i])
+ {
+ $away_winner = $away[$i];
+ $home_loser = $home[$i];
+ $home_bonus = $home_bpoints[$i];
+ $away_bonus = $away_bpoints[$i];
+ }
+
+ //Draw
+ elseif($home_runs[$i] == $away_runs[$i])
+ {
+ $home_tie = $home[$i];
+ $away_tie = $away[$i];
+ $home_bonus = $home_bpoints[$i];
+ $away_bonus = $away_bpoints[$i];
+ }
+
+ //query to check if home or away team already exists in the current day
+ $query = $xoopsDB->query("SELECT LM.LeagueMatchID FROM
+ ".$xoopsDB->prefix("cricket_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_runs[$i] !== null) && ($home_runs[$i] !== null)) {
+ $xoopsDB->query("INSERT INTO ".$xoopsDB->prefix("cricket_leaguematches")." SET
+ LeagueMatchSeasonID = '$cricket_seasonid',
+ LeagueMatchLeagueID = '$cricket_leagueid',
+ LeagueMatchDate = '$dateandtime',
+ LeagueMatchHomeID = '$home[$i]',
+ LeagueMatchAwayID = '$away[$i]',
+ LeagueMatchHomeWinnerID = '$home_winner',
+ LeagueMatchHomeLoserID = '$home_loser',
+ LeagueMatchHomeBonus = '$home_bonus',
+ LeagueMatchAwayBonus = '$away_bonus',
+ LeagueMatchHomeBpoints = '$home_bpoints[$i]',
+ LeagueMatchAwayBpoints = '$away_bpoints[$i]',
+ LeagueMatchAwayWinnerID = '$away_winner',
+ LeagueMatchAwayLoserID = '$away_loser',
+ LeagueMatchHomeTieID = '$home_tie',
+ LeagueMatchAwayTieID = '$away_tie',
+ LeagueMatchHomeRuns = '$home_runs[$i]',
+ LeagueMatchHomeWickets = '$home_wickets[$i]',
+ LeagueMatchAwayRuns = '$away_runs[$i]',
+ LeagueMatchAwayWickets = '$away_wickets[$i]',
+ LeagueMatchCreated = ".time()."
+ ");
+ }
+ else {
+ $xoopsDB->query("INSERT INTO ".$xoopsDB->prefix("cricket_leaguematches")." SET
+ LeagueMatchSeasonID = '$cricket_seasonid',
+ LeagueMatchLeagueID = '$cricket_leagueid',
+ LeagueMatchDate = '$dateandtime',
+ LeagueMatchHomeID = '$home[$i]',
+ LeagueMatchAwayID = '$away[$i]',
+ LeagueMatchHomeBonus = '-1',
+ LeagueMatchAwayBonus = '-1',
+ LeagueMatchHomeWinnerID = '-1',
+ LeagueMatchHomeLoserID = '-1',
+ LeagueMatchAwayWinnerID = '-1',
+ LeagueMatchAwayLoserID = '-1',
+ LeagueMatchHomeTieID = '-1',
+ LeagueMatchAwayTieID = '-1',
+ LeagueMatchCreated = ".time()."
+ ");
+ }
+ }
+ }
+ $i++;
+ }
+}
+elseif($cricket_modifyall_submit)
+{
+ $year = $cricket_seasonname;
+ $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("cricket_leaguematches")."
+ WHERE LeagueMatchDate = '$dateandtime'
+ ");
+
+ //Check the submitted form
+ $i = 0;
+ $home = $_POST['home']; //home team id
+ $away = $_POST['away']; //away team id
+ $home_bpoints = $_POST['home_bpoints']; //home team bonus points
+ $away_bpoints = $_POST['away_bpoints']; //away team bonus points
+ $home_runs = $_POST['home_runs'];
+ $home_wickets = $_POST['home_wickets'];
+ $away_runs = $_POST['away_runs'];
+ $away_wickets = $_POST['away_wickets'];
+ while($i < $qty)
+ {
+ $home[$i] = intval($home[$i]);
+ $away[$i] = intval($away[$i]);
+ $home_bpoints[$i] = $home_bpoints[$i] != null ? intval($home_bpoints[$i]) : null;
+ $away_bpoints[$i] = $away_bpoints[$i] != null ? intval($away_bpoints[$i]) : null;
+ $home_runs[$i] = $home_runs[$i] != null ? intval($home_runs[$i]) : null;
+ $home_wickets[$i] = $home_wickets[$i] != null ? intval($home_wickets[$i]) : null;
+ $away_runs[$i] = $away_runs[$i] != null ? intval($away_runs[$i]) : null;
+ $away_wickets[$i] = $away_wickets[$i] != null ? intval($away_wickets[$i]) : null;
+
+ //Set default
+ $home_bonus = -1;
+ $away_bonus = -1;
+ $home_winner = -1;
+ $home_loser = -1;
+ $home_tie = -1;
+ $away_winner = -1;
+ $away_loser = -1;
+ $away_tie = -1;
+
+ //Home wins
+ if($home_runs[$i] > $away_runs[$i])
+ {
+ $home_winner = $home[$i];
+ $away_loser = $away[$i];
+ $home_bonus = $home_bpoints[$i];
+ $away_bonus = $away_bpoints[$i];
+ }
+
+ //Away wins
+ elseif($home_runs[$i] < $away_runs[$i])
+ {
+ $away_winner = $away[$i];
+ $home_loser = $home[$i];
+ $home_bonus = $home_bpoints[$i];
+ $away_bonus = $away_bpoints[$i];
+ }
+
+ //Draw
+ elseif($home_runs[$i] == $away_runs[$i])
+ {
+ $home_tie = $home[$i];
+ $away_tie = $away[$i];
+ $home_bonus = $home_bpoints[$i];
+ $away_bonus = $away_bpoints[$i];
+ }
+
+ if (($home_runs[$i] !== null) && ($away_runs[$i] !== null)) {
+ $xoopsDB->query("INSERT INTO ".$xoopsDB->prefix("cricket_leaguematches")." SET
+ LeagueMatchSeasonID = '$cricket_seasonid',
+ LeagueMatchLeagueID = '$cricket_leagueid',
+ LeagueMatchDate = '$dateandtime',
+ LeagueMatchHomeID = '$home[$i]',
+ LeagueMatchAwayID = '$away[$i]',
+ LeagueMatchHomeBonus = '$home_bonus',
+ LeagueMatchAwayBonus = '$away_bonus',
+ LeagueMatchHomeBpoints = '$home_bpoints[$i]',
+ LeagueMatchAwayBpoints = '$away_bpoints[$i]',
+ LeagueMatchHomeWinnerID = '$home_winner',
+ LeagueMatchHomeLoserID = '$home_loser',
+ LeagueMatchAwayWinnerID = '$away_winner',
+ LeagueMatchAwayLoserID = '$away_loser',
+ LeagueMatchHomeTieID = '$home_tie',
+ LeagueMatchAwayTieID = '$away_tie',
+ LeagueMatchHomeRuns = '$home_runs[$i]',
+ LeagueMatchHomeWickets = '$home_wickets[$i]',
+ LeagueMatchAwayRuns = '$away_runs[$i]',
+ LeagueMatchAwayWickets = '$away_wickets[$i]',
+ LeagueMatchCreated = ".time()."
+ ");
+ }
+ else {
+ $xoopsDB->query("INSERT INTO ".$xoopsDB->prefix("cricket_leaguematches")." SET
+ LeagueMatchSeasonID = '$cricket_seasonid',
+ LeagueMatchLeagueID = '$cricket_leagueid',
+ LeagueMatchDate = '$dateandtime',
+ LeagueMatchHomeID = '$home[$i]',
+ LeagueMatchAwayID = '$away[$i]',
+ LeagueMatchHomeBonus = '-1',
+ LeagueMatchAwayBonus = '-1',
+ LeagueMatchHomeWinnerID = '-1',
+ LeagueMatchHomeLoserID = '-1',
+ LeagueMatchAwayWinnerID = '-1',
+ LeagueMatchAwayLoserID = '-1',
+ LeagueMatchHomeTieID = '-1',
+ LeagueMatchAwayTieID = '-1',
+ LeagueMatchCreated = ".time()."
+ ");
+ }
+ $i++;
+ }
+}
+elseif($cricket_modify_submit)
+{
+ $mid = intval($_POST['mid']);
+ $homeid = intval($_POST['homeid']);
+ $awayid = intval($_POST['awayid']);
+ $year = $cricket_seasonname;
+ $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_bpoints = $_POST['home_bpoints'] != null ? intval($_POST['home_bpoints']) : null;
+ $away_bpoints = $_POST['away_bpoints'] != null ? intval($_POST['away_bpoints']) : null;
+ $home_runs = $_POST['home_runs'] != null ? intval($_POST['home_runs']) : null;
+ $home_wickets = $_POST['home_wickets'] != null ? intval($_POST['home_wickets']) : null;
+ $away_runs = $_POST['home_runs'] != null ? intval($_POST['away_runs']) : null;
+ $away_wickets = $_POST['home_wickets'] != null ? intval($_POST['away_wickets']) : null;
+
+ //Set default
+ $home_bonus = -1;
+ $home_bonus = -1;
+ $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_runs > $away_runs)
+ {
+ $home_winner = $home;
+ $away_loser = $away;
+ $home_bonus = $home_bpoints;
+ $away_bonus = $away_bpoints;
+ }
+
+ //Away wins
+ elseif($home_runs < $away_runs)
+ {
+ $away_winner = $away;
+ $home_loser = $home;
+ $home_bonus = $home_bpoints;
+ $away_bonus = $away_bpoints;
+ }
+
+ //Draw
+ elseif($home_runs == $away_runs)
+ {
+ $home_tie = $home;
+ $away_tie = $away;
+ $home_bonus = $home_bpoints;
+ $away_bonus = $away_bpoints;
+ }
+
+ //query to check if home or away team already exists in the current day
+ $query = $xoopsDB->query("SELECT LM.LeagueMatchID FROM
+ ".$xoopsDB->prefix("cricket_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_runs !== null) && ($away_runs !== null)) {
+ $xoopsDB->query("UPDATE ".$xoopsDB->prefix("cricket_leaguematches")." SET
+ LeagueMatchDate = '$dateandtime',
+ LeagueMatchHomeID = '$home',
+ LeagueMatchAwayID = '$away',
+ LeagueMatchHomeBonus = '$home_bonus',
+ LeagueMatchAwayBonus = '$away_bonus',
+ LeagueMatchHomeBpoints = '$home_bpoints',
+ LeagueMatchAwayBpoints = '$away_bpoints',
+ LeagueMatchHomeWinnerID = '$home_winner',
+ LeagueMatchHomeLoserID = '$home_loser',
+ LeagueMatchAwayWinnerID = '$away_winner',
+ LeagueMatchAwayLoserID = '$away_loser',
+ LeagueMatchHomeTieID = '$home_tie',
+ LeagueMatchAwayTieID = '$away_tie',
+ LeagueMatchHomeRuns = '$home_runs',
+ LeagueMatchHomeWickets = '$home_wickets',
+ LeagueMatchAwayRuns = '$away_runs',
+ LeagueMatchAwayWickets = '$away_wickets',
+ LeagueMatchCreated = ".time()."
+ WHERE LeagueMatchID = '$mid'
+ LIMIT 1
+ ");
+ }
+ else {
+ $xoopsDB->query("UPDATE ".$xoopsDB->prefix("cricket_leaguematches")." SET
+ LeagueMatchDate = '$dateandtime',
+ LeagueMatchHomeID = '$home',
+ LeagueMatchAwayID = '$away',
+ LeagueMatchHomeBonus = '-1',
+ LeagueMatchAwayBonus = '-1',
+ LeagueMatchHomeBpoints = NULL,
+ LeagueMatchAwayBpoints = NULL,
+ LeagueMatchHomeWinnerID = '-1',
+ LeagueMatchHomeLoserID = '-1',
+ LeagueMatchAwayWinnerID = '-1',
+ LeagueMatchAwayLoserID = '-1',
+ LeagueMatchHomeTieID = '-1',
+ LeagueMatchAwayTieID = '-1',
+ LeagueMatchHomeRuns = NULL,
+ LeagueMatchHomeWickets = NULL,
+ LeagueMatchAwayRuns = NULL,
+ LeagueMatchAwayWickets = NULL,
+ LeagueMatchCreated = ".time()."
+ WHERE LeagueMatchID = '$mid'
+ LIMIT 1
+ ");
+ }
+ }
+ }
+}
+elseif($cricket_delete_submit)
+{
+ $mid = intval($_POST['mid']);
+ $xoopsDB->query("DELETE FROM ".$xoopsDB->prefix("cricket_leaguematches")." WHERE LeagueMatchID = '$mid' LIMIT 1");
+}
+
+ ?>
+
+ <?php
+ include('head.php');
+ include('leaguehead.php');
+ ?>
+
+ <table align="center" width="700">
+ <tr>
+ <td align="left" valign="top">
+ <form method="post" action="<?php echo "$PHP_SELF"?>">
+ <?php
+ if(!isset($cricket_action))
+ {
+ ?>
+ <h3><?php echo _AM_CRICK_ADDMATCH;?></h3>
+ <?php echo _AM_CRICK_ADDMATCHNOTE;?><br><br>
+
+ <?php echo _AM_CRICK_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 = $cricket_seasonname ; $i < $cricket_seasonname+1 ; $i++)
+ {
+ if($i<10)
+ {
+ $i = "0".$cricket_seasonname;
+ }
+ if($i == $cricket_seasonname)
+ echo "<option value=\"$i\" SELECTED>$i</option>\n";
+ else
+ echo "<option value=\"$i\">$i</option>\n";
+ }
+ ?>
+ </select><br><br>
+ <?php echo _AM_CRICK_ADDMATCHNOTE2;?><br><br>
+
+ <table width="100%" cellspacing="3" cellpadding="3" border="0">
+ <tr>
+ <td align="left" valign="middle"><b><?php echo _AM_CRICK_HOMETEAM;?></b></td>
+ <td align="center" valign="middle"><b><?php echo _AM_CRICK_BONUSPOINTS;?></b></td>
+ <td align="center" valign="middle"><b><?php echo _AM_CRICK_RUNS;?></b></td>
+ <td align="center" valign="middle"><b><?php echo _AM_CRICK_WICKETS;?></b></td>
+ <td align="left" valign="middle"><b><?php echo _AM_CRICK_AWAYTEAM;?></b></td>
+ <td align="center" valign="middle"><b><?php echo _AM_CRICK_BONUSPOINTS;?></b></td>
+ <td align="center" valign="middle"><b><?php echo _AM_CRICK_RUNS;?></b></td>
+ <td align="center" valign="middle"><b><?php echo _AM_CRICK_WICKETS;?></b></td>
+ </tr>
+
+ <?php
+ //query to get all the teams
+ $cricket_get_opponents = $xoopsDB->query("SELECT OpponentID AS id,
+ OpponentName AS name
+ FROM ".$xoopsDB->prefix("cricket_opponents")." WHERE OpponentLeagueID = $cricket_leagueid AND OpponentSeasonID = $cricket_seasonid
+ 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($cricket_get_opponents, 0);
+
+ echo'
+ <tr>
+ <td align="left" valign="middle">
+ ';
+
+ echo"<select name=\"home[$i]\">";
+
+ while($cricket_data = $xoopsDB->fetchArray($cricket_get_opponents))
+ {
+ echo"<option value=\"$cricket_data[id]\">$cricket_data[name]</option>\n";
+ }
+
+ echo'
+ </select>
+ </td>
+ ';
+
+ echo"
+ <td align=\"center\" valign=\"middle\"><input type=\"text\" name=\"home_bpoints[$i]\" size=\"2\"></td>
+ <td align=\"center\" valign=\"middle\"><input type=\"text\" name=\"home_runs[$i]\" size=\"2\"></td>
+ <td align=\"center\" valign=\"middle\"><input type=\"text\" name=\"home_wickets[$i]\" size=\"2\"></td>
+ ";
+
+ echo'
+ <td align="left" valign="middle">
+ ';
+
+ //Back to line 0 in the query
+ mysql_data_seek($cricket_get_opponents, 0);
+
+ echo"<select name=\"away[$i]\">";
+
+ while($cricket_data = $xoopsDB->fetchArray($cricket_get_opponents))
+ {
+ echo"<option value=\"$cricket_data[id]\">$cricket_data[name]</option>\n";
+ }
+
+ echo"
+ </select>
+ </td>
+ ";
+
+ echo"
+ <td align=\"center\" valign=\"middle\"><input type=\"text\" name=\"away_bpoints[$i]\" size=\"2\"></td>
+ <td align=\"center\" valign=\"middle\"><input type=\"text\" name=\"away_runs[$i]\" size=\"2\"></td>
+ <td align=\"center\" valign=\"middle\"><input type=\"text\" name=\"away_wickets[$i]\" size=\"2\"></td>
+ </tr>
+ ";
+
+ $i++;
+ }
+ ?>
+
+ </table><br><br>
+ <input type="hidden" name="seasonid" value="<?php echo $cricket_seasonid; ?>">
+ <input type="hidden" name="seasonname" value="<?php echo $cricket_seasonname; ?>">
+ <input type="hidden" name="leagueid" value="<?php echo $cricket_leagueid; ?>">
+ <input type="hidden" name="leaguename" value="<?php echo $cricket_leaguename; ?>">
+ <input type="submit" name="add_submit" value="<?php echo _AM_CRICK_ADDMATCHES;?>">
+ </form>
+ <?php
+ }
+ elseif($cricket_action == 'modifyall')
+ {
+ $date = $_REQUEST['date'];
+
+ $cricket_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.LeagueMatchHomeBpoints AS homebpoints,
+ LM.LeagueMatchAwayBpoints AS awaybpoints,
+ LM.LeagueMatchHomeRuns AS homeruns,
+ LM.LeagueMatchHomeWickets AS homewickets,
+ LM.LeagueMatchAwayRuns AS awayruns,
+ LM.LeagueMatchAwayWickets AS awaywickets
+ FROM ".$xoopsDB->prefix("cricket_leaguematches")." LM
+ WHERE LM.LeaguematchDate = '$date'
+ ");
+
+ //query to get date
+ $cricket_get_match = $xoopsDB->query("SELECT DAYOFMONTH(LM.LeagueMatchDate) AS dayofmonth,
+ MONTH(LM.LeagueMatchDate) AS month,
+ YEAR(LM.LeagueMatchDate) AS year
+ FROM ".$xoopsDB->prefix("cricket_leaguematches")." LM
+ WHERE LM.LeaguematchDate = '$date'
+ LIMIT 1
+ ");
+
+ $datedata = $xoopsDB->fetchArray($cricket_get_match);
+
+ $cricket_get_opponents = $xoopsDB->query("SELECT OpponentID AS id,
+ OpponentName AS name
+ FROM ".$xoopsDB->prefix("cricket_opponents")." WHERE OpponentLeagueID = $cricket_leagueid AND OpponentSeasonID = $cricket_seasonid
+ ORDER BY OpponentName
+ ");
+ ?>
+
+ <form method="post" action="<?php echo "$PHP_SELF" ?>">
+ <h3><?php echo _AM_CRICK_MODMATCHES;?></h3>
+
+ <table width="100%" cellspacing="3" cellpadding="3" border="0">
+
+ <tr>
+ <td align="left" valign="top">
+ <?php echo _AM_CRICK_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 = $cricket_seasonname ; $i < $cricket_seasonname+1 ; $i++)
+ {
+ if($i<10)
+ {
+ $i = "0".$cricket_seasonname;
+ }
+ if($datedata['year'] == $cricket_seasonname)
+ 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_CRICK_HOMETEAM;?></b></td>
+ <td align="center" valign="middle"><b><?php echo _AM_CRICK_BONUSPOINTS;?></b></td>
+ <td align="center" valign="middle"><b><?php echo _AM_CRICK_RUNS;?></b></td>
+ <td align="center" valign="middle"><b><?php echo _AM_CRICK_WICKETSHOME;?></b></td>
+ <td align="left" valign="middle"><b><?php echo _AM_CRICK_AWAYTEAM;?></b></td>
+ <td align="center" valign="middle"><b><?php echo _AM_CRICK_BONUSPOINTS;?></b></td>
+ <td align="center" valign="middle"><b><?php echo _AM_CRICK_RUNS;?></b></td>
+ <td align="center" valign="middle"><b><?php echo _AM_CRICK_WICKETS;?></b></td>
+ </tr>
+
+ <?php
+ //Lets get all the matches from selected date to the form
+ $i = 0;
+ while($matchdata = $xoopsDB->fetchArray($cricket_get_matches))
+ {
+ //Back to line 0 in the query if not the first loop
+ if($i>0)
+ mysql_data_seek($cricket_get_opponents, 0);
+
+ echo'
+ <tr>
+ <td align="left" valign="middle">
+ ';
+
+ echo"<select name=\"home[$i]\">";
+
+ while($cricket_data = $xoopsDB->fetchArray($cricket_get_opponents))
+ {
+ if($matchdata['homeid'] == $cricket_data['id'])
+ echo"<option value=\"$cricket_data[id]\" SELECTED>$cricket_data[name]</option>\n";
+ }
+
+ echo'
+ </select>
+ </td>
+ ';
+
+ echo'
+ <td align="center" valign="middle"><input type="text" name="home_bpoints[$i]" size="2" value="$matchdata[homebpoints]"></td>
+ <td align="center" valign="middle"><input type="text" name="home_runs[$i]" size="2" value="$matchdata[homeruns]"></td>
+ <td align="center" valign="middle"><input type="text" name="home_wickets[$i]" size="2" value="$matchdata[homewickets]"></td>
+ ';
+
+ echo'
+ <td align="left" valign="middle">
+ ';
+
+ //Back to line 0 in the query
+ mysql_data_seek($cricket_get_opponents, 0);
+
+ echo"<select name=\"away[$i]\">";
+
+ while($cricket_data = $xoopsDB->fetchArray($cricket_get_opponents))
+ {
+ if($matchdata['awayid'] == $cricket_data['id'])
+ echo"<option value=\"$cricket_data[id]\" SELECTED>$cricket_data[name]</option>\n";
+ }
+
+ echo"
+ </select>
+ </td>
+ ";
+
+ echo"
+ <td align=\"center\" valign=\"middle\"><input type=\"text\" name=\"away_bpoints[$i]\" size=\"2\" value=\"$matchdata[awaybpoints]\"></td>
+ <td align=\"center\" valign=\"middle\"><input type=\"text\" name=\"away_runs[$i]\" size=\"2\" value=\"$matchdata[awayruns]\"></td>
+ <td align=\"center\" valign=\"middle\"><input type=\"text\" name=\"away_wickets[$i]\" size=\"2\" value=\"$matchdata[awaywickets]\"></td>
+ </tr>
+ ";
+
+ $i++;
+ }
+ ?>
+ </table>
+
+ <font color="red"><?php echo _AM_CRICK_MODNOTICE1;?></font><br><br>
+ <input type="hidden" name="qty" value="<?= $i ?>">
+ <input type="hidden" name="seasonname" value="<?php echo $cricket_seasonname; ?>">
+ <input type="hidden" name="leaguename" value="<?php echo $cricket_leaguename; ?>">
+ <br><input type="submit" name="modifyall_submit" value="<?php echo _AM_CRICK_MODINPUT;?>">
+ </form>
+
+ <?php
+ }
+ elseif($cricket_action == 'modify')
+ {
+ $id = intval($_REQUEST['id']);
+
+ $cricket_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.LeagueMatchHomeBpoints AS homebpoints,
+ LM.LeagueMatchAwayBpoints AS awaybpoints,
+ LM.LeagueMatchHomeRuns AS homeruns,
+ LM.LeagueMatchHomeWickets AS homewickets,
+ LM.LeagueMatchAwayRuns AS awayruns,
+ LM.LeagueMatchAwayWickets AS awaywickets
+ FROM ".$xoopsDB->prefix("cricket_leaguematches")." LM
+ WHERE LM.LeaguematchID = '$id'
+ LIMIT 1
+ ");
+
+ $cricket_get_opponents = $xoopsDB->query("SELECT OpponentID AS id,
+ OpponentName AS name
+ FROM ".$xoopsDB->prefix("cricket_opponents")." WHERE OpponentLeagueID = $cricket_leagueid AND OpponentSeasonID = $cricket_seasonid
+ ORDER BY OpponentName
+ ");
+
+ $matchdata = $xoopsDB->fetchArray($cricket_get_match);
+ ?>
+ <form method="post" action="<?php echo "$PHP_SELF"?>">
+ <h3><?php echo _AM_CRICK_MODMATCH;?></h3>
+
+ <table width="100%" cellspacing="3" cellpadding="3" border="0">
+
+ <tr>
+ <td align="left" valign="top">
+ <?php echo _AM_CRICK_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 = $cricket_seasonname ; $i < $cricket_seasonname+1 ; $i++)
+ {
+ if($i<10)
+ {
+ $i = "0".$cricket_seasonname;
+ }
+ if($matchdata['year'] == $cricket_seasonname)
+ 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_CRICK_HOMETEAM;?></b></td>
+ <td align="center" valign="middle"><b><?php echo _AM_CRICK_BONUSPOINTS;?></b></td>
+ <td align="center" valign="middle"><b><?php echo _AM_CRICK_RUNS;?></b></td>
+ <td align="center" valign="middle"><b><?php echo _AM_CRICK_WICKETS;?></b></td>
+ <td align="left" valign="middle"><b><?php echo _AM_CRICK_AWAYTEAM;?></b></td>
+ <td align="center" valign="middle"><b><?php echo _AM_CRICK_BONUSPOINTS;?></b></td>
+ <td align="center" valign="middle"><b><?php echo _AM_CRICK_RUNS;?></b></td>
+ <td align="center" valign="middle"><b><?php echo _AM_CRICK_WICKETS;?></b></td>
+ </tr>
+
+ <tr>
+ <td align="left" valign="middle">
+
+ <select name="home">
+ <?php
+
+ while($cricket_data = $xoopsDB->fetchArray($cricket_get_opponents))
+ {
+ if($matchdata['homeid'] == $cricket_data['id'])
+ echo"<option value=\"$cricket_data[id]\" SELECTED>$cricket_data[name]</option>\n";
+ else
+ echo"<option value=\"$cricket_data[id]\">$cricket_data[name]</option>\n";
+ }
+
+ ?>
+ </select>
+ </td>
+ <td align="center" valign="middle"><input type="text" name="home_bpoints" size="2" value="<?= $matchdata['homebpoints'] ?>"></td>
+ <td align="center" valign="middle"><input type="text" name="home_runs" size="2" value="<?= $matchdata['homeruns'] ?>"></td>
+ <td align="center" valign="middle"><input type="text" name="home_wickets" size="2" value="<?= $matchdata['homewickets'] ?>"></td>
+
+ <td align="left" valign="middle">
+
+ <select name="away">
+ <?php
+
+ mysql_data_seek($cricket_get_opponents, 0);
+
+ while($cricket_data = $xoopsDB->fetchArray($cricket_get_opponents))
+ {
+ if($matchdata['awayid'] == $cricket_data['id'])
+ echo"<option value=\"$cricket_data[id]\" SELECTED>$cricket_data[name]</option>\n";
+ else
+ echo"<option value=\"$cricket_data[id]\">$cricket_data[name]</option>\n";
+ }
+
+ ?>
+ </select>
+ </td>
+ <td align="center" valign="middle"><input type="text" name="away_bpoints" size="2" value="<?= $matchdata['awaybpoints'] ?>"></td>
+ <td align="center" valign="middle"><input type="text" name="away_runs" size="2" value="<?= $matchdata['awayruns'] ?>"></td>
+ <td align="center" valign="middle"><input type="text" name="awa...
[truncated message content] |