function GetModuleSettingsByBlock($blockID, $templateName = false)
{
global $wpdb;
if (!$templateName) {
$templateName = get_option('template');
}
$moduleSettings = new FlutterLayoutBlock();
// Load settings
$moduleSettingsInfo = $wpdb->get_row(" SELECT * FROM " . FLUTTER_TABLE_LAYOUT_MODULES . " WHERE block_id = {$blockID} ");
if (!$moduleSettingsInfo) {
return false;
}
$moduleSettingsInfo->module_name = $wpdb->get_var(" SELECT name" . " FROM " . RC_CWP_TABLE_MODULES . " WHERE id=" . $moduleSettingsInfo->module_id);
if ($moduleSettingsInfo->duplicate_id > 0) {
$moduleSettingsInfo->title = $wpdb->get_var("SELECT duplicate_name FROM " . FLUTTER_TABLE_MODULES_DUPLICATES . " WHERE duplicate_id = '{$moduleSettingsInfo->duplicate_id}'");
} else {
$moduleSettingsInfo->title = $moduleSettingsInfo->module_name;
}
$moduleSettingsID = $moduleSettingsInfo->block_id;
// Load Variables
$moduleVariables = $wpdb->get_results("SELECT * FROM " . FLUTTER_TABLE_LAYOUT_VARIABLES . " WHERE parent = '{$moduleSettingsID}' ORDER BY variable_id");
foreach ($moduleSettingsInfo as $key => $val) {
$moduleSettings->{$key} = $val;
}
if (empty($moduleVariables)) {
$moduleVariables = array();
}
$moduleSettings->variables = $moduleVariables;
// Load Variables options
foreach ($moduleSettings->variables as $varKey => $variable) {
$moduleSettings->variables[$varKey]->options = unserialize($moduleSettings->variables[$varKey]->options);
if (!is_array($moduleSettings->variables[$varKey]->options)) {
$moduleSettings->variables[$varKey]->options = array();
}
if (isset($moduleSettings->variables[$varKey]->options['dbvalue'])) {
$moduleSettings->variables[$varKey]->options = FlutterLayoutBlock::GenerateOptionsFromDatabase(trim($moduleSettings->variables[$varKey]->options['dbvalue']), trim(stripslashes($moduleSettings->variables[$varKey]->options['query'])));
}
switch ($moduleSettings->variables[$varKey]->type) {
case 'checkbox_list':
case 'listbox':
$moduleSettings->variables[$varKey]->value = unserialize($moduleSettings->variables[$varKey]->value);
break;
}
}
return $moduleSettings;
}
