INSERT INTO `tiki_pages` (`page_id`, `pageName`, `pageSlug`, `hits`, `data`, `description`, `lastModif`, `comment`, `version`, `version_minor`, `user`, `ip`, `flag`, `points`, `votes`, `cache`, `wiki_cache`, `cache_timestamp`, `pageRank`, `creator`, `page_size`, `lang`, `lockedby`, `is_html`, `created`, `wysiwyg`, `wiki_authors_style`, `comments_enabled`, `keywords`) VALUES
(545, 'META-Pro 2024 - Chapter 20', 'META-Pro+2024+-+Chapter+20', 124, '!Creation and Re-Creation of Beliefs\r\n{TABS(name=\"tabset_meta-pro_2024\" tabs=\"Video lecture|Livesession\" )}\r\n\r\n{vimeo url=\"https://vimeo.com/812989431\" width=\"800\" height=\"450\"} \r\n\r\n00:33 Hierarchy of Determination example\r\n05:42 Identity and Belonging\r\n12:23 Cognitive Dissonance\r\n16:37 Secondary Gain from Symptoms\r\n24:05 Question Negative Beliefs\r\n32:35 The Power of Belief: Evidence\r\n39:08 Negative Beliefs in Medicine\r\n45:23 Byron Katie: The Work\r\n52:41 Check for Congruence\r\n55:38 A Story about Traditions\r\n\r\nDownload [https://www.meta-health.net/tiki-download_file.php?fileId=2379|presentation]\r\n\r\n!!Task\r\n__Your beliefs__\r\n* Think of an own health issue or challenge\r\n* What are your beliefs about it?\r\n* What are they founded upon?\r\n* How are they useful for you?\r\n* Find a limiting belief you like to change, and go through the reframing process!\r\n\r\n\r\n\r\n/////\r\n\r\n!!Livesession\r\nWe discuss challenging beliefs\r\n*of teenagers\r\n*of family\r\n*of clients\r\nand our scope of belief work\r\n*with different approaches\r\n*with respect to former experiences\r\n*with respect to core values\r\n\r\n{vimeo url=\"https://vimeo.com/1022231278\" width=\"800\" height=\"450\"} \r\n{TABS}\r\n', '', 1729789061, '', 2, 0, 'Kora', '185.13.79.36', '', NULL, NULL, NULL, NULL, 0, NULL, 'Kora', 1165, 'en', '', 0, 1728415419, 'n', '', 'y', NULL),
(546, 'META-Pro 2024 - Final class', 'META-Pro+2024+-+Final+class', 52, '!Final class\r\n{TABS(name=\"tabset_meta-pro_2024\" tabs=\"Livesession\" )}\r\n\r\n!!Livesession\r\n*Certification and celebration\r\n*How to become a [https://www.meta-health.info/organization/membership/sign-up/|licensed META-Health Practitioner]\r\n*[https://www.meta-health.info/meta-health/code-of-practice/|MHI Code of Practice]\r\n*Client disclaimer\r\n*Your [https://www.meta-health.info/meta-health/find-help/|profile on the META-Health International website]\r\n*MHI resources for marketing yourself\r\n*Specializing and ongoing learning opportunities\r\n\r\n{vimeo url=\"https://vimeo.com/1026675671\" width=\"800\" height=\"450\"} \r\n\r\n\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2386|Download the Code of Practice]\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2243|Download the Client Disclaimer] \r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2495|Managing a complaint situation] \r\n\r\n\r\n\r\n!!More dates\r\nNov 10: META-Health Council\r\nNov 12: Pro-Café (students are welcome too) See the recording [https://www.meta-health.net/tiki-view_forum_thread.php?comments_parentId=1270&forumId=6|here]!\r\nNov 16: EFT symposium on trauma healing\r\nThese events are described [http://h5kn.mjt.lu/nl3/3gUfYdOmIjZ4F8HTqD05VQ|here]\r\n\r\nStart of the [https://www.meta-health.info/international-meta-health-professional-online-course/|next META-Pro online], if you want to repeat: January 7, 2025\r\nStart of the Level 3 training: October 2025\r\n\r\n\r\n{TABS}\r\n', '', 1731445402, '', 7, 1, 'Kora', '79.116.128.242', '', NULL, NULL, NULL, NULL, 0, NULL, 'Kora', 1457, 'en', '', 0, 1730841933, 'n', '', 'y', NULL),
(547, 'META-Master 2024 D - Lektion 13', 'META-Master+2024+D+-+Lektion+13', 13, '!Vertiefung ins Stütz- und Bewegungssystem\r\n{TABS(name=\"tabset_master_dach\" tabs=\"Video|Livesession|Fallstudien\" )}\r\n!!Haltung, Bewegung und Gelenke\r\n\r\n{vimeo url=\"https://vimeo.com/135434715/\" width=\"800\" height=\"450\" quality=\"high\" allowFullScreen=\"true\" showTitle=\"false\" showByline=\"false\" showPortrait=\"false\"}\r\n\r\n*Funktionen und Bedeutung des Halteapparates\r\n*Was macht Haltung?\r\n*Übung: Gehalten sein\r\n*Knochen - Funktionen und Konfliktaktivierungen\r\n*Knochenhaut - Bedeutung und Muster im Heilzyklus\r\n*Gelenke und ihre Komponenten\r\n*Typische Symptomatiken und Prozesse in Gelenken\r\n*Faszien: Zusammenspieler und Kraftlinien\r\n*Typische Symptomatiken der Faszien\r\n*Empfindungsnuancen in Konflikttriggern\r\n*Nützliche Fragen\r\n*Was pflegt die Gelenke?\r\n\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2426|Download Präsentation (PDF)|_blank]\r\n\r\nWiki-Übersicht ((Stütz- und Bewegungsapparat Übersicht|Stützapparat))\r\n\r\n/////\r\n\r\n!!Livesession 06.11.2024\r\n\r\nVertiefung in den Stützapparat\r\n*Schwerpunkt ((Stütz- und Bewegungsapparat - Periost|Knochenhaut)) - Funktionen, Prozesse, Konfliktthematik\r\n*Fallbeispiele\r\n*Praktische Herangehensweise bei META-Analytics und Coaching\r\n\r\n{vimeo url=\"https://vimeo.com/1027048048\" width=\"800\" height=\"450\" quality=\"high\" allowFullScreen=\"true\" showTitle=\"false\" showByline=\"false\" showPortrait=\"false\"}\r\n\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2513|Download Fallstudie Ellbogenschmerz|_blank]\r\n\r\n!!Aufgabe\r\nRecherchiere zu \"Fibromyalgie\" - hat das mit der Knochenhaut zu tun?\r\n\r\n/////\r\n!!Fallstudien\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2513|Ellbogenschmerz|_blank]\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2516|Schulterschmerz|_blank]\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2514|chronische Gonarthritis|_blank]\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2515|Sprunggelenk|_blank]\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2517|Lendenwirbel|_blank]\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2518|Knie und Hüfte|_blank]\r\n\r\n\r\n{TABS}\r\n', '', 1730932186, '', 2, 1, 'Kora', '79.116.128.242', '', NULL, NULL, NULL, NULL, 0, NULL, 'Kora', 2133, 'de', '', 0, 1730932077, 'n', '', 'y', NULL),
(548, 'Material for Practitioners', 'Material+for+Practitioners', 130, '!Material for Practitioners\r\nOn this page you find downloads and links to material that you can use in your clinic and practice!\r\n{TABS(name=\"tabset_presenter\" tabs=\"Rules|Worksheets|Charts|Logos & pics|Presentations|Reading material|Videos\" )}\r\n!!MHI - rules and resources\r\n*[https://www.meta-health.info/organization/|About MHI]\r\n*[https://www.meta-health.info/organization/membership|MHI certification and licensing]\r\n*[https://www.meta-health.info/meta-health/learn-meta-health/professional-standards/|Practitioner standards for training and certification]\r\n*[https://www.meta-health.info/meta-health/learn-meta-health/presenter-standards/|Presenter standards and levels]\r\n*[https://www.meta-health.info/meta-health/code-of-practice/|Code of Practice]\r\n*[https://www.meta-health.net/tiki-download_file.php?fileId=2499|Feedback form]\r\n*[https://www.meta-health.net/tiki-download_file.php?fileId=2500|MHI community Code of Conduct]\r\n*[https://www.meta-health.net/tiki-download_file.php?fileId=2495|Tips for managing a complaint situation]\r\n\r\n/////\r\n!!Forms and Worksheets\r\n__Symptom Analytics:__\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2215|Download META Health Analytics Script]\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2018|Download Symptom Characteristics Compass]\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2013|Download Brain Stem Tissue list]\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2014|Download Cerebellum tissue list]\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2016|Download Cerebral Medulla tissue list]\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2015|Download Cerebral Cortex tissue list]\r\n\r\n__Documentation:__\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2214|Case study documentation form]\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2243|Client Disclaimer]\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2246|Personal history Intake form]\r\n\r\n/////\r\n!!Charts\r\n\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2046|Download Hamer Relay Chart Brain Stem]\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2047|Download Hamer Relay Chart Cerebellum]\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2040|Download Hamer Relay Chart Cerebral Medulla]\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2039|Download Hamer Relay Chart Cerebral Cortex]\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2048|Download Hamer Constellation Charts - complete]\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2541|Download Hamer Constellation Charts A]\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2542|Download Hamer Constellation Charts B]\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2543|Download Hamer Constellation Charts C]\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2544|Download Hamer Constellation Charts D]\r\n\r\n/////\r\n!!Logos and Pictures\r\n\r\n!!!MHI Logo stamp\r\n{img fileId=\"2123\" thumb=\"box\"}\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2123|Download here]\r\n\r\n!!!META-Health Logo phases\r\n{img fileId=\"2070\" thumb=\"box\"}\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2070|Download here]\r\n\r\n!!!META-Health Wheel\r\n{img fileId=\"2082\" thumb=\"box\"}\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2082|Download here]\r\n\r\n!!!2-phases wave\r\n{img fileId=\"2069\" thumb=\"box\"}\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2069|Download here]\r\n\r\n!!!Points & phases globe\r\n{img fileId=\"2074\" thumb=\"box\"}\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2074|Download here]\r\n\r\n/////\r\n!!Presentations\r\n!!!Introductory talk\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2139|Download PowerPoint]\r\nYou can  use these slides to create your own introductory talk into META-Health and your services. Feel free to select and adapt the slides, but make sure that they reflect the MHI code of practice and the code of conduct among the MHI community, and that you feature the MHI logo!\r\nWhen you have done a talk about or including META-Health in a live setting or a recorded online setting, please let it be approved by your mentor in MHI and acquire the title of a \"META-Health Speaker\"!\r\n\r\n/////\r\n!!Reading Material\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2203|Björn Eybl: The psychic roots of diseases] commented\r\n[https://www.meta-health.info/meta-health-and-german-new-medicine-what-is-the-difference/|META-Health and German New Medicine – what is the difference?]\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2249|Polyvagal Theory and the \"Autonomic Ladder\"]\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2456|Richard Flook: How can I heal?]\r\n[https://www.meta-healthy.life|META-Healthy Life articles]\r\n\r\n\r\n/////\r\n!!Videos\r\n\r\n\r\n\r\n\r\n\r\n{TABS}\r\n', '', 1734647615, '', 4, 0, 'Kora', '79.116.130.150', '', NULL, NULL, NULL, NULL, 0, NULL, 'Kora', 4937, 'en', '', 0, 1731765720, 'n', '', 'y', NULL),
(549, 'META-Master 2024 D - Lektion 14', 'META-Master+2024+D+-+Lektion+14', 21, '!Schmerzen, deren Entstehung, Verarbeitung und Behandlung\r\n{TABS(name=\"tabset_master_dach\" tabs=\"Video|Livesession 1|Livesession 2|Fallstudien\" )}\r\n!!Schmerzentstehung und Differenzierung\r\n{vimeo url=\"https://vimeo.com/253157458/\" width=\"800\" height=\"450\" quality=\"high\" allowFullScreen=\"true\" showTitle=\"false\" showByline=\"false\" showPortrait=\"false\"}\r\n\r\n*Schmerzleitung und -verarbeitung\r\n*Sinn von Schmerz und Verstärkung\r\n*Verringerung oder Abschalten von Schmerz\r\n*Unterschiedliche schmerzhafte Prozesse\r\n*Verschiedene Gründe für Kopfschmerz\r\n*Vaskulärer Schmerz  -  Druck\r\n*Gesichtsschmerz\r\n*Stechender Kopfschmerz\r\n*Schädel und Hirnhäute\r\n*Nervenschmerzen\r\n*Spannungskopfschmerz\r\n*Schmerz & Rhythmen\r\n*Konsequenzen für Therapie und Nachhaltigkeit\r\n\r\n\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2414|Download Präsentation (PDF)|_blank]\r\n\r\n\r\n/////\r\n\r\n!!Livesession 20.11.2024\r\n\r\n__Schmerzbehandlung__\r\n*Schmerzmedikamente und ihre Wirkweisen\r\n*Nicht-medikamentöse Einflüse auf Schmerzen\r\n*Fallbeispiel \"plötzlicher Schulterschmerz\"\r\n*Teufelskreis chronischer Schmerz\r\n*Das Muster durchbrechen\r\n*Neue wissenschaftliche Studien zu EFT bei chronischem Schmerz\r\n\r\n{vimeo url=\"https://vimeo.com/1031694189\" width=\"800\" height=\"450\" quality=\"high\" allowFullScreen=\"true\" showTitle=\"false\" showByline=\"false\" showPortrait=\"false\"}\r\n\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2532|Download Präsentation|_blank]\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2531|Download Fallstudie plötzlicher Schulterschmerz|_blank]\r\n\r\n!!Aufgabe\r\nHast Du Fallstudien oder weitere Beispiele zu verschiedenen Schmerzarten?\r\n\r\n/////\r\n\r\n!!Livesession 4.12.2024\r\n\r\n*Trigeminusfunktionen und -schmerzen im Detail\r\n*Beispiel Sarah: Zusammenhang von Migräne und Trigeminus mit Hals, Faszien und Nebenhöhlen\r\n*Fallbeispiel Kopfschmerz und Sinusitis, Hintergrund und Therapie\r\n*Unsere nächsten Schritte zum \"Master\"\r\n\r\n{vimeo url=\"https://vimeo.com/1036136398\" width=\"800\" height=\"450\" quality=\"high\" allowFullScreen=\"true\" showTitle=\"false\" showByline=\"false\" showPortrait=\"false\"}\r\n\r\n/////\r\n\r\n!!Fallstudien Schmerz\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2513|Ellbogenschmerz|_blank]\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2516|Schulterschmerz|_blank]\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2531|plötzlicher Schulterschmerz|_blank]\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2533|Lumbalgie und Ödeme|_blank]\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2534|Myom und Blutung|_blank]\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2535|Endometriose und SIBO|_blank]\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2536|Sinusitis und Kopfschmerz|_blank]\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2537|Schmerz bei Metastasen|_blank]\r\n\r\n\r\n\r\n\r\n{TABS}\r\n', '', 1733348899, '', 3, 0, 'Kora', '79.116.130.150', '', NULL, NULL, NULL, NULL, 0, NULL, 'Kora', 2925, 'de', '', 0, 1732138718, 'n', '', 'y', NULL),
(550, 'Material für Practitioner', 'Material+f%C3%BCr+Practitioner', 31, '!Material für Practitioner\r\nAuf dieser Seite findest Du Downloads und Links zu Material, das Du in Deiner Praxis nutzen kannst!  \r\n{TABS(name=\"tabset_practitioner\" tabs=\"Regeln|Formulare|Logos & Bilder|Präsentationen|Lesematerial\" )}\r\n!!MHI - Regeln und Ressourcen\r\n*[http://www.meta-gesundheit.de/organisation/|Über MHI]\r\n*[http://www.meta-gesundheit.de/organisation/mitgliedschaft/mitgliedschaft-details/|MHI Zertifizierung und Lizenzen]\r\n*[http://www.meta-gesundheit.de/meta-health/ausbildung/professionelle-standards/|Standards für Ausbildungen und Zertifikation]\r\n*[http://www.meta-gesundheit.de/organisation/code-of-practice/|Code of Practice]\r\n*[https://www.meta-health.net/tiki-download_file.php?fileId=2486|MHI Community Verhaltenskodex]\r\n\r\n/////\r\n!!Arbeitsblätter und Formulare\r\n__Symptomanalyse:__\r\n\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2538|Download META-Analytics Script]\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2297|Download Arbeitsblatt 12 Fragen]\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2298|Download Symptomcharakteristika Uebersicht]\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2293|Download Gewebe Katalog 1 Stammhirn]\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2294|Download Gewebe Katalog 2 Kleinhirn]\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2295|Download Gewebe Katalog 3 Grosshirnmark]\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2296|Download  Gewebe Katalog 4 Grosshirnrindet]\r\n\r\n__Dokumentation:__\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2383|Fallstudienformular.doc]\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2384|Fallstudienformular.pdf]\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2458|Klientendisclaimer]\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2298|Formular persönliche Vorgeschichte]\r\n\r\n/////\r\n!!Logos und Bilder\r\n\r\n!!!MHI Logo rund\r\n{img fileId=\"2123\" thumb=\"box\"}\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2123|Download]\r\n\r\n!!!META-Health Logo Phasen\r\n{img fileId=\"2070\" thumb=\"box\"}\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2070|Download]\r\n\r\n!!!META-Health \"Lebensrad\"\r\n{img fileId=\"2082\" thumb=\"box\"}\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2083|Download]\r\n\r\n!!!2-Phasen Welle\r\n{img fileId=\"2069\" thumb=\"box\"}\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2069|Download]\r\n\r\n!!!Punkte & Phasen rund\r\n{img fileId=\"2074\" thumb=\"box\"}\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2075|Download]\r\n\r\n/////\r\n!!Präsentationen\r\n!!!Einführungsvortrag\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2140|Download PowerPoint]\r\nDu kannst diese Folien verwenden, um Deinen eigenen Einführungsvortrag zu META-Health und Deinen Diensten zu erstellen. Du darfst die Folien nach Belieben auswählen und anpassen, aber stelle sicher, dass Du dabei den MHI-Praxiskodex und den Verhaltenskodex der MHI-Community beachtest und dass Du das MHI-Logo verwendest!\r\nWenn Du einen Vortrag über oder mit META-Health Live oder Online gehalten hast, lass ihn bitte von Deinem Mentor bei MHI genehmigen und erwirb den Titel eines „META-Health-Speakers“!\r\n\r\n\r\n/////\r\n!!Lesematerial\r\n\r\n[https://www.meta-gesundheit.de/blog/meta-health-und-germanische-heilkunde-was-ist-der-unterschied/|META-Health und Germanische Heilkunde – was ist der Unterschied?]\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2249|Polyvagal Theory and the \"Autonomic Ladder\" (Englisch)]\r\n[https://www.meta-health.net/tiki-download_file.php?fileId=2456|Richard Flook: How can I heal? (Englisch)]\r\n[https://www.meta-gesund.de|META-Gesund! Artikelsammlung]\r\n\r\n\r\n{TABS} \r\n\r\n\r\n\r\n\r\n\r\n\r\n', '', 1732214993, '', 2, 1, 'Kora', '79.116.130.150', '', NULL, NULL, NULL, NULL, 0, NULL, 'Kora', 3789, 'de', '', 0, 1732214901, 'n', '', 'y', NULL);

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `tiki_preferences`
--

