diff options
author | Philip Häusler <msquare@notrademark.de> | 2015-08-12 23:44:39 +0200 |
---|---|---|
committer | Philip Häusler <msquare@notrademark.de> | 2015-08-12 23:44:39 +0200 |
commit | 803c0a552f2bf3eaab1a88efa3785a985a258277 (patch) | |
tree | 6d759a47170cf2e0fe51f9de5b35d2ce85845b3c /includes/model | |
parent | 681d52fe0f8a124904f97e7966ed2ee1b73124d2 (diff) |
make multiple vouchers possible
Diffstat (limited to 'includes/model')
-rw-r--r-- | includes/model/User_model.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/includes/model/User_model.php b/includes/model/User_model.php index f1c3d34b..bd3ec31f 100644 --- a/includes/model/User_model.php +++ b/includes/model/User_model.php @@ -29,7 +29,7 @@ function User_update($user) { `color`='" . sql_escape($user['color']) . "', `Sprache`='" . sql_escape($user['Sprache']) . "', `Hometown`='" . sql_escape($user['Hometown']) . "', - `got_voucher`=" . sql_bool($user['got_voucher']) . ", + `got_voucher`='" . sql_escape($user['got_voucher']) . "', `arrival_date`='" . sql_escape($user['arrival_date']) . "', `planned_arrival_date`='" . sql_escape($user['planned_arrival_date']) . "' WHERE `UID`='" . sql_escape($user['UID']) . "'"); @@ -47,7 +47,7 @@ function User_active_count() { } function User_got_voucher_count() { - return sql_select_single_cell("SELECT COUNT(*) FROM `User` WHERE `got_voucher` = TRUE"); + return sql_select_single_cell("SELECT SUM(`got_voucher`) FROM `User`"); } function User_arrived_count() { |