RyXéo » GLPI

//ryxeo

function plugin_manageentity_anetinsertnextupgrade($eID,$text){

  $DB = new DB;

  $query="SELECT ID FROM glpi_plugin_anet_epacks_upgrade WHERE FK_serveur='$eID';";

  $result = $DB->query($query);

  if($DB->numrows($result)>0)

    $query="UPDATE glpi_plugin_anet_epacks_upgrade SET upgradecmd='$text' WHERE FK_serveur='$eID';";

  else

    $query="INSERT INTO glpi_plugin_anet_epacks_upgrade (FK_serveur,upgradecmd) VALUES ('$eID','$text');";

  $result = $DB->query($query);

}

//ryxeo

function plugin_manageentity_showanetnextupgrade($instID) {

	global $DB,$CFG_GLPI, $LANG,$LANGMANAGEENTITY;

	if (!haveRight("computer","r")) return false;

	$query = "SELECT upgradecmd FROM glpi_plugin_anet_epacks_upgrade as u

LEFT JOIN glpi_plugin_anet_epacks AS g ON g.FK_serveur=u.FK_serveur

WHERE FK_enduser=".$instID;

	//print $query;

	$title=$LANG["central"][9];

	$result = $DB->query($query);

	$number = $DB->numrows($result);

	$upgradecmd = $DB->result($result, 0, "upgradecmd");

	$query = "SELECT FK_serveur as srvID FROM glpi_plugin_anet_epacks WHERE FK_enduser=".$instID;

	//	print $query;

	$result = $DB->query($query);

	$srvID = $DB->result($result, 0, "srvID");

	echo "<form method='post' action=\"./index.php\">";

	echo "<input type='hidden' name='srvID' value='$srvID'>";

	echo "<br><div align='center'><table class='tab_cadre' align='center' width='95%'>";

	echo "<tr>";

	echo "<th colspan='4'>Commande à lancer lors de la prochaine mise à jour de ce serveur </th>";

	echo "</tr>";

	echo "<tr class='tab_bg_2'>";

	echo "<td width=\"100%\"><u>Note:</u> Cette commande doit-être gpg signée par une clé GPG acceptée par ce serveur !<br /><textarea name=\"upgradecmd\" cols=\"100\" rows=\"10\">".$upgradecmd."</textarea></td>";

	echo "</tr>";

	echo "<tr class='tab_bg_2'>";

	echo "<td width=\"100%\"><input type=\"submit\" name=\"anetinsertnextupgrade\" value=\"Enregistrer\" class=\"submit\"></td>";

	echo "</tr>";

	echo "</table></div>";

	echo"</form>";

	echo "<br />";

}

} elseif (isset($_POST["anetinsertnextupgrade"])){

	  //ryxeo

	  if(plugin_manageentity_HaveRight("manageentity","w"))

	    plugin_manageentity_anetinsertnextupgrade($_POST["srvID"],$_POST["upgradecmd"]);

	  glpi_header($_SERVER['HTTP_REFERER']);

}else if (isset($_GET["deletecontracts"])){

		plugin_manageentity_showanetnextupgrade($_SESSION["glpiactive_entity"]);