{SubmissionCode:body}" ["GridLayout"]=> string(179) "[[{"columns":[["59","62","63","64","66","68","86","243","87","88","89","79","236","235","237","83","130","532","129","241","242","238","85","261","263"]],"sizes":["12"]}],["538"]]" ["FormLayoutName"]=> string(10) "responsive" ["LoadFormLayoutFramework"]=> int(1) ["FormLayoutAutogenerate"]=> int(1) ["FormLayoutFlow"]=> int(0) ["DisableSubmitButton"]=> int(1) ["RemoveCaptchaLogged"]=> int(0) ["CSS"]=> string(0) "" ["JS"]=> string(0) "" ["FormTitle"]=> string(21) "Lägeranmälan Ledare" ["ShowFormTitle"]=> int(1) ["Published"]=> int(1) ["Lang"]=> string(5) "en-GB" ["ReturnUrl"]=> string(0) "" ["ShowSystemMessage"]=> int(1) ["ShowThankyou"]=> int(1) ["ScrollToThankYou"]=> int(0) ["ThankYouMessagePopUp"]=> int(0) ["Thankyou"]=> string(0) "" ["ShowContinue"]=> int(1) ["UserEmailText"]=> string(0) "" ["UserEmailTo"]=> string(13) "{email:value}" ["UserEmailCC"]=> string(0) "" ["UserEmailBCC"]=> string(0) "" ["UserEmailFrom"]=> string(27) "lagerchef@malarscouterna.se" ["UserEmailReplyTo"]=> string(0) "" ["UserEmailReplyToName"]=> string(0) "" ["UserEmailFromName"]=> string(17) "{global:fromname}" ["UserEmailSubject"]=> string(0) "" ["UserEmailMode"]=> int(1) ["UserEmailAttach"]=> int(0) ["UserEmailAttachFile"]=> string(0) "" ["UserEmailGenerate"]=> int(0) ["AdminEmailText"]=> string(0) "" ["AdminEmailTo"]=> string(0) "" ["AdminEmailCC"]=> string(0) "" ["AdminEmailBCC"]=> string(0) "" ["AdminEmailFrom"]=> string(0) "" ["AdminEmailReplyTo"]=> string(0) "" ["AdminEmailReplyToName"]=> string(0) "" ["AdminEmailFromName"]=> string(0) "" ["AdminEmailSubject"]=> string(0) "" ["AdminEmailMode"]=> int(1) ["AdminEmailGenerate"]=> int(0) ["DeletionEmailText"]=> string(0) "" ["DeletionEmailTo"]=> string(0) "" ["DeletionEmailCC"]=> string(0) "" ["DeletionEmailBCC"]=> string(0) "" ["DeletionEmailFrom"]=> string(0) "" ["DeletionEmailReplyTo"]=> string(0) "" ["DeletionEmailReplyToName"]=> string(0) "" ["DeletionEmailFromName"]=> string(0) "" ["DeletionEmailSubject"]=> string(0) "" ["DeletionEmailMode"]=> int(1) ["ScriptProcess"]=> string(0) "" ["ScriptProcess2"]=> string(1504) "$code = Joomla\CMS\Factory::getApplication()->input->get('SubmissionCode'); $db = Joomla\CMS\Factory::getDbo(); // Check unique code if ($code) { // Grab old submission $db->setQuery("SELECT `SubmissionId` FROM #__rsform_submission_values WHERE `FormId`= " . $db->q($formId) ." AND `FieldName`='SubmissionCode' AND FieldValue = " . $db->q($code) . " ORDER BY SubmissionId ASC LIMIT 1"); if ($oldSubId = $db->loadResult()) { // Remove it $db->setQuery("DELETE rs,rsv FROM #__rsform_submissions AS rs ,#__rsform_submission_values AS rsv WHERE rs.`SubmissionId`=rsv.`SubmissionId` AND rs.`SubmissionId`='".$oldSubId."'")->execute(); } // Override generated code if supplied $db->setQuery("UPDATE #__rsform_submission_values SET FieldValue = " . $db->q($code) . " WHERE FieldName = " . $db->q('SubmissionCode') . " AND SubmissionId = " . $db->q($SubmissionId))->execute(); } else { $db->setQuery("SELECT `SubmissionId` FROM #__rsform_submissions WHERE `UserId`='".Joomla\CMS\Factory::getUser()->id."' AND `FormId`='".$formId."' ORDER BY `SubmissionId` DESC LIMIT 2"); $oldSubId = ''; if(count($db->loadColumn()) == 2){ $oldSubId = $db->loadColumn()[1]; } if(!empty($oldSubId)){ $db->setQuery("DELETE rs,rsv FROM #__rsform_submissions AS rs ,#__rsform_submission_values AS rsv WHERE rs.`SubmissionId`=rsv.`SubmissionId` AND rs.`SubmissionId`='".$oldSubId."'"); $db->execute(); } }" ["ScriptBeforeDisplay"]=> string(4292) " if(Joomla\CMS\Factory::getUser()->id == 0){ // User is not logged in, need to fin SubmissionCode $code = Joomla\CMS\Factory::getApplication()->input->get('SubmissionCode'); $db = Joomla\CMS\Factory::getDbo(); $db->setQuery("SELECT `SubmissionId` FROM #__rsform_submission_values WHERE `FormId`= " . $db->q($formId) ." AND `FieldName`='SubmissionCode' AND FieldValue = " . $db->q($code) . " ORDER BY SubmissionId DESC LIMIT 1"); }else{ $db = Joomla\CMS\Factory::getDBO(); $db->setQuery("SELECT `SubmissionId` FROM #__rsform_submissions WHERE `UserId`='".Joomla\CMS\Factory::getUser()->id."' AND `FormId`='".$formId."' ORDER BY `SubmissionId` DESC LIMIT 1"); } $SubmissionId = $db->loadResult(); //grabs previous user submission, if any. if(!empty($SubmissionId)){ //this basically triggers if the user had submitted the form before. $exclude = implode("','",array(7,8,9,10,11,12,13,14,15,21,22,23,24,27,28,30,31,32,33,34,41,212,499,500,2424)); /* certain form elements are EXCLUDED as follows: 7 button 8 captcha 9 File Upload 10 freeText 11 hidden field 12 image button 13 submit button 14 password 15 support ticket 21 single product 22 multiple product 23 total 24 recaptcha 27 choose payment 28 donation 30 RSEvents!Pro name 31 RSEvents!Pro email 32 RSEvents!Pro tickets 33 RSEvents!Pro payments 34 RSEvents!Pro coupon 41 Page Break 212 Google Map 499 offline payment 500 PayPal payment 2424 reCaptcha V2 */ $db->setQuery("SELECT ct.`ComponentTypeName`, p.`PropertyValue`, sv.`FieldValue` FROM #__rsform_component_types AS ct LEFT JOIN #__rsform_components AS c ON ct.`ComponentTypeId` = c.`ComponentTypeId` LEFT JOIN #__rsform_properties AS p ON c.`ComponentId` = p.`ComponentId` LEFT JOIN #__rsform_submission_values AS sv ON p.`PropertyValue` = sv.`FieldName` WHERE c.`FormId`='".$formId."' AND c.`ComponentTypeId` NOT IN ('".$exclude."') AND p.`PropertyName`='NAME' AND sv.`SubmissionId` = '".$SubmissionId."'"); $results = $db->loadObjectList(); //to keep things sort, the above query grabs previously submitted data of your form fields based on the logged in user. foreach($results as $result){ //there are four main cases when you have to specify a particular syntax to include data within the $val variable that will eventually pre-fill form fields if($result->ComponentTypeName == 'selectList' || $result->ComponentTypeName == 'checkboxGroup'){ //for dropdowns and checkbox groups if(strstr($result->FieldValue,"\n") !== false){ //for multi selections $multiVals = explode("\n",$result->FieldValue); foreach($multiVals as $multiVal){ $val[$result->PropertyValue][] = $multiVal; } }else{ //for single selections $val[$result->PropertyValue] = $result->FieldValue; } } elseif ($result->ComponentTypeName == 'calendar'){ //for the calendar field $val[$result->PropertyValue] = $result->FieldValue; //if you're using other calendar formats than d-m-Y, you may need to use something like the following instead (adjust according to your date format): //$calDate = explode("/",$result->FieldValue); //$val[$result->PropertyValue] = $calDate[2].'/'.$calDate[0].'/'.$calDate[1]; }elseif($result->ComponentTypeName == 'birthDay'){ //for the birthday field $bDate = str_replace(' ','',$result->FieldValue); $bDate = explode("/",$bDate); $val[$result->PropertyValue]['d'] = $bDate[0]; $val[$result->PropertyValue]['m'] = $bDate[1]; $val[$result->PropertyValue]['y'] = $bDate[2]; }else{ //for other fields such as textboxes, radio groups and so on $val[$result->PropertyValue] = $result->FieldValue; } } } " ["ScriptBeforeValidation"]=> string(0) "" ["ScriptDisplay"]=> string(2296) "$medlemsnr=$_GET["form"]["medlemsnr"]; // echo $medlemsnr; echo "";" ["UserEmailScript"]=> string(0) "" ["AdminEmailScript"]=> string(0) "" ["AdditionalEmailsScript"]=> string(0) "" ["MetaTitle"]=> int(0) ["MetaDesc"]=> string(0) "" ["MetaKeywords"]=> string(0) "" ["Required"]=> string(3) "(*)" ["ErrorMessage"]=> string(59) "

Please complete all required fields!

" ["MultipleSeparator"]=> string(2) "\n" ["TextareaNewLines"]=> int(1) ["CSSClass"]=> string(0) "" ["CSSId"]=> string(8) "userForm" ["CSSName"]=> string(0) "" ["CSSAction"]=> string(0) "" ["CSSAdditionalAttributes"]=> string(0) "" ["AjaxValidation"]=> int(0) ["ScrollToError"]=> int(0) ["Keepdata"]=> int(1) ["KeepIP"]=> int(0) ["DeleteSubmissionsAfter"]=> int(250) ["Backendmenu"]=> int(0) ["ConfirmSubmission"]=> int(0) ["ConfirmSubmissionDefer"]=> string(2) """" ["ConfirmSubmissionUrl"]=> string(0) "" ["Access"]=> string(1) "1" ["LimitSubmissions"]=> int(0) }

Lägeranmälan Ledare

Välkommen på sommarens läger. Anmäl dig som Ledare nedan

Lägeranmälan för ledare

LÄGERANMÄLAN -->