PHP Decode

use phpformbuilder\Form;$query_content_forms_select='SELECT * FROM content_forms WHERE id=:id LIMIT 1';$statement_content_forms_select=$db_connect[$db_type]->prepare($query_content_forms_select);$statement_content_forms_select->bindParam(':id', $form_id, PDO::PARAM_INT);$result_content_forms_select=$statement_content_forms_select->execute();$row_content_forms_select=$statement_content_forms_select->fetch(PDO::FETCH_ASSOC);$form_id=$row_content_forms_select['id'];$form[$form_id] = new Form($row_content_forms_select['name'], 'horizontal', 'novalidate');if($_SERVER['REQUEST_METHOD'] != 'POST') Form::clear($row_content_forms_select['name']);$query_content_forms_fields_select_pre='SELECT name, column_width, row FROM content_forms_fields WHERE form=:form AND sequence!=0'.((isset($specific_fields) && $specific_fields!='')? ' AND name IN ('.$specific_fields.')' : '').' ORDER BY sequence';$statement_content_forms_fields_select_pre=$db_connect[$db_type]->prepare($query_content_forms_fields_select_pre);$statement_content_forms_fields_select_pre->bindParam(':form', $form_id, PDO::PARAM_INT);$result_content_forms_fields_select_pre=$statement_content_forms_fields_select_pre->execute();$group_inputs=array();$group_inputs_width=0;foreach($statement_content_forms_fields_select_pre->fetchAll(PDO::FETCH_ASSOC) as $row_content_forms_fields_select_pre){if(isset($name_index)){$name_array=explode('_', $row_content_forms_fields_select_pre['name']);$last_name_index=array_pop($name_array);$name_array=array(implode('_', $name_array), $last_name_index);$row_content_forms_fields_select_pre['name'] = $name_array[0].'_'.$name_index;} if($row_content_forms_fields_select_pre['column_width'] <= 0 || $row_content_forms_fields_select_pre['column_width'] > 12) $field_column_width=12;else $field_column_width=$row_content_forms_fields_select_pre['column_width'];$group_inputs_width+=$field_column_width;if($group_inputs_width>12){if(isset($group_inputs[6])) $form[$form_id]->groupInputs($group_inputs[0], $group_inputs[1], $group_inputs[2], $group_inputs[3], $group_inputs[4], $group_inputs[5], $group_inputs[6]);elseif(isset($group_inputs[5])) $form[$form_id]->groupInputs($group_inputs[0], $group_inputs[1], $group_inputs[2], $group_inputs[3], $group_inputs[4], $group_inputs[5]);elseif(isset($group_inputs[4])) $form[$form_id]->groupInputs($group_inputs[0], $group_inputs[1], $group_inputs[2], $group_inputs[3], $group_inputs[4]);elseif(isset($group_inputs[3])) $form[$form_id]->groupInputs($group_inputs[0], $group_inputs[1], $group_inputs[2], $group_inputs[3]);elseif(isset($group_inputs[2])) $form[$form_id]->groupInputs($group_inputs[0], $group_inputs[1], $group_inputs[2]);elseif(isset($group_inputs[1])) $form[$form_id]->groupInputs($group_inputs[0], $group_inputs[1]);$group_inputs=array();$group_inputs_width=$field_column_width;} array_push($group_inputs, $row_content_forms_fields_select_pre['name']);if($group_inputs_width==12 || $row_content_forms_fields_select_pre['row'] == 1){if(isset($group_inputs[6])) $form[$form_id]->groupInputs($group_inputs[0], $group_inputs[1], $group_inputs[2], $group_inputs[3], $group_inputs[4], $group_inputs[5], $group_inputs[6]);elseif(isset($group_inputs[5])) $form[$form_id]->groupInputs($group_inputs[0], $group_inputs[1], $group_inputs[2], $group_inputs[3], $group_inputs[4], $group_inputs[5]);elseif(isset($group_inputs[4])) $form[$form_id]->groupInputs($group_inputs[0], $group_inputs[1], $group_inputs[2], $group_inputs[3], $group_inputs[4]);elseif(isset($group_inputs[3])) $form[$form_id]->groupInputs($group_inputs[0], $group_inputs[1], $group_inputs[2], $group_inputs[3]);elseif(isset($group_inputs[2])) $form[$form_id]->groupInputs($group_inputs[0], $group_inputs[1], $group_inputs[2]);elseif(isset($group_inputs[1])) $form[$form_id]->groupInputs($group_inputs[0], $group_inputs[1]);$group_inputs=array();$group_inputs_width=0;}} $query_content_forms_fields_select='SELECT * FROM content_forms_fields WHERE form=:form AND sequence!=0'.((isset($specific_fields) && $specific_fields!='')? ' AND name IN ('.$specific_fields.')' : '').' ORDER BY sequence';$statement_content_forms_fields_select=$db_connect[$db_type]->prepare($query_content_forms_fields_select);$statement_content_forms_fields_select->bindParam(':form', $form_id, PDO::PARAM_INT);$result_content_forms_fields_select=$statement_content_forms_fields_select->execute();foreach($statement_content_forms_fields_select->fetchAll(PDO::FETCH_ASSOC) as $row_content_forms_fields_select){if(isset($name_index)){$name_array=explode('_', $row_content_forms_fields_select['name']);$last_name_index=array_pop($name_array);$name_array=array(implode('_', $name_array), $last_name_index);$row_content_forms_fields_select['name'] = $name_array[0].'_'.$name_index;} if($row_content_forms_fields_select['column_width'] <= 0 || $row_content_forms_fields_select['column_width'] > 12) $field_column_width=12;else $field_column_width=$row_content_forms_fields_select['column_width'];$form[$form_id]->setCols(0, $field_column_width, 'md', 'frm-grp');if($row_content_forms_fields_select['database_action'] != '' && $row_content_forms_fields_select['type'] != 'hidden' && defined('LAST_URI') && is_numeric(LAST_URI) && isset($_GET['page_action']) && ($_GET['page_action'] == 'view' || $_GET['page_action'] == 'edit')){$database_action=explode(',', $row_content_forms_fields_select['database_action']);if($row_content_forms_fields_select['relation_column_table'] != ''){$relation_column_table=explode(',', $row_content_forms_fields_select['relation_column_table']);if(!isset($query_relation_column_table_select_index)) $query_relation_column_table_select_index=1;$query_relation_column_table_select_counter=1;$query_relation_column_table_select_count="SELECT COUNT(id) FROM $database_action[1] WHERE $relation_column_table[0]=:relation_column_table";$statement_relation_column_table_select_count=$db_connect[$database_action[0]]->prepare($query_relation_column_table_select_count);$statement_relation_column_table_select_count->bindValue(':relation_column_table', LAST_URI, PDO::PARAM_INT);$result_relation_column_table_select_count=$statement_relation_column_table_select_count->execute();$count_relation_column_table_select=$statement_relation_column_table_select_count->fetchColumn();if($count_relation_column_table_select!=0){$query_relation_column_table_select="SELECT id FROM $database_action[1] WHERE $relation_column_table[0]=:relation_column_table";$statement_relation_column_table_select=$db_connect[$database_action[0]]->prepare($query_relation_column_table_select);$statement_relation_column_table_select->bindValue(':relation_column_table', LAST_URI, PDO::PARAM_INT);$result_relation_column_table_select=$statement_relation_column_table_select->execute();foreach($statement_relation_column_table_select->fetchAll(PDO::FETCH_ASSOC) as $row_relation_column_table_select){if($query_relation_column_table_select_counter==$query_relation_column_table_select_index){$query_id=$row_relation_column_table_select['id'];break;} $query_relation_column_table_select_counter++;}} } else $query_id=LAST_URI;if(!isset($count_relation_column_table_select) || ($count_relation_column_table_select!=0)){$query_field_value_select="SELECT $database_action[2] FROM $database_action[1] WHERE id=:id LIMIT 1";$statement_field_value_select=$db_connect[$database_action[0]]->prepare($query_field_value_select);$statement_field_value_select->bindParam(':id', $query_id, PDO::PARAM_INT);$result_field_value_select=$statement_field_value_select->execute();$row_field_value_select=$statement_field_value_select->fetch(PDO::FETCH_ASSOC);$field_value_database=$row_field_value_select[$database_action[2]];$field_value=$row_field_value_select[$database_action[2]];if(isset($database_action[3])){$query_field_value_select="SELECT $database_action[5], $database_action[6] FROM $database_action[4] WHERE $database_action[5]=:field_value LIMIT 1";$statement_field_value_select=$db_connect[$database_action[3]]->prepare($query_field_value_select);$statement_field_value_select->bindParam(':field_value', $field_value, PDO::PARAM_STR);$result_field_value_select=$statement_field_value_select->execute();$row_field_value_select=$statement_field_value_select->fetch(PDO::FETCH_ASSOC);$field_value=$row_field_value_select[$database_action[6]];}} else{$field_value_database=$row_content_forms_fields_select['value'];$field_value=$row_content_forms_fields_select['value'];} if(isset($count_relation_column_table_select)) unset($count_relation_column_table_select);} else{$field_value_database=$row_content_forms_fields_select['value'];$field_value=$row_content_forms_fields_select['value'];} if($row_content_forms_fields_select['value'] == 'null') $field_value='';if(defined('LAST_URI') && is_numeric(LAST_URI) && isset($_GET['page_action']) && $_GET['page_action'] == 'edit'){if($row_content_forms_fields_select['required_edit'] == 1) $required='required';else $required='';} else{if($row_content_forms_fields_select['required'] == 1) $required='required';else $required='';} if(defined('LAST_URI') && is_numeric(LAST_URI) && isset($_GET['page_action']) && $_GET['page_action'] == 'edit'){if($row_content_forms_fields_select['validation_edit'] != '') $validation=$row_content_forms_fields_select['validation_edit'];else $validation='';} else{if($row_content_forms_fields_select['validation'] != '') $validation=$row_content_forms_fields_select['validation'];else $validation='';} if(defined('LAST_URI') && is_numeric(LAST_URI) && isset($_GET['page_action']) && $_GET['page_action'] == 'edit'){if($row_content_forms_fields_select['remote_edit'] == 1) $remote='data-fv-remote, data-fv-remote-type=POST, data-fv-remote-delay=1000, data-fv-remote-url=includes/json/remote/edit.php, data-fv-remote-message=That '.strtolower($row_content_forms_fields_select['label']).' is taken. Please try another.';else $remote='';} else{if($row_content_forms_fields_select['remote'] == 1) $remote='data-fv-remote, data-fv-remote-type=POST, data-fv-remote-delay=1000, data-fv-remote-url=includes/json/remote/add.php, data-fv-remote-message=That '.strtolower($row_content_forms_fields_select['label']).' is taken. Please try another.';else $remote='';} if($row_content_forms_fields_select['dependant_fields'] != ''){$dependant_fields=explode(',', $row_content_forms_fields_select['dependant_fields']);$form[$form_id]->startDependantFields($dependant_fields[0], $dependant_fields[1]);} if($row_content_forms_fields_select['database_action'] != ''){require_once('includes/functions/core/string_replace.php');$row_content_forms_fields_select['database_action'] = string_replace($row_content_forms_fields_select['database_action']);} if($row_content_forms_fields_select['database_fetch'] != ''){require_once('includes/functions/core/string_replace.php');$row_content_forms_fields_select['database_fetch'] = string_replace($row_content_forms_fields_select['database_fetch']);} if($row_content_forms_fields_select['icon_class'] != ''){$form[$form_id]->addIcon($row_content_forms_fields_select['name'], "<span class='".$row_content_forms_fields_select['icon_class']."'></span>", 'before');$form[$form_id]->addIcon($row_content_forms_fields_select['name'].'[]', "<span class='".$row_content_forms_fields_select['icon_class']."'></span>", 'before');} if($row_content_forms_fields_select['label'] != ''){if(defined('LAST_URI') && is_numeric(LAST_URI) && isset($_GET['page_action']) && $_GET['page_action'] == 'edit'){if($row_content_forms_fields_select['label_edit'] != '') $row_content_forms_fields_select['label'] = dgettext((($db_type=='core')? 'core' : LANGUAGE_DOMAIN), $row_content_forms_fields_select['label_edit']);if($row_content_forms_fields_select['required_edit'] == 1) $row_content_forms_fields_select['label'] = dgettext((($db_type=='core')? 'core' : LANGUAGE_DOMAIN), $row_content_forms_fields_select['label']).'<span class="required">*</span>';else $row_content_forms_fields_select['label'] = dgettext((($db_type=='core')? 'core' : LANGUAGE_DOMAIN), $row_content_forms_fields_select['label']).' '.dgettext('core', '(optional)');} else{if($row_content_forms_fields_select['required'] == 1) $row_content_forms_fields_select['label'] = dgettext((($db_type=='core')? 'core' : LANGUAGE_DOMAIN), $row_content_forms_fields_select['label']).'<span class="required">*</span>';else $row_content_forms_fields_select['label'] = dgettext((($db_type=='core')? 'core' : LANGUAGE_DOMAIN), $row_content_forms_fields_select['label']).' '.dgettext('core', '(optional)');} $form[$form_id]->addHtml('<label for="'.$row_content_forms_fields_select['name'].'">'.$row_content_forms_fields_select['label'].'</label>', $row_content_forms_fields_select['name'], 'before');$form[$form_id]->addHtml('<label for="'.$row_content_forms_fields_select['name'].'[]'.'">'.$row_content_forms_fields_select['label'].'</label>', $row_content_forms_fields_select['name'].'[]', 'before');} if($row_content_forms_fields_select['help_block'] != ''){$form[$form_id]->addHtml('<span class="help-block">'.dgettext((($db_type=='core')? 'core' : LANGUAGE_DOMAIN), $row_content_forms_fields_select['help_block']).'</span>', $row_content_forms_fields_select['name'], 'after');$form[$form_id]->addHtml('<span class="help-block">'.dgettext((($db_type=='core')? 'core' : LANGUAGE_DOMAIN), $row_content_forms_fields_select['help_block']).'</span>', $row_content_forms_fields_select['name'].'[]', 'after');} if($row_content_forms_fields_select['plugin'] == 'autocomplete'){$autocomplete_tags='';if($row_content_forms_fields_select['autocomplete_replacements'] != ''){$autocomplete_replacements=explode(',', $row_content_forms_fields_select['autocomplete_replacements']);for($k=0;$k<sizeof($autocomplete_replacements);$k++){if($k==0) $autocomplete_tags.='"'.$autocomplete_replacements[$k].'"';else $autocomplete_tags.=',"'.$autocomplete_replacements[$k].'"';}} elseif($row_content_forms_fields_select['database_fetch'] != ''){$database_fetch=explode(',', $row_content_forms_fields_select['database_fetch']);if(isset($database_fetch[4])){if($database_fetch[4][0] == '('){$database_fetch[4] = str_replace('-', ',', $database_fetch[4]);$where_sign='IN';} else $where_sign='=';} $item_display_array=explode('|', $database_fetch[2]);if(isset($item_display_array[1])){if(isset($database_fetch[5])) $query_database_fetch_select="SELECT $item_display_array[0], $item_display_array[1] FROM $database_fetch[1] WHERE $database_fetch[3] $where_sign ".(($where_sign=='IN')? $database_fetch[4] : ':where_value')." ORDER BY $database_fetch[5]";elseif(isset($database_fetch[4])) $query_database_fetch_select="SELECT $item_display_array[0], $item_display_array[1] FROM $database_fetch[1] WHERE $database_fetch[3] $where_sign ".(($where_sign=='IN')? $database_fetch[4] : ':where_value');elseif(isset($database_fetch[3])) $query_database_fetch_select="SELECT $item_display_array[0], $item_display_array[1] FROM $database_fetch[1] ORDER BY $database_fetch[3]";} else{if(isset($database_fetch[5])) $query_database_fetch_select="SELECT $item_display_array[0] FROM $database_fetch[1] WHERE $database_fetch[3] $where_sign ".(($where_sign=='IN')? $database_fetch[4] : ':where_value')." ORDER BY $database_fetch[6]";elseif(isset($database_fetch[4])) $query_database_fetch_select="SELECT $item_display_array[0] FROM $database_fetch[1] WHERE $database_fetch[3] $where_sign ".(($where_sign=='IN')? $database_fetch[4] : ':where_value');elseif(isset($database_fetch[3])) $query_database_fetch_select="SELECT $item_display_array[0] FROM $database_fetch[1] ORDER BY $database_fetch[3]";} $statement_database_fetch_select=$db_connect[$database_fetch[0]]->prepare($query_database_fetch_select);if(isset($where_sign) && $where_sign=='=') $statement_database_fetch_select->bindParam(':where_value', $database_fetch[4], PDO::PARAM_STR);$result_database_fetch_select=$statement_database_fetch_select->execute();$k=0;foreach($statement_database_fetch_select->fetchAll(PDO::FETCH_ASSOC) as $row_database_fetch_select){if(isset($item_display_array[1])) $item_display=$row_database_fetch_select[$item_display_array[0]].' | '.$row_database_fetch_select[$item_display_array[1]];else $item_display=$row_database_fetch_select[$item_display_array[0]];if($k==0) $autocomplete_tags.='"'.$item_display.'"';else $autocomplete_tags.=',"'.$item_display.'"';$k++;}} $autocomplete=array('%availableTags%' => $autocomplete_tags);$form[$form_id]->addPlugin('autocomplete', '.'.$row_content_forms_fields_select['name'], 'default', $autocomplete);} elseif($row_content_forms_fields_select['plugin'] == 'pickatime') $form[$form_id]->addPlugin('pickadate', '.'.$row_content_forms_fields_select['name'], 'pickatime');elseif($row_content_forms_fields_select['plugin'] == 'passfield') $form[$form_id]->addPlugin('passfield', '.'.$row_content_forms_fields_select['name'], 'lower-upper-number-symbol-min8');elseif($row_content_forms_fields_select['plugin'] == 'word-character-count') $form[$form_id]->addPlugin('word-character-count', '.'.$row_content_forms_fields_select['name'], 'default', array('%maxAuthorized%' => 400));elseif($row_content_forms_fields_select['plugin'] != '') $form[$form_id]->addPlugin($row_content_forms_fields_select['plugin'], '.'.$row_content_forms_fields_select['name']);if($row_content_forms_fields_select['type'] == 'title'){$form[$form_id]->endFieldset();$form[$form_id]->startFieldset(dgettext((($db_type=='core')? 'core' : LANGUAGE_DOMAIN), $field_value));} if($row_content_forms_fields_select['type'] == 'ajaxelements'){$field_value_array=explode(',', $field_value);$form[$form_id]->addHtml('<div id="ajax-elements-container"></div>');$form[$form_id]->addInput('hidden', $row_content_forms_fields_select['name'].'_count', 1);$form[$form_id]->addHtml('<div class="row mt-10 mb-20"><div class="col-sm-12">');$form[$form_id]->addHtml('<button type="button" class="btn btn-primary add-button-'.$row_content_forms_fields_select['name'].'">Add '.dgettext((($db_type=='core')? 'core' : LANGUAGE_DOMAIN), $row_content_forms_fields_select['placeholder']).'</button>');$form[$form_id]->addHtml('<button type="button" class="btn remove-button-'.$row_content_forms_fields_select['name'].' hidden">Remove '.dgettext((($db_type=='core')? 'core' : LANGUAGE_DOMAIN), $row_content_forms_fields_select['placeholder']).'</button>');$form[$form_id]->addHtml('</div></div>');if(isset($GLOBALS['page_js'])) $GLOBALS['page_js'] .=' <script type="text/javascript"> $(document).ready(function(){var ajaxElementsTarget=$("#ajax-elements-container");'.((isset($_GET['page_action']) && ($_GET['page_action'] == 'view' || $_GET['page_action'] == 'edit'))? ' $.ajax({url: "includes/content/types/form/get-ajax-elements.php", data: {"db_type": "'.$db_type.'", "form_id": "'.$form_id.'", "ajax_elements": "'.$field_value.'", "name_index": parseInt($(".'.$field_value_array[0].'").length)+1, "past_elements": "'.LAST_URI.'", }}).done(function(data){ajaxElementsTarget.append(data);$("input[name=\''.$row_content_forms_fields_select['name'].'_count\']").val(parseInt($(".'.$field_value_array[0].'").length));if(parseInt($(".'.$field_value_array[0].'").length) > 1){$(".remove-button-'.$row_content_forms_fields_select['name'].'").removeClass("hidden").off("click").on("click", function(){$("#ajax-elements-container .form-group").last().remove();$("input[name=\''.$row_content_forms_fields_select['name'].'_count\']").val(parseInt($(".'.$field_value_array[0].'").length));if(parseInt($(".'.$field_value_array[0].'").length) < 2){$(".remove-button-'.$row_content_forms_fields_select['name'].'").addClass("hidden").off("click");}});}}).fail(function(data, statut, error){console.log(error);});' : '').' $(".add-button-'.$row_content_forms_fields_select['name'].'").on("click", function(){$.ajax({url: "includes/content/types/form/get-ajax-elements.php", data: {"db_type": "'.$db_type.'", "form_id": "'.$form_id.'", "ajax_elements": "'.$field_value.'", "name_index": parseInt($(".'.$field_value_array[0].'").length)+1, "past_elements": 0, }}).done(function(data){ajaxElementsTarget.append(data);$("input[name=\''.$row_content_forms_fields_select['name'].'_count\']").val(parseInt($(".'.$field_value_array[0].'").length));if(parseInt($(".'.$field_value_array[0].'").length) > 1){$(".remove-button-'.$row_content_forms_fields_select['name'].'").removeClass("hidden").off("click").on("click", function(){$("#ajax-elements-container .form-group").last().remove();$("input[name=\''.$row_content_forms_fields_select['name'].'_count\']").val(parseInt($(".'.$field_value_array[0].'").length));if(parseInt($(".'.$field_value_array[0].'").length) < 2){$(".remove-button-'.$row_content_forms_fields_select['name'].'").addClass("hidden").off("click");}});}}).fail(function(data, statut, error){console.log(error);});});});</script>';} elseif($row_content_forms_fields_select['type'] == 'text' || $row_content_forms_fields_select['type'] == 'email' || $row_content_forms_fields_select['type'] == 'password' || $row_content_forms_fields_select['type'] == 'url' || $row_content_forms_fields_select['type'] == 'color' || $row_content_forms_fields_select['type'] == 'range' || $row_content_forms_fields_select['type'] == 'hidden') $form[$form_id]->addInput($row_content_forms_fields_select['type'], $row_content_forms_fields_select['name'], $field_value, '', 'placeholder='.dgettext((($db_type=='core')? 'core' : LANGUAGE_DOMAIN), $row_content_forms_fields_select['placeholder']).', class='.$row_content_forms_fields_select['class'].' '.$row_content_forms_fields_select['name'].', field_value='.$field_value_database.', '.$row_content_forms_fields_select['attributes'].', '.$disabled.', '.$required.', '.$validation.', '.$remote);elseif($row_content_forms_fields_select['type'] == 'textarea'){if($row_content_forms_fields_select['plugin'] == 'tinymce') $form[$form_id]->addTextarea($row_content_forms_fields_select['name'], $field_value, '', 'cols=100, rows=20, placeholder='.dgettext((($db_type=='core')? 'core' : LANGUAGE_DOMAIN), $row_content_forms_fields_select['placeholder']).', class=tinyMce '.$row_content_forms_fields_select['class'].' '.$row_content_forms_fields_select['name'].', field_value='.$field_value_database.', '.$row_content_forms_fields_select['attributes'].', '.$disabled.', '.$required.', '.$validation.', '.$remote);else $form[$form_id]->addTextarea($row_content_forms_fields_select['name'], $field_value, '', 'cols=30, rows=4, placeholder='.dgettext((($db_type=='core')? 'core' : LANGUAGE_DOMAIN), $row_content_forms_fields_select['placeholder']).', class='.$row_content_forms_fields_select['class'].' '.$row_content_forms_fields_select['name'].', field_value='.$field_value_database.', '.$row_content_forms_fields_select['attributes'].', '.$disabled.', '.$required.', '.$validation.', '.$remote);} elseif($row_content_forms_fields_select['type'] == 'select'){if($row_content_forms_fields_select['select_multiple'] == 1){$select_multiple='multiple=multiple';$row_content_forms_fields_select['name'] = $row_content_forms_fields_select['name'].'[]';$field_value_database_array=explode(',', $field_value_database);} else $select_multiple='';if($row_content_forms_fields_select['select_search'] == 1) $select_search='data-live-search=true';else $select_search='';if($row_content_forms_fields_select['placeholder'] != '') $form[$form_id]->addOption($row_content_forms_fields_select['name'], '', dgettext((($db_type=='core')? 'core' : LANGUAGE_DOMAIN), $row_content_forms_fields_select['placeholder']));if($row_content_forms_fields_select['select_options'] != ''){$select_options=explode(',', $row_content_forms_fields_select['select_options']);for($k=0;$k<sizeof($select_options);$k+=4){if(isset($select_options[$k+2]) && $select_options[$k+2] !='') $option_icon='data-icon='.$select_options[$k+2];else $option_icon='';if(isset($select_options[$k+3]) && $select_options[$k+3] !='') $option_group=$select_options[$k+3];else $option_group='';if($row_content_forms_fields_select['select_multiple'] == 1){for($j=0;$j<sizeof($field_value_database_array);$j++){if($select_options[$k] == $field_value_database_array[$j]){$option_selected='selected';break;} else $option_selected='';}} else{if($select_options[$k] == $field_value_database) $option_selected='selected';else $option_selected='';} $form[$form_id]->addOption($row_content_forms_fields_select['name'], $select_options[$k], dgettext((($db_type=='core')? 'core' : LANGUAGE_DOMAIN), $select_options[$k+1]), $option_group, $option_icon.', '.$option_selected);}} elseif($row_content_forms_fields_select['database_fetch'] != ''){$database_fetch=explode(',', $row_content_forms_fields_select['database_fetch']);if(isset($database_fetch[5])){if($database_fetch[5][0] == '('){$database_fetch[5] = str_replace('-', ',', $database_fetch[5]);$where_sign='IN';} else $where_sign='=';} $item_display_array=explode('|', $database_fetch[3]);if(isset($item_display_array[1])){$query_field_value_select="SELECT $database_fetch[2], $item_display_array[0], $item_display_array[1] FROM $database_fetch[1]";if(isset($database_fetch[6])) $query_field_value_select="SELECT $database_fetch[2], $item_display_array[0], $item_display_array[1] FROM $database_fetch[1] WHERE $database_fetch[4] $where_sign ".(($where_sign=='IN')? $database_fetch[5] : ':where_value')." ORDER BY $database_fetch[6]";elseif(isset($database_fetch[5])) $query_field_value_select="SELECT $database_fetch[2], $item_display_array[0], $item_display_array[1] FROM $database_fetch[1] WHERE $database_fetch[4] $where_sign ".(($where_sign=='IN')? $database_fetch[5] : ':where_value');elseif(isset($database_fetch[4])) $query_field_value_select="SELECT $database_fetch[2], $item_display_array[0], $item_display_array[1] FROM $database_fetch[1] ORDER BY $database_fetch[4]";} else{$query_field_value_select="SELECT $database_fetch[2], $item_display_array[0] FROM $database_fetch[1]";if(isset($database_fetch[6])) $query_field_value_select="SELECT $database_fetch[2], $item_display_array[0] FROM $database_fetch[1] WHERE $database_fetch[4] $where_sign ".(($where_sign=='IN')? $database_fetch[5] : ':where_value')." ORDER BY $database_fetch[6]";elseif(isset($database_fetch[5])) $query_field_value_select="SELECT $database_fetch[2], $item_display_array[0] FROM $database_fetch[1] WHERE $database_fetch[4] $where_sign ".(($where_sign=='IN')? $database_fetch[5] : ':where_value');elseif(isset($database_fetch[4])) $query_field_value_select="SELECT $database_fetch[2], $item_display_array[0] FROM $database_fetch[1] ORDER BY $database_fetch[4]";} $statement_field_value_select=$db_connect[$database_fetch[0]]->prepare($query_field_value_select);if(isset($where_sign) && $where_sign=='=') $statement_field_value_select->bindParam(':where_value', $database_fetch[5], PDO::PARAM_STR);$result_field_value_select=$statement_field_value_select->execute();foreach($statement_field_value_select->fetchAll(PDO::FETCH_ASSOC) as $row_field_value_select){if($database_fetch[1] == 'countries') $option_icon='class=flag '.strtolower($row_field_value_select[$database_fetch[2]]);else $option_icon='';if($row_content_forms_fields_select['select_multiple'] == 1){for($j=0;$j<sizeof($field_value_database_array);$j++){if($row_field_value_select[$database_fetch[2]] == $field_value_database_array[$j]){$option_selected='selected';break;} else $option_selected='';}} else{if($row_field_value_select[$database_fetch[2]] == $field_value_database) $option_selected='selected';else $option_selected='';} if(isset($item_display_array[1])) $item_display=$row_field_value_select[$item_display_array[0]].' | '.$row_field_value_select[$item_display_array[1]];else $item_display=$row_field_value_select[$item_display_array[0]];$form[$form_id]->addOption($row_content_forms_fields_select['name'], $row_field_value_select[$database_fetch[2]], $item_display, '', $option_icon.', '.$option_selected);}} $form[$form_id]->addSelect($row_content_forms_fields_select['name'], '', 'class=selectpicker show-tick '.$row_content_forms_fields_select['class'].', '.$select_multiple.', '.$select_search.', field_value='.$field_value_database.', '.$row_content_forms_fields_select['attributes'].', '.$disabled.', '.$required.', '.$validation.', '.$remote);} elseif($row_content_forms_fields_select['type'] == 'radiogroup' || $row_content_forms_fields_select['type'] == 'checkboxgroup'){if($row_content_forms_fields_select['type'] == 'checkboxgroup') $row_content_forms_fields_select['name'] = $row_content_forms_fields_select['name'].'[]';if($row_content_forms_fields_select['radiogroup_checkboxgroup_layout'] == 'vertical'){$radiogroup_checkboxgroup_layout=true;if($row_content_forms_fields_select['label'] != '') $form[$form_id]->addHtml('<br />', $row_content_forms_fields_select['name'], 'before');} else $radiogroup_checkboxgroup_layout=false;$form[$form_id]->addPlugin('icheck', 'input', 'default', array('%theme%' => 'square', '%color%' => 'red'));if($row_content_forms_fields_select['radiogroup_checkboxgroup_options'] != ''){$radiogroup_checkboxgroup_options=explode(',', $row_content_forms_fields_select['radiogroup_checkboxgroup_options']);for($k=0;$k<sizeof($radiogroup_checkboxgroup_options);$k+=2){if($radiogroup_checkboxgroup_options[$k] == $field_value_database) $radio_checked='checked';else $radio_checked='';if($row_content_forms_fields_select['type'] == 'radiogroup') $form[$form_id]->addRadio($row_content_forms_fields_select['name'], dgettext((($db_type=='core')? 'core' : LANGUAGE_DOMAIN), $radiogroup_checkboxgroup_options[$k+1]), $radiogroup_checkboxgroup_options[$k], $radio_checked.', '.$disabled.', '.$validation.', '.$remote);elseif($row_content_forms_fields_select['type'] == 'checkboxgroup') $form[$form_id]->addCheckbox($row_content_forms_fields_select['name'], dgettext((($db_type=='core')? 'core' : LANGUAGE_DOMAIN), $radiogroup_checkboxgroup_options[$k+1]), $radiogroup_checkboxgroup_options[$k].', '.$disabled.', '.$validation.', '.$remote);}} elseif($row_content_forms_fields_select['database_fetch'] != ''){$database_fetch=explode(',', $row_content_forms_fields_select['database_fetch']);if(isset($database_fetch[5])){if($database_fetch[5][0] == '('){$database_fetch[5] = str_replace('-', ',', $database_fetch[5]);$where_sign='IN';} else $where_sign='=';} $item_display_array=explode('|', $database_fetch[3]);if(isset($item_display_array[1])){$query_field_value_select="SELECT $database_fetch[2], $item_display_array[0], $item_display_array[1] FROM $database_fetch[1]";if(isset($database_fetch[6])) $query_field_value_select="SELECT $database_fetch[2], $item_display_array[0], $item_display_array[1] FROM $database_fetch[1] WHERE $database_fetch[4] $where_sign ".(($where_sign=='IN')? $database_fetch[5] : ':where_value')." ORDER BY $database_fetch[6]";elseif(isset($database_fetch[5])) $query_field_value_select="SELECT $database_fetch[2], $item_display_array[0], $item_display_array[1] FROM $database_fetch[1] WHERE $database_fetch[4] $where_sign ".(($where_sign=='IN')? $database_fetch[5] : ':where_value');elseif(isset($database_fetch[4])) $query_field_value_select="SELECT $database_fetch[2], $item_display_array[0], $item_display_array[1] FROM $database_fetch[1] ORDER BY $database_fetch[4]";} else{$query_field_value_select="SELECT $database_fetch[2], $item_display_array[0] FROM $database_fetch[1]";if(isset($database_fetch[6])) $query_field_value_select="SELECT $database_fetch[2], $item_display_array[0] FROM $database_fetch[1] WHERE $database_fetch[4] $where_sign ".(($where_sign=='IN')? $database_fetch[5] : ':where_value')." ORDER BY $database_fetch[6]";elseif(isset($database_fetch[5])) $query_field_value_select="SELECT $database_fetch[2], $item_display_array[0] FROM $database_fetch[1] WHERE $database_fetch[4] $where_sign ".(($where_sign=='IN')? $database_fetch[5] : ':where_value');elseif(isset($database_fetch[4])) $query_field_value_select="SELECT $database_fetch[2], $item_display_array[0] FROM $database_fetch[1] ORDER BY $database_fetch[4]";} $statement_field_value_select=$db_connect[$database_fetch[0]]->prepare($query_field_value_select);if(isset($where_sign) && $where_sign=='=') $statement_field_value_select->bindParam(':where_value', $database_fetch[5], PDO::PARAM_STR);$result_field_value_select=$statement_field_value_select->execute();foreach($statement_field_value_select->fetchAll(PDO::FETCH_ASSOC) as $row_field_value_select){if($row_field_value_select[$database_fetch[2]] == $field_value_database) $radio_checked='checked';else $radio_checked='';if(isset($item_display_array[1])) $item_display=$row_field_value_select[$item_display_array[0]].' | '.$row_field_value_select[$item_display_array[1]];else $item_display=$row_field_value_select[$item_display_array[0]];if($row_content_forms_fields_select['type'] == 'radiogroup') $form[$form_id]->addRadio($row_content_forms_fields_select['name'], $item_display, $row_field_value_select[$database_fetch[2]], $radio_checked.', '.$disabled.', '.$validation.', '.$remote);elseif($row_content_forms_fields_select['type'] == 'checkboxgroup') $form[$form_id]->addCheckbox($row_content_forms_fields_select['name'], $item_display, $row_field_value_select[$database_fetch[2]].', '.$disabled.', '.$validation.', '.$remote);}} if($row_content_forms_fields_select['type'] == 'radiogroup') $form[$form_id]->printRadioGroup($row_content_forms_fields_select['name'], '', $radiogroup_checkboxgroup_layout, $row_content_forms_fields_select['class'].', field_value='.$field_value_database.', '.$row_content_forms_fields_select['attributes'].', '.$disabled.', '.$required.', '.$validation.', '.$remote);elseif($row_content_forms_fields_select['type'] == 'checkboxgroup') $form[$form_id]->printCheckboxGroup($row_content_forms_fields_select['name'], '', $radiogroup_checkboxgroup_layout, $row_content_forms_fields_select['class'].', field_value='.$field_value_database.', '.$row_content_forms_fields_select['attributes'].', '.$disabled.', '.$required.', '.$validation.', '.$remote);} elseif($row_content_forms_fields_select['type'] == 'file'){if($row_content_forms_fields_select['fileupload_dir'] != ''){require_once('includes/functions/core/string_replace.php');$fileupload_dir=string_replace($row_content_forms_fields_select['fileupload_dir']);} else $fileupload_dir='';if($row_content_forms_fields_select['fileupload_multiple'] == 1){$multiple='multiple';$row_content_forms_fields_select['name'] = $row_content_forms_fields_select['name'].'[]';} else $multiple='';if(defined('LAST_URI') && is_numeric(LAST_URI) && isset($_GET['page_action']) && ($_GET['page_action'] == 'edit' || $_GET['page_action'] == 'view')){$form[$form_id]->addHtml('<div class="row fileupload">', $row_content_forms_fields_select['name'], 'after');if($row_content_forms_fields_select['fileupload_multiple'] == 1){if(!isset($fileupload_no)) $fileupload_no=0;if(file_exists('uploads/'.$fileupload_dir)){$results=scandir('uploads/'.$fileupload_dir);foreach($results as $result){if($result=== '.' || $result=== '..') continue;$file='uploads/'.$fileupload_dir.'/'.$result;if(file_exists($file)){$fileupload_no++;$extended_forms='<form id="fileupload_'.$fileupload_no.'" action="'.BASE.'includes/actions/delete_file.php" method="POST"> <input type="hidden" name="file" value="'.$file.'" /> </form>';$form[$form_id]->addHtml(' <div class="col-md-2"> <div class="mt-element-ribbon bg-grey-steel"> '.(($_GET['page_action'] == 'edit')? ' <a href="javascript:void(0);" onclick="document.getElementById(\''.'fileupload_'.$fileupload_no.'\').submit();" class="ribbon ribbon-vertical-right ribbon-color-danger" data-toggle="delete" data-placement="left"><i class="fas fa-close"></i></a>' : '').' <p class="ribbon-content"><a target="_blank" href="'.$file.'"> '.((in_array(exif_imagetype($file), array(IMAGETYPE_JPEG, IMAGETYPE_PNG, IMAGETYPE_BMP, IMAGETYPE_GIF)))? '<img class="img-responsive" src="'.$file.'" />' : '<i class="fas fa-file fileupload-icon"></i>').' <br/>'.$result.' </a></p></div></div>', $row_content_forms_fields_select['name'], 'after');}} }} else{if(!isset($fileupload_no)) $fileupload_no=0;$file='uploads/'.$fileupload_dir.'/'.$field_value_database;if(file_exists($file) && $field_value_database!=''){$fileupload_no++;$extended_forms.='<form id="fileupload_'.$fileupload_no.'" action="'.BASE.'includes/actions/delete_file.php" method="POST"> <input type="hidden" name="file" value="'.$file.'" /> <input type="hidden" name="id" value="'.LAST_URI.'" /> <input type="hidden" name="dba" value="'.$row_content_forms_fields_select['database_action'].'" /> </form>';$form[$form_id]->addHtml(' <div class="col-md-4"> <div class="mt-element-ribbon bg-grey-steel"> '.(($_GET['page_action'] == 'edit')? ' <a href="javascript:void(0);" onclick="document.getElementById(\''.'fileupload_'.$fileupload_no.'\').submit();" class="ribbon ribbon-vertical-right ribbon-color-danger" data-toggle="delete" data-placement="left"><i class="fas fa-close"></i></a>' : '').' <p class="ribbon-content"><a target="_blank" href="'.$file.'"> '.((in_array(exif_imagetype($file), array(IMAGETYPE_JPEG, IMAGETYPE_PNG, IMAGETYPE_BMP, IMAGETYPE_GIF)))? '<img class="img-responsive" src="'.$file.'" />' : '<i class="fas fa-file fileupload-icon"></i>').' <br/>'.$field_value_database.' </a></p></div></div>', $row_content_forms_fields_select['name'], 'after');}} $form[$form_id]->addHtml('</div>', $row_content_forms_fields_select['name'], 'after');} $form[$form_id]->addInput($row_content_forms_fields_select['type'], $row_content_forms_fields_select['name'], $field_value, '', 'placeholder='.dgettext((($db_type=='core')? 'core' : LANGUAGE_DOMAIN), $row_content_forms_fields_select['placeholder']).', class='.$row_content_forms_fields_select['class'].' '.$row_content_forms_fields_select['name'].', field_value='.$field_value_database.', '.$multiple.', '.$row_content_forms_fields_select['attributes'].', '.$disabled.', '.$required.', '.$validation.', '.$remote);} elseif($row_content_forms_fields_select['type'] == 'recaptcha') $form[$form_id]->addRecaptcha($row_content_forms_fields_select['value']);if($row_content_forms_fields_select['dependant_fields'] != '') $form[$form_id]->endDependantFields();}