Ejemplo n.º 1
0
 function load()
 {
     parent::load();
     $m = new ActivateModel();
     if (isset($_GET['id'])) {
         $this->playerStatus = $m->doActivation($_GET['id']) ? 1 : 2;
     } else {
         if (isset($_GET['uid'])) {
             $this->uid = intval($_GET['uid']);
             $row = $m->getPlayerData($this->uid);
             if ($row == NULL) {
                 $this->uid = 0 - 1;
             } else {
                 $this->uname = $row['name'];
                 if ($this->isPost()) {
                     if (isset($_POST['pw']) && md5($_POST['pw']) == $row['pwd']) {
                         $mj = new QueueJobModel();
                         $mj->deletePlayer($this->uid);
                         $this->playerStatus = 3;
                     }
                 }
             }
         }
     }
     $m->dispose();
 }
Ejemplo n.º 2
0
 function load()
 {
     // run the queue job
     if (!$this->isCallback()) {
         $qj = new QueueJobModel();
         $qj->processQueue();
     }
     // change the selected village
     if (isset($_GET['vid']) && $this->globalModel->hasVillage($this->player->playerId, intval($_GET['vid']))) {
         $this->globalModel->setSelectedVillage($this->player->playerId, intval($_GET['vid']));
     }
     // fetch the player/village data
     $this->data = $this->globalModel->getVillageData($this->player->playerId);
     if ($this->data == NULL) {
         $this->player->logout();
         $this->redirect('index.php');
         return;
     }
     $this->player->gameStatus = $this->data['gameStatus'];
     if ($this->isCallback()) {
         return;
     }
     // check for global message
     if ($this->checkForGlobalMessage && !$this->player->isSpy && $this->data['new_gnews'] == 1) {
         $this->redirect('shownew.php');
         return;
     }
     // check for new village creation flag
     if ($this->checkForNewVillage && !$this->player->isSpy && intval($this->data['create_nvil']) == 1) {
         $this->redirect('shownvill.php');
         return;
     }
     $bannerModel = new AdvertisingModel();
     $this->banner = $bannerModel->GetBanner(2);
     // fetch the items in the queue
     $this->queueModel->fetchQueue($this->player->playerId);
     // fill the player custom links
     if (trim($this->data['custom_links']) != '') {
         $lnk_arr = explode("\n\n", $this->data['custom_links']);
         foreach ($lnk_arr as $lnk_str) {
             list($linkName, $linkHref, $linkSelfTarget) = explode("\n", $lnk_str);
             $this->playerLinks[] = array('linkName' => $linkName, 'linkHref' => $linkHref, 'linkSelfTarget' => $linkSelfTarget != '*');
         }
     }
     // fill the player villages array
     $v_arr = explode("\n", $this->data['villages_data']);
     foreach ($v_arr as $v_str) {
         list($vid, $x, $y, $vname) = explode(' ', $v_str, 4);
         $this->playerVillages[$vid] = array($x, $y, $vname);
     }
     // fill the resources
     $wrapString = '';
     $elapsedTimeInSeconds = $this->data['elapsedTimeInSeconds'];
     $r_arr = explode(',', $this->data['resources']);
     foreach ($r_arr as $r_str) {
         $r2 = explode(' ', $r_str);
         $prate = floor($r2[4] * (1 + $r2[5] / 100)) - ($r2[0] == 4 ? $this->data['crop_consumption'] : 0);
         $current_value = floor($r2[1] + $elapsedTimeInSeconds * ($prate / 3600));
         if ($current_value > $r2[2]) {
             $current_value = $r2[2];
         }
         $this->resources[$r2[0]] = array('current_value' => $current_value, 'store_max_limit' => $r2[2], 'store_init_limit' => $r2[3], 'prod_rate' => $r2[4], 'prod_rate_percentage' => $r2[5], 'calc_prod_rate' => $prate);
         $wrapString .= $this->resources[$r2[0]]['current_value'] . $this->resources[$r2[0]]['store_max_limit'];
     }
     $this->wrap = strlen($wrapString) > 40;
     // calc the cp
     list($this->cpValue, $this->cpRate) = explode(' ', $this->data['cp']);
     $this->cpValue += $elapsedTimeInSeconds * ($this->cpRate / 86400);
 }
