/var/softaculous/xoops
| Name | Size | Mode | Actions |
|---|---|---|---|
| images/ | - | 0755 | rm |
| php53/ | - | 0755 | rm |
| php56/ | - | 0755 | rm |
| php71/ | - | 0755 | rm |
| php81/ | - | 0755 | rm |
| changelog.txt | 9989 | 0644 | editdlrm |
| clone.php | 3358 | 0644 | editdlrm |
| data.zip | 729687 | 0644 | editdlrm |
| edit.php | 4477 | 0644 | editdlrm |
| edit.xml | 433 | 0644 | editdlrm |
| fileindex.php | 452 | 0644 | editdlrm |
| import.php | 3638 | 0644 | editdlrm |
| info.xml | 2917 | 0644 | editdlrm |
| install.js | 921 | 0644 | editdlrm |
| install.php | 5543 | 0644 | editdlrm |
| install.xml | 1469 | 0644 | editdlrm |
| mainfile.php | 3537 | 0644 | editdlrm |
| md5 | 32580 | 0644 | editdlrm |
| notes.txt | 818 | 0644 | editdlrm |
| secure.php | 1697 | 0644 | editdlrm |
| upgrade.php | 4497 | 0644 | editdlrm |
| upgrade.xml | 429 | 0644 | editdlrm |
| xoops.sql | 262199 | 0644 | editdlrm |
| xoops.zip | 11297117 | 0644 | editdlrm |
Edit:
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `xoops2510`
--
-- --------------------------------------------------------
--
-- 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=utf8 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=utf8;
-- --------------------------------------------------------
--
-- 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` mediumint(8) unsigned NOT NULL DEFAULT '0',
`clicks` mediumint(8) 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=utf8 AUTO_INCREMENT=5 ;
--
-- Dumping data for table `[[dbprefix]]_banner`
--
INSERT INTO `[[dbprefix]]_banner` VALUES
(1, 1, 0, 1, 0, '[[softurl]]/images/banners/xoops_flashbanner2.htm', 'http://www.xoops.org/', 1008813250, 1, ''),
(2, 1, 0, 1, 0, '[[softurl]]/images/banners/xoops_banner_2.gif', 'http://www.xoops.org/', 1008813250, 0, ''),
(3, 1, 0, 1, 0, '[[softurl]]/images/banners/banner.htm', 'http://www.xoops.org/', 1008813250, 1, ''),
(4, 1, 0, 1, 0, '[[softurl]]/images/banners/xoopsifyIt.gif', 'http://www.xoops.org/', 1008813250, 1, '');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]_bannerclient`
--
CREATE TABLE `[[dbprefix]]_bannerclient` (
`cid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(60) NOT NULL DEFAULT '',
`contact` varchar(60) NOT NULL DEFAULT '',
`email` varchar(60) NOT NULL DEFAULT '',
`login` varchar(10) NOT NULL DEFAULT '',
`passwd` varchar(10) NOT NULL DEFAULT '',
`extrainfo` text,
PRIMARY KEY (`cid`),
KEY `login` (`login`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `[[dbprefix]]_bannerclient`
--
INSERT INTO `[[dbprefix]]_bannerclient` VALUES
(1, 'XOOPS', 'XOOPS Dev Team', 'webmaster@xoops.org', '', '', '');
-- --------------------------------------------------------
--
-- 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=utf8 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=utf8;
--
-- 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=utf8;
-- --------------------------------------------------------
--
-- 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=utf8 AUTO_INCREMENT=135 ;
--
-- Dumping data for table `[[dbprefix]]_config`
--
INSERT INTO `[[dbprefix]]_config` VALUES
(1, 0, 1, 'sitename', '_MD_AM_SITENAME', '[[site_name]]', '_MD_AM_SITENAMEDSC', 'textbox', 'text', 0),
(2, 0, 1, 'slogan', '_MD_AM_SLOGAN', '[[site_desc]]', '_MD_AM_SLOGANDSC', 'textbox', 'text', 2),
(3, 0, 1, 'language', '_MD_AM_LANGUAGE', 'english', '_MD_AM_LANGUAGEDSC', 'language', 'other', 4),
(4, 0, 1, 'startpage', '_MD_AM_STARTPAGE', '--', '_MD_AM_STARTPAGEDSC', 'startpage', 'other', 6),
(5, 0, 1, 'server_TZ', '_MD_AM_SERVERTZ', '0', '_MD_AM_SERVERTZDSC', 'timezone', 'float', 8),
(6, 0, 1, 'default_TZ', '_MD_AM_DEFAULTTZ', '0', '_MD_AM_DEFAULTTZDSC', 'timezone', 'float', 10),
(7, 0, 1, 'theme_set', '_MD_AM_DTHEME', 'xbootstrap', '_MD_AM_DTHEMEDSC', 'theme', 'other', 12),
(8, 0, 1, 'anonymous', '_MD_AM_ANONNAME', 'Anonymous', '_MD_AM_ANONNAMEDSC', 'textbox', 'text', 15),
(9, 0, 1, 'gzip_compression', '_MD_AM_USEGZIP', '0', '_MD_AM_USEGZIPDSC', 'yesno', 'int', 16),
(10, 0, 1, 'usercookie', '_MD_AM_USERCOOKIE', 'xoops_user_[[usercookie]]', '_MD_AM_USERCOOKIEDSC', 'textbox', 'text', 18),
(11, 0, 1, 'session_expire', '_MD_AM_SESSEXPIRE', '15', '_MD_AM_SESSEXPIREDSC', 'textbox', 'int', 22),
(12, 0, 1, 'banners', '_MD_AM_BANNERS', '1', '_MD_AM_BANNERSDSC', 'yesno', 'int', 26),
(13, 0, 1, 'debug_mode', '_MD_AM_DEBUGMODE', '0', '_MD_AM_DEBUGMODEDSC', 'select', 'int', 24),
(14, 0, 1, 'my_ip', '_MD_AM_MYIP', '[[clientip]]', '_MD_AM_MYIPDSC', 'textbox', 'text', 29),
(15, 0, 1, 'use_ssl', '_MD_AM_USESSL', '0', '_MD_AM_USESSLDSC', 'yesno', 'int', 30),
(16, 0, 1, 'session_name', '_MD_AM_SESSNAME', 'xoops_session_[[usercookie]]', '_MD_AM_SESSNAMEDSC', 'textbox', 'text', 20),
(17, 0, 2, 'minpass', '_MD_AM_MINPASS', '5', '_MD_AM_MINPASSDSC', 'textbox', 'int', 1),
(18, 0, 2, 'minuname', '_MD_AM_MINUNAME', '3', '_MD_AM_MINUNAMEDSC', 'textbox', 'int', 2),
(19, 0, 2, 'new_user_notify', '_MD_AM_NEWUNOTIFY', '1', '_MD_AM_NEWUNOTIFYDSC', 'yesno', 'int', 4),
(20, 0, 2, 'new_user_notify_group', '_MD_AM_NOTIFYTO', '1', '_MD_AM_NOTIFYTODSC', 'group', 'int', 6),
(21, 0, 2, 'activation_type', '_MD_AM_ACTVTYPE', '0', '_MD_AM_ACTVTYPEDSC', 'select', 'int', 8),
(22, 0, 2, 'activation_group', '_MD_AM_ACTVGROUP', '1', '_MD_AM_ACTVGROUPDSC', 'group', 'int', 10),
(23, 0, 2, 'uname_test_level', '_MD_AM_UNAMELVL', '0', '_MD_AM_UNAMELVLDSC', 'select', 'int', 12),
(24, 0, 2, 'avatar_allow_upload', '_MD_AM_AVATARALLOW', '0', '_MD_AM_AVATARALWDSC', 'yesno', 'int', 14),
(27, 0, 2, 'avatar_width', '_MD_AM_AVATARW', '128', '_MD_AM_AVATARWDSC', 'textbox', 'int', 16),
(28, 0, 2, 'avatar_height', '_MD_AM_AVATARH', '128', '_MD_AM_AVATARHDSC', 'textbox', 'int', 18),
(29, 0, 2, 'avatar_maxsize', '_MD_AM_AVATARMAX', '35000', '_MD_AM_AVATARMAXDSC', 'textbox', 'int', 20),
(30, 0, 1, 'adminmail', '_MD_AM_ADMINML', '[[admin_email]]', '_MD_AM_ADMINMLDSC', 'textbox', 'text', 3),
(31, 0, 2, 'self_delete', '_MD_AM_SELFDELETE', '0', '_MD_AM_SELFDELETEDSC', 'yesno', 'int', 22),
(32, 0, 1, 'com_mode', '_MD_AM_COMMODE', 'flat', '_MD_AM_COMMODEDSC', 'select', 'text', 34),
(33, 0, 1, 'com_order', '_MD_AM_COMORDER', '0', '_MD_AM_COMORDERDSC', 'select', 'int', 36),
(34, 0, 2, 'bad_unames', '_MD_AM_BADUNAMES', 'a:3:{i:0;s:9:"webmaster";i:1;s:6:"^xoops";i:2;s:6:"^admin";}', '_MD_AM_BADUNAMESDSC', 'textarea', 'array', 24),
(35, 0, 2, 'bad_emails', '_MD_AM_BADEMAILS', 'a:1:{i:0;s:10:"xoops.org$";}', '_MD_AM_BADEMAILSDSC', 'textarea', 'array', 26),
(36, 0, 2, 'maxuname', '_MD_AM_MAXUNAME', '10', '_MD_AM_MAXUNAMEDSC', 'textbox', 'int', 3),
(37, 0, 1, 'bad_ips', '_MD_AM_BADIPS', 'a:1:{i:0;s:9:"127.0.0.1";}', '_MD_AM_BADIPSDSC', 'textarea', 'array', 42),
(38, 0, 3, 'meta_keywords', '_MD_AM_METAKEY', 'xoops, web application framework, cms, content management system', '_MD_AM_METAKEYDSC', 'textarea', 'text', 0),
(39, 0, 3, 'footer', '_MD_AM_FOOTER', 'Powered by XOOPS © 2001-2019 The XOOPS Project', '_MD_AM_FOOTERDSC', 'textarea', 'text', 20),
(40, 0, 4, 'censor_enable', '_MD_AM_DOCENSOR', '0', '_MD_AM_DOCENSORDSC', 'yesno', 'int', 0),
(41, 0, 4, 'censor_words', '_MD_AM_CENSORWRD', 'a:2:{i:0;s:4:"fuck";i:1;s:4:"shit";}', '_MD_AM_CENSORWRDDSC', 'textarea', 'array', 1),
(42, 0, 4, 'censor_replace', '_MD_AM_CENSORRPLC', '#OOPS#', '_MD_AM_CENSORRPLCDSC', 'textbox', 'text', 2),
(43, 0, 3, 'meta_robots', '_MD_AM_METAROBOTS', 'index,follow', '_MD_AM_METAROBOTSDSC', 'textbox', 'text', 2),
(44, 0, 5, 'enable_search', '_MD_AM_DOSEARCH', '1', '_MD_AM_DOSEARCHDSC', 'yesno', 'int', 0),
(45, 0, 5, 'keyword_min', '_MD_AM_MINSEARCH', '5', '_MD_AM_MINSEARCHDSC', 'textbox', 'int', 1),
(46, 0, 2, 'avatar_minposts', '_MD_AM_AVATARMP', '0', '_MD_AM_AVATARMPDSC', 'textbox', 'int', 15),
(47, 0, 1, 'enable_badips', '_MD_AM_DOBADIPS', '0', '_MD_AM_DOBADIPSDSC', 'yesno', 'int', 40),
(48, 0, 3, 'meta_rating', '_MD_AM_METARATING', 'general', '_MD_AM_METARATINGDSC', 'select', 'text', 4),
(49, 0, 3, 'meta_author', '_MD_AM_METAAUTHOR', 'XOOPS', '_MD_AM_METAAUTHORDSC', 'textbox', 'text', 6),
(50, 0, 3, 'meta_copyright', '_MD_AM_METACOPYR', 'Copyright © 2001-2019', '_MD_AM_METACOPYRDSC', 'textbox', 'text', 8),
(51, 0, 3, 'meta_description', '_MD_AM_METADESC', 'XOOPS is a dynamic Object Oriented based open source portal script written in PHP.', '_MD_AM_METADESCDSC', 'textarea', 'text', 1),
(52, 0, 2, 'allow_chgmail', '_MD_AM_ALLWCHGMAIL', '0', '_MD_AM_ALLWCHGMAILDSC', 'yesno', 'int', 3),
(53, 0, 1, 'use_mysession', '_MD_AM_USEMYSESS', '1', '_MD_AM_USEMYSESSDSC', 'yesno', 'int', 19),
(54, 0, 2, 'reg_dispdsclmr', '_MD_AM_DSPDSCLMR', '1', '_MD_AM_DSPDSCLMRDSC', 'yesno', 'int', 30),
(55, 0, 2, 'reg_disclaimer', '_MD_AM_REGDSCLMR', 'While the administrators and moderators of this site will attempt to remove\nor edit any generally objectionable material as quickly as possible, it is\nimpossible to review every message. Therefore you acknowledge that all posts\nmade to this site express the views and opinions of the author and not the\nadministrators, moderators or webmaster (except for posts by these people)\nand hence will not be held liable.\n\nYou agree not to post any abusive, obscene, vulgar, slanderous, hateful,\nthreatening, sexually-orientated or any other material that may violate any\napplicable laws. Doing so may lead to you being immediately and permanently\nbanned (and your service provider being informed). The IP address of all\nposts is recorded to aid in enforcing these conditions. Creating multiple\naccounts for a single user is not allowed. You agree that the webmaster,\nadministrator and moderators of this site have the right to remove, edit,\nmove or close any topic at any time should they see fit. As a user you agree\nto any information you have entered above being stored in a database. While\nthis information will not be disclosed to any third party without your\nconsent the webmaster, administrator and moderators cannot be held\nresponsible for any hacking attempt that may lead to the data being\ncompromised.\n\nThis site system uses cookies to store information on your local computer.\nThese cookies do not contain any of the information you have entered above,\nthey serve only to improve your viewing pleasure. The email address is used\nonly for confirming your registration details and password (and for sending\nnew passwords should you forget your current one).\n\nBy clicking Register below you agree to be bound by these conditions.', '_MD_AM_REGDSCLMRDSC', 'textarea', 'text', 32),
(56, 0, 2, 'allow_register', '_MD_AM_ALLOWREG', '1', '_MD_AM_ALLOWREGDSC', 'yesno', 'int', 0),
(57, 0, 1, 'theme_fromfile', '_MD_AM_THEMEFILE', '0', '_MD_AM_THEMEFILEDSC', 'yesno', 'int', 13),
(58, 0, 1, 'closesite', '_MD_AM_CLOSESITE', '0', '_MD_AM_CLOSESITEDSC', 'yesno', 'int', 26),
(59, 0, 1, 'closesite_okgrp', '_MD_AM_CLOSESITEOK', 'a:1:{i:0;s:1:"1";}', '_MD_AM_CLOSESITEOKDSC', 'group_multi', 'array', 27),
(60, 0, 1, 'closesite_text', '_MD_AM_CLOSESITETXT', 'The site is currently closed for maintenance. Please come back later.', '_MD_AM_CLOSESITETXTDSC', 'textarea', 'text', 28),
(61, 0, 1, 'sslpost_name', '_MD_AM_SSLPOST', 'xoops_ssl', '_MD_AM_SSLPOSTDSC', 'textbox', 'text', 31),
(62, 0, 1, 'module_cache', '_MD_AM_MODCACHE', '', '_MD_AM_MODCACHEDSC', 'module_cache', 'array', 50),
(63, 0, 1, 'template_set', '_MD_AM_DTPLSET', 'default', '_MD_AM_DTPLSETDSC', 'tplset', 'other', 14),
(64, 0, 6, 'mailmethod', '_MD_AM_MAILERMETHOD', 'mail', '_MD_AM_MAILERMETHODDESC', 'select', 'text', 4),
(65, 0, 6, 'smtphost', '_MD_AM_SMTPHOST', 'a:1:{i:0;s:0:"";}', '_MD_AM_SMTPHOSTDESC', 'textarea', 'array', 6),
(66, 0, 6, 'smtpuser', '_MD_AM_SMTPUSER', '', '_MD_AM_SMTPUSERDESC', 'textbox', 'text', 7),
(67, 0, 6, 'smtppass', '_MD_AM_SMTPPASS', '', '_MD_AM_SMTPPASSDESC', 'password', 'text', 8),
(68, 0, 6, 'sendmailpath', '_MD_AM_SENDMAILPATH', '/usr/sbin/sendmail', '_MD_AM_SENDMAILPATHDESC', 'textbox', 'text', 5),
(69, 0, 6, 'from', '_MD_AM_MAILFROM', '', '_MD_AM_MAILFROMDESC', 'textbox', 'text', 1),
(70, 0, 6, 'fromname', '_MD_AM_MAILFROMNAME', '', '_MD_AM_MAILFROMNAMEDESC', 'textbox', 'text', 2),
(71, 0, 1, 'sslloginlink', '_MD_AM_SSLLINK', 'https://', '_MD_AM_SSLLINKDSC', 'textbox', 'text', 33),
(72, 0, 1, 'theme_set_allowed', '_MD_AM_THEMEOK', 'a:1:{i:0;s:10:"xbootstrap";}', '_MD_AM_THEMEOKDSC', 'theme_multi', 'array', 13),
(73, 0, 6, 'fromuid', '_MD_AM_MAILFROMUID', '1', '_MD_AM_MAILFROMUIDDESC', 'user', 'int', 3),
(74, 0, 7, 'auth_method', '_MD_AM_AUTHMETHOD', 'xoops', '_MD_AM_AUTHMETHODDESC', 'select', 'text', 1),
(75, 0, 7, 'ldap_port', '_MD_AM_LDAP_PORT', '389', '_MD_AM_LDAP_PORT', 'textbox', 'int', 2),
(76, 0, 7, 'ldap_server', '_MD_AM_LDAP_SERVER', 'your directory server', '_MD_AM_LDAP_SERVER_DESC', 'textbox', 'text', 3),
(77, 0, 7, 'ldap_base_dn', '_MD_AM_LDAP_BASE_DN', 'dc=xoops,dc=org', '_MD_AM_LDAP_BASE_DN_DESC', 'textbox', 'text', 4),
(78, 0, 7, 'ldap_manager_dn', '_MD_AM_LDAP_MANAGER_DN', 'manager_dn', '_MD_AM_LDAP_MANAGER_DN_DESC', 'textbox', 'text', 5),
(79, 0, 7, 'ldap_manager_pass', '_MD_AM_LDAP_MANAGER_PASS', 'manager_pass', '_MD_AM_LDAP_MANAGER_PASS_DESC', 'password', 'text', 6),
(80, 0, 7, 'ldap_version', '_MD_AM_LDAP_VERSION', '3', '_MD_AM_LDAP_VERSION_DESC', 'textbox', 'text', 7),
(81, 0, 7, 'ldap_users_bypass', '_MD_AM_LDAP_USERS_BYPASS', 'a:1:{i:0;s:5:"admin";}', '_MD_AM_LDAP_USERS_BYPASS_DESC', 'textarea', 'array', 8),
(82, 0, 7, 'ldap_loginname_asdn', '_MD_AM_LDAP_LOGINNAME_ASDN', 'uid_asdn', '_MD_AM_LDAP_LOGINNAME_ASDN_D', 'yesno', 'int', 9),
(83, 0, 7, 'ldap_loginldap_attr', '_MD_AM_LDAP_LOGINLDAP_ATTR', 'uid', '_MD_AM_LDAP_LOGINLDAP_ATTR_D', 'textbox', 'text', 10),
(84, 0, 7, 'ldap_filter_person', '_MD_AM_LDAP_FILTER_PERSON', '', '_MD_AM_LDAP_FILTER_PERSON_DESC', 'textbox', 'text', 11),
(85, 0, 7, 'ldap_domain_name', '_MD_AM_LDAP_DOMAIN_NAME', 'mydomain', '_MD_AM_LDAP_DOMAIN_NAME_DESC', 'textbox', 'text', 12),
(86, 0, 7, 'ldap_provisionning', '_MD_AM_LDAP_PROVIS', '0', '_MD_AM_LDAP_PROVIS_DESC', 'yesno', 'int', 13),
(87, 0, 7, 'ldap_provisionning_group', '_MD_AM_LDAP_PROVIS_GROUP', 'a:1:{i:0;s:1:"2";}', '_MD_AM_LDAP_PROVIS_GROUP_DSC', 'group_multi', 'array', 14),
(88, 0, 7, 'ldap_mail_attr', '_MD_AM_LDAP_MAIL_ATTR', 'mail', '_MD_AM_LDAP_MAIL_ATTR_DESC', 'textbox', 'text', 15),
(89, 0, 7, 'ldap_givenname_attr', '_MD_AM_LDAP_GIVENNAME_ATTR', 'givenname', '_MD_AM_LDAP_GIVENNAME_ATTR_DSC', 'textbox', 'text', 16),
(90, 0, 7, 'ldap_surname_attr', '_MD_AM_LDAP_SURNAME_ATTR', 'sn', '_MD_AM_LDAP_SURNAME_ATTR_DESC', 'textbox', 'text', 17),
(91, 0, 7, 'ldap_field_mapping', '_MD_AM_LDAP_FIELD_MAPPING_ATTR', 'email=mail|name=displayname', '_MD_AM_LDAP_FIELD_MAPPING_DESC', 'textarea', 'text', 18),
(92, 0, 7, 'ldap_provisionning_upd', '_MD_AM_LDAP_PROVIS_UPD', '1', '_MD_AM_LDAP_PROVIS_UPD_DESC', 'yesno', 'int', 19),
(93, 0, 7, 'ldap_use_TLS', '_MD_AM_LDAP_USETLS', '0', '_MD_AM_LDAP_USETLS_DESC', 'yesno', 'int', 20),
(94, 0, 1, 'cpanel', '_MD_AM_CPANEL', 'transition', '_MD_AM_CPANELDSC', 'cpanel', 'other', 11),
(95, 0, 2, 'welcome_type', '_MD_AM_WELCOMETYPE', '1', '_MD_AM_WELCOMETYPE_DESC', 'select', 'int', 3),
(96, 1, 0, 'break1', '_MI_SYSTEM_PREFERENCE_BREAK_GENERAL', 'head', '', 'line_break', 'textbox', 0),
(97, 1, 0, 'usetips', '_MI_SYSTEM_PREFERENCE_TIPS', '1', '_MI_SYSTEM_PREFERENCE_TIPS_DSC', 'yesno', 'int', 10),
(98, 1, 0, 'typeicons', '_MI_SYSTEM_PREFERENCE_ICONS', 'transition', '', 'select', 'text', 20),
(99, 1, 0, 'typebreadcrumb', '_MI_SYSTEM_PREFERENCE_BREADCRUMB', 'default', '', 'select', 'text', 30),
(100, 1, 0, 'break2', '_MI_SYSTEM_PREFERENCE_BREAK_ACTIVE', 'head', '', 'line_break', 'textbox', 40),
(101, 1, 0, 'active_avatars', '_MI_SYSTEM_PREFERENCE_ACTIVE_AVATARS', '1', '', 'yesno', 'int', 50),
(102, 1, 0, 'active_banners', '_MI_SYSTEM_PREFERENCE_ACTIVE_BANNERS', '1', '', 'yesno', 'int', 60),
(103, 1, 0, 'active_blocksadmin', '_MI_SYSTEM_PREFERENCE_ACTIVE_BLOCKSADMIN', '1', '', 'hidden', 'int', 70),
(104, 1, 0, 'active_comments', '_MI_SYSTEM_PREFERENCE_ACTIVE_COMMENTS', '1', '', 'yesno', 'int', 80),
(105, 1, 0, 'active_filemanager', '_MI_SYSTEM_PREFERENCE_ACTIVE_FILEMANAGER', '1', '', 'yesno', 'int', 90),
(106, 1, 0, 'active_groups', '_MI_SYSTEM_PREFERENCE_ACTIVE_GROUPS', '1', '', 'hidden', 'int', 100),
(107, 1, 0, 'active_images', '_MI_SYSTEM_PREFERENCE_ACTIVE_IMAGES', '1', '', 'yesno', 'int', 110),
(108, 1, 0, 'active_mailusers', '_MI_SYSTEM_PREFERENCE_ACTIVE_MAILUSERS', '1', '', 'yesno', 'int', 120),
(109, 1, 0, 'active_modulesadmin', '_MI_SYSTEM_PREFERENCE_ACTIVE_MODULESADMIN', '1', '', 'hidden', 'int', 130),
(110, 1, 0, 'active_maintenance', '_MI_SYSTEM_PREFERENCE_ACTIVE_MAINTENANCE', '1', '', 'yesno', 'int', 140),
(111, 1, 0, 'active_preferences', '_MI_SYSTEM_PREFERENCE_ACTIVE_PREFERENCES', '1', '', 'hidden', 'int', 150),
(112, 1, 0, 'active_smilies', '_MI_SYSTEM_PREFERENCE_ACTIVE_SMILIES', '1', '', 'yesno', 'int', 160),
(113, 1, 0, 'active_tplsets', '_MI_SYSTEM_PREFERENCE_ACTIVE_TPLSETS', '1', '', 'hidden', 'int', 170),
(114, 1, 0, 'active_userrank', '_MI_SYSTEM_PREFERENCE_ACTIVE_USERRANK', '1', '', 'yesno', 'int', 180),
(115, 1, 0, 'active_users', '_MI_SYSTEM_PREFERENCE_ACTIVE_USERS', '1', '', 'yesno', 'int', 190),
(116, 1, 0, 'break3', '_MI_SYSTEM_PREFERENCE_BREAK_PAGER', 'head', '', 'line_break', 'textbox', 200),
(117, 1, 0, 'avatars_pager', '_MI_SYSTEM_PREFERENCE_AVATARS_PAGER', '10', '', 'textbox', 'int', 210),
(118, 1, 0, 'banners_pager', '_MI_SYSTEM_PREFERENCE_BANNERS_PAGER', '10', '', 'textbox', 'int', 220),
(119, 1, 0, 'comments_pager', '_MI_SYSTEM_PREFERENCE_COMMENTS_PAGER', '20', '', 'textbox', 'int', 230),
(120, 1, 0, 'groups_pager', '_MI_SYSTEM_PREFERENCE_GROUPS_PAGER', '15', '', 'textbox', 'int', 240),
(121, 1, 0, 'images_pager', '_MI_SYSTEM_PREFERENCE_IMAGES_PAGER', '15', '', 'textbox', 'int', 250),
(122, 1, 0, 'smilies_pager', '_MI_SYSTEM_PREFERENCE_SMILIES_PAGER', '20', '', 'textbox', 'int', 260),
(123, 1, 0, 'userranks_pager', '_MI_SYSTEM_PREFERENCE_USERRANKS_PAGER', '20', '', 'textbox', 'int', 270),
(124, 1, 0, 'users_pager', '_MI_SYSTEM_PREFERENCE_USERS_PAGER', '20', '', 'textbox', 'int', 280),
(125, 1, 0, 'break4', '_MI_SYSTEM_PREFERENCE_BREAK_EDITOR', 'head', '', 'line_break', 'textbox', 290),
(126, 1, 0, 'blocks_editor', '_MI_SYSTEM_PREFERENCE_BLOCKS_EDITOR', 'dhtmltextarea', '_MI_SYSTEM_PREFERENCE_BLOCKS_EDITOR_DSC', 'select', 'text', 300),
(127, 1, 0, 'comments_editor', '_MI_SYSTEM_PREFERENCE_COMMENTS_EDITOR', 'dhtmltextarea', '_MI_SYSTEM_PREFERENCE_COMMENTS_EDITOR_DSC', 'select', 'text', 310),
(128, 1, 0, 'general_editor', '_MI_SYSTEM_PREFERENCE_GENERAL_EDITOR', 'dhtmltextarea', '_MI_SYSTEM_PREFERENCE_GENERAL_EDITOR_DSC', 'select', 'text', 320),
(129, 1, 0, 'redirect', '_MI_SYSTEM_PREFERENCE_REDIRECT', 'admin.php?fct=preferences', '', 'hidden', 'text', 330),
(130, 1, 0, 'com_anonpost', '_MI_SYSTEM_PREFERENCE_ANONPOST', '', '', 'hidden', 'text', 340),
(133, 1, 0, 'jquery_theme', '_MI_SYSTEM_PREFERENCE_JQUERY_THEME', 'base', '', 'select', 'text', 35),
(134, 0, 1, 'redirect_message_ajax', '_MD_AM_CUSTOM_REDIRECT', '1', '_MD_AM_CUSTOM_REDIRECT_DESC', 'yesno', 'int', 12);
-- --------------------------------------------------------
--
-- 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=utf8 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=utf8 AUTO_INCREMENT=54 ;
--
-- 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, 'dhtmltextarea', 'dhtmltextarea', 126),
(36, 'textarea', 'textarea', 126),
(37, 'tinymce', 'tinymce', 126),
(38, 'dhtmltextarea', 'dhtmltextarea', 127),
(39, 'textarea', 'textarea', 127),
(40, 'tinymce', 'tinymce', 127),
(41, 'dhtmltextarea', 'dhtmltextarea', 128),
(42, 'textarea', 'textarea', 128),
(43, 'tinymce', 'tinymce', 128),
(44, 'default', 'default', 98),
(45, 'transition', 'transition', 98),
(46, 'default', 'default', 99),
(47, 'base', 'base', 133),
(48, 'cupertino', 'cupertino', 133),
(49, 'redmond', 'redmond', 133),
(50, 'smoothness', 'smoothness', 133),
(51, 'south-street', 'south-street', 133),
(52, 'ui-darkness', 'ui-darkness', 133),
(53, 'ui-lightness', 'ui-lightness', 133);
-- --------------------------------------------------------
--
-- 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=utf8 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=utf8 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=utf8 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=utf8 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=utf8;
-- --------------------------------------------------------
--
-- 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=utf8 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=utf8 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=utf8 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=utf8;
--
-- 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` smallint(5) unsigned NOT NULL DEFAULT '100',
`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=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `[[dbprefix]]_modules`
--
INSERT INTO `[[dbprefix]]_modules` VALUES
(1, 'System', 214, [[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=utf8 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=utf8;
-- --------------------------------------------------------
--
-- 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',
PRIMARY KEY (`msg_id`),
KEY `to_userid` (`to_userid`),
KEY `touseridreadmsg` (`to_userid`,`read_msg`),
KEY `msgidfromuserid` (`from_userid`,`msg_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 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=utf8 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');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]_session`
--
CREATE TABLE `[[dbprefix]]_session` (
`sess_id` varchar(256) CHARACTER SET ascii NOT NULL DEFAULT '',
`sess_updated` int(10) unsigned NOT NULL DEFAULT '0',
`sess_ip` varchar(45) NOT NULL DEFAULT '',
`sess_data` text,
PRIMARY KEY (`sess_id`),
KEY `updated` (`sess_updated`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- 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=utf8 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=utf8 AUTO_INCREMENT=75 ;
--
-- 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_imagemanager.html', '', [[timestamp]], [[timestamp]], 'module'),
(26, 1, 'system', 'default', 'system_imagemanager2.html', '', [[timestamp]], [[timestamp]], 'module'),
(27, 1, 'system', 'default', 'system_userinfo.html', '', [[timestamp]], [[timestamp]], 'module'),
(28, 1, 'system', 'default', 'system_userform.html', '', [[timestamp]], [[timestamp]], 'module'),
(29, 1, 'system', 'default', 'system_rss.html', '', [[timestamp]], [[timestamp]], 'module'),
(30, 1, 'system', 'default', 'system_redirect.html', '', [[timestamp]], [[timestamp]], 'module'),
(31, 1, 'system', 'default', 'system_comment.html', '', [[timestamp]], [[timestamp]], 'module'),
(32, 1, 'system', 'default', 'system_comments_flat.html', '', [[timestamp]], [[timestamp]], 'module'),
(33, 1, 'system', 'default', 'system_comments_thread.html', '', [[timestamp]], [[timestamp]], 'module'),
(34, 1, 'system', 'default', 'system_comments_nest.html', '', [[timestamp]], [[timestamp]], 'module'),
(35, 1, 'system', 'default', 'system_siteclosed.html', '', [[timestamp]], [[timestamp]], 'module'),
(36, 1, 'system', 'default', 'system_dummy.html', '', [[timestamp]], [[timestamp]], 'module'),
(37, 1, 'system', 'default', 'system_notification_list.html', '', [[timestamp]], [[timestamp]], 'module'),
(38, 1, 'system', 'default', 'system_notification_select.html', '', [[timestamp]], [[timestamp]], 'module'),
(39, 1, 'system', 'default', 'system_block_dummy.html', '', [[timestamp]], [[timestamp]], 'module'),
(40, 1, 'system', 'default', 'system_homepage.html', '', [[timestamp]], [[timestamp]], 'module'),
(41, 1, 'system', 'default', 'system_bannerlogin.html', '', [[timestamp]], [[timestamp]], 'module'),
(42, 1, 'system', 'default', 'system_banner.html', '', [[timestamp]], [[timestamp]], 'module'),
(43, 1, 'system', 'default', 'system_bannerdisplay.html', '', [[timestamp]], [[timestamp]], 'module'),
(44, 1, 'system', 'default', 'system_header.tpl', '', [[timestamp]], [[timestamp]], 'admin'),
(45, 1, 'system', 'default', 'system_banners.tpl', '', [[timestamp]], [[timestamp]], 'admin'),
(46, 1, 'system', 'default', 'system_modules.tpl', '', [[timestamp]], [[timestamp]], 'admin'),
(47, 1, 'system', 'default', 'system_modules_confirm.tpl', '', [[timestamp]], [[timestamp]], 'admin'),
(48, 1, 'system', 'default', 'system_avatars.tpl', '', [[timestamp]], [[timestamp]], 'admin'),
(49, 1, 'system', 'default', 'system_smilies.tpl', '', [[timestamp]], [[timestamp]], 'admin'),
(50, 1, 'system', 'default', 'system_blocks.tpl', '', [[timestamp]], [[timestamp]], 'admin'),
(51, 1, 'system', 'default', 'system_blocks_item.tpl', '', [[timestamp]], [[timestamp]], 'admin'),
(52, 1, 'system', 'default', 'system_comments.tpl', '', [[timestamp]], [[timestamp]], 'admin'),
(53, 1, 'system', 'default', 'system_userrank.tpl', '', [[timestamp]], [[timestamp]], 'admin'),
(54, 1, 'system', 'default', 'system_users.tpl', '', [[timestamp]], [[timestamp]], 'admin'),
(55, 1, 'system', 'default', 'system_preferences.tpl', '', [[timestamp]], [[timestamp]], 'admin'),
(56, 1, 'system', 'default', 'system_mailusers.tpl', '', [[timestamp]], [[timestamp]], 'admin'),
(57, 1, 'system', 'default', 'system_groups.tpl', '', [[timestamp]], [[timestamp]], 'admin'),
(58, 1, 'system', 'default', 'system_images.tpl', '', [[timestamp]], [[timestamp]], 'admin'),
(59, 1, 'system', 'default', 'system_templates.tpl', '', [[timestamp]], [[timestamp]], 'admin'),
(60, 1, 'system', 'default', 'system_index.tpl', '', [[timestamp]], [[timestamp]], 'admin'),
(61, 1, 'system', 'default', 'system_maintenance.tpl', '', [[timestamp]], [[timestamp]], 'admin'),
(62, 1, 'system', 'default', 'system_help.tpl', '', [[timestamp]], [[timestamp]], 'admin'),
(63, 1, 'system', 'default', 'system_block_user.tpl', 'Shows user block', [[timestamp]], [[timestamp]], 'block'),
(64, 2, 'system', 'default', 'system_block_login.tpl', 'Shows login form', [[timestamp]], [[timestamp]], 'block'),
(65, 3, 'system', 'default', 'system_block_search.tpl', 'Shows search form block', [[timestamp]], [[timestamp]], 'block'),
(66, 4, 'system', 'default', 'system_block_waiting.tpl', 'Shows contents waiting for approval', [[timestamp]], [[timestamp]], 'block'),
(67, 5, 'system', 'default', 'system_block_mainmenu.tpl', 'Shows the main navigation menu of the site', [[timestamp]], [[timestamp]], 'block'),
(68, 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'),
(69, 7, 'system', 'default', 'system_block_online.tpl', 'Displays users/guests currently online', [[timestamp]], [[timestamp]], 'block'),
(70, 8, 'system', 'default', 'system_block_topusers.tpl', 'Top posters', [[timestamp]], [[timestamp]], 'block'),
(71, 9, 'system', 'default', 'system_block_newusers.tpl', 'Shows most recent users', [[timestamp]], [[timestamp]], 'block'),
(72, 10, 'system', 'default', 'system_block_comments.tpl', 'Shows most recent comments', [[timestamp]], [[timestamp]], 'block'),
(73, 11, 'system', 'default', 'system_block_notification.tpl', 'Shows notification options', [[timestamp]], [[timestamp]], 'block'),
(74, 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=utf8 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=utf8;
--
-- Dumping data for table `[[dbprefix]]_tplsource`
--
INSERT INTO `[[dbprefix]]_tplsource` VALUES
(1, '\n\n\n \n \n /var/softaculous/xoops/xoops.sql (262199B)
| <{$lang_imagename}> | \n<{$lang_image}> | \n<{$lang_imagemime}> | \n<{$lang_align}> | \n
|---|---|---|---|
| <{$images[i].nicename}> | \n<{$images[i].mimetype}> | \n\n \n \n |
| <{$lang_imgmanager}> | \n
<{$imgcat_name}>
\n\n<{$smarty.const._IMGMAXSIZE}> <{$imgcat_maxsize}>
\n<{$smarty.const._IMGMAXWIDTH}> <{$imgcat_maxwidth}>
\n<{$smarty.const._IMGMAXHEIGHT}> <{$imgcat_maxheight}>
\n\n\n\n\n\n\n\n'),
(3, '<{if $user_ownpage == true}>\n \n \n
\n<{elseif $xoops_isadmin != false}>\n
\n
\n
| \n \n |
\n
\n<{/if}>\n\n
\n
| \n \n
\n
| \n |||||||||||||||||||||||||||||||||||||||||
\n
<{$module.name}>
\n \n <{foreach item=result from=$module.results}>\n\n (<{$result.time|default:''''}>)\n
\n <{/foreach}>\n \n\n <{$module.showall_link}>\n\n\n<{/foreach}>\n\n'), (4, '\n\n
\n\n\n'), (5, '\n
\n
\n<{if $xoops_logdump != ''''}>\n <{$message}>
\n\n<{$lang_ifnotreload}>
\n<{$xoops_logdump}>
\n<{/if}>\n\n\n'),
(7, '\n<{$lang_posted}>: <{$comment.date_posted}> \n <{if $comment.date_posted != $comment.date_modified}>\n <{$lang_updated}>:<{$comment.date_modified}>\n <{/if}>\n
\n \n 
\n
\n <{$comment.poster.rank_title}>
\n <{$lang_joined}>: <{$comment.poster.regdate}>
\n <{$lang_from}>: <{$comment.poster.from}>
\n <{$lang_posts}>: <{$comment.poster.postnum}>
\n <{$comment.poster.status}>
\n <{$comment.image}><{$comment.title}>
\n <{$comment.text}>
\n | <{$lang_poster}> | \n<{$lang_thread}> | \n
|---|
<{$commentform}>
<{/if}>\n'),
(10, '<{section name=i loop=$comments}>\n \n
| <{$lang_poster}> | \n<{$lang_thread}> | \n
|---|
\n <{$lang_top}> | <{$lang_parent}>\n
\n <{/if}>\n\n <{if $comments[i].show_replies == true}>\n \n \n
| <{$lang_subject}> | \n<{$lang_poster}> | \n<{$lang_posted}> | \n
|---|---|---|
| <{$reply.prefix}> <{$reply.title}>\n | \n<{$reply.poster.uname}> | \n<{$reply.date_posted}> | \n
<{$commentform}>
<{/if}>\n'),
(11, '<{section name=i loop=$comments}>\n \n
| <{$lang_poster}> | \n<{$lang_thread}> | \n
|---|
\n
| \n | \n
| \n
<{$commentform}>
<{/if}>\n'),
(12, '\n\n\n \n \n | \n | |
| \n | |
| \n \n <{$lang_siteclosemsg}>\n \n | \n
| \n |
<{$lang_activenotifications}>
\n\n'), (15, '<{if $xoops_notification.show}>\n \n<{/if}>\n'), (16, '<{$block.content}>'), (17, '\n'), (18, '\n
\n'),
(19, '<{$smarty.const._BANNERS_LOGIN_TITLE}>
\n\n \n<{$smarty.const._BANNERS_MANAGEMENT}>
\n<{$welcomeuser}>
\n\n<{$smarty.const._BANNERS_TITLE}>
\n| <{$smarty.const._BANNERS_NO}> | \n<{$smarty.const._BANNERS_IMP_MADE}> | \n<{$smarty.const._BANNERS_IMP_TOTAL}> | \n<{$smarty.const._BANNERS_IMP_LEFT}> | \n<{$smarty.const._BANNERS_CLICKS}> | \n<{$smarty.const._BANNERS_PER_CLICKS}> | \n<{$smarty.const._BANNERS_FUNCTIONS}> | \n
|---|---|---|---|---|---|---|
| <{$banner.bid}> | \n<{$banner.impmade}> | \n<{$banner.imptotal}> | \n<{$banner.left}> | \n<{$banner.clicks}> | \n<{$banner.percent}>% | \n\n <{$smarty.const._BANNERS_STATS}>\n <{$smarty.const._BANNERS_SHOWBANNER}>\n | \n
| <{$smarty.const._BANNERS_NOTHINGFOUND}> | \n||||||
| \n | ||||||
\n\n
<{$smarty.const._BANNERS_FINISHED}>
\n\n| <{$smarty.const._BANNERS_NO}> | \n<{$smarty.const._BANNERS_IMP_MADE}> | \n<{$smarty.const._BANNERS_CLICKS}> | \n<{$smarty.const._BANNERS_PER_CLICKS}> | \n<{$smarty.const._BANNERS_STARTED}> | \n<{$smarty.const._BANNERS_ENDED}> | \n|
|---|---|---|---|---|---|---|
| <{$ebanner.bid}> | \n<{$ebanner.impressions}> | \n<{$ebanner.clicks}> | \n<{$ebanner.percent}> | \n<{$ebanner.datestart}> | \n<{$ebanner.dateend}>% | \n|
| <{$smarty.const._BANNERS_NOTHINGFOUND}> | \n||||||
| \n | ||||||
\n'), (20, '
<{$smarty.const._BANNERS_MANAGEMENT}>
\n<{$welcomeuser}>
\n\n\n<{$banneractive}>
\n<{if $count}>\n <{foreach item=banner from=$banners}>\n \n <{/foreach}>\n<{/if}>\n'), (21, '<{if $results}> \n
<{$smarty.const._SR_SEARCHRESULTS}>
\n <{$smarty.const._SR_KEYWORDS}>: <{$keywords}>\n\n <{if $error_length != ''''}>\n <{$error_length}> <{$error_keywords}>\n
\n <{/if}>\n <{if $nomatch}> \n
\n <{$nomatch}>\n
\n <{/if}>\n <{foreach item=search from=$search}>\n
<{$search.module_name}>
\n <{foreach item=data from=$search.module_data}>\n\n <{if $data.uname}>\n \n <{$data.uname}>\n <{if $data.time}>\n (<{$data.time}>)\n <{/if}> \n \n
\n <{/if}>\n <{/foreach}>\n <{if $search.module_show_all}>\n
\n <{$smarty.const._SR_SHOWALLR}>\n
\n <{/if}>\n <{/foreach}>\n<{/if}>\n<{if $showallbyuser}> \n<{$smarty.const._SR_SEARCHRESULTS}>
\n <{if $showall}>\n <{$smarty.const._SR_KEYWORDS}>: <{$keywords}>\n\n <{/if}>\n <{$showing}>\n
<{$module_name}>
\n <{foreach item=data from=$results_arr}>\n\n <{if $data.uname}>\n \n <{$data.uname}>\n <{if $data.time}>\n (<{$data.time}>)\n <{/if}> \n \n
\n <{/if}>\n <{/foreach}>\n <{if $nomatch}>\n
\n <{$smarty.const._SR_NOMATCH}>\n
\n <{/if}>\n <{if $previous || next}>\n\n
| \n <{$smarty.const._SR_PREVIOUS}>\n | \n <{/if}>\n <{if $next}>\n\n <{$smarty.const._SR_NEXT}>\n | \n <{/if}>\n
\n <{$form}>\n<{/if}>\n'), (22, '\n\n\n \n \n
| <{$lang_imagename}> | \n<{$lang_image}> | \n<{$lang_imagemime}> | \n<{$lang_align}> | \n
|---|---|---|---|
| <{$images[i].nicename}> | \n<{$images[i].mimetype}> | \n\n \n \n |
| <{$lang_imgmanager}> | \n
<{$imgcat_name}>
\n\n<{$smarty.const._IMGMAXSIZE}> <{$imgcat_maxsize}>
\n<{$smarty.const._IMGMAXWIDTH}> <{$imgcat_maxwidth}>
\n<{$smarty.const._IMGMAXHEIGHT}> <{$imgcat_maxheight}>
\n\n\n\n\n\n\n\n'),
(27, '<{if $user_ownpage == true}>\n \n \n
\n<{elseif $xoops_isadmin != false}>\n
\n
\n
| \n \n |
\n
\n<{/if}>\n\n
\n
| \n \n
\n
| \n |||||||||||||||||||||||||||||||||||||||||
\n
<{$module.name}>
\n \n <{foreach item=result from=$module.results}>\n\n (<{$result.time|default:''''}>)\n
\n <{/foreach}>\n \n\n <{$module.showall_link}>\n\n\n<{/foreach}>\n\n'), (28, '\n\n
\n\n\n'), (29, '\n
\n
\n<{if $xoops_logdump != ''''}>\n <{$message}>
\n\n<{$lang_ifnotreload}>
\n<{$xoops_logdump}>
\n<{/if}>\n\n\n'),
(31, '\n<{$lang_posted}>: <{$comment.date_posted}> \n <{if $comment.date_posted != $comment.date_modified}>\n <{$lang_updated}>:<{$comment.date_modified}>\n <{/if}>\n
\n \n \n
\n <{$comment.poster.rank_title}>
\n <{$lang_joined}>: <{$comment.poster.regdate}>
\n <{$lang_from}>: <{$comment.poster.from}>
\n <{$lang_posts}>: <{$comment.poster.postnum}>
\n <{$comment.poster.status}>
\n <{$comment.image}><{$comment.title}>
\n <{$comment.text}>
\n 
\n 
\n 
\n \n \n \n | <{$lang_poster}> | \n<{$lang_thread}> | \n
|---|
<{$commentform}>
<{/if}>\n'),
(33, '<{section name=i loop=$comments}>\n \n
| <{$lang_poster}> | \n<{$lang_thread}> | \n
|---|
\n <{$lang_top}> | <{$lang_parent}>\n
\n <{/if}>\n\n <{if $comments[i].show_replies == true}>\n \n \n
| <{$lang_subject}> | \n<{$lang_poster}> | \n<{$lang_posted}> | \n
|---|---|---|
| <{$reply.prefix}> <{$reply.title}>\n | \n<{$reply.poster.uname}> | \n<{$reply.date_posted}> | \n
<{$commentform}>
<{/if}>\n'),
(34, '<{section name=i loop=$comments}>\n \n
| <{$lang_poster}> | \n<{$lang_thread}> | \n
|---|
\n
| \n | \n
| \n
<{$commentform}>
<{/if}>\n'),
(35, '\n\n\n \n \n | \n | |
| \n | |
| \n \n <{$lang_siteclosemsg}>\n \n | \n
| \n |
<{$lang_activenotifications}>
\n\n'), (38, '<{if $xoops_notification.show}>\n \n<{/if}>\n'), (39, '<{$block.content}>'), (40, '\n'), (41, '\n
\n'),
(42, '<{$smarty.const._BANNERS_LOGIN_TITLE}>
\n\n \n<{$smarty.const._BANNERS_MANAGEMENT}>
\n<{$welcomeuser}>
\n\n<{$smarty.const._BANNERS_TITLE}>
\n| <{$smarty.const._BANNERS_NO}> | \n<{$smarty.const._BANNERS_IMP_MADE}> | \n<{$smarty.const._BANNERS_IMP_TOTAL}> | \n<{$smarty.const._BANNERS_IMP_LEFT}> | \n<{$smarty.const._BANNERS_CLICKS}> | \n<{$smarty.const._BANNERS_PER_CLICKS}> | \n<{$smarty.const._BANNERS_FUNCTIONS}> | \n
|---|---|---|---|---|---|---|
| <{$banner.bid}> | \n<{$banner.impmade}> | \n<{$banner.imptotal}> | \n<{$banner.left}> | \n<{$banner.clicks}> | \n<{$banner.percent}>% | \n\n <{$smarty.const._BANNERS_STATS}>\n <{$smarty.const._BANNERS_SHOWBANNER}>\n | \n
| <{$smarty.const._BANNERS_NOTHINGFOUND}> | \n||||||
| \n | ||||||
\n\n
<{$smarty.const._BANNERS_FINISHED}>
\n\n| <{$smarty.const._BANNERS_NO}> | \n<{$smarty.const._BANNERS_IMP_MADE}> | \n<{$smarty.const._BANNERS_CLICKS}> | \n<{$smarty.const._BANNERS_PER_CLICKS}> | \n<{$smarty.const._BANNERS_STARTED}> | \n<{$smarty.const._BANNERS_ENDED}> | \n|
|---|---|---|---|---|---|---|
| <{$ebanner.bid}> | \n<{$ebanner.impressions}> | \n<{$ebanner.clicks}> | \n<{$ebanner.percent}> | \n<{$ebanner.datestart}> | \n<{$ebanner.dateend}>% | \n|
| <{$smarty.const._BANNERS_NOTHINGFOUND}> | \n||||||
| \n | ||||||
\n'), (43, '
<{$smarty.const._BANNERS_MANAGEMENT}>
\n<{$welcomeuser}>
\n\n\n<{$banneractive}>
\n<{if $count}>\n <{foreach item=banner from=$banners}>\n \n <{/foreach}>\n<{/if}>\n'), (44, '
- \n <{foreach item=breadcrumb from=$xo_sys_breadcrumb}>\n <{if $breadcrumb.home}>\n
- <{$breadcrumb.title}>\n \n <{else}>\n
- <{$breadcrumb.title}> \n <{/if}>\n <{/if}>\n <{/foreach}>\n <{if $xo_sys_help}>\n
- \n
\n \n \n <{/if}>\n
\n <{includeq file="$help_content"}>\n
\n<{/if}>\n<{if $xo_sys_tips}>\n \n 
\n\n \n
\n<{else}>\n \n\n <{$xo_sys_tips}>
\n \n<{/if}>\n'); INSERT INTO `[[dbprefix]]_tplsource` VALUES (45, '<{includeq file="db:system_header.tpl"}>\n\n
\n <{$smarty.const._AM_SYSTEM_BANNERS_CURACTBNR}>\n | \n <{/if}>\n \n \n | \n
\n <{$smarty.const._AM_SYSTEM_BANNERS_ADDNWBNR}>\n 
\n <{$smarty.const._AM_SYSTEM_BANNERS_ADDCLI}>\n | <{$smarty.const._AM_SYSTEM_BANNERS_IMPRESION}> | \n<{$smarty.const._AM_SYSTEM_BANNERS_IMPLEFT}> | \n<{$smarty.const._AM_SYSTEM_BANNERS_CLICKS}> | \n<{$smarty.const._AM_SYSTEM_BANNERS_NCLICKS}> | \n<{$smarty.const._AM_SYSTEM_BANNERS_CLINAME}> | \n<{$smarty.const._AM_SYSTEM_BANNERS_FUNCTION}> | \n
|---|---|---|---|---|---|
| <{$banner.impmade}> | \n<{$banner.left}> | \n<{$banner.clicks}> | \n<{$banner.percent}>% | \n<{$banner.name}> | \n\n  \n \n  \n \n \n  \n \n | \n
<{$nav_menu_banner}>
\n \n <{/if}>\n \n <{foreach item=banner from=$popup_banner}>\n \n <{/foreach}>\n \n<{/if}>\n\n\n<{if $banner_finish_count == true}>\n <{$smarty.const._AM_SYSTEM_BANNERS_FINISHBNR}>
\n| <{$smarty.const._AM_SYSTEM_BANNERS_IMPD}> | \n<{$smarty.const._AM_SYSTEM_BANNERS_CLICKS}> | \n<{$smarty.const._AM_SYSTEM_BANNERS_NCLICKS}> | \n<{$smarty.const._AM_SYSTEM_BANNERS_STARTDATE}> | \n<{$smarty.const._AM_SYSTEM_BANNERS_ENDDATE}> | \n<{$smarty.const._AM_SYSTEM_BANNERS_CLINAME}> | \n<{$smarty.const._AM_SYSTEM_BANNERS_FUNCTION}> | \n
|---|---|---|---|---|---|---|
| <{$banner_finish.impressions}> | \n<{$banner_finish.clicks}> | \n<{$banner_finish.percent}>% | \n<{$banner_finish.datestart}> | \n<{$banner_finish.dateend}> | \n<{$banner_finish.name}> | \n\n \n \n \n | \n
<{$nav_menu_bannerF}>
\n \n <{/if}>\n\n<{/if}>\n\n<{if $banner_client_count == true}>\n <{$smarty.const._AM_SYSTEM_BANNERS_ADVCLI}>
\n| <{$smarty.const._AM_SYSTEM_BANNERS_CLINAME}> | \n<{$smarty.const._AM_SYSTEM_BANNERS_ACTIVEBNR}> | \n<{$smarty.const._AM_SYSTEM_BANNERS_CONTNAME}> | \n<{$smarty.const._AM_SYSTEM_BANNERS_CONTMAIL}> | \n<{$smarty.const._AM_SYSTEM_BANNERS_FUNCTION}> | \n
|---|---|---|---|---|
| <{$banner_client.name}> | \n<{$banner_client.banner_active}> | \n<{$banner_client.contact}> | \n<{$banner_client.email}> | \n\n \n \n \n \n \n \n | \n
<{$nav_menu_client}>
\n \n <{/if}>\n<{/if}>\n\n\n<{if $form}>\n
<{$form}>
\n<{/if}>\n'),
(46, '<{includeq file="db:system_header.tpl"}>\n<{if $install_mods}>\n \n \n 
\n 
\n
\n \n \n \n<{/if}>\n\n<{if $toinstall_mods}>\n \n \n \n \n \n
\n \n \n \n | <{$smarty.const._AM_SYSTEM_MODULES_MODULE}> | \n<{$smarty.const._AM_SYSTEM_MODULES_VERSION}> | \n<{$smarty.const._AM_SYSTEM_MODULES_ACTION}> | \n
|---|---|---|
| \n \n <{if $row.hasadmin == 1 && $row.isactive == 1}>\n \n \n \n <{else}>\n \n <{/if}>\n <{$row.name}>\n \n | \n <{$row.version}> <{$row.module_status}> | \n\n \n  \n \n  \n | \n
\n \n \n
\n
\n<{/foreach}>\n\n'),
(47, '<{includeq file="db:system_header.tpl"}>\n<{if $modifs_mods}>\n \n<{else}>\n | \n | \n \n
| \n
<{$row.description}>
\n\n <{if $result}>\n
\n<{/if}>\n'),
(48, '\n<{includeq file="db:system_header.tpl"}>\n\n\n<{if $type == ''s''}>\n \n <{foreach item=row from=$result}>\n
\n <{/if}>\n <{$smarty.const._AM_SYSTEM_MODULES_BTOMADMIN}>\n <{$row}>
\n <{/foreach}>\n \n
\n<{/if}>\n<{if $view_cat}>\n \n \n \n
\n | <{$smarty.const._AM_SYSTEM_AVATAR_SYSTEM}> | \n<{$smarty.const._AM_SYSTEM_AVATAR_CUSTOM}> | \n
|---|---|
\n \n  \n \n\n <{$smarty.const._AM_SYSTEM_AVATAR_SYSTEM}> : <{$count_system}> \n | \n \n \n  \n \n\n <{$smarty.const._AM_SYSTEM_AVATAR_CUSTOM}> : <{$count_custom}> \n | \n
\n<{/if}>\n\n<{if $avatars_list}>\n <{foreach item=avatar from=$avatars_list}>\n
\n \n
\n <{/foreach}>\n \n 
\n 
\n <{if $avatar.type == ''c''}>\n 
\n <{/if}>\n <{$nav_menu}>
\n \n <{/if}>\n<{/if}>\n\n<{if $multiupload}>\n \n \n
\n <{$smarty.const._AM_SYSTEM_AVATAR_SYSTEM}>
\n \n<{$smarty.const._IMGMAXSIZE}> <{$imgcat_maxsize}>
\n <{$smarty.const._IMGMAXWIDTH}> <{$imgcat_maxwidth}>
\n <{$smarty.const._IMGMAXHEIGHT}> <{$imgcat_maxheight}>
\n \n \n<{/if}>\n\n\n<{if $form}>\n <{$form}>
\n<{/if}>\n\n'),
(49, '\n<{includeq file="db:system_header.tpl"}>\n\n<{if $smilies_count == true}>\n \n \n
\n 
\n <{$smarty.const._AM_SYSTEM_SMILIES_ADD}>\n | <{$smarty.const._AM_SYSTEM_SMILIES_CODE}> | \n<{$smarty.const._AM_SYSTEM_SMILIES_SMILIE}> | \n<{$smarty.const._AM_SYSTEM_SMILIES_DESCRIPTION}> | \n<{$smarty.const._AM_SYSTEM_SMILIES_DISPLAY}> | \n<{$smarty.const._AM_SYSTEM_SMILIES_ACTION}> | \n
|---|---|---|---|---|
| <{$smilies.code}> | \n<{$smilies.image}> | \n<{$smilies.emotion}> | \n\n  \n | \n \n \n \n \n \n \n \n | \n
<{$nav_menu}>
\n \n <{/if}>\n<{/if}>\n\n<{if $form}>\n <{$form}>
\n<{/if}>\n');
INSERT INTO `[[dbprefix]]_tplsource` VALUES
(50, '\n<{includeq file="db:system_header.tpl"}>\n\n<{if $filterform}>\n \n \n
\n \n \n \n
\n
\n<{/if}>\n| \n \n | \n||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
\n
| \n ||||||||||||||
class="hide"<{/if}>>\n <{if !$filterform}>
<{/if}>\n <{$blockform}>\n
\n\n\n'),
(51, '<{foreach item=item from=$blocks}>\n <{if $item.side == $side}>\n <{/if}>\n <{$blockform}>\n
\n
\n <{/if}>\n<{/foreach}>\n'),
(52, '<{includeq file="db:system_header.tpl"}>\n\n<{if $form}>\n \n \n 
\n \n<{$item.title}><{if $item.block_type == ''D''}> (<{$item.bid}>)<{/if}>\n
\n \n \n \n<{$item.title}><{if $item.block_type == ''D''}> (<{$item.bid}>)<{/if}>\n 
<{$form}>
\n<{else}>\n <{$form_sort}>
\n \n \n
\n \n | \n | \n | <{$smarty.const._AM_SYSTEM_COMMENTS_TITLE}> | \n<{$smarty.const._AM_SYSTEM_COMMENTS_POSTED}> | \n<{$smarty.const._AM_SYSTEM_COMMENTS_IP}> | \n<{$smarty.const._DATE}> | \n<{$smarty.const._AM_SYSTEM_COMMENTS_MODULE}> | \n<{$smarty.const._AM_SYSTEM_COMMENTS_STATUS}> | \n<{$smarty.const._AM_SYSTEM_COMMENTS_ACTION}> | \n
|---|
'' title=''<{$comments.comments_title}>'' style=''display:none;''>\n 
\n\n
\n <{/foreach}>\n \n \n\n <{$comments.comments_text}>
\n<{$nav}>
\n<{/if}>\n'),
(53, '<{includeq file="db:system_header.tpl"}>\n\n\n<{if $userrank_count == true}>\n \n | <{$smarty.const._AM_SYSTEM_USERRANK_IMAGE}> | \n<{$smarty.const._AM_SYSTEM_USERRANK_TITLE}> | \n<{$smarty.const._AM_SYSTEM_USERRANK_MINPOST}> | \n<{$smarty.const._AM_SYSTEM_USERRANK_MAXPOST}> | \n<{$smarty.const._AM_SYSTEM_USERRANK_SPECIAL}> | \n<{$smarty.const._AM_SYSTEM_USERRANK_ACTION}> | \n
|---|---|---|---|---|---|
| <{$userrank.rank_image}> | \n<{$userrank.rank_title}> | \n<{$userrank.rank_min}> | \n<{$userrank.rank_max}> | \n \n | \n \n \n \n \n \n \n \n | \n
<{$nav_menu}>
\n \n <{/if}>\n<{/if}>\n\n<{if $form}>\n <{$form}>
\n<{/if}>\n\n'),
(54, '<{includeq file="db:system_header.tpl"}>\n\n<{if $users_display == true}>\n \n \n
\n <{$form_sort}>
\n \n 
\n <{$smarty.const._AM_SYSTEM_USERS_SYNCHRONIZE}>\n | \n | <{$smarty.const._AM_SYSTEM_USERS_STATUS}> | \n<{$smarty.const._AM_SYSTEM_USERS_UNAME}> | \n<{$smarty.const._AM_SYSTEM_USERS_EMAIL}> | \n<{$smarty.const._AM_SYSTEM_USERS_REG_DATE}> | \n<{$smarty.const._AM_SYSTEM_USERS_LAST_LOGIN}> | \n<{$smarty.const._AM_SYSTEM_USERS_POSTS}> | \n<{$smarty.const._AM_SYSTEM_USERS_ACTION}> | \n
|---|---|---|---|---|---|---|---|
| <{$smarty.const._AM_SYSTEM_USERS_NO_FOUND}> | \n
\n \n
\n
\n <{/foreach}>\n <{/if}>\n \n | \n | \n \n ''> \n />\n /pmlite.php?send2=1&to_userid=<{$users.uid}>","pmlite",565,500);''> >\n | \n
\n
| \n |
<{$nav}>
\n<{/if}>\n\n\n<{if $form}>\n
<{$form}>
\n<{/if}>\n'),
(55, '<{if $breadcrumb}>\n <{includeq file="db:system_header.tpl"}>\n<{/if}>\n\n<{if $menu}>\n \n <{foreach item=preferences from=$preferences}>\n \n 
\n <{$preferences.name}>\n \n <{/foreach}>\n \n 
\n <{$smarty.const._AM_SYSTEM_PREFERENCES_SETTINGS}>\n \n
\n<{/if}>\n\n <{$smarty.const._AM_SYSTEM_PREFERENCES_SETTINGS}>\n \n \n\n\n'), (56, '\n<{includeq file="db:system_header.tpl"}>\n\n
\n<{if $form}>\n
<{$form}>
\n<{/if}>\n<{$Sucess}>\n<{$Errors}>\n'),
(57, '\n<{includeq file="db:system_header.tpl"}>\n<{if $groups_count == true}>\n \n \n
\n | <{$smarty.const._AM_SYSTEM_GROUPS_ID}> | \n<{$smarty.const._AM_SYSTEM_GROUPS_NAME}> | \n<{$smarty.const._AM_SYSTEM_GROUPS_DESCRIPTION}> | \n<{$smarty.const._AM_SYSTEM_GROUPS_NB_USERS_BY_GROUPS}> | \n<{$smarty.const._AM_SYSTEM_GROUPS_ACTION}> | \n
|---|---|---|---|---|
| <{$groups.groups_id}> | \n\n \n <{$groups.name}>\n \n | \n<{$groups.description}> | \n\n <{$groups.nb_users_by_groups}>\n | \n\n \n \n \n <{if $groups.delete}>\n \n \n \n <{/if}>\n | \n
<{$nav_menu}>
\n \n <{/if}>\n<{/if}>\n\n<{if $form}>\n <{$form}>
\n<{/if}>\n');
INSERT INTO `[[dbprefix]]_tplsource` VALUES
(58, '\n<{includeq file="db:system_header.tpl"}>\n\n\n
\n\n<{if !$edit_form && !$listimg && !$multiupload}>\n \n \n
\n| <{$smarty.const._AM_SYSTEM_IMAGES_NAME}> | \n<{$smarty.const._AM_SYSTEM_IMAGES_NBIMAGES}> | \n<{$smarty.const._AM_SYSTEM_IMAGES_MAXSIZE}> | \n<{$smarty.const._AM_SYSTEM_IMAGES_MAXWIDTH}> | \n<{$smarty.const._AM_SYSTEM_IMAGES_MAXHEIGHT}> | \n<{$smarty.const._AM_SYSTEM_IMAGES_DISPLAY}> | \n<{$smarty.const._AM_SYSTEM_IMAGES_ACTIONS}> | \n
|---|---|---|---|---|---|---|
| \n \n <{$cat.name}>\n \n | \n<{$cat.count}> | \n<{$cat.maxsize}> | \n<{$cat.maxwidth}> | \n<{$cat.maxheight}> | \n \n | \n \n \n \n \n <{if $xoops_isadmin}>\n \n \n \n \n \n \n <{/if}>\n | \n
| <{$smarty.const._AM_SYSTEM_IMAGES_NOCAT}> | \n||||||
<{$nav_menu}>
\n \n <{/if}>\n<{/if}>\n<{if $images}>\n \n \n <{foreach item=img from=$images}>\n
\n <{if $nav_menu}>\n \n
\n \n
\n \n 
\n
\n \n 
\n <{if !$db_store}>\n \n <{else}>\n \n <{/if}>\n \n \n \n \n \n \n \n \n \n
\n <{$img.image_nicename}>
\n \n <{if !$db_store}>\n \n <{else}>\n \n <{/if}>\n \n \n \n \n \n \n \n \n \n \n
\n <{/foreach}>\n \n \n <{if !$db_store}>\n <{$xoops_upload_url}>/<{$img.image_name}>\n <{else}>\n <{$xoops_url}>/image.php?id=<{$img.image_id}>\n <{/if}>\n
\n <{$nav_menu}>
\n \n <{/if}>\n<{else}>\n \n \n
\n<{/if}>\n\n\n\n
\n <{$image_form.javascript}>\n \n
\n\n\n <{$image_form.javascript}>\n \n
\n
\n <{$imagecat_form.javascript}>\n \n
\n<{if $multiupload}>\n \n <{$imagecat_form.javascript}>\n \n
<{$imgcat_name}>
\n \n<{$smarty.const._IMGMAXSIZE}> <{$imgcat_maxsize}>
\n <{$smarty.const._IMGMAXWIDTH}> <{$imgcat_maxwidth}>
\n <{$smarty.const._IMGMAXHEIGHT}> <{$imgcat_maxheight}>
\n \n \n<{/if}>\n\n<{if $edit_form}>\n \n <{$edit_thumbs}>\n
\n <{$edit_form.javascript}>\n \n
\n<{/if}>\n\n'),
(59, '<{includeq file="db:system_header.tpl"}>\n\n<{if $index}>\n \n <{$edit_form.javascript}>\n \n
\n
\n \n
\n\n
\n
\n<{else}>\n | <{$smarty.const._AM_SYSTEM_TEMPLATES_YOUR_THEMES}> | \n\n |
|---|---|
| \n \n | \n\n <{$form}> \n \n \n \n | \n
\n \n
\n <{if $verif}>\n <{$infos}>\n <{else}>\n
<{$smarty.const._AM_SYSTEM_TEMPLATES_NOT_CREATED}>
\n <{/if}>\n<{/if}>\n'),
(60, '<{includeq file="db:system_header.tpl"}>\n\n| <{$smarty.const._AM_SYSTEM_SECTION}> | \n<{$smarty.const._AM_SYSTEM_DESC}> | \n<{$smarty.const._AM_SYSTEM_USAGE}> | \n<{$smarty.const._AM_SYSTEM_ACTIVE}> | \n
|---|---|---|---|
| \n \n | \n <{$menu.desc}> | \n<{$menu.infos}> | \n\n <{if $menu.used}>\n \n  \n <{/if}>\n | \n
\n<{if $form_maintenance}>\n
<{$form_maintenance}>
\n \n
<{$form_dump}>
\n<{elseif $maintenance}>\n <{if $verif_cache || $verif_session || $verif_avatar}>\n | <{$smarty.const._AM_SYSTEM_MAINTENANCE}> | \n<{$smarty.const._AM_SYSTEM_MAINTENANCE_RESULT}> | \n
|---|---|
| <{$smarty.const._AM_SYSTEM_MAINTENANCE_RESULT_CACHE}> | \n<{if $result_cache}> <{else}> <{/if}>\n | \n
| <{$smarty.const._AM_SYSTEM_MAINTENANCE_RESULT_SESSION}> | \n<{if $result_session}><{else}><{/if}>\n | \n
| <{$smarty.const._AM_SYSTEM_MAINTENANCE_RESULT_AVATAR}> | \n<{if $result_avatar}><{else}><{/if}>\n | \n
\n <{/if}>\n <{if $verif_maintenance}>\n <{$result_maintenance}>\n <{/if}>\n<{else}>\n <{$result_dump}>\n<{/if}>\n'), (62, '<{includeq file="db:system_header.tpl"}>\n
| \n <{if $help}>\n \n <{/if}>\n <{if $list_mods}>\n \n <{/if}>\n | \n\n \n <{$helpcontent}>\n \n | \n
\n \n <{$block.lang_advsearch}>\n
\n'),
(66, '- \n <{foreach item=module from=$block.modules}>\n
- <{$module.lang_linkname}>: <{$module.pendingnum}> \n <{/foreach}>\n
| <{$group.name}> | \n|
|---|---|
| \n \n <{$user.name}>\n | \n \n <{$user.msglink}>\n | \n
\n\n
\n 
<{$block.recommendlink}>\n
\n'),
(69, '<{$block.online_total}>\n<{$block.recommendlink}>\n
\n<{$block.lang_members}>: <{$block.online_members}>\n
\n<{$block.lang_guests}>: <{$block.online_guests}>\n
\n<{$block.online_names}>\n\n <{$block.lang_more}>\n\n'), (70, '
| <{$user.rank}> | \n\n <{if $user.avatar != ""}>\n \n <{/if}>\n <{$user.name}>\n | \n <{$user.posts}> | \n
| \n <{if $user.avatar != ""}>\n \n <{/if}>\n <{$user.name}>\n | \n <{$user.joindate}> | \n
 | \n <{$comment.title}> | \n<{$comment.module}> | \n<{$comment.poster}> | \n<{$comment.time}> | \n
\n \n
\n');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]_users`
--
CREATE TABLE `[[dbprefix]]_users` (
`uid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(60) NOT NULL DEFAULT '',
`uname` varchar(25) NOT NULL DEFAULT '',
`email` varchar(60) NOT NULL DEFAULT '',
`url` varchar(100) NOT NULL DEFAULT '',
`user_avatar` varchar(30) NOT NULL DEFAULT 'blank.gif',
`user_regdate` int(10) unsigned NOT NULL DEFAULT '0',
`user_icq` varchar(15) NOT NULL DEFAULT '',
`user_from` varchar(100) NOT NULL DEFAULT '',
`user_sig` tinytext,
`user_viewemail` tinyint(1) unsigned NOT NULL DEFAULT '0',
`actkey` varchar(8) NOT NULL DEFAULT '',
`user_aim` varchar(18) NOT NULL DEFAULT '',
`user_yim` varchar(25) NOT NULL DEFAULT '',
`user_msnm` varchar(100) NOT NULL DEFAULT '',
`pass` varchar(255) NOT NULL DEFAULT '',
`posts` mediumint(8) unsigned NOT NULL DEFAULT '0',
`attachsig` tinyint(1) unsigned NOT NULL DEFAULT '0',
`rank` smallint(5) unsigned NOT NULL DEFAULT '0',
`level` tinyint(3) unsigned NOT NULL DEFAULT '1',
`theme` varchar(100) NOT NULL DEFAULT '',
`timezone_offset` float(3,1) NOT NULL DEFAULT '0.0',
`last_login` int(10) unsigned NOT NULL DEFAULT '0',
`umode` varchar(10) NOT NULL DEFAULT '',
`uorder` tinyint(1) unsigned NOT NULL DEFAULT '0',
`notify_method` tinyint(1) NOT NULL DEFAULT '1',
`notify_mode` tinyint(1) NOT NULL DEFAULT '0',
`user_occ` varchar(100) NOT NULL DEFAULT '',
`bio` tinytext,
`user_intrest` varchar(150) NOT NULL DEFAULT '',
`user_mailok` tinyint(1) unsigned NOT NULL DEFAULT '1',
PRIMARY KEY (`uid`),
KEY `uname` (`uname`),
KEY `email` (`email`),
KEY `uiduname` (`uid`,`uname`),
KEY `level` (`level`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `[[dbprefix]]_users`
--
INSERT INTO `[[dbprefix]]_users` VALUES
(1, '', '[[admin_username]]', '[[admin_email]]', '[[softurl]]/', 'avatars/blank.gif', [[timestamp]], '', '', '', 1, '', '', '', '', '[[admin_pass]]', 0, 0, 7, 5, 'xbootstrap', 0.0, [[timestamp]], 'flat', 0, 1, 0, '', '', '', 0);
-- --------------------------------------------------------
--
-- 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=utf8 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=utf8 AUTO_INCREMENT=1 ;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;