private static function getPlayerColumns($matchId, SimulationPlayer $player, $fieldArea)
{
$columns['spiel_id'] = $matchId;
$columns['spieler_id'] = $player->id;
$columns['team_id'] = $player->team->id;
$columns['name'] = $player->name;
$columns['note'] = $player->getMark();
$columns['minuten_gespielt'] = $player->getMinutesPlayed();
$columns['karte_gelb'] = $player->yellowCards;
$columns['karte_rot'] = $player->redCard;
$columns['verletzt'] = $player->injured;
$columns['gesperrt'] = $player->blocked;
$columns['tore'] = $player->getGoals();
$columns['feld'] = $fieldArea;
$columns['position'] = $player->position;
$columns['position_main'] = $player->mainPosition;
$columns['age'] = $player->age;
$columns['w_staerke'] = $player->strength;
$columns['w_technik'] = $player->strengthTech;
$columns['w_kondition'] = $player->strengthStamina;
$columns['w_frische'] = $player->strengthFreshness;
$columns['w_zufriedenheit'] = $player->strengthSatisfaction;
$columns['ballcontacts'] = $player->getBallContacts();
$columns['wontackles'] = $player->getWonTackles();
$columns['losttackles'] = $player->getLostTackles();
$columns['shoots'] = $player->getShoots();
$columns['passes_successed'] = $player->getPassesSuccessed();
$columns['passes_failed'] = $player->getPassesFailed();
$columns['assists'] = $player->getAssists();
return $columns;
}
/**
* Update overall player statistics and match records of player.
*
* @param SimulationMatch $match
* @param SimulationPlayer $player
* @param $isOnPitch TRUE if player is on pitch in the end, FALSE if got removed (substitution or red card or injury).
*/
private function _updatePlayer(SimulationMatch $match, SimulationPlayer $player, $isOnPitch)
{
// update match statistics
$columns = array('name' => $player->name, 'position_main' => $player->mainPosition, 'grade' => $player->getMark(), 'minutes_played' => $player->getMinutesPlayed(), 'card_yellow' => $player->yellowCards, 'card_red' => $player->redCard, 'goals' => $player->getGoals(), 'strength' => $player->strength, 'ballcontacts' => $player->getBallContacts(), 'wontackles' => $player->getWonTackles(), 'shoots' => $player->getShoots(), 'passes_successed' => $player->getPassesSuccessed(), 'passes_failed' => $player->getPassesFailed(), 'assists' => $player->getAssists(), 'state' => $isOnPitch ? '1' : 'Ausgewechselt');
$this->_db->queryUpdate($columns, $this->_websoccer->getConfig('db_prefix') . '_youthmatch_player', 'match_id = %d AND player_id = %d', array($match->id, $player->id));
// update player record, if actually played
if ($this->_websoccer->getConfig('sim_played_min_minutes') <= $player->getMinutesPlayed()) {
// query existing statistics
$result = $this->_db->querySelect('*', $this->_websoccer->getConfig('db_prefix') . '_youthplayer', 'id = %d', $player->id);
$playerinfo = $result->fetch_array();
$result->free();
$strengthChange = $this->_computeStrengthChange($player);
// trigger plug-ins
$event = new YouthPlayerPlayedEvent($this->_websoccer, $this->_db, I18n::getInstance($this->_websoccer->getConfig('supported_languages')), $player, $strengthChange);
PluginMediator::dispatchEvent($event);
$yellowRedCards = 0;
if ($player->yellowCards == 2) {
$yellowCards = 1;
$yellowRedCards = 1;
} else {
$yellowCards = $player->yellowCards;
}
// ensure that new strength does not exceed boundaries (max/min strength)
$strength = $playerinfo['strength'] + $strengthChange;
$maxStrength = $this->_websoccer->getConfig('youth_scouting_max_strength');
$minStrength = $this->_websoccer->getConfig('youth_scouting_min_strength');
if ($strength > $maxStrength) {
$strengthChange = 0;
$strength = $maxStrength;
} else {
if ($strength < $minStrength) {
$strengthChange = 0;
$strength = $minStrength;
}
}
// save
$columns = array('strength' => $strength, 'strength_last_change' => $strengthChange, 'st_goals' => $playerinfo['st_goals'] + $player->getGoals(), 'st_matches' => $playerinfo['st_matches'] + 1, 'st_assists' => $playerinfo['st_assists'] + $player->getAssists(), 'st_cards_yellow' => $playerinfo['st_cards_yellow'] + $yellowCards, 'st_cards_yellow_red' => $playerinfo['st_cards_yellow_red'] + $yellowRedCards, 'st_cards_red' => $playerinfo['st_cards_red'] + $player->redCard);
$this->_db->queryUpdate($columns, $this->_websoccer->getConfig('db_prefix') . '_youthplayer', 'id = %d', $player->id);
}
}
/**
* @see ISimulationObserver::onBallPassFailure()
*/
public function onBallPassFailure(SimulationMatch $match, SimulationPlayer $player)
{
// show mercy when player already hit at least twice or assisted twice or both scored and assisted
if ($player->getGoals() < 2 && $player->getAssists() < 2 && ($player->getGoals() == 0 || $player->getAssists() == 0)) {
$player->downgradeMark(MARK_DOWNGRADE_BALLPASS_FAILURE);
}
$player->setPassesFailed($player->getPassesFailed() + 1);
}