sYg8XL1Q

1DROP TABLE IF EXISTS `strings`;
2CREATE TABLE `strings` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `language` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `find` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `replace` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3ALTER TABLE users ADD `locale` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'en';
4ALTER TABLE users ADD `theme` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'default';
5DROP TABLE IF EXISTS `widgets`;
6CREATE TABLE `widgets` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `Title` longtext COLLATE utf8mb4_unicode_ci, `html` longtext COLLATE utf8mb4_unicode_ci, `javascript` longtext COLLATE utf8mb4_unicode_ci, `css` longtext COLLATE utf8mb4_unicode_ci, `php` longtext COLLATE utf8mb4_unicode_ci, `content` longtext COLLATE utf8mb4_unicode_ci, `order` int(11) DEFAULT NULL, `package` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
7INSERT INTO `widgets` VALUES (1,NULL,NULL,NULL,NULL,'namespace App;\r\n\r\necho \'<div class=\"row\">\';\r\n$colors = [\'aqua\', \'red\', \'green\', \'yellow\', \'orange\', \'blue\'];\r\n$i = 0;\r\n$showonindex = Objects::where(\'showonindex\', \'1\')->get();\r\nforeach($showonindex as $data) {\r\n $index[\'count\'] = Store::where(\'slug\', $data->slug)->count();\r\n $index[\'url\'] = \'/admin/store/\'.$data->id;\r\n $index[\'title\'] = $data->title;\r\n $index[\'icon\'] = $data->icon;\r\n echo \'<div class=\"col-lg-3 col-xs-6\"><div class=\"small-box bg-\'.$colors[$i].\'\">\';\r\n echo \'<div class=\"inner\">\';\r\n echo \'<h3 class=\"elip\">\'.$index[\'count\'].\'</h3>\';\r\n echo \'<h3 class=\"elip\">\'.__($index[\'title\']).\'</h3>\';\r\n echo \'</div>\';\r\n echo \'<div class=\"icon\"><i class=\"fa fas \'.$index[\'icon\'].\'\"></i></div>\';\r\n echo \'<a href=\"\'.$index[\'url\'].\'\" class=\"small-box-footer\">More info <i class=\"fa fa-arrow-circle-right\"></i></a>\';\r\n echo \'</div></div>\';\r\n $i++;\r\n if($i >= sizeof($colors))\r\n $i = 0;\r\n}\r\n\r\n\r\necho \'<div class=\"col-lg-3 col-xs-6\"><div class=\"small-box bg-\'.$colors[$i++].\'\">\';\r\necho \'<div class=\"inner\">\';\r\necho \'<h3 class=\"elip\">\'.User::count().\'</h3>\';\r\necho \'<h3 class=\"elip\">\'.__(\'Users\').\'</h3>\';\r\necho \'</div>\';\r\necho \'<div class=\"icon\"><i class=\"fa fas fa-users\"></i></div>\';\r\necho \'<a href=\"/admin/users\" class=\"small-box-footer\">More info <i class=\"fa fa-arrow-circle-right\"></i></a>\';\r\necho \'</div></div>\';\r\n$i++;\r\nif($i >= sizeof($colors))\r\n $i = 0;\r\n\r\nif($settings->loglast == 1) {\r\n $cap = \\Carbon\\Carbon::now()->subMinute();\r\n $data[\'online\'] = User::where(\'last\', \'>\', $cap)->count();\r\n echo \'<div class=\"col-lg-3 col-xs-6\"><div class=\"small-box bg-\'.$colors[$i++].\'\">\';\r\n echo \'<div class=\"inner\">\';\r\n echo \'<h3 class=\"elip\">\'.$data[\'online\'].\'</h3>\';\r\n echo \'<h3 class=\"elip\">\'.__(\'Logged in\').\'</h3>\';\r\n echo \'</div>\';\r\n echo \'<div class=\"icon\"><i class=\"fa fas fa-plug\"></i></div>\';\r\n echo \'<a href=\"/admin/users?online=1\" class=\"small-box-footer\">More info <i class=\"fa fa-arrow-circle-right\"></i></a>\';\r\n echo \'</div></div>\';\r\n}\r\necho \'</div>\';',NULL,0,NULL,'2019-08-05 04:06:25','2019-08-05 09:40:27');
8INSERT INTO `menu` (`title`,`path`,`name`,`order`,`category`,`auth`,`icon`,`created_at`,`updated_at`) VALUES ('Widgets','/admin/widgets','widgets',1,'admin',2,'fa-columns','2019-07-30 22:55:45','2019-07-30 22:55:45');
9DROP TABLE IF EXISTS `widgets`;
10CREATE TABLE `widgets` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `Title` longtext COLLATE utf8mb4_unicode_ci, `html` longtext COLLATE utf8mb4_unicode_ci, `javascript` longtext COLLATE utf8mb4_unicode_ci, `css` longtext COLLATE utf8mb4_unicode_ci, `php` longtext COLLATE utf8mb4_unicode_ci, `content` longtext COLLATE utf8mb4_unicode_ci, `order` int(11) DEFAULT NULL, `package` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
11INSERT INTO `widgets` VALUES (1,NULL,NULL,NULL,'.widget-1 {\r\n cursor: pointer;\r\n}\r\n.col-xs-6 .fa {\r\n color: unset !important;\r\n}','namespace App;\r\n\r\necho \'<div class=\"row\">\';\r\n$colors = [\'aqua\', \'red\', \'green\', \'yellow\', \'orange\', \'blue\'];\r\n$i = 0;\r\n$showonindex = Objects::where(\'showonindex\', \'1\')->get();\r\nforeach($showonindex as $data) {\r\n $index[\'count\'] = Store::where(\'slug\', $data->slug)->count();\r\n $index[\'url\'] = \'/admin/store/\'.$data->id;\r\n $index[\'title\'] = $data->title;\r\n $index[\'icon\'] = $data->icon;\r\n echo \'<div class=\"col-lg-3 col-xs-6 widget-1\" onclick=\"window.location=\\\'\'.$index[\'url\'].\'\\\'\"><div class=\"small-box bg-\'.$colors[$i].\'\">\';\r\n echo \'<div class=\"inner\">\';\r\n echo \'<h3 class=\"elip\">\'.$index[\'count\'].\'</h3>\';\r\n echo \'<h3 class=\"elip\">\'.__($index[\'title\']).\'</h3>\';\r\n echo \'</div>\';\r\n echo \'<div class=\"icon\"><i class=\"fa fas \'.$index[\'icon\'].\'\"></i></div>\';\r\n echo \'<a href=\"\'.$index[\'url\'].\'\" class=\"small-box-footer\">More info <i class=\"fa fa-arrow-circle-right\"></i></a>\';\r\n echo \'</div></div>\';\r\n $i++;\r\n if($i >= sizeof($colors))\r\n $i = 0;\r\n}\r\n\r\n\r\necho \'<div class=\"col-lg-3 col-xs-6 widget-1\" onclick=\"window.location=\\\'/admin/users\\\'\"><div class=\"small-box bg-\'.$colors[$i++].\'\">\';\r\necho \'<div class=\"inner\">\';\r\necho \'<h3 class=\"elip\">\'.User::count().\'</h3>\';\r\necho \'<h3 class=\"elip\">\'.__(\'Users\').\'</h3>\';\r\necho \'</div>\';\r\necho \'<div class=\"icon\"><i class=\"fa fas fa-users\"></i></div>\';\r\necho \'<a href=\"/admin/users\" class=\"small-box-footer\">More info <i class=\"fa fa-arrow-circle-right\"></i></a>\';\r\necho \'</div></div>\';\r\n$i++;\r\nif($i >= sizeof($colors))\r\n $i = 0;\r\n\r\nif($settings->loglast == 1) {\r\n $cap = \\Carbon\\Carbon::now()->subMinute();\r\n $data[\'online\'] = User::where(\'last\', \'>\', $cap)->count();\r\n echo \'<div class=\"col-lg-3 col-xs-6 widget-1\" onclick=\"window.location=\\\'/admin/users?online=1\\\'\"><div class=\"small-box bg-\'.$colors[$i++].\'\">\';\r\n echo \'<div class=\"inner\">\';\r\n echo \'<h3 class=\"elip\">\'.$data[\'online\'].\'</h3>\';\r\n echo \'<h3 class=\"elip\">\'.__(\'Logged in\').\'</h3>\';\r\n echo \'</div>\';\r\n echo \'<div class=\"icon\"><i class=\"fa fas fa-plug\"></i></div>\';\r\n echo \'<a href=\"/admin/users?online=1\" class=\"small-box-footer\">More info <i class=\"fa fa-arrow-circle-right\"></i></a>\';\r\n echo \'</div></div>\';\r\n}\r\necho \'</div>\';',NULL,0,NULL,'2019-08-05 00:06:25','2019-08-07 21:04:33');
12ALTER TABLE `fields` ADD COLUMN `html` longtext;
13ALTER TABLE `fields` ADD COLUMN `php` longtext;
14ALTER TABLE `fields` ADD COLUMN `css` longtext;
15ALTER TABLE `fields` ADD COLUMN `javascript` longtext;
16ALTER TABLE `fields` ADD COLUMN `package` VARCHAR(191);
17DROP TABLE IF EXISTS `widgets`;
18CREATE TABLE `widgets` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `Title` longtext COLLATE utf8mb4_unicode_ci, `html` longtext COLLATE utf8mb4_unicode_ci, `javascript` longtext COLLATE utf8mb4_unicode_ci, `css` longtext COLLATE utf8mb4_unicode_ci, `php` longtext COLLATE utf8mb4_unicode_ci, `content` longtext COLLATE utf8mb4_unicode_ci, `order` int(11) DEFAULT NULL, `package` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
19INSERT INTO `widgets` VALUES (1,NULL,NULL,NULL,'.widget-1 {\r\n cursor: pointer;\r\n}\r\n.col-xs-6 .fa {\r\n color: unset !important;\r\n}','namespace App;\r\n\r\necho \'<div class=\"row\">\';\r\n$colors = [\'aqua\', \'red\', \'green\', \'yellow\', \'orange\', \'blue\'];\r\n$i = 0;\r\n$showonindex = Objects::where(\'showonindex\', \'1\')->get();\r\nforeach($showonindex as $data) {\r\n $index[\'count\'] = Store::where(\'slug\', $data->slug)->count();\r\n $index[\'url\'] = \'/admin/store/\'.$data->id;\r\n $index[\'title\'] = $data->title;\r\n $index[\'icon\'] = $data->icon;\r\n echo \'<div class=\"col-lg-3 col-xs-6 widget-1\" onclick=\"window.location=\\\'\'.$index[\'url\'].\'\\\'\"><div class=\"small-box bg-\'.$colors[$i].\'\">\';\r\n echo \'<div class=\"inner\">\';\r\n echo \'<h3 class=\"elip\">\'.$index[\'count\'].\'</h3>\';\r\n echo \'<h3 class=\"elip\">\'.__($index[\'title\']).\'</h3>\';\r\n echo \'</div>\';\r\n echo \'<div class=\"icon\"><i class=\"fa fas \'.$index[\'icon\'].\'\"></i></div>\';\r\n echo \'<a href=\"\'.$index[\'url\'].\'\" class=\"small-box-footer\">More info <i class=\"fa fa-arrow-circle-right\"></i></a>\';\r\n echo \'</div></div>\';\r\n $i++;\r\n if($i >= sizeof($colors))\r\n $i = 0;\r\n}\r\n\r\n\r\necho \'<div class=\"col-lg-3 col-xs-6 widget-1\" onclick=\"window.location=\\\'/admin/users\\\'\"><div class=\"small-box bg-\'.$colors[$i++].\'\">\';\r\necho \'<div class=\"inner\">\';\r\necho \'<h3 class=\"elip\">\'.User::count().\'</h3>\';\r\necho \'<h3 class=\"elip\">\'.__(\'Users\').\'</h3>\';\r\necho \'</div>\';\r\necho \'<div class=\"icon\"><i class=\"fa fas fa-users\"></i></div>\';\r\necho \'<a href=\"/admin/users\" class=\"small-box-footer\">More info <i class=\"fa fa-arrow-circle-right\"></i></a>\';\r\necho \'</div></div>\';\r\n$i++;\r\nif($i >= sizeof($colors))\r\n $i = 0;\r\n\r\nif($settings->loglast == 1) {\r\n $cap = \\Carbon\\Carbon::now()->subMinute();\r\n $data[\'online\'] = User::where(\'last\', \'>\', $cap)->count();\r\n echo \'<div class=\"col-lg-3 col-xs-6 widget-1\" onclick=\"window.location=\\\'/admin/users?online=1\\\'\"><div class=\"small-box bg-\'.$colors[$i++].\'\">\';\r\n echo \'<div class=\"inner\">\';\r\n echo \'<h3 class=\"elip\">\'.$data[\'online\'].\'</h3>\';\r\n echo \'<h3 class=\"elip\">\'.__(\'Logged in\').\'</h3>\';\r\n echo \'</div>\';\r\n echo \'<div class=\"icon\"><i class=\"fa fas fa-plug\"></i></div>\';\r\n echo \'<a href=\"/admin/users?online=1\" class=\"small-box-footer\">More info <i class=\"fa fa-arrow-circle-right\"></i></a>\';\r\n echo \'</div></div>\';\r\n}\r\necho \'</div>\';',NULL,0,NULL,'2019-08-04 22:06:25','2019-08-07 19:04:33'),(2,NULL,NULL,NULL,NULL,'namespace App;\r\n\r\n$data[\'ver\'] = config(\'settings\')->corever;\r\n$data[\'latest\'] = Update::getLatest();\r\n$data[\'islatest\'] = Update::isLatest();\r\n$data[\'current\'] = Update::getVer();\r\necho \'<div class=\"col-md-12\">\';\r\nif($data[\'islatest\'] == true) {\r\n echo \'<div class=\"box box-success\">\';\r\n echo \'<div class=\"box-header with-border\">\';\r\n echo \'<h3 class=\"box-title\">System Updates</h3>\';\r\n echo \'<div class=\"box-tools pull-\'.$antipull.\'>\';\r\n echo \'<button type=\"button\" class=\"btn btn-box-tool\" data-widget=\"collapse\"><i class=\"fa fa-minus\"></i></button>\';\r\n echo \'</div></div>\';\r\n echo \'<div class=\"box-body\" style=\"\">\';\r\n echo \'<div class=\"info-box col-md-12\">\r\n <span class=\"info-box-icon bg-green\"><i class=\"fa fa-check\"></i></span>\r\n <div class=\"info-box-content\">\r\n <span class=\"info-box-text\">\'.__(\'Your system is up to date\').\'</span>\r\n <span class=\"info-box-number\">\'.__(\'Version\').\': \'.$data[\'ver\'].\'</span>\r\n </div>\';\r\n echo \'<hr class=\"col-md-12\"/><ol class=\"col-md-12\">\';\r\n foreach($data[\'latest\']->comments as $comment) {\r\n echo \'<li>\'.$comment.\'</li>\';\r\n }\r\n echo \'</ol>\';\r\n echo \'</div>\';\r\n echo \'</div></div></div>\';\r\n\r\n} else {\r\n echo \'<div class=\"box box-warning\">\';\r\n echo \'<div class=\"box-header with-border\">\';\r\n echo \'<h3 class=\"box-title\">System Updates</h3>\';\r\n echo \'<div class=\"box-tools pull-\'.$antipull.\'>\';\r\n echo \'<button type=\"button\" class=\"btn btn-box-tool\" data-widget=\"collapse\"><i class=\"fa fa-minus\"></i></button>\';\r\n echo \'</div></div>\';\r\n echo \'<div class=\"box-body\" style=\"\">\';\r\n echo \'<div class=\"info-box col-md-12\">\r\n <span class=\"info-box-icon bg-red\"><i class=\"fa fa-warning\"></i></span>\r\n <div class=\"info-box-content\">\r\n <div class=\"col-md-12\">\r\n <span class=\"info-box-text\">\'.__(\'A new version was found\').\'</span>\r\n <span class=\"info-box-number\">\'.__(\'Current Version\').\': \'.$data[\'ver\'].\'</span>\r\n <span class=\"info-box-number\">\'.__(\'Latest Version\').\': \'.$data[\'latest\']->version.\'</span>\r\n </div>\r\n <div class=\"col-md-12\">\r\n <span class=\"info-box-text\">\r\n </span>\r\n </div>\r\n </div>\r\n </div>\r\n <form class=\"col-md-3\" style=\"display: grid;\" role=\"form\" method=\"post\" action=\"/admin/updates\" enctype=\"multipart/form-data\">\r\n <button type=\"submit\" class=\"btn btn-md btn-success\"><em class=\"fa fa-refresh\"></em> \'.__(\'Update\').\'</button>\r\n \'.csrf_field().\'\r\n </form>\';\r\n echo \'<hr class=\"col-md-12\"/><ol class=\"col-md-12\">\';\r\n foreach($data[\'latest\']->comments as $comment) {\r\n echo \'<li>\'.$comment.\'</li>\';\r\n }\r\n echo \'</ol>\';\r\n echo \'</div></div></div>\';\r\n}',NULL,2,NULL,'2019-08-07 22:29:16','2019-08-07 23:04:47');
20insert into settings (slug, value) values('memcache', '1');
21DROP TABLE IF EXISTS `routes`;
22CREATE TABLE `routes` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `route` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'get', `php` longtext COLLATE utf8mb4_unicode_ci, `package` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `routes_route_unique` (`route`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
23INSERT INTO `menu` (`title`, `path`, `main`, `name`, `order`, `category`, `auth`, `icon`) VALUES ('Routes','/admin/routes',NULL,'routes',1,'admin',3,'fa-link');
24INSERT INTO `menu` (`title`, `path`, `main`, `name`, `order`, `category`, `auth`, `icon`) VALUES ('File Settings','/admin/settings/files',23,'routes',1,'admin',3,'fa-circle');
25delete from menu where name = 'backups' or name='updates' or name='system' or name='logs';
26INSERT into menu (`id`, `title`, `path`, `main`, `name`, `order`, `category`, `auth`, `icon`) VALUES (999999, 'System','#',NULL,'system',2,'admin',2,'fa-robot');
27INSERT into menu (`title`, `path`, `main`, `name`, `order`, `category`, `auth`, `icon`) VALUES ('Logs','/admin/logs',999999,'logs',1,'admin',2,'fa-file-alt'),('Backups','/admin/backups',999999,'backups',1,'admin',2,'fa-file-archive'),('Updates','/admin/updates',999999,'updates',1,'admin',2,'fa-sync-alt');