Home
last modified time | relevance | path

Searched refs:preTableName (Results 1 – 23 of 23) sorted by relevance

/dports/net-mgmt/nagiosql/nagiosql-365d4e0b5edc623b12ea96e8002e8ac66aad6aac/admin/
H A Dserviceextinfo.php31 $preTableName = 'tbl_serviceextinfo'; variable
62 $myDataClass->updateStatusTable($preTableName);
74 $booReturn = $myDataClass->updateHash($preTableName, $chkDataId);
96 $intReturn = $myConfigClass->lastModifiedFile($preTableName, $arrTimeData, $strTimeInfoString);
225 $strOrderString = "ORDER BY `$preTableName`.`config_id`, `$preKeyField` $hidSortDir";
230 $strSQL = "SELECT count(*) AS `number` FROM `$preTableName` "
231 . "LEFT JOIN `tbl_host` ON `$preTableName`.`$preKeyField` = `tbl_host`.`id` "
232 . "LEFT JOIN `tbl_service` ON `$preTableName`.`service_description` = `tbl_service`.`id` "
246 …. "`$preTableName`.`notes`, `$preTableName`.`register`, `$preTableName`.`active`, `$preTableName`.…
247 . "`$preTableName`.`access_group` FROM `$preTableName` "
[all …]
H A Dhostextinfo.php30 $preTableName = 'tbl_hostextinfo'; variable
62 $myDataClass->updateStatusTable($preTableName);
87 $intReturn = $myConfigClass->lastModifiedFile($preTableName, $arrTimeData, $strTimeInfoString);
158 $strOrderString = "ORDER BY `$preTableName`.`config_id`, `$preKeyField` $hidSortDir";
160 $strOrderString = "ORDER BY `$preTableName`.`config_id`, `notes` $hidSortDir";
163 $strSQL = "SELECT count(*) AS `number` FROM `$preTableName` "
164 . "LEFT JOIN `tbl_host` ON `$preTableName`.`$preKeyField`=`tbl_host`.`id` "
177 $strSQL = "SELECT `$preTableName`.`id`, `tbl_host`.`$preKeyField`, `$preTableName`.`notes`, "
178 . "`$preTableName`.`register`, `$preTableName`.`active`, `$preTableName`.`config_id`, "
179 . "`$preTableName`.`access_group` FROM `$preTableName` "
[all …]
H A Dtimeperiods.php30 $preTableName = 'tbl_timeperiod'; variable
43 …$strSQLx = "`$preTableName` SET `$preKeyField`='$chkTfValue1', `alias`='$chkTfValue2', `exclude`=$…
60 $myDataClass->updateStatusTable($preTableName);
165 $intReturn = $myConfigClass->lastModifiedFile($preTableName, $arrTimeData, $strTimeInfoString);
183 $preTableName,
201 $preTableName,
234 $intLocked = $myDataClass->infoRelation($preTableName, $arrModifyData['id'], $preKeyField);
268 …$strSQL = "SELECT count(*) AS `number` FROM `$preTableName` WHERE $strDomainWhere $strSearchWh…
282 … . "FROM `$preTableName` WHERE $strDomainWhere $strSearchWhere AND `access_group` IN ($strAccess) "
H A Dcheckcommands.php31 $preTableName = 'tbl_command'; variable
44 … $strSQLx = "`$preTableName` SET `$preKeyField`='$chkTfValue1', `command_line`='$chkTfSpValue1', "
64 $myDataClass->updateStatusTable($preTableName);
89 $intReturn = $myConfigClass->lastModifiedFile($preTableName, $arrTimeData, $strTimeInfoString);
124 $intLocked = $myDataClass->infoRelation($preTableName, $arrModifyData['id'], $preKeyField);
164 $strSQL = "SELECT count(*) AS `number` FROM `$preTableName` "
178 . "FROM `$preTableName` WHERE $strDomainWhere $strSearchWhere "
H A Dcontactgroups.php30 $preTableName = 'tbl_contactgroup'; variable
43 …$strSQLx = "`$preTableName` SET `$preKeyField`='$chkTfValue1', `alias`='$chkTfValue2', `members`=$…
60 $myDataClass->updateStatusTable($preTableName);
138 $intReturn = $myConfigClass->lastModifiedFile($preTableName, $arrTimeData, $strTimeInfoString);
175 $preTableName,
207 $intLocked = $myDataClass->infoRelation($preTableName, $arrModifyData['id'], $preKeyField);
239 $strSQL = "SELECT count(*) AS `number` FROM `$preTableName` "
253 … . "FROM `$preTableName` WHERE $strDomainWhere $strSearchWhere AND `access_group` IN ($strAccess) "
H A Dhostgroups.php30 $preTableName = 'tbl_hostgroup'; variable
43 …$strSQLx = "`$preTableName` SET `$preKeyField`='$chkTfValue1', `alias`='$chkTfValue2', `members`=$…
61 $myDataClass->updateStatusTable($preTableName);
139 $intReturn = $myConfigClass->lastModifiedFile($preTableName, $arrTimeData, $strTimeInfoString);
178 $preTableName,
210 $intLocked = $myDataClass->infoRelation($preTableName, $arrModifyData['id'], $preKeyField);
263 $strSQL1 = "SELECT count(*) AS `number` FROM `$preTableName` "
277 . "FROM `$preTableName` WHERE $strDomainWhere $strSearchWhere AND `access_group` "
H A Dservicegroups.php30 $preTableName = 'tbl_servicegroup'; variable
43 …$strSQLx = "`$preTableName` SET `$preKeyField`='$chkTfValue1', `alias`='$chkTfValue2', `members`=$…
61 $myDataClass->updateStatusTable($preTableName);
141 $intReturn = $myConfigClass->lastModifiedFile($preTableName, $arrTimeData, $strTimeInfoString);
180 $preTableName,
212 $intLocked = $myDataClass->infoRelation($preTableName, $arrModifyData['id'], $preKeyField);
265 …$strSQL1 = "SELECT count(*) AS `number` FROM `$preTableName` WHERE $strDomainWhere $strSearchWh…
279 … . "FROM `$preTableName` WHERE $strDomainWhere $strSearchWhere AND `access_group` IN ($strAccess) "
H A Dhostescalations.php30 $preTableName = 'tbl_hostescalation'; variable
47 $strSQLx = "`$preTableName` SET `$preKeyField`='$chkTfValue1', `host_name`=$intMselValue3, "
68 $myDataClass->updateStatusTable($preTableName);
175 $booReturn = $myDataClass->updateHash($preTableName, $chkDataId);
197 $intReturn = $myConfigClass->lastModifiedFile($preTableName, $arrTimeData, $strTimeInfoString);
310 $intLocked = $myDataClass->infoRelation($preTableName, $arrModifyData['id'], $preKeyField);
346 $strSQL = "SELECT count(*) AS `number` FROM `$preTableName` "
360 … . "`access_group` FROM `$preTableName` WHERE $strDomainWhere $strSearchWhere AND `access_group` "
H A Dhostdependencies.php30 $preTableName = 'tbl_hostdependency'; variable
48 …$strSQLx = "`$preTableName` SET `$preKeyField`='$chkTfValue1', `dependent_host_name`=$intMselValue…
68 $myDataClass->updateStatusTable($preTableName);
175 $booReturn = $myDataClass->updateHash($preTableName, $chkDataId);
197 $intReturn = $myConfigClass->lastModifiedFile($preTableName, $arrTimeData, $strTimeInfoString);
306 $intLocked = $myDataClass->infoRelation($preTableName, $arrModifyData['id'], $preKeyField);
349 $strSQL = "SELECT count(*) AS `number` FROM `$preTableName` "
363 …. "`active`, `config_id`, `access_group` FROM `$preTableName` WHERE $strDomainWhere $strSearchWher…
H A Dserviceescalations.php30 $preTableName = 'tbl_serviceescalation'; variable
47 $strSQLx = "`$preTableName` SET `$preKeyField`='$chkTfValue1', `host_name`=$intMselValue1, "
69 $myDataClass->updateStatusTable($preTableName);
226 $booReturn = $myDataClass->updateHash($preTableName, $chkDataId);
248 $intReturn = $myConfigClass->lastModifiedFile($preTableName, $arrTimeData, $strTimeInfoString);
534 $intLocked = $myDataClass->infoRelation($preTableName, $arrModifyData['id'], $preKeyField);
571 $strSQL = "SELECT count(*) AS `number` FROM `$preTableName` "
585 …. "`access_group` FROM `$preTableName` WHERE $strDomainWhere $strSearchWhere AND `access_group` IN…
H A Dcontacts.php30 $preTableName = 'tbl_contact'; variable
53 $strSQLx = "`$preTableName` SET `$preKeyField`='$chkTfValue1', `alias`='$chkTfValue2', "
82 $myDataClass->updateStatusTable($preTableName);
252 $intReturn = $myConfigClass->lastModifiedFile($preTableName, $arrTimeData, $strTimeInfoString);
291 … . "FROM `$preTableName` WHERE `name` <> '' $strWhere AND $strDomainWhere ORDER BY `name`";
417 $intLocked = $myDataClass->infoRelation($preTableName, $arrModifyData['id'], $preKeyField);
475 … . "FROM `$preTableName` WHERE $strDomainWhere $strSearchWhere AND `access_group` IN ($strAccess)";
488 . "FROM `$preTableName` WHERE $strDomainWhere $strSearchWhere AND `access_group` "
H A Dcontacttemplates.php30 $preTableName = 'tbl_contacttemplate'; variable
53 $strSQLx = "`$preTableName` SET `$preKeyField`='$chkTfValue1', `alias`='$chkTfValue2', "
82 $myDataClass->updateStatusTable($preTableName);
257 $intReturn = $myConfigClass->lastModifiedFile($preTableName, $arrTimeData, $strTimeInfoString);
273 $strSQL1 = "SELECT `id`,`$preKeyField`, `active` FROM `$preTableName` "
416 $intLocked = $myDataClass->infoRelation($preTableName, $arrModifyData['id'], $preKeyField);
473 … . "FROM `$preTableName` WHERE $strDomainWhere $strSearchWhere AND `access_group` IN ($strAccess)";
486 … . "FROM `$preTableName` WHERE $strDomainWhere $strSearchWhere AND `access_group` IN ($strAccess) "
H A Ddatadomain.php29 $preTableName = 'tbl_datadomain'; variable
45 …$strSQLx = "`$preTableName` SET `$preKeyField`='$chkTfValue1', `alias`='$chkTfValue2', `targets`=$…
159 …$strSQL = "SELECT count(*) AS `number` FROM `$preTableName` WHERE `access_group` IN ($strAcces…
172 . "FROM `$preTableName` WHERE `access_group` IN ($strAccess) $strOrderString "
H A Dgroup.php30 $preTableName = 'tbl_group'; variable
45 …$strSQLx = "`$preTableName` SET `groupname`='$chkTfValue1', `description`='$chkTfValue2', `active`…
174 $strSQL = "SELECT count(*) AS `number` FROM `$preTableName`";
187 … . "FROM `$preTableName` $strOrderString LIMIT $chkLimit,".$SETS['common']['pagelines'];
H A Dservices.php30 $preTableName = 'tbl_service'; variable
63 $strSQLx = "`$preTableName` SET `$preKeyField`='$chkTfValue1', `host_name`=$intMselValue1, "
246 $intServiceCount = $myDBClass->countRows("SELECT * FROM `$preTableName` "
277 $intServiceCount = $myDBClass->countRows("SELECT * FROM `$preTableName` "
388 $intReturn = $myDataClass->updateHash($preTableName, $chkDataId);
441 $strSQL2 = "SELECT `id`, `name`, `active` FROM `$preTableName` "
512 $preTableName,
652 $intLocked = $myDataClass->infoRelation($preTableName, $arrModifyData['id'], $preKeyField);
728 …$strSQL1 = "SELECT DISTINCT `$preKeyField` FROM `$preTableName` WHERE $strDomainWhere ORDER BY …
781 …$strSQL2 = "SELECT count(*) AS `number` FROM `$preTableName` WHERE $strDomainWhere $strSearchWh…
[all …]
H A Duser.php30 $preTableName = 'tbl_user'; variable
58 …$strSQLx = "`$preTableName` SET `$preKeyField`='$chkTfValue1', `alias`='$chkTfValue2', $strPasswd "
185 $strSQL = "SELECT count(*) AS `number` FROM `$preTableName`";
198 … . "FROM `$preTableName` $strOrderString LIMIT $chkLimit,".$SETS['common']['pagelines'];
H A Dservicetemplates.php30 $preTableName = 'tbl_servicetemplate'; variable
58 $strSQLx = "`$preTableName` SET `$preKeyField`='$chkTfValue1', `host_name`=$intMselValue1, "
95 $myDataClass->updateStatusTable($preTableName);
333 $intReturn = $myConfigClass->lastModifiedFile($preTableName, $arrTimeData, $strTimeInfoString);
349 $strSQL1 = "SELECT `id`, `$preKeyField`, `active` FROM `$preTableName` "
436 $preTableName,
556 $intLocked = $myDataClass->infoRelation($preTableName, $arrModifyData['id'], $preKeyField);
650 $strSQL1 = "SELECT count(*) AS `number` FROM `$preTableName` "
664 … . "`config_id`, `access_group` FROM `$preTableName` WHERE $strDomainWhere $strSearchWhere "
H A Dhosttemplates.php30 $preTableName = 'tbl_hosttemplate'; variable
59 …$strSQLx = "`$preTableName` SET `$preKeyField`='$chkTfValue1', `alias`='$chkTfValue2', `parents`=$…
94 $myDataClass->updateStatusTable($preTableName);
287 $intReturn = $myConfigClass->lastModifiedFile($preTableName, $arrTimeData, $strTimeInfoString);
303 $strSQL1 = "SELECT `id`,`$preKeyField`, `active` FROM `$preTableName` "
474 $intLocked = $myDataClass->infoRelation($preTableName, $arrModifyData['id'], $preKeyField);
566 …$strSQL1 = "SELECT count(*) AS `number` FROM `$preTableName` WHERE $strDomainWhere $strSearchWh…
580 … . "`access_group` FROM `$preTableName` WHERE $strDomainWhere $strSearchWhere AND `access_group` "
H A Dservicedependencies.php30 $preTableName = 'tbl_servicedependency'; variable
48 …$strSQLx = "`$preTableName` SET `dependent_host_name`=$intMselValue2, `dependent_hostgroup_name`=$…
70 $myDataClass->updateStatusTable($preTableName);
283 $booReturn = $myDataClass->updateHash($preTableName, $chkDataId);
305 $intReturn = $myConfigClass->lastModifiedFile($preTableName, $arrTimeData, $strTimeInfoString);
677 $intLocked = $myDataClass->infoRelation($preTableName, $arrModifyData['id'], $preKeyField);
720 $strSQL = "SELECT count(*) AS `number` FROM `$preTableName` "
734 … . "`access_group` FROM `$preTableName`WHERE $strDomainWhere $strSearchWhere AND `access_group` "
H A Dhosts.php30 $preTableName = 'tbl_host'; variable
63 $strSQLx = "`$preTableName` SET `$preKeyField`='$chkTfValue1', `alias`='$chkTfValue3', "
436 … . "FROM `$preTableName` WHERE `name` <> '' $strWhere AND $strDomainWhere ORDER BY `name`";
469 $preTableName,
618 $intLocked = $myDataClass->infoRelation($preTableName, $arrModifyData['id'], $preKeyField);
721 …$strSQL = "SELECT count(*) AS `number` FROM `$preTableName` WHERE $strDomainWhere $strSearchWh…
735 … . "`access_group` FROM `$preTableName` WHERE $strDomainWhere $strSearchWhere AND `access_group` "
H A Dconfigtargets.php29 $preTableName = 'tbl_configtarget'; variable
130 …$strSQLx = "`$preTableName` SET `$preKeyField`='$chkTfValue1', `alias`='$chkTfValue2', `server`='$…
326 …$strSQL = "SELECT count(*) AS `number` FROM `$preTableName` WHERE `access_group` IN ($strAcces…
339 . "FROM `$preTableName` WHERE `access_group` IN ($strAccess) $strOrderString "
/dports/net-mgmt/nagiosql/nagiosql-365d4e0b5edc623b12ea96e8002e8ac66aad6aac/functions/
H A Dprepend_content.php32 if (!isset($preTableName)) {
33 $preTableName = ''; variable
46 $myContentClass->strTableName = $preTableName;
264 if ($preTableName == 'tbl_host') {
293 } elseif ($preTableName == 'tbl_service') {
335 if ($preTableName == 'tbl_service') {
348 } elseif ((($preTableName == 'tbl_datadomain') || ($preTableName == 'tbl_configtarget')) &&
352 } elseif (($preTableName == 'tbl_user') || ($preTableName == 'tbl_datadomain') ||
357 if ($preTableName == 'tbl_service') {
400 if ($preTableName == 'tbl_host') {
[all …]
H A Dprepend_adm.php661 if (isset($preTableName)) {
663 …$strDomainWhere = " (`$preTableName`.`config_id`=$chkDomainId OR `$preTableName`.`config_id`=0) ";
666 $strDomainWhere = " (`$preTableName`.`config_id`=$chkDomainId) ";