Ubikuity.net Web application developer

Last year, I had the chance to attend one of the excellent workshop “Hack Yourself First” presented by Troy Hunt: http://www.troyhunt.com/2016/02/more-europe-even-more-again-and-more.html

Now it’s time to practice again by using the (very simple) tool Havij and use the dedicated and deliberately vulnerable website http://hackyourselffirst.troyhunt.com/

To celebrate the unveiling of Tesla new car, I just played a little with Havij and I updated an existing car with Tesla Model S P90D characteristics: http://hackyourselffirst.troyhunt.com/Supercar/8

I guess the changes will be reverted soon, so I took a screenshot:

Just for reference, here is the SQL script I used:

UPDATE Make SET name=’Tesla Motors’ WHERE MakeId=8;
UPDATE Supercar SET Cylinders=’V0′ WHERE SupercarId=8;
UPDATE Supercar SET Description=’Model S acceleration is instantaneous, silent and smooth’ WHERE SupercarId=8;
UPDATE Supercar SET EngineCc=0 WHERE SupercarId=8;
UPDATE Supercar SET EngineLayout=’Dual electric motor’ WHERE SupercarId=8;
UPDATE Supercar SET Model=’Tesla Model S P90D’ WHERE SupercarId=8;
UPDATE Supercar SET PowerKw=568 WHERE SupercarId=8;
UPDATE Supercar SET TopSpeedKm=250 WHERE SupercarId=8;
UPDATE Supercar SET TorqueNm=967 WHERE SupercarId=8;
UPDATE Supercar SET WeightKg=2200 WHERE SupercarId=8;
UPDATE Supercar SET ZeroToOneHundredKmInSecs=2.8 WHERE SupercarId=8;

Some of the other attendees created a blog post to summarize what we learned at the workshop:

• https://theholyjava.wordpress.com/2015/06/17/notes-from-troy-hunts-hack-yourself-first-workshop/
• https://bjorncoltof.github.io/2015/06/26/ndcoslo-security-workshop/

I was searching for a list of neighboring/bordering/adjacent states for each USA state.

I wasn’t able to find any open data, so I decided to create my own list using the following sources:

• http://theincidentaleconomist.com/wordpress/list-of-neighboring-states-with-stata-code/
• http://www.john.geek.nz/2009/01/sql-tips-list-of-us-states/
• http://askville.amazon.com/Trivia-state-bordered-states/AnswerViewer.do?requestId=3941039
• http://en.wikipedia.org/wiki/List_of_U.S._states_by_date_of_statehood
• http://en.wikipedia.org/wiki/History_of_Washington,_D.C.

=> Feel free to verify, contribute and reuse my file: neighbors-states.csv

Notes:

• The SQL script was created for SQL Server 2008.

Possible improvements:

• Add a column called “IsApproximativeNeighbor” in the table “NeighborStates” to define properly the relation between Alaska and Washington state even if there is no common border.

Off topic:

• At first, I wanted to use MySQL but I discovered that MySQL constraint implementation still is incomplete: “the CHECK clause is parsed but ignored by all storage engines”. See http://bugs.mysql.com/bug.php?id=3464 and http://dev.mysql.com/doc/refman/5.1/en/create-table.html.
• Maybe some of you remember the song from this cartoon: Animaniacs video of Wakko’s famous 50 State Capitols song.
• By the way, I never been to the USA and this list give some motivation to visit USA!

Here is a nice poster to summarize what’s new in .NET Framework 4.5:

http://www.heikniemi.net/hardcoded/2011/10/whats-new-in-net-framework-4-5-poster/

Concerning ASP.NET, I like:

• New site template for ASPNET MVC 4
• Built-in Javascript + CSS combining and minification
• Strongly typed data binding in ASP.NET Web Forms
• Multiple file upload component for ASP.NET Web Forms
• IIS Express used by default (instead of Cassini)