=========================================================== .___ __ __ _________________ __ __ __| _/|__|/ |_ / ___\_` __ \__ \ | | \/ __ | | \\_ __\ / /_/ > | \// __ \| | / /_/ | | || | \___ /|__| (____ /____/\____ | |__||__| /_____/ \/ \/ grep rough audit - static analysis tool v2.8 written by @Wireghoul =================================[justanotherhacker.com]=== ruby-riddle-2.3.1/spec/fixtures/sphinx/configuration.erb-30- ruby-riddle-2.3.1/spec/fixtures/sphinx/configuration.erb:31: sql_query = SELECT id, first_name, middle_initial, last_name, gender, street_address, city, state, postcode, email, UNIX_TIMESTAMP(birthday) AS birthday FROM people WHERE id >= $start AND id <= $end ruby-riddle-2.3.1/spec/fixtures/sphinx/configuration.erb-32- sql_query_range = SELECT MIN(id), MAX(id) FROM people ruby-riddle-2.3.1/spec/fixtures/sphinx/configuration.erb:33: sql_query_info = SELECT * FROM people WHERE id = $id ruby-riddle-2.3.1/spec/fixtures/sphinx/configuration.erb-34- sql_attr_timestamp = birthday ############################################## ruby-riddle-2.3.1/spec/fixtures/sphinx/configuration.erb-54- ruby-riddle-2.3.1/spec/fixtures/sphinx/configuration.erb:55: sql_query = SELECT id, title, 0 AS deleted FROM articles WHERE id >= $start AND id <= $end AND delta = 0 ruby-riddle-2.3.1/spec/fixtures/sphinx/configuration.erb-56- sql_query_range = SELECT MIN(id), MAX(id) FROM articles ############################################## ruby-riddle-2.3.1/spec/fixtures/sphinx/configuration.erb-74- ruby-riddle-2.3.1/spec/fixtures/sphinx/configuration.erb:75: sql_query = SELECT id, title, 0 AS deleted FROM articles WHERE id >= $start AND id <= $end AND delta = 1 ruby-riddle-2.3.1/spec/fixtures/sphinx/configuration.erb-76- sql_query_range = SELECT MIN(id), MAX(id) FROM articles ############################################## ruby-riddle-2.3.1/spec/fixtures/sql/data.sql-17449-insert into `people` (gender, first_name, middle_initial, last_name, street_address, city, state, postcode, email, birthday) values('male','James','A','Hill','63 English Street','St Ives','SA','5252','James.A.Hill@trashymail.com','1959/5/23 00:00:00'); ruby-riddle-2.3.1/spec/fixtures/sql/data.sql:17450:insert into `people` (gender, first_name, middle_initial, last_name, street_address, city, state, postcode, email, birthday) values('male','Riley','M','Gardner','9 Barnett Street','Chasm Creek','TAS','7321','Riley.M.Gardner@dodgit.com','1946/6/11 00:00:00'); ruby-riddle-2.3.1/spec/fixtures/sql/data.sql-17451-insert into `people` (gender, first_name, middle_initial, last_name, street_address, city, state, postcode, email, birthday) values('female','Zoe','M','Little','12 Mt Berryman Road','Mount Whitestone','QLD','4347','Zoe.M.Little@spambob.com','1956/11/15 00:00:00'); ############################################## ruby-riddle-2.3.1/spec/fixtures/sql/data.sql-21485-insert into `people` (gender, first_name, middle_initial, last_name, street_address, city, state, postcode, email, birthday) values('female','Amber','E','French','47 Thomas Lane','Ivanhoe North','VIC','3079','Amber.E.French@dodgit.com','1969/3/8 00:00:00'); ruby-riddle-2.3.1/spec/fixtures/sql/data.sql:21486:insert into `people` (gender, first_name, middle_initial, last_name, street_address, city, state, postcode, email, birthday) values('female','Abigail','J','McCarthy','97 Barnett Street','Chasm Creek','TAS','7321','Abigail.J.McCarthy@mailinator.com','1975/3/23 00:00:00'); ruby-riddle-2.3.1/spec/fixtures/sql/data.sql-21487-insert into `people` (gender, first_name, middle_initial, last_name, street_address, city, state, postcode, email, birthday) values('female','Freya','S','Graham','55 Ocean Pde','Barringha','QLD','4816','Freya.S.Graham@dodgit.com','1946/4/15 00:00:00'); ############################################## ruby-riddle-2.3.1/spec/fixtures/sql/data.tsv-17449-'male','James','A','Hill','63 English Street','St Ives','SA','5252','James.A.Hill@trashymail.com','1959/5/23 00:00:00' ruby-riddle-2.3.1/spec/fixtures/sql/data.tsv:17450:'male','Riley','M','Gardner','9 Barnett Street','Chasm Creek','TAS','7321','Riley.M.Gardner@dodgit.com','1946/6/11 00:00:00' ruby-riddle-2.3.1/spec/fixtures/sql/data.tsv-17451-'female','Zoe','M','Little','12 Mt Berryman Road','Mount Whitestone','QLD','4347','Zoe.M.Little@spambob.com','1956/11/15 00:00:00' ############################################## ruby-riddle-2.3.1/spec/fixtures/sql/data.tsv-21485-'female','Amber','E','French','47 Thomas Lane','Ivanhoe North','VIC','3079','Amber.E.French@dodgit.com','1969/3/8 00:00:00' ruby-riddle-2.3.1/spec/fixtures/sql/data.tsv:21486:'female','Abigail','J','McCarthy','97 Barnett Street','Chasm Creek','TAS','7321','Abigail.J.McCarthy@mailinator.com','1975/3/23 00:00:00' ruby-riddle-2.3.1/spec/fixtures/sql/data.tsv-21487-'female','Freya','S','Graham','55 Ocean Pde','Barringha','QLD','4816','Freya.S.Graham@dodgit.com','1946/4/15 00:00:00' ############################################## ruby-riddle-2.3.1/spec/unit/configuration/sql_source_spec.rb-53- source.sql_query_pre << "SET NAMES utf8" << "SET SESSION query_cache_type=OFF" ruby-riddle-2.3.1/spec/unit/configuration/sql_source_spec.rb:54: source.sql_query = "SELECT id, group_id, UNIX_TIMESTAMP(date_added) AS date_added, title, content FROM documents WHERE id >= $start AND id <= $end" ruby-riddle-2.3.1/spec/unit/configuration/sql_source_spec.rb-55- source.sql_query_range = "SELECT MIN(id), MAX(id) FROM documents" ############################################## ruby-riddle-2.3.1/spec/unit/configuration/sql_source_spec.rb-67- source.sql_ranged_throttle = 0 ruby-riddle-2.3.1/spec/unit/configuration/sql_source_spec.rb:68: source.sql_query_info = "SELECT * FROM documents WHERE id = $id" ruby-riddle-2.3.1/spec/unit/configuration/sql_source_spec.rb-69- source.mssql_winauth = 1 ############################################## ruby-riddle-2.3.1/spec/unit/configuration/sql_source_spec.rb-87- sql_query_pre = SET SESSION query_cache_type=OFF ruby-riddle-2.3.1/spec/unit/configuration/sql_source_spec.rb:88: sql_query = SELECT id, group_id, UNIX_TIMESTAMP(date_added) AS date_added, title, content FROM documents WHERE id >= $start AND id <= $end ruby-riddle-2.3.1/spec/unit/configuration/sql_source_spec.rb-89- sql_query_range = SELECT MIN(id), MAX(id) FROM documents ############################################## ruby-riddle-2.3.1/spec/unit/configuration/sql_source_spec.rb-106- sql_ranged_throttle = 0 ruby-riddle-2.3.1/spec/unit/configuration/sql_source_spec.rb:107: sql_query_info = SELECT * FROM documents WHERE id = $id ruby-riddle-2.3.1/spec/unit/configuration/sql_source_spec.rb-108- mssql_winauth = 1