function displayEventSettingsForm($create = false) { global $sql; global $pref; if (e_WYSIWYG) { $insertjs = "rows='15'"; } else { require_once e_HANDLER . "ren_help.php"; $insertjs = "rows='5' onselect='storeCaret(this);' onclick='storeCaret(this);' onkeyup='storeCaret(this);'"; } if ($create == true) { $event_str = ''; $action_str = 'actionid=create'; } else { $event_str = 'eventid=' . $this->getField('EventID'); $action_str = '&actionid=edit'; } /* Nbr players */ $q = "SELECT COUNT(*) as NbrPlayers" . " FROM " . TBL_PLAYERS . " WHERE (" . TBL_PLAYERS . ".Event = '" . $this->fields['EventID'] . "')"; $result = $sql->db_Query($q); $row = mysql_fetch_array($result); $nbrplayers = $row['NbrPlayers']; /* Nbr Teams */ $q = "SELECT COUNT(*) as NbrTeams" . " FROM " . TBL_TEAMS . " WHERE (Event = '" . $this->fields['EventID'] . "')"; $result = $sql->db_Query($q); $row = mysql_fetch_array($result); $nbrteams = $row['NbrTeams']; $competition_type = $this->getCompetitionType(); $text .= "\r\n\t\t<script type='text/javascript'>\r\n\t\t<!--//\r\n\t\t// Forms\r\n\t\t\$(function() {\r\n\t\t\$( '#radio2' ).buttonset();\r\n\t\t\$('.timepicker').datetimepicker({\r\n\t\tampm: true,\r\n\t\ttimeFormat: 'hh:mm TT',\r\n\t\tstepHour: 1,\r\n\t\tstepMinute: 10,\r\n\t\tminDate: 0\r\n\t\t});\r\n\t\t});\r\n\t\t//-->\r\n\t\t</script>\r\n\t\t"; $text .= ' <script type="text/javascript"> <!--// function clearStartDate(frm) { frm.startdate.value = "" } function clearEndDate(frm) { frm.enddate.value = "" } //--> </script> '; $text .= "\r\n\t\t<script type='text/javascript'>\r\n\t\t<!--//\r\n\t\tfunction kick_player(v)\r\n\t\t{\r\n\t\tdocument.getElementById('kick_player').value=v;\r\n\t\tdocument.getElementById('playersform').submit();\r\n\t\t}\r\n\t\tfunction ban_player(v)\r\n\t\t{\r\n\t\tdocument.getElementById('ban_player').value=v;\r\n\t\tdocument.getElementById('playersform').submit();\r\n\t\t}\r\n\t\tfunction unban_player(v)\r\n\t\t{\r\n\t\tdocument.getElementById('unban_player').value=v;\r\n\t\tdocument.getElementById('playersform').submit();\r\n\t\t}\r\n\t\tfunction del_player_games(v)\r\n\t\t{\r\n\t\tdocument.getElementById('del_player_games').value=v;\r\n\t\tdocument.getElementById('playersform').submit();\r\n\t\t}\r\n\t\tfunction del_player_awards(v)\r\n\t\t{\r\n\t\tdocument.getElementById('del_player_awards').value=v;\r\n\t\tdocument.getElementById('playersform').submit();\r\n\t\t}\r\n\t\tfunction checkin_player(v)\r\n\t\t{\r\n\t\tdocument.getElementById('checkin_player').value=v;\r\n\t\tdocument.getElementById('playersform').submit();\r\n\t\t}\r\n\t\tfunction replace_player(v)\r\n\t\t{\r\n\t\tdocument.getElementById('replace_player').value=v;\r\n\t\tdocument.getElementById('playersform').submit();\r\n\t\t}\t\t\r\n\t\tfunction kick_team(v)\r\n\t\t{\r\n\t\tdocument.getElementById('kick_team').value=v;\r\n\t\tdocument.getElementById('teamsform').submit();\r\n\t\t}\r\n\t\tfunction ban_team(v)\r\n\t\t{\r\n\t\tdocument.getElementById('ban_team').value=v;\r\n\t\tdocument.getElementById('teamsform').submit();\r\n\t\t}\r\n\t\tfunction unban_team(v)\r\n\t\t{\r\n\t\tdocument.getElementById('unban_team').value=v;\r\n\t\tdocument.getElementById('teamsform').submit();\r\n\t\t}\r\n\t\tfunction del_team_games(v)\r\n\t\t{\r\n\t\tdocument.getElementById('del_team_games').value=v;\r\n\t\tdocument.getElementById('teamsform').submit();\r\n\t\t}\r\n\t\tfunction del_team_awards(v)\r\n\t\t{\r\n\t\tdocument.getElementById('del_team_awards').value=v;\r\n\t\tdocument.getElementById('teamsform').submit();\r\n\t\t}\r\n\t\tfunction checkin_team(v)\r\n\t\t{\r\n\t\tdocument.getElementById('checkin_team').value=v;\r\n\t\tdocument.getElementById('teamsform').submit();\r\n\t\t}\r\n\t\tfunction replace_team(v)\r\n\t\t{\r\n\t\tdocument.getElementById('replace_team').value=v;\r\n\t\tdocument.getElementById('teamsform').submit();\r\n\t\t}\t\t\r\n\t\t//-->\r\n\t\t</script>\r\n\t\t"; $text .= '<form id="form-event-settings" action="' . e_PLUGIN . 'ebattles/eventprocess.php?' . $event_str . $action_str . '" method="post">'; $text .= ' <table class="eb_table" style="width:95%"> <tbody> '; //<!-- Event Name --> $text .= ' <tr> <td class="eb_td eb_tdc1 eb_w40">' . EB_EVENTM_L15 . '<span class="required">*</span></td> <td class="eb_td"> <div><input class="tbox required" type="text" size="40" name="eventname" value="' . $this->getField('Name') . '"/></div> </td> </tr> '; //<!-- Event Password --> $text .= ' <tr> <td class="eb_td eb_tdc1 eb_w40">' . EB_EVENTM_L16 . '</td> <td class="eb_td"> <div><input class="tbox" type="text" size="40" name="eventpassword" value="' . $this->getField('password') . '"/></div> </td> </tr> '; //<!-- Event Game --> // Can change only if no players are signed up $disabled_str = $nbrplayers + $nbrteams == 0 ? '' : 'disabled="disabled"'; $q = "SELECT " . TBL_GAMES . ".*" . " FROM " . TBL_GAMES . " WHERE (GameID = '" . $this->getField('Game') . "')"; $result = $sql->db_Query($q); $gIcon = mysql_result($result, $i, TBL_GAMES . ".Icon"); $q = "SELECT " . TBL_GAMES . ".*" . " FROM " . TBL_GAMES . " ORDER BY Name"; $result = $sql->db_Query($q); /* Error occurred, return given name by default */ $numGames = mysql_numrows($result); $text .= '<tr>'; $text .= '<td class="eb_td eb_tdc1 eb_w40">' . EB_EVENTM_L17 . '</td>'; $text .= '<td class="eb_td">'; $text .= '<img ' . getGameIconResize($gIcon) . '/> '; $text .= '<select class="tbox" name="eventgame" ' . $disabled_str . '>'; for ($i = 0; $i < $numGames; $i++) { $gname = mysql_result($result, $i, TBL_GAMES . ".Name"); $gid = mysql_result($result, $i, TBL_GAMES . ".GameID"); if ($this->getField('Game') == $gid) { $text .= '<option value="' . $gid . '" selected="selected">' . htmlspecialchars($gname) . '</option>'; $ematchtypes = explode(",", preg_replace('/\\s+/', '', mysql_result($result, $i, TBL_GAMES . ".MatchTypes"))); } else { $text .= '<option value="' . $gid . '">' . htmlspecialchars($gname) . '</option>'; } } $text .= '</select>'; $text .= '</td></tr>'; //<!-- Type --> $disabled_str = $create == true ? '' : 'disabled="disabled"'; $text .= ' <tr> <td class="eb_td eb_tdc1 eb_w40">' . EB_EVENTM_L18 . '</td> <td class="eb_td"><select class="tbox" name="eventtype" ' . $disabled_str . '>'; $text .= '<option value="One Player Ladder" ' . ($this->getField('Type') == "One Player Ladder" ? 'selected="selected"' : '') . '>' . EB_EVENTS_L22 . '</option>'; $text .= '<option value="Team Ladder" ' . ($this->getField('Type') == "Team Ladder" ? 'selected="selected"' : '') . '>' . EB_EVENTS_L23 . '</option>'; $text .= '<option value="Clan Ladder" ' . ($this->getField('Type') == "Clan Ladder" ? 'selected="selected"' : '') . '>' . EB_EVENTS_L25 . '</option>'; $text .= '<option value="One Player Tournament" ' . ($this->getField('Type') == "One Player Tournament" ? 'selected="selected"' : '') . '>' . EB_EVENTS_L33 . '</option>'; $text .= '<option value="Clan Tournament" ' . ($this->getField('Type') == "Clan Tournament" ? 'selected="selected"' : '') . '>' . EB_EVENTS_L35 . '</option>'; $text .= '</select> </td> </tr> '; if ($create == false) { //<!-- Match Type --> // Can change only if no players are signed up $disabled_str = $nbrplayers + $nbrteams == 0 ? '' : 'disabled="disabled"'; $text .= ' <tr> <td class="eb_td eb_tdc1 eb_w40">' . EB_EVENTM_L132 . '</td> <td class="eb_td"> <div> '; $text .= '<select class="tbox" name="eventmatchtype" ' . $disabled_str . '>'; $text .= '<option value="" ' . ($this->getField('MatchType') == "" ? 'selected="selected"' : '') . '>-</option>'; foreach ($ematchtypes as $matchtype) { if ($matchtype != '') { $text .= '<option value="' . $matchtype . '" ' . ($this->getField('MatchType') == $matchtype ? 'selected="selected"' : '') . '>' . $matchtype . '</option>'; } } $text .= '</select> </div> </td> </tr>'; } if ($create == false) { //<!-- Rating Type --> switch ($competition_type) { case "Ladder": $text .= ' <tr> <td class="eb_td eb_tdc1 eb_w40" title="' . EB_EVENTM_L118 . '">' . EB_EVENTM_L117 . '</td> <td class="eb_td"> <div id="radio2"> '; $text .= '<input class="tbox" type="radio" id="radio21" size="40" name="eventrankingtype" ' . ($this->getField('RankingType') == "Classic" ? 'checked="checked"' : '') . ' value="Classic" /><label for="radio21">' . EB_EVENTM_L119 . '</label>'; $text .= '<input class="tbox" type="radio" id="radio22" size="40" name="eventrankingtype" ' . ($this->getField('RankingType') == "CombinedStats" ? 'checked="checked"' : '') . ' value="CombinedStats" /><label for="radio22">' . EB_EVENTM_L120 . '</label>'; $text .= ' </div> </td> </tr> '; break; } } //<!-- Match report userclass --> $text .= ' <tr> <td class="eb_td eb_tdc1 eb_w40">' . EB_EVENTM_L21 . '</td> <td class="eb_td"><select class="tbox" name="eventmatchreportuserclass">'; $text .= '<option value="' . eb_UC_MATCH_WINNER . '" ' . ($this->getField('match_report_userclass') == eb_UC_MATCH_WINNER ? 'selected="selected"' : '') . '>' . EB_EVENTM_L211 . '</option>'; $text .= '<option value="' . eb_UC_EVENT_PLAYER . '" ' . ($this->getField('match_report_userclass') == eb_UC_EVENT_PLAYER ? 'selected="selected"' : '') . '>' . EB_EVENTM_L22 . '</option>'; $text .= '<option value="' . eb_UC_EVENT_MODERATOR . '" ' . ($this->getField('match_report_userclass') == eb_UC_EVENT_MODERATOR ? 'selected="selected"' : '') . '>' . EB_EVENTM_L23 . '</option>'; $text .= '<option value="' . eb_UC_EVENT_OWNER . '" ' . ($this->getField('match_report_userclass') == eb_UC_EVENT_OWNER ? 'selected="selected"' : '') . '>' . EB_EVENTM_L24 . '</option>'; $text .= '</select> </td> </tr> '; //<!-- Match replay report userclass --> /* $text .= ' <tr> <td class="eb_td eb_tdc1 eb_w40">'.EB_EVENTM_L134.'</td> <td class="eb_td"><select class="tbox" name="eventmatchreplayreportuserclass">'; $text .= '<option value="'.eb_UC_EVENT_PLAYER.'" '.($this->getField('match_replay_report_userclass') == eb_UC_EVENT_PLAYER ? 'selected="selected"' : '') .'>'.EB_EVENTM_L22.'</option>'; $text .= '<option value="'.eb_UC_EVENT_MODERATOR.'" '.($this->getField('match_replay_report_userclass') == eb_UC_EVENT_MODERATOR ? 'selected="selected"' : '') .'>'.EB_EVENTM_L23.'</option>'; $text .= '<option value="'.eb_UC_EVENT_OWNER.'" '.($this->getField('match_replay_report_userclass') == eb_UC_EVENT_OWNER ? 'selected="selected"' : '') .'>'.EB_EVENTM_L24.'</option>'; $text .= '</select> </td> </tr> '; */ if ($create == false) { //<!-- Allow Quick Loss Report --> switch ($competition_type) { case "Ladder": $text .= ' <tr> <td class="eb_td eb_tdc1 eb_w40">' . EB_EVENTM_L25 . '</td> <td class="eb_td"> <div> '; $text .= '<input class="tbox" type="checkbox" name="eventallowquickloss"'; if ($this->getField('quick_loss_report') == true) { $text .= ' checked="checked"/>'; } else { $text .= '/>'; } $text .= ' </div> </td> </tr> '; break; } } //<!-- Allow Score --> $text .= ' <tr> <td class="eb_td eb_tdc1 eb_w40">' . EB_EVENTM_L26 . '</td> <td class="eb_td"> <div> '; $text .= '<input class="tbox" type="checkbox" name="eventallowscore"'; if ($this->getField('AllowScore') == true) { $text .= ' checked="checked"/>'; } else { $text .= '/>'; } $text .= ' </div> </td> </tr>'; //<!-- Match Approval --> $q = "SELECT COUNT(DISTINCT " . TBL_MATCHS . ".MatchID) as NbrMatches" . " FROM " . TBL_MATCHS . ", " . TBL_SCORES . " WHERE (" . TBL_MATCHS . ".Event = '" . $this->getField('EventID') . "')" . " AND (" . TBL_SCORES . ".MatchID = " . TBL_MATCHS . ".MatchID)" . " AND (" . TBL_MATCHS . ".Status = 'pending')"; $result = $sql->db_Query($q); $row = mysql_fetch_array($result); $nbrMatchesPending = $row['NbrMatches']; $text .= ' <tr> <td class="eb_td eb_tdc1 eb_w40" title="' . EB_EVENTM_L109 . '">' . EB_EVENTM_L108 . '</td> <td class="eb_td"> <div>'; $text .= '<select class="tbox" name="eventmatchapprovaluserclass">'; $text .= '<option value="' . eb_UC_NONE . '" ' . ($this->getField('MatchesApproval') == eb_UC_NONE ? 'selected="selected"' : '') . '>' . EB_EVENTM_L113 . '</option>'; $text .= '<option value="' . eb_UC_EVENT_PLAYER . '" ' . (($this->getField('MatchesApproval') & eb_UC_EVENT_PLAYER) != 0 ? 'selected="selected"' : '') . '>' . EB_EVENTM_L112 . '</option>'; $text .= '<option value="' . eb_UC_EVENT_MODERATOR . '" ' . (($this->getField('MatchesApproval') & eb_UC_EVENT_MODERATOR) != 0 ? 'selected="selected"' : '') . '>' . EB_EVENTM_L111 . '</option>'; $text .= '<option value="' . eb_UC_EVENT_OWNER . '" ' . (($this->getField('MatchesApproval') & eb_UC_EVENT_OWNER) != 0 ? 'selected="selected"' : '') . '>' . EB_EVENTM_L110 . '</option>'; $text .= '</select>'; $text .= $nbrMatchesPending > 0 ? '<div><img class="eb_image" src="' . e_PLUGIN . 'ebattles/images/exclamation.png" alt="' . EB_MATCH_L13 . '" title="' . EB_MATCH_L13 . '"/> ' . $nbrMatchesPending . ' ' . EB_EVENT_L64 . '</div>' : ''; $text .= ' </div> </td> </tr> '; if ($create == false) { //<!-- Allow Draws --> switch ($competition_type) { case "Ladder": $text .= ' <tr> <td class="eb_td eb_tdc1 eb_w40">' . EB_EVENTM_L27 . '</td> <td class="eb_td"> <div>'; $text .= '<input class="tbox" type="checkbox" name="eventallowdraw"'; if ($this->getField('AllowDraw') == true) { $text .= ' checked="checked"/>'; } else { $text .= '/>'; } $text .= ' </div> </td> </tr> '; //<!-- Points --> $text .= ' <tr> <td class="eb_td eb_tdc1 eb_w40">' . EB_EVENTM_L28 . '</td> <td class="eb_td"> <table class="table_left"> <tr> <td>' . EB_EVENTM_L29 . '</td> <td>' . EB_EVENTM_L30 . '</td> <td>' . EB_EVENTM_L31 . '</td> </tr> <tr> <td> <div><input class="tbox" type="text" name="eventpointsperwin" value="' . $this->getField('PointsPerWin') . '"/></div> </td> <td> <div><input class="tbox" type="text" name="eventpointsperdraw" value="' . $this->getField('PointsPerDraw') . '"/></div> </td> <td> <div><input class="tbox" type="text" name="eventpointsperloss" value="' . $this->getField('PointsPerLoss') . '"/></div> </td> </tr> </table> </td> </tr> '; break; } } if ($create == false) { //<!-- Allow Forfeits --> $text .= ' <tr> <td class="eb_td eb_tdc1 eb_w40">' . EB_EVENTM_L127 . '</td> <td class="eb_td"> <div>'; $text .= '<input class="tbox" type="checkbox" name="eventallowforfeit"'; if ($this->getField('AllowForfeit') == true) { $text .= ' checked="checked"/>'; } else { $text .= '/>'; } $text .= ' ' . EB_EVENTM_L128; $text .= '</div>'; switch ($competition_type) { case "Ladder": $text .= '<div>'; $text .= '<input class="tbox" type="checkbox" name="eventForfeitWinLossUpdate"'; if ($this->getField('ForfeitWinLossUpdate') == true) { $text .= ' checked="checked"/>'; } else { $text .= '/>'; } $text .= EB_EVENTM_L129; $text .= '</div>'; $text .= ' <div> <table class="table_left"> <tr> <td>' . EB_EVENTM_L130 . '</td> <td>' . EB_EVENTM_L131 . '</td> </tr> <tr> <td> <div><input class="tbox" type="text" name="eventforfeitwinpoints" value="' . $this->getField('ForfeitWinPoints') . '"/></div> </td> <td> <div><input class="tbox" type="text" name="eventforfeitlosspoints" value="' . $this->getField('ForfeitLossPoints') . '"/></div> </td> </tr> </table> </div> '; break; } $text .= ' </td> </tr> '; //<!-- Maps --> $text .= ' <tr> <td class="eb_td eb_tdc1 eb_w40">' . EB_EVENTM_L125 . '</td> <td class="eb_td"> <div> '; $text .= '<input class="tbox" type="text" name="eventmaxmapspermatch" size="2" value="' . $this->getField('MaxMapsPerMatch') . '"/>'; $text .= ' </div> </td> </tr> '; //<!-- Gold --> if (is_gold_system_active() && check_class($pref['eb_gold_userclass'])) { $text .= ' <tr> <td class="eb_td eb_tdc1 eb_w40">' . EB_EVENTM_L175 . '</td> <td class="eb_td"> <div> '; $text .= '<input class="tbox" type="text" name="event_gold_entry_fee" size="4" value="' . $this->getField('GoldEntryFee') . '"/>'; $text .= ' </div> </td> </tr> '; $text .= ' <tr> <td class="eb_td eb_tdc1 eb_w40">' . EB_EVENTM_L176 . '</td> <td class="eb_td"> <div> '; $text .= '<input class="tbox" type="text" name="event_gold_winning_event" size="4" value="' . $this->getField('GoldWinningEvent') . '"/>'; $text .= ' </div> </td> </tr> '; } } //<!-- Start Date --> if ($this->getField('StartDateTime') != 0) { $startdatetime_local = $this->getField('StartDateTime') + TIMEOFFSET; $date_start = date("m/d/Y h:i A", $startdatetime_local); } else { $date_start = ""; } $text .= ' <tr> <td class="eb_td eb_tdc1 eb_w40">' . EB_EVENTM_L32 . '<span class="required">*</span></td> <td class="eb_td"> <table class="table_left"> <tr> <td> <div><input class="eb_button" type="button" value="' . EB_EVENTM_L34 . '" onclick="clearStartDate(this.form);"/></div> </td> <td> <div><input class="tbox timepicker required" type="text" name="startdate" id="f_date_start" value="' . $date_start . '" readonly="readonly" /></div> </td> </tr> </table> </td> </tr> '; //<!-- End Date --> if ($this->getField('EndDateTime') != 0) { $enddatetime_local = $this->getField('EndDateTime') + TIMEOFFSET; $date_end = date("m/d/Y h:i A", $enddatetime_local); } else { $date_end = ""; } $text .= ' <tr> <td class="eb_td eb_tdc1 eb_w40">' . EB_EVENTM_L35 . '</td> <td class="eb_td"> <table class="table_left"> <tr> <td> <div><input class="eb_button" type="button" value="' . EB_EVENTM_L34 . '" onclick="clearEndDate(this.form);"/></div> </td> <td> <div><input class="tbox timepicker" type="text" name="enddate" id="f_date_end" value="' . $date_end . '" readonly="readonly" /></div> </td> </tr> </table> </td> </tr> '; //<!-- Checkin Duration --> $text .= ' <tr> <td class="eb_td eb_tdc1 eb_w40">' . EB_EVENTM_L169 . '</td> <td class="eb_td"> <div> '; $text .= '<input class="tbox" type="text" name="checkin_duration" size="5" value="' . $this->getField('CheckinDuration') . '"/>'; $text .= ' </div> </td> </tr> '; //<!-- Signups Enable --> $text .= ' <tr> <td class="eb_td eb_tdc1 eb_w40">' . EB_EVENTM_L177 . '</td> <td class="eb_td"> <div> '; $text .= '<input class="tbox" type="checkbox" name="eventsignupsenable"'; if ($this->getField('SignupsEnable') == true) { $text .= ' checked="checked"/>'; } else { $text .= '/>'; } $text .= ' </div> </td> </tr>'; //<!-- Allow Late Signups --> $text .= ' <tr> <td class="eb_td eb_tdc1 eb_w40">' . EB_EVENTM_L178 . '</td> <td class="eb_td"> <div> '; $text .= '<input class="tbox" type="checkbox" name="eventallowlatesignups"'; if ($this->getField('AllowLateSignups') == true) { $text .= ' checked="checked"/>'; } else { $text .= '/>'; } $text .= ' </div> </td> </tr>'; if ($create == false) { switch ($competition_type) { case "Tournament": //<!-- Map Pool --> if ($this->getID() != 0) { $mapPool = explode(",", $this->getField('MapPool')); $nbrMapsInPool = count($mapPool); $text .= ' <tr> <td class="eb_td eb_tdc1 eb_w40">' . EB_EVENTM_L147 . '</td> <td class="eb_td">'; $text .= '<table class="table_left">'; foreach ($mapPool as $key => $map) { if ($map != '') { $mapID = $map; $q_Maps = "SELECT " . TBL_MAPS . ".*" . " FROM " . TBL_MAPS . " WHERE (" . TBL_MAPS . ".MapID = '{$mapID}')"; $result_Maps = $sql->db_Query($q_Maps); $mapName = mysql_result($result_Maps, 0, TBL_MAPS . ".Name"); $text .= '<tr>'; $text .= '<td>' . $mapName . '</td>'; $text .= '<td>'; $text .= '<div>'; $text .= ebImageTextButton('eventdeletemap', 'delete.png', EB_EVENTM_L150, 'negative jq-button', '', '', 'value="' . $key . '"'); $text .= '</div>'; $text .= '</td>'; $text .= '</tr>'; } else { $text .= '<tr>'; $text .= '<td><div>'; $text .= EB_EVENTM_L148; $text .= '</div></td>'; $text .= '</tr>'; } } $text .= '</table>'; // List of all Maps $q_Maps = "SELECT " . TBL_MAPS . ".*" . " FROM " . TBL_MAPS . " WHERE (" . TBL_MAPS . ".Game = '" . $this->getField('Game') . "')"; $result_Maps = $sql->db_Query($q_Maps); $numMaps = mysql_numrows($result_Maps); if ($numMaps > $nbrMapsInPool) { $text .= ' <table class="table_left"> <tr>'; $text .= '<td><select class="tbox" name="map">'; for ($map = 0; $map < $numMaps; $map++) { $mID = mysql_result($result_Maps, $map, TBL_MAPS . ".MapID"); $mImage = mysql_result($result_Maps, $map, TBL_MAPS . ".Image"); $mName = mysql_result($result_Maps, $map, TBL_MAPS . ".Name"); $mDescrition = mysql_result($result_Maps, $map, TBL_MAPS . ".Description"); $isMapInMapPool = false; foreach ($mapPool as $poolmap) { if ($mID == $poolmap) { $isMapInMapPool = true; } } if ($isMapInMapPool == false) { $text .= '<option value="' . $mID . '"'; $text .= '>' . $mName . '</option>'; } } $text .= '</select></td>'; $text .= ' <td> <div> ' . ebImageTextButton('eventaddmap', 'add.png', EB_EVENTM_L149) . ' </div> </td> </tr> </table> '; } $text .= '</td></tr>'; } break; } } //<!-- Description --> $text .= ' <tr> <td class="eb_td eb_tdc1 eb_w40">' . EB_EVENTM_L36 . '</td> <td class="eb_td"> '; $text .= '<textarea class="tbox" id="eventdescription" name="eventdescription" cols="70" ' . $insertjs . '>' . $this->getField('Description') . '</textarea>'; if (!e_WYSIWYG) { $text .= '<br />' . display_help("helpb", 1); } $text .= ' </td> </tr>'; //<!-- Rules --> $text .= ' <tr> <td class="eb_td eb_tdc1 eb_w40">' . EB_EVENTM_L38 . '</td> <td class="eb_td"> '; $text .= '<textarea class="tbox" id="eventrules" name="eventrules" cols="70" ' . $insertjs . '>' . $this->getField('Rules') . '</textarea>'; if (!e_WYSIWYG) { $text .= '<br />' . display_help("helpb", 1); } $text .= ' </td> </tr> </tbody> </table> '; //<!-- Save Button --> $text .= ' <table><tbody><tr><td> <div> ' . ebImageTextButton('eventsettingssave', 'disk.png', EB_EVENTM_L37) . ' </div> </td></tr></tbody></table> </form>'; return $text; }
$num_divs = mysql_numrows($result); if ($num_divs > 0) { //$text .= '<div>'.$uname.' '.EB_USER_L35.'</div>'; // Display list of games icons $games_links_list = '<div class="spacer">'; for ($i = 0; $i < $num_divs; $i++) { $gname = mysql_result($result, $i, TBL_GAMES . ".Name"); $gicon = mysql_result($result, $i, TBL_GAMES . ".Icon"); $gid = mysql_result($result, $i, TBL_GAMES . ".GameID"); if ($game_id == "") { $game_id = $gid; } if ($gid == $game_id) { $gname_selected = $gname; } $games_links_list .= '<a href="' . e_PLUGIN . 'ebattles/clanmanage.php?clanid=' . $clan_id . '&gameid=' . $gid . '"><img ' . getGameIconResize($gicon) . ' title="' . $gname . '"/></a>'; $games_links_list .= ' '; } $games_links_list .= '<br /><b>' . $gname_selected . '</b></div><br />'; } $text .= '<div id="tabs">'; $text .= '<ul>'; $text .= '<li><a href="#tabs-1">' . EB_CLANM_L2 . '</a></li>'; $text .= '<li><a href="#tabs-2">' . EB_CLANM_L36 . '</a></li>'; $text .= '<li><a href="#tabs-3">' . EB_CLANM_L3 . '</a></li>'; $text .= '</ul>'; //*************************************************************************************** // tab-page "Team Summary" $text .= '<div id="tabs-1">'; $text .= '<table class="eb_table" style="width:95%">'; $text .= '<tbody>';
/** * displayEvents - Displays the events database table in * a nicely formatted html table. */ function displayPastEvents() { global $sql; global $text; global $time; $pages = new Paginator(); $array = array('latest' => array(EB_EVENTS_L4, 'EventID'), 'name' => array(EB_EVENTS_L5, TBL_EVENTS . '.Name'), 'game' => array(EB_EVENTS_L6, TBL_GAMES . '.Name'), 'type' => array(EB_EVENTS_L7, TBL_EVENTS . '.Type'), 'start' => array(EB_EVENTS_L8, TBL_EVENTS . '.StartDateTime')); if (!isset($_GET['gameid'])) { $_GET['gameid'] = "All"; } $gameid = eb_sanitize($_GET['gameid']); if (!isset($_GET['matchtype'])) { $_GET['matchtype'] = "All"; } $matchtype = eb_sanitize($_GET['matchtype']); if (!isset($_GET['orderby'])) { $_GET['orderby'] = 'game'; } $orderby = eb_sanitize($_GET['orderby']); $sort = "ASC"; if (isset($_GET["sort"]) && !empty($_GET["sort"])) { $sort = $_GET["sort"] == "ASC" ? "DESC" : "ASC"; } $game_string = $gameid == "All" ? "" : " AND (" . TBL_EVENTS . ".Game = '{$gameid}')"; $matchtype_string = $matchtype == "All" ? "" : " AND (" . TBL_GAMES . ".MatchTypes LIKE '%{$matchtype}%')"; // Drop down list to select Games to display $q_Games = "SELECT DISTINCT " . TBL_GAMES . ".*" . " FROM " . TBL_GAMES . ", " . TBL_EVENTS . " WHERE (" . TBL_EVENTS . ".Game = " . TBL_GAMES . ".GameID)" . $matchtype_string . " ORDER BY Name"; $result_Games = $sql->db_Query($q_Games); $numGames = mysql_numrows($result_Games); // Drop down list to select Match type to display $q_mt = "SELECT " . TBL_GAMES . ".*" . " FROM " . TBL_GAMES . ", " . TBL_EVENTS . " WHERE (" . TBL_EVENTS . ".Game = " . TBL_GAMES . ".GameID)" . $game_string; $result_mt = $sql->db_Query($q_mt); $num_mt = mysql_numrows($result_mt); $gmatchtypes = ''; for ($i = 0; $i < $num_mt; $i++) { $gmatchtypes .= ',' . mysql_result($result_mt, $i, TBL_GAMES . ".MatchTypes"); } $text .= '<form id="submitform" action="' . htmlspecialchars($_SERVER['PHP_SELF']) . '" method="get">'; $text .= '<div>'; $text .= '<table class="table_left">'; $text .= '<tr>'; // Games drop down $text .= '<td>' . EB_EVENTS_L9 . '<br />'; $text .= '<select class="tbox" name="gameid" onchange="this.form.submit()">'; $text .= '<option value="All" ' . ($gameid == "All" ? 'selected="selected"' : '') . '>' . EB_EVENTS_L10 . '</option>'; for ($i = 0; $i < $numGames; $i++) { $gName = mysql_result($result_Games, $i, TBL_GAMES . ".Name"); $gid = mysql_result($result_Games, $i, TBL_GAMES . ".GameID"); $text .= '<option value="' . $gid . '" ' . ($gameid == $gid ? 'selected="selected"' : '') . '>' . htmlspecialchars($gName) . '</option>'; } $text .= '</select>'; $text .= '</td>'; // Match Types drop down $text .= '<td>' . EB_EVENTS_L32 . '<br />'; $text .= '<select class="tbox" name="matchtype" onchange="this.form.submit()">'; $text .= '<option value="All" ' . ($matchtype == "All" ? 'selected="selected"' : '') . '>' . EB_EVENTS_L10 . '</option>'; $gmatchtypes = explode(",", $gmatchtypes); $gmatchtypes = array_unique($gmatchtypes); sort($gmatchtypes); foreach ($gmatchtypes as $gmatchtype) { if ($gmatchtype != '') { $text .= '<option value="' . $gmatchtype . '" ' . ($gmatchtype == $matchtype ? 'selected="selected"' : '') . '>' . htmlspecialchars($gmatchtype) . '</option>'; } } $text .= '</select>'; $text .= '</td>'; $text .= '</tr>'; $text .= '</table>'; $game_string = $gameid == "All" ? "" : " AND (" . TBL_EVENTS . ".Game = '{$gameid}')"; $matchtype_string = $matchtype == "All" ? "" : " AND (" . TBL_EVENTS . ".MatchType = '{$matchtype}')"; $q = "SELECT count(*) " . " FROM " . TBL_EVENTS . " WHERE (" . TBL_EVENTS . ".Status = 'finished')" . $game_string . $matchtype_string; $result = $sql->db_Query($q); $totalItems = mysql_result($result, 0); $pages->items_total = $totalItems; $pages->mid_range = eb_PAGINATION_MIDRANGE; $pages->paginate(); $orderby_array = $array["{$orderby}"]; $q = "SELECT " . TBL_EVENTS . ".*, " . TBL_GAMES . ".*" . " FROM " . TBL_EVENTS . ", " . TBL_GAMES . " WHERE (" . TBL_EVENTS . ".Status = 'finished')" . " AND (" . TBL_EVENTS . ".Game = " . TBL_GAMES . ".GameID)" . $game_string . $matchtype_string . " ORDER BY {$orderby_array['1']} {$sort}, EventID DESC" . " {$pages->limit}"; $result = $sql->db_Query($q); $numEvents = mysql_numrows($result); if (!$result || $numEvents < 0) { /* Error occurred, return given name by default */ $text .= EB_EVENTS_L11 . '</div>'; $text .= '</form><br/>'; } else { if ($numEvents == 0) { $text .= EB_EVENTS_L12 . '</div>'; $text .= '</form><br/>'; } else { // Paginate & Sorting $items = ''; foreach ($array as $opt => $opt_array) { $items .= $opt == $orderby ? '<option selected="selected" value="' . $opt . '">' . $opt_array[0] . '</option>' : '<option value="' . $opt . '">' . $opt_array[0] . '</option>'; } // Paginate $text .= '<span class="paginate" style="float:left;">' . $pages->display_pages() . '</span>'; $text .= '<span style="float:right">'; // Sort By $text .= EB_PGN_L6; $text .= '<select class="tbox" name="orderby" onchange="this.form.submit()">'; $text .= $items; $text .= '</select>'; // Up/Down arrow $text .= '<input type="hidden" id="sort" name="sort" value=""/>'; if ($sort == "ASC") { $text .= '<a href="javascript:buttonval(\'ASC\');" title="Ascending"><img src="' . e_PLUGIN . 'ebattles/images/sort_asc.gif" alt="Asc" style="vertical-align:middle; border:0"/></a>'; } else { $text .= '<a href="javascript:buttonval(\'DESC\');" title="Descending"><img src="' . e_PLUGIN . 'ebattles/images/sort_desc.gif" alt="Desc" style="vertical-align:middle; border:0"/></a>'; } $text .= ' '; // Go To Page $text .= $pages->display_jump_menu(); $text .= ' '; // Items per page $text .= $pages->display_items_per_page(); $text .= '</span>'; $text .= '</div>'; $text .= '</form><br/><br/>'; /* Display table contents */ $text .= '<table class="eb_table" style="width:95%"><tbody>'; $text .= '<tr> <th class="eb_th2">' . EB_EVENTS_L13 . '</th> <th colspan="2" class="eb_th2">' . EB_EVENTS_L14 . '</th> <th class="eb_th2">' . EB_EVENTS_L15 . '</th> <th class="eb_th2">' . EB_EVENTS_L16 . '</th> <th class="eb_th2">' . EB_EVENTS_L17 . '</th> <th class="eb_th2">' . EB_EVENTS_L18 . '</th> <th class="eb_th2">' . EB_EVENTS_L19 . '</th> <th class="eb_th2">' . EB_EVENTS_L34 . '</th> </tr>'; for ($i = 0; $i < $numEvents; $i++) { $gName = mysql_result($result, $i, TBL_GAMES . ".Name"); $gIcon = mysql_result($result, $i, TBL_GAMES . ".Icon"); $event_id = mysql_result($result, $i, TBL_EVENTS . ".EventID"); $event = new Event($event_id); if ($event->getField('StartDateTime') != 0) { $startdatetime_local = $event->getField('StartDateTime') + TIMEOFFSET; $date_start = date("d M Y", $startdatetime_local); } else { $date_start = "-"; } if ($event->getField('EndDateTime') != 0) { $enddatetime_local = $event->getField('EndDateTime') + TIMEOFFSET; $date_end = date("d M Y", $enddatetime_local); } else { $date_end = "-"; } /* Nbr players */ $q_2 = "SELECT COUNT(*) as NbrPlayers" . " FROM " . TBL_PLAYERS . " WHERE (Event = '{$event_id}')"; $result_2 = $sql->db_Query($q_2); $row = mysql_fetch_array($result_2); $nbrplayers = $row['NbrPlayers']; /* Nbr Teams */ $q_2 = "SELECT COUNT(*) as NbrTeams" . " FROM " . TBL_TEAMS . " WHERE (" . TBL_TEAMS . ".Event = '{$event_id}')"; $result_2 = $sql->db_Query($q_2); $row = mysql_fetch_array($result_2); $nbrTeams = $row['NbrTeams']; /* Nbr matches */ $q_2 = "SELECT COUNT(DISTINCT " . TBL_MATCHS . ".MatchID) as NbrMatches" . " FROM " . TBL_MATCHS . ", " . TBL_SCORES . " WHERE (Event = '{$event_id}')" . " AND (" . TBL_MATCHS . ".Status = 'active')" . " AND (" . TBL_SCORES . ".MatchID = " . TBL_MATCHS . ".MatchID)"; $result_2 = $sql->db_Query($q_2); $row = mysql_fetch_array($result_2); $nbrmatches = $row['NbrMatches']; switch ($event->getField('Type')) { case "One Player Ladder": case "One Player Tournament": $nbrTeamPlayers = $nbrplayers; break; case "Team Ladder": $nbrTeamPlayers = $nbrTeams . '/' . $nbrplayers; break; case "Clan Ladder": case "Clan Tournament": $nbrTeamPlayers = $nbrTeams; break; default: } $text .= '<tr> <td class="eb_td"><a href="' . e_PLUGIN . 'ebattles/eventinfo.php?eventid=' . $event_id . '">' . $event->getField('Name') . '</a></td> <td class="eb_td"><img ' . getGameIconResize($gIcon) . '/></td> <td class="eb_td">' . $gName . '</td> <td class="eb_td">' . ($event->getField('MatchType') != '' ? $event->getField('MatchType') . ' - ' : '') . $event->eventTypeToString() . '</td> <td class="eb_td">' . $date_start . '</td> <td class="eb_td">' . $date_end . '</td> <td class="eb_td">' . $nbrTeamPlayers . '</td> <td class="eb_td">' . $nbrmatches . '</td> <td class="eb_td">' . $event->eventStatusToString() . '</td> </tr>'; } $text .= '</tbody></table><br />'; $text .= '<div>'; $text .= ebImageLink('back_to_events', '', e_PLUGIN . 'ebattles/events.php', '', 'action_back.gif', EB_EVENTP_L3 . ' ' . EB_EVENTP_L4, 'jq-button'); $text .= '</div>'; } } }
function displayRecentEvents() { global $pref; global $sql; global $text; global $time; $pages = new Paginator(); // how many rows to show per page $rowsPerPage = $pref['eb_default_items_per_page']; if (!isset($_GET['gameid'])) { $_GET['gameid'] = "All"; } $gameid = eb_sanitize($_GET['gameid']); if (!isset($_GET['matchtype'])) { $_GET['matchtype'] = "All"; } $matchtype = eb_sanitize($_GET['matchtype']); $game_string = $gameid == "All" ? "" : " AND (" . TBL_EVENTS . ".Game = '{$gameid}')"; $matchtype_string = $matchtype == "All" ? "" : " AND (" . TBL_GAMES . ".MatchTypes LIKE '%{$matchtype}%')"; // Drop down list to select Games to display $q_Games = "SELECT DISTINCT " . TBL_GAMES . ".*" . " FROM " . TBL_GAMES . ", " . TBL_EVENTS . " WHERE (" . TBL_EVENTS . ".Game = " . TBL_GAMES . ".GameID)" . $matchtype_string . " ORDER BY Name"; $result_Games = $sql->db_Query($q_Games); $numGames = mysql_numrows($result_Games); if ($numGames > 0) { //$text .= '<div>'.$uname.' '.EB_USER_L35.'</div>'; // Display list of games icons $games_links_list = '<div class="spacer">'; for ($i = 0; $i < $numGames; $i++) { $gname = mysql_result($result_Games, $i, TBL_GAMES . ".Name"); $gicon = mysql_result($result_Games, $i, TBL_GAMES . ".Icon"); $gid = mysql_result($result_Games, $i, TBL_GAMES . ".GameID"); if ($gameid == "All") { $gname_selected = EB_EVENTS_L10; } if ($gid == $gameid) { $gname_selected = $gname; } $games_links_list .= '<a href="' . e_PLUGIN . 'ebattles/events.php?gameid=' . $gid . '"><img ' . getGameIconResize($gicon) . ' title="' . $gname . '"/></a>'; $games_links_list .= ' '; } $games_links_list .= '<br /><b>' . $gname_selected . '</b></div><br />'; } $text .= $games_links_list; // Drop down list to select Match type to display $q_mt = "SELECT " . TBL_GAMES . ".*" . " FROM " . TBL_GAMES . ", " . TBL_EVENTS . " WHERE (" . TBL_EVENTS . ".Game = " . TBL_GAMES . ".GameID)" . $game_string; $result_mt = $sql->db_Query($q_mt); $num_mt = mysql_numrows($result_mt); $gmatchtypes = ''; for ($i = 0; $i < $num_mt; $i++) { $gmatchtypes .= ',' . mysql_result($result_mt, $i, TBL_GAMES . ".MatchTypes"); } $text .= '<form id="submitformrecent" action="' . htmlspecialchars($_SERVER['PHP_SELF']) . '" method="get">'; $text .= '<div>'; $text .= '<table class="table_left">'; $text .= '<tr>'; // Match Types drop down $text .= '<td>' . EB_EVENTS_L32 . '<br />'; $text .= '<select class="tbox" name="matchtype" onchange="this.form.submit()">'; $text .= '<option value="All" ' . ($matchtype == "All" ? 'selected="selected"' : '') . '>' . EB_EVENTS_L10 . '</option>'; $gmatchtypes = explode(",", $gmatchtypes); $gmatchtypes = array_unique($gmatchtypes); sort($gmatchtypes); foreach ($gmatchtypes as $gmatchtype) { if ($gmatchtype != '') { $text .= '<option value="' . $gmatchtype . '" ' . ($gmatchtype == $matchtype ? 'selected="selected"' : '') . '>' . htmlspecialchars($gmatchtype) . '</option>'; } } $text .= '</select>'; $text .= '</td>'; $text .= '</tr>'; $text .= '</table>'; $game_string = $gameid == "All" ? "" : " AND (" . TBL_EVENTS . ".Game = '{$gameid}')"; $matchtype_string = $matchtype == "All" ? "" : " AND (" . TBL_EVENTS . ".MatchType = '{$matchtype}')"; $q = "SELECT " . TBL_EVENTS . ".*, " . TBL_GAMES . ".*" . " FROM " . TBL_EVENTS . ", " . TBL_GAMES . " WHERE (" . TBL_EVENTS . ".Status = 'finished')" . " AND (" . TBL_EVENTS . ".Game = " . TBL_GAMES . ".GameID)" . $game_string . $matchtype_string . " LIMIT 0, {$rowsPerPage}"; $result = $sql->db_Query($q); $numEvents = mysql_numrows($result); if (!$result || $numEvents < 0) { /* Error occurred, return given name by default */ $text .= EB_EVENTS_L11 . '</div>'; $text .= '</form><br/>'; } else { if ($numEvents == 0) { $text .= EB_EVENTS_L12 . '</div>'; $text .= '</form><br/>'; } else { $text .= '</div>'; $text .= '</form><br/><br/>'; /* Display table contents */ $text .= '<table class="eb_table" style="width:95%"><tbody>'; $text .= '<tr> <th class="eb_th2">' . EB_EVENTS_L13 . '</th>'; if ($gameid == "All") { $text .= '<th colspan="2" class="eb_th2">' . EB_EVENTS_L14 . '</th>'; } $text .= ' <th class="eb_th2">' . EB_EVENTS_L15 . '</th> <th class="eb_th2">' . EB_EVENTS_L16 . '</th> <th class="eb_th2">' . EB_EVENTS_L17 . '</th> <th class="eb_th2">' . EB_EVENTS_L18 . '</th> <th class="eb_th2">' . EB_EVENTS_L19 . '</th> <th class="eb_th2">' . EB_EVENTS_L34 . '</th> </tr>'; for ($i = 0; $i < $numEvents; $i++) { $gName = mysql_result($result, $i, TBL_GAMES . ".Name"); $gIcon = mysql_result($result, $i, TBL_GAMES . ".Icon"); $event_id = mysql_result($result, $i, TBL_EVENTS . ".EventID"); $event = new Event($event_id); if ($event->getField('StartDateTime') != 0) { $startdatetime_local = $event->getField('StartDateTime') + TIMEOFFSET; $date_start = date("d M Y", $startdatetime_local); } else { $date_start = "-"; } if ($event->getField('EndDateTime') != 0) { $enddatetime_local = $event->getField('EndDateTime') + TIMEOFFSET; $date_end = date("d M Y", $enddatetime_local); } else { $date_end = "-"; } /* Nbr players */ $q_2 = "SELECT COUNT(*) as NbrPlayers" . " FROM " . TBL_PLAYERS . " WHERE (Event = '{$event_id}')"; $result_2 = $sql->db_Query($q_2); $row = mysql_fetch_array($result_2); $nbrplayers = $row['NbrPlayers']; /* Nbr Teams */ $q_2 = "SELECT COUNT(*) as NbrTeams" . " FROM " . TBL_TEAMS . " WHERE (" . TBL_TEAMS . ".Event = '{$event_id}')"; $result_2 = $sql->db_Query($q_2); $row = mysql_fetch_array($result_2); $nbrTeams = $row['NbrTeams']; /* Nbr matches */ $q_2 = "SELECT COUNT(DISTINCT " . TBL_MATCHS . ".MatchID) as NbrMatches" . " FROM " . TBL_MATCHS . ", " . TBL_SCORES . " WHERE (Event = '{$event_id}')" . " AND (" . TBL_MATCHS . ".Status = 'active')" . " AND (" . TBL_SCORES . ".MatchID = " . TBL_MATCHS . ".MatchID)"; $result_2 = $sql->db_Query($q_2); $row = mysql_fetch_array($result_2); $nbrmatches = $row['NbrMatches']; switch ($event->getField('Type')) { case "One Player Ladder": case "One Player Tournament": $nbrTeamPlayers = $nbrplayers; break; case "Team Ladder": $nbrTeamPlayers = $nbrTeams . '/' . $nbrplayers; break; case "Clan Ladder": case "Clan Tournament": $nbrTeamPlayers = $nbrTeams; break; default: } $text .= '<tr> <td class="eb_td"><a href="' . e_PLUGIN . 'ebattles/eventinfo.php?eventid=' . $event_id . '">' . $event->getField('Name') . '</a></td>'; if ($gameid == "All") { $text .= '<td class="eb_td"><img ' . getGameIconResize($gIcon) . '/></td> <td class="eb_td">' . $gName . '</td>'; } $text .= ' <td class="eb_td">' . ($event->getField('MatchType') != '' ? $event->getField('MatchType') . ' - ' : '') . $event->eventTypeToString() . '</td> <td class="eb_td">' . $date_start . '</td> <td class="eb_td">' . $date_end . '</td> <td class="eb_td">' . $nbrTeamPlayers . '</td> <td class="eb_td">' . $nbrmatches . '</td> <td class="eb_td">' . $event->eventStatusToString() . '</td> </tr>'; } $text .= '</tbody></table><br />'; $text .= '<div>'; $text .= ebImageLink('link_to_eventspast', '', e_PLUGIN . 'ebattles/eventspast.php', '', 'action_back.gif', EB_EVENTS_L21, 'jq-button'); $text .= '</div>'; } } }
/** * displayGames - Displays the games database table */ function displayGames() { global $pref; global $sql; global $text; global $session; $pages = new Paginator(); $array = array('id' => array(EB_GAMES_L3, TBL_GAMES . '.GameID'), 'icon' => array(EB_GAMES_L4, TBL_GAMES . '.Icon'), 'game' => array(EB_GAMES_L5, TBL_GAMES . '.Name')); if (!isset($_GET['orderby'])) { $_GET['orderby'] = 'game'; } $orderby = eb_sanitize($_GET['orderby']); $sort = "ASC"; if (isset($_GET["sort"]) && !empty($_GET["sort"])) { $sort = $_GET["sort"] == "ASC" ? "DESC" : "ASC"; } $q = "SELECT count(*) " . " FROM " . TBL_GAMES; $result = $sql->db_Query($q); $numGames = mysql_result($result, 0); $totalItems = $numGames; $pages->items_total = $totalItems; $pages->mid_range = eb_PAGINATION_MIDRANGE; $pages->paginate(); $text .= '<div class="spacer">'; $text .= '<p>'; $text .= $numGames . ' ' . EB_GAMES_L6 . '<br />'; $text .= '</p>'; $text .= '</div>'; $orderby_array = $array["{$orderby}"]; $q = "SELECT " . TBL_GAMES . ".*" . " FROM " . TBL_GAMES . " ORDER BY {$orderby_array['1']} {$sort}" . " {$pages->limit}"; $result = $sql->db_Query($q); $num_rows = mysql_numrows($result); if (!$result || $num_rows < 0) { $text .= EB_GAMES_L7; return; } if ($num_rows == 0) { $text .= EB_GAMES_L8; } else { // Paginate $text .= '<br />'; $text .= '<span class="paginate" style="float:left;">' . $pages->display_pages() . '</span>'; $text .= '<span style="float:right">'; // Go To Page $text .= $pages->display_jump_menu(); $text .= ' '; // Items per page $text .= $pages->display_items_per_page(); $text .= '</span><br /><br />'; /* Display table contents */ $text .= '<form id="gamesform" action="' . e_PLUGIN . 'ebattles/gameprocess.php" method="post">'; $text .= '<table class="fborder" style="width:95%"><tbody>'; $text .= '<tr>'; $text .= '<td class="eb_td2"><input class="tbox" type="checkbox" name="sAll" onclick="selectAll(this)" /> (' . EB_GAMES_L9 . ')</td>'; foreach ($array as $opt => $opt_array) { $text .= '<td class="eb_td2"><a href="' . e_PLUGIN . 'ebattles/admin_config.php?eb_games&orderby=' . $opt . '&sort=' . $sort . '">' . $opt_array[0] . '</a></td>'; } $text .= '<td class="eb_td2">' . EB_GAMES_L10; $text .= '<input type="hidden" id="delete_game" name="delete_game" value=""/></td></tr>'; for ($i = 0; $i < $num_rows; $i++) { $gid = mysql_result($result, $i, TBL_GAMES . ".GameID"); $gname = mysql_result($result, $i, TBL_GAMES . ".Name"); $gicon = mysql_result($result, $i, TBL_GAMES . ".Icon"); $text .= '<tr>'; $text .= '<td class="forumheader3"><input class="tbox" type="checkbox" name="game_sel[]" value="' . $gid . '" /></td>'; $text .= '<td class="forumheader3">' . $gid . '</td>'; $text .= '<td class="forumheader3"><img ' . getGameIconResize($gicon) . ' title="' . $gicon . '"/></td>'; $text .= '<td class="forumheader3"><a href="' . e_PLUGIN . 'ebattles/admin_config.php?eb_games&gameid=' . $gid . '">' . $gname . '</a></td>'; $text .= '<td class="forumheader3"><a href="' . e_PLUGIN . 'ebattles/admin_config.php?eb_games&gameid=' . $gid . '"><img src="' . e_PLUGIN . 'ebattles/images/page_white_edit.png" alt="' . EB_GAMES_L11 . '" title="' . EB_GAMES_L11 . '"/></a>'; $text .= '<a href="javascript:buttonval(\'' . $gid . '\');" title="' . EB_GAMES_L12 . '" onclick="return confirm(\'' . EB_GAMES_L13 . '\')"><img src="' . e_PLUGIN . 'ebattles/images/cross.png" alt="' . EB_GAMES_L12 . '"/></a>'; $text .= '</td>'; $text .= '</tr>'; } $text .= '</tbody></table>'; $text .= '<table><tr> <td> <input class="eb_button" type="submit" name="delete_selected_games" value="' . EB_GAMES_L14 . '" onclick="return confirm(\'' . EB_GAMES_L15 . '\')"/> </td> <td> <input class="eb_button" type="submit" name="delete_all_games" value="' . EB_GAMES_L16 . '" onclick="return confirm(\'' . EB_GAMES_L17 . '\')"/> </td> <td> <input class="eb_button" type="submit" name="update_selected_games" value="' . EB_GAMES_L18 . '"/> </td> <td> <input class="eb_button" type="submit" name="update_all_games" value="' . EB_GAMES_L19 . '"/> </td> <td> <input class="eb_button" type="submit" name="add_games" value="' . EB_GAMES_L20 . '"/> </td> </tr> </table> '; $text .= '</form>'; } }
default: } $text .= '</tbody></table>'; /* Info */ $text .= '<table class="eb_table" style="width:95%"><tbody>'; $text .= '<tr>'; $text .= '<td class="eb_td eb_tdc1">' . EB_EVENT_L36 . '</td>'; $text .= '<td class="eb_td" style="font-variant:small-caps"><b>' . $event->getField('Name') . '</b></td>'; $text .= '</tr>'; $text .= '<tr>'; $text .= '<td class="eb_td eb_tdc1">' . EB_EVENT_L37 . '</td>'; $text .= '<td class="eb_td">' . ($event->getField('MatchType') != '' ? $event->getField('MatchType') . ' - ' : '') . $event->eventTypeToString() . '</td>'; $text .= '</tr>'; $text .= '<tr>'; $text .= '<td class="eb_td eb_tdc1">' . EB_EVENT_L38 . '</td>'; $text .= '<td class="eb_td"><img ' . getGameIconResize($egameicon) . '/> ' . $egame . '</td>'; $text .= '</tr>'; $text .= '<tr>'; $text .= '<td class="eb_td eb_tdc1">' . EB_EVENT_L39 . '</td>'; $text .= '<td class="eb_td"><a href="' . e_PLUGIN . 'ebattles/userinfo.php?user='******'">' . $eownername . '</a>'; $text .= '</td></tr>'; $text .= '<tr>'; $q = "SELECT " . TBL_EVENTMODS . ".*, " . TBL_USERS . ".*" . " FROM " . TBL_EVENTMODS . ", " . TBL_USERS . " WHERE (" . TBL_EVENTMODS . ".Event = '{$event_id}')" . " AND (" . TBL_USERS . ".user_id = " . TBL_EVENTMODS . ".User)"; $result = $sql->db_Query($q); $numMods = mysql_numrows($result); $text .= '<td class="eb_td eb_tdc1">' . EB_EVENT_L41 . '</td>'; $text .= '<td class="eb_td">'; if ($numMods > 0) { $text .= '<ul>'; for ($i = 0; $i < $numMods; $i++) { $modid = mysql_result($result, $i, TBL_USERS . ".user_id");
$num_gamers = mysql_numrows($result); if ($num_gamers > 0) { //$text .= '<div>'.$uname.' '.EB_USER_L35.'</div>'; // Display list of games icons $games_links_list = '<div class="spacer">'; for ($i = 0; $i < $num_gamers; $i++) { $gname = mysql_result($result, $i, TBL_GAMES . ".Name"); $gicon = mysql_result($result, $i, TBL_GAMES . ".Icon"); $gid = mysql_result($result, $i, TBL_GAMES . ".GameID"); if ($game_id == "") { $game_id = $gid; } if ($gid == $game_id) { $gname_selected = $gname; } $games_links_list .= '<a href="' . e_PLUGIN . 'ebattles/userinfo.php?user='******'&gameid=' . $gid . '"><img ' . getGameIconResize($gicon) . ' title="' . $gname . '"/></a>'; $games_links_list .= ' '; } $games_links_list .= '<br /><b>' . $gname_selected . '</b></div><br />'; } $text .= '<div id="tabs">'; $text .= '<ul>'; $text .= '<li><a href="#tabs-1">' . EB_USER_L2 . '</a></li>'; $text .= '<li><a href="#tabs-2">' . EB_USER_L3 . '</a></li>'; $text .= '<li><a href="#tabs-3">' . EB_USER_L4 . '</a></li>'; $text .= '<li><a href="#tabs-4">' . EB_USER_L5 . '</a></li>'; $text .= '<li><a href="#tabs-5">' . EB_USER_L6 . '</a></li>'; $text .= '</ul>'; /* --------------------- Player Profile