/**
* Returns all site settings
*
* @return <bool>
*/
private function readSettings()
{
// TODO sort out this hard code define problem
if ($this->memCache) {
$memCacheSettings = $this->memCache->read('settings');
if ($memCacheSettings) {
$settings = $memCacheSettings;
} else {
$settings = \Hotaru\Models2\Setting::getValues($this);
//$settings = HotaruModels\Setting::getValues();
$this->memCache->write('settings', $settings, 10000);
}
} else {
$settings = \Hotaru\Models2\Setting::getValues($this);
}
if (!$settings) {
$default_settings = array('THEME' => 'default/', 'SITE_NAME' => 'Hotaru CMS', 'FRIENDLY_URLS' => false, 'LANG_CACHE' => false, 'SITE_OPEN' => false, 'DB_CACHE_DURATION' => 0, 'DB_CACHE' => false, 'DEBUG' => false, 'MINIFY_JS' => false, 'MINIFY_CSS' => false);
foreach ($default_settings as $setting => $value) {
$this->settings[$setting] = $value;
if (!defined($setting)) {
define($setting, $value);
}
}
return false;
}
/**
* override the theme if admin and ?themePreview is set on url
*/
$themePreview = $this->cage->get->testAlnumLines('themePreview');
if ($themePreview) {
$settings[2] = array('settings_name' => 'THEME', 'settings_value' => $themePreview . '/');
}
// Make Hotaru settings global constants
foreach ($settings as $setting) {
if (!defined($setting->settings_name)) {
define($setting->settings_name, $setting->settings_value);
}
}
return true;
}
/**
* Get system data
*
* @param string $type 'log' or 'object'
* @return object
*/
public function getSystemData($h, $level = '')
{
// essentials:
//$data = \Hotaru\Models\Miscdata::getCurrentSettings();
//print_r($data);
$report['hotaru_site_name'] = SITE_NAME;
$report['hotaru_SITEURL'] = SITEURL;
$report['php_version'] = phpversion();
$report['mysql_version'] = $h->db->get_var("SELECT VERSION() AS VE");
$report['hotaru_version'] = $h->version;
$report['php_extensions'] = get_loaded_extensions();
$sql = "SELECT miscdata_value FROM " . TABLE_MISCDATA . " WHERE miscdata_key = %s";
$report['hotaru_version_db'] = $h->db->get_var($h->db->prepare($sql, 'hotaru_version'));
// default permissions
if ($level !== 'lite') {
$sql = "SELECT miscdata_value FROM " . TABLE_MISCDATA . " WHERE miscdata_key = %s";
$report['hotaru_permissions'] = $h->db->get_var($h->db->prepare($sql, 'permissions'));
}
// default user settings
$sql = "SELECT miscdata_value FROM " . TABLE_MISCDATA . " WHERE miscdata_key = %s";
$report['hotaru_user_settings'] = $h->db->get_var($h->db->prepare($sql, 'user_settings'));
// Settings: Name, value (excluding SMTP PASSWORD)
$settings = \Hotaru\Models2\Setting::getValues($h);
//$settings = \Hotaru\Models\Setting::getValues();
if ($settings) {
foreach ($settings as $setting) {
// mask sensitive data
switch ($setting->settings_name) {
case 'SMTP_HOST':
case 'SMTP_PORT':
case 'SMTP_USERNAME':
case 'SMTP_PASSWORD':
case 'FORUM_PASSWORD':
$setting->settings_value = preg_replace("/[a-zA-Z0-9]/", "*", $setting->settings_value);
break;
}
$report['settings'][$setting->settings_name] = $setting->settings_value;
}
}
// Counts for all tables
foreach ($h->db->get_col("SHOW TABLES", 0) as $table_name) {
$report['hotaru_table_count'][$table_name] = $h->db->get_var("SELECT COUNT(*) FROM " . $table_name);
}
// $sql = 'SELECT s.schema_name,t.table_name, CONCAT(IFNULL(ROUND(SUM(t.data_length)/1024/1024,2),0.00),"Mb") data_size,CONCAT(IFNULL(ROUND(SUM(t.index_length)/1024/1024,2),0.00),"Mb") index_size, t.ENGINE ENGINE, t.table_rows TABLE_ROWS,t.row_format TABLE_ROW_FORMAT,date(t.update_time) FROM INFORMATION_SCHEMA.SCHEMATA s LEFT JOIN INFORMATION_SCHEMA.TABLES t ON s.schema_name = t.table_schema WHERE s.schema_name not in ("mysql","information_schema") GROUP BY s.schema_name,t.table_name,TABLE_ROW_FORMAT,ENGINE ORDER BY TABLE_ROWS DESC,data_size DESC,index_size DESC';
//
// print_r($h->db->get_results($sql));
// plugins: folder, enabled, version, order
$sql = "SELECT plugin_folder, plugin_enabled, plugin_version, plugin_order, plugin_latestversion FROM " . TABLE_PLUGINS . " ORDER BY plugin_order";
$plugins = $h->db->get_results($h->db->prepare($sql));
if ($plugins) {
foreach ($plugins as $plugin) {
$report['hotaru_plugins'][$plugin->plugin_folder]['enabled'] = $plugin->plugin_enabled;
$report['hotaru_plugins'][$plugin->plugin_folder]['version'] = $plugin->plugin_version;
$report['hotaru_plugins'][$plugin->plugin_folder]['order'] = $plugin->plugin_order;
$report['hotaru_plugins'][$plugin->plugin_folder]['plugin_latestversion'] = $plugin->plugin_latestversion;
}
}
// plugin hooks: id, folder, hook name
if ($level !== 'lite') {
$sql = "SELECT phook_id, plugin_folder, plugin_hook FROM " . TABLE_PLUGINHOOKS;
$plugins = $h->db->get_results($h->db->prepare($sql));
if ($plugins) {
foreach ($plugins as $plugin) {
$report['hotaru_plugin_hooks'][$plugin->phook_id]['folder'] = $plugin->plugin_folder;
$report['hotaru_plugin_hooks'][$plugin->phook_id]['hook'] = $plugin->plugin_hook;
}
}
}
// plugin settings: folder, setting (can't use value because might include passwords)
if ($level !== 'lite') {
$sql = "SELECT plugin_folder, plugin_setting, plugin_value FROM " . TABLE_PLUGINSETTINGS;
$plugins = $h->db->get_results($h->db->prepare($sql));
if ($plugins) {
foreach ($plugins as $plugin) {
if (is_serialized($plugin->plugin_value)) {
$plugin->plugin_value = unserialize($plugin->plugin_value);
}
$report['hotaru_plugin_settings'][$plugin->plugin_folder][$plugin->plugin_setting] = $this->applyMaskToArrays($h, $plugin->plugin_value);
}
}
}
// Widgets: plugin, function, args
$sql = "SELECT widget_plugin, widget_function, widget_args FROM " . TABLE_WIDGETS;
$widgets = $h->db->get_results($h->db->prepare($sql));
if ($widgets) {
foreach ($widgets as $widget) {
$report['hotaru_widgets'][$widget->widget_plugin]['function'] = $widget->widget_function;
$report['hotaru_widgets'][$widget->widget_plugin]['args'] = $widget->widget_args;
}
}
return $report;
}
