
<stat>DROP TABLE IF EXISTS HFCS00_Base; 
<stat>DROP TABLE IF EXISTS HFCS00_Base_language; 
<stat>DROP TABLE IF EXISTS HFCS00_Base_script; 
<stat>DROP TABLE IF EXISTS HFCS00_Base_tree; 
<stat>CREATE TABLE `HFCS00_Base` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `q_pos` int(5) NOT NULL,
  `q_name` char(20) COLLATE utf8_unicode_ci NOT NULL,
  `tip_sql` int(2) DEFAULT NULL,
  `drg_sql` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  `les_sql` int(2) DEFAULT NULL,
  `goto_sql` text COLLATE utf8_unicode_ci NOT NULL,
  `fil_sql` text COLLATE utf8_unicode_ci NOT NULL,
  `con_sql` text COLLATE utf8_unicode_ci NOT NULL,
  `open_sql` int(2) DEFAULT NULL,
  `anno_sql` int(2) DEFAULT NULL,
  `attachAnswers` int(11) DEFAULT NULL,
  `attachFalse` tinyint(1) DEFAULT NULL,
  `rot_sql` text COLLATE utf8_unicode_ci,
  `srot_sql` int(1) DEFAULT NULL,
  `erot_sql` int(1) DEFAULT NULL,
  `srotLegend` int(1) DEFAULT NULL,
  `erotLegend` int(1) DEFAULT NULL,
  `srotAttributes` int(1) DEFAULT NULL,
  `erotAttributes` int(1) DEFAULT NULL,
  `qrot_sql` char(9) COLLATE utf8_unicode_ci DEFAULT NULL,
  `id_style` int(8) DEFAULT NULL,
  `id_mask` int(8) DEFAULT NULL,
  `must_answer` tinyint(1) NOT NULL DEFAULT '1',
  `disable_question` tinyint(1) NOT NULL DEFAULT '0',
  `answers_filter` tinyint(1) NOT NULL DEFAULT '0',
  `variableTypeBase` tinyint(1) NOT NULL DEFAULT '4',
  `variableTypeOpen` tinyint(1) NOT NULL DEFAULT '0',
  `open_answers` char(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `open_legend` char(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `open_attributes` char(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `multi_nogo_answers` char(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `multi_nogo_legends` char(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `multilanguage_all` text COLLATE utf8_unicode_ci,
  `qleave_js_alert` tinyint(1) NOT NULL DEFAULT '0',
  `filter_answer` text COLLATE utf8_unicode_ci,
  `filter_legend` text COLLATE utf8_unicode_ci,
  `filter_attributes` text COLLATE utf8_unicode_ci,
  `hasStructure` tinyint(4) DEFAULT '0',
  `use_for_quotas` tinyint(1) DEFAULT '0',
  `isFinal` tinyint(1) DEFAULT '0',
  `id_showTogether` int(11) NOT NULL DEFAULT '0',
  `answerGroups` text COLLATE utf8_unicode_ci,
  `legendGroups` text COLLATE utf8_unicode_ci,
  `id_plugin` int(11) DEFAULT NULL,
  `id_incentive` int(11) DEFAULT NULL,
  `incentive_possibilites` tinyint(1) NOT NULL DEFAULT '0',
  `allow_listening` tinyint(1) NOT NULL DEFAULT '0',
  `old_id` int(11) NOT NULL,
  `up_down_rotchk` int(11) NOT NULL,
  `up_down_rotvar` int(11) NOT NULL,
  `repeat_legend` int(11) NOT NULL,
  `autoSubmit` tinyint(1) NOT NULL DEFAULT '0',
  `autoSubmitTimeout` int(11) NOT NULL DEFAULT '100',
  `missing_values` char(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `open_end_type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1 text box 2 text area',
  `enter_submit` tinyint(1) NOT NULL DEFAULT '1',
  `slider_color` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `trace_color` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `slider_shape` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `slider_handle_image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email_app_group` int(11) DEFAULT NULL,
  `email_app_template` int(11) DEFAULT NULL,
  `encrypt` tinyint(1) DEFAULT NULL,
  `multi_type` tinyint(4) DEFAULT '1' COMMENT '1 column multi response 2 line multi response 3 line and column',
  `rotate_legend` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '0 do not rotate legend text 1 rotate legend on desktop 2 rotate legend on mobile 3 rotate legend on both',
  `anonymize` tinyint(4) NOT NULL DEFAULT '0',
  `input_types` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `input_types_properties` text COLLATE utf8_unicode_ci,
  `custom_controls` text COLLATE utf8_unicode_ci,
  `rec_question_id` int(11) DEFAULT '0',
  `rec_interval` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'start_q:end_q',
  `show_as_single` tinyint(4) NOT NULL DEFAULT '0',
  `show_as_single_cond` text COLLATE utf8_unicode_ci,
  `show_as_single_design` int(11) DEFAULT NULL,
  `show_as_single_autosubmit` tinyint(1) DEFAULT '0',
  `show_as_single_autosubmit_delay` int(11) DEFAULT '200',
  `input_position` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1 next to label 2 under label',
  `after_text` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `answer_click_animation` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `answer_click_element` int(11) DEFAULT NULL COMMENT '1 - control 2 - label 3 both',
  `answer_click_animation_duration` int(11) NOT NULL DEFAULT '1000',
  PRIMARY KEY (`id`),
  UNIQUE KEY `q_name` (`q_name`),
  KEY `q_pos` (`q_pos`),
  KEY `tip_sql` (`tip_sql`),
  KEY `show_as_single_design` (`show_as_single_design`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 
<stat>CREATE TABLE `HFCS00_Base_language` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_language` int(11) NOT NULL,
  `id_question` int(11) NOT NULL,
  `id_text_type` int(11) NOT NULL,
  `lngText` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `qlt_index` (`id_language`,`id_question`,`id_text_type`),
  KEY `id_question` (`id_question`)
) ENGINE=MyISAM AUTO_INCREMENT=40 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 
<stat>CREATE TABLE `HFCS00_Base_script` (
  `id_question` int(11) NOT NULL,
  `id_event` int(11) NOT NULL,
  `script` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id_question`,`id_event`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 
<stat>CREATE TABLE `HFCS00_Base_tree` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `id_sup` int(5) NOT NULL,
  `id_question` int(5) NOT NULL,
  `orderBy` smallint(6) NOT NULL,
  `idLab` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `node_img` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `is_leaf` tinyint(1) NOT NULL,
  `showTogether` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `id_sup` (`id_sup`),
  KEY `id_question` (`id_question`),
  KEY `orderBy` (`orderBy`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
<stat>INSERT INTO HFCS00_Base SET id = '1',q_pos = '-6',q_name = '_Start',tip_sql = '5',drg_sql = '',les_sql = '0',goto_sql = 'true#1',fil_sql = '',con_sql = '',open_sql = '0',anno_sql = '0',attachAnswers = '0',attachFalse = '0',rot_sql = '',srot_sql = '0',erot_sql = '0',srotLegend = '0',erotLegend = '0',srotAttributes = '0',erotAttributes = '0',qrot_sql = '',id_style = '0',id_mask = '0',must_answer = '1',disable_question = '0',answers_filter = '0',variableTypeBase = '4',variableTypeOpen = '0',open_answers = '',open_legend = '',open_attributes = '',multi_nogo_answers = '',multi_nogo_legends = '',multilanguage_all = '',qleave_js_alert = '0',filter_answer = '',filter_legend = '',filter_attributes = '',hasStructure = '1',use_for_quotas = '0',isFinal = '0',id_showTogether = '0',answerGroups = '',legendGroups = '',id_plugin = '0',id_incentive = '0',incentive_possibilites = '0',allow_listening = '0',old_id = '0',up_down_rotchk = '0',up_down_rotvar = '0',repeat_legend = '0',autoSubmit = '0',autoSubmitTimeout = '100',missing_values = '',open_end_type = '1',enter_submit = '1',slider_color = '',trace_color = '',slider_shape = '',slider_handle_image = '',email_app_group = '',email_app_template = '',encrypt = '',multi_type = '1',rotate_legend = '0',anonymize = '0',input_types = '',input_types_properties = '',custom_controls = '',rec_question_id = '0',rec_interval = '',show_as_single = '0',show_as_single_cond = '',show_as_single_design = '',show_as_single_autosubmit = '0',show_as_single_autosubmit_delay = '200',input_position = '1',after_text = '',answer_click_animation = '0',answer_click_element = '',answer_click_animation_duration = '1000';
<stat>INSERT INTO HFCS00_Base SET id = '2',q_pos = '-5',q_name = '_End',tip_sql = '5',drg_sql = '',les_sql = '0',goto_sql = '',fil_sql = '',con_sql = '',open_sql = '0',anno_sql = '0',attachAnswers = '0',attachFalse = '0',rot_sql = '',srot_sql = '0',erot_sql = '0',srotLegend = '0',erotLegend = '0',srotAttributes = '0',erotAttributes = '0',qrot_sql = '',id_style = '0',id_mask = '0',must_answer = '1',disable_question = '0',answers_filter = '0',variableTypeBase = '4',variableTypeOpen = '0',open_answers = '',open_legend = '',open_attributes = '',multi_nogo_answers = '',multi_nogo_legends = '',multilanguage_all = '',qleave_js_alert = '0',filter_answer = '',filter_legend = '',filter_attributes = '',hasStructure = '1',use_for_quotas = '0',isFinal = '0',id_showTogether = '0',answerGroups = '',legendGroups = '',id_plugin = '0',id_incentive = '0',incentive_possibilites = '0',allow_listening = '0',old_id = '0',up_down_rotchk = '0',up_down_rotvar = '0',repeat_legend = '0',autoSubmit = '0',autoSubmitTimeout = '100',missing_values = '',open_end_type = '1',enter_submit = '1',slider_color = '',trace_color = '',slider_shape = '',slider_handle_image = '',email_app_group = '',email_app_template = '',encrypt = '',multi_type = '1',rotate_legend = '0',anonymize = '0',input_types = '',input_types_properties = '',custom_controls = '',rec_question_id = '0',rec_interval = '',show_as_single = '0',show_as_single_cond = '',show_as_single_design = '',show_as_single_autosubmit = '0',show_as_single_autosubmit_delay = '200',input_position = '1',after_text = '',answer_click_animation = '0',answer_click_element = '',answer_click_animation_duration = '1000';
<stat>INSERT INTO HFCS00_Base SET id = '3',q_pos = '-15',q_name = '_notAllow',tip_sql = '5',drg_sql = '',les_sql = '0',goto_sql = '',fil_sql = '',con_sql = '',open_sql = '0',anno_sql = '0',attachAnswers = '0',attachFalse = '0',rot_sql = '',srot_sql = '0',erot_sql = '0',srotLegend = '0',erotLegend = '0',srotAttributes = '0',erotAttributes = '0',qrot_sql = '',id_style = '0',id_mask = '0',must_answer = '1',disable_question = '0',answers_filter = '0',variableTypeBase = '4',variableTypeOpen = '0',open_answers = '',open_legend = '',open_attributes = '',multi_nogo_answers = '',multi_nogo_legends = '',multilanguage_all = '',qleave_js_alert = '0',filter_answer = '',filter_legend = '',filter_attributes = '',hasStructure = '1',use_for_quotas = '0',isFinal = '0',id_showTogether = '0',answerGroups = '',legendGroups = '',id_plugin = '0',id_incentive = '0',incentive_possibilites = '0',allow_listening = '0',old_id = '0',up_down_rotchk = '0',up_down_rotvar = '0',repeat_legend = '0',autoSubmit = '0',autoSubmitTimeout = '100',missing_values = '',open_end_type = '1',enter_submit = '1',slider_color = '',trace_color = '',slider_shape = '',slider_handle_image = '',email_app_group = '',email_app_template = '',encrypt = '',multi_type = '1',rotate_legend = '0',anonymize = '0',input_types = '',input_types_properties = '',custom_controls = '',rec_question_id = '0',rec_interval = '',show_as_single = '0',show_as_single_cond = '',show_as_single_design = '',show_as_single_autosubmit = '0',show_as_single_autosubmit_delay = '200',input_position = '1',after_text = '',answer_click_animation = '0',answer_click_element = '',answer_click_animation_duration = '1000';
<stat>INSERT INTO HFCS00_Base SET id = '4',q_pos = '-16',q_name = '_notActive',tip_sql = '5',drg_sql = '',les_sql = '0',goto_sql = '',fil_sql = '',con_sql = '',open_sql = '0',anno_sql = '0',attachAnswers = '0',attachFalse = '0',rot_sql = '',srot_sql = '0',erot_sql = '0',srotLegend = '0',erotLegend = '0',srotAttributes = '0',erotAttributes = '0',qrot_sql = '',id_style = '0',id_mask = '0',must_answer = '1',disable_question = '0',answers_filter = '0',variableTypeBase = '4',variableTypeOpen = '0',open_answers = '',open_legend = '',open_attributes = '',multi_nogo_answers = '',multi_nogo_legends = '',multilanguage_all = '',qleave_js_alert = '0',filter_answer = '',filter_legend = '',filter_attributes = '',hasStructure = '1',use_for_quotas = '0',isFinal = '0',id_showTogether = '0',answerGroups = '',legendGroups = '',id_plugin = '0',id_incentive = '0',incentive_possibilites = '0',allow_listening = '0',old_id = '0',up_down_rotchk = '0',up_down_rotvar = '0',repeat_legend = '0',autoSubmit = '0',autoSubmitTimeout = '100',missing_values = '',open_end_type = '1',enter_submit = '1',slider_color = '',trace_color = '',slider_shape = '',slider_handle_image = '',email_app_group = '',email_app_template = '',encrypt = '',multi_type = '1',rotate_legend = '0',anonymize = '0',input_types = '',input_types_properties = '',custom_controls = '',rec_question_id = '0',rec_interval = '',show_as_single = '0',show_as_single_cond = '',show_as_single_design = '',show_as_single_autosubmit = '0',show_as_single_autosubmit_delay = '200',input_position = '1',after_text = '',answer_click_animation = '0',answer_click_element = '',answer_click_animation_duration = '1000';
<stat>INSERT INTO HFCS00_Base SET id = '10',q_pos = '3',q_name = 'questtext',tip_sql = '4',drg_sql = '',les_sql = '6',goto_sql = '',fil_sql = '',con_sql = '',open_sql = '1',anno_sql = '0',attachAnswers = '0',attachFalse = '0',rot_sql = '',srot_sql = '0',erot_sql = '0',srotLegend = '0',erotLegend = '0',srotAttributes = '0',erotAttributes = '0',qrot_sql = '',id_style = '0',id_mask = '0',must_answer = '0',disable_question = '1',answers_filter = '0',variableTypeBase = '6',variableTypeOpen = '0',open_answers = '',open_legend = '',open_attributes = '',multi_nogo_answers = '',multi_nogo_legends = '',multilanguage_all = '',qleave_js_alert = '0',filter_answer = '',filter_legend = '',filter_attributes = '',hasStructure = '1',use_for_quotas = '0',isFinal = '0',id_showTogether = '0',answerGroups = '',legendGroups = '',id_plugin = '0',id_incentive = '0',incentive_possibilites = '0',allow_listening = '0',old_id = '0',up_down_rotchk = '0',up_down_rotvar = '0',repeat_legend = '0',autoSubmit = '0',autoSubmitTimeout = '100',missing_values = '',open_end_type = '1',enter_submit = '1',slider_color = '',trace_color = '',slider_shape = '',slider_handle_image = '',email_app_group = '',email_app_template = '',encrypt = '',multi_type = '1',rotate_legend = '0',anonymize = '0',input_types = '',input_types_properties = '',custom_controls = '',rec_question_id = '0',rec_interval = '',show_as_single = '0',show_as_single_cond = '',show_as_single_design = '',show_as_single_autosubmit = '0',show_as_single_autosubmit_delay = '200',input_position = '1',after_text = '',answer_click_animation = '0',answer_click_element = '',answer_click_animation_duration = '1000';
<stat>INSERT INTO HFCS00_Base SET id = '11',q_pos = '1',q_name = 'Projektdaten',tip_sql = '4',drg_sql = '',les_sql = '3',goto_sql = '',fil_sql = '$Projektdaten_1 == NULL',con_sql = '',open_sql = '0',anno_sql = '0',attachAnswers = '0',attachFalse = '0',rot_sql = '',srot_sql = '0',erot_sql = '0',srotLegend = '0',erotLegend = '0',srotAttributes = '0',erotAttributes = '0',qrot_sql = '',id_style = '0',id_mask = '0',must_answer = '0',disable_question = '0',answers_filter = '0',variableTypeBase = '6',variableTypeOpen = '0',open_answers = '',open_legend = '',open_attributes = '',multi_nogo_answers = '',multi_nogo_legends = '',multilanguage_all = '',qleave_js_alert = '0',filter_answer = '0true<!>0true<!>0true<!>0true<!>0true<!>0<!>0true<!>0true<!>0<!>0true<!>0<!>0<!>0<!>0<!>0true<!>0true<!>0true<!>0true<!>0<!>0true<!>0true<!>0true<!>0true<!>0true<!>0true',filter_legend = '',filter_attributes = '',hasStructure = '1',use_for_quotas = '0',isFinal = '0',id_showTogether = '0',answerGroups = '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0<|><|>',legendGroups = '',id_plugin = '0',id_incentive = '0',incentive_possibilites = '0',allow_listening = '0',old_id = '0',up_down_rotchk = '0',up_down_rotvar = '0',repeat_legend = '0',autoSubmit = '0',autoSubmitTimeout = '100',missing_values = '',open_end_type = '1',enter_submit = '1',slider_color = '',trace_color = '',slider_shape = '',slider_handle_image = '',email_app_group = '',email_app_template = '',encrypt = '',multi_type = '1',rotate_legend = '0',anonymize = '0',input_types = '',input_types_properties = '',custom_controls = '',rec_question_id = '0',rec_interval = '',show_as_single = '0',show_as_single_cond = '',show_as_single_design = '',show_as_single_autosubmit = '0',show_as_single_autosubmit_delay = '200',input_position = '1',after_text = '',answer_click_animation = '0',answer_click_element = '',answer_click_animation_duration = '1000';
<stat>INSERT INTO HFCS00_Base SET id = '13',q_pos = '4',q_name = 'TEST',tip_sql = '1',drg_sql = '',les_sql = '1',goto_sql = '$TEST == 5#farbstart',fil_sql = '$Projektdaten_17 == \"\" || $Projektdaten_17 == 0',con_sql = '',open_sql = '0',anno_sql = '0',attachAnswers = '0',attachFalse = '0',rot_sql = '',srot_sql = '0',erot_sql = '0',srotLegend = '0',erotLegend = '0',srotAttributes = '0',erotAttributes = '0',qrot_sql = '',id_style = '0',id_mask = '0',must_answer = '1',disable_question = '0',answers_filter = '0',variableTypeBase = '5',variableTypeOpen = '0',open_answers = '',open_legend = '',open_attributes = '',multi_nogo_answers = '',multi_nogo_legends = '',multilanguage_all = '',qleave_js_alert = '0',filter_answer = '0<!>0<!>0true<!>0true<!>0true<!>0<!>0true',filter_legend = '',filter_attributes = '',hasStructure = '1',use_for_quotas = '0',isFinal = '0',id_showTogether = '0',answerGroups = '0,0,0,0,0,0,0<|><|>',legendGroups = '',id_plugin = '0',id_incentive = '0',incentive_possibilites = '0',allow_listening = '0',old_id = '0',up_down_rotchk = '0',up_down_rotvar = '0',repeat_legend = '0',autoSubmit = '0',autoSubmitTimeout = '100',missing_values = '',open_end_type = '1',enter_submit = '1',slider_color = '',trace_color = '',slider_shape = '',slider_handle_image = '',email_app_group = '',email_app_template = '',encrypt = '',multi_type = '1',rotate_legend = '0',anonymize = '0',input_types = '',input_types_properties = '',custom_controls = '',rec_question_id = '0',rec_interval = '',show_as_single = '0',show_as_single_cond = '',show_as_single_design = '',show_as_single_autosubmit = '0',show_as_single_autosubmit_delay = '200',input_position = '1',after_text = '',answer_click_animation = '0',answer_click_element = '',answer_click_animation_duration = '1000';
<stat>INSERT INTO HFCS00_Base SET id = '18',q_pos = '8',q_name = 'kondata',tip_sql = '4',drg_sql = '',les_sql = '3',goto_sql = '',fil_sql = '',con_sql = '(intval( $kondata_8  )>1 or ( $kondata_8 == 0  and $Projektdaten_11 ==  $kondata_3  )) and  strlen($kondata_4)>=1',open_sql = '0',anno_sql = '0',attachAnswers = '0',attachFalse = '0',rot_sql = '',srot_sql = '0',erot_sql = '0',srotLegend = '0',erotLegend = '0',srotAttributes = '0',erotAttributes = '0',qrot_sql = '',id_style = '0',id_mask = '0',must_answer = '0',disable_question = '0',answers_filter = '1',variableTypeBase = '0',variableTypeOpen = '0',open_answers = '',open_legend = '',open_attributes = '',multi_nogo_answers = '',multi_nogo_legends = '',multilanguage_all = '',qleave_js_alert = '0',filter_answer = '',filter_legend = '',filter_attributes = '',hasStructure = '1',use_for_quotas = '0',isFinal = '0',id_showTogether = '0',answerGroups = '0,0,0,0,0,0,0,0,0,0,0,0,0<|><|>',legendGroups = '',id_plugin = '0',id_incentive = '0',incentive_possibilites = '0',allow_listening = '0',old_id = '0',up_down_rotchk = '0',up_down_rotvar = '0',repeat_legend = '0',autoSubmit = '0',autoSubmitTimeout = '100',missing_values = '',open_end_type = '1',enter_submit = '1',slider_color = '',trace_color = '',slider_shape = '',slider_handle_image = '',email_app_group = '',email_app_template = '',encrypt = '',multi_type = '1',rotate_legend = '0',anonymize = '0',input_types = '',input_types_properties = '',custom_controls = '',rec_question_id = '0',rec_interval = '',show_as_single = '0',show_as_single_cond = '',show_as_single_design = '',show_as_single_autosubmit = '0',show_as_single_autosubmit_delay = '200',input_position = '1',after_text = '',answer_click_animation = '0',answer_click_element = '',answer_click_animation_duration = '1000';
<stat>INSERT INTO HFCS00_Base SET id = '19',q_pos = '9',q_name = 'streetname',tip_sql = '4',drg_sql = '',les_sql = '6',goto_sql = '',fil_sql = '$kondata_8 == 999999',con_sql = '',open_sql = '1',anno_sql = '0',attachAnswers = '0',attachFalse = '0',rot_sql = '',srot_sql = '0',erot_sql = '0',srotLegend = '0',erotLegend = '0',srotAttributes = '0',erotAttributes = '0',qrot_sql = '',id_style = '0',id_mask = '0',must_answer = '1',disable_question = '0',answers_filter = '0',variableTypeBase = '6',variableTypeOpen = '0',open_answers = '',open_legend = '',open_attributes = '',multi_nogo_answers = '',multi_nogo_legends = '',multilanguage_all = '',qleave_js_alert = '0',filter_answer = '',filter_legend = '',filter_attributes = '',hasStructure = '1',use_for_quotas = '0',isFinal = '0',id_showTogether = '0',answerGroups = '',legendGroups = '',id_plugin = '0',id_incentive = '0',incentive_possibilites = '0',allow_listening = '0',old_id = '0',up_down_rotchk = '0',up_down_rotvar = '0',repeat_legend = '0',autoSubmit = '0',autoSubmitTimeout = '100',missing_values = '',open_end_type = '1',enter_submit = '1',slider_color = '',trace_color = '',slider_shape = '',slider_handle_image = '',email_app_group = '',email_app_template = '',encrypt = '',multi_type = '1',rotate_legend = '0',anonymize = '0',input_types = '',input_types_properties = '',custom_controls = '',rec_question_id = '0',rec_interval = '',show_as_single = '0',show_as_single_cond = '',show_as_single_design = '',show_as_single_autosubmit = '0',show_as_single_autosubmit_delay = '200',input_position = '1',after_text = '',answer_click_animation = '0',answer_click_element = '',answer_click_animation_duration = '1000';
<stat>INSERT INTO HFCS00_Base SET id = '20',q_pos = '10',q_name = 'vernr',tip_sql = '4',drg_sql = '',les_sql = '6',goto_sql = '',fil_sql = '',con_sql = '',open_sql = '1',anno_sql = '0',attachAnswers = '0',attachFalse = '0',rot_sql = '',srot_sql = '0',erot_sql = '0',srotLegend = '0',erotLegend = '0',srotAttributes = '0',erotAttributes = '0',qrot_sql = '',id_style = '0',id_mask = '0',must_answer = '1',disable_question = '1',answers_filter = '0',variableTypeBase = '6',variableTypeOpen = '0',open_answers = '',open_legend = '',open_attributes = '',multi_nogo_answers = '',multi_nogo_legends = '',multilanguage_all = '',qleave_js_alert = '0',filter_answer = '',filter_legend = '',filter_attributes = '',hasStructure = '1',use_for_quotas = '0',isFinal = '0',id_showTogether = '0',answerGroups = '',legendGroups = '',id_plugin = '0',id_incentive = '0',incentive_possibilites = '0',allow_listening = '0',old_id = '0',up_down_rotchk = '0',up_down_rotvar = '0',repeat_legend = '0',autoSubmit = '0',autoSubmitTimeout = '100',missing_values = '',open_end_type = '1',enter_submit = '1',slider_color = '',trace_color = '',slider_shape = '',slider_handle_image = '',email_app_group = '',email_app_template = '',encrypt = '',multi_type = '1',rotate_legend = '0',anonymize = '0',input_types = '',input_types_properties = '',custom_controls = '',rec_question_id = '0',rec_interval = '',show_as_single = '0',show_as_single_cond = '',show_as_single_design = '',show_as_single_autosubmit = '0',show_as_single_autosubmit_delay = '200',input_position = '1',after_text = '',answer_click_animation = '0',answer_click_element = '',answer_click_animation_duration = '1000';
<stat>INSERT INTO HFCS00_Base SET id = '21',q_pos = '11',q_name = 'intnr',tip_sql = '4',drg_sql = '',les_sql = '6',goto_sql = '',fil_sql = '',con_sql = '',open_sql = '1',anno_sql = '0',attachAnswers = '0',attachFalse = '0',rot_sql = '',srot_sql = '0',erot_sql = '0',srotLegend = '0',erotLegend = '0',srotAttributes = '0',erotAttributes = '0',qrot_sql = '',id_style = '0',id_mask = '0',must_answer = '1',disable_question = '1',answers_filter = '0',variableTypeBase = '6',variableTypeOpen = '0',open_answers = '',open_legend = '',open_attributes = '',multi_nogo_answers = '',multi_nogo_legends = '',multilanguage_all = '',qleave_js_alert = '0',filter_answer = '',filter_legend = '',filter_attributes = '',hasStructure = '1',use_for_quotas = '0',isFinal = '0',id_showTogether = '0',answerGroups = '',legendGroups = '',id_plugin = '0',id_incentive = '0',incentive_possibilites = '0',allow_listening = '0',old_id = '0',up_down_rotchk = '0',up_down_rotvar = '0',repeat_legend = '0',autoSubmit = '0',autoSubmitTimeout = '100',missing_values = '',open_end_type = '1',enter_submit = '1',slider_color = '',trace_color = '',slider_shape = '',slider_handle_image = '',email_app_group = '',email_app_template = '',encrypt = '',multi_type = '1',rotate_legend = '0',anonymize = '0',input_types = '',input_types_properties = '',custom_controls = '',rec_question_id = '0',rec_interval = '',show_as_single = '0',show_as_single_cond = '',show_as_single_design = '',show_as_single_autosubmit = '0',show_as_single_autosubmit_delay = '200',input_position = '1',after_text = '',answer_click_animation = '0',answer_click_element = '',answer_click_animation_duration = '1000';
<stat>INSERT INTO HFCS00_Base SET id = '22',q_pos = '12',q_name = 'verng2',tip_sql = '1',drg_sql = '',les_sql = '1',goto_sql = '',fil_sql = '',con_sql = '($verng2_opn >= 10000 and  $verng2_opn <= 99999) or  $verng2 == 1',open_sql = '0',anno_sql = '0',attachAnswers = '0',attachFalse = '0',rot_sql = '',srot_sql = '0',erot_sql = '0',srotLegend = '0',erotLegend = '0',srotAttributes = '0',erotAttributes = '0',qrot_sql = '',id_style = '0',id_mask = '0',must_answer = '1',disable_question = '0',answers_filter = '0',variableTypeBase = '5',variableTypeOpen = '0',open_answers = '2',open_legend = '',open_attributes = '',multi_nogo_answers = '',multi_nogo_legends = '',multilanguage_all = '',qleave_js_alert = '0',filter_answer = '',filter_legend = '',filter_attributes = '',hasStructure = '1',use_for_quotas = '0',isFinal = '0',id_showTogether = '0',answerGroups = '0,0<|><|>',legendGroups = '',id_plugin = '0',id_incentive = '0',incentive_possibilites = '0',allow_listening = '0',old_id = '0',up_down_rotchk = '0',up_down_rotvar = '0',repeat_legend = '0',autoSubmit = '0',autoSubmitTimeout = '100',missing_values = '',open_end_type = '1',enter_submit = '1',slider_color = '',trace_color = '',slider_shape = '',slider_handle_image = '',email_app_group = '',email_app_template = '',encrypt = '',multi_type = '1',rotate_legend = '0',anonymize = '0',input_types = '',input_types_properties = '',custom_controls = '',rec_question_id = '0',rec_interval = '',show_as_single = '0',show_as_single_cond = '',show_as_single_design = '',show_as_single_autosubmit = '0',show_as_single_autosubmit_delay = '200',input_position = '1',after_text = '',answer_click_animation = '0',answer_click_element = '',answer_click_animation_duration = '1000';
<stat>INSERT INTO HFCS00_Base SET id = '23',q_pos = '13',q_name = 'verende',tip_sql = '6',drg_sql = '',les_sql = '0',goto_sql = '',fil_sql = '',con_sql = '',open_sql = '0',anno_sql = '0',attachAnswers = '0',attachFalse = '0',rot_sql = '',srot_sql = '0',erot_sql = '0',srotLegend = '0',erotLegend = '0',srotAttributes = '0',erotAttributes = '0',qrot_sql = '',id_style = '0',id_mask = '0',must_answer = '1',disable_question = '1',answers_filter = '0',variableTypeBase = '9',variableTypeOpen = '0',open_answers = '',open_legend = '',open_attributes = '',multi_nogo_answers = '',multi_nogo_legends = '',multilanguage_all = '',qleave_js_alert = '0',filter_answer = '',filter_legend = '',filter_attributes = '',hasStructure = '1',use_for_quotas = '0',isFinal = '0',id_showTogether = '0',answerGroups = '',legendGroups = '',id_plugin = '0',id_incentive = '0',incentive_possibilites = '0',allow_listening = '0',old_id = '0',up_down_rotchk = '0',up_down_rotvar = '0',repeat_legend = '0',autoSubmit = '0',autoSubmitTimeout = '100',missing_values = '',open_end_type = '1',enter_submit = '1',slider_color = '',trace_color = '',slider_shape = '',slider_handle_image = '',email_app_group = '',email_app_template = '',encrypt = '',multi_type = '1',rotate_legend = '0',anonymize = '0',input_types = '',input_types_properties = '',custom_controls = '',rec_question_id = '0',rec_interval = '',show_as_single = '0',show_as_single_cond = '',show_as_single_design = '',show_as_single_autosubmit = '0',show_as_single_autosubmit_delay = '200',input_position = '1',after_text = '',answer_click_animation = '0',answer_click_element = '',answer_click_animation_duration = '1000';
<stat>INSERT INTO HFCS00_Base SET id = '24',q_pos = '14',q_name = 'verng1',tip_sql = '4',drg_sql = '',les_sql = '3',goto_sql = 'true#ENDIV',fil_sql = '',con_sql = '($verng1_1 >= 0 and  $verng1_1 <= 300) or $verng1_1 == NULL',open_sql = '1',anno_sql = '0',attachAnswers = '0',attachFalse = '0',rot_sql = '',srot_sql = '0',erot_sql = '0',srotLegend = '0',erotLegend = '0',srotAttributes = '0',erotAttributes = '0',qrot_sql = '',id_style = '0',id_mask = '0',must_answer = '1',disable_question = '0',answers_filter = '0',variableTypeBase = '4',variableTypeOpen = '0',open_answers = '',open_legend = '',open_attributes = '',multi_nogo_answers = '',multi_nogo_legends = '',multilanguage_all = '',qleave_js_alert = '0',filter_answer = '',filter_legend = '',filter_attributes = '',hasStructure = '1',use_for_quotas = '0',isFinal = '0',id_showTogether = '0',answerGroups = '',legendGroups = '',id_plugin = '0',id_incentive = '0',incentive_possibilites = '0',allow_listening = '0',old_id = '0',up_down_rotchk = '0',up_down_rotvar = '0',repeat_legend = '0',autoSubmit = '0',autoSubmitTimeout = '100',missing_values = '',open_end_type = '1',enter_submit = '1',slider_color = '',trace_color = '',slider_shape = '',slider_handle_image = '',email_app_group = '',email_app_template = '',encrypt = '',multi_type = '1',rotate_legend = '0',anonymize = '0',input_types = '',input_types_properties = '',custom_controls = '',rec_question_id = '0',rec_interval = '',show_as_single = '0',show_as_single_cond = '',show_as_single_design = '',show_as_single_autosubmit = '0',show_as_single_autosubmit_delay = '200',input_position = '1',after_text = '',answer_click_animation = '0',answer_click_element = '',answer_click_animation_duration = '1000';
<stat>INSERT INTO HFCS00_Base SET id = '25',q_pos = '15',q_name = 'BREAK',tip_sql = '1',drg_sql = '',les_sql = '1',goto_sql = '$BREAK == 1#Projektdaten,true#BREAK',fil_sql = '',con_sql = '',open_sql = '1',anno_sql = '0',attachAnswers = '0',attachFalse = '0',rot_sql = '',srot_sql = '0',erot_sql = '0',srotLegend = '0',erotLegend = '0',srotAttributes = '0',erotAttributes = '0',qrot_sql = '',id_style = '0',id_mask = '0',must_answer = '1',disable_question = '0',answers_filter = '0',variableTypeBase = '5',variableTypeOpen = '0',open_answers = '',open_legend = '',open_attributes = '',multi_nogo_answers = '',multi_nogo_legends = '',multilanguage_all = '',qleave_js_alert = '0',filter_answer = '',filter_legend = '',filter_attributes = '',hasStructure = '1',use_for_quotas = '0',isFinal = '0',id_showTogether = '0',answerGroups = '',legendGroups = '',id_plugin = '0',id_incentive = '0',incentive_possibilites = '0',allow_listening = '0',old_id = '0',up_down_rotchk = '0',up_down_rotvar = '0',repeat_legend = '0',autoSubmit = '0',autoSubmitTimeout = '100',missing_values = '',open_end_type = '1',enter_submit = '1',slider_color = '',trace_color = '',slider_shape = '',slider_handle_image = '',email_app_group = '',email_app_template = '',encrypt = '',multi_type = '1',rotate_legend = '0',anonymize = '0',input_types = '',input_types_properties = '',custom_controls = '',rec_question_id = '0',rec_interval = '',show_as_single = '0',show_as_single_cond = '',show_as_single_design = '',show_as_single_autosubmit = '0',show_as_single_autosubmit_delay = '200',input_position = '1',after_text = '',answer_click_animation = '0',answer_click_element = '',answer_click_animation_duration = '1000';
<stat>INSERT INTO HFCS00_Base SET id = '26',q_pos = '16',q_name = 'ENDIV',tip_sql = '1',drg_sql = '',les_sql = '1',goto_sql = '',fil_sql = '',con_sql = '',open_sql = '1',anno_sql = '0',attachAnswers = '0',attachFalse = '0',rot_sql = '',srot_sql = '0',erot_sql = '0',srotLegend = '0',erotLegend = '0',srotAttributes = '0',erotAttributes = '0',qrot_sql = '',id_style = '0',id_mask = '0',must_answer = '1',disable_question = '0',answers_filter = '0',variableTypeBase = '5',variableTypeOpen = '0',open_answers = '',open_legend = '',open_attributes = '',multi_nogo_answers = '',multi_nogo_legends = '',multilanguage_all = '',qleave_js_alert = '0',filter_answer = '',filter_legend = '',filter_attributes = '',hasStructure = '1',use_for_quotas = '0',isFinal = '0',id_showTogether = '0',answerGroups = '',legendGroups = '',id_plugin = '0',id_incentive = '0',incentive_possibilites = '0',allow_listening = '0',old_id = '0',up_down_rotchk = '0',up_down_rotvar = '0',repeat_legend = '0',autoSubmit = '0',autoSubmitTimeout = '100',missing_values = '',open_end_type = '1',enter_submit = '1',slider_color = '',trace_color = '',slider_shape = '',slider_handle_image = '',email_app_group = '',email_app_template = '',encrypt = '',multi_type = '1',rotate_legend = '0',anonymize = '0',input_types = '',input_types_properties = '',custom_controls = '',rec_question_id = '0',rec_interval = '',show_as_single = '0',show_as_single_cond = '',show_as_single_design = '',show_as_single_autosubmit = '0',show_as_single_autosubmit_delay = '200',input_position = '1',after_text = '',answer_click_animation = '0',answer_click_element = '',answer_click_animation_duration = '1000';
<stat>INSERT INTO HFCS00_Base SET id = '27',q_pos = '17',q_name = 'fbende',tip_sql = '6',drg_sql = '',les_sql = '0',goto_sql = '',fil_sql = '',con_sql = '',open_sql = '0',anno_sql = '0',attachAnswers = '0',attachFalse = '0',rot_sql = '',srot_sql = '0',erot_sql = '0',srotLegend = '0',erotLegend = '0',srotAttributes = '0',erotAttributes = '0',qrot_sql = '',id_style = '0',id_mask = '0',must_answer = '1',disable_question = '1',answers_filter = '0',variableTypeBase = '9',variableTypeOpen = '0',open_answers = '',open_legend = '',open_attributes = '',multi_nogo_answers = '',multi_nogo_legends = '',multilanguage_all = '',qleave_js_alert = '0',filter_answer = '',filter_legend = '',filter_attributes = '',hasStructure = '1',use_for_quotas = '0',isFinal = '0',id_showTogether = '0',answerGroups = '',legendGroups = '',id_plugin = '0',id_incentive = '0',incentive_possibilites = '0',allow_listening = '0',old_id = '0',up_down_rotchk = '0',up_down_rotvar = '0',repeat_legend = '0',autoSubmit = '0',autoSubmitTimeout = '100',missing_values = '',open_end_type = '1',enter_submit = '1',slider_color = '',trace_color = '',slider_shape = '',slider_handle_image = '',email_app_group = '',email_app_template = '',encrypt = '',multi_type = '1',rotate_legend = '0',anonymize = '0',input_types = '',input_types_properties = '',custom_controls = '',rec_question_id = '0',rec_interval = '',show_as_single = '0',show_as_single_cond = '',show_as_single_design = '',show_as_single_autosubmit = '0',show_as_single_autosubmit_delay = '200',input_position = '1',after_text = '',answer_click_animation = '0',answer_click_element = '',answer_click_animation_duration = '1000';
<stat>INSERT INTO HFCS00_Base SET id = '28',q_pos = '5',q_name = 'timevdbstart',tip_sql = '6',drg_sql = '',les_sql = '0',goto_sql = '',fil_sql = '',con_sql = '',open_sql = '0',anno_sql = '0',attachAnswers = '0',attachFalse = '0',rot_sql = '',srot_sql = '0',erot_sql = '0',srotLegend = '0',erotLegend = '0',srotAttributes = '0',erotAttributes = '0',qrot_sql = '',id_style = '0',id_mask = '0',must_answer = '1',disable_question = '1',answers_filter = '0',variableTypeBase = '9',variableTypeOpen = '0',open_answers = '',open_legend = '',open_attributes = '',multi_nogo_answers = '',multi_nogo_legends = '',multilanguage_all = '',qleave_js_alert = '0',filter_answer = '',filter_legend = '',filter_attributes = '',hasStructure = '1',use_for_quotas = '0',isFinal = '0',id_showTogether = '0',answerGroups = '',legendGroups = '',id_plugin = '0',id_incentive = '0',incentive_possibilites = '0',allow_listening = '0',old_id = '0',up_down_rotchk = '0',up_down_rotvar = '0',repeat_legend = '0',autoSubmit = '0',autoSubmitTimeout = '100',missing_values = '',open_end_type = '1',enter_submit = '1',slider_color = '',trace_color = '',slider_shape = '',slider_handle_image = '',email_app_group = '',email_app_template = '',encrypt = '',multi_type = '1',rotate_legend = '0',anonymize = '0',input_types = '',input_types_properties = '',custom_controls = '',rec_question_id = '0',rec_interval = '',show_as_single = '0',show_as_single_cond = '',show_as_single_design = '',show_as_single_autosubmit = '0',show_as_single_autosubmit_delay = '200',input_position = '1',after_text = '',answer_click_animation = '0',answer_click_element = '',answer_click_animation_duration = '1000';
<stat>INSERT INTO HFCS00_Base SET id = '29',q_pos = '7',q_name = 'timevdbend',tip_sql = '6',drg_sql = '',les_sql = '0',goto_sql = '',fil_sql = '',con_sql = '',open_sql = '1',anno_sql = '0',attachAnswers = '0',attachFalse = '0',rot_sql = '',srot_sql = '0',erot_sql = '0',srotLegend = '0',erotLegend = '0',srotAttributes = '0',erotAttributes = '0',qrot_sql = '',id_style = '0',id_mask = '0',must_answer = '1',disable_question = '1',answers_filter = '0',variableTypeBase = '4',variableTypeOpen = '0',open_answers = '',open_legend = '',open_attributes = '',multi_nogo_answers = '',multi_nogo_legends = '',multilanguage_all = '',qleave_js_alert = '0',filter_answer = '',filter_legend = '',filter_attributes = '',hasStructure = '1',use_for_quotas = '0',isFinal = '0',id_showTogether = '0',answerGroups = '',legendGroups = '',id_plugin = '0',id_incentive = '0',incentive_possibilites = '0',allow_listening = '0',old_id = '0',up_down_rotchk = '0',up_down_rotvar = '0',repeat_legend = '0',autoSubmit = '0',autoSubmitTimeout = '100',missing_values = '',open_end_type = '1',enter_submit = '1',slider_color = '',trace_color = '',slider_shape = '',slider_handle_image = '',email_app_group = '',email_app_template = '',encrypt = '',multi_type = '1',rotate_legend = '0',anonymize = '0',input_types = '',input_types_properties = '',custom_controls = '',rec_question_id = '0',rec_interval = '',show_as_single = '0',show_as_single_cond = '',show_as_single_design = '',show_as_single_autosubmit = '0',show_as_single_autosubmit_delay = '200',input_position = '1',after_text = '',answer_click_animation = '0',answer_click_element = '',answer_click_animation_duration = '1000';
<stat>INSERT INTO HFCS00_Base SET id = '31',q_pos = '6',q_name = 'switch1',tip_sql = '1',drg_sql = '',les_sql = '1',goto_sql = '$switch1==1#switch1',fil_sql = '',con_sql = '',open_sql = '0',anno_sql = '0',attachAnswers = '0',attachFalse = '0',rot_sql = '',srot_sql = '0',erot_sql = '0',srotLegend = '0',erotLegend = '0',srotAttributes = '0',erotAttributes = '0',qrot_sql = '',id_style = '0',id_mask = '0',must_answer = '1',disable_question = '0',answers_filter = '0',variableTypeBase = '4',variableTypeOpen = '0',open_answers = '',open_legend = '',open_attributes = '',multi_nogo_answers = '',multi_nogo_legends = '',multilanguage_all = '',qleave_js_alert = '0',filter_answer = '0$switch1==2<!>0$switch1!=2',filter_legend = '',filter_attributes = '',hasStructure = '1',use_for_quotas = '0',isFinal = '0',id_showTogether = '0',answerGroups = '0,0<|><|>',legendGroups = '',id_plugin = '0',id_incentive = '0',incentive_possibilites = '0',allow_listening = '0',old_id = '0',up_down_rotchk = '0',up_down_rotvar = '0',repeat_legend = '0',autoSubmit = '0',autoSubmitTimeout = '100',missing_values = '',open_end_type = '1',enter_submit = '1',slider_color = '',trace_color = '',slider_shape = '',slider_handle_image = '',email_app_group = '',email_app_template = '',encrypt = '',multi_type = '1',rotate_legend = '0',anonymize = '0',input_types = 'text,',input_types_properties = 'null',custom_controls = '',rec_question_id = '0',rec_interval = '',show_as_single = '0',show_as_single_cond = '',show_as_single_design = '',show_as_single_autosubmit = '0',show_as_single_autosubmit_delay = '200',input_position = '1',after_text = '',answer_click_animation = '0',answer_click_element = '',answer_click_animation_duration = '1000';
<stat>INSERT INTO HFCS00_Base SET id = '32',q_pos = '2',q_name = 'links',tip_sql = '4',drg_sql = '',les_sql = '6',goto_sql = '',fil_sql = '',con_sql = '',open_sql = '1',anno_sql = '0',attachAnswers = '0',attachFalse = '0',rot_sql = '',srot_sql = '0',erot_sql = '0',srotLegend = '0',erotLegend = '0',srotAttributes = '0',erotAttributes = '0',qrot_sql = '',id_style = '0',id_mask = '0',must_answer = '0',disable_question = '1',answers_filter = '0',variableTypeBase = '6',variableTypeOpen = '0',open_answers = '',open_legend = '',open_attributes = '',multi_nogo_answers = '',multi_nogo_legends = '',multilanguage_all = '',qleave_js_alert = '0',filter_answer = '',filter_legend = '',filter_attributes = '',hasStructure = '1',use_for_quotas = '0',isFinal = '0',id_showTogether = '0',answerGroups = '',legendGroups = '',id_plugin = '0',id_incentive = '0',incentive_possibilites = '0',allow_listening = '0',old_id = '0',up_down_rotchk = '0',up_down_rotvar = '0',repeat_legend = '0',autoSubmit = '0',autoSubmitTimeout = '100',missing_values = '',open_end_type = '1',enter_submit = '1',slider_color = '',trace_color = '',slider_shape = '',slider_handle_image = '',email_app_group = '',email_app_template = '',encrypt = '',multi_type = '1',rotate_legend = '0',anonymize = '0',input_types = '',input_types_properties = '',custom_controls = '',rec_question_id = '0',rec_interval = '',show_as_single = '0',show_as_single_cond = '',show_as_single_design = '',show_as_single_autosubmit = '0',show_as_single_autosubmit_delay = '200',input_position = '1',after_text = '',answer_click_animation = '0',answer_click_element = '',answer_click_animation_duration = '1000';
<stat>INSERT INTO HFCS00_Base SET id = '33',q_pos = '-3',q_name = '_Repeal',tip_sql = '5',drg_sql = '',les_sql = '',goto_sql = '',fil_sql = '',con_sql = '',open_sql = '',anno_sql = '',attachAnswers = '',attachFalse = '',rot_sql = '',srot_sql = '',erot_sql = '',srotLegend = '',erotLegend = '',srotAttributes = '',erotAttributes = '',qrot_sql = '',id_style = '',id_mask = '',must_answer = '1',disable_question = '1',answers_filter = '0',variableTypeBase = '4',variableTypeOpen = '0',open_answers = '',open_legend = '',open_attributes = '',multi_nogo_answers = '',multi_nogo_legends = '',multilanguage_all = '',qleave_js_alert = '0',filter_answer = '',filter_legend = '',filter_attributes = '',hasStructure = '1',use_for_quotas = '0',isFinal = '0',id_showTogether = '0',answerGroups = '',legendGroups = '',id_plugin = '',id_incentive = '',incentive_possibilites = '0',allow_listening = '0',old_id = '0',up_down_rotchk = '0',up_down_rotvar = '0',repeat_legend = '0',autoSubmit = '0',autoSubmitTimeout = '100',missing_values = '',open_end_type = '1',enter_submit = '1',slider_color = '',trace_color = '',slider_shape = '',slider_handle_image = '',email_app_group = '',email_app_template = '',encrypt = '',multi_type = '1',rotate_legend = '0',anonymize = '0',input_types = '',input_types_properties = '',custom_controls = '',rec_question_id = '0',rec_interval = '',show_as_single = '0',show_as_single_cond = '',show_as_single_design = '',show_as_single_autosubmit = '0',show_as_single_autosubmit_delay = '200',input_position = '1',after_text = '',answer_click_animation = '0',answer_click_element = '',answer_click_animation_duration = '1000';
<stat>INSERT INTO HFCS00_Base_language SET id = '1',id_language = '60',id_question = '1',id_text_type = '2',lngText = '<div>Diese  wissenschaftliche  Erhebung  im  Auftrag  der  Oesterreichischen  Nationalbank 
beschäftigt  sich  mit  der  finanziellen  Situation  und  dem  Ausgabeverhalten  der  privaten 
Haushalte. Sie ist Teil einer größeren Erhebung für das gesamte Euro-Währungsgebiet. <br></div><div><br></div><div>Ihr Haushalt wurde nach dem Zufallsprinzip ausgewählt. <br></div><div><br></div><div>Wir  versichern  Ihnen,  dass  wir  die  erhobenen  Daten  ausschließlich  für  statistische  und 
wissenschaftliche  Zwecke  verwenden  und  die  Antworten  auf  alle  hier  gestellten  Fragen 
vertraulich behandeln.</div><div><br></div><div>
Die Ergebnisse der Befragung werden Forschern ausschließlich in anonymisierter Form, 
d.h. ohne Namen und Anschrift, zugänglich  gemacht. Das heißt, es ist nicht möglich zu 
erkennen, von welcher Person bestimmte Angaben gemacht worden sind! </div>';
<stat>INSERT INTO HFCS00_Base_language SET id = '2',id_language = '60',id_question = '2',id_text_type = '2',lngText = 'Questionnaire finished';
<stat>INSERT INTO HFCS00_Base_language SET id = '3',id_language = '60',id_question = '3',id_text_type = '2',lngText = 'Thank you for participating in this survey!';
<stat>INSERT INTO HFCS00_Base_language SET id = '4',id_language = '60',id_question = '4',id_text_type = '2',lngText = 'This survey is not active!';
<stat>INSERT INTO HFCS00_Base_language SET id = '5',id_language = '60',id_question = '11',id_text_type = '2',lngText = 'Projekt';
<stat>INSERT INTO HFCS00_Base_language SET id = '6',id_language = '60',id_question = '11',id_text_type = '3',lngText = '1 Projektname/2 Welle/3 Verrechnungsnummer/4 Listennummer/5 Lfd Nummer/6 Bundesland/7 Politischer Bezirk/8 Größenklasse/9 Name (inkl. Vorname)/10 Vorname/11 Straße/12 PLZ/13 Ort/14 Telefonnummer/15 Version/16 Kontrollvariable/17 Adresstyp (0 = Test, 1 = Org, 2 = Ers, 3 = Einsteiger)/18 ID_POST/19 Straße Zusatz/20 Abgleichdatum/21 Status inkl. Kontaktblatt/22 QS Daten/23 LiveUpdateVersion/24 Fragebogenart(1 = TTM ohne Einschaltung, 2 = AKI ohne Einschaltung, 3 = MTU, 4 = mit Einschaltung /25 BLANK 25';
<stat>INSERT INTO HFCS00_Base_language SET id = '7',id_language = '60',id_question = '11',id_text_type = '8',lngText = '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0<|><|>';
<stat>INSERT INTO HFCS00_Base_language SET id = '11',id_language = '60',id_question = '13',id_text_type = '2',lngText = 'TEST ODER ECHTES INTERVIEW MACHEN';
<stat>INSERT INTO HFCS00_Base_language SET id = '12',id_language = '60',id_question = '13',id_text_type = '3',lngText = '1 unbezahltes TESTINTERVIEW/6 unbezahltes TESTINTERVIEW ohne Fragebogenblock/2 bezahltes INTERVIEW mit echter Adresse/3 bezahltes EINSTEIGERINTERVIEW mit selbst gesuchter Adresse/4 Kontaktergebnis durch IFES/5 Test Sprung/9 TESTDATENSPRUNG';
<stat>INSERT INTO HFCS00_Base_language SET id = '13',id_language = '60',id_question = '13',id_text_type = '8',lngText = '0,0,0,0,0,0,0<|><|>';
<stat>INSERT INTO HFCS00_Base_language SET id = '39',id_language = '60',id_question = '31',id_text_type = '8',lngText = '0,0<|><|>';
<stat>INSERT INTO HFCS00_Base_language SET id = '18',id_language = '60',id_question = '16',id_text_type = '2',lngText = 'Alter';
<stat>INSERT INTO HFCS00_Base_language SET id = '19',id_language = '60',id_question = '16',id_text_type = '3',lngText = '1 Alter';
<stat>INSERT INTO HFCS00_Base_language SET id = '20',id_language = '60',id_question = '17',id_text_type = '2',lngText = 'Geschlecht';
<stat>INSERT INTO HFCS00_Base_language SET id = '21',id_language = '60',id_question = '17',id_text_type = '3',lngText = '1 männlich/2 weiblich';
<stat>INSERT INTO HFCS00_Base_language SET id = '22',id_language = '60',id_question = '18',id_text_type = '3',lngText = '1 *Tragen Sie den Nachnamen des Respondenten ein.<br>Wenn möglich tragen Sie bitte auch den Vornamen ein./2 Zur schnellen Adresssuche tragen Sie die Postleitzahl ein./3 *Sobald Sie zumindest drei Buchstaben der Straße eingetragen haben, <br>erhalten Sie eine Liste aller passenden Straßen.<br>Klicken Sie die korrekte Straße an.<br>/4 *Ergänzen Sie die Adresse mit der Hausnummer. <br>Wenn zutreffend tragen Sie unbedingt auch korrekt Stiege, (Stock) und Türnummer ein.<br>/5 Ort<br>/6 *Bitte Fragen Sie den Respondenten zur Qualitätskontrolle nach seiner Telefonnummer.<br>Wir sind verpflichtet 10% der Interviews zu kontrollieren.<br>Die angegebene Telefonnummer wird nur für diese Kontrollzwecke verwendet.<br>/7 Kommentar/8';
<stat>INSERT INTO HFCS00_Base_language SET id = '23',id_language = '60',id_question = '18',id_text_type = '8',lngText = '0,0,0,0,0,0,0,0,0<|><|>';
<stat>INSERT INTO HFCS00_Base_language SET id = '24',id_language = '60',id_question = '18',id_text_type = '2',lngText = '<span style=\"background-color: rgb(255, 255, 0);\">Notieren/korrigieren Sie bitte die Kontaktdaten!<br>(* verpflichtende Eingabe)<br></span><br>';
<stat>INSERT INTO HFCS00_Base_language SET id = '25',id_language = '60',id_question = '19',id_text_type = '2',lngText = 'Notieren sie den Straßennamen so genau wie möglich.<br><br>(Nicht zuordenbare Adressen können nicht akzeptiert werden!)<br>';
<stat>INSERT INTO HFCS00_Base_language SET id = '26',id_language = '60',id_question = '20',id_text_type = '2',lngText = 'Intnr_ver';
<stat>INSERT INTO HFCS00_Base_language SET id = '27',id_language = '60',id_question = '21',id_text_type = '2',lngText = 'Intnr_org';
<stat>INSERT INTO HFCS00_Base_language SET id = '28',id_language = '60',id_question = '22',id_text_type = '2',lngText = 'Tragen Sie bitte Ihre Verrechnungsnummer (Interviewernummer) ein.<br><br>Verrechnen auf ...<br>';
<stat>INSERT INTO HFCS00_Base_language SET id = '29',id_language = '60',id_question = '22',id_text_type = '3',lngText = '1 $intnr_1/2 (notieren:)';
<stat>INSERT INTO HFCS00_Base_language SET id = '30',id_language = '60',id_question = '22',id_text_type = '8',lngText = '0,0<|><|>';
<stat>INSERT INTO HFCS00_Base_language SET id = '31',id_language = '60',id_question = '24',id_text_type = '2',lngText = 'Tragen Sie die einfache Entfernung zur Adresse ein? (0 = eigene Gemeinde)';
<stat>INSERT INTO HFCS00_Base_language SET id = '32',id_language = '60',id_question = '25',id_text_type = '2',lngText = 'In diesem Haushalt ist kein Interview möglich!';
<stat>INSERT INTO HFCS00_Base_language SET id = '33',id_language = '60',id_question = '25',id_text_type = '3',lngText = '1 zurück zum Anfang/2 Interview abbrechen';
<stat>INSERT INTO HFCS00_Base_language SET id = '34',id_language = '60',id_question = '26',id_text_type = '2',lngText = 'INT.: Ich versichere, dass dieses Interview wahrheitsgemäss aufgezeichnet wurde und dass es entsprechend den Verhaltensregeln der Marktforschungsgesellschaft durchgeführt wurde (ESOMAR-Code).<br><br>Wenn Sie jetzt weiter gehen, schließen Sie das Interview endgültig ab.';
<stat>INSERT INTO HFCS00_Base_language SET id = '35',id_language = '60',id_question = '26',id_text_type = '3',lngText = '1 weiter';
<stat>INSERT INTO HFCS00_Base_language SET id = '37',id_language = '60',id_question = '31',id_text_type = '2',lngText = '$questtext_1';
<stat>INSERT INTO HFCS00_Base_language SET id = '38',id_language = '60',id_question = '31',id_text_type = '3',lngText = '1 weiter/2 weiter';
<stat>INSERT INTO HFCS00_Base_script SET id_question = '11',id_event = '1',script = '
$i_userid = reset(getVar(\"user_id\"));

//1 Projektname
            saveVar(\'Projektdaten_1=\"Projekttitel\"\');
            //saveVar(\"Projektdaten_1=\'\". $i_address[0][\"capi_hhid\"] . \"\'\");
//3 Verrechnungsnummer
            saveVar(\'Projektdaten_3=\"Projektnummer\"\');
            //saveVar(\"Projektdaten_3=\'\". $i_address[0][\"capi_hhidf2\"] . \"\'\");
//24 Fragebogen ART
     //Fragebogenart(1 = TTM ohne Einschaltung, 2 = AKI ohne Einschaltung, 3 = MTU, 4 = mit Einschaltung, 9 = Sonstiges
            saveVar(\'Projektdaten_24=\"1\"\');
//15 Version
            saveVar(\'Projektdaten_15=\"0.1\"\'); // FRAGEBOGENVERSION VORLAGE

if ($i_userid != 0)
 {
$i_table_id = reset(getVar(\"id_capi_table\"));
$i_address_id = reset(getVar(\"id_capi_address\"));
$i_sample_id = reset(getVar(\"id_capi_sample\"));

// Interviewernummer eintragen
$i_userid = reset(getVar(\"user_id\"));
$i_info = getVarFromTable(\"_Interviewer\", \"username\", \"WHERE id = $i_userid\");

if (count($i_info) == 1)
    saveVar(\"intnr_1=\'\" . $i_info[0][\"username\"] . \"\'\");

if ($i_table_id != null)
{
    $i_table_name = getVarFromTable(\"_CapiTables\", \"name\", \"WHERE id = \".$i_table_id);
    if (count($i_table_name) == 1)
    {    
        $i_sample_table = \"capi___\" . $i_table_name[0][\"name\"];
    
//        $i_address = getVarFromTable($i_sample_table, \"id_municipality, municipality, id_settlement, capi_BL, capi_PB, capi_OG, name, street, zip, town, capi_vorwahl, capi_telnr\", \"WHERE id = \".$i_address_id);
        $i_address = getVarFromTable($i_sample_table, \"id, id_municipality, municipality, id_settlement, id_street, capi_BL, capi_PB, capi_OG, capi_ID_POST, name, street, addon_address, zip, town\", \"WHERE id = \".$i_address_id);
        if (count($i_address) == 1)
        {
//2 Welle
            //saveVar(\'Projektdaten_2=\"1\"\');
            saveVar(\"Projektdaten_2=\'\". $i_address[0][\"id_municipality\"] . \"\'\");
//4 Listennummer
            saveVar(\"Projektdaten_4=\'\". $i_address[0][\"municipality\"] . \"\'\");
//5 Lfd Nummer
            saveVar(\"Projektdaten_5=\'\". $i_address[0][\"id_settlement\"] . \"\'\");
//6 Bundesland
            saveVar(\"Projektdaten_6=\'\". $i_address[0][\"capi_BL\"]. \"\'\");
//7 Politischer Bezirk
            saveVar(\"Projektdaten_7=\'\". $i_address[0][\"capi_PB\"]. \"\'\");            
//8 Größenklasse
            saveVar(\"Projektdaten_8=\'\". $i_address[0][\"capi_OG\"]. \"\'\");            
//9 Name
            saveVar(\"Projektdaten_9=\'\". $i_address[0][\"name\"]. \"\'\");            
//10 Vorname
            //saveVar(\"Projektdaten_10=\'\". $i_address[0][\"capi_hhnrb2\"]. \"\'\");        
//11 Adresse
            saveVar(\"Projektdaten_11=\'\". $i_address[0][\"street\"]. \"\'\");
//12 PLZ
            saveVar(\"Projektdaten_12=\'\". $i_address[0][\"zip\"]. \"\'\");            
//13 Ort
            saveVar(\"Projektdaten_13=\'\". $i_address[0][\"town\"]. \"\'\");            
//14 Telefonnummer
            saveVar(\"Projektdaten_14=\'\". $i_address[0][\"capi_vorwahl\"]. $i_address[0][\"capi_telnr\"]. \"\'\");            
//16 Kontrollvariable
            //saveVar(\"Projektdaten_16=\'ver\'\");  wir für die Kontaktdaten gesetzt
//17 Adresstyp
           saveVar(\"Projektdaten_17=\'\". $i_address[0][\"id_street\"] . \"\'\");      
//18 ID_POST
            saveVar(\"Projektdaten_18=\'\". $i_address[0][\"capi_ID_POST\"]. \"\'\");            
//19 Straße Zusatz (Hausnummer etc.)
           saveVar(\"Projektdaten_19=\'\". $i_address[0][\"addon_address\"] . \"\'\");      
        }}}     
 }
//20 RESERVIERT FÜR ABGLEICHDATUM
//21 RESERVIERT FÜR STATUS INKL KONTAKTBLATT
//22 RESERVIERT FÜR QS DATEN
//23 RESERVIERT FÜR LIVE UPDATE VERSION
//24 RESERVIERT FÜR Fragebogen ART - Wird am Skriptanfang gesetzt
//25 FREI

$i_bld = reset(getVar(\"Projektdaten_6\"));    
if ($i_bld == \"\") {saveVar(\"Projektdaten_6=\'9\'\");};
$i_linr = reset(getVar(\"Projektdaten_4\"));    
if ($i_linr == \"\") {
    saveVar(\"Projektdaten_4=\'099999\'\");
    saveVar(\"Projektdaten_2=1\");
};
$i_id = reset(getVar(\"id\"));
$i_lfdnr = reset(getVar(\"Projektdaten_5\"));  
if ($i_lfdnr == \"\") {saveVar(\"Projektdaten_5=\".$i_id);};


';
<stat>INSERT INTO HFCS00_Base_script SET id_question = '14',id_event = '2',script = 'echo \"TEST\";
$i_userid = reset(getVar(\"user_id\"));
if ($i_userid==0) $i_userid = 135;

$txtchck = sprintf(\'Projektdaten_17,Projektdaten_9,Projektdaten_10,Projektdaten_11,Projektdaten_12,Projektdaten_13,Projektdaten_14,Projektdaten_19\');
$checkvar = getVar($txtchck);
$allvars = $txtchck;
    foreach (explode(\",\",$allvars) as $itemvar) {
           $$itemvar = $checkvar[$itemvar] ;
    }
if ($Projektdaten_17 == 1 or $Projektdaten_17 == 0) {
    $txtQuest = \'Sie bearbeiten gerade folgende Adresse:<br>\'.
        \"&nbsp;&nbsp;\".$Projektdaten_9.\" \".$Projektdaten_10.\"<br>\".
        \"&nbsp;&nbsp;\".$Projektdaten_11.\" \".$Projektdaten_19.\"<br>\".
        \"&nbsp;&nbsp;\".$Projektdaten_12.\" \".$Projektdaten_13.\"<br>\".
        \"&nbsp;&nbsp;\".$Projektdaten_14;
} else if ($Projektdaten_17 == \"2\") {
    $txtQuest = \'Sie führen ein bezahltes Interview durch.<br>\'.
        \'Tragen Sie am Interviewende die korrekte Adresse ein.<br>\'.
        \'Nicht den Vorgaben entsprechende Interviews,<br>\'.
        \'können nicht berücksichtigt werden\';
} else if ($Projektdaten_17 == \"3\") {
    $txtQuest = \'Sie führen eines von max. 4 bezahlten Einsteigerinterviews durch<br>\'.
        \'Tragen Sie am Interviewende die korrekte Adresse ein\';
} else {
    $txtQuest = \'Sie führen ein unbezahltes Testinterview durch<br>\';
}

$txtchck = sprintf(\'user_id,Projektdaten_4\');
$checkvar = getVar($txtchck);
$allvars = $txtchck;
    foreach (explode(\",\",$allvars) as $itemvar) {
           $$itemvar = $checkvar[$itemvar] ;
    }

$i_cmplts = getVarFromTable($_SESSION[\'projname\'].\"_structure\", \"Projektdaten_4,Projektdaten_5,Projektdaten_17,AGE_1,SEX\",
    \"WHERE user_id =\".$user_id.
    \" and Projektdaten_4 = \'\".$Projektdaten_4.\"\'\".
    \" and flag_bad = 1\");

echo \"<pre>\";
//var_dump($i_cmplts);
echo \"</pre>\";
$lfdsInLinr = array();
$count_linr = 0;
$cmplt_linr = 0;
$count_him = 0;
$count_her = 0;
$count_young = 0;
$count_old = 0;
if(count($i_cmplts)) {
    foreach ($i_cmplts as $key => $value) {
        if(!in_array($value[\"Projektdaten_5\"],$lfdsInLinr)) {
           $cmplt_linr++;
           $lfdsInLinr[] = $value[\"Projektdaten_5\"];
               if ($value[\"Projektdaten_17\"] == \"2\" || $value[\"Projektdaten_17\"] == \"0\") {
                   if($value[\"SEX\"] == \"1\") {
                       $count_him++;
                   } else if ($value[\"SEX\"] == \"2\") {
                       $count_her++;
                   }
                   if($value[\"AGE_1\"] > 15 && $value[\"AGE_1\"] <= 45) {
                       $count_young ++;
                   } else if ($value[\"AGE_1\"] >= 46 || $value[\"AGE_1\"] <= 99) {
                       $count_old ++;
                   }
            }
        }
    }
}

$txtQuest .= \"<br><br>Sie bearbeiten aktuell folgende Liste \".$Projektdaten_4.\":<br>\".
   \"&nbsp;&nbsp;\".\"Darauf wurden bereits \".$cmplt_linr.\" Interview(s) durchgeführt.\";
//$txtQuest .= \"<br>&nbsp;&nbsp;Insgesamt \".$count_linr.\" Adressen sind bereits abgeschlossen.\";
if ($Projektdaten_17 == 2 || ($Projektdaten_17 == 0 && $i_userid == 135)) {
    $txtQuest .= \"<br><br>Alter und Geschlechtsverteilung:<br>&nbsp;&nbsp;\";
    if ($count_him > $count_her+1) $txtQuest .= \'<font color=\"red\">\';
    $txtQuest .=$count_him.\" Männer<br>&nbsp;&nbsp;\";
    if ($count_him > $count_her+1) $txtQuest .= \"</font>\";
    if ($count_her> $count_him +1) $txtQuest .= \'<font color=\"red\">\';
    $txtQuest .=$count_her.\" Frauen<br>&nbsp;&nbsp;\";
    if ($count_her> $count_him +1) $txtQuest .= \"</font>\";
    if ($count_young> $count_old+1) $txtQuest .= \'<font color=\"red\">\';
    $txtQuest .=$count_young.\" unter 45<br>&nbsp;&nbsp;\";
    if ($count_young> $count_old+1) $txtQuest .= \"</font>\";
    if ($count_old> $count_young+1) $txtQuest .= \'<font color=\"red\">\';
    $txtQuest .=$count_old.\" 45 oder älter<br>\";
    if ($count_old> $count_young+1) $txtQuest .= \"</font>\";
}
    $txtQuest .= \"<br>\";

saveVar(\"questtext_1=\'\".$txtQuest.\"\'\");
';
<stat>INSERT INTO HFCS00_Base_script SET id_question = '15',id_event = '2',script = '$txtchck = sprintf(\'user_id,Projektdaten_2,Projektdaten_4,Projektdaten_5\');
$checkvar = getVar($txtchck);
$allvars = $txtchck;
    foreach (explode(\",\",$allvars) as $itemvar) {
           $$itemvar = $checkvar[$itemvar] ;
    }
$i_userid = reset(getVar(\"user_id\"));
$i_projectid = $_SESSION[\"id_project\"];
if ($i_userid==0) {
    $i_projectid = 309; //Test MTU 2.HJ 2017
    $i_userid = 57; // 135 test, 57 Boden
    $Projektdaten_4 = 820919;
    }

if ($user_id == 0) {$visitsTable = \"_Capi_interviewer_visits\"; } else {$visitsTable = \"_capi_interviewer_visits\"; }
if ($user_id == 0) {$ProjectsTable = \"_Projects\"; } else {$ProjectsTable = \"_projects\"; }
if ($user_id == 0) {$AddressTables = \"_CapiTables\"; } else {$AddressTables = \"_capitables\"; }

$i_tableIds = getVarFromTable($ProjectsTable, \"proj_name,naziv_proj,id_capiTable\", \"WHERE id = \".$i_projectid);
$i_AddressTableInfo = getVarFromTable($AddressTables, \"name\", \"WHERE id = \".$i_tableIds[0][\"id_capiTable\"]);

$s_projname = $_SESSION[\"proj_name\"];
$s_structure = $s_projname.\"_structure\";
$s_sample = $s_projname.\"___sample\";
$s_address = \"capi___\".$i_AddressTableInfo[0][\"name\"];
/*
echo \"<pre>\";
//var_dump($_SESSION);
echo \'$i_userid:\'.$i_userid.\"<br>\";
echo \'$i_projectid:\'.$i_projectid.\"<br>\";
echo \'$s_projname:\'.$s_projname.\"<br>\";
echo \'$user_id:\'.$user_id.\"<br>\";
echo \'$Projektdaten_2:\'.$Projektdaten_2.\"<br>\";
echo \'$Projektdaten_4:\'.$Projektdaten_4.\"-\".$Projektdaten_5.\"<br>\";
echo \"</pre>\";
*/
$i_address = getVarFromTable($s_address, \"id,municipality,id_settlement,name\",
    \"WHERE id_municipality= \".$Projektdaten_2.
    \" and municipality= \".$Projektdaten_4);

$questtxt = \"<table  align=\'left\' style=\'text-align: center;font-size:70%;\'>
    <tr><th>Listennummer: \".$Projektdaten_4.\"</th></tr>\";
$questtxt .=\"
    <tr><th style=\'padding-left: 15px;padding-right: 15px;\'>LfdNr.</th>
    <th style=\'padding-left: 15px;padding-right: 15px;\'>Name.</th>
    <th style=\'padding-left: 15px;padding-right: 15px;\'>Anzahl Kontakte</th>
    <th style=\'padding-left: 15px;padding-right: 15px;\'>letzter Kontakt</th></tr>\";

foreach ($i_address as $adresse) {
    //var_dump($kontakt);
    if ($user_id == 0) {$s_sample = \"p27293105___sample\"; } // TEST
    $i_sample = getVarFromTable($s_sample, \"id,user_id\",
        \"WHERE id_sample= \".$adresse[\"id\"]);
    $i_contacts = getVarFromTable($visitsTable, \"sample_point,cas_obiska,status_obiska,id_structure,user_id\",
    \"WHERE user_id =\".$i_userid.
    \" and id_project = \".$i_projectid.
     \" and sample_point = \".$i_sample[0][\"id\"]);
if ($i_sample[0][\"user_id\"] == $user_id || $user_id == 0 ) {
$questtxt .= \"<tr><td>\".$adresse[\"id_settlement\"] .\"</td><td style=\'text-align: left;\'>\"
          . $adresse[\"name\"].\"</td>\";
  
    if ($i_contacts) {
       $i_count_con = 0;
        foreach ($i_contacts as $Kontakt) {
            $i_count_con ++;
            switch($Kontakt[status_obiska]) {
                case 1:
                    $kontxt = \"Interview abgeschlossen\";
                    break;
                case 9:
                    $kontxt = \"Interview unterbrochen\";
                    break;
                case 21:
                    $kontxt = \"Niemand erreicht/angetroffen\";
                    break;
                case 22:
                    $kontxt = \"Rückruf\";
                    break;
                case 8:
                    $kontxt = \"Terminvereinbarung\";
                    break;
                case 23:
                    $kontxt = \"Verweigerung bei 1.Kontakt\";
                    break;
                case 24:
                    $kontxt = \"Verweigerung\";
                    break;
                case 31:
                    $kontxt = \"kritische Verweigerung\";
                    break;
                case 32:
                    $kontxt = \"keine geeignete ZP\";
                    break;
                case 33:
                    $kontxt = \"Adresse unauffindbar\";
                    break;
                case 34:
                    $kontxt = \"ungültige Adresse\";
                    break;
                case 35:
                    $kontxt = \"Adresse unbearbeitet abgelegt\";
                    break;
                default:                    
                    $kontxt = \"unbekannt\";
                }
         }
$questtxt .= \"<td>\".$i_count_con.\"</td><td>\".$kontxt.\"</td>\";        
    }
$questtxt .= \"</tr>\";
    }

 }

$questtxt .= \"</table>\";

saveVar(\"questtext_1=\'\".$txtQuest.\"\'\");


';
<stat>INSERT INTO HFCS00_Base_script SET id_question = '16',id_event = '1',script = 'saveVar(\"questtext_1=NULL\");';
<stat>INSERT INTO HFCS00_Base_script SET id_question = '18',id_event = '1',script = '$txtchck = sprintf(\'Projektdaten_6,Projektdaten_9,Projektdaten_10,Projektdaten_11,Projektdaten_12,Projektdaten_13,Projektdaten_14,Projektdaten_16,Projektdaten_19,kondata_5\');
    $checkvar = getVar($txtchck);
    $allvars = $txtchck;
    foreach (explode(\",\",$allvars) as $itemvar) {
           $$itemvar = $checkvar[$itemvar] ;
    }
if ($Projektdaten_16 <> \'ver\' && ($Projektdaten_17 == 1 || $Projektdaten_17 == 0)) {
    saveVar(sprintf(\'kondata_1=\"%s\"\',$Projektdaten_9));
    saveVar(sprintf(\'kondata_2=\"%s\"\',$Projektdaten_12));
    saveVar(sprintf(\'kondata_3=\"%s\"\',$Projektdaten_11));
    saveVar(sprintf(\'kondata_4=\"%s\"\',$Projektdaten_19));
    saveVar(sprintf(\'kondata_5=\"%s\"\',$Projektdaten_13));
    saveVar(sprintf(\'kondata_6=\"%s\"\',$Projektdaten_14));
}

saveVar(\"Projektdaten_16=\'ver\'\");

$bld = $Projektdaten_6;
$bldstat = array(\"ges\",8,7,5,4,2,6,1,3,9);
/*
if ($Projektdaten_6 != \"\" and $Projektdaten_11 != \"\" and $Projektdaten_12 != \"\") {
    $plz = $Projektdaten_12;
    $table = \"strassen_ges\";
    $filter = \"WHERE `Straßenname` = \'\".$Projektdaten_11.\"\' and Postleitzahl = \".$plz.\" and bld = \".$bldstat[$bld];
    
    $Variable = getVarFromTable( $table , \"id\", $filter);

    if (isset($Variable[0][\"id\"])) {
        $id_street = $Variable[0][\"id\"];
    } else {
         $id_street = 0;
    }
}
*/
if ($Projektdaten_17 == 1 || $Projektdaten_17 == 0) {
    $id_street = 0;
}
if ($Projektdaten_11== \"Blumenweg\" and $Projektdaten_12 == 1811) {
     $id_street = 999999;
    }
/*
if ($kontakt[\"kondata_5\"] == null) {
    saveVar(\"kondata_3=\".$Projektdaten_12); //PLZ
    saveVar(\"kondata_4=\'\".$Projektdaten_11.\"\'\"); // Straße
    saveVar(\"kondata_5=\'\".$Projektdaten_19.\"\'\"); // Straße_Zusatz
    saveVar(\"kondata_6=\'\".$Projektdaten_13.\"\'\"); // Ort
    saveVar(\"kondata_9=\".$id_street); // idStreet
}
*/
$projname = $_SESSION[\"projname\"];
$questname = \"strasse\";
//echo \'<input id=plzID type=\"hidden\" name=\"forStreet\" value=\"\'.$plz.\'\">\';
echo \'<input id=bldID type=\"hidden\" name=\"forStreet\" value=\"\'.$bld.\'\">\';
echo \'<input id=frageID type=\"hidden\" name=\"forStreet\" value=\"\'.$questname.\'\">\';

';
<stat>INSERT INTO HFCS00_Base_script SET id_question = '18',id_event = '3',script = 'document.getElementById(\"ct_kondata_8\").style.display=\"none\";
$(function() {
    var tbID = $(\"#ct_kondata_8\"),
        tbStrn = $(\"#ct_kondata_3\"),
        plz = $(\"#ct_kondata_2\"),
        ort = $(\"#ct_kondata_5\"),
        bld = $(\"#bldID\"),
        frage = $(\"#frageID\");
    tbStrn.autocomplete({
        minLength: 3,
        source: function(request, response) {
            $.ajax({
                url: \"../../webProjects/lookups/lookup_street.php\",
                dataType: \"json\",
                data: {
                    query: request.term,
                    bld: bld.val(),
                    plz: plz.val()
                },
                success: function(data) {
                    response(data);
                }
            });
        },
        focus: function(event, ui) {
            tbID.val(ui.item.value);
            return false;
        },
        select: function(event, ui) {
            tbID.val(ui.item.value);
            tbStrn.val(ui.item.str_ret);
            plz.val(ui.item.plz_ret);
            ort.val(ui.item.ort_ret);
            return false;
        }
    });
    
    var found = $.grep(data, function(element) {
        return (element.value == tbID.val());
    });

    if (found.length > 0) {
//        tbStrn.parent().prev().html(\"Straßenname: \" + found[0].label);
        tbStrn.parent().prev().html(\"<p id=\\\"strassenname\\\">Bitte nach Straßenname suchen...</p>\");
    } else {
        tbStrn.parent().prev().html(\"<p id=\\\"strassenname\\\">Bitte nach Straßenname suchen...<br>\"+
                                    \"Geben Sie zumindest drei Buchstaben des Straßennames ein um die Suche zu starten</p>\");
    }
});';
<stat>INSERT INTO HFCS00_Base_script SET id_question = '21',id_event = '1',script = '
$i_userid = reset(getVar(\"user_id\"));
$i_info = getVarFromTable(\"_Interviewer\", \"username\", \"WHERE id = $i_userid\");

if (count($i_info) == 1)
    saveVar(\"intnr_1=\'\" . $i_info[0][\"username\"] . \"\'\");';
<stat>INSERT INTO HFCS00_Base_script SET id_question = '24',id_event = '1',script = '$txtchck = sprintf(\'verng2,verng2_opn,intnr_1\');
    $checkvar = getVar($txtchck);
    $allvars = $txtchck;
        foreach (explode(\",\",$allvars) as $itemvar) {
               $$itemvar = $checkvar[$itemvar] ;
        }
if ($verng2 == 2) {
    
        saveVar(sprintf(\'vernr_1=\"%s\"\',$verng2_opn));
    
    } else {
 
       saveVar(sprintf(\'vernr_1=\"%s\"\',$intnr_1));       
        
        }
';
<stat>INSERT INTO HFCS00_Base_script SET id_question = '31',id_event = '1',script = '
';
<stat>INSERT INTO HFCS00_Base_script SET id_question = '31',id_event = '3',script = '    $(\'[name=\"questSubmit\"]\').attr(\'disabled\',\'disabled\');
    //$(\'[name=\"questBack\"]\').attr(\'disabled\',\'disabled\');

';
<stat>INSERT INTO HFCS00_Base_script SET id_question = '31',id_event = '2',script = '
getQuestData();


';
<stat>INSERT INTO HFCS00_Base_script SET id_question = '0',id_event = '3',script = 'setCustomDesignerText(\'custDrop\', \'Custom Option\');
setCustomDesignerText(\'custTitle\', \'HFCS 2020\');';
<stat>INSERT INTO HFCS00_Base_script SET id_question = '14',id_event = '1',script = 'echo \"TEST\";';
<stat>INSERT INTO HFCS00_Base_script SET id_question = '13',id_event = '1',script = 'echo \"<br><br><br><br><br><pre>\";
$arr = get_defined_functions();
//if(in_array(\"getVar\",$arr[\"user\"])) echo \"getVar gefunden<br>\";
//if(in_array(\"get_quest_text\",$arr[\"user\"])) echo \"get_quest_text gefunden<br>\";
//var_dump($arr[\"user\"][\"get_quest_text\"]);
echo \"</pre>\";
';
<stat>INSERT INTO HFCS00_Base_tree SET id = '5',id_sup = '0',id_question = '0',orderBy = '1',idLab = 'DUMMY',node_img = '',is_leaf = '0',showTogether = '0';
<stat>INSERT INTO HFCS00_Base_tree SET id = '6',id_sup = '0',id_question = '0',orderBy = '2',idLab = 'START',node_img = '',is_leaf = '0',showTogether = '0';
<stat>INSERT INTO HFCS00_Base_tree SET id = '7',id_sup = '0',id_question = '0',orderBy = '6',idLab = 'VER',node_img = '',is_leaf = '0',showTogether = '0';
<stat>INSERT INTO HFCS00_Base_tree SET id = '8',id_sup = '0',id_question = '0',orderBy = '7',idLab = 'END',node_img = '',is_leaf = '0',showTogether = '0';
<stat>INSERT INTO HFCS00_Base_tree SET id = '10',id_sup = '5',id_question = '10',orderBy = '3',idLab = 'questtext',node_img = '',is_leaf = '1',showTogether = '0';
<stat>INSERT INTO HFCS00_Base_tree SET id = '11',id_sup = '5',id_question = '11',orderBy = '1',idLab = 'Projektdaten',node_img = '',is_leaf = '1',showTogether = '0';
<stat>INSERT INTO HFCS00_Base_tree SET id = '13',id_sup = '6',id_question = '13',orderBy = '1',idLab = 'TEST',node_img = '',is_leaf = '1',showTogether = '0';
<stat>INSERT INTO HFCS00_Base_tree SET id = '18',id_sup = '7',id_question = '18',orderBy = '1',idLab = 'kondata',node_img = '',is_leaf = '1',showTogether = '0';
<stat>INSERT INTO HFCS00_Base_tree SET id = '19',id_sup = '7',id_question = '19',orderBy = '2',idLab = 'streetname',node_img = '',is_leaf = '1',showTogether = '0';
<stat>INSERT INTO HFCS00_Base_tree SET id = '20',id_sup = '7',id_question = '20',orderBy = '3',idLab = 'vernr',node_img = '',is_leaf = '1',showTogether = '0';
<stat>INSERT INTO HFCS00_Base_tree SET id = '21',id_sup = '7',id_question = '21',orderBy = '4',idLab = 'intnr',node_img = '',is_leaf = '1',showTogether = '0';
<stat>INSERT INTO HFCS00_Base_tree SET id = '22',id_sup = '7',id_question = '22',orderBy = '5',idLab = 'verng2',node_img = '',is_leaf = '1',showTogether = '0';
<stat>INSERT INTO HFCS00_Base_tree SET id = '23',id_sup = '7',id_question = '23',orderBy = '6',idLab = 'verende',node_img = '',is_leaf = '1',showTogether = '0';
<stat>INSERT INTO HFCS00_Base_tree SET id = '24',id_sup = '7',id_question = '24',orderBy = '7',idLab = 'verng1',node_img = '',is_leaf = '1',showTogether = '0';
<stat>INSERT INTO HFCS00_Base_tree SET id = '25',id_sup = '8',id_question = '25',orderBy = '1',idLab = 'BREAK',node_img = '',is_leaf = '1',showTogether = '0';
<stat>INSERT INTO HFCS00_Base_tree SET id = '26',id_sup = '8',id_question = '26',orderBy = '2',idLab = 'ENDIV',node_img = '',is_leaf = '1',showTogether = '0';
<stat>INSERT INTO HFCS00_Base_tree SET id = '27',id_sup = '8',id_question = '27',orderBy = '3',idLab = 'fbende',node_img = '',is_leaf = '1',showTogether = '0';
<stat>INSERT INTO HFCS00_Base_tree SET id = '28',id_sup = '0',id_question = '28',orderBy = '3',idLab = 'timevdbstart',node_img = '',is_leaf = '1',showTogether = '0';
<stat>INSERT INTO HFCS00_Base_tree SET id = '29',id_sup = '0',id_question = '29',orderBy = '5',idLab = 'timevdbend',node_img = '',is_leaf = '1',showTogether = '0';
<stat>INSERT INTO HFCS00_Base_tree SET id = '30',id_sup = '0',id_question = '0',orderBy = '4',idLab = 'FRABO',node_img = '',is_leaf = '0',showTogether = '0';
<stat>INSERT INTO HFCS00_Base_tree SET id = '31',id_sup = '30',id_question = '31',orderBy = '1',idLab = 'switch1',node_img = '',is_leaf = '1',showTogether = '0';
<stat>INSERT INTO HFCS00_Base_tree SET id = '32',id_sup = '5',id_question = '32',orderBy = '2',idLab = 'links',node_img = '',is_leaf = '1',showTogether = '0';