forked from TDR-1000/KeyAuth-Source-Code
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathvariable.php
More file actions
73 lines (67 loc) · 2.21 KB
/
variable.php
File metadata and controls
73 lines (67 loc) · 2.21 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
<?php
namespace misc\variable;
use misc\etc;
use misc\cache;
use misc\mysql;
function add($name, $data, $authed, $secret = null)
{
$name = etc\sanitize($name);
$data = etc\sanitize($data);
$authed = etc\sanitize($authed);
$name_check = mysql\query("SELECT 1 FROM `vars` WHERE `varid` = ? AND `app` = ?",[$name, $secret ?? $_SESSION['app']]);
if ($name_check->num_rows > 0) {
return 'exists';
}
$query = mysql\query("INSERT INTO `vars`(`varid`, `msg`, `app`, `authed`) VALUES (?, ?, ?, ?)",[$name, $data,$secret ?? $_SESSION['app'], $authed]);
if ($query->affected_rows > 0) {
if ($_SESSION['role'] == "seller" || !is_null($secret)) {
cache\purge('KeyAuthVars:' . ($secret ?? $_SESSION['app']));
}
return 'success';
} else {
return 'failure';
}
}
function deleteAll($secret = null)
{
$query = mysql\query("DELETE FROM `vars` WHERE `app` = ?",[$secret ?? $_SESSION['app']]);
if ($query->affected_rows > 0) {
cache\purgePattern('KeyAuthVar:' . ($secret ?? $_SESSION['app']));
if ($_SESSION['role'] == "seller" || !is_null($secret)) {
cache\purge('KeyAuthVars:' . ($secret ?? $_SESSION['app']));
}
return 'success';
} else {
return 'failure';
}
}
function deleteSingular($var, $secret = null)
{
$var = etc\sanitize($var);
$query = mysql\query("DELETE FROM `vars` WHERE `app` = ? AND `varid` = ?",[$secret ?? $_SESSION['app'], $var]);
if ($query->affected_rows > 0) {
cache\purge('KeyAuthVar:' . ($secret ?? $_SESSION['app']) . ':' . $var);
if ($_SESSION['role'] == "seller" || !is_null($secret)) {
cache\purge('KeyAuthVars:' . ($secret ?? $_SESSION['app']));
}
return 'success';
} else {
return 'failure';
}
}
function edit($name, $data, $authed, $secret = null)
{
$name = etc\sanitize($name);
$data = etc\sanitize($data);
$authed = etc\sanitize($authed);
$query = mysql\query("UPDATE `vars` SET `msg` = ?, `authed` = ? WHERE `varid` = ? AND `app` = ?",[$data, $authed, $name, $secret ?? $_SESSION['app']]);
if ($query->affected_rows > 0) {
cache\purge('KeyAuthVar:' . ($secret ?? $_SESSION['app']) . ':' . $name);
if ($_SESSION['role'] == "seller" || !is_null($secret)) {
cache\purge('KeyAuthVars:' . ($secret ?? $_SESSION['app']));
}
return 'success';
} else {
return 'failure';
}
}