Пример #1
0
    function handleWarAttack($taskRow, $toVillageRow, $fromVillageRow, $procInfo)
    {
        global $GameMetadata, $SetupMetadata;
        if (!$toVillageRow['is_oasis'] && intval($toVillageRow['player_id']) == 0) {
            $paramsArray = explode('|', $taskRow['proc_params']);
            $paramsArray[sizeof($paramsArray) - 1] = 1;
            $newParams = implode('|', $paramsArray);
            $this->provider->executeQuery('UPDATE p_queue q 
				SET 
					q.player_id=%s,
					q.village_id=%s,
					q.to_player_id=%s,
					q.to_village_id=%s,
					q.proc_type=%s,
					q.proc_params=\'%s\',
					q.end_date=(q.end_date + INTERVAL q.execution_time SECOND)
				WHERE q.id=%s', array(intval($taskRow['to_player_id']), intval($taskRow['to_village_id']), intval($taskRow['player_id']), intval($taskRow['village_id']), QS_WAR_REINFORCE, $newParams, intval($taskRow['id'])));
            return TRUE;
        }
        $heroLevel = array('att' => 0, 'deff' => 0, 'heroTroopId' => -1);
        if ($procInfo['troopsArray']['hasHero']) {
            $_row = $this->provider->fetchRow('SELECT p.hero_att, p.hero_deff, p.hero_troop_id FROM p_players p WHERE p.id=%s', array(intval($fromVillageRow['player_id'])));
            if ($_row != NULL) {
                $heroLevel['att'] = intval($_row['hero_att']);
                $heroLevel['deff'] = intval($_row['hero_deff']);
                $heroLevel['heroTroopId'] = intval($_row['hero_troop_id']);
            }
        }
        $heroBuildingLevel = 0;
        $wringerLevel = 0;
        $buildings = array();
        $bStr = trim($fromVillageRow['buildings']);
        if ($bStr != '') {
            $bStrArr = explode(',', $bStr);
            foreach ($bStrArr as $b2Str) {
                list($item_id, $level, $update_state) = explode(' ', $b2Str);
                if ($item_id == 35) {
                    $wringerLevel = $level;
                } else {
                    if ($item_id == 37) {
                        $heroBuildingLevel = $level;
                    } else {
                        if ($item_id == 27) {
                            $TreasuryLevel = $level;
                        }
                    }
                }
            }
        }
        $attackTroops = $this->_getAttackTroopsForVillage($fromVillageRow['troops_training'], $procInfo['troopsArray']['troops'], $heroLevel, $wringerLevel, FALSE);
        $buildinStabilityFactor = 1;
        $crannyTotalSize = 0;
        $palLevel = 0;
        $wallPower = 0;
        $wallLevel = 0;
        $wallBid = 0;
        $wallItemId = 0;
        $buildings = array();
        $bStr = trim($toVillageRow['buildings']);
        if ($bStr != '') {
            $bStrArr = explode(',', $bStr);
            $fcc = 0;
            foreach ($bStrArr as $b2Str) {
                ++$fcc;
                list($item_id, $level, $update_state) = explode(' ', $b2Str);
                if ($item_id == 31 || $item_id == 32 || $item_id == 33) {
                    $wallBid = $fcc;
                    $wallItemId = $item_id;
                    $wallLevel = $level;
                    $wallPower = $level > 0 ? $GameMetadata['items'][$item_id]['levels'][$level - 1]['value'] : 0;
                } else {
                    if ($item_id == 23 && $level > 0) {
                        $crannyTotalSize += $GameMetadata['items'][$item_id]['levels'][$level - 1]['value'] * $GameMetadata['items'][$item_id]['for_tribe_id'][$toVillageRow['tribe_id']];
                    } else {
                        if ($item_id == 34 && $level > 0) {
                            $buildinStabilityFactor = $GameMetadata['items'][$item_id]['levels'][$level - 1]['value'] / 100;
                        } else {
                            if ($item_id == 26 && $level > 0) {
                                $palLevel = $level;
                            }
                        }
                    }
                }
            }
        }
        $crannyTotalSize = floor($crannyTotalSize * $GameMetadata['tribes'][$fromVillageRow['tribe_id']]['crannyFactor']);
        $buildinStability = 1;
        $crannySize = 0;
        $crannyTotalSize = floor($crannyTotalSize * $GameMetadata['tribes'][$fromVillageRow['tribe_id']]['crannyFactor']);
        $defenseTroops = array();
        $totalDefensePower['infantry_power'] = $totalDefensePower['cavalry_power'] = 0;
        $troops_num = trim($toVillageRow['troops_num']);
        if ($troops_num != '') {
            $vtroopsArr = explode('|', $troops_num);
            foreach ($vtroopsArr as $vtroopsStr) {
                list($tvid, $tvtroopsStr) = explode(':', $vtroopsStr);
                $incFactor = $toVillageRow['is_oasis'] && intval($toVillageRow['player_id']) == 0 && $tvid == -1 ? floor($toVillageRow['oasisElapsedTimeInSeconds'] / 86400) : 0;
                $_hasHero = FALSE;
                $vtroops = array();
                $_arr = explode(',', $tvtroopsStr);
                foreach ($_arr as $_arrStr) {
                    list($_tid, $_tnum) = explode(' ', $_arrStr);
                    if ($_tnum == -1) {
                        $_hasHero = TRUE;
                    } else {
                        $vtroops[$_tid] = $_tnum + $incFactor;
                    }
                }
                if ($tvid == -1) {
                    $hero_in_village_id = intval($this->provider->fetchScalar('SELECT p.hero_in_village_id FROM p_players p WHERE p.id=%s', array(intval($toVillageRow['player_id']))));
                    if ($hero_in_village_id > 0 && $hero_in_village_id == $toVillageRow['id']) {
                        $_hasHero = TRUE;
                    }
                }
                $defenseTroops[$tvid] = $this->_getDefenseTroopsForVillage($tvid == -1 ? $toVillageRow['id'] : $tvid, $vtroops, $_hasHero, $toVillageRow['people_count'], $wallPower, FALSE);
                $totalDefensePower['infantry_power'] += $defenseTroops[$tvid]['infantry_power'];
                $totalDefensePower['cavalry_power'] += $defenseTroops[$tvid]['cavalry_power'];
            }
        }
        $warResult = $this->getWarResult($attackTroops, $defenseTroops, $totalDefensePower, $wallLevel, $palLevel, $taskRow['proc_type'] == QS_WAR_ATTACK_PLUNDER, $procInfo['troopsArray']['onlyHero'] ? TRUE : FALSE);
        $harvestResources = '0 0 0 0';
        $harvestInfoStruct = array('string' => $harvestResources, 'sum' => 0);
        if (!$warResult['all_attack_killed']) {
            $harvestInfoStruct = $this->_harvestTroopsFrom($toVillageRow, $warResult['attackTroops']['total_carry_load'], $crannyTotalSize);
            $harvestResources = $harvestInfoStruct['string'];
        }
        $reduceConsumption = $warResult['attackTroops']['total_dead_consumption'];
        if ($warResult['all_attack_killed'] && $procInfo['troopsArray']['hasHero']) {
            $reduceConsumption += $GameMetadata['troops'][$procInfo['troopsArray']['heroTroopId']]['crop_consumption'];
        }
        if ($reduceConsumption > 0) {
            $this->_updateVillage($fromVillageRow, $reduceConsumption, $warResult['all_attack_killed'] && $procInfo['troopsArray']['hasHero']);
        }
        if ($procInfo['troopsArray']['hasHero'] && $warResult['defense_total_dead_number'] >= 1) {
            $heroStatisticPoint = ceil(5 * $warResult['defense_total_dead_number'] / 100);
            $this->provider->executeQuery('UPDATE p_players p SET p.hero_points=p.hero_points+%s WHERE p.id=%s', array($heroStatisticPoint, intval($fromVillageRow['player_id'])));
        }
        $defenseTroopsStr = '';
        $defenseReduceConsumption = 0;
        $reportTroopTable = array();
        $villages = array();
        $tribeId = 0;
        foreach ($warResult['defenseTroops'] as $vid => $troopsTable) {
            $defenseReduceConsumption += $troopsTable['total_dead_consumption'];
            $newTroops = '';
            $thisInforcementDied = TRUE;
            foreach ($troopsTable['troops'] as $tid => $tprop) {
                if ($newTroops != '') {
                    $newTroops .= ',';
                }
                $newTroops .= $tid . ' ' . $tprop['live_number'];
                if ($tprop['live_number'] > 0) {
                    $thisInforcementDied = FALSE;
                }
                if ($tid != 99) {
                    if ($vid != -1) {
                        if (!isset($villages[$vid])) {
                            $villages[$vid] = array('troops' => array(), 'hero' => array('number' => 0, 'dead_number' => 0));
                        }
                        if (!isset($villages[$vid]['troops'][$tid])) {
                            $villages[$vid]['troops'][$tid] = array('number' => $tprop['number'], 'dead_number' => $tprop['number'] - $tprop['live_number']);
                        } else {
                            $villages[$vid]['troops'][$tid]['number'] += $tprop['number'];
                            $villages[$vid]['troops'][$tid]['dead_number'] += $tprop['number'] - $tprop['live_number'];
                        }
                    }
                    $tribeId = $GameMetadata['troops'][$tid]['for_tribe_id'];
                    if (!isset($reportTroopTable[$tribeId])) {
                        $reportTroopTable[$tribeId] = array('troops' => array(), 'hero' => array('number' => 0, 'dead_number' => 0));
                    }
                    if (!isset($reportTroopTable[$tribeId]['troops'][$tid])) {
                        $reportTroopTable[$tribeId]['troops'][$tid] = array('number' => $tprop['number'], 'dead_number' => $tprop['number'] - $tprop['live_number']);
                    } else {
                        $reportTroopTable[$tribeId]['troops'][$tid]['number'] += $tprop['number'];
                        $reportTroopTable[$tribeId]['troops'][$tid]['dead_number'] += $tprop['number'] - $tprop['live_number'];
                    }
                }
            }
            if ($troopsTable['hasHero']) {
                $reportTroopTable[$tribeId]['hero']['number']++;
                if ($vid != -1) {
                    $villages[$vid]['hero']['number']++;
                }
            }
            if ($troopsTable['total_live_number'] > 0 && $troopsTable['hasHero']) {
                if ($vid != -1) {
                    if ($newTroops != '') {
                        $newTroops .= ',';
                    }
                    $newTroops .= $troopsTable['heroTroopId'] . ' -1';
                }
                if ($vid == -1 && !$toVillageRow['is_oasis'] && $warResult['attackTroops']['total_dead_number'] > 0) {
                    $heroStatisticPoint = ceil(5 * $warResult['attackTroops']['total_dead_number'] / 100);
                    $this->provider->executeQuery('UPDATE p_players p SET p.hero_points=p.hero_points+%s WHERE p.id=%s', array($heroStatisticPoint, intval($toVillageRow['player_id'])));
                }
                $thisInforcementDied = FALSE;
            }
            if ($troopsTable['hasHero'] && $troopsTable['total_live_number'] <= 0) {
                $reportTroopTable[$tribeId]['hero']['dead_number']++;
                if ($vid != -1) {
                    $villages[$vid]['hero']['dead_number']++;
                }
                $defenseReduceConsumption += $GameMetadata['troops'][$troopsTable['heroTroopId']]['crop_consumption'];
            }
            $this->_updateVillageOutTroops($vid, $toVillageRow['id'], $newTroops, $troopsTable['hasHero'] && $troopsTable['total_live_number'] <= 0, $thisInforcementDied, intval($toVillageRow['player_id']));
            if ($vid == -1 && $toVillageRow['is_oasis']) {
                $this->provider->executeQuery('UPDATE p_villages v SET v.creation_date=NOW() WHERE v.id=%s', array(intval($toVillageRow['id'])));
            }
            if (!$thisInforcementDied || $vid == -1) {
                if ($defenseTroopsStr != '') {
                    $defenseTroopsStr .= '|';
                }
                $defenseTroopsStr .= $vid . ':' . $newTroops;
            }
        }
        if ($toVillageRow['is_oasis'] && intval($toVillageRow['player_id']) > 0 && isset($reportTroopTable[4])) {
            unset($reportTroopTable[4]);
        }
        $this->provider->executeQuery('UPDATE p_villages v SET v.troops_num=\'%s\' WHERE v.id=%s', array($defenseTroopsStr, $toVillageRow['id']));
        if (!($toVillageRow['is_oasis'] && intval($toVillageRow['player_id']) == 0)) {
            $_tovid = $toVillageRow['is_oasis'] ? intval($toVillageRow['parent_id']) : $toVillageRow['id'];
            $this->provider->executeQuery('UPDATE p_villages v SET v.crop_consumption=v.crop_consumption-%s WHERE v.id=%s', array($defenseReduceConsumption, intval($_tovid)));
        }
        $villageTotallyDestructed = FALSE;
        $wallDestructionResult = '';
        $catapultResult = '';
        if (!$toVillageRow['is_oasis'] && !$warResult['all_attack_killed'] && $taskRow['proc_type'] != QS_WAR_ATTACK_PLUNDER) {
            $wallDestrTroopsCount = 0;
            $buildDestrTroopsCount = 0;
            foreach ($warResult['attackTroops']['troops'] as $tid => $tprop) {
                if ($tid == 7 || $tid == 17 || $tid == 27 || $tid == 57) {
                    $wallDestrTroopsCount = $tprop['number'];
                } else {
                    if ($tid == 8 || $tid == 18 || $tid == 28 || $tid == 58) {
                        $buildDestrTroopsCount = $tprop['number'];
                    }
                }
            }
            if ($procInfo['troopsArray']['hasWallDest']) {
                if ($wallLevel > 0) {
                    $dropLevels = 0;
                    if (2 * $wallPower < $wallDestrTroopsCount) {
                        $dropLevels = floor($wallDestrTroopsCount / (2 * $wallPower));
                        if ($wallLevel - $dropLevels < 0) {
                            $dropLevels = $wallLevel;
                        }
                    }
                    if ($dropLevels > 0) {
                        $wallDestructionResult = $wallLevel . '-' . ($wallLevel - $dropLevels);
                        $wallLevel -= $dropLevels;
                        $mq = new QueueJobModel();
                        while (0 < $dropLevels--) {
                            $mq->upgradeBuilding($toVillageRow['id'], $wallBid, $wallItemId, TRUE);
                        }
                    } else {
                        $wallDestructionResult = '-';
                    }
                } else {
                    $wallDestructionResult = '+';
                }
            }
            if (trim($procInfo['catapultTarget']) != '') {
                $catapultTargetArr = explode(':', $procInfo['catapultTarget']);
                $catapultTargetArr = explode(' ', $catapultTargetArr[1]);
                $buildingsInfo = array();
                $bStr = trim($toVillageRow['buildings']);
                if ($bStr != '') {
                    $bStrArr = explode(',', $bStr);
                    $_i = 0;
                    foreach ($bStrArr as $b2Str) {
                        ++$_i;
                        list($item_id, $level, $update_state) = explode(' ', $b2Str);
                        if ($item_id == 31 || $item_id == 32 || $item_id == 33) {
                            continue;
                        }
                        if ($level > 0) {
                            $buildingsInfo[] = array('id' => $_i, 'item_id' => $item_id, 'level' => $level);
                        }
                    }
                }
                $catapultTargetInfoArr = array();
                if (sizeof($buildingsInfo) > 0) {
                    foreach ($catapultTargetArr as $catapultTargetItemId) {
                        $targetExists = FALSE;
                        foreach ($buildingsInfo as $bInfo) {
                            if ($catapultTargetItemId == $bInfo['item_id']) {
                                $catapultTargetInfoArr[] = $bInfo;
                                $targetExists = TRUE;
                                break;
                                break;
                            }
                        }
                        if (!$targetExists) {
                            $_randIndex = mt_rand(0, sizeof($buildingsInfo) - 1);
                            $catapultTargetInfoArr[] = $buildingsInfo[$_randIndex];
                        }
                    }
                }
                if (sizeof($catapultTargetInfoArr) > 0) {
                    if (sizeof($catapultTargetInfoArr) > 1 && $catapultTargetInfoArr[0]['id'] == $catapultTargetInfoArr[1]['id']) {
                        $tmp = $catapultTargetInfoArr[0];
                        $catapultTargetInfoArr = array();
                        $catapultTargetInfoArr[] = $tmp;
                    }
                    $buildDestrTroopsCount = floor($buildDestrTroopsCount / sizeof($catapultTargetInfoArr));
                    foreach ($catapultTargetInfoArr as $catapultTargetInfoItem) {
                        if ($catapultResult != '') {
                            $catapultResult .= '#';
                        }
                        $canDestructBuilding = $catapultTargetInfoItem['level'] * $buildinStabilityFactor * 4 <= $buildDestrTroopsCount;
                        if ($canDestructBuilding) {
                            $dropBuildingLevels = floor($buildDestrTroopsCount / ($catapultTargetInfoItem['level'] * $buildinStabilityFactor * 4));
                            if ($catapultTargetInfoItem['level'] - $dropBuildingLevels < 0) {
                                $dropBuildingLevels = $catapultTargetInfoItem['level'];
                            }
                            $catapultResult .= $catapultTargetInfoItem['item_id'] . ' ' . $catapultTargetInfoItem['level'] . ' ' . ($catapultTargetInfoItem['level'] - $dropBuildingLevels);
                            $mq = new QueueJobModel();
                            while (0 < $dropBuildingLevels--) {
                                $mq->upgradeBuilding($toVillageRow['id'], $catapultTargetInfoItem['id'], $catapultTargetInfoItem['item_id'], TRUE);
                            }
                        } else {
                            $catapultResult .= $catapultTargetInfoItem['item_id'] . ' ' . $catapultTargetInfoItem['level'] . ' -1';
                        }
                    }
                }
                if (!$toVillageRow['is_capital'] && !$toVillageRow['is_special_village']) {
                    $checkToVillageRow = $this->_getVillageInfo($taskRow['to_village_id']);
                    $villageTotallyDestructed = TRUE;
                    $bStr = trim($checkToVillageRow['buildings']);
                    if ($bStr != '') {
                        $bStrArr = explode(',', $bStr);
                        $_i = 0;
                        foreach ($bStrArr as $b2Str) {
                            ++$_i;
                            list($item_id, $level, $update_state) = explode(' ', $b2Str);
                            if ($level > 0) {
                                $villageTotallyDestructed = FALSE;
                                break;
                            }
                        }
                    }
                    if ($villageTotallyDestructed) {
                        $catapultResult = '+';
                        $this->leaveVillage($toVillageRow['id'], $toVillageRow['player_id'], 0, $toVillageRow['parent_id']);
                    }
                }
            }
        }
        $doTroopsBack = TRUE;
        $villageCaptured = FALSE;
        $captureResult = '';
        if ($procInfo['troopsArray']['hasKing'] && !$toVillageRow['is_oasis'] && !$warResult['all_attack_killed'] && $taskRow['proc_type'] != QS_WAR_ATTACK_PLUNDER && !$toVillageRow['is_capital'] && !$villageTotallyDestructed && $warResult['all_defense_killed'] && $toVillageRow['player_id'] != $fromVillageRow['player_id'] && !$toVillageRow['is_artefacts']) {
            $checkToVillageRow = $this->_getVillageInfo($taskRow['to_village_id']);
            $b25_26_exists = FALSE;
            $bStr = trim($checkToVillageRow['buildings']);
            if ($bStr != '') {
                $bStrArr = explode(',', $bStr);
                foreach ($bStrArr as $b2Str) {
                    list($item_id, $level, $update_state) = explode(' ', $b2Str);
                    if ($level > 0 && ($item_id == 25 || $item_id == 26)) {
                        $b25_26_exists = TRUE;
                        break;
                    }
                }
            }
            $kingIsLive = FALSE;
            foreach ($warResult['attackTroops']['troops'] as $tid => $tprop) {
                if ($tid == 9 || $tid == 19 || $tid == 29) {
                    $kingIsLive = $tprop['live_number'] > 0;
                    break;
                }
            }
            if ($kingIsLive && $b25_26_exists) {
                $captureResult = '#';
            }
            if ($kingIsLive && !$b25_26_exists) {
                $elapsedTimeInSeconds = $toVillageRow['elapsedTimeInSeconds'];
                $addValue = $elapsedTimeInSeconds * 10 / 3600;
                $total = round($toVillageRow['allegiance_percent'] + $addValue);
                $allegiancepercent = $total < 100 ? $total : 100;
                $minusAllgeriance = $fromVillageRow['tribe_id'] == 1 ? mt_rand(25, 30) : mt_rand(20, 25);
                $allegiance_percent = $allegiancepercent - round($minusAllgeriance * (1 - $wringerLevel / 100));
                if ($allegiance_percent > 0) {
                    $this->provider->executeQuery('UPDATE p_villages v SET v.allegiance_percent=%s, v.last_update_date=NOW() WHERE v.id=%s', array($allegiance_percent, intval($toVillageRow['id'])));
                    $captureResult = $allegiancepercent . '-' . $allegiance_percent;
                } else {
                    $allegiance_percent = 0;
                    $captureResult = '+';
                }
                if ($allegiance_percent == 0) {
                    $villageCaptured = TRUE;
                    $kingCropConumption = 0;
                    $doTroopsBack = FALSE;
                    foreach ($warResult['attackTroops']['troops'] as $tid => $tprop) {
                        if ($tid == 9 || $tid == 19 || $tid == 29) {
                            $kingCropConumption = $GameMetadata['troops'][$tid]['crop_consumption'];
                            break;
                        }
                        if ($tprop['live_number'] > 0) {
                            $doTroopsBack = TRUE;
                        }
                    }
                    $toCheckPeople = $this->provider->fetchScalar('SELECT v.people_count FROM p_villages v WHERE v.id=%s', array($toVillageRow['id']));
                    $this->leaveVillage($toVillageRow['id'], $toVillageRow['player_id'], $toCheckPeople, $toVillageRow['parent_id'], FALSE);
                    $this->captureVillage($toVillageRow, $fromVillageRow, $kingCropConumption);
                }
            }
        }
        $oasisResult = '';
        if ($procInfo['troopsArray']['hasHero'] && $toVillageRow['is_oasis'] && !$warResult['all_attack_killed'] && $warResult['all_defense_killed'] && $toVillageRow['player_id'] != $fromVillageRow['player_id'] && 10 <= $heroBuildingLevel) {
            $canCaptureOasis = FALSE;
            $numberOfOwnedOases = trim($fromVillageRow['village_oases_id']) == '' ? 0 : sizeof(explode(',', $fromVillageRow['village_oases_id']));
            if ($heroBuildingLevel == 20) {
                $canCaptureOasis = $numberOfOwnedOases < 3;
            } else {
                if (15 <= $heroBuildingLevel) {
                    $canCaptureOasis = $numberOfOwnedOases < 2;
                } else {
                    if (10 <= $heroBuildingLevel) {
                        $canCaptureOasis = $numberOfOwnedOases < 1;
                    }
                }
            }
            $oasisInRang = FALSE;
            $rang = 3;
            $map_size = $SetupMetadata['map_size'];
            $x = $fromVillageRow['rel_x'];
            $y = $fromVillageRow['rel_y'];
            $mi = -$rang;
            while ($mi <= $rang) {
                if ($oasisInRang) {
                    break;
                }
                $mj = -$rang;
                while ($mj <= $rang) {
                    if ($toVillageRow['id'] == $this->__getVillageId($map_size, $this->__getCoordInRange($map_size, $x + $mi), $this->__getCoordInRange($map_size, $y + $mj))) {
                        $oasisInRang = TRUE;
                        break;
                    }
                    ++$mj;
                }
                ++$mi;
            }
            if ($canCaptureOasis && $oasisInRang) {
                $qm = new QueueJobModel();
                if (intval($toVillageRow['player_id']) == 0) {
                    $oasisResult = '+';
                    $qm->captureOasis($toVillageRow['id'], $fromVillageRow['player_id'], $fromVillageRow['id'], TRUE);
                } else {
                    $allegiance_percent = $toVillageRow['allegiance_percent'];
                    $allegiance_percent -= 25;
                    if ($allegiance_percent > 0) {
                        $oasisResult = $toVillageRow['allegiance_percent'] . '-' . $allegiance_percent;
                        $this->provider->executeQuery('UPDATE p_villages v SET v.allegiance_percent=%s WHERE v.id=%s', array($allegiance_percent, intval($toVillageRow['id'])));
                    } else {
                        $allegiance_percent = 0;
                        $oasisResult = '+';
                    }
                    if ($allegiance_percent == 0) {
                        $qm->captureOasis($toVillageRow['id'], $toVillageRow['player_id'], $toVillageRow['parent_id'], FALSE);
                        $qm->captureOasis($toVillageRow['id'], $fromVillageRow['player_id'], $fromVillageRow['id'], TRUE);
                    }
                }
            }
        }
        $artefactResult = '';
        if ($procInfo['troopsArray']['hasHero'] && $toVillageRow['artefacts'] != '' && !$warResult['all_attack_killed'] && $warResult['all_defense_killed'] && $toVillageRow['player_id'] != $fromVillageRow['player_id'] && 10 <= $TreasuryLevel) {
            $checkToVillageRow = $this->_getVillageInfo($taskRow['to_village_id']);
            $b27_exists = FALSE;
            $bStr = trim($checkToVillageRow['buildings']);
            if ($bStr != '') {
                $bStrArr = explode(',', $bStr);
                foreach ($bStrArr as $b2Str) {
                    list($item_id, $level, $update_state) = explode(' ', $b2Str);
                    if ($level > 0 && $item_id == 27) {
                        $b27_exists = TRUE;
                        break;
                    }
                }
            }
            if ($b27_exists) {
                $artefactResult = 'X';
            }
            if (!$b27_exists) {
                list($type, $effect) = explode(' ', $toVillageRow['artefacts']);
                if ($TreasuryLevel >= 10 && $effect == 2) {
                    if ($fromVillageRow['artefacts'] != '') {
                        $artefactResult = '#';
                    } else {
                        $this->captureArtefact($toVillageRow, $fromVillageRow);
                        $artefactResult = '+';
                    }
                } else {
                    if ($TreasuryLevel == 20 && $effect == 1) {
                        if ($fromVillageRow['artefacts'] != '') {
                            $artefactResult = '#';
                        } else {
                            $this->captureArtefact($toVillageRow, $fromVillageRow);
                            $artefactResult = '+';
                        }
                    } else {
                        $artefactResult = '-';
                    }
                }
            }
        }
        $newTroops = '';
        foreach ($warResult['attackTroops']['troops'] as $tid => $tprop) {
            if ($newTroops != '') {
                $newTroops .= ',';
            }
            $newTroops .= $tid . ' ' . $tprop['number'] . ' ' . ($tprop['number'] - $tprop['live_number']);
        }
        if ($procInfo['troopsArray']['hasHero']) {
            if ($newTroops != '') {
                $newTroops .= ',';
            }
            $newTroops .= -1 . ' ' . 1 . ' ' . ($warResult['all_attack_killed'] ? 1 : 0);
        }
        $attackReportTroops = $newTroops;
        $defenseReportTroops = '';
        foreach ($reportTroopTable as $tribeId => $defTroops) {
            $defenseReportTroops1 = '';
            if ($tribeId == 4) {
                $monsterTroops = array();
                foreach ($GameMetadata['troops'] as $t4k => $t4v) {
                    if ($t4v['for_tribe_id'] == 4) {
                        $monsterTroops[$t4k] = array('number' => isset($defTroops['troops'][$t4k]) ? $defTroops['troops'][$t4k]['number'] : 0, 'dead_number' => isset($defTroops['troops'][$t4k]) ? $defTroops['troops'][$t4k]['dead_number'] : 0);
                    }
                }
                $defTroops['troops'] = $monsterTroops;
            }
            foreach ($defTroops['troops'] as $tid => $tArr) {
                if ($defenseReportTroops1 != '') {
                    $defenseReportTroops1 .= ',';
                }
                $defenseReportTroops1 .= $tid . ' ' . $tArr['number'] . ' ' . $tArr['dead_number'];
            }
            if ($defTroops['hero']['number'] > 0) {
                if ($defenseReportTroops1 != '') {
                    $defenseReportTroops1 .= ',';
                }
                $defenseReportTroops1 .= -1 . ' ' . $defTroops['hero']['number'] . ' ' . $defTroops['hero']['dead_number'];
            }
            if ($defenseReportTroops1 != '') {
                if ($defenseReportTroops != '') {
                    $defenseReportTroops .= '#';
                }
                $defenseReportTroops .= $defenseReportTroops1;
            }
        }
        $timeInSeconds = $taskRow['remainingTimeInSeconds'];
        $attackDigit = 0;
        $defenseDigit = 0;
        if ($warResult['all_attack_killed']) {
            $attackDigit = 3;
            $defenseDigit = $warResult['defense_total_dead_number'] > 0 ? 5 : 4;
        } else {
            $attackDigit = $warResult['attackTroops']['total_dead_number'] > 0 ? 2 : 1;
            $defenseDigit = $warResult['defense_total_dead_number'] > 0 ? 6 : 7;
        }
        $reportResult = $defenseDigit * 10 + $attackDigit;
        $reportCategory = 3;
        $reportBody = $attackReportTroops . '|' . $defenseReportTroops . '|' . $warResult['attackTroops']['total_carry_load'] . '|' . $harvestResources . '|' . $wallDestructionResult . '|' . $catapultResult . '|' . $oasisResult . '|' . $captureResult . '|' . $artefactResult;
        $r = new ReportModel();
        $r->createReport(intval($fromVillageRow['player_id']), intval($toVillageRow['player_id']), intval($fromVillageRow['id']), intval($toVillageRow['id']), $reportCategory, $reportResult, $reportBody, $timeInSeconds);
        foreach ($villages as $vID => $vTroops) {
            $defenseReportTroops2 = '';
            $playerID = $this->provider->fetchScalar('SELECT v.player_id FROM p_villages v WHERE v.id=%s', array(intval($vID)));
            if ($playerID != NULL) {
                foreach ($vTroops['troops'] as $tid => $tArr) {
                    if ($defenseReportTroops2 != '') {
                        $defenseReportTroops2 .= ',';
                    }
                    $defenseReportTroops2 .= $tid . ' ' . $tArr['number'] . ' ' . $tArr['dead_number'];
                }
                if ($vTroops['hero']['number'] > 0) {
                    if ($defenseReportTroops2 != '') {
                        $defenseReportTroops2 .= ',';
                    }
                    $defenseReportTroops2 .= -1 . ' ' . $vTroops['hero']['number'] . ' ' . $vTroops['hero']['dead_number'];
                }
                $r->createReport('', intval($playerID), '', intval($toVillageRow['id']), 5, 62, $defenseReportTroops2, $taskRow['remainingTimeInSeconds']);
            }
        }
        if (intval($toVillageRow['player_id']) != intval($fromVillageRow['player_id'])) {
            $statisticPoint = 0;
            $harvestPoint = $harvestInfoStruct['sum'];
            if (intval($toVillageRow['player_id']) > 0 && intval($toVillageRow['tribe_id']) != 5) {
                $statisticPoint = $warResult['attackTroops']['total_dead_number'];
                $this->provider->executeQuery('UPDATE p_players p SET p.defense_points=p.defense_points+%s, p.week_defense_points=p.week_defense_points+%s WHERE p.id=%s', array($statisticPoint, $statisticPoint, intval($toVillageRow['player_id'])));
            }
            if (intval($fromVillageRow['player_id']) > 0 && intval($toVillageRow['tribe_id']) != 5) {
                $statisticPoint = $warResult['defense_total_dead_number'];
                $this->provider->executeQuery('UPDATE p_players p SET p.attack_points=p.attack_points+%s, p.week_attack_points=p.week_attack_points+%s, p.week_thief_points=p.week_thief_points+%s WHERE p.id=%s', array($statisticPoint, $statisticPoint, $harvestPoint, intval($fromVillageRow['player_id'])));
            }
            if (intval($toVillageRow['alliance_id']) > 0) {
                $statisticPoint = $warResult['attackTroops']['total_dead_number'];
                $this->provider->executeQuery('UPDATE p_alliances p SET p.rating=p.rating+%s, p.defense_points=p.defense_points+%s, p.week_defense_points=p.week_defense_points+%s WHERE p.id=%s', array($statisticPoint, $statisticPoint, $statisticPoint, intval($toVillageRow['alliance_id'])));
            }
            if (intval($fromVillageRow['alliance_id']) > 0) {
                $statisticPoint = $warResult['defense_total_dead_number'];
                $this->provider->executeQuery('UPDATE p_alliances p SET p.rating=p.rating+%s, p.attack_points=p.attack_points+%s, p.week_attack_points=p.week_attack_points+%s, p.week_thief_points=p.week_thief_points+%s WHERE p.id=%s', array($statisticPoint, $statisticPoint, $statisticPoint, $harvestPoint, intval($fromVillageRow['alliance_id'])));
            }
        }
        if (!$warResult['all_attack_killed'] && $doTroopsBack) {
            $paramsArray = explode('|', $taskRow['proc_params']);
            $paramsArray[sizeof($paramsArray) - 1] = 1;
            $newTroops = '';
            foreach ($warResult['attackTroops']['troops'] as $tid => $tprop) {
                if ($newTroops != '') {
                    $newTroops .= ',';
                }
                if ($villageCaptured && ($tid == 9 || $tid == 19 || $tid == 29)) {
                    $tprop['live_number'] = 0;
                }
                $newTroops .= $tid . ' ' . $tprop['live_number'];
            }
            if (!$warResult['all_attack_killed'] && $procInfo['troopsArray']['hasHero']) {
                if ($newTroops != '') {
                    $newTroops .= ',';
                }
                $newTroops .= $procInfo['troopsArray']['heroTroopId'] . ' -1';
            }
            $paramsArray[0] = $newTroops;
            $paramsArray[4] = $harvestResources;
            $newParams = implode('|', $paramsArray);
            $this->provider->executeQuery('UPDATE p_queue q 
				SET 
					q.player_id=%s,
					q.village_id=%s,
					q.to_player_id=%s,
					q.to_village_id=%s,
					q.proc_type=%s,
					q.proc_params=\'%s\',
					q.end_date=(q.end_date + INTERVAL q.execution_time SECOND)
				WHERE q.id=%s', array(intval($taskRow['to_player_id']), intval($taskRow['to_village_id']), intval($taskRow['player_id']), intval($taskRow['village_id']), QS_WAR_REINFORCE, $newParams, intval($taskRow['id'])));
            return TRUE;
        }
        return FALSE;
    }
Пример #2
0
 public function handleWarAttack($taskRow, $toVillageRow, $fromVillageRow, $procInfo)
 {
     $GameMetadata = $GLOBALS['GameMetadata'];
     $SetupMetadata = $GLOBALS['SetupMetadata'];
     if (!$toVillageRow['is_oasis'] && intval($toVillageRow['player_id']) == 0) {
         $paramsArray = explode("|", $taskRow['proc_params']);
         $paramsArray[sizeof($paramsArray) - 1] = 1;
         $newParams = implode("|", $paramsArray);
         $this->provider->executeQuery("UPDATE p_queue q \r\n\t\t\t\tSET \r\n\t\t\t\t\tq.player_id=%s,\r\n\t\t\t\t\tq.village_id=%s,\r\n\t\t\t\t\tq.to_player_id=%s,\r\n\t\t\t\t\tq.to_village_id=%s,\r\n\t\t\t\t\tq.proc_type=%s,\r\n\t\t\t\t\tq.proc_params='%s',\r\n\t\t\t\t\tq.end_date=(q.end_date + INTERVAL q.execution_time SECOND)\r\n\t\t\t\tWHERE q.id=%s", array(intval($taskRow['to_player_id']), intval($taskRow['to_village_id']), intval($taskRow['player_id']), intval($taskRow['village_id']), QS_WAR_REINFORCE, $newParams, intval($taskRow['id'])));
         return TRUE;
     }
     $heroLevel = 0;
     if ($procInfo['troopsArray']['hasHero']) {
         $heroLevel = intval($this->provider->fetchScalar("SELECT p.hero_level FROM p_players p WHERE p.id=%s", array(intval($fromVillageRow['player_id']))));
     }
     $heroBuildingLevel = 0;
     $wringerLevel = 0;
     $buildings = array();
     $bStr = trim($fromVillageRow['buildings']);
     if ($bStr != "") {
         $bStrArr = explode(",", $bStr);
         foreach ($bStrArr as $b2Str) {
             $update_state = explode(" ", $b2Str);
             $level = explode(" ", $b2Str);
             $item_id = explode(" ", $b2Str);
             list($item_id, $level, $update_state) = $item_id;
             if ($item_id == 35) {
                 $wringerLevel = $level;
             } else {
                 if ($item_id == 37) {
                     $heroBuildingLevel = $level;
                 }
             }
         }
     }
     $attackTroops = $this->_getAttackTroopsForVillage($fromVillageRow['troops_training'], $procInfo['troopsArray']['troops'], $heroLevel, $fromVillageRow['people_count'], $wringerLevel, FALSE);
     $buildinStabilityFactor = 1;
     $crannyTotalSize = 0;
     $wallPower = 0;
     $wallLevel = 0;
     $wallBid = 0;
     $wallItemId = 0;
     $buildings = array();
     $bStr = trim($toVillageRow['buildings']);
     if ($bStr != "") {
         $bStrArr = explode(",", $bStr);
         $fcc = 0;
         foreach ($bStrArr as $b2Str) {
             ++$fcc;
             $update_state = explode(" ", $b2Str);
             $level = explode(" ", $b2Str);
             $item_id = explode(" ", $b2Str);
             list($item_id, $level, $update_state) = $item_id;
             if ($item_id == 31 || $item_id == 32 || $item_id == 33) {
                 $wallBid = $fcc;
                 $wallItemId = $item_id;
                 $wallLevel = $level;
                 $wallPower = 0 < $level ? $GameMetadata['items'][$item_id]['levels'][$level - 1]['value'] : 0;
             } else {
                 if ($item_id == 23 && 0 < $level) {
                     $crannyTotalSize += $GameMetadata['items'][$item_id]['levels'][$level - 1]['value'] * $GameMetadata['items'][$item_id]['for_tribe_id'][$toVillageRow['tribe_id']];
                 } else {
                     if ($item_id == 34 && 0 < $level) {
                         $buildinStabilityFactor = $GameMetadata['items'][$item_id]['levels'][$level - 1]['value'] / 100;
                     }
                 }
             }
         }
     }
     $crannyTotalSize = floor($crannyTotalSize * $GameMetadata['tribes'][$fromVillageRow['tribe_id']]['crannyFactor']);
     $defenseTroops = array();
     $totalDefensePower = 0;
     $troops_num = trim($toVillageRow['troops_num']);
     if ($troops_num != "") {
         $vtroopsArr = explode("|", $troops_num);
         foreach ($vtroopsArr as $vtroopsStr) {
             $tvtroopsStr = explode(":", $vtroopsStr);
             $tvid = explode(":", $vtroopsStr);
             list($tvid, $tvtroopsStr) = $tvid;
             $incFactor = $toVillageRow['is_oasis'] && intval($toVillageRow['player_id']) == 0 && $tvid == 0 - 1 ? floor($toVillageRow['oasisElapsedTimeInSeconds'] / 86400) : 0;
             $_hasHero = FALSE;
             $vtroops = array();
             $_arr = explode(",", $tvtroopsStr);
             foreach ($_arr as $_arrStr) {
                 $_tnum = explode(" ", $_arrStr);
                 $_tid = explode(" ", $_arrStr);
                 list($_tid, $_tnum) = $_tid;
                 if ($_tnum == 0 - 1) {
                     $_hasHero = TRUE;
                 } else {
                     $vtroops[$_tid] = $_tnum + $incFactor;
                 }
             }
             if ($tvid == 0 - 1) {
                 $hero_in_village_id = intval($this->provider->fetchScalar("SELECT p.hero_in_village_id FROM p_players p WHERE p.id=%s", array(intval($toVillageRow['player_id']))));
                 if (0 < $hero_in_village_id && $hero_in_village_id == $toVillageRow['id']) {
                     $_hasHero = TRUE;
                 }
             }
             $defenseTroops[$tvid] = $this->_getDefenseTroopsForVillage($tvid == 0 - 1 ? $toVillageRow['id'] : $tvid, $vtroops, $_hasHero, $toVillageRow['people_count'], $wallPower, FALSE);
             $totalDefensePower += $defenseTroops[$tvid]['total_power'];
         }
     }
     $warResult = $this->getWarResult($attackTroops, $defenseTroops, $totalDefensePower, $taskRow['proc_type'] == QS_WAR_ATTACK_PLUNDER);
     $harvestResources = "0 0 0 0";
     $harvestInfoStruct = array("string" => $harvestResources, "sum" => 0);
     if (!$warResult['all_attack_killed']) {
         $harvestInfoStruct = $this->_harvestTroopsFrom($toVillageRow, $warResult['attackTroops']['total_carry_load'], $crannyTotalSize);
         $harvestResources = $harvestInfoStruct['string'];
     }
     $reduceConsumption = $warResult['attackTroops']['total_dead_consumption'];
     if ($warResult['all_attack_killed'] && $procInfo['troopsArray']['hasHero']) {
         $reduceConsumption += $GameMetadata['troops'][$procInfo['troopsArray']['heroTroopId']]['crop_consumption'];
     }
     if (0 < $reduceConsumption) {
         $this->_updateVillage($fromVillageRow, $reduceConsumption, $warResult['all_attack_killed'] && $procInfo['troopsArray']['hasHero']);
     }
     if ($procInfo['troopsArray']['hasHero'] && !$warResult['all_attack_killed'] && 1 <= $warResult['defense_total_dead_number']) {
         $heroStatisticPoint = 1;
         $this->provider->executeQuery("UPDATE p_players p SET p.hero_points=p.hero_points+%s, p.hero_level=p.hero_level+floor(p.hero_points/(100*(p.hero_level+1))) WHERE p.id=%s", array($heroStatisticPoint, intval($fromVillageRow['player_id'])));
     }
     $defenseTroopsStr = "";
     $defenseReduceConsumption = 0;
     $reportTroopTable = array();
     $tribeId = 0;
     foreach ($warResult['defenseTroops'] as $vid => $troopsTable) {
         $defenseReduceConsumption += $troopsTable['total_dead_consumption'];
         $newTroops = "";
         $thisInforcementDied = TRUE;
         foreach ($troopsTable['troops'] as $tid => $tprop) {
             if ($newTroops != "") {
                 $newTroops .= ",";
             }
             $newTroops .= $tid . " " . $tprop['live_number'];
             if (0 < $tprop['live_number']) {
                 $thisInforcementDied = FALSE;
             }
             $tribeId = $GameMetadata['troops'][$tid]['for_tribe_id'];
             if (!isset($reportTroopTable[$tribeId])) {
                 $reportTroopTable[$tribeId] = array("troops" => array(), "hero" => array("number" => 0, "dead_number" => 0));
             }
             if ($tid != 99) {
                 if (!isset($reportTroopTable[$tribeId]['troops'][$tid])) {
                     $reportTroopTable[$tribeId]['troops'][$tid] = array("number" => $tprop['number'], "dead_number" => $tprop['number'] - $tprop['live_number']);
                 } else {
                     $reportTroopTable[$tribeId]['troops'][$tid]['number'] += $tprop['number'];
                     $reportTroopTable[$tribeId]['troops'][$tid]['dead_number'] += $tprop['number'] - $tprop['live_number'];
                 }
             }
         }
         if ($troopsTable['hasHero']) {
             ++$reportTroopTable[$tribeId]['hero']['number'];
         }
         if (0 < $troopsTable['total_live_number'] && $troopsTable['hasHero']) {
             if ($vid != 0 - 1) {
                 if ($newTroops != "") {
                     $newTroops .= ",";
                 }
                 $newTroops .= $troopsTable['heroTroopId'] . " -1";
             }
             if ($vid == 0 - 1 && !$toVillageRow['is_oasis'] && $warResult['all_attack_killed']) {
                 $heroStatisticPoint = 1;
                 $this->provider->executeQuery("UPDATE p_players p SET p.hero_points=p.hero_points+%s, p.hero_level=p.hero_level+floor(p.hero_points/(100*(p.hero_level+1))) WHERE p.id=%s", array($heroStatisticPoint, intval($toVillageRow['player_id'])));
             }
             $thisInforcementDied = FALSE;
         }
         if ($troopsTable['hasHero'] && $troopsTable['total_live_number'] <= 0) {
             ++$reportTroopTable[$tribeId]['hero']['dead_number'];
             $defenseReduceConsumption += $GameMetadata['troops'][$troopsTable['heroTroopId']]['crop_consumption'];
         }
         $this->_updateVillageOutTroops($vid, $toVillageRow['id'], $newTroops, $troopsTable['hasHero'] && $troopsTable['total_live_number'] <= 0, $thisInforcementDied, intval($toVillageRow['player_id']));
         if ($vid == 0 - 1 && $toVillageRow['is_oasis']) {
             $this->provider->executeQuery("UPDATE p_villages v SET v.creation_date=NOW() WHERE v.id=%s", array(intval($toVillageRow['id'])));
         }
         if (!$thisInforcementDied || $vid == 0 - 1) {
             if ($defenseTroopsStr != "") {
                 $defenseTroopsStr .= "|";
             }
             $defenseTroopsStr .= $vid . ":" . $newTroops;
         }
     }
     if ($toVillageRow['is_oasis'] && 0 < intval($toVillageRow['player_id']) && isset($reportTroopTable[4])) {
         unset($reportTroopTable[4]);
     }
     $this->provider->executeQuery("UPDATE p_villages v SET v.troops_num='%s' WHERE v.id=%s", array($defenseTroopsStr, $toVillageRow['id']));
     if (!($toVillageRow['is_oasis'] && intval($toVillageRow['player_id']) == 0)) {
         $_tovid = $toVillageRow['is_oasis'] ? intval($toVillageRow['parent_id']) : $toVillageRow['id'];
         $this->provider->executeQuery("UPDATE p_villages v SET v.crop_consumption=v.crop_consumption-%s WHERE v.id=%s", array($defenseReduceConsumption, intval($_tovid)));
     }
     $villageTotallyDestructed = FALSE;
     $wallDestructionResult = "";
     $catapultResult = "";
     if (!$toVillageRow['is_oasis'] && !$warResult['all_attack_killed'] && $taskRow['proc_type'] != QS_WAR_ATTACK_PLUNDER) {
         $wallDestrTroopsCount = 0;
         $buildDestrTroopsCount = 0;
         foreach ($warResult['attackTroops']['troops'] as $tid => $tprop) {
             if ($tid == 7 || $tid == 17 || $tid == 27 || $tid == 106 || $tid == 57) {
                 $wallDestrTroopsCount = $tprop['live_number'];
             } else {
                 if ($tid == 8 || $tid == 18 || $tid == 28 || $tid == 107 || $tid == 58) {
                     $buildDestrTroopsCount = $tprop['live_number'];
                 }
             }
         }
         if ($procInfo['troopsArray']['hasWallDest']) {
             if (0 < $wallLevel) {
                 $dropLevels = 0;
                 if (2 * $wallPower < $wallDestrTroopsCount) {
                     $dropLevels = floor($wallDestrTroopsCount / (2 * $wallPower));
                     if ($wallLevel - $dropLevels < 0) {
                         $dropLevels = $wallLevel;
                     }
                 }
                 if (0 < $dropLevels) {
                     $wallDestructionResult = $wallLevel . "-" . ($wallLevel - $dropLevels);
                     $wallLevel -= $dropLevels;
                     $mq = new QueueJobModel();
                     while (0 < $dropLevels--) {
                         $mq->upgradeBuilding($toVillageRow['id'], $wallBid, $wallItemId, TRUE);
                     }
                 } else {
                     $wallDestructionResult = "-";
                 }
             } else {
                 $wallDestructionResult = "+";
             }
         }
         if (trim($procInfo['catapultTarget']) != "") {
             $catapultTargetArr = explode(":", $procInfo['catapultTarget']);
             $catapultTargetArr = explode(" ", $catapultTargetArr[1]);
             $buildingsInfo = array();
             $bStr = trim($toVillageRow['buildings']);
             if ($bStr != "") {
                 $bStrArr = explode(",", $bStr);
                 $_i = 0;
                 foreach ($bStrArr as $b2Str) {
                     ++$_i;
                     $update_state = explode(" ", $b2Str);
                     $level = explode(" ", $b2Str);
                     $item_id = explode(" ", $b2Str);
                     list($item_id, $level, $update_state) = $item_id;
                     if ($item_id == 31 || $item_id == 32 || $item_id == 33) {
                         continue;
                     }
                     if (0 < $level) {
                         $buildingsInfo[] = array("id" => $_i, "item_id" => $item_id, "level" => $level);
                     }
                 }
             }
             $catapultTargetInfoArr = array();
             if (0 < sizeof($buildingsInfo)) {
                 foreach ($catapultTargetArr as $catapultTargetItemId) {
                     $targetExists = FALSE;
                     foreach ($buildingsInfo as $bInfo) {
                         if (!($catapultTargetItemId == $bInfo['item_id'])) {
                             continue;
                         }
                         $catapultTargetInfoArr[] = $bInfo;
                         $targetExists = TRUE;
                         break;
                         break;
                     }
                     if (!$targetExists) {
                         $_randIndex = mt_rand(0, sizeof($buildingsInfo) - 1);
                         $catapultTargetInfoArr[] = $buildingsInfo[$_randIndex];
                     }
                 }
             }
             if (0 < sizeof($catapultTargetInfoArr)) {
                 if (1 < sizeof($catapultTargetInfoArr) && $catapultTargetInfoArr[0]['id'] == $catapultTargetInfoArr[1]['id']) {
                     $tmp = $catapultTargetInfoArr[0];
                     $catapultTargetInfoArr = array();
                     $catapultTargetInfoArr[] = $tmp;
                 }
                 $buildDestrTroopsCount = floor($buildDestrTroopsCount / sizeof($catapultTargetInfoArr));
                 foreach ($catapultTargetInfoArr as $catapultTargetInfoItem) {
                     if ($catapultResult != "") {
                         $catapultResult .= "#";
                     }
                     $canDestructBuilding = $catapultTargetInfoItem['level'] * $buildinStabilityFactor * 4 <= $buildDestrTroopsCount;
                     if ($canDestructBuilding) {
                         $dropBuildingLevels = floor($buildDestrTroopsCount / ($catapultTargetInfoItem['level'] * $buildinStabilityFactor * 4));
                         if ($catapultTargetInfoItem['level'] - $dropBuildingLevels < 0) {
                             $dropBuildingLevels = $catapultTargetInfoItem['level'];
                         }
                         $catapultResult .= $catapultTargetInfoItem['item_id'] . " " . $catapultTargetInfoItem['level'] . " " . ($catapultTargetInfoItem['level'] - $dropBuildingLevels);
                         $mq = new QueueJobModel();
                         do {
                             if (0 < $dropBuildingLevels--) {
                                 $mq->upgradeBuilding($toVillageRow['id'], $catapultTargetInfoItem['id'], $catapultTargetInfoItem['item_id'], TRUE);
                             }
                         } while (1);
                     } else {
                         $catapultResult .= $catapultTargetInfoItem['item_id'] . " " . $catapultTargetInfoItem['level'] . " -1";
                     }
                 }
             }
             if (!$toVillageRow['is_capital'] && !$toVillageRow['is_special_village']) {
                 $checkToVillageRow = $this->_getVillageInfo($taskRow['to_village_id']);
                 $villageTotallyDestructed = TRUE;
                 $bStr = trim($checkToVillageRow['buildings']);
                 if ($bStr != "") {
                     $bStrArr = explode(",", $bStr);
                     $_i = 0;
                     foreach ($bStrArr as $b2Str) {
                         ++$_i;
                         $update_state = explode(" ", $b2Str);
                         $level = explode(" ", $b2Str);
                         $item_id = explode(" ", $b2Str);
                         list($item_id, $level, $update_state) = $item_id;
                         if (!(0 < $level)) {
                             continue;
                         }
                         $villageTotallyDestructed = FALSE;
                         break;
                         break;
                     }
                 }
                 if ($villageTotallyDestructed) {
                     $catapultResult = "+";
                     $this->leaveVillage($toVillageRow['id'], $toVillageRow['player_id'], $toVillageRow['people_count'], $toVillageRow['parent_id']);
                 }
             }
         }
     }
     $doTroopsBack = TRUE;
     $villageCaptured = FALSE;
     $captureResult = "";
     if ($procInfo['troopsArray']['hasKing'] && !$toVillageRow['is_oasis'] && !$warResult['all_attack_killed'] && $taskRow['proc_type'] != QS_WAR_ATTACK_PLUNDER && !$toVillageRow['is_capital'] && !$villageTotallyDestructed && $warResult['all_defense_killed'] && $toVillageRow['player_id'] != $fromVillageRow['player_id']) {
         $checkToVillageRow = $this->_getVillageInfo($taskRow['to_village_id']);
         $b25_26_exists = FALSE;
         $bStr = trim($checkToVillageRow['buildings']);
         if ($bStr != "") {
             $bStrArr = explode(",", $bStr);
             foreach ($bStrArr as $b2Str) {
                 $update_state = explode(" ", $b2Str);
                 $level = explode(" ", $b2Str);
                 $item_id = explode(" ", $b2Str);
                 list($item_id, $level, $update_state) = $item_id;
                 if (0 < $level && ($item_id == 25 || $item_id == 26)) {
                     $b25_26_exists = TRUE;
                     break;
                 }
             }
         }
         $kingIsLive = FALSE;
         foreach ($warResult['attackTroops']['troops'] as $tid => $tprop) {
             if (!($tid == 9 || $tid == 19 || $tid == 29 || $tid == 108 || $tid == 59)) {
                 continue;
             }
             $kingIsLive = 0 < $tprop['live_number'];
             break;
             break;
         }
         if ($kingIsLive && !$b25_26_exists) {
             $allegiance_percent = $toVillageRow['allegiance_percent'];
             $allegiance_percent -= 25;
             if (0 < $allegiance_percent) {
                 $this->provider->executeQuery("UPDATE p_villages v SET v.allegiance_percent=%s WHERE v.id=%s", array($allegiance_percent, intval($toVillageRow['id'])));
                 $captureResult = $toVillageRow['allegiance_percent'] . "-" . $allegiance_percent;
             } else {
                 $allegiance_percent = 0;
                 $captureResult = "+";
             }
             if ($allegiance_percent == 0) {
                 $villageCaptured = TRUE;
                 $kingCropConumption = 0;
                 $doTroopsBack = FALSE;
                 foreach ($warResult['attackTroops']['troops'] as $tid => $tprop) {
                     if ($tid == 9 || $tid == 19 || $tid == 29 || $tid == 108 || $tid == 59) {
                         $kingCropConumption = $GLOBALS['GameMetadata']['troops'][$tid]['crop_consumption'];
                         break;
                     }
                     if (0 < $tprop['live_number']) {
                         $doTroopsBack = TRUE;
                     }
                 }
                 $this->leaveVillage($toVillageRow['id'], $toVillageRow['player_id'], $toVillageRow['people_count'], $toVillageRow['parent_id'], FALSE);
                 $this->captureVillage($toVillageRow, $fromVillageRow, $kingCropConumption);
             }
         }
     }
     $oasisResult = "";
     if ($procInfo['troopsArray']['hasHero'] && $toVillageRow['is_oasis'] && !$warResult['all_attack_killed'] && $warResult['all_defense_killed'] && $toVillageRow['player_id'] != $fromVillageRow['player_id'] && 10 <= $heroBuildingLevel) {
         $canCaptureOasis = FALSE;
         $numberOfOwnedOases = trim($fromVillageRow['village_oases_id']) == "" ? 0 : sizeof(explode(",", $fromVillageRow['village_oases_id']));
         if ($heroBuildingLevel == 20) {
             $canCaptureOasis = $numberOfOwnedOases < 3;
         } else {
             if (15 <= $heroBuildingLevel) {
                 $canCaptureOasis = $numberOfOwnedOases < 2;
             } else {
                 if (10 <= $heroBuildingLevel) {
                     $canCaptureOasis = $numberOfOwnedOases < 1;
                 }
             }
         }
         $oasisInRang = FALSE;
         $rang = 3;
         $map_size = $SetupMetadata['map_size'];
         $x = $fromVillageRow['rel_x'];
         $y = $fromVillageRow['rel_y'];
         $mi = 0 - $rang;
         while ($mi <= $rang) {
             if ($oasisInRang) {
                 break;
             }
             $mj = 0 - $rang;
             while ($mj <= $rang) {
                 if ($toVillageRow['id'] == $this->__getVillageId($map_size, $this->__getCoordInRange($map_size, $x + $mi), $this->__getCoordInRange($map_size, $y + $mj))) {
                     $oasisInRang = TRUE;
                     break;
                 }
                 ++$mj;
             }
             ++$mi;
         }
         if ($canCaptureOasis && $oasisInRang) {
             $qm = new QueueJobModel();
             if (intval($toVillageRow['player_id']) == 0) {
                 $oasisResult = "+";
                 $qm->captureOasis($toVillageRow['id'], $fromVillageRow['player_id'], $fromVillageRow['id'], TRUE);
             } else {
                 $allegiance_percent = $toVillageRow['allegiance_percent'];
                 $allegiance_percent -= 25;
                 if (0 < $allegiance_percent) {
                     $oasisResult = $toVillageRow['allegiance_percent'] . "-" . $allegiance_percent;
                     $this->provider->executeQuery("UPDATE p_villages v SET v.allegiance_percent=%s WHERE v.id=%s", array($allegiance_percent, intval($toVillageRow['id'])));
                 } else {
                     $allegiance_percent = 0;
                     $oasisResult = "+";
                 }
                 if ($allegiance_percent == 0) {
                     $qm->captureOasis($toVillageRow['id'], $toVillageRow['player_id'], $toVillageRow['parent_id'], FALSE);
                     $qm->captureOasis($toVillageRow['id'], $fromVillageRow['player_id'], $fromVillageRow['id'], TRUE);
                 }
             }
         }
     }
     $newTroops = "";
     foreach ($warResult['attackTroops']['troops'] as $tid => $tprop) {
         if ($newTroops != "") {
             $newTroops .= ",";
         }
         $newTroops .= $tid . " " . $tprop['number'] . " " . ($tprop['number'] - $tprop['live_number']);
     }
     if ($procInfo['troopsArray']['hasHero']) {
         if ($newTroops != "") {
             $newTroops .= ",";
         }
         $newTroops .= 0 - 1 . " " . 1 . " " . ($warResult['all_attack_killed'] ? 1 : 0);
     }
     $attackReportTroops = $newTroops;
     $defenseReportTroops = "";
     foreach ($reportTroopTable as $tribeId => $defTroops) {
         $defenseReportTroops1 = "";
         if ($tribeId == 4) {
             $monsterTroops = array();
             foreach ($GLOBALS['GameMetadata']['troops'] as $t4k => $t4v) {
                 if ($t4v['for_tribe_id'] == 4) {
                     $monsterTroops[$t4k] = array("number" => isset($defTroops['troops'][$t4k]) ? $defTroops['troops'][$t4k]['number'] : 0, "dead_number" => isset($defTroops['troops'][$t4k]) ? $defTroops['troops'][$t4k]['dead_number'] : 0);
                 }
             }
             $defTroops['troops'] = $monsterTroops;
         }
         foreach ($defTroops['troops'] as $tid => $tArr) {
             if ($defenseReportTroops1 != "") {
                 $defenseReportTroops1 .= ",";
             }
             $defenseReportTroops1 .= $tid . " " . $tArr['number'] . " " . $tArr['dead_number'];
         }
         if (0 < $defTroops['hero']['number']) {
             if ($defenseReportTroops1 != "") {
                 $defenseReportTroops1 .= ",";
             }
             $defenseReportTroops1 .= 0 - 1 . " " . $defTroops['hero']['number'] . " " . $defTroops['hero']['dead_number'];
         }
         if ($defenseReportTroops1 != "") {
             if ($defenseReportTroops != "") {
                 $defenseReportTroops .= "#";
             }
             $defenseReportTroops .= $defenseReportTroops1;
         }
     }
     $timeInSeconds = $taskRow['remainingTimeInSeconds'];
     $attackDigit = 0;
     $defenseDigit = 0;
     if ($warResult['all_attack_killed']) {
         $attackDigit = 3;
         $defenseDigit = 0 < $warResult['defense_total_dead_number'] ? 5 : 4;
     } else {
         $attackDigit = 0 < $warResult['attackTroops']['total_dead_number'] ? 2 : 1;
         $defenseDigit = 0 < $warResult['defense_total_dead_number'] ? 6 : 7;
     }
     $reportResult = $defenseDigit * 10 + $attackDigit;
     $reportCategory = 3;
     $reportBody = $attackReportTroops . "|" . $defenseReportTroops . "|" . $warResult['attackTroops']['total_carry_load'] . "|" . $harvestResources . "|" . $wallDestructionResult . "|" . $catapultResult . "|" . $oasisResult . "|" . $captureResult;
     $r = new ReportModel();
     $r->createReport(intval($fromVillageRow['player_id']), intval($toVillageRow['player_id']), intval($fromVillageRow['id']), intval($toVillageRow['id']), $reportCategory, $reportResult, $reportBody, $timeInSeconds);
     if (intval($toVillageRow['player_id']) != intval($fromVillageRow['player_id'])) {
         $statisticPoint = 0;
         $harvestPoint = $harvestInfoStruct['sum'];
         if (0 < intval($toVillageRow['player_id']) && intval($toVillageRow['tribe_id']) != 5) {
             $statisticPoint = $warResult['attackTroops']['total_dead_number'];
             $this->provider->executeQuery("UPDATE p_players p SET p.defense_points=p.defense_points+%s, p.week_defense_points=p.week_defense_points+%s WHERE p.id=%s", array($statisticPoint, $statisticPoint, intval($toVillageRow['player_id'])));
         }
         if (0 < intval($fromVillageRow['player_id']) && intval($fromVillageRow['tribe_id']) != 5) {
             $statisticPoint = $warResult['defense_total_dead_number'];
             $this->provider->executeQuery("UPDATE p_players p SET p.attack_points=p.attack_points+%s, p.week_attack_points=p.week_attack_points+%s, p.week_thief_points=p.week_thief_points+%s WHERE p.id=%s", array($statisticPoint, $statisticPoint, $harvestPoint, intval($fromVillageRow['player_id'])));
         }
         if (0 < intval($toVillageRow['alliance_id'])) {
             $statisticPoint = $warResult['attackTroops']['total_dead_number'];
             $allianceRate = $warResult['all_attack_killed'] ? 1 : 0;
             $this->provider->executeQuery("UPDATE p_alliances p SET p.rating=p.rating+%s, p.defense_points=p.defense_points+%s, p.week_defense_points=p.week_defense_points+%s WHERE p.id=%s", array($allianceRate, $statisticPoint, $statisticPoint, intval($toVillageRow['alliance_id'])));
         }
         if (0 < intval($fromVillageRow['alliance_id'])) {
             $statisticPoint = $warResult['defense_total_dead_number'];
             $allianceRate = !$warResult['all_attack_killed'] && 0 < $statisticPoint ? 1 : 0;
             $this->provider->executeQuery("UPDATE p_alliances p SET p.rating=p.rating+%s, p.attack_points=p.attack_points+%s, p.week_attack_points=p.week_attack_points+%s, p.week_thief_points=p.week_thief_points+%s WHERE p.id=%s", array($allianceRate, $statisticPoint, $statisticPoint, $harvestPoint, intval($fromVillageRow['alliance_id'])));
         }
     }
     if (!$warResult['all_attack_killed'] && $doTroopsBack) {
         $paramsArray = explode("|", $taskRow['proc_params']);
         $paramsArray[sizeof($paramsArray) - 1] = 1;
         $newTroops = "";
         foreach ($warResult['attackTroops']['troops'] as $tid => $tprop) {
             if ($newTroops != "") {
                 $newTroops .= ",";
             }
             if ($villageCaptured && ($tid == 9 || $tid == 19 || $tid == 29 || $tid == 108 || $tid == 59)) {
                 $tprop['live_number'] = 0;
             }
             $newTroops .= $tid . " " . $tprop['live_number'];
         }
         if (!$warResult['all_attack_killed'] && $procInfo['troopsArray']['hasHero']) {
             if ($newTroops != "") {
                 $newTroops .= ",";
             }
             $newTroops .= $procInfo['troopsArray']['heroTroopId'] . " -1";
         }
         $paramsArray[0] = $newTroops;
         $paramsArray[4] = $harvestResources;
         $newParams = implode("|", $paramsArray);
         $this->provider->executeQuery("UPDATE p_queue q \r\n\t\t\t\tSET \r\n\t\t\t\t\tq.player_id=%s,\r\n\t\t\t\t\tq.village_id=%s,\r\n\t\t\t\t\tq.to_player_id=%s,\r\n\t\t\t\t\tq.to_village_id=%s,\r\n\t\t\t\t\tq.proc_type=%s,\r\n\t\t\t\t\tq.proc_params='%s',\r\n\t\t\t\t\tq.end_date=(q.end_date + INTERVAL q.execution_time SECOND)\r\n\t\t\t\tWHERE q.id=%s", array(intval($taskRow['to_player_id']), intval($taskRow['to_village_id']), intval($taskRow['player_id']), intval($taskRow['village_id']), QS_WAR_REINFORCE, $newParams, intval($taskRow['id'])));
         return TRUE;
     }
     return FALSE;
 }