· 8 years ago · Dec 12, 2017, 01:14 PM
1<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
2<html xmlns="http://www.w3.org/1999/xhtml">
3<head>
4<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
5<title>SETUP DB</title>
6</head>
7
8<body bgcolor="#000000">
9
10<div style=" margin-top:20px;color:#FFF; font-size:24px; text-align:center">
11Welcome
12<font color="#FF0000"> Dhakkan </font>
13<br>
14</div>
15
16<div style=" margin-top:10px;color:#FFF; font-size:23px; text-align:left">
17<font size="3" color="#FFFF00">
18SETTING UP THE DATABASE SCHEMA AND POPULATING DATA IN TABLES:
19<br><br>
20
21
22<?php
23//including the Mysql connect parameters.
24include("../sql-connections/db-creds.inc");
25
26
27
28
29$con = mysql_connect($hos,$dbuser,$dbpass);
30if (!$con)
31 {
32 die('[*]...................Could not connect to DB, check the creds in db-creds.inc: ' . mysql_error());
33 }
34
35
36
37
38//@mysql_select_db('mysql',$con)
39
40//purging Old Database
41 $sql="DROP DATABASE IF EXISTS security";
42 if (mysql_query($sql))
43 {echo "[*]...................Old database 'SECURITY' purged if exists"; echo "<br><br>\n";}
44 else
45 {echo "[*]...................Error purging database: " . mysql_error(); echo "<br><br>\n";}
46
47
48//Creating new database security
49 $sql="CREATE database `security` CHARACTER SET `gbk` ";
50 if (mysql_query($sql))
51 {echo "[*]...................Creating New database 'SECURITY' successfully";echo "<br><br>\n";}
52 else
53 {echo "[*]...................Error creating database: " . mysql_error();echo "<br><br>\n";}
54
55//creating table users
56$sql="CREATE TABLE security.users (id int(3) NOT NULL AUTO_INCREMENT, username varchar(20) NOT NULL, password varchar(20) NOT NULL, PRIMARY KEY (id))";
57 if (mysql_query($sql))
58 {echo "[*]...................Creating New Table 'USERS' successfully";echo "<br><br>\n";}
59 else
60 {echo "[*]...................Error creating Table: " . mysql_error();echo "<br><br>\n";}
61
62
63//creating table emails
64$sql="CREATE TABLE security.emails
65 (
66 id int(3)NOT NULL AUTO_INCREMENT,
67 email_id varchar(30) NOT NULL,
68 PRIMARY KEY (id)
69 )";
70 if (mysql_query($sql))
71 {echo "[*]...................Creating New Table 'EMAILS' successfully"; echo "<br><br>\n";}
72 else
73 {echo "[*]...................Error creating Table: " . mysql_error();echo "<br><br>\n";}
74
75
76
77//creating table uagents
78$sql="CREATE TABLE security.uagents
79 (
80 id int(3)NOT NULL AUTO_INCREMENT,
81 uagent varchar(256) NOT NULL,
82 ip_address varchar(35) NOT NULL,
83 username varchar(20) NOT NULL,
84 PRIMARY KEY (id)
85 )";
86 if (mysql_query($sql))
87 {echo "[*]...................Creating New Table 'UAGENTS' successfully";echo "<br><br>\n";}
88 else
89 {echo "[*]...................Error creating Table: " . mysql_error();echo "<br><br>\n";}
90
91
92//creating table referers
93$sql="CREATE TABLE security.referers
94 (
95 id int(3)NOT NULL AUTO_INCREMENT,
96 referer varchar(256) NOT NULL,
97 ip_address varchar(35) NOT NULL,
98 PRIMARY KEY (id)
99 )";
100 if (mysql_query($sql))
101 {echo "[*]...................Creating New Table 'REFERERS' successfully";echo "<br><br>\n";}
102 else
103 {echo "[*]...................Error creating Table: " . mysql_error();echo "<br><br>\n";}
104
105
106
107
108
109
110
111//inserting data
112$sql="INSERT INTO security.users (id, username, password) VALUES ('1', 'Dumb', 'Dumb'), ('2', 'Angelina', 'I-kill-you'), ('3', 'Dummy', 'p@ssword'), ('4', 'secure', 'crappy'), ('5', 'stupid', 'stupidity'), ('6', 'superman', 'genious'), ('7', 'batman', 'mob!le'), ('8', 'admin', 'admin'), ('9', 'admin1', 'admin1'), ('10', 'admin2', 'admin2'), ('11', 'admin3', 'admin3'), ('12', 'dhakkan', 'dumbo'), ('14', 'admin4', 'admin4')";
113 if (mysql_query($sql))
114 {echo "[*]...................Inserted data correctly into table 'USERS'";echo "<br><br>\n";}
115 else
116 {echo "[*]...................Error inserting data: " . mysql_error();echo "<br><br>\n";}
117
118
119
120//inserting data
121$sql="INSERT INTO `security`.`emails` (id, email_id) VALUES ('1', 'Dumb@dhakkan.com'), ('2', 'Angel@iloveu.com'), ('3', 'Dummy@dhakkan.local'), ('4', 'secure@dhakkan.local'), ('5', 'stupid@dhakkan.local'), ('6', 'superman@dhakkan.local'), ('7', 'batman@dhakkan.local'), ('8', 'admin@dhakkan.com')";
122 if (mysql_query($sql))
123 {echo "[*]...................Inserted data correctly into table 'EMAILS'";echo "<br><br>\n";}
124 else
125 {echo "[*]...................Error inserting data: " . mysql_error();echo "<br><br>\n";}
126
127
128
129
130//CREATE TABLE security.search (id int(3) NOT NULL AUTO_INCREMENT, search varchar(20) NOT NULL, PRIMARY KEY (id));
131//INSERT INTO `security`.`search` (search) VALUES ( 'Dumb@dhakkan.com'), ('Angel@iloveu.com'), ('Dummy@dhakkan.local'), ( 'secure@dhakkan.local'), ( 'stupid@dhakkan.local'), ( 'superman@dhakkan.local'), ( 'batman@dhakkan.local'), ( 'admin@dhakkan.com')";
132
133//including the Challenges DB creation file.
134include("../sql-connections/setup-db-challenge.php");
135?>
136
137
138</font>
139</div>
140</body>
141</html>