===========================================================
.___ __ __
_________________ __ __ __| _/|__|/ |_
/ ___\_` __ \__ \ | | \/ __ | | \\_ __\
/ /_/ > | \// __ \| | / /_/ | | || |
\___ /|__| (____ /____/\____ | |__||__|
/_____/ \/ \/
grep rough audit - static analysis tool
v2.8 written by @Wireghoul
=================================[justanotherhacker.com]===
homer-api-5.0.6+dfsg2/api/Authentication/External.php-87- curl_setopt($ch, CURLOPT_CUSTOMREQUEST, strtoupper(EXTERNAL_AUTH_METHOD));
homer-api-5.0.6+dfsg2/api/Authentication/External.php:88: $result = curl_exec($ch);
homer-api-5.0.6+dfsg2/api/Authentication/External.php-89- $info = curl_getinfo($ch);
##############################################
homer-api-5.0.6+dfsg2/api/Authentication/Internal.php-84-
homer-api-5.0.6+dfsg2/api/Authentication/Internal.php:85: $query = $mydb->makeQuery("SELECT * FROM ".$layer->getTableName($this->user_table)." WHERE ".$this->user_column."='?' AND ".$this->pass_column." = ".$layer->getPassword($param['password'], $this->pass_column).";" , $param['username']);
homer-api-5.0.6+dfsg2/api/Authentication/Internal.php-86- $rows = $mydb->loadObjectList($query);
##############################################
homer-api-5.0.6+dfsg2/api/Authentication/Internal.php-97- //update lastvisit
homer-api-5.0.6+dfsg2/api/Authentication/Internal.php:98: $query = "UPDATE ".$layer->getTableName($this->user_table)." SET lastvisit = NOW() WHERE ".$this->id_column."='".$row->uid."'";
homer-api-5.0.6+dfsg2/api/Authentication/Internal.php-99- $mydb->executeQuery($query);
##############################################
homer-api-5.0.6+dfsg2/api/Authentication/Internal.php-126-
homer-api-5.0.6+dfsg2/api/Authentication/Internal.php:127: $query = $mydb->makeQuery("SELECT id, userobject FROM api_auth_key WHERE authkey = '?' AND NOW() BETWEEN `startdate` AND `stopdate` AND (source_ip = '0.0.0.0' OR source_ip = '?') AND enable = 1;" , $authkey, $ip);
homer-api-5.0.6+dfsg2/api/Authentication/Internal.php-128- $rows = $mydb->loadObjectList($query);
##############################################
homer-api-5.0.6+dfsg2/api/Authentication/Internal.php-139-
homer-api-5.0.6+dfsg2/api/Authentication/Internal.php:140: $query = "UPDATE userobject SET lastvisit = NOW() WHERE id=".$data->id;
homer-api-5.0.6+dfsg2/api/Authentication/Internal.php-141- $mydb->executeQuery($query);
##############################################
homer-api-5.0.6+dfsg2/api/Authentication/Internal.php-190-
homer-api-5.0.6+dfsg2/api/Authentication/Internal.php:191: $query = $mydb->makeQuery("SELECT uid, gid, username, `grp`, firstname, lastname, email, lastvisit,department FROM ".$layer->getTableName($this->user_table)." WHERE ".$this->id_column." = ? limit 1;", $_SESSION['loggedin']);
homer-api-5.0.6+dfsg2/api/Authentication/Internal.php-192- $rows = $mydb->loadObjectList($query);
##############################################
homer-api-5.0.6+dfsg2/api/Authentication/Internal.php-235- $exten = "";
homer-api-5.0.6+dfsg2/api/Authentication/Internal.php:236: $callwhere = generateWhere($update, 1, $mydb, 0);
homer-api-5.0.6+dfsg2/api/Authentication/Internal.php-237- if(count($callwhere)) {
##############################################
homer-api-5.0.6+dfsg2/api/Authentication/Internal.php-241-
homer-api-5.0.6+dfsg2/api/Authentication/Internal.php:242: $query = $mydb->makeQuery("UPDATE ".$layer->getTableName($this->user_table)." SET ".$exten. " WHERE ".$this->id_column." = ? limit 1;", $_SESSION['loggedin']);
homer-api-5.0.6+dfsg2/api/Authentication/Internal.php-243- $mydb->executeQuery($query);
##############################################
homer-api-5.0.6+dfsg2/api/Authentication/Internal.php-258- //update database with new password
homer-api-5.0.6+dfsg2/api/Authentication/Internal.php:259: $query = "UPDATE ".$layer->getTableName($this->user_table)." SET ".$this->pass_column."=".$layer->setPassword($newpassword)." WHERE ".$this->user_column."='".stripslashes($username)."'";
homer-api-5.0.6+dfsg2/api/Authentication/Internal.php-260-
##############################################
homer-api-5.0.6+dfsg2/api/Database/Layer/mysql.php-57-
homer-api-5.0.6+dfsg2/api/Database/Layer/mysql.php:58: $callwhere = $layerHelper['where']['param'];
homer-api-5.0.6+dfsg2/api/Database/Layer/mysql.php-59-
##############################################
homer-api-5.0.6+dfsg2/api/Database/Layer/mysql.php-125- $values = implode(",", $layerHelper['values']);
homer-api-5.0.6+dfsg2/api/Database/Layer/mysql.php:126: $callwhere = $layerHelper['where']['param'];
homer-api-5.0.6+dfsg2/api/Database/Layer/mysql.php-127-
##############################################
homer-api-5.0.6+dfsg2/api/Database/Layer/pgsql.php-58-
homer-api-5.0.6+dfsg2/api/Database/Layer/pgsql.php:59: $callwhere = $layerHelper['where']['param'];
homer-api-5.0.6+dfsg2/api/Database/Layer/pgsql.php-60-
##############################################
homer-api-5.0.6+dfsg2/api/Database/Layer/pgsql.php-124- $values = implode(",", $layerHelper['values']);
homer-api-5.0.6+dfsg2/api/Database/Layer/pgsql.php:125: $callwhere = $layerHelper['where']['param'];
homer-api-5.0.6+dfsg2/api/Database/Layer/pgsql.php-126-
##############################################
homer-api-5.0.6+dfsg2/api/Database/Layer/sqlite.php-55- }
homer-api-5.0.6+dfsg2/api/Database/Layer/sqlite.php:56: $callwhere = $layerHelper['where']['param'];
homer-api-5.0.6+dfsg2/api/Database/Layer/sqlite.php-57-
##############################################
homer-api-5.0.6+dfsg2/api/Database/Layer/sqlite.php-138- $values = implode(",", $layerHelper['values']);
homer-api-5.0.6+dfsg2/api/Database/Layer/sqlite.php:139: $callwhere = $layerHelper['where']['param'];
homer-api-5.0.6+dfsg2/api/Database/Layer/sqlite.php-140-
##############################################
homer-api-5.0.6+dfsg2/api/Database/PDOConnector.php-149- function executeQuery($query) {
homer-api-5.0.6+dfsg2/api/Database/PDOConnector.php:150: //$result = mysql_query($query);
homer-api-5.0.6+dfsg2/api/Database/PDOConnector.php-151- if(DATABASE_DRIVER == 'pgsql') $query = $this->toPgSql($query);
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Admin.php-147- $exten = "";
homer-api-5.0.6+dfsg2/api/RestApi/Admin.php:148: $callwhere = generateWhere($update, 1, $db, 0);
homer-api-5.0.6+dfsg2/api/RestApi/Admin.php-149-
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Admin.php-156- //$exten .= implode(", ", $callwhere);
homer-api-5.0.6+dfsg2/api/RestApi/Admin.php:157: foreach($callwhere as $k=>$v)
homer-api-5.0.6+dfsg2/api/RestApi/Admin.php-158- {
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Admin.php-210- $exten = "";
homer-api-5.0.6+dfsg2/api/RestApi/Admin.php:211: $callwhere = generateWhere($update, 1, $db, 0);
homer-api-5.0.6+dfsg2/api/RestApi/Admin.php-212- if(count($callwhere)) {
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Admin.php-217- $table = "user";
homer-api-5.0.6+dfsg2/api/RestApi/Admin.php:218: $query = "UPDATE ".$layer->getTableName($table)." SET ".$exten. " WHERE uid=".$uid;
homer-api-5.0.6+dfsg2/api/RestApi/Admin.php-219- $db->executeQuery($query);
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Admin.php-241-
homer-api-5.0.6+dfsg2/api/RestApi/Admin.php:242: $query = "DELETE FROM user WHERE uid=".$id;
homer-api-5.0.6+dfsg2/api/RestApi/Admin.php-243- $db->executeQuery($query);
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Admin.php-316- $exten = "";
homer-api-5.0.6+dfsg2/api/RestApi/Admin.php:317: $callwhere = generateWhere($update, 1, $db, 0);
homer-api-5.0.6+dfsg2/api/RestApi/Admin.php-318- if(count($callwhere)) {
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Admin.php-321- $insertvalue = array();
homer-api-5.0.6+dfsg2/api/RestApi/Admin.php:322: foreach($callwhere as $k=>$v)
homer-api-5.0.6+dfsg2/api/RestApi/Admin.php-323- {
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Admin.php-368- $exten = "";
homer-api-5.0.6+dfsg2/api/RestApi/Admin.php:369: $callwhere = generateWhere($update, 1, $db, 0);
homer-api-5.0.6+dfsg2/api/RestApi/Admin.php-370- if(count($callwhere)) {
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Admin.php-374- $table = "alias";
homer-api-5.0.6+dfsg2/api/RestApi/Admin.php:375: $query = "UPDATE ".$table." SET ".$exten. " WHERE id=".$id;
homer-api-5.0.6+dfsg2/api/RestApi/Admin.php-376- $db->executeQuery($query);
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Admin.php-398-
homer-api-5.0.6+dfsg2/api/RestApi/Admin.php:399: $query = "DELETE FROM alias WHERE id=".$id;
homer-api-5.0.6+dfsg2/api/RestApi/Admin.php-400- $db->executeQuery($query);
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Admin.php-479-
homer-api-5.0.6+dfsg2/api/RestApi/Admin.php:480: $callwhere = generateWhere($update, 1, $db, 0);
homer-api-5.0.6+dfsg2/api/RestApi/Admin.php-481- if(count($callwhere)) {
homer-api-5.0.6+dfsg2/api/RestApi/Admin.php-482- //$exten .= implode(", ", $callwhere);
homer-api-5.0.6+dfsg2/api/RestApi/Admin.php:483: foreach($callwhere as $k=>$v)
homer-api-5.0.6+dfsg2/api/RestApi/Admin.php-484- {
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Admin.php-533- $exten = "";
homer-api-5.0.6+dfsg2/api/RestApi/Admin.php:534: $callwhere = generateWhere($update, 1, $db, 0);
homer-api-5.0.6+dfsg2/api/RestApi/Admin.php-535- if(count($callwhere)) {
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Admin.php-539- $table = "node";
homer-api-5.0.6+dfsg2/api/RestApi/Admin.php:540: $query = "UPDATE ".$table." SET ".$exten. " WHERE id=".$id;
homer-api-5.0.6+dfsg2/api/RestApi/Admin.php-541- $db->executeQuery($query);
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Admin.php-563-
homer-api-5.0.6+dfsg2/api/RestApi/Admin.php:564: $query = "DELETE FROM node WHERE id=".$id;
homer-api-5.0.6+dfsg2/api/RestApi/Admin.php-565- $db->executeQuery($query);
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php-139- $insertvalue = array();
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php:140: $callwhere = generateWhere($update, 1, $db, 0);
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php-141- if(count($callwhere)) {
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php-142- //$exten .= implode(", ", $callwhere);
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php:143: foreach($callwhere as $k=>$v)
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php-144- {
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php-192- $exten = "";
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php:193: $callwhere = generateWhere($update, 1, $db, 0);
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php-194- if(count($callwhere)) {
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php-198- $table = "alarm_config";;
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php:199: $query = "UPDATE ".$table." SET ".$exten. " WHERE id=".$id;
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php-200- $db->executeQuery($query);
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php-222-
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php:223: $query = "DELETE FROM alarm_config WHERE id=".$id;
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php-224- $db->executeQuery($query);
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php-325-
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php:326: $callwhere = generateWhere($search[$key], 1, $db, 0);
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php-327- if(count($callwhere)) $calldata[] = "(". implode(" AND ", $callwhere). ")";
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php-329-
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php:330: if(count($calldata)) $arrwhere = " AND (". implode(" OR ", $calldata). ")";
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php-331-
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php-410- $table = "alarm_data";;
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php:411: $query = "UPDATE ".$table." SET status=".$status. " WHERE id=".$id;
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php-412- $db->executeQuery($query);
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php-451-
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php:452: $callwhere = generateWhere($search[$key], 1, $db, 0);
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php-453- if(count($callwhere)) $calldata[] = "(". implode(" AND ", $callwhere). ")";
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php-455-
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php:456: if(count($calldata)) $arrwhere = " AND (". implode(" OR ", $calldata). ")";
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php-457-
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php-573- $search[$key]['type'] = getVar('type', NULL, $filter, 'string');
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php:574: $callwhere = generateWhere($search[$key], 1, $db, 0);
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php-575- if(count($callwhere)) $calldata[] = "(". implode(" AND ", $callwhere). ")";
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php-577-
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php:578: if(count($calldata)) $arrwhere = " AND (". implode(" OR ", $calldata). ")";
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php-579-
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php-695- $search[$key]['source_ip'] = getVar('source_ip', NULL, $filter, 'string');
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php:696: $callwhere = generateWhere($search[$key], 1, $db, 0);
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php-697- if(count($callwhere)) $calldata[] = "(". implode(" AND ", $callwhere). ")";
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php-699-
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php:700: if(count($calldata)) $arrwhere = " AND (". implode(" OR ", $calldata). ")";
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php-701-
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php-811- $search[$key]['useragent'] = getVar('useragent', NULL, $filter, 'string');
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php:812: $callwhere = generateWhere($search[$key], 1, $db, 0);
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php-813- if(count($callwhere)) $calldata[] = "(". implode(" AND ", $callwhere). ")";
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php-815-
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php:816: if(count($calldata)) $arrwhere = " AND (". implode(" OR ", $calldata). ")";
homer-api-5.0.6+dfsg2/api/RestApi/Alarm.php-817-
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Report.php-129-
homer-api-5.0.6+dfsg2/api/RestApi/Report.php:130: if(empty($callwhere)) $callwhere = generateWhere($search, $and_or, $db, 0);
homer-api-5.0.6+dfsg2/api/RestApi/Report.php-131-
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Report.php-181-
homer-api-5.0.6+dfsg2/api/RestApi/Report.php:182: $callwhere = generateWhere($search, $and_or, $db, 0);
homer-api-5.0.6+dfsg2/api/RestApi/Report.php-183- $layerHelper = array();
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Report.php-330-
homer-api-5.0.6+dfsg2/api/RestApi/Report.php:331: if(empty($callwhere)) $callwhere = generateWhere($search, $and_or, $db, 0);
homer-api-5.0.6+dfsg2/api/RestApi/Report.php-332-
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Report.php-492-
homer-api-5.0.6+dfsg2/api/RestApi/Report.php:493: $callwhere = generateWhere($search, $and_or, $db, 0);
homer-api-5.0.6+dfsg2/api/RestApi/Report.php-494-
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Report.php-699-
homer-api-5.0.6+dfsg2/api/RestApi/Report.php:700: $callwhere = generateWhere($search, $and_or, $db, 0);
homer-api-5.0.6+dfsg2/api/RestApi/Report.php-701- $callwhere[] = "type = 1";
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Report.php-879-
homer-api-5.0.6+dfsg2/api/RestApi/Report.php:880: $callwhere = generateWhere($search, $and_or, $db, 0);
homer-api-5.0.6+dfsg2/api/RestApi/Report.php-881- $callwhere[] = "(type = 2 OR type = 4)";
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Report.php-1112- //$search['content_type'] = "application/sdp";
homer-api-5.0.6+dfsg2/api/RestApi/Report.php:1113: $callwhere = generateWhere($search, $and_or, $db, $b2b);
homer-api-5.0.6+dfsg2/api/RestApi/Report.php-1114-
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Report.php-1559-
homer-api-5.0.6+dfsg2/api/RestApi/Report.php:1560: if(empty($callwhere)) $callwhere = generateWhere($search, $and_or, $db, 0);
homer-api-5.0.6+dfsg2/api/RestApi/Report.php-1561-
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Report.php-1698-
homer-api-5.0.6+dfsg2/api/RestApi/Report.php:1699: if(empty($callwhere)) $callwhere = generateWhere($search, $and_or, $db, 0);
homer-api-5.0.6+dfsg2/api/RestApi/Report.php-1700-
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Report.php-1851- curl_setopt($ch, CURLOPT_CUSTOMREQUEST, strtoupper($method));
homer-api-5.0.6+dfsg2/api/RestApi/Report.php:1852: $result = curl_exec($ch);
homer-api-5.0.6+dfsg2/api/RestApi/Report.php-1853- curl_close($ch);
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Report.php-1939- $search[] = "type=1";
homer-api-5.0.6+dfsg2/api/RestApi/Report.php:1940: if(empty($callwhere)) $callwhere = generateWhere($search, $and_or, $db, 0);
homer-api-5.0.6+dfsg2/api/RestApi/Report.php-1941-
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Report.php-1956- $limit = $limit_orig;
homer-api-5.0.6+dfsg2/api/RestApi/Report.php:1957: if(empty($callwhere)) $callwhere = generateWhere($search, $and_or, $db, 0);
homer-api-5.0.6+dfsg2/api/RestApi/Report.php-1958-
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Search.php-475- $callwhere = array();
homer-api-5.0.6+dfsg2/api/RestApi/Search.php:476: $callwhere = generateWhere($search, $and_or, $db, $b2b);
homer-api-5.0.6+dfsg2/api/RestApi/Search.php-477-
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Search.php-645- $callwhere = array();
homer-api-5.0.6+dfsg2/api/RestApi/Search.php:646: $callwhere = generateWhere($search, $and_or, $db, $b2b);
homer-api-5.0.6+dfsg2/api/RestApi/Search.php-647-
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Search.php-752- $search['callid'] = implode(";", $callids);
homer-api-5.0.6+dfsg2/api/RestApi/Search.php:753: $callwhere = generateWhere($search, $and_or, $db, $b2b);
homer-api-5.0.6+dfsg2/api/RestApi/Search.php-754-
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Search.php-875- curl_setopt($ch, CURLOPT_POSTFIELDS, $post);
homer-api-5.0.6+dfsg2/api/RestApi/Search.php:876: $response = curl_exec($ch);
homer-api-5.0.6+dfsg2/api/RestApi/Search.php-877-
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Search.php-1029- $search['id'] = $record_id;
homer-api-5.0.6+dfsg2/api/RestApi/Search.php:1030: $callwhere = generateWhere($search, $and_or, $db, 0);
homer-api-5.0.6+dfsg2/api/RestApi/Search.php-1031-
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Search.php-1118- $search['id'] = $record_id;
homer-api-5.0.6+dfsg2/api/RestApi/Search.php:1119: $callwhere = generateWhere($search, $and_or, $db, 0);
homer-api-5.0.6+dfsg2/api/RestApi/Search.php-1120-
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Search.php-1217-
homer-api-5.0.6+dfsg2/api/RestApi/Search.php:1218: $callwhere = generateWhere($search, $and_or, $db, $b2b);
homer-api-5.0.6+dfsg2/api/RestApi/Search.php-1219-
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Search.php-1344- $search['callid'] = implode(";", $callids);
homer-api-5.0.6+dfsg2/api/RestApi/Search.php:1345: $callwhere = generateWhere($search, $and_or, $db, $b2b);
homer-api-5.0.6+dfsg2/api/RestApi/Search.php-1346-
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Search.php-1537-
homer-api-5.0.6+dfsg2/api/RestApi/Search.php:1538: if(empty($callwhere)) $callwhere = generateWhere($search, $and_or, $db, 0);
homer-api-5.0.6+dfsg2/api/RestApi/Search.php-1539-
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Search.php-2149- curl_setopt($ch, CURLOPT_POSTFIELDS, $post);
homer-api-5.0.6+dfsg2/api/RestApi/Search.php:2150: $response = curl_exec($ch);
homer-api-5.0.6+dfsg2/api/RestApi/Search.php-2151-
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Search.php-2657- $command = TSHARK_PATH.' -V -r ' . $pcap_file . ' -O isup | '.EGREP.' \'^\s(.*)\'';
homer-api-5.0.6+dfsg2/api/RestApi/Search.php:2658: $output = exec ( $command, $arr_output );
homer-api-5.0.6+dfsg2/api/RestApi/Search.php-2659-
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Search.php-2742- $command = TSHARK_PATH.' -V -r ' . $pcap_file . ' -O isup | '.EGREP.' \'^\s(.*)\'';
homer-api-5.0.6+dfsg2/api/RestApi/Search.php:2743: $output = exec($command,$arr_output);
homer-api-5.0.6+dfsg2/api/RestApi/Search.php-2744- array_shift($arr_output);
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php-90-
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php:91: $callwhere = generateWhere($search[$key], 1, $db, 0);
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php-92- if(count($callwhere)) $calldata[] = "(". implode(" AND ", $callwhere). ")";
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php-105-
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php:106: //if(count($calldata)) $arrwhere = " AND (". implode(" OR ", $calldata). ")";
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php-107-
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php-209-
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php:210: $callwhere = generateWhere($search[$key], 1, $db, 0);
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php-211- if(count($callwhere)) $calldata[] = "(". implode(" AND ", $callwhere). ")";
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php-213-
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php:214: //if(count($calldata)) $arrwhere = " AND (". implode(" OR ", $calldata). ")";
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php-215-
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php-320- $search[$key]['source_ip'] = getVar('source_ip', NULL, $filter, 'string');
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php:321: $callwhere = generateWhere($search[$key], 1, $db, 0);
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php-322- if(count($callwhere)) $calldata[] = "(". implode(" AND ", $callwhere). ")";
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php-324-
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php:325: if(count($calldata)) $arrwhere = " AND (". implode(" OR ", $calldata). ")";
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php-326-
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php-439-
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php:440: $callwhere = generateWhere($search[$key], 1, $db, 0);
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php-441- if(count($callwhere)) $calldata[] = "(". implode(" AND ", $callwhere). ")";
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php-443-
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php:444: if(count($calldata)) $arrwhere = " AND (". implode(" OR ", $calldata). ")";
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php-445-
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php-549- $search[$key]['source_ip'] = getVar('source_ip', NULL, $filter, 'string');
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php:550: $callwhere = generateWhere($search[$key], 1, $db, 0);
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php-551- if(count($callwhere)) $calldata[] = "(". implode(" AND ", $callwhere). ")";
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php-553-
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php:554: if(count($calldata)) $arrwhere = " AND (". implode(" OR ", $calldata). ")";
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php-555-
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php-667- if($search[$key]['method'] == "ALL") $search[$key]['method'] = NULL;
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php:668: $callwhere = generateWhere($search[$key], 1, $db, 0);
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php-669- if(count($callwhere)) $calldata[] = "(". implode(" AND ", $callwhere). ")";
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php-671-
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php:672: if(count($calldata)) $arrwhere = " AND (". implode(" OR ", $calldata). ")";
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php-673-
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php-785- if($search[$key]['method'] == "ALL") $search[$key]['method'] = NULL;
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php:786: $callwhere = generateWhere($search[$key], 1, $db, 0);
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php-787- if(count($callwhere)) $calldata[] = "(". implode(" AND ", $callwhere). ")";
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php-789-
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php:790: if(count($calldata)) $arrwhere = " AND (". implode(" OR ", $calldata). ")";
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php-791-
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php-896- $search[$key]['useragent'] = getVar('useragent', NULL, $filter, 'string');
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php:897: $callwhere = generateWhere($search[$key], 1, $db, 0);
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php-898- if(count($callwhere)) $calldata[] = "(". implode(" AND ", $callwhere). ")";
##############################################
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php-900-
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php:901: if(count($calldata)) $arrwhere = " AND (". implode(" OR ", $calldata). ")";
homer-api-5.0.6+dfsg2/api/RestApi/Statistic.php-902-
##############################################
homer-api-5.0.6+dfsg2/examples/dashboards/_1411848944046.json:1:{"title":"Stats: IP Network","structure":"4-4-4","rows":[{"columns":[{"styleClass":"col-md-4","widgets":[{"type":"elasticapChart","config":{"chart":{"legend":{"align":"center","layout":"horizontal","enabled":true},"type":{"id":4,"label":"Bar","value":"bar"},"yaxis":{"title":"Bytes"},"sss":false,"size":{"height":250},"ccc":"","query_type":"histogram","query_res":"1m"},"path":"http:\/\/localhost\/nprobe-*\/_search?size=0","query":"{\n \"facets\": {\n \"0\": {\n \"date_histogram\": {\n \"field\": \"@timestamp\",\n \"interval\": \"5m\"\n },\n \"global\": true,\n \"facet_filter\": {\n \"fquery\": {\n \"query\": {\n \"filtered\": {\n \"query\": {\n \"query_string\": {\n \"query\": \"*\"\n }\n },\n \"filter\": {\n \"bool\": {\n \"must\": [\n {\n \"range\": {\n \"@timestamp\": {\n \"from\": \"$fromts\",\n \"to\": \"$tots\"\n }\n }\n }\n ]\n }\n }\n }\n }\n }\n }\n }\n },\n \"size\": 0\n}","db":{"name":"nprobe-*","password":"","user":"userpass"},"panel":{"timefield":"time","fieldname":"packets","fieldvalue":"count"},"debugresp":"{\"took\":852,\"timed_out\":false,\"_shards\":{\"total\":10,\"successful\":10,\"failed\":0},\"hits\":{\"total\":19014,\"max_score\":0,\"hits\":[]},\"facets\":{\"0\":{\"_type\":\"date_histogram\",\"entries\":[{\"time\":1431426300000,\"count\":21},{\"time\":1431426600000,\"count\":552},{\"time\":1431426900000,\"count\":613},{\"time\":1431427200000,\"count\":539},{\"time\":1431427500000,\"count\":567},{\"time\":1431427800000,\"count\":522},{\"time\":1431428100000,\"count\":856},{\"time\":1431428400000,\"count\":783},{\"time\":1431428700000,\"count\":743}]}}}"},"title":"Elasticsearch Histogram","wid":3},{"type":"querycapChart","config":{"chart":{"legend":{"align":"center","layout":"horizontal","enabled":true},"type":{"id":3,"label":"Area spline","value":"areaspline"},"size":{"height":250},"ccc":"#7B972E, #6A538D, #3B83A1, #CB7221, #F2E200"},"panel":{"timefield":"time","fieldname":"name","fieldvalue":"value"},"query":"select * from \"homer.1MinAvg\" where time \u003E $fromts AND time \u003C $tots;\nselect * from \"homer.5MinAvg\" where time \u003E $fromts AND time \u003C $tots;\nselect * from \"homer.15MinAvg\" where time \u003E $fromts AND time \u003C $tots;","path":"http:\/\/localhost:8086\/query","db":{"name":"homer_stats","user":"root","password":"password"},"source":{"main":"results","sub":"series"}},"title":"InfluxDB Charts - Homer Load","wid":3}],"cid":15},{"styleClass":"col-md-4","widgets":[{"type":"elasticapChart","config":{"chart":{"legend":{"align":"right","layout":"vertical","enabled":false},"type":{"id":4,"label":"Bar","value":"bar"},"size":{"height":250},"query_type":"terms","query_res":"1m","ccc":""},"path":"http:\/\/localhost\/nprobe-*\/_search?size=0","db":{"user":"userpass","name":"nprobe-*"},"query":"{\n \"facets\": {\n \"terms\": {\n \"terms\": {\n \"field\": \"IPV4_SRC_ADDR\",\n \"size\": 10,\n \"order\": \"count\",\n \"exclude\": []\n },\n \"facet_filter\": {\n \"fquery\": {\n \"query\": {\n \"filtered\": {\n \"query\": {\n \"bool\": {\n \"should\": [\n {\n \"query_string\": {\n \"query\": \"*\"\n }\n }\n ]\n }\n },\n \"filter\": {\n \"bool\": {\n \"must\": [\n {\n \"range\": {\n \"@timestamp\": {\n \"from\": \"$fromts\",\n \"to\": \"$tots\"\n }\n }\n }\n ]\n }\n }\n }\n }\n }\n }\n }\n },\n \"size\": 0\n}","panel":{"timefield":"term","fieldname":"count","fieldvalue":"count"},"debugresp":"{\"took\":837,\"timed_out\":false,\"_shards\":{\"total\":10,\"successful\":10,\"failed\":0},\"hits\":{\"total\":19014,\"max_score\":0,\"hits\":[]},\"facets\":{\"terms\":{\"_type\":\"terms\",\"missing\":0,\"total\":5196,\"other\":358,\"terms\":[{\"term\":\"192.168.1.23\",\"count\":3431},{\"term\":\"127.0.0.1\",\"count\":1043},{\"term\":\"172.17.42.1\",\"count\":73},{\"term\":\"192.168.1.6\",\"count\":63},{\"term\":\"192.168.1.25\",\"count\":52},{\"term\":\"192.168.1.24\",\"count\":51},{\"term\":\"fe80::1165:5f20:e2a8:4d56\",\"count\":44},{\"term\":\"192.168.1.249\",\"count\":31},{\"term\":\"173.194.65.189\",\"count\":29},{\"term\":\"fe80::13:bbc7:8822:7d86\",\"count\":21}]}}}"},"title":"Elasticsearch Terms: Top 10 IPv4 Sources","wid":7},{"type":"elasticapChart","config":{"chart":{"legend":{"align":"center","layout":"horizontal"},"query_type":"terms","query_res":"1m","type":{"id":4,"label":"Bar","value":"bar"},"size":{"height":250},"ccc":""},"path":"http:\/\/localhost\/nprobe-*\/_search?size=0","db":{"user":"userpass"},"query":"{\n \"facets\": {\n \"terms\": {\n \"terms\": {\n \"field\": \"L7_PROTO_NAME\",\n \"size\": 10,\n \"order\": \"count\",\n \"exclude\": []\n },\n \"facet_filter\": {\n \"fquery\": {\n \"query\": {\n \"filtered\": {\n \"query\": {\n \"bool\": {\n \"should\": [\n {\n \"query_string\": {\n \"query\": \"*\"\n }\n }\n ]\n }\n },\n \"filter\": {\n \"bool\": {\n \"must\": [\n {\n \"range\": {\n \"@timestamp\": {\n \"from\": \"$fromts\",\n \"to\": \"$tots\"\n }\n }\n }\n ]\n }\n }\n }\n }\n }\n }\n }\n },\n \"size\": 0\n}","panel":{"timefield":"term","fieldname":"count","fieldvalue":"count"},"debugresp":"{\"took\":756,\"timed_out\":false,\"_shards\":{\"total\":10,\"successful\":10,\"failed\":0},\"hits\":{\"total\":19014,\"max_score\":0,\"hits\":[]},\"facets\":{\"terms\":{\"_type\":\"terms\",\"missing\":0,\"total\":5196,\"other\":212,\"terms\":[{\"term\":\"DNS\",\"count\":1606},{\"term\":\"SSL\",\"count\":1217},{\"term\":\"Skype\",\"count\":726},{\"term\":\"Redis\",\"count\":405},{\"term\":\"Unknown\",\"count\":281},{\"term\":\"DropBox\",\"count\":244},{\"term\":\"SSDP\",\"count\":234},{\"term\":\"Google\",\"count\":106},{\"term\":\"ICMP\",\"count\":100},{\"term\":\"HTTP\",\"count\":65}]}}}"},"title":"Elasticsearch Terms: Top L7","wid":18}],"cid":16},{"styleClass":"col-md-4","widgets":[{"type":"sipcaptureChart","config":{"path":"statistic\/method","chart":{"type":{"id":1,"label":"Spline","value":"spline"},"legend":{"enabled":false,"align":"center","layout":"horizontal"},"yaxis":{"title":"ALL Messages"},"size":{"height":250},"sss":true,"ccc":"#923532, #7B972E, #6A538D, #3B83A1, #CB7221, #F2E200"},"panel":{"timefield":"to_ts","fieldname":"method","fieldvalue":"total"},"query":"{\n \"timestamp\": {\n \"from\": \"@from_ts\",\n \"to\": \"@to_ts\"\n },\n \"param\": {\n \"filter\": [ \n { \"method\": \"ALL\"}\n ],\n \"limit\": 200,\n \"total\": false\n }\n}"},"title":"HOMER Packet Count","wid":11},{"type":"sipcaptureChart","config":{"chart":{"legend":{"align":"center","layout":"horizontal","enabled":true},"type":{"id":4,"label":"Bar","value":"bar"},"sss":true,"ppp":true,"size":{"height":250}},"query":"{\n \"timestamp\": {\n \"from\": \"@from_ts\",\n \"to\": \"@to_ts\"\n },\n \"param\": {\n \"filter\": [ \n { \"method\": \"!ALL\"}\n ],\n \"limit\": 200,\n \"total\": false\n }\n}","path":"statistic\/method","panel":{"timefield":"to_ts","fieldname":"method","fieldvalue":"total"}},"title":"HOMER Method Distribution","wid":5}],"cid":17}]}]}
##############################################
homer-api-5.0.6+dfsg2/examples/pgsql/kamailio.cfg-511- if($var(atype) == "scanner") {
homer-api-5.0.6+dfsg2/examples/pgsql/kamailio.cfg:512: sql_query("cb", "DELETE FROM alarm_data_mem WHERE type='scanner' AND total < $var(avalue)");
homer-api-5.0.6+dfsg2/examples/pgsql/kamailio.cfg-513- if($var(anotify) == 1)
homer-api-5.0.6+dfsg2/examples/pgsql/kamailio.cfg-514- {
homer-api-5.0.6+dfsg2/examples/pgsql/kamailio.cfg:515: sql_query("cb", "SELECT * FROM alarm_data_mem WHERE type='scanner' AND total >= $var(avalue) LIMIT 2", "rd");
homer-api-5.0.6+dfsg2/examples/pgsql/kamailio.cfg-516- if($dbr(rd=>rows) > 0) {
##############################################
homer-api-5.0.6+dfsg2/examples/sipcapture/el6/sipcapture.init-87-
homer-api-5.0.6+dfsg2/examples/sipcapture/el6/sipcapture.init:88:SHM_MEMORY=$((`echo $SHM_MEMORY | sed -e 's/[^0-9]//g'`))
homer-api-5.0.6+dfsg2/examples/sipcapture/el6/sipcapture.init:89:PKG_MEMORY=$((`echo $PKG_MEMORY | sed -e 's/[^0-9]//g'`))
homer-api-5.0.6+dfsg2/examples/sipcapture/el6/sipcapture.init-90-[ -z "$USER" ] && USER=kamailio
##############################################
homer-api-5.0.6+dfsg2/examples/sipcapture/sipcapture.kamailio-514- if($var(atype) == "scanner") {
homer-api-5.0.6+dfsg2/examples/sipcapture/sipcapture.kamailio:515: sql_query("cb", "DELETE FROM alarm_data_mem WHERE type='scanner' AND total < $var(avalue)");
homer-api-5.0.6+dfsg2/examples/sipcapture/sipcapture.kamailio-516- if($var(anotify) == 1)
homer-api-5.0.6+dfsg2/examples/sipcapture/sipcapture.kamailio-517- {
homer-api-5.0.6+dfsg2/examples/sipcapture/sipcapture.kamailio:518: sql_query("cb", "SELECT * FROM alarm_data_mem WHERE type='scanner' AND total >= $var(avalue) LIMIT 2", "rd");
homer-api-5.0.6+dfsg2/examples/sipcapture/sipcapture.kamailio-519- if($dbr(rd=>rows) > 0) {
##############################################
homer-api-5.0.6+dfsg2/examples/sipcapture/sipcapture.opensips-316-route[SEND_ALARM] {
homer-api-5.0.6+dfsg2/examples/sipcapture/sipcapture.opensips:317: exec('echo "Value: $var(thvalue), Type: $var(atype), Desc: $var(aname)" | mail -s "Homer Alarm $var(atype) - $var(thvalue)" $var(aemail) ') ;
homer-api-5.0.6+dfsg2/examples/sipcapture/sipcapture.opensips-318-}
##############################################
homer-api-5.0.6+dfsg2/examples/sipcapture/sipcapture.opensips-324- #Homer 5 sql schema
homer-api-5.0.6+dfsg2/examples/sipcapture/sipcapture.opensips:325: avp_db_query("SELECT type,value,name,notify,email FROM alarm_config WHERE NOW() between startdate AND stopdate AND active = 1", "$avp(type);$avp(value);$avp(name);$avp(notify);$avp(email)");
homer-api-5.0.6+dfsg2/examples/sipcapture/sipcapture.opensips-326- $var(i) = 0;
##############################################
homer-api-5.0.6+dfsg2/examples/sipcapture/sipcapture.opensips-353- if($var(atype) == "scanner") {
homer-api-5.0.6+dfsg2/examples/sipcapture/sipcapture.opensips:354: avp_db_query("DELETE FROM alarm_data_mem WHERE type='scanner' AND total < $var(avalue)");
homer-api-5.0.6+dfsg2/examples/sipcapture/sipcapture.opensips-355- if($var(anotify) == 1)
homer-api-5.0.6+dfsg2/examples/sipcapture/sipcapture.opensips-356- {
homer-api-5.0.6+dfsg2/examples/sipcapture/sipcapture.opensips:357: avp_db_query("SELECT * FROM alarm_data_mem WHERE type='scanner' AND total >= $var(avalue) LIMIT 2", "$avp(as)");
homer-api-5.0.6+dfsg2/examples/sipcapture/sipcapture.opensips-358- if($(avp(as){s.int}) > 0) {
##############################################
homer-api-5.0.6+dfsg2/scripts/homer_mysql_remove_partitions.pl-33-# Determine path and set default rotation.ini location
homer-api-5.0.6+dfsg2/scripts/homer_mysql_remove_partitions.pl:34:my $script_location = `dirname $0`;
homer-api-5.0.6+dfsg2/scripts/homer_mysql_remove_partitions.pl-35-$script_location =~ s/^\s+|\s+$//g;
##############################################
homer-api-5.0.6+dfsg2/scripts/homer_mysql_remove_partitions.pl-101- my $query = "SELECT PARTITION_NAME, PARTITION_DESCRIPTION"
homer-api-5.0.6+dfsg2/scripts/homer_mysql_remove_partitions.pl:102: ."\n FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_NAME='".$table_name."'"
homer-api-5.0.6+dfsg2/scripts/homer_mysql_remove_partitions.pl-103- ."\n AND TABLE_SCHEMA='".$db_name."' ORDER BY PARTITION_DESCRIPTION ASC;";
##############################################
homer-api-5.0.6+dfsg2/scripts/homer_mysql_remove_partitions.pl-117-
homer-api-5.0.6+dfsg2/scripts/homer_mysql_remove_partitions.pl:118: my $query="SELECT create_options FROM information_schema.tables WHERE table_schema = '".$db_name."' and table_name = '".$table_name."'";
homer-api-5.0.6+dfsg2/scripts/homer_mysql_remove_partitions.pl-119- say "Debug: $query" if($CONFIG->{"SYSTEM"}{"debug"} == 1);
##############################################
homer-api-5.0.6+dfsg2/scripts/homer_mysql_rotate.pl-32-# Determine path and set default rotation.ini location
homer-api-5.0.6+dfsg2/scripts/homer_mysql_rotate.pl:33:my $script_location = `dirname $0`;
homer-api-5.0.6+dfsg2/scripts/homer_mysql_rotate.pl-34-$script_location =~ s/^\s+|\s+$//g;
##############################################
homer-api-5.0.6+dfsg2/scripts/homer_mysql_rotate.pl-296- #check if the table has partitions. If not, create one
homer-api-5.0.6+dfsg2/scripts/homer_mysql_rotate.pl:297: ##my $query = "SHOW TABLE STATUS FROM ".$CONFIG{"MYSQL"}{"db_stats"}. " WHERE Name='".$table."'";
homer-api-5.0.6+dfsg2/scripts/homer_mysql_rotate.pl:298: my $query="SELECT create_options FROM information_schema.tables WHERE table_schema = '".$db_name."' and table_name = '".$table."'";
homer-api-5.0.6+dfsg2/scripts/homer_mysql_rotate.pl-299- say "Debug: $query" if($CONFIG->{"SYSTEM"}{"debug"} == 1);
##############################################
homer-api-5.0.6+dfsg2/scripts/homer_mysql_rotate.pl-304- if ($tstatus !~ /partitioned/) {
homer-api-5.0.6+dfsg2/scripts/homer_mysql_rotate.pl:305: my $query = "ALTER TABLE ".$table. " PARTITION BY RANGE ( UNIX_TIMESTAMP(`".$part_key."`)) (PARTITION pmax VALUES LESS THAN MAXVALUE)";
homer-api-5.0.6+dfsg2/scripts/homer_mysql_rotate.pl-306- print "Table is not partitioned..[$table]" if($CONFIG->{"SYSTEM"}{"debug"} == 1);
##############################################
homer-api-5.0.6+dfsg2/scripts/homer_mysql_rotate.pl-317- $query = "SELECT PARTITION_NAME, PARTITION_DESCRIPTION"
homer-api-5.0.6+dfsg2/scripts/homer_mysql_rotate.pl:318: ."\n FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_NAME='".$table."'"
homer-api-5.0.6+dfsg2/scripts/homer_mysql_rotate.pl-319- ."\n AND TABLE_SCHEMA='".$db_name."' ORDER BY PARTITION_DESCRIPTION ASC;";
##############################################
homer-api-5.0.6+dfsg2/scripts/homer_partremove-5-
homer-api-5.0.6+dfsg2/scripts/homer_partremove:6:bin_dir=`dirname $0`
homer-api-5.0.6+dfsg2/scripts/homer_partremove-7-programm="$bin_dir/homer_mysql_remove_partitions.pl"
##############################################
homer-api-5.0.6+dfsg2/scripts/homer_rotate-5-
homer-api-5.0.6+dfsg2/scripts/homer_rotate:6:bin_dir=`dirname $0`
homer-api-5.0.6+dfsg2/scripts/homer_rotate-7-programm="$bin_dir/homer_mysql_rotate.pl"
##############################################
homer-api-5.0.6+dfsg2/scripts/old/homer_mysql_partrotate_unixtimestamp.pl-68-#check if the table has partitions. If not, create one
homer-api-5.0.6+dfsg2/scripts/old/homer_mysql_partrotate_unixtimestamp.pl:69:my $query = "SHOW TABLE STATUS FROM ".$mysql_dbname. " WHERE Name='".$mysql_table."'";
homer-api-5.0.6+dfsg2/scripts/old/homer_mysql_partrotate_unixtimestamp.pl-70-$sth = $db->prepare($query);
##############################################
homer-api-5.0.6+dfsg2/scripts/old/homer_mysql_partrotate_unixtimestamp.pl-73-if ($tstatus !~ /partitioned/) {
homer-api-5.0.6+dfsg2/scripts/old/homer_mysql_partrotate_unixtimestamp.pl:74: my $query = "ALTER TABLE ".$mysql_table. " PARTITION BY RANGE ( UNIX_TIMESTAMP(`".$part_key."`)) (PARTITION pmax VALUES LESS THAN MAXVALUE)";
homer-api-5.0.6+dfsg2/scripts/old/homer_mysql_partrotate_unixtimestamp.pl-75- $sth = $db->prepare($query);
##############################################
homer-api-5.0.6+dfsg2/scripts/old/homer_mysql_partrotate_unixtimestamp.pl-88-$query = "SELECT PARTITION_NAME, PARTITION_DESCRIPTION"
homer-api-5.0.6+dfsg2/scripts/old/homer_mysql_partrotate_unixtimestamp.pl:89: ."\n FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_NAME='".$mysql_table."'"
homer-api-5.0.6+dfsg2/scripts/old/homer_mysql_partrotate_unixtimestamp.pl-90- ."\n AND TABLE_SCHEMA='".$mysql_dbname."' ORDER BY PARTITION_DESCRIPTION ASC;";
##############################################
homer-api-5.0.6+dfsg2/scripts/old/homer_rotate-7-
homer-api-5.0.6+dfsg2/scripts/old/homer_rotate:8:bin_dir=`dirname $0`
homer-api-5.0.6+dfsg2/scripts/old/homer_rotate-9-new_table="$bin_dir/homer_mysql_new_table.pl"
##############################################
homer-api-5.0.6+dfsg2/scripts/old/homer_rotate-37-
homer-api-5.0.6+dfsg2/scripts/old/homer_rotate:38:TS=`expr $TS - 2592000`
homer-api-5.0.6+dfsg2/scripts/old/homer_rotate:39:for table in `mysql -u${MYSQL_USER} -p${MYSQL_PASSWORD} -D${MYSQL_DB} -B -e "show tables" | grep sip_capture`;
homer-api-5.0.6+dfsg2/scripts/old/homer_rotate-40-do
homer-api-5.0.6+dfsg2/scripts/old/homer_rotate:41: table_date=`echo $table | awk -F'_' '{print $4}'`;
homer-api-5.0.6+dfsg2/scripts/old/homer_rotate:42: table_ts=`date --date=$table_date +%s`;
homer-api-5.0.6+dfsg2/scripts/old/homer_rotate-43- if [ $table_ts -lt $TS ];
##############################################
homer-api-5.0.6+dfsg2/scripts/pgsql/homer_pgsql_rotate.pl-32-# Determine path and set default rotation.ini location
homer-api-5.0.6+dfsg2/scripts/pgsql/homer_pgsql_rotate.pl:33:my $script_location = `dirname $0`;
homer-api-5.0.6+dfsg2/scripts/pgsql/homer_pgsql_rotate.pl-34-$script_location =~ s/^\s+|\s+$//g;
##############################################
homer-api-5.0.6+dfsg2/scripts/pgsql/homer_rotate-5-
homer-api-5.0.6+dfsg2/scripts/pgsql/homer_rotate:6:bin_dir=`dirname $0`
homer-api-5.0.6+dfsg2/scripts/pgsql/homer_rotate-7-programm="$bin_dir/homer_pgsql_rotate.pl"
##############################################
homer-api-5.0.6+dfsg2/debian/homer-api.kamailio-homer.init-18-DAEMON=/usr/sbin/kamailio
homer-api-5.0.6+dfsg2/debian/homer-api.kamailio-homer.init:19:NAME=`basename "$0"`
homer-api-5.0.6+dfsg2/debian/homer-api.kamailio-homer.init-20-DESC="Kamailio HOMER API"
##############################################
homer-api-5.0.6+dfsg2/debian/homer-api.kamailio-homer.init-96-
homer-api-5.0.6+dfsg2/debian/homer-api.kamailio-homer.init:97:SHM_MEMORY=$((`echo $SHM_MEMORY | sed -e 's/[^0-9]//g'`))
homer-api-5.0.6+dfsg2/debian/homer-api.kamailio-homer.init:98:PKG_MEMORY=$((`echo $PKG_MEMORY | sed -e 's/[^0-9]//g'`))
homer-api-5.0.6+dfsg2/debian/homer-api.kamailio-homer.init-99-[ -z "$USER" ] && USER=kamailio