



--
-- Database: `xoops2511`
--

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_avatar`
--

CREATE TABLE `[[dbprefix]]_avatar` (
  `avatar_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `avatar_file` varchar(30) NOT NULL DEFAULT '',
  `avatar_name` varchar(100) NOT NULL DEFAULT '',
  `avatar_mimetype` varchar(30) NOT NULL DEFAULT '',
  `avatar_created` int(10) NOT NULL DEFAULT '0',
  `avatar_display` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `avatar_weight` smallint(5) unsigned NOT NULL DEFAULT '0',
  `avatar_type` char(1) NOT NULL DEFAULT '',
  PRIMARY KEY (`avatar_id`),
  KEY `avatar_type` (`avatar_type`,`avatar_display`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_avatar_user_link`
--

CREATE TABLE `[[dbprefix]]_avatar_user_link` (
  `avatar_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  KEY `avatar_user_id` (`avatar_id`,`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_banner`
--

CREATE TABLE `[[dbprefix]]_banner` (
  `bid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `cid` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `imptotal` int(10) unsigned NOT NULL DEFAULT '0',
  `impmade` int(10) unsigned NOT NULL DEFAULT '0',
  `clicks` int(10) unsigned NOT NULL DEFAULT '0',
  `imageurl` varchar(255) NOT NULL DEFAULT '',
  `clickurl` varchar(255) NOT NULL DEFAULT '',
  `date` int(10) NOT NULL DEFAULT '0',
  `htmlbanner` tinyint(1) NOT NULL DEFAULT '0',
  `htmlcode` text,
  PRIMARY KEY (`bid`),
  KEY `idxbannercid` (`cid`),
  KEY `idxbannerbidcid` (`bid`,`cid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `[[dbprefix]]_banner`
--

INSERT INTO `[[dbprefix]]_banner` VALUES
(1, 1, 0, 1, 0, '[[softurl]]/images/banners/xoops_banner_2.gif', 'http://xoops.org/', 1008813250, 0, ''),
(2, 1, 0, 1, 0, '[[softurl]]/images/banners/xoopsifyIt.gif', 'http://xoops.org/', 1008813250, 1, '');

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_bannerfinish`
--

CREATE TABLE `[[dbprefix]]_bannerfinish` (
  `bid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `cid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `impressions` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `clicks` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `datestart` int(10) unsigned NOT NULL DEFAULT '0',
  `dateend` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`bid`),
  KEY `cid` (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_block_module_link`
--

CREATE TABLE `[[dbprefix]]_block_module_link` (
  `block_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `module_id` smallint(5) NOT NULL DEFAULT '0',
  PRIMARY KEY (`module_id`,`block_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `[[dbprefix]]_block_module_link`
--

INSERT INTO `[[dbprefix]]_block_module_link` VALUES
(1, 0),
(2, 0),
(3, 0),
(4, 0),
(5, 0),
(6, 0),
(7, 0),
(8, 0),
(9, 0),
(10, 0),
(11, 0),
(12, 0);

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_cache_model`
--

CREATE TABLE `[[dbprefix]]_cache_model` (
  `cache_key` varchar(64) NOT NULL DEFAULT '',
  `cache_expires` int(10) unsigned NOT NULL DEFAULT '0',
  `cache_data` text,
  PRIMARY KEY (`cache_key`),
  KEY `cache_expires` (`cache_expires`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_config`
--

CREATE TABLE `[[dbprefix]]_config` (
  `conf_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `conf_modid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `conf_catid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `conf_name` varchar(25) NOT NULL DEFAULT '',
  `conf_title` varchar(255) NOT NULL DEFAULT '',
  `conf_value` text,
  `conf_desc` varchar(255) NOT NULL DEFAULT '',
  `conf_formtype` varchar(15) NOT NULL DEFAULT '',
  `conf_valuetype` varchar(10) NOT NULL DEFAULT '',
  `conf_order` smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`conf_id`),
  KEY `conf_mod_cat_id` (`conf_modid`,`conf_catid`),
  KEY `conf_order` (`conf_order`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=136 ;



-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_configcategory`
--

CREATE TABLE `[[dbprefix]]_configcategory` (
  `confcat_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `confcat_name` varchar(255) NOT NULL DEFAULT '',
  `confcat_order` smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`confcat_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `[[dbprefix]]_configcategory`
--

INSERT INTO `[[dbprefix]]_configcategory` VALUES
(1, '_MD_AM_GENERAL', 0),
(2, '_MD_AM_USERSETTINGS', 0),
(3, '_MD_AM_METAFOOTER', 0),
(4, '_MD_AM_CENSOR', 0),
(5, '_MD_AM_SEARCH', 0),
(6, '_MD_AM_MAILER', 0),
(7, '_MD_AM_AUTHENTICATION', 0);

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_configoption`
--

CREATE TABLE `[[dbprefix]]_configoption` (
  `confop_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `confop_name` varchar(255) NOT NULL DEFAULT '',
  `confop_value` varchar(255) NOT NULL DEFAULT '',
  `conf_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`confop_id`),
  KEY `conf_id` (`conf_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=61 ;

--
-- Dumping data for table `[[dbprefix]]_configoption`
--

INSERT INTO `[[dbprefix]]_configoption` VALUES
(1, '_MD_AM_DEBUGMODE1', '1', 13),
(2, '_MD_AM_DEBUGMODE2', '2', 13),
(3, '_NESTED', 'nest', 32),
(4, '_FLAT', 'flat', 32),
(5, '_THREADED', 'thread', 32),
(6, '_OLDESTFIRST', '0', 33),
(7, '_NEWESTFIRST', '1', 33),
(8, '_MD_AM_USERACTV', '0', 21),
(9, '_MD_AM_AUTOACTV', '1', 21),
(10, '_MD_AM_ADMINACTV', '2', 21),
(11, '_MD_AM_STRICT', '0', 23),
(12, '_MD_AM_MEDIUM', '1', 23),
(13, '_MD_AM_LIGHT', '2', 23),
(14, '_MD_AM_DEBUGMODE3', '3', 13),
(15, '_MD_AM_INDEXFOLLOW', 'index,follow', 43),
(16, '_MD_AM_NOINDEXFOLLOW', 'noindex,follow', 43),
(17, '_MD_AM_INDEXNOFOLLOW', 'index,nofollow', 43),
(18, '_MD_AM_NOINDEXNOFOLLOW', 'noindex,nofollow', 43),
(19, '_MD_AM_METAOGEN', 'general', 48),
(20, '_MD_AM_METAO14YRS', '14 years', 48),
(21, '_MD_AM_METAOREST', 'restricted', 48),
(22, '_MD_AM_METAOMAT', 'mature', 48),
(23, '_MD_AM_DEBUGMODE0', '0', 13),
(24, 'PHP mail()', 'mail', 64),
(25, 'sendmail', 'sendmail', 64),
(26, 'SMTP', 'smtp', 64),
(27, 'SMTPAuth', 'smtpauth', 64),
(28, '_MD_AM_AUTH_CONFOPTION_XOOPS', 'xoops', 74),
(29, '_MD_AM_AUTH_CONFOPTION_LDAP', 'ldap', 74),
(30, '_MD_AM_AUTH_CONFOPTION_AD', 'ads', 74),
(31, '_NO', '0', 95),
(32, '_MD_AM_WELCOMETYPE_EMAIL', '1', 95),
(33, '_MD_AM_WELCOMETYPE_PM', '2', 95),
(34, '_MD_AM_WELCOMETYPE_BOTH', '3', 95),
(35, 'qmail', 'qmail', 64),
(36, 'dhtmltextarea', 'dhtmltextarea', 126),
(37, 'textarea', 'textarea', 126),
(38, 'tinymce', 'tinymce', 126),
(39, 'tinymce5', 'tinymce5', 126),
(40, 'dhtmltextarea', 'dhtmltextarea', 127),
(41, 'textarea', 'textarea', 127),
(42, 'tinymce', 'tinymce', 127),
(43, 'tinymce5', 'tinymce5', 127),
(44, 'dhtmltextarea', 'dhtmltextarea', 128),
(45, 'textarea', 'textarea', 128),
(46, 'tinymce', 'tinymce', 128),
(47, 'tinymce5', 'tinymce5', 128),
(48, 'default', 'default', 98),
(49, 'transition', 'transition', 98),
(50, 'default', 'default', 99),
(51, 'base', 'base', 133),
(52, 'cupertino', 'cupertino', 133),
(53, 'redmond', 'redmond', 133),
(54, 'smoothness', 'smoothness', 133),
(55, 'south-street', 'south-street', 133),
(56, 'ui-darkness', 'ui-darkness', 133),
(57, 'ui-lightness', 'ui-lightness', 133),
(58, '_MI_DEFAULT_NOTIFICATION_METHOD_DISABLE', '0', 135),
(59, '_MI_DEFAULT_NOTIFICATION_METHOD_PM', '1', 135),
(60, '_MI_DEFAULT_NOTIFICATION_METHOD_EMAIL', '2', 135);

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_groups`
--

CREATE TABLE `[[dbprefix]]_groups` (
  `groupid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `description` text,
  `group_type` varchar(10) NOT NULL DEFAULT '',
  PRIMARY KEY (`groupid`),
  KEY `group_type` (`group_type`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `[[dbprefix]]_groups`
--

INSERT INTO `[[dbprefix]]_groups` VALUES
(1, 'Webmasters', 'Webmasters of this site', 'Admin'),
(2, 'Registered Users', 'Registered Users Group', 'User'),
(3, 'Anonymous Users', 'Anonymous Users Group', 'Anonymous');

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_groups_users_link`
--

CREATE TABLE `[[dbprefix]]_groups_users_link` (
  `linkid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `groupid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `uid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`linkid`),
  KEY `groupid_uid` (`groupid`,`uid`),
  KEY `uid` (`uid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `[[dbprefix]]_groups_users_link`
--

INSERT INTO `[[dbprefix]]_groups_users_link` VALUES
(1, 1, 1),
(2, 2, 1);

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_group_permission`
--

CREATE TABLE `[[dbprefix]]_group_permission` (
  `gperm_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `gperm_groupid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `gperm_itemid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `gperm_modid` mediumint(5) unsigned NOT NULL DEFAULT '0',
  `gperm_name` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`gperm_id`),
  KEY `groupid` (`gperm_groupid`),
  KEY `itemid` (`gperm_itemid`),
  KEY `gperm_modid` (`gperm_modid`,`gperm_name`(10))
) ENGINE=MyISAM  DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=58 ;

--
-- Dumping data for table `[[dbprefix]]_group_permission`
--

INSERT INTO `[[dbprefix]]_group_permission` VALUES
(1, 1, 1, 1, 'module_admin'),
(2, 1, 1, 1, 'module_read'),
(3, 2, 1, 1, 'module_read'),
(4, 3, 1, 1, 'module_read'),
(5, 1, 1, 1, 'system_admin'),
(6, 1, 2, 1, 'system_admin'),
(7, 1, 3, 1, 'system_admin'),
(8, 1, 4, 1, 'system_admin'),
(9, 1, 5, 1, 'system_admin'),
(10, 1, 6, 1, 'system_admin'),
(11, 1, 7, 1, 'system_admin'),
(12, 1, 8, 1, 'system_admin'),
(13, 1, 9, 1, 'system_admin'),
(14, 1, 10, 1, 'system_admin'),
(15, 1, 11, 1, 'system_admin'),
(16, 1, 12, 1, 'system_admin'),
(17, 1, 13, 1, 'system_admin'),
(18, 1, 14, 1, 'system_admin'),
(19, 1, 15, 1, 'system_admin'),
(20, 1, 16, 1, 'system_admin'),
(21, 1, 17, 1, 'system_admin'),
(22, 1, 1, 1, 'block_read'),
(23, 2, 1, 1, 'block_read'),
(24, 3, 1, 1, 'block_read'),
(25, 1, 2, 1, 'block_read'),
(26, 2, 2, 1, 'block_read'),
(27, 3, 2, 1, 'block_read'),
(28, 1, 3, 1, 'block_read'),
(29, 2, 3, 1, 'block_read'),
(30, 3, 3, 1, 'block_read'),
(31, 1, 4, 1, 'block_read'),
(32, 2, 4, 1, 'block_read'),
(33, 3, 4, 1, 'block_read'),
(34, 1, 5, 1, 'block_read'),
(35, 2, 5, 1, 'block_read'),
(36, 3, 5, 1, 'block_read'),
(37, 1, 6, 1, 'block_read'),
(38, 2, 6, 1, 'block_read'),
(39, 3, 6, 1, 'block_read'),
(40, 1, 7, 1, 'block_read'),
(41, 2, 7, 1, 'block_read'),
(42, 3, 7, 1, 'block_read'),
(43, 1, 8, 1, 'block_read'),
(44, 2, 8, 1, 'block_read'),
(45, 3, 8, 1, 'block_read'),
(46, 1, 9, 1, 'block_read'),
(47, 2, 9, 1, 'block_read'),
(48, 3, 9, 1, 'block_read'),
(49, 1, 10, 1, 'block_read'),
(50, 2, 10, 1, 'block_read'),
(51, 3, 10, 1, 'block_read'),
(52, 1, 11, 1, 'block_read'),
(53, 2, 11, 1, 'block_read'),
(54, 3, 11, 1, 'block_read'),
(55, 1, 12, 1, 'block_read'),
(56, 2, 12, 1, 'block_read'),
(57, 3, 12, 1, 'block_read');

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_image`
--

CREATE TABLE `[[dbprefix]]_image` (
  `image_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `image_name` varchar(30) NOT NULL DEFAULT '',
  `image_nicename` varchar(255) NOT NULL DEFAULT '',
  `image_mimetype` varchar(30) NOT NULL DEFAULT '',
  `image_created` int(10) unsigned NOT NULL DEFAULT '0',
  `image_display` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `image_weight` smallint(5) unsigned NOT NULL DEFAULT '0',
  `imgcat_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`image_id`),
  KEY `imgcat_id` (`imgcat_id`),
  KEY `image_display` (`image_display`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_imagebody`
--

CREATE TABLE `[[dbprefix]]_imagebody` (
  `image_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `image_body` mediumblob,
  KEY `image_id` (`image_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_imagecategory`
--

CREATE TABLE `[[dbprefix]]_imagecategory` (
  `imgcat_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `imgcat_name` varchar(100) NOT NULL DEFAULT '',
  `imgcat_maxsize` int(8) unsigned NOT NULL DEFAULT '0',
  `imgcat_maxwidth` smallint(3) unsigned NOT NULL DEFAULT '0',
  `imgcat_maxheight` smallint(3) unsigned NOT NULL DEFAULT '0',
  `imgcat_display` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `imgcat_weight` smallint(3) unsigned NOT NULL DEFAULT '0',
  `imgcat_type` char(1) NOT NULL DEFAULT '',
  `imgcat_storetype` varchar(5) NOT NULL DEFAULT '',
  PRIMARY KEY (`imgcat_id`),
  KEY `imgcat_display` (`imgcat_display`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_imgset`
--

CREATE TABLE `[[dbprefix]]_imgset` (
  `imgset_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `imgset_name` varchar(50) NOT NULL DEFAULT '',
  `imgset_refid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`imgset_id`),
  KEY `imgset_refid` (`imgset_refid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `[[dbprefix]]_imgset`
--

INSERT INTO `[[dbprefix]]_imgset` VALUES
(1, 'default', 0);

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_imgsetimg`
--

CREATE TABLE `[[dbprefix]]_imgsetimg` (
  `imgsetimg_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `imgsetimg_file` varchar(50) NOT NULL DEFAULT '',
  `imgsetimg_body` blob,
  `imgsetimg_imgset` smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`imgsetimg_id`),
  KEY `imgsetimg_imgset` (`imgsetimg_imgset`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_imgset_tplset_link`
--

CREATE TABLE `[[dbprefix]]_imgset_tplset_link` (
  `imgset_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  `tplset_name` varchar(50) NOT NULL DEFAULT '',
  KEY `tplset_name` (`tplset_name`(10))
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `[[dbprefix]]_imgset_tplset_link`
--

INSERT INTO `[[dbprefix]]_imgset_tplset_link` VALUES
(1, 'default');

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_modules`
--

CREATE TABLE `[[dbprefix]]_modules` (
  `mid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(150) NOT NULL DEFAULT '',
  `version` varchar(32) NOT NULL DEFAULT '',
  `last_update` int(10) unsigned NOT NULL DEFAULT '0',
  `weight` smallint(3) unsigned NOT NULL DEFAULT '0',
  `isactive` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `dirname` varchar(25) NOT NULL DEFAULT '',
  `hasmain` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `hasadmin` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `hassearch` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `hasconfig` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `hascomments` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `hasnotification` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`mid`),
  KEY `hasmain` (`hasmain`),
  KEY `hasadmin` (`hasadmin`),
  KEY `hassearch` (`hassearch`),
  KEY `hasnotification` (`hasnotification`),
  KEY `dirname` (`dirname`),
  KEY `name` (`name`(15)),
  KEY `isactive` (`isactive`),
  KEY `weight` (`weight`),
  KEY `hascomments` (`hascomments`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `[[dbprefix]]_modules`
--

INSERT INTO `[[dbprefix]]_modules` VALUES
(1, 'System', '2.1.7-Stable', [[timestamp]], 0, 1, 'system', 0, 1, 0, 0, 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_newblocks`
--

CREATE TABLE `[[dbprefix]]_newblocks` (
  `bid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `mid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `func_num` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `options` varchar(255) NOT NULL DEFAULT '',
  `name` varchar(150) NOT NULL DEFAULT '',
  `title` varchar(255) NOT NULL DEFAULT '',
  `content` text,
  `side` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `weight` smallint(5) unsigned NOT NULL DEFAULT '0',
  `visible` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `block_type` char(1) NOT NULL DEFAULT '',
  `c_type` char(1) NOT NULL DEFAULT '',
  `isactive` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `dirname` varchar(50) NOT NULL DEFAULT '',
  `func_file` varchar(50) NOT NULL DEFAULT '',
  `show_func` varchar(50) NOT NULL DEFAULT '',
  `edit_func` varchar(50) NOT NULL DEFAULT '',
  `template` varchar(50) NOT NULL DEFAULT '',
  `bcachetime` int(10) unsigned NOT NULL DEFAULT '0',
  `last_modified` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`bid`),
  KEY `mid` (`mid`),
  KEY `visible` (`visible`),
  KEY `isactive_visible_mid` (`isactive`,`visible`,`mid`),
  KEY `mid_funcnum` (`mid`,`func_num`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=13 ;

--
-- Dumping data for table `[[dbprefix]]_newblocks`
--

INSERT INTO `[[dbprefix]]_newblocks` VALUES
(1, 1, 0, '', 'User Menu', 'User Menu', '', 0, 0, 1, 'S', 'H', 1, 'system', 'system_blocks.php', 'b_system_user_show', '', 'system_block_user.tpl', 0, [[timestamp]]),
(2, 1, 2, '', 'Login', 'Login', '', 0, 0, 1, 'S', 'H', 1, 'system', 'system_blocks.php', 'b_system_login_show', '', 'system_block_login.tpl', 0, [[timestamp]]),
(3, 1, 3, '', 'Search', 'Search', '', 0, 0, 0, 'S', 'H', 1, 'system', 'system_blocks.php', 'b_system_search_show', '', 'system_block_search.tpl', 0, [[timestamp]]),
(4, 1, 4, '', 'Waiting Contents', 'Waiting Contents', '', 0, 0, 0, 'S', 'H', 1, 'system', 'system_blocks.php', 'b_system_waiting_show', '', 'system_block_waiting.tpl', 0, [[timestamp]]),
(5, 1, 5, '', 'Main Menu', 'Main Menu', '', 0, 0, 1, 'S', 'H', 1, 'system', 'system_blocks.php', 'b_system_main_show', '', 'system_block_mainmenu.tpl', 0, [[timestamp]]),
(6, 1, 6, '320|190|s_poweredby.png|1', 'Site Info', 'Site Info', '', 0, 0, 0, 'S', 'H', 1, 'system', 'system_blocks.php', 'b_system_info_show', 'b_system_info_edit', 'system_block_siteinfo.tpl', 0, [[timestamp]]),
(7, 1, 7, '', 'Who is Online', 'Who is Online', '', 0, 0, 0, 'S', 'H', 1, 'system', 'system_blocks.php', 'b_system_online_show', '', 'system_block_online.tpl', 0, [[timestamp]]),
(8, 1, 8, '10|1', 'Top Posters', 'Top Posters', '', 0, 0, 0, 'S', 'H', 1, 'system', 'system_blocks.php', 'b_system_topposters_show', 'b_system_topposters_edit', 'system_block_topusers.tpl', 0, [[timestamp]]),
(9, 1, 9, '10|1', 'New Members', 'New Members', '', 0, 0, 0, 'S', 'H', 1, 'system', 'system_blocks.php', 'b_system_newmembers_show', 'b_system_newmembers_edit', 'system_block_newusers.tpl', 0, [[timestamp]]),
(10, 1, 10, '10', 'Recent Comments', 'Recent Comments', '', 0, 0, 0, 'S', 'H', 1, 'system', 'system_blocks.php', 'b_system_comments_show', 'b_system_comments_edit', 'system_block_comments.tpl', 0, [[timestamp]]),
(11, 1, 11, '', 'Notification Options', 'Notification Options', '', 0, 0, 0, 'S', 'H', 1, 'system', 'system_blocks.php', 'b_system_notification_show', '', 'system_block_notification.tpl', 0, [[timestamp]]),
(12, 1, 12, '0|120|3', 'Themes', 'Themes', '', 0, 0, 0, 'S', 'H', 1, 'system', 'system_blocks.php', 'b_system_themes_show', 'b_system_themes_edit', 'system_block_themes.tpl', 0, [[timestamp]]);

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_online`
--

CREATE TABLE `[[dbprefix]]_online` (
  `online_uid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `online_uname` varchar(25) NOT NULL DEFAULT '',
  `online_updated` int(10) unsigned NOT NULL DEFAULT '0',
  `online_module` smallint(5) unsigned NOT NULL DEFAULT '0',
  `online_ip` varchar(45) NOT NULL DEFAULT '',
  KEY `online_module` (`online_module`),
  KEY `online_updated` (`online_updated`),
  KEY `online_uid` (`online_uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_priv_msgs`
--

CREATE TABLE `[[dbprefix]]_priv_msgs` (
  `msg_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `msg_image` varchar(100) DEFAULT NULL,
  `subject` varchar(255) NOT NULL DEFAULT '',
  `from_userid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `to_userid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `msg_time` int(10) unsigned NOT NULL DEFAULT '0',
  `msg_text` text,
  `read_msg` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `from_delete` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `from_save` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `to_delete` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `to_save` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`msg_id`),
  KEY `to_userid` (`to_userid`),
  KEY `touseridreadmsg` (`to_userid`,`read_msg`),
  KEY `msgidfromuserid` (`from_userid`,`msg_id`),
  KEY `prune` (`msg_time`,`read_msg`,`from_save`,`to_delete`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_ranks`
--

CREATE TABLE `[[dbprefix]]_ranks` (
  `rank_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `rank_title` varchar(50) NOT NULL DEFAULT '',
  `rank_min` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `rank_max` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `rank_special` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `rank_image` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`rank_id`),
  KEY `rank_min` (`rank_min`),
  KEY `rank_max` (`rank_max`),
  KEY `rankminrankmaxranspecial` (`rank_min`,`rank_max`,`rank_special`),
  KEY `rankspecial` (`rank_special`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `[[dbprefix]]_ranks`
--

INSERT INTO `[[dbprefix]]_ranks` VALUES
(1, 'Just popping in', 0, 20, 0, 'ranks/rank3e632f95e81ca.gif'),
(2, 'Not too shy to talk', 21, 40, 0, 'ranks/rank3dbf8e94a6f72.gif'),
(3, 'Quite a regular', 41, 70, 0, 'ranks/rank3dbf8e9e7d88d.gif'),
(4, 'Just can''t stay away', 71, 150, 0, 'ranks/rank3dbf8ea81e642.gif'),
(5, 'Home away from home', 151, 10000, 0, 'ranks/rank3dbf8eb1a72e7.gif'),
(6, 'Moderator', 0, 0, 1, 'ranks/rank3dbf8edf15093.gif'),
(7, 'Webmaster', 0, 0, 1, 'ranks/rank3dbf8ee8681cd.gif');

--
-- Dumping data for table `[[dbprefix]]_session`
--


-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_smiles`
--

CREATE TABLE `[[dbprefix]]_smiles` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(50) NOT NULL DEFAULT '',
  `smile_url` varchar(100) NOT NULL DEFAULT '',
  `emotion` varchar(75) NOT NULL DEFAULT '',
  `display` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=18 ;

--
-- Dumping data for table `[[dbprefix]]_smiles`
--

INSERT INTO `[[dbprefix]]_smiles` VALUES
(1, ':-D', 'smilies/smil3dbd4d4e4c4f2.gif', 'Very Happy', 1),
(2, ':-)', 'smilies/smil3dbd4d6422f04.gif', 'Smile', 1),
(3, ':-(', 'smilies/smil3dbd4d75edb5e.gif', 'Sad', 1),
(4, ':-o', 'smilies/smil3dbd4d8676346.gif', 'Surprised', 1),
(5, ':-?', 'smilies/smil3dbd4d99c6eaa.gif', 'Confused', 1),
(6, '8-)', 'smilies/smil3dbd4daabd491.gif', 'Cool', 1),
(7, ':lol:', 'smilies/smil3dbd4dbc14f3f.gif', 'Laughing', 1),
(8, ':-x', 'smilies/smil3dbd4dcd7b9f4.gif', 'Mad', 1),
(9, ':-P', 'smilies/smil3dbd4ddd6835f.gif', 'Razz', 1),
(10, ':oops:', 'smilies/smil3dbd4df1944ee.gif', 'Embaressed', 0),
(11, ':cry:', 'smilies/smil3dbd4e02c5440.gif', 'Crying (very sad)', 0),
(12, ':evil:', 'smilies/smil3dbd4e1748cc9.gif', 'Evil or Very Mad', 0),
(13, ':roll:', 'smilies/smil3dbd4e29bbcc7.gif', 'Rolling Eyes', 0),
(14, ';-)', 'smilies/smil3dbd4e398ff7b.gif', 'Wink', 0),
(15, ':pint:', 'smilies/smil3dbd4e4c2e742.gif', 'Another pint of beer', 0),
(16, ':hammer:', 'smilies/smil3dbd4e5e7563a.gif', 'ToolTimes at work', 0),
(17, ':idea:', 'smilies/smil3dbd4e7853679.gif', 'I have an idea', 0);

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_tplfile`
--

CREATE TABLE `[[dbprefix]]_tplfile` (
  `tpl_id` mediumint(7) unsigned NOT NULL AUTO_INCREMENT,
  `tpl_refid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `tpl_module` varchar(25) NOT NULL DEFAULT '',
  `tpl_tplset` varchar(50) NOT NULL DEFAULT '',
  `tpl_file` varchar(50) NOT NULL DEFAULT '',
  `tpl_desc` varchar(255) NOT NULL DEFAULT '',
  `tpl_lastmodified` int(10) unsigned NOT NULL DEFAULT '0',
  `tpl_lastimported` int(10) unsigned NOT NULL DEFAULT '0',
  `tpl_type` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`tpl_id`),
  UNIQUE KEY `tpl_refid_module_set_file_type` (`tpl_refid`,`tpl_module`,`tpl_tplset`,`tpl_file`,`tpl_type`),
  KEY `tpl_refid` (`tpl_refid`,`tpl_type`),
  KEY `tpl_tplset` (`tpl_tplset`,`tpl_file`(10))
) ENGINE=MyISAM  DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=81 ;

--
-- Dumping data for table `[[dbprefix]]_tplfile`
--

INSERT INTO `[[dbprefix]]_tplfile` VALUES
(1, 1, 'system', 'default', 'system_imagemanager.tpl', '', [[timestamp]], [[timestamp]], 'module'),
(2, 1, 'system', 'default', 'system_imagemanager2.tpl', '', [[timestamp]], [[timestamp]], 'module'),
(3, 1, 'system', 'default', 'system_userinfo.tpl', '', [[timestamp]], [[timestamp]], 'module'),
(4, 1, 'system', 'default', 'system_userform.tpl', '', [[timestamp]], [[timestamp]], 'module'),
(5, 1, 'system', 'default', 'system_rss.tpl', '', [[timestamp]], [[timestamp]], 'module'),
(6, 1, 'system', 'default', 'system_redirect.tpl', '', [[timestamp]], [[timestamp]], 'module'),
(7, 1, 'system', 'default', 'system_comment.tpl', '', [[timestamp]], [[timestamp]], 'module'),
(8, 1, 'system', 'default', 'system_comments_controls.tpl', '', [[timestamp]], [[timestamp]], 'module'),
(9, 1, 'system', 'default', 'system_comments_flat.tpl', '', [[timestamp]], [[timestamp]], 'module'),
(10, 1, 'system', 'default', 'system_comments_thread.tpl', '', [[timestamp]], [[timestamp]], 'module'),
(11, 1, 'system', 'default', 'system_comments_nest.tpl', '', [[timestamp]], [[timestamp]], 'module'),
(12, 1, 'system', 'default', 'system_siteclosed.tpl', '', [[timestamp]], [[timestamp]], 'module'),
(13, 1, 'system', 'default', 'system_dummy.tpl', '', [[timestamp]], [[timestamp]], 'module'),
(14, 1, 'system', 'default', 'system_notification_list.tpl', '', [[timestamp]], [[timestamp]], 'module'),
(15, 1, 'system', 'default', 'system_notification_select.tpl', '', [[timestamp]], [[timestamp]], 'module'),
(16, 1, 'system', 'default', 'system_block_dummy.tpl', '', [[timestamp]], [[timestamp]], 'module'),
(17, 1, 'system', 'default', 'system_homepage.tpl', '', [[timestamp]], [[timestamp]], 'module'),
(18, 1, 'system', 'default', 'system_bannerlogin.tpl', '', [[timestamp]], [[timestamp]], 'module'),
(19, 1, 'system', 'default', 'system_banner.tpl', '', [[timestamp]], [[timestamp]], 'module'),
(20, 1, 'system', 'default', 'system_bannerdisplay.tpl', '', [[timestamp]], [[timestamp]], 'module'),
(21, 1, 'system', 'default', 'system_search.tpl', '', [[timestamp]], [[timestamp]], 'module'),
(22, 1, 'system', 'default', 'system_popup_header.tpl', '', [[timestamp]], [[timestamp]], 'module'),
(23, 1, 'system', 'default', 'system_popup_footer.tpl', '', [[timestamp]], [[timestamp]], 'module'),
(24, 1, 'system', 'default', 'system_trigger_uploads.tpl', '', [[timestamp]], [[timestamp]], 'module'),
(25, 1, 'system', 'default', 'system_confirm.tpl', '', [[timestamp]], [[timestamp]], 'module'),
(26, 1, 'system', 'default', 'system_pagenav.tpl', '', [[timestamp]], [[timestamp]], 'module'),
(27, 1, 'system', 'default', 'system_misc_avatars.tpl', '', [[timestamp]], [[timestamp]], 'module'),
(28, 1, 'system', 'default', 'system_misc_friend.tpl', '', [[timestamp]], [[timestamp]], 'module'),
(29, 1, 'system', 'default', 'system_misc_online.tpl', '', [[timestamp]], [[timestamp]], 'module'),
(30, 1, 'system', 'default', 'system_misc_smilies.tpl', '', [[timestamp]], [[timestamp]], 'module'),
(31, 1, 'system', 'default', 'system_imagemanager.html', '', [[timestamp]], [[timestamp]], 'module'),
(32, 1, 'system', 'default', 'system_imagemanager2.html', '', [[timestamp]], [[timestamp]], 'module'),
(33, 1, 'system', 'default', 'system_userinfo.html', '', [[timestamp]], [[timestamp]], 'module'),
(34, 1, 'system', 'default', 'system_userform.html', '', [[timestamp]], [[timestamp]], 'module'),
(35, 1, 'system', 'default', 'system_rss.html', '', [[timestamp]], [[timestamp]], 'module'),
(36, 1, 'system', 'default', 'system_redirect.html', '', [[timestamp]], [[timestamp]], 'module'),
(37, 1, 'system', 'default', 'system_comment.html', '', [[timestamp]], [[timestamp]], 'module'),
(38, 1, 'system', 'default', 'system_comments_flat.html', '', [[timestamp]], [[timestamp]], 'module'),
(39, 1, 'system', 'default', 'system_comments_thread.html', '', [[timestamp]], [[timestamp]], 'module'),
(40, 1, 'system', 'default', 'system_comments_nest.html', '', [[timestamp]], [[timestamp]], 'module'),
(41, 1, 'system', 'default', 'system_siteclosed.html', '', [[timestamp]], [[timestamp]], 'module'),
(42, 1, 'system', 'default', 'system_dummy.html', '', [[timestamp]], [[timestamp]], 'module'),
(43, 1, 'system', 'default', 'system_notification_list.html', '', [[timestamp]], [[timestamp]], 'module'),
(44, 1, 'system', 'default', 'system_notification_select.html', '', [[timestamp]], [[timestamp]], 'module'),
(45, 1, 'system', 'default', 'system_block_dummy.html', '', [[timestamp]], [[timestamp]], 'module'),
(46, 1, 'system', 'default', 'system_homepage.html', '', [[timestamp]], [[timestamp]], 'module'),
(47, 1, 'system', 'default', 'system_bannerlogin.html', '', [[timestamp]], [[timestamp]], 'module'),
(48, 1, 'system', 'default', 'system_banner.html', '', [[timestamp]], [[timestamp]], 'module'),
(49, 1, 'system', 'default', 'system_bannerdisplay.html', '', [[timestamp]], [[timestamp]], 'module'),
(50, 1, 'system', 'default', 'system_header.tpl', '', [[timestamp]], [[timestamp]], 'admin'),
(51, 1, 'system', 'default', 'system_banners.tpl', '', [[timestamp]], [[timestamp]], 'admin'),
(52, 1, 'system', 'default', 'system_modules.tpl', '', [[timestamp]], [[timestamp]], 'admin'),
(53, 1, 'system', 'default', 'system_modules_confirm.tpl', '', [[timestamp]], [[timestamp]], 'admin'),
(54, 1, 'system', 'default', 'system_avatars.tpl', '', [[timestamp]], [[timestamp]], 'admin'),
(55, 1, 'system', 'default', 'system_smilies.tpl', '', [[timestamp]], [[timestamp]], 'admin'),
(56, 1, 'system', 'default', 'system_blocks.tpl', '', [[timestamp]], [[timestamp]], 'admin'),
(57, 1, 'system', 'default', 'system_blocks_item.tpl', '', [[timestamp]], [[timestamp]], 'admin'),
(58, 1, 'system', 'default', 'system_comments.tpl', '', [[timestamp]], [[timestamp]], 'admin'),
(59, 1, 'system', 'default', 'system_userrank.tpl', '', [[timestamp]], [[timestamp]], 'admin'),
(60, 1, 'system', 'default', 'system_users.tpl', '', [[timestamp]], [[timestamp]], 'admin'),
(61, 1, 'system', 'default', 'system_preferences.tpl', '', [[timestamp]], [[timestamp]], 'admin'),
(62, 1, 'system', 'default', 'system_mailusers.tpl', '', [[timestamp]], [[timestamp]], 'admin'),
(63, 1, 'system', 'default', 'system_groups.tpl', '', [[timestamp]], [[timestamp]], 'admin'),
(64, 1, 'system', 'default', 'system_images.tpl', '', [[timestamp]], [[timestamp]], 'admin'),
(65, 1, 'system', 'default', 'system_templates.tpl', '', [[timestamp]], [[timestamp]], 'admin'),
(66, 1, 'system', 'default', 'system_index.tpl', '', [[timestamp]], [[timestamp]], 'admin'),
(67, 1, 'system', 'default', 'system_maintenance.tpl', '', [[timestamp]], [[timestamp]], 'admin'),
(68, 1, 'system', 'default', 'system_help.tpl', '', [[timestamp]], [[timestamp]], 'admin'),
(69, 1, 'system', 'default', 'system_block_user.tpl', 'Shows user block', [[timestamp]], [[timestamp]], 'block'),
(70, 2, 'system', 'default', 'system_block_login.tpl', 'Shows login form', [[timestamp]], [[timestamp]], 'block'),
(71, 3, 'system', 'default', 'system_block_search.tpl', 'Shows search form block', [[timestamp]], [[timestamp]], 'block'),
(72, 4, 'system', 'default', 'system_block_waiting.tpl', 'Shows contents waiting for approval', [[timestamp]], [[timestamp]], 'block'),
(73, 5, 'system', 'default', 'system_block_mainmenu.tpl', 'Shows the main navigation menu of the site', [[timestamp]], [[timestamp]], 'block'),
(74, 6, 'system', 'default', 'system_block_siteinfo.tpl', 'Shows basic info about the site and a link to Recommend Us pop up window', [[timestamp]], [[timestamp]], 'block'),
(75, 7, 'system', 'default', 'system_block_online.tpl', 'Displays users/guests currently online', [[timestamp]], [[timestamp]], 'block'),
(76, 8, 'system', 'default', 'system_block_topusers.tpl', 'Top posters', [[timestamp]], [[timestamp]], 'block'),
(77, 9, 'system', 'default', 'system_block_newusers.tpl', 'Shows most recent users', [[timestamp]], [[timestamp]], 'block'),
(78, 10, 'system', 'default', 'system_block_comments.tpl', 'Shows most recent comments', [[timestamp]], [[timestamp]], 'block'),
(79, 11, 'system', 'default', 'system_block_notification.tpl', 'Shows notification options', [[timestamp]], [[timestamp]], 'block'),
(80, 12, 'system', 'default', 'system_block_themes.tpl', 'Shows theme selection box', [[timestamp]], [[timestamp]], 'block');

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_tplset`
--

CREATE TABLE `[[dbprefix]]_tplset` (
  `tplset_id` int(7) unsigned NOT NULL AUTO_INCREMENT,
  `tplset_name` varchar(50) NOT NULL DEFAULT '',
  `tplset_desc` varchar(255) NOT NULL DEFAULT '',
  `tplset_credits` text,
  `tplset_created` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`tplset_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `[[dbprefix]]_tplset`
--

INSERT INTO `[[dbprefix]]_tplset` VALUES
(1, 'default', 'XOOPS Default Template Set', '', [[timestamp]]);

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_tplsource`
--

CREATE TABLE `[[dbprefix]]_tplsource` (
  `tpl_id` mediumint(7) unsigned NOT NULL DEFAULT '0',
  `tpl_source` mediumtext,
  KEY `tpl_id` (`tpl_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;



INSERT INTO `[[dbprefix]]_tplsource` VALUES
(50, '<ul id="xo-breadcrumb" class="ui-corner-all" style="background-image:url(''<{xoAdminNav}>bc_bg.png'');">\n    <{foreach item=breadcrumb from=$xo_sys_breadcrumb|default:null}>\n        <{if !empty($breadcrumb.home)}>\n            <li><a class="tooltip" href="<{$breadcrumb.link}>" title="<{$breadcrumb.title}>" style="background-image:url(''<{xoAdminNav}>bc_separator.png'');"><img\n                            class="home" src="<{xoAdminNav}>home.png" alt="<{$breadcrumb.title}>"/></a></li>\n        <{else}>\n            <{if !empty($breadcrumb.link)}>\n                <li><a class="tooltip" href="<{$breadcrumb.link}>" title="<{$breadcrumb.title}>" style="background-image:url(''<{xoAdminNav}>bc_separator.png'');"><{$breadcrumb.title}></a>\n                </li>\n            <{else}>\n                <li><{$breadcrumb.title}></li>\n            <{/if}>\n        <{/if}>\n    <{/foreach}>\n    <{if !empty($xo_sys_help)}>\n        <li class="xo-help">\n            <a class="cursorhelp tooltip help_view" title="<{$smarty.const._AM_SYSTEM_HELP_VIEW}>"\n               style="background-image:url(''<{xoAdminNav}>bc_separator_end.png''); display: inline;"><img src="<{xoAdminIcons ''help.png''}>"\n                                                                                                           alt="<{$smarty.const._AM_SYSTEM_HELP_VIEW}>"/></a>\n            <a class="cursorhelp tooltip help_hide" title="<{$smarty.const._AM_SYSTEM_HELP_HIDE}>"\n               style="background-image:url(''<{xoAdminNav}>bc_separator_end.png'');"><img src="<{xoAdminIcons ''help.png''}>"\n                                                                                                        alt="<{$smarty.const._AM_SYSTEM_HELP_HIDE}>"/></a>\n        </li>\n    <{/if}>\n</ul>\n<{if !empty($help_content)}>\n    <div class="hide" id="xo-system-help">\n        <{include file="$help_content"}>\n    </div>\n<{/if}>\n<{if !empty($xo_sys_tips)}>\n    <div class="tips ui-corner-all">\n        <img class="floatleft tooltip" src="<{xoAdminIcons ''tips.png''}>" alt="<{$smarty.const._AM_SYSTEM_TIPS}>" title="<{$smarty.const._AM_SYSTEM_TIPS}>"/>\n\n        <div class="floatleft"><{$xo_sys_tips}></div>\n        <div class="clear">&nbsp;</div>\n    </div>\n<{else}>\n    <br>\n<{/if}>\n'),
(51, '<{include file="db:system_header.tpl"}>\n<!--Banner-->\n<table class=''width100 bnone'' cellspacing=''1''>\n    <tr>\n        <{if isset($banner_count) && $banner_count == true}>}>\n            <td>\n                <h4><{$smarty.const._AM_SYSTEM_BANNERS_CURACTBNR}></h4>\n            </td>\n        <{/if}>\n        <td>\n            <div class="floatright">\n                <div class="xo-buttons">\n                    <a class="ui-corner-all tooltip" href="admin.php?fct=banners&amp;op=new_banner"\n                       title="<{$smarty.const._AM_SYSTEM_BANNERS_ADDNWBNR}>">\n                        <img src="<{xoAdminIcons ''attach.png''}>" alt="<{$smarty.const._AM_SYSTEM_BANNERS_ADDNWBNR}>"/>\n                        <{$smarty.const._AM_SYSTEM_BANNERS_ADDNWBNR}></a>\n                    <a class="ui-corner-all tooltip" href="admin.php?fct=banners&amp;op=new_client"\n                       title="<{$smarty.const._AM_SYSTEM_BANNERS_ADDCLI}>">\n                        <img src="<{xoAdminIcons ''user_add.png''}>" alt="<{$smarty.const._AM_SYSTEM_BANNERS_ADDCLI}>"/>\n                        <{$smarty.const._AM_SYSTEM_BANNERS_ADDCLI}></a>\n                </div>\n            </div>\n        </td>\n    </tr>\n</table>\n<{if isset($banner_count) && $banner_count == true}>\n    <table id="xo-bannerslist-sorter" cellspacing="1" class="outer tablesorter">\n        <thead>\n        <tr>\n            <th class="txtcenter"><{$smarty.const._AM_SYSTEM_BANNERS_IMPRESION}></th>\n            <th class="txtcenter"><{$smarty.const._AM_SYSTEM_BANNERS_IMPLEFT}></th>\n            <th class="txtcenter"><{$smarty.const._AM_SYSTEM_BANNERS_CLICKS}></th>\n            <th class="txtcenter"><{$smarty.const._AM_SYSTEM_BANNERS_NCLICKS}></th>\n            <th class="txtcenter"><{$smarty.const._AM_SYSTEM_BANNERS_CLINAME}></th>\n            <th class="txtcenter width10"><{$smarty.const._AM_SYSTEM_BANNERS_FUNCTION}></th>\n        </tr>\n        </thead>\n        <tbody>\n        <{foreach item=bannerdetail from=$banner|default:null}>\n            <tr class="<{cycle values=''even,odd''}>">\n                <td class="txtcenter"><{$bannerdetail.impmade}></td>\n                <td class="txtcenter"><{$bannerdetail.left}></td>\n                <td class="txtcenter"><{$bannerdetail.clicks}></td>\n                <td class="txtcenter"><{$bannerdetail.percent}>%</td>\n                <td class="txtcenter"><{$bannerdetail.name}></td>\n                <td class="xo-actions txtcenter">\n                    <img class="tooltip" onclick="display_dialog(<{$bannerdetail.bid}>, true, true, ''slide'', ''slide'', 200, 520);" src="<{xoAdminIcons ''display.png''}>"\n                         alt="<{$smarty.const._AM_SYSTEM_BANNERS_VIEW}>" title="<{$smarty.const._AM_SYSTEM_BANNERS_VIEW}>"/>\n                    <a class="tooltip" href="admin.php?fct=banners&amp;op=banner_edit&amp;bid=<{$bannerdetail.bid}>"\n                       title="<{$smarty.const._AM_SYSTEM_BANNERS_EDIT}>">\n                        <img src="<{xoAdminIcons ''edit.png''}>" alt="<{$smarty.const._AM_SYSTEM_BANNERS_EDIT}>"/></a>\n                    <a class="tooltip" href="admin.php?fct=banners&amp;op=banner_delete&amp;bid=<{$bannerdetail.bid}>"\n                       title="<{$smarty.const._AM_SYSTEM_BANNERS_DELETE}>">\n                        <img src="<{xoAdminIcons ''delete.png''}>" alt="<{$smarty.const._AM_SYSTEM_BANNERS_DELETE}>"/></a>\n                </td>\n            </tr>\n        <{/foreach}>\n        </tbody>\n    </table>\n    <div class="clear spacer"></div>\n    <{if !empty($nav_menu_banner)}>\n        <div class="xo-avatar-pagenav floatright"><{$nav_menu_banner}></div>\n        <div class="clear spacer"></div>\n    <{/if}>\n    <!--Pop-pup-->\n    <{foreach item=banner from=$popup_banner|default:null}>\n        <div id="dialog<{$banner.bid}>" title="<{$banner.name}>" style=''display:none;''>\n            <{$banner.imageurl}>\n        </div>\n    <{/foreach}>\n    <!--Pop-pup-->\n<{/if}>\n\n<!--Banner Finish-->\n<{if isset($banner_finish_count) && $banner_finish_count == true}>\n    <h4><{$smarty.const._AM_SYSTEM_BANNERS_FINISHBNR}></h4>\n    <table id="xo-bannersfinish-sorter" cellspacing="1" class="outer tablesorter">\n        <thead>\n        <tr>\n            <th class="txtcenter"><{$smarty.const._AM_SYSTEM_BANNERS_IMPD}></th>\n            <th class="txtcenter"><{$smarty.const._AM_SYSTEM_BANNERS_CLICKS}></th>\n            <th class="txtcenter"><{$smarty.const._AM_SYSTEM_BANNERS_NCLICKS}></th>\n            <th class="txtcenter"><{$smarty.const._AM_SYSTEM_BANNERS_STARTDATE}></th>\n            <th class="txtcenter"><{$smarty.const._AM_SYSTEM_BANNERS_ENDDATE}></th>\n            <th class="txtcenter"><{$smarty.const._AM_SYSTEM_BANNERS_CLINAME}></th>\n            <th class="txtcenter width10"><{$smarty.const._AM_SYSTEM_BANNERS_FUNCTION}></th>\n        </tr>\n        </thead>\n        <tbody>\n        <{foreach item=finished_banner from=$banner_finish|default:null}>\n            <tr class="<{cycle values=''even,odd''}>">\n                <td class="txtcenter"><{$finished_banner.impressions}></td>\n                <td class="txtcenter"><{$finished_banner.clicks}></td>\n                <td class="txtcenter"><{$finished_banner.percent}>%</td>\n                <td class="txtcenter"><{$finished_banner.datestart}></td>\n                <td class="txtcenter"><{$finished_banner.dateend}></td>\n                <td class="txtcenter"><{$finished_banner.name}></td>\n                <td class="xo-actions txtcenter">\n                    <a class="tooltip" href="admin.php?fct=banners&amp;op=banner_finish_delete&amp;bid=<{$finished_banner.bid}>"\n                       title="<{$smarty.const._AM_SYSTEM_BANNERS_DELETE}>">\n                        <img src="<{xoAdminIcons ''delete.png''}>" alt="<{$smarty.const._AM_SYSTEM_BANNERS_DELETE}>"/></a>\n                </td>\n            </tr>\n        <{/foreach}>\n        </tbody>\n    </table>\n    <div class="clear spacer"></div>\n    <{if !empty($nav_menu_bannerF)}>\n        <div class="xo-avatar-pagenav floatright"><{$nav_menu_bannerF}></div>\n        <div class="clear spacer"></div>\n    <{/if}>\n\n<{/if}>\n<!--Banner Client-->\n<{if isset($banner_client_count) && $banner_client_count == true}>\n    <h4><{$smarty.const._AM_SYSTEM_BANNERS_ADVCLI}></h4>\n    <table id="xo-bannersclient-sorter" cellspacing="1" class="outer tablesorter">\n        <thead>\n        <tr>\n            <th class="txtcenter"><{$smarty.const._AM_SYSTEM_BANNERS_CLINAME}></th>\n            <th class="txtcenter"><{$smarty.const._AM_SYSTEM_BANNERS_ACTIVEBNR}></th>\n            <th class="txtcenter"><{$smarty.const._AM_SYSTEM_BANNERS_CONTNAME}></th>\n            <th class="txtcenter"><{$smarty.const._AM_SYSTEM_BANNERS_CONTMAIL}></th>\n            <th class="txtcenter width10"><{$smarty.const._AM_SYSTEM_BANNERS_FUNCTION}></th>\n        </tr>\n        </thead>\n        <tbody>\n        <{foreach item=banner_client_detail from=$banner_client|default:null}>\n            <tr class="<{cycle values=''even,odd''}>">\n                <td class="txtcenter"><{$banner_client_detail.name}></td>\n                <td class="txtcenter"><{$banner_client_detail.banner_active}></td>\n                <td class="txtcenter"><{$banner_client_detail.contact}></td>\n                <td class="txtcenter"><{$banner_client_detail.email}></td>\n                <td class="xo-actions txtcenter">\n                    <a class="tooltip" href="admin.php?fct=banners&amp;op=banner_client_edit&amp;cid=<{$banner_client_detail.cid}>"\n                       title="<{$smarty.const._AM_SYSTEM_BANNERS_EDIT}>">\n                        <img src="<{xoAdminIcons ''edit.png''}>" alt="<{$smarty.const._AM_SYSTEM_BANNERS_EDIT}>"/></a>\n                    <a class="tooltip" href="admin.php?fct=banners&amp;op=banner_client_delete&amp;cid=<{$banner_client_detail.cid}>"\n                       title="<{$smarty.const._AM_SYSTEM_BANNERS_DELETE}>">\n                        <img src="<{xoAdminIcons ''delete.png''}>" alt="<{$smarty.const._AM_SYSTEM_BANNERS_DELETE}>"/></a>\n                </td>\n            </tr>\n        <{/foreach}>\n        </tbody>\n    </table>\n    <div class="clear spacer"></div>\n    <{if !empty($nav_menu_client)}>\n        <div class="xo-avatar-pagenav floatright"><{$nav_menu_client}></div>\n        <div class="clear spacer"></div>\n    <{/if}>\n<{/if}>\n<br>\n<!-- Display Avatar form (add,edit) -->\n<{if !empty($form)}>\n    <div class="spacer"><{$form}></div>\n<{/if}>\n'),
(52, '<{include file="db:system_header.tpl"}>\n<{if !empty($install_mods)}>\n    <script type="text/javascript">\n        IMG_ON = "<{xoAdminIcons ''success.png''}>";\n        IMG_OFF = "<{xoAdminIcons ''cancel.png''}>";\n    </script>\n    <div class="floatleft">\n        <img class="cursorpointer tooltip" onclick="system_moduleLargeView();" src="<{xoAdminIcons ''view_large.png''}>"\n             alt="<{$smarty.const._AM_SYSTEM_MODULES_VIEWLARGE}>" title="<{$smarty.const._AM_SYSTEM_MODULES_VIEWLARGE}>"/>\n        <img class="cursorpointer tooltip" onclick="system_moduleListView();" src="<{xoAdminIcons ''view_small.png''}>"\n             alt="<{$smarty.const._AM_SYSTEM_MODULES_VIEWLINE}>" title="<{$smarty.const._AM_SYSTEM_MODULES_VIEWLINE}>"/>\n    </div>\n    <div class="floatright">\n        <div class="xo-buttons">\n            <a class="ui-corner-all tooltip" href="admin.php?fct=modulesadmin&amp;op=installlist" title="<{$smarty.const._AM_SYSTEM_MODULES_TOINSTALL}>">\n                <img src="<{xoAdminIcons ''install.png''}>" alt="<{$smarty.const._AM_SYSTEM_MODULES_TOINSTALL}>"/>\n                <{$smarty.const._AM_SYSTEM_MODULES_TOINSTALL}>&nbsp;<span class="red">(<{$toinstall_nb}>)</span></a>\n        </div>\n    </div>\n    <div class="clear spacer"></div>\n    <form action="admin.php" method="post" name="moduleadmin">\n        <table id="xo-module-sort" class="outer" cellspacing="1">\n            <thead>\n            <tr class="txtcenter">\n                <th><{$smarty.const._AM_SYSTEM_MODULES_MODULE}></th>\n                <th><{$smarty.const._AM_SYSTEM_MODULES_VERSION}></th>\n                <th><{$smarty.const._AM_SYSTEM_MODULES_LASTUP}></th>\n                <th><{$smarty.const._AM_SYSTEM_MODULES_ACTIVE}></th>\n                <th><{$smarty.const._AM_SYSTEM_MODULES_MENU}></th>\n                <th><{$smarty.const._AM_SYSTEM_MODULES_ACTION}></th>\n            </tr>\n            </thead>\n            <tbody>\n            <{foreach item=row from=$install_mods|default:null}>\n                <{if $row.dirname == ''system''}>\n                    <tr class="txtcenter foot">\n                        <td>\n                            <a class="xo-logonormal tooltip" href="<{$xoops_url}>/modules/<{$row.dirname}>/<{$row.adminindex}>" title="<{$row.name}>">\n                                <img src="<{$xoops_url}>/modules/<{$row.dirname}>/<{$row.image}>" alt="<{$row.name}>"/></a>\n\n                            <div class="spacer xo-modsimages">\n                                <a class="tooltip" href="<{$xoops_url}>/modules/<{$row.dirname}>/<{$row.adminindex}>" title="<{$row.name}>">\n                                    <img class="xo-mods hide" src="<{xoAdminIcons ''applications.png''}>" alt="<{$row.name}>" title="<{$row.name}>"/></a>\n                                <input type="text" name="newname[<{$row.mid}>]" value="<{$row.name}>" maxlength="150" size="20"/>\n                                <input type="hidden" name="oldname[<{$row.mid}>]" value="<{$row.name}>"/>\n                            </div>\n                        </td>\n                        <td>\n                            <{if $row.warning_update == 1}>\n                                <strong class="red"><{$row.version}></strong>\n                            <{else}>\n                                <{$row.version}>\n                            <{/if}>\n                        </td>\n                        <td><{$row.last_update}></td>\n                        <td class="xo-modsimages"></td>\n                        <td class="xo-modsimages"></td>\n                        <td class="xo-modsimages">\n                            <{if $row.isactive == 1}>\n                                <a class="tooltip" href="<{$xoops_url}>/modules/system/admin.php?fct=modulesadmin&amp;op=update&amp;module=<{$row.dirname}>"\n                                   title="<{$smarty.const._AM_SYSTEM_MODULES_UPDATE}>">\n                                    <{if $row.warning_update == 1}>\n                                        <img src="<{xoAdminIcons ''messagebox_warning.png''}>" alt="<{$smarty.const._AM_SYSTEM_MODULES_UPDATE}>"/></a>\n                                    <{else}>\n                                        <img src="<{xoAdminIcons ''reload.png''}>" alt="<{$smarty.const._AM_SYSTEM_MODULES_UPDATE}>"/></a>\n                                    <{/if}>\n                            <{/if}>\n                            <img class="cursorpointer tooltip" onclick="display_dialog(<{$row.mid}>, true, true, ''slide'', ''slide'', 240, 450);"\n                                 src="<{xoAdminIcons ''info.png''}>" alt="<{$smarty.const._INFO}>" title="<{$smarty.const._INFO}>"/>\n                            <input type="hidden" name="module[]" value="<{$row.mid}>"/>\n                        </td>\n                    </tr>\n                <{/if}>\n            <{/foreach}>\n            <tr class="head">\n                <td colspan="6"></td>\n            </tr>\n            </tbody>\n            <tbody class="xo-module">\n            <{foreach item=row from=$install_mods|default:null}>\n                <{if $row.dirname != ''system'' && $row.hasmain}>\n                    <tr id="mod_<{$row.mid}>" class="<{if $row.dirname == ''system''}>xo-system <{/if}>txtcenter <{cycle values=''odd, even''}>">\n                        <td>\n                            <{if $row.hasadmin == 1 && $row.isactive == 1}>\n                                <a class="xo-logonormal tooltip" href="<{$xoops_url}>/modules/<{$row.dirname}>/<{$row.adminindex}>" title="<{$row.name}>">\n                                    <img src="<{$xoops_url}>/modules/<{$row.dirname}>/<{$row.image}>" alt="<{$row.name}>"/></a>\n                            <{else}>\n                                <img class="xo-logonormal tooltip" src="<{$xoops_url}>/modules/<{$row.dirname}>/<{$row.image}>" alt="<{$row.name}>"\n                                     title="<{$row.name}>"/>\n                            <{/if}>\n                            <div class="spacer xo-modsimages">\n                                <{if $row.hasadmin == 1 && $row.isactive == 1}>\n                                    <a class="tooltip" href="<{$xoops_url}>/modules/<{$row.dirname}>/<{$row.adminindex}>" title="<{$row.name}>">\n                                        <img class="xo-mods hide" src="<{xoAdminIcons ''applications.png''}>" alt="<{$row.name}>" title="<{$row.name}>"/></a>\n                                <{else}>\n                                    <img class="xo-mods hide tooltip" src="<{xoAdminIcons ''applications.png''}>" alt="<{$row.name}>" title="<{$row.name}>"/>\n                                <{/if}>\n                                <input type="text" name="newname[<{$row.mid}>]" value="<{$row.name}>" maxlength="150" size="20"/>\n                                <input type="hidden" name="oldname[<{$row.mid}>]" value="<{$row.name}>"/>\n                            </div>\n                        </td>\n                        <td>\n                            <{if $row.warning_update == 1}>\n                                <a class="tooltip maxi" style="color:red;"\n                                   href="<{$xoops_url}>/modules/system/admin.php?fct=modulesadmin&amp;op=update&amp;module=<{$row.dirname}>"\n                                   title="<{$smarty.const._AM_SYSTEM_MODULES_UPDATE}>"><{$row.version}></a>\n                                <br>\n                                <{$smarty.const._AM_SYSTEM_MODULES_UPDATE}>\n                            <{else}>\n                                <{$row.version}>\n                            <{/if}>\n                        </td>\n                        <td><{$row.last_update}></td>\n                        <td class="xo-modsimages">\n                            <img id="loading_active<{$row.mid}>" src="images/spinner.gif" style="display:none;" alt="<{$smarty.const._AM_SYSTEM_LOADING}>"/>\n                            <img class="cursorpointer tooltip" id="active<{$row.mid}>"\n                                 onclick="system_setStatus( { fct: ''modulesadmin'', op: ''display'', mid: <{$row.mid}> }, ''active<{$row.mid}>'', ''admin.php'' )"\n                                 src="<{if $row.isactive}><{xoAdminIcons ''success.png''}><{else}><{xoAdminIcons ''cancel.png''}><{/if}>"\n                                 alt="<{if $row.isactive}><{$smarty.const._AM_SYSTEM_MODULES_DEACTIVATE}><{else}><{$smarty.const._AM_SYSTEM_MODULES_ACTIVATE}><{/if}>"\n                                 title="<{if $row.isactive}><{$smarty.const._AM_SYSTEM_MODULES_DEACTIVATE}><{else}><{$smarty.const._AM_SYSTEM_MODULES_ACTIVATE}><{/if}>"/>\n                        </td>\n                        <td class="xo-modsimages">\n                            <img id="loading_menu<{$row.mid}>" src="images/spinner.gif" style="display:none;" title="<{$smarty.const._AM_SYSTEM_LOADING}>"\n                                 alt="<{$smarty.const._AM_SYSTEM_LOADING}>"/>\n                            <img class="cursorpointer tooltip" id="menu<{$row.mid}>"\n                                 onclick="system_setStatus( { fct: ''modulesadmin'', op: ''display_in_menu'', mid: <{$row.mid}> }, ''menu<{$row.mid}>'', ''admin.php'' )"\n                                 src="<{if $row.weight != 0}><{xoAdminIcons ''success.png''}><{else}><{xoAdminIcons ''cancel.png''}><{/if}>"\n                                 alt="<{if $row.weight != 0}><{$smarty.const._AM_SYSTEM_MODULES_HIDE}><{else}><{$smarty.const._AM_SYSTEM_MODULES_SHOW}><{/if}>"\n                                 title="<{if $row.weight != 0}><{$smarty.const._AM_SYSTEM_MODULES_HIDE}><{else}><{$smarty.const._AM_SYSTEM_MODULES_SHOW}><{/if}>"/>\n                        </td>\n                        <td class="xo-modsimages">\n                            <{if $row.isactive == 1}>\n                                <a class="tooltip" href="<{$xoops_url}>/modules/system/admin.php?fct=modulesadmin&amp;op=update&amp;module=<{$row.dirname}>"\n                                   title="<{$smarty.const._AM_SYSTEM_MODULES_UPDATE}>">\n                                    <{if $row.warning_update == 1}>\n                                        <img src="<{xoAdminIcons ''messagebox_warning.png''}>" alt="<{$smarty.const._AM_SYSTEM_MODULES_UPDATE}>"/></a>\n                                    <{else}>\n                                        <img src="<{xoAdminIcons ''reload.png''}>" alt="<{$smarty.const._AM_SYSTEM_MODULES_UPDATE}>"/></a>\n                                    <{/if}>\n                            <{/if}>\n                            <a class="tooltip" href="<{$xoops_url}>/modules/system/admin.php?fct=modulesadmin&amp;op=uninstall&amp;module=<{$row.dirname}>"\n                               title="<{$smarty.const._AM_SYSTEM_MODULES_UNINSTALL}>">\n                                <img src="<{xoAdminIcons ''uninstall.png''}>" alt="<{$smarty.const._AM_SYSTEM_MODULES_UNINSTALL}>"/></a>\n                            <img class="cursorpointer tooltip" onclick="display_dialog(<{$row.mid}>, true, true, ''slide'', ''slide'', 240, 450);"\n                                 src="<{xoAdminIcons ''info.png''}>" alt="<{$smarty.const._INFO}>" title="<{$smarty.const._INFO}>"/>\n                            <input type="hidden" name="module[]" value="<{$row.mid}>"/>\n                        </td>\n                    </tr>\n                <{/if}>\n            <{/foreach}>\n            </tbody>\n            <tbody>\n            <tr class="head">\n                <td colspan="6"></td>\n            </tr>\n            <{foreach item=row from=$install_mods|default:null}>\n                <{if $row.dirname != ''system'' && !$row.hasmain}>\n                    <tr class="txtcenter foot">\n                        <td>\n                            <a class="xo-logonormal tooltip" href="<{$xoops_url}>/modules/<{$row.dirname}>/<{$row.adminindex}>" title="<{$row.name}>">\n                                <img src="<{$xoops_url}>/modules/<{$row.dirname}>/<{$row.image}>" alt="<{$row.name}>"/></a>\n\n                            <div class="spacer xo-modsimages">\n                                <a class="tooltip" href="<{$xoops_url}>/modules/<{$row.dirname}>/<{$row.adminindex}>" title="<{$row.name}>">\n                                    <img class="xo-mods hide" src="<{xoAdminIcons ''applications.png''}>" alt="<{$row.name}>" title="<{$row.name}>"/></a>\n                                <input type="text" name="newname[<{$row.mid}>]" value="<{$row.name}>" maxlength="150" size="20"/>\n                                <input type="hidden" name="oldname[<{$row.mid}>]" value="<{$row.name}>"/>\n                            </div>\n                        </td>\n                        <td>\n                            <{if $row.warning_update == 1}>\n                                <a class="tooltip maxi" style="color:red;"\n                                   href="<{$xoops_url}>/modules/system/admin.php?fct=modulesadmin&amp;op=update&amp;module=<{$row.dirname}>"\n                                   title="<{$smarty.const._AM_SYSTEM_MODULES_UPDATE}>"><{$row.version}></a>\n                                <br>\n                                <{$smarty.const._AM_SYSTEM_MODULES_UPDATE}>\n                            <{else}>\n                                <{$row.version}>\n                            <{/if}>\n                        </td>\n                        <td><{$row.last_update}></td>\n                        <td class="xo-modsimages"><img id="loading_mid<{$row.mid}>" src="images/spinner.gif" style="display:none;"\n                                                       title="<{$smarty.const._AM_SYSTEM_LOADING}>" alt="<{$smarty.const._AM_SYSTEM_LOADING}>"/><img\n                                    class="cursorpointer tooltip" id="mid<{$row.mid}>"\n                                    onclick="system_setStatus( { fct: ''modulesadmin'', op: ''display'', mid: <{$row.mid}> }, ''mid<{$row.mid}>'', ''admin.php'' )"\n                                    src="<{if $row.isactive}><{xoAdminIcons ''success.png''}><{else}><{xoAdminIcons ''cancel.png''}><{/if}>"\n                                    alt="<{if $row.isactive}><{$smarty.const._AM_SYSTEM_MODULES_DEACTIVATE}><{else}><{$smarty.const._AM_SYSTEM_MODULES_ACTIVATE}><{/if}>"\n                                    title="<{if $row.isactive}><{$smarty.const._AM_SYSTEM_MODULES_DEACTIVATE}><{else}><{$smarty.const._AM_SYSTEM_MODULES_ACTIVATE}><{/if}>"/>\n                        </td>\n                        <td class="xo-modsimages"></td>\n                        <td class="xo-modsimages">\n                            <{if $row.isactive == 1}>\n                                <a class="tooltip" href="<{$xoops_url}>/modules/system/admin.php?fct=modulesadmin&amp;op=update&amp;module=<{$row.dirname}>"\n                                   title="<{$smarty.const._AM_SYSTEM_MODULES_UPDATE}>">\n                                    <img src="<{xoAdminIcons ''reload.png''}>" alt="<{$smarty.const._AM_SYSTEM_MODULES_UPDATE}>"/></a>\n                            <{/if}>\n                            <a class="tooltip" href="<{$xoops_url}>/modules/system/admin.php?fct=modulesadmin&amp;op=uninstall&amp;module=<{$row.dirname}>"\n                               title="<{$smarty.const._AM_SYSTEM_MODULES_UNINSTALL}>">\n                                <img src="<{xoAdminIcons ''uninstall.png''}>" alt="<{$smarty.const._AM_SYSTEM_MODULES_UNINSTALL}>"/></a>\n                            <img class="cursorpointer tooltip" onclick="display_dialog(<{$row.mid}>, true, true, ''slide'', ''slide'', 240, 450);"\n                                 src="<{xoAdminIcons ''info.png''}>" alt="<{$smarty.const._INFO}>" title="<{$smarty.const._INFO}>"/>\n                            <input type="hidden" name="module[]" value="<{$row.mid}>"/>\n                        </td>\n                    </tr>\n                <{/if}>\n            <{/foreach}>\n            </tbody>\n            <tfoot>\n            <tr class="txtcenter foot">\n                <td colspan="6">\n                    <input type="hidden" name="fct" value="modulesadmin"/>\n                    <input type="hidden" name="op" value="confirm"/>\n                    <input class="xo-formbuttons" type="submit" name="submit" value="<{$smarty.const._AM_SYSTEM_MODULES_SUBMIT}>"/>\n                </td>\n            </tr>\n            </tfoot>\n        </table>\n        <{securityToken}>\n    </form>\n<{/if}>\n\n<{if !empty($toinstall_mods)}>\n    <div class="floatleft">\n        <img class="cursorpointer tooltip" onclick="system_moduleLargeView();" src="<{xoAdminIcons ''view_large.png''}>"\n             alt="<{$smarty.const._AM_SYSTEM_MODULES_VIEWLARGE}>" title="<{$smarty.const._AM_SYSTEM_MODULES_VIEWLARGE}>"/>\n        <img class="cursorpointer tooltip" onclick="system_moduleListView();" src="<{xoAdminIcons ''view_small.png''}>"\n             alt="<{$smarty.const._AM_SYSTEM_MODULES_VIEWLINE}>" title="<{$smarty.const._AM_SYSTEM_MODULES_VIEWLINE}>"/>\n    </div>\n    <div class="clear spacer"></div>\n    <table class="outer" cellspacing="1">\n        <thead>\n        <tr class="txtcenter">\n            <th><{$smarty.const._AM_SYSTEM_MODULES_MODULE}></th>\n            <th><{$smarty.const._AM_SYSTEM_MODULES_VERSION}></th>\n            <th><{$smarty.const._AM_SYSTEM_MODULES_ACTION}></th>\n        </tr>\n        </thead>\n        <tbody>\n        <{foreach item=row from=$toinstall_mods|default:null}>\n            <tr class="txtcenter <{cycle values=''odd, even''}>">\n                <td>\n                    <img class="xo-logonormal" src="<{$xoops_url}>/modules/<{$row.dirname}>/<{$row.image}>" alt="<{$row.name}>" title="<{$row.name}>"/>\n\n                    <div class="spacer xo-modsimages">\n                        <{if (!empty($row.hasadmin) && $row.hasadmin == 1) && (!empty($row.isactive) && $row.isactive == 1)}>\n                            <a class="tooltip" href="<{$xoops_url}>/modules/<{$row.dirname}>/<{$row.adminindex}>" title="<{$row.name}>">\n                                <img class="xo-mods hide" src="<{xoAdminIcons ''applications.png''}>" alt="<{$row.name}>" title="<{$row.name}>"/></a>\n                        <{else}>\n                            <img class="xo-mods hide tooltip" src="<{xoAdminIcons ''applications.png''}>" alt="<{$row.name}>" title="<{$row.name}>"/>\n                        <{/if}>\n                        <span class="spacer bold"><{$row.name}></span>\n                    </div>\n                </td>\n                <td><{$row.version}></td>\n                <td class="xo-modsimages">\n                    <a class="tooltip" href="<{$xoops_url}>/modules/system/admin.php?fct=modulesadmin&amp;op=install&amp;module=<{$row.dirname}>"\n                       title="<{$smarty.const._AM_SYSTEM_MODULES_INSTALL}>">\n                        <img src="<{xoAdminIcons ''install.png''}>" alt="<{$smarty.const._AM_SYSTEM_MODULES_INSTALL}>"/></a>\n                    <img class="cursorpointer tooltip" onclick="display_dialog(<{$row.mid}>, true, true, ''slide'', ''slide'', 240, 450);"\n                         src="<{xoAdminIcons ''info.png''}>" alt="<{$smarty.const._INFO}>" title="<{$smarty.const._INFO}>"/>\n                </td>\n            </tr>\n        <{/foreach}>\n        </tbody>\n    </table>\n<{/if}>\n<!--Pop-pup-->\n<{foreach item=row from=$mods_popup|default:null}>\n    <div id="dialog<{$row.mid}>" title="<{$row.name}>" style=''display:none;''>\n        <table>\n            <tr>\n                <td class="width10 aligntop">\n                    <img src="<{$xoops_url}>/modules/<{$row.dirname}>/<{$row.image}>" alt="<{$row.name}>" title="<{$row.name}>"/>\n                </td>\n                <td>\n                    <ul class="xo-moduleinfos">\n                        <li><span class="bold"><{$smarty.const._VERSION}></span>&nbsp;:&nbsp;<{$row.version}></li>\n                        <li><span class="bold"><{$smarty.const._AUTHOR}></span>&nbsp;:&nbsp;<{$row.author}></li>\n                        <li><span class="bold"><{$smarty.const._CREDITS}></span>&nbsp;:&nbsp;<{$row.credits}></li>\n                        <li><span class="bold"><{$smarty.const._LICENCE}></span>&nbsp;:&nbsp;<{$row.license}></li>\n                    </ul>\n                </td>\n            </tr>\n        </table>\n        <p><{$row.description}></p>\n    </div>\n<{/foreach}>\n<!--Pop-pup-->\n'),
(53, '<{include file="db:system_header.tpl"}>\n<{if isset($modifs_mods)}>\n    <form action="admin.php" method="post">\n        <table class="outer" cellspacing="1">\n            <thead>\n            <tr class="txtcenter">\n                <th><{$smarty.const._AM_SYSTEM_MODULES_MODULE}></th>\n                <th><{$smarty.const._AM_SYSTEM_MODULES_ACTION}></th>\n                <th><{$smarty.const._AM_SYSTEM_MODULES_ORDER}></th>\n            </tr>\n            </thead>\n            <tbody>\n            <{foreach item=row from=$modifs_mods|default:null}>\n                <tr class="txtcenter <{cycle values=''odd, even''}>">\n                    <td>\n                        <{$row.oldname}>\n                        <{if $row.oldname != $row.newname}>\n                            <span class="bold red">&nbsp;&raquo;&nbsp;<{$row.newname}></span>\n                        <{/if}>\n                    </td>\n                    <td>\n                        <{if $row.oldstatus != $row.newstatus}>\n                            <{if $row.newstatus == 1}>\n                                <div class="bold red"><{$smarty.const._AM_SYSTEM_MODULES_ACTIVATE}></div>\n                            <{else}>\n                                <div class="bold red"><{$smarty.const._AM_SYSTEM_MODULES_DEACTIVATE}></div>\n                            <{/if}>\n                        <{else}>\n                            <{$smarty.const._AM_SYSTEM_MODULES_NOCHANGE}>\n                        <{/if}>\n                    </td>\n                    <td>\n                        <{if $row.oldweight != $row.weight}>\n                            <div class="bold red"><{$row.weight}></div>\n                        <{else}>\n                            <{$row.weight}>\n                        <{/if}>\n                        <input type="hidden" name="module[]" value="<{$row.mid}>"/>\n                        <input type="hidden" name="oldname[<{$row.mid}>]" value="<{$row.oldname}>"/>\n                        <input type="hidden" name="newname[<{$row.mid}>]" value="<{$row.newname}>"/>\n                        <input type="hidden" name="oldstatus[<{$row.mid}>]" value="<{$row.oldstatus}>"/>\n                        <input type="hidden" name="newstatus[<{$row.mid}>]" value="<{$row.newstatus}>"/>\n                        <input type="hidden" name="oldweight[<{$row.mid}>]" value="<{$row.oldweight}>"/>\n                        <input type="hidden" name="weight[<{$row.mid}>]" value="<{$row.weight}>"/>\n                    </td>\n                </tr>\n            <{/foreach}>\n            </tbody>\n            <tfoot>\n            <tr class="txtcenter foot">\n                <td colspan="3">\n                    <input class="formButton" type="submit" value="<{$smarty.const._AM_SYSTEM_MODULES_SUBMIT}>"/>&nbsp;\n                    <input class="formButton" type="button" value="<{$smarty.const._AM_SYSTEM_MODULES_CANCEL}>"\n                           onclick="location=''admin.php?fct=modulesadmin''"/>\n                    <input type="hidden" name="fct" value="modulesadmin"/>\n                    <input type="hidden" name="op" value="submit"/>\n                    <{$input_security}>\n                </td>\n            </tr>\n            </tfoot>\n        </table>\n    </form>\n<{else}>\n    <div id="xo-module-log">\n        <{if isset($result)}>\n            <div class="logger">\n                <{foreach item=row from=$result|default:null}>\n                    <div class="spacer"><{$row}></div>\n                <{/foreach}>\n            </div>\n        <{/if}>\n        <a href="admin.php?fct=modulesadmin"><{$smarty.const._AM_SYSTEM_MODULES_BTOMADMIN}></a>\n    </div>\n<{/if}>\n'),
(54, '<!-- Header -->\n<{include file="db:system_header.tpl"}>\n<script type="text/javascript">\n    IMG_ON = ''<{xoAdminIcons ''success.png''}>'';\n    IMG_OFF = ''<{xoAdminIcons ''cancel.png''}>'';\n</script>\n<!-- Buttons -->\n<{if isset($type) && $type == ''s''}>\n    <div style="height: 30px;">\n        <div class="floatright">\n            <div class="xo-buttons" >\n                <button id="xo-addavatar-btn" class="ui-corner-all tooltip" onclick=''location="admin.php?fct=avatars&amp;op=multiupload"''\n                        title="<{$smarty.const._AM_SYSTEM_AVATAR_MULTIUPLOAD}>">\n                    <img src="<{xoAdminIcons ''add.png''}>" alt="<{$smarty.const._AM_SYSTEM_AVATAR_MULTIUPLOAD}>"/>\n                    <{$smarty.const._AM_SYSTEM_AVATAR_MULTIUPLOAD}>\n                </button>\n            </div>\n        </div>\n    </div>\n<{/if}>\n<{if !empty($view_cat)}>\n    <!-- Display Avatar header for switch between system & custom category -->\n    <table class="outer" cellspacing="1">\n        <thead>\n        <tr>\n            <th class="txtcenter"><{$smarty.const._AM_SYSTEM_AVATAR_SYSTEM}></th>\n            <th class="txtcenter"><{$smarty.const._AM_SYSTEM_AVATAR_CUSTOM}></th>\n        </tr>\n        </thead>\n        <tbody>\n        <tr class="odd">\n            <td class="txtcenter">\n                <a class="tooltip" href="admin.php?fct=avatars&amp;op=listavt&amp;type=s" title="<{$smarty.const._AM_SYSTEM_AVATAR_SYSTEM}>">\n                    <img src="<{xoAdminIcons ''avatar_system.png''}>" alt="<{$smarty.const._AM_SYSTEM_AVATAR_SYSTEM}>"/>\n                </a>\n\n                <div class="spacer"><{$smarty.const._AM_SYSTEM_AVATAR_SYSTEM}>&nbsp;:&nbsp;<strong><{$count_system}></strong></div>\n            </td>\n            <td class="txtcenter">\n                <a class="tooltip" href="admin.php?fct=avatars&amp;op=listavt&amp;type=c" title="<{$smarty.const._AM_SYSTEM_AVATAR_CUSTOM}>">\n                    <img src="<{xoAdminIcons ''avatar_custom.png''}>" alt="<{$smarty.const._AM_SYSTEM_AVATAR_CUSTOM}>"/>\n                </a>\n\n                <div class="spacer"><{$smarty.const._AM_SYSTEM_AVATAR_CUSTOM}>&nbsp;:&nbsp;<strong><{$count_custom}></strong></div>\n            </td>\n        </tr>\n        </tbody>\n    </table>\n    <br>\n<{/if}>\n<!-- Display Avatar list for each category -->\n<{if !empty($avatars_list)}>\n    <{foreach item=avatar from=$avatars_list|default:null}>\n        <div class="floatleft">\n            <div class="ui-corner-all xo-thumb txtcenter">\n                <div class="xo-thumbimg">\n                    <img class="tooltip" src="<{$xoops_url}>/uploads/<{$avatar.avatar_file}>"\n                         alt="<{$avatar.avatar_name}>" title="<{$avatar.avatar_name}>"/>\n                </div>\n                <div class="xo-actions txtcenter">\n                    <div class="spacer bold"><{$avatar.avatar_name}></div>\n                    <img id="loading_avt<{$avatar.avatar_id}>" src="images/spinner.gif" style="display:none;" title="<{$smarty.const._AM_SYSTEM_LOADING}>"\n                         alt="<{$smarty.const._AM_SYSTEM_LOADING}>"/><img class="tooltip" id="avt<{$avatar.avatar_id}>"\n                                                                          onclick="system_setStatus( { fct: ''avatars'', op: ''display'', avatar_id: <{$avatar.avatar_id}> }, ''avt<{$avatar.avatar_id}>'', ''admin.php'' )"\n                                                                          src="<{if $avatar.avatar_display}><{xoAdminIcons ''success.png''}><{else}><{xoAdminIcons ''cancel.png''}><{/if}>"\n                                                                          alt="<{$smarty.const._IMGDISPLAY}>" title="<{$smarty.const._IMGDISPLAY}>"/>\n                    <{if $avatar.type == ''c''}>\n                        <a href="<{$xoops_url}>/modules/profile/userinfo.php?uid=<{$avatar.user}>" title="<{$smarty.const._AM_SYSTEM_AVATAR_USERS}>">\n                            <img src="<{xoAdminIcons ''edit.png''}>" alt="<{$smarty.const._AM_SYSTEM_AVATAR_USERS}>"/>\n                        </a>\n                    <{else}>\n                        <img class="cursorhelp tooltip" src="<{xoAdminIcons ''forum.png''}>" alt="<{$avatar.count}> <{$smarty.const._AM_SYSTEM_AVATAR_USERS}>"\n                             title="<{$avatar.count}> <{$smarty.const._AM_SYSTEM_AVATAR_USERS}>"/>\n                    <{/if}>\n                    <a class="tooltip" href="admin.php?fct=avatars&amp;op=edit&amp;avatar_id=<{$avatar.avatar_id}>" title="<{$smarty.const._EDIT}>">\n                        <img src="<{xoAdminIcons ''edit.png''}>" alt="<{$smarty.const._EDIT}>"/>\n                    </a>\n                    <a class="tooltip" href="admin.php?fct=avatars&amp;op=delfile&amp;avatar_id=<{$avatar.avatar_id}>" title="<{$smarty.const._DELETE}>">\n                        <img src="<{xoAdminIcons ''delete.png''}>" alt="<{$smarty.const._DELETE}>"/>\n                    </a>\n                </div>\n            </div>\n        </div>\n    <{/foreach}>\n    <!-- Display Avatars navigation -->\n    <div class="clear">&nbsp;</div>\n    <{if !empty($nav_menu)}>\n        <div class="xo-pagenav floatright"><{$nav_menu}></div>\n        <div class="clear spacer"></div>\n    <{/if}>\n<{/if}>\n\n<{if !empty($multiupload)}>\n    <div class="floatright">\n        <div class="xo-buttons">\n            <button id="xo-addavatar-btn" class="ui-corner-all tooltip" onclick=''location="admin.php?fct=avatars&amp;op=listavt&amp;type=s"''\n                    title="<{$smarty.const._AM_SYSTEM_AVATAR_SYSTEM}>">\n                <img src="<{xoAdminIcons ''view.png''}>" alt="<{$smarty.const._AM_SYSTEM_AVATAR_SYSTEM}>"/>\n                <{$smarty.const._AM_SYSTEM_AVATAR_SYSTEM}>\n            </button>\n        </div>\n    </div>\n    <div class="clear">&nbsp;</div>\n    <{include file="db:system_trigger_uploads.tpl"}>\n    <h2><{$smarty.const._AM_SYSTEM_AVATAR_SYSTEM}></h2>\n    <div id="fine-uploader-manual-trigger"></div>\n    <div><{$smarty.const._IMGMAXSIZE}> <{$imgcat_maxsize}></div>\n    <div><{$smarty.const._IMGMAXWIDTH}> <{$imgcat_maxwidth}></div>\n    <div><{$smarty.const._IMGMAXHEIGHT}> <{$imgcat_maxheight}></div>\n    <!-- Your code to create an instance of Fine Uploader and bind to the DOM/template\n    ====================================================================== -->\n    <script>\n        var manualUploader = new qq.FineUploader({\n            element: document.getElementById(''fine-uploader-manual-trigger''),\n            template: ''qq-template-manual-trigger'',\n            request: {\n                endpoint: ''<{$xoops_url}>/ajaxfineupload.php'',\n                params: {\n                    "Authorization": "<{$jwt}>"\n                }\n            },\n            text: {\n                formatProgress: "<{$smarty.const._FORMATPROGRESS}>",\n                failUpload: "<{$smarty.const._FAILUPLOAD}>",\n                waitingForResponse: "<{$smarty.const._WAITINGFORRESPONSE}>",\n                paused: "<{$smarty.const._PAUSED}>"\n            },\n            messages: {\n                typeError: "<{$smarty.const._TYPEERROR}>",\n                sizeError: "<{$smarty.const._SIZEERROR}>",\n                minSizeError: "<{$smarty.const._MINSIZEERROR}>",\n                emptyError: "<{$smarty.const._EMPTYERROR}>",\n                noFilesError: "<{$smarty.const._NOFILESERROR}>",\n                tooManyItemsError: "<{$smarty.const._TOOMANYITEMSERROR}>",\n                maxHeightImageError: "<{$smarty.const._MAXHEIGHTIMAGEERROR}>",\n                maxWidthImageError: "<{$smarty.const._MAXWIDTHIMAGEERROR}>",\n                minHeightImageError: "<{$smarty.const._MINHEIGHTIMAGEERROR}>",\n                minWidthImageError: "<{$smarty.const._MINWIDTHIMAGEERROR}>",\n                retryFailTooManyItems: "<{$smarty.const._RETRYFAILTOOMANYITEMS}>",\n                onLeave: "<{$smarty.const._ONLEAVE}>",\n                unsupportedBrowserIos8Safari: "<{$smarty.const._UNSUPPORTEDBROWSERIOS8SAFARI}>"\n            },\n            thumbnails: {\n                placeholders: {\n                    waitingPath: ''<{$xoops_url}>/media/fine-uploader/placeholders/waiting-generic.png'',\n                    notAvailablePath: ''<{$xoops_url}>/media/fine-uploader/placeholders/not_available-generic.png''\n                }\n            },\n            validation: {\n                acceptFiles: [''image/jpeg'', ''image/gif'', ''image/png''],\n                allowedExtensions: [''jpeg'', ''jpg'', ''png'', ''gif''],\n                image: {\n                    maxHeight: <{$imgcat_maxheight}>,\n                    maxWidth: <{$imgcat_maxwidth}>\n                },\n                sizeLimit: <{$imgcat_maxsize}>\n            },\n            autoUpload: false,\n            callbacks: {\n            onError: function(id, name, errorReason, xhrOrXdr) {\n                 console.log(qq.format("Error uploading {}.  Reason: {}", name, errorReason));\n             }\n         },\n        debug: <{$fineup_debug}>\n        });\n\n        qq(document.getElementById("trigger-upload")).attach("click", function() {\n            manualUploader.uploadStoredFiles();\n        });\n    </script>\n<{/if}>\n\n<!-- Display Avatar form (add,edit) -->\n<{if !empty($form)}>\n    <div class="spacer"><{$form}></div>\n<{/if}>\n<!-- Display Avatar images on edit page -->\n'),
(55, '<!--smilies-->\n<{include file="db:system_header.tpl"}>\n<script type="text/javascript">\n    IMG_ON = "<{xoAdminIcons ''success.png''}>";\n    IMG_OFF = "<{xoAdminIcons ''cancel.png''}>";\n</script>\n<{if isset($smilies_count) && $smilies_count == true}>\n    <div class="floatright">\n        <div class="xo-buttons">\n            <a class="ui-corner-all tooltip" href="admin.php?fct=smilies&amp;op=new_smilie" title="<{$smarty.const._AM_SYSTEM_SMILIES_ADD}>">\n                <img src="<{xoAdminIcons ''add.png''}>" alt="<{$smarty.const._AM_SYSTEM_SMILIES_ADD}>"/>\n                <{$smarty.const._AM_SYSTEM_SMILIES_ADD}>\n            </a>\n        </div>\n    </div>\n    <table id="xo-smilies-sorter" cellspacing="1" class="outer tablesorter">\n        <thead>\n        <tr>\n            <th class="txtcenter"><{$smarty.const._AM_SYSTEM_SMILIES_CODE}></th>\n            <th class="txtcenter"><{$smarty.const._AM_SYSTEM_SMILIES_SMILIE}></th>\n            <th class="txtcenter"><{$smarty.const._AM_SYSTEM_SMILIES_DESCRIPTION}></th>\n            <th class="txtcenter"><{$smarty.const._AM_SYSTEM_SMILIES_DISPLAY}></th>\n            <th class="txtcenter width10"><{$smarty.const._AM_SYSTEM_SMILIES_ACTION}></th>\n        </tr>\n        </thead>\n        <tbody>\n        <{foreach item=smiley from=$smilies|default:null}>\n            <tr class="<{cycle values=''even,odd''}> alignmiddle">\n                <td class="txtcenter width5"><{$smiley.code}></td>\n                <td class="txtcenter width5"><{$smiley.image}></td>\n                <td class="txtcenter width50"><{$smiley.emotion}></td>\n                <td class="xo-actions txtcenter width10">\n                    <img id="loading_sml<{$smiley.smilies_id}>" src="images/spinner.gif" style="display:none;" title="<{$smarty.const._AM_SYSTEM_LOADING}>"\n                         alt="<{$smarty.const._AM_SYSTEM_LOADING}>"/><img class="cursorpointer tooltip" id="sml<{$smiley.smilies_id}>"\n                                                                          onclick="system_setStatus( { fct: ''smilies'', op: ''smilies_update_display'', smilies_id: <{$smiley.smilies_id}> }, ''sml<{$smiley.smilies_id}>'', ''admin.php'' )"\n                                                                          src="<{if $smiley.display}><{xoAdminIcons ''success.png''}><{else}><{xoAdminIcons ''cancel.png''}><{/if}>"\n                                                                          alt="<{if $smiley.display}><{$smarty.const._AM_SYSTEM_SMILIES_OFF}><{else}><{$smarty.const._AM_SYSTEM_SMILIES_ON}><{/if}>"\n                                                                          title="<{if $smiley.display}><{$smarty.const._AM_SYSTEM_SMILIES_OFF}><{else}><{$smarty.const._AM_SYSTEM_SMILIES_ON}><{/if}>"/>\n                </td>\n                <td class="xo-actions txtcenter width10">\n                    <a class="tooltip" href="admin.php?fct=smilies&amp;op=edit_smilie&amp;smilies_id=<{$smiley.smilies_id}>"\n                       title="<{$smarty.const._AM_SYSTEM_SMILIES_EDIT}>">\n                        <img src="<{xoAdminIcons ''edit.png''}>" alt="<{$smarty.const._AM_SYSTEM_SMILIES_EDIT}>"/></a>\n                    <a class="tooltip" href="admin.php?fct=smilies&amp;op=smilies_delete&amp;smilies_id=<{$smiley.smilies_id}>"\n                       title="<{$smarty.const._AM_SYSTEM_SMILIES_DELETE}>">\n                        <img src="<{xoAdminIcons ''delete.png''}>" alt="<{$smarty.const._AM_SYSTEM_SMILIES_DELETE}>"/></a>\n                </td>\n            </tr>\n        <{/foreach}>\n        </tbody>\n    </table>\n    <!-- Display smilies navigation -->\n    <div class="clear spacer"></div>\n    <{if !empty($nav_menu)}>\n        <div class="xo-avatar-pagenav floatright"><{$nav_menu}></div>\n        <div class="clear spacer"></div>\n    <{/if}>\n<{/if}>\n<!-- Display smilies form (add,edit) -->\n<{if !empty($form)}>\n    <div class="spacer"><{$form}></div>\n<{/if}>\n');
INSERT INTO `[[dbprefix]]_tplsource` VALUES
(56, '<!-- Breadcrumb Header -->\n<{include file="db:system_header.tpl"}>\n<script type="text/javascript">\n    IMG_ON = "<{xoAdminIcons ''success.png''}>";\n    IMG_OFF = "<{xoAdminIcons ''cancel.png''}>";\n</script>\n<{if !empty($filterform)}>\n    <div class="floatright">\n        <div class="xo-buttons">\n            <button id="xo-add-btn" class="ui-corner-all" onclick="self.location.href=''admin.php?fct=blocksadmin&amp;op=add'';">\n                <img src="<{xoAdminIcons ''add.png''}>" alt="<{$smarty.const._AM_SYSTEM_BLOCKS_ADD}>"/>\n                <{$smarty.const._AM_SYSTEM_BLOCKS_ADD}>\n            </button>\n        </div>\n    </div>\n    <div class="clear"></div>\n    <div id="xo-block-dragndrop">\n        <table class="outer">\n            <tr>\n                <th>\n                    <form name="<{$filterform.name}>" id="<{$filterform.name}>" action="<{$filterform.action}>" method="<{$filterform.method}>"\n                            <{$filterform.extra}> >\n                        <div class="xo-blocksfilter">\n                            <{foreach item=element from=$filterform.elements|default:null}>\n                                <{if $element.hidden != true}>\n                                    <div class="xo-caption"><{$element.caption}></div>\n                                    <div class="xo-element"><{$element.body}></div>\n                                <{else}>\n                                    <{$element.body}>\n                                <{/if}>\n                            <{/foreach}>\n                        </div>\n                    </form>\n                </th>\n            </tr>\n            <tr>\n                <td>\n                    <table id="xo-block-managment">\n                        <tr>\n                            <td side="0" class="xo-blocksection" rowspan="3" id="xo-leftcolumn">\n                                <div class="xo-title"><{$smarty.const._AM_SYSTEM_BLOCKS_SIDELEFT}></div>\n                                <{include file="db:system_blocks_item.tpl" blocks=$blocks side=0}>\n                            </td>\n                            <td side="3" class="xo-blocksection">\n                                <div class="xo-title"><{$smarty.const._AM_SYSTEM_BLOCKS_SIDETOPLEFT}></div>\n                                <{include file="db:system_blocks_item.tpl" blocks=$blocks side=3}>\n                            </td>\n                            <td side="5" class="xo-blocksection">\n                                <div class="xo-title"><{$smarty.const._AM_SYSTEM_BLOCKS_SIDETOPCENTER}></div>\n                                <{include file="db:system_blocks_item.tpl" blocks=$blocks side=5}>\n                            </td>\n                            <td side="4" class="xo-blocksection">\n                                <div class="xo-title"><{$smarty.const._AM_SYSTEM_BLOCKS_SIDETOPRIGHT}></div>\n                                <{include file="db:system_blocks_item.tpl" blocks=$blocks side=4}>\n                            </td>\n                            <td side="1" class="xo-blocksection" rowspan="3" id="xo-rightcolumn">\n                                <div class="xo-title"><{$smarty.const._AM_SYSTEM_BLOCKS_SIDERIGHT}></div>\n                                <{include file="db:system_blocks_item.tpl" blocks=$blocks side=1}>\n                            </td>\n                        </tr>\n                        <tr style="height:30px;">\n                            <td colspan="3" class="xo-blockContent width5">&nbsp;</td>\n                        </tr>\n                        <tr>\n                            <td side="7" class="xo-blocksection">\n                                <div class="xo-title"><{$smarty.const._AM_SYSTEM_BLOCKS_SIDEBOTTOMLEFT}></div>\n                                <{include file="db:system_blocks_item.tpl" blocks=$blocks side=7}>\n                            </td>\n                            <td side="9" class="xo-blocksection">\n                                <div class="xo-title"><{$smarty.const._AM_SYSTEM_BLOCKS_SIDEBOTTOMCENTER}></div>\n                                <{include file="db:system_blocks_item.tpl" blocks=$blocks side=9}>\n                            </td>\n                            <td side="8" class="xo-blocksection">\n                                <div class="xo-title"><{$smarty.const._AM_SYSTEM_BLOCKS_SIDEBOTTOMRIGHT}></div>\n                                <{include file="db:system_blocks_item.tpl" blocks=$blocks side=8}>\n                            </td>\n                        </tr>\n                        <tr>\n                            <!-- Start Footer Blocks (By Timgno) -->\n                            <table id="xo-block-footer">\n                                <tr>\n                                    <td side="10" class="xo-blocksection">\n                                        <div class="xo-title"><{$smarty.const._AM_SYSTEM_BLOCKS_SIDEFOOTERLEFT}></div>\n                                        <{include file="db:system_blocks_item.tpl" blocks=$blocks side=10}>\n                                    </td>\n                                    <td side="12" class="xo-blocksection">\n                                        <div class="xo-title"><{$smarty.const._AM_SYSTEM_BLOCKS_SIDEFOOTERCENTER}></div>\n                                        <{include file="db:system_blocks_item.tpl" blocks=$blocks side=12}>\n                                    </td>\n                                    <td side="11" class="xo-blocksection">\n                                        <div class="xo-title"><{$smarty.const._AM_SYSTEM_BLOCKS_SIDEFOOTERRIGHT}></div>\n                                        <{include file="db:system_blocks_item.tpl" blocks=$blocks side=11}>\n                                    </td>\n                                </tr>\n                            </table>\n                            <!-- End Footer Blocks (By Timgno) -->\n                        </tr>\n                    </table>\n                </td>\n            </tr>\n        </table>\n    </div>\n<{/if}>\n<div id="xo-block-add" <{if !empty($filterform)}>class="hide"<{/if}>>\n    <{if empty($filterform)}><br><{/if}>\n    <{$blockform}>\n</div>\n<!-- Preview block -->\n<div id="xo-preview-block" class="hide"></div>\n'),
(57, '<{foreach item=item from=$blocks|default:null}>\n    <{if $item.side == $side}>\n        <div id="blk_<{$item.bid}>" bid="<{$item.bid}>" side="<{$item.side}>" order="<{$item.weight}>"\n             class="xo-block ui-widget ui-widget-content ui-corner-all">\n            <div class="xo-blocktitle ui-corner-all">\n        <span class="spacer">\n            <img class="xo-imgmini" src="<{xoAdminIcons ''block.png''}>" alt="<{$smarty.const._AM_SYSTEM_BLOCKS_DRAG}>"\n                 title="<{$smarty.const._AM_SYSTEM_BLOCKS_DRAG}>"/>\n        </span>\n<{$item.title}><{if $item.block_type == ''D''}> (<{$item.bid}>)<{/if}>\n            </div>\n            <div class="xo-blockaction xo-actions"><img id="loading_img<{$item.bid}>" src="./images/mimetypes/spinner.gif" style="display:none;"\n                                                        title="<{$smarty.const._AM_SYSTEM_LOADING}>" alt="<{$smarty.const._AM_SYSTEM_LOADING}>"/><img\n                        class="tooltip" id="img<{$item.bid}>"\n                        onclick="system_setStatus( { fct: ''blocksadmin'', op: ''display'', bid: <{$item.bid}>, visible: <{if $item.visible}>0<{else}>1<{/if}> }, ''img<{$item.bid}>'', ''admin.php'' )"\n                        src="<{if $item.visible}><{xoAdminIcons ''success.png''}><{else}><{xoAdminIcons ''cancel.png''}><{/if}>"\n                        alt="<{if $item.visible}><{$smarty.const._AM_SYSTEM_BLOCKS_HIDE}><{else}><{$smarty.const._AM_SYSTEM_BLOCKS_DISPLAY}><{/if}><{$item.name}>"\n                        title="<{if $item.visible}><{$smarty.const._AM_SYSTEM_BLOCKS_HIDE}><{else}><{$smarty.const._AM_SYSTEM_BLOCKS_DISPLAY}><{/if}><{$item.name}>"/>\n                <a class="tooltip" href="admin.php?fct=blocksadmin&amp;op=edit&amp;bid=<{$item.bid}>" title="<{$smarty.const._EDIT}>">\n                    <img src="<{xoAdminIcons ''edit.png''}>" alt="<{$smarty.const._EDIT}>"/></a>\n                <{if $item.block_type != ''S''}>\n                    <a class="tooltip" href="admin.php?fct=blocksadmin&amp;op=delete&amp;bid=<{$item.bid}>" title="<{$smarty.const._DELETE}>">\n                        <img src="<{xoAdminIcons ''delete.png''}>" alt="<{$smarty.const._DELETE}>"/></a>\n                <{/if}>\n                <a class="tooltip" href="admin.php?fct=blocksadmin&amp;op=clone&amp;bid=<{$item.bid}>" title="<{$smarty.const._AM_SYSTEM_BLOCKS_CLONE}>">\n                    <img src="<{xoAdminIcons ''clone.png''}>" alt="<{$smarty.const._AM_SYSTEM_BLOCKS_CLONE}>"/></a>\n            </div>\n        </div>\n    <{/if}>\n<{/foreach}>\n'),
(58, '<{include file="db:system_header.tpl"}>\n<!--Comments-->\n<{if !empty($form)}>\n    <div class="spacer"><{$form}></div>\n<{else}>\n    <div class="floatleft"><{$form_sort}></div>\n    <div class="floatright">\n        <div class="xo-buttons">\n            <button class="ui-corner-all" onclick="self.location.href=''admin.php?fct=comments&op=comments_form_purge''">\n                <img src="<{xoAdminIcons ''clear.png''}>" alt="<{$smarty.const._AM_SYSTEM_COMMENTS_FORM_PURGE}>"/>\n                <{$smarty.const._AM_SYSTEM_COMMENTS_FORM_PURGE}>\n            </button>\n        </div>\n    </div>\n    <div class="clear"></div>\n    <table id="xo-comment-sorter" cellspacing="1" class="outer tablesorter">\n        <thead>\n        <tr>\n            <th class="txtcenter width5"><input name=''allbox'' id=''allbox'' onclick=''xoopsCheckAll("commentslist", "allbox");'' type=''checkbox''\n                                                value=''Check All''/></th>\n            <th class="txtcenter width5"></th>\n            <th class="txtleft"><{$smarty.const._AM_SYSTEM_COMMENTS_TITLE}></th>\n            <th class="txtcenter"><{$smarty.const._AM_SYSTEM_COMMENTS_POSTED}></th>\n            <th class="txtcenter"><{$smarty.const._AM_SYSTEM_COMMENTS_IP}></th>\n            <th class="txtcenter"><{$smarty.const._DATE}></th>\n            <th class="txtcenter"><{$smarty.const._AM_SYSTEM_COMMENTS_MODULE}></th>\n            <th class="txtcenter"><{$smarty.const._AM_SYSTEM_COMMENTS_STATUS}></th>\n            <th class="txtcenter width10"><{$smarty.const._AM_SYSTEM_COMMENTS_ACTION}></th>\n        </tr>\n        </thead>\n        <form name=''commentslist'' id=''commentslist'' action=''<{$php_selft}>'' method="post">\n            <tbody>\n            <{foreach item=comment from=$comments|default:null}>\n                <tr class="<{cycle values=''even,odd''}> alignmiddle">\n                    <td class="txtcenter"><input type=''checkbox'' name=''commentslist_id[]'' id=''commentslist_id[]'' value=''<{$comment.comments_id}>''/></td>\n                    <td class="txtcenter"><{$comment.comments_icon}></td>\n                    <td>\n                        <a href="admin.php?fct=comments&amp;op=comments_jump&amp;com_id=<{$comment.comments_id}>" title="<{$comment.comments_title}>">\n                            <{$comment.comments_title}>\n                        </a>\n                    </td>\n                    <td class="txtcenter"><{$comment.comments_poster}></td>\n                    <td class="txtcenter"><{$comment.comments_ip}></td>\n                    <td class="txtcenter"><{$comment.comments_date}></td>\n                    <td class="txtcenter"><{$comment.comments_modid}></td>\n                    <td class="txtcenter"><{$comment.comments_status}></td>\n                    <td class="xo-actions txtcenter">\n                        <img class="cursorpointer" onclick="display_dialog(''<{$comment.comments_id}>'', true, true, ''slide'', ''slide'', 300, 500);"\n                             src="<{xoAdminIcons ''display.png''}>" alt="<{$smarty.const._AM_SYSTEM_COMMENTS_VIEW}>"\n                             title="<{$smarty.const._AM_SYSTEM_COMMENTS_VIEW}>"/>\n                        <a href="admin/comments/comment_edit.php?com_id=<{$comment.comments_id}>" title="<{$smarty.const._EDIT}>">\n                            <img src="<{xoAdminIcons ''edit.png''}>" alt="<{$smarty.const._EDIT}>"></a>\n                        <a href="admin/comments/comment_delete.php?com_id=<{$comment.comments_id}>" title="<{$smarty.const._DELETE}>">\n                            <img src="<{xoAdminIcons ''delete.png''}>" alt="<{$smarty.const._DELETE}>"></a>\n                    </td>\n                </tr>\n            <{/foreach}>\n            </tbody>\n            <tr>\n                <td><input type=''submit'' name=''<{$smarty.const._DELETE}>'' value=''<{$smarty.const._DELETE}>''/></td>\n                <td colspan="7">&nbsp;</td>\n            </tr>\n        </form>\n    </table>\n    <{foreach item=comment from=$comments_popup|default:null}>\n        <!--Pop-pup-->\n        <div id=''dialog<{$comment.comments_id}>'' title=''<{$comment.comments_title}>'' style=''display:none;''>\n            <img src="<{xoAdminIcons ''comment.png''}>" alt="comments" title="comments" class="xo-commentsimg"/>\n\n            <p><{$comment.comments_text}></p>\n        </div>\n    <{/foreach}>\n    <!--Pop-pup-->\n    <div class="txtright"><{$nav|default:''''}></div>\n<{/if}>\n'),
(59, '<{include file="db:system_header.tpl"}>\n<script type="text/javascript">\n    IMG_ON = "<{xoAdminIcons ''success.png''}>";\n    IMG_OFF = "<{xoAdminIcons ''cancel.png''}>";\n</script>\n<!--User rank-->\n<{if isset($userrank_count) && $userrank_count == true}>\n    <div class="floatright">\n        <div class="xo-buttons">\n            <a class="ui-corner-all tooltip" href="admin.php?fct=userrank&amp;op=userrank_new" title="<{$smarty.const._AM_SYSTEM_USERRANK_ADD}>">\n                <img src="<{xoAdminIcons ''add.png''}>" alt="<{$smarty.const._AM_SYSTEM_USERRANK_ADD}>"/>\n                <{$smarty.const._AM_SYSTEM_USERRANK_ADD}>\n            </a>\n        </div>\n    </div>\n    <table id="xo-rank-sorter" cellspacing="1" class="outer tablesorter">\n        <thead>\n        <tr>\n            <th class="txtcenter"><{$smarty.const._AM_SYSTEM_USERRANK_IMAGE}></th>\n            <th class="txtcenter"><{$smarty.const._AM_SYSTEM_USERRANK_TITLE}></th>\n            <th class="txtcenter"><{$smarty.const._AM_SYSTEM_USERRANK_MINPOST}></th>\n            <th class="txtcenter"><{$smarty.const._AM_SYSTEM_USERRANK_MAXPOST}></th>\n            <th class="txtcenter"><{$smarty.const._AM_SYSTEM_USERRANK_SPECIAL}></th>\n            <th class="txtcenter width10"><{$smarty.const._AM_SYSTEM_USERRANK_ACTION}></th>\n        </tr>\n        </thead>\n        <tbody>\n        <{foreach item=rankinfo from=$userrank|default:null}>\n            <tr class="<{cycle values=''even,odd''}> alignmiddle">\n                <td class="txtcenter"><{$rankinfo.rank_image}></td>\n                <td class="txtcenter"><{$rankinfo.rank_title}></td>\n                <td class="txtcenter"><{$rankinfo.rank_min}></td>\n                <td class="txtcenter"><{$rankinfo.rank_max}></td>\n                <td class="xo-actions txtcenter"><img id="loading_sml<{$rankinfo.rank_id}>" src="images/spinner.gif" style="display:none;"\n                                                      alt="<{$smarty.const._AM_SYSTEM_LOADING}>"/><img class="cursorpointer tooltip"\n                                                                                                       id="sml<{$rankinfo.rank_id}>"\n                                                                                                       onclick="system_setStatus( { fct: ''userrank'', op: ''userrank_update_special'', rank_id: <{$rankinfo.rank_id}> }, ''sml<{$rankinfo.rank_id}>'', ''admin.php'' )"\n                                                                                                       src="<{if $rankinfo.rank_special}><{xoAdminIcons ''success.png''}><{else}><{xoAdminIcons ''cancel.png''}><{/if}>"\n                                                                                                       alt="<{if $rankinfo.rank_special}><{$smarty.const._AM_SYSTEM_USERRANK_OFF}><{else}><{$smarty.const._AM_SYSTEM_USERRANK_ON}><{/if}>"\n                                                                                                       title="<{if $rankinfo.rank_special}><{$smarty.const._AM_SYSTEM_USERRANK_OFF}><{else}><{$smarty.const._AM_SYSTEM_USERRANK_ON}><{/if}>"/>\n                </td>\n                <td class="xo-actions txtcenter">\n                    <a class="tooltip" href="admin.php?fct=userrank&amp;op=userrank_edit&amp;rank_id=<{$rankinfo.rank_id}>"\n                       title="<{$smarty.const._AM_SYSTEM_USERRANK_EDIT}>">\n                        <img src="<{xoAdminIcons ''edit.png''}>" alt="<{$smarty.const._AM_SYSTEM_USERRANK_EDIT}>"/></a>\n                    <a class="tooltip" href="admin.php?fct=userrank&amp;op=userrank_delete&amp;rank_id=<{$rankinfo.rank_id}>"\n                       title="<{$smarty.const._AM_SYSTEM_USERRANK_DELETE}>">\n                        <img src="<{xoAdminIcons ''delete.png''}>" alt="<{$smarty.const._AM_SYSTEM_USERRANK_DELETE}>"/></a>\n                </td>\n            </tr>\n        <{/foreach}>\n        </tbody>\n    </table>\n    <!-- Display rank navigation -->\n    <div class="clear spacer"></div>\n    <{if !empty($nav_menu)}>\n        <div class="xo-avatar-pagenav floatright"><{$nav_menu}></div>\n        <div class="clear spacer"></div>\n    <{/if}>\n<{/if}>\n<!--Display rank form (add,edit)-->\n<{if !empty($form)}>\n    <div class="spacer"><{$form}></div>\n<{/if}>\n\n'),
(60, '<{include file="db:system_header.tpl"}>\n\n<{if isset($users_display) && $users_display == true}>\n    <!--Display form sort-->\n    <div class="xo-headercontent">\n        <div class="floatleft"><{$form_sort}></div>\n        <div class="floatright">\n            <div class="xo-buttons">\n                <a class="ui-corner-all tooltip" href="admin.php?fct=users&amp;op=users_synchronize&amp;status=2"\n                   title="<{$smarty.const._AM_SYSTEM_USERS_SYNCHRONIZE}>">\n                    <img src="<{xoAdminIcons ''reload.png''}>" alt="<{$smarty.const._AM_SYSTEM_USERS_SYNCHRONIZE}>"/>\n                    <{$smarty.const._AM_SYSTEM_USERS_SYNCHRONIZE}>\n                </a>\n                <a class="ui-corner-all tooltip" href="admin.php?fct=users&amp;op=users_add" title="<{$smarty.const._AM_SYSTEM_USERS_ADDUSER}>">\n                    <img src="<{xoAdminIcons ''user_add.png''}>" alt="<{$smarty.const._AM_SYSTEM_USERS_ADDUSER}>"/>\n                    <{$smarty.const._AM_SYSTEM_USERS_ADDUSER}>\n                </a>\n            </div>\n        </div>\n    </div>\n    <div class="clear">&nbsp;</div>\n    <table id="xo-users-sorter" cellspacing="1" class="outer tablesorter">\n        <thead>\n        <tr>\n            <th class="txtcenter width3"><input name=''allbox'' id=''allbox'' onclick=''xoopsCheckAll("memberslist", "allbox");'' type=''checkbox''\n                                                value=''Check All''/></th>\n            <th class="txtcenter width5"><{$smarty.const._AM_SYSTEM_USERS_STATUS}></th>\n            <th class="txtcenter"><{$smarty.const._AM_SYSTEM_USERS_UNAME}></th>\n            <th class="txtcenter"><{$smarty.const._AM_SYSTEM_USERS_REALNAME}></th>\n            <th class="txtcenter"><{$smarty.const._AM_SYSTEM_USERS_EMAIL}></th>\n            <th class="txtcenter"><{$smarty.const._AM_SYSTEM_USERS_REG_DATE}></th>\n            <th class="txtcenter"><{$smarty.const._AM_SYSTEM_USERS_LAST_LOGIN}></th>\n            <th class="txtcenter"><{$smarty.const._AM_SYSTEM_USERS_POSTS}></th>\n            <th class="txtcenter" width=''11%''><{$smarty.const._AM_SYSTEM_USERS_ACTION}></th>\n        </tr>\n        </thead>\n        <!--Display data-->\n        <{if isset($users_count) && $users_count == true}>\n            <form name=''memberslist'' id=''memberslist'' action=''<{xoAppUrl "modules/system/admin.php?fct=users"}>'' method=''POST''>\n                <tbody>\n                <{foreach item=user from=$users|default:null}>\n                    <tr class="<{cycle values=''even,odd''}> alignmiddle">\n                        <td class="txtcenter"><{if $user.checkbox_user}><input type=''checkbox'' name=''memberslist_id[]'' id=''memberslist_id[]''\n                                                                                value=''<{$user.uid}>''/><{/if}>\n                        </td>\n                        <td class="txtcenter"><img class="xo-imgmini" src="<{$user.group}>" alt=""/></td>\n                        <td class="txtcenter"><a title="<{$user.uname}>" href="<{$xoops_url}>/userinfo.php?uid=<{$user.uid}>"><{$user.uname}></a></td>\n                        <td class="txtcenter"><{$user.name}></td>\n                        <td class="txtcenter"><{$user.email}></td>\n                        <td class="txtcenter"><{$user.reg_date}></td>\n                        <td class="txtcenter"><{$user.last_login}></td>\n                        <td class="txtcenter">\n                            <div id="display_post_<{$user.uid}>"><{$user.posts}></div>\n                            <div id=''loading_<{$user.uid}>'' class="txtcenter" style="display:none;"><img src="./images/mimetypes/spinner.gif" title="Loading"\n                                                                                                          alt="Loading" width="12px"/></div>\n                        </td>\n                        <td class="xo-actions txtcenter">\n                            <{if $user.user_level > 0}>\n                                <img class="tooltip" onclick="display_post(''<{$user.uid}>'');" src="<{xoAdminIcons ''reload.png''}>"\n                                     alt="<{$smarty.const._AM_SYSTEM_USERS_SYNCHRONIZE}>" title="<{$smarty.const._AM_SYSTEM_USERS_SYNCHRONIZE}>"/>\n                                <img class="tooltip" onclick="display_dialog(''<{$user.uid}>'', true, true, ''slide'', ''slide'', 300, 400);"\n                                     src="<{xoAdminIcons ''display.png''}>" alt="<{$smarty.const._AM_SYSTEM_USERS_VIEW}>"\n                                     title="<{$smarty.const._AM_SYSTEM_USERS_VIEW}>"/>\n                                <a class="tooltip" href="admin.php?fct=users&amp;op=users_edit&amp;uid=<{$user.uid}>"\n                                   title="<{$smarty.const._AM_SYSTEM_USERS_EDIT}>">\n                                    <img src="<{xoAdminIcons ''edit.png''}>" alt="<{$smarty.const._AM_SYSTEM_USERS_EDIT}>"/></a>\n                                <a class="tooltip" href="admin.php?fct=users&amp;op=users_delete&amp;uid=<{$user.uid}>"\n                                   title="<{$smarty.const._AM_SYSTEM_USERS_DEL}>">\n                                    <img src="<{xoAdminIcons ''delete.png''}>" alt="<{$smarty.const._AM_SYSTEM_USERS_DEL}>"/></a>\n                            <{else}>\n                                <a class="tooltip" href="admin.php?fct=users&amp;op=users_active&amp;uid=<{$user.uid}>"\n                                   title="<{$smarty.const._AM_SYSTEM_USERS_ACTIVE}>">\n                                    <img src="<{xoAdminIcons ''xoops/active_user.png''}>" alt="<{$smarty.const._AM_SYSTEM_USERS_ACTIVE}>"/></a>\n                                <img class="tooltip" onclick="display_dialog(''<{$user.uid}>'', true, true, ''slide'', ''slide'', 300, 400);"\n                                     src="<{xoAdminIcons ''display.png''}>" alt="<{$smarty.const._AM_SYSTEM_USERS_VIEW}>"\n                                     title="<{$smarty.const._AM_SYSTEM_USERS_VIEW}>"/>\n                                <a class="tooltip" href="admin.php?fct=users&amp;op=users_edit&amp;uid=<{$user.uid}>"\n                                   title="<{$smarty.const._AM_SYSTEM_USERS_EDIT}>">\n                                    <img src="<{xoAdminIcons ''edit.png''}>" alt="<{$smarty.const._AM_SYSTEM_USERS_EDIT}>"/></a>\n                                <a class="tooltip" href="admin.php?fct=users&amp;op=users_delete&amp;uid=<{$user.uid}>"\n                                   title="<{$smarty.const._AM_SYSTEM_USERS_DEL}>">\n                                    <img src="<{xoAdminIcons ''delete.png''}>" alt="<{$smarty.const._AM_SYSTEM_USERS_DEL}>"/></a>\n                            <{/if}>\n                        </td>\n                    </tr>\n                <{/foreach}>\n                </tbody>\n                <tr>\n                    <td class=''txtleft'' colspan=''6''>\n                        <select name=''fct'' onChange=''changeDisplay (this.value, "groups", "edit_group")''>\n                            <option value=''''>---------</option>\n                            <option value=''mailusers''><{$smarty.const._AM_SYSTEM_USERS_SENDMAIL}></option>\n                            <option value=''groups''><{$smarty.const._AM_SYSTEM_USERS_EDIT_GROUPS}></option>\n                            <option value=''users''><{$smarty.const._AM_SYSTEM_USERS_DELETE}></option>\n                        </select>&nbsp;\n                        <select name=''edit_group'' id=''edit_group'' onChange=''changeDisplay (this.value, this.value, "selgroups")'' style="display:none;">\n                            <option value=''''>---------</option>\n                            <option value=''add_group''><{$smarty.const._AM_SYSTEM_USERS_ADD_GROUPS}></option>\n                            <option value=''delete_group''><{$smarty.const._AM_SYSTEM_USERS_DELETE_GROUPS}></option>\n                        </select>\n                        <{$form_select_groups}>\n                        <{$form_token}>\n                        <input type="hidden" name="op" value="action_group">\n                        <input type=''submit'' name=''Submit''/>\n                    </td>\n                </tr>\n            </form>\n        <{/if}>\n        <!--No found-->\n        <{if isset($users_no_found) && $users_no_found == true}>\n            <tr class="<{cycle values=''even,odd''}> alignmiddle">\n                <td colspan=''8'' class="txtcenter"><{$smarty.const._AM_SYSTEM_USERS_NO_FOUND}></td>\n            </tr>\n        <{/if}>\n    </table>\n    <!--Pop-pup-->\n    <{if isset($users_count) && $users_count == true}>\n        <{foreach item=users from=$users_popup|default:null}>\n            <div id="dialog<{$users.uid}>" title="<{$users.uname}>" style=''display:none;''>\n                <table>\n                    <tr>\n                        <td class="txtcenter">\n                            <img src="<{$users.user_avatar}>" alt="<{$users.uname}>" title="<{$users.uname}>"/>\n                        </td>\n                        <td class="txtcenter">\n                            <a href=''mailto:<{$users.email}>''><img src="<{xoAdminIcons ''mail_send.png''}>" alt="" title=<{$smarty.const._AM_SYSTEM_USERS_EMAIL}>\n                                /></a>\n                            <a href=''javascript:openWithSelfMain("<{$xoops_url}>/pmlite.php?send2=1&amp;to_userid=<{$users.uid}>","pmlite",565,500);''><img\n                                        src="<{xoAdminIcons ''pm.png''}>" alt="" title="<{$smarty.const._AM_SYSTEM_USERS_PM}>"></a>\n                            <{if !empty($users.url)}><a href=''<{$users.url}>'' rel=''external''><img src="<{xoAdminIcons ''url.png''}>" alt="" title="<{$smarty.const._AM_SYSTEM_USERS_URL}>"></a><{/if}>\n                        </td>\n                    </tr>\n                    <tr>\n                        <td colspan="2">\n                            <ul style="border: 1px solid #666; padding: 8px;">\n                                <{if !empty($users.user_name)}>\n                                    <li><span class="bold"><{$smarty.const._AM_SYSTEM_USERS_NAME}></span>&nbsp;:&nbsp;<{$users.name}></li>\n                                <{/if}>\n                                <li><span class="bold"><{$smarty.const._AM_SYSTEM_USERS_UNAME}></span>&nbsp;:&nbsp;<{$users.uname}></li>\n                                <li><span class="bold"><{$smarty.const._AM_SYSTEM_USERS_EMAIL}></span>&nbsp;:&nbsp;<{$users.email}></li>\n                                <{if !empty($users.user_url)}>\n                                    <li><span class="bold"><{$smarty.const._AM_SYSTEM_USERS_URL}></span>&nbsp;:&nbsp;<{$users.url}></li>\n                                <{/if}>\n                                <{if $users.user_icq}>\n                                    <li><span class="bold"><{$smarty.const._AM_SYSTEM_USERS_ICQ}></span>&nbsp;:&nbsp;<{$users.user_icq}></li>\n                                <{/if}>\n                                <{if $users.user_aim}>\n                                    <li><span class="bold"><{$smarty.const._AM_SYSTEM_USERS_AIM}></span>&nbsp;:&nbsp;<{$users.user_aim}></li>\n                                <{/if}>\n                                <{if $users.user_yim}>\n                                    <li><span class="bold"><{$smarty.const._AM_SYSTEM_USERS_YIM}></span>&nbsp;:&nbsp;<{$users.user_yim}></li>\n                                <{/if}>\n                                <{if $users.user_msnm}>\n                                    <li><span class="bold"><{$smarty.const._AM_SYSTEM_USERS_MSNM}></span>&nbsp;:&nbsp;<{$users.user_msnm}></li>\n                                <{/if}>\n                            </ul>\n                        </td>\n                    </tr>\n                </table>\n            </div>\n        <{/foreach}>\n    <{/if}>\n    <!--Pop-pup-->\n    <div class=''txtright''><{$nav|default:''''}></div>\n<{/if}>\n<br>\n<!-- Display Avatar form (add,edit) -->\n<{if !empty($form)}>\n    <div class="spacer"><{$form}></div>\n<{/if}>\n'),
(61, '<{if !empty($breadcrumb)}>\n    <{include file="db:system_header.tpl"}>\n<{/if}>\n<!--Preferences-->\n<{if !empty($menu)}>\n    <div class="xo-catsetting">\n        <{foreach item=preference from=$preferences|default:null}>\n            <a class="tooltip" href="admin.php?fct=preferences&amp;op=show&amp;confcat_id=<{$preference.id}>" title="<{$preference.name}>">\n                <img src="<{$preference.image}>" alt="<{$preference.name}>"/>\n                <span><{$preference.name}></span>\n            </a>\n        <{/foreach}>\n        <a class="tooltip" href="admin.php?fct=preferences&amp;op=showmod&amp;mod=1" title="<{$smarty.const._AM_SYSTEM_PREFERENCES_SETTINGS}>">\n            <img src="<{xoAdminIcons ''xoops/system_mods.png''}>" alt="<{$smarty.const._AM_SYSTEM_PREFERENCES_SETTINGS}>"/>\n            <span><{$smarty.const._AM_SYSTEM_PREFERENCES_SETTINGS}></span>\n        </a>\n    </div>\n<{/if}>\n<div class="clear">&nbsp;</div>\n<br>\n\n\n'),
(62, '<!--smilies-->\n<{include file="db:system_header.tpl"}>\n<!-- Display mailusers form  -->\n<br>\n<{if !empty($form)}>\n    <div class="spacer"><{$form}></div>\n<{/if}>\n<{$Sucess|default:''''}>\n<{$Errors|default:''''}>\n'),
(63, '<!--groups-->\n<{include file="db:system_header.tpl"}>\n<{if isset($groups_count) && $groups_count == true}>\n    <div class="floatright">\n        <div class="xo-buttons">\n            <button class="ui-corner-all" onclick="self.location.href=''admin.php?fct=groups&amp;op=groups_add''">\n                <img src="<{xoAdminIcons ''add.png''}>" alt="<{$smarty.const._AM_SYSTEM_GROUPS_ADD}>"/>\n                <{$smarty.const._AM_SYSTEM_GROUPS_ADD}>\n            </button>\n        </div>\n    </div>\n    <table id="xo-group-sorter" cellspacing="1" class="outer tablesorter">\n        <thead>\n        <tr>\n            <th class="txtcenter width5"><{$smarty.const._AM_SYSTEM_GROUPS_ID}></th>\n            <th class="txtcenter width20"><{$smarty.const._AM_SYSTEM_GROUPS_NAME}></th>\n            <th class="txtcenter"><{$smarty.const._AM_SYSTEM_GROUPS_DESCRIPTION}></th>\n            <th class="txtcenter"><{$smarty.const._AM_SYSTEM_GROUPS_NB_USERS_BY_GROUPS}></th>\n            <th class="txtcenter width10"><{$smarty.const._AM_SYSTEM_GROUPS_ACTION}></th>\n        </tr>\n        </thead>\n        <tbody>\n        <{foreach item=groupdetail from=$groups|default:null}>\n            <tr class="<{cycle values=''odd, even''}> alignmiddle">\n                <td class="txtcenter"><{$groupdetail.groups_id}></td>\n                <td class="txtleft">\n                    <a class="tooltip" href="admin.php?fct=groups&amp;op=groups_edit&amp;groups_id=<{$groupdetail.groups_id}>"\n                       title="<{$smarty.const._AM_SYSTEM_GROUPS_EDIT}>">\n                        <{$groupdetail.name}>\n                    </a>\n                </td>\n                <td class="txtleft"><{$groupdetail.description}></td>\n                <td class="txtcenter width25">\n                    <a href="./admin.php?fct=users&amp;selgroups=<{$groupdetail.groups_id}>"><{$groupdetail.nb_users_by_groups}></a>\n                </td>\n                <td class="xo-actions txtcenter">\n                    <a class="tooltip" href="admin.php?fct=groups&amp;op=groups_edit&amp;groups_id=<{$groupdetail.groups_id}>"\n                       title="<{$smarty.const._AM_SYSTEM_GROUPS_EDIT}>">\n                        <img src="<{xoAdminIcons ''edit.png''}>" alt="<{$smarty.const._AM_SYSTEM_GROUPS_EDIT}>"/></a>\n                    <{if !empty($groupdetail.delete)}>\n                        <a class="tooltip" href="admin.php?fct=groups&amp;op=groups_delete&amp;groups_id=<{$groupdetail.groups_id}>"\n                           title="<{$smarty.const._AM_SYSTEM_GROUPS_DELETE}>">\n                            <img src="<{xoAdminIcons ''delete.png''}>" alt="<{$smarty.const._AM_SYSTEM_GROUPS_DELETE}>"/></a>\n                    <{/if}>\n                </td>\n            </tr>\n        <{/foreach}>\n        </tbody>\n    </table>\n    <!-- Display groups navigation -->\n    <div class="clear spacer"></div>\n    <{if !empty($nav_menu)}>\n        <div class="xo-avatar-pagenav floatright"><{$nav_menu}></div>\n        <div class="clear spacer"></div>\n    <{/if}>\n<{/if}>\n<!-- Display groups form (add,edit) -->\n<{if !empty($form)}>\n    <div class="spacer"><{$form}></div>\n<{/if}>\n');
INSERT INTO `[[dbprefix]]_tplsource` VALUES
(64, '<!-- Header -->\n<{include file="db:system_header.tpl"}>\n<!-- Buttons -->\n<div style="height: 30px;">\n    <div class="floatright">\n        <div class="xo-buttons">\n            <{if empty($edit_form) && empty($listimg) && empty($multiupload)}>\n                <button id="xo-addcat-btn" class="ui-corner-all tooltip" onclick="xo_toggle(''div#xo-category-add'');"\n                        title="<{$smarty.const._AM_SYSTEM_IMAGES_ADDCAT}>">\n                    <img src="<{xoAdminIcons ''add.png''}>" alt="<{$smarty.const._AM_SYSTEM_IMAGES_ADDCAT}>"/>\n                    <{$smarty.const._AM_SYSTEM_IMAGES_ADDCAT}>\n                </button>\n            <{/if}>\n            <{if !empty($cat_img) || !empty($listimg)}>\n                <button id="xo-addimg-btn" class="ui-corner-all tooltip" onclick="xo_toggle(''div#xo-images-add'');"\n                        title="<{$smarty.const._AM_SYSTEM_IMAGES_ADDIMG}>">\n                    <img src="<{xoAdminIcons ''add.png''}>" alt="<{$smarty.const._AM_SYSTEM_IMAGES_ADDIMG}>"/>\n                    <{$smarty.const._AM_SYSTEM_IMAGES_ADDIMG}>\n                </button>\n            <{/if}>\n            <{if !empty($listimg)}>\n                <button id="xo-addavatar-btn" class="ui-corner-all tooltip" onclick=''location="admin.php?fct=images&amp;op=multiupload&amp;imgcat_id=<{$imgcat_id}>"''\n                        title="<{$smarty.const._AM_SYSTEM_IMAGES_MULTIUPLOAD}>">\n                    <img src="<{xoAdminIcons ''add.png''}>" alt="<{$smarty.const._AM_SYSTEM_IMAGES_MULTIUPLOAD}>"/>\n                    <{$smarty.const._AM_SYSTEM_IMAGES_MULTIUPLOAD}>\n                </button>\n            <{/if}>\n        </div>\n    </div>\n</div>\n<!-- Category List -->\n<{if empty($edit_form) && empty($listimg) && empty($multiupload)}>\n    <table class="outer" cellspacing="1">\n        <thead>\n        <tr>\n            <th><{$smarty.const._AM_SYSTEM_IMAGES_NAME}></th>\n            <th><{$smarty.const._AM_SYSTEM_IMAGES_NBIMAGES}></th>\n            <th><{$smarty.const._AM_SYSTEM_IMAGES_MAXSIZE}></th>\n            <th><{$smarty.const._AM_SYSTEM_IMAGES_MAXWIDTH}></th>\n            <th><{$smarty.const._AM_SYSTEM_IMAGES_MAXHEIGHT}></th>\n            <th><{$smarty.const._AM_SYSTEM_IMAGES_DISPLAY}></th>\n            <th><{$smarty.const._AM_SYSTEM_IMAGES_ACTIONS}></th>\n        </tr>\n        </thead>\n        <tbody>\n        <{foreach item=cat from=$cat_img|default:null}>\n            <tr class="<{cycle values=''odd, even''}> txtcenter">\n                <td>\n                    <a class="tooltip" href="admin.php?fct=images&amp;op=listimg&amp;imgcat_id=<{$cat.id}>" title="<{$smarty.const._AM_SYSTEM_IMAGES_VIEW}>">\n                        <{$cat.name}>\n                    </a>\n                </td>\n                <td><{$cat.count}></td>\n                <td><{$cat.maxsize}></td>\n                <td><{$cat.maxwidth}></td>\n                <td><{$cat.maxheight}></td>\n                <td class="xo-actions"><img id="loading_cat<{$cat.id}>" src="./images/spinner.gif" style="display:none;"\n                                            alt="<{$smarty.const._AM_SYSTEM_LOADING}>"/><img class="cursorpointer tooltip" id="cat<{$cat.id}>"\n                                                                                             onclick="system_setStatus( { fct: ''images'', op: ''display_cat'', imgcat_id: <{$cat.id}> }, ''cat<{$cat.id}>'', ''admin.php'' )"\n                                                                                             src="<{if $cat.display}><{xoAdminIcons ''success.png''}><{else}><{xoAdminIcons ''cancel.png''}><{/if}>"\n                                                                                             alt=""\n                                                                                             title="<{if $cat.display}><{$smarty.const._AM_SYSTEM_IMAGES_OFF}><{else}><{$smarty.const._AM_SYSTEM_IMAGES_ON}><{/if}>"/>\n                </td>\n                <td class="xo-actions txtcenter">\n                    <a class="tooltip" href="admin.php?fct=images&amp;op=listimg&amp;imgcat_id=<{$cat.id}>" title="<{$smarty.const._AM_SYSTEM_IMAGES_VIEW}>">\n                        <img src="<{xoAdminIcons ''display.png''}>" alt="<{$smarty.const._AM_SYSTEM_IMAGES_VIEW}>"/></a>\n                    <{if isset($xoops_isadmin)}>\n                        <a class="tooltip" href="admin.php?fct=images&amp;op=editcat&amp;imgcat_id=<{$cat.id}>" title="<{$smarty.const._EDIT}>">\n                            <img src="<{xoAdminIcons ''edit.png''}>" alt="<{$smarty.const._EDIT}>"/></a>\n                        <a class="tooltip" href="admin.php?fct=images&amp;op=delcat&amp;imgcat_id=<{$cat.id}>" title="<{$smarty.const._DELETE}>">\n                            <img src="<{xoAdminIcons ''delete.png''}>" alt=""/></a>\n                    <{/if}>\n                </td>\n            </tr>\n        <{/foreach}>\n        <{if empty($cat_img)}>\n            <tr>\n                <td class="txtcenter bold odd" colspan="7"><{$smarty.const._AM_SYSTEM_IMAGES_NOCAT}></td>\n            </tr>\n        <{/if}>\n        </tbody>\n    </table>\n    <!-- Nav menu -->\n    <{if !empty($nav_menu)}>\n        <div class="xo-avatar-pagenav floatright"><{$nav_menu}></div>\n        <div class="clear spacer"></div>\n    <{/if}>\n<{/if}>\n<{if !empty($images)}>\n    <!-- Image list -->\n    <div id="xo-category-add" class="">\n        <{foreach item=img from=$images|default:null}>\n            <div class="floatleft">\n                <div class="ui-corner-all xo-thumb txtcenter">\n                    <div class="xo-thumbimg">\n                        <img class="tooltip" src="<{$xoops_url}>/image.php?id=<{$img.image_id}>&amp;width=120&amp;height=120" alt="<{$img.image_nicename}>"\n                             title="<{$img.image_nicename}>" style="max-width:120px; max-height:120px;"/>\n                    </div>\n                    <div class="xo-actions txtcenter">\n                        <div class="spacer bold"><{$img.image_nicename|truncate:18:''…'':true}></div>\n						<img id="loading_img<{$img.image_id}>" src="./images/spinner.gif" style="display:none;" alt="<{$smarty.const._AM_SYSTEM_LOADING}>"/>\n						<img class="cursorpointer tooltip" id="img<{$img.image_id}>"\n							onclick="system_setStatus( { fct: ''images'', op: ''display_img'', image_id: ''<{$img.image_id}>'' }, ''img<{$img.image_id}>'', ''admin.php'' )"\n							src="<{if $img.image_display}><{xoAdminIcons ''success.png''}><{else}><{xoAdminIcons ''cancel.png''}><{/if}>"\n							alt="<{$smarty.const._IMGDISPLAY}>" title="<{$smarty.const._IMGDISPLAY}>"/>\n						<{if empty($db_store)}>\n							<a class="lightbox tooltip" href="<{$xoops_upload_url}>/<{$img.image_name}>" title="<{$smarty.const._PREVIEW}>">\n						<{else}>\n							<a class="lightbox tooltip" href="<{$xoops_url}>/image.php?id=<{$img.image_id}>" title="<{$smarty.const._PREVIEW}>">\n						<{/if}>\n						<img src="<{xoAdminIcons ''display.png''}>" alt="<{$smarty.const._AM_SYSTEM_IMAGES_VIEW}>"/></a>\n						<a class="tooltip" href="admin.php?fct=images&amp;op=editimg&amp;image_id=<{$img.image_id}>" title="<{$smarty.const._EDIT}>"><img src="<{xoAdminIcons ''edit.png''}>" alt="<{$smarty.const._EDIT}>"/></a>\n                        <a class="tooltip" href="admin.php?fct=images&amp;op=delfile&amp;image_id=<{$img.image_id}>" title="<{$smarty.const._DELETE}>"><img src="<{xoAdminIcons ''delete.png''}>" alt="<{$smarty.const._DELETE}>"/></a>\n						<img class="tooltip" onclick="display_dialog(<{$img.image_id}>, true, true, ''slide'', ''slide'', 120, 350);" src="<{xoAdminIcons ''url.png''}>" alt="<{$smarty.const._AM_SYSTEM_IMAGES_URL}>" title="<{$smarty.const._AM_SYSTEM_IMAGES_URL}>"/>\n                    </div>\n                </div>\n            </div>\n            <div id="dialog<{$img.image_id}>" title="<{$img.image_nicename}>" style=''display:none;''>\n                <div class="center">\n                    <{if empty($db_store)}>\n                        <{$xoops_upload_url}>/<{$img.image_name}>\n                    <{else}>\n                        <{$xoops_url}>/image.php?id=<{$img.image_id}>\n                    <{/if}>\n                </div>\n            </div>\n        <{/foreach}>\n        <div class="clear"></div>\n    </div>\n    <{if !empty($nav_menu)}>\n        <div class="xo-avatar-pagenav floatright"><{$nav_menu}></div>\n        <div class="clear spacer"></div>\n    <{/if}>\n<{else}>\n    <div id="xo-category-add" class="">\n        <div class="clear"></div>\n    </div>\n<{/if}>\n\n<!-- Add Image form -->\n<{if !empty($image_form)}>\n<div id="xo-images-add" class="hide">\n    <br>\n    <{$image_form.javascript}>\n    <form name="<{$image_form.name}>" id="<{$image_form.name}>" action="<{$image_form.action}>" method="<{$image_form.method}>"\n            <{$image_form.extra}> >\n        <table class="outer">\n            <tr>\n                <th colspan="2"><{$image_form.title}></th>\n            </tr>\n            <{foreach item=element from=$image_form.elements|default:null}>\n                <{if isset($element.hidden) && $element.hidden != true && !empty($element.body)}>\n                    <tr>\n                        <td class="odd aligntop">\n                            <div class="spacer bold"><{$element.caption|default:''''}><{if !empty($element.required)}><span class="red">&nbsp;*</span><{/if}></div>\n                            <{if !empty($element.description)}>\n                                <div class="spacer"><{$element.description|default:''''}></div>\n                            <{/if}>\n                        </td>\n                        <td class="even"><{$element.body}></td>\n                    </tr>\n                <{else}>\n                    <{$element.body}>\n                <{/if}>\n            <{/foreach}>\n        </table>\n    </form>\n</div>\n<{/if}>\n<!-- Add Category form -->\n<{if !empty($imagecat_form)}>\n<div id="xo-category-add" class="hide">\n    <br>\n    <{$imagecat_form.javascript}>\n    <form name="<{$imagecat_form.name}>" id="<{$imagecat_form.name}>" action="<{$imagecat_form.action}>" method="<{$imagecat_form.method}>"\n            <{$imagecat_form.extra}> >\n        <table class="outer">\n            <tr>\n                <th colspan="2"><{$imagecat_form.title}></th>\n            </tr>\n            <{foreach item=element from=$imagecat_form.elements|default:null}>\n                <{if isset($element.hidden) && $element.hidden != true && !empty($element.body)}>\n                    <tr>\n                        <td class="odd aligntop">\n                            <div class="spacer bold"><{$element.caption|default:''''}><{if !empty($element.required)}><span class="red">&nbsp;*</span><{/if}></div>\n                            <{if !empty($element.description)}>\n                                <div class="spacer"><{$element.description|default:''''}></div>\n                            <{/if}>\n                        </td>\n                        <td class="even"><{$element.body}></td>\n                    </tr>\n                <{else}>\n                    <{$element.body}>\n                <{/if}>\n            <{/foreach}>\n        </table>\n    </form>\n</div>\n<{/if}>\n<{if !empty($multiupload)}>\n    <div class="clear"></div>\n    <{include file="db:system_trigger_uploads.tpl"}>\n    <h2><{$imgcat_name}></h2>\n    <div id="fine-uploader-manual-trigger"></div>\n    <div><{$smarty.const._IMGMAXSIZE}> <{$imgcat_maxsize}></div>\n    <div><{$smarty.const._IMGMAXWIDTH}> <{$imgcat_maxwidth}></div>\n    <div><{$smarty.const._IMGMAXHEIGHT}> <{$imgcat_maxheight}></div>\n    <!-- Your code to create an instance of Fine Uploader and bind to the DOM/template\n    ====================================================================== -->\n    <script>\n        var imgcat_maxheight = "<{$imgcat_maxheight}>";\n        var imgcat_maxwidth = "<{$imgcat_maxwidth}>";\n        var imgcat_maxsize = "<{$imgcat_maxsize}>";\n        var fineup_debug = "<{$fineup_debug}>";\n\n        var manualUploader = new qq.FineUploader({\n            element: document.getElementById(''fine-uploader-manual-trigger''),\n            template: ''qq-template-manual-trigger'',\n            request: {\n                endpoint: ''<{$xoops_url}>/ajaxfineupload.php'',\n                params: {\n                    "Authorization": "<{$jwt}>"\n                }\n            },\n            text: {\n                formatProgress: "<{$smarty.const._FORMATPROGRESS}>",\n                failUpload: "<{$smarty.const._FAILUPLOAD}>",\n                waitingForResponse: "<{$smarty.const._WAITINGFORRESPONSE}>",\n                paused: "<{$smarty.const._PAUSED}>"\n            },\n            messages: {\n                typeError: "<{$smarty.const._TYPEERROR}>",\n                sizeError: "<{$smarty.const._SIZEERROR}>",\n                minSizeError: "<{$smarty.const._MINSIZEERROR}>",\n                emptyError: "<{$smarty.const._EMPTYERROR}>",\n                noFilesError: "<{$smarty.const._NOFILESERROR}>",\n                tooManyItemsError: "<{$smarty.const._TOOMANYITEMSERROR}>",\n                maxHeightImageError: "<{$smarty.const._MAXHEIGHTIMAGEERROR}>",\n                maxWidthImageError: "<{$smarty.const._MAXWIDTHIMAGEERROR}>",\n                minHeightImageError: "<{$smarty.const._MINHEIGHTIMAGEERROR}>",\n                minWidthImageError: "<{$smarty.const._MINWIDTHIMAGEERROR}>",\n                retryFailTooManyItems: "<{$smarty.const._RETRYFAILTOOMANYITEMS}>",\n                onLeave: "<{$smarty.const._ONLEAVE}>",\n                unsupportedBrowserIos8Safari: "<{$smarty.const._UNSUPPORTEDBROWSERIOS8SAFARI}>"\n            },\n            thumbnails: {\n                placeholders: {\n                    waitingPath: ''<{$xoops_url}>/media/fine-uploader/placeholders/waiting-generic.png'',\n                    notAvailablePath: ''<{$xoops_url}>/media/fine-uploader/placeholders/not_available-generic.png''\n                }\n            },\n            validation: {\n                acceptFiles: [''image/jpeg'', ''image/gif'', ''image/png''],\n                allowedExtensions: [''jpeg'', ''jpg'', ''png'', ''gif''],\n                image: {\n                    maxHeight: imgcat_maxheight,\n                    maxWidth: imgcat_maxwidth\n                },\n                sizeLimit: imgcat_maxsize\n            },\n            autoUpload: false,\n            callbacks: {\n            onError: function(id, name, errorReason, xhrOrXdr) {\n                 console.log(qq.format("Error uploading {}.  Reason: {}", name, errorReason));\n             }\n         },\n            debug: fineup_debug\n        });\n        qq(document.getElementById("trigger-upload")).attach("click", function() {\n            manualUploader.uploadStoredFiles();\n        });\n    </script>\n<{/if}>\n<!-- Edit form image -->\n<{if !empty($edit_form)}>\n    <div id="xo-images-add" class="">\n        <{$edit_thumbs}>\n        <br>\n        <{$edit_form.javascript}>\n        <form name="<{$edit_form.name}>" id="<{$edit_form.name}>" action="<{$edit_form.action}>" method="<{$edit_form.method}>"\n                <{$edit_form.extra}> >\n            <table class="outer">\n                <tr>\n                    <th colspan="2"><{$edit_form.title}></th>\n                </tr>\n                <{foreach item=element from=$edit_form.elements|default:null}>\n                    <{if isset($element.hidden) && $element.hidden != true && !empty($element.body)}>\n                        <tr>\n                            <td class="odd aligntop">\n                                <div class="spacer bold"><{$element.caption|default:''''}><{if !empty($element.required)}><span class="red">&nbsp;*</span><{/if}></div>\n                                <{if !empty($element.description)}>\n                                    <div class="spacer"><{$element.description|default:''''}></div>\n                                <{/if}>\n                            </td>\n                            <td class="even"><{$element.body}></td>\n                        </tr>\n                    <{else}>\n                        <{$element.body}>\n                    <{/if}>\n                <{/foreach}>\n            </table>\n        </form>\n    </div>\n<{/if}>\n<script type="text/javascript">\n    IMG_ON = "<{xoAdminIcons ''success.png''}>";\n    IMG_OFF = "<{xoAdminIcons ''cancel.png''}>";\n\n    $(''.lightbox'').lightBox({\n        imageLoading: ''language/<{if isset($xoops_language)}><{$xoops_language}><{else}>english<{/if}>/images/lightbox-ico-loading.gif'',\n        imageBtnClose: ''language/<{if isset($xoops_language)}><{$xoops_language}><{else}>english<{/if}>/images/lightbox-btn-close.gif'',\n        imageBtnNext: ''language/<{if isset($xoops_language)}><{$xoops_language}><{else}>english<{/if}>/images/lightbox-btn-next.gif'',\n        imageBtnPrev: ''language/<{if isset($xoops_language)}><{$xoops_language}><{else}>english<{/if}>/images/lightbox-btn-prev.gif'',\n        imageBlank: ''language/<{if isset($xoops_language)}><{$xoops_language}><{else}>english<{/if}>/images/lightbox-blank.gif''\n    });\n\n\n</script>\n'),
(65, '<{include file="db:system_header.tpl"}>\n\n<{if isset($index)}>\n    <br class="clear"/>\n    <div class="spacer">\n        <table class="outer ui-corner-all" cellspacing="1">\n            <tr>\n                <th><{$smarty.const._AM_SYSTEM_TEMPLATES_YOUR_THEMES}></th>\n                <th>&nbsp;</th>\n            </tr>\n            <tr>\n                <td class="aligntop width10">\n                    <div id="fileTree" class="display_folder"></div>\n                </td>\n                <td class="aligntop">\n                    <div id="display_form"><{$form}></div>\n                    <div id="display_contenu"></div>\n                    <div id=''display_message'' class="txtcenter" style="display:none;"></div>\n                    <div id=''loading'' class="txtcenter" style="display:none;"><br><br><img src="images/loading.gif" title="Loading" alt="Loading"/>\n                    </div>\n                </td>\n            </tr>\n        </table>\n\n        <br class="clear"/>\n    </div>\n<{else}>\n    <br>\n    <{if isset($verif)}>\n        <{$infos}>\n    <{else}>\n        <div class="txtcenter"><{$smarty.const._AM_SYSTEM_TEMPLATES_NOT_CREATED}></div>\n    <{/if}>\n<{/if}>\n'),
(66, '<{include file="db:system_header.tpl"}>\n<script type="text/javascript">\n    IMG_ON = "<{xoAdminIcons ''success.png''}>";\n    IMG_OFF = "<{xoAdminIcons ''cancel.png''}>";\n</script>\n<table cellspacing="1" class="outer">\n    <thead>\n    <tr>\n        <th class="txtcenter"><{$smarty.const._AM_SYSTEM_SECTION}></th>\n        <th class="txtcenter"><{$smarty.const._AM_SYSTEM_DESC}></th>\n        <th class="txtcenter"><{$smarty.const._AM_SYSTEM_USAGE}></th>\n        <th class="txtcenter"><{$smarty.const._AM_SYSTEM_ACTIVE}></th>\n    </tr>\n    </thead>\n\n    <tbody>\n    <{foreach item=menuitem from=$menu|default:null}>\n        <{if $menuitem.title}>\n            <tr class="<{cycle values=''even,odd''}>">\n                <td class="bold width15">\n                    <a class="tooltip" href="admin.php?fct=<{$menuitem.file}>" title="<{$smarty.const._AM_SYSTEM_GO}>: <{$menuitem.title}>">\n                        <img class="xo-imgmini" src=''<{$theme_icons}>/<{$menuitem.icon|default:''''}>'' alt="<{$menuitem.title|default:''''}>"/>\n                        <{$menuitem.title}>\n                    </a>\n                </td>\n                <td class=""><{$menuitem.desc}></td>\n                <td class="width15"><{$menuitem.infos|default:''''}></td>\n                <td class="xo-actions width2">\n                    <{if !empty($menuitem.used)}>\n                        <img id="loading_<{$menuitem.file}>" src="images/spinner.gif" style="display:none;" alt="<{$smarty.const._AM_SYSTEM_LOADING}>"/>\n                        <img class="tooltip" id="<{$menuitem.file}>"\n                             onclick="system_setStatus( { op: ''system_activate'', type: ''<{$menuitem.file}>'' }, ''<{$menuitem.file}>'', ''admin.php'' )"\n                             src="<{if $menuitem.status}><{xoAdminIcons ''success.png''}><{else}><{xoAdminIcons ''cancel.png''}><{/if}>"\n                             alt="<{$smarty.const._AM_SYSTEM_STATUS}>" title="<{$smarty.const._AM_SYSTEM_STATUS}>"/>\n                    <{/if}>\n                </td>\n            </tr>\n        <{/if}>\n    <{/foreach}>\n    </tbody>\n</table>\n'),
(67, '<!--maintenance-->\n<{include file="db:system_header.tpl"}>\n<!-- Display mailusers form  -->\n<br>\n<{if !empty($form_maintenance)}>\n    <div class="spacer"><{$form_maintenance}></div>\n    <br>\n    <div class="spacer"><{$form_dump}></div>\n<{elseif !empty($maintenance)}>\n    <{if $verif_cache || $verif_session || $verif_avatar}>\n        <table class="outer ui-corner-all" cellspacing="1">\n            <tr>\n                <th><{$smarty.const._AM_SYSTEM_MAINTENANCE}></th>\n                <th><{$smarty.const._AM_SYSTEM_MAINTENANCE_RESULT}></th>\n            </tr>\n            <{if isset($verif_cache)}>\n                <tr>\n                    <td class="aligntop txtcenter"><{$smarty.const._AM_SYSTEM_MAINTENANCE_RESULT_CACHE}></td>\n                    <td class="aligntop txtcenter"><{if isset($result_cache)}><img width="16" src="<{xoAdminIcons ''success.png''}>"/><{else}><img style="width:16px;"\n                                                                                                                                        src="<{xoAdminIcons ''cancel.png''}>"\n                                                                                                                                        alt="Cancel"/><{/if}>\n                    </td>\n                </tr>\n            <{/if}>\n\n            <{if isset($verif_session)}>\n                <tr>\n                    <td class="aligntop" align="center"><{$smarty.const._AM_SYSTEM_MAINTENANCE_RESULT_SESSION}></td>\n                    <td class="aligntop" align="center"><{if isset($result_session)}><img style="width:16px;" src="<{xoAdminIcons ''success.png''}>"\n                                                                                   alt="Success"/><{else}><img style="width:16px;"\n                                                                                                               src="<{xoAdminIcons ''cancel.png''}>" alt="Cancel"/><{/if}>\n                    </td>\n                </tr>\n            <{/if}>\n\n            <{if isset($verif_avatar)}>\n                <tr>\n                    <td class="aligntop" align="center"><{$smarty.const._AM_SYSTEM_MAINTENANCE_RESULT_AVATAR}></td>\n                    <td class="aligntop" align="center"><{if isset($result_avatar)}><img style="width:16px;" src="<{xoAdminIcons ''success.png''}>"\n                                                                                  alt="Success"/><{else}><img style="width:16px;"\n                                                                                                              src="<{xoAdminIcons ''cancel.png''}>" alt="Cancel"/><{/if}>\n                    </td>\n                </tr>\n            <{/if}>\n        </table>\n        <br>\n    <{/if}>\n    <{if !empty($verif_maintenance)}>\n        <{$result_maintenance}>\n    <{/if}>\n<{else}>\n    <{$result_dump}>\n<{/if}>\n'),
(68, '<{include file="db:system_header.tpl"}>\n<table id="help-system">\n    <tr>\n        <td class="width20">\n            <{if !empty($help)}>\n                <div class="xo-help-menu">\n                    <h2 class="head"><{$modname}></h2>\n                    <{foreach item=helpitem from=$help|default:null}>\n                        <div class="<{cycle values=''odd, even''}>"><a href="<{$helpitem.link}>"><{$helpitem.name}></a></div>\n                    <{/foreach}>\n                </div>\n            <{/if}>\n            <{if !empty($list_mods)}>\n                <div class="xo-help-menu">\n                    <{foreach item=row from=$list_mods|default:null}>\n                        <h2 class="head"><{$row.name}></h2>\n                        <{foreach item=list from=$row.help_page|default:null}>\n                            <div class="<{cycle values=''odd, even''}>" title="<{$list.name}>"><a href="<{$list.link}>"><{$list.name}></a></div>\n                        <{/foreach}>\n                    <{/foreach}>\n                </div>\n            <{/if}>\n        </td>\n        <td>\n            <div id="help-content">\n                <{$helpcontent}>\n            </div>\n        </td>\n    </tr>\n</table>\n'),
(69, '<div id="usermenu">\n    <{if isset($xoops_isadmin)}>\n        <a class="menuTop" href="<{xoAppUrl ''admin.php''}>" title="<{$block.lang_adminmenu}>"><{$block.lang_adminmenu}></a>\n        <a href="<{xoAppUrl ''user.php''}>" title="<{$block.lang_youraccount}>"><{$block.lang_youraccount}></a>\n    <{else}>\n        <a class="menuTop" href="<{xoAppUrl ''user.php''}>" title="<{$block.lang_youraccount}>"><{$block.lang_youraccount}></a>\n    <{/if}>\n    <a href="<{xoAppUrl ''edituser.php''}>" title="<{$block.lang_editaccount}>"><{$block.lang_editaccount}></a>\n    <a href="<{xoAppUrl ''notifications.php''}>" title="<{$block.lang_notifications}>"><{$block.lang_notifications}></a>\n    <{if $block.new_messages > 0}>\n        <a class="highlight" href="<{xoAppUrl ''viewpmsg.php''}>" title="<{$block.lang_inbox}>"><{$block.lang_inbox}>\n            (<strong><{$block.new_messages}></strong>)</a>\n    <{else}>\n        <a href="<{xoAppUrl ''viewpmsg.php''}>" title="<{$block.lang_inbox}>"><{$block.lang_inbox}></a>\n    <{/if}>\n    <a href="<{xoAppUrl ''user.php?op=logout''}>" title="<{$block.lang_logout}>"><{$block.lang_logout}></a>\n</div>\n'),
(70, '<div class="txtcenter">\n    <form style="margin-top: 0;" action="<{xoAppUrl ''user.php''}>" method="post">\n        <{$block.lang_username}><br>\n        <input type="text" name="uname" size="12" value="<{$block.unamevalue}>" maxlength="25"/><br>\n        <{$block.lang_password}><br>\n        <input type="password" name="pass" size="12" maxlength="32"/><br>\n        <{if isset($block.lang_rememberme)}>\n            <input type="checkbox" name="rememberme" value="On" class="formButton"/>\n            <{$block.lang_rememberme}>\n            <br>\n        <{/if}>\n        <br>\n        <input type="hidden" name="xoops_redirect" value="<{$xoops_requesturi}>"/>\n        <input type="hidden" name="op" value="login"/>\n        <input type="submit" value="<{$block.lang_login}>"/><br>\n        <{$block.sslloginlink|default:''''}>\n    </form>\n    <br>\n    <a href="<{xoAppUrl ''user.php#lost''}>" title="<{$block.lang_lostpass}>"><{$block.lang_lostpass}></a>\n    <br><br>\n    <a href="<{xoAppUrl ''register.php''}>" title="<{$block.lang_registernow}>"><{$block.lang_registernow}></a>\n</div>\n'),
(71, '<div class="txtcenter">\n    <form style="margin-top: 0;" action="<{xoAppUrl ''search.php''}>" method="get">\n        <input type="text" name="query" size="14"/>\n        <input type="hidden" name="action" value="results"/><br>\n        <input type="submit" value="<{$block.lang_search}>"/>\n    </form>\n    <a href="<{xoAppUrl ''search.php''}>" title="<{$block.lang_advsearch}>"><{$block.lang_advsearch}></a>\n</div>\n'),
(72, '<ul>\n    <{foreach item=module from=$block.modules|default:null}>\n        <li><a href="<{$module.adminlink}>" title="<{$module.lang_linkname}>"><{$module.lang_linkname}></a>: <{$module.pendingnum}></li>\n    <{/foreach}>\n</ul>\n'),
(73, '<div id="mainmenu">\n    <a class="menuTop <{if empty($block.nothome)}>maincurrent<{/if}>" href="<{xoAppUrl}>" title="<{$block.lang_home}>"><{$block.lang_home}></a>\n    <!-- start module menu loop -->\n    <{foreach item=module from=$block.modules|default:null}>\n        <a class="menuMain <{if !empty($module.highlight)}>maincurrent<{/if}>" href="<{$xoops_url}>/modules/<{$module.directory}>/" title="<{$module.name}>"><{$module.name}></a>\n        <{foreach item=sublink from=$module.sublinks|default:null}>\n            <a class="menuSub" href="<{$sublink.url}>" title="<{$sublink.name}>"><{$sublink.name}></a>\n        <{/foreach}>\n    <{/foreach}>\n    <!-- end module menu loop -->\n</div>\n'),
(74, '<{if $block.showgroups == true}>\n	\n	<table class="outer collapse">\n\n        <!-- start group loop -->\n        <{foreach item=group from=$block.groups|default:null}>\n\n			<{if !empty($group.name)}>\n				<thead> \n					<tr>\n						<th colspan="2"><{$group.name}></th>\n					</tr>\n				</thead> \n            <{/if}>\n\n            <!-- start group member loop -->\n            <{foreach item=user from=$group.users|default:null}>\n                <tr>\n                    <td class="even txtcenter alignmiddle">\n                        <img style="width:32px;" src="<{$user.avatar}>" alt="<{$user.name}>"/><br>\n                        <a href="<{$xoops_url}>/userinfo.php?uid=<{$user.id}>" title="<{$user.name}>"><{$user.name}></a>\n                    </td>\n                    <td class="odd width20 txtright alignmiddle">\n                        <{$user.msglink}>\n                    </td>\n                </tr>\n            <{/foreach}>\n            <!-- end group member loop -->\n\n        <{/foreach}>\n        <!-- end group loop -->\n	</table>\n<{/if}>\n\n<br>\n\n<div class="txtcenter marg3">\n    <img src="<{$block.logourl}>" alt=""/><br><{$block.recommendlink}>\n</div>\n'),
(75, '<{$block.online_total}>\n<br><br>\n<{$block.lang_members}>: <{$block.online_members}>\n<br>\n<{$block.lang_guests}>: <{$block.online_guests}>\n<br><br>\n<{$block.online_names}>\n<a href="javascript:openWithSelfMain(''<{$xoops_url}>/misc.php?action=showpopups&amp;type=online'',''Online'',420,350);" title="<{$block.lang_more}>">\n    <{$block.lang_more}>\n</a>\n'),
(76, '<table cellspacing="1" class="outer">\n    <{foreach item=user from=$block.users|default:null}>\n        <tr class="<{cycle values=''even,odd''}> alignmiddle">\n            <td><{$user.rank}></td>\n            <td class="txtcenter">\n                <{if !empty($user.avatar)}>\n                    <img style="width:32px;" src="<{$user.avatar}>" alt="<{$user.name}>"/>\n                    <br>\n                <{/if}>\n                <a href="<{$xoops_url}>/userinfo.php?uid=<{$user.id}>" title="<{$user.name}>"><{$user.name}></a>\n            </td>\n            <td class="txtcenter"><{$user.posts}></td>\n        </tr>\n    <{/foreach}>\n</table>\n'),
(77, '<table cellspacing="1" class="outer">\n    <{foreach item=user from=$block.users|default:null}>\n        <tr class="<{cycle values=''even,odd''}> alignmiddle">\n            <td class="txtcenter">\n                <{if !empty($user.avatar)}>\n                    <img style="width:32px;" src="<{$user.avatar}>" alt="<{$user.name}>"/>\n                    <br>\n                <{/if}>\n                <a href="<{$xoops_url}>/userinfo.php?uid=<{$user.id}>" title="<{$user.name}>"><{$user.name}></a>\n            </td>\n            <td class="txtcenter"><{$user.joindate}></td>\n        </tr>\n    <{/foreach}>\n</table>\n'),
(78, '<table cellspacing="1" class="outer width100">\n    <{foreach item=comment from=$block.comments|default:null}>\n        <tr class="<{cycle values=''even,odd''}>">\n            <td class="txtcenter"><img src="<{$xoops_url}>/images/subject/<{$comment.icon}>" alt=""/></td>\n            <td><{$comment.title}></td>\n            <td class="txtcenter"><{$comment.module}></td>\n            <td class="txtcenter"><{$comment.poster}></td>\n            <td class="txtright"><{$comment.time}></td>\n        </tr>\n    <{/foreach}>\n</table>\n'),
(79, '<form action="<{$block.target_page}>" method="post">\n    <table class="outer">\n        <{foreach item=category from=$block.categories|default:null}>\n            <{foreach item=event from=$category.events|default:null name=inner}>\n                <{if $smarty.foreach.inner.first}>\n                    <tr>\n                        <td class="head" colspan="2"><{$category.title}></td>\n                    </tr>\n                <{/if}>\n                <tr>\n                    <td class="odd">\n                        <{counter assign=index}>\n                        <input type="hidden" name="not_list[<{$index}>][params]" value="<{$category.name}>,<{$category.itemid}>,<{$event.name}>"/>\n                        <input type="checkbox" name="not_list[<{$index}>][status]" value="1" <{if $event.subscribed}>checked<{/if}> />\n                    </td>\n                    <td class="odd"><{$event.caption}></td>\n                </tr>\n            <{/foreach}>\n        <{/foreach}>\n        <tr>\n            <td class="foot" colspan="2">\n                <input type="hidden" name="not_redirect" value="<{$block.redirect_script}>">\n                <input type="hidden" value="<{$block.notification_token}>" name="XOOPS_TOKEN_REQUEST"/>\n                <input type="submit" name="not_submit" value="<{$block.submit_button}>"/>\n            </td>\n        </tr>\n    </table>\n</form>\n'),
(80, '<div class="txtcenter">\n    <form action="<{xoAppUrl ''index.php''}>" method="post">\n        <{$block.theme_select}>\n    </form>\n</div>\n');

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_xoopscomments`
--

CREATE TABLE `[[dbprefix]]_xoopscomments` (
  `com_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `com_pid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `com_rootid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `com_modid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `com_itemid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `com_icon` varchar(25) NOT NULL DEFAULT '',
  `com_created` int(10) unsigned NOT NULL DEFAULT '0',
  `com_modified` int(10) unsigned NOT NULL DEFAULT '0',
  `com_uid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `com_user` varchar(60) NOT NULL DEFAULT '',
  `com_email` varchar(60) NOT NULL DEFAULT '',
  `com_url` varchar(60) NOT NULL DEFAULT '',
  `com_ip` varchar(45) NOT NULL DEFAULT '',
  `com_title` varchar(255) NOT NULL DEFAULT '',
  `com_text` text,
  `com_sig` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `com_status` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `com_exparams` varchar(255) NOT NULL DEFAULT '',
  `dohtml` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `dosmiley` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `doxcode` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `doimage` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `dobr` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`com_id`),
  KEY `com_pid` (`com_pid`),
  KEY `com_itemid` (`com_itemid`),
  KEY `com_uid` (`com_uid`),
  KEY `com_title` (`com_title`(40)),
  KEY `com_status` (`com_status`),
  KEY `com_user` (`com_user`),
  KEY `com_email` (`com_email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_xoopsnotifications`
--

CREATE TABLE `[[dbprefix]]_xoopsnotifications` (
  `not_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `not_modid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `not_itemid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `not_category` varchar(30) NOT NULL DEFAULT '',
  `not_event` varchar(30) NOT NULL DEFAULT '',
  `not_uid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `not_mode` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`not_id`),
  KEY `not_modid` (`not_modid`),
  KEY `not_itemid` (`not_itemid`),
  KEY `not_class` (`not_category`),
  KEY `not_uid` (`not_uid`),
  KEY `not_event` (`not_event`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;

