forked from TDR-1000/KeyAuth-Source-Code
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathchat.php
More file actions
103 lines (89 loc) · 3.05 KB
/
Copy pathchat.php
File metadata and controls
103 lines (89 loc) · 3.05 KB
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
<?php
namespace misc\chat;
use misc\etc;
use misc\cache;
use misc\mysql;
function deleteMessage($id, $secret = null)
{
$id = etc\sanitize($id);
$query = mysql\query("SELECT `channel` FROM `chatmsgs` WHERE `app` = ? AND `id` = ?",[$secret ?? $_SESSION['app'], $id]);
$row = mysqli_fetch_array($query->result);
cache\purge('KeyAuthChatMsgs:' . ($secret ?? $_SESSION['app']) . ':' . $row['channel']);
$query = mysql\query("DELETE FROM `chatmsgs` WHERE `app` = ? AND `id` = ?",[$secret ?? $_SESSION['app'], $id]);
if ($query->affected_rows > 0) {
return 'success';
} else {
return 'failure';
}
}
function muteUser($user, $time, $secret = null)
{
$user = etc\sanitize($user);
$time = etc\sanitize($time);
$query = mysql\query("SELECT 1 FROM `users` WHERE `app` = ? AND `username` = ?",[$secret ?? $_SESSION['app'], $user]);
if ($query->num_rows == 0) {
return 'missing';
}
$query = mysql\query("INSERT INTO `chatmutes` (`user`, `time`, `app`) VALUES (?, ?, ?)",[$user, $time, $secret ?? $_SESSION['app']]);
if ($query->affected_rows > 0) {
if ($_SESSION['role'] == "seller" || !is_null($secret)) {
cache\purge('KeyAuthMutes:' . ($secret ?? $_SESSION['app']));
}
return 'success';
} else {
return 'failure';
}
}
function unMuteUser($user, $secret = null)
{
$user = etc\sanitize($user);
$query = mysql\query("DELETE FROM `chatmutes` WHERE `app` = ? AND `user` = ?",[$secret ?? $_SESSION['app'], $user]);
if ($query->affected_rows > 0) {
if ($_SESSION['role'] == "seller" || !is_null($secret)) {
cache\purge('KeyAuthMutes:' . ($secret ?? $_SESSION['app']));
}
return 'success';
} else {
return 'failure';
}
}
function clearChannel($channel, $secret = null)
{
$channel = etc\sanitize($channel);
$query = mysql\query("DELETE FROM `chatmsgs` WHERE `app` = ? AND `channel` = ?",[$secret ?? $_SESSION['app'], $channel]);
if ($query->affected_rows > 0) {
cache\purge('KeyAuthChatMsgs:' . ($secret ?? $_SESSION['app']) . ':' . $channel);
return 'success';
} else {
return 'failure';
}
}
function createChannel($name, $delay, $secret = null)
{
$name = etc\sanitize($name);
$delay = etc\sanitize($delay);
$query = mysql\query("INSERT INTO `chats` (`name`, `delay`, `app`) VALUES (?, ?, ?)",[$name, $delay, $secret ?? $_SESSION['app']]);
if ($query->affected_rows > 0) {
if ($_SESSION['role'] == "seller" || !is_null($secret)) {
cache\purge('KeyAuthChats:' . ($secret ?? $_SESSION['app']));
}
return 'success';
} else {
return 'failure';
}
}
function deleteChannel($name, $secret = null)
{
$name = etc\sanitize($name);
$query = mysql\query("DELETE FROM `chats` WHERE `app` = ? AND `name` = ?",[$secret ?? $_SESSION['app'], $name]);
if ($query->affected_rows > 0) {
$query = mysql\query("DELETE FROM `chatmsgs` WHERE `app` = ? AND `channel` = ?",[$secret ?? $_SESSION['app'], $name]);
cache\purge('KeyAuthChatMsgs:' . ($secret ?? $_SESSION['app']) . ':' . $name);
if ($_SESSION['role'] == "seller" || !is_null($secret)) {
cache\purge('KeyAuthChats:' . ($secret ?? $_SESSION['app']));
}
return 'success';
} else {
return 'failure';
}
}