IP : 18.220.89.180Hostname : host45.registrar-servers.comKernel : Linux host45.registrar-servers.com 4.18.0-513.18.1.lve.2.el8.x86_64 #1 SMP Sat Mar 30 15:36:11 UTC 2024 x86_64Disable Function : None :) OS : Linux
PATH:
/
home/
../
var/
softaculous/
symfony2/
../
jorani/
../
ocart/
../
microweber/
../
una/
una.sql/
/
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */;
-- -- Table structure for table `sys_objects_chart` --
CREATE TABLE `sys_objects_chart` ( `id` int(11) NOT NULL AUTO_INCREMENT, `object` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `table` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `field_date_ts` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `field_date_dt` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `field_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `column_date` int(11) NOT NULL DEFAULT '0', `column_count` int(11) NOT NULL DEFAULT '1', `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `options` text COLLATE utf8mb4_unicode_ci NOT NULL, `query` text COLLATE utf8mb4_unicode_ci NOT NULL, `active` tinyint(4) NOT NULL DEFAULT '1', `order` int(11) NOT NULL, `class_name` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `class_file` varchar(256) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`id`), UNIQUE KEY `object` (`object`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=5 ;
-- -- Dumping data for table `sys_objects_chart` --
INSERT INTO `sys_objects_chart` VALUES (1, 'sys_accounts_growth', '_sys_chart_accounts_growth', 'sys_accounts', 'added', '', '', 0, 1, '', '', '', 1, 1, 'BxDolChartGrowth', ''), (2, 'sys_accounts_growth_speed', '_sys_chart_accounts_growth_speed', 'sys_accounts', 'added', '', '', 0, 1, '', '', '', 1, 1, 'BxDolChartGrowthSpeed', ''), (3, 'bx_persons_growth', '_bx_persons_chart_growth', 'bx_persons_data', 'added', '', '', 0, 1, '', '', 'SELECT {field_date_formatted} AS `period`, COUNT(*) AS {object} FROM {table} LEFT JOIN `sys_profiles` AS `tp` ON {table}.`id` = `tp`.`content_id` AND `tp`.`type`=''bx_persons'' WHERE 1 AND `tp`.`status`=''active'' {where_inteval} GROUP BY `period` ORDER BY {table}.{field_date} ASC', 1, 2, 'BxDolChartGrowth', ''), (4, 'bx_persons_growth_speed', '_bx_persons_chart_growth_speed', 'bx_persons_data', 'added', '', '', 0, 1, '', '', 'SELECT {field_date_formatted} AS `period`, COUNT(*) AS {object} FROM {table} LEFT JOIN `sys_profiles` AS `tp` ON {table}.`id` = `tp`.`content_id` AND `tp`.`type`=''bx_persons'' WHERE 1 AND `tp`.`status`=''active'' {where_inteval} GROUP BY `period` ORDER BY {table}.{field_date} ASC', 1, 3, 'BxDolChartGrowthSpeed', '');
-- -- Table structure for table `sys_recommendation_criteria` --
CREATE TABLE `sys_recommendation_criteria` ( `id` int(11) NOT NULL AUTO_INCREMENT, `object_id` int(11) NOT NULL DEFAULT '0', `name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `source_type` enum('sql','service') COLLATE utf8mb4_unicode_ci NOT NULL, `source` text COLLATE utf8mb4_unicode_ci NOT NULL, `params` text COLLATE utf8mb4_unicode_ci NOT NULL, `weight` float NOT NULL DEFAULT '0', `active` tinyint(4) NOT NULL DEFAULT '1', PRIMARY KEY (`id`), UNIQUE KEY `criterion` (`object_id`,`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=7 ;
-- -- Dumping data for table `sys_recommendation_criteria` --
INSERT INTO `sys_recommendation_criteria` VALUES (1, 1, 'mutual_friends', 'sql', 'SELECT `tff`.`initiator` AS `id`, SUM({points}) AS `value` FROM `sys_profiles_conn_friends` AS `tf` INNER JOIN `sys_profiles_conn_friends` AS `tff` ON `tf`.`content`=`tff`.`content` AND `tff`.`initiator`<>{profile_id} AND `tff`.`initiator` NOT IN (SELECT `content` FROM `sys_profiles_conn_friends` WHERE `initiator`={profile_id} AND `mutual`=''1'') AND `tff`.`mutual`=''1'' WHERE `tf`.`initiator`={profile_id} AND `tf`.`mutual`=''1'' GROUP BY `id`', 'a:1:{s:6:"points";i:2;}', 0.5, 1), (2, 1, 'shared_context', 'service', 'a:4:{s:6:"module";s:6:"system";s:6:"method";s:44:"get_friend_recommendations_by_shared_context";s:6:"params";a:3:{i:0;s:12:"{profile_id}";i:1;s:12:"{connection}";i:2;s:8:"{points}";}s:5:"class";s:27:"TemplServiceRecommendations";}', 'a:2:{s:6:"points";i:1;s:10:"connection";s:14:"bx_groups_fans";}', 0.2, 1), (3, 1, 'shared_location', 'service', 'a:4:{s:6:"module";s:6:"system";s:6:"method";s:45:"get_friend_recommendations_by_shared_location";s:6:"params";a:3:{i:0;s:12:"{profile_id}";i:1;s:8:"{radius}";i:2;s:8:"{points}";}s:5:"class";s:27:"TemplServiceRecommendations";}', 'a:2:{s:6:"radius";i:10;s:6:"points";i:1;}', 0.2, 1), (4, 1, 'last_active', 'sql', 'SELECT `tp`.`id` AS `id`, {points} AS `value` FROM `sys_profiles` AS `tp` INNER JOIN `sys_accounts` AS `ta` ON `tp`.`account_id`=`ta`.`id` LEFT JOIN `sys_sessions` AS `ts` ON `tp`.`account_id`=`ts`.`user_id` WHERE `tp`.`id`<>{profile_id} AND `tp`.`id` NOT IN (SELECT `content` FROM `sys_profiles_conn_friends` WHERE `initiator`={profile_id} AND `mutual`=''1'') AND `tp`.`type` IN (''bx_persons'', ''bx_organizations'') ORDER BY `ts`.`date` DESC, `ta`.`logged` DESC, {order_by}', 'a:1:{s:6:"points";i:0;}', 0.1, 1), (5, 2, 'mutual_subscriptions', 'sql', 'SELECT `tff`.`content` AS `id`, SUM({points}) AS `value` FROM `sys_profiles_conn_subscriptions` AS `tf` INNER JOIN `sys_profiles_conn_subscriptions` AS `tff` ON `tf`.`content`=`tff`.`initiator` AND `tff`.`content`<>{profile_id} AND `tff`.`content` NOT IN (SELECT `content` FROM `sys_profiles_conn_subscriptions` WHERE `initiator`={profile_id}) WHERE `tf`.`initiator`={profile_id} GROUP BY `id`', 'a:1:{s:6:"points";i:2;}', 0.5, 1), (6, 2, 'shared_context', 'service', 'a:4:{s:6:"module";s:6:"system";s:6:"method";s:50:"get_subscription_recommendations_by_shared_context";s:6:"params";a:3:{i:0;s:12:"{profile_id}";i:1;s:12:"{connection}";i:2;s:8:"{points}";}s:5:"class";s:27:"TemplServiceRecommendations";}', 'a:2:{s:6:"points";i:1;s:10:"connection";s:14:"bx_groups_fans";}', 0.5, 1);
-- -- Table structure for table `sys_statistics` --
CREATE TABLE `sys_statistics` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `module` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `link` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `icon` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `query` text COLLATE utf8mb4_unicode_ci NOT NULL, `order` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=3 ;
-- -- Dumping data for table `sys_statistics` --
INSERT INTO `sys_statistics` VALUES (1, 'system', 'sys_accounts', '_sys_accounts', '', 'user', 'SELECT COUNT(*) FROM `sys_accounts` WHERE 1', 1), (2, 'bx_persons', 'bx_persons', '_bx_persons', 'page.php?i=persons-home', 'user col-blue3', 'SELECT COUNT(*) FROM `bx_persons_data` AS `td` LEFT JOIN `sys_profiles` AS `tp` ON `td`.`id` = `tp`.`content_id` AND `tp`.`type`=''bx_persons'' WHERE 1 AND `tp`.`status`=''active''', 2);
-- -- Table structure for table `sys_wiki_images_resized` --
CREATE TABLE `sys_wiki_images_resized` ( `id` int(11) NOT NULL AUTO_INCREMENT, `profile_id` int(10) unsigned NOT NULL, `remote_id` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL, `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `file_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `mime_type` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL, `ext` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL, `size` bigint(20) NOT NULL, `added` int(11) NOT NULL, `modified` int(11) NOT NULL, `private` int(11) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `remote_id` (`remote_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;