=========================================================== .___ __ __ _________________ __ __ __| _/|__|/ |_ / ___\_` __ \__ \ | | \/ __ | | \\_ __\ / /_/ > | \// __ \| | / /_/ | | || | \___ /|__| (____ /____/\____ | |__||__| /_____/ \/ \/ grep rough audit - static analysis tool v2.8 written by @Wireghoul =================================[justanotherhacker.com]=== eekboek-2.03.01/lib/EB/Report/Balres.pm-166- my $did_vd = 0; eekboek-2.03.01/lib/EB/Report/Balres.pm:167: $sth = $dbh->sql_exec($sql, $vd->[0]); eekboek-2.03.01/lib/EB/Report/Balres.pm-168- ############################################## eekboek-2.03.01/lib/EB/Report/Balres.pm-232- else { # Op Grootboek eekboek-2.03.01/lib/EB/Report/Balres.pm:233: $sth = $dbh->sql_exec($sql); eekboek-2.03.01/lib/EB/Report/Balres.pm-234- ############################################## eekboek-2.03.01/lib/EB/Report/GenBase.pm-138- " FROM Boekjaren". eekboek-2.03.01/lib/EB/Report/GenBase.pm:139: " WHERE bky_code = ?", $bky); eekboek-2.03.01/lib/EB/Report/GenBase.pm-140- die("?",__x("Onbekend boekjaar: {bky}", bky => $bky)."\n"), return unless $rr; ############################################## eekboek-2.03.01/lib/EB/Report/BTWAangifte.pm-103- " FROM Boekjaren". eekboek-2.03.01/lib/EB/Report/BTWAangifte.pm:104: " WHERE bky_code = ?", $bky); eekboek-2.03.01/lib/EB/Report/BTWAangifte.pm-105- die("?",__x("Onbekend boekjaar: {bky}", bky => $bky)."\n"), return unless $rr; ############################################## eekboek-2.03.01/lib/EB/Report/BTWAangifte.pm-127- " FROM Boekjaren". eekboek-2.03.01/lib/EB/Report/BTWAangifte.pm:128: " WHERE bky_code = ?", $bky); eekboek-2.03.01/lib/EB/Report/BTWAangifte.pm-129- die("?",__x("Onbekend boekjaar: {bky}", bky => $bky)."\n"), return unless $rr; ############################################## eekboek-2.03.01/lib/EB/Booking/Delete.pm-42- " FROM Boekstukken". eekboek-2.03.01/lib/EB/Booking/Delete.pm:43: " WHERE bsk_id = ?", $bsk)}; eekboek-2.03.01/lib/EB/Booking/Delete.pm-44- my ($begin, $end); ############################################## eekboek-2.03.01/lib/EB/Booking/Delete.pm-63- " FROM Boekstukken". eekboek-2.03.01/lib/EB/Booking/Delete.pm:64: " WHERE bsk_id = ?", $bsk)}; eekboek-2.03.01/lib/EB/Booking/Delete.pm-65- ############################################## eekboek-2.03.01/lib/EB/Booking/Delete.pm-90- " FROM Boekstukregels". eekboek-2.03.01/lib/EB/Booking/Delete.pm:91: " WHERE bsr_paid IS NOT NULL AND bsr_bsk_id = ?", $bsk); eekboek-2.03.01/lib/EB/Booking/Delete.pm-92- $rr = $sth->fetchall_arrayref; ############################################## eekboek-2.03.01/lib/EB/Booking/Delete.pm-108- " FROM Journal". eekboek-2.03.01/lib/EB/Booking/Delete.pm:109: " WHERE jnl_bsk_id = ? AND jnl_seq > 0", $bsk); eekboek-2.03.01/lib/EB/Booking/Delete.pm-110- while ( my $rr = $sth->fetchrow_arrayref ) { ############################################## eekboek-2.03.01/lib/EB/Booking/Delete.pm-115- $dbh->sql_exec("DELETE FROM Journal". eekboek-2.03.01/lib/EB/Booking/Delete.pm:116: " WHERE jnl_bsk_id = ?", $bsk)->finish; eekboek-2.03.01/lib/EB/Booking/Delete.pm-117- ############################################## eekboek-2.03.01/lib/EB/Booking/Delete.pm-120- " SET bsk_open = bsk_open - ?". eekboek-2.03.01/lib/EB/Booking/Delete.pm:121: " WHERE bsk_id = ?", shift(@amt), $_)->finish eekboek-2.03.01/lib/EB/Booking/Delete.pm-122- foreach @bsk; ############################################## eekboek-2.03.01/lib/EB/Booking/Delete.pm-125- $dbh->sql_exec("DELETE FROM Boekstukregels". eekboek-2.03.01/lib/EB/Booking/Delete.pm:126: " WHERE bsr_bsk_id = ?", $bsk)->finish; eekboek-2.03.01/lib/EB/Booking/Delete.pm-127- ############################################## eekboek-2.03.01/lib/EB/Booking/Delete.pm-129- $dbh->sql_exec("DELETE FROM Boekstukken". eekboek-2.03.01/lib/EB/Booking/Delete.pm:130: " WHERE bsk_id = ?", $bsk)->finish; eekboek-2.03.01/lib/EB/Booking/Delete.pm-131- ############################################## eekboek-2.03.01/lib/EB/Booking/Decode.pm-61- " FROM Boekstukken". eekboek-2.03.01/lib/EB/Booking/Decode.pm:62: " WHERE bsk_id = ?", $bsk); eekboek-2.03.01/lib/EB/Booking/Decode.pm-63- ############################################## eekboek-2.03.01/lib/EB/Booking/Decode.pm-75- " FROM Dagboeken". eekboek-2.03.01/lib/EB/Booking/Decode.pm:76: " WHERE dbk_id = ?", $bsk_dbk_id)}; eekboek-2.03.01/lib/EB/Booking/Decode.pm-77- my $cmd = ""; ############################################## eekboek-2.03.01/lib/EB/Booking/Decode.pm-102- " FROM Attachments". eekboek-2.03.01/lib/EB/Booking/Decode.pm:103: " WHERE att_id = ?", $bsk_att) }; eekboek-2.03.01/lib/EB/Booking/Decode.pm-104- $name = sprintf("int://%08d/%s", $bsk_att, $name) ############################################## eekboek-2.03.01/lib/EB/Booking/Decode.pm-321- " FROM Accounts". eekboek-2.03.01/lib/EB/Booking/Decode.pm:322: " WHERE acc_id = ?", $acct); eekboek-2.03.01/lib/EB/Booking/Decode.pm-323- die("?".__x("Onbekend rekeningnummer: {acct}", acct => $acct)."\n") ############################################## eekboek-2.03.01/lib/EB/Booking/IV.pm-185- " FROM Accounts". eekboek-2.03.01/lib/EB/Booking/IV.pm:186: " WHERE acc_id = ?", $acct); eekboek-2.03.01/lib/EB/Booking/IV.pm-187- unless ( $rr ) { ############################################## eekboek-2.03.01/lib/EB/Booking/BKM.pm-186- " FROM Accounts". eekboek-2.03.01/lib/EB/Booking/BKM.pm:187: " WHERE acc_id = ?", $acct); eekboek-2.03.01/lib/EB/Booking/BKM.pm-188- unless ( $rr ) { ############################################## eekboek-2.03.01/lib/EB/Booking/BKM.pm-437- my $res = []; eekboek-2.03.01/lib/EB/Booking/BKM.pm:438: my $sth = $dbh->sql_exec($sql, @sql_args); eekboek-2.03.01/lib/EB/Booking/BKM.pm-439- while ( $rr = $sth->fetchrow_arrayref ) { ############################################## eekboek-2.03.01/lib/EB/Report.pm-65- " FROM Boekjaarbalans". eekboek-2.03.01/lib/EB/Report.pm:66: " WHERE bkb_end ".($inc ? "<=" : "<")." ?", $end); eekboek-2.03.01/lib/EB/Report.pm-67- while ( my $rr = $sth->fetchrow_arrayref ) { ############################################## eekboek-2.03.01/lib/EB/Format.pm-171- eekboek-2.03.01/lib/EB/Format.pm:172: eval("sub numfmt_plain { $sub; \$v }"); eekboek-2.03.01/lib/EB/Format.pm-173- die($@) if $@; ############################################## eekboek-2.03.01/lib/EB/Format.pm-180- eekboek-2.03.01/lib/EB/Format.pm:181: eval("sub numfmt { $sub; \$v }"); eekboek-2.03.01/lib/EB/Format.pm-182- die($@) if $@; ############################################## eekboek-2.03.01/lib/EB/Format.pm-214- for ( $sub, $sub_full, $sub_plain ) { eekboek-2.03.01/lib/EB/Format.pm:215: eval($_); eekboek-2.03.01/lib/EB/Format.pm-216- die($_."\n".$@) if $@; ############################################## eekboek-2.03.01/lib/EB/Format.pm-304- eekboek-2.03.01/lib/EB/Format.pm:305: my $res = eval($val); eekboek-2.03.01/lib/EB/Format.pm-306- warn("$val: $@"), return undef if $debug && $@; ############################################## eekboek-2.03.01/lib/EB/Relation.pm-114- " FROM Accounts". eekboek-2.03.01/lib/EB/Relation.pm:115: " WHERE acc_id = ?", $acct); eekboek-2.03.01/lib/EB/Relation.pm-116- unless ( $rr ) { ############################################## eekboek-2.03.01/lib/EB/Tools/Einde.pm-67- " FROM Boekjaren". eekboek-2.03.01/lib/EB/Tools/Einde.pm:68: " WHERE bky_code = ?", $bky); eekboek-2.03.01/lib/EB/Tools/Einde.pm-69- warn("?",__x("Onbekend boekjaar: {bky}", bky => $bky)."\n"), return unless $rr; ############################################## eekboek-2.03.01/lib/EB/Tools/Einde.pm-83- eekboek-2.03.01/lib/EB/Tools/Einde.pm:84: $dbh->sql_exec("DELETE FROM Boekjaarbalans where bkb_bky = ?", $bky)->finish; eekboek-2.03.01/lib/EB/Tools/Einde.pm-85- ############################################## eekboek-2.03.01/lib/EB/Tools/Einde.pm-317- " SET bky_closed = now()". eekboek-2.03.01/lib/EB/Tools/Einde.pm:318: " WHERE bky_code = ?", $bky)->finish; eekboek-2.03.01/lib/EB/Tools/Einde.pm-319- } ############################################## eekboek-2.03.01/lib/EB/Tools/Opening.pm-106- " FROM Accounts". eekboek-2.03.01/lib/EB/Tools/Opening.pm:107: " WHERE acc_id = ?", $acct); eekboek-2.03.01/lib/EB/Tools/Opening.pm-108- return __x("Onbekende grootboekrekening: {acct}", acct => $acct)."\n" ############################################## eekboek-2.03.01/lib/EB/Tools/Opening.pm-368- " FROM Boekjaren". eekboek-2.03.01/lib/EB/Tools/Opening.pm:369: " WHERE bky_code = ?", $bky); eekboek-2.03.01/lib/EB/Tools/Opening.pm-370- my $rr = $sth->fetchrow_arrayref; ############################################## eekboek-2.03.01/lib/EB/Tools/Opening.pm-444- " SET bky_closed = ?, bky_end = ?". eekboek-2.03.01/lib/EB/Tools/Opening.pm:445: " WHERE bky_code = ?", $t, $t, BKY_PREVIOUS); eekboek-2.03.01/lib/EB/Tools/Opening.pm-446- ############################################## eekboek-2.03.01/lib/EB/Tools/Attachments.pm-173- else { eekboek-2.03.01/lib/EB/Tools/Attachments.pm:174: system("start", $file); # ???? eekboek-2.03.01/lib/EB/Tools/Attachments.pm-175- } ############################################## eekboek-2.03.01/lib/EB/Tools/Attachments.pm-179- # Do we need to sleep here? eekboek-2.03.01/lib/EB/Tools/Attachments.pm:180: system("sh -c 'open \"$file\"; rm -f \"$file\"'&"); eekboek-2.03.01/lib/EB/Tools/Attachments.pm-181- } ############################################## eekboek-2.03.01/lib/EB/Tools/Attachments.pm-183- # xdg-open spawns the right tool and exits immediately. eekboek-2.03.01/lib/EB/Tools/Attachments.pm:184: system("sh -c 'xdg-open \"$file\"; sleep 5; rm -f \"$file\"'&"); eekboek-2.03.01/lib/EB/Tools/Attachments.pm-185- } ############################################## eekboek-2.03.01/lib/EB/Booking.pm-94- " FROM Boekjaren". eekboek-2.03.01/lib/EB/Booking.pm:95: " WHERE bky_code = ?", $self->{bky})}; eekboek-2.03.01/lib/EB/Booking.pm-96- if ( $c ) { ############################################## eekboek-2.03.01/lib/EB/Booking.pm-257- " FROM BTWTabel". eekboek-2.03.01/lib/EB/Booking.pm:258: " WHERE btw_id = ?", $bsr_btw_id); eekboek-2.03.01/lib/EB/Booking.pm-259- confess( "Unknown BTW: $bsr_btw_id" ) unless $rr; ############################################## eekboek-2.03.01/lib/EB/Booking.pm-298- " FROM Boekstukken". eekboek-2.03.01/lib/EB/Booking.pm:299: " WHERE bsk_id = ?", $bsk_id); eekboek-2.03.01/lib/EB/Booking.pm-300- my ($bsk_nr, $bsk_desc, $bsk_dbk_id, $bsk_date, $bsk_ref) = @$rr; ############################################## eekboek-2.03.01/lib/EB/Booking.pm-304- " FROM Dagboeken". eekboek-2.03.01/lib/EB/Booking.pm:305: " WHERE dbk_id = ?", $bsk_dbk_id)}; eekboek-2.03.01/lib/EB/Booking.pm-306- my $sth = $::dbh->sql_exec("SELECT bsr_nr, bsr_date, ". ############################################## eekboek-2.03.01/lib/EB/Booking.pm-309- " FROM Boekstukregels". eekboek-2.03.01/lib/EB/Booking.pm:310: " WHERE bsr_bsk_id = ?", $bsk_id); eekboek-2.03.01/lib/EB/Booking.pm-311- ############################################## eekboek-2.03.01/lib/EB/Globals.pm-26- #warn("sub $_[0](){$t}\n"); eekboek-2.03.01/lib/EB/Globals.pm:27: eval("sub $_[0](){$t}"); eekboek-2.03.01/lib/EB/Globals.pm-28- push(@EXPORT, $_[0]); ############################################## eekboek-2.03.01/lib/EB/Globals.pm-82-# Eval, since it uses the (run-time defined) subroutines. eekboek-2.03.01/lib/EB/Globals.pm:83:eval( 'sub BTWKLASSE($$$) {'. eekboek-2.03.01/lib/EB/Globals.pm-84- ' ($_[0] ? BTWKLASSE_BTW_BIT : 0)'. ############################################## eekboek-2.03.01/lib/EB/DB.pm-104- next unless defined; eekboek-2.03.01/lib/EB/DB.pm:105: my $rr = $self->do("SELECT acc_debcrd, acc_balres FROM Accounts where acc_id = ?", $_); eekboek-2.03.01/lib/EB/DB.pm-106- $fail++, warn("?".__x("Geen grootboekrekening voor {dc} ({acct})", ############################################## eekboek-2.03.01/lib/EB/DB.pm-116- next unless defined; eekboek-2.03.01/lib/EB/DB.pm:117: my $rr = $self->do("SELECT acc_debcrd, acc_balres FROM Accounts where acc_id = ?", $_); eekboek-2.03.01/lib/EB/DB.pm-118- $fail++, warn("?".__x("Geen grootboekrekening voor {dc} ({acct})", ############################################## eekboek-2.03.01/lib/EB/DB.pm-128- next unless defined; eekboek-2.03.01/lib/EB/DB.pm:129: my $rr = $self->do("SELECT acc_balres FROM Accounts where acc_id = ?", $_); eekboek-2.03.01/lib/EB/DB.pm-130- $fail++, warn("?".__x("Geen grootboekrekening voor {dc} ({acct})", ############################################## eekboek-2.03.01/lib/EB/DB.pm-138- for ( $self->std_acc("winst") ) { eekboek-2.03.01/lib/EB/DB.pm:139: my $rr = $self->do("SELECT acc_balres FROM Accounts where acc_id = ?", $_); eekboek-2.03.01/lib/EB/DB.pm-140- $fail++, warn("?".__x("Geen grootboekrekening voor {dc} ({acct})", ############################################## eekboek-2.03.01/lib/EB/DB.pm-216- " FROM Relaties". eekboek-2.03.01/lib/EB/DB.pm:217: " WHERE upper(rel_code) = ?", uc($1)) ) { eekboek-2.03.01/lib/EB/DB.pm-218- my ($rel_id, $rel_desc) = @$rr; ############################################## eekboek-2.03.01/lib/EB/DB.pm-705- my ($self, $column, $table) = @_; eekboek-2.03.01/lib/EB/DB.pm:706: my $sth = $self->sql_exec("SELECT $column FROM $table"); eekboek-2.03.01/lib/EB/DB.pm-707- my $rr = $sth->fetchrow_arrayref; ############################################## eekboek-2.03.01/lib/EB/DB.pm-717- my @args = @_; eekboek-2.03.01/lib/EB/DB.pm:718: my $sth = $self->sql_exec($sql, @args); eekboek-2.03.01/lib/EB/DB.pm-719- my $rr = $sth->fetchrow_arrayref; ############################################## eekboek-2.03.01/lib/EB/DB.pm-728- my @args = @_; eekboek-2.03.01/lib/EB/DB.pm:729: my $sth = $self->sql_exec($sql, @args); eekboek-2.03.01/lib/EB/DB.pm-730- my $res; ############################################## eekboek-2.03.01/lib/EB/CPAN/Term/ReadLine/readline.pm-1233- } elsif ($key =~ s#^\\x([0-9a-fA-F]{2})##) { eekboek-2.03.01/lib/EB/CPAN/Term/ReadLine/readline.pm:1234: push(@keys, eval('0x'.$1)); eekboek-2.03.01/lib/EB/CPAN/Term/ReadLine/readline.pm-1235- } elsif ($key =~ s#^\\([0-7]{3})##) { eekboek-2.03.01/lib/EB/CPAN/Term/ReadLine/readline.pm:1236: push(@keys, eval('0'.$1)); eekboek-2.03.01/lib/EB/CPAN/Term/ReadLine/readline.pm-1237- } elsif ($key =~ s#^\\\*$##) { # JP: added ############################################## eekboek-2.03.01/lib/EB/CPAN/Term/ReadLine/readline.pm-1239- } elsif ($key =~ s#^\\([afnrtv])##) { eekboek-2.03.01/lib/EB/CPAN/Term/ReadLine/readline.pm:1240: push(@keys, ord(eval(qq("\\$1")))); eekboek-2.03.01/lib/EB/CPAN/Term/ReadLine/readline.pm-1241- } elsif ($key =~ s#^\\d##) { ############################################## eekboek-2.03.01/lib/EB/CPAN/Term/ReadLine/readline.pm-2360- warn("Warning$InputLocMsg:\n". eekboek-2.03.01/lib/EB/CPAN/Term/ReadLine/readline.pm:2361: " Invalid value `$val' for variable `$var'.\n". eekboek-2.03.01/lib/EB/CPAN/Term/ReadLine/readline.pm-2362- " Choose from [@selections].\n") if $^W; ############################################## eekboek-2.03.01/lib/EB/CPAN/Term/ReadLine/readline.pm-3509- eekboek-2.03.01/lib/EB/CPAN/Term/ReadLine/readline.pm:3510: #print qq/\r\neval("\@matches = &$func(\$text, \$line, \$start)\n\r/;#DEBUG eekboek-2.03.01/lib/EB/CPAN/Term/ReadLine/readline.pm:3511: #eval("\@matches = &$func(\$text, \$line, \$start);1") || warn "$@ "; eekboek-2.03.01/lib/EB/CPAN/Term/ReadLine/readline.pm-3512- @matches = &$func($text, $line, $start); ############################################## eekboek-2.03.01/lib/EB/CPAN/Term/ReadLine/Perl.pm-12- #$loaded = defined &Term::ReadKey::ReadKey; eekboek-2.03.01/lib/EB/CPAN/Term/ReadLine/Perl.pm:13: #print STDOUT "\nrl=`$in', loaded = `$loaded'\n"; eekboek-2.03.01/lib/EB/CPAN/Term/ReadLine/Perl.pm-14- #if (ref \$in eq 'GLOB') { # Bug under debugger ############################################## eekboek-2.03.01/lib/EB/DB/Sqlite.pm-212- " FROM eb_seq". eekboek-2.03.01/lib/EB/DB/Sqlite.pm:213: " WHERE name = ?", {}, $seq); eekboek-2.03.01/lib/EB/DB/Sqlite.pm-214- ############################################## eekboek-2.03.01/lib/EB/DB/Sqlite.pm-220- eekboek-2.03.01/lib/EB/DB/Sqlite.pm:221: $sdb->do("UPDATE eb_seq SET value = ? WHERE name = ?", {}, $value, $seq); eekboek-2.03.01/lib/EB/DB/Sqlite.pm-222- $sdb->commit if CONCURRENT; ############################################## eekboek-2.03.01/lib/EB/DB/Sqlite.pm-262- " FROM Attachments". eekboek-2.03.01/lib/EB/DB/Sqlite.pm:263: " WHERE att_id = ?", {}, $id ); eekboek-2.03.01/lib/EB/DB/Sqlite.pm-264- my ( $name, $enc, $data ) = @{ $rr }; ############################################## eekboek-2.03.01/lib/EB/DB/Sqlite.pm-332- " FROM Attachments". eekboek-2.03.01/lib/EB/DB/Sqlite.pm:333: " WHERE att_id = ?", {}, $id ); eekboek-2.03.01/lib/EB/DB/Sqlite.pm-334- my ( $name, $enc ) = @{ $rr }; eekboek-2.03.01/lib/EB/DB/Sqlite.pm-335- eekboek-2.03.01/lib/EB/DB/Sqlite.pm:336: $dbh->do("DELETE FROM Attachments WHERE att_id = ?", {}, $id ); eekboek-2.03.01/lib/EB/DB/Sqlite.pm-337- return if $enc == ATTENCODING_URI; ############################################## eekboek-2.03.01/lib/EB/DB/Postgres.pm-266- " FROM Attachments". eekboek-2.03.01/lib/EB/DB/Postgres.pm:267: " WHERE att_id = ?", {}, $id ); eekboek-2.03.01/lib/EB/DB/Postgres.pm-268- my ( $name, $enc, $data ) = @{ $rr }; ############################################## eekboek-2.03.01/lib/EB/DB/Postgres.pm-290- my ( $self, $id ) = @_; eekboek-2.03.01/lib/EB/DB/Postgres.pm:291: $dbh->do("DELETE FROM Attachments WHERE att_id = ?", {}, $id ); eekboek-2.03.01/lib/EB/DB/Postgres.pm-292-} ############################################## eekboek-2.03.01/lib/EB/Export.pm-307- " FROM Boekjaarbalans". eekboek-2.03.01/lib/EB/Export.pm:308: " WHERE bkb_bky = ?", $bky); eekboek-2.03.01/lib/EB/Export.pm-309- my $rr; ############################################## eekboek-2.03.01/contrib/API/example1.pl-55-# Parse SQL and execute. eekboek-2.03.01/contrib/API/example1.pl:56:my $sth = $dbh->sql_exec($sql); eekboek-2.03.01/contrib/API/example1.pl-57-