mirror of
https://github.com/holo-gfx/mangadex.git
synced 2024-11-24 22:38:20 -05:00
229 lines
9.5 KiB
PHP
229 lines
9.5 KiB
PHP
<?php
|
|
|
|
if (!validate_level($user, 'admin')) die('No access');
|
|
|
|
$mode = $_GET['mode'] ?? 'stats';
|
|
$type = ($mode == 'visit_logs' && !isset($_GET['type'])) ? 'summary' : ($_GET['type'] ?? '');
|
|
|
|
$templateVars = [
|
|
'mode' => $mode,
|
|
'type' => $type
|
|
];
|
|
|
|
$page_html = parse_template('admin/partials/admin_navtabs', $templateVars);
|
|
|
|
switch ($mode) {
|
|
|
|
case 'action_logs':
|
|
|
|
$templateVars['logs'] = new Action_logs();
|
|
$page_html .= parse_template('admin/action_logs', $templateVars);
|
|
|
|
break;
|
|
|
|
case 'cache_stats':
|
|
|
|
$cacheFlushed = false;
|
|
if (isset($_POST['flush_cache']) && $_POST['flush_cache']) {
|
|
$memcached->flush();
|
|
$cacheFlushed = true;
|
|
}
|
|
|
|
$templateVars['stats'] = $memcached->getStats();
|
|
$templateVars['cache_flushed'] = $cacheFlushed;
|
|
$page_html .= parse_template('admin/cache_stats', $templateVars);
|
|
|
|
break;
|
|
|
|
case 'report_reasons':
|
|
|
|
$message = '';
|
|
if (!empty($_POST)) {
|
|
// HTML array forms order is fucked up beyond belief, so we have to reorder the array
|
|
|
|
$keep_reason_ids = [];
|
|
$update_reasons = [];
|
|
$add_reasons = [];
|
|
$order = 0;
|
|
foreach ($_POST['type_id'] ?? [] AS $type_id => $reason_ids) {
|
|
// if reason id is set, we keep this and only maybe update it. if reason_id is empty, its a new element
|
|
foreach ($reason_ids AS $position => $reason_id) {
|
|
if ($reason_id) {
|
|
// Save the id so we can remove all reasons which ids we dont have, since we assume those have
|
|
// been removed from the form before submitting
|
|
$keep_reason_ids[] = (int)$reason_id;
|
|
// We have to assume the html form was submitted properly and hasnt been tampered with, then we
|
|
// can also assume that the other field arrays have the same structure and just grab the variables
|
|
// from there.
|
|
$update_reasons[$reason_id] = [
|
|
'id' => (int)$reason_id,
|
|
'type_id' => (int)$type_id,
|
|
'text' => $_POST['text'][$type_id][$position],
|
|
'is_info_required' => (int)(isset($_POST['is_info_required'][$type_id][$position]) && $_POST['is_info_required'][$type_id][$position]), // Checkbox set to "On"
|
|
'sortorder' => $order++,
|
|
];
|
|
} else {
|
|
$add_reasons[] = [
|
|
'type_id' => (int)$type_id,
|
|
'text' => $_POST['text'][$type_id][$position],
|
|
'is_info_required' => (int)(isset($_POST['is_info_required'][$type_id][$position]) && $_POST['is_info_required'][$type_id][$position]), // Checkbox set to "On"
|
|
'sortorder' => $order++,
|
|
];
|
|
}
|
|
}
|
|
}
|
|
|
|
//dump($_POST, $add_reasons, $update_reasons, $keep_reason_ids);die();
|
|
|
|
// Write changes
|
|
try {
|
|
if (empty($keep_reason_ids)) {
|
|
$sql->modify('keep_remove_reasons', 'DELETE FROM mangadex_report_reason', []); // Note that we can skip the pdobind because keep_reason_ids are guaranteed ints
|
|
} else {
|
|
$sql->modify('keep_remove_reasons', 'DELETE FROM mangadex_report_reason WHERE id NOT IN (' .implode(',',$keep_reason_ids).")", []); // Note that we can skip the pdobind because keep_reason_ids are guaranteed ints
|
|
}
|
|
foreach ($update_reasons AS $reason_id => $reason) {
|
|
$sql->modify('update_reasons', 'UPDATE mangadex_report_reason SET `text` = ?, `type_id` = ?, `is_info_required` = ?, `sortorder` = ? WHERE `id` = ?', [
|
|
$reason['text'], $reason['type_id'], $reason['is_info_required'], $reason['sortorder'], $reason_id
|
|
]);
|
|
}
|
|
foreach ($add_reasons AS $reason) {
|
|
$sql->modify('add_reasons', 'INSERT INTO mangadex_report_reason (`text`, `type_id`, `is_info_required`, `sortorder`) VALUES (?,?,?,?)', [
|
|
$reason['text'], $reason['type_id'], $reason['is_info_required'], $reason['sortorder']
|
|
]);
|
|
}
|
|
|
|
$memcached->delete('report_reasons');
|
|
$message = 'Changes applied successfully!';
|
|
|
|
$report_reasons = (new Report_Reasons())->toArray();
|
|
} catch (\Exception $e) {
|
|
$message = ['class' => 'danger', 'text' => $e->getMessage()];
|
|
}
|
|
}
|
|
|
|
if (!isset($report_reasons))
|
|
$report_reasons = (new Report_Reasons())->toArray();
|
|
|
|
$templateVars['report_reasons'] = $report_reasons;
|
|
$templateVars['message'] = $message;
|
|
$page_html .= parse_template('admin/report_reasons', $templateVars);
|
|
|
|
break;
|
|
|
|
case 'ip_unban':
|
|
|
|
if ($type == 'ip_unban') {
|
|
|
|
$page_html .= parse_template('admin/ip_unban', $templateVars);
|
|
|
|
} else if ($type == 'ip_ban') {
|
|
|
|
$templateVars['banlist'] = $sql->prep('ip_banlist', "SELECT * FROM mangadex_ip_bans ORDER BY expires DESC", [], 'fetchAll', PDO::FETCH_ASSOC, 3600);
|
|
$page_html .= parse_template('admin/ip_ban', $templateVars);
|
|
|
|
} else if ($type == 'ip_failtwoban') {
|
|
|
|
$query_ip = trim($_GET['query_ip'] ?? '');
|
|
if (!empty($query_ip)) {
|
|
$templateVars['data'] = $sql->prep('ip_f2b', 'SELECT * FROM mangadex_fail2ban_log WHERE ip = ? LIMIT 100', [$query_ip], 'fetchAll', PDO::FETCH_ASSOC, -1);
|
|
}
|
|
$page_html .= parse_template('admin/ip_fail2ban', $templateVars);
|
|
|
|
}
|
|
break;
|
|
|
|
case 'ip_tracking':
|
|
|
|
$creation_ip = trim($_GET['creation_ip'] ?? '');
|
|
$last_ip = trim($_GET['last_ip'] ?? '');
|
|
$email_host = trim($_GET['email_host'] ?? '');
|
|
|
|
if ($email_host) {
|
|
$templateVars['data'] = $sql->prep('ip_tracking', "SELECT users.user_id, users.username, users.email, users.joined_timestamp, users.last_seen_timestamp, users.creation_ip, users.last_ip, levels.level_id, levels.level_name, levels.level_colour, (SELECT COUNT(*) FROM mangadex_forum_posts posts WHERE posts.user_id = users.user_id) AS post_count
|
|
FROM mangadex_users users
|
|
LEFT JOIN mangadex_user_levels levels ON users.level_id = levels.level_id
|
|
WHERE creation_ip IN (?,?) OR last_ip IN (?,?) OR email LIKE ? ORDER BY users.last_seen_timestamp DESC", [$creation_ip, $last_ip, $creation_ip, $last_ip, "%$email_host"], 'fetchAll', PDO::FETCH_ASSOC, -1);
|
|
}
|
|
else {
|
|
$templateVars['data'] = $sql->prep('ip_tracking', "SELECT users.user_id, users.username, users.email, users.joined_timestamp, users.last_seen_timestamp, users.creation_ip, users.last_ip, levels.level_id, levels.level_name, levels.level_colour, (SELECT COUNT(*) FROM mangadex_forum_posts posts WHERE posts.user_id = users.user_id) AS post_count
|
|
FROM mangadex_users users
|
|
LEFT JOIN mangadex_user_levels levels ON users.level_id = levels.level_id
|
|
WHERE creation_ip IN (?,?) OR last_ip IN (?,?) ORDER BY users.last_seen_timestamp DESC", [$creation_ip, $last_ip, $creation_ip, $last_ip], 'fetchAll', PDO::FETCH_ASSOC, -1);
|
|
}
|
|
|
|
$page_html .= parse_template('admin/ip_tracking', $templateVars);
|
|
|
|
break;
|
|
|
|
case 'tempmail':
|
|
$templateVars['tempmail'] = $sql->query_read('tempmail', "SELECT host FROM mangadex_tempmail ORDER BY host ASC ", 'fetchAll', PDO::FETCH_COLUMN);
|
|
|
|
$page_html .= parse_template('admin/tempmail', $templateVars);
|
|
|
|
break;
|
|
|
|
case 'visit_logs':
|
|
|
|
if ($type === 'summary') {
|
|
|
|
$templateVars['results'] = $sql->query_read('visit_summary', ' SELECT * FROM mangadex_logs_visits_summary ORDER BY id DESC ', 'fetchAll', PDO::FETCH_UNIQUE, -1);
|
|
$page_html .= parse_template('admin/visit_logs_summary', $templateVars);
|
|
|
|
} else {
|
|
|
|
$templateVars['visit_logs'] = new Visit_logs();
|
|
$page_html .= parse_template('admin/visit_logs', $templateVars);
|
|
|
|
}
|
|
|
|
break;
|
|
|
|
case 'database':
|
|
|
|
$stats = [];
|
|
$errors = [];
|
|
foreach (\array_unique(DB_READ_HOSTS ?? []) AS $dsn) {
|
|
if (\strpos($dsn, ':') !== false) {
|
|
[$host, $port] = explode(':', $dsn);
|
|
} else {
|
|
$host = $dsn;
|
|
$port = 3306;
|
|
}
|
|
|
|
$res = [];
|
|
try {
|
|
$conn = new PDO("mysql:host=$host;port=$port;dbname=".DB_READ_NAME.";charset=utf8mb4", DB_READ_USER, DB_READ_PASSWORD,
|
|
[
|
|
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
|
|
]
|
|
);
|
|
$q = $conn->query('SHOW SLAVE STATUS');
|
|
$res = $q->fetchAll(PDO::FETCH_ASSOC);
|
|
} catch (PDOException $e) {
|
|
$stats[$dsn] = null;
|
|
$errors[$dsn] = $e->getMessage();
|
|
continue;
|
|
}
|
|
$stats[$dsn] = $res;
|
|
}
|
|
|
|
$templateVars['stats'] = $stats;
|
|
$templateVars['errors'] = $errors;
|
|
|
|
$page_html .= parse_template('admin/database', $templateVars);
|
|
|
|
break;
|
|
|
|
case 'stats':
|
|
default:
|
|
|
|
$templateVars['stats'] = $sql->query_read('registration_stats', "SELECT * FROM mangadex_stats_registrations ", 'fetchAll', PDO::FETCH_ASSOC, -1);
|
|
$templateVars['memcached'] = $memcached;
|
|
|
|
$page_html .= parse_template('admin/stats', $templateVars);
|
|
|
|
break;
|
|
|
|
}
|