- $record_type_v = '';
- }
-
- $sql = "insert into tt_teams (name, address, currency $lockspec_f $locktime_f, lang $decimal_mark_f $date_format_f $time_format_f $week_start_f $plugins_f $tracking_mode_f $record_type_f)
- values(".
- $mdb2->quote(trim($fields['name'])).
- ", ".$mdb2->quote(trim($fields['address'])).
- ", ".$mdb2->quote(trim($fields['currency']))." $lockspec_v $locktime_v, ".$mdb2->quote($lang).
- "$decimal_mark_v $date_format_v $time_format_v $week_start_v $plugins_v $tracking_mode_v $record_type_v)";
+ $record_type_v = '';
+ }
+
+ $uncompleted_indicators = $fields['uncompleted_indicators'];
+ if ($uncompleted_indicators !== null) {
+ $uncompleted_indicators_f = ', uncompleted_indicators';
+ $uncompleted_indicators_v = ', ' . (int)$uncompleted_indicators;
+ } else {
+ $uncompleted_indicators_f = '';
+ $uncompleted_indicators_v = '';
+ }
+
+ $bcc_email = $fields['bcc_email'];
+ if ($bcc_email !== null) {
+ $bcc_email_f = ', bcc_email';
+ $bcc_email_v = ', ' . $mdb2->quote($bcc_email);
+ } else {
+ $bcc_email_f = '';
+ $bcc_email_v = '';
+ }
+
+ $plugins = $fields['plugins'];
+ if ($plugins !== null) {
+ $plugins_f = ', plugins';
+ $plugins_v = ', ' . $mdb2->quote($plugins);
+ } else {
+ $plugins_f = '';
+ $plugins_v = '';
+ }
+
+ $lock_spec = $fields['lock_spec'];
+ if ($lock_spec !== null) {
+ $lockspec_f = ', lock_spec';
+ $lockspec_v = ', ' . $mdb2->quote($lock_spec);
+ } else {
+ $lockspec_f = '';
+ $lockspec_v = '';
+ }
+
+ $workday_hours = $fields['workday_hours'];
+ if ($workday_hours !== null) {
+ $workday_hours_f = ', workday_hours';
+ $workday_hours_v = ', ' . (int)$workday_hours;
+ } else {
+ $workday_hours_f = '';
+ $workday_hours_v = '';
+ }
+
+ $sql = "insert into tt_teams (name, currency $decimal_mark_f, lang $date_format_f $time_format_f $week_start_f $tracking_mode_f $project_required_f $task_required_f $record_type_f $uncompleted_indicators_f $bcc_email_f $plugins_f $lockspec_f $workday_hours_f)
+ values(".$mdb2->quote(trim($fields['name'])).
+ ", ".$mdb2->quote(trim($fields['currency']))." $decimal_mark_v, ".$mdb2->quote($lang).
+ "$date_format_v $time_format_v $week_start_v $tracking_mode_v $project_required_v $task_required_v $record_type_v $uncompleted_indicators_v $bcc_email_v $plugins_v $lockspec_v $workday_hours_v)";