Installer/database.php at master · ElMedievo/Installer · GitHub

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
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
<?php
	echo "---------- SQL Info ---------". "\xA";
	$servername = readline("<- Host: ");
	$username = readline("<- Username: ");
	$password = readline("<- Password: ");
	echo "-----------------------------". "\xA";

	$conn = new mysqli($servername, $username, $password);

	if ($conn->connect_error) {
	    die("Connection failed: " . $conn->connect_error);
	}

	echo "---------- Medievo ---------" . "\xA";

	###

	$create_db = "CREATE DATABASE medievo";
	if ($conn->query($create_db) === TRUE) {
	    echo "-> Database created successfully." . "\xA";
	} else {
	    echo "-> Error creating database: " . $conn->error . "\xA";
	}

	###

	$create_player_data = "CREATE TABLE `medievo`.`player_data`
			(
			`uuid` VARCHAR(50) NOT NULL ,
			`name` VARCHAR(16) NOT NULL ,
			`gold` INT NOT NULL ,
			`clan` VARCHAR(16) NOT NULL ,
			`kills` INT NOT NULL ,
			`killed` INT NOT NULL ,
			`deaths` INT NOT NULL
			)
			ENGINE = InnoDB;
			";
	if ($conn->query($create_player_data) === TRUE) {
	    echo "-> player_data table created successfully." . "\xA";
	} else {
	    echo "-> Error creating player_data table: " . $conn->error . "\xA";
	}

	###

	$create_clans_data = "CREATE TABLE `medievo`.`clans_data`
			(
			`name` VARCHAR(16) NOT NULL ,
			`leader_uuid` VARCHAR(50) NOT NULL ,
			`leader_name` VARCHAR(16) NOT NULL
			)
			ENGINE = InnoDB;
			";
	if ($conn->query($create_clans_data) === TRUE) {
	    echo "-> clans_data table created successfully." . "\xA";
	} else {
	    echo "-> Error creating clans_data table " . $conn->error . "\xA";
	}

	###

	$create_economy_data = "CREATE TABLE `medievo`.`economy_data`
			(
			`clan` VARCHAR(16) NOT NULL ,
			`gold_ingot` INT NOT NULL ,
			`gold_nugget` INT NOT NULL ,
			`golden_carrot` INT NOT NULL ,
			`golden_horse_armor` INT NOT NULL ,
			`gold_block` INT NOT NULL ,
			`golden_sword` INT NOT NULL ,
			`golden_shovel` INT NOT NULL ,
			`golden_pickaxe` INT NOT NULL ,
			`golden_axe` INT NOT NULL ,
			`golden_hoe` INT NOT NULL ,
			`golden_helmet` INT NOT NULL ,
			`golden_chestplate` INT NOT NULL ,
			`golden_leggings` INT NOT NULL ,
			`golden_boots` INT NOT NULL ,
			`golden_apple` INT NOT NULL ,
			`alfonsos` INT NOT NULL
			)
			ENGINE = InnoDB;
			";
	if ($conn->query($create_economy_data) === TRUE) {
	    echo "-> economy_data table created successfully." . "\xA";
	} else {
	    echo "-> Error creating economy_data table " . $conn->error . "\xA";
	}

	###

	$conn->close();
	echo "-----------------------------" . "\xA";
?>