=========================================================== .___ __ __ _________________ __ __ __| _/|__|/ |_ / ___\_` __ \__ \ | | \/ __ | | \\_ __\ / /_/ > | \// __ \| | / /_/ | | || | \___ /|__| (____ /____/\____ | |__||__| /_____/ \/ \/ grep rough audit - static analysis tool v2.8 written by @Wireghoul =================================[justanotherhacker.com]=== icingaweb2-module-nagvis-1.1.1/library/nagvis-includes/GlobalBackendicingaweb2.php-83- // Do some checks to make sure that Nagios is running and the Data at the DB is ok icingaweb2-module-nagvis-1.1.1/library/nagvis-includes/GlobalBackendicingaweb2.php:84: $QUERYHANDLE = $this->mysqlQuery('SELECT is_currently_running, UNIX_TIMESTAMP(status_update_time) AS status_update_time FROM '.$this->dbPrefix.'programstatus WHERE instance_id='.$this->dbInstanceId); icingaweb2-module-nagvis-1.1.1/library/nagvis-includes/GlobalBackendicingaweb2.php-85- $nagiosstate = mysql_fetch_array($QUERYHANDLE); ############################################## icingaweb2-module-nagvis-1.1.1/library/nagvis-includes/GlobalBackendicingaweb2.php-207- icingaweb2-module-nagvis-1.1.1/library/nagvis-includes/GlobalBackendicingaweb2.php:208: $QUERYHANDLE = $this->mysqlQuery('SELECT name1,name2 FROM '.$this->dbPrefix.'objects WHERE objecttype_id='.$objectType.' AND '.$filter.$isActiveFilter.' instance_id='.$this->dbInstanceId.' ORDER BY name1'); icingaweb2-module-nagvis-1.1.1/library/nagvis-includes/GlobalBackendicingaweb2.php-209- while($data = mysql_fetch_array($QUERYHANDLE)) { ############################################## icingaweb2-module-nagvis-1.1.1/library/nagvis-includes/GlobalBackendicingaweb2.php-259- private function checkConfigTypeObjects() { icingaweb2-module-nagvis-1.1.1/library/nagvis-includes/GlobalBackendicingaweb2.php:260: if(mysql_num_rows($this->mysqlQuery('SELECT host_id FROM '.$this->dbPrefix.'hosts WHERE config_type=1 AND instance_id='.$this->dbInstanceId.' LIMIT 1')) > 0) { icingaweb2-module-nagvis-1.1.1/library/nagvis-includes/GlobalBackendicingaweb2.php-261- return TRUE; ############################################## icingaweb2-module-nagvis-1.1.1/library/nagvis-includes/GlobalBackendicingaweb2.php-368- FROM '.$this->dbPrefix.'objects AS o,'.$this->dbPrefix.'hoststatus AS h icingaweb2-module-nagvis-1.1.1/library/nagvis-includes/GlobalBackendicingaweb2.php:369: WHERE (o.objecttype_id=1 AND o.name1 = binary \''.$hostName.'\' AND o.instance_id='.$this->dbInstanceId.') AND h.host_object_id=o.object_id LIMIT 1'); icingaweb2-module-nagvis-1.1.1/library/nagvis-includes/GlobalBackendicingaweb2.php-370- ############################################## icingaweb2-module-nagvis-1.1.1/library/nagvis-includes/GlobalBackendicingaweb2.php-985- FROM icingaweb2-module-nagvis-1.1.1/library/nagvis-includes/GlobalBackendicingaweb2.php:986: `'.$this->dbPrefix.'objects` AS o1, icingaweb2-module-nagvis-1.1.1/library/nagvis-includes/GlobalBackendicingaweb2.php:987: `'.$this->dbPrefix.'hosts` AS h1 icingaweb2-module-nagvis-1.1.1/library/nagvis-includes/GlobalBackendicingaweb2.php:988: LEFT OUTER JOIN `'.$this->dbPrefix.'host_parenthosts` AS ph1 ON h1.host_id=ph1.host_id icingaweb2-module-nagvis-1.1.1/library/nagvis-includes/GlobalBackendicingaweb2.php-989- WHERE o1.objecttype_id=1 ############################################## icingaweb2-module-nagvis-1.1.1/library/nagvis-includes/GlobalBackendicingaweb2.php-1017- FROM icingaweb2-module-nagvis-1.1.1/library/nagvis-includes/GlobalBackendicingaweb2.php:1018: `'.$this->dbPrefix.'objects` AS o1, icingaweb2-module-nagvis-1.1.1/library/nagvis-includes/GlobalBackendicingaweb2.php:1019: `'.$this->dbPrefix.'hosts` AS h1, icingaweb2-module-nagvis-1.1.1/library/nagvis-includes/GlobalBackendicingaweb2.php:1020: `'.$this->dbPrefix.'host_parenthosts` AS ph1, icingaweb2-module-nagvis-1.1.1/library/nagvis-includes/GlobalBackendicingaweb2.php:1021: `'.$this->dbPrefix.'objects` AS o2 icingaweb2-module-nagvis-1.1.1/library/nagvis-includes/GlobalBackendicingaweb2.php:1022: WHERE o1.objecttype_id=1 AND o1.name1=\''.$hostName.'\' icingaweb2-module-nagvis-1.1.1/library/nagvis-includes/GlobalBackendicingaweb2.php-1023- AND (h1.config_type='.$this->objConfigType.' AND h1.instance_id='.$this->dbInstanceId.' AND h1.host_object_id=o1.object_id) ############################################## icingaweb2-module-nagvis-1.1.1/library/nagvis-includes/GlobalBackendicingaweb2.php-1049- FROM icingaweb2-module-nagvis-1.1.1/library/nagvis-includes/GlobalBackendicingaweb2.php:1050: `'.$this->dbPrefix.'objects` AS o1, icingaweb2-module-nagvis-1.1.1/library/nagvis-includes/GlobalBackendicingaweb2.php:1051: `'.$this->dbPrefix.'hosts` AS h1, icingaweb2-module-nagvis-1.1.1/library/nagvis-includes/GlobalBackendicingaweb2.php:1052: `'.$this->dbPrefix.'host_parenthosts` AS ph1, icingaweb2-module-nagvis-1.1.1/library/nagvis-includes/GlobalBackendicingaweb2.php:1053: `'.$this->dbPrefix.'hosts` AS h2, icingaweb2-module-nagvis-1.1.1/library/nagvis-includes/GlobalBackendicingaweb2.php:1054: `'.$this->dbPrefix.'objects` AS o2 icingaweb2-module-nagvis-1.1.1/library/nagvis-includes/GlobalBackendicingaweb2.php:1055: WHERE o1.objecttype_id=1 AND o1.name1=\''.$hostName.'\' icingaweb2-module-nagvis-1.1.1/library/nagvis-includes/GlobalBackendicingaweb2.php-1056- AND (h1.config_type='.$this->objConfigType.' AND h1.instance_id='.$this->dbInstanceId.' AND h1.host_object_id=o1.object_id) ############################################## icingaweb2-module-nagvis-1.1.1/library/nagvis-includes/GlobalBackendicingaweb2.php-1230- $QUERYHANDLE = $this->mysqlQuery('SELECT UNIX_TIMESTAMP(program_start_time) AS program_start ' icingaweb2-module-nagvis-1.1.1/library/nagvis-includes/GlobalBackendicingaweb2.php:1231: .'FROM '.$this->dbPrefix.'programstatus WHERE instance_id='.$this->dbInstanceId); icingaweb2-module-nagvis-1.1.1/library/nagvis-includes/GlobalBackendicingaweb2.php-1232- $data = mysql_fetch_array($QUERYHANDLE);