Breadbin/admin.php at master · Jamie932/Breadbin · 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
<?php
    require("php/common.php");
    require("php/checkLogin.php");
    require("php/checkRank.php");

    $interval = '';

    if ((isset($_GET['t']) && $_GET['t'] != 'all') || (!isset($_GET['t']))) {
        $pre = isset($_GET['t']) ? $_GET['t'] . ' HOUR' : '1 DAY';
        $interval = ' WHERE date > DATE_SUB(now(), INTERVAL ' . $pre . ')';
    }

    $query = "SELECT COUNT(*) FROM posts" . $interval;
    $stmt = $db->prepare($query);
    $result = $stmt->execute();
    $numPosts = $stmt->fetchColumn();

    $query = "SELECT COUNT(*) FROM post_toasts" . $interval;
    $stmt = $db->prepare($query);
    $result = $stmt->execute();
    $numToasts = $stmt->fetchColumn();

    $query = "SELECT COUNT(*) FROM post_burns" . $interval;
    $stmt = $db->prepare($query);
    $result = $stmt->execute();
    $numBurns = $stmt->fetchColumn();

    $query = "SELECT COUNT(*) FROM users" . $interval;
    $stmt = $db->prepare($query);
    $result = $stmt->execute();
    $numUsers = $stmt->fetchColumn();
?>

<!DOCTYPE html>
<html>
<head>
    <title>Admin | Breadbin</title>
    <meta name="viewport" content="width=device-width, initial-scale=1.0" />
    <link href="css/common.css" rel="stylesheet" type="text/css">
    <link href="css/navbar.css" rel="stylesheet" type="text/css">
    <link href="css/admin.css" rel="stylesheet" type="text/css">
    <link href="css/vendor/chartist.min.css" rel="stylesheet" type="text/css">
    <link href="css/vendor/normalize.css" rel="stylesheet" type="text/css">
    <link href='http://fonts.googleapis.com/css?family=Roboto:400,700' rel='stylesheet' type='text/css'>
    <link rel="stylesheet" href="//maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css">
    <link rel="icon" type="image/png" href="img/favicon.png" />
    <script src="js/vendor/jquery-1.11.2.min.js"></script>
    <script src="js/vendor/jquery.cookie.js"></script>
    <script src="js/vendor/chartist.min.js"></script>
    <script src="js/pages/admin.js"></script>
    <script src="js/errorHandler.js"></script>
</head>
<body>
    <noscript>
      <META HTTP-EQUIV="Refresh" CONTENT="0;URL=error.php">
    </noscript>

    <?php require('php/template/navbar.php');?>
    <?php require('php/template/popup.php');?>

    <div id="contentWrap">
        <div class="bar" id="topBar">
            <div class="contentContainer">
                <div class="content">
                    <div class="statNumber"><?php echo $numPosts; ?></div>
                    <div class="statBottom">Posts</div>
                </div>
                <div class="content">
                    <div class="statNumber"><?php echo $numToasts; ?></div>
                    <div class="statBottom">Toasts</div>
                </div>
                <div class="content">
                    <div class="statNumber"><?php echo $numBurns; ?></div>
                    <div class="statBottom">Burns</div>
                </div>
                <div class="content">
                    <div class="statNumber">0</div>
                    <div class="statBottom">Reports</div>
                </div>
                <div class="content">
                    <div class="statNumber"><?php echo $numUsers; ?></div>
                    <div class="statBottom">New Users</div>
                </div>
            </div>

            <div id="bottomTopBar">
                <div class="content">
                    <?php
                        echo '<a href="admin.php" ' . (((isset($_GET['t']) && $_GET['t'] == '24') || !isset($_GET['t'])) ? 'class="timeActive"' : '') . '>24hr</a>';
                        echo '<a href="admin.php?t=48" ' . ((isset($_GET['t']) && $_GET['t'] == '48') ? 'class="timeActive"' : '') . '>48hr</a>';
                        echo '<a href="admin.php?t=168" ' . ((isset($_GET['t']) && $_GET['t'] == '168') ? 'class="timeActive"' : '') . '>1wk</a>';
                        echo '<a href="admin.php?t=all" ' . ((isset($_GET['t']) && $_GET['t'] == 'all') ? 'class="timeActive"' : '') . '>all</a>';
                     ?>
                </div>
            </div>
        </div>

        <div id="midContainer">
            <div id="midLeft">
                <?php
                    echo isset($colour) ? '<div class="title" style="background-color: '. $colour . '">Unique Visitors</div>' : '<div class="title">Unique Visitors</div>';
                ?>

                <div class="ct-chart ct-octave"></div>
            </div>

            <div id="midRight">
                <?php
                    echo isset($colour) ? '<div class="title" style="background-color: '. $colour . '">Reports</div>' : '<div class="title">Reports</div>';
                ?>
            </div>
        </div>

        <div class="bar" id="bottomBar">
			<?php
				echo isset($colour) ? '<div class="title" style="background-color: '. $colour . '">Tools</div>' : '<div class="title">Tools</div>';
			?>
            <div class="contentContainer" style="text-align: center; height: auto; padding-top:25px; padding-bottom:25px;">
				<button id="clearPosts" class="buttonstyle">Clear Posts</button>
				<button id="clearToasts" class="buttonstyle">Clear Toasts</button>
				<button id="clearBurns" class="buttonstyle">Clear Burns</button>
				<button id="clearFavourites" class="buttonstyle">Clear Favourites</button>
            </div>
        </div>
    </div>
</body>
</html>