function getLists() { $gdbo = new ArcDb(); $gdbo->dbConStr = $GLOBALS['globalDBCON']; $gdbo->dbType = $GLOBALS['globalDBTP']; $gdbo->dbSchema = $GLOBALS['globalDB']; # Degree Level require "_model/dboDegreeLevel.php"; $gdbo->getRec(); $this->listDegreeLevel = $gdbo->dbData; # Campuses require "_model/dboCampus.php"; $gdbo->getRec(); $this->listCampus = $gdbo->dbData; $this->listCampusJSON = json_encode($this->listCampus); echo '<script>window.listCampusJSON=\'' . $this->listCampusJSON . '\'</script>'; # Education Status require "_model/dboEducationStatus.php"; $gdbo->getRec(); $this->listEducationStatus = $gdbo->dbData; # University require "_model/dboUniversity.php"; $gdbo->getRec(); $this->listUniversity = $gdbo->dbData; return true; }
function getLists() { $gdbo = new ArcDb(); $gdbo->dbConStr = $GLOBALS['globalDBCON']; $gdbo->dbType = $GLOBALS['globalDBTP']; $gdbo->dbSchema = $GLOBALS['globalDB']; # Countries $gdbo->sql = "SELECT id_loc_country,loc_country FROM _loc_country"; $gdbo->getRec(); $this->listCountries = $gdbo->dbData; # Regions $gdbo->sql = "SELECT id_loc_region,loc_region,id_loc_country FROM _loc_region"; $gdbo->getRec(); $this->listRegions = $gdbo->dbData; # Filterable Objects $gdbo = new ArcDb(); $gdbo->dbConStr = $GLOBALS['globalDBCON']; $gdbo->dbType = $GLOBALS['globalDBTP']; $gdbo->dbSchema = $GLOBALS['globalDB']; $gdbo->sql = "SELECT id_loc_region,loc_region FROM _loc_region"; $gdbo->dbFilter = "WHERE id_loc_country="; $gdbo->type = "list"; $gdbo->id = "id_loc_region"; $gdbo->attributes = 'class="chRegion"'; $this->regionDBO = encrypt(json_encode((array) $gdbo)); return true; }
function getLists() { $gdbo = new ArcDb(); $gdbo->dbConStr = $GLOBALS['globalDBCON']; $gdbo->dbType = $GLOBALS['globalDBTP']; $gdbo->dbSchema = $GLOBALS['globalDB']; $gdbo->sql = "SELECT id_purchaseorder_payment_tp, purchaseorder_payment_tp FROM _purchaseorder_payment_tp"; $gdbo->getRec(); $this->listPaymentTp = $gdbo->dbData; $gdbo->sql = "SELECT\na.id_contract,\na.contract,\na.id_cust_company,\nb.cust_company\nFROM _contract a\nLEFT JOIN _cust_company b\nON a.id_cust_company = b.id_cust_company\nORDER by b.cust_company\n"; $gdbo->getRec(); $this->listContract = $gdbo->dbData; return true; }
function getLists() { $gdbo = new ArcDb(); $gdbo->dbConStr = $GLOBALS['globalDBCON']; $gdbo->dbType = $GLOBALS['globalDBTP']; $gdbo->dbSchema = $GLOBALS['globalDB']; $gdbo->sql = "SELECT \nid_invoice_qty_tp,\ninvoice_qty_tp\nFROM _invoice_qty_tp;\n"; $gdbo->getRec(); $this->listQtyType = $gdbo->dbData; $gdbo->sql = "SELECT\na.id_contract,\na.contract,\na.id_cust_company,\nb.cust_company\nFROM _contract a\nLEFT JOIN _cust_company b\nON a.id_cust_company = b.id_cust_company\nORDER by b.cust_company\n"; $gdbo->getRec(); $this->listContract = $gdbo->dbData; return true; }
function getLists() { $gdbo = new ArcDb(); $gdbo->dbConStr = $GLOBALS['globalDBCON']; $gdbo->dbType = $GLOBALS['globalDBTP']; $gdbo->dbSchema = $GLOBALS['globalDB']; # Insurance Plan $gdbo->sql = "SELECT \nid_hr_insurance_plan,\nhr_insurance_plan,\nid_cust_company \nFROM _hr_insurance_plan\nORDER BY id_cust_company asc,hr_insurance_plan asc"; $gdbo->getRec(); $this->listInsurancePlan = $gdbo->dbData; $this->listInsurancePlanJSON = json_encode($this->listInsurancePlan); echo '<script>window.listInsurancePlanJSON=\'' . $this->listInsurancePlanJSON . '\'</script>'; # Insurance Provider require "_model/dboInsuranceProvider.php"; $gdbo->getRec(); $this->listInsuranceProvider = $gdbo->dbData; # Insurance Coverage require "_model/dboInsuranceCoverage.php"; $gdbo->getRec(); $this->listInsuranceCoverage = $gdbo->dbData; return true; }
function getLists() { $gdbo = new ArcDb(); $gdbo->dbConStr = $GLOBALS['globalDBCON']; $gdbo->dbType = $GLOBALS['globalDBTP']; $gdbo->dbSchema = $GLOBALS['globalDB']; # Certification Type require "_model/dboCertification.php"; $gdbo->getRec(); $this->listCertification = $gdbo->dbData; $this->listCertificationJSON = json_encode($this->listCertification); echo '<script>window.listCertificationJSON=\'' . $this->listCertificationJSON . '\'</script>'; # Education Status require "_model/dboEducationStatus.php"; $gdbo->getRec(); $this->listEducationStatus = $gdbo->dbData; # Provider require "_model/dboCertificationProvider.php"; $gdbo->getRec(); $this->listProvider = $gdbo->dbData; return true; }
function getRecords() { $gdbo = new ArcDb(); $gdbo->dbConStr = $GLOBALS['globalDBCON']; $gdbo->dbType = $GLOBALS['globalDBTP']; $gdbo->dbSchema = $GLOBALS['globalDB']; if (is_null($this->filter) || is_null($this->id)) { return false; } $gdbo->sql = "SELECT\n_contract_payment.id_contract_payment,\n_contract_payment.contract_payment,\ncontract_payment_dr,\ncontract_payment_dp,\n_contract_payment.id_contract_payment_method_tp,\n_contract_payment.id_contract\nFROM _contract_payment\nWHERE " . $this->filter . "=" . $this->id . " ORDER BY contract_payment_dr ASC, id_contract_payment ASC"; $gdbo->getRec(); $results = $gdbo->getAssociative(); return $results; }
$start = strtotime("{$curYear}-{$curMonth}-1 00:00:00 "); $end = strtotime("{$curYear}-{$curMonth}-{$dayCount} 23:59:59"); $arc = new ArcDb(); $arc->dbConStr = $globalDBCON; $arc->dbOffset = 0; $arc->dbType = $globalDBTP; $arc->dbSchema = $globalDB; if (isset($_POST["start_date"]) && isset($_POST["end_date"])) { $start = strtotime($_POST["start_date"]); $end = strtotime($_POST["end_date"]); } $daterange = "{$start} and {$end}"; $daterangeFriendly = date('F j, Y', $start) . " through " . date('F j, Y', $end); $filter = $start != "" ? "where UNIX_TIMESTAMP(a.srv_dc)+{$gmtOffset} between " . $daterange : ""; $arc->sql = "\nSELECT * FROM(\nSELECT\nFROM_UNIXTIME(UNIX_TIMESTAMP(a.srv_dc)+{$gmtOffset},'%m-%d-%y') name,\ncount(id_srv) as data\nFROM _srv a {$filter} group by name order by name desc) as derived WHERE data >=1"; $arc->getRec(); $arcData = $arc->getAssociative(); $arcJSON = json_encode($arcData); ?> <script type="text/javascript"> var chartData=<?php echo $arcJSON; ?> ; var chart = AmCharts.makeChart("chartdiv", { "theme": "none", "type": "serial", "dataProvider": chartData, "chartCursor": {}, "pathToImages": "/_thirdparty/amcharts/images/", "valueAxes": [{
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program. If not, see <http://www.gnu.org/licenses/>. */ require_once "_lib/php/auth.php"; $sql = isset($_POST["sqlbox"]) ? hex2str($_POST["sqlbox"]) : ""; if (isset($_POST["id_con"]) && $_POST["id_con"] != "") { $arcdb = new ArcDb(); $arcdb->dbConStr = $globalDBCON; $arcdb->dbType = $globalDBTP; $arcdb->dbSchema = $globalDB; /**************************************************/ $arcdb->sql = "\nSELECT\na.id_con, \na.con, \na.id_con_db_tp,\na.con_alias,\na.con_user,\na.con_enabledbit,\na.con_password,\na.con_host,\na.con_port,\na.con_catalog,\na.con_options,\nb.con_db_tp\nFROM _con a\nLEFT JOIN _con_db_tp b ON a.id_con_db_tp=b.id_con_db_tp\nWHERE a.id_con =" . $_POST["id_con"]; $arcdb->getRec(); $con = $arcdb->getAssociative(); } $arcCon = new ArcTbl(); $arcCon->dbLimit = 23; $arcCon->dbOffset = 0; $arcCon->dbCatalog = isset($con[0]["con_catalog"]) ? $con[0]["con_catalog"] : $arcCon->dbCatalog; $arcCon->oCon = isset($con[0]["con"]) ? $con[0]["con"] : $arcCon->oCon; $arcCon->dbTable = $arcCon->oCon; $arcCon->dbSchema = isset($con[0]["con"]) ? $con[0]["con"] : $arcCon->dbSchema; $arcCon->oUser = isset($con[0]["con_user"]) ? $con[0]["con_user"] : $arcCon->oUser; $arcCon->oPassword = isset($con[0]["con_password"]) && !empty($con[0]["con_password"]) ? decrypt($con[0]["con_password"]) : $arcCon->oPassword; $arcCon->oHost = isset($con[0]["con_host"]) ? $con[0]["con_host"] : $arcCon->oHost; $arcCon->oPort = isset($con[0]["con_port"]) ? $con[0]["con_port"] : $arcCon->oPort; $arcCon->oOptions = isset($con[0]["con_options"]) ? $con[0]["con_options"] : $arcCon->oOptions; $arcCon->dbType = isset($con[0]["con_db_tp"]) ? $con[0]["con_db_tp"] : $arcCon->dbType;
You should have received a copy of the GNU General Public License along with this program. If not, see <http://www.gnu.org/licenses/>. */ require_once "_lib/php/auth.php"; $ajCfgDevice = null; $ajCfgDevice = isset($_POST["id_cfg_device"]) ? "&id_cfg_device=" . $_POST["id_cfg_device"] : ""; $ajCfgDevice .= isset($_POST["id_device"]) ? "&id_device=" . $_POST["id_device"] : ""; $ajCfgDevice .= isset($_POST["id_cfg"]) ? "&id_cfg=" . $_POST["id_cfg"] : ""; /**************************************************/ $iflabel = new ArcDb(); $iflabel->dbConStr = $globalDBCON; $iflabel->dbType = $globalDBTP; $iflabel->dbSchema = $globalDB; $iflabel->sql = "SELECT id_cfg_device_netgroup,cfg_device_netgroup from _cfg_device_netgroup order by cfg_device_netgroup"; $iflabel->getRec(); $listiflabel = $iflabel->dbData; /**************************************************/ $buttonAdd = '<div class="elementIconBox" onclick="prepSaveChanges(\'frmIFLabel\')"><i class="fa fa-plus"></i></div>'; /**************************************************/ $mnuiflabel = array(array(array("Interface Label", "device_interfacelabel", 'class="elementIcon"', 0, null, null, null, $buttonAdd, null, 'Network Interface'))); /**************************************************/ ?> <legend> Add Inteface Label </legend> <form name="frmIFLabel" id="frmIFLabel" method="post" action="javascript:submitFrmVals('fs_labels','/_mod/smod_18/sql.php','device_interfacelabel','<?php echo $ajCfgDevice; ?> &action=insert&form=frmIFLabel','frmIFLabel')"> <?php
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program. If not, see <http://www.gnu.org/licenses/>. */ require_once "_lib/php/auth.php"; $gdbo = new ArcDb(); $gdbo->dbConStr = $globalDBCON; $gdbo->dbType = $globalDBTP; $gdbo->dbSchema = $globalDB; # Record $gdbo->sql = "SELECT\na.id_cfg_device,\na.id_hr_emp,\na.id_device,\na.cfg_device,\na.id_cfg,\na.cfg_device_serialnumber,\nUNHEX(a.cfg_device_notes) as \"cfg_device_notes\",\nFROM_UNIXTIME(UNIX_TIMESTAMP(a.cfg_device_dc)+{$gmtOffset}) as \"cfg_device_dc\",\nFROM_UNIXTIME(UNIX_TIMESTAMP(a.cfg_device_du)+{$gmtOffset}) as \"cfg_device_du\",\na.cfg_device_dr,\na.id_sys_status,\na.cfg_device_keyenabled,\na.cfg_device_key,\nb.id_device_grp,\na.cfg_device_os\nFROM\n_cfg_device a\nLEFT JOIN\n_device b ON a.id_device=b.id_device\nWHERE a.id_cfg_device=" . $_POST["id_cfg_device"]; $gdbo->getRec(); $rec = $gdbo->getAssociative(); # Device Group $gdbo->sql = "SELECT \nid_device_grp,\ndevice_grp\nFROM _device_grp"; $gdbo->getRec(); $listDeviceGroup = $gdbo->dbData; # Users $gdbo->sql = "SELECT\na.id_hr_emp,\nconcat(b.cust_contact_givenName,' ',b.cust_contact_familyName) as \"fullname\" \nFROM\n_hr_emp as a\nLEFT JOIN _cust_contact b ON a.id_cust_contact=b.id_cust_contact\nORDER BY b.cust_contact_givenName,b.cust_contact_familyName"; $gdbo->getRec(); $listUsers = $gdbo->dbData; # Status $gdbo->sql = "SELECT \nid_sys_status,\nsys_status\nFROM _sys_status \nWHERE id_sys_status_tp=7"; $gdbo->getRec(); $listStatus = $gdbo->dbData; # Configuration $gdbo->sql = "SELECT \nid_cfg,\ncfg FROM _cfg;";
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program. If not, see <http://www.gnu.org/licenses/>. */ require_once "_lib/php/auth.php"; /**************************************************/ $interfacerec = new ArcDb(); $interfacerec->dbConStr = $globalDBCON; $interfacerec->dbType = $globalDBTP; $interfacerec->dbSchema = $globalDB; /**************************************************/ #netgroup $interfacerec->sql = "SELECT a.id_cfg_device_netgroup,a.cfg_device_netgroup from _cfg_device_netgroup a\nWHERE EXISTS (SELECT b.id_cfg_device_netgroup FROM _cfg_device_ip4netaddress b WHERE a.id_cfg_device_netgroup=b.id_cfg_device_netgroup AND b.cfg_device_ip4netaddress_enabled = 1)\norder by cfg_device_netgroup"; $interfacerec->getRec(); $listnetgroup = $interfacerec->dbData; /**************************************************/ #interfaces $interfacerec->sql = "SELECT\na.id_cfg_device_ip4netaddress,\nconcat(RTRIM(cast(inet_ntoa(a.cfg_device_ip4netaddress) as char)),'/',RTRIM(cast(a.cfg_device_ip4netaddress_nmbits as char))) as net,\na.id_cfg_device_netgroup,b.cfg_device_netgroup\nFROM _cfg_device_ip4netaddress a LEFT JOIN _cfg_device_netgroup b ON a.id_cfg_device_netgroup=b.id_cfg_device_netgroup\nWHERE a.cfg_device_ip4netaddress_enabled=1 ORDER BY a.id_cfg_device_netgroup,a.cfg_device_ip4netaddress"; $interfacerec->getRec(); $listnetworkinterfaces = $interfacerec->dbData; echo "<script type='text/javascript'>window.listNetworkInterface=" . json_encode($listnetworkinterfaces) . ";</script>"; /**************************************************/ #speedandduplex $interfacerec->sql = "SELECT id_device_ifspeedduplex,device_ifspeedduplex FROM _device_ifspeedduplex"; $interfacerec->getRec(); $listifspeedduplex = $interfacerec->dbData; /**************************************************/ #label $interfacerec->sql = "\nSELECT \na.id_device_interfacelabel,\na.device_interfacelabel \nFROM _device_interfacelabel a\nWHERE NOT EXISTS \n(SELECT b.id_device_interfacelabel \nFROM _cfg_device_interface b \nWHERE a.id_device_interfacelabel=b.id_device_interfacelabel \nAND b.id_cfg_device=" . $_POST["id_cfg_device"] . " \nAND b.cfg_device_interface_enabled=1) AND id_device=" . $_POST["id_device"];
You should have received a copy of the GNU General Public License along with this program. If not, see <http://www.gnu.org/licenses/>. */ require_once "_lib/php/auth.php"; $ajCfgDevice = null; $ajCfgDevice = isset($_POST["id_cfg_device"]) ? "&id_cfg_device=" . $_POST["id_cfg_device"] : ""; $ajCfgDevice .= isset($_POST["id_device"]) ? "&id_device=" . $_POST["id_device"] : ""; $ajCfgDevice .= isset($_POST["id_cfg"]) ? "&id_cfg=" . $_POST["id_cfg"] : ""; /**************************************************/ $netgroup = new ArcDb(); $netgroup->dbConStr = $globalDBCON; $netgroup->dbType = $globalDBTP; $netgroup->dbSchema = $globalDB; $netgroup->sql = "SELECT id_cfg_device_netgroup,cfg_device_netgroup from _cfg_device_netgroup order by cfg_device_netgroup"; $netgroup->getRec(); $listnetgroup = $netgroup->dbData; /**************************************************/ $netgroup->sql = "\nSELECT \ninet_ntoa(a.cfg_device_ip4netaddress) as \"Network\",\na.cfg_device_ip4netaddress_nmbits as \"Netmask\",\na.id_cfg_device_netgroup,\nb.cfg_device_netgroup\nFROM _cfg_device_ip4netaddress a\nINNER JOIN _cfg_device_netgroup b\nON a.id_cfg_device_netgroup=b.id_cfg_device_netgroup \nWHERE cfg_device_ip4netaddress_enabled=1"; $netgroup->getRec(); $listnetwork = $netgroup->dbData; echo "<script type='text/javascript'>window.listNetwork=" . json_encode($listnetwork) . ";</script>"; /**************************************************/ $buttonAdd = '<div class="elementIconBox" onclick="prepSaveChanges(\'frmNetGroup\')"><i class="fa fa-plus"></i></div>'; $mnunetgroup = array(array(array("Network Group", "cfg_device_netgroup", "class=\"elementIcon\"", 0, null, null, null, $buttonAdd, null, 'Network Group'))); /**************************************************/ ?> <legend> Add Network Group </legend> <form name="frmNetGroup" id="frmNetGroup" method="post" action="javascript:submitFrmVals('fs_network_groups','/_mod/smod_18/sql.php','cfg_device_netgroup','<?php
} switch ($arcCon->dbType) { case "mysql": $arcCon->dbSchema = "information_schema"; $sql = "SELECT TABLE_SCHEMA as `Schema`,TABLE_NAME as `Table`,COLUMN_NAME as `Column`,DATA_TYPE as `Type` FROM COLUMNS WHERE TABLE_SCHEMA='" . $arcCon->oCon . "' ORDER BY TABLE_NAME,COLUMN_NAME"; break; case "mssql": $sql = "SELECT TABLE_SCHEMA as [Schema],TABLE_NAME as [Table],COLUMN_NAME as [Column],DATA_TYPE as [Type] FROM INFORMATION_SCHEMA.COLUMNS ORDER BY TABLE_NAME,COLUMN_NAME"; $arcCon->recOrderCol = "[Column]"; break; case "pgsql": $sql = "SELECT TABLE_Catalog as \"Database Schema\",TABLE_SCHEMA as \"Table Schema\",TABLE_NAME as \"Table\",COLUMN_NAME as \"Column\",DATA_TYPE as \"Type\" FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA='" . $arcCon->dbCatalog . "' AND TABLE_CATALOG='" . $arcCon->oCon . "' ORDER BY TABLE_NAME,COLUMN_NAME"; break; } $arcCon->sql = $sql; $arcCon->getRec(); $schemaCols = $arcCon->dbData; $schemaColsList = ""; for ($i = 0; $i < count($schemaCols); $i++) { $next = $i + 1; $prev = $i - 1; if ($i == 0 || $schemaCols[$i][1] != $schemaCols[$prev][1]) { $topLevel = '<ul class="fa-ul"><li onclick="toggleChild(this)"><i class="fa-li fa fa-chevron-circle-up"></i>' . $schemaCols[$i][1] . '</li>'; $subLevelTop = '<ul style="display:none" class="childlist">'; $closeTopLevel = ''; $closeSubLevel = ''; } else { $topLevel = ''; $subLevelTop = ''; } if ($i == count($schemaCols) - 1 || $schemaCols[$i][1] != $schemaCols[$next][1]) {
public function getSchemata($dbType, $dbSchema, $dbTable, $dbCon = null, $dbConStr = null, $dbCatalog = null) { switch ($dbType) { case "mysql": $sql = "SELECT COLUMN_NAME,DATA_TYPE,ORDINAL_POSITION FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA='" . $dbSchema . "' AND TABLE_NAME='" . $dbTable . "';"; break; case "mssql": $sql = "SELECT COLUMN_NAME,DATA_TYPE,ORDINAL_POSITION FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='" . $dbTable . "';"; break; case "pgsql": $sql = "SELECT COLUMN_NAME,DATA_TYPE,ORDINAL_POSITION FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='" . $dbTable . "';"; $dbSchema = "information_schema"; break; } $dbCatalogInsert = !is_null($dbCatalog) ? ",dbCatalog=" . $dbCatalog : ""; $schDbo = new ArcDb(); $schDbo->sql = $sql; $schDbo->dbConStr = $dbConStr; $schDbo->dbSettings = "dbSchema=" . $dbSchema . ",dbType=" . $dbType . ",dbCon=" . $dbCon . $dbCatalogInsert; $schDbo->getRec(); $schemadata = $schDbo->dbData; $this->primaryKey = $schemadata[0][0]; return $schemadata; }
case "frmConfig,insert": $dbo->dbTable = "_cfg"; $dbo->insertRec(); $_POST['id_cfg'] = $dbo->insertedID; include "edit.php"; break; case "frmConfig,edit": $dbo->dbTable = "_cfg"; $dbo->updateRec("id_cfg=" . $_POST["id_cfg"]); include "edit.php"; break; case "frmConfig,delete": $dbo->dbTable = "_cfg"; $dbo->deleteRec("id_cfg=" . $_POST["id_cfg"]); $dbo->sql = "SELECT id_cfg_device FROM _cfg_device WHERE id_cfg=" . $_POST["id_cfg"]; $dbo->getRec(); $devices = $dbo->dbData; $dbo->dbTable = "_cfg_device_interface"; foreach ($devices as $record => $cols) { $dbo->deleteRec("id_cfg_cdevice=" . $cols[0]); } $dbo->dbTable = "_cfg_device"; $dbo->deleteRec("id_cfg=" . $_POST["id_cfg"]); include "index.php"; break; # frmDevice # frmDevice case "frmDevice,insert": $dbo->dbTable = "_cfg_device"; $dbo->insertRec(); $_POST['id_cfg_device'] = $dbo->insertedID;
* @dependency ArcCore-13.3.0.0.php * @dependency ArcDb-13.3.0.0.php * @dependency ArcTbl-13.3.0.0.php * @dependency ArcDbFilter.php * @dependency auth.php (Contains references for preceding *.php) * * */ require_once "_lib/php/auth.php"; /* define database */ $ip = new ArcDb(); $ip->dbConStr = $globalDBCON; $ip->dbType = $globalDBTP; $ip->dbSchema = $globalDB; /* return all interfaces with the same address */ $ip->sql = "\nSELECT\nid_cfg_device_interface,\nid_cfg_device_ip4netaddress,\na.id_cfg_device,\na.id_device_interfacelabel,\nid_device_ifspeedduplex,\ncfg_device_interface_ip4hostaddress,\ncfg_device_interface_enabled,\nd.device,\ne.cfg,\nc.device_interfacelabel\nFROM\n_cfg_device_interface a\nINNER JOIN\n_cfg_device b \nON a.id_cfg_device=b.id_cfg_device\nINNER JOIN\n_device_interfacelabel c \nON a.id_device_interfacelabel=c.id_device_interfacelabel\nINNER JOIN\n_device d \nON b.id_device=d.id_device\nINNER JOIN\n_cfg e \nON b.id_cfg=e.id_cfg\nWHERE\ncfg_device_interface_enabled=1\nAND cfg_device_interface_ip4hostaddress=" . $_POST["cfg_device_interface_ip4hostaddress"]; $ip->getRec(); if ($ip->dbRows > 0) { $existingInterfaceAssignments = $ip->getAssociative(); } else { die('<script>prepSaveChanges("' . $_POST["form"] . '")</script>'); } /* evaluate returned results */ if (count($existingInterfaceAssignments) > 0) { /* matches were found */ /* * search array for network id passed via POST */ $netIsDefined = multiArraySearch($existingInterfaceAssignments, $_POST["id_cfg_device_ip4netaddress"]); if ($netIsDefined !== false) { $errorMsg = long2ip($_POST["cfg_device_interface_ip4hostaddress"]) . " already exists."; $errorMsg .= "</br> The address is assigned to the following device interface."; $errorMsg .= "<pre>" . print_r($existingInterfaceAssignments[$netIsDefined], true) . "</pre>"; } else {