For running J!5.1 you must https://fabrikar.com/forums/index.php?wiki/update-from-github/ or include the new file manually https://fabrikar.com/forums/index.php?threads/joomla-5-1-and-fabrik-cannot-find-files-error.54473/post-285151 See also Announcements
Please see our announcement here.
<?php
# Check to ensure this file is included in Joomla!
defined('_JEXEC') or die();
# empty current dropdowns table
$db = JFactory::getDbo();
$query = "TRUNCATE `jos_fabrik_dropdowns`";
$db->setQuery($query);
# get dropdowns and their parameters from $query = $db->getQuery(true);
$query = $db->getQuery(true);
$query = "SELECT `jos_fabrik_elements`.`name`, `jos_fabrik_elements`.`params` FROM `jos_fabrik_elements` WHERE `jos_fabrik_elements`.`plugin`= 'dropdown'";
$db->setQuery($query);
$dropdowns = $db->loadObjectList();
# start of query to insert dropdown values and labels
$query = $db->getQuery(true);
$query = "INSERT INTO `jos_fabrik_dropdowns` (`name`, `value`, `label`) VALUES ";
# do for each dropdown
foreach ($dropdowns as $dropdown) {
# decode json encoded parameters
$dropdown_map = json_decode($dropdown->params, true);
# array with all values of this dropdown
$values = $dropdown_map['sub_options']['sub_values'];
# array with all labels of this dropdown
$labels = $dropdown_map['sub_options']['sub_labels'];
for($i = 0; $i < count($values); $i++) {
# create recordset for SQL statement
$query .= "('".mysql_real_escape_string($dropdown->name)."','".$values[$i]."','".mysql_real_escape_string($labels[$i])."'),";
}
}
# remove trailing comma
$query = rtrim($query, ',');
# insert records in table
$db->setQuery($query);
$result = $db->query();
?>