From 803c0a552f2bf3eaab1a88efa3785a985a258277 Mon Sep 17 00:00:00 2001 From: Philip Häusler Date: Wed, 12 Aug 2015 23:44:39 +0200 Subject: make multiple vouchers possible --- includes/model/User_model.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'includes/model/User_model.php') 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() { -- cgit v1.2.3-54-g00ecf