PageRenderTime 51ms CodeModel.GetById 22ms RepoModel.GetById 0ms app.codeStats 0ms

/modules/tournament2/details.php

http://lansuite.googlecode.com/
PHP | 225 lines | 177 code | 37 blank | 11 comment | 70 complexity | 8d49b860088d0959c2466a90ea889f1a MD5 | raw file
Possible License(s): LGPL-3.0, AGPL-1.0, LGPL-2.1 
    

  1. <?php
    2. 

  2. 

  3. include_once("modules/tournament2/class_tournament.php");
    4. 

  4. $tfunc = new tfunc;
    5. 

  5. 

  6. $headermenuitem	= $_GET['headermenuitem'];
    7. 

  7. 

  8. if ($headermenuitem == "") $headermenuitem = 1;
    9. 

  9. 

  10. $tournament = $db->qry_first("SELECT *, UNIX_TIMESTAMP(starttime) AS starttime FROM %prefix%tournament_tournaments WHERE tournamentid = %int%", $_GET['tournamentid']);
    11. 

  11. 

  12. if (!$tournament["tournamentid"]) $func->error(t('Das ausgewählte Turnier existiert nicht'), "index.php?mod=tournament2");
    13. 

  13. else {
    14. 

  14. 

  15. 	switch ($_GET['step']){
    16. 

  16.     // Shuffle maps
    17. 

  17.     case 20:
    18. 

  18.       if ($auth['type'] <= 1) $func->information('ACCESS_DENIED');
    19. 

  19.       else {
    20. 

  20.         $maps = explode("\n", $tournament["mapcycle"]);
    21. 

  21.         shuffle($maps);
    22. 

  22.         $tournament["mapcycle"] = implode("\n", $maps);
    23. 

  23.         $db->qry("UPDATE %prefix%tournament_tournaments SET mapcycle = %string% WHERE tournamentid = %int%", $tournament['mapcycle'], $_GET['tournamentid']);
    24. 

  24.       }
    25. 

  25.     break;
    26. 

  26.   }
    27. 

  27.   
    28. 

  28. 	switch ($_GET['step']){
    29. 

  29. 		case 10:	// Activate Seeding
    30. 

  30. 			$seeded = $db->qry_first("SELECT COUNT(*) AS anz FROM %prefix%t2_teams WHERE (tournamentid = %int%) AND (seeding_mark = '1') GROUP BY tournamentid", $_GET['tournamentid']);
    31. 

  31. 			$team = $db->qry_first("SELECT COUNT(*) AS anz FROM %prefix%t2_teams WHERE (tournamentid = %int%) GROUP BY tournamentid", $_GET['tournamentid']);
    32. 

  32. 

  33. 			if (($seeded['anz']+1) > ($team['anz'] / 2)){
    34. 

  34. 				$func->information(t('Es wurde bereits die Hälfte der fest angemeldeten Teams markiert! Demarkiere zuerst ein Team, bevor du ein weiteres markierst'), "index.php?mod=tournament2&action=details&tournamentid={$_GET['tournamentid']}&headermenuitem=2");
    35. 

  35. 			} else {
    36. 

  36. 				$db->qry("UPDATE %prefix%t2_teams SET seeding_mark = '1' WHERE (teamid = %int%)", $_GET['teamid']);
    37. 

  37. 				$func->confirmation(t('Das Team wurde zum Setzen markiert.<br>Alle markierten Teams werden beim Generieren so gesetzt, dass sie möglichst spät im Turnierbaum aufeinander treffen werden.'), "index.php?mod=tournament2&action=details&tournamentid={$_GET['tournamentid']}&headermenuitem=2");
    38. 

  38. 			}
    39. 

  39. 		break;
    40. 

  40. 

  41. 		case 11:	// Deaktivate Seeding
    42. 

  42. 			$db->qry("UPDATE %prefix%t2_teams SET seeding_mark = '0' WHERE (teamid = %int%)", $_GET['teamid']);
    43. 

  43. 			$func->confirmation(t('Das Team wurde demarkiert.'), "index.php?mod=tournament2&action=details&tournamentid={$_GET['tournamentid']}&headermenuitem=2");
    44. 

  44. 		break;
    45. 

  45. 

  46. 		default:	// Show details
    47. 

  47. 			$dsp->NewContent(t('Turnier %1', $tournament['name']), t('Hier findest du Informationen zu diesem Turnier und kannst dich anmelden'));
    48. 

  48. 

  49. 			/*$menunames[1] = t('Turnierinfos');
    50. 

  50. 			$menunames[2] = t('Angemeldete Teams');
    51. 

  51. 			$dsp->AddHeaderMenu($menunames, "index.php?mod=tournament2&action=details&tournamentid={$_GET['tournamentid']}", $headermenuitem);
    52. 

  52. 			*/
    53. 

  53. 			$dsp->StartTabs();
    54. 

  54. 				
    55. 

  55. 				$dsp->StartTab(t('Turnierinfos'), 'details');
    56. 

  56. 				
    57. 

  57. 					$dsp->AddDoubleRow(t('Turniername'), $tournament['name']);
    58. 

  58. 

  59. 					if (($tournament['icon']) && ($tournament['icon'] != "none")) $icon = "<img src=\"ext_inc/tournament_icons/{$tournament['icon']}\" alt=\"Icon\"> ";
    60. 

  60. 					if ($tournament['version'] == "") $tournament['version'] = "<i>".t('unbekannt')."</i>";
    61. 

  61. 					$dsp->AddDoubleRow(t('Spiel'), $icon . $tournament['game'] ." (".t('Version').": ". $tournament['version'] .")");
    62. 

  62. 

  63. 					$league = "";
    64. 

  64. 					if ($tournament['wwcl_gameid'] != 0) $league .= ", <img src=\"ext_inc/tournament_icons/leagues/wwcl.png\" alt=\"WWCL\">";
    65. 

  65. 					if ($tournament['ngl_gamename']) $league .= ", <img src=\"ext_inc/tournament_icons/leagues/ngl.png\" alt=\"NGL\">";
    66. 

  66. 					if ($tournament['mode'] == "single") $modus = t('Single-Elimination');
    67. 

  67. 					if ($tournament['mode'] == "double") $modus = t('Double-Elimination');
    68. 

  68. 					if ($tournament['mode'] == "liga") $modus = t('Liga');
    69. 

  69. 					if ($tournament['mode'] == "groups") $modus = t('Gruppenspiele + KO');
    70. 

  70. 					if ($tournament['mode'] == "all") $modus = t('Alle in einem');
    71. 

  71. 					if ($tournament['blind_draw']) $blind_draw = " (Blind Draw)";
    72. 

  72. 					else $blind_draw = "";
    73. 

  73. 					$dsp->AddDoubleRow(t('Spiel-Modus'), $modus .", ". $tournament['teamplayer'] ." ".t('gegen')." ". $tournament['teamplayer'] . $blind_draw . $league);
    74. 

  74. 

  75.           $sponsor_banners = '';
    76. 

  76.           $sponsor = $db->qry("SELECT * FROM %prefix%sponsor WHERE tournamentid = %int%", $_GET['tournamentid']);
    77. 

  77.       		while($sponsor_row = $db->fetch_array($sponsor)) {
    78. 

  78.             $sponsor_banner = '<img src="'. $sponsor_row['pic_path'] .'" border="1" class="img_border" title="'. $sponsor_row['name'] .'" alt="Sponsor Banner"/>';
    79. 

  79.             if ($cfg['sys_internet']) $sponsor_banner = '<a href="index.php?mod=sponsor&action=bannerclick&design=base&type=banner&sponsorid='. $sponsor_row["sponsorid"] .'" target="_blank">'. $sponsor_banner .'</a><br>';
    80. 

  80.             $sponsor_banners .= $sponsor_banner;
    81. 

  81.           }
    82. 

  82.           $db->free_result($sponsor);
    83. 

  83. 					if ($sponsor_banners) $dsp->AddDoubleRow('Sponsored by', $sponsor_banners);
    84. 

  84. 

  85.           $dsp->AddFieldsetStart(t('Anmeldeeinschränkungen'));
    86. 

  86. 					if ($tournament['status'] == "invisible") $status = t('Unsichtbar');
    87. 

  87. 					if ($tournament['status'] == "open") $status = t('Anmeldung offen');
    88. 

  88. 					if ($tournament['status'] == "locked") $status = t('Anmeldung geschlossen');
    89. 

  89. 					if ($tournament['status'] == "closed") $status = "<div class=\"tbl_error\">".t('Turnier beendet')."</div>";
    90. 

  90. 					if ($tournament['status'] == "process") $status = "<div class=\"tbl_error\">".t('Partien werden gespielt')."</div>";
    91. 

  91. 					$dsp->AddDoubleRow(t('Status'), $status);
    92. 

  92. 

  93. 					($tournament['groupid'] == 0) ?
    94. 

  94. 						$dsp->AddDoubleRow(t('Turniergruppe'), t('Dieses Turnier wurde keiner Gruppe zugeordnet. Jeder darf teilnehmen.'))
    95. 

  95. 						: $dsp->AddDoubleRow(t('Turniergruppe'), t('Dieses Turnier wurde der Gruppe %1 zugeordnet. Es düfen sich nur Spieler anmelden, welche nicht bereits zu einem anderen Turnier der Gruppe %1 angemeldet sind.', $tournament['groupid']));
    96. 

  96. 

  97.           if ($auth['userid'] != '') {
    98. 

  98.   					if ($tournament['coins'] == 0) $dsp->AddDoubleRow(t('Coin-Kosten'), t('Für dieses Turnier werden keine Coins benötigt'));
    99. 

  99.   					else {
    100. 

  100.   						$team_coin = $db->qry_first("SELECT SUM(t.coins) AS t_coins
    101. 

  101.          FROM %prefix%tournament_tournaments AS t
    102. 

  102.          INNER JOIN %prefix%t2_teams AS teams ON t.tournamentid = teams.tournamentid
    103. 

  103.          WHERE (teams.leaderid = %int%)
    104. 

  104.          AND t.party_id=%int% 
    105. 

  105.          GROUP BY teams.leaderid
    106. 

  106.          ", $auth["userid"], $party->party_id);
    107. 

  107.   						$member_coin = $db->qry_first("SELECT SUM(t.coins) AS t_coins
    108. 

  108.          FROM %prefix%tournament_tournaments AS t
    109. 

  109.          INNER JOIN %prefix%t2_teammembers AS members ON t.tournamentid = members.tournamentid
    110. 

  110.          WHERE (members.userid = %int%)
    111. 

  111.          AND t.party_id=%int% 
    112. 

  112.          GROUP BY members.userid
    113. 

  113.          ", $auth["userid"], $party->party_id);
    114. 

  114.   						(($cfg['t_coins'] - $team_coin['t_coins'] - $member_coin['t_coins']) < $tournament['coins']) ?
    115. 

  115.   							$coin_out = t('Das Anmelden kostet %COST% Coins, du besitzt jedoch nur %IS% Coins!')
    116. 

  116.   							: $coin_out = t('Das Anmelden kostet %COST% Coins. Du besitzen noch: %IS% Coins');
    117. 

  117.   						
    118. 

  118.   						$dsp->AddDoubleRow(t('Coin-Kosten'), "<div class=\"tbl_error\">". str_replace("%IS%", ($cfg['t_coins'] - $team_coin['t_coins'] - $member_coin['t_coins']), str_replace("%COST%", $tournament['coins'], $coin_out)) ."</div>");
    119. 

  119.   					}
    120. 

  120.           }
    121. 

  121. 

  122. 					($tournament['over18']) ?
    123. 

  123. 						$dsp->AddDoubleRow(t('U18-Sperre'), t('Nur zugänglich für Spieler aus Über-18-Blöcken'))
    124. 

  124. 						: $dsp->AddDoubleRow(t('U18-Sperre'), t('Keine Sperre'));
    125. 

  125.           $dsp->AddFieldsetEnd();
    126. 

  126. 

  127. 

  128. 					($tournament["defwin_on_time_exceed"] == "1")? $defwin_warning = "<div class=\"tbl_error\">".t('ACHTUNG: Bei Zeitüberschreitung wird das Ergebnis automatisch gelost!')."</div> ".t('Wir bitten euch daher die Spiele direkt zu beginnen und das Ergebnis umgehend zu melden!')."" : $defwin_warning = "";
    129. 

  129.           $dsp->AddFieldsetStart(t('Zeiten') . $defwin_warning);
    130. 

  130. 					$dsp->AddDoubleRow(t('Turnier beginnt um'), $func->unixstamp2date($tournament["starttime"], "datetime"));
    131. 

  131. 

  132. 					$dsp->AddDoubleRow(t('Dauer einer Runde'), t('Maximal %1 Spiel(e) pro Runde (je %2) + %3 Pause -> %4', $tournament["max_games"], $tournament["game_duration"] ."min", $tournament["break_duration"] ."min", $tournament["max_games"] * $tournament["game_duration"] + $tournament["break_duration"] ."min"));
    133. 

  133. ;
    134. 

  134.           $dsp->AddFieldsetEnd();
    135. 

  135. 

  136. 

  137.           $dsp->AddFieldsetStart(t('Regeln und Sonstiges'));
    138. 

  138. 					if ($tournament['rules_ext']) $dsp->AddDoubleRow(t('Regelwerk'), "<a href=\"./ext_inc/tournament_rules/{$tournament['rules_ext']}\" target=\"_blank\">".t('Regelwerk öffnen')."({$tournament['rules_ext']})</a>");
    139. 

  139. 

  140. 					$dsp->AddDoubleRow(t('Bemerkung'), $func->text2html($tournament["comment"]));
    141. 

  141. 

  142.           $maps = explode("\n", $tournament["mapcycle"]);
    143. 

  143.           $map_str = '';
    144. 

  144.           foreach ($maps as $key => $val) $map_str .= t('Runde')." $key: $val \n";
    145. 

  145.           $mapcycle = t('Mapcycle'). HTML_NEWLINE . HTML_NEWLINE;
    146. 

  146.           if ($auth['type'] > 1) $mapcycle .= '<a href="index.php?mod=tournament2&action=details&tournamentid='. $_GET['tournamentid'] .'&step=20">'. t('Maps neu mischen') .'</a>';
    147. 

  147. 					$dsp->AddDoubleRow($mapcycle, $func->text2html($map_str));
    148. 

  148.           $dsp->AddFieldsetEnd();
    149. 

  149.           $dsp->EndTab();
    150. 

  150. 

  151. 

  152. 		  $dsp->StartTab(t('Angemeldete Teams'), 'assign');
    153. 

  153. 					$waiting_teams = "";
    154. 

  154. 					$completed_teams = "";
    155. 

  155. 					$teams = $db->qry("SELECT name, teamid, seeding_mark, disqualified FROM %prefix%t2_teams WHERE (tournamentid = %int%)", $_GET['tournamentid']);
    156. 

  156. 					while($team = $db->fetch_array($teams)) {
    157. 

  157. 						$members = $db->qry_first("SELECT COUNT(*) AS members
    158. 

  158.        FROM %prefix%t2_teammembers
    159. 

  159.        WHERE (teamid = %int%)
    160. 

  160.        GROUP BY teamid
    161. 

  161.        ", $team['teamid']);
    162. 

  162. 						$team_out = $team["name"] . $tfunc->button_team_details($team['teamid'], $_GET['tournamentid']);
    163. 

  163. 						if (($tournament['mode'] == "single") or ($tournament['mode'] == "double")){
    164. 

  164. 							if ($team["seeding_mark"]) $team_out .= " ". t('Dieses Team wird beim Generieren gesetzt');
    165. 

  165. 							if (($auth["type"] > 1) && ($tournament['status'] == "open")) {
    166. 

  166. 								if ($team["seeding_mark"]) $team_out .= " <a href=\"index.php?mod=tournament2&action=details&step=11&tournamentid={$_GET['tournamentid']}&teamid={$team['teamid']}\">".t('demarkieren')."</a>";
    167. 

  167. 								else $team_out .= " <a href=\"index.php?mod=tournament2&action=details&step=10&tournamentid={$_GET['tournamentid']}&teamid={$team['teamid']}\">".t('Team setzen')."</a>";
    168. 

  168. 							}
    169. 

  169. 						}
    170. 

  170. /*  // Disquallifiy droped, due to errors
    171. 

  171. 						if ($auth["type"] > 1 and $tournament['status'] == "process") {
    172. 

  172. 							if ($team['disqualified']) $team_out .= " <font color=\"#ff0000\">".t('Disqualifiziert')."</font> ". $dsp->FetchSpanButton(t('Disqualifizieren rückgängig'), "index.php?mod=tournament2&action=disqualify&teamid={$team['teamid']}&step=10");
    173. 

  173. 							else $team_out .= " ". $dsp->FetchSpanButton(t('Disqualifizieren'), "index.php?mod=tournament2&action=disqualify&teamid={$team['teamid']}");
    174. 

  174. 						}
    175. 

  175. */
    176. 

  176. 						$team_out .= HTML_NEWLINE;
    177. 

  177. 						if(($members["members"] + 1) < $tournament['teamplayer'])  {
    178. 

  178. 							$teamcount[0]++;
    179. 

  179. 							$waiting_teams .= $team_out;
    180. 

  180. 						} else {
    181. 

  181. 							$teamcount[1]++;
    182. 

  182. 							$completed_teams .= $team_out;
    183. 

  183. 						}
    184. 

  184. 					}
    185. 

  185. 					$db->free_result($teams);
    186. 

  186. 

  187. 					$dsp->AddSingleRow(t('Es sind %1 von maximal %2 Teams zu diesem Turnier angemeldet.',($teamcount[0] + $teamcount[1]), $tournament['maxteams']));
    188. 

  188. 

  189. 					if ($completed_teams == "") $completed_teams = "<i>".t('Keine')."</i>";
    190. 

  190. 					$dsp->AddDoubleRow(t('Teamnamen'), $completed_teams);
    191. 

  191. 

  192. 					if (($tournament['teamplayer'] > 1) && ($waiting_teams != "")){
    193. 

  193. 						$dsp->AddSingleRow(t('Folgende %1 Teams sind noch unvollständig', ($teamcount[0] + 0)));
    194. 

  194. 						$dsp->AddDoubleRow(t('Teamnamen'), $waiting_teams);
    195. 

  195. 					}
    196. 

  196. 				$dsp->EndTab();
    197. 

  197. 

  198. 		$dsp->EndTabs();
    199. 

  199. 

  200. 			$buttons="";
    201. 

  201. 			switch($tournament["status"]) {
    202. 

  202. 				case "open":
    203. 

  203. 					$buttons .= $dsp->FetchSpanButton(t('Teilnehmen'), "index.php?mod=tournament2&action=join&tournamentid={$_GET['tournamentid']}&step=2"). " ";
    204. 

  204. 					if ($auth["type"] > 1) $buttons .= $dsp->FetchSpanButton(t('Generieren'), "index.php?mod=tournament2&action=generate_pairs&step=2&tournamentid={$_GET['tournamentid']}"). " ";
    205. 

  205. 				break;
    206. 

  206. 				case "process":
    207. 

  207. 					$buttons .= $dsp->FetchSpanButton(t('Paarungen'), "index.php?mod=tournament2&action=games&step=2&tournamentid={$_GET['tournamentid']}"). " ";
    208. 

  208. 					$buttons .= $dsp->FetchSpanButton(t('Spielbaum'), "index.php?mod=tournament2&action=tree&step=2&tournamentid={$_GET['tournamentid']}"). " ";
    209. 

  209. 					if ($auth["type"] > 1) $buttons .= $dsp->FetchSpanButton(t('Generieren rückgängig'), "index.php?mod=tournament2&action=undo_generate&tournamentid={$_GET['tournamentid']}"). " ";
    210. 

  210. 				break;
    211. 

  211. 				case "closed":
    212. 

  212. 					$buttons .= $dsp->FetchSpanButton(t('Paarungen'), "index.php?mod=tournament2&action=games&step=2&tournamentid={$_GET['tournamentid']}"). " ";
    213. 

  213. 					$buttons .= $dsp->FetchSpanButton(t('Spielbaum'), "index.php?mod=tournament2&action=tree&step=2&tournamentid={$_GET['tournamentid']}"). " ";
    214. 

  214. 					if ($auth["type"] > 1) $buttons .= $dsp->FetchSpanButton(t('Schließen rückgängig'), "index.php?mod=tournament2&action=undo_close&tournamentid={$_GET['tournamentid']}"). " ";
    215. 

  215. 				break;
    216. 

  216. 			} // END: switch status
    217. 

  217. 			$dsp->AddDoubleRow("", $buttons);
    218. 

  218. 			$dsp->AddBackButton("index.php?mod=tournament2", "tournament2/details"); 
    219. 

  219. 

  220. 			$dsp->AddContent();
    221. 

  221. 		break;
    222. 

  222. 	} // END: Switch Step
    223. 

  223. 

  224. } // else
    225. 

  225. ?>
    226. 

  226.