Sstrutt: Initial creation

2011-08-31T14:03:41Z

Initial creation

New page

<source lang="php">

<html xmlns='http://www.w3.org/TR/REC-html40'>



<html>
<head>
<title>vi-db (vApps)</title>
<link rel='SHORTCUT ICON' href='favicon.ico'>
<link rel='stylesheet' type='text/css' href='alpha.css' />
<meta name='Author' content='Simon Strutt'>
<meta name='Description' content='VI Info'>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" >
<meta http-equiv="Content-Type" content="image/jpeg" >
<meta http-equiv='Pragma' content='no-cache'>
<meta http-equiv='Expires' content='900'>
</head>
<body>

<?php
$time_start = microtime(true);

//Local variables etc
require 'config.php';
$self = $_SERVER['PHP_SELF'];
$debug = 0;

// open connection and select database
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect to database!");
mysql_select_db($db) or die ("Unable to select database!");

//Set debug on if required
if (array_key_exists('debug', $_REQUEST) and ($_REQUEST["debug"] == 1)) {
$debug = 1;
}

// show parameters and errors
if ($debug) {
error_reporting(-1);
print_r($_REQUEST);
print "<br>";
}

print "DISCLAIMER: Please use all information gained from here with caution - I haven't performed exhaustive validation and testing of any of the information that may be presented.<br>\n";
print "If you're making changes or decisions, please double check with the reality of what is displayed by the vCentre servers. You retain full responsibility for your actions...!\n ";
print "<h1>vApps</h1>\n";

if (array_key_exists('vappid', $_REQUEST)) {
$vapp_link = "&vappid=".$_REQUEST["vappid"];
$vappid=$_REQUEST["vappid"];
} else {
$vapp_link = "";
$vappid=0;
}

// Initial query

$query = "SELECT vc.name AS vc, cluster.name AS cluster, vappid, vapp.name AS vapp, vc_path, status FROM vapp JOIN vc USING (vcid) JOIN cluster USING (clid) WHERE vapp.exist=1 ORDER BY vc, cluster, vapp;";

$result = mysql_query($query);
//print $query;
if (mysql_num_rows($result) == 0) {
die ("No vApps found....");
}
$row = mysql_fetch_assoc($result);

// ----------------- Layout table (top) ----------------------------
print "<table align='center' cellspacing=10><tr><td valign='top'>\n";

// ------------------- Summary table ------------------------

print "<table class='BasicTable' align='center'>\n<tr><th>vCentre<th>Cluster<th>vApp<th>Status<th>vCenter<br>Path\n";
while ($row = mysql_fetch_assoc($result)) {
print "<tr><td>".$row['vc']."<td>".$row['cluster'];
if ($vappid == $row['vappid']) {
print "<td><b>".$row['vapp']."</b>";
} else {
print "<td><a href='$self?vappid=".$row['vappid']."'>".$row['vapp']."</a>";
}
if ($row['status'] == "Started") {
print "<td class='good'>Started";
} else {
print "<td class='warn'>".$row['status'];
}
print "<td>".$row['vc_path'];
}
print "</table>\n";

// ------------------ Layout table cell (bottom)--------------------------
print "\n<tr><td valign='top'>\n";

// ----------------- Detail table ---------------------------------------

if ($vappid) {
$query = "SELECT name, prod_name, prod_ver, prod_fver, prod_vend FROM vapp WHERE vappid=$vappid;";
$result = mysql_query($query);

if (mysql_num_rows($result) == 0) {
die ("Unexpected error...!");
}
$row = mysql_fetch_assoc($result);

print "<h1>".$row['name']."</h1>\n";
print "<table class='BasicTable' align='center'><tr><th colspan=2>Product";
print "<tr><th>Name<td width=150>".$row['prod_name'];
print "<tr><th>Version<td>".$row['prod_ver'];
print "<tr><th>Full Version<td>".$row['prod_fver'];
print "<tr><th>Vendor<td>".$row['prod_vend']."</table><br>\n";

$query = "SELECT vmid, name, is_on, ord, start_dly, start_wait, stop_dly, stop_act FROM vapp_vm JOIN vm USING (vmid) WHERE vapp_vm.vappid=$vappid ORDER BY ord, name;";
$result = mysql_query($query);

if (mysql_num_rows($result) == 0) {
die ("No VM's found in vApp...!");
}

print "<table class='BasicTable' align='center'><tr><th rowspan=2>Start<br>Order<th rowspan=2>VM<th rowspan=2>Power<th colspan=2>Start<th colspan=2>Stop\n";
print "<tr><th>Delay<br><small>sec</small><th>Proceed<br>After<th>Delay<br><small>sec</small><th>Method\n";

$odd_row = false;
$last_ord = false;
while ($row = mysql_fetch_assoc($result)) {
if ($last_ord <> $row['ord']) {
$odd_row = !$odd_row;
$last_ord = $row['ord'];
}
if ($odd_row) {
print "<tr class='odd'>";
} else {
print "<tr>";
}
print "<td class='num'>".$row['ord']."<td><a href='vm-detail.php?vmid=".$row['vmid']."'>".$row['name']."</a>";
if ($row['is_on']) {
print "<td class='good'>ON";
} else {
print "<td class='warn'>off";
}
print "<td class='num'>".$row['start_dly'];
if ($row['start_wait']) {
print "<td>Tools started";
} else {
print "<td>Delay expired";
}
print "<td class='num'>".$row['stop_dly'];
if ($row['stop_act'] == "guestShutdown") {
print "<td>Shutdown Guest";
} elseif ($row['stop_act'] == "powerOff") {
print "<td>Power Off VM";
} else {
print "<td>".$row['stop_act'];
}
}
print "</table>";

} else {
print "Select a vApp...\n";
}

// ------------------- Layout table end ------------------------------
print "</table>\n";

print "<br><a href='index.php'>Search page</a> &nbsp <a href='status.php'>Status page</a><br>\n";

$time = round((microtime(true) - $time_start)*1000);
print "Page took $time msecs to execute on server";

// ------------------- End of HTML ---------------------------------
print "</body><html>";

// ================ FUNCTIONS ============================

function search_char ($text) {

return (str_replace(array("*", "?"), array("%", "_"), trim($text)));
}

?>

</source>

VI-DB vapps.php v2 - Revision history

Sstrutt: Initial creation