-- MySQL dump 10.16 Distrib 10.2.10-MariaDB, for debian-linux-gnu (x86_64) -- -- Host: localhost Database: -- ------------------------------------------------------ -- Server version 10.2.10-MariaDB-10.2.10+maria~xenial-log /*!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 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Current Database: `iratus_forums` -- CREATE DATABASE /*!32312 IF NOT EXISTS*/ `iratus_forums` /*!40100 DEFAULT CHARACTER SET latin1 */; USE `iratus_forums`; -- -- Table structure for table `EWRporta2_articles` -- DROP TABLE IF EXISTS `EWRporta2_articles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `EWRporta2_articles` ( `thread_id` int(10) unsigned NOT NULL, `article_date` int(10) unsigned NOT NULL, `article_title` varchar(255) NOT NULL, `article_break` text NOT NULL, `article_excerpt` mediumtext NOT NULL, `article_icon` blob NOT NULL, `article_custom` int(1) unsigned NOT NULL, `article_options` blob NOT NULL, `article_exclude` int(1) unsigned NOT NULL, PRIMARY KEY (`thread_id`), KEY `article_date` (`article_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `EWRporta2_articles` -- LOCK TABLES `EWRporta2_articles` WRITE; /*!40000 ALTER TABLE `EWRporta2_articles` DISABLE KEYS */; INSERT INTO `EWRporta2_articles` VALUES (1,1510723680,'','','','a:1:{s:4:\"type\";s:7:\"disable\";}',0,'a:0:{}',0),(34,1511421240,'','','','a:1:{s:4:\"type\";s:0:\"\";}',0,'a:0:{}',0),(47,1511833140,'','','','a:1:{s:4:\"type\";s:0:\"\";}',0,'a:0:{}',0),(95,1512625620,'','','','a:1:{s:4:\"type\";s:0:\"\";}',0,'a:0:{}',0); /*!40000 ALTER TABLE `EWRporta2_articles` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `EWRporta2_authors` -- DROP TABLE IF EXISTS `EWRporta2_authors`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `EWRporta2_authors` ( `user_id` int(10) unsigned NOT NULL, `author_time` int(10) unsigned NOT NULL, `author_name` varchar(100) NOT NULL, `author_byline` text NOT NULL, `author_status` varchar(255) NOT NULL, `author_order` int(10) unsigned NOT NULL, PRIMARY KEY (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `EWRporta2_authors` -- LOCK TABLES `EWRporta2_authors` WRITE; /*!40000 ALTER TABLE `EWRporta2_authors` DISABLE KEYS */; /*!40000 ALTER TABLE `EWRporta2_authors` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `EWRporta2_categories` -- DROP TABLE IF EXISTS `EWRporta2_categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `EWRporta2_categories` ( `style_id` int(10) unsigned NOT NULL, `category_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `category_name` varchar(255) NOT NULL, `category_desc` text NOT NULL, `category_type` enum('category','tag') NOT NULL, PRIMARY KEY (`category_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `EWRporta2_categories` -- LOCK TABLES `EWRporta2_categories` WRITE; /*!40000 ALTER TABLE `EWRporta2_categories` DISABLE KEYS */; /*!40000 ALTER TABLE `EWRporta2_categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `EWRporta2_catlinks` -- DROP TABLE IF EXISTS `EWRporta2_catlinks`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `EWRporta2_catlinks` ( `thread_id` int(10) unsigned NOT NULL, `user_id` int(10) unsigned NOT NULL, `category_id` int(10) unsigned NOT NULL, `catlink_id` int(10) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`catlink_id`), KEY `thread_id` (`thread_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `EWRporta2_catlinks` -- LOCK TABLES `EWRporta2_catlinks` WRITE; /*!40000 ALTER TABLE `EWRporta2_catlinks` DISABLE KEYS */; /*!40000 ALTER TABLE `EWRporta2_catlinks` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `EWRporta2_features` -- DROP TABLE IF EXISTS `EWRporta2_features`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `EWRporta2_features` ( `thread_id` int(10) unsigned NOT NULL, `feature_date` int(10) unsigned NOT NULL, `feature_time` int(10) unsigned NOT NULL, `feature_title` varchar(255) NOT NULL, `feature_excerpt` text NOT NULL, `feature_custom` int(1) unsigned NOT NULL, `feature_exclude` int(1) unsigned NOT NULL, PRIMARY KEY (`thread_id`), KEY `feature_date` (`feature_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `EWRporta2_features` -- LOCK TABLES `EWRporta2_features` WRITE; /*!40000 ALTER TABLE `EWRporta2_features` DISABLE KEYS */; /*!40000 ALTER TABLE `EWRporta2_features` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `EWRporta2_layouts` -- DROP TABLE IF EXISTS `EWRporta2_layouts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `EWRporta2_layouts` ( `layout_id` varchar(100) NOT NULL, `layout_title` varchar(100) NOT NULL, `layout_template` varchar(100) NOT NULL, `layout_eval` varchar(100) NOT NULL, `layout_priority` int(10) unsigned NOT NULL, `layout_sidebar` int(1) unsigned NOT NULL, `layout_protected` int(1) unsigned NOT NULL, `active` int(1) unsigned NOT NULL, PRIMARY KEY (`layout_id`), KEY `layout_template` (`layout_template`), KEY `layout_priority` (`layout_priority`), KEY `layout_title` (`layout_title`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `EWRporta2_layouts` -- LOCK TABLES `EWRporta2_layouts` WRITE; /*!40000 ALTER TABLE `EWRporta2_layouts` DISABLE KEYS */; INSERT INTO `EWRporta2_layouts` VALUES ('article_list','Article List','EWRporta2_ArticleList','',100,0,1,1); /*!40000 ALTER TABLE `EWRporta2_layouts` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `EWRporta2_options` -- DROP TABLE IF EXISTS `EWRporta2_options`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `EWRporta2_options` ( `widget_id` varchar(100) NOT NULL, `option_id` varchar(100) NOT NULL, `option_value` blob NOT NULL, `default_value` blob NOT NULL, `title` varchar(100) NOT NULL, `explain` text NOT NULL, `edit_format` enum('textbox','spinbox','onoff','radio','select','checkbox','template','callback') NOT NULL, `edit_format_params` text NOT NULL, `data_type` enum('string','integer','numeric','array','boolean','positive_integer','unsigned_integer','unsigned_numeric') NOT NULL, `sub_options` text NOT NULL, `validation_class` varchar(75) NOT NULL, `validation_method` varchar(75) NOT NULL, `display_order` int(10) unsigned NOT NULL, PRIMARY KEY (`option_id`), KEY `widget_id` (`widget_id`), KEY `display_order` (`display_order`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `EWRporta2_options` -- LOCK TABLES `EWRporta2_options` WRITE; /*!40000 ALTER TABLE `EWRporta2_options` DISABLE KEYS */; INSERT INTO `EWRporta2_options` VALUES ('StatusUpdates','statusupdates_limit','5','5','Limit','The maximum number of status updates to display.','spinbox','min=1','unsigned_integer','','','',1),('Threads','threads_cutoff','7','7','Age Cutoff','Limits the search to only display threads updated within X days.','spinbox','min=1','unsigned_integer','','','',2),('Threads','threads_limit','5','5','Limit','The maximum number of threads to display on the widget.','spinbox','min=1','unsigned_integer','','','',1),('Threads','threads_source','a:1:{i:0;s:1:\"0\";}','a:1:{i:0;s:1:\"0\";}','Source Forums','Only selected forums will be searched. (unspecify to select all)','callback','EWRporta2_Option_ForumChooser::renderOption','array','*','','',3),('UsersOnline','usersonline_staff','1','1','Show Staff Online Now','','onoff','','boolean','','','',1); /*!40000 ALTER TABLE `EWRporta2_options` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `EWRporta2_settings` -- DROP TABLE IF EXISTS `EWRporta2_settings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `EWRporta2_settings` ( `user_id` int(10) unsigned NOT NULL, `setting_filter` mediumblob NOT NULL, `setting_arrange` mediumblob NOT NULL, `setting_options` mediumblob NOT NULL, PRIMARY KEY (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `EWRporta2_settings` -- LOCK TABLES `EWRporta2_settings` WRITE; /*!40000 ALTER TABLE `EWRporta2_settings` DISABLE KEYS */; /*!40000 ALTER TABLE `EWRporta2_settings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `EWRporta2_widgets` -- DROP TABLE IF EXISTS `EWRporta2_widgets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `EWRporta2_widgets` ( `widget_id` varchar(100) NOT NULL, `widget_title` varchar(100) NOT NULL, `widget_desc` text NOT NULL, `widget_string` varchar(30) NOT NULL, `widget_version` int(10) unsigned NOT NULL, `widget_url` varchar(100) NOT NULL, `widget_install_class` varchar(75) NOT NULL, `widget_install_method` varchar(75) NOT NULL, `widget_uninstall_class` varchar(75) NOT NULL, `widget_uninstall_method` varchar(75) NOT NULL, `widget_values` mediumblob NOT NULL, `locked` int(1) unsigned NOT NULL, `display` enum('show','hide') NOT NULL, `groups` varchar(255) NOT NULL, `ctime` varchar(100) NOT NULL, `cdate` int(10) unsigned NOT NULL, `cache` mediumblob NOT NULL, `active` int(1) unsigned NOT NULL, PRIMARY KEY (`widget_id`), KEY `widget_title` (`widget_title`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `EWRporta2_widgets` -- LOCK TABLES `EWRporta2_widgets` WRITE; /*!40000 ALTER TABLE `EWRporta2_widgets` DISABLE KEYS */; INSERT INTO `EWRporta2_widgets` VALUES ('ForumStats','Forum Statistics','Displays basic statistics about the forum','1',1,'','','','','','a:0:{}',0,'show','','',0,'a:0:{}',1),('SharePage','Share Page','Displays social media widgets to share the current page','1',1,'','','','','','a:0:{}',0,'show','','',0,'a:0:{}',1),('StatusUpdates','Status Updates','Displays the most recent status updates','1',1,'','','','','','a:1:{s:19:\"statusupdates_limit\";s:1:\"5\";}',0,'show','','',0,'a:0:{}',1),('Threads','Threads Recent','Displays a list of most recently active threads','1',1,'','','','','','a:3:{s:13:\"threads_limit\";s:1:\"5\";s:14:\"threads_cutoff\";s:1:\"7\";s:14:\"threads_source\";a:1:{i:0;s:1:\"0\";}}',0,'show','','',0,'a:0:{}',1),('UsersOnline','Users Online','Displays the current visitors list','1',1,'','','','','','a:1:{s:17:\"usersonline_staff\";s:1:\"1\";}',0,'show','','',0,'a:0:{}',1); /*!40000 ALTER TABLE `EWRporta2_widgets` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `EWRporta2_widlinks` -- DROP TABLE IF EXISTS `EWRporta2_widlinks`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `EWRporta2_widlinks` ( `layout_id` varchar(100) NOT NULL, `widget_id` varchar(100) NOT NULL, `widopt_id` int(10) unsigned NOT NULL, `widlink_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `widlink_title` varchar(100) NOT NULL, `widlink_position` enum('sidebar','header','footer','left','above','below','b-left','b-right','disabled') NOT NULL, `widlink_order` int(10) unsigned NOT NULL, PRIMARY KEY (`widlink_id`), KEY `layout_id` (`layout_id`), KEY `widget_id` (`widget_id`), KEY `widlink_order` (`widlink_order`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `EWRporta2_widlinks` -- LOCK TABLES `EWRporta2_widlinks` WRITE; /*!40000 ALTER TABLE `EWRporta2_widlinks` DISABLE KEYS */; INSERT INTO `EWRporta2_widlinks` VALUES ('article_list','Threads',0,1,'Recent Threads','sidebar',2),('article_list','StatusUpdates',0,2,'New Profile Posts','sidebar',3),('article_list','UsersOnline',0,3,'Members Online Now','sidebar',1),('article_list','ForumStats',0,4,'Forum Statistics','sidebar',4),('article_list','SharePage',0,5,'Share This Page','sidebar',5); /*!40000 ALTER TABLE `EWRporta2_widlinks` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `EWRporta2_widopts` -- DROP TABLE IF EXISTS `EWRporta2_widopts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `EWRporta2_widopts` ( `widget_id` varchar(100) NOT NULL, `widopt_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `widopt_title` varchar(100) NOT NULL, `widopt_values` mediumblob NOT NULL, `locked` int(1) unsigned NOT NULL, `display` enum('show','hide') NOT NULL, `groups` varchar(255) NOT NULL, `ctime` varchar(100) NOT NULL, `cdate` int(10) unsigned NOT NULL, `cache` mediumblob NOT NULL, PRIMARY KEY (`widopt_id`), KEY `widget_id` (`widget_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `EWRporta2_widopts` -- LOCK TABLES `EWRporta2_widopts` WRITE; /*!40000 ALTER TABLE `EWRporta2_widopts` DISABLE KEYS */; /*!40000 ALTER TABLE `EWRporta2_widopts` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nat_options` -- DROP TABLE IF EXISTS `nat_options`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `nat_options` ( `node_id` int(10) unsigned NOT NULL, `nat_display_tab` tinyint(3) unsigned NOT NULL, `nat_display_tabperms` tinyint(3) unsigned NOT NULL, `nat_tabtitle` varchar(50) NOT NULL, `nat_display_order` int(10) unsigned NOT NULL, `nat_position` enum('home','middle','end') NOT NULL, `nat_childlinks` tinyint(3) unsigned NOT NULL, `nat_childlinksperms` tinyint(3) unsigned NOT NULL, `nat_unreadcount` tinyint(3) unsigned NOT NULL, `nat_markread` tinyint(3) unsigned NOT NULL, `nat_linkstemplate` varchar(50) NOT NULL, `nat_popup` tinyint(3) unsigned NOT NULL, `nat_popup_columns` tinyint(3) unsigned NOT NULL, `nat_tabid` varchar(50) NOT NULL, `nat_newwindow` tinyint(3) unsigned NOT NULL, `nat_childnodes` text NOT NULL, `nat_firstchildnodes` mediumblob NOT NULL, UNIQUE KEY `node_id` (`node_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='NodesAsTabs addon'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `nat_options` -- LOCK TABLES `nat_options` WRITE; /*!40000 ALTER TABLE `nat_options` DISABLE KEYS */; INSERT INTO `nat_options` VALUES (1,0,0,'',1,'end',0,0,0,0,'',1,0,'',0,'',''),(2,0,0,'',1,'end',0,0,0,0,'',1,0,'',0,'',''),(3,1,0,'',1,'middle',0,0,0,0,'',1,0,'',1,'',''),(4,1,0,'',1,'middle',0,0,0,0,'',1,0,'',0,'',''),(5,0,0,'',1,'end',0,0,0,0,'',1,0,'',0,'',''),(6,0,0,'',1,'end',0,0,0,0,'',1,0,'',0,'',''),(7,0,0,'',1,'end',0,0,0,0,'',1,0,'',0,'',''),(8,0,0,'',1,'end',0,0,0,0,'',1,0,'',0,'',''),(9,0,0,'',1,'end',0,0,0,0,'',1,0,'',0,'',''),(10,0,0,'',1,'end',0,0,0,0,'',1,0,'',0,'',''),(11,0,0,'',1,'end',0,0,0,0,'',1,0,'',0,'',''),(12,0,0,'',1,'end',0,0,0,0,'',1,0,'',0,'',''),(13,0,0,'',1,'end',0,0,0,0,'',1,0,'',0,'',''),(14,0,0,'',1,'end',0,0,0,0,'',1,0,'',0,'',''),(15,0,0,'',1,'end',0,0,0,0,'',1,0,'',0,'',''),(16,0,0,'',1,'end',0,0,0,0,'',1,0,'',0,'',''),(17,0,0,'',1,'end',0,0,0,0,'',1,0,'',0,'',''),(18,0,0,'',1,'end',0,0,0,0,'',1,0,'',0,'',''),(19,0,0,'',1,'end',0,0,0,0,'',1,0,'',0,'',''),(20,0,0,'',1,'end',0,0,0,0,'',1,0,'',0,'',''); /*!40000 ALTER TABLE `nat_options` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `uix_node_fields` -- DROP TABLE IF EXISTS `uix_node_fields`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `uix_node_fields` ( `node_id` int(10) unsigned NOT NULL, `uix_node_icons` mediumblob NOT NULL, `uix_styling` mediumblob NOT NULL, `collapsed` tinyint(1) unsigned NOT NULL DEFAULT 0, `inheritClass` tinyint(1) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`node_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `uix_node_fields` -- LOCK TABLES `uix_node_fields` WRITE; /*!40000 ALTER TABLE `uix_node_fields` DISABLE KEYS */; /*!40000 ALTER TABLE `uix_node_fields` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `uix_node_layout` -- DROP TABLE IF EXISTS `uix_node_layout`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `uix_node_layout` ( `node_id` int(10) unsigned NOT NULL, `separator_type` varchar(50) NOT NULL DEFAULT 'grid', `separator_max_width` int(10) NOT NULL DEFAULT 0, `layout_data` mediumblob NOT NULL, PRIMARY KEY (`node_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `uix_node_layout` -- LOCK TABLES `uix_node_layout` WRITE; /*!40000 ALTER TABLE `uix_node_layout` DISABLE KEYS */; INSERT INTO `uix_node_layout` VALUES (0,'grid',0,'{\"maximum_columns\":{\"value\":\"6\"},\"minimum_column_width\":{\"value\":\"330\"},\"fill_last_row\":{\"value\":\"0\"},\"column_widths\":{\"value\":\"0\"},\"custom_column_widths\":{\"count\":\"\",\"layouts\":{\"1\":{\"1\":\"\"},\"2\":{\"1\":\"\",\"2\":\"\"},\"3\":{\"1\":\"\",\"2\":\"\",\"3\":\"\"},\"4\":{\"1\":\"\",\"2\":\"\",\"3\":\"\",\"4\":\"\"},\"5\":{\"1\":\"\",\"2\":\"\",\"3\":\"\",\"4\":\"\",\"5\":\"\"},\"6\":{\"1\":\"\",\"2\":\"\",\"3\":\"\",\"4\":\"\",\"5\":\"\",\"6\":\"\"}}}}'),(10240,'grid',0,'{\"maximum_columns\":{\"value\":\"1\"},\"minimum_column_width\":{\"value\":\"\"},\"fill_last_row\":{\"value\":\"0\"},\"column_widths\":{\"value\":\"0\"},\"custom_column_widths\":{\"count\":\"\",\"layouts\":{\"1\":{\"1\":\"\"}}}}'); /*!40000 ALTER TABLE `uix_node_layout` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `xf_addon` -- DROP TABLE IF EXISTS `xf_addon`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `xf_addon` ( `addon_id` varbinary(25) NOT NULL, `title` varchar(75) NOT NULL, `version_string` varchar(30) NOT NULL DEFAULT '', `version_id` int(10) unsigned NOT NULL DEFAULT 0, `url` varchar(100) NOT NULL, `install_callback_class` varchar(75) NOT NULL DEFAULT '', `install_callback_method` varchar(75) NOT NULL DEFAULT '', `uninstall_callback_class` varchar(75) NOT NULL DEFAULT '', `uninstall_callback_method` varchar(75) NOT NULL DEFAULT '', `active` tinyint(3) unsigned NOT NULL, PRIMARY KEY (`addon_id`), KEY `title` (`title`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `xf_addon` -- LOCK TABLES `xf_addon` WRITE; /*!40000 ALTER TABLE `xf_addon` DISABLE KEYS */; INSERT INTO `xf_addon` VALUES ('EWRporta2','XenPorta','1.1.0a',10,'','EWRporta2_Install','installCode','EWRporta2_Install','uninstallCode',1),('NodesAsTabs','Nodes As Tabs','1.5.1',105010,'http://xenforo.com/community/resources/nodes-as-tabs.9/','NodesAsTabs_Install','install','NodesAsTabs_Install','uninstall',1),('XenStaff','Staff Page','1.1.2',3,'','','','','',1),('uix','[AD] UI.X','1.0.12b',1001272,'https://www.audentio.com','Audentio_UIX_Listener_Install','run','Audentio_UIX_Listener_Uninstall','run',1); /*!40000 ALTER TABLE `xf_addon` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `xf_admin` -- DROP TABLE IF EXISTS `xf_admin`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `xf_admin` ( `user_id` int(10) unsigned NOT NULL, `extra_user_group_ids` varbinary(255) NOT NULL, `last_login` int(10) unsigned NOT NULL DEFAULT 0, `permission_cache` mediumblob DEFAULT NULL, `admin_language_id` int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `xf_admin` -- LOCK TABLES `xf_admin` WRITE; /*!40000 ALTER TABLE `xf_admin` DISABLE KEYS */; INSERT INTO `xf_admin` VALUES (1,'3',0,'a:25:{s:5:\"addOn\";b:1;s:10:\"attachment\";b:1;s:3:\"ban\";b:1;s:12:\"bbCodeSmilie\";b:1;s:4:\"cron\";b:1;s:3:\"dev\";b:1;s:4:\"help\";b:1;s:6:\"import\";b:1;s:8:\"language\";b:1;s:4:\"node\";b:1;s:6:\"notice\";b:1;s:6:\"option\";b:1;s:12:\"rebuildCache\";b:1;s:5:\"style\";b:1;s:3:\"tag\";b:1;s:6:\"thread\";b:1;s:6:\"trophy\";b:1;s:14:\"upgradeXenForo\";b:1;s:4:\"user\";b:1;s:9:\"userField\";b:1;s:9:\"userGroup\";b:1;s:11:\"userUpgrade\";b:1;s:8:\"viewLogs\";b:1;s:14:\"viewStatistics\";b:1;s:7:\"warning\";b:1;}',0),(3,'',0,'a:26:{s:6:\"option\";b:1;s:4:\"help\";b:1;s:12:\"bbCodeSmilie\";b:1;s:5:\"addOn\";b:1;s:4:\"node\";b:1;s:6:\"thread\";b:1;s:10:\"attachment\";b:1;s:3:\"tag\";b:1;s:6:\"notice\";b:1;s:4:\"user\";b:1;s:9:\"userField\";b:1;s:6:\"trophy\";b:1;s:7:\"warning\";b:1;s:3:\"ban\";b:1;s:9:\"userGroup\";b:1;s:11:\"userUpgrade\";b:1;s:5:\"style\";b:1;s:8:\"language\";b:1;s:4:\"cron\";b:1;s:12:\"rebuildCache\";b:1;s:14:\"viewStatistics\";b:1;s:8:\"viewLogs\";b:1;s:6:\"import\";b:1;s:3:\"dev\";b:1;s:14:\"upgradeXenForo\";b:1;s:10:\"uix_styles\";b:1;}',0); /*!40000 ALTER TABLE `xf_admin` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `xf_admin_log` -- DROP TABLE IF EXISTS `xf_admin_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `xf_admin_log` ( `admin_log_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(10) unsigned NOT NULL, `ip_address` varbinary(16) NOT NULL DEFAULT '', `request_date` int(10) unsigned NOT NULL, `request_url` text NOT NULL, `request_data` mediumblob NOT NULL, PRIMARY KEY (`admin_log_id`), KEY `request_date` (`request_date`), KEY `user_id_request_date` (`user_id`,`request_date`) ) ENGINE=InnoDB AUTO_INCREMENT=313 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `xf_admin_log` -- LOCK TABLES `xf_admin_log` WRITE; /*!40000 ALTER TABLE `xf_admin_log` DISABLE KEYS */; INSERT INTO `xf_admin_log` VALUES (1,1,'?D??',1510723127,'add-ons/install','{\"server_file\":\"\",\"_xfConfirm\":\"1\"}'),(2,1,'?D??',1510723138,'tools/run-deferred','{\"redirect\":\"https:\\/\\/iratuspvp.com\\/admin.php?add-ons\\/\",\"execute\":\"1\"}'),(3,1,'?D??',1510723162,'add-ons/install','{\"server_file\":\"\",\"_xfConfirm\":\"1\"}'),(4,1,'?D??',1510723175,'tools/run-deferred','{\"redirect\":\"https:\\/\\/iratuspvp.com\\/admin.php?add-ons\\/\",\"execute\":\"1\"}'),(5,1,'?D??',1510723189,'options/save/EWRporta2','{\"options\":{\"EWRporta2_classes\":{\"EWRporta2_ViewPublic_ArticleList\":\"1\",\"XenForo_ViewPublic_Forum_List\":\"1\"},\"EWRporta2_views\":\"\",\"EWRporta2_breakout\":\"1\",\"EWRporta2_articles_limit\":\"10\",\"EWRporta2_articles_excerpt\":\"0\",\"EWRporta2_articles_dateblock\":\"1\",\"EWRporta2_features_limit\":\"10\",\"EWRporta2_features_excerpt\":\"500\",\"EWRporta2_features_height\":\"400\",\"EWRporta2_features_mode\":\"horizontal\",\"EWRporta2_features_speed\":\"1000\",\"EWRporta2_features_auto\":\"5000\",\"EWRporta2_features_relocate\":\"\",\"EWRporta2_feature_width\":\"1000\",\"EWRporta2_feature_height\":\"400\",\"EWRporta2_promote_timezone\":\"0\",\"EWRporta2_promote_iconsearch\":\"1\",\"EWRporta2_promote_autoforums\":[\"0\"],\"EWRporta2_promote_disqus\":\"\",\"EWRporta2_promote_facebook\":\"0\"},\"options_listed\":[\"EWRporta2_classes\",\"EWRporta2_views\",\"EWRporta2_style\",\"EWRporta2_breakout\",\"EWRporta2_articles_limit\",\"EWRporta2_articles_excerpt\",\"EWRporta2_articles_dateblock\",\"EWRporta2_articles_headerblock\",\"EWRporta2_articles_stripnl\",\"EWRporta2_articles_exclude\",\"EWRporta2_articles_permissions\",\"EWRporta2_articles_masonry\",\"EWRporta2_articles_scroll\",\"EWRporta2_features_limit\",\"EWRporta2_features_sections\",\"EWRporta2_features_excerpt\",\"EWRporta2_features_height\",\"EWRporta2_features_mode\",\"EWRporta2_features_speed\",\"EWRporta2_features_auto\",\"EWRporta2_features_options\",\"EWRporta2_features_relocate\",\"EWRporta2_feature_width\",\"EWRporta2_feature_height\",\"EWRporta2_promote_timezone\",\"EWRporta2_promote_24hour\",\"EWRporta2_promote_wysiwyg\",\"EWRporta2_promote_iconsearch\",\"EWRporta2_promote_image\",\"EWRporta2_promote_autoforums\",\"EWRporta2_promote_disqus\",\"EWRporta2_promote_facebook\",\"EWRporta2_promote_defaults\"]}'),(6,1,'?D??',1510723200,'add-ons/install','{\"server_file\":\"\",\"_xfConfirm\":\"1\"}'),(7,1,'?D??',1510723205,'porta2/layouts/article_list/links','{\"positions\":{\"3\":\"sidebar\",\"1\":\"sidebar\",\"2\":\"sidebar\",\"4\":\"sidebar\",\"5\":\"sidebar\"},\"_xfRequestUri\":\"\\/admin.php?porta2\\/layouts\\/article_list\\/links\",\"_xfNoRedirect\":\"1\",\"_xfResponseType\":\"json\"}'),(8,1,'?D??',1510723208,'options/save/basicBoard','{\"options\":{\"boardTitle\":\"IratusPvP\",\"boardDescription\":\"Forum software by XenForo\",\"boardUrl\":\"https:\\/\\/iratuspvp.com\",\"defaultEmailAddress\":\"info@iratuspvp.com\",\"contactEmailAddress\":\"info@iratuspvp.com\",\"indexRoute\":\"articles\\/\",\"homePageUrl\":\"https:\\/\\/iratuspvp.com\",\"logoLink\":\"1\",\"privacyPolicyUrl\":\"\",\"tosUrl\":{\"type\":\"default\"},\"contactUrl\":{\"type\":\"default\"},\"guestTimeZone\":\"Europe\\/London\",\"captcha\":\"ReCaptcha\"},\"options_listed\":[\"boardTitle\",\"boardDescription\",\"boardUrl\",\"defaultEmailAddress\",\"contactEmailAddress\",\"indexRoute\",\"homePageUrl\",\"logoLink\",\"privacyPolicyUrl\",\"tosUrl\",\"contactUrl\",\"showFirstCookieNotice\",\"guestTimeZone\",\"captcha\",\"extraCaptchaKeys\",\"useFriendlyUrls\",\"romanizeUrls\"],\"_whatever\":\"1\"}'),(9,1,'?D??',1510723213,'tools/run-deferred','{\"redirect\":\"https:\\/\\/iratuspvp.com\\/admin.php?add-ons\\/\",\"execute\":\"1\"}'),(10,1,'?D??',1510723227,'nodes/insert','{\"node_type_id\":\"LinkForum\",\"parent_node_id\":\"0\"}'),(11,1,'?D??',1510723227,'nodes/insert','{\"node_type_id\":\"LinkForum\",\"parent_node_id\":\"0\"}'),(12,1,'?D??',1510723230,'link-forums/validate-field','{\"name\":\"title\",\"value\":\"Store\",\"existingDataKey\":\"\",\"_xfRequestUri\":\"\\/admin.php?nodes\\/insert\",\"_xfNoRedirect\":\"1\",\"_xfResponseType\":\"json\"}'),(13,1,'?D??',1510723231,'link-forums/validate-field','{\"name\":\"link_url\",\"value\":\"#\",\"existingDataKey\":\"\",\"_xfRequestUri\":\"\\/admin.php?nodes\\/insert\",\"_xfNoRedirect\":\"1\",\"_xfResponseType\":\"json\"}'),(14,1,'?D??',1510723234,'link-forums/save','{\"title\":\"Store\",\"description\":\"\",\"link_url\":\"#\",\"parent_node_id\":\"0\",\"display_order\":\"1\",\"nat_display_tab\":\"1\",\"nat_tabtitle\":\"\",\"nat_display_order\":\"1\",\"nat_position\":\"middle\",\"nat_childlinks\":\"0\",\"nat_linkstemplate\":\"\",\"nat_popup\":\"1\",\"nat_tabid\":\"\",\"node_type_id\":\"LinkForum\",\"_xfRequestUri\":\"\\/admin.php?nodes\\/insert\",\"_xfNoRedirect\":\"1\",\"_xfResponseType\":\"json\"}'),(15,1,'?D??',1510723243,'user-groups/administrative.3/save','{\"title\":\"Administrative\",\"display_style_priority\":\"1000\",\"user_title_override\":\"1\",\"user_title\":\"Administrator\",\"username_css\":\"\",\"banner_text\":\"\",\"banner_css_class\":\"userBanner bannerHidden\",\"permissions\":{\"general\":{\"view\":\"unset\",\"viewNode\":\"unset\",\"viewMemberList\":\"unset\",\"viewProfile\":\"unset\",\"search\":\"unset\",\"maxTaggedUsers\":\"0\",\"createTag\":\"unset\",\"bypassUserTagLimit\":\"unset\",\"editProfile\":\"unset\",\"editCustomTitle\":\"allow\",\"requireTfa\":\"unset\",\"followModerationRules\":\"unset\",\"bypassFloodCheck\":\"allow\",\"bypassSpamCheck\":\"unset\",\"report\":\"unset\",\"viewIps\":\"unset\",\"bypassUserPrivacy\":\"unset\",\"cleanSpam\":\"unset\",\"viewWarning\":\"unset\",\"warn\":\"unset\",\"manageWarning\":\"unset\",\"editBasicProfile\":\"unset\",\"editSignature\":\"unset\"},\"forum\":{\"viewOthers\":\"unset\",\"viewContent\":\"unset\",\"like\":\"unset\",\"postThread\":\"unset\",\"postReply\":\"unset\",\"editOwnPost\":\"unset\",\"deleteOwnPost\":\"unset\",\"editOwnPostTimeLimit\":\"-1\",\"editOwnThreadTitle\":\"unset\",\"deleteOwnThread\":\"allow\",\"viewAttachment\":\"unset\",\"uploadAttachment\":\"unset\",\"tagOwnThread\":\"unset\",\"tagAnyThread\":\"unset\",\"manageOthersTagsOwnThread\":\"allow\",\"votePoll\":\"unset\",\"stickUnstickThread\":\"unset\",\"lockUnlockThread\":\"unset\",\"manageAnyThread\":\"unset\",\"deleteAnyThread\":\"unset\",\"hardDeleteAnyThread\":\"unset\",\"threadReplyBan\":\"unset\",\"editAnyPost\":\"unset\",\"deleteAnyPost\":\"unset\",\"hardDeleteAnyPost\":\"unset\",\"warn\":\"unset\",\"manageAnyTag\":\"unset\",\"viewDeleted\":\"unset\",\"viewModerated\":\"unset\",\"undelete\":\"unset\",\"approveUnapprove\":\"unset\"},\"avatar\":{\"allowed\":\"allow\",\"maxFileSize\":\"-1\"},\"conversation\":{\"start\":\"unset\",\"receive\":\"unset\",\"uploadAttachment\":\"allow\",\"editOwnPost\":\"unset\",\"editOwnPostTimeLimit\":\"0\",\"maxRecipients\":\"-1\",\"editAnyPost\":\"allow\",\"alwaysInvite\":\"allow\"},\"signature\":{\"basicText\":\"unset\",\"extendedText\":\"unset\",\"align\":\"unset\",\"list\":\"unset\",\"image\":\"unset\",\"link\":\"unset\",\"media\":\"unset\",\"block\":\"unset\",\"maxPrintable\":\"0\",\"maxLinks\":\"0\",\"maxLines\":\"0\",\"maxImages\":\"0\",\"maxSmilies\":\"0\",\"maxTextSize\":\"0\"},\"profilePost\":{\"view\":\"unset\",\"like\":\"unset\",\"manageOwn\":\"unset\",\"post\":\"unset\",\"comment\":\"unset\",\"deleteOwn\":\"unset\",\"editOwn\":\"unset\",\"editAny\":\"unset\",\"deleteAny\":\"unset\",\"hardDeleteAny\":\"unset\",\"warn\":\"unset\",\"viewDeleted\":\"unset\",\"viewModerated\":\"unset\",\"undelete\":\"unset\",\"approveUnapprove\":\"unset\"},\"EWRporta2\":{\"canAdmin\":\"allow\",\"canModerate\":\"allow\",\"canPromote\":\"allow\",\"canTag\":\"allow\",\"canTags\":\"allow\",\"canFilter\":\"allow\",\"canArrange\":\"allow\"},\"uix\":{\"canCollapseSidebar\":\"unset\",\"canViewWelcomeBlock\":\"unset\",\"canUseStylerPanel\":\"unset\",\"canUseStylerSwatches\":\"unset\",\"canUseStylerPresets\":\"unset\"}}}'),(16,1,'?D??',1510723276,'styles/import','{\"target\":\"new\",\"parent_style_id\":\"0\",\"_xfConfirm\":\"1\"}'),(17,1,'?D??',1510723488,'styles/import','{\"target\":\"new\",\"parent_style_id\":\"2\",\"_xfConfirm\":\"1\"}'),(18,1,'?D??',1510723501,'styles/save','{\"parent_id\":\"2\",\"title\":\"IratusPvP\",\"description\":\"\",\"user_selectable\":\"1\",\"style_id\":\"3\",\"_xfRequestUri\":\"\\/admin.php?styles\\/outlawfactions.3\\/edit\",\"_xfNoRedirect\":\"1\",\"_xfResponseType\":\"json\"}'),(19,1,'?D??',1510723515,'templates/save-multiple.json','{\"titleArray\":{\"740\":\"footer\"},\"styleidArray\":{\"740\":\"3\"},\"templateArray\":{\"740\":\"