blob: e931e04b27f3f1b2f6aa5084d1dc3e9a12d83d22 (
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
|
<?php
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");
}
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");
}
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");
}
function UserAngelType_delete($user_angeltype) {
return sql_query("
DELETE FROM `UserAngelTypes`
WHERE `id`=" . sql_escape($user_angeltype['id']) . "
LIMIT 1");
}
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();
}
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];
}
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];
}
?>
|