=========================================================== .___ __ __ _________________ __ __ __| _/|__|/ |_ / ___\_` __ \__ \ | | \/ __ | | \\_ __\ / /_/ > | \// __ \| | / /_/ | | || | \___ /|__| (____ /____/\____ | |__||__| /_____/ \/ \/ grep rough audit - static analysis tool v2.8 written by @Wireghoul =================================[justanotherhacker.com]=== ocsinventory-server-2.8+dfsg1/Apache/Changes-215- * Added LOCAL_FL to CURRENT_CONTEXT ocsinventory-server-2.8+dfsg1/Apache/Changes:216: * The default Ip(hardware.IPADDR) is now based on REMOTE_ADDR (or HTTP_X_FORWARDED_FOR) ocsinventory-server-2.8+dfsg1/Apache/Changes-217- * Added IS_TRUSTED test if INVENTORY_SESSION_ONLY ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Config.pm-51- ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Config.pm:52: my $sth = get_sth('SELECT IVALUE,TVALUE FROM config WHERE NAME=?', $key); ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Config.pm-53- unless($sth->rows){ ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Config.pm-96- } ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Config.pm:97: my $sth = get_sth("SELECT * FROM config WHERE NAME=?", $key); ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Config.pm-98- if( !$sth->rows ){ ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Config.pm-101- $sth->finish(); ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Config.pm:102: do_sql("UPDATE config SET IVALUE=? WHERE NAME=?", $ivalue, $key ) if defined $ivalue; ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Config.pm:103: do_sql("UPDATE config SET TVALUE=? WHERE NAME=?", $tvalue, $key ) if defined $tvalue; ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Config.pm-104- } ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/History.pm-63- if( defined $row->{'EQUIVALENT'} ){ ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/History.pm:64: do_sql('DELETE FROM deleted_equiv WHERE DELETED=? AND DATE=? AND EQUIVALENT=?', $row->{'DELETED'}, $row->{'DATE'}, $row->{'EQUIVALENT'}) or die; ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/History.pm-65- } ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/History.pm-66- else{ ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/History.pm:67: do_sql('DELETE FROM deleted_equiv WHERE DELETED=? AND DATE=? AND EQUIVALENT IS NULL', $row->{'DELETED'}, $row->{'DATE'}) or die; ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/History.pm-68- } ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Internals.pm-120- # Generate sql string ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Internals.pm:121: my $search_string = "SELECT DISTINCT $main_table.ID FROM $main_table,$accountinfo_table WHERE $main_table.$deviceid_column NOT LIKE '\\_%' AND $main_table.ID=$accountinfo_table.$pk $id $name $userid $checksum $tag ORDER BY hardware.$sort_by $sort_dir limit $begin,$ENV{OCS_OPT_WEB_SERVICE_RESULTS_LIMIT}"; ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Internals.pm-122- # Play it ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Internals.pm-145- my $deviceid = &{ $get_table_pk_functions{ $main_table } }($section); ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Internals.pm:146: my $sth = get_sth("SELECT * FROM $section WHERE $deviceid=?", $id); ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Internals.pm-147- ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Internals.pm-174- my( $checksum, $ref ) = @_; ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Internals.pm:175: my $where = join(',', @$ref); ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Internals.pm-176- return do_sql("UPDATE hardware SET CHECKSUM=? WHERE ID IN ($where)", $checksum); ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Internals.pm-205- # Request database ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Internals.pm:206: my $sth = get_sth('SELECT ID, NAME FROM accountinfo_config WHERE NAME_ACCOUNTINFO IS NULL AND ACCOUNT_TYPE=?', $account_type); ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Internals.pm-207- # Build data structure... ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Inventory.pm-172- # Request database ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Inventory.pm:173: my $sth = get_sth('SELECT * FROM accountinfo WHERE HARDWARE_ID=?', $id); ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Inventory.pm-174- # Build data structure... ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Inventory.pm-191- my @tmp; ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Inventory.pm:192: my $sth = get_sth('SELECT DISTINCT dico_soft.FORMATTED AS FORMAT FROM softwares,dico_soft WHERE HARDWARE_ID=? AND EXTRACTED=NAME', $id); ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Inventory.pm-193- while( my $row = $sth->fetchrow_hashref() ){ ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Inventory.pm-203- my $extracted = shift; ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Inventory.pm:204: my $sth = get_sth('SELECT DISTINCT FORMATTED FROM dico_soft WHERE EXTRACTED=?', $extracted); ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Inventory.pm-205- unless($sth->rows){ ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Ipdiscover.pm-73- my ( $device, $description, $type, $user ) = @_; ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Ipdiscover.pm:74: return send_error('BAD_TYPE') if do_sql('SELECT * FROM devicetype WHERE NAME=?', $type) == 0E0; ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Ipdiscover.pm:75: return send_error('BAD_USER') if do_sql('SELECT * FROM operators WHERE ID=?', $user) == 0E0; ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Ipdiscover.pm-76- return do_sql('INSERT INTO network_devices(DESCRIPTION,TYPE,MACADDR,USER) VALUES(?,?,?,?)', ($description, $type, $device, $user ) ); ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Ipdiscover.pm-80- my $device = shift; ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Ipdiscover.pm:81: return do_sql('DELETE FROM network_devices WHERE MACADDR=?', $device); ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Ipdiscover.pm-82-} ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Ipdiscover.pm-85- my $device = shift; ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Ipdiscover.pm:86: return do_sql('DELETE FROM network_devices WHERE MACADDR=?', $device); ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Ipdiscover.pm-87-} ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Ipdiscover.pm-90- my $type = shift; ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Ipdiscover.pm:91: return 0 if do_sql( 'SELECT * FROM devicetype WHERE NAME=?', $type )!=0E0; ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Ipdiscover.pm-92- return do_sql( 'INSERT INTO devicetype(NAME) VALUES(?)', $type ); ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Ipdiscover.pm-96- my $type = shift; ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Ipdiscover.pm:97: return do_sql( 'DELETE FROM devicetype WHERE NAME=?', $type ); ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Ipdiscover.pm-98-} ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Snmp.pm-164- # Request database ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Snmp.pm:165: my $sth = get_sth('SELECT * FROM snmp_accountinfo WHERE SNMP_ID=?', $id); ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Snmp.pm-166- # Build data structure... ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Updates.pm-49- next if !$DATA_MAP{ $section }->{delOnReplace} ; ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Updates.pm:50: do_sql("DELETE FROM $section WHERE $hardwareIdField=$hardwareId") ; ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Interface/Updates.pm-51- } ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Capacities/Download/Inventory.pm-69- ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Capacities/Download/Inventory.pm:70: $dbh->do('DELETE FROM download_history WHERE HARDWARE_ID=?', {}, $hardwareId); ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Capacities/Download/Inventory.pm-71- ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Capacities/Download/Inventory.pm-115- next if !defined ($_); ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Capacities/Download/Inventory.pm:116: $dbh->do( 'DELETE FROM download_history WHERE HARDWARE_ID=? AND PKG_ID=?', {}, $hardwareId, $_ ); ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Capacities/Download/Inventory.pm-117- } ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Capacities/Download.pm-302- if ( grep /^$fileid$/, @history ){ ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Capacities/Download.pm:303: $dbh->do(q{ UPDATE devices SET TVALUE='SUCCESS_ALREADY_IN_HISTORY', COMMENTS=? WHERE NAME='DOWNLOAD' AND HARDWARE_ID=? AND IVALUE=? }, {}, scalar localtime(), $current_context->{'DATABASE_ID'}, $enable_id ) ; ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Capacities/Download.pm-304- next ; ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Capacities/Download.pm-431- # Handle deployment servers ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Capacities/Download.pm:432: $dbh->do('UPDATE download_enable SET SERVER_ID=? WHERE SERVER_ID=?', {}, $current_context->{'DATABASE_ID'}, $device); ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Capacities/Download.pm:433: $dbh->do('UPDATE download_servers SET HARDWARE_ID=? WHERE HARDWARE_ID=?', {}, $current_context->{'DATABASE_ID'}, $device); ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Capacities/Download.pm-434- ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Capacities/Download.pm-435- # If we encounter problems, it aborts whole replacement ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Capacities/Download.pm:436: return $dbh->do('DELETE FROM download_history WHERE HARDWARE_ID=?', {}, $device); ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Capacities/Download.pm-437-} ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Capacities/Ipdiscover.pm-223- if($remove){ ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Capacities/Ipdiscover.pm:224: if(!$dbh->do('DELETE FROM devices WHERE HARDWARE_ID=? AND NAME="IPDISCOVER"', {}, $DeviceID)){ ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Capacities/Ipdiscover.pm-225- return 1; ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Capacities/Ipdiscover.pm-401- # Compare to the current and replace it if needed ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Capacities/Ipdiscover.pm:402: if(!$dbh->do('UPDATE devices SET HARDWARE_ID=? WHERE HARDWARE_ID=? AND NAME="IPDISCOVER"', {}, $DeviceID, $worth[0])){ ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Capacities/Ipdiscover.pm-403- return 1; ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Capacities/Notify.pm-129- $mask = $mask|1 if $update_hardware; ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Capacities/Notify.pm:130: $dbh->do("UPDATE hardware SET CHECKSUM=($mask|CHECKSUM) WHERE ID=$hardwareId"); ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Capacities/Notify.pm-131- } ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Capacities/Snmp/Data.pm-105- $sectionsMeta->{$section}->{sql_select_string} = "SELECT ID,$fields_string FROM $section ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Capacities/Snmp/Data.pm:106: WHERE SNMP_ID=? ORDER BY ".$DATA_MAP{$section}->{sortBy}; ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Capacities/Snmp/Data.pm-107- # Build the "DBI->prepare" sql deletion string ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Capacities/Snmp/Inventory.pm-167- if( $sectionMeta->{delOnReplace}) { ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Capacities/Snmp/Inventory.pm:168: if(!$dbh->do("DELETE FROM $section WHERE SNMP_ID=?", {}, $snmpDatabaseId)){ ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Capacities/Snmp/Inventory.pm-169- return(1); ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Capacities/Snmp/Inventory.pm-228- TYPE=".$dbh->quote($base->{TYPE})." ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Capacities/Snmp/Inventory.pm:229: WHERE ID = $snmpDatabaseId") ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Capacities/Snmp/Inventory.pm-230- or return(1); ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Capacities/Snmp/Inventory.pm-244- if (defined $row->{'TAG'}) { ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Capacities/Snmp/Inventory.pm:245: $dbh->do("UPDATE snmp_accountinfo SET TAG=".$dbh->quote($row->{'TAG'})." WHERE SNMP_ID=$snmpDatabaseId"); ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Capacities/Snmp/Inventory.pm-246- $dbh->commit; ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Communication/Session.pm-68- if($row->{IVALUE}< $ENV{OCS_OPT_SESSION_CLEAN_TIME} ){ ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Communication/Session.pm:69: $dbh->do('DELETE FROM engine_mutex WHERE PID=? AND NAME="SESSION" AND TAG="CLEAN"', {}, $$ ); ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Communication/Session.pm-70- return; ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Communication/Session.pm-79- ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Communication/Session.pm:80: $dbh->do('DELETE FROM engine_mutex WHERE PID=? AND NAME="SESSION" AND TAG="CLEAN"', {}, $$ ); ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Communication/Session.pm-81- ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Communication/Session.pm-115- ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Communication/Session.pm:116: my $code = $dbh->do('DELETE FROM prolog_conntrack WHERE DEVICEID=?', {}, $deviceId); ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Communication/Session.pm-117- if(!$code){ ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Duplicate.pm-248- USERID=".$dbh->quote($userid)." ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Duplicate.pm:249: WHERE ID=".$DeviceID ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Duplicate.pm-250- ) ; ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Duplicate.pm:251: $dbh->do("DELETE FROM hardware WHERE ID=?", {}, $device) ; ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Duplicate.pm-252- ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Duplicate.pm-253- # We keep the informations of the following tables: devices, accountinfo, itmgmt_comments ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Duplicate.pm:254: $dbh->do('DELETE FROM accountinfo WHERE HARDWARE_ID=?', {}, $DeviceID) ; ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Duplicate.pm:255: $dbh->do('UPDATE accountinfo SET HARDWARE_ID=? WHERE HARDWARE_ID=?', {}, $DeviceID, $device) ; ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Duplicate.pm:256: $dbh->do('DELETE FROM devices WHERE HARDWARE_ID=?', {}, $DeviceID) ; ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Duplicate.pm:257: $dbh->do('UPDATE devices SET HARDWARE_ID=? WHERE HARDWARE_ID=?', {}, $DeviceID, $device) ; ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Duplicate.pm:258: $dbh->do('UPDATE itmgmt_comments SET HARDWARE_ID=? WHERE HARDWARE_ID=?', {}, $DeviceID, $device) ; ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Duplicate.pm-259- # We keep the static inclusions/exclusions (STATIC=1|2) ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Duplicate.pm:260: $dbh->do('UPDATE groups_cache SET HARDWARE_ID=? WHERE HARDWARE_ID=? AND (STATIC=1 OR STATIC=2)', {}, $DeviceID, $device) ; ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Duplicate.pm-261- # The computer may not correspond to the previous dynamic groups, as its inventory could potentially change ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Duplicate.pm:262: $dbh->do('DELETE FROM groups_cache WHERE HARDWARE_ID=?', {}, $device) ; ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Duplicate.pm-263- ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Duplicate.pm-267- next if !$DATA_MAP{$_}->{delOnReplace} || !$DATA_MAP{$_}->{auto} || $DATA_MAP{$_}->{capacities}; ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Duplicate.pm:268: unless($dbh->do("DELETE FROM $_ WHERE HARDWARE_ID=?", {}, $device)){ ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Duplicate.pm-269- &_unlock($device); ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Groups.pm-192-# Updating cache time ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Groups.pm:193: $dbh->do("UPDATE groups SET CREATE_TIME=UNIX_TIMESTAMP(), REVALIDATE_FROM=UNIX_TIMESTAMP()+? WHERE HARDWARE_ID=?", {}, $offset, $group_id); ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Groups.pm-194- &_log(307,'groups', "revalidate_cache($group_id(".scalar @ids."))") if $ENV{'OCS_OPT_LOGLEVEL'}; ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Inventory/Cache.pm-45- my $table = $section.'_'.lc $field.'_cache'; ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Inventory/Cache.pm:46: my $err = $dbh->do("SELECT $field FROM $table WHERE $field=?", {}, $values->[ $sectionMeta->{field_cached}->{$field} ]); ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Inventory/Cache.pm-47- if( $err && $err == 0E0 && $op eq 'add'){ ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Inventory/Cache.pm-50- elsif( $err != 0E0 && $op eq 'del'){ ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Inventory/Cache.pm:51: my $err2 = $dbh->do("SELECT $field FROM $section WHERE $field=? LIMIT 0,1", {}, $values->[ $sectionMeta->{field_cached}->{$field} ]); ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Inventory/Cache.pm-52- if( $err2 && $err2 == 0E0 ){ ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Inventory/Cache.pm:53: $dbh->do("DELETE FROM $table WHERE $field=?", {}, $values->[ $sectionMeta->{field_cached}->{$field} ]); ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Inventory/Cache.pm-54- } ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Inventory/Cache.pm-136-sub _lock_cache_release{ ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Inventory/Cache.pm:137: return $Apache::Ocsinventory::CURRENT_CONTEXT{'DBI_HANDLE'}->do("DELETE FROM engine_mutex WHERE NAME='INVENTORY_CACHE_REVALIDATE' AND PID=?", {}, $$); ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Inventory/Cache.pm-138-} ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Inventory/Data.pm-106- $sectionsMeta->{$section}->{sql_select_string} = "SELECT ID,$fields_string FROM $section ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Inventory/Data.pm:107: WHERE HARDWARE_ID=? ORDER BY ".$DATA_MAP{$section}->{sortBy}; ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Inventory/Data.pm-108- # Build the "DBI->prepare" sql deletion string ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Inventory/Update/AccountInfos.pm-73- if($_->{KEYNAME} eq $accountkey){ ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Inventory/Update/AccountInfos.pm:74: if(!$dbh->do('UPDATE accountinfo SET '.$accountkey."=".$dbh->quote($_->{KEYVALUE}).' WHERE HARDWARE_ID='.$hardwareId)){ ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Inventory/Update/AccountInfos.pm-75- return 1; ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Inventory/Update/AccountInfos.pm-85- if($lost){ ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Inventory/Update/AccountInfos.pm:86: if(!$dbh->do('UPDATE accountinfo SET TAG = "LOST" WHERE HARDWARE_ID=?', {}, $hardwareId)){ ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Inventory/Update/AccountInfos.pm-87- return(1); ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Inventory/Update/Hardware.pm-78- CATEGORY_ID=".$dbh->quote($base->{CATEGORY_ID})." ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Inventory/Update/Hardware.pm:79: WHERE ID=".$deviceId) ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Inventory/Update/Hardware.pm-80- or return(1); ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Inventory/Update.pm-97- if( $sectionMeta->{delOnReplace} && !($sectionMeta->{writeDiff} && $ENV{'OCS_OPT_INVENTORY_WRITE_DIFF'}) ){ ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Inventory/Update.pm:98: if(!$dbh->do("DELETE FROM $section WHERE HARDWARE_ID=?", {}, $deviceId)){ ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/Inventory/Update.pm-99- return(1); ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/System/Config.pm-480- if( !defined($ENV{$truename}) ){ ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/System/Config.pm:481: print STDERR "ocsinventory-server: Bad setting. `$name` is not set. Default: `$CONFIG{$name}->{default}`\n"; ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/System/Config.pm-482- $ENV{$truename} = $CONFIG{$name}->{default}; ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/System/Config.pm-484- elsif( $ENV{$truename} !~ $CONFIG{$name}->{filter} ){ ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/System/Config.pm:485: print STDERR "ocsinventory-server: Bad setting. `$name` is set to `$ENV{$truename}`. Default: `$CONFIG{$name}->{default}`\n"; ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/System/Config.pm-486- $ENV{$truename} = $CONFIG{$name}->{default}; ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/System/Config.pm-488- else{ ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/System/Config.pm:489: print "ocsinventory-server: Parameter `$truename` is ok\n" if $verbose; ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/System/Config.pm-490- } ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/System.pm-254- &_log(516,'lock', 'reuse_lock') if $ENV{'OCS_OPT_LOGLEVEL'}; ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/System.pm:255: if( $dbh->do('UPDATE locks SET ID=? WHERE HARDWARE_ID=?', {}, $$, $device) ){ ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/System.pm-256- $Apache::Ocsinventory::CURRENT_CONTEXT{'LOCK_FL'} = 1; ############################################## ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/System.pm-273- ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/System.pm:274: if($dbh->do('DELETE FROM locks WHERE HARDWARE_ID=? AND ID=?', {}, $device, $$)){ ocsinventory-server-2.8+dfsg1/Apache/Ocsinventory/Server/System.pm-275- $Apache::Ocsinventory::CURRENT_CONTEXT{'LOCK_FL'} = 0 if $device eq ${Apache::Ocsinventory::CURRENT_CONTEXT{'DATABASE_ID'}}; ############################################## ocsinventory-server-2.8+dfsg1/Api/Ocsinventory/Restapi/Ipdiscover/Get/IpdiscoverTag.pm-19- my $json_return = $database->selectall_arrayref( ocsinventory-server-2.8+dfsg1/Api/Ocsinventory/Restapi/Ipdiscover/Get/IpdiscoverTag.pm:20: "SELECT * from netmap WHERE TAG = '$tag'", ocsinventory-server-2.8+dfsg1/Api/Ocsinventory/Restapi/Ipdiscover/Get/IpdiscoverTag.pm-21- { Slice => {} } ############################################## ocsinventory-server-2.8+dfsg1/Api/Ocsinventory/Restapi/Loader.pm-47- ocsinventory-server-2.8+dfsg1/Api/Ocsinventory/Restapi/Loader.pm:48: my $where = $c->param('where')|| ""; ocsinventory-server-2.8+dfsg1/Api/Ocsinventory/Restapi/Loader.pm-49- my $operator = $c->param('operator')|| ""; ############################################## ocsinventory-server-2.8+dfsg1/Api/Ocsinventory/Restapi/Snmp/Get/SnmpIdField.pm-19- my $snmps = $database->selectall_arrayref( ocsinventory-server-2.8+dfsg1/Api/Ocsinventory/Restapi/Snmp/Get/SnmpIdField.pm:20: "SELECT * from $type WHERE ID = $id", ocsinventory-server-2.8+dfsg1/Api/Ocsinventory/Restapi/Snmp/Get/SnmpIdField.pm-21- { Slice => {} } ############################################## ocsinventory-server-2.8+dfsg1/binutils/ipdiscover-util.pl-188- } ocsinventory-server-2.8+dfsg1/binutils/ipdiscover-util.pl:189: system("./ipdiscover-util.pl -net=".$subnet{$_}.($xml?' -xml':'')." -a > $path/ipd/'".$subnet{$_}.".ipd'"); ocsinventory-server-2.8+dfsg1/binutils/ipdiscover-util.pl-190- $i++; ############################################## ocsinventory-server-2.8+dfsg1/binutils/ipdiscover-util.pl-240- next unless $ip =~ /^\d{1,3}(?:\.\d{1,3}){3}$/; ocsinventory-server-2.8+dfsg1/binutils/ipdiscover-util.pl:241: my $req = $dbh->prepare('select h.deviceid, h.id, h.name, h.quality,h.fidelity,h.lastcome,h.lastdate,osname, n.ipmask, n.ipaddress from hardware h,networks n where n.hardware_id=h.id and n.ipsubnet='.$dbh->quote($ip).' order by lastdate'); ocsinventory-server-2.8+dfsg1/binutils/ipdiscover-util.pl-242- $req->execute; ############################################## ocsinventory-server-2.8+dfsg1/binutils/ipdiscover-util.pl-251- while($result = $req->fetchrow_hashref){ ocsinventory-server-2.8+dfsg1/binutils/ipdiscover-util.pl:252: my $r = $dbh->prepare('select * from devices where hardware_id='.$dbh->quote($result->{'id'}).' and tvalue='.$dbh->quote($ip).' and name="ipdiscover"'); ocsinventory-server-2.8+dfsg1/binutils/ipdiscover-util.pl-253- $r->execute; ############################################## ocsinventory-server-2.8+dfsg1/binutils/ipdiscover-util.pl-293- ($netname, $uid)= &_getnetname($network, '-'); ocsinventory-server-2.8+dfsg1/binutils/ipdiscover-util.pl:294: my @nmb = `nmblookup -A $iptarget`; ocsinventory-server-2.8+dfsg1/binutils/ipdiscover-util.pl-295- #DNS name ############################################## ocsinventory-server-2.8+dfsg1/binutils/ipdiscover-util.pl-304- } ocsinventory-server-2.8+dfsg1/binutils/ipdiscover-util.pl:305: $request = $dbh->prepare('SELECT * FROM networks WHERE IPADDRESS='.$dbh->quote($iptarget)); ocsinventory-server-2.8+dfsg1/binutils/ipdiscover-util.pl-306- $request->execute; ############################################## ocsinventory-server-2.8+dfsg1/binutils/ipdiscover-util.pl-310- }else{ ocsinventory-server-2.8+dfsg1/binutils/ipdiscover-util.pl:311: $request = $dbh->prepare('SELECT IP,TYPE FROM netmap, network_devices WHERE MAC=MACADDR AND IP='.$dbh->quote($iptarget)); ocsinventory-server-2.8+dfsg1/binutils/ipdiscover-util.pl-312- $request->execute; ############################################## ocsinventory-server-2.8+dfsg1/binutils/ipdiscover-util.pl-317- ocsinventory-server-2.8+dfsg1/binutils/ipdiscover-util.pl:318: $request = $dbh->prepare('SELECT MAC FROM netmap WHERE IP='.$dbh->quote($iptarget)); ocsinventory-server-2.8+dfsg1/binutils/ipdiscover-util.pl-319- $request->execute; ############################################## ocsinventory-server-2.8+dfsg1/binutils/ipdiscover-util.pl-569- #Analyse ocsinventory-server-2.8+dfsg1/binutils/ipdiscover-util.pl:570: system("nmap -R -v @ips -p 135,80,22,23 -oG $path/$filter.gnmap -P0 -O > /dev/null"); ocsinventory-server-2.8+dfsg1/binutils/ipdiscover-util.pl-571- # ############################################## ocsinventory-server-2.8+dfsg1/binutils/ipdiscover-util.pl-711- #If no dns name, we try a netbios resolution ocsinventory-server-2.8+dfsg1/binutils/ipdiscover-util.pl:712: my @smb = `nmblookup -A $ip`; ocsinventory-server-2.8+dfsg1/binutils/ipdiscover-util.pl-713- #On cherche un enregistrment <00> pour l'ip passee en argument ############################################## ocsinventory-server-2.8+dfsg1/binutils/ipdiscover-util.pl-756- my $name; ocsinventory-server-2.8+dfsg1/binutils/ipdiscover-util.pl:757: chomp(my @names = `host $ip 2>/dev/null`); ocsinventory-server-2.8+dfsg1/binutils/ipdiscover-util.pl-758- for(@names){ ############################################## ocsinventory-server-2.8+dfsg1/binutils/ocsinventory-log.pl-6- $a = 0; ocsinventory-server-2.8+dfsg1/binutils/ocsinventory-log.pl:7: @lines = `cat $f`; ocsinventory-server-2.8+dfsg1/binutils/ocsinventory-log.pl-8-} ocsinventory-server-2.8+dfsg1/binutils/ocsinventory-log.pl-9-else{ ocsinventory-server-2.8+dfsg1/binutils/ocsinventory-log.pl:10: @lines = `$f.$a.gz`; ocsinventory-server-2.8+dfsg1/binutils/ocsinventory-log.pl-11-} ############################################## ocsinventory-server-2.8+dfsg1/dtd/inventory_request.dtd-58-<!ELEMENT IPADDRESS (#PCDATA)> ocsinventory-server-2.8+dfsg1/dtd/inventory_request.dtd:59:<!ELEMENT IPADDR (#PCDATA)> ocsinventory-server-2.8+dfsg1/dtd/inventory_request.dtd-60-<!ELEMENT IPDHCP (#PCDATA)> ############################################## ocsinventory-server-2.8+dfsg1/dtd/inventory_request.dtd-76-<!ELEMENT LOGDATE (#PCDATA)> ocsinventory-server-2.8+dfsg1/dtd/inventory_request.dtd:77:<!ELEMENT MACADDR (#PCDATA)> ocsinventory-server-2.8+dfsg1/dtd/inventory_request.dtd-78-<!ELEMENT MANUFACTURER (#PCDATA)> ############################################## ocsinventory-server-2.8+dfsg1/dtd/snmp_request.dtd-29-<!ELEMENT DEVICEADDRESS (#PCDATA)> ocsinventory-server-2.8+dfsg1/dtd/snmp_request.dtd:30:<!ELEMENT DEVICEMACADDR (#PCDATA)> ocsinventory-server-2.8+dfsg1/dtd/snmp_request.dtd-31-<!ELEMENT DEVICENAME (#PCDATA)> ############################################## ocsinventory-server-2.8+dfsg1/dtd/snmp_request.dtd-41-<!ELEMENT FREE (#PCDATA)> ocsinventory-server-2.8+dfsg1/dtd/snmp_request.dtd:42:<!ELEMENT IPADDR (#PCDATA)> ocsinventory-server-2.8+dfsg1/dtd/snmp_request.dtd-43-<!ELEMENT IPDHCP (#PCDATA)> ############################################## ocsinventory-server-2.8+dfsg1/dtd/snmp_request.dtd-50-<!ELEMENT LOCATION (#PCDATA)> ocsinventory-server-2.8+dfsg1/dtd/snmp_request.dtd:51:<!ELEMENT MACADDR (#PCDATA)> ocsinventory-server-2.8+dfsg1/dtd/snmp_request.dtd-52-<!ELEMENT MANUFACTURER (#PCDATA)> ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/backend/AUTH/auth.php-60- while ($list_methode[$i]) { ocsinventory-server-2.8+dfsg1/ocsreports/backend/AUTH/auth.php:61: require_once('methode/' . $list_methode[$i]); ocsinventory-server-2.8+dfsg1/ocsreports/backend/AUTH/auth.php-62- if ($login_successful == "OK") ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/backend/identity/identity.php-32- while ($list_methode[$i]) { ocsinventory-server-2.8+dfsg1/ocsreports/backend/identity/identity.php:33: require_once('methode/' . $list_methode[$i]); ocsinventory-server-2.8+dfsg1/ocsreports/backend/identity/identity.php-34- //on garde les erreurs présentes ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/backend/identity/methode/ldap.php-131- echo ("field2: ".$item['CONEX_LDAP_CHECK_FIELD2_NAME']." value=".$f2_value." condition: ".$config['LDAP_CHECK_FIELD2_VALUE']." role=".$config['LDAP_CHECK_FIELD2_ROLE']." level=".$config['LDAP_CHECK_FIELD2_USERLEVEL']."<br>"); ocsinventory-server-2.8+dfsg1/ocsreports/backend/identity/methode/ldap.php:132: echo ("user: ".$_SESSION['OCS']["loggeduser"]." will have level=".$defaultLevel." and role=".$defaultRole."<br>"); ocsinventory-server-2.8+dfsg1/ocsreports/backend/identity/methode/ldap.php-133- */ ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/backend/ipdiscover/ipdiscover.php-31- while ($list_methode[$i]) { ocsinventory-server-2.8+dfsg1/ocsreports/backend/ipdiscover/ipdiscover.php:32: require_once('methode/' . $list_methode[$i]); ocsinventory-server-2.8+dfsg1/ocsreports/backend/ipdiscover/ipdiscover.php-33- //on garde les droits de l'utilisateur sur l'ipdiscover ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/crontab/cron_cve.php-26- curl_setopt($curl, CURLOPT_RETURNTRANSFER, true); ocsinventory-server-2.8+dfsg1/ocsreports/crontab/cron_cve.php:27: curl_exec($curl); ocsinventory-server-2.8+dfsg1/ocsreports/crontab/cron_cve.php-28- ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/files/ocsbase.sql-409-LOCK TABLES `downloadwk_fields` WRITE; ocsinventory-server-2.8+dfsg1/ocsreports/files/ocsbase.sql:410:INSERT INTO `downloadwk_fields` VALUES ('1','USER',3,'1038',1,1,'loggeduser',1,0,0),('2','NAME_TELEDEPLOY',0,'1037',1,2,'',1,0,0),('2','INFO_PACK',0,'53',1,3,'',1,0,0),('3','PRIORITY',2,'1039',1,4,'',1,0,0),('3','NOTIF_USER',2,'1040',1,5,'',1,0,0),('3','REPORT_USER',2,'1041',1,6,'',1,0,0),('3','REBOOT',2,'1042',1,7,'',1,0,0),('4','VALID_INSTALL',6,'1043',1,8,'',1,0,0),('4','STATUS',2,'1046',0,9,'2',1,1,0),('5','LIST_HISTO',10,'1052',0,10,'select AUTHOR,DATE,ACTION from downloadwk_history where id_dde=%s$$$$OLD_MODIF',1,0,0); ocsinventory-server-2.8+dfsg1/ocsreports/files/ocsbase.sql-411-UNLOCK TABLES; ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/files/ocsbase_new.sql-409-LOCK TABLES `downloadwk_fields` WRITE; ocsinventory-server-2.8+dfsg1/ocsreports/files/ocsbase_new.sql:410:INSERT INTO `downloadwk_fields` VALUES ('1','USER',3,'1038',1,1,'loggeduser',1,0,0),('2','NAME_TELEDEPLOY',0,'1037',1,2,'',1,0,0),('2','INFO_PACK',0,'53',1,3,'',1,0,0),('3','PRIORITY',2,'1039',1,4,'',1,0,0),('3','NOTIF_USER',2,'1040',1,5,'',1,0,0),('3','REPORT_USER',2,'1041',1,6,'',1,0,0),('3','REBOOT',2,'1042',1,7,'',1,0,0),('4','VALID_INSTALL',6,'1043',1,8,'',1,0,0),('4','STATUS',2,'1046',0,9,'2',1,1,0),('5','LIST_HISTO',10,'1052',0,10,'select AUTHOR,DATE,ACTION from downloadwk_history where id_dde=%s$$$$OLD_MODIF',1,0,0); ocsinventory-server-2.8+dfsg1/ocsreports/files/ocsbase_new.sql-411-UNLOCK TABLES; ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/install.php-136- //update ocsinventory-server-2.8+dfsg1/ocsreports/install.php:137: $res = mysql2_query_secure("select tvalue from config where name='GUI_VERSION'", $link); ocsinventory-server-2.8+dfsg1/ocsreports/install.php-138- $item = mysqli_fetch_object($res); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/ipdiscover-util.pl-188- } ocsinventory-server-2.8+dfsg1/ocsreports/ipdiscover-util.pl:189: system("./ipdiscover-util.pl -net=".$subnet{$_}.($xml?' -xml':'')." -a > $path/ipd/'".$subnet{$_}.".ipd'"); ocsinventory-server-2.8+dfsg1/ocsreports/ipdiscover-util.pl-190- $i++; ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/ipdiscover-util.pl-240- next unless $ip =~ /^\d{1,3}(?:\.\d{1,3}){3}$/; ocsinventory-server-2.8+dfsg1/ocsreports/ipdiscover-util.pl:241: my $req = $dbh->prepare('select h.deviceid, h.id, h.name, h.quality,h.fidelity,h.lastcome,h.lastdate,osname, n.ipmask, n.ipaddress from hardware h,networks n where n.hardware_id=h.id and n.ipsubnet='.$dbh->quote($ip).' order by lastdate'); ocsinventory-server-2.8+dfsg1/ocsreports/ipdiscover-util.pl-242- $req->execute; ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/ipdiscover-util.pl-251- while($result = $req->fetchrow_hashref){ ocsinventory-server-2.8+dfsg1/ocsreports/ipdiscover-util.pl:252: my $r = $dbh->prepare('select * from devices where hardware_id='.$dbh->quote($result->{'id'}).' and tvalue='.$dbh->quote($ip).' and name="ipdiscover"'); ocsinventory-server-2.8+dfsg1/ocsreports/ipdiscover-util.pl-253- $r->execute; ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/ipdiscover-util.pl-293- ($netname, $uid)= &_getnetname($network, '-'); ocsinventory-server-2.8+dfsg1/ocsreports/ipdiscover-util.pl:294: my @nmb = `nmblookup -A $iptarget`; ocsinventory-server-2.8+dfsg1/ocsreports/ipdiscover-util.pl-295- #DNS name ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/ipdiscover-util.pl-304- } ocsinventory-server-2.8+dfsg1/ocsreports/ipdiscover-util.pl:305: $request = $dbh->prepare('SELECT * FROM networks WHERE IPADDRESS='.$dbh->quote($iptarget)); ocsinventory-server-2.8+dfsg1/ocsreports/ipdiscover-util.pl-306- $request->execute; ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/ipdiscover-util.pl-310- }else{ ocsinventory-server-2.8+dfsg1/ocsreports/ipdiscover-util.pl:311: $request = $dbh->prepare('SELECT IP,TYPE FROM netmap, network_devices WHERE MAC=MACADDR AND IP='.$dbh->quote($iptarget)); ocsinventory-server-2.8+dfsg1/ocsreports/ipdiscover-util.pl-312- $request->execute; ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/ipdiscover-util.pl-317- ocsinventory-server-2.8+dfsg1/ocsreports/ipdiscover-util.pl:318: $request = $dbh->prepare('SELECT MAC FROM netmap WHERE IP='.$dbh->quote($iptarget)); ocsinventory-server-2.8+dfsg1/ocsreports/ipdiscover-util.pl-319- $request->execute; ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/ipdiscover-util.pl-569- #Analyse ocsinventory-server-2.8+dfsg1/ocsreports/ipdiscover-util.pl:570: system("nmap -R -v @ips -p 135,80,22,23 -oG $path/$filter.gnmap -P0 -O > /dev/null"); ocsinventory-server-2.8+dfsg1/ocsreports/ipdiscover-util.pl-571- # ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/ipdiscover-util.pl-711- #If no dns name, we try a netbios resolution ocsinventory-server-2.8+dfsg1/ocsreports/ipdiscover-util.pl:712: my @smb = `nmblookup -A $ip`; ocsinventory-server-2.8+dfsg1/ocsreports/ipdiscover-util.pl-713- #On cherche un enregistrment <00> pour l'ip passee en argument ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/ipdiscover-util.pl-756- my $name; ocsinventory-server-2.8+dfsg1/ocsreports/ipdiscover-util.pl:757: chomp(my @names = `host $ip 2>/dev/null`); ocsinventory-server-2.8+dfsg1/ocsreports/ipdiscover-util.pl-758- for(@names){ ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_admininfo/cd_admininfo.php-259- if($config['SELECT_DEFAULT'][$key] == 'YES'){ ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_admininfo/cd_admininfo.php:260: $sql_selected_data = "SELECT ".$value." FROM `accountinfo` WHERE `HARDWARE_ID` = ".$protectedGet['systemid']; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_admininfo/cd_admininfo.php-261- $result = mysql2_query_secure($sql_selected_data, $_SESSION['OCS']["readServer"]); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_bios/cd_bios.php-88-} ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_bios/cd_bios.php:89:$queryDetails = substr($queryDetails, 0, -1) . " FROM bios WHERE (hardware_id=$systemid)"; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_bios/cd_bios.php-90-ajaxtab_entete_fixe($list_fields, $default_fields, $tab_options, $list_col_cant_del); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_comments/cd_comments.php-101- ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_comments/cd_comments.php:102:$queryDetails = "SELECT ID,DATE_INSERT,USER_INSERT,COMMENTS,ACTION FROM itmgmt_comments WHERE (visible is null or visible =1) and hardware_id=$systemid"; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_comments/cd_comments.php-103-$list_fields = array( $l->g(1126) => 'DATE_INSERT', ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_controllers/cd_controllers.php-56-} ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_controllers/cd_controllers.php:57:$queryDetails = substr($queryDetails, 0, -1) . " FROM controllers WHERE (hardware_id=$systemid)"; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_controllers/cd_controllers.php-58-ajaxtab_entete_fixe($list_fields, $default_fields, $tab_options, $list_col_cant_del); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_drives/cd_drives.php-55-$tab_options["replace_query_arg"]['CAPACITY'] = " round(100-(FREE*100/TOTAL)) "; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_drives/cd_drives.php:56:$queryDetails = "SELECT *, round(100-(FREE*100/TOTAL)) AS CAPACITY FROM drives WHERE (hardware_id=$systemid)"; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_drives/cd_drives.php-57-ajaxtab_entete_fixe($list_fields, $default_fields, $tab_options, $list_col_cant_del); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_inputs/cd_inputs.php-50-$default_fields = $list_fields; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_inputs/cd_inputs.php:51:$queryDetails = "SELECT * FROM inputs WHERE (hardware_id=$systemid)"; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_inputs/cd_inputs.php-52-ajaxtab_entete_fixe($list_fields, $default_fields, $tab_options, $list_col_cant_del); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_memories/cd_memories.php-53-$default_fields = $list_fields; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_memories/cd_memories.php:54:$queryDetails = "SELECT * FROM memories WHERE (hardware_id=$systemid)"; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_memories/cd_memories.php-55-ajaxtab_entete_fixe($list_fields, $default_fields, $tab_options, $list_col_cant_del); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_modems/cd_modems.php-49-$default_fields = $list_fields; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_modems/cd_modems.php:50:$queryDetails = "SELECT * FROM modems WHERE (hardware_id=$systemid)"; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_modems/cd_modems.php-51-ajaxtab_entete_fixe($list_fields, $default_fields, $tab_options, $list_col_cant_del); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_monitors/cd_monitors.php-49-$default_fields = $list_fields; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_monitors/cd_monitors.php:50:$queryDetails = "SELECT * FROM monitors WHERE (hardware_id=$systemid)"; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_monitors/cd_monitors.php-51-ajaxtab_entete_fixe($list_fields, $default_fields, $tab_options, $list_col_cant_del); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_networks/cd_networks.php-98-} ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_networks/cd_networks.php:99:$queryDetails = substr($queryDetails, 0, -1) . " FROM networks WHERE (hardware_id=$systemid)"; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_networks/cd_networks.php-100-ajaxtab_entete_fixe($list_fields, $default_fields, $tab_options, $list_col_cant_del); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_pda/cd_pda.php-56- ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_pda/cd_pda.php:57:$queryDetails = "SELECT * FROM sim WHERE hardware_id=$systemid"; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_pda/cd_pda.php-58-ajaxtab_entete_fixe($list_fields, $default_fields, $tab_options, $list_col_cant_del); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_ports/cd_ports.php-44-$default_fields = $list_fields; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_ports/cd_ports.php:45:$queryDetails = "SELECT * FROM ports WHERE (hardware_id=$systemid)"; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_ports/cd_ports.php-46-ajaxtab_entete_fixe($list_fields, $default_fields, $tab_options, $list_col_cant_del); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_printers/cd_printers.php-61-$tab_options['FILTRE'] = array_flip($list_fields); ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_printers/cd_printers.php:62:$queryDetails = "SELECT * FROM printers WHERE (hardware_id=$systemid)"; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_printers/cd_printers.php-63-ajaxtab_entete_fixe($list_fields, $default_fields, $tab_options, $list_col_cant_del); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_processors/cd_processors.php-58- $default_fields = $list_fields; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_processors/cd_processors.php:59: $queryDetails = "SELECT * FROM cpus WHERE (hardware_id=$systemid)"; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_processors/cd_processors.php-60-} else { ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_processors/cd_processors.php-66- $default_fields = $list_fields; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_processors/cd_processors.php:67: $queryDetails = "SELECT * FROM hardware WHERE (id=$systemid)"; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_processors/cd_processors.php-68-} ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_registry/cd_registry.php-40- ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_registry/cd_registry.php:41:$queryDetails = "SELECT * FROM registry WHERE (hardware_id=$systemid)"; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_registry/cd_registry.php-42-ajaxtab_entete_fixe($list_fields, $default_fields, $tab_options, $list_col_cant_del); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_saas/cd_saas.php-56- } ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_saas/cd_saas.php:57: $queryDetails = substr($queryDetails, 0, -1) . " FROM saas s LEFT JOIN saas_exp e ON e.ID = s.SAAS_EXP_ID WHERE (hardware_id=$systemid)"; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_saas/cd_saas.php-58- ajaxtab_entete_fixe($list_fields, $default_fields, $tab_options, $list_col_cant_del); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_slots/cd_slots.php-43-//$tab_options['FILTRE']=array('NAME'=>$l->g(212),'REGVALUE'=>$l->g(213));; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_slots/cd_slots.php:44:$queryDetails = "SELECT * FROM slots WHERE (hardware_id=$systemid)"; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_slots/cd_slots.php-45-ajaxtab_entete_fixe($list_fields, $default_fields, $tab_options, $list_col_cant_del); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_softwares/cd_softwares.php-79- LEFT JOIN software_categories c ON c.id = s.category ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_softwares/cd_softwares.php:80: WHERE (hardware_id=$systemid)"; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_softwares/cd_softwares.php-81- $list_fields[$l->g(49)] = 's_name.NAME'; ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_softwares/cd_softwares.php-87- LEFT JOIN software_categories c ON n.CATEGORY = c.ID ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_softwares/cd_softwares.php:88: WHERE (hardware_id=$systemid)"; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_softwares/cd_softwares.php-89- $list_fields[$l->g(49)] = 'NAME'; ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_sounds/cd_sounds.php-47-$default_fields = $list_fields; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_sounds/cd_sounds.php:48:$queryDetails = "SELECT * FROM sounds WHERE (hardware_id=$systemid)"; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_sounds/cd_sounds.php-49-ajaxtab_entete_fixe($list_fields, $default_fields, $tab_options, $list_col_cant_del); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_storages/cd_storages.php-50-$tab_options['FILTRE'] = array('NAME' => $l->g(49), 'MANUFACTURER' => $l->g(64), 'TYPE' => $l->g(66)); ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_storages/cd_storages.php:51:$queryDetails = "SELECT * FROM storages WHERE (hardware_id=$systemid)"; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_storages/cd_storages.php-52-ajaxtab_entete_fixe($list_fields, $default_fields, $tab_options, $list_col_cant_del); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_videos/cd_videos.php-48-$default_fields = $list_fields; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_videos/cd_videos.php:49:$queryDetails = "SELECT * FROM videos WHERE (hardware_id = $systemid)"; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/cd_videos/cd_videos.php-50-ajaxtab_entete_fixe($list_fields, $default_fields, $tab_options, $list_col_cant_del); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/require/functions.php-39- } ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/require/functions.php:40: $queryDetails = substr($queryDetails, 0, -1) . " FROM " . $table . " WHERE (hardware_id=$systemid)"; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/computer_detail/require/functions.php-41- ajaxtab_entete_fixe($list_fields, $default_fields, $tab_options, $list_col_cant_del); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_admininfo/ms_admininfo.php-217- ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_admininfo/ms_admininfo.php:218: $queryDetails = "select ID," . implode(',', $array_fields) . " from accountinfo_config where ACCOUNT_TYPE = '" . $account_choise . "'"; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_admininfo/ms_admininfo.php-219- ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_admininfo/ms_admininfo.php-236- $tab_options['LBL_POPUP']['SUP'] = 'NAME'; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_admininfo/ms_admininfo.php:237: $tab_options['REQUEST']['SUP'] = "select name_accountinfo AS FIRST from accountinfo_config where ACCOUNT_TYPE = '" . $account_choise . "'"; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_admininfo/ms_admininfo.php-238- $tab_options['FIELD']['SUP'] = 'NAME'; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_admininfo/ms_admininfo.php-239- $tab_options['EXIST']['SUP'] = 'NAME'; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_admininfo/ms_admininfo.php:240: $tab_options['REQUEST']['CHECK'] = "select name_accountinfo AS FIRST from accountinfo_config where ACCOUNT_TYPE = '" . $account_choise . "'"; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_admininfo/ms_admininfo.php-241- $tab_options['FIELD']['CHECK'] = 'NAME'; ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_config/ms_snmp_config.php-203- if($protectedPost['type_filter'] != "empty" && $protectedPost['type_filter'] != null) { ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_config/ms_snmp_config.php:204: $filter = " WHERE c.TYPE_ID ='".$protectedPost['type_filter']."'"; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_config/ms_snmp_config.php-205- } else { ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_cve_correspondance/ms_cve_correspondance.php-99- if (is_defined($protectedPost['SUP_PROF'])) { ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_cve_correspondance/ms_cve_correspondance.php:100: $reqDcatall = "DELETE FROM cve_search_correspondance WHERE ID = ".$protectedPost['SUP_PROF']; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_cve_correspondance/ms_cve_correspondance.php-101- mysqli_query($_SESSION['OCS']["writeServer"], $reqDcatall) or die(mysqli_error($_SESSION['OCS']["writeServer"])); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_dict/ms_dict.php-117- $sql_list_cat = "select formatted name ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_dict/ms_dict.php:118: from dico_soft where extracted!=formatted " . $search_count . " group by formatted"; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_dict/ms_dict.php-119- $result_list_cat = mysqli_query($_SESSION['OCS']["readServer"], $sql_list_cat); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_dict/ms_dict.php-132- } ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_dict/ms_dict.php:133: $reqDcat = "DELETE FROM dico_soft WHERE formatted='" . $list_cat[$protectedPost['SUP_CAT']] . "'"; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_dict/ms_dict.php-134- mysqli_query($_SESSION['OCS']["writeServer"], $reqDcat) or die(mysqli_error($_SESSION['OCS']["writeServer"])); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_dict/ms_dict.php-170- $querydico .= " from dico_soft left join " . $table . " cache on dico_soft.extracted=cache.name ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_dict/ms_dict.php:171: where formatted='" . mysqli_real_escape_string($_SESSION['OCS']["readServer"], $list_cat[$protectedPost['onglet_soft']]) . "' " . $search_count . " group by EXTRACTED"; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_dict/ms_dict.php-172-} ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_dict/ms_dict.php-279- $querydico .= " from dico_soft left join " . $table . " cache on cache.name=dico_soft.extracted ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_dict/ms_dict.php:280: where extracted=formatted " . $search_cache . " group by EXTRACTED "; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_dict/ms_dict.php-281-} ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_doubles/ms_doubles.php-53- while (isset($list_id_fusion[$i])) { ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_doubles/ms_doubles.php:54: $res = mysqli_query($_SESSION['OCS']["readServer"], "SELECT deviceid,id,lastcome FROM hardware WHERE id=" . $list_id_fusion[$i]) or die(mysqli_error($_SESSION['OCS']["readServer"])); ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_doubles/ms_doubles.php-55- $afus[] = mysqli_fetch_array($res, MYSQLI_ASSOC); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_export/ms_soft_csv.php-55- } ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_export/ms_soft_csv.php:56: $sql['SQL'] .= " ,accountinfo a where a.hardware_id=softwares.hardware_id and softwares." . $info_name_soft["field_name_soft"] . " in ("; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_export/ms_soft_csv.php-57- $sql['SQL'] .= $sql_list_soft['SQL'] . " )"; ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_export/ms_soft_csv.php-76- $sql['SQL'] = "select count(*) nb, " . $field_name_soft . " from " . $info_name_soft['table']; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_export/ms_soft_csv.php:77: $sql['SQL'] .= " , accountinfo a where a.hardware_id=" . $info_name_soft['table'] . ".hardware_id "; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_export/ms_soft_csv.php-78- if (is_defined($protectedGet['soft'])) { ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_groups/ms_group_show.php-234- ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_groups/ms_group_show.php:235: require(MAIN_SECTIONS_DIR . "/" . $_SESSION['OCS']['url_service']->getDirectory('ms_server_redistrib') . "/ms_server_redistrib.php"); ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_groups/ms_group_show.php-236- ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_groups/ms_group_show.php-446- ,groups_cache e ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_groups/ms_group_show.php:447: where group_id='" . $systemid . "' and h.id=e.HARDWARE_ID "; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_groups/ms_group_show.php-448- if (isset($mesmachines) && $mesmachines != '') { ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_groups/ms_group_show.php-470- $i = 0; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_groups/ms_group_show.php:471: $queryDetails = "SELECT * FROM devices WHERE hardware_id=$systemid"; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_groups/ms_group_show.php-472- $resultDetails = mysqli_query($_SESSION['OCS']["readServer"], $queryDetails) or die(mysqli_error($_SESSION['OCS']["readServer"])); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_plugins/functions_check.php-53- ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_plugins/functions_check.php:54: $query = $conn->query("SELECT EXISTS( SELECT * FROM `plugins` WHERE name = '" . $value . "' ) AS name_exists"); ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_plugins/functions_check.php-55- $anwser = $query->fetch(); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_search_soft/ms_search_soft.php-110- $queryDetails .= " FROM hardware h INNER JOIN softwares s ON s.hardware_id = h.ID INNER JOIN accountinfo a ON a.hardware_id = h.ID ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_search_soft/ms_search_soft.php:111: WHERE s.HARDWARE_ID =h.ID and s.NAME like '" . $logiciel . "' "; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_search_soft/ms_search_soft.php-112- }else{ ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_search_soft/ms_search_soft.php-113- $queryDetails .= " FROM hardware h INNER JOIN softwares s ON s.hardware_id = h.ID INNER JOIN accountinfo a ON a.hardware_id = h.ID ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_search_soft/ms_search_soft.php:114: WHERE s.HARDWARE_ID =h.ID and s.NAME='" . $logiciel . "' "; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_search_soft/ms_search_soft.php-115- } ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_search_soft/require/fonction.inc.php-40- echo "<br /><b><i>Vous avez choisi :<br />" . $var . "</i></b>"; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_search_soft/require/fonction.inc.php:41: $sql_version = "SELECT hardware.NAME AS 'hnom',hardware.IPADDR AS 'ip',hardware.WORKGROUP AS 'domaine', softwares.NAME AS 'snom', softwares.VERSION AS 'sversion',softwares.FOLDER as 'sfold' FROM hardware INNER JOIN softwares ON softwares.HARDWARE_ID =hardware.ID WHERE softwares.NAME='$var' ORDER BY softwares.VERSION"; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_search_soft/require/fonction.inc.php-42- $query_version = mysqli_query($_SESSION['OCS']["readServer"], $sql_version); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_search_soft/require/fonction.inc.php-58-function csv($var) { ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_search_soft/require/fonction.inc.php:59: $sql_version = "SELECT hardware.NAME AS 'hnom',softwares.NAME AS 'snom',softwares.VERSION AS 'sversion', softwares.FOLDER as 'sfold', hardware.IPADDR AS 'ip',hardware.WORKGROUP AS 'domaine' FROM hardware INNER JOIN softwares ON softwares.HARDWARE_ID =hardware.ID WHERE softwares.NAME='$var' ORDER BY softwares.VERSION"; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_search_soft/require/fonction.inc.php-60- $query_version = mysqli_query($_SESSION['OCS']["readServer"], $sql_version); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_server_infos/ms_server_infos.php-96- <li><?php echo PHP_MAJOR_VERSION.".".PHP_MINOR_VERSION.".".PHP_RELEASE_VERSION; ?></li> ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_server_infos/ms_server_infos.php:97: <li><?php echo $_SERVER['SERVER_SOFTWARE']; ?></li> ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_server_infos/ms_server_infos.php-98- <li><?php ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_server_infos/ms_server_infos.php-121- <ul class="server-information-ul-li"> ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_server_infos/ms_server_infos.php:122: <li><?php echo $_SERVER['SERVER_ADDR']; ?></li> ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_server_infos/ms_server_infos.php-123- </ul> ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_snmp/ms_snmp_detail.php-168- if (file_exists($Directory . "/" . $protectedPost['onglet_sd'] . "/" . $protectedPost['onglet_sd'] . ".php")) { ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_snmp/ms_snmp_detail.php:169: include ($Directory . "/" . $protectedPost['onglet_sd'] . "/" . $protectedPost['onglet_sd'] . ".php"); ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_snmp/ms_snmp_detail.php-170- } ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_snmp/require/function_snmp.php-62- $reqSub = "select NAME,NETID from subnet left join networks on networks.ipsubnet = subnet.netid ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_snmp/require/function_snmp.php:63: where networks.status='Up' and hardware_id=" . $systemid; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_snmp/require/function_snmp.php-64- $resSub = mysqli_query($_SESSION['OCS']["readServer"], $reqSub) or die(mysqli_error($_SESSION['OCS']["readServer"])); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_soft_cat/ms_soft_cat.php-99- } ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_soft_cat/ms_soft_cat.php:100: $reqDcatall = "DELETE FROM software_category_exp WHERE CATEGORY_ID = (SELECT ID FROM software_categories WHERE CATEGORY_NAME = '" . $list_cat[$protectedPost['SUP_CAT']] . "')"; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_soft_cat/ms_soft_cat.php-101- mysqli_query($_SESSION['OCS']["writeServer"], $reqDcatall) or die(mysqli_error($_SESSION['OCS']["writeServer"])); ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_soft_cat/ms_soft_cat.php:102: $reqDcat = "DELETE FROM software_categories WHERE CATEGORY_NAME ='" . $list_cat[$protectedPost['SUP_CAT']] . "'"; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_soft_cat/ms_soft_cat.php-103- mysqli_query($_SESSION['OCS']["writeServer"], $reqDcat) or die(mysqli_error($_SESSION['OCS']["writeServer"])); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_soft_cat/ms_soft_cat.php-121- if (is_defined($protectedPost['SUP_PROF'])) { ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_soft_cat/ms_soft_cat.php:122: $reqDreg = "DELETE FROM software_category_exp WHERE CATEGORY_ID ='" . $categorie_id[$list_cat[$protectedPost['onglet_soft']]] . "' AND ID = ".$protectedPost['SUP_PROF']; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_soft_cat/ms_soft_cat.php-123- mysqli_query($_SESSION['OCS']["writeServer"], $reqDreg) or die(mysqli_error($_SESSION['OCS']["writeServer"])); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_soft_cat/ms_soft_cat.php-192- LEFT JOIN software_version v ON v.ID = s.VERSION_ID ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_soft_cat/ms_soft_cat.php:193: WHERE n.CATEGORY =".$categorie_id[$list_cat[$protectedPost['onglet_soft']]]." GROUP BY n.NAME, v.VERSION"; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_soft_cat/ms_soft_cat.php-194- $default_fields = $list_fields; ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_teledeploy/ms_server_redistrib.php-49- if($protectedPost['Valid_modif'] != ""){ ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_teledeploy/ms_server_redistrib.php:50: $sql_update = "update download_servers set URL='" . $protectedPost['URL'] . "' ,ADD_REP='" . $protectedPost['REP_STORE'] . "' where hardware_id=" . $protectedPost['MODIF']; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_teledeploy/ms_server_redistrib.php-51- mysqli_query($_SESSION['OCS']["writeServer"], $sql_update); ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_teledeploy/ms_server_redistrib.php:52: $sql_update = "update download_enable set pack_loc='" . $protectedPost['URL'] . "' where SERVER_ID=" . $protectedPost['MODIF']; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_teledeploy/ms_server_redistrib.php-53- mysqli_query($_SESSION['OCS']["writeServer"], $sql_update); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_teledeploy/ms_server_redistrib.php-77- from hardware h right join download_servers d on h.id=d.hardware_id ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_teledeploy/ms_server_redistrib.php:78: where d.GROUP_ID=".$systemid ; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_teledeploy/ms_server_redistrib.php-79- ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_teledeploy/ms_server_redistrib.php-108- ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_teledeploy/ms_server_redistrib.php:109: $sql = "select URL, ADD_REP from download_servers where HARDWARE_ID = ".$protectedPost['MODIF'] ; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_teledeploy/ms_server_redistrib.php-110- $result = mysql2_query_secure($sql, $_SESSION['OCS']["readServer"]); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_teledeploy/ms_tele_actives.php-50- } ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_teledeploy/ms_tele_actives.php:51: mysql2_query_secure("DELETE FROM download_enable WHERE FILEID=%s", $_SESSION['OCS']["writeServer"], $protectedPost['DEL_ALL']); ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_teledeploy/ms_tele_actives.php-52- echo "<script>window.opener.document.packlist.submit(); self.close();</script>"; ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_teledeploy/ms_tele_actives.php-55- desactive_packet('', $protectedPost['SUP_PROF']); ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_teledeploy/ms_tele_actives.php:56: mysql2_query_secure("DELETE FROM download_enable WHERE ID=%s", $_SESSION['OCS']["writeServer"], $protectedPost['SUP_PROF']); ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_teledeploy/ms_tele_actives.php-57- } ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_teledeploy/ms_tele_actives.php-90-$querypack .= " from download_enable e RIGHT JOIN download_available a ON a.fileid = e.fileid ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_teledeploy/ms_tele_actives.php:91: where e.FILEID=" . $protectedGet['timestamp']; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_teledeploy/ms_tele_actives.php-92-$tab_options['form_name'] = $form_name; ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_teledeploy/ms_tele_popup_active.php-68- if ($protectedPost['choix_activ'] == "MAN") { ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_teledeploy/ms_tele_popup_active.php:69: $reqFrags = "SELECT fragments FROM download_available WHERE fileid='" . $protectedGet["active"] . "'"; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_teledeploy/ms_tele_popup_active.php-70- $resFrags = mysqli_query($_SESSION['OCS']["readServer"], $reqFrags); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_upload_file/ms_local.php-56- } ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_upload_file/ms_local.php:57: alert('<?php echo mysqli_real_escape_string($_SESSION['OCS']["readServer"],$l->g(559)) ?>'); ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_upload_file/ms_local.php-58- return (false); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_upload_file/ms_upload_file_popup.php-111- $queryDetails = substr($queryDetails, 0, -1); ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_upload_file/ms_upload_file_popup.php:112: $queryDetails .= " FROM temp_files where fields_name = '" . $field . "' ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_upload_file/ms_upload_file_popup.php-113- and (id_dde is null or id_dde='" . $protectedGet["dde"] . "')"; ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_users/ms_admin_user_group.php-54- if (isset($protectedPost['SUP_PROF'])) { ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_users/ms_admin_user_group.php:55: mysqli_query($_SESSION['OCS']["writeServer"], "DELETE FROM config WHERE name='USER_GROUP_" . $protectedPost['SUP_PROF'] . "'"); ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_users/ms_admin_user_group.php-56- } ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_users/ms_admin_user_group.php-80- if (trim($protectedPost['newfield']) != '') { ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_users/ms_admin_user_group.php:81: $sql_verif = "SELECT count(*) c FROM config WHERE TVALUE = '" . $protectedPost['newfield'] . "' and NAME like 'USER_GROUP%'"; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_users/ms_admin_user_group.php-82- $res_verif = mysqli_query($_SESSION['OCS']["readServer"], $sql_verif); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_users/ms_custom_perim.php-133-echo "<br>"; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_users/ms_custom_perim.php:134:echo $l->g(617) . " " . $_SESSION['OCS']['TAG_LBL']['TAG'] . ": " . $select_choise; ocsinventory-server-2.8+dfsg1/ocsreports/plugins/main_sections/ms_users/ms_custom_perim.php-135-echo "<input type='submit' name='ADD_TAG' value='" . $l->g(13) . "' class='btn'><br>"; ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/require/commandLine/CommandLine.php-34- $cmd = "snmptranslate -Tz -m ".$values['tvalue']['SNMP_MIB_DIRECTORY']."/".$file; ocsinventory-server-2.8+dfsg1/ocsreports/require/commandLine/CommandLine.php:35: $result_cmd = shell_exec(escapeshellcmd($cmd)); ocsinventory-server-2.8+dfsg1/ocsreports/require/commandLine/CommandLine.php-36- $result_cmd = preg_split("/\r\n|\n|\r/", $result_cmd); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/require/console/Console.php-39- foreach($machine as $key => $value){ ocsinventory-server-2.8+dfsg1/ocsreports/require/console/Console.php:40: $sql = "SELECT DISTINCT h.name, count(h.id) as nb, h.USERAGENT FROM hardware h LEFT JOIN accountinfo a ON a.HARDWARE_ID = h.id WHERE h.lastcome >= date_format(sysdate(),'%Y-%m-%d 00:00:00') AND h.USERAGENT LIKE '%$key%'"; ocsinventory-server-2.8+dfsg1/ocsreports/require/console/Console.php-41- if (is_defined($_SESSION['OCS']["mesmachines"])) { ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/require/cve/Cve.php-214- curl_setopt ($curl, CURLOPT_RETURNTRANSFER, 1); ocsinventory-server-2.8+dfsg1/ocsreports/require/cve/Cve.php:215: $result = curl_exec ($curl); ocsinventory-server-2.8+dfsg1/ocsreports/require/cve/Cve.php-216- $vars = json_decode($result, true); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/require/cve/Cve.php-361- curl_setopt ($curl, CURLOPT_RETURNTRANSFER, 1); ocsinventory-server-2.8+dfsg1/ocsreports/require/cve/Cve.php:362: $result = curl_exec ($curl); ocsinventory-server-2.8+dfsg1/ocsreports/require/cve/Cve.php-363- $vars = json_decode($result, true); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/require/footer.php-48- if ($_SESSION['OCS']["DEBUG"] == "ON") { ocsinventory-server-2.8+dfsg1/ocsreports/require/footer.php:49: echo "<b>CACHE: <font color='" . ($_SESSION['OCS']["usecache"] ? "green'><b>ON</b>" : "red'><b>OFF</b>") . "</font> <font color='black'><b>" . round($fin - $debut, 3) . " secondes</b></font> "; ocsinventory-server-2.8+dfsg1/ocsreports/require/footer.php-50- echo "<script language='javascript'>document.getElementById(\"tps\").innerHTML=\"<b>" . round($fin - $debut, 3) . " secondes</b>\"</script>"; ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/require/function_admininfo.php-197- if ($type != '') { ocsinventory-server-2.8+dfsg1/ocsreports/require/function_admininfo.php:198: $where = " where account_type='" . $type . "' "; ocsinventory-server-2.8+dfsg1/ocsreports/require/function_admininfo.php-199- $and = " and account_type='" . $type . "' "; ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/require/function_admininfo.php-206- if ($where != '') { ocsinventory-server-2.8+dfsg1/ocsreports/require/function_admininfo.php:207: $where .= " and type not in (" . $exclu_type . ") "; ocsinventory-server-2.8+dfsg1/ocsreports/require/function_admininfo.php-208- $and .= " and type not in (" . $exclu_type . ")"; ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/require/function_admininfo.php-215- } elseif ($id != '') { ocsinventory-server-2.8+dfsg1/ocsreports/require/function_admininfo.php:216: $sql_info_account = "select " . implode(',', $list_field) . " from accountinfo_config where id=%s " . $and . " order by show_order DESC"; ocsinventory-server-2.8+dfsg1/ocsreports/require/function_admininfo.php-217- $arg_info_account = array($id); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/require/function_admininfo.php-236- if ($account_type != '') { ocsinventory-server-2.8+dfsg1/ocsreports/require/function_admininfo.php:237: $sql_accountinfo .= " where account_type = '" . $account_type . "' "; ocsinventory-server-2.8+dfsg1/ocsreports/require/function_admininfo.php-238- } ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/require/function_computers.php-152- //Deleted computers tracking ocsinventory-server-2.8+dfsg1/ocsreports/require/function_computers.php:153: if ($traceDel && mysqli_num_rows(mysql2_query_secure("SELECT IVALUE FROM config WHERE IVALUE>0 AND NAME='TRACE_DELETED'", $_SESSION['OCS']["readServer"]))) { ocsinventory-server-2.8+dfsg1/ocsreports/require/function_computers.php-154- $sql = "insert into deleted_equiv(DELETED,EQUIVALENT) values('%s',%s)"; ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/require/function_computers.php-205- //TRACE_DELETED ocsinventory-server-2.8+dfsg1/ocsreports/require/function_computers.php:206: if (mysqli_num_rows(mysql2_query_secure("SELECT * FROM config WHERE IVALUE>0 AND NAME='TRACE_DELETED'", $_SESSION['OCS']["readServer"]))) { ocsinventory-server-2.8+dfsg1/ocsreports/require/function_computers.php-207- foreach ($afus as $a) { ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/require/function_console.php-26-if ($_SESSION['OCS']["TAGS"]) { ocsinventory-server-2.8+dfsg1/ocsreports/require/function_console.php:27: $sql_tag = mysql2_prepare('select id from hardware h, accountinfo a where a.hardware_id=h.id and a.tag in ', array(), $_SESSION['OCS']["TAGS"]); ocsinventory-server-2.8+dfsg1/ocsreports/require/function_console.php-28- $result = mysql2_query_secure($sql_tag['SQL'], $_SESSION['OCS']["readServer"], $sql_tag['ARG']); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/require/function_console.php-214- "OCS_REPORT_RESOLUTION" => array('ARG' => array('count(distinct resolution) c', $table["OCS_REPORT_RESOLUTION"], '')), ocsinventory-server-2.8+dfsg1/ocsreports/require/function_console.php:215: "OCS_REPORT_NB_LIMIT_FREQ_H" => array('ARG' => array('count(id) c', $table["OCS_REPORT_NB_LIMIT_FREQ_H"], "where processors >= " . $data_limit['GUI_REPORT_PROC_MAX'])), ocsinventory-server-2.8+dfsg1/ocsreports/require/function_console.php:216: "OCS_REPORT_NB_LIMIT_FREQ_M" => array('ARG' => array('count(id) c', $table["OCS_REPORT_NB_LIMIT_FREQ_M"], "where processors <= " . $data_limit['GUI_REPORT_PROC_MINI'])), ocsinventory-server-2.8+dfsg1/ocsreports/require/function_console.php:217: "OCS_REPORT_NB_LIMIT_FREQ_B" => array('ARG' => array('count(id) c', $table["OCS_REPORT_NB_LIMIT_FREQ_B"], "where processors <= " . $data_limit['GUI_REPORT_PROC_MAX'] . " and processors >= " . $data_limit['GUI_REPORT_PROC_MINI'])), ocsinventory-server-2.8+dfsg1/ocsreports/require/function_console.php:218: "OCS_REPORT_NB_LIMIT_MEM_H" => array('ARG' => array('count(id) c', $table["OCS_REPORT_NB_LIMIT_MEM_H"], "where memory >= " . $data_limit['GUI_REPORT_RAM_MAX'])), ocsinventory-server-2.8+dfsg1/ocsreports/require/function_console.php:219: "OCS_REPORT_NB_LIMIT_MEM_M" => array('ARG' => array('count(id) c', $table["OCS_REPORT_NB_LIMIT_MEM_M"], "where memory <= " . $data_limit['GUI_REPORT_RAM_MINI'])), ocsinventory-server-2.8+dfsg1/ocsreports/require/function_console.php:220: "OCS_REPORT_NB_LIMIT_MEM_B" => array('ARG' => array('count(id) c', $table["OCS_REPORT_NB_LIMIT_MEM_B"], "where memory <= " . $data_limit['GUI_REPORT_RAM_MAX'] . " and memory >= " . $data_limit['GUI_REPORT_RAM_MINI'])), ocsinventory-server-2.8+dfsg1/ocsreports/require/function_console.php-221- "OCS_REPORT_NB_ALL_COMPUTOR" => array('ARG' => array('count(id) c', $table["OCS_REPORT_NB_ALL_COMPUTOR"], '')), ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/require/function_dico.php-68- if ($new_cat != '') { ocsinventory-server-2.8+dfsg1/ocsreports/require/function_dico.php:69: $sql_verif = "select extracted from dico_soft where formatted ='" . mysqli_real_escape_string($_SESSION['OCS']["readServer"], $new_cat) . "'"; ocsinventory-server-2.8+dfsg1/ocsreports/require/function_dico.php-70- $result_search_soft = mysqli_query($_SESSION['OCS']["readServer"], $sql_verif); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/require/function_ipdiscover.php-254- $command = "perl ipdiscover-util.pl $command -xml -h=" . SERVER_READ . " -P=" . SERVER_PORT . " -u=" . COMPTE_BASE . " -p=" . PSWD_BASE . " -d=" . DB_NAME . " -path=" . $fname; ocsinventory-server-2.8+dfsg1/ocsreports/require/function_ipdiscover.php:255: exec($command); ocsinventory-server-2.8+dfsg1/ocsreports/require/function_ipdiscover.php-256-} ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/require/function_machine.php-71- $querydeviceid = "SELECT * FROM hardware h left join accountinfo a on a.hardware_id=h.id ocsinventory-server-2.8+dfsg1/ocsreports/require/function_machine.php:72: WHERE h.id=" . $systemid . " "; ocsinventory-server-2.8+dfsg1/ocsreports/require/function_machine.php-73- if ($_SESSION['OCS']['profile']->getRestriction('GUI') == "YES" ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/require/function_machine.php-91- $reqSub = "select NAME,NETID from subnet left join networks on networks.ipsubnet = subnet.netid ocsinventory-server-2.8+dfsg1/ocsreports/require/function_machine.php:92: where networks.status='Up' and hardware_id=" . $systemid; ocsinventory-server-2.8+dfsg1/ocsreports/require/function_machine.php-93- $resSub = mysqli_query($_SESSION['OCS']["readServer"], $reqSub) or die(mysqli_error($_SESSION['OCS']["readServer"])); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/require/function_table_html.php-295- var form_name = "form#<?php echo $option['form_name']; ?>"; ocsinventory-server-2.8+dfsg1/ocsreports/require/function_table_html.php:296: var csrfid = "input#CSRF_<?php echo $_SESSION['OCS']['CSRFNUMBER']; ?>"; ocsinventory-server-2.8+dfsg1/ocsreports/require/function_table_html.php-297- ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/require/function_table_html.php-338- //Add CSRF ocsinventory-server-2.8+dfsg1/ocsreports/require/function_table_html.php:339: d.CSRF_<?php echo $_SESSION['OCS']['CSRFNUMBER']; ?> = $(csrfid).val(); ocsinventory-server-2.8+dfsg1/ocsreports/require/function_table_html.php-340- var visible = []; ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/require/function_telediff.php-287- select %s,'%s',url,'INSTALL_PATH','INSTALL_PATH/cacert.pem', ocsinventory-server-2.8+dfsg1/ocsreports/require/function_telediff.php:288: HARDWARE_ID, GROUP_ID from download_servers where GROUP_ID=%s" . $listDoub; ocsinventory-server-2.8+dfsg1/ocsreports/require/function_telediff.php-289- $arg = array($fileid, $https_server, $id_server_group); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/require/function_telediff.php-485- //delete all package with the same id ocsinventory-server-2.8+dfsg1/ocsreports/require/function_telediff.php:486: mysql2_query_secure("DELETE FROM download_available WHERE FILEID='%s'", $_SESSION['OCS']["writeServer"], $sql_details['timestamp']); ocsinventory-server-2.8+dfsg1/ocsreports/require/function_telediff.php-487- //insert new package ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/require/header.php-438- if(file_exists(MAIN_SECTIONS_DIR . $rep . "/" . $url_name . ".php")){ ocsinventory-server-2.8+dfsg1/ocsreports/require/header.php:439: require (MAIN_SECTIONS_DIR . $rep . "/" . $url_name . ".php"); ocsinventory-server-2.8+dfsg1/ocsreports/require/header.php-440- }elseif (file_exists($rep . "/" . $url_name . ".php")){ ocsinventory-server-2.8+dfsg1/ocsreports/require/header.php:441: require ($rep . "/" . $url_name . ".php"); ocsinventory-server-2.8+dfsg1/ocsreports/require/header.php-442- }else{ ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/require/header.php-450- } else if ($profile->hasPage('ms_console')) { ocsinventory-server-2.8+dfsg1/ocsreports/require/header.php:451: require ($default_first_page); ocsinventory-server-2.8+dfsg1/ocsreports/require/header.php-452- } else { ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/require/html_header.php-87- if ($_SESSION['OCS']['DEBUG'] == 'ON') { ocsinventory-server-2.8+dfsg1/ocsreports/require/html_header.php:88: echo "<li class='dropdown-header' >CACHE: <font color='" . ($_SESSION['OCS']["usecache"] ? "green'>ON" : "red'>OFF") . "</font></li>"; ocsinventory-server-2.8+dfsg1/ocsreports/require/html_header.php-89- echo "<li class='dropdown-header'><span id='tps'>wait...</span></li>"; ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/require/ipdiscover/Ipdiscover.php-299- $command = "perl ipdiscover-util.pl $command -xml -h=" . SERVER_READ . " -P=" . SERVER_PORT . " -u=" . COMPTE_BASE . " -p=" . PSWD_BASE . " -d=" . DB_NAME . " -path=" . $fname; ocsinventory-server-2.8+dfsg1/ocsreports/require/ipdiscover/Ipdiscover.php:300: exec($command); ocsinventory-server-2.8+dfsg1/ocsreports/require/ipdiscover/Ipdiscover.php-301- } ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/require/plugin/ComputerPlugin.php-55- ocsinventory-server-2.8+dfsg1/ocsreports/require/plugin/ComputerPlugin.php:56: public function setSystem($system) { ocsinventory-server-2.8+dfsg1/ocsreports/require/plugin/ComputerPlugin.php-57- $this->system = $system; ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/require/search/DatabaseSearch.php-220- $sql= "SELECT id FROM download_enable d_e LEFT JOIN download_available d_a ON d_a.fileid=d_e.fileid ocsinventory-server-2.8+dfsg1/ocsreports/require/search/DatabaseSearch.php:221: WHERE 1=1 AND d_a.comment NOT LIKE '%[VISIBLE=0]%' AND d_e.fileid='".$fileid."'"; ocsinventory-server-2.8+dfsg1/ocsreports/require/search/DatabaseSearch.php-222- $idPackage = mysql2_query_secure($sql, $this->dbObject); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/require/search/Search.php-432- && $value[self::SESS_OPERATOR] != "NOT IN") { ocsinventory-server-2.8+dfsg1/ocsreports/require/search/Search.php:433: $this->columnsQueryConditions .= "$operator[$p] $open EXISTS (SELECT 1 FROM %s WHERE hardware.ID = %s.HARDWARE_ID AND %s.%s %s '%s')$close "; ocsinventory-server-2.8+dfsg1/ocsreports/require/search/Search.php-434- $this->queryArgs[] = $nameTable; ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/require/search/Search.php-441- || $value[self::SESS_OPERATOR] == "NOT IN"){ ocsinventory-server-2.8+dfsg1/ocsreports/require/search/Search.php:442: $this->columnsQueryConditions .= "$operator[$p] $open EXISTS (SELECT 1 FROM %s WHERE hardware.ID = %s.HARDWARE_ID AND %s.%s %s (%s))$close "; ocsinventory-server-2.8+dfsg1/ocsreports/require/search/Search.php-443- if($nameTable == self::GROUP_TABLE){ ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/require/search/Search.php-458- } elseif($value[self::SESS_OPERATOR] == "ISNOTEMPTY") { ocsinventory-server-2.8+dfsg1/ocsreports/require/search/Search.php:459: $this->columnsQueryConditions .= "$operator[$p] $open EXISTS (SELECT 1 FROM %s WHERE hardware.ID = %s.HARDWARE_ID AND %s.%s IS NOT NULL AND TRIM(%s.%s) != '')$close "; ocsinventory-server-2.8+dfsg1/ocsreports/require/search/Search.php-460- $this->queryArgs[] = $nameTable; ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/require/search/Search.php-493- if ($nameTable != DatabaseSearch::COMPUTER_DEF_TABLE) { ocsinventory-server-2.8+dfsg1/ocsreports/require/search/Search.php:494: $this->columnsQueryConditions .= "$operator[$p] $open EXISTS (SELECT 1 FROM %s WHERE hardware.ID = %s.HARDWARE_ID AND %s.%s %s)$close "; ocsinventory-server-2.8+dfsg1/ocsreports/require/search/Search.php-495- $this->queryArgs[] = $nameTable; ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/require/search/SQLCache.php-164- SELECT 1 FROM $nameTable ocsinventory-server-2.8+dfsg1/ocsreports/require/search/SQLCache.php:165: WHERE hardware.ID = $nameTable.HARDWARE_ID ocsinventory-server-2.8+dfsg1/ocsreports/require/search/SQLCache.php-166- AND $nameTable.$argFields $argOperators '$argValues')$close "; ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/require/search/SQLCache.php-172- SELECT 1 FROM $nameTable ocsinventory-server-2.8+dfsg1/ocsreports/require/search/SQLCache.php:173: WHERE hardware.ID = $nameTable.HARDWARE_ID ocsinventory-server-2.8+dfsg1/ocsreports/require/search/SQLCache.php-174- AND hardware.ID $argOperators ($argValues))$close "; ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/require/search/SQLCache.php-177- SELECT 1 FROM $nameTable ocsinventory-server-2.8+dfsg1/ocsreports/require/search/SQLCache.php:178: WHERE hardware.ID = $nameTable.HARDWARE_ID ocsinventory-server-2.8+dfsg1/ocsreports/require/search/SQLCache.php-179- AND $nameTable.$argFields $argOperators ($argValues))$close "; ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/require/search/SQLCache.php-183- SELECT 1 FROM $nameTable ocsinventory-server-2.8+dfsg1/ocsreports/require/search/SQLCache.php:184: WHERE hardware.ID = $nameTable.HARDWARE_ID ocsinventory-server-2.8+dfsg1/ocsreports/require/search/SQLCache.php-185- AND $nameTable.$argFields IS NOT NULL AND TRIM($nameTable.$argFields) != '')$close "; ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/require/search/SQLCache.php-204- SELECT 1 FROM $nameTable ocsinventory-server-2.8+dfsg1/ocsreports/require/search/SQLCache.php:205: WHERE hardware.ID = $nameTable.HARDWARE_ID ocsinventory-server-2.8+dfsg1/ocsreports/require/search/SQLCache.php-206- AND $nameTable.$argFields $argOperators)$close "; ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/require/table/Table.php-73- var form_name = "<?php echo $formid; ?>"; ocsinventory-server-2.8+dfsg1/ocsreports/require/table/Table.php:74: var csrfid = "input#CSRF_<?php echo $_SESSION['OCS']['CSRFNUMBER']; ?>"; ocsinventory-server-2.8+dfsg1/ocsreports/require/table/Table.php-75- /* ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/require/table/Table.php-110- //Add CSRF ocsinventory-server-2.8+dfsg1/ocsreports/require/table/Table.php:111: d.CSRF_<?php echo $_SESSION['OCS']['CSRFNUMBER']; ?> = $(csrfid).val(); ocsinventory-server-2.8+dfsg1/ocsreports/require/table/Table.php-112- var visible = []; ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/require/function_commun.php-452- ocsinventory-server-2.8+dfsg1/ocsreports/require/function_commun.php:453: $content = curl_exec($ch); ocsinventory-server-2.8+dfsg1/ocsreports/require/function_commun.php-454- curl_close($ch); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/vendor/jasig/phpcas/source/CAS/Client.php-1579- phpCAS::trace( ocsinventory-server-2.8+dfsg1/ocsreports/vendor/jasig/phpcas/source/CAS/Client.php:1580: 'user = `'.$_SESSION['phpCAS']['user'].'\', PGT = `' ocsinventory-server-2.8+dfsg1/ocsreports/vendor/jasig/phpcas/source/CAS/Client.php-1581- .$_SESSION['phpCAS']['pgt'].'\'' ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/vendor/jasig/phpcas/source/CAS/Client.php-1763- $client_ip = $_SERVER['REMOTE_ADDR']; ocsinventory-server-2.8+dfsg1/ocsreports/vendor/jasig/phpcas/source/CAS/Client.php:1764: $client = gethostbyaddr($client_ip); ocsinventory-server-2.8+dfsg1/ocsreports/vendor/jasig/phpcas/source/CAS/Client.php-1765- phpCAS::trace("Client: ".$client."/".$client_ip); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/vendor/jasig/phpcas/source/CAS/Client.php-2130- $user = trim($success_elements->item(0)->nodeValue); ocsinventory-server-2.8+dfsg1/ocsreports/vendor/jasig/phpcas/source/CAS/Client.php:2131: phpCAS::trace('user = `'.$user.'`'); ocsinventory-server-2.8+dfsg1/ocsreports/vendor/jasig/phpcas/source/CAS/Client.php-2132- $this->_setUser($user); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/vendor/jasig/phpcas/source/CAS/Client.php-2439- if (preg_match('/^[PT]GT-[\.\-\w]+$/', $pgtId)) { ocsinventory-server-2.8+dfsg1/ocsreports/vendor/jasig/phpcas/source/CAS/Client.php:2440: phpCAS::trace('Storing PGT `'.$pgtId.'\' (id=`'.$pgtIou.'\')'); ocsinventory-server-2.8+dfsg1/ocsreports/vendor/jasig/phpcas/source/CAS/Client.php-2441- $this->_storePGT($pgtId, $pgtIou); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/vendor/jasig/phpcas/source/CAS/Client.php-2451- $this->printHTMLHeader('phpCAS callback'); ocsinventory-server-2.8+dfsg1/ocsreports/vendor/jasig/phpcas/source/CAS/Client.php:2452: echo '<p>Storing PGT `'.$pgtId.'\' (id=`'.$pgtIou.'\').</p>'; ocsinventory-server-2.8+dfsg1/ocsreports/vendor/jasig/phpcas/source/CAS/Client.php-2453- $this->printHTMLFooter(); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/vendor/jasig/phpcas/source/CAS/Client.php-3950- if (!empty($ip)) { ocsinventory-server-2.8+dfsg1/ocsreports/vendor/jasig/phpcas/source/CAS/Client.php:3951: $dns = gethostbyaddr($ip); ocsinventory-server-2.8+dfsg1/ocsreports/vendor/jasig/phpcas/source/CAS/Client.php-3952- } ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/vendor/jasig/phpcas/source/CAS/Request/CurlMultiRequest.php-133- do { ocsinventory-server-2.8+dfsg1/ocsreports/vendor/jasig/phpcas/source/CAS/Request/CurlMultiRequest.php:134: curl_multi_exec($multiHandle, $running); ocsinventory-server-2.8+dfsg1/ocsreports/vendor/jasig/phpcas/source/CAS/Request/CurlMultiRequest.php-135- } while ($running > 0); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/vendor/jasig/phpcas/source/CAS/Request/CurlRequest.php-74- *********************************************************/ ocsinventory-server-2.8+dfsg1/ocsreports/vendor/jasig/phpcas/source/CAS/Request/CurlRequest.php:75: $buf = curl_exec($ch); ocsinventory-server-2.8+dfsg1/ocsreports/vendor/jasig/phpcas/source/CAS/Request/CurlRequest.php-76- if ( $buf === false ) { ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/vendor/jasig/phpcas/source/CAS.php-1457- if (is_string($params)) { ocsinventory-server-2.8+dfsg1/ocsreports/vendor/jasig/phpcas/source/CAS.php:1458: phpCAS :: error('method `phpCAS::logout($url)\' is now deprecated, use `phpCAS::logoutWithUrl($url)\' instead'); ocsinventory-server-2.8+dfsg1/ocsreports/vendor/jasig/phpcas/source/CAS.php-1459- } ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/vendor/phpmailer/phpmailer/SECURITY.md-24- ocsinventory-server-2.8+dfsg1/ocsreports/vendor/phpmailer/phpmailer/SECURITY.md:25:PHPMailer didn't sanitise the `$lang_path` parameter in `SetLanguage`. This wasn't a problem in itself, but some apps (PHPClassifieds, ATutor) also failed to sanitise user-provided parameters passed to it, permitting semi-arbitrary local file inclusion, reported in [CVE-2010-4914](https://web.nvd.nist.gov/view/vuln/detail?vulnId=CVE-2010-4914), [CVE-2007-2021](https://web.nvd.nist.gov/view/vuln/detail?vulnId=CVE-2007-2021) and [CVE-2006-5734](https://web.nvd.nist.gov/view/vuln/detail?vulnId=CVE-2006-5734). ocsinventory-server-2.8+dfsg1/ocsreports/vendor/phpmailer/phpmailer/SECURITY.md-26- ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/vendor/phpmailer/phpmailer/src/PHPMailer.php-531- * ocsinventory-server-2.8+dfsg1/ocsreports/vendor/phpmailer/phpmailer/src/PHPMailer.php:532: * If set, takes precedence over `$DKIM_private`. ocsinventory-server-2.8+dfsg1/ocsreports/vendor/phpmailer/phpmailer/src/PHPMailer.php-533- * ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/vendor/phpmailer/phpmailer/src/PHPMailer.php-854- */ ocsinventory-server-2.8+dfsg1/ocsreports/vendor/phpmailer/phpmailer/src/PHPMailer.php:855: private function mailPassthru($to, $subject, $body, $header, $params) ocsinventory-server-2.8+dfsg1/ocsreports/vendor/phpmailer/phpmailer/src/PHPMailer.php-856- { ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/vendor/phpmailer/phpmailer/src/PHPMailer.php-1654- foreach ($this->SingleToArray as $toAddr) { ocsinventory-server-2.8+dfsg1/ocsreports/vendor/phpmailer/phpmailer/src/PHPMailer.php:1655: $mail = @popen($sendmail, 'w'); ocsinventory-server-2.8+dfsg1/ocsreports/vendor/phpmailer/phpmailer/src/PHPMailer.php-1656- if (!$mail) { ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/vendor/phpmailer/phpmailer/src/PHPMailer.php-1677- } else { ocsinventory-server-2.8+dfsg1/ocsreports/vendor/phpmailer/phpmailer/src/PHPMailer.php:1678: $mail = @popen($sendmail, 'w'); ocsinventory-server-2.8+dfsg1/ocsreports/vendor/phpmailer/phpmailer/src/PHPMailer.php-1679- if (!$mail) { ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/vendor/phpmailer/phpmailer/src/PHPMailer.php-1792- foreach ($toArr as $toAddr) { ocsinventory-server-2.8+dfsg1/ocsreports/vendor/phpmailer/phpmailer/src/PHPMailer.php:1793: $result = $this->mailPassthru($toAddr, $this->Subject, $body, $header, $params); ocsinventory-server-2.8+dfsg1/ocsreports/vendor/phpmailer/phpmailer/src/PHPMailer.php-1794- $this->doCallback($result, [$toAddr], $this->cc, $this->bcc, $this->Subject, $body, $this->From, []); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/vendor/phpmailer/phpmailer/src/PHPMailer.php-1796- } else { ocsinventory-server-2.8+dfsg1/ocsreports/vendor/phpmailer/phpmailer/src/PHPMailer.php:1797: $result = $this->mailPassthru($to, $this->Subject, $body, $header, $params); ocsinventory-server-2.8+dfsg1/ocsreports/vendor/phpmailer/phpmailer/src/PHPMailer.php-1798- $this->doCallback($result, $this->to, $this->cc, $this->bcc, $this->Subject, $body, $this->From, []); ############################################## ocsinventory-server-2.8+dfsg1/ocsreports/vendor/phpmailer/phpmailer/src/PHPMailer.php-4331- * Usage Example: ocsinventory-server-2.8+dfsg1/ocsreports/vendor/phpmailer/phpmailer/src/PHPMailer.php:4332: * `$mail->set('SMTPSecure', static::ENCRYPTION_STARTTLS);` ocsinventory-server-2.8+dfsg1/ocsreports/vendor/phpmailer/phpmailer/src/PHPMailer.php-4333- * is the same as: ocsinventory-server-2.8+dfsg1/ocsreports/vendor/phpmailer/phpmailer/src/PHPMailer.php:4334: * `$mail->SMTPSecure = static::ENCRYPTION_STARTTLS;`. ocsinventory-server-2.8+dfsg1/ocsreports/vendor/phpmailer/phpmailer/src/PHPMailer.php-4335- * ############################################## ocsinventory-server-2.8+dfsg1/setup.sh-304- then ocsinventory-server-2.8+dfsg1/setup.sh:305: APACHE_ROOT=`eval $APACHE_BIN -V | grep "HTTPD_ROOT" | cut -d'=' -f2 | tr -d '"'` ocsinventory-server-2.8+dfsg1/setup.sh-306- echo "Found Apache HTTPD_ROOT $APACHE_ROOT" >> $SETUP_LOG ocsinventory-server-2.8+dfsg1/setup.sh:307: APACHE_CONFIG=`eval $APACHE_BIN -V | grep "SERVER_CONFIG_FILE" | cut -d'=' -f2 | tr -d '"'` ocsinventory-server-2.8+dfsg1/setup.sh-308- echo "Found Apache SERVER_CONFIG_FILE $APACHE_CONFIG" >> $SETUP_LOG ############################################## ocsinventory-server-2.8+dfsg1/setup.sh-373- "redhat") ocsinventory-server-2.8+dfsg1/setup.sh:374: APACHE_USER_FOUND=`cat $APACHE_CONFIG_FILE | grep "User " | tail -1 | cut -d' ' -f2` ocsinventory-server-2.8+dfsg1/setup.sh-375- ;; ############################################## ocsinventory-server-2.8+dfsg1/setup.sh-392- # Ensure group exist in /etc/passwd ocsinventory-server-2.8+dfsg1/setup.sh:393: if [ `cat /etc/passwd | grep $APACHE_USER | wc -l` -eq 0 ] ocsinventory-server-2.8+dfsg1/setup.sh-394- then ############################################## ocsinventory-server-2.8+dfsg1/setup.sh-428- "redhat") ocsinventory-server-2.8+dfsg1/setup.sh:429: APACHE_GROUP_FOUND=`cat $APACHE_CONFIG_FILE | grep "Group " | tail -1 | cut -d' ' -f2` ocsinventory-server-2.8+dfsg1/setup.sh-430- ;; ############################################## ocsinventory-server-2.8+dfsg1/setup.sh-454- # Ensure group exist in /etc/group ocsinventory-server-2.8+dfsg1/setup.sh:455: if [ `cat /etc/group | grep $APACHE_GROUP | wc -l` -eq 0 ] ocsinventory-server-2.8+dfsg1/setup.sh-456- then ############################################## ocsinventory-server-2.8+dfsg1/setup.sh-1538- echo "<?php" >> $ADM_SERVER_STATIC_DIR/$ADM_SERVER_STATIC_REPORTS_DIR/dbconfig.inc.php ocsinventory-server-2.8+dfsg1/setup.sh:1539: echo -n '$_SESSION["SERVEUR_SQL"]="' >> $ADM_SERVER_STATIC_DIR/$ADM_SERVER_STATIC_REPORTS_DIR/dbconfig.inc.php ocsinventory-server-2.8+dfsg1/setup.sh-1540- echo -n "$DB_SERVER_HOST" >> $ADM_SERVER_STATIC_DIR/$ADM_SERVER_STATIC_REPORTS_DIR/dbconfig.inc.php ocsinventory-server-2.8+dfsg1/setup.sh-1541- echo '";' >> $ADM_SERVER_STATIC_DIR/$ADM_SERVER_STATIC_REPORTS_DIR/dbconfig.inc.php ocsinventory-server-2.8+dfsg1/setup.sh:1542: echo -n '$_SESSION["COMPTE_BASE"]="' >> $ADM_SERVER_STATIC_DIR/$ADM_SERVER_STATIC_REPORTS_DIR/dbconfig.inc.php ocsinventory-server-2.8+dfsg1/setup.sh-1543- echo -n "$DB_SERVER_USER" >> $ADM_SERVER_STATIC_DIR/$ADM_SERVER_STATIC_REPORTS_DIR/dbconfig.inc.php ocsinventory-server-2.8+dfsg1/setup.sh-1544- echo '";' >> $ADM_SERVER_STATIC_DIR/$ADM_SERVER_STATIC_REPORTS_DIR/dbconfig.inc.php ocsinventory-server-2.8+dfsg1/setup.sh:1545: echo -n '$_SESSION["PSWD_BASE"]="' >> $ADM_SERVER_STATIC_DIR/$ADM_SERVER_STATIC_REPORTS_DIR/dbconfig.inc.php ocsinventory-server-2.8+dfsg1/setup.sh-1546- echo -n "$DB_SERVER_PWD" >> $ADM_SERVER_STATIC_DIR/$ADM_SERVER_STATIC_REPORTS_DIR/dbconfig.inc.php ############################################## ocsinventory-server-2.8+dfsg1/.pc/use_system_libraries/ocsreports/require/function_commun.php-452- ocsinventory-server-2.8+dfsg1/.pc/use_system_libraries/ocsreports/require/function_commun.php:453: $content = curl_exec($ch); ocsinventory-server-2.8+dfsg1/.pc/use_system_libraries/ocsreports/require/function_commun.php-454- curl_close($ch);