| /dports/net-mgmt/nagiosql/nagiosql-365d4e0b5edc623b12ea96e8002e8ac66aad6aac/functions/ |
| H A D | NagImportClass.php | 368 $strSQL1,
382 $strSQL1,
791 * @param string $strSQL1 SQL statement part 1
802 &$strSQL1, argument
815 $strSQL1 = 'UPDATE `' .$strTable. '` SET ';
843 $strSQL1 = 'INSERT INTO `' .$strTable."` SET $test";
878 $strSQL1 .= '`command_type` = 1,';
880 $strSQL1 .= '`command_type` = 2,';
1089 $strSQL1 .= '`' . $elem['key'] . "` = 'null',";
1123 $strSQL1 .= '`' . $elem['key'] . '` = 3,';
[all …]
|
| H A D | NagConfigClass.php | 120 $strSQL1 = "SELECT DATE_FORMAT(`last_modified`,'%Y-%m-%d %H:%i:%s') FROM `tbl_host` ".
124 $arrTimeData['table'] = $this->myDBClass->getFieldData($strSQL1);
127 … $strSQL1 = "SELECT DATE_FORMAT(`last_modified`,'%Y-%m-%d %H:%i:%s') FROM `tbl_service` ".
131 $arrTimeData['table'] = $this->myDBClass->getFieldData($strSQL1);
|
| /dports/net-mgmt/nagiosql/nagiosql-365d4e0b5edc623b12ea96e8002e8ac66aad6aac/admin/ |
| H A D | servicetemplates.php | 300 … $strSQL1 = 'INSERT INTO `tbl_variabledefinition` (`name`,`value`,`last_modified`) ' variable
302 $intReturn1 = $myDataClass->dataInsert($strSQL1, $intInsertId);
349 $strSQL1 = "SELECT `id`, `$preKeyField`, `active` FROM `$preTableName` " variable
351 $booReturn1 = $myDBClass->hasDataArray($strSQL1, $arrDataTpl, $intDataCountTpl);
650 $strSQL1 = "SELECT count(*) AS `number` FROM `$preTableName` " variable
652 $booReturn1 = $myDBClass->hasSingleDataset($strSQL1, $arrDataLinesCount);
|
| H A D | services.php | 343 … $strSQL1 = 'DELETE FROM `tbl_lnkServiceToVariabledefinition` WHERE `idMaster`=' .$chkDataId; variable
344 $intReturn1 = $myDataClass->dataInsert($strSQL1, $intInsertId);
419 $strSQL1 = 'SELECT `id`,`template_name`, `active` FROM `tbl_servicetemplate` ' variable
421 $booReturn1 = $myDBClass->hasDataArray($strSQL1, $arrDataTpl, $intDataCountTpl);
728 …$strSQL1 = "SELECT DISTINCT `$preKeyField` FROM `$preTableName` WHERE $strDomainWhere ORDER BY … variable
729 $booReturn1 = $myDBClass->hasDataArray($strSQL1, $arrDataConfig, $intDataCount);
|
| H A D | hosttemplates.php | 303 $strSQL1 = "SELECT `id`,`$preKeyField`, `active` FROM `$preTableName` " variable
305 $booReturn1 = $myDBClass->hasDataArray($strSQL1, $arrDataTpl, $intDataCountTpl);
566 …$strSQL1 = "SELECT count(*) AS `number` FROM `$preTableName` WHERE $strDomainWhere $strSearchWh… variable
568 $booReturn1 = $myDBClass->hasSingleDataset($strSQL1, $arrDataLinesCount);
|
| H A D | hostgroups.php | 263 $strSQL1 = "SELECT count(*) AS `number` FROM `$preTableName` " variable
265 $booReturn1 = $myDBClass->hasSingleDataset($strSQL1, $arrDataLinesCount);
|
| H A D | servicegroups.php | 265 …$strSQL1 = "SELECT count(*) AS `number` FROM `$preTableName` WHERE $strDomainWhere $strSearchWh… variable
267 $booReturn1 = $myDBClass->hasSingleDataset($strSQL1, $arrDataLinesCount);
|
| H A D | hosts.php | 361 … $strSQL1 = 'INSERT INTO `tbl_lnkServiceToHost` (`idMaster`,`idSlave`,`exclude`) ' variable
363 $intReturn1 = $myDataClass->dataInsert($strSQL1, $intInsertId);
413 $strSQL1 = 'SELECT `id`,`template_name`, `active` ' . variable
415 $booReturn1 = $myDBClass->hasDataArray($strSQL1, $arrDataTpl, $intDataCountTpl);
|
| H A D | contacts.php | 195 … $strSQL1 = "SELECT * FROM `tbl_lnkContactToVariabledefinition` WHERE `idMaster`=$chkDataId"; variable
196 $booReturn = $myDBClass->hasDataArray($strSQL1, $arrData, $intDataCount);
|
| H A D | contacttemplates.php | 273 $strSQL1 = "SELECT `id`,`$preKeyField`, `active` FROM `$preTableName` " variable
275 $booReturn1 = $myDBClass->hasDataArray($strSQL1, $arrDataTpl, $intDataCountTpl);
|
| H A D | verify.php | 52 $strSQL1 = "SELECT `id` FROM `tbl_host` WHERE `config_id` = $chkDomainId AND `active`='1'"; variable
53 $myDBClass->hasDataArray($strSQL1, $arrData, $intDataCount);
|
| /dports/net-mgmt/nagiosql/nagiosql-365d4e0b5edc623b12ea96e8002e8ac66aad6aac/install/functions/ |
| H A D | NagInstallClass.php | 772 $strSQL1 = 'SELECT `value` FROM `tbl_settings` '
776 $intCount = $this->myDBClass->countRows($strSQL1);
1045 $strSQL1 = 'SHOW TABLES FROM `' .$this->arrSession['install']['dbname']. '`';
1046 $booReturn = $this->myDBClass->hasDataArray($strSQL1, $arrDataset1, $intDataCount1);
|