-
Notifications
You must be signed in to change notification settings - Fork 1
/
connection.php
71 lines (56 loc) · 2.64 KB
/
connection.php
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
<?php
class Connection
{
public function initialize()
{
if (file_exists("include/configuration.php")) {
$configs = include("include/configuration.php");
} else {
$configs = include("include/configuration-template.php");
}
require("alert.php");
/** Create connection */
$conn = new mysqli($configs->host, $configs->username, $configs->password);
$alert = new Alert;
/** Check connection */
if ($conn->connect_error) {
die("<div class=\"alert alert-danger alert-dismissable\"><a class=\"close fa fa-close\" data-dismiss=\"alert\" aria-label=\"close\"></a><b>Connection failed:</b> " . $conn->connect_error . "</div>");
}
$conn = new mysqli($configs->host, $configs->username, $configs->password, $configs->database);
/** sql to create table */
$sql = "CREATE TABLE Tracked (sha VARCHAR(256), issueID VARCHAR(256))";
if ($conn->query($sql) === TRUE) {
$message = "Table Tracked created successfully";
$alert->success($message);
}
/** sql to create table */
$sql = "CREATE TABLE Users (name VARCHAR(256) NOT NULL, username VARCHAR(128) NOT NULL, id INT(35) NOT NULL, score INT(25) DEFAULT 0, added INT(25) DEFAULT 0, removed INT(25) DEFAULT 0, challenge INT(25) DEFAULT 0, commits INT(25) DEFAULT 0, issues INT(25) DEFAULT 0, pullRequests INT(25) DEFAULT 0)";
if ($conn->query($sql) === TRUE) {
$message = "Table Users created successfully";
$alert->success($message);
}
/** sql to create table */
$sql = "CREATE TABLE Stats (repository VARCHAR(256), commits INT(25) DEFAULT 0)";
if ($conn->query($sql) === TRUE) {
$message = "Table Stats created successfully";
$alert->success($message);
}
if ($configs->options->event == true) {
/** sql to create table */
$sql = "CREATE TABLE Events (prize VARCHAR(256))";
if ($conn->query($sql) === TRUE) {
$message = "Table Events created successfully";
$alert->success($message);
}
}
if ($configs->options->challenges == true) {
/** sql to create table */
$sql = "CREATE TABLE Challenges (id INT(25) NOT NULL, name VARCHAR(256), description VARCHAR(5000), points INT(25), hint VARCHAR(256), users VARCHAR(1024))";
if ($conn->query($sql) === TRUE) {
$message = "Table Challenges created successfully";
$alert->success($message);
}
}
return $conn;
}
}