blob: 4987eddde08ffe9c7ab7d2e397ce771be365e2cf (
plain)
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
|
<?php
/**
* Delete all unconfirmed UserAngelTypes for given Angeltype.
*
* @param int $angeltype_id
*/
function UserAngelTypes_delete_all($angeltype_id) {
return sql_query("
DELETE FROM `UserAngelTypes`
WHERE `angeltype_id`=" . sql_escape($angeltype_id) . "
AND `confirm_user_id` IS NULL");
}
/**
* Confirm all unconfirmed UserAngelTypes for given Angeltype.
*
* @param int $angeltype_id
* @param User $confirm_user
*/
function UserAngelTypes_confirm_all($angeltype_id, $confirm_user) {
return sql_query("
UPDATE `UserAngelTypes`
SET `confirm_user_id`=" . sql_escape($confirm_user['UID']) . "
WHERE `angeltype_id`=" . sql_escape($angeltype_id) . "
AND `confirm_user_id` IS NULL");
}
/**
* Confirm an UserAngelType with confirming user.
*
* @param int $user_angeltype_id
* @param User $confirm_user
*/
function UserAngelType_confirm($user_angeltype_id, $confirm_user) {
return sql_query("
UPDATE `UserAngelTypes`
SET `confirm_user_id`=" . sql_escape($confirm_user['UID']) . "
WHERE `id`=" . sql_escape($user_angeltype_id) . "
LIMIT 1");
}
/**
* Delete an UserAngelType.
*
* @param UserAngelType $user_angeltype
*/
function UserAngelType_delete($user_angeltype) {
return sql_query("
DELETE FROM `UserAngelTypes`
WHERE `id`=" . sql_escape($user_angeltype['id']) . "
LIMIT 1");
}
/**
* Create an UserAngelType.
*
* @param User $user
* @param Angeltype $angeltype
*/
function UserAngelType_create($user, $angeltype) {
$result = sql_query("
INSERT INTO `UserAngelTypes` SET
`user_id`=" . sql_escape($user['UID']) . ",
`angeltype_id`=" . sql_escape($angeltype['id']));
if ($result === false)
return false;
return sql_id();
}
/**
* Get an UserAngelType by its id.
*
* @param int $user_angeltype_id
*/
function UserAngelType($user_angeltype_id) {
$angeltype = sql_select("
SELECT *
FROM `UserAngelTypes`
WHERE `id`=" . sql_escape($user_angeltype_id) . "
LIMIT 1");
if ($angeltype === false)
return false;
if (count($angeltype) == 0)
return null;
return $angeltype[0];
}
/**
* Get an UserAngelType by user and angeltype.
*
* @param User $user
* @param Angeltype $angeltype
*/
function UserAngelType_by_User_and_AngelType($user, $angeltype) {
$angeltype = sql_select("
SELECT *
FROM `UserAngelTypes`
WHERE `user_id`=" . sql_escape($user['UID']) . "
AND `angeltype_id`=" . sql_escape($angeltype['id']) . "
LIMIT 1");
if ($angeltype === false)
return false;
if (count($angeltype) == 0)
return null;
return $angeltype[0];
}
?>
|
