← back to room
SQL Injection
NewsDesk — Article archive
Scenario
NewsDesk's article viewer looks up rows by id from the query string. Errors from the database sometimes echo back to the page. Recover credential material stored in the users table.
Your approach
- Request a valid article id, then probe with a quote to trigger an error.
- Count columns with ORDER BY or UNION probes until the query succeeds.
- Union-select username and password fields from the users table.
- Read the admin password or flag value from the rendered result.
- Submit that recovered secret as your answer.
NewsDesk
Article archive
Articles are loaded by numeric id. Open one and experiment with the id parameter.
The meaning of life
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Phasellus tincidunt nec ipsum et lacinia. Donec semper orci vitae urna bibendum mollis. Fusce...
How to get started in hacking
Mauris et tempus purus. Vivamus a eros pulvinar, tristique massa sit amet, molestie sem. Aenean ullamcorper ligula eget nulla gravida, in congue metus...