2 AND HOUR(FROM_UNIXTIME(`Shifts`.`end`)) < 6) OR (HOUR(FROM_UNIXTIME(`Shifts`.`start`)) > 2 AND HOUR(FROM_UNIXTIME(`Shifts`.`start`)) < 6) OR (HOUR(FROM_UNIXTIME(`Shifts`.`start`)) <= 2 AND HOUR(FROM_UNIXTIME(`Shifts`.`end`)) >= 6) ))*(`Shifts`.`end` - `Shifts`.`start`)*(1 - 3 * `ShiftEntry`.`freeloaded`) )'; // voucher calculation $voucher_settings = [ 'initial_vouchers' => 2, 'shifts_per_voucher' => 1 ]; // weigh every shift the same // $shift_sum_formula = 'SUM(`end` - `start`)'; // For accessing stats $api_key = ''; // MySQL-Connection Settings $config = [ 'host' => 'localhost', 'user' => 'root', 'pw' => '', 'db' => 'engelsystem' ];