A Dangerous Contact | CyberStart Completion

Intern

Hello World Mixed Up Messages Social Engineering Lazy Locked Login The Rocketeer 610enC0de'd Password Traffic Jam Start-Up Troubles Hextraordinary Maths at Light Speed Off Balance The Final Countdown

Headquarters L1

Social Secret Broken Banks Happy Customers Race To Where Mixed Messages Executable Secret Saesar Hidden Report Bike Fan Horrible Hats Tower of Wheels Binary Bike Lock

Headquarters L2

Decryption Ring Binary Bike Lock Secret Pages Too Much Text More Broken Bicycles Broken Link Hard Hash Encrypted Message Fingerprints Useful Hack Under Attack User Who

Headquarters L3

A Secret Rendezvous Lucky Throw Chopper Check-in Confused Secret Source Corrupted Route into the Router Password Postulation Snake Charmer The Competitor Revealed Big Transfer Dante In Command?

Headquarters L4

A Helping Hand Arnold Chopper? Photobomb Upgrades? Paaa! A Dangerous Contact Maggie's File Bendikke Loves Axes Phishing For Flemming Lockdown Lost But Not Forgotten Bad Kitty

Headquarters L5

Perplexed by Pixels Word On The Street Shinji's Drone Out Of Sight Zapped File Found Shopping For Secrets Perplexed by Pixels Yakoo Cars T-Shirt Trivia Baffled By Browsers Dangerous Comment

Headquarters L6

Rezapped Truck Stop Meeting Momoko Lost Key Running Man Heroka's DB Hush Fund Junya Who? QR.gif Custom Plates Still Hiding Brute Strength

Headquarters L7

Dot Dot Dash Hidden Boats Docking Port Pedro's Password Quick Drop Miguel the Moneyman Developer Disaster Breaking Bottles Bash the Botnet All Zipped Up Secret Spreadsheet Password Pickle

Moon L1

Programming 101 Handy Variables Converting for Fun Maths in Code Super Strings

Moon L2

Flow with Conditionals Logical Let's Get Functional Hooray for Arrays Going Loopy

A Dangerous Contact

Briefing:

During our research into The Choppers, we noticed that their website has a contact page with a form for getting in touch. Our agents want to know whether it might be vulnerable to SQL injection.

See if you can put the SQL code in the right order. If you do, the data should appear in the console at the top of the page. This will contain the information we’re looking for - a list of all previously submitted messages.

Tip: The flag is the last name of the most recent person to send a message through the form.

Hint:

This is a test on SQL injection. You have to get the whole table of information by running the right SQL command, so re-order the parts of the command in the message box and submit the form. Try starting with the single quote character, which will close the speechmarks in the command and then think about what is always true.

How to Solve:

Arrange the query in the correct order:
1. '); SELECT first_name, last_name, email, message FROM messages:--

Answer:

Wolsen

Improve this page