function resetWorld($getPage_connection3) { if ($_SESSION["admin"] == 1) { if (strlen($_SESSION["action"]) >= 1) { if ($_SESSION["action"] == "reset_world") { if ($stmt = $getPage_connection3->prepare("TRUNCATE TABLE agreements")) { $stmt->execute(); $stmt->close(); } else { } // else if ($stmt = $getPage_connection3->prepare("TRUNCATE TABLE claims")) { $stmt->execute(); $stmt->close(); } else { } // else if ($stmt = $getPage_connection3->prepare("TRUNCATE TABLE combatlog")) { $stmt->execute(); $stmt->close(); } else { } // else if ($stmt = $getPage_connection3->prepare("TRUNCATE TABLE continents")) { $stmt->execute(); $stmt->close(); } else { } // else if ($stmt = $getPage_connection3->prepare("TRUNCATE TABLE improvementsmap")) { $stmt->execute(); $stmt->close(); } else { } // else if ($stmt = $getPage_connection3->prepare("TRUNCATE TABLE nations")) { $stmt->execute(); $stmt->close(); } else { } // else if ($stmt = $getPage_connection3->prepare("TRUNCATE TABLE offers")) { $stmt->execute(); $stmt->close(); } else { } // else if ($stmt = $getPage_connection3->prepare("TRUNCATE TABLE organizations")) { $stmt->execute(); $stmt->close(); } else { } // else if ($stmt = $getPage_connection3->prepare("TRUNCATE TABLE production")) { $stmt->execute(); $stmt->close(); } else { } // else if ($stmt = $getPage_connection3->prepare("TRUNCATE TABLE rankings")) { $stmt->execute(); $stmt->close(); } else { } // else if ($stmt = $getPage_connection3->prepare("TRUNCATE TABLE resourcesmap")) { $stmt->execute(); $stmt->close(); } else { } // else if ($stmt = $getPage_connection3->prepare("TRUNCATE TABLE tilesmap")) { $stmt->execute(); $stmt->close(); } else { } // else if ($stmt = $getPage_connection3->prepare("TRUNCATE TABLE trade")) { $stmt->execute(); $stmt->close(); } else { } // else if ($stmt = $getPage_connection3->prepare("TRUNCATE TABLE transport")) { $stmt->execute(); $stmt->close(); } else { } // else if ($stmt = $getPage_connection3->prepare("TRUNCATE TABLE unitsmap")) { $stmt->execute(); $stmt->close(); } else { } // else if ($stmt = $getPage_connection3->prepare("TRUNCATE TABLE users")) { $stmt->execute(); $stmt->close(); } else { } // else if ($stmt = $getPage_connection3->prepare("TRUNCATE TABLE mapmemory")) { $stmt->execute(); $stmt->close(); } else { } // else if ($stmt = $getPage_connection3->prepare("SELECT id FROM market ORDER BY id ASC")) { $stmt->execute(); $stmt->store_result(); $stmt->bind_result($r_id); while ($stmt->fetch()) { $next_markets = $r_id; $marketInfo1 = getMarketInfo($getPage_connection3, $next_markets); setMarketInfo($getPage_connection3, $next_markets, $marketInfo1["name"], 100); } // while $stmt->close(); } else { } // else resetSession(false); // Create Admin Account, starter continent $new_salt = ""; $new_username = "******"; $new_avatar = "images/users/avatar.png"; $allowed_chars = 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789./'; $chars_length = 63; for ($i = 0; $i < 51; $i++) { $new_salt .= $allowed_chars[mt_rand(0, $chars_length)]; } // for $new_date = date("Y-m-d H:i:s"); $new_token = mt_rand(1000, 9999); $new_thread = mt_rand(100, 999); $final_salt = '$2y$09$' . $new_salt . '$'; $created_password = crypt("qwertyuiop" . $new_salt, $final_salt); addUserInfo($getPage_connection3, $new_username, $new_avatar, $new_date, $new_date, $created_password, $new_salt, $new_token, $new_thread, 1); $new_userid = $getPage_connection3->insert_id; $new_name = "Administrator"; $new_formal = "Administrator"; addProductionInfo($getPage_connection3, $new_userid, 100, array(0 => 2, 1 => 2, 2 => 2, 3 => 2, 4 => 2, 5 => 2, 6 => 2, 7 => 2), array(0 => 2, 1 => 2, 2 => 2, 3 => 2, 4 => 2, 5 => 2, 6 => 2, 7 => 2)); addRankingInfo($getPage_connection3, $new_userid, 999, 999, 999, 999, 999); $new_routes = array(0 => 0); $new_worth = array(0 => 0); $new_offers = array(0 => 0); addTradeInfo($getPage_connection3, $new_userid, $new_routes, 0); $capitalBuilt = false; $availableTiles = array(0 => 0, 1 => 0, 2 => 0, 3 => 0, 4 => 0); $finalTiles = array(0 => 0, 1 => 0); $availableContinent = 0; if ($stmt = $getPage_connection3->prepare("SELECT id FROM continents ORDER BY id ASC")) { $stmt->execute(); $stmt->store_result(); $stmt->bind_result($r_id); while ($stmt->fetch()) { $next_continents = $r_id; $availableTiles = array(0 => 0, 1 => 0, 2 => 0, 3 => 0, 4 => 0); $next_tiles = 1; $counter1 = 0; if ($stmt2 = $getPage_connection3->prepare("SELECT id FROM tilesmap ORDER BY id ASC")) { $stmt2->execute(); $stmt2->store_result(); $stmt2->bind_result($r_id1); while ($stmt2->fetch()) { $next_tiles = $r_id1; $tileInfoD = getTileInfoByID($getPage_connection3, $next_tiles); if ($tileInfoD["continent"] == $next_continents && $tileInfoD["owner"] == 0 && $tileInfoD["terrain"] != 2) { $tileInfoDWest = getTileInfo($getPage_connection3, $tileInfoD["continent"], $tileInfoD["xpos"] - 1, $tileInfoD["ypos"]); $tileInfoDNorthWest = getTileInfo($getPage_connection3, $tileInfoD["continent"], $tileInfoD["xpos"] - 1, $tileInfoD["ypos"] - 1); $tileInfoDNorth = getTileInfo($getPage_connection3, $tileInfoD["continent"], $tileInfoD["xpos"] - 1, $tileInfoD["ypos"] - 1); $tileInfoDNorthEast = getTileInfo($getPage_connection3, $tileInfoD["continent"], $tileInfoD["xpos"] + 1, $tileInfoD["ypos"] - 1); $tileInfoDEast = getTileInfo($getPage_connection3, $tileInfoD["continent"], $tileInfoD["xpos"] + 1, $tileInfoD["ypos"]); $tileInfoDSouthEast = getTileInfo($getPage_connection3, $tileInfoD["continent"], $tileInfoD["xpos"] + 1, $tileInfoD["ypos"] + 1); $tileInfoDSouth = getTileInfo($getPage_connection3, $tileInfoD["continent"], $tileInfoD["xpos"], $tileInfoD["ypos"] + 1); $tileInfoDSouthWest = getTileInfo($getPage_connection3, $tileInfoD["continent"], $tileInfoD["xpos"] - 1, $tileInfoD["ypos"] + 1); if ($tileInfoDWest["continent"] == $next_continents && $tileInfoDWest["owner"] == 0 && $tileInfoDWest["terrain"] != 2 || $tileInfoDNorthWest["continent"] == $next_continents && $tileInfoDNorthWest["owner"] == 0 && $tileInfoDNorthWest["terrain"] != 2 || $tileInfoDNorth["continent"] == $next_continents && $tileInfoDNorth["owner"] == 0 && $tileInfoDNorth["terrain"] != 2 || $tileInfoDNorthEast["continent"] == $next_continents && $tileInfoDNorthEast["owner"] == 0 && $tileInfoDNorthEast["terrain"] != 2 || $tileInfoDEast["continent"] == $next_continents && $tileInfoDEast["owner"] == 0 && $tileInfoDEast["terrain"] != 2 || $tileInfoDSouthEast["continent"] == $next_continents && $tileInfoDSouthEast["owner"] == 0 && $tileInfoDSouthEast["terrain"] != 2 || $tileInfoDSouth["continent"] == $next_continents && $tileInfoDSouth["owner"] == 0 && $tileInfoDSouth["terrain"] != 2 || $tileInfoDSouthWest["continent"] == $next_continents && $tileInfoDSouthWest["owner"] == 0 && $tileInfoDSouthWest["terrain"] != 2) { $availableTiles[$counter1] = $tileInfoD["id"]; $counter1++; } // if } // if if ($counter1 == 4) { $availableContinent = $next_continents; } // if } // while $stmt2->close(); } else { } // else if ($counter1 == 4) { break; } // if } // while $stmt->close(); } else { $next_continents = 0; } // else // get available tiles from newly created continent if no continent is available if ($availableContinent < 1) { $continent1 = generateContinent($getPage_connection3); $next_continents = $continent1; $availableContinent = $next_continents; $availableTiles = array(0 => 0, 1 => 0, 2 => 0, 3 => 0, 4 => 0); $counter1 = 0; if ($stmt = $getPage_connection3->prepare("SELECT id FROM tilesmap ORDER BY id ASC")) { $stmt->execute(); $stmt->store_result(); $stmt->bind_result($r_result); while ($stmt->fetch()) { $next_tiles = $r_result; $tileInfoD = getTileInfoByID($getPage_connection3, $next_tiles); if ($tileInfoD["continent"] == $next_continents && $tileInfoD["owner"] == 0 && ($tileInfoD["terrain"] != 2 && $tileInfoD["terrain"] != 3)) { $tileInfoDWest = getTileInfo($getPage_connection3, $tileInfoD["continent"], $tileInfoD["xpos"] - 1, $tileInfoD["ypos"]); $tileInfoDNorthWest = getTileInfo($getPage_connection3, $tileInfoD["continent"], $tileInfoD["xpos"] - 1, $tileInfoD["ypos"] - 1); $tileInfoDNorth = getTileInfo($getPage_connection3, $tileInfoD["continent"], $tileInfoD["xpos"] - 1, $tileInfoD["ypos"] - 1); $tileInfoDNorthEast = getTileInfo($getPage_connection3, $tileInfoD["continent"], $tileInfoD["xpos"] + 1, $tileInfoD["ypos"] - 1); $tileInfoDEast = getTileInfo($getPage_connection3, $tileInfoD["continent"], $tileInfoD["xpos"] + 1, $tileInfoD["ypos"]); $tileInfoDSouthEast = getTileInfo($getPage_connection3, $tileInfoD["continent"], $tileInfoD["xpos"] + 1, $tileInfoD["ypos"] + 1); $tileInfoDSouth = getTileInfo($getPage_connection3, $tileInfoD["continent"], $tileInfoD["xpos"], $tileInfoD["ypos"] + 1); $tileInfoDSouthWest = getTileInfo($getPage_connection3, $tileInfoD["continent"], $tileInfoD["xpos"] - 1, $tileInfoD["ypos"] + 1); if ($tileInfoDWest["continent"] == $next_continents && $tileInfoDWest["owner"] == 0 && ($tileInfoDWest["terrain"] != 2 && $tileInfoDWest["terrain"] != 3) || $tileInfoDNorthWest["continent"] == $next_continents && $tileInfoDNorthWest["owner"] == 0 && ($tileInfoDNorthWest["terrain"] != 2 && $tileInfoDNorthWest["terrain"] != 3) || $tileInfoDNorth["continent"] == $next_continents && $tileInfoDNorth["owner"] == 0 && ($tileInfoDNorth["terrain"] != 2 && $tileInfoDNorth["terrain"] != 3) || $tileInfoDNorthEast["continent"] == $next_continents && $tileInfoDNorthEast["owner"] == 0 && ($tileInfoDNorthEast["terrain"] != 2 && $tileInfoDNorthEast["terrain"] != 3) || $tileInfoDEast["continent"] == $next_continents && $tileInfoDEast["owner"] == 0 && ($tileInfoDEast["terrain"] != 2 && $tileInfoDEast["terrain"] != 3) || $tileInfoDSouthEast["continent"] == $next_continents && $tileInfoDSouthEast["owner"] == 0 && ($tileInfoDSouthEast["terrain"] != 2 && $tileInfoDSouthEast["terrain"] != 3) || $tileInfoDSouth["continent"] == $next_continents && $tileInfoDSouth["owner"] == 0 && ($tileInfoDSouth["terrain"] != 2 && $tileInfoDSouth["terrain"] != 3) || $tileInfoDSouthWest["continent"] == $next_continents && $tileInfoDSouthWest["owner"] == 0 && ($tileInfoDSouthWest["terrain"] != 2 && $tileInfoDSouthWest["terrain"] != 3)) { $availableTiles[$counter1] = $tileInfoD["id"]; $counter1++; } // if } // if } // while $stmt->close(); } else { } // else } // if $sameTile = true; $randTiles = array(0 => 0, 1 => 0); while ($sameTile === true) { $randTiles[0] = mt_rand(1, count($availableTiles) - 2); $randDirection = mt_rand(1, 2); if ($randDirection == 1) { $randTiles[1] = $randTiles[0] - 1; } else { if ($randDirection == 2) { $randTiles[1] = $randTiles[0] + 1; } } // else if if ($randTiles[0] == $randTiles[1]) { $sameTile = true; } else { $sameTile = false; } // else } // while $finalTiles[0] = $availableTiles[$randTiles[0]]; $finalTiles[1] = $availableTiles[$randTiles[1]]; $claims = array(0 => 0); for ($c = 0; $c < 3; $c++) { if (isset($finalTiles[$c])) { if ($finalTiles[$c] > 0) { addClaimInfo($getPage_connection3, 10, $new_userid, $finalTiles[$c]); } // if } // if } // for for ($j = 0; $j < 3; $j++) { if (isset($finalTiles[$j])) { if ($finalTiles[$j] > 0) { $tileInfo2 = getTileInfoByID($getPage_connection3, $finalTiles[$j]); setTileInfo($getPage_connection3, $tileInfo2["id"], $tileInfo2["continent"], $tileInfo2["xpos"], $tileInfo2["ypos"], $tileInfo2["terrain"], $tileInfo2["resources"], $tileInfo2["improvements"], $new_userid, $tileInfo2["claims"], $tileInfo2["population"]); if ($capitalBuilt === false) { addImprovementInfo($getPage_connection3, $tileInfo2["continent"], $tileInfo2["xpos"], $tileInfo2["ypos"], 1, 1, array(0 => 0), array(0 => $new_userid), "Capital City"); // add capital addImprovementInfo($getPage_connection3, $tileInfo2["continent"], $tileInfo2["xpos"], $tileInfo2["ypos"], 4, 1, array(0 => 0), array(0 => $new_userid), "First Farm"); // add farm $capitalBuilt = true; } // if } // if } // if } // for addNationInfo($getPage_connection3, $new_userid, $new_name, $availableContinent, $new_formal, "", 12, 5000, 0, 3, 2500, 5, 0, 5, 0, array(0 => 0), array(0 => 0), array(0 => 5, 1 => 0, 2 => 0, 3 => 5, 4 => 2, 5 => 5, 6 => 0, 7 => 5), array(0 => 5, 1 => 5, 2 => 5, 3 => 5), 2000, 0); // go through y positions for ($y = 1; $y < 21; $y++) { // go through x positions for ($x = 1; $x < 21; $x++) { $mapContentString = ""; $mapContentToken = 0; for ($qw = 0; $qw < 5; $qw++) { if ($qw == 0) { $_SESSION["overlay"] = "terrain"; } else { if ($qw == 1) { $_SESSION["overlay"] = "control"; } else { if ($qw == 2) { $_SESSION["overlay"] = "claims"; } else { if ($qw == 3) { $_SESSION["overlay"] = "units"; } else { if ($qw == 4) { $_SESSION["overlay"] = "nations"; } } } } } // else if $mapContent_generated = array("", 0); $mapContent_generated = generateMapTile($getPage_connection3, $availableContinent, $x, $y); $mapContentString = $mapContent_generated[0]; $mapContentToken = $mapContent_generated[1]; $_SESSION["terrainMapContentsTokens"] = array(0); $_SESSION["terrainMapContents"] = array(0); $_SESSION["controlMapContentsTokens"] = array(0); $_SESSION["controlMapContents"] = array(0); $_SESSION["claimsMapContentsTokens"] = array(0); $_SESSION["claimsMapContents"] = array(0); $_SESSION["unitsMapContentsTokens"] = array(0); $_SESSION["unitsMapContents"] = array(0); $_SESSION["nationsMapContentsTokens"] = array(0); $_SESSION["nationsMapContents"] = array(0); if ($_SESSION["overlay"] == "terrain") { $_SESSION["terrainMapContentsTokens"][$y][$x] = $mapContentToken; $_SESSION["terrainMapContents"][$y][$x] = $mapContentString; } else { if ($_SESSION["overlay"] == "control") { $_SESSION["controlMapContentsTokens"][$y][$x] = $mapContentToken; $_SESSION["controlMapContents"][$y][$x] = $mapContentString; } else { if ($_SESSION["overlay"] == "claims") { $_SESSION["claimsMapContentsTokens"][$y][$x] = $mapContentToken; $_SESSION["claimsMapContents"][$y][$x] = $mapContentString; } else { if ($_SESSION["overlay"] == "units") { $_SESSION["unitsMapContentsTokens"][$y][$x] = $mapContentToken; $_SESSION["unitsMapContents"][$y][$x] = $mapContentString; } else { if ($_SESSION["overlay"] == "nations") { $_SESSION["nationsMapContentsTokens"][$y][$x] = $mapContentToken; $_SESSION["nationsMapContents"][$y][$x] = $mapContentString; } else { $_SESSION["nationsMapContentsTokens"][$y][$x] = $mapContentToken; $_SESSION["nationsMapContents"][$y][$x] = $mapContentString; } } } } } // else } // for } // for } // for addMapMemoryInfo($getPage_connection3, $new_userid, $_SESSION["terrainMapContents"], $_SESSION["controlMapContents"], $_SESSION["claimsMapContents"], $_SESSION["unitsMapContents"], $_SESSION["nationsMapContents"], $_SESSION["terrainMapContentsTokens"], $_SESSION["controlMapContentsTokens"], $_SESSION["claimsMapContentsTokens"], $_SESSION["unitsMapContentsTokens"], $_SESSION["nationsMapContentsTokens"]); // $_SESSION["success_message"] = "World has been reset successfully!"; } else { $_SESSION["warning_message"] = "Cannot complete action: action is not valid."; } // else } else { $_SESSION["warning_message"] = "Cannot complete action: action is not valid."; } // else } else { $_SESSION["warning_message"] = "Cannot complete action: not valid admin."; } // else }
function securities_user_main() { global $fromDate, $toDate, $tmpFromDate, $tmpToDate, $maxTradingDate, $urlParam; $data['from_date'] = $fromDate; $data['to_date'] = $toDate; $data['url_param'] = $urlParam; $seId = 1; //{ Xu ly khung info $data['se'] = 'hose'; //{{Cau hinh rieng cho san HOSE if (!empty($_GET['seid']) && $_GET['seid'] == 2) { $data['se'] = 'hase'; $seId = $_GET['seid']; } //}} //} $view = 0; if (!empty($_GET['view'])) { $view = $_GET['view']; } $data['view'] = $view; //Khac giao dich trai phieu //{ Xu ly khung du lieu $data['type'] = '.'; $symbol = ''; $validSymbol = false; if (!empty($_GET['symbol'])) { $symbol = $_GET['symbol']; if ($view != 3) { $data['type'] = '.filter.'; $data['se'] = 'company'; } $data['url_param'] .= '&symbol=' . $symbol; $db1 = _db('stockbiz'); $db1->query('SELECT c.Symbol, c.CompanyName, i.Name AS IndustryName,Bourse, i.IndustryId FROM _prefix_companyinfo c, _prefix_industry i WHERE i.IndustryId = c.IndustryID AND Symbol="' . $symbol . '"'); if ($info = $db1->fetch()) { $data['info'] = $info; if ($info['Bourse'] == 'HOSE') { $seId = 1; } else { $seId = 2; } $validSymbol = true; $data['symbol'] = $symbol; } } $data['seid'] = $seId; if ($seId == 1) { require 'hose.php'; } else { require 'hase.php'; } switch ($view) { case 0: //Khong co loc if ($symbol == '') { if ($seId == 1) { $data['hose_current_security'] = get_hcm_security($toDate); } else { $data['hase_current_security'] = get_hn_security($toDate); } //Co loc } else { if ($validSymbol) { $data['current_security'] = get_hcm_security_filter($symbol, $fromDate, $toDate, $seId); } } break; case 1: if ($seId == 1) { $data['put_through'] = get_hcm_putthrough($symbol, $fromDate, $toDate); $data['put_through_info'] = getPutExecInfo_sum($symbol, $fromDate, $toDate); } else { if ($symbol == '') { $data['put_through'] = get_hn_putthrough($toDate, $data['put_through_qty'], $data['put_through_val']); } } break; case 2: $result_per_page = 20; $data['fi_sum'] = getForeignInvestment_sum($symbol, $fromDate, $toDate, $seId); $data['fi_top5bvol'] = getTopFI5BVol($fromDate, $toDate, $seId); $data['fi_top5bval'] = getTopFI5BVal($fromDate, $toDate, $seId); $data['fi_top5svol'] = getTopFI5SVol($fromDate, $toDate, $seId); $data['fi_top5sval'] = getTopFI5SVal($fromDate, $toDate, $seId); $data['fi'] = getForeignInvestment($symbol, $fromDate, $toDate, $seId); $paging = new Paging('p', $result_per_page, 0, _display_page()); $paging->sCurrentPageClass = 'current'; $paging->sPageNextClass = 'next'; $paging->sPostfix = '#detail'; $paging->nTotalRow = count($data['fi']); $data['fi_offset'] = $paging->getResultRowStart(); $data['fi_total'] = $data['fi_offset'] + $result_per_page; $data['fi_paging'] = $paging; /*if ($seId == 1) $data[] = ''; else $data[] = '';*/ break; case 3: //Su dung ham trong hose if ($seId == 2) { require 'hose.php'; } $data['bond'] = get_hcm_putthrough($symbol, $fromDate, $toDate, 1); $data['bond_info'] = getPutExecInfo_sum($symbol, $fromDate, $toDate, 1); $data['se'] = 'hose'; return $data; break; case 4: break; } if ($symbol == '') { $data['maxtradingdate'] = $toDate; getMarketInfo($toDate, $seId, $data); $data['chart_startdate'] = date("Y-m-d", mktime(0, 0, 0, date("m", strtotime($toDate)) - 6, date("d", strtotime($toDate)), date("Y", strtotime($toDate)))); $data['chart_today'] = $toDate; } return $data; }
function showTradeInfo($getPage_connection2) { $nationInfo = getNationInfo($getPage_connection2, $_SESSION["nation_id"]); $tradeInfo = getTradeInfo($getPage_connection2, $_SESSION["nation_id"]); $authorityReport = getAuthorityReport($nationInfo["authority"]); $economyReport = getEconomyReport($nationInfo["economy"]); echo " <div class=\"spacing-from-menu well well-lg standard-text\">\n"; echo " <div class=\"panel panel-info\">\n"; echo " <div data-toggle=\"tooltip\" data-placement=\"bottom\" title=\"View and reply to pending trade agreements.\" class=\"panel-heading\">\n"; echo " <h3 class=\"panel-title\">Pending Agreements <button type=\"button\" class=\"btn btn-default btn-md collapsed\" data-toggle=\"collapse\" data-target=\"#collapsePendingAgreements\"><span class=\"glyphicon glyphicon-plus\"></span>/<span class=\"glyphicon glyphicon-minus\"></span></button></h3>\n"; echo " </div>\n"; echo " <div id=\"collapsePendingAgreements\" class=\"panel-body collapse in\">\n"; echo " <div class=\"col-md-8 col-center\">\n"; $agreementsExist = false; if ($stmt = $getPage_connection2->prepare("SELECT id FROM agreements ORDER BY id ASC")) { $stmt->execute(); $stmt->store_result(); $stmt->bind_result($r_result); while ($stmt->fetch()) { $next_agreements = $r_result; $agreementInfo1 = getAgreementInfo($getPage_connection2, $next_agreements); if (($agreementInfo1["toNation"] == $_SESSION["nation_id"] || $agreementInfo1["fromNation"] == $_SESSION["nation_id"]) && $agreementInfo1["status"] == 0) { $agreementsExist = true; $toNationInfo = getNationInfo($getPage_connection2, $agreementInfo1["toNation"]); $fromNationInfo = getNationInfo($getPage_connection2, $agreementInfo1["fromNation"]); echo " To: <a href=\"index.php?page=info&section=nations&info_id=" . $toNationInfo["id"] . "\">" . $toNationInfo["name"] . "</a>, From: <a href=\"index.php?page=info&section=nations&info_id=" . $fromNationInfo["id"] . "\">" . $fromNationInfo["name"] . "</a>\n <br />\n"; echo " Agreement Policy: " . $agreementInfo1["policy"] . "\n <br />\n"; echo " " . $agreementInfo1["turns"] . " turns \n"; echo " <br />\n"; echo " <form action=\"index.php?page=trade#collapsePendingAgreements\" method=\"post\">\n"; echo " <div class=\"form-group form-group-xs\">\n"; echo " <input type=\"hidden\" name=\"page\" value=\"trade\" />\n"; echo " <input type=\"hidden\" name=\"actionid\" value=\"" . $agreementInfo1["id"] . "\" />\n"; echo " <button onclick=\"loadButton(this)\" data-toggle=\"tooltip\" data-placement=\"bottom\" title=\"Accept trade agreement proposal.\" name=\"action\" value=\"accept_agreement\" id=\"accept_agreement-" . $agreementInfo1["id"] . "\" type=\"submit\" class=\"btn btn-sm btn-success\">Accept</button>\n"; echo " <button onclick=\"loadButton(this)\" data-toggle=\"tooltip\" data-placement=\"bottom\" title=\"Decline trade agreement proposal.\" name=\"action\" value=\"decline_agreement\" id=\"decline_agreement-" . $agreementInfo1["id"] . "\" type=\"submit\" class=\"btn btn-sm btn-danger\">Decline</button>\n"; echo " </div>\n"; echo " </form\">\n"; echo " ----\n <br />\n"; } // if } // while $stmt->close(); } else { } // else if ($agreementsExist === false) { echo " No agreements established.\n"; } // if echo " </div>\n"; echo " </div>\n"; echo " </div>\n"; echo " <div class=\"panel panel-info\">\n"; echo " <div data-toggle=\"tooltip\" data-placement=\"bottom\" title=\"View and reply to pending offers.\" class=\"panel-heading\">\n"; echo " <h3 class=\"panel-title\">Pending Offers <button type=\"button\" class=\"btn btn-default btn-md collapsed\" data-toggle=\"collapse\" data-target=\"#collapsePendingOffers\"><span class=\"glyphicon glyphicon-plus\"></span>/<span class=\"glyphicon glyphicon-minus\"></span></button></h3>\n"; echo " </div>\n"; echo " <div id=\"collapsePendingOffers\" class=\"panel-body collapse in\">\n"; echo " <div class=\"col-md-8 col-center\">\n"; $offersExist = false; if ($stmt = $getPage_connection2->prepare("SELECT id FROM offers ORDER BY id ASC")) { $stmt->execute(); $stmt->store_result(); $stmt->bind_result($r_result); while ($stmt->fetch()) { $next_offers = $r_result; $offerInfo1 = getOfferInfo($getPage_connection2, $next_offers); if ($offerInfo1["toNation"] == $_SESSION["nation_id"] && $offerInfo1["status"] == 0) { if ($offerInfo1["givingItems"][0] > 0 || $offerInfo1["receivingItems"][0] > 0) { $offersExist = true; $toNationInfo = getNationInfo($getPage_connection2, $offerInfo1["toNation"]); $fromNationInfo = getNationInfo($getPage_connection2, $offerInfo1["fromNation"]); echo " To: <a href=\"index.php?page=info&section=nations&info_id=" . $toNationInfo["id"] . "\">" . $toNationInfo["name"] . "</a>, From: <a href=\"index.php?page=info&section=nations&info_id=" . $fromNationInfo["id"] . "\">" . $fromNationInfo["name"] . "</a>\n <br />\n"; if ($offerInfo1["givingItems"][0] > 0) { echo " Giving:\n <br />\n"; for ($z = 0; $z < count($offerInfo1["givingItems"]); $z++) { if ($offerInfo1["givingQuantities"][$z] > 0) { if ($offerInfo1["givingTypes"][$z] == "goods") { $itemInfo1 = getGoodsInfo($getPage_connection2, $offerInfo1["givingItems"][$z]); $name1 = $itemInfo1["name"]; } else { if ($offerInfo1["givingTypes"][$z] == "resources") { $itemInfo1 = getResourceTypeInfo($getPage_connection2, $offerInfo1["givingItems"][$z]); $name1 = $itemInfo1["name"]; } else { $name1 = "money"; } } // else echo " " . $offerInfo1["givingQuantities"][$z] . " " . $name1 . "\n <br />\n"; } // if } // for } else { echo " Giving:\n <br />\n Nothing.\n"; } // else if ($offerInfo1["receivingItems"][0] > 0) { echo " Receiving:\n <br />\n"; for ($z = 0; $z < count($offerInfo1["receivingItems"]); $z++) { if ($offerInfo1["receivingQuantities"][$z] > 0) { if ($offerInfo1["receivingTypes"][$z] == "goods") { $itemInfo1 = getGoodsInfo($getPage_connection2, $offerInfo1["receivingItems"][$z]); $name1 = $itemInfo1["name"]; } else { if ($offerInfo1["receivingTypes"][$z] == "resources") { $itemInfo1 = getResourceTypeInfo($getPage_connection2, $offerInfo1["receivingItems"][$z]); $name1 = $itemInfo1["name"]; } else { $name1 = "money"; } } // else echo " " . $offerInfo1["receivingQuantities"][$z] . " " . $name1 . "\n <br />\n"; } // if } // for } else { echo " Receiving:\n <br />\n Nothing.\n <br />\n"; } // else echo " " . $offerInfo1["turns"] . " turns \n"; echo " <br />\n"; echo " <form action=\"index.php?page=trade#collapsePendingOffers\" method=\"post\">\n"; echo " <div class=\"form-group form-group-xs\">\n"; echo " <input type=\"hidden\" name=\"page\" value=\"trade\" />\n"; echo " <input type=\"hidden\" name=\"actionid\" value=\"" . $offerInfo1["id"] . "\" />\n"; echo " <button onclick=\"loadButton(this)\" data-toggle=\"tooltip\" data-placement=\"bottom\" title=\"Accept offer.\" name=\"action\" value=\"accept_offer\" id=\"accept_offer-" . $offerInfo1["id"] . "\" type=\"submit\" class=\"btn btn-sm btn-success\">Accept</button>\n"; echo " <button onclick=\"loadButton(this)\" data-toggle=\"tooltip\" data-placement=\"bottom\" title=\"Decline offer.\" name=\"action\" value=\"decline_offer\" id=\"decline_offer-" . $offerInfo1["id"] . "\" type=\"submit\" class=\"btn btn-sm btn-danger\">Decline</button>\n"; echo " </div>\n"; echo " </form\">\n"; echo " ----\n <br />\n"; } // if } // if } // while $stmt->close(); } else { } // else if ($offersExist === false) { echo " No offers established.\n"; } // if echo " </div>\n"; echo " </div>\n"; echo " </div>\n"; echo " <div class=\"panel panel-info\">\n"; echo " <div data-toggle=\"tooltip\" data-placement=\"bottom\" title=\"Create new trade agreement proposal.\" class=\"panel-heading\">\n"; echo " <h3 class=\"panel-title\">Make Trade Agreement <button type=\"button\" class=\"btn btn-default btn-md collapsed\" data-toggle=\"collapse\" data-target=\"#collapseMakeAgreement\"><span class=\"glyphicon glyphicon-plus\"></span>/<span class=\"glyphicon glyphicon-minus\"></span></button></h3>\n"; echo " </div>\n"; echo " <div id=\"collapseMakeAgreement\" class=\"panel-body collapse in\">\n"; echo " <div class=\"col-md-8 col-center\">\n"; if ($tradeInfo["limit"] > count($tradeInfo["routes"])) { echo " <form action=\"index.php?page=trade#collapseMakeAgreement\" method=\"post\">\n"; echo " <input type=\"hidden\" name=\"page\" value=\"trade\" />\n"; echo " <div class=\"form-group form-group-sm\">\n"; echo " <input data-toggle=\"tooltip\" data-placement=\"bottom\" title=\"Specify target nation.\" name=\"send_nation\" type=\"text\" class=\"form-control input-md\" id=\"send_nation\" placeholder=\"Name of Target Nation\" />\n"; echo " <br />\n"; echo " <label class=\"control-label\" for=\"slider-agreement\">Trade Policy:</label>\n"; echo " <input data-toggle=\"tooltip\" data-placement=\"bottom\" title=\"Specify trade agreement free trade policy arrangement. A lower number means less state intervention, and a higher number means more.\" name=\"agreement\" id=\"slider-agreement\" type=\"range\" min=\"1\" max=\"10\" step=\"1\" value=\"1\" />\n"; echo " <br />\n"; echo " <label class=\"control-label\" for=\"set_turns_agreement\">Turns:</label>\n"; echo " <input data-toggle=\"tooltip\" data-placement=\"bottom\" title=\"Specify the duration of the deal.\" type=\"text\" name=\"turns\" id=\"set_turns_agreement\" class=\"form-control input-sm\" value=\"1\" placeholder=\"e.g. 1\" />\n"; echo " <br />\n"; echo " <button onclick=\"loadButton(this)\" data-toggle=\"tooltip\" data-placement=\"bottom\" title=\"Send deal to nation for consideration.\" value=\"send_agreement\" name=\"action\" id=\"send_agreement\" type=\"submit\" class=\"btn btn-md btn-success info_button\">Send</button>\n"; echo " <button onclick=\"loadButton(this)\" data-toggle=\"tooltip\" data-placement=\"bottom\" title=\"Reset deal's contents to none.\" value=\"reset_agreement\" name=\"action\" id=\"reset_agreement\" type=\"submit\" class=\"btn btn-md btn-danger info_button\">Reset</button>\n"; echo " </div>\n"; echo " </form>\n"; } else { echo " You have no trade routes available.\n"; } // else echo " </div>\n"; echo " </div>\n"; echo " </div>\n"; echo " <div class=\"panel panel-info\">\n"; echo " <div data-toggle=\"tooltip\" data-placement=\"bottom\" title=\"Create new offer.\" class=\"panel-heading\">\n"; echo " <h3 class=\"panel-title\">Make Offer <button type=\"button\" class=\"btn btn-default btn-md collapsed\" data-toggle=\"collapse\" data-target=\"#collapseMakeOffer\"><span class=\"glyphicon glyphicon-plus\"></span>/<span class=\"glyphicon glyphicon-minus\"></span></button></h3>\n"; echo " </div>\n"; echo " <div id=\"collapseMakeOffer\" class=\"panel-body collapse in\">\n"; echo " <div class=\"col-md-8 col-center\">\n"; echo " <form action=\"index.php?page=trade#collapseMakeOffer\" method=\"post\">\n"; echo " <input type=\"hidden\" name=\"page\" value=\"trade\" />\n"; echo " <div class=\"form-group form-group-sm\">\n"; echo " <input data-toggle=\"tooltip\" data-placement=\"bottom\" title=\"Specify target nation.\" name=\"send_nation\" type=\"text\" class=\"form-control input-md\" id=\"send_nation\" placeholder=\"Name of Target Nation\" />\n"; echo " <div class=\"col-md-6\">\n"; echo " <label for=\"add_offer\">Add Offer</label>\n"; echo " <button onclick=\"loadButton(this)\" data-toggle=\"tooltip\" data-placement=\"bottom\" title=\"Add another offer (something the player's nation contributes).\" value=\"add_offer\" name=\"action\" id=\"add_offer\" type=\"submit\" class=\"btn btn-md btn-success\">Add</button>\n"; echo " <br />\n"; echo " <div id=\"offers\">\n"; for ($ff = 0; $ff <= count($_SESSION["offers"]); $ff++) { if ($ff < count($_SESSION["offers"])) { echo " <input type=\"hidden\" name=\"offers[" . $ff . "]\" value=\"1\" />\n"; echo " Offer <input data-toggle=\"tooltip\" data-placement=\"bottom\" title=\"Specify quantity of item.\" type=\"text\" name=\"offersQuantities[" . $ff . "]\" class=\"form-control input-sm\" placeholder=\"Quantity\" value=\"" . $_SESSION["offersQuantities"][$ff] . "\" />\n"; echo " <select data-toggle=\"tooltip\" data-placement=\"bottom\" title=\"Specify item.\" name=\"offersItems[" . $ff . "]\" class=\"form-control input-sm\">\n"; if ($stmt = $getPage_connection2->prepare("SELECT id FROM resources ORDER BY id ASC")) { $stmt->execute(); $stmt->store_result(); $stmt->bind_result($r_result); while ($stmt->fetch()) { $next_resources = $r_result; $resourceTypeInfo1 = getResourceTypeInfo($getPage_connection2, $next_resources); if ($_SESSION["offersItems"][$ff] == $resourceTypeInfo1["id"] && $_SESSION["offersTypes"][$ff] == "resources") { echo " <option selected value=\"resources." . strtolower($resourceTypeInfo1["name"]) . "\">" . $resourceTypeInfo1["name"] . "</option>\n"; } else { echo " <option value=\"resources." . strtolower($resourceTypeInfo1["name"]) . "\">" . $resourceTypeInfo1["name"] . "</option>\n"; } // else } // while $stmt->close(); } else { } // else if ($stmt = $getPage_connection2->prepare("SELECT id FROM goods ORDER BY id ASC")) { $stmt->execute(); $stmt->store_result(); $stmt->bind_result($r_result); while ($stmt->fetch()) { $next_goods = $r_result; $goodsInfo1 = getGoodsInfo($getPage_connection2, $next_goods); if ($_SESSION["offersItems"][$ff] == $goodsInfo1["id"] && $_SESSION["offersTypes"][$ff] == "goods") { echo " <option selected value=\"goods." . strtolower($goodsInfo1["name"]) . "\">" . $goodsInfo1["name"] . "</option>\n"; } else { echo " <option value=\"goods." . strtolower($goodsInfo1["name"]) . "\">" . $goodsInfo1["name"] . "</option>\n"; } // else } // while $stmt->close(); } else { } // else if ($_SESSION["offersTypes"][$ff] == "money") { echo " <option selected value=\"money.money\">Money</option>\n"; } else { echo " <option value=\"money.money\">Money</option>\n"; } // else if ($_SESSION["offersTypes"][$ff] == "food") { echo " <option selected value=\"food.food\">Food</option>\n"; } else { echo " <option value=\"food.food\">Food</option>\n"; } // else echo " </select>\n"; echo " <br />\n"; } else { echo " <input type=\"hidden\" name=\"offers[" . $ff . "]\" value=\"1\" />\n"; echo " Offer <input data-toggle=\"tooltip\" data-placement=\"bottom\" title=\"Specify quantity of item.\" type=\"text\" name=\"offersQuantities[" . $ff . "]\" class=\"form-control input-sm\" placeholder=\"Quantity\" value=\"0\" />\n"; echo " <select data-toggle=\"tooltip\" data-placement=\"bottom\" title=\"Specify item.\" name=\"offersItems[" . $ff . "]\" class=\"form-control input-sm\">\n"; if ($stmt = $getPage_connection2->prepare("SELECT id FROM resources ORDER BY id ASC")) { $stmt->execute(); $stmt->store_result(); $stmt->bind_result($r_result); while ($stmt->fetch()) { $next_resources = $r_result; $resourceTypeInfo1 = getResourceTypeInfo($getPage_connection2, $next_resources); echo " <option value=\"resources." . strtolower($resourceTypeInfo1["name"]) . "\">" . $resourceTypeInfo1["name"] . "</option>\n"; } // while $stmt->close(); } else { } // else if ($stmt = $getPage_connection2->prepare("SELECT id FROM goods ORDER BY id ASC")) { $stmt->execute(); $stmt->store_result(); $stmt->bind_result($r_result); while ($stmt->fetch()) { $next_goods = $r_result; $goodsInfo1 = getGoodsInfo($getPage_connection2, $next_goods); echo " <option value=\"goods." . strtolower($goodsInfo1["name"]) . "\">" . $goodsInfo1["name"] . "</option>\n"; } // while $stmt->close(); } else { } // else echo " <option value=\"money.money\">Money</option>\n"; echo " <option value=\"food.food\">Food</option>\n"; echo " </select>\n"; echo " <br />\n"; } // else } // for echo " </div>\n"; echo " </div>\n"; echo " <div class=\"col-md-6\">\n"; echo " <label for=\"add_demand\">Add Demand</label>\n"; echo " <button onclick=\"loadButton(this)\" data-toggle=\"tooltip\" data-placement=\"bottom\" title=\"Add another demand (something the target nation contributes).\" value=\"add_demand\" name=\"action\" id=\"add_demand\" type=\"submit\" class=\"btn btn-md btn-success\">Add</button>\n"; echo " <br />\n"; echo " <div id=\"demands\">\n"; for ($ff = 0; $ff <= count($_SESSION["demands"]); $ff++) { if ($ff < count($_SESSION["demands"])) { echo " <input type=\"hidden\" name=\"demands[" . $ff . "]\" value=\"1\" />\n"; echo " Demand <input data-toggle=\"tooltip\" data-placement=\"bottom\" title=\"Specify quantity of item.\" type=\"text\" name=\"demandsQuantities[" . $ff . "]\" class=\"form-control input-sm\" placeholder=\"Quantity\" value=\"" . $_SESSION["demandsQuantities"][$ff] . "\" />\n"; echo " <select data-toggle=\"tooltip\" data-placement=\"bottom\" title=\"Specify item.\" name=\"demandsItems[" . $ff . "]\" class=\"form-control input-sm\">\n"; if ($stmt = $getPage_connection2->prepare("SELECT id FROM resources ORDER BY id ASC")) { $stmt->execute(); $stmt->store_result(); $stmt->bind_result($r_result); while ($stmt->fetch()) { $next_resources = $r_result; $resourceTypeInfo1 = getResourceTypeInfo($getPage_connection2, $next_resources); if ($_SESSION["demandsItems"][$ff] == $resourceTypeInfo1["id"] && $_SESSION["demandsTypes"][$ff] == "resources") { echo " <option selected value=\"resources." . strtolower($resourceTypeInfo1["name"]) . "\">" . $resourceTypeInfo1["name"] . "</option>\n"; } else { echo " <option value=\"resources." . strtolower($resourceTypeInfo1["name"]) . "\">" . $resourceTypeInfo1["name"] . "</option>\n"; } // else } // while $stmt->close(); } else { } // else if ($stmt = $getPage_connection2->prepare("SELECT id FROM goods ORDER BY id ASC")) { $stmt->execute(); $stmt->store_result(); $stmt->bind_result($r_result); while ($stmt->fetch()) { $next_goods = $r_result; $goodsInfo1 = getGoodsInfo($getPage_connection2, $next_goods); if ($_SESSION["demandsItems"][$ff] == $goodsInfo1["id"] && $_SESSION["demandsTypes"][$ff] == "goods") { echo " <option selected value=\"goods." . strtolower($goodsInfo1["name"]) . "\">" . $goodsInfo1["name"] . "</option>\n"; } else { echo " <option value=\"goods." . strtolower($goodsInfo1["name"]) . "\">" . $goodsInfo1["name"] . "</option>\n"; } // else } // while $stmt->close(); } else { } // else if ($_SESSION["demandsTypes"][$ff] == "money") { echo " <option selected value=\"money.money\">Money</option>\n"; } else { echo " <option value=\"money.money\">Money</option>\n"; } // else if ($_SESSION["demandsTypes"][$ff] == "food") { echo " <option selected value=\"food.food\">Food</option>\n"; } else { echo " <option value=\"food.food\">Food</option>\n"; } // else echo " </select>\n"; echo " <br />\n"; } else { echo " <input type=\"hidden\" name=\"demands[" . $ff . "]\" value=\"1\" />\n"; echo " Demand <input data-toggle=\"tooltip\" data-placement=\"bottom\" title=\"Specify quantity of item.\" type=\"text\" name=\"demandsQuantities[" . $ff . "]\" class=\"form-control input-sm\" placeholder=\"Quantity\" value=\"0\" />\n"; echo " <select data-toggle=\"tooltip\" data-placement=\"bottom\" title=\"Specify item.\" name=\"demandsItems[" . $ff . "]\" class=\"form-control input-sm\">\n"; if ($stmt = $getPage_connection2->prepare("SELECT id FROM resources ORDER BY id ASC")) { $stmt->execute(); $stmt->store_result(); $stmt->bind_result($r_result); while ($stmt->fetch()) { $next_resources = $r_result; $resourceTypeInfo1 = getResourceTypeInfo($getPage_connection2, $next_resources); echo " <option value=\"resources." . strtolower($resourceTypeInfo1["name"]) . "\">" . $resourceTypeInfo1["name"] . "</option>\n"; } // while $stmt->close(); } else { } // else if ($stmt = $getPage_connection2->prepare("SELECT id FROM goods ORDER BY id ASC")) { $stmt->execute(); $stmt->store_result(); $stmt->bind_result($r_result); while ($stmt->fetch()) { $next_goods = $r_result; $goodsInfo1 = getGoodsInfo($getPage_connection2, $next_goods); echo " <option value=\"goods." . strtolower($goodsInfo1["name"]) . "\">" . $goodsInfo1["name"] . "</option>\n"; } // while $stmt->close(); } else { } // else echo " <option value=\"money.money\">Money</option>\n"; echo " <option value=\"food.food\">Food</option>\n"; echo " </select>\n"; echo " <br />\n"; } // else } // for echo " </div>\n"; echo " </div>\n"; echo " <br />\n"; echo " <div class=\"col-md-12\">\n"; echo " <label class=\"control-label\" for=\"set_turns\">Turns:</label>\n"; echo " <input data-toggle=\"tooltip\" data-placement=\"bottom\" title=\"Specify the duration of the deal.\" type=\"text\" name=\"turns\" id=\"set_turns\" class=\"form-control input-sm\" value=\"1\" placeholder=\"e.g. 1\" />\n"; echo " </div>\n"; echo " <br />\n"; echo " <div class=\"col-md-12\">\n"; echo " <button onclick=\"loadButton(this)\" data-toggle=\"tooltip\" data-placement=\"bottom\" title=\"Send deal to nation for consideration.\" value=\"send_offer\" name=\"action\" id=\"send_offer\" type=\"submit\" class=\"btn btn-md btn-success info_button\">Send</button>\n"; echo " <button onclick=\"loadButton(this)\" data-toggle=\"tooltip\" data-placement=\"bottom\" title=\"Reset deal's contents to none.\" value=\"reset_offer\" name=\"action\" id=\"reset_offer\" type=\"submit\" class=\"btn btn-md btn-danger info_button\">Reset</button>\n"; echo " </div>\n"; echo " </div>\n"; echo " </form>\n"; echo " </div>\n"; echo " </div>\n"; echo " </div>\n"; echo " <div class=\"panel panel-info\">\n"; echo " <div data-toggle=\"tooltip\" data-placement=\"bottom\" title=\"View current market rates.\" class=\"panel-heading\">\n"; echo " <h3 class=\"panel-title\">Current Market <button type=\"button\" class=\"btn btn-default btn-md collapsed\" data-toggle=\"collapse\" data-target=\"#collapseMarket\"><span class=\"glyphicon glyphicon-plus\"></span>/<span class=\"glyphicon glyphicon-minus\"></span></button></h3>\n"; echo " </div>\n"; echo " <div id=\"collapseMarket\" class=\"panel-body collapse in\">\n"; echo " <div class=\"col-md-8 col-center\">\n"; if ($stmt = $getPage_connection2->prepare("SELECT id FROM market ORDER BY id ASC")) { $stmt->execute(); $stmt->store_result(); $stmt->bind_result($r_result); while ($stmt->fetch()) { $next_market = $r_result; $marketInfo1 = getMarketInfo($getPage_connection2, $next_market); echo " " . $marketInfo1["name"] . ": " . $marketInfo1["rate"] . "% value\n <br />\n"; } // while $stmt->close(); } else { } // else echo " </div>\n"; echo " </div>\n"; echo " </div>\n"; echo " <div class=\"panel panel-info\">\n"; echo " <div data-toggle=\"tooltip\" data-placement=\"bottom\" title=\"View previously accepted trade agreements.\" class=\"panel-heading\">\n"; echo " <h3 class=\"panel-title\">Accepted Agreements <button type=\"button\" class=\"btn btn-default btn-md collapsed\" data-toggle=\"collapse\" data-target=\"#collapseAcceptedAgreements\"><span class=\"glyphicon glyphicon-plus\"></span>/<span class=\"glyphicon glyphicon-minus\"></span></button></h3>\n"; echo " </div>\n"; echo " <div id=\"collapseAcceptedAgreements\" class=\"panel-body collapse in\">\n"; echo " <div class=\"col-md-8 col-center\">\n"; $agreementsExist = false; if ($stmt = $getPage_connection2->prepare("SELECT id FROM agreements ORDER BY id ASC")) { $stmt->execute(); $stmt->store_result(); $stmt->bind_result($r_result); while ($stmt->fetch()) { $next_agreements = $r_result; $agreementInfo1 = getAgreementInfo($getPage_connection2, $next_agreements); if (($agreementInfo1["toNation"] == $_SESSION["nation_id"] || $agreementInfo1["fromNation"] == $_SESSION["nation_id"]) && $agreementInfo1["status"] == 1) { $agreementsExist = true; $toNationInfo = getNationInfo($getPage_connection2, $agreementInfo1["toNation"]); $fromNationInfo = getNationInfo($getPage_connection2, $agreementInfo1["fromNation"]); echo " To: <a href=\"index.php?page=info&section=nations&info_id=" . $toNationInfo["id"] . "\">" . $toNationInfo["name"] . "</a>, From: <a href=\"index.php?page=info&section=nations&info_id=" . $fromNationInfo["id"] . "\">" . $fromNationInfo["name"] . "</a>\n <br />\n"; echo " Agreement Policy: " . $agreementInfo1["policy"] . "\n <br />\n"; echo " " . $agreementInfo1["counter"] . " / " . $agreementInfo1["turns"] . " turns \n"; echo " <br />\n"; echo " ----\n <br />\n"; } // if } // while $stmt->close(); } else { } // else if ($agreementsExist === false) { echo " No agreements established.\n"; } // if echo " </div>\n"; echo " </div>\n"; echo " </div>\n"; echo " <div class=\"panel panel-info\">\n"; echo " <div data-toggle=\"tooltip\" data-placement=\"bottom\" title=\"View previously accepted offers.\" class=\"panel-heading\">\n"; echo " <h3 class=\"panel-title\">Accepted Offers <button type=\"button\" class=\"btn btn-default btn-md collapsed\" data-toggle=\"collapse\" data-target=\"#collapseAcceptedOffers\"><span class=\"glyphicon glyphicon-plus\"></span>/<span class=\"glyphicon glyphicon-minus\"></span></button></h3>\n"; echo " </div>\n"; echo " <div id=\"collapseAcceptedOffers\" class=\"panel-body collapse in\">\n"; echo " <div class=\"col-md-8 col-center\">\n"; $offersExist = false; if ($stmt = $getPage_connection2->prepare("SELECT id FROM offers ORDER BY id ASC")) { $stmt->execute(); $stmt->store_result(); $stmt->bind_result($r_result); while ($stmt->fetch()) { $next_offers = $r_result; $offerInfo1 = getOfferInfo($getPage_connection2, $next_offers); if (($offerInfo1["toNation"] == $_SESSION["nation_id"] || $offerInfo1["fromNation"] == $_SESSION["nation_id"]) && $offerInfo1["status"] == 1) { if ($offerInfo1["givingItems"][0] > 0 || $offerInfo1["receivingItems"][0] > 0) { $offersExist = true; $toNationInfo = getNationInfo($getPage_connection2, $offerInfo1["toNation"]); $fromNationInfo = getNationInfo($getPage_connection2, $offerInfo1["fromNation"]); echo " To: <a href=\"index.php?page=info&section=nations&info_id=" . $toNationInfo["id"] . "\">" . $toNationInfo["name"] . "</a>, From: <a href=\"index.php?page=info&section=nations&info_id=" . $fromNationInfo["id"] . "\">" . $fromNationInfo["name"] . "</a>\n <br />\n"; if ($offerInfo1["givingItems"][0] > 0) { echo " Giving:\n <br />\n"; for ($z = 0; $z < count($offerInfo1["givingItems"]); $z++) { if ($offerInfo1["givingQuantities"][$z] > 0) { if ($offerInfo1["givingTypes"][$z] == "goods") { $itemInfo1 = getGoodsInfo($getPage_connection2, $offerInfo1["givingItems"][$z]); $name1 = $itemInfo1["name"]; } else { if ($offerInfo1["givingTypes"][$z] == "resources") { $itemInfo1 = getResourceTypeInfo($getPage_connection2, $offerInfo1["givingItems"][$z]); $name1 = $itemInfo1["name"]; } else { $name1 = "money"; } } // else echo " " . $offerInfo1["givingQuantities"][$z] . " " . $name1 . "\n <br />\n"; } // if } // for } else { echo " Giving:\n <br />\n Nothing.\n"; } // else if ($offerInfo1["receivingItems"][0] > 0) { echo " Receiving:\n <br />\n"; for ($z = 0; $z < count($offerInfo1["receivingItems"]); $z++) { if ($offerInfo1["receivingQuantities"][$z] > 0) { if ($offerInfo1["receivingTypes"][$z] == "goods") { $itemInfo1 = getGoodsInfo($getPage_connection2, $offerInfo1["receivingItems"][$z]); $name1 = $itemInfo1["name"]; } else { if ($offerInfo1["receivingTypes"][$z] == "resources") { $itemInfo1 = getResourceTypeInfo($getPage_connection2, $offerInfo1["receivingItems"][$z]); $name1 = $itemInfo1["name"]; } else { $name1 = "money"; } } // else echo " " . $offerInfo1["receivingQuantities"][$z] . " " . $name1 . "\n <br />\n"; } // if } // for } else { echo " Receiving:\n <br />\n Nothing.\n"; } // else echo " <br />\n"; echo " " . $offerInfo1["counter"] . " / " . $offerInfo1["turns"] . " turns \n"; echo " <br />\n"; echo " ----\n <br />\n"; } // if } // if } // while $stmt->close(); } else { } // else if ($offersExist === false) { echo " No offers established.\n"; } // if echo " </div>\n"; echo " </div>\n"; echo " </div>\n"; echo " <div class=\"panel panel-info\">\n"; echo " <div data-toggle=\"tooltip\" data-placement=\"bottom\" title=\"View previously declined trade agreements.\" class=\"panel-heading\">\n"; echo " <h3 class=\"panel-title\">Declined Agreements <button type=\"button\" class=\"btn btn-default btn-md collapsed\" data-toggle=\"collapse\" data-target=\"#collapseDeclinedAgreements\"><span class=\"glyphicon glyphicon-plus\"></span>/<span class=\"glyphicon glyphicon-minus\"></span></button></h3>\n"; echo " </div>\n"; echo " <div id=\"collapseDeclinedAgreements\" class=\"panel-body collapse in\">\n"; echo " <div class=\"col-md-8 col-center\">\n"; $agreementsExist = false; if ($stmt = $getPage_connection2->prepare("SELECT id FROM agreements ORDER BY id ASC")) { $stmt->execute(); $stmt->store_result(); $stmt->bind_result($r_result); while ($stmt->fetch()) { $next_agreements = $r_result; $agreementInfo1 = getAgreementInfo($getPage_connection2, $next_agreements); if (($agreementInfo1["toNation"] == $_SESSION["nation_id"] || $agreementInfo1["fromNation"] == $_SESSION["nation_id"]) && $agreementInfo1["status"] == 2) { $agreementsExist = true; $toNationInfo = getNationInfo($getPage_connection2, $agreementInfo1["toNation"]); $fromNationInfo = getNationInfo($getPage_connection2, $agreementInfo1["fromNation"]); echo " To: <a href=\"index.php?page=info&section=nations&info_id=" . $toNationInfo["id"] . "\">" . $toNationInfo["name"] . "</a>, From: <a href=\"index.php?page=info&section=nations&info_id=" . $fromNationInfo["id"] . "\">" . $fromNationInfo["name"] . "</a>\n <br />\n"; echo " Agreement Policy: " . $agreementInfo1["policy"] . "\n <br />\n"; echo " <br />\n"; echo " " . $agreementInfo1["counter"] . " / " . $agreementInfo1["turns"] . " turns \n"; echo " <br />\n"; echo " ----\n <br />\n"; } // if } // while $stmt->close(); } else { } // else if ($agreementsExist === false) { echo " No declined agreements exist so far.\n"; } // if echo " </div>\n"; echo " </div>\n"; echo " </div>\n"; echo " <div class=\"panel panel-info\">\n"; echo " <div data-toggle=\"tooltip\" data-placement=\"bottom\" title=\"View previously declined offers.\" class=\"panel-heading\">\n"; echo " <h3 class=\"panel-title\">Declined Offers <button type=\"button\" class=\"btn btn-default btn-md collapsed\" data-toggle=\"collapse\" data-target=\"#collapseDeclinedOffers\"><span class=\"glyphicon glyphicon-plus\"></span>/<span class=\"glyphicon glyphicon-minus\"></span></button></h3>\n"; echo " </div>\n"; echo " <div id=\"collapseDeclinedOffers\" class=\"panel-body collapse in\">\n"; echo " <div class=\"col-md-8 col-center\">\n"; $offersExist = false; if ($stmt = $getPage_connection2->prepare("SELECT id FROM offers ORDER BY id ASC")) { $stmt->execute(); $stmt->store_result(); $stmt->bind_result($r_result); while ($stmt->fetch()) { $next_offers = $r_result; $offerInfo1 = getOfferInfo($getPage_connection2, $next_offers); if (($offerInfo1["toNation"] == $_SESSION["nation_id"] || $offerInfo1["fromNation"] == $_SESSION["nation_id"]) && $offerInfo1["status"] == 2) { if ($offerInfo1["givingItems"][0] > 0 || $offerInfo1["receivingItems"][0] > 0) { $offersExist = true; $toNationInfo = getNationInfo($getPage_connection2, $offerInfo1["toNation"]); $fromNationInfo = getNationInfo($getPage_connection2, $offerInfo1["fromNation"]); echo " To: <a href=\"index.php?page=info&section=nations&info_id=" . $toNationInfo["id"] . "\">" . $toNationInfo["name"] . "</a>, From: <a href=\"index.php?page=info&section=nations&info_id=" . $fromNationInfo["id"] . "\">" . $fromNationInfo["name"] . "</a>\n <br />\n"; if ($offerInfo1["givingItems"][0] > 0) { echo " Giving:\n <br />\n"; for ($z = 0; $z < count($offerInfo1["givingItems"]); $z++) { if ($offerInfo1["givingQuantities"][$z] > 0) { if ($offerInfo1["givingTypes"][$z] == "goods") { $itemInfo1 = getGoodsInfo($getPage_connection2, $offerInfo1["givingItems"][$z]); $name1 = $itemInfo1["name"]; } else { if ($offerInfo1["givingTypes"][$z] == "resources") { $itemInfo1 = getResourceTypeInfo($getPage_connection2, $offerInfo1["givingItems"][$z]); $name1 = $itemInfo1["name"]; } else { $name1 = "money"; } } // else echo " " . $offerInfo1["givingQuantities"][$z] . " " . $name1 . "\n <br />\n"; } // if } // for } else { echo " Giving:\n <br />\n Nothing.\n"; } // else if ($offerInfo1["receivingItems"][0] > 0) { echo " Receiving:\n <br />\n"; for ($z = 0; $z < count($offerInfo1["receivingItems"]); $z++) { if ($offerInfo1["receivingQuantities"][$z] > 0) { if ($offerInfo1["receivingTypes"][$z] == "goods") { $itemInfo1 = getGoodsInfo($getPage_connection2, $offerInfo1["receivingItems"][$z]); $name1 = $itemInfo1["name"]; } else { if ($offerInfo1["receivingTypes"][$z] == "resources") { $itemInfo1 = getResourceTypeInfo($getPage_connection2, $offerInfo1["receivingItems"][$z]); $name1 = $itemInfo1["name"]; } else { $name1 = "money"; } } // else echo " " . $offerInfo1["receivingQuantities"][$z] . " " . $name1 . "\n <br />\n"; } // if } // for } else { echo " Receiving:\n <br />\n Nothing.\n"; } // else echo " <br />\n"; echo " " . $offerInfo1["counter"] . " / " . $offerInfo1["turns"] . " turns \n"; echo " <br />\n"; echo " ----\n <br />\n"; } // if } // if } // while $stmt->close(); } else { } // else if ($offersExist === false) { echo " No declined offers exist so far.\n"; } // if echo " </div>\n"; echo " </div>\n"; echo " </div>\n"; echo " </div>\n"; }
function updateGlobe($getPage_connection2) { // change requirements of luxury and basic goods // set luxurygoods $goodsInfoW = getGoodsInfo($getPage_connection2, 5); if ($goodsInfoW["productionRequired"] - 2 > 1) { $new_productionRequired = mt_rand($goodsInfoW["productionRequired"] - 2, $goodsInfoW["productionRequired"] + 2); } else { $new_productionRequired = mt_rand(1, $goodsInfoW["productionRequired"] + 2); } // else if ($new_productionRequired < 1) { $new_productionRequired = 1; } // if $rand_metals = 2; $rand_wood = 1; $rand_metals = mt_rand(2, 10); $rand_wood = mt_rand(2, 10); $new_resourceTypesRequired = array(0 => 0); $new_resourceQuantitiesRequired = array(0 => 0); if ($rand_wood > 0) { $new_resourceTypesRequired[0] = 1; $new_resourceQuantitiesRequired[0] = $rand_wood; } // if if ($rand_metals > 0) { $new_resourceTypesRequired[1] = 2; $new_resourceQuantitiesRequired[1] = $rand_metals; } // if setGoodsInfo($getPage_connection2, $goodsInfoW["id"], $goodsInfoW["name"], $new_productionRequired, $goodsInfoW["foodRequired"], $new_resourceTypesRequired, $new_resourceQuantitiesRequired, $goodsInfoW["improvementTypesRequired"], $goodsInfoW["improvementQuantitiesRequired"], $goodsInfoW["improvementLevelRequired"], $goodsInfoW["buyStrength"], $goodsInfoW["sellStrength"]); // set basicgoods $goodsInfoW = getGoodsInfo($getPage_connection2, 6); if ($goodsInfoW["productionRequired"] - 2 > 1) { $new_productionRequired = mt_rand($goodsInfoW["productionRequired"] - 2, $goodsInfoW["productionRequired"] + 2); } else { $new_productionRequired = mt_rand(0, $goodsInfoW["productionRequired"] + 2); } // else if ($new_productionRequired < 1) { $new_productionRequired = 1; } // if $rand_metals = 1; $rand_wood = 1; $rand_metals = mt_rand(1, 8); $rand_wood = mt_rand(1, 8); $new_resourceTypesRequired = array(0 => 0); $new_resourceQuantitiesRequired = array(0 => 0); if ($rand_wood > 0) { $new_resourceTypesRequired[0] = 1; $new_resourceQuantitiesRequired[0] = $rand_wood; } // if if ($rand_metals > 0) { $new_resourceTypesRequired[1] = 2; $new_resourceQuantitiesRequired[1] = $rand_metals; } // if setGoodsInfo($getPage_connection2, $goodsInfoW["id"], $goodsInfoW["name"], $new_productionRequired, $goodsInfoW["foodRequired"], $new_resourceTypesRequired, $new_resourceQuantitiesRequired, $goodsInfoW["improvementTypesRequired"], $goodsInfoW["improvementQuantitiesRequired"], $goodsInfoW["improvementLevelRequired"], $goodsInfoW["buyStrength"], $goodsInfoW["sellStrength"]); // set new market rates if ($stmt = $getPage_connection2->prepare("SELECT id FROM goods ORDER BY id ASC")) { $stmt->execute(); $stmt->store_result(); $stmt->bind_result($r_result); while ($stmt->fetch()) { $next_goods = $r_result; $goodsInfoW = getGoodsInfo($getPage_connection2, $next_goods); $marketInfoW = getMarketInfo($getPage_connection2, $next_goods); $rate = 0; // if buy strength is more, increase rate, otherwise decrease or remain constant if ($goodsInfoW["buyStrength"] > $goodsInfoW["sellStrength"]) { $randRateBonus = mt_rand(1, 4); $rate = $marketInfoW["rate"] + $randRateBonus; } else { if ($goodsInfoW["buyStrength"] < $goodsInfoW["sellStrength"]) { $randFlux = mt_rand(1, 4); // random drop or rise (75% more likely drop) if ($randFlux == 1) { $randRateBonus = mt_rand(1, 2); $rate = $marketInfoW["rate"] + $randRateBonus; } else { $randRateBonus = mt_rand(1, 4); $rate = $marketInfoW["rate"] - $randRateBonus; } // else } else { $randFlux = mt_rand(1, 2); // random drop or rise (50/50) if ($randFlux == 1) { $randRateBonus = mt_rand(1, 2); $rate = $marketInfoW["rate"] + $randRateBonus; } else { $randRateBonus = mt_rand(1, 2); $rate = $marketInfoW["rate"] - $randRateBonus; } // else } } // else if ($rate >= 1) { setMarketInfo($getPage_connection2, $next_goods, $marketInfoW["name"], $rate); } else { setMarketInfo($getPage_connection2, $next_goods, $marketInfoW["name"], 0); } // else // reset strength of good for next turn (no reset for now) //setGoodsInfo($getPage_connection2,$goodsInfoW["id"],$goodsInfoW["name"],$goodsInfoW["productionRequired"],$goodsInfoW["foodRequired"],$goodsInfoW["resourceTypesRequired"],$goodsInfoW["resourceQuantitiesRequired"],$goodsInfoW["improvementTypesRequired"],$goodsInfoW["improvementQuantitiesRequired"],$goodsInfoW["improvementLevelRequired"],100,100); } // while $stmt->close(); } else { } // else // add to turn counter for trade offers if ($stmt = $getPage_connection2->prepare("SELECT id FROM offers ORDER BY id ASC")) { $stmt->execute(); $stmt->store_result(); $stmt->bind_result($r_result); while ($stmt->fetch()) { $next_offers = $r_result; $offerInfo1 = getOfferInfo($getPage_connection2, $next_offers); $new_counter = $offerInfo1["counter"] + 1; setOfferInfo($getPage_connection2, $offerInfo1["id"], $offerInfo1["fromNation"], $offerInfo1["toNation"], $offerInfo1["givingItems"], $offerInfo1["receivingItems"], $offerInfo1["givingQuantities"], $offerInfo1["receivingQuantities"], $offerInfo1["givingTypes"], $offerInfo1["receivingTypes"], $offerInfo1["turns"], $new_counter, $offerInfo1["status"]); } // while $stmt->close(); } else { } // else // remove empty organizations, automatically appoint new manager if there is no manager (new manager is the oldest joined member) if ($stmt = $getPage_connection2->prepare("SELECT id FROM organizations ORDER BY id ASC")) { $stmt->execute(); $stmt->store_result(); $stmt->bind_result($r_result); while ($stmt->fetch()) { $next_organizations = $r_result; $organizationInfo1 = getOrganizationInfo($getPage_connection2, $next_organizations); $new_managers = array(0 => 0); if (count($organizationInfo1["members"]) == 1) { if ($organizationInfo1["members"][0] == 0) { deleteOrganizationInfo($getPage_connection2, $next_organizations); } // if } else { if (count($organizationInfo1["members"]) > 1) { if (count($organizationInfo1["managers"]) == 1) { if ($organizationInfo1["managers"][0] == 0) { $new_managers[0] = $organizationInfo1["members"][0]; setOrganizationInfo($getPage_connection2, $next_organizations, $organizationInfo1["name"], $organizationInfo1["members"], $new_managers, $organizationInfo1["pending"], $organizationInfo1["ranking"]); } // if } else { } // else } else { deleteOrganizationInfo($getPage_connection2, $next_organizations); } } // else } // while $stmt->close(); } else { } // else // set rankings if ($stmt = $getPage_connection2->prepare("SELECT id FROM nations ORDER BY id ASC")) { $stmt->execute(); $stmt->store_result(); $stmt->bind_result($r_result); $offset = 0; while ($stmt->fetch()) { $next_nations = $r_result; $rank = $offset + 1; // production if ($stmt11 = $getPage_connection2->prepare("SELECT id FROM nations ORDER BY production DESC LIMIT 1 OFFSET ?")) { $stmt11->bind_param("i", $offset); $stmt11->execute(); $stmt11->bind_result($r_result); $stmt11->fetch(); $next_production_nation = $r_result; $stmt11->close(); } else { } // else if ($stmt11 = $getPage_connection2->prepare("UPDATE rankings SET production=? WHERE nation=?")) { $stmt11->bind_param("ii", $rank, $next_production_nation); $stmt11->execute(); $stmt11->close(); } else { } // else // money if ($stmt11 = $getPage_connection2->prepare("SELECT id FROM nations ORDER BY money DESC LIMIT 1 OFFSET ?")) { $stmt11->bind_param("i", $offset); $stmt11->execute(); $stmt11->bind_result($r_result); $stmt11->fetch(); $next_money_nation = $r_result; $stmt11->close(); } else { } // else if ($stmt11 = $getPage_connection2->prepare("UPDATE rankings SET money=? WHERE nation=?")) { $stmt11->bind_param("ii", $rank, $next_money_nation); $stmt11->execute(); $stmt11->close(); } else { } // else // happiness if ($stmt11 = $getPage_connection2->prepare("SELECT id FROM nations ORDER BY happiness DESC LIMIT 1 OFFSET ?")) { $stmt11->bind_param("i", $offset); $stmt11->execute(); $stmt11->bind_result($r_result); $stmt11->fetch(); $next_happiness_nation = $r_result; $stmt11->close(); } else { } // else if ($stmt11 = $getPage_connection2->prepare("UPDATE rankings SET happiness=? WHERE nation=?")) { $stmt11->bind_param("ii", $rank, $next_happiness_nation); $stmt11->execute(); $stmt11->close(); } else { } // else // food if ($stmt11 = $getPage_connection2->prepare("SELECT id FROM nations ORDER BY food DESC LIMIT 1 OFFSET ?")) { $stmt11->bind_param("i", $offset); $stmt11->execute(); $stmt11->bind_result($r_result); $stmt11->fetch(); $next_food_nation = $r_result; $stmt11->close(); } else { } // else if ($stmt11 = $getPage_connection2->prepare("UPDATE rankings SET food=? WHERE nation=?")) { $stmt11->bind_param("ii", $rank, $next_food_nation); $stmt11->execute(); $stmt11->close(); } else { } // else // population if ($stmt11 = $getPage_connection2->prepare("SELECT id FROM nations ORDER BY population DESC LIMIT 1 OFFSET ?")) { $stmt11->bind_param("i", $offset); $stmt11->execute(); $stmt11->bind_result($r_result); $stmt11->fetch(); $next_population_nation = $r_result; $stmt11->close(); } else { } // else if ($stmt11 = $getPage_connection2->prepare("UPDATE rankings SET population=? WHERE nation=?")) { $stmt11->bind_param("ii", $rank, $next_population_nation); $stmt11->execute(); $stmt11->close(); } else { } // else $offset++; } // while $stmt->close(); } else { $next_offers = 0; } // else }