/branches/1.2.0/www/instances_view.php

<? 
	require("src/prepend.inc.php"); 
	$display['load_extjs'] = true;
	
	if ($req_farmid)
	{
		if ($_SESSION["uid"] != 0)
	        $farminfo = $db->GetRow("SELECT * FROM farms WHERE id=? AND clientid=?", array($req_farmid, $_SESSION["uid"]));
	    else
	        $farminfo = $db->GetRow("SELECT * FROM farms WHERE id=?", array($req_farmid));
	        
		if (!$farminfo)
		{
		    $errmsg = _("Farm not found");
		    UI::Redirect("farms_view.php");
		}
		
		$clientid = $farminfo['clientid'];
	}
	else
	{
		if ($_SESSION["uid"] == 0)
		{
			$errmsg = _("Requested page cannot be viewed from admin account");
			UI::Redirect("index.php");
		}
		else
			$clientid = $_SESSION['uid'];
	}
	

	// Load Client Object
    $Client = Client::Load($clientid);

    

    if ($post_cancel)

		UI::Redirect("instances_view.php?farmid={$farminfo['id']}");

    

        
	$display["title"] = _("Servers&nbsp;&raquo;&nbsp;View");
			

	if ($req_action == "sshClient")

	{

		$DBInstance = DBInstance::LoadByIID($req_instanceid);
		$DBFarm = $DBInstance->GetFarmObject();
		
		if ($DBFarm->ClientID == $clientid)
		{

			$ssh_host = $DBInstance->ExternalIP;
			if ($ssh_host)

			{

				$ssh_port = $db->GetOne("SELECT default_ssh_port FROM roles WHERE ami_id=?", array($DBInstance->AMIID));
				if (!$ssh_port)
					$ssh_port = 22;
				
				$Smarty->assign(
					array(
						"DBInstance" => $DBInstance, 
						"host" => $ssh_host, 
						"port" => $ssh_port, 
						"key" => base64_encode($DBFarm->GetSetting(DBFarm::SETTING_AWS_PRIVATE_KEY))
					)
				);

				$Smarty->display("ssh_applet.tpl");

				exit();

			}
		}
		else
		{
			$errmsg = _("SSH console works only for instances launched by Scalr");
		}

	}


	if ($req_task || $req_action)
	{
		$AmazonEC2Client = AmazonEC2::GetInstance(AWSRegions::GetAPIURL($farminfo['region'])); 
		$AmazonEC2Client->SetAuthKeys($Client->AWSPrivateKey, $Client->AWSCertificate);
		
		if ($req_task == 'setactive')

		{

			$instanceinfo = $db->GetRow("SELECT * FROM farm_instances

				WHERE instance_id=? AND farmid=?",

				array($req_iid, $farminfo["id"])

			);

		

			if ($instanceinfo)

			{

				$db->Execute("UPDATE farm_instances SET isactive='1' 

					WHERE id=?", 

					array($instanceinfo['id'])

				);

				

				$zones = $db->GetAll("SELECT * FROM zones WHERE farmid=?", array($instanceinfo['farmid']));

				

				$DNSZoneController = new DNSZoneControler();

				

				$ami_info = $db->GetRow("SELECT * FROM roles WHERE ami_id=?", array($instanceinfo['ami_id']));

				

				try

				{

					foreach ($zones as $zoneinfo)

					{

						try
						{
							$DBFarmRole = DBFarmRole::LoadByID($instanceinfo['farm_roleid']);
							$skip_main_a_records = ($DBFarmRole->GetSetting(DBFarmRole::SETTING_BALANCING_USE_ELB) == 1) ? true : false;
						}
						catch(Exception $e)
						{
							$Logger->fatal(sprintf("instances_view(73): %s", $e->getMessage()));
							$skip_main_a_records = false;
						}
						
						$records = DNSZoneControler::GetInstanceDNSRecordsList($instanceinfo, $zoneinfo["role_name"], $ami_info['alias']);

														

						foreach ($records as $k=>$v)

						{

							if ($v["rkey"] != '' && $v["rvalue"] != '')

								$db->Execute("REPLACE INTO records SET zoneid=?, `rtype`=?, `ttl`=?, `rpriority`=?, `rvalue`=?, `rkey`=?, `issystem`=?", array($zoneinfo["id"], $v["rtype"], $v["ttl"], $v["rpriority"], $v["rvalue"], $v["rkey"], $v["issystem"] ? 1 : 0));

						}

						

						$DNSZoneController->Update($zoneinfo["id"]);

					}

					

					$i++;

				}

				catch(Exception $e)

				{

					$err[] = $e->getMessage();

				}

			}

			

			if (count($err) == 0)

				$okmsg = _("Instance successfully marked as active");

		}

		elseif ($req_task == 'setinactive')

		{

			$instanceinfo = $db->GetRow("SELECT * FROM farm_instances

				WHERE instance_id=? AND farmid=?",

				array($req_iid, $farminfo["id"])

			);

			

			if ($instanceinfo)

			{

				$db->Execute("UPDATE farm_instances SET isactive='0' 

					WHERE id=?", 

					array($instanceinfo['id'])

				);

				

				$zones = $db->GetAll("SELECT zoneid FROM records 

					WHERE (rvalue='{$instanceinfo['internal_ip']}' OR 

						rvalue='{$instanceinfo['external_ip']}') AND issystem='1' GROUP BY zoneid"

				);

				

				$DNSZoneController = new DNSZoneControler();

				

				try

				{

					foreach ($zones as $zoneid)

					{

						$zoneinfo = $db->GetRow("SELECT * FROM zones WHERE id=?", array($zoneid));

						

						// Add A records pointed to new active instance

						$db->Execute("DELETE FROM records WHERE 

							zoneid='{$zoneinfo['id']}' AND 

							(rvalue='{$instanceinfo['internal_ip']}' OR 

								rvalue='{$instanceinfo['external_ip']}'

							) AND issystem='1'"

						);

						

						$DNSZoneController->Update($zoneinfo["id"]);

					}

					

					$i++;

				}

				catch(Exception $e)

				{

					$err[] = $e->getMessage();

				}

			}



			if (count($err) == 0)

				$okmsg = _("Instance successfully marked as active");

		}

		

		if ($okmsg)

			UI::Redirect("instances_view.php?farmid={$req_farmid}");
	}
	
	$display["grid_query_string"] = "&farmid={$farminfo["id"]}";
	
	if (isset($req_farm_roleid))
	{
		$req_farm_roleid = (int)$req_farm_roleid;
		$display["grid_query_string"] .= "&farm_roleid={$req_farm_roleid}";
	}
	
	require("src/append.inc.php"); 
	
?>