[ehb54/us3lims_dbinst] 7cf05c: Prevent sql injections by using prepared statements
Branch: refs/heads/master Home: https://github.com/ehb54/us3lims_dbinst Commit: 7cf05c544a2b0773973774e9e525d7ea495b50b1 https://github.com/ehb54/us3lims_dbinst/commit/7cf05c544a2b0773973774e9e525d... Author: doluk <69309597+doluk@users.noreply.github.com> Date: 2024-08-26 (Mon, 26 Aug 2024) Changed paths: M 2DSA-CG_2.php M 2DSA_2.php M DMGA_2.php M GA_3.php M PCSA_2.php M activate.php M checkuser.php M data_sharing.php M db.php M edit_instruments.php M edit_labs.php M edit_projects.php M edit_users.php M lib/HPC_analysis.php M lib/controls.php M lib/file_writer.php M lib/payload_manager.php M lib/reports.php M lib/selectboxes.php M profile.php M queue_setup_1.php M queue_setup_2_funcs.php M queue_setup_3.php M queue_viewer.php M recover_password.php M register.php M report_detail.php M runID_info.php M show_image.php M solution_detail.php M view_users.php Log Message: ----------- Prevent sql injections by using prepared statements Commit: 3c93487caad3831a11b053c428e957c9094beb1c https://github.com/ehb54/us3lims_dbinst/commit/3c93487caad3831a11b053c428e95... Author: doluk <69309597+doluk@users.noreply.github.com> Date: 2024-08-26 (Mon, 26 Aug 2024) Changed paths: M lib/utility.php Log Message: ----------- Random Length for makeRandomPassword Commit: cb5a83c1b423fff8c011d5a56e262dbd72cb82a6 https://github.com/ehb54/us3lims_dbinst/commit/cb5a83c1b423fff8c011d5a56e262... Author: ehb54 <ehb54@users.noreply.github.com> Date: 2024-08-29 (Thu, 29 Aug 2024) Changed paths: M 2DSA-CG_2.php M 2DSA_2.php M DMGA_2.php M GA_3.php M PCSA_2.php M activate.php M checkuser.php M data_sharing.php M db.php M edit_instruments.php M edit_labs.php M edit_projects.php M edit_users.php M lib/HPC_analysis.php M lib/controls.php M lib/file_writer.php M lib/payload_manager.php M lib/reports.php M lib/selectboxes.php M lib/utility.php M profile.php M queue_setup_1.php M queue_setup_2_funcs.php M queue_setup_3.php M queue_viewer.php M recover_password.php M register.php M report_detail.php M runID_info.php M show_image.php M solution_detail.php M view_users.php Log Message: ----------- Merge pull request #26 from doluk/sql-injection Sql injection Commit: 96152b08826a96f703130026cdc035fe22f96674 https://github.com/ehb54/us3lims_dbinst/commit/96152b08826a96f703130026cdc03... Author: doluk <69309597+doluk@users.noreply.github.com> Date: 2024-08-29 (Thu, 29 Aug 2024) Changed paths: M db.php Log Message: ----------- Rename mysqli_prepared_query to mysqli_prep_query Commit: f1bdae2ad9394a433d7453efdc4e6ee50cccdbe5 https://github.com/ehb54/us3lims_dbinst/commit/f1bdae2ad9394a433d7453efdc4e6... Author: doluk <69309597+doluk@users.noreply.github.com> Date: 2024-08-30 (Fri, 30 Aug 2024) Changed paths: M 2DSA_2.php M DMGA_2.php M edit_instruments.php M edit_labs.php Log Message: ----------- Fix prepared statements (replacing php variable with ?) Commit: ec79f98aef751ce3084f5f7b8b70d2ed48a0ea3f https://github.com/ehb54/us3lims_dbinst/commit/ec79f98aef751ce3084f5f7b8b70d... Author: doluk <69309597+doluk@users.noreply.github.com> Date: 2024-08-30 (Fri, 30 Aug 2024) Changed paths: M queue_setup_2_funcs.php Log Message: ----------- Fix SQL query having ambiguous columns Commit: 11ae6dd1065d7c48abeada00b41f44a1769fa6a9 https://github.com/ehb54/us3lims_dbinst/commit/11ae6dd1065d7c48abeada00b41f4... Author: doluk <69309597+doluk@users.noreply.github.com> Date: 2024-08-30 (Fri, 30 Aug 2024) Changed paths: M 2DSA_2.php M DMGA_2.php M edit_instruments.php M edit_labs.php M queue_setup_2_funcs.php Log Message: ----------- Merge remote-tracking branch 'origin/sql-injection' into sql-injection Commit: 15bb0dfd800e44f8fd940bf06825a6f670dc5cc3 https://github.com/ehb54/us3lims_dbinst/commit/15bb0dfd800e44f8fd940bf06825a... Author: doluk <69309597+doluk@users.noreply.github.com> Date: 2024-08-30 (Fri, 30 Aug 2024) Changed paths: M queue_setup_2_funcs.php Log Message: ----------- Fix more sql queries Commit: 6ab2cda8daec6240bef7b08ffe9b138220603e23 https://github.com/ehb54/us3lims_dbinst/commit/6ab2cda8daec6240bef7b08ffe9b1... Author: doluk <69309597+doluk@users.noreply.github.com> Date: 2024-08-30 (Fri, 30 Aug 2024) Changed paths: M queue_setup_2_funcs.php Log Message: ----------- Fix more sql query order Commit: 1560d902475b3c21e4a5bf275921f222db47377a https://github.com/ehb54/us3lims_dbinst/commit/1560d902475b3c21e4a5bf275921f... Author: doluk <69309597+doluk@users.noreply.github.com> Date: 2024-08-30 (Fri, 30 Aug 2024) Changed paths: M queue_setup_2_funcs.php Log Message: ----------- Fix more sql query order Commit: c99f383f8411552cb7f8a7ca6c02de85aa35f918 https://github.com/ehb54/us3lims_dbinst/commit/c99f383f8411552cb7f8a7ca6c02d... Author: doluk <69309597+doluk@users.noreply.github.com> Date: 2024-08-30 (Fri, 30 Aug 2024) Changed paths: M queue_setup_2_funcs.php Log Message: ----------- Ensure experimentID is present for every selected rawdata set Commit: 4ac03c049ec20aaf12ebc141e75ada892f78c684 https://github.com/ehb54/us3lims_dbinst/commit/4ac03c049ec20aaf12ebc141e75ad... Author: doluk <69309597+doluk@users.noreply.github.com> Date: 2024-08-30 (Fri, 30 Aug 2024) Changed paths: M db.php Log Message: ----------- prevent mysqli_prep_query from being redeclared Commit: da85000a02a495428fa58d2a42cdbb61e116fb8b https://github.com/ehb54/us3lims_dbinst/commit/da85000a02a495428fa58d2a42cdb... Author: doluk <69309597+doluk@users.noreply.github.com> Date: 2024-08-30 (Fri, 30 Aug 2024) Changed paths: M 2DSA_1.php Log Message: ----------- prevent undefined variables Commit: 301d5059197cd0830a3e81cec5a7b7747083c1fa https://github.com/ehb54/us3lims_dbinst/commit/301d5059197cd0830a3e81cec5a7b... Author: doluk <69309597+doluk@users.noreply.github.com> Date: 2024-08-30 (Fri, 30 Aug 2024) Changed paths: M lib/reports.php Log Message: ----------- Fix args array construction Commit: c14382cc84452ab4a9e020c0e80ad9f2275ad346 https://github.com/ehb54/us3lims_dbinst/commit/c14382cc84452ab4a9e020c0e80ad... Author: doluk <69309597+doluk@users.noreply.github.com> Date: 2024-08-30 (Fri, 30 Aug 2024) Changed paths: M lib/reports.php Log Message: ----------- Fix args array construction Commit: a04ecea6d52e85661a416a50c075ab07475181b4 https://github.com/ehb54/us3lims_dbinst/commit/a04ecea6d52e85661a416a50c075a... Author: doluk <69309597+doluk@users.noreply.github.com> Date: 2024-08-30 (Fri, 30 Aug 2024) Changed paths: M solution_detail.php Log Message: ----------- Fix duplicated query Commit: 73875525831996d2618c17301df503d0e69c3350 https://github.com/ehb54/us3lims_dbinst/commit/73875525831996d2618c17301df50... Author: doluk <69309597+doluk@users.noreply.github.com> Date: 2024-08-30 (Fri, 30 Aug 2024) Changed paths: M solution_detail.php Log Message: ----------- Fix missing ? in prepared statement Commit: e974d9392a7bc61c8f5bdbab9a7188dea1b22185 https://github.com/ehb54/us3lims_dbinst/commit/e974d9392a7bc61c8f5bdbab9a718... Author: doluk <69309597+doluk@users.noreply.github.com> Date: 2024-08-30 (Fri, 30 Aug 2024) Changed paths: M data_sharing.php Log Message: ----------- Fix construction of data sharing options Commit: 50edfc06a1b2c64ff6ccbd2687c4694bb9600e03 https://github.com/ehb54/us3lims_dbinst/commit/50edfc06a1b2c64ff6ccbd2687c46... Author: doluk <69309597+doluk@users.noreply.github.com> Date: 2024-08-30 (Fri, 30 Aug 2024) Changed paths: M data_sharing.php Log Message: ----------- Fix db query Commit: fa6545d070b72c56694bdf099b797c75d2dfa8f7 https://github.com/ehb54/us3lims_dbinst/commit/fa6545d070b72c56694bdf099b797... Author: doluk <69309597+doluk@users.noreply.github.com> Date: 2024-08-30 (Fri, 30 Aug 2024) Changed paths: M data_sharing.php Log Message: ----------- Fix html Commit: d75bd65800c154b31aa3fae02f757494f181d5f5 https://github.com/ehb54/us3lims_dbinst/commit/d75bd65800c154b31aa3fae02f757... Author: doluk <69309597+doluk@users.noreply.github.com> Date: 2024-08-30 (Fri, 30 Aug 2024) Changed paths: M 2DSA-CG_1.php Log Message: ----------- Prevent undefined variables Commit: fcfe7ac09616715ef363e1c83f4150f4e7e5f748 https://github.com/ehb54/us3lims_dbinst/commit/fcfe7ac09616715ef363e1c83f415... Author: doluk <69309597+doluk@users.noreply.github.com> Date: 2024-08-30 (Fri, 30 Aug 2024) Changed paths: M runID_info.php Log Message: ----------- Ensure proper dealing with no run info and fixing sql query Commit: f6c9b5d85afbb2385c2bc50bc83ae84c7ca306f5 https://github.com/ehb54/us3lims_dbinst/commit/f6c9b5d85afbb2385c2bc50bc83ae... Author: doluk <69309597+doluk@users.noreply.github.com> Date: 2024-08-30 (Fri, 30 Aug 2024) Changed paths: M runID_info.php Log Message: ----------- Fix runID_info.php and add table of content for better navigation Commit: 60cfd8667c97c4801f0c84cb6fe5cda67b205237 https://github.com/ehb54/us3lims_dbinst/commit/60cfd8667c97c4801f0c84cb6fe5c... Author: ehb54 <ehb54@users.noreply.github.com> Date: 2024-08-30 (Fri, 30 Aug 2024) Changed paths: M 2DSA-CG_1.php M 2DSA_1.php M 2DSA_2.php M DMGA_2.php M data_sharing.php M db.php M edit_instruments.php M edit_labs.php M lib/reports.php M queue_setup_2_funcs.php M runID_info.php M solution_detail.php Log Message: ----------- Merge pull request #29 from doluk/sql-injection Sql injection Commit: b3252cb2c3b85a1320108e7e607d67329d4a68e7 https://github.com/ehb54/us3lims_dbinst/commit/b3252cb2c3b85a1320108e7e607d6... Author: Lukas Dobler <69309597+doluk@users.noreply.github.com> Date: 2024-08-30 (Fri, 30 Aug 2024) Changed paths: M lib/payload_manager.php Log Message: ----------- Update payload_manager.php Commit: 00ce3b9dfc446cd292376011307a296b2b8784aa https://github.com/ehb54/us3lims_dbinst/commit/00ce3b9dfc446cd292376011307a2... Author: Lukas Dobler <69309597+doluk@users.noreply.github.com> Date: 2024-08-30 (Fri, 30 Aug 2024) Changed paths: Log Message: ----------- Merge branch 'ehb54:sql-injection' into sql-injection Commit: 07fb8d97cfdc791ba4645fe013b5394cf657b6ed https://github.com/ehb54/us3lims_dbinst/commit/07fb8d97cfdc791ba4645fe013b53... Author: ehb54 <ehb54@users.noreply.github.com> Date: 2024-08-30 (Fri, 30 Aug 2024) Changed paths: M lib/payload_manager.php Log Message: ----------- Merge pull request #30 from doluk/sql-injection Sql injection Commit: b43eb331a0397e3b3c1f3cf8509e29dac6de3699 https://github.com/ehb54/us3lims_dbinst/commit/b43eb331a0397e3b3c1f3cf8509e2... Author: Lukas Dobler <69309597+doluk@users.noreply.github.com> Date: 2024-08-30 (Fri, 30 Aug 2024) Changed paths: M lib/HPC_analysis.php Log Message: ----------- Update HPC_analysis.php Commit: cab44e7ff5f6b70413ad9633f0d25cd8bb0fa7f6 https://github.com/ehb54/us3lims_dbinst/commit/cab44e7ff5f6b70413ad9633f0d25... Author: Lukas Dobler <69309597+doluk@users.noreply.github.com> Date: 2024-08-30 (Fri, 30 Aug 2024) Changed paths: M lib/HPC_analysis.php Log Message: ----------- Update HPC_analysis.php Commit: 5ad0d9c1e206e5afc25e309d15c59465f5568427 https://github.com/ehb54/us3lims_dbinst/commit/5ad0d9c1e206e5afc25e309d15c59... Author: Lukas Dobler <69309597+doluk@users.noreply.github.com> Date: 2024-08-30 (Fri, 30 Aug 2024) Changed paths: M lib/HPC_analysis.php Log Message: ----------- Update HPC_analysis.php Commit: e5aff3137dcc0274d0d5ee489d6badb9fae8c3e9 https://github.com/ehb54/us3lims_dbinst/commit/e5aff3137dcc0274d0d5ee489d6ba... Author: Lukas Dobler <69309597+doluk@users.noreply.github.com> Date: 2024-08-30 (Fri, 30 Aug 2024) Changed paths: M lib/HPC_analysis.php Log Message: ----------- Update HPC_analysis.php Commit: 450d22dbcdf19a34853655958a5e9cd39bf7e0a5 https://github.com/ehb54/us3lims_dbinst/commit/450d22dbcdf19a34853655958a5e9... Author: Lukas Dobler <69309597+doluk@users.noreply.github.com> Date: 2024-08-30 (Fri, 30 Aug 2024) Changed paths: M runID_info.php Log Message: ----------- Update runID_info.php Commit: 76c1a1b12dd63ebec2f80a6eba810daccb7683ce https://github.com/ehb54/us3lims_dbinst/commit/76c1a1b12dd63ebec2f80a6eba810... Author: ehb54 <ehb54@users.noreply.github.com> Date: 2024-08-31 (Sat, 31 Aug 2024) Changed paths: M lib/HPC_analysis.php M runID_info.php Log Message: ----------- Merge pull request #31 from doluk/sql-injection Sql injection Commit: cd146a68eead46d701791ee5d5a9b6e4ccfa2de1 https://github.com/ehb54/us3lims_dbinst/commit/cd146a68eead46d701791ee5d5a9b... Author: doluk <69309597+doluk@users.noreply.github.com> Date: 2024-09-06 (Fri, 06 Sep 2024) Changed paths: M checkuser.php M config.php.template M edit_users.php M get_user_info.php M register.php Log Message: ----------- Deal with Database features GMP/PAM not being available, document feature flags properly Commit: 144f0e8775edb283ac73d2156c5307fa45a9ace7 https://github.com/ehb54/us3lims_dbinst/commit/144f0e8775edb283ac73d2156c530... Author: doluk <69309597+doluk@users.noreply.github.com> Date: 2024-09-06 (Fri, 06 Sep 2024) Changed paths: M lib/utility.php M newaccount.php Log Message: ----------- Fix captcha text extending over background by limiting it to 6 characters Commit: ced904d84085aa8d44b9e2ba76659a92ea85433b https://github.com/ehb54/us3lims_dbinst/commit/ced904d84085aa8d44b9e2ba76659... Author: doluk <69309597+doluk@users.noreply.github.com> Date: 2024-09-14 (Sat, 14 Sep 2024) Changed paths: M checkuser.php M edit_users.php M queue_setup_2_funcs.php Log Message: ----------- Format usage of ?? Commit: ad75969f102f23fcd8706dc627cd1adf97c60985 https://github.com/ehb54/us3lims_dbinst/commit/ad75969f102f23fcd8706dc627cd1... Author: doluk <69309597+doluk@users.noreply.github.com> Date: 2024-09-14 (Sat, 14 Sep 2024) Changed paths: M runID_info.php Log Message: ----------- Properly check permissions before displaying HPCDetails Commit: b1f605f1db73b8e4feffceac9b858b5a5b85cda0 https://github.com/ehb54/us3lims_dbinst/commit/b1f605f1db73b8e4feffceac9b858... Author: doluk <69309597+doluk@users.noreply.github.com> Date: 2024-09-14 (Sat, 14 Sep 2024) Changed paths: M 2DSA-CG_1.php M DMGA_1.php M DMGA_2.php M GA_1.php M GA_2.php M HPC_requests.php M PCSA_1.php M admin_links.php M global_menu.php M globaldb_stats.php M lib/HPC_analysis.php M lib/payload_manager.php M links.php M queue_content.php M queue_setup_2.php M queue_setup_2_funcs.php M queue_setup_3.php M queue_viewer.php M report_getInfo.php M view_reports.php Log Message: ----------- Convert `isset( $x ) ? $x : default` to `$x ?? default` Commit: fde4bc21a4974e47686ece8dcc87d547caabbd7a https://github.com/ehb54/us3lims_dbinst/commit/fde4bc21a4974e47686ece8dcc87d... Author: ehb54 <ehb54@users.noreply.github.com> Date: 2024-10-03 (Thu, 03 Oct 2024) Changed paths: M 2DSA-CG_1.php M DMGA_1.php M DMGA_2.php M GA_1.php M GA_2.php M HPC_requests.php M PCSA_1.php M admin_links.php M checkuser.php M config.php.template M edit_users.php M get_user_info.php M global_menu.php M globaldb_stats.php M lib/HPC_analysis.php M lib/payload_manager.php M lib/utility.php M links.php M newaccount.php M queue_content.php M queue_setup_2.php M queue_setup_2_funcs.php M queue_setup_3.php M queue_viewer.php M register.php M report_getInfo.php M runID_info.php M view_reports.php Log Message: ----------- Merge pull request #33 from doluk/sql-injection New user account creation fails Commit: 264f6e51e4102fdb6b3f60ce54f4194174276e93 https://github.com/ehb54/us3lims_dbinst/commit/264f6e51e4102fdb6b3f60ce54f41... Author: doluk <69309597+doluk@users.noreply.github.com> Date: 2024-10-03 (Thu, 03 Oct 2024) Changed paths: M edit_users.php M register.php Log Message: ----------- Fix missing userNamePAM Commit: 8600f6bbf7d949066bfabbbea7a3d6e59f449aea https://github.com/ehb54/us3lims_dbinst/commit/8600f6bbf7d949066bfabbbea7a3d... Author: doluk <69309597+doluk@users.noreply.github.com> Date: 2024-10-04 (Fri, 04 Oct 2024) Changed paths: M edit_users.php Log Message: ----------- Fix additional , breaking sql query with enable_GMP = true Commit: 1c774191db50e5008e4ddc3b6e33726f7a62de8d https://github.com/ehb54/us3lims_dbinst/commit/1c774191db50e5008e4ddc3b6e337... Author: doluk <69309597+doluk@users.noreply.github.com> Date: 2024-10-07 (Mon, 07 Oct 2024) Changed paths: M edit_users.php Log Message: ----------- Fix missing update for GMP Reviewer Role due to missing global enable_GMP Commit: cd48d89c74c456522f16719fc96e9aa29221a61b https://github.com/ehb54/us3lims_dbinst/commit/cd48d89c74c456522f16719fc96e9... Author: doluk <69309597+doluk@users.noreply.github.com> Date: 2024-10-07 (Mon, 07 Oct 2024) Changed paths: M newaccount.php Log Message: ----------- Fix unset variable $_SESSION['POST'] Commit: c4deda70608fc50f6932960245db1ad54005163b https://github.com/ehb54/us3lims_dbinst/commit/c4deda70608fc50f6932960245db1... Author: doluk <69309597+doluk@users.noreply.github.com> Date: 2024-10-07 (Mon, 07 Oct 2024) Changed paths: M register.php Log Message: ----------- Remove parts of old querying Commit: 422c385ac77e6eea88e4da5238ea4947c00e701c https://github.com/ehb54/us3lims_dbinst/commit/422c385ac77e6eea88e4da5238ea4... Author: Lukas Dobler <69309597+doluk@users.noreply.github.com> Date: 2024-10-07 (Mon, 07 Oct 2024) Changed paths: M css/supporting_files.css M edit_users.php M js/supporting_files.js M lib/grant_integrity.php Log Message: ----------- Merge branch 'master' into sql-injection Commit: b0b62b469322f9634419678d1eb323181eaf2dfc https://github.com/ehb54/us3lims_dbinst/commit/b0b62b469322f9634419678d1eb32... Author: doluk <69309597+doluk@users.noreply.github.com> Date: 2024-10-08 (Tue, 08 Oct 2024) Changed paths: M edit_users.php Log Message: ----------- Don't default to email for userNamePAM if enable_PAM is set and true Commit: 57c25fb3d6ee1158d77ad0e4f8acde1d0165fe5b https://github.com/ehb54/us3lims_dbinst/commit/57c25fb3d6ee1158d77ad0e4f8acd... Author: doluk <69309597+doluk@users.noreply.github.com> Date: 2024-11-11 (Mon, 11 Nov 2024) Changed paths: M profile.php Log Message: ----------- Fix update query of change_my_info Commit: 65d58aec109d8b011b6f0ea204f3b60f2ca0d8df https://github.com/ehb54/us3lims_dbinst/commit/65d58aec109d8b011b6f0ea204f3b... Author: ehb54 <ehb54@users.noreply.github.com> Date: 2025-01-26 (Sun, 26 Jan 2025) Changed paths: M lib/utility.php M queue_content.php Log Message: ----------- Merge pull request #38 from ehb54/metascheduler Metascheduler Commit: c78cba1aa69f3bbb7fe1baa4bf23792bb159f0ce https://github.com/ehb54/us3lims_dbinst/commit/c78cba1aa69f3bbb7fe1baa4bf237... Author: ehb54 <ehb54@users.noreply.github.com> Date: 2025-03-07 (Fri, 07 Mar 2025) Changed paths: M 2DSA-CG_1.php M 2DSA-CG_2.php M 2DSA_1.php M 2DSA_2.php M DMGA_1.php M DMGA_2.php M GA_1.php M GA_2.php M GA_3.php M HPC_requests.php M PCSA_1.php M PCSA_2.php M activate.php M admin_links.php M checkuser.php M config.php.template M data_sharing.php M db.php M edit_instruments.php M edit_labs.php M edit_projects.php M edit_users.php M get_user_info.php M global_menu.php M globaldb_stats.php M lib/HPC_analysis.php M lib/controls.php M lib/file_writer.php M lib/payload_manager.php M lib/reports.php M lib/selectboxes.php M lib/utility.php M links.php M newaccount.php M profile.php M queue_content.php M queue_setup_1.php M queue_setup_2.php M queue_setup_2_funcs.php M queue_setup_3.php M queue_viewer.php M recover_password.php M register.php M report_detail.php M report_getInfo.php M runID_info.php M show_image.php M solution_detail.php M view_reports.php M view_users.php Log Message: ----------- Merge pull request #27 from ehb54/sql-injection Sql injection Compare: https://github.com/ehb54/us3lims_dbinst/compare/97ea12f2b49d...c78cba1aa69f To unsubscribe from these emails, change your notification settings at https://github.com/ehb54/us3lims_dbinst/settings/notifications
participants (1)
-
ehb54