Ejemplo n.º 3
0
 public function makeVillageAsCapital($playerId, $villageId)
 {
     $mq = new QueueJobModel();
     $capitalRow = $this->provider->fetchRow("SELECT v.id, v.buildings FROM p_villages v WHERE  v.player_id=%s AND v.is_capital=1", array($playerId));
     $buildingArr = explode(",", $capitalRow['buildings']);
     $c = 0;
     foreach ($buildingArr as $buildingItem) {
         ++$c;
         $update_state = explode(" ", $buildingItem[2]);
         $level = explode(" ", $buildingItem[1]);
         $item_id = explode(" ", $buildingItem[0]);
         list($item_id, $level, $update_state) = $item_id;
         if ($item_id == 0) {
             continue;
         }
         $max_lvl_in_non_capital = $GLOBALS['GameMetadata']['items'][$item_id]['max_lvl_in_non_capital'];
         if ($max_lvl_in_non_capital == NULL || $level + $update_state <= $max_lvl_in_non_capital) {
             continue;
         }
         $dropLevels = $level + $update_state - $max_lvl_in_non_capital;
         while (0 < $dropLevels--) {
             $mq->upgradeBuilding($capitalRow['id'], $c, $item_id, TRUE);
         }
     }
     $this->provider->executeQuery("UPDATE p_villages v SET v.is_capital=0 WHERE v.player_id=%s", array($playerId));
     $this->provider->executeQuery("UPDATE p_villages v SET v.is_capital=1 WHERE v.id=%s AND v.player_id=%s", array($villageId, $playerId));
 }