CREATE TABLE `tiki_preferences` (
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `value` text COLLATE utf8_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Daten für Tabelle `tiki_preferences`
--

INSERT INTO `tiki_preferences` (`name`, `value`) VALUES
('allowmsg_is_optional', 'y'),
('allowRegister', 'y'),
('article_feature_copyrights', 'y'),
('article_remembers_creator', 'y'),
('available_languages', 'a:2:{i:0;s:2:\"en\";i:1;s:2:\"de\";}'),
('browsertitle', 'META-Health Net'),
('calendar_export', 'y'),
('calendar_fullcalendar', 'y'),
('captcha_noise', '60'),
('category_browse_count_objects', 'n'),
('category_i18n_sync', 'whitelist'),
('category_i18n_synced', 'a:0:{}'),
('comments_notitle', 'n'),
('contact_anon', 'y'),
('cookie_consent_description', 'This website is using only technically necessary cookies. For access to all features of the portal, please accept cookies. '),
('cookie_consent_feature', 'n'),
('cookie_consent_mode', 'dialog'),
('cookie_domain', 'https://www.meta-health.net'),
('cookie_name', 'META-Health Net'),
('cookie_refresh_rememberme', 'y'),
('default_calendars', 'a:0:{}'),
('desactive_login_autocomplete', 'y'),
('display_field_order', 'DMY'),
('display_timezone', 'Europe/Berlin'),
('error_reporting_adminonly', 'y'),
('error_reporting_level', '2039'),
('feature_accounting', 'y'),
('feature_action_calendar', 'y'),
('feature_articles', 'y'),
('feature_banning', 'y'),
('feature_best_language', 'n'),
('feature_blogposts_comments', 'n'),
('feature_blogs', 'n'),
('feature_cal_manual_time', 'y'),
('feature_calendar', 'n'),
('feature_categories', 'y'),
('feature_comments_moderation', 'y'),
('feature_contacts', 'y'),
('feature_contribution', 'y'),
('feature_copyright', 'n'),
('feature_custom_home', 'y'),
('feature_default_calendars', 'n'),
('feature_detect_language', 'y'),
('feature_editcss', 'y'),
('feature_endbody_code', '<!-- <script async id=\"slcLiveChat\" src=\"https://widget.sonetel.com/SonetelWidget.min.js\" data-account-id=\"206905290\"></script> -->'),
('feature_faq_comments', 'n'),
('feature_file_galleries_batch', 'y'),
('feature_fixed_width', 'n'),
('feature_forum_local_search', 'n'),
('feature_forum_local_tiki_search', 'y'),
('feature_forum_parse', 'y'),
('feature_forum_rankings', 'n'),
('feature_forums', 'y'),
('feature_forums_name_search', 'y'),
('feature_freetags', 'y'),
('feature_group_watches', 'y'),
('feature_groupalert', 'y'),
('feature_help', 'n'),
('feature_html_pages', 'y'),
('feature_invoice', 'y'),
('feature_jquery_carousel', 'y'),
('feature_live_support', 'n'),
('feature_maps', 'y'),
('feature_messages', 'y'),
('feature_minichat', 'y'),
('feature_multilingual', 'y'),
('feature_multilingual_one_page', 'y'),
('feature_multilingual_structures', 'y'),
('feature_mytiki', 'y'),
('feature_newsletters', 'y'),
('feature_page_title', 'n'),
('feature_polls', 'y'),
('feature_purifier', 'n'),
('feature_quizzes', 'y'),
('feature_referer_stats', 'y'),
('feature_search', 'y'),
('feature_search_fulltext', 'n'),
('feature_search_show_last_modification', 'y'),
('feature_search_show_object_type', 'y'),
('feature_search_show_pertinence', 'y'),
('feature_search_show_search_box', 'y'),
('feature_sefurl', 'n'),
('feature_show_stay_in_ssl_mode', 'y'),
('feature_sitelogo', 'n'),
('feature_socialnetworks', 'n'),
('feature_stats', 'y'),
('feature_surveys', 'y'),
('feature_switch_ssl_mode', 'y'),
('feature_sync_language', 'n'),
('feature_syntax_highlighter', 'y'),
('feature_tasks', 'y'),
('feature_ticketlib', 'n'),
('feature_ticketlib2', 'n'),
('feature_trackers', 'y'),
('feature_translation', 'y'),
('feature_unified_user_details', 'y'),
('feature_urgent_translation', 'y'),
('feature_user_bookmarks', 'y'),
('feature_user_watches', 'y'),
('feature_user_watches_languages', 'n'),
('feature_user_watches_translations', 'n'),
('feature_userfiles', 'y'),
('feature_userlevels', 'y'),
('feature_usermenu', 'y'),
('feature_userPreferences', 'y'),
('feature_wiki_allowhtml', 'y'),
('feature_wiki_argvariable', 'y'),
('feature_wiki_comments', 'n'),
('feature_wiki_discuss', 'n'),
('feature_wiki_export', 'y'),
('feature_wiki_import_html', 'y'),
('feature_wiki_pagealias', 'n'),
('feature_wiki_structure', 'y'),
('feature_wiki_templates', 'y'),
('feature_wiki_undo', 'y'),
('feature_wiki_userpage', 'y'),
('feature_wiki_userpage_prefix', 'User: '),
('feature_wizard_user', 'y'),
('feature_wysiwyg', 'n'),
('fgal_allow_duplicates', 'y'),
('fgal_batch_dir', '/var/www/vhosts/meta-health.net/htdocs/files/extern/'),
('fgal_default_view', 'list'),
('fgal_enable_auto_indexing', 'n'),
('fgal_fix_mime_type', 'y'),
('fgal_icon_fileId', ''),
('fgal_limit_hits_per_file', 'y'),
('fgal_list_author', 'o'),
('fgal_list_author_admin', 'o'),
('fgal_list_backlinks', 'n'),
('fgal_list_backlinks_admin', 'y'),
('fgal_list_comment', 'o'),
('fgal_list_comment_admin', 'o'),
('fgal_list_created', 'o'),
('fgal_list_created_admin', 'o'),
('fgal_list_creator', 'o'),
('fgal_list_creator_admin', 'o'),
('fgal_list_deleteAfter', 'n'),
('fgal_list_description', 'o'),
('fgal_list_description_admin', 'o'),
('fgal_list_files', 'o'),
('fgal_list_files_admin', 'o'),
('fgal_list_hits', 'o'),
('fgal_list_hits_admin', 'o'),
('fgal_list_id', 'o'),
('fgal_list_id_admin', 'y'),
('fgal_list_last_user', 'o'),
('fgal_list_last_user_admin', 'o'),
('fgal_list_lastDownload', 'n'),
('fgal_list_lastDownload_admin', 'n'),
('fgal_list_lastModif', 'y'),
('fgal_list_lastModif_admin', 'y'),
('fgal_list_lockedby', 'a'),
('fgal_list_lockedby_admin', 'n'),
('fgal_list_name', 'n'),
('fgal_list_name_admin', 'n'),
('fgal_list_share', 'n'),
('fgal_list_size', 'y'),
('fgal_list_size_admin', 'y'),
('fgal_list_type', 'y'),
('fgal_list_type_admin', 'y'),
('fgal_podcast_dir', 'files/'),
('fgal_quota_default', '0'),
('fgal_sort_mode', 'created_desc'),
('fgal_use_db', 'n'),
('fgal_use_dir', '/var/www/vhosts/meta-health.net/htdocs/files/manager/'),
('flaggedrev_approval_categories', 'a:1:{i:0;i:0;}'),
('forum_available_categories', 'a:1:{i:0;s:0:\"\";}'),
('forum_image_file_gallery', '1'),
('forum_list_topics', 'y'),
('forum_reply_notitle', 'n'),
('forum_strip_wiki_syntax_outgoing', 'y'),
('forum_thread_sort_mode', 'commentDate_asc'),
('forum_thread_style', 'commentStyle_threaded'),
('forums_ordering', 'name_asc'),
('freetags_multilingual', 'n'),
('gal_use_lib', 'gd'),
('generate_password', 'y'),
('header_custom_css', 'li.level3 {background-color:3ffd700;}'),
('home_forum', NULL),
('https_external_links_for_users', 'y'),
('https_login', 'encouraged'),
('https_port', '443'),
('internal_site_hash', 'OER1Ac0IIvMEcZSTv0RGQxDufa16xHyfSLp2CneXATQdnlwS3BRWYV/zI8LxiKqlCyZBvxPO+U82E61R258HdOTDU7FpwC5Q7AKqnbS5Q7ztcPkjV31VLs+gqI4CzTiuofiLRQ=='),
('lang_use_db', 'y'),
('language', 'en'),
('layout_fixed_width', '980px'),
('layout_tabs_optional', 'y'),
('log_mail', 'y'),
('log_sql', 'y'),
('log_tpl', 'n'),
('login_allow_email', 'y'),
('login_autologin_user', 'Thorsten'),
('login_http_basic', 'ssl'),
('login_is_email', 'n'),
('login_multiple_forbidden', 'n'),
('menus_items_icons', 'y'),
('menus_items_icons_path', 'img/icons/large'),
('messu_archive_size', '0'),
('messu_sent_size', '0'),
('messu_truncate_internal_message', '100'),
('metatag_freetags', 'n'),
('metatag_robots', 'NOINDEX, NOFOLLOW'),
('min_pass_length', '12'),
('monitor_enabled', 'y'),
('monitor_individual_clear', 'y'),
('newsletter_batch_size', '10'),
('newsletter_pause_length', '30'),
('newsletter_throttle', 'y'),
('pass_chr_case', 'y'),
('pass_chr_num', 'y'),
('pass_repetition', 'y'),
('payment_currency', 'EUR'),
('payment_default_delay', '14'),
('payment_feature', 'y'),
('permission_denied_login_box', 'y'),
('print_wiki_authors', 'y'),
('proxy_host', ''),
('proxy_pass', ''),
('proxy_port', ''),
('proxy_user', ''),
('record_untranslated', 'y'),
('registerPasscode', 'METAHealth4U'),
('rememberme', 'always'),
('remembertime', '31556926'),
('restrict_language', 'y'),
('search_default_where', 'a:1:{i:0;s:0:\"\";}'),
('sender_email', 'server@meta-health.net'),
('server_timezone', 'Europe/Berlin'),
('session_lifetime', '9999999999'),
('session_protected', 'y'),
('site_title_location', 'after'),
('sitelogo_alt', 'META-Health'),
('sitelogo_src', 'img/tiki/MH_phases_trans_200x100.png'),
('sitelogo_title', ''),
('sitesubtitle', 'The Caring Community'),
('sitetitle', 'META-Health'),
('smarty_notice_reporting', 'n'),
('style', 'tikinewt.css'),
('t_use_db', 'y'),
('t_use_dir', ''),
('theme', 'Tikipedia'),
('tiki_check_status', '{\"MySQL\":{\"Version\":{\"fitness\":\"good\",\"setting\":\"5.5.52-0ubuntu0.14.04.1\",\"message\":\"Tiki requires MySQL >= 5.x.\",\"ack\":true},\"max_allowed_packet\":{\"fitness\":\"good\",\"setting\":\"16M\",\"message\":\"Your max_allowed_packet setting is at 16M. You can upload quite big files, but keep in mind to set your script timeouts accordingly. This limits the size of binary files that can be added to Tiki, when storing files in the database. Please see: <a href=\\\"http:\\/\\/doc.tiki.org\\/File+Storage\\\">file storage<\\/a>.\",\"ack\":true},\"character_set_client\":{\"fitness\":\"good\",\"setting\":\"utf8\",\"message\":\"Tiki is fully UTF-8 and so should every part of your stack be.\",\"ack\":true},\"character_set_connection\":{\"fitness\":\"good\",\"setting\":\"utf8\",\"message\":\"Tiki is fully UTF-8 and so should every part of your stack be.\",\"ack\":true},\"character_set_database\":{\"fitness\":\"good\",\"setting\":\"utf8\",\"message\":\"Tiki is fully UTF-8 and so should every part of your stack be.\",\"ack\":true},\"character_set_results\":{\"fitness\":\"good\",\"setting\":\"utf8\",\"message\":\"Tiki is fully UTF-8 and so should every part of your stack be.\",\"ack\":true},\"character_set_server\":{\"fitness\":\"ugly\",\"setting\":\"latin1\",\"message\":\"On a fresh install you should have everything set to UTF-8 to not run into any suprises. For further information please see <a href=\\\"http:\\/\\/doc.tiki.org\\/Understanding+Encoding\\\">Understanding Encoding<\\/a>.\",\"ack\":false},\"character_set_system\":{\"fitness\":\"good\",\"setting\":\"utf8\",\"message\":\"Tiki is fully UTF-8 and so should every part of your stack be.\",\"ack\":true},\"collation_connection\":{\"fitness\":\"good\",\"setting\":\"utf8_general_ci\",\"message\":\"Tiki is fully UTF-8 and so should every part of your stack be. utf8_unicode_ci is the default collation for Tiki.\",\"ack\":true},\"collation_database\":{\"fitness\":\"good\",\"setting\":\"utf8_general_ci\",\"message\":\"Tiki is fully UTF-8 and so should every part of your stack be. utf8_unicode_ci is the default collation for Tiki.\",\"ack\":true},\"collation_server\":{\"fitness\":\"ugly\",\"setting\":\"latin1_swedish_ci\",\"message\":\"On a fresh install you should have everything set to UTF-8 to not run into any suprises. utf8_unicode_ci is the default collation for Tiki. For further information please see <a href=\\\"http:\\/\\/doc.tiki.org\\/Understanding+Encoding\\\">Understanding Encoding<\\/a>.\",\"ack\":false},\"slow_query_log\":{\"fitness\":\"info\",\"setting\":\"OFF\",\"message\":\"Your MySQL doesn\'t log slow queries. If you have performance issues, you might want to enable this, but keep in mind that the logging itself slows MySQL down.\",\"ack\":false},\"SSL connection\":{\"fitness\":\"info\",\"setting\":\"OFF\",\"message\":\"MySQL Server does not have SSL activated\",\"ack\":false},\"Strict Mode\":{\"fitness\":\"info\",\"setting\":\"\",\"message\":\"MySQL is not using strict mode\",\"ack\":false}},\"Server\":{\"Disk Space\":{\"fitness\":\"good\",\"setting\":\"51.77 GB\",\"message\":\"Du hast mehr als 251 MB freien Festplattenplatz. Tiki wird funktionieren, aber es k\\u00f6nnte zu Problemen kommen wenn Tiki w\\u00e4chst weil z.B. Dateien hochgeladen werden When the disk runs full you will not be able to log into your Tiki any more. We can not reliably check for quotas, so be warned that if your server makes use of them you might have less disk space available.\",\"ack\":true}},\"Apache\":{\"mod_rewrite\":{\"setting\":\"Loaded\",\"fitness\":\"good\",\"message\":\"Tiki needs this module for Search Engine Friendly URLs via .htaccess. We can\'t check though, if your web server respects configurations made in .htaccess. For further information go to Admin->SefURL in your Tiki.\",\"ack\":true},\"RewriteBase\":{\"setting\":\"\\/\",\"fitness\":\"good\",\"message\":\"Your RewriteBase is set correctly in .htaccess. Search Engine Friendly URLs should work. Beware though that we can\'t check if Apache really loads .htaccess.\",\"ack\":true},\"mod_expires\":{\"setting\":\"Not available\",\"fitness\":\"ugly\",\"message\":\"With this module you can set the HTTP Expires header and therefore increase performance. Once you install it, you still need to configure it correctly.\",\"ack\":false},\"mod_deflate\":{\"setting\":\"Loaded\",\"fitness\":\"good\",\"message\":\"With this module you can compress the data your webserver sends out and therefore decrease used bandwidth and increase performance. We can\'t check though, if mod_deflate is configured correctly.\",\"ack\":true},\"mod_security\":{\"setting\":\"Not available\",\"fitness\":\"info\",\"message\":\"This module can increase security of your Tiki and therefore your server, but be warned that it is very tricky to configure it correctly. A misconfiguration can lead to failed page saves or other hard to trace bugs.\",\"ack\":false}},\"PHP\":{\"Error reporting\":{\"fitness\":\"info\",\"setting\":\"Disabled\",\"message\":\"You will get no errors reported, because display_errors is turned off. This might be the right thing for a production site, but in case of problems enable it in php.ini to get more information. Your error_reporting level is decent at 32759.\",\"ack\":false},\"ini_set\":{\"fitness\":\"good\",\"setting\":\"Enabled\",\"message\":\"ini_set is used in some places to accomodate for special needs of some Tiki features.\",\"ack\":true},\"DB Driver\":{\"fitness\":\"good\",\"setting\":\"PDO\",\"message\":\"The PDO extension is the suggested database driver\\/abstraction layer.\",\"ack\":true},\"PHP version\":{\"fitness\":\"good\",\"setting\":\"5.5.9-1ubuntu4.20\",\"message\":\"You have a recent version of PHP and you can run any supported versions of Tiki.\",\"ack\":true},\"PHP Server API\":{\"fitness\":\"info\",\"setting\":\"apache2handler\",\"message\":\"You are not running PHP as CGI. Be aware that PHP is not thread-safe and you should not use a threaded Apache MPM (like worker).\",\"ack\":false},\"ByteCode Cache\":{\"fitness\":\"good\",\"setting\":\"OPcache\",\"message\":\"You are using OPcache as your ByteCode Cache which increases performance, if correctly configured. See Admin->Performance in your Tiki for more details.\",\"ack\":true},\"memory_limit\":{\"fitness\":\"good\",\"setting\":\"256M\",\"message\":\"Your memory_limit is at 256M. This is known to behave well even for bigger sites.\",\"ack\":true},\"session.save_handler\":{\"fitness\":\"good\",\"setting\":\"files\",\"message\":\"Well set! the default setting of \'files\' is needed for Tiki.\",\"ack\":true},\"session.save_path\":{\"fitness\":\"bad\",\"setting\":\"\\/var\\/sentora\\/sessions\",\"message\":\"Your session.save_path must writable.\",\"ack\":false},\"session\":{\"fitness\":\"ugly\",\"setting\":\"leer\",\"message\":\"Your session is empty, try reloading the page and if you see this message again you may have a problem with your server setup.\",\"ack\":false},\"zlib.output_compression\":{\"fitness\":\"info\",\"setting\":\"Off\",\"message\":\"You have zlib output compression turned off. This reduces CPU usage. Turning it on would in turn save bandwidth. Choose your poison.\",\"ack\":false},\"register_globals\":{\"fitness\":\"good\",\"setting\":\"Off\",\"message\":\"Well set! And you are future proof also as register_globals is deprecated.\",\"ack\":true},\"safe_mode\":{\"fitness\":\"good\",\"setting\":\"Off\",\"message\":\"Well set! And you are future proof also as safe_mode is deprecated.\",\"ack\":true},\"magic_quotes_gpc\":{\"fitness\":\"good\",\"setting\":\"Off\",\"message\":\"Well set! Some features like assigning perms to a group with a name containing a quote will not work with this being on. And you are future proof also as magic_quotes_gpc is deprecated.\",\"ack\":true},\"default_charset\":{\"fitness\":\"ugly\",\"setting\":\"\",\"message\":\"default_charset should be UTF-8 as Tiki is fully UTF-8. Please check your php.ini.\",\"ack\":false},\"date.timezone\":{\"fitness\":\"good\",\"setting\":\"Europe\\/Mariehamn\",\"message\":\"Well done! Having a time zone set protects you from many weird errors.\",\"ack\":true},\"file_uploads\":{\"fitness\":\"good\",\"setting\":\"On\",\"message\":\"Du kannst Dateien in Deine Tiki hochladen.\",\"ack\":true},\"max_execution_time\":{\"fitness\":\"ugly\",\"setting\":\"300s\",\"message\":\"Your max_execution_time is at 300. This is not necessarily bad, but it\'s a good idea to limit this time on productions servers in order to eliminate unexpectedly long running scripts.\",\"ack\":false},\"max_input_time\":{\"fitness\":\"ugly\",\"setting\":\"300s\",\"message\":\"Your max_input_time is at 300. This is not necessarily bad, but it\'s a good idea to limit this time on productions servers in order to eliminate unexpectedly long running scripts.\",\"ack\":false},\"upload_max_filesize\":{\"fitness\":\"good\",\"setting\":\"20M\",\"message\":\"Your upload_max_filesize is at 20M. You can upload quite big files, but keep in mind to set your script timeouts accordingly.\",\"ack\":true},\"post_max_size\":{\"fitness\":\"good\",\"setting\":\"20M\",\"message\":\"Your post_max_size is at 20M. You can upload quite big files, but keep in mind to set your script timeouts accordingly.\",\"ack\":true},\"fileinfo\":{\"fitness\":\"good\",\"setting\":\"Loaded\",\"message\":\"The fileinfo extension is needed for the \'Validate uploaded file content\' preference.\",\"ack\":true},\"intl\":{\"fitness\":\"good\",\"setting\":\"Loaded\",\"message\":\"intl extension is required for Tiki 15 onwards.\",\"ack\":true},\"gd\":{\"fitness\":\"good\",\"setting\":\"2.1.1-dev\",\"message\":\"The GD extension is needed for manipulation of images, e.g. also for CAPTCHAs.\",\"ack\":true},\"Image Magick\":{\"fitness\":\"info\",\"setting\":\"Not Available\",\"message\":\"ImageMagick is used as a fallback in case that GD is not available.\",\"ack\":false},\"mbstring\":{\"fitness\":\"good\",\"setting\":\"Loaded\",\"message\":\"The mbstring extension is needed for an UTF-8 compatible lower case filter in the admin search for example.\",\"ack\":true},\"calendar\":{\"fitness\":\"good\",\"setting\":\"Loaded\",\"message\":\"calendar extension is needed by Tiki.\",\"ack\":true},\"ctype\":{\"fitness\":\"good\",\"setting\":\"Loaded\",\"message\":\"ctype extension is needed by Tiki.\",\"ack\":true},\"libxml\":{\"fitness\":\"good\",\"setting\":\"Loaded\",\"message\":\"This extension is needed for WebDAV and the dom extension (see below).\",\"ack\":true},\"dom\":{\"fitness\":\"good\",\"setting\":\"Loaded\",\"message\":\"This extension is needed for many features such as:<br>bigbluebutton, machine translation, SCORM & meta-data in file galleries, wiki importers, custom search, Kaltura and others.\",\"ack\":true},\"LDAP\":{\"fitness\":\"info\",\"setting\":\"Not available\",\"message\":\"You will not be able to connect your Tiki to an LDAP server as the needed PHP extension is missing. More info at: http:\\/\\/doc.tiki.org\\/LDAP\",\"ack\":false},\"memcache\":{\"fitness\":\"info\",\"setting\":\"Not available\",\"message\":\"This extension can be used to speed up your Tiki by saving sessions as well as wiki and forum data on a memcached server.\",\"ack\":false},\"SSH2\":{\"fitness\":\"info\",\"setting\":\"Not available\",\"message\":\"This extension is needed for the show.tiki.org tracker field type.\",\"ack\":false},\"json\":{\"fitness\":\"good\",\"setting\":\"Loaded\",\"message\":\"This extension is required for many features in Tiki.\",\"ack\":true},\"mcrypt\":{\"fitness\":\"good\",\"setting\":\"Loaded\",\"message\":\"Enable safe, encrypted storage of data, e.g. passwords. Required for the User Encryption feature and improves encryption in other features, when available.\",\"ack\":true},\"iconv\":{\"fitness\":\"good\",\"setting\":\"Loaded\",\"message\":\"This extension is required and used frequently in validation functions invoked within Zend Framework.\",\"ack\":true},\"eval()\":{\"fitness\":\"good\",\"setting\":\"Available\",\"message\":\"The eval() function is required by the Smarty templating engine.\",\"ack\":true},\"ZipArchive class\":{\"fitness\":\"good\",\"setting\":\"Available\",\"message\":\"The ZipArchive class is needed for features such as XML Wiki Import\\/Export and PluginArchiveBuilder.\",\"ack\":true},\"DateTime class\":{\"fitness\":\"good\",\"setting\":\"Available\",\"message\":\"The DateTime class is needed for the WebDAV feature.\",\"ack\":true},\"Xdebug\":{\"fitness\":\"info\",\"setting\":\"Not Available\",\"message\":\"Xdebug can be very handy for a development server, but it might be better to disable it when on a production server.\",\"ack\":false}},\"PHP Security\":{\"upload_tmp_dir\":{\"fitness\":\"unbekannt\",\"setting\":\"\\/var\\/sentora\\/temp\\/\",\"message\":\"Can\'t reliably determine, if your upload_tmp_dir is accessible via a web browser. To make sure you should check your webserver config.\",\"ack\":false},\"register_globals\":{\"setting\":\"Off\",\"fitness\":\"sicher\",\"message\":\"register_globals sollte ausgeschaltet sein. Details bitte der PHP Anleitung entnehmen.\",\"ack\":false},\"exec\":{\"setting\":\"Deaktiviert\",\"fitness\":\"sicher\",\"message\":\"Exec can be potentially be used to execute arbitrary code on your server. Tiki does not need it, you are wise to have it disabled.\",\"ack\":false},\"passthru\":{\"setting\":\"Deaktiviert\",\"fitness\":\"sicher\",\"message\":\"Passthru is similar to exec. Tiki does not need it, you are wise to have it disabled.\",\"ack\":false},\"shell_exec\":{\"setting\":\"Deaktiviert\",\"fitness\":\"sicher\",\"message\":\"Shell_exec is similar to exec. Tiki needs it to run PDF from URL: WebKit (wkhtmltopdf). If you need this and trust the other PHP software on your server, you should enable it.\",\"ack\":false},\"system\":{\"setting\":\"Deaktiviert\",\"fitness\":\"sicher\",\"message\":\"System is similar to exec. Tiki does not need it, you are wise to have it disabled.\",\"ack\":false},\"proc_open\":{\"setting\":\"Deaktiviert\",\"fitness\":\"sicher\",\"message\":\"Proc_open is similar to exec. Tiki does not need it, you are wise to have it disabled. However, Composer may need it (If you are running Tiki from SVN)\",\"ack\":false},\"popen\":{\"setting\":\"Deaktiviert\",\"fitness\":\"sicher\",\"message\":\"popen is similar to exec. Tiki needs it for file search indexing in file galleries. If you need this and trust the other PHP software on your server, you should enable it.\",\"ack\":false},\"curl_exec\":{\"setting\":\"Aktiviert\",\"fitness\":\"gef\\u00e4hrlich\",\"message\":\"Curl_exec can potentially be abused to write malicious code. Tiki needs it to run features like Kaltura, CAS login, CClite and the myspace and sf wiki-plugins. If you need these and trust the other PHP software on your server, you should enable it.\",\"ack\":false},\"curl_multi_exec\":{\"setting\":\"Aktiviert\",\"fitness\":\"gef\\u00e4hrlich\",\"message\":\"Curl_multi_exec can potentially be abused to write malicious code. Tiki needs it to run features like Kaltura, CAS login, CClite and the myspace and sf wiki-plugins. If you need these and trust the other PHP software on your server, you should enable it.\",\"ack\":false},\"parse_ini_file\":{\"setting\":\"Aktiviert\",\"fitness\":\"gef\\u00e4hrlich\",\"message\":\"It is probably an urban myth that this is dangerous. Tiki team will reconsider this check, but be warned. It is required for the <a href=\\\"http:\\/\\/doc.tiki.org\\/System+Configuration\\\" target=\\\"_blank\\\">System Configuration<\\/a> feature.\",\"ack\":false},\"show_source\":{\"setting\":\"Deaktiviert\",\"fitness\":\"sicher\",\"message\":\"It is probably an urban myth that this is dangerous. Tiki team will reconsider this check, but be warned.\",\"ack\":false},\"session.use_trans_sid\":{\"setting\":\"Disabled\",\"fitness\":\"sicher\",\"message\":\"session.use_trans_sid sollte ausgeschaltet sein. Details bitte der PHP Anleitung entnehmen.\",\"ack\":false},\"xbithack\":{\"setting\":\"Disabled\",\"fitness\":\"sicher\",\"message\":\"setting the xbithack option is unsafe. Depending on the file handling of your webserver and your tiki settings, it may be possible that an attacker can upload scripts to file gallery and execute them\",\"ack\":false},\"allow_url_fopen\":{\"setting\":\"Enabled\",\"fitness\":\"gef\\u00e4hrlich\",\"message\":\"allow_url_fopen may potentially be used to upload remote data or scripts. Also used by Composer to fetch dependencies. If you dont use the blog feature, you can switch it off.\",\"ack\":false}}}'),
('tiki_release_cycle', 'longterm'),
('tiki_version_check_frequency', '2592000'),
('tikiIndex', 'tiki-custom_home.php'),
('toolbar_global', '\r\n							bold\r\n						,\r\n							italic\r\n						,\r\n							underline\r\n						,\r\n							strike\r\n						,\r\n							sub\r\n						,\r\n							sup\r\n						,\r\n							-\r\n						,\r\n							color\r\n						,\r\n							-\r\n						,\r\n							tikiimage\r\n						,\r\n							tikilink\r\n						,\r\n							link\r\n						,\r\n							email\r\n						,\r\n							unlink\r\n						,\r\n							anchor\r\n						,\r\n							-\r\n						,\r\n							undo\r\n						,\r\n							redo\r\n						,\r\n							-\r\n						,\r\n							find\r\n						,\r\n							replace\r\n						,\r\n							-\r\n						,\r\n							removeformat\r\n						,\r\n							specialchar\r\n						,\r\n							smiley\r\n						|\r\n							help\r\n						,\r\n							switcheditor\r\n						,\r\n							autosave\r\n						,\r\n							admintoolbar\r\n						,wikiplugin_\r\n							code\r\n						/\r\n							format\r\n						,\r\n							cut\r\n						,\r\n							copy\r\n						,\r\n							paste\r\n						,\r\n							pastetext\r\n						,\r\n							pasteword\r\n						,\r\n							-\r\n						,\r\n							h1\r\n						,\r\n							h2\r\n						,\r\n							h3\r\n						,\r\n							left\r\n						,\r\n							center\r\n						,wikiplugin_\r\n							quote\r\n						,\r\n							-\r\n						,\r\n							list\r\n						,\r\n							numlist\r\n						,\r\n							-\r\n						,\r\n							pagebreak\r\n						,\r\n							rule\r\n						,\r\n							-\r\n						,\r\n							table\r\n						,\r\n							-\r\n						,\r\n							source\r\n						,\r\n							showblocks\r\n						,\r\n							screencapture\r\n						,\r\n							-\r\n						,wikiplugin_\r\n							vimeo\r\n						,wikiplugin_\r\n							youtube\r\n						,\r\n							-\r\n						,\r\n							toc\r\n						|\r\n							fullscreen\r\n						/\r\n							style\r\n						,\r\n							fontname\r\n						,\r\n							fontsize\r\n						,\r\n							outdent\r\n						,\r\n							indent\r\n						/'),
('toolbar_globalmodified', 'y'),
('trackerfield_action', 'y'),
('trackerfield_file', 'y'),
('trackerfield_geographicfeature', 'y'),
('trackerfield_userpreference', 'y'),
('trackerfield_webservice', 'n'),
('uf_use_db', 'n'),
('uf_use_dir', 'files/users/'),
('unified_engine', 'lucene'),
('unified_excluded_categories', 'a:1:{i:0;s:0:\"\";}'),
('unified_identifier_fields', 'a:38:{i:0;s:8:\"language\";i:1;s:15:\"view_permission\";i:2;s:3:\"url\";i:3;s:4:\"hash\";i:4;s:13:\"primary_image\";i:5;s:13:\"comment_count\";i:6;s:11:\"geo_located\";i:7;s:12:\"geo_location\";i:8;s:13:\"title_initial\";i:9;s:15:\"title_firstword\";i:10;s:10:\"searchable\";i:11;s:11:\"object_type\";i:12;s:9:\"object_id\";i:13;s:8:\"forum_id\";i:14;s:13:\"forum_section\";i:15;s:16:\"parent_thread_id\";i:16;s:18:\"parent_object_type\";i:17;s:16:\"parent_object_id\";i:18;s:22:\"parent_view_permission\";i:19;s:4:\"hits\";i:20;s:14:\"root_thread_id\";i:21;s:11:\"thread_type\";i:22;s:6:\"locked\";i:23;s:13:\"lastpost_hits\";i:24;s:18:\"lastpost_thread_id\";i:25;s:8:\"filename\";i:26;s:10:\"gallery_id\";i:27;s:22:\"global_view_permission\";i:28;s:10:\"addongroup\";i:29;s:16:\"addonleadergroup\";i:30;s:17:\"addonpendinggroup\";i:31;s:10:\"event_type\";i:32;s:4:\"type\";i:33;s:6:\"object\";i:34;s:9:\"parent_id\";i:35;s:4:\"user\";i:36;s:7:\"page_id\";i:37;s:7:\"version\";}'),
('unified_incremental_update', 'n'),
('unified_last_rebuild', '1643748128'),
('unified_lucene_default_operator', '1'),
('unified_lucene_highlight', 'y'),
('unified_lucene_max_resultset_limit', '0'),
('unified_mysql_index_current', 'index_61f99b2034989'),
('unified_parse_results', 'y'),
('unsuccessful_logins', '4'),
('unsuccessful_logins_invalid', '6'),
('urlIndex', 'tiki-index.php?page=HomePage'),
('use_proxy', 'n'),
('user_flip_modules', 'n'),
('user_picture_gallery_id', NULL),
('user_selector_realnames_messu', 'y'),
('user_show_realnames', 'y'),
('user_store_file_gallery_picture', 'n'),
('user_unique_email', 'y'),
('useRegisterPasscode', 'y'),
('userfiles_quota', '30'),
('username_pattern', '/^[ \'\\-_a-zA-Z0-9@ÄÖÜäöüß\\.]*$/'),
('users_prefs_display_timezone', 'Site'),
('users_prefs_mess_sendReadStatus', 'y'),
('users_prefs_mytiki_blogs', 'n'),
('users_prefs_mytiki_gals', 'n'),
('useUrlIndex', 'y'),
('validateRegistration', 'y'),
('validateUsers', 'y'),
('warn_on_edit_time', '30'),
('wiki_actions_bar', 'both'),
('wiki_authors_style', 'lastmodif'),
('wiki_auto_toc', 'n'),
('wiki_comments_allow_per_page', 'y'),
('wiki_comments_default_ordering', 'commentDate_asc'),
('wiki_comments_displayed_default', 'y'),
('wiki_comments_form_displayed_default', 'y'),
('wiki_dynvar_multilingual', 'y'),
('wiki_edit_minor', 'y'),
('wiki_feature_copyrights', 'y'),
('wiki_page_name_above', 'n'),
('wiki_page_navigation_bar', 'both'),
('wiki_url_scheme', 'urlencode'),
('wiki_watch_comments', 'y'),
('wikiHomePage', 'META-Wiki english'),
('wikiLicensePage', 'META-Wiki+english&no_bl=y#License'),
('wikiplugin_addfreetag', 'y'),
('wikiplugin_alink', 'y'),
('wikiplugin_aname', 'y'),
('wikiplugin_attach', 'n'),
('wikiplugin_avatar', 'y'),
('wikiplugin_backlinks', 'y'),
('wikiplugin_bigbluebutton', 'n'),
('wikiplugin_button', 'y'),
('wikiplugin_calendar', 'n'),
('wikiplugin_carousel', 'y'),
('wikiplugin_draw', 'n'),
('wikiplugin_events', 'n'),
('wikiplugin_favorite', 'n'),
('wikiplugin_flash', 'n'),
('wikiplugin_galleriffic', 'y'),
('wikiplugin_iframe', 'y'),
('wikiplugin_invite', 'n'),
('wikiplugin_kaltura', 'n'),
('wikiplugin_list', 'y'),
('wikiplugin_listpages', 'y'),
('wikiplugin_mail', 'y'),
('wikiplugin_map', 'n'),
('wikiplugin_pagetabs', 'y'),
('wikiplugin_perm', 'y'),
('wikiplugin_proposal', 'y'),
('wikiplugin_realnamelist', 'y'),
('wikiplugin_sharethis', 'y'),
('wikiplugin_showpages', 'y'),
('wikiplugin_slider', 'y'),
('wikiplugin_topfriends', 'n'),
('wikiplugin_tr', 'y'),
('wikiplugin_trackercomments', 'n'),
('wikiplugin_userpref', 'y'),
('wikiplugin_wantedpages', 'y'),
('wikiplugin_zotero', 'n'),
('wikiplugininline_button', 'y'),
('wikipluginprefs_pending_notification', 'y'),
('wikiSubmitNotice', 'META-Wiki license'),
('wizard_admin_hide_on_login', 'y'),
('wysiwyg_default', 'n'),
('wysiwyg_htmltowiki', 'n'),
('wysiwyg_optional', 'n'),
('wysiwyg_wiki_parsed', 'n');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `tiki_sent_newsletters`
--

CREATE TABLE `tiki_sent_newsletters` (
  `editionId` int(12) NOT NULL,
  `nlId` int(12) NOT NULL DEFAULT '0',
  `users` int(10) DEFAULT NULL,
  `sent` int(14) DEFAULT NULL,
  `subject` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `data` longblob,
  `datatxt` longblob,
  `wysiwyg` char(1) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Daten für Tabelle `tiki_sent_newsletters`
--

INSERT INTO `tiki_sent_newsletters` (`editionId`, `nlId`, `users`, `sent`, `subject`, `data`, `datatxt`, `wysiwyg`) VALUES
(1, 2, 69, 1513114136, 'META-Health Gemeinschaftstreffen und Neues von der IMMA - Dezember 2017', 0x[encoded data, 9894 characters], 0x[encoded data, 9482 characters], 'n'),
(2, 3, 395, 1513128139, 'META-Health Convention and exciting new stuff in IMMA - December 2017', 0x[encoded data, 8116 characters], 0x[encoded data, 7904 characters], 'n');
INSERT INTO `tiki_sent_newsletters` (`editionId`, `nlId`, `users`, `sent`, `subject`, `data`, `datatxt`, `wysiwyg`) VALUES
(3, 4, 339, 1518732793, 'Your IMMA and META-Health resources - february 2018', 0x[encoded data, 9560 characters], 0x[encoded data, 8700 characters], 'n'),
(4, 5, 71, 1518738737, 'Aktuelle Neuigkeiten für alle IMMA-Mitglieder - Februar 2018', 0x[encoded data, 9376 characters], 0x[encoded data, 9024 characters], 'n'),
(5, 6, 71, 1523266292, 'Aktuelle Neuigkeiten für alle IMMA-Mitglieder - April', 0x[encoded data, 8090 characters], 0x4469657365204e616368726963687420697374206e757220696d2048544d4c2d466f726d61742076657266617373742e, 'n');
INSERT INTO `tiki_sent_newsletters` (`editionId`, `nlId`, `users`, `sent`, `subject`, `data`, `datatxt`, `wysiwyg`) VALUES
(6, 7, 341, 1523275355, 'Your IMMA and META-Health resources - april 2018', 0x[encoded data, 8072 characters], 0x54686973206d656d6265727327206e6f74696669636174696f6e20697320666f726d617474656420696e2048544d4c206f6e6c792e, 'n'),
(7, 8, 0, -1, 'IMMA will become MHI - member notifications july 2018', 0x5468697320656d61696c2069732073656e7420696e202074657874206f6e6c7920666f726d61742e, 0x[encoded data, 9870 characters], 'n'),
(8, 9, 1, 1530993296, 'Tset July 2018', 0x54657874206f6e6c79, 0x[encoded data, 9870 characters], 'n'),
(9, 9, 1, 1530994269, 'Test 2', 0x[encoded data, 10002 characters], 0x[encoded data, 9870 characters], 'n');
INSERT INTO `tiki_sent_newsletters` (`editionId`, `nlId`, `users`, `sent`, `subject`, `data`, `datatxt`, `wysiwyg`) VALUES
(10, 9, 1, 1530994849, 'Test 3', '', 0x[encoded data, 9870 characters], 'n'),
(11, 10, 355, 1530997970, 'IMMA will become MHI - member notifications july 2018', 0x[encoded data, 10102 characters], 0x[encoded data, 9830 characters], 'n');
INSERT INTO `tiki_sent_newsletters` (`editionId`, `nlId`, `users`, `sent`, `subject`, `data`, `datatxt`, `wysiwyg`) VALUES
(12, 11, 73, 1531083415, 'IMMA wird MHI! - Mitgliederinformation Juli 2018', 0x[encoded data, 10870 characters], 0x[encoded data, 10700 characters], 'n'),
(13, 10, 357, 1540027444, 'Live stream from the META-Health Convention in Barcelona', '', 0x546f6765746865722077697468206f7572206c6f63616c20736572766963652070726f766964657220696e2042617263656c6f6e612077652077696c6c2073686f7274207465726d6564206f7267616e697a652061206c6976652073747265616d2066726f6d20746865204d4554412d4865616c746820436f6e76656e74696f6e20696e204844207175616c6974792e2057652077696c6c206265206f6e20737461676520776974682074776f2063616d657261732e0d0a0d0a546865206c6f63616c2073747265616d696e672074696d657320696e20537061696e2077696c6c206265203a0d0a0d0a54687572736461792c206f63746f6265722032352c2066726f6d20393a303020746f2031333a303020616e642066726f6d2031353a303020746f2031393a3030202857455354290d0a4672696461792c206f63746f6265722032362c202066726f6d20393a303020746f2031333a3030202857455354290d0a53617475726461792c206f63746f6265722032372c202066726f6d20393a303020746f2031333a3030202857455354290d0a53756e6461792c206f63746f6265722032382c202066726f6d20393a303020746f2031333a30302028574554290d0a0d0a506c65617365206f6273657276652c207468617420537061696e2077696c6c206368616e67652066726f6d206461796c6967687420736176696e672074696d6520746f207374616e646172642074696d652061742074686520436f6e76656e74696f6e2773207765656b656e642e0d0a0d0a5765206861766520353020706c6163657320617661696c61626c6520666f722039352045555220656163682e20466972737420636f6d652c206669727374207365727665210d0a0d0a416c6c20617474656e646565732077696c6c20616c736f206765742061636365737320746f20746865207265636f7264696e6773206f662074686520436f6e76656e74696f6e2c20617320746865206c6976652073747265616d2077696c6c20626520746563686e6963616c6c792070726f76696465642061732069732e0d0a0d0a446972656374206c696e6b20746f20726573657276652061636365737320746f20746865206c6976652073747265616d3a0d0a0d0a68747470733a2f2f7777772e6d6574612d6865616c74682e696e666f2f62617263656c6f6e612d7370697269742d6f662d77652d636f6e76656e74696f6e2f23626f6f6b696e670d0a0d0a506c6561736520737072656164207468697320696e666f726d6174696f6e20616c736f20746f20796f757220706572736f6e616c204d4554412d4865616c7468206e6574776f726b206e6f7721, 'n'),
(14, 11, 84, 1540114551, 'Livestream von der META-Health Convention in Barcelona', '', 0x5a7573616d6d656e206d697420756e736572656d206c6f6b616c656e205365727669636570726f766964657220696e2042617263656c6f6e612077657264656e20776972206b75727a667269737469672065696e656e204c69766573747265616d20696e2048442d5175616c6974c3a47420766f6e20646572204d4554412d4865616c746820436f6e76656e74696f6e206f7267616e6973696572656e2e205769722077657264656e206d6974207a776569204b616d65726173206461732047657363686568656e206175666e65686d656e2e0d0a0d0a4469652053656e64657a656974656e2077657264656e207365696e3a0d0a0d0a446f6e6e6572737461672c2032352e204f6b746f6265722c20766f6e20393a3030206269732031333a303020756e6420766f6e2031353a3030206269732031393a303020284d45535a290d0a467265697461672c2032362e204f6b746f6265722c2020766f6e20393a3030206269732031333a303020284d45535a290d0a53616d737461672c2032372e204f6b746f6265722c2020766f6e20393a3030206269732031333a303020284d45535a290d0a536f6e6e7461672c2032382e204f6b746f6265722c2020766f6e20393a3030206269732031333a303020284d455a290d0a0d0a426974746520616d20576f6368656e656e64652064656e205765636873656c20766f6e20536f6d6d65722d207a752057696e7465727a65697420626561636874656e2e0d0a0d0a5769722068616c74656e203530205a7567c3a46e6765207a756d20507265697320766f6e20393520455552206265726569742c2064696520696e206465722052656968656e666f6c67652064657220416e6d656c64756e6720766572676562656e2077657264656e2e0d0a0d0a416c6c65205465696c6e65686d657220657268616c74656e207a7564656d205a7567616e67207a752064656e20566964656f6175666e61686d656e2064657220436f6e76656e74696f6e2e0d0a0d0a446972656b746c696e6b207a757220526573657276696572756e672028696e20456e676c69736368293a0d0a0d0a68747470733a2f2f7777772e6d6574612d6865616c74682e696e666f2f62617263656c6f6e612d7370697269742d6f662d77652d636f6e76656e74696f6e2f23626f6f6b696e670d0a0d0a4269747465207665726272656974657420646965736520496e666f726d6174696f6e206175636820696e20457572656e2070657273c3b66e6c696368656e204e65747a7765726b656e2e, 'n'),
(15, 10, 358, 1543936133, 'My META-Health: members\' notifications december 2018', '', 0x[encoded data, 7768 characters], 'n'),
(16, 11, 87, 1543946090, 'Mein META-Health: Mitgliederinformationen Dezember 2018', '', 0x[encoded data, 8188 characters], 'n'),
(17, 11, 87, 1544784119, 'Schreibfehler - internationales Meeting heute abend um 19 Uhr MEZ', 0x4c69656265204d6974676c6965646572210d0a0d0a0d0a496e20756e73657265206c65747a74652042656e61636872696368746967756e672068617474652073696368206c65696465722065696e20536368726569626665686c65722065696e67657363686c696368656e2e2044696520726963687469676520496e666f726d6174696f6e206c61757465742077696520666f6c67743a0d0a0d0a2a202a202a202a202a0d0a0d0a312e35205a7573616d6d656e68616c7420756e642057656974657262696c64756e670d0a0d0a4d4849732041627369636874206973742c20696e20726567656c6dc3a4c39f6967656d204b6f6e74616b74207a75207365696e2e20446166c3bc722062696574656e20776972204f6e6c696e657472656666656e20756e6420576562696e61726520616e2c20756d205468656d656e2067656d65696e73616d656e20496e7465726573736573207a752076657274696566656e20756e6420756d204d4554412d4865616c746820776569746572207a7520656e747769636b656c6e2e205a756d205374617274206c6164656e2077697220616c6c65204d6974676c6965646572207a756d205472656666656e2028696e20656e676c2e205370726163686529206d6974205265666c656b74696f6e656e207a757220436f6e76656e74696f6e20736f776965206d69742046726167657374756e6465207a7572204d48492065696e2e0d0a416d20467265697461672031342e2044657a656d62657220756d2031393a303020646575747363686572205a65697420686965723a0d0a68747470733a2f2f7a6f6f6d2e75732f6a2f3935353234303336320d0a0d0a446173206ec3a46368737465204d4554412d4865616c74682050726f2d436166c3a920616c73206465757473636873707261636869676572205375706572766973696f6e732d20756e642041757374617573636874726566662066696e64657420616d2032332e204a616e75617220756d2032303a303020646575747363686572205a6569742073746174742e0d0a0d0a2a202a202a202a202a0d0a0d0a4265737465204772c3bc7373650d0a54686f727374656e, 0x4c69656265204d6974676c6965646572210d0a0d0a0d0a496e20756e73657265206c65747a74652042656e61636872696368746967756e672068617474652073696368206c65696465722065696e20536368726569626665686c65722065696e67657363686c696368656e2e2044696520726963687469676520496e666f726d6174696f6e206c61757465742077696520666f6c67743a0d0a0d0a2a202a202a202a202a0d0a0d0a312e35205a7573616d6d656e68616c7420756e642057656974657262696c64756e670d0a0d0a4d4849732041627369636874206973742c20696e20726567656c6dc3a4c39f6967656d204b6f6e74616b74207a75207365696e2e20446166c3bc722062696574656e20776972204f6e6c696e657472656666656e20756e6420576562696e61726520616e2c20756d205468656d656e2067656d65696e73616d656e20496e7465726573736573207a752076657274696566656e20756e6420756d204d4554412d4865616c746820776569746572207a7520656e747769636b656c6e2e205a756d205374617274206c6164656e2077697220616c6c65204d6974676c6965646572207a756d205472656666656e2028696e20656e676c2e205370726163686529206d6974205265666c656b74696f6e656e207a757220436f6e76656e74696f6e20736f776965206d69742046726167657374756e6465207a7572204d48492065696e2e0d0a416d20467265697461672031342e2044657a656d62657220756d2031393a303020646575747363686572205a65697420686965723a0d0a68747470733a2f2f7a6f6f6d2e75732f6a2f3935353234303336320d0a0d0a446173206ec3a46368737465204d4554412d4865616c74682050726f2d436166c3a920616c73206465757473636873707261636869676572205375706572766973696f6e732d20756e642041757374617573636874726566662066696e64657420616d2032332e204a616e75617220756d2032303a303020646575747363686572205a6569742073746174742e0d0a0d0a2a202a202a202a202a0d0a0d0a4265737465204772c3bc7373650d0a54686f727374656e, 'n');
INSERT INTO `tiki_sent_newsletters` (`editionId`, `nlId`, `users`, `sent`, `subject`, `data`, `datatxt`, `wysiwyg`) VALUES
(18, 11, 88, 1548026045, 'Mein META-Health - Mitgliederinformationen Januar 2019', 0x[encoded data, 9378 characters], 0x[encoded data, 9526 characters], 'n'),
(19, 10, 358, 1548201115, 'My META-Health - members\' notifications January 2019', 0x[encoded data, 10442 characters], 0x[encoded data, 10250 characters], 'n'),
(20, 10, 359, 1549671994, '[META-Health Community] In transit - from IMMA to MHI (1)', 0x[encoded data, 4114 characters], 0x2d202d202d20546578742076657273696f6e202d202d202d0d0a4465617220436f6d6d756e697479206d656d62657273210d0a0d0a54686520646576656c6f706d656e742070726f63657373206f6620746865206e6577204d4554412d4865616c746820496e7465726e6174696f6e616c20646174616261736520697320636f6d706c657465206e6f772e205468652064617461626173652077696c6c206e6f74206f6e6c7920626520746865206261736520746f2061646d696e6973747261746520616c6c206d656d626572732c2062757420616c736f206665656420746865206e657720757020746f20646174652070726163746974696f6e657220616e6420747261696e6572206c697374732c20746f2062652070726573656e746564206f6e20746865207075626c6963204d4554412d4865616c74682077656273697465207777772e6d6574612d6865616c74682e696e666f2e200d0a0d0a546f2061766f6964206f7574646174656420696e666f726d6174696f6e732c2077652077696c6c2061736b20616c6c2070726573656e7420616e64206561726c69657220494d4d41206d656d6265727320746f207369676e20757020666f72204d4849206d656d6265727368697020616e6420746f20636f6d706c65746520746865206d656d6265727368697020666f726d207468656d73656c7665732e2054686520646174612077696c6c20626520636f6c6c61746564207769746820746865206f6c6420494d4d41206461746162617365732e0d0a0d0a4f7572204d4554412d4865616c7468204d617374657220547261696e6572732077696c6c2062652074686520666972737420746f207369676e2075702e20546869732077696c6c20656e61626c6520757320746f206d616b65206d696e6f722061646a7573746d656e7473206f6620746865207369676e2075702070726f636573732c206966206e65636573736172792e0d0a0d0a4d65616e7768696c6520616c6c20737562736372697074696f6e7320666f7220494d4d41206d656d626572736869702077696c6c2062652063616e63656c6c65642077697468696e20746865206e657874207765656b732c20746f207072657061726520746865206c69717569646174696f6e206f6620494d4d412061742074686520656e64206f6620746865207472616e736974696f6e20706572696f642e20416c6c20494d4d41206d656d62657273686970207061796d656e7473206d61646520666f7220323031392077696c6c20626520637265646974656420666f72204d4849206d656d626572736869702e0d0a0d0a4d48492077696c6c206973737565206e6577207175616c696669636174696f6e206365727469666963617465732061732077656c6c206173206e65772061636372656469746174696f6e206365727469666963617465732c206c6173746e616d656420666f7220616374697665204d4554412d4865616c74682070726f66657373696f6e616c732e20546865206e6577204d4849206365727469666963617465732077696c6c207265706c61636520746865206f6c6420494d4d41206365727469666963617465732e0d0a0d0a4576656e74206e6f746963650d0a41732070726f706f736564206f6e20746865204d4554412d4865616c746820436f6e76656e74696f6e2c204d48492077696c6c206f7267616e697a6520726567756c617220776562696e61727320616e64206d656574696e677320666f722065786368616e676520616e64206f6e676f696e6720656475636174696f6e20616d6f6e67206d656d626572732e205468697320697320746865206669727374206f6e6520696e20323031393a0d0a4d65657420416e75204d656874612066726f6d20496e6469612c2077686f2073686172657320616e6420646973637573736573202267656e65726174696f6e616c207061747465726e7320696e206469736561736522200d0a6f6e206d6f6e6461792031317468206f662066656272756172792061742035706d20474d542028746869732074696d65207265666c656374732036706d20696e204e6f727761792c2044656e6d61726b2c204765726d616e792c20537061696e3b2037706d20696e2046696e6c616e642c204573746f6e69612c20456779707420616e6420536f757468204166726963612c2031303a3330706d20696e20496e64696120616e642039616d20696e205765737465726e2055534129200d0a54686572652069732074696d6520666f7220636f6d6d756e6974792064697363757373696f6e20616e642065786368616e6765206f6620657870657269656e6365732e2054686520776562696e61722077696c6c206265207265636f726465642e200d0a0d0a5768656e2070617274696369706174696e672c20706c656173652072656d656d62657220746f204d55544520796f757273656c66207768656e206e6f7420737065616b696e6720746f2065766572796f6e652c20616e6420706c6561736520646f204e4f5420736861726520796f75722073637265656e20756e6c65737320696e766974656420746f2e200d0a0d0a466f6c6c6f772074686973206c696e6b20746f20706172746963697061746520696e2074686520776562696e617220286e6f20726567697374726174696f6e293a200d0a68747470733a2f2f7a6f6f6d2e75732f6a2f3935353234303336320d0a0d0a42657374207769736865730d0a54686f727374656e0d0a, 'n');
INSERT INTO `tiki_sent_newsletters` (`editionId`, `nlId`, `users`, `sent`, `subject`, `data`, `datatxt`, `wysiwyg`) VALUES
(21, 12, 1, 1549709967, '[META-Health Community] In transit - from IMMA to MHI (1)', 0x[encoded data, 4114 characters], 0x2d202d202d20546578742076657273696f6e202d202d202d0d0a4465617220436f6d6d756e697479206d656d62657273210d0a0d0a54686520646576656c6f706d656e742070726f63657373206f6620746865206e6577204d4554412d4865616c746820496e7465726e6174696f6e616c20646174616261736520697320636f6d706c657465206e6f772e205468652064617461626173652077696c6c206e6f74206f6e6c7920626520746865206261736520746f2061646d696e6973747261746520616c6c206d656d626572732c2062757420616c736f206665656420746865206e657720757020746f20646174652070726163746974696f6e657220616e6420747261696e6572206c697374732c20746f2062652070726573656e746564206f6e20746865207075626c6963204d4554412d4865616c74682077656273697465207777772e6d6574612d6865616c74682e696e666f2e200d0a0d0a546f2061766f6964206f7574646174656420696e666f726d6174696f6e732c2077652077696c6c2061736b20616c6c2070726573656e7420616e64206561726c69657220494d4d41206d656d6265727320746f207369676e20757020666f72204d4849206d656d6265727368697020616e6420746f20636f6d706c65746520746865206d656d6265727368697020666f726d207468656d73656c7665732e2054686520646174612077696c6c20626520636f6c6c61746564207769746820746865206f6c6420494d4d41206461746162617365732e0d0a0d0a4f7572204d4554412d4865616c7468204d617374657220547261696e6572732077696c6c2062652074686520666972737420746f207369676e2075702e20546869732077696c6c20656e61626c6520757320746f206d616b65206d696e6f722061646a7573746d656e7473206f6620746865207369676e2075702070726f636573732c206966206e65636573736172792e0d0a0d0a4d65616e7768696c6520616c6c20737562736372697074696f6e7320666f7220494d4d41206d656d626572736869702077696c6c2062652063616e63656c6c65642077697468696e20746865206e657874207765656b732c20746f207072657061726520746865206c69717569646174696f6e206f6620494d4d412061742074686520656e64206f6620746865207472616e736974696f6e20706572696f642e20416c6c20494d4d41206d656d62657273686970207061796d656e7473206d61646520666f7220323031392077696c6c20626520637265646974656420666f72204d4849206d656d626572736869702e0d0a0d0a4d48492077696c6c206973737565206e6577207175616c696669636174696f6e206365727469666963617465732061732077656c6c206173206e65772061636372656469746174696f6e206365727469666963617465732c206c6173746e616d656420666f7220616374697665204d4554412d4865616c74682070726f66657373696f6e616c732e20546865206e6577204d4849206365727469666963617465732077696c6c207265706c61636520746865206f6c6420494d4d41206365727469666963617465732e0d0a0d0a4576656e74206e6f746963650d0a41732070726f706f736564206f6e20746865204d4554412d4865616c746820436f6e76656e74696f6e2c204d48492077696c6c206f7267616e697a6520726567756c617220776562696e61727320616e64206d656574696e677320666f722065786368616e676520616e64206f6e676f696e6720656475636174696f6e20616d6f6e67206d656d626572732e205468697320697320746865206669727374206f6e6520696e20323031393a0d0a4d65657420416e75204d656874612066726f6d20496e6469612c2077686f2073686172657320616e6420646973637573736573202267656e65726174696f6e616c207061747465726e7320696e206469736561736522200d0a6f6e206d6f6e6461792031317468206f662066656272756172792061742035706d20474d542028746869732074696d65207265666c656374732036706d20696e204e6f727761792c2044656e6d61726b2c204765726d616e792c20537061696e3b2037706d20696e2046696e6c616e642c204573746f6e69612c20456779707420616e6420536f757468204166726963612c2031303a3330706d20696e20496e64696120616e642039616d20696e205765737465726e2055534129200d0a54686572652069732074696d6520666f7220636f6d6d756e6974792064697363757373696f6e20616e642065786368616e6765206f6620657870657269656e6365732e2054686520776562696e61722077696c6c206265207265636f726465642e200d0a0d0a5768656e2070617274696369706174696e672c20706c656173652072656d656d62657220746f204d55544520796f757273656c66207768656e206e6f7420737065616b696e6720746f2065766572796f6e652c20616e6420706c6561736520646f204e4f5420736861726520796f75722073637265656e20756e6c65737320696e766974656420746f2e200d0a0d0a466f6c6c6f772074686973206c696e6b20746f20706172746963697061746520696e2074686520776562696e617220286e6f20726567697374726174696f6e293a200d0a68747470733a2f2f7a6f6f6d2e75732f6a2f3935353234303336320d0a0d0a42657374207769736865730d0a54686f727374656e0d0a, 'n'),
(22, 13, 1, 1549710485, '[META-Health Community] In transit - from IMMA to MHI (1)', 0x[encoded data, 4114 characters], 0x2d202d202d20546578742076657273696f6e202d202d202d0d0a4465617220436f6d6d756e697479206d656d62657273210d0a0d0a54686520646576656c6f706d656e742070726f63657373206f6620746865206e6577204d4554412d4865616c746820496e7465726e6174696f6e616c20646174616261736520697320636f6d706c657465206e6f772e205468652064617461626173652077696c6c206e6f74206f6e6c7920626520746865206261736520746f2061646d696e6973747261746520616c6c206d656d626572732c2062757420616c736f206665656420746865206e657720757020746f20646174652070726163746974696f6e657220616e6420747261696e6572206c697374732c20746f2062652070726573656e746564206f6e20746865207075626c6963204d4554412d4865616c74682077656273697465207777772e6d6574612d6865616c74682e696e666f2e200d0a0d0a546f2061766f6964206f7574646174656420696e666f726d6174696f6e732c2077652077696c6c2061736b20616c6c2070726573656e7420616e64206561726c69657220494d4d41206d656d6265727320746f207369676e20757020666f72204d4849206d656d6265727368697020616e6420746f20636f6d706c65746520746865206d656d6265727368697020666f726d207468656d73656c7665732e2054686520646174612077696c6c20626520636f6c6c61746564207769746820746865206f6c6420494d4d41206461746162617365732e0d0a0d0a4f7572204d4554412d4865616c7468204d617374657220547261696e6572732077696c6c2062652074686520666972737420746f207369676e2075702e20546869732077696c6c20656e61626c6520757320746f206d616b65206d696e6f722061646a7573746d656e7473206f6620746865207369676e2075702070726f636573732c206966206e65636573736172792e0d0a0d0a4d65616e7768696c6520616c6c20737562736372697074696f6e7320666f7220494d4d41206d656d626572736869702077696c6c2062652063616e63656c6c65642077697468696e20746865206e657874207765656b732c20746f207072657061726520746865206c69717569646174696f6e206f6620494d4d412061742074686520656e64206f6620746865207472616e736974696f6e20706572696f642e20416c6c20494d4d41206d656d62657273686970207061796d656e7473206d61646520666f7220323031392077696c6c20626520637265646974656420666f72204d4849206d656d626572736869702e0d0a0d0a4d48492077696c6c206973737565206e6577207175616c696669636174696f6e206365727469666963617465732061732077656c6c206173206e65772061636372656469746174696f6e206365727469666963617465732c206c6173746e616d656420666f7220616374697665204d4554412d4865616c74682070726f66657373696f6e616c732e20546865206e6577204d4849206365727469666963617465732077696c6c207265706c61636520746865206f6c6420494d4d41206365727469666963617465732e0d0a0d0a4576656e74206e6f746963650d0a41732070726f706f736564206f6e20746865204d4554412d4865616c746820436f6e76656e74696f6e2c204d48492077696c6c206f7267616e697a6520726567756c617220776562696e61727320616e64206d656574696e677320666f722065786368616e676520616e64206f6e676f696e6720656475636174696f6e20616d6f6e67206d656d626572732e205468697320697320746865206669727374206f6e6520696e20323031393a0d0a4d65657420416e75204d656874612066726f6d20496e6469612c2077686f2073686172657320616e6420646973637573736573202267656e65726174696f6e616c207061747465726e7320696e206469736561736522200d0a6f6e206d6f6e6461792031317468206f662066656272756172792061742035706d20474d542028746869732074696d65207265666c656374732036706d20696e204e6f727761792c2044656e6d61726b2c204765726d616e792c20537061696e3b2037706d20696e2046696e6c616e642c204573746f6e69612c20456779707420616e6420536f757468204166726963612c2031303a3330706d20696e20496e64696120616e642039616d20696e205765737465726e2055534129200d0a54686572652069732074696d6520666f7220636f6d6d756e6974792064697363757373696f6e20616e642065786368616e6765206f6620657870657269656e6365732e2054686520776562696e61722077696c6c206265207265636f726465642e200d0a0d0a5768656e2070617274696369706174696e672c20706c656173652072656d656d62657220746f204d55544520796f757273656c66207768656e206e6f7420737065616b696e6720746f2065766572796f6e652c20616e6420706c6561736520646f204e4f5420736861726520796f75722073637265656e20756e6c65737320696e766974656420746f2e200d0a0d0a466f6c6c6f772074686973206c696e6b20746f20706172746963697061746520696e2074686520776562696e617220286e6f20726567697374726174696f6e293a200d0a68747470733a2f2f7a6f6f6d2e75732f6a2f3935353234303336320d0a0d0a42657374207769736865730d0a54686f727374656e0d0a, 'n'),
(23, 14, 0, -1, '[META-Health International] Ready for Boarding', 0x[encoded data, 4140 characters], 0x526561647920666f7220626f617264696e67202d20596f75206172652020696e20746865207072696f72697479206c616e65210d0a44656172204d4554412d4865616c7468204d617374657220547261696e6572210d0a0d0a596f7520617265206e6f7720696e20746865207072696f72697479206c616e6520746f207369676e20757020666f72206f7572206e6577204d4554412d4865616c74682070726f66657373696f6e616c73206c6973742e0d0a0d0a5765206861766520612074776f2d70617274207369676e2075702070726f636573732e204166746572207375626d697474696e6720796f75722067656e6572616c206461746120796f75276c6c20676574206120706572736f6e616c206c696e6b20746f20616464206d6f72652064657461696c732e205769746820796f757220706572736f6e616c206c696e6b20796f752063616e20616e7974696d652061636365737320796f75722070726f66696c6520746f20616464206f72206368616e676520646174612e0d0a0d0a5369676e207570206e6f77210d0a0d0a4d4554412d4865616c7468206973206120686f6c6973746963206d6574686f646f6c6f67790d0a4d4554412d4865616c7468206861732061206d6574686f646f6c6f6779206f6620616371756972696e6720616e64207573696e672074686520696e666f726d6174696f6e206e656365737361727920666f7220756e6465727374616e64696e6720696e646976696475616c2064697365617365732c20616e6420666163696c69746174696e672073656c662d6865616c696e672061732077656c6c20617320706572736f6e616c2067726f7774682e2054686973206d6574686f646f6c6f6779206973206b657920746f206d616e7920646966666572656e74206d6574686f647320616e64206d6f64616c697469657320746861742063616e206265207573656420696e73696465206f757220636f6d6d6f6e204d4554412d4865616c746820636f6e636570742e20546865736520646966666572656e63657320616e642074686520646976657273697479206f66206f757220636f6d6d756e697479206172652074686520466c61766f757273206f66204d4554412d4865616c74682e2052656164206d6f726520686572653a0d0a0d0a4d4554412d4865616c7468202d20536369656e636520616e64207265666572656e6365732f0d0a596f752061726520756e69717565210d0a0d0a4974206973206f757220696e74656e74696f6e20746f2070726573656e7420796f75206173204d4554412d4865616c746820747261696e657220746f20746865207075626c6963207769746820796f757220756e6971756520696e646976696475616c2070726f66696c652e0d0a0d0a5468657265666f7265204d48492077696c6c20696e2066757475726520646966666572656e7469617465206265747765656e20747261696e657220726f6c657320726567617264696e672074686520747261696e696e677327206d61696e20636f6e74656e743a0d0a0d0a4d4554412d4865616c746820466f756e646174696f6e20547261696e657220283d20666f726d657220494d4d41204d4554412d4865616c746820547261696e6572290d0a4d4554412d4865616c7468204d6f64616c69747920547261696e65720d0a4d4554412d4865616c74682043657274696669636174696f6e20547261696e657220283d20666f726d657220494d4d41204d4554412d4865616c7468204d617374657220547261696e6572290d0a4d4554412d4865616c7468204d6f64616c6974696573206d65616e206d6574686f64732077686963682061726520747261696e65642077697468696e20746865204d4554412d4865616c7468206d6574686f646f6c6f677920286c696b65204546542c204e4c502c2054686520576f726b2c20546865204a6f75726e65792c206574632e290d0a0d0a57656c636f6d6520746f204d4554412d4865616c746820496e7465726e6174696f6e616c202d2074686520676c6f62616c206e6574776f726b206f6620686f6c6973746963206865616c74682070726f66657373696f6e616c73210d0a0d0a, 'n'),
(24, 10, 360, 1552219959, 'META-Health International - Ready for Boarding', 0x[encoded data, 4262 characters], 0x[encoded data, 4202 characters], 'n'),
(25, 10, 360, 1553690176, '[META-Health International] Opportunities to make your voice heard', 0x7b696d672066696c6549643d2232313139222077696474683d22383025227d0d0a0d0a44656172204d4554412d4865616c746820436f6d6d756e697479210d0a0d0a4f6e2073756e6461792033317374206f66206d617263682c204d4554412d4865616c746820496e7465726e6174696f6e616c204349432077696c6c20686f6c6420746865205f5f66697273742047656e6572616c204d656574696e67206f6620746865207368617265686f6c646572735f5f2c2077686f2061726520746f20656c65637420746865206e657720426f617264206f66204469726563746f727320616e6420746f20646973637573732067656e6572616c207374726174656769657320666f7220746865204d4554412d4865616c7468206d6f76656d656e742e0d0a0d0a596f752077616e7420746f2068617665206120766f69636520696e206465636973696f6e6d616b696e673f0d0a5f5f4265636f6d652061204d4849207368617265686f6c646572215f5f0d0a0d0a556e74696c206672696461792c2032397468206f66206d617263682c207075726368617365206973206f70656e20666f7220746865206669727374206261746368206f66207368617265733a0d0a68747470733a2f2f7777772e6d6574612d6865616c74682e696e666f2f6f7267616e697a6174696f6e2f636f6d6d756e6974792d6f776e65642f0d0a0d0a5368617265732061726520746865206d61696e206d65616e73206f662066756e64696e6720696e204d48493a0d0a5570646174657320616e6420646576656c6f706d656e7473206f6620636f6d6d6f6e2067726170686963732c206368617274732c2070726573656e746174696f6e732c20666f726d732c206578616d7320616e642068616e646f75747320616c6c2077616e7420746f2062652066756e646564206279207368617265732e200d0a0d0a7b696d672066696c6549643d2232313231222077696474683d22363025227d0d0a0d0a4f6e2073617475726461792c2033307468206f66206d617263682c202027275f5f4d656e74616c2049737375657320616e642074686520506f77657220746f204372656174655f5f20272777696c6c2062652072656c6561736564210d0a466f722074686973206e6577206973737565206f66204d4554412d4865616c746879204c696665206f6e6c696e65206d6167617a696e652c20776520636f6c6c65637465642031302061727469636c6573206279203820636f6e7472696275746f72732c207370616e6e696e672066726f6d20706f657472792c2061757468656e74696320706572736f6e616c2073686172696e67732c20736369656e74696669632076696577706f696e747320746f2061206d65646974617469766520657870657269656e636521200d0a0d0a0d0a5468616e6b20796f7520666f72206265696e672070617274206f6620746865206d6f76656d656e74210d0a0d0a54686f727374656e0d0a6f6e20626568616c66206f6620746865204d484920426f617264, 0x2d202d202d2074657874206f6e6c792076657273696f6e202d202d202d0d0a0d0a44656172204d4554412d4865616c746820436f6d6d756e697479210d0a0d0a4f6e2073756e6461792033317374206f66206d617263682c204d4554412d4865616c746820496e7465726e6174696f6e616c204349432077696c6c20686f6c64207468652066697273742047656e6572616c204d656574696e67206f6620746865207368617265686f6c646572732c2077686f2061726520746f20656c65637420746865206e657720426f617264206f66204469726563746f727320616e6420746f20646973637573732067656e6572616c207374726174656769657320666f7220746865204d4554412d4865616c7468206d6f76656d656e742e0d0a0d0a596f752077616e7420746f2068617665206120766f69636520696e206465636973696f6e6d616b696e673f0d0a4265636f6d652061204d4849207368617265686f6c646572210d0a0d0a556e74696c206672696461792c2032397468206f66206d617263682c207075726368617365206973206f70656e20666f7220746865206669727374206261746368206f66207368617265733a0d0a68747470733a2f2f7777772e6d6574612d6865616c74682e696e666f2f6f7267616e697a6174696f6e2f636f6d6d756e6974792d6f776e65642f0d0a0d0a5368617265732061726520746865206d61696e206d65616e73206f662066756e64696e6720696e204d48493a0d0a5570646174657320616e6420646576656c6f706d656e7473206f6620636f6d6d6f6e2067726170686963732c206368617274732c2070726573656e746174696f6e732c20666f726d732c206578616d7320616e642068616e646f75747320616c6c2077616e7420746f2062652066756e646564206279207368617265732e200d0a0d0a4d4554412d4865616c746879204c6966650d0a0d0a4f6e2073617475726461792c2033307468206f66206d617263682c20224d656e74616c2049737375657320616e642074686520506f77657220746f20437265617465222077696c6c2062652072656c6561736564210d0a466f722074686973206e6577206973737565206f66204d4554412d4865616c746879204c696665206f6e6c696e65206d6167617a696e652c20776520636f6c6c65637465642031302061727469636c6573206279203820636f6e7472696275746f72732c207370616e6e696e672066726f6d20706f657472792c2061757468656e74696320706572736f6e616c2073686172696e67732c20736369656e74696669632076696577706f696e747320746f2061206d65646974617469766520657870657269656e636521200d0a0d0a0d0a5468616e6b20796f7520666f72206265696e672070617274206f6620746865206d6f76656d656e74210d0a0d0a54686f727374656e0d0a6f6e20626568616c66206f6620746865204d484920426f617264, 'n');
INSERT INTO `tiki_sent_newsletters` (`editionId`, `nlId`, `users`, `sent`, `subject`, `data`, `datatxt`, `wysiwyg`) VALUES
(26, 10, 359, 1555109637, 'Your META-Health: member notifications april 2019', 0x[encoded data, 8950 characters], 0x[encoded data, 8992 characters], 'n'),
(27, 11, 90, 1555193676, 'Dein META-Health - Neuigkeiten für Mitglieder April 2019', 0x[encoded data, 7004 characters], 0x[encoded data, 7030 characters], 'n'),
(28, 10, 360, 1557693056, 'Your META-Health - members notifications may 2019', 0x[encoded data, 5766 characters], 0x[encoded data, 5632 characters], 'n');
INSERT INTO `tiki_sent_newsletters` (`editionId`, `nlId`, `users`, `sent`, `subject`, `data`, `datatxt`, `wysiwyg`) VALUES
(29, 10, 359, 1560118491, 'Your META-Health - members notifications June 2019', 0x[encoded data, 5730 characters], 0x[encoded data, 5882 characters], 'n'),
(30, 11, 91, 1560201322, 'Dein META-Health - Mitgliederbenachrichtigung Juni 2019', 0x[encoded data, 7050 characters], 0x[encoded data, 7194 characters], 'n'),
(31, 10, 359, 1566161001, 'Your META-Health resources - members\' news august 2019', 0x[encoded data, 5070 characters], 0x[encoded data, 5142 characters], 'n');
