CS238-Forum-Website/install.php at master · jpeg/CS238-Forum-Website · 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
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
<?php
include 'config.php';
include 'template.php';

template_head('Install Script', 'Jason Gassel');
?>
<section id="content">
<?php

if(isset($_GET['install']))
{
  // Just in case logged into old instance
  session_start();
  session_destroy();

  $success = "<font class=\"success\">SUCCESS</font><br />\n";
  $failure = "<font class=\"failure\">FAILED</font><br />\n";
  $dne = "<font class=\"success\">DNE</font><br />\n";

  // Setup database
  echo "<h3>Install Script</h3><p>\n";

  echo 'Connect to database: ';
  $db = new mysqli($db_server, $db_user, $db_password);
  if(!$db)
    echo $failure;
  else
  {
    echo $success;

    // Drop database to delete old data
    echo 'Drop old database: ';
    if($db->query("DROP DATABASE $db_database"))
      echo $success;
    else
      echo $dne;

    // Create and connect to database
    echo 'Creating database: ';
    if($db->query("CREATE DATABASE $db_database"))
      echo $success;
    else
      echo $failure;
    echo 'Connecting to database: ';
    if(!$db->select_db($db_database))
      echo $failure;
    else
    {
      echo $success;

      // Create database tables
      echo 'Creating users table: ';
      if($db->query("CREATE TABLE user(uid INT UNIQUE NOT NULL AUTO_INCREMENT PRIMARY KEY, username VARCHAR(20) UNIQUE NOT NULL, password CHAR(32) NOT NULL, avatar VARCHAR(200) DEFAULT '$avatar_default', firstName VARCHAR(20), lastName VARCHAR(20))"))
        echo $success;
      else
        echo $failure;

      echo 'Creating threads table: ';
      if($db->query('CREATE TABLE thread(tid INT UNIQUE NOT NULL AUTO_INCREMENT PRIMARY KEY, uid INT NOT NULL, title VARCHAR(40) NOT NULL, type INT NOT NULL, question VARCHAR(100), tag VARCHAR(10), FOREIGN KEY (uid) REFERENCES user(uid))'))
        echo $success;
      else
        echo $failure;

      echo 'Creating posts table: ';
      if($db->query('CREATE TABLE post(pid INT UNIQUE NOT NULL AUTO_INCREMENT, tid INT NOT NULL, uid INT NOT NULL, date DATE NOT NULL, time TIME NOT NULL, text VARCHAR(10000), PRIMARY KEY(pid, tid), FOREIGN KEY (tid) REFERENCES thread(tid), FOREIGN KEY (uid) REFERENCES user(uid))'))
        echo $success;
      else
        echo $failure;

      echo 'Creating poll options table: ';
      if($db->query('CREATE TABLE poll_option(tid INT NOT NULL, oid INT NOT NULL, option_text VARCHAR(60) NOT NULL, PRIMARY KEY(tid, oid), FOREIGN KEY (tid) REFERENCES thread(tid))'))
        echo $success;
      else
        echo $failure;

      echo 'Creating poll votes table: ';
      if($db->query('CREATE TABLE poll_vote(tid INT NOT NULL, uid INT NOT NULL, oid INT NOT NULL, PRIMARY KEY(tid, uid), FOREIGN KEY (tid) REFERENCES thread(tid), FOREIGN KEY (uid) REFERENCES user(uid))'))
        echo $success;
      else
        echo $failure;
    }
  }
  $db->close();

  // Avatars
  echo 'Checking images directory: ';
  if (!is_dir('images'))
  {
    if(mkdir('images'))
      echo $success;
    else
      echo $failure;
  }
  else
    echo $success;

  echo 'Deleting old avatar directory: ';
  if (is_dir('images/avatars'))
  {
    if(rmdir('images/avatars'))
      echo $success;
    else
      echo $failure;
  }
  else
    echo $dne;

  echo 'Creating avatar directory: ';
  if(mkdir('images/avatars'))
    echo $success;
  else
    echo $failure;

  // Finished
  echo "</p><p>Done</p>\n";
}
else
{
  // Make sure user really wants to install
?>
    <br />
    <h3 style="text-align: center;">WARNING: Install script will erase ALL existing data.</h3>
    <h1 style="text-align: center;"><a href="install.php?install">INSTALL</a></h1>
    <br />
    <br />
<?php
}

template_footer();
?>