Ejemplo n.º 4
0
 public function load()
 {
     parent::load();
     $this->selectedTabIndex = isset($_GET['t']) && is_numeric($_GET['t']) && 0 <= intval($_GET['t']) && intval($_GET['t']) <= 11 ? intval($_GET['t']) : 0;
     $this->isAdmin = $this->data['player_type'] == PLAYERTYPE_ADMIN;
     $this->_tb = isset($_GET['tb']) ? intval($_GET['tb']) : 0;
     $m = new StatisticsModel();
     $this->tatarRaised = $m->tatarRaised();
     if ($this->selectedTabIndex == 11 && !$this->tatarRaised) {
         $this->selectedTabIndex = 0;
     }
     $this->selectedRank = 0;
     if ($this->selectedTabIndex == 0) {
         if ($this->isPost() && isset($_POST['rank']) && isset($_POST['name'])) {
             if (trim($_POST['name']) != "") {
                 $this->selectedRank = intval($m->getPlayerRankByName(trim($_POST['name']), $this->_tb));
             } else {
                 if (0 < intval($_POST['rank'])) {
                     $this->selectedRank = intval($_POST['rank']);
                 }
             }
         } else {
             if (!isset($_GET['p'])) {
                 $this->selectedRank = 0 < $this->_tb && $this->data['tribe_id'] != $this->_tb ? 1 : intval($m->getPlayerRankById($this->player->playerId, $this->_tb));
             }
         }
         if ($this->isAdmin && !$this->isPost()) {
             if (isset($_GET['_cs']) && 0 < intval($_GET['_cs'])) {
                 $m->togglePlayerStatus(intval($_GET['_cs']));
                 $this->adminActionMessage = statistics_p_playerstatusch;
             } else {
                 if (isset($_GET['_dp']) && 0 < intval($_GET['_dp'])) {
                     if ($m->getPlayerType(intval($_GET['_dp'])) == PLAYERTYPE_NORMAL) {
                         $qm = new QueueJobModel();
                         $qm->deletePlayer(intval($_GET['_dp']));
                         $this->adminActionMessage = statistics_p_playerdeleted;
                     }
                 } else {
                     if (isset($_GET['_gd']) && 0 < intval($_GET['_gd']) && isset($_GET['_g']) && 0 <= intval($_GET['_g'])) {
                         $m->setPlayerGold(intval($_GET['_gd']), intval($_GET['_g']));
                         $this->adminActionMessage = statistics_p_goldwaschanged;
                     }
                 }
             }
         }
     } else {
         if ($this->selectedTabIndex == 1) {
             if ($this->isPost() && isset($_POST['rank']) && isset($_POST['name'])) {
                 if (trim($_POST['name']) != "") {
                     $this->selectedRank = intval($m->getAllianceRankByName(trim($_POST['name'])));
                 } else {
                     if (0 < intval($_POST['rank'])) {
                         $this->selectedRank = intval($_POST['rank']);
                     }
                 }
             } else {
                 if (!isset($_GET['p'])) {
                     $this->selectedRank = intval($m->getAllianceRankById(intval($this->data['alliance_id'])));
                 }
             }
         } else {
             if ($this->selectedTabIndex == 2) {
                 if ($this->isPost() && isset($_POST['rank']) && isset($_POST['name'])) {
                     if (trim($_POST['name']) != "") {
                         $this->selectedRank = intval($m->getVillageRankByName(trim($_POST['name'])));
                     } else {
                         if (0 < intval($_POST['rank'])) {
                             $this->selectedRank = intval($_POST['rank']);
                         }
                     }
                 } else {
                     if (!isset($_GET['p'])) {
                         $this->selectedRank = intval($m->getVillageRankById($this->data['selected_village_id']));
                     }
                 }
             } else {
                 if ($this->selectedTabIndex == 3) {
                     if ($this->isPost() && isset($_POST['rank']) && isset($_POST['name'])) {
                         if (trim($_POST['name']) != "") {
                             $this->selectedRank = intval($m->getHeroRankByName(trim($_POST['name'])));
                         } else {
                             if (0 < intval($_POST['rank'])) {
                                 $this->selectedRank = intval($_POST['rank']);
                             }
                         }
                     } else {
                         if (!isset($_GET['p'])) {
                             $this->selectedRank = intval($m->getHeroRankById($this->player->playerId));
                         }
                     }
                 } else {
                     if ($this->selectedTabIndex == 6 || $this->selectedTabIndex == 7) {
                         if ($this->isPost() && isset($_POST['rank']) && isset($_POST['name'])) {
                             if (trim($_POST['name']) != "") {
                                 $this->selectedRank = intval($m->getPlayersPointsByName(trim($_POST['name']), $this->selectedTabIndex == 6));
                             } else {
                                 if (0 < intval($_POST['rank'])) {
                                     $this->selectedRank = intval($_POST['rank']);
                                 }
                             }
                         } else {
                             if (!isset($_GET['p'])) {
                                 $this->selectedRank = intval($m->getPlayersPointsById($this->player->playerId, $this->selectedTabIndex == 6));
                             }
                         }
                     } else {
                         if ($this->selectedTabIndex == 9 || $this->selectedTabIndex == 10) {
                             if ($this->isPost() && isset($_POST['rank']) && isset($_POST['name'])) {
                                 if (trim($_POST['name']) != "") {
                                     $this->selectedRank = intval($m->getAlliancePointsRankByName(trim($_POST['name']), $this->selectedTabIndex == 9));
                                 } else {
                                     if (0 < intval($_POST['rank'])) {
                                         $this->selectedRank = intval($_POST['rank']);
                                     }
                                 }
                             } else {
                                 if (!isset($_GET['p'])) {
                                     $this->selectedRank = intval($m->getAlliancePointsRankById(intval($this->data['alliance_id']), $this->selectedTabIndex == 9));
                                 }
                             }
                         }
                     }
                 }
             }
         }
     }
     if ($this->selectedTabIndex == 0) {
         $rowsCount = $m->getPlayerListCount($this->_tb);
         $this->pageCount = 0 < $rowsCount ? ceil($rowsCount / $this->pageSize) : 1;
         $this->pageIndex = 0 < $this->selectedRank ? floor(($this->selectedRank - 1) / $this->pageSize) : isset($_GET['p']) && is_numeric($_GET['p']) ? intval($_GET['p']) : 0;
         if ($this->pageCount <= $this->pageIndex) {
             $this->pageIndex = $this->pageCount - 1;
             $this->selectedRank = 0 - 1;
         }
         $this->dataList = $m->getPlayerList($this->pageIndex, $this->pageSize, $this->_tb);
     } else {
         if ($this->selectedTabIndex == 1) {
             $rowsCount = $m->getAllianceListCount();
             $this->pageCount = 0 < $rowsCount ? ceil($rowsCount / $this->pageSize) : 1;
             $this->pageIndex = 0 < $this->selectedRank ? floor(($this->selectedRank - 1) / $this->pageSize) : isset($_GET['p']) && is_numeric($_GET['p']) ? intval($_GET['p']) : 0;
             if ($this->pageCount <= $this->pageIndex) {
                 $this->pageIndex = $this->pageCount - 1;
                 $this->selectedRank = 0 - 1;
             }
             $this->dataList = $m->getAlliancesList($this->pageIndex, $this->pageSize);
         } else {
             if ($this->selectedTabIndex == 2) {
                 $rowsCount = $m->getVillageListCount();
                 $this->pageCount = 0 < $rowsCount ? ceil($rowsCount / $this->pageSize) : 1;
                 $this->pageIndex = 0 < $this->selectedRank ? floor(($this->selectedRank - 1) / $this->pageSize) : isset($_GET['p']) && is_numeric($_GET['p']) ? intval($_GET['p']) : 0;
                 if ($this->pageCount <= $this->pageIndex) {
                     $this->pageIndex = $this->pageCount - 1;
                     $this->selectedRank = 0 - 1;
                 }
                 $this->dataList = $m->getVillagesList($this->pageIndex, $this->pageSize);
             } else {
                 if ($this->selectedTabIndex == 3) {
                     $rowsCount = $m->getHeroListCount();
                     $this->pageCount = 0 < $rowsCount ? ceil($rowsCount / $this->pageSize) : 1;
                     $this->pageIndex = 0 < $this->selectedRank ? floor(($this->selectedRank - 1) / $this->pageSize) : isset($_GET['p']) && is_numeric($_GET['p']) ? intval($_GET['p']) : 0;
                     if ($this->pageCount <= $this->pageIndex) {
                         $this->pageIndex = $this->pageCount - 1;
                         $this->selectedRank = 0 - 1;
                     }
                     $this->dataList = $m->getHerosList($this->pageIndex, $this->pageSize);
                 } else {
                     if ($this->selectedTabIndex == 4) {
                         $this->generalData = $m->getGeneralSummary();
                     } else {
                         if ($this->selectedTabIndex == 6 || $this->selectedTabIndex == 7) {
                             $rowsCount = $m->getPlayersPointsListCount();
                             $this->pageCount = 0 < $rowsCount ? ceil($rowsCount / $this->pageSize) : 1;
                             $this->pageIndex = 0 < $this->selectedRank ? floor(($this->selectedRank - 1) / $this->pageSize) : isset($_GET['p']) && is_numeric($_GET['p']) ? intval($_GET['p']) : 0;
                             if ($this->pageCount <= $this->pageIndex) {
                                 $this->pageIndex = $this->pageCount - 1;
                                 $this->selectedRank = 0 - 1;
                             }
                             $this->dataList = $m->getPlayersPointsList($this->pageIndex, $this->pageSize, $this->selectedTabIndex == 6);
                         } else {
                             if ($this->selectedTabIndex == 9 || $this->selectedTabIndex == 10) {
                                 $rowsCount = $m->getAlliancePointsListCount();
                                 $this->pageCount = 0 < $rowsCount ? ceil($rowsCount / $this->pageSize) : 1;
                                 $this->pageIndex = 0 < $this->selectedRank ? floor(($this->selectedRank - 1) / $this->pageSize) : isset($_GET['p']) && is_numeric($_GET['p']) ? intval($_GET['p']) : 0;
                                 if ($this->pageCount <= $this->pageIndex) {
                                     $this->pageIndex = $this->pageCount - 1;
                                     $this->selectedRank = 0 - 1;
                                 }
                                 $this->dataList = $m->getAlliancePointsList($this->pageIndex, $this->pageSize, $this->selectedTabIndex == 9);
                             } else {
                                 if ($this->selectedTabIndex == 5 || $this->selectedTabIndex == 8) {
                                     if ($this->selectedTabIndex == 5) {
                                     }
                                     $this->top10Result = array("URL" => $this->selectedTabIndex == 5 ? "profile.php?uid=" : "alliance.php?id=", "TARGETNAME" => $this->selectedTabIndex == 5 ? $this->data['name'] : $this->data['alliance_name'], "TARGETID" => $this->selectedTabIndex == 5 ? $this->player->playerId : intval($this->data['alliance_id']), "TARGEPOINT_ATTACK" => $this->selectedTabIndex == 5 ? $this->data['week_attack_points'] : $m->getAlliancePoint(intval($this->data['alliance_id']), "week_attack_points"), "TARGEPOINT_DEFENSE" => $this->selectedTabIndex == 5 ? $this->data['week_defense_points'] : $m->getAlliancePoint(intval($this->data['alliance_id']), "week_defense_points"), "TARGEPOINT_DEV" => $this->selectedTabIndex == 5 ? $this->data['week_dev_points'] : $m->getAlliancePoint(intval($this->data['alliance_id']), "week_dev_points"), "TARGEPOINT_THIEF" => $this->selectedTabIndex == 5 ? $this->data['week_thief_points'] : $m->getAlliancePoint(intval($this->data['alliance_id']), "week_thief_points"), "ATTACK" => $m->getTop10($this->selectedTabIndex == 5, "week_attack_points"), "DEFENSE" => $m->getTop10($this->selectedTabIndex == 5, "week_defense_points"), "DEV" => $m->getTop10($this->selectedTabIndex == 5, "week_dev_points"), "THIEF" => $m->getTop10($this->selectedTabIndex == 5, "week_thief_points"));
                                 } else {
                                     if ($this->selectedTabIndex == 11) {
                                         $this->dataList = $m->getTatarVillagesList();
                                     }
                                 }
                             }
                         }
                     }
                 }
             }
         }
     }
     $m->dispose();
 }
