svn commit: r1644655 - /vcl/trunk/web/.ht-inc/managementnode.php

[jf...@apache.org]

Author: jfthomps
Date: Thu Dec 11 14:40:18 2014
New Revision: 1644655

URL: http://svn.apache.org/r1644655
Log:
VCL-174 - NAT - support for sites that have small IP address ranges

managementnode.php: modified AJsaveResource and addResource: added code to add to/update nathost table when updating managementnode information; this is only for 2.4 and will be removed when a section is added to the site for managing nat hosts

Modified:
    vcl/trunk/web/.ht-inc/managementnode.php

Modified: vcl/trunk/web/.ht-inc/managementnode.php
URL: http://svn.apache.org/viewvc/vcl/trunk/web/.ht-inc/managementnode.php?rev=1644655&r1=1644654&r2=1644655&view=diff
==============================================================================
--- vcl/trunk/web/.ht-inc/managementnode.php (original)
+++ vcl/trunk/web/.ht-inc/managementnode.php Thu Dec 11 14:40:18 2014
@@ -520,6 +520,30 @@ class ManagementNode extends Resource {
 				else
 					setVariable("timesource|{$data['name']}", $data['timeservers'], 'none');
 			}
+			# update nathost (TODO change in release after 2.4 when section added to manage nat hosts)
+			if($data['ipaddress'] != $olddata['IPaddress']) {
+				$query = "SELECT id "
+				       . "FROM resource "
+				       . "WHERE resourcetypeid = 16 AND "
+				       .       "subid = {$data['rscid']}";
+				$qh = doQuery($query);
+				if($row = mysql_fetch_assoc($qh)) {
+					$resourceid = $row['id'];
+					$query = "UPDATE nathost "
+					       . "SET natIP = '{$data['ipaddress']}' "
+					       . "WHERE resourceid = $resourceid";
+					doQuery($query);
+					if(! mysql_affected_rows($GLOBALS['mysql_link_vcl'])) {
+						$query = "INSERT INTO nathost "
+						       .        "(resourceid, "
+						       .        "natIP) "
+						       . "VALUES "
+						       .        "($resourceid, "
+						       .        "'{$data['ipaddress']}')";
+						doQuery($query);
+					}
+				}
+			}
 		}
 
 		# clear user resource cache for this type
@@ -903,6 +927,16 @@ class ManagementNode extends Resource {
 				 .         "$rscid)";
 		doQuery($query);
 
+		$resourceid = dbLastInsertID();
+
+		// add entry to nathost table (TODO change in release after 2.4 when section added to manage nat hosts)
+		$query = "INSERT INTO nathost "
+				 .        "(resourceid, "
+				 .        "natIP) "
+				 . "VALUES ($resourceid, "
+				 .         "'{$data['ipaddress']}')";
+		doQuery($query);
+
 		# time server
 		$globalval = getVariable('timesource|global');
 		if($data['timeservers'] != $globalval)