-- MySQL dump 10.16  Distrib 10.1.44-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: Warpit_Webcati
-- ------------------------------------------------------
-- Server version	10.1.44-MariaDB-0+deb9u1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `HFCS00_Base_script`
--

DROP TABLE IF EXISTS `HFCS00_Base_script`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `HFCS00_Base_script` (
  `id_question` int(11) NOT NULL,
  `id_event` int(11) NOT NULL,
  `script` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id_question`,`id_event`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `HFCS00_Base_script`
--

LOCK TABLES `HFCS00_Base_script` WRITE;
/*!40000 ALTER TABLE `HFCS00_Base_script` DISABLE KEYS */;
INSERT INTO `HFCS00_Base_script` VALUES (11,1,'\n$i_userid = reset(getVar(\"user_id\"));\n\n//1 Projektname\n            saveVar(\'Projektdaten_1=\"Projekttitel\"\');\n            //saveVar(\"Projektdaten_1=\'\". $i_address[0][\"capi_hhid\"] . \"\'\");\n//3 Verrechnungsnummer\n            saveVar(\'Projektdaten_3=\"Projektnummer\"\');\n            //saveVar(\"Projektdaten_3=\'\". $i_address[0][\"capi_hhidf2\"] . \"\'\");\n//24 Fragebogen ART\n     //Fragebogenart(1 = TTM ohne Einschaltung, 2 = AKI ohne Einschaltung, 3 = MTU, 4 = mit Einschaltung, 9 = Sonstiges\n            saveVar(\'Projektdaten_24=\"1\"\');\n//15 Version\n            saveVar(\'Projektdaten_15=\"0.1\"\'); // FRAGEBOGENVERSION VORLAGE\n\nif ($i_userid != 0)\n {\n$i_table_id = reset(getVar(\"id_capi_table\"));\n$i_address_id = reset(getVar(\"id_capi_address\"));\n$i_sample_id = reset(getVar(\"id_capi_sample\"));\n\n// Interviewernummer eintragen\n$i_userid = reset(getVar(\"user_id\"));\n$i_info = getVarFromTable(\"_Interviewer\", \"username\", \"WHERE id = $i_userid\");\n\nif (count($i_info) == 1)\n    saveVar(\"intnr_1=\'\" . $i_info[0][\"username\"] . \"\'\");\n\nif ($i_table_id != null)\n{\n    $i_table_name = getVarFromTable(\"_CapiTables\", \"name\", \"WHERE id = \".$i_table_id);\n    if (count($i_table_name) == 1)\n    {    \n        $i_sample_table = \"capi___\" . $i_table_name[0][\"name\"];\n    \n//        $i_address = getVarFromTable($i_sample_table, \"id_municipality, municipality, id_settlement, capi_BL, capi_PB, capi_OG, name, street, zip, town, capi_vorwahl, capi_telnr\", \"WHERE id = \".$i_address_id);\n        $i_address = getVarFromTable($i_sample_table, \"id, id_municipality, municipality, id_settlement, id_street, capi_BL, capi_PB, capi_OG, capi_ID_POST, name, street, addon_address, zip, town\", \"WHERE id = \".$i_address_id);\n        if (count($i_address) == 1)\n        {\n//2 Welle\n            //saveVar(\'Projektdaten_2=\"1\"\');\n            saveVar(\"Projektdaten_2=\'\". $i_address[0][\"id_municipality\"] . \"\'\");\n//4 Listennummer\n            saveVar(\"Projektdaten_4=\'\". $i_address[0][\"municipality\"] . \"\'\");\n//5 Lfd Nummer\n            saveVar(\"Projektdaten_5=\'\". $i_address[0][\"id_settlement\"] . \"\'\");\n//6 Bundesland\n            saveVar(\"Projektdaten_6=\'\". $i_address[0][\"capi_BL\"]. \"\'\");\n//7 Politischer Bezirk\n            saveVar(\"Projektdaten_7=\'\". $i_address[0][\"capi_PB\"]. \"\'\");            \n//8 Größenklasse\n            saveVar(\"Projektdaten_8=\'\". $i_address[0][\"capi_OG\"]. \"\'\");            \n//9 Name\n            saveVar(\"Projektdaten_9=\'\". $i_address[0][\"name\"]. \"\'\");            \n//10 Vorname\n            //saveVar(\"Projektdaten_10=\'\". $i_address[0][\"capi_hhnrb2\"]. \"\'\");        \n//11 Adresse\n            saveVar(\"Projektdaten_11=\'\". $i_address[0][\"street\"]. \"\'\");\n//12 PLZ\n            saveVar(\"Projektdaten_12=\'\". $i_address[0][\"zip\"]. \"\'\");            \n//13 Ort\n            saveVar(\"Projektdaten_13=\'\". $i_address[0][\"town\"]. \"\'\");            \n//14 Telefonnummer\n            saveVar(\"Projektdaten_14=\'\". $i_address[0][\"capi_vorwahl\"]. $i_address[0][\"capi_telnr\"]. \"\'\");            \n//16 Kontrollvariable\n            //saveVar(\"Projektdaten_16=\'ver\'\");  wir für die Kontaktdaten gesetzt\n//17 Adresstyp\n           saveVar(\"Projektdaten_17=\'\". $i_address[0][\"id_street\"] . \"\'\");      \n//18 ID_POST\n            saveVar(\"Projektdaten_18=\'\". $i_address[0][\"capi_ID_POST\"]. \"\'\");            \n//19 Straße Zusatz (Hausnummer etc.)\n           saveVar(\"Projektdaten_19=\'\". $i_address[0][\"addon_address\"] . \"\'\");      \n        }}}     \n }\n//20 RESERVIERT FÜR ABGLEICHDATUM\n//21 RESERVIERT FÜR STATUS INKL KONTAKTBLATT\n//22 RESERVIERT FÜR QS DATEN\n//23 RESERVIERT FÜR LIVE UPDATE VERSION\n//24 RESERVIERT FÜR Fragebogen ART - Wird am Skriptanfang gesetzt\n//25 FREI\n\n$i_bld = reset(getVar(\"Projektdaten_6\"));    \nif ($i_bld == \"\") {saveVar(\"Projektdaten_6=\'9\'\");};\n$i_linr = reset(getVar(\"Projektdaten_4\"));    \nif ($i_linr == \"\") {\n    saveVar(\"Projektdaten_4=\'099999\'\");\n    saveVar(\"Projektdaten_2=1\");\n};\n$i_id = reset(getVar(\"id\"));\n$i_lfdnr = reset(getVar(\"Projektdaten_5\"));  \nif ($i_lfdnr == \"\") {saveVar(\"Projektdaten_5=\".$i_id);};\n\n\n'),(14,2,'echo \"TEST\";\n$i_userid = reset(getVar(\"user_id\"));\nif ($i_userid==0) $i_userid = 135;\n\n$txtchck = sprintf(\'Projektdaten_17,Projektdaten_9,Projektdaten_10,Projektdaten_11,Projektdaten_12,Projektdaten_13,Projektdaten_14,Projektdaten_19\');\n$checkvar = getVar($txtchck);\n$allvars = $txtchck;\n    foreach (explode(\",\",$allvars) as $itemvar) {\n           $$itemvar = $checkvar[$itemvar] ;\n    }\nif ($Projektdaten_17 == 1 or $Projektdaten_17 == 0) {\n    $txtQuest = \'Sie bearbeiten gerade folgende Adresse:<br>\'.\n        \"&nbsp;&nbsp;\".$Projektdaten_9.\" \".$Projektdaten_10.\"<br>\".\n        \"&nbsp;&nbsp;\".$Projektdaten_11.\" \".$Projektdaten_19.\"<br>\".\n        \"&nbsp;&nbsp;\".$Projektdaten_12.\" \".$Projektdaten_13.\"<br>\".\n        \"&nbsp;&nbsp;\".$Projektdaten_14;\n} else if ($Projektdaten_17 == \"2\") {\n    $txtQuest = \'Sie führen ein bezahltes Interview durch.<br>\'.\n        \'Tragen Sie am Interviewende die korrekte Adresse ein.<br>\'.\n        \'Nicht den Vorgaben entsprechende Interviews,<br>\'.\n        \'können nicht berücksichtigt werden\';\n} else if ($Projektdaten_17 == \"3\") {\n    $txtQuest = \'Sie führen eines von max. 4 bezahlten Einsteigerinterviews durch<br>\'.\n        \'Tragen Sie am Interviewende die korrekte Adresse ein\';\n} else {\n    $txtQuest = \'Sie führen ein unbezahltes Testinterview durch<br>\';\n}\n\n$txtchck = sprintf(\'user_id,Projektdaten_4\');\n$checkvar = getVar($txtchck);\n$allvars = $txtchck;\n    foreach (explode(\",\",$allvars) as $itemvar) {\n           $$itemvar = $checkvar[$itemvar] ;\n    }\n\n$i_cmplts = getVarFromTable($_SESSION[\'projname\'].\"_structure\", \"Projektdaten_4,Projektdaten_5,Projektdaten_17,AGE_1,SEX\",\n    \"WHERE user_id =\".$user_id.\n    \" and Projektdaten_4 = \'\".$Projektdaten_4.\"\'\".\n    \" and flag_bad = 1\");\n\necho \"<pre>\";\n//var_dump($i_cmplts);\necho \"</pre>\";\n$lfdsInLinr = array();\n$count_linr = 0;\n$cmplt_linr = 0;\n$count_him = 0;\n$count_her = 0;\n$count_young = 0;\n$count_old = 0;\nif(count($i_cmplts)) {\n    foreach ($i_cmplts as $key => $value) {\n        if(!in_array($value[\"Projektdaten_5\"],$lfdsInLinr)) {\n           $cmplt_linr++;\n           $lfdsInLinr[] = $value[\"Projektdaten_5\"];\n               if ($value[\"Projektdaten_17\"] == \"2\" || $value[\"Projektdaten_17\"] == \"0\") {\n                   if($value[\"SEX\"] == \"1\") {\n                       $count_him++;\n                   } else if ($value[\"SEX\"] == \"2\") {\n                       $count_her++;\n                   }\n                   if($value[\"AGE_1\"] > 15 && $value[\"AGE_1\"] <= 45) {\n                       $count_young ++;\n                   } else if ($value[\"AGE_1\"] >= 46 || $value[\"AGE_1\"] <= 99) {\n                       $count_old ++;\n                   }\n            }\n        }\n    }\n}\n\n$txtQuest .= \"<br><br>Sie bearbeiten aktuell folgende Liste \".$Projektdaten_4.\":<br>\".\n   \"&nbsp;&nbsp;\".\"Darauf wurden bereits \".$cmplt_linr.\" Interview(s) durchgeführt.\";\n//$txtQuest .= \"<br>&nbsp;&nbsp;Insgesamt \".$count_linr.\" Adressen sind bereits abgeschlossen.\";\nif ($Projektdaten_17 == 2 || ($Projektdaten_17 == 0 && $i_userid == 135)) {\n    $txtQuest .= \"<br><br>Alter und Geschlechtsverteilung:<br>&nbsp;&nbsp;\";\n    if ($count_him > $count_her+1) $txtQuest .= \'<font color=\"red\">\';\n    $txtQuest .=$count_him.\" Männer<br>&nbsp;&nbsp;\";\n    if ($count_him > $count_her+1) $txtQuest .= \"</font>\";\n    if ($count_her> $count_him +1) $txtQuest .= \'<font color=\"red\">\';\n    $txtQuest .=$count_her.\" Frauen<br>&nbsp;&nbsp;\";\n    if ($count_her> $count_him +1) $txtQuest .= \"</font>\";\n    if ($count_young> $count_old+1) $txtQuest .= \'<font color=\"red\">\';\n    $txtQuest .=$count_young.\" unter 45<br>&nbsp;&nbsp;\";\n    if ($count_young> $count_old+1) $txtQuest .= \"</font>\";\n    if ($count_old> $count_young+1) $txtQuest .= \'<font color=\"red\">\';\n    $txtQuest .=$count_old.\" 45 oder älter<br>\";\n    if ($count_old> $count_young+1) $txtQuest .= \"</font>\";\n}\n    $txtQuest .= \"<br>\";\n\nsaveVar(\"questtext_1=\'\".$txtQuest.\"\'\");\n'),(15,2,'$txtchck = sprintf(\'user_id,Projektdaten_2,Projektdaten_4,Projektdaten_5\');\n$checkvar = getVar($txtchck);\n$allvars = $txtchck;\n    foreach (explode(\",\",$allvars) as $itemvar) {\n           $$itemvar = $checkvar[$itemvar] ;\n    }\n$i_userid = reset(getVar(\"user_id\"));\n$i_projectid = $_SESSION[\"id_project\"];\nif ($i_userid==0) {\n    $i_projectid = 309; //Test MTU 2.HJ 2017\n    $i_userid = 57; // 135 test, 57 Boden\n    $Projektdaten_4 = 820919;\n    }\n\nif ($user_id == 0) {$visitsTable = \"_Capi_interviewer_visits\"; } else {$visitsTable = \"_capi_interviewer_visits\"; }\nif ($user_id == 0) {$ProjectsTable = \"_Projects\"; } else {$ProjectsTable = \"_projects\"; }\nif ($user_id == 0) {$AddressTables = \"_CapiTables\"; } else {$AddressTables = \"_capitables\"; }\n\n$i_tableIds = getVarFromTable($ProjectsTable, \"proj_name,naziv_proj,id_capiTable\", \"WHERE id = \".$i_projectid);\n$i_AddressTableInfo = getVarFromTable($AddressTables, \"name\", \"WHERE id = \".$i_tableIds[0][\"id_capiTable\"]);\n\n$s_projname = $_SESSION[\"proj_name\"];\n$s_structure = $s_projname.\"_structure\";\n$s_sample = $s_projname.\"___sample\";\n$s_address = \"capi___\".$i_AddressTableInfo[0][\"name\"];\n/*\necho \"<pre>\";\n//var_dump($_SESSION);\necho \'$i_userid:\'.$i_userid.\"<br>\";\necho \'$i_projectid:\'.$i_projectid.\"<br>\";\necho \'$s_projname:\'.$s_projname.\"<br>\";\necho \'$user_id:\'.$user_id.\"<br>\";\necho \'$Projektdaten_2:\'.$Projektdaten_2.\"<br>\";\necho \'$Projektdaten_4:\'.$Projektdaten_4.\"-\".$Projektdaten_5.\"<br>\";\necho \"</pre>\";\n*/\n$i_address = getVarFromTable($s_address, \"id,municipality,id_settlement,name\",\n    \"WHERE id_municipality= \".$Projektdaten_2.\n    \" and municipality= \".$Projektdaten_4);\n\n$questtxt = \"<table  align=\'left\' style=\'text-align: center;font-size:70%;\'>\n    <tr><th>Listennummer: \".$Projektdaten_4.\"</th></tr>\";\n$questtxt .=\"\n    <tr><th style=\'padding-left: 15px;padding-right: 15px;\'>LfdNr.</th>\n    <th style=\'padding-left: 15px;padding-right: 15px;\'>Name.</th>\n    <th style=\'padding-left: 15px;padding-right: 15px;\'>Anzahl Kontakte</th>\n    <th style=\'padding-left: 15px;padding-right: 15px;\'>letzter Kontakt</th></tr>\";\n\nforeach ($i_address as $adresse) {\n    //var_dump($kontakt);\n    if ($user_id == 0) {$s_sample = \"p27293105___sample\"; } // TEST\n    $i_sample = getVarFromTable($s_sample, \"id,user_id\",\n        \"WHERE id_sample= \".$adresse[\"id\"]);\n    $i_contacts = getVarFromTable($visitsTable, \"sample_point,cas_obiska,status_obiska,id_structure,user_id\",\n    \"WHERE user_id =\".$i_userid.\n    \" and id_project = \".$i_projectid.\n     \" and sample_point = \".$i_sample[0][\"id\"]);\nif ($i_sample[0][\"user_id\"] == $user_id || $user_id == 0 ) {\n$questtxt .= \"<tr><td>\".$adresse[\"id_settlement\"] .\"</td><td style=\'text-align: left;\'>\"\n          . $adresse[\"name\"].\"</td>\";\n  \n    if ($i_contacts) {\n       $i_count_con = 0;\n        foreach ($i_contacts as $Kontakt) {\n            $i_count_con ++;\n            switch($Kontakt[status_obiska]) {\n                case 1:\n                    $kontxt = \"Interview abgeschlossen\";\n                    break;\n                case 9:\n                    $kontxt = \"Interview unterbrochen\";\n                    break;\n                case 21:\n                    $kontxt = \"Niemand erreicht/angetroffen\";\n                    break;\n                case 22:\n                    $kontxt = \"Rückruf\";\n                    break;\n                case 8:\n                    $kontxt = \"Terminvereinbarung\";\n                    break;\n                case 23:\n                    $kontxt = \"Verweigerung bei 1.Kontakt\";\n                    break;\n                case 24:\n                    $kontxt = \"Verweigerung\";\n                    break;\n                case 31:\n                    $kontxt = \"kritische Verweigerung\";\n                    break;\n                case 32:\n                    $kontxt = \"keine geeignete ZP\";\n                    break;\n                case 33:\n                    $kontxt = \"Adresse unauffindbar\";\n                    break;\n                case 34:\n                    $kontxt = \"ungültige Adresse\";\n                    break;\n                case 35:\n                    $kontxt = \"Adresse unbearbeitet abgelegt\";\n                    break;\n                default:                    \n                    $kontxt = \"unbekannt\";\n                }\n         }\n$questtxt .= \"<td>\".$i_count_con.\"</td><td>\".$kontxt.\"</td>\";        \n    }\n$questtxt .= \"</tr>\";\n    }\n\n }\n\n$questtxt .= \"</table>\";\n\nsaveVar(\"questtext_1=\'\".$txtQuest.\"\'\");\n\n\n'),(16,1,'saveVar(\"questtext_1=NULL\");'),(18,1,'$txtchck = sprintf(\'Projektdaten_6,Projektdaten_9,Projektdaten_10,Projektdaten_11,Projektdaten_12,Projektdaten_13,Projektdaten_14,Projektdaten_16,Projektdaten_19,kondata_5\');\n    $checkvar = getVar($txtchck);\n    $allvars = $txtchck;\n    foreach (explode(\",\",$allvars) as $itemvar) {\n           $$itemvar = $checkvar[$itemvar] ;\n    }\nif ($Projektdaten_16 <> \'ver\' && ($Projektdaten_17 == 1 || $Projektdaten_17 == 0)) {\n    saveVar(sprintf(\'kondata_1=\"%s\"\',$Projektdaten_9));\n    saveVar(sprintf(\'kondata_2=\"%s\"\',$Projektdaten_12));\n    saveVar(sprintf(\'kondata_3=\"%s\"\',$Projektdaten_11));\n    saveVar(sprintf(\'kondata_4=\"%s\"\',$Projektdaten_19));\n    saveVar(sprintf(\'kondata_5=\"%s\"\',$Projektdaten_13));\n    saveVar(sprintf(\'kondata_6=\"%s\"\',$Projektdaten_14));\n}\n\nsaveVar(\"Projektdaten_16=\'ver\'\");\n\n$bld = $Projektdaten_6;\n$bldstat = array(\"ges\",8,7,5,4,2,6,1,3,9);\n/*\nif ($Projektdaten_6 != \"\" and $Projektdaten_11 != \"\" and $Projektdaten_12 != \"\") {\n    $plz = $Projektdaten_12;\n    $table = \"strassen_ges\";\n    $filter = \"WHERE `Straßenname` = \'\".$Projektdaten_11.\"\' and Postleitzahl = \".$plz.\" and bld = \".$bldstat[$bld];\n    \n    $Variable = getVarFromTable( $table , \"id\", $filter);\n\n    if (isset($Variable[0][\"id\"])) {\n        $id_street = $Variable[0][\"id\"];\n    } else {\n         $id_street = 0;\n    }\n}\n*/\nif ($Projektdaten_17 == 1 || $Projektdaten_17 == 0) {\n    $id_street = 0;\n}\nif ($Projektdaten_11== \"Blumenweg\" and $Projektdaten_12 == 1811) {\n     $id_street = 999999;\n    }\n/*\nif ($kontakt[\"kondata_5\"] == null) {\n    saveVar(\"kondata_3=\".$Projektdaten_12); //PLZ\n    saveVar(\"kondata_4=\'\".$Projektdaten_11.\"\'\"); // Straße\n    saveVar(\"kondata_5=\'\".$Projektdaten_19.\"\'\"); // Straße_Zusatz\n    saveVar(\"kondata_6=\'\".$Projektdaten_13.\"\'\"); // Ort\n    saveVar(\"kondata_9=\".$id_street); // idStreet\n}\n*/\n$projname = $_SESSION[\"projname\"];\n$questname = \"strasse\";\n//echo \'<input id=plzID type=\"hidden\" name=\"forStreet\" value=\"\'.$plz.\'\">\';\necho \'<input id=bldID type=\"hidden\" name=\"forStreet\" value=\"\'.$bld.\'\">\';\necho \'<input id=frageID type=\"hidden\" name=\"forStreet\" value=\"\'.$questname.\'\">\';\n\n'),(18,3,'document.getElementById(\"ct_kondata_8\").style.display=\"none\";\n$(function() {\n    var tbID = $(\"#ct_kondata_8\"),\n        tbStrn = $(\"#ct_kondata_3\"),\n        plz = $(\"#ct_kondata_2\"),\n        ort = $(\"#ct_kondata_5\"),\n        bld = $(\"#bldID\"),\n        frage = $(\"#frageID\");\n    tbStrn.autocomplete({\n        minLength: 3,\n        source: function(request, response) {\n            $.ajax({\n                url: \"../../webProjects/lookups/lookup_street.php\",\n                dataType: \"json\",\n                data: {\n                    query: request.term,\n                    bld: bld.val(),\n                    plz: plz.val()\n                },\n                success: function(data) {\n                    response(data);\n                }\n            });\n        },\n        focus: function(event, ui) {\n            tbID.val(ui.item.value);\n            return false;\n        },\n        select: function(event, ui) {\n            tbID.val(ui.item.value);\n            tbStrn.val(ui.item.str_ret);\n            plz.val(ui.item.plz_ret);\n            ort.val(ui.item.ort_ret);\n            return false;\n        }\n    });\n    \n    var found = $.grep(data, function(element) {\n        return (element.value == tbID.val());\n    });\n\n    if (found.length > 0) {\n//        tbStrn.parent().prev().html(\"Straßenname: \" + found[0].label);\n        tbStrn.parent().prev().html(\"<p id=\\\"strassenname\\\">Bitte nach Straßenname suchen...</p>\");\n    } else {\n        tbStrn.parent().prev().html(\"<p id=\\\"strassenname\\\">Bitte nach Straßenname suchen...<br>\"+\n                                    \"Geben Sie zumindest drei Buchstaben des Straßennames ein um die Suche zu starten</p>\");\n    }\n});'),(21,1,'echo \"<br><br><br><br><br>\";\n$i_userid = reset(getVar(\"user_id\"));\n$i_info = getVarFromTable(\"_Interviewer\", \"username\", \"WHERE id = $i_userid\");\necho $i_userid;\nif (count($i_info) == 1)\n    saveVar(\"intnr_1=\'\" . $i_info[0][\"username\"] . \"\'\");'),(24,1,'$txtchck = sprintf(\'verng2,verng2_opn,intnr_1\');\n    $checkvar = getVar($txtchck);\n    $allvars = $txtchck;\n        foreach (explode(\",\",$allvars) as $itemvar) {\n               $$itemvar = $checkvar[$itemvar] ;\n        }\nif ($verng2 == 2) {\n    \n        saveVar(sprintf(\'vernr_1=\"%s\"\',$verng2_opn));\n    \n    } else {\n \n       saveVar(sprintf(\'vernr_1=\"%s\"\',$intnr_1));       \n        \n        }\n'),(31,1,'\n'),(31,3,'var complete = document.getElementById(\"complete\").value;\nif (complete===0) {\n    $(\'[name=\"questSubmit\"]\').attr(\'disabled\',\'disabled\');\n    //$(\'[name=\"questBack\"]\').attr(\'disabled\',\'disabled\');\n}\n'),(31,2,'\ngetQuestData();\n\n\n'),(0,3,'setCustomDesignerText(\'custDrop\', \'Custom Option\');\nsetCustomDesignerText(\'custTitle\', \'HFCS 2020\');'),(14,1,'echo \"TEST\";'),(13,1,'echo \"<br><br><br><br><br><pre>\";\n$arr = get_defined_functions();\n//if(in_array(\"getVar\",$arr[\"user\"])) echo \"getVar gefunden<br>\";\n//if(in_array(\"get_quest_text\",$arr[\"user\"])) echo \"get_quest_text gefunden<br>\";\n//var_dump($arr[\"user\"][\"get_quest_text\"]);\necho \"</pre>\";\n');
/*!40000 ALTER TABLE `HFCS00_Base_script` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2020-05-28 17:23:08
