forked from jackcogdill/FB-hack-attack
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathdatabase.txt
More file actions
72 lines (71 loc) · 5.4 KB
/
database.txt
File metadata and controls
72 lines (71 loc) · 5.4 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
/——————————————————————————————\
| Copy Pasta |
\——————————————————————————————/
create database quiz;
use quiz;
GRANT ALL PRIVILEGES ON quiz.*
TO 'quizer'@'localhost'
IDENTIFIED BY 'quizme';
CREATE TABLE users (
id INT(11) NOT NULL AUTO_INCREMENT,
first_name VARCHAR(55) NOT NULL,
last_name VARCHAR(55) NOT NULL,
username VARCHAR(55) NOT NULL,
email VARCHAR(55) NOT NULL,
password VARCHAR(255) NOT NULL,
salt VARCHAR(55) NOT NULL,
points INT(11),
PRIMARY KEY (id)
);
CREATE TABLE waiting (
id INT(11) NOT NULL AUTO_INCREMENT,
username VARCHAR(55) NOT NULL,
first_name VARCHAR(55) NOT NULL,
last_name VARCHAR(55) NOT NULL,
language VARCHAR(55) NOT NULL,
points INT(11),
opponent VARCHAR(55),
PRIMARY KEY (id)
);
CREATE TABLE challenges (
id INT(11) NOT NULL,
language VARCHAR(55) NOT NULL,
challenge_num INT(11) NOT NULL,
challenge_info VARCHAR(255) NOT NULL,
correct_out VARCHAR(255) NOT NULL,
points INT(11) NOT NULL,
minutes INT(11) NOT NULL,
PRIMARY KEY (id)
);
CREATE TABLE ongoing (
id VARCHAR(255) NOT NULL,
challenge_id INT(11) NOT NULL,
user1 VARCHAR(55) NOT NULL,
user2 VARCHAR(55) NOT NULL,
first_name1 VARCHAR(55) NOT NULL,
last_name1 VARCHAR(55) NOT NULL,
first_name2 VARCHAR(55) NOT NULL,
last_name2 VARCHAR(55) NOT NULL,
start_time INT(11) NOT NULL,
winner VARCHAR(55),
points1 INT(11) NOT NULL,
points2 INT(11) NOT NULL,
PRIMARY KEY (id)
);
insert into challenges (id, language, challenge_num, challenge_info, correct_out, points, minutes) values (1, 'Python', 1, 'Output the following string: "Hello, World!"', 'Hello, World!', 1, 1);
insert into challenges (id, language, challenge_num, challenge_info, correct_out, points, minutes) values (2, 'Python', 2, 'Add up all the numbers from 1 to 100,000 containing the number 1337 within its digits; e.g., 11337. Print the sum.', '597115', 5, 2);
insert into challenges (id, language, challenge_num, challenge_info, correct_out, points, minutes) values (3, 'Python', 3, 'Find the largest number in the list: [31410, 13652, 93851, 51322, 21260, 98965, 70442, 92985, 6586, 86111, 9445, 6857, 71703, 80278, 18551, 92955, 52557, 63390, 94262, 30979, 53297, 16560, 33799, 21134, 89342, 41782, 17806, 71952, 2641, 75456]', '98965', 5, 1);
insert into challenges (id, language, challenge_num, challenge_info, correct_out, points, minutes) values (4, 'Python', 4, 'What is the highest frequency color in: "orangeyelloworangeyellowpurpleyellowgreengreenyellowredyellowyellowbluepurpleorangeblueblueredbluepurplepurplegreenbluegreenpurpleblueredorangeorangepurplegreenyelloworangebluegreenblueorangeyellowyellowblueblue"', 'blue', 12, 5);
insert into challenges (id, language, challenge_num, challenge_info, correct_out, points, minutes) values (5, 'Java', 1, 'Output the following string: "Hello, World!"', 'Hello, World!', 1, 1);
insert into challenges (id, language, challenge_num, challenge_info, correct_out, points, minutes) values (6, 'Crypto', 1, 'PelcGbTenCulPunYYraTrTrGFbzrCbvAgf', 'CrypToGraPhyChaLLenGeGeTSomePoiNts', 2, 3);
insert into challenges (id, language, challenge_num, challenge_info, correct_out, points, minutes) values (7, 'Crypto', 2, 'Q2FuIHlvdSBnZXQgYmFzZTY0PyBIbS4uIEkgd29uZGVyCg==', 'Can you get base64? Hm.. I wonder', 2, 3);
insert into challenges (id, language, challenge_num, challenge_info, correct_out, points, minutes) values (8, 'Crypto', 3, '00101010 01101010 00000010 11001110 01001110 10100110 11010110 11000110 10000110 00010010 00000100 11110110 00101110 00000100 00101110 10101110 11110110 00000100 10100110 10110110 11110110 11000010', 'Come out to Hackers@VT', 5, 4);
insert into challenges (id, language, challenge_num, challenge_info, correct_out, points, minutes) values (9, 'Crypto', 4, 'ffd3624a222b0e079c6ea0c9935fa83d', 'imsuper1337', 6, 5);
insert into challenges (id, language, challenge_num, challenge_info, correct_out, points, minutes) values (10, 'Crypto', 5, 'Crack this code: <img src="crypt5.png" width="50%"><br>Hint: VBGDEIHCN', 'veni vidi vici', 7, 5);
insert into challenges (id, language, challenge_num, challenge_info, correct_out, points, minutes) values (11, 'Crypto', 6, 'Find the message within this password protected zip file: <a href="crypt6.zip">crypt6.zip</a><br>Hint: the password is lowercase', 'You found me! I\'m the password for crypto 6 (^_^)', 25, 10);
insert into challenges (id, language, challenge_num, challenge_info, correct_out, points, minutes) values (12, 'CTF', 1, 'Find the password.', 'La4NrQCUvbzscKeL', 2, 3);
insert into challenges (id, language, challenge_num, challenge_info, correct_out, points, minutes) values (13, 'CTF', 2, '<span style="color: red;">Error loading password.php</span>', 'h2L2AweW', 3, 4);
insert into challenges (id, language, challenge_num, challenge_info, correct_out, points, minutes) values (14, 'CTF', 3, 'Enter your age as 1337.', '', 5, 4);
insert into challenges (id, language, challenge_num, challenge_info, correct_out, points, minutes) values (15, 'CTF', 4, 'Info: you must be using the "HackAttacks" web browser.', '', 6, 5);
insert into challenges (id, language, challenge_num, challenge_info, correct_out, points, minutes) values (16, 'CTF', 5, 'Find the secret!!<br>Hint: Man vs machine', 'th1s_1s_it!!!', 15, 7);
insert into challenges (id, language, challenge_num, challenge_info, correct_out, points, minutes) values (17, 'CTF', 6, 'Hint: dwssapth', '', 25, 10);