Ejemplo n.º 5
0
 function captureVillage($toVillageRow, $fromVillageRow, $kingCropConumption)
 {
     global $GameMetadata, $SetupMetadata;
     $this->provider->executeQuery('DELETE FROM p_queue WHERE player_id=%s AND village_id=%s AND proc_type IN (%s)', array(intval($toVillageRow['player_id']), intval($toVillageRow['id']), QS_BUILD_CREATEUPGRADE . ',' . QS_BUILD_DROP . ',' . QS_TROOP_RESEARCH . ',' . QS_TROOP_UPGRADE_ATTACK . ',' . QS_TROOP_UPGRADE_DEFENSE . ',' . QS_TROOP_TRAINING . ',' . QS_TROOP_TRAINING_HERO . ',' . QS_WAR_ATTACK . ',' . QS_WAR_ATTACK_PLUNDER . ',' . QS_WAR_ATTACK_SPY . ',' . QS_CREATEVILLAGE));
     $troops_training = '';
     $troops_num = '';
     foreach ($GameMetadata['troops'] as $k => $v) {
         if ($v['for_tribe_id'] == -1 || $v['for_tribe_id'] == $fromVillageRow['tribe_id']) {
             if ($troops_training != '') {
                 $troops_training .= ',';
             }
             $researching_done = $v['research_time_consume'] == 0 ? 1 : 0;
             $troops_training .= $k . ' ' . $researching_done . ' 0 0';
             if ($troops_num != '') {
                 $troops_num .= ',';
             }
             $troops_num .= $k . ' 0';
         }
     }
     $troops_num = '-1:' . $troops_num;
     $buildings = '';
     $reCheckBuilding = $this->provider->fetchScalar('SELECT v.buildings FROM p_villages v WHERE v.id=%s', array(intval($toVillageRow['id'])));
     $bStr = trim($reCheckBuilding);
     if ($bStr != '') {
         $bStrArr = explode(',', $bStr);
         $mq = new QueueJobModel();
         $ccb = 0;
         foreach ($bStrArr as $b2Str) {
             ++$ccb;
             if ($buildings != '') {
                 $buildings .= ',';
             }
             list($item_id, $level, $update_state) = explode(' ', $b2Str);
             if (!isset($GameMetadata['items'][$item_id]['for_tribe_id'][$fromVillageRow['tribe_id']])) {
                 while (0 < $level--) {
                     $mq->upgradeBuilding($toVillageRow['id'], $ccb, $item_id, TRUE);
                 }
                 $item_id = $level = $update_state = 0;
             }
             $buildings .= $item_id . ' ' . $level . ' ' . $update_state;
         }
     }
     $this->provider->executeQuery('UPDATE p_villages v
             SET
                 v.parent_id=%s,
                 v.tribe_id=%s,
                 v.player_id=%s,
                 v.alliance_id=%s,
                 v.player_name=\'%s\',
                 v.alliance_name=\'%s\',
                 v.is_capital=0,
                 v.buildings=\'%s\',
                 v.troops_training=\'%s\',
                 v.troops_num=\'%s\',
                 v.child_villages_id=NULL,
                 v.allegiance_percent=100,
                 v.troops_out_num=NULL,
                 v.troops_out_intrap_num=NULL,
                 v.creation_date=NOW(),
                 v.last_update_date=NOW()
             WHERE v.id=%s', array(intval($fromVillageRow['id']), intval($fromVillageRow['tribe_id']), intval($fromVillageRow['player_id']), intval($fromVillageRow['alliance_id']) > 0 ? intval($fromVillageRow['alliance_id']) : 'NULL', $fromVillageRow['player_name'], $fromVillageRow['alliance_name'], $buildings, $troops_training, $troops_num, intval($toVillageRow['id'])));
     $this->provider->executeQuery('UPDATE p_villages v
             SET
                 v.tribe_id=%s,
                 v.player_id=%s,
                 v.alliance_id=%s,
                 v.player_name=\'%s\',
                 v.alliance_name=\'%s\',
                 v.troops_num=NULL,
                 v.troops_out_num=NULL,
                 v.troops_out_intrap_num=NULL
             WHERE v.parent_id=%s AND v.is_oasis=1', array(intval($fromVillageRow['tribe_id']), intval($fromVillageRow['player_id']), intval($fromVillageRow['alliance_id']) > 0 ? intval($fromVillageRow['alliance_id']) : 'NULL', $fromVillageRow['player_name'], $fromVillageRow['alliance_name'], intval($toVillageRow['id'])));
     $child_villages_id = trim($fromVillageRow['child_villages_id']);
     if ($child_villages_id != '') {
         $child_villages_id .= ',';
     }
     $child_villages_id .= $toVillageRow['id'];
     $this->provider->executeQuery('UPDATE p_villages v
             SET
                 v.crop_consumption=v.crop_consumption-%s,
                 v.child_villages_id=\'%s\'
             WHERE v.id=%s', array($kingCropConumption, $child_villages_id, intval($fromVillageRow['id'])));
     $prow = $this->provider->fetchRow('SELECT p.villages_id, p.villages_data FROM p_players p WHERE p.id=%s', array(intval($fromVillageRow['player_id'])));
     $villages_id = trim($prow['villages_id']);
     if ($villages_id != '') {
         $villages_id .= ',';
     }
     $villages_id .= $toVillageRow['id'];
     $villages_data = trim($prow['villages_data']);
     if ($villages_data != '') {
         $villages_data .= "\n";
     }
     $villages_data .= $toVillageRow['id'] . ' ' . $toVillageRow['rel_x'] . ' ' . $toVillageRow['rel_y'] . ' ' . $toVillageRow['village_name'];
     $toCheckPeople = $this->provider->fetchScalar('SELECT v.people_count FROM p_villages v WHERE v.id=%s', array(intval($toVillageRow['id'])));
     $this->provider->executeQuery('UPDATE p_players p
             SET
                 p.total_people_count=p.total_people_count+%s,
                 p.villages_count=p.villages_count+1,
                 p.selected_village_id=%s,
                 p.villages_id=\'%s\',
                 p.villages_data=\'%s\'
             WHERE
                 p.id=%s', array(intval($toCheckPeople), intval($toVillageRow['id']), $villages_id, $villages_data, intval($fromVillageRow['player_id'])));
 }
Ejemplo n.º 6
0
 public function captureVillage($toVillageRow, $fromVillageRow, $kingCropConumption)
 {
     $GameMetadata = $GLOBALS['GameMetadata'];
     $SetupMetadata = $GLOBALS['SetupMetadata'];
     $this->provider->executeQuery("DELETE FROM p_queue WHERE player_id=%s AND village_id=%s AND proc_type IN (%s)", array(intval($toVillageRow['player_id']), intval($toVillageRow['id']), QS_BUILD_CREATEUPGRADE . "," . QS_BUILD_DROP . "," . QS_TROOP_RESEARCH . "," . QS_TROOP_UPGRADE_ATTACK . "," . QS_TROOP_UPGRADE_DEFENSE . "," . QS_TROOP_TRAINING . "," . QS_TROOP_TRAINING_HERO . "," . QS_WAR_REINFORCE . "," . QS_WAR_ATTACK . "," . QS_WAR_ATTACK_PLUNDER . "," . QS_WAR_ATTACK_SPY . "," . QS_CREATEVILLAGE));
     $troops_training = "";
     $troops_num = "";
     foreach ($GameMetadata['troops'] as $k => $v) {
         if ($v['for_tribe_id'] == 0 - 1 || $v['for_tribe_id'] == $fromVillageRow['tribe_id']) {
             if ($troops_training != "") {
                 $troops_training .= ",";
             }
             $researching_done = $v['research_time_consume'] == 0 ? 1 : 0;
             $troops_training .= $k . " " . $researching_done . " 0 0";
             if ($troops_num != "") {
                 $troops_num .= ",";
             }
             $troops_num .= $k . " 0";
         }
     }
     $troops_num = "-1:" . $troops_num;
     $buildings = "";
     $bStr = trim($toVillageRow['buildings']);
     if ($bStr != "") {
         $bStrArr = explode(",", $bStr);
         $mq = new QueueJobModel();
         $ccb = 0;
         foreach ($bStrArr as $b2Str) {
             ++$ccb;
             if ($buildings != "") {
                 $buildings .= ",";
             }
             $update_state = explode(" ", $b2Str);
             $level = explode(" ", $b2Str);
             $item_id = explode(" ", $b2Str);
             list($item_id, $level, $update_state) = $item_id;
             if (!isset($GameMetadata['items'][$item_id]['for_tribe_id'][$fromVillageRow['tribe_id']])) {
                 while (0 < $level--) {
                     $mq->upgradeBuilding($toVillageRow['id'], $ccb, $item_id, TRUE);
                 }
                 $item_id = $level = $update_state = 0;
             }
             $buildings .= $item_id . " " . $level . " " . $update_state;
         }
     }
     $this->provider->executeQuery("UPDATE p_villages v\r\n\t\t\tSET\r\n\t\t\t\tv.parent_id=%s,\r\n\t\t\t\tv.tribe_id=%s,\r\n\t\t\t\tv.player_id=%s,\r\n\t\t\t\tv.alliance_id=%s,\r\n\t\t\t\tv.player_name='%s',\r\n\t\t\t\tv.alliance_name='%s',\r\n\t\t\t\tv.is_capital=0,\r\n\t\t\t\tv.buildings='%s',\r\n\t\t\t\tv.troops_training='%s',\r\n\t\t\t\tv.troops_num='%s',\r\n\t\t\t\tv.child_villages_id=NULL,\r\n\t\t\t\tv.allegiance_percent=100,\r\n\t\t\t\tv.troops_out_num=NULL,\r\n\t\t\t\tv.troops_out_intrap_num=NULL,\r\n\t\t\t\tv.creation_date=NOW(),\r\n\t\t\t\tv.last_update_date=NOW()\r\n\t\t\tWHERE v.id=%s", array(intval($fromVillageRow['id']), intval($fromVillageRow['tribe_id']), intval($fromVillageRow['player_id']), 0 < intval($fromVillageRow['alliance_id']) ? intval($fromVillageRow['alliance_id']) : "NULL", $fromVillageRow['player_name'], $fromVillageRow['alliance_name'], $buildings, $troops_training, $troops_num, intval($toVillageRow['id'])));
     $this->provider->executeQuery("UPDATE p_villages v\r\n\t\t\tSET\r\n\t\t\t\tv.tribe_id=%s,\r\n\t\t\t\tv.player_id=%s,\r\n\t\t\t\tv.alliance_id=%s,\r\n\t\t\t\tv.player_name='%s',\r\n\t\t\t\tv.alliance_name='%s',\r\n\t\t\t\tv.troops_num=NULL,\r\n\t\t\t\tv.troops_out_num=NULL,\r\n\t\t\t\tv.troops_out_intrap_num=NULL\r\n\t\t\tWHERE v.parent_id=%s AND v.is_oasis=1", array(intval($fromVillageRow['tribe_id']), intval($fromVillageRow['player_id']), 0 < intval($fromVillageRow['alliance_id']) ? intval($fromVillageRow['alliance_id']) : "NULL", $fromVillageRow['player_name'], $fromVillageRow['alliance_name'], intval($toVillageRow['id'])));
     $child_villages_id = trim($fromVillageRow['child_villages_id']);
     if ($child_villages_id != "") {
         $child_villages_id .= ",";
     }
     $child_villages_id .= $toVillageRow['id'];
     $this->provider->executeQuery("UPDATE p_villages v\r\n\t\t\tSET\r\n\t\t\t\tv.crop_consumption=v.crop_consumption-%s,\r\n\t\t\t\tv.child_villages_id='%s'\r\n\t\t\tWHERE v.id=%s", array($kingCropConumption, $child_villages_id, intval($fromVillageRow['id'])));
     $prow = $this->provider->fetchRow("SELECT p.villages_id, p.villages_data FROM p_players p WHERE p.id=%s", array(intval($fromVillageRow['player_id'])));
     $villages_id = trim($prow['villages_id']);
     if ($villages_id != "") {
         $villages_id .= ",";
     }
     $villages_id .= $toVillageRow['id'];
     $villages_data = trim($prow['villages_data']);
     if ($villages_data != "") {
         $villages_data .= "\n";
     }
     $villages_data .= $toVillageRow['id'] . " " . $toVillageRow['rel_x'] . " " . $toVillageRow['rel_y'] . " " . $toVillageRow['village_name'];
     $this->provider->executeQuery("UPDATE p_players p\r\n\t\t\tSET\r\n\t\t\t\tp.total_people_count=p.total_people_count+%s,\r\n\t\t\t\tp.villages_count=p.villages_count+1,\r\n\t\t\t\tp.selected_village_id=%s,\r\n\t\t\t\tp.villages_id='%s',\r\n\t\t\t\tp.villages_data='%s'\r\n\t\t\tWHERE\r\n\t\t\t\tp.id=%s", array(intval($toVillageRow['people_count']), intval($toVillageRow['id']), $villages_id, $villages_data, intval($fromVillageRow['player_id'])));
 }