arfnet2-mlm/admin.php at master · ARF20NET/arfnet2-mlm · 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
<?php

session_start();

if(!isset($_SESSION["loggedin"]) || $_SESSION["loggedin"] !== true){
    header("location: /login.php");
    exit;
}

$username = $_SESSION["username"];
$type = $_SESSION["type"];

if ($type != "admin") die("Permission denied.");

require_once "config.php";

// Get lists
$sql = "SELECT id, name, type FROM lists";
$stmt = mysqli_prepare($link, $sql);
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);
$lists = $result->fetch_all(MYSQLI_ASSOC);

// Get subscribers
$sql = "SELECT id, email, list, unsubcode, subdate, status FROM subscribers";
$stmt = mysqli_prepare($link, $sql);
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);
$subscribers = $result->fetch_all(MYSQLI_ASSOC);

// Get archive
$sql = "SELECT id, list, subject, message, author, date FROM archive";
$stmt = mysqli_prepare($link, $sql);
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);
$archive = $result->fetch_all(MYSQLI_ASSOC);

// Get users
$sql = "SELECT id, username, type FROM users";
$stmt = mysqli_prepare($link, $sql);
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);
$users = $result->fetch_all(MYSQLI_ASSOC);

function getlistbyid($id) {
    global $lists;
    foreach ($lists as $list) {
        if ($list["id"] == $id) {
            return $list;
        }
    }
}

function getuserbyid($id) {
    global $users;
    foreach ($users as $user) {
        if ($user["id"] == $id) {
            return $user;
        }
    }
}

?>

<!doctype html>
<html>
    <head>
        <meta charset="UTF-8">
        <link rel="stylesheet" type="text/css" href="/style.css">
        <title>ARFNET MLM</title>
    </head>
    <body>
        <header><a href="https://arf20.com/">
            <img src="arfnet_logo.png" width="64"><span class="title"><strong>ARFNET</strong></span>
        </a></header>
        <hr>
        <main>
            <div class="row">
                <div class="col8">
                    <h2 class="center">ARFNET Mailing List Manager</h2>
                    <h3><?php echo strtoupper($type[0]).substr($type, 1); ?> panel</h3>
                    <div class="row">
                        <div class="col3">
                            <h3>Lists</h3>
                            <table>
                                <tr><th>name</th><th>type</th></tr>
                                <?php
                                foreach ($lists as $list) {
                                    echo "<tr><td>".$list["name"]."</td><td>".$list["type"]."</td></tr>\n";
                                }
                                ?>
                            </table>
                        </div>
                        <div class="col3">
                            <h3>Subscribers</h3>
                            <table>
                                <tr><th>email</th><th>list</th><th>status</th></tr>
                                <?php
                                foreach ($subscribers as $sub) {
                                    echo "<tr><td>".$sub["email"]."</td><td>".getlistbyid($sub["list"])["name"]."</td><td>".$sub["status"]."</tr>\n";
                                }
                                ?>
                            </table>
                        </div>
                        <div class="col3">
                            <h3>Archive</h3>
                            <table>
                                <tr><th>list</th><th>subject</th><th>message</th><th>author</th></tr>
                                <?php
                                foreach ($archive as $msg) {
                                    echo "<tr><td>".getlistbyid($msg["list"])["name"]."</td><td>".$msg["subject"]."</td><td><details><summary></summary><pre>".$msg["message"]."</pre></details></td><td>".getuserbyid($msg["author"])["username"]."</tr>\n";
                                }
                                ?>
                            </table>
                        </div>
                    </div>
                </div>
                <div class="col2">
                    <h3>Logged as <?php echo $username; ?></h3>
                    <h3><a href="/logout.php">Logout</h2>
                    <h3><a href="/managelists.php">Manage lists</h2>
                    <h3><a href="/managesubs.php">Manage subscribers</h2>
                    <h3><a href="/managearchive.php">Manage archive</h2>
                    <h3><a href="/post.php">Post</h2>
                </div>
            </div>
        </main>
    </body>
</html>