/**
* Generates a new formation for the specified team, which will be directly stored both in the database and in the internal model.
*
* It is a 4-4-2 formation. It always selects the freshest players of the team.
*
* @param WebSoccer $websoccer request context.
* @param DbConnection $db database connection.
* @param SimulationTeam $team Team that needs a new formation.
* @param int $matchId match id.
*/
public static function generateNewFormationForTeam(WebSoccer $websoccer, DbConnection $db, SimulationTeam $team, $matchId)
{
// get all players (prefer the freshest players)
$columns['id'] = 'id';
$columns['position'] = 'position';
$columns['position_main'] = 'mainPosition';
$columns['vorname'] = 'firstName';
$columns['nachname'] = 'lastName';
$columns['kunstname'] = 'pseudonym';
$columns['w_staerke'] = 'strength';
$columns['w_technik'] = 'technique';
$columns['w_kondition'] = 'stamina';
$columns['w_frische'] = 'freshness';
$columns['w_zufriedenheit'] = 'satisfaction';
if ($websoccer->getConfig('players_aging') == 'birthday') {
$ageColumn = 'TIMESTAMPDIFF(YEAR,geburtstag,CURDATE())';
} else {
$ageColumn = 'age';
}
$columns[$ageColumn] = 'age';
// get players from usual team
if (!$team->isNationalTeam) {
$fromTable = $websoccer->getConfig('db_prefix') . '_spieler';
$whereCondition = 'verein_id = %d AND verletzt = 0 AND gesperrt = 0 AND status = 1 ORDER BY w_frische DESC';
$parameters = $team->id;
$result = $db->querySelect($columns, $fromTable, $whereCondition, $parameters);
} else {
// national team: take best players of nation
$columnsStr = '';
$firstColumn = TRUE;
foreach ($columns as $dbName => $aliasName) {
if (!$firstColumn) {
$columnsStr = $columnsStr . ', ';
} else {
$firstColumn = FALSE;
}
$columnsStr = $columnsStr . $dbName . ' AS ' . $aliasName;
}
$nation = $db->connection->escape_string($team->name);
$dbPrefix = $websoccer->getConfig('db_prefix');
$queryStr = '(SELECT ' . $columnsStr . ' FROM ' . $dbPrefix . '_spieler WHERE nation = \'' . $nation . '\' AND position = \'Torwart\' ORDER BY w_staerke DESC, w_frische DESC LIMIT 1)';
$queryStr .= ' UNION ALL (SELECT ' . $columnsStr . ' FROM ' . $dbPrefix . '_spieler WHERE nation = \'' . $nation . '\' AND position = \'Abwehr\' ORDER BY w_staerke DESC, w_frische DESC LIMIT 4)';
$queryStr .= ' UNION ALL (SELECT ' . $columnsStr . ' FROM ' . $dbPrefix . '_spieler WHERE nation = \'' . $nation . '\' AND position = \'Mittelfeld\' ORDER BY w_staerke DESC, w_frische DESC LIMIT 4)';
$queryStr .= ' UNION ALL (SELECT ' . $columnsStr . ' FROM ' . $dbPrefix . '_spieler WHERE nation = \'' . $nation . '\' AND position = \'Sturm\' ORDER BY w_staerke DESC, w_frische DESC LIMIT 2)';
$result = $db->executeQuery($queryStr);
}
$lvExists = FALSE;
$rvExists = FALSE;
$lmExists = FALSE;
$rmExists = FALSE;
$ivPlayers = 0;
$zmPlayers = 0;
while ($playerinfo = $result->fetch_array()) {
$position = $playerinfo['position'];
// generate a 4-4-2 formation
if ($position == PLAYER_POSITION_GOALY && isset($team->positionsAndPlayers[PLAYER_POSITION_GOALY]) && count($team->positionsAndPlayers[PLAYER_POSITION_GOALY]) == 1 || $position == PLAYER_POSITION_DEFENCE && isset($team->positionsAndPlayers[PLAYER_POSITION_DEFENCE]) && count($team->positionsAndPlayers[PLAYER_POSITION_DEFENCE]) >= 4 || $position == PLAYER_POSITION_MIDFIELD && isset($team->positionsAndPlayers[PLAYER_POSITION_MIDFIELD]) && count($team->positionsAndPlayers[PLAYER_POSITION_MIDFIELD]) >= 4 || $position == PLAYER_POSITION_STRIKER && isset($team->positionsAndPlayers[PLAYER_POSITION_STRIKER]) && count($team->positionsAndPlayers[PLAYER_POSITION_STRIKER]) >= 2) {
continue;
}
$mainPosition = $playerinfo['mainPosition'];
//prevent double LV/RV/LM/RM
if ($mainPosition == 'LV') {
if ($lvExists) {
$mainPosition = 'IV';
$ivPlayers++;
if ($ivPlayers == 3) {
$mainPosition = 'RV';
$rvExists = TRUE;
}
} else {
$lvExists = TRUE;
}
} elseif ($mainPosition == 'RV') {
if ($rvExists) {
$mainPosition = 'IV';
$ivPlayers++;
if ($ivPlayers == 3) {
$mainPosition = 'LV';
$lvExists = TRUE;
}
} else {
$rvExists = TRUE;
}
} elseif ($mainPosition == 'IV') {
$ivPlayers++;
if ($ivPlayers == 3) {
if (!$rvExists) {
$mainPosition = 'RV';
$rvExists = TRUE;
} else {
$mainPosition = 'LV';
$lvExists = TRUE;
}
}
} elseif ($mainPosition == 'LM') {
if ($lmExists) {
$mainPosition = 'ZM';
$zmPlayers++;
} else {
$lmExists = TRUE;
}
} elseif ($mainPosition == 'RM') {
if ($rmExists) {
$mainPosition = 'ZM';
$zmPlayers++;
} else {
$rmExists = TRUE;
}
} elseif ($mainPosition == 'LS' || $mainPosition == 'RS') {
$mainPosition = 'MS';
} elseif ($mainPosition == 'ZM') {
$zmPlayers++;
if ($zmPlayers > 2) {
$mainPosition = 'DM';
}
}
$player = new SimulationPlayer($playerinfo['id'], $team, $position, $mainPosition, 3.0, $playerinfo['age'], $playerinfo['strength'], $playerinfo['technique'], $playerinfo['stamina'], $playerinfo['freshness'], $playerinfo['satisfaction']);
if (strlen($playerinfo['pseudonym'])) {
$player->name = $playerinfo['pseudonym'];
} else {
$player->name = $playerinfo['firstName'] . ' ' . $playerinfo['lastName'];
}
$team->positionsAndPlayers[$player->position][] = $player;
SimulationStateHelper::createSimulationRecord($websoccer, $db, $matchId, $player);
}
$result->free();
}
public static function addPlayers(WebSoccer $websoccer, DbConnection $db, SimulationTeam $team, $matchinfo, $columnPrefix)
{
$fromTable = $websoccer->getConfig('db_prefix') . '_spieler';
$columns['verein_id'] = 'team_id';
$columns['nation'] = 'nation';
$columns['position'] = 'position';
$columns['position_main'] = 'mainPosition';
$columns['position_second'] = 'secondPosition';
$columns['vorname'] = 'firstName';
$columns['nachname'] = 'lastName';
$columns['kunstname'] = 'pseudonym';
$columns['w_staerke'] = 'strength';
$columns['w_technik'] = 'technique';
$columns['w_kondition'] = 'stamina';
$columns['w_frische'] = 'freshness';
$columns['w_zufriedenheit'] = 'satisfaction';
$columns['st_spiele'] = 'matches_played';
if ($websoccer->getConfig('players_aging') == 'birthday') {
$ageColumn = 'TIMESTAMPDIFF(YEAR,geburtstag,CURDATE())';
} else {
$ageColumn = 'age';
}
$columns[$ageColumn] = 'age';
$whereCondition = 'id = %d AND verletzt = 0';
// player must not be blocked
if ($team->isNationalTeam) {
$whereCondition .= ' AND gesperrt_nationalteam = 0';
} elseif ($matchinfo['type'] == 'Pokalspiel') {
$whereCondition .= ' AND gesperrt_cups = 0';
} elseif ($matchinfo['type'] != 'Freundschaft') {
$whereCondition .= ' AND gesperrt = 0';
}
$positionMapping = SimulationHelper::getPositionsMapping();
$addedPlayers = 0;
for ($playerNo = 1; $playerNo <= 11; $playerNo++) {
$playerId = $matchinfo[$columnPrefix . '_formation_player' . $playerNo];
$mainPosition = $matchinfo[$columnPrefix . '_formation_player_pos_' . $playerNo];
$result = $db->querySelect($columns, $fromTable, $whereCondition, $playerId);
$playerinfo = $result->fetch_array();
$result->free();
// is player still in team?
if (isset($playerinfo['team_id']) && $playerinfo['team_id'] == $team->id || $team->isNationalTeam && $playerinfo['nation'] == $team->name) {
$position = $positionMapping[$mainPosition];
$strength = $playerinfo['strength'];
// player becomes weaker: wrong position
if ($playerinfo['position'] != $position && $playerinfo['mainPosition'] != $mainPosition && $playerinfo['secondPosition'] != $mainPosition) {
$strength = round($strength * (1 - $websoccer->getConfig('sim_strength_reduction_wrongposition') / 100));
// player becomes weaker: secondary position
} elseif (strlen($playerinfo['mainPosition']) && $playerinfo['mainPosition'] != $mainPosition && ($playerinfo['position'] == $position || $playerinfo['secondPosition'] == $mainPosition)) {
$strength = round($strength * (1 - $websoccer->getConfig('sim_strength_reduction_secondary') / 100));
}
$player = new SimulationPlayer($playerId, $team, $position, $mainPosition, 3.0, $playerinfo['age'], $strength, $playerinfo['technique'], $playerinfo['stamina'], $playerinfo['freshness'], $playerinfo['satisfaction']);
if (strlen($playerinfo['pseudonym'])) {
$player->name = $playerinfo['pseudonym'];
} else {
$player->name = $playerinfo['firstName'] . ' ' . $playerinfo['lastName'];
}
$team->positionsAndPlayers[$player->position][] = $player;
SimulationStateHelper::createSimulationRecord($websoccer, $db, $matchinfo['match_id'], $player);
$addedPlayers++;
// is player the team captain?
if ($matchinfo[$columnPrefix . '_captain_id'] == $playerId) {
self::computeMorale($player, $playerinfo['matches_played']);
}
// is player free kick taker?
if ($matchinfo[$columnPrefix . '_formation_freekickplayer'] == $playerId) {
$team->freeKickPlayer = $player;
}
}
}
// generate new formation if formation is invalid
if ($addedPlayers < 11 && $websoccer->getConfig('sim_createformation_on_invalidsubmission')) {
// delete existing invalid formation
$db->queryDelete($websoccer->getConfig('db_prefix') . '_spiel_berechnung', 'spiel_id = %d AND team_id = %d', array($matchinfo['match_id'], $team->id));
$team->positionsAndPlayers = array();
// generate a new one
SimulationFormationHelper::generateNewFormationForTeam($websoccer, $db, $team, $matchinfo['match_id']);
$team->noFormationSet = TRUE;
return;
}
// bench
for ($playerNo = 1; $playerNo <= 5; $playerNo++) {
$playerId = $matchinfo[$columnPrefix . '_formation_bench' . $playerNo];
$result = $db->querySelect($columns, $fromTable, $whereCondition, $playerId);
$playerinfo = $result->fetch_array();
$result->free();
// is player still in team?
if (isset($playerinfo['team_id']) && $playerinfo['team_id'] == $team->id || $team->isNationalTeam && $playerinfo['nation'] == $team->name) {
$player = new SimulationPlayer($playerId, $team, $playerinfo['position'], $playerinfo['mainPosition'], 3.0, $playerinfo['age'], $playerinfo['strength'], $playerinfo['technique'], $playerinfo['stamina'], $playerinfo['freshness'], $playerinfo['satisfaction']);
if (strlen($playerinfo['pseudonym'])) {
$player->name = $playerinfo['pseudonym'];
} else {
$player->name = $playerinfo['firstName'] . ' ' . $playerinfo['lastName'];
}
$team->playersOnBench[$playerId] = $player;
SimulationStateHelper::createSimulationRecord($websoccer, $db, $matchinfo['match_id'], $player, TRUE);
}
}
}
