function settingGetAllSettingGroup()
{
$q = db_query("select settings_groupID, settings_group_name, sort_order from " . SETTINGS_GROUPS_TABLE . " where settings_groupID != " . (int) settingGetFreeGroupId() . " order by sort_order, settings_group_name ");
$res = array();
while ($row = db_fetch_row($q)) {
$res[] = $row;
}
return $res;
}
/**
* Install module
* Should be redefined
* In redefinition before call to parent method should be init SettingsFields
*
*/
function install()
{
db_query("insert into " . MODULES_TABLE . " ( module_name, ModuleClassName ) " . " values( '" . $this->title . "', '" . get_class($this) . "' ) ");
$NewModuleConfigID = db_insert_id();
$this->ModuleConfigID = $NewModuleConfigID;
$sql = "\n UPDATE " . MODULES_TABLE . "\n SET module_name='" . $this->title . ($this->SingleInstall ? '' : ' (' . $NewModuleConfigID . ")") . "'\n WHERE module_id=" . $NewModuleConfigID . "\n ";
db_query($sql);
$this->_initSettingFields();
$this->SettingsFields = xEscapeSQLstring($this->SettingsFields);
foreach ($this->Settings as $_SettingName) {
$sql = "\n INSERT INTO " . SETTINGS_TABLE . "\n (\n settings_groupID, settings_constant_name,\n settings_value,\n settings_title,\n settings_description,\n settings_html_function,\n sort_order\n )\n VALUES (\n " . settingGetFreeGroupId() . ", '" . $_SettingName . ($this->SingleInstall ? '' : '_' . $NewModuleConfigID) . "',\n '" . (isset($this->SettingsFields[$_SettingName]['settings_value']) ? $this->SettingsFields[$_SettingName]['settings_value'] : '') . "',\n '" . (isset($this->SettingsFields[$_SettingName]['settings_title']) ? $this->SettingsFields[$_SettingName]['settings_title'] : '') . "',\n '" . (isset($this->SettingsFields[$_SettingName]['settings_description']) ? $this->SettingsFields[$_SettingName]['settings_description'] : '') . "',\n '" . (isset($this->SettingsFields[$_SettingName]['settings_html_function']) ? $this->SettingsFields[$_SettingName]['settings_html_function'] : '') . "',\n '" . (isset($this->SettingsFields[$_SettingName]['sort_order']) ? $this->SettingsFields[$_SettingName]['sort_order'] : '') . "'\n )";
db_query($sql);
}
}
