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" ]; ?>