summaryrefslogtreecommitdiff
path: root/includes/model/UserAngelTypes_model.php
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];
}
?>