forked from qazbnm456/dockerized_fbctf
-
Notifications
You must be signed in to change notification settings - Fork 0
/
import_empty_db.sh
executable file
·47 lines (33 loc) · 1.43 KB
/
import_empty_db.sh
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
#!/bin/bash
DB="fbctf"
P_ROOT="root"
MODE="dev"
CTF_PATH="/var/www/fbctf"
function import_empty_db() {
local __u="ctf"
local __p="ctf"
local __user=$1
local __pwd=$2
local __db=$3
local __path=$4
local __mode=$5
mysql -u "$__user" --password="$__pwd" -e "CREATE DATABASE \`$__db\`;"
mysql -u "$__user" --password="$__pwd" "$__db" -e "source $__path/database/schema.sql;"
mysql -u "$__user" --password="$__pwd" "$__db" -e "source $__path/database/countries.sql;"
mysql -u "$__user" --password="$__pwd" "$__db" -e "source $__path/database/logos.sql;"
mysql -u "$__user" --password="$__pwd" -e "CREATE USER '$__u'@'localhost' IDENTIFIED BY '$__p';"
mysql -u "$__user" --password="$__pwd" -e "GRANT ALL PRIVILEGES ON \`$__db\`.* TO '$__u'@'localhost';"
mysql -u "$__user" --password="$__pwd" -e "FLUSH PRIVILEGES;"
cat "$__path/extra/settings.ini.example" | sed "s/DATABASE/$__db/g" | sed "s/MYUSER/$__u/g" | sed "s/MYPWD/$__p/g" > "$__path/settings.ini"
local PASSWORD
if [[ $__mode = "dev" ]]; then
PASSWORD='password'
else
PASSWORD=$(head -c 500 /dev/urandom | md5sum | cut -d" " -f1)
fi
HASH=$(hhvm -f "$__path/extra/hash.php" "$PASSWORD")
mysql -u "$__user" --password="$__pwd" "$__db" -e "INSERT INTO teams (name, password_hash, admin, protected, logo, created_ts) VALUES('admin', '$HASH', 1, 1, 'admin', NOW());"
}
# Database creation
import_empty_db "root" "$P_ROOT" "$DB" "$CTF_PATH" "$MODE"
exit 0