
<stat>DROP TABLE IF EXISTS p98049023ver; 
<stat>DROP TABLE IF EXISTS p98049023ver_language; 
<stat>DROP TABLE IF EXISTS p98049023ver_script; 
<stat>DROP TABLE IF EXISTS p98049023ver_tree; 
<stat>CREATE TABLE `p98049023ver` (
  `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=27 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 
<stat>CREATE TABLE `p98049023ver_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=37 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 
<stat>CREATE TABLE `p98049023ver_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 `p98049023ver_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=27 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
<stat>INSERT INTO p98049023ver 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 = '0',email_app_template = '0',encrypt = '0',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 = '0',show_as_single_autosubmit = '0',show_as_single_autosubmit_delay = '200',input_position = '1',after_text = '',answer_click_animation = '0',answer_click_element = '0',answer_click_animation_duration = '1000';
<stat>INSERT INTO p98049023ver 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 = '0',email_app_template = '0',encrypt = '0',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 = '0',show_as_single_autosubmit = '0',show_as_single_autosubmit_delay = '200',input_position = '1',after_text = '',answer_click_animation = '0',answer_click_element = '0',answer_click_animation_duration = '1000';
<stat>INSERT INTO p98049023ver 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 = '0',email_app_template = '0',encrypt = '0',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 = '0',show_as_single_autosubmit = '0',show_as_single_autosubmit_delay = '200',input_position = '1',after_text = '',answer_click_animation = '0',answer_click_element = '0',answer_click_animation_duration = '1000';
<stat>INSERT INTO p98049023ver 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 = '0',email_app_template = '0',encrypt = '0',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 = '0',show_as_single_autosubmit = '0',show_as_single_autosubmit_delay = '200',input_position = '1',after_text = '',answer_click_animation = '0',answer_click_element = '0',answer_click_animation_duration = '1000';
<stat>INSERT INTO p98049023ver SET id = '14',q_pos = '3',q_name = 'kmanr',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 = 'S00',id_style = '0',id_mask = '0',must_answer = '1',disable_question = '0',answers_filter = '0',variableTypeBase = '4',variableTypeOpen = '4',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 = '10',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 = '0',email_app_template = '0',encrypt = '0',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 = '0',show_as_single_autosubmit = '0',show_as_single_autosubmit_delay = '200',input_position = '1',after_text = '',answer_click_animation = '0',answer_click_element = '0',answer_click_animation_duration = '1000';
<stat>INSERT INTO p98049023ver SET id = '18',q_pos = '4',q_name = 'f0',tip_sql = '4',drg_sql = '',les_sql = '3',goto_sql = '',fil_sql = '',con_sql = '$f0_1 >= 10000 and $f0_1 <= 99999',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 = 'S00',id_style = '0',id_mask = '0',must_answer = '1',disable_question = '0',answers_filter = '0',variableTypeBase = '4',variableTypeOpen = '4',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 = '15',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 = '0',email_app_template = '0',encrypt = '0',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 = '0',show_as_single_autosubmit = '0',show_as_single_autosubmit_delay = '200',input_position = '1',after_text = '',answer_click_animation = '0',answer_click_element = '0',answer_click_animation_duration = '1000';
<stat>INSERT INTO p98049023ver SET id = '19',q_pos = '5',q_name = 'f1',tip_sql = '4',drg_sql = '',les_sql = '3',goto_sql = '',fil_sql = '',con_sql = '$f1_1 >= 0 and $f1_1 <= 999',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 = 'S00',id_style = '0',id_mask = '0',must_answer = '1',disable_question = '1',answers_filter = '0',variableTypeBase = '4',variableTypeOpen = '4',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 = '1',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 = '0',email_app_template = '0',encrypt = '0',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 = '0',show_as_single_autosubmit = '0',show_as_single_autosubmit_delay = '200',input_position = '1',after_text = '',answer_click_animation = '0',answer_click_element = '0',answer_click_animation_duration = '1000';
<stat>INSERT INTO p98049023ver SET id = '20',q_pos = '6',q_name = 'f1a',tip_sql = '1',drg_sql = '',les_sql = '1',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 = 'S00',id_style = '0',id_mask = '0',must_answer = '1',disable_question = '1',answers_filter = '0',variableTypeBase = '4',variableTypeOpen = '0',open_answers = '4',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<|><|>',legendGroups = '',id_plugin = '0',id_incentive = '0',incentive_possibilites = '0',allow_listening = '0',old_id = '22',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 = '0',email_app_template = '0',encrypt = '0',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 = '0',show_as_single_autosubmit = '0',show_as_single_autosubmit_delay = '200',input_position = '1',after_text = '',answer_click_animation = '0',answer_click_element = '0',answer_click_animation_duration = '1000';
<stat>INSERT INTO p98049023ver SET id = '21',q_pos = '7',q_name = 'f2',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 = 'S00',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 = '8',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 = '0',email_app_template = '0',encrypt = '0',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 = '0',show_as_single_autosubmit = '0',show_as_single_autosubmit_delay = '200',input_position = '1',after_text = '',answer_click_animation = '0',answer_click_element = '0',answer_click_animation_duration = '1000';
<stat>INSERT INTO p98049023ver SET id = '22',q_pos = '8',q_name = 'warn',tip_sql = '1',drg_sql = '',les_sql = '1',goto_sql = '',fil_sql = '$f2 == 2',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 = 'S00',id_style = '0',id_mask = '0',must_answer = '0',disable_question = '0',answers_filter = '0',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 = '',legendGroups = '',id_plugin = '0',id_incentive = '0',incentive_possibilites = '0',allow_listening = '0',old_id = '20',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 = '0',email_app_template = '0',encrypt = '0',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 = '0',show_as_single_autosubmit = '0',show_as_single_autosubmit_delay = '200',input_position = '1',after_text = '',answer_click_animation = '0',answer_click_element = '0',answer_click_animation_duration = '1000';
<stat>INSERT INTO p98049023ver SET id = '23',q_pos = '9',q_name = 'ende',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 = 'S00',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 = '7',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 = '0',email_app_template = '0',encrypt = '0',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 = '0',show_as_single_autosubmit = '0',show_as_single_autosubmit_delay = '200',input_position = '1',after_text = '',answer_click_animation = '0',answer_click_element = '0',answer_click_animation_duration = '1000';
<stat>INSERT INTO p98049023ver SET id = '24',q_pos = '2',q_name = 'kon',tip_sql = '4',drg_sql = '',les_sql = '3',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 = '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 = '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 = '0',email_app_template = '0',encrypt = '0',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 = '0',show_as_single_autosubmit = '0',show_as_single_autosubmit_delay = '200',input_position = '1',after_text = '',answer_click_animation = '0',answer_click_element = '0',answer_click_animation_duration = '1000';
<stat>INSERT INTO p98049023ver SET id = '25',q_pos = '1',q_name = 'Projektdaten',tip_sql = '4',drg_sql = '',les_sql = '3',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 = '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,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 = '0',email_app_template = '0',encrypt = '0',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 = '0',show_as_single_autosubmit = '0',show_as_single_autosubmit_delay = '200',input_position = '1',after_text = '',answer_click_animation = '0',answer_click_element = '0',answer_click_animation_duration = '1000';
<stat>INSERT INTO p98049023ver SET id = '26',q_pos = '-3',q_name = '_Repeal',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 = '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 = '0',email_app_template = '0',encrypt = '0',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 = '0',show_as_single_autosubmit = '0',show_as_single_autosubmit_delay = '200',input_position = '1',after_text = '',answer_click_animation = '0',answer_click_element = '0',answer_click_animation_duration = '1000';
<stat>INSERT INTO p98049023ver_language SET id = '1',id_language = '60',id_question = '1',id_text_type = '2',lngText = 'SHARE Verrechnung<br>';
<stat>INSERT INTO p98049023ver_language SET id = '2',id_language = '60',id_question = '2',id_text_type = '2',lngText = 'Verrechnung abgeschlossen<br>';
<stat>INSERT INTO p98049023ver_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 p98049023ver_language SET id = '4',id_language = '60',id_question = '4',id_text_type = '2',lngText = 'This survey is not active!';
<stat>INSERT INTO p98049023ver_language SET id = '15',id_language = '60',id_question = '14',id_text_type = '2',lngText = 'anrechenbare Kilometer';
<stat>INSERT INTO p98049023ver_language SET id = '19',id_language = '60',id_question = '18',id_text_type = '1',lngText = 'Bei Unstimmigkeiten oder Problemen wenden sie sich bitte an share.verrechnung@ifes.at';
<stat>INSERT INTO p98049023ver_language SET id = '20',id_language = '60',id_question = '18',id_text_type = '2',lngText = 'HHID: $kon_2<br>RESP-ID: $kon_1<br>
Respondent: $kon_3 $kon_4<br><br>

Adresse: $kon_5 $kon_6<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $kon_7 $kon_8<br><br>
Geboren: $kon_9<br><br>

Tel1: $kon_10<br>
Tel2: $kon_11<br><br>

Auf welche Interviewernummer soll dieses Interview verrechnet werden?';
<stat>INSERT INTO p98049023ver_language SET id = '21',id_language = '60',id_question = '19',id_text_type = '2',lngText = 'Bitte tragen sie die km für die einfache Fahrstrecke von zu Hause zu diesem Haushalt ein.';
<stat>INSERT INTO p98049023ver_language SET id = '22',id_language = '60',id_question = '20',id_text_type = '2',lngText = 'Wieviele Gutscheine hat der Respondent erhalten?';
<stat>INSERT INTO p98049023ver_language SET id = '23',id_language = '60',id_question = '20',id_text_type = '3',lngText = '1 keine/2 € 12,-/3 € 17,-/5 € 10,-/7 € 15,-/4 anderes:';
<stat>INSERT INTO p98049023ver_language SET id = '24',id_language = '60',id_question = '21',id_text_type = '2',lngText = 'HHID: $kon_2<br>RESP-ID: $kon_1<br>
Respondent: $kon_3 $kon_4<br><br>

Adresse: $kon_5 $kon_6<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $kon_7 $kon_8<br><br>
Geboren: $kon_9<br><br>

Tel1: $kon_10<br>
Tel2: $kon_11<br><br>

Interview wird verrechnet auf: <font color=\"red\">$f0_1</font> <br><br>

einfache Entfernung: $f1_1<br><br>

Honorar: € $kon_12<br><div><br></div><div>Sind diese Daten korrekt?</div><div><br></div><div>(Diese Angaben zur Verrechnung dienen nur zur Information. Die finale Berechnung erfolgt nach Abgleich dieses Verrechnungsinterviews und der internen Prüfung des SHARE Interviews)<br></div>';
<stat>INSERT INTO p98049023ver_language SET id = '25',id_language = '60',id_question = '21',id_text_type = '3',lngText = '1 ja/2 nein';
<stat>INSERT INTO p98049023ver_language SET id = '26',id_language = '60',id_question = '22',id_text_type = '2',lngText = 'Bitte schicken Sie eine Mail mit der HaushaltsID und den Unstimmigkeiten an share@ifes.at ';
<stat>INSERT INTO p98049023ver_language SET id = '27',id_language = '60',id_question = '22',id_text_type = '3',lngText = '1 weiter';
<stat>INSERT INTO p98049023ver_language SET id = '28',id_language = '60',id_question = '23',id_text_type = '2',lngText = '<span style=background-color:#FFCC00>**INT: ACHTUNG: WENN SIE JETZT WEITERGEHEN KÖNNEN SIE NICHT MEHR ZURÜCK**</span>';
<stat>INSERT INTO p98049023ver_language SET id = '29',id_language = '60',id_question = '23',id_text_type = '3',lngText = '1 Interview endgültig abschliessen.';
<stat>INSERT INTO p98049023ver_language SET id = '30',id_language = '60',id_question = '24',id_text_type = '2',lngText = 'Kontakdaten';
<stat>INSERT INTO p98049023ver_language SET id = '31',id_language = '60',id_question = '24',id_text_type = '3',lngText = '1 respid/2 hhid/3 vorname/4 nachname/5 adresse/6 hnr/7 plz/8 ort/9 gebdat/10 tel1/11 tel2/12 honorar/13 primresp';
<stat>INSERT INTO p98049023ver_language SET id = '32',id_language = '60',id_question = '24',id_text_type = '8',lngText = '0,0,0,0,0,0,0,0,0,0,0,0<|><|>';
<stat>INSERT INTO p98049023ver_language SET id = '33',id_language = '60',id_question = '25',id_text_type = '2',lngText = 'Projekt';
<stat>INSERT INTO p98049023ver_language SET id = '34',id_language = '60',id_question = '25',id_text_type = '3',lngText = '1 Projektname/2 Fraboname/3 Verrechnungsnummer/4 Listennummer/5 Lfd Nummer/6 Bundesland/7 Politischer Bezirk/8 Größenklasse/9 Name/10 Vorname/11 Adresse/12 PLZ/13 Ort/14 Telefonnummer/15 Version/16 Kontrollvariable/17 17/18 18/19 Interviewernummer';
<stat>INSERT INTO p98049023ver_language SET id = '35',id_language = '60',id_question = '25',id_text_type = '8',lngText = '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0<|><|>';
<stat>INSERT INTO p98049023ver_language SET id = '36',id_language = '60',id_question = '20',id_text_type = '8',lngText = '0,0,0,0,0,0<|><|>';
<stat>INSERT INTO p98049023ver_script SET id_question = '21',id_event = '1',script = '    $txtchck = sprintf(\'f1_1,kon_13\');
    $checkvar = getVar($txtchck);
    $allvars = $txtchck;

foreach (explode(\",\",$allvars) as $itemvar) {
               $$itemvar = $checkvar[$itemvar] ;
        }

if ($f1_1 < 10) {$f1_1 = 10;}
if ($f1_1 > 100) {$f1_1 = 100;}

if ($kon_13 > 0)
{
    $kmanr = ($f1_1 / 1.5) + 24;
}
else
{
    $kmanr = ($f1_1 / 3) + 12;
}

saveVar(\"kmanr_1=\" . $kmanr);
';
<stat>INSERT INTO p98049023ver_script SET id_question = '25',id_event = '1',script = '$i_table_id = reset(getVar(\"id_capi_table\"));
$i_address_id = reset(getVar(\"id_capi_address\"));
$i_sample_id = reset(getVar(\"id_capi_sample\"));

 //1 Projektname
            saveVar(\'Projektdaten_1=\"SHARE IX Verrechnung\"\');
            //saveVar(\"Projektdaten_1=\'\". $i_address[0][\"capi_hhid\"] . \"\'\");
//3 Verrechnungsnummer
            saveVar(\'Projektdaten_3=\"98049022\"\');
            //saveVar(\"Projektdaten_3=\'\". $i_address[0][\"capi_hhidf2\"] . \"\'\");
//15 Version
            saveVar(\'Projektdaten_15=\"1.0.0\"\');
            //saveVar(\"Projektdaten_15=\'\". $i_address[0][\"capi_adrnrb2\"]. \"\'\");   


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, name, street, zip, town, capi_vorwahl, capi_tel1, capi_tel2\", \"WHERE id = \".$i_address_id);
        $i_address = getVarFromTable($i_sample_table, \"id_municipality, municipality, id_settlement, id_street, 
                                     capi_BL, capi_tel1, capi_tel2, capi_idsample, capi_respid, capi_hhid, 
                                     capi_gebdat, capi_honorar, capi_primresp, capi_vorname, capi_nachname, capi_intein, 
                                     name, street, zip, town, address\", \"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\"] . \"\'\");
            saveVar(\"kon_1=\'\". $i_address[0][\"municipality\"] . \"\'\");            
            saveVar(\"kon_2=\'\". $i_address[0][\"capi_hhid\"] . \"\'\");            
//5 Sample Typ 1 = Refresher;2 = Panel
            saveVar(\"Projektdaten_5=\'\". $i_address[0][\"address\"] . \"\'\");
            //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(\"kon_3=\'\". $i_address[0][\"capi_vorname\"]. \"\'\");        
            saveVar(\"kon_4=\'\". $i_address[0][\"capi_nachname\"]. \"\'\");        
//11 Adresse
            saveVar(\"Projektdaten_11=\'\". $i_address[0][\"street\"]. \"\'\");
            saveVar(\"kon_5=\'\". $i_address[0][\"street\"]. \"\'\");
//12 PLZ
            saveVar(\"Projektdaten_12=\'\". $i_address[0][\"zip\"]. \"\'\");            
            saveVar(\"kon_7=\'\". $i_address[0][\"zip\"]. \"\'\");            
//13 Ort
            saveVar(\"Projektdaten_13=\'\". $i_address[0][\"town\"]. \"\'\");            
            saveVar(\"kon_8=\'\". $i_address[0][\"town\"]. \"\'\");            
//14 Telefonnummer
            saveVar(\"kon_10=\'\". $i_address[0][\"capi_tel1\"]. \"\'\");            
            saveVar(\"kon_11=\'\". $i_address[0][\"capi_tel2\"]. \"\'\");            
//16 Kontrollvariable
            //saveVar(\"Projektdaten_16=\'ver\'\");  wir für die Kontaktdaten gesetzt
//17 17
           saveVar(\"Projektdaten_17=\'\". $i_address[0][\"id_street\"] . \"\'\");      
//18 18
//19 19
        
        
           saveVar(\"kon_9=\'\". $i_address[0][\"capi_gebdat\"] . \"\'\");      
           saveVar(\"kon_12=\'\". $i_address[0][\"capi_honorar\"] . \"\'\");      
           saveVar(\"kon_13=\'\". $i_address[0][\"capi_primresp\"] . \"\'\");      
           saveVar(\"f0_1=\'\". $i_address[0][\"capi_intein\"] . \"\'\");      
        
        }}}           

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

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







';
<stat>INSERT INTO p98049023ver_script SET id_question = '0',id_event = '3',script = 'setCustomDesignerText(\'custTitle\',\'SHARE IX Main CATI - Verrechnung\');';
<stat>INSERT INTO p98049023ver_tree SET id = '14',id_sup = '0',id_question = '14',orderBy = '3',idLab = 'kmanr',node_img = '',is_leaf = '1',showTogether = '0';
<stat>INSERT INTO p98049023ver_tree SET id = '18',id_sup = '0',id_question = '18',orderBy = '4',idLab = 'f0',node_img = '',is_leaf = '1',showTogether = '0';
<stat>INSERT INTO p98049023ver_tree SET id = '19',id_sup = '0',id_question = '19',orderBy = '5',idLab = 'f1',node_img = '',is_leaf = '1',showTogether = '0';
<stat>INSERT INTO p98049023ver_tree SET id = '20',id_sup = '0',id_question = '20',orderBy = '6',idLab = 'f1a',node_img = '',is_leaf = '1',showTogether = '0';
<stat>INSERT INTO p98049023ver_tree SET id = '21',id_sup = '0',id_question = '21',orderBy = '7',idLab = 'f2',node_img = '',is_leaf = '1',showTogether = '0';
<stat>INSERT INTO p98049023ver_tree SET id = '22',id_sup = '0',id_question = '22',orderBy = '8',idLab = 'warn',node_img = '',is_leaf = '1',showTogether = '0';
<stat>INSERT INTO p98049023ver_tree SET id = '23',id_sup = '0',id_question = '23',orderBy = '9',idLab = 'ende',node_img = '',is_leaf = '1',showTogether = '0';
<stat>INSERT INTO p98049023ver_tree SET id = '24',id_sup = '0',id_question = '24',orderBy = '2',idLab = 'kon',node_img = '',is_leaf = '1',showTogether = '0';
<stat>INSERT INTO p98049023ver_tree SET id = '25',id_sup = '0',id_question = '25',orderBy = '1',idLab = 'Projektdaten',node_img = '',is_leaf = '1',showTogether = '0';