migration MySQL 4.0.15 vers MSSQL (SQLServer)

[jeromebuchler]

au secours les zamiiiiiiiiiis

j'ai 160 tables MySQL à convertir en SQL
je passe par ODBC et j'utilise Entreprise Manager (import Data)

j'ai des erreurs de création de tables MSSQL
(syntax error line n near token '(' )

après quelques essais, il semblerait que les types de données MySQL suivants : CHAR(n) [n > 1], VARCHAR, DATETIME... posent problème et que Entreprise Manager ne sait pas bien faire la conversion de types...

j'ai cherché sur les sites officiels, et en effet MySQL converti tout seul le VARCHAR(n) si n<4 en CHAR(n). A part ça, rien sur la conversion de types vers SQL

bref HELP ME complètement svp!!! quelques pistes! j'ai pas envie de modifier 80 tables qui posent probleme sur 160 au total (enfin, les modifications ça ne me dérange pas de passer 4h à les faire, mais je ne voudrais surtout pas avoir à modifier mon appli PHP bref je voudrais si je change les types que ça soit complètement transparent pour l'appli)


ps. j'ai tenté via OleDB pour la partie "source" (MySQL) mais je n'arrive même pas à lancer la conversion

[fadace]

C'est étrange : les types CHAR(n), VARCHAR, DATETIME sont tout ce qu'il y a de plus compatible MS-SQL.

[jeromebuchler]

ok voici le dump MySQL de la base que j'aimerais convertir en MSSQL
(oui il s'agit du CMS Xoops 2.0.10 de base :)
J'ai des erreurs sur 10 tables sur un total de 31 tables
je rappelle que j'utilise la fonction "import data" de Enterprise Manager via le driver ODBC pour MySQL et OleDB pour MSSQL

si quelqu'un arrive à convertir ça sans que j'aie à modifier mon app derrière, ça serait du ballon 8O :) ou au moins une petite piste... quels sont les formats qui merdent? dur de faire des déductions comme ça mais a priori le CHAR(n) (n>2) ne passe pas, ainsi que certaines tailles de VARCHAR... pas certain

-------

Database xoops running on localhost
# phpMyAdmin SQL Dump
# version 2.5.3
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: May 03, 2005 at 10:02 AM
# Server version: 4.0.15
# PHP Version: 4.3.3
#
# Database : `xoops`
#

# --------------------------------------------------------

#
# Table structure for table `xoops_avatar`
#

CREATE TABLE `xoops_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`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Dumping data for table `xoops_avatar`
#


# --------------------------------------------------------

#
# Table structure for table `xoops_avatar_user_link`
#

CREATE TABLE `xoops_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`)
) TYPE=MyISAM;

#
# Dumping data for table `xoops_avatar_user_link`
#


# --------------------------------------------------------

#
# Table structure for table `xoops_banner`
#

CREATE TABLE `xoops_banner` (
`bid` smallint(5) unsigned NOT NULL auto_increment,
`cid` tinyint(3) unsigned NOT NULL default '0',
`imptotal` mediumint(8) 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 NOT NULL,
PRIMARY KEY (`bid`),
KEY `idxbannercid` (`cid`),
KEY `idxbannerbidcid` (`bid`,`cid`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;

#
# Dumping data for table `xoops_banner`
#

INSERT INTO `xoops_banner` VALUES (1, 1, 0, 1, 0, 'http://jb:5180/xoops/images/banners/xoops_banner.gif', 'http://www.xoops.org/', 1008813250, 0, '');
INSERT INTO `xoops_banner` VALUES (2, 1, 0, 1, 0, 'http://jb:5180/xoops/images/banners/xoops_banner_2.gif', 'http://www.xoops.org/', 1008813250, 0, '');
INSERT INTO `xoops_banner` VALUES (3, 1, 0, 2, 0, 'http://jb:5180/xoops/images/banners/banner.swf', 'http://www.xoops.org/', 1008813250, 0, '');

# --------------------------------------------------------

#
# Table structure for table `xoops_bannerclient`
#

CREATE TABLE `xoops_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 NOT NULL,
PRIMARY KEY (`cid`),
KEY `login` (`login`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

#
# Dumping data for table `xoops_bannerclient`
#

INSERT INTO `xoops_bannerclient` VALUES (1, 'XOOPS', 'XOOPS Dev Team', 'webmaster@xoops.org', '', '', '');

# --------------------------------------------------------

#
# Table structure for table `xoops_bannerfinish`
#

CREATE TABLE `xoops_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`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Dumping data for table `xoops_bannerfinish`
#


# --------------------------------------------------------

#
# Table structure for table `xoops_block_module_link`
#

CREATE TABLE `xoops_block_module_link` (
`block_id` mediumint(8) unsigned NOT NULL default '0',
`module_id` smallint(5) NOT NULL default '0',
KEY `module_id` (`module_id`),
KEY `block_id` (`block_id`)
) TYPE=MyISAM;

#
# Dumping data for table `xoops_block_module_link`
#

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

# --------------------------------------------------------

#
# Table structure for table `xoops_config`
#

CREATE TABLE `xoops_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(30) NOT NULL default '',
`conf_value` text NOT NULL,
`conf_desc` varchar(30) 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`)
) TYPE=MyISAM AUTO_INCREMENT=74 ;

#
# Dumping data for table `xoops_config`
#

INSERT INTO `xoops_config` VALUES (1, 0, 1, 'sitename', '_MD_AM_SITENAME', 'XOOPS Site', '_MD_AM_SITENAMEDSC', 'textbox', 'text', 0);
INSERT INTO `xoops_config` VALUES (2, 0, 1, 'slogan', '_MD_AM_SLOGAN', 'Just Use it!', '_MD_AM_SLOGANDSC', 'textbox', 'text', 2);
INSERT INTO `xoops_config` VALUES (3, 0, 1, 'language', '_MD_AM_LANGUAGE', 'english', '_MD_AM_LANGUAGEDSC', 'language', 'other', 4);
INSERT INTO `xoops_config` VALUES (4, 0, 1, 'startpage', '_MD_AM_STARTPAGE', '--', '_MD_AM_STARTPAGEDSC', 'startpage', 'other', 6);
INSERT INTO `xoops_config` VALUES (5, 0, 1, 'server_TZ', '_MD_AM_SERVERTZ', '0', '_MD_AM_SERVERTZDSC', 'timezone', 'float', 8);
INSERT INTO `xoops_config` VALUES (6, 0, 1, 'default_TZ', '_MD_AM_DEFAULTTZ', '0', '_MD_AM_DEFAULTTZDSC', 'timezone', 'float', 10);
INSERT INTO `xoops_config` VALUES (7, 0, 1, 'theme_set', '_MD_AM_DTHEME', 'default', '_MD_AM_DTHEMEDSC', 'theme', 'other', 12);
INSERT INTO `xoops_config` VALUES (8, 0, 1, 'anonymous', '_MD_AM_ANONNAME', 'Anonymous', '_MD_AM_ANONNAMEDSC', 'textbox', 'text', 15);
INSERT INTO `xoops_config` VALUES (9, 0, 1, 'gzip_compression', '_MD_AM_USEGZIP', '0', '_MD_AM_USEGZIPDSC', 'yesno', 'int', 16);
INSERT INTO `xoops_config` VALUES (10, 0, 1, 'usercookie', '_MD_AM_USERCOOKIE', 'xoops_user', '_MD_AM_USERCOOKIEDSC', 'textbox', 'text', 18);
INSERT INTO `xoops_config` VALUES (11, 0, 1, 'session_expire', '_MD_AM_SESSEXPIRE', '15', '_MD_AM_SESSEXPIREDSC', 'textbox', 'int', 22);
INSERT INTO `xoops_config` VALUES (12, 0, 1, 'banners', '_MD_AM_BANNERS', '1', '_MD_AM_BANNERSDSC', 'yesno', 'int', 26);
INSERT INTO `xoops_config` VALUES (13, 0, 1, 'debug_mode', '_MD_AM_DEBUGMODE', '0', '_MD_AM_DEBUGMODEDSC', 'select', 'int', 24);
INSERT INTO `xoops_config` VALUES (14, 0, 1, 'my_ip', '_MD_AM_MYIP', '127.0.0.1', '_MD_AM_MYIPDSC', 'textbox', 'text', 29);
INSERT INTO `xoops_config` VALUES (15, 0, 1, 'use_ssl', '_MD_AM_USESSL', '0', '_MD_AM_USESSLDSC', 'yesno', 'int', 30);
INSERT INTO `xoops_config` VALUES (16, 0, 1, 'session_name', '_MD_AM_SESSNAME', 'xoops_session', '_MD_AM_SESSNAMEDSC', 'textbox', 'text', 20);
INSERT INTO `xoops_config` VALUES (17, 0, 2, 'minpass', '_MD_AM_MINPASS', '5', '_MD_AM_MINPASSDSC', 'textbox', 'int', 1);
INSERT INTO `xoops_config` VALUES (18, 0, 2, 'minuname', '_MD_AM_MINUNAME', '3', '_MD_AM_MINUNAMEDSC', 'textbox', 'int', 2);
INSERT INTO `xoops_config` VALUES (19, 0, 2, 'new_user_notify', '_MD_AM_NEWUNOTIFY', '1', '_MD_AM_NEWUNOTIFYDSC', 'yesno', 'int', 4);
INSERT INTO `xoops_config` VALUES (20, 0, 2, 'new_user_notify_group', '_MD_AM_NOTIFYTO', '1', '_MD_AM_NOTIFYTODSC', 'group', 'int', 6);
INSERT INTO `xoops_config` VALUES (21, 0, 2, 'activation_type', '_MD_AM_ACTVTYPE', '0', '_MD_AM_ACTVTYPEDSC', 'select', 'int', 8);
INSERT INTO `xoops_config` VALUES (22, 0, 2, 'activation_group', '_MD_AM_ACTVGROUP', '1', '_MD_AM_ACTVGROUPDSC', 'group', 'int', 10);
INSERT INTO `xoops_config` VALUES (23, 0, 2, 'uname_test_level', '_MD_AM_UNAMELVL', '0', '_MD_AM_UNAMELVLDSC', 'select', 'int', 12);
INSERT INTO `xoops_config` VALUES (24, 0, 2, 'avatar_allow_upload', '_MD_AM_AVATARALLOW', '0', '_MD_AM_AVATARALWDSC', 'yesno', 'int', 14);
INSERT INTO `xoops_config` VALUES (27, 0, 2, 'avatar_width', '_MD_AM_AVATARW', '80', '_MD_AM_AVATARWDSC', 'textbox', 'int', 16);
INSERT INTO `xoops_config` VALUES (28, 0, 2, 'avatar_height', '_MD_AM_AVATARH', '80', '_MD_AM_AVATARHDSC', 'textbox', 'int', 18);
INSERT INTO `xoops_config` VALUES (29, 0, 2, 'avatar_maxsize', '_MD_AM_AVATARMAX', '35000', '_MD_AM_AVATARMAXDSC', 'textbox', 'int', 20);
INSERT INTO `xoops_config` VALUES (30, 0, 1, 'adminmail', '_MD_AM_ADMINML', 'jetbuch@yahoo.fr', '_MD_AM_ADMINMLDSC', 'textbox', 'text', 3);
INSERT INTO `xoops_config` VALUES (31, 0, 2, 'self_delete', '_MD_AM_SELFDELETE', '0', '_MD_AM_SELFDELETEDSC', 'yesno', 'int', 22);
INSERT INTO `xoops_config` VALUES (32, 0, 1, 'com_mode', '_MD_AM_COMMODE', 'nest', '_MD_AM_COMMODEDSC', 'select', 'text', 34);
INSERT INTO `xoops_config` VALUES (33, 0, 1, 'com_order', '_MD_AM_COMORDER', '0', '_MD_AM_COMORDERDSC', 'select', 'int', 36);
INSERT INTO `xoops_config` VALUES (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);
INSERT INTO `xoops_config` VALUES (35, 0, 2, 'bad_emails', '_MD_AM_BADEMAILS', 'a:1:{i:0;s:10:"xoops.org$";}', '_MD_AM_BADEMAILSDSC', 'textarea', 'array', 26);
INSERT INTO `xoops_config` VALUES (36, 0, 2, 'maxuname', '_MD_AM_MAXUNAME', '10', '_MD_AM_MAXUNAMEDSC', 'textbox', 'int', 3);
INSERT INTO `xoops_config` VALUES (37, 0, 1, 'bad_ips', '_MD_AM_BADIPS', 'a:1:{i:0;s:9:"127.0.0.1";}', '_MD_AM_BADIPSDSC', 'textarea', 'array', 42);
INSERT INTO `xoops_config` VALUES (38, 0, 3, 'meta_keywords', '_MD_AM_METAKEY', 'news, technology, headlines, xoops, xoop, nuke, myphpnuke, myphp-nuke, phpnuke, SE, geek, geeks, hacker, hackers, linux, software, download, downloads, free, community, mp3, forum, forums, bulletin, board, boards, bbs, php, survey, poll, polls, kernel, comment, comments, portal, odp, open, source, opensource, FreeSoftware, gnu, gpl, license, Unix, *nix, mysql, sql, database, databases, web site, weblog, guru, module, modules, theme, themes, cms, content management', '_MD_AM_METAKEYDSC', 'textarea', 'text', 0);
INSERT INTO `xoops_config` VALUES (39, 0, 3, 'footer', '_MD_AM_FOOTER', 'Powered by XOOPS 2.0 &copy; 2001-2003 <a href="http://www.xoops.org/" target="_blank">The XOOPS Project</a>', '_MD_AM_FOOTERDSC', 'textarea', 'text', 20);
INSERT INTO `xoops_config` VALUES (40, 0, 4, 'censor_enable', '_MD_AM_DOCENSOR', '0', '_MD_AM_DOCENSORDSC', 'yesno', 'int', 0);
INSERT INTO `xoops_config` VALUES (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);
INSERT INTO `xoops_config` VALUES (42, 0, 4, 'censor_replace', '_MD_AM_CENSORRPLC', '#OOPS#', '_MD_AM_CENSORRPLCDSC', 'textbox', 'text', 2);
INSERT INTO `xoops_config` VALUES (43, 0, 3, 'meta_robots', '_MD_AM_METAROBOTS', 'index,follow', '_MD_AM_METAROBOTSDSC', 'select', 'text', 2);
INSERT INTO `xoops_config` VALUES (44, 0, 5, 'enable_search', '_MD_AM_DOSEARCH', '1', '_MD_AM_DOSEARCHDSC', 'yesno', 'int', 0);
INSERT INTO `xoops_config` VALUES (45, 0, 5, 'keyword_min', '_MD_AM_MINSEARCH', '5', '_MD_AM_MINSEARCHDSC', 'textbox', 'int', 1);
INSERT INTO `xoops_config` VALUES (46, 0, 2, 'avatar_minposts', '_MD_AM_AVATARMP', '0', '_MD_AM_AVATARMPDSC', 'textbox', 'int', 15);
INSERT INTO `xoops_config` VALUES (47, 0, 1, 'enable_badips', '_MD_AM_DOBADIPS', '0', '_MD_AM_DOBADIPSDSC', 'yesno', 'int', 40);
INSERT INTO `xoops_config` VALUES (48, 0, 3, 'meta_rating', '_MD_AM_METARATING', 'general', '_MD_AM_METARATINGDSC', 'select', 'text', 4);
INSERT INTO `xoops_config` VALUES (49, 0, 3, 'meta_author', '_MD_AM_METAAUTHOR', 'XOOPS', '_MD_AM_METAAUTHORDSC', 'textbox', 'text', 6);
INSERT INTO `xoops_config` VALUES (50, 0, 3, 'meta_copyright', '_MD_AM_METACOPYR', 'Copyright &copy; 2001-2003', '_MD_AM_METACOPYRDSC', 'textbox', 'text', 8);
INSERT INTO `xoops_config` VALUES (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);
INSERT INTO `xoops_config` VALUES (52, 0, 2, 'allow_chgmail', '_MD_AM_ALLWCHGMAIL', '0', '_MD_AM_ALLWCHGMAILDSC', 'yesno', 'int', 3);
INSERT INTO `xoops_config` VALUES (53, 0, 1, 'use_mysession', '_MD_AM_USEMYSESS', '0', '_MD_AM_USEMYSESSDSC', 'yesno', 'int', 19);
INSERT INTO `xoops_config` VALUES (54, 0, 2, 'reg_dispdsclmr', '_MD_AM_DSPDSCLMR', '1', '_MD_AM_DSPDSCLMRDSC', 'yesno', 'int', 30);
INSERT INTO `xoops_config` VALUES (55, 0, 2, 'reg_disclaimer', '_MD_AM_REGDSCLMR', 'While the administrators and moderators of this site will attempt to remove\r\nor edit any generally objectionable material as quickly as possible, it is\r\nimpossible to review every message. Therefore you acknowledge that all posts\r\nmade to this site express the views and opinions of the author and not the\r\nadministrators, moderators or webmaster (except for posts by these people)\r\nand hence will not be held liable. \r\n\r\nYou agree not to post any abusive, obscene, vulgar, slanderous, hateful,\r\nthreatening, sexually-orientated or any other material that may violate any\r\napplicable laws. Doing so may lead to you being immediately and permanently\r\nbanned (and your service provider being informed). The IP address of all\r\nposts is recorded to aid in enforcing these conditions. Creating multiple\r\naccounts for a single user is not allowed. You agree that the webmaster,\r\nadministrator and moderators of this site have the right to remove, edit,\r\nmove or close any topic at any time should they see fit. As a user you agree\r\nto any information you have entered above being stored in a database. While\r\nthis information will not be disclosed to any third party without your\r\nconsent the webmaster, administrator and moderators cannot be held\r\nresponsible for any hacking attempt that may lead to the data being\r\ncompromised. \r\n\r\nThis site system uses cookies to store information on your local computer.\r\nThese cookies do not contain any of the information you have entered above,\r\nthey serve only to improve your viewing pleasure. The email address is used\r\nonly for confirming your registration details and password (and for sending\r\nnew passwords should you forget your current one). \r\n\r\nBy clicking Register below you agree to be bound by these conditions.', '_MD_AM_REGDSCLMRDSC', 'textarea', 'text', 32);
INSERT INTO `xoops_config` VALUES (56, 0, 2, 'allow_register', '_MD_AM_ALLOWREG', '1', '_MD_AM_ALLOWREGDSC', 'yesno', 'int', 0);
INSERT INTO `xoops_config` VALUES (57, 0, 1, 'theme_fromfile', '_MD_AM_THEMEFILE', '0', '_MD_AM_THEMEFILEDSC', 'yesno', 'int', 13);
INSERT INTO `xoops_config` VALUES (58, 0, 1, 'closesite', '_MD_AM_CLOSESITE', '0', '_MD_AM_CLOSESITEDSC', 'yesno', 'int', 26);
INSERT INTO `xoops_config` VALUES (59, 0, 1, 'closesite_okgrp', '_MD_AM_CLOSESITEOK', 'a:1:{i:0;s:1:"1";}', '_MD_AM_CLOSESITEOKDSC', 'group_multi', 'array', 27);
INSERT INTO `xoops_config` VALUES (60, 0, 1, 'closesite_text', '_MD_AM_CLOSESITETXT', 'The site is currently closed for maintainance. Please come back later.', '_MD_AM_CLOSESITETXTDSC', 'textarea', 'text', 28);
INSERT INTO `xoops_config` VALUES (61, 0, 1, 'sslpost_name', '_MD_AM_SSLPOST', 'xoops_ssl', '_MD_AM_SSLPOSTDSC', 'textbox', 'text', 31);
INSERT INTO `xoops_config` VALUES (62, 0, 1, 'module_cache', '_MD_AM_MODCACHE', '', '_MD_AM_MODCACHEDSC', 'module_cache', 'array', 50);
INSERT INTO `xoops_config` VALUES (63, 0, 1, 'template_set', '_MD_AM_DTPLSET', 'default', '_MD_AM_DTPLSETDSC', 'tplset', 'other', 14);
INSERT INTO `xoops_config` VALUES (64, 0, 6, 'mailmethod', '_MD_AM_MAILERMETHOD', 'mail', '_MD_AM_MAILERMETHODDESC', 'select', 'text', 4);
INSERT INTO `xoops_config` VALUES (65, 0, 6, 'smtphost', '_MD_AM_SMTPHOST', 'a:1:{i:0;s:0:"";}', '_MD_AM_SMTPHOSTDESC', 'textarea', 'array', 6);
INSERT INTO `xoops_config` VALUES (66, 0, 6, 'smtpuser', '_MD_AM_SMTPUSER', '', '_MD_AM_SMTPUSERDESC', 'textbox', 'text', 7);
INSERT INTO `xoops_config` VALUES (67, 0, 6, 'smtppass', '_MD_AM_SMTPPASS', '', '_MD_AM_SMTPPASSDESC', 'password', 'text', 8);
INSERT INTO `xoops_config` VALUES (68, 0, 6, 'sendmailpath', '_MD_AM_SENDMAILPATH', '/usr/sbin/sendmail', '_MD_AM_SENDMAILPATHDESC', 'textbox', 'text', 5);
INSERT INTO `xoops_config` VALUES (69, 0, 6, 'from', '_MD_AM_MAILFROM', '', '_MD_AM_MAILFROMDESC', 'textbox', 'text', 1);
INSERT INTO `xoops_config` VALUES (70, 0, 6, 'fromname', '_MD_AM_MAILFROMNAME', '', '_MD_AM_MAILFROMNAMEDESC', 'textbox', 'text', 2);
INSERT INTO `xoops_config` VALUES (71, 0, 1, 'sslloginlink', '_MD_AM_SSLLINK', 'https://', '_MD_AM_SSLLINKDSC', 'textbox', 'text', 33);
INSERT INTO `xoops_config` VALUES (72, 0, 1, 'theme_set_allowed', '_MD_AM_THEMEOK', 'a:1:{i:0;s:7:"default";}', '_MD_AM_THEMEOKDSC', 'theme_multi', 'array', 13);
INSERT INTO `xoops_config` VALUES (73, 0, 6, 'fromuid', '_MD_AM_MAILFROMUID', '1', '_MD_AM_MAILFROMUIDDESC', 'user', 'int', 3);

# --------------------------------------------------------

#
# Table structure for table `xoops_configcategory`
#

CREATE TABLE `xoops_configcategory` (
`confcat_id` smallint(5) unsigned NOT NULL auto_increment,
`confcat_name` varchar(25) NOT NULL default '',
`confcat_order` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`confcat_id`)
) TYPE=MyISAM AUTO_INCREMENT=7 ;

#
# Dumping data for table `xoops_configcategory`
#

INSERT INTO `xoops_configcategory` VALUES (1, '_MD_AM_GENERAL', 0);
INSERT INTO `xoops_configcategory` VALUES (2, '_MD_AM_USERSETTINGS', 0);
INSERT INTO `xoops_configcategory` VALUES (3, '_MD_AM_METAFOOTER', 0);
INSERT INTO `xoops_configcategory` VALUES (4, '_MD_AM_CENSOR', 0);
INSERT INTO `xoops_configcategory` VALUES (5, '_MD_AM_SEARCH', 0);
INSERT INTO `xoops_configcategory` VALUES (6, '_MD_AM_MAILER', 0);

# --------------------------------------------------------

#
# Table structure for table `xoops_configoption`
#

CREATE TABLE `xoops_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`)
) TYPE=MyISAM AUTO_INCREMENT=28 ;

#
# Dumping data for table `xoops_configoption`
#

INSERT INTO `xoops_configoption` VALUES (1, '_MD_AM_DEBUGMODE1', '1', 13);
INSERT INTO `xoops_configoption` VALUES (2, '_MD_AM_DEBUGMODE2', '2', 13);
INSERT INTO `xoops_configoption` VALUES (3, '_NESTED', 'nest', 32);
INSERT INTO `xoops_configoption` VALUES (4, '_FLAT', 'flat', 32);
INSERT INTO `xoops_configoption` VALUES (5, '_THREADED', 'thread', 32);
INSERT INTO `xoops_configoption` VALUES (6, '_OLDESTFIRST', '0', 33);
INSERT INTO `xoops_configoption` VALUES (7, '_NEWESTFIRST', '1', 33);
INSERT INTO `xoops_configoption` VALUES (8, '_MD_AM_USERACTV', '0', 21);
INSERT INTO `xoops_configoption` VALUES (9, '_MD_AM_AUTOACTV', '1', 21);
INSERT INTO `xoops_configoption` VALUES (10, '_MD_AM_ADMINACTV', '2', 21);
INSERT INTO `xoops_configoption` VALUES (11, '_MD_AM_STRICT', '0', 23);
INSERT INTO `xoops_configoption` VALUES (12, '_MD_AM_MEDIUM', '1', 23);
INSERT INTO `xoops_configoption` VALUES (13, '_MD_AM_LIGHT', '2', 23);
INSERT INTO `xoops_configoption` VALUES (14, '_MD_AM_DEBUGMODE3', '3', 13);
INSERT INTO `xoops_configoption` VALUES (15, '_MD_AM_INDEXFOLLOW', 'index,follow', 43);
INSERT INTO `xoops_configoption` VALUES (16, '_MD_AM_NOINDEXFOLLOW', 'noindex,follow', 43);
INSERT INTO `xoops_configoption` VALUES (17, '_MD_AM_INDEXNOFOLLOW', 'index,nofollow', 43);
INSERT INTO `xoops_configoption` VALUES (18, '_MD_AM_NOINDEXNOFOLLOW', 'noindex,nofollow', 43);
INSERT INTO `xoops_configoption` VALUES (19, '_MD_AM_METAOGEN', 'general', 48);
INSERT INTO `xoops_configoption` VALUES (20, '_MD_AM_METAO14YRS', '14 years', 48);
INSERT INTO `xoops_configoption` VALUES (21, '_MD_AM_METAOREST', 'restricted', 48);
INSERT INTO `xoops_configoption` VALUES (22, '_MD_AM_METAOMAT', 'mature', 48);
INSERT INTO `xoops_configoption` VALUES (23, '_MD_AM_DEBUGMODE0', '0', 13);
INSERT INTO `xoops_configoption` VALUES (24, 'PHP mail()', 'mail', 64);
INSERT INTO `xoops_configoption` VALUES (25, 'sendmail', 'sendmail', 64);
INSERT INTO `xoops_configoption` VALUES (26, 'SMTP', 'smtp', 64);
INSERT INTO `xoops_configoption` VALUES (27, 'SMTPAuth', 'smtpauth', 64);

# --------------------------------------------------------

#
# Table structure for table `xoops_group_permission`
#

CREATE TABLE `xoops_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))
) TYPE=MyISAM AUTO_INCREMENT=56 ;

#
# Dumping data for table `xoops_group_permission`
#

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

# --------------------------------------------------------

#
# Table structure for table `xoops_groups`
#

CREATE TABLE `xoops_groups` (
`groupid` smallint(5) unsigned NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`description` text NOT NULL,
`group_type` varchar(10) NOT NULL default '',
PRIMARY KEY (`groupid`),
KEY `group_type` (`group_type`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;

#
# Dumping data for table `xoops_groups`
#

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

# --------------------------------------------------------

#
# Table structure for table `xoops_groups_users_link`
#

CREATE TABLE `xoops_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`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

#
# Dumping data for table `xoops_groups_users_link`
#

INSERT INTO `xoops_groups_users_link` VALUES (1, 1, 1);
INSERT INTO `xoops_groups_users_link` VALUES (2, 2, 1);

# --------------------------------------------------------

#
# Table structure for table `xoops_image`
#

CREATE TABLE `xoops_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`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Dumping data for table `xoops_image`
#


# --------------------------------------------------------

#
# Table structure for table `xoops_imagebody`
#

CREATE TABLE `xoops_imagebody` (
`image_id` mediumint(8) unsigned NOT NULL default '0',
`image_body` mediumblob,
KEY `image_id` (`image_id`)
) TYPE=MyISAM;

#
# Dumping data for table `xoops_imagebody`
#


# --------------------------------------------------------

#
# Table structure for table `xoops_imagecategory`
#

CREATE TABLE `xoops_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`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Dumping data for table `xoops_imagecategory`
#


# --------------------------------------------------------

#
# Table structure for table `xoops_imgset`
#

CREATE TABLE `xoops_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`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

#
# Dumping data for table `xoops_imgset`
#

INSERT INTO `xoops_imgset` VALUES (1, 'default', 0);

# --------------------------------------------------------

#
# Table structure for table `xoops_imgset_tplset_link`
#

CREATE TABLE `xoops_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))
) TYPE=MyISAM;

#
# Dumping data for table `xoops_imgset_tplset_link`
#

INSERT INTO `xoops_imgset_tplset_link` VALUES (1, 'default');

# --------------------------------------------------------

#
# Table structure for table `xoops_imgsetimg`
#

CREATE TABLE `xoops_imgsetimg` (
`imgsetimg_id` mediumint(8) unsigned NOT NULL auto_increment,
`imgsetimg_file` varchar(50) NOT NULL default '',
`imgsetimg_body` blob NOT NULL,
`imgsetimg_imgset` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`imgsetimg_id`),
KEY `imgsetimg_imgset` (`imgsetimg_imgset`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Dumping data for table `xoops_imgsetimg`
#


# --------------------------------------------------------

#
# Table structure for table `xoops_modules`
#

CREATE TABLE `xoops_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))
) TYPE=MyISAM AUTO_INCREMENT=2 ;

#
# Dumping data for table `xoops_modules`
#

INSERT INTO `xoops_modules` VALUES (1, 'System', 100, 1115107319, 0, 1, 'system', 0, 1, 0, 0, 0, 0);

# --------------------------------------------------------

#
# Table structure for table `xoops_newblocks`
#

CREATE TABLE `xoops_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 NOT NULL,
`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`)
) TYPE=MyISAM AUTO_INCREMENT=13 ;

#
# Dumping data for table `xoops_newblocks`
#

INSERT INTO `xoops_newblocks` VALUES (1, 1, 1, '', 'User Menu', 'User Menu', '', 0, 0, 1, 'S', 'H', 1, 'system', 'system_blocks.php', 'b_system_user_show', '', 'system_block_user.html', 0, 1115107319);
INSERT INTO `xoops_newblocks` VALUES (2, 1, 2, '', 'Login', 'Login', '', 0, 0, 1, 'S', 'H', 1, 'system', 'system_blocks.php', 'b_system_login_show', '', 'system_block_login.html', 0, 1115107319);
INSERT INTO `xoops_newblocks` VALUES (3, 1, 3, '', 'Search', 'Search', '', 0, 0, 0, 'S', 'H', 1, 'system', 'system_blocks.php', 'b_system_search_show', '', 'system_block_search.html', 0, 1115107319);
INSERT INTO `xoops_newblocks` VALUES (4, 1, 4, '', 'Waiting Contents', 'Waiting Contents', '', 0, 0, 0, 'S', 'H', 1, 'system', 'system_blocks.php', 'b_system_waiting_show', '', 'system_block_waiting.html', 0, 1115107319);
INSERT INTO `xoops_newblocks` VALUES (5, 1, 5, '', 'Main Menu', 'Main Menu', '', 0, 0, 1, 'S', 'H', 1, 'system', 'system_blocks.php', 'b_system_main_show', '', 'system_block_mainmenu.html', 0, 1115107319);
INSERT INTO `xoops_newblocks` VALUES (6, 1, 6, '320|190|s_poweredby.gif|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.html', 0, 1115107319);
INSERT INTO `xoops_newblocks` VALUES (7, 1, 7, '', 'Who\'s Online', 'Who\'s Online', '', 0, 0, 0, 'S', 'H', 1, 'system', 'system_blocks.php', 'b_system_online_show', '', 'system_block_online.html', 0, 1115107319);
INSERT INTO `xoops_newblocks` VALUES (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.html', 0, 1115107319);
INSERT INTO `xoops_newblocks` VALUES (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.html', 0, 1115107319);
INSERT INTO `xoops_newblocks` VALUES (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.html', 0, 1115107319);
INSERT INTO `xoops_newblocks` VALUES (11, 1, 11, '', 'Notification Options', 'Notification Options', '', 0, 0, 0, 'S', 'H', 1, 'system', 'system_blocks.php', 'b_system_notification_show', '', 'system_block_notification.html', 0, 1115107319);
INSERT INTO `xoops_newblocks` VALUES (12, 1, 12, '0|80', 'Themes', 'Themes', '', 0, 0, 0, 'S', 'H', 1, 'system', 'system_blocks.php', 'b_system_themes_show', 'b_system_themes_edit', 'system_block_themes.html', 0, 1115107319);

# --------------------------------------------------------

#
# Table structure for table `xoops_online`
#

CREATE TABLE `xoops_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(15) NOT NULL default '',
KEY `online_module` (`online_module`)
) TYPE=MyISAM;

#
# Dumping data for table `xoops_online`
#


# --------------------------------------------------------

#
# Table structure for table `xoops_priv_msgs`
#

CREATE TABLE `xoops_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 NOT NULL,
`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` (`msg_id`,`from_userid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Dumping data for table `xoops_priv_msgs`
#


# --------------------------------------------------------

#
# Table structure for table `xoops_ranks`
#

CREATE TABLE `xoops_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`)
) TYPE=MyISAM AUTO_INCREMENT=8 ;

#
# Dumping data for table `xoops_ranks`
#

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

# --------------------------------------------------------

#
# Table structure for table `xoops_session`
#

CREATE TABLE `xoops_session` (
`sess_id` varchar(32) NOT NULL default '',
`sess_updated` int(10) unsigned NOT NULL default '0',
`sess_ip` varchar(15) NOT NULL default '',
`sess_data` text NOT NULL,
PRIMARY KEY (`sess_id`),
KEY `updated` (`sess_updated`)
) TYPE=MyISAM;

#
# Dumping data for table `xoops_session`
#

INSERT INTO `xoops_session` VALUES ('735a0f4ff226f8df135f4c1a3034ce42', 1115107324, '192.168.0.37', '');

# --------------------------------------------------------

#
# Table structure for table `xoops_smiles`
#

CREATE TABLE `xoops_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`)
) TYPE=MyISAM AUTO_INCREMENT=18 ;

#
# Dumping data for table `xoops_smiles`
#

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

# --------------------------------------------------------

#
# Table structure for table `xoops_tplfile`
#

CREATE TABLE `xoops_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`),
KEY `tpl_refid` (`tpl_refid`,`tpl_type`),
KEY `tpl_tplset` (`tpl_tplset`,`tpl_file`(10))
) TYPE=MyISAM AUTO_INCREMENT=28 ;

#
# Dumping data for table `xoops_tplfile`
#

INSERT INTO `xoops_tplfile` VALUES (1, 1, 'system', 'default', 'system_imagemanager.html', '', 1115107319, 1115107319, 'module');
INSERT INTO `xoops_tplfile` VALUES (2, 1, 'system', 'default', 'system_imagemanager2.html', '', 1115107319, 1115107319, 'module');
INSERT INTO `xoops_tplfile` VALUES (3, 1, 'system', 'default', 'system_userinfo.html', '', 1115107319, 1115107319, 'module');
INSERT INTO `xoops_tplfile` VALUES (4, 1, 'system', 'default', 'system_userform.html', '', 1115107319, 1115107319, 'module');
INSERT INTO `xoops_tplfile` VALUES (5, 1, 'system', 'default', 'system_rss.html', '', 1115107319, 1115107319, 'module');
INSERT INTO `xoops_tplfile` VALUES (6, 1, 'system', 'default', 'system_redirect.html', '', 1115107319, 1115107319, 'module');
INSERT INTO `xoops_tplfile` VALUES (7, 1, 'system', 'default', 'system_comment.html', '', 1115107319, 1115107319, 'module');
INSERT INTO `xoops_tplfile` VALUES (8, 1, 'system', 'default', 'system_comments_flat.html', '', 1115107319, 1115107319, 'module');
INSERT INTO `xoops_tplfile` VALUES (9, 1, 'system', 'default', 'system_comments_thread.html', '', 1115107319, 1115107319, 'module');
INSERT INTO `xoops_tplfile` VALUES (10, 1, 'system', 'default', 'system_comments_nest.html', '', 1115107319, 1115107319, 'module');
INSERT INTO `xoops_tplfile` VALUES (11, 1, 'system', 'default', 'system_siteclosed.html', '', 1115107319, 1115107319, 'module');
INSERT INTO `xoops_tplfile` VALUES (12, 1, 'system', 'default', 'system_dummy.html', 'Dummy template file for holding non-template contents. This should not be edited.', 1115107319, 1115107319, 'module');
INSERT INTO `xoops_tplfile` VALUES (13, 1, 'system', 'default', 'system_notification_list.html', '', 1115107319, 1115107319, 'module');
INSERT INTO `xoops_tplfile` VALUES (14, 1, 'system', 'default', 'system_notification_select.html', '', 1115107319, 1115107319, 'module');
INSERT INTO `xoops_tplfile` VALUES (15, 1, 'system', 'default', 'system_block_dummy.html', 'Dummy template for custom blocks or blocks without templates', 1115107319, 1115107319, 'module');
INSERT INTO `xoops_tplfile` VALUES (16, 1, 'system', 'default', 'system_block_user.html', 'Shows user block', 1115107319, 1115107319, 'block');
INSERT INTO `xoops_tplfile` VALUES (17, 2, 'system', 'default', 'system_block_login.html', 'Shows login form', 1115107319, 1115107319, 'block');
INSERT INTO `xoops_tplfile` VALUES (18, 3, 'system', 'default', 'system_block_search.html', 'Shows search form block', 1115107319, 1115107319, 'block');
INSERT INTO `xoops_tplfile` VALUES (19, 4, 'system', 'default', 'system_block_waiting.html', 'Shows contents waiting for approval', 1115107319, 1115107319, 'block');
INSERT INTO `xoops_tplfile` VALUES (20, 5, 'system', 'default', 'system_block_mainmenu.html', 'Shows the main navigation menu of the site', 1115107319, 1115107319, 'block');
INSERT INTO `xoops_tplfile` VALUES (21, 6, 'system', 'default', 'system_block_siteinfo.html', 'Shows basic info about the site and a link to Recommend Us pop up window', 1115107319, 1115107319, 'block');
INSERT INTO `xoops_tplfile` VALUES (22, 7, 'system', 'default', 'system_block_online.html', 'Displays users/guests currently online', 1115107319, 1115107319, 'block');
INSERT INTO `xoops_tplfile` VALUES (23, 8, 'system', 'default', 'system_block_topusers.html', 'Top posters', 1115107319, 1115107319, 'block');
INSERT INTO `xoops_tplfile` VALUES (24, 9, 'system', 'default', 'system_block_newusers.html', 'Shows most recent users', 1115107319, 1115107319, 'block');
INSERT INTO `xoops_tplfile` VALUES (25, 10, 'system', 'default', 'system_block_comments.html', 'Shows most recent comments', 1115107319, 1115107319, 'block');
INSERT INTO `xoops_tplfile` VALUES (26, 11, 'system', 'default', 'system_block_notification.html', 'Shows notification options', 1115107319, 1115107319, 'block');
INSERT INTO `xoops_tplfile` VALUES (27, 12, 'system', 'default', 'system_block_themes.html', 'Shows theme selection box', 1115107319, 1115107319, 'block');

# --------------------------------------------------------

#
# Table structure for table `xoops_tplset`
#

CREATE TABLE `xoops_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 NOT NULL,
`tplset_created` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`tplset_id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

#
# Dumping data for table `xoops_tplset`
#

INSERT INTO `xoops_tplset` VALUES (1, 'default', 'XOOPS Default Template Set', '', 1115107319);

# --------------------------------------------------------

#
# Table structure for table `xoops_tplsource`
#

CREATE TABLE `xoops_tplsource` (
`tpl_id` mediumint(7) unsigned NOT NULL default '0',
`tpl_source` mediumtext NOT NULL,
KEY `tpl_id` (`tpl_id`)
) TYPE=MyISAM;

#
# Dumping data for table `xoops_tplsource`
#

INSERT INTO `xoops_tplsource` VALUES (1, '<!DOCTYPE html PUBLIC \'-//W3C//DTD XHTML 1.0 Transitional//EN\' \'http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\'>\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="<{$xoops_langcode}>" lang="<{$xoops_langcode}>">\r\n<head>\r\n<meta http-equiv="content-type" content="text/html; charset=<{$xoops_charset}>" />\r\n<meta http-equiv="content-language" content="<{$xoops_langcode}>" />\r\n<title><{$sitename}> <{$lang_imgmanager}></title>\r\n<script type="text/javascript">\r\n<!--//\r\nfunction appendCode(addCode) {\r\n var targetDom = window.opener.xoopsGetElementById(\'<{$target}>\');\r\n if (targetDom.createTextRange && targetDom.caretPos){\r\n var caretPos = targetDom.caretPos;\r\n caretPos.text = caretPos.text.charAt(caretPos.text.length - 1) \r\n== \' \' ? addCode + \' \' : addCode; \r\n } else if (targetDom.getSelection && targetDom.caretPos){\r\n var caretPos = targetDom.caretPos;\r\n caretPos.text = caretPos.text.charat(caretPos.text.length - 1) \r\n== \' \' ? addCode + \' \' : addCode;\r\n } else {\r\n targetDom.value = targetDom.value + addCode;\r\n }\r\n window.close();\r\n return;\r\n}\r\n//-->\r\n</script>\r\n<style type="text/css" media="all">\r\nbody {margin: 0;}\r\nimg {border: 0;}\r\ntable {width: 100%; margin: 0;}\r\na:link {color: #3a76d6; font-weight: bold; background-color: transparent;}\r\na:visited {color: #9eb2d6; font-weight: bold; background-color: transparent;}\r\na:hover {color: #e18a00; background-color: transparent;}\r\ntable td {background-color: white; font-size: 12px; padding: 0; border-width: 0; vertical-align: top; font-family: Verdana, Arial, Helvetica, sans-serif;}\r\ntable#imagenav td {vertical-align: bottom; padding: 5px;}\r\ntable#imagemain td {border-right: 1px solid silver; border-bottom: 1px solid silver; padding: 5px; vertical-align: middle;}\r\ntable#imagemain th {border: 0; background-color: #2F5376; color:white; font-size: 12px; padding: 5px; vertical-align: top; text-align:center; font-family: Verdana, Arial, Helvetica, sans-serif;}\r\ntable#header td {width: 100%; background-color: #2F5376; vertical-align: middle;}\r\ntable#header td#headerbar {border-bottom: 1px solid silver; background-color: #dddddd;}\r\ndiv#pagenav {text-align:center;}\r\ndiv#footer {text-align:right; padding: 5px;}\r\n</style>\r\n</head>\r\n\r\n<body onload="window.resizeTo(<{$xsize}>, <{$ysize}>);">\r\n <table id="header" cellspacing="0">\r\n <tr>\r\n <td><a href="<{$xoops_url}>/"><img src="<{$xoops_url}>/images/logo.gif" width="150" height="80" alt="" /></a></td><td> </td>\r\n </tr>\r\n <tr>\r\n <td id="headerbar" colspan="2"> </td>\r\n </tr>\r\n </table>\r\n\r\n <form action="imagemanager.php" method="get">\r\n <table cellspacing="0" id="imagenav">\r\n <tr>\r\n <td>\r\n <select name="cat_id" onchange="location=\'<{$xoops_url}>/imagemanager.php?target=<{$target}>&cat_id=\'+this.options[this.selectedIndex].value"><{$cat_options}></select> <input type="hidden" name="target" value="<{$target}>" /><input type="submit" value="<{$lang_go}>" />\r\n </td>\r\n\r\n <{if $show_cat > 0}>\r\n <td align="right"><a href="<{$xoops_url}>/imagemanager.php?target=<{$target}>&op=upload&imgcat_id=<{$show_cat}>"><{$lang_addimage}></a></td>\r\n <{/if}>\r\n\r\n </tr>\r\n </table>\r\n </form>\r\n\r\n <{if $image_total > 0}>\r\n\r\n <table cellspacing="0" id="imagemain">\r\n <tr>\r\n <th><{$lang_imagename}></th>\r\n <th><{$lang_image}></th>\r\n <th><{$lang_imagemime}></th>\r\n <th><{$lang_align}></th>\r\n </tr>\r\n\r\n <{section name=i loop=$images}>\r\n <tr align="center">\r\n <td><input type="hidden" name="image_id[]" value="<{$images[i].id}>" /><{$images[i].nicename}></td>\r\n <td><img src="<{$images[i].src}>" alt="" /></td>\r\n <td><{$images[i].mimetype}></td>\r\n <td><a href="#" onclick="javascript:appendCode(\'<{$images[i].lxcode}>\');"><img src="<{$xoops_url}>/images/alignleft.gif" alt="Left" /></a> <a href="#" onclick="javascript:appendCode(\'<{$images[i].xcode}>\');"><img src="<{$xoops_url}>/images/aligncenter.gif" alt="Center" /></a> <a href="#" onclick="javascript:appendCode(\'<{$images[i].rxcode}>\');"><img src="<{$xoops_url}>/images/alignright.gif" alt="Right" /></a></td>\r\n </tr>\r\n <{/section}>\r\n </table>\r\n\r\n <{/if}>\r\n\r\n <div id="pagenav"><{$pagenav}></div>\r\n\r\n <div id="footer">\r\n <input value="<{$lang_close}>" type="button" onclick="javascript:window.close();" />\r\n </div>\r\n\r\n </body>\r\n</html>');
INSERT INTO `xoops_tplsource` VALUES (2, '<!DOCTYPE html PUBLIC \'-//W3C//DTD XHTML 1.0 Transitional//EN\' \'http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\'>\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="<{$xoops_langcode}>" lang="<{$xoops_langcode}>">\r\n<head>\r\n<meta http-equiv="content-type" content="text/html; charset=<{$xoops_charset}>" />\r\n<meta http-equiv="content-language" content="<{$xoops_langcode}>" />\r\n<title><{$xoops_sitename}> <{$lang_imgmanager}></title>\r\n<{$image_form.javascript}>\r\n<style type="text/css" media="all">\r\nbody {margin: 0;}\r\nimg {border: 0;}\r\ntable {width: 100%; margin: 0;}\r\na:link {color: #3a76d6; font-weight: bold; background-color: transparent;}\r\na:visited {color: #9eb2d6; font-weight: bold; background-color: transparent;}\r\na:hover {color: #e18a00; background-color: transparent;}\r\ntable td {background-color: white; font-size: 12px; padding: 0; border-width: 0; vertical-align: top; font-family: Verdana, Arial, Helvetica, sans-serif;}\r\ntable#imagenav td {vertical-align: bottom; padding: 5px;}\r\ntd.body {padding: 5px; vertical-align: middle;}\r\ntd.caption {border: 0; background-color: #2F5376; color:white; font-size: 12px; padding: 5px; vertical-align: top; text-align:left; font-family: Verdana, Arial, Helvetica, sans-serif;}\r\ntable#imageform {border: 1px solid silver;}\r\ntable#header td {width: 100%; background-color: #2F5376; vertical-align: middle;}\r\ntable#header td#headerbar {border-bottom: 1px solid silver; background-color: #dddddd;}\r\ndiv#footer {text-align:right; padding: 5px;}\r\n</style>\r\n</head>\r\n\r\n<body onload="window.resizeTo(<{$xsize}>, <{$ysize}>);">\r\n <table id="header" cellspacing="0">\r\n <tr>\r\n <td><a href="<{$xoops_url}>/"><img src="<{$xoops_url}>/images/logo.gif" width="150" height="80" alt="" /></a></td><td> </td>\r\n </tr>\r\n <tr>\r\n <td id="headerbar" colspan="2"> </td>\r\n </tr>\r\n </table>\r\n\r\n <table cellspacing="0" id="imagenav">\r\n <tr>\r\n <td align="left"><a href="<{$xoops_url}>/imagemanager.php?target=<{$target}>&cat_id=<{$show_cat}>"><{$lang_imgmanager}></a></td>\r\n </tr>\r\n </table>\r\n\r\n <form name="<{$image_form.name}>" id="<{$image_form.name}>" action="<{$image_form.action}>" method="<{$image_form.method}>" <{$image_form.extra}>>\r\n <table id="imageform" cellspacing="0">\r\n <!-- start of form elements loop -->\r\n <{foreach item=element from=$image_form.elements}>\r\n <{if $element.hidden != true}>\r\n <tr valign="top">\r\n <td class="caption"><{$element.caption}></td>\r\n <td class="body"><{$element.body}></td>\r\n </tr>\r\n <{else}>\r\n <{$element.body}>\r\n <{/if}>\r\n <{/foreach}>\r\n <!-- end of form elements loop -->\r\n </table>\r\n </form>\r\n\r\n\r\n <div id="footer">\r\n <input value="<{$lang_close}>" type="button" onclick="javascript:window.close();" />\r\n </div>\r\n\r\n </body>\r\n</html>');
INSERT INTO `xoops_tplsource` VALUES (3, '<{if $user_ownpage == true}>\r\n\r\n<form name="usernav" action="user.php" method="post">\r\n\r\n<br /><br />\r\n\r\n<table width="70%" align="center" border="0">\r\n <tr align="center">\r\n <td><input type="button" value="<{$lang_editprofile}>" onclick="location=\'edituser.php\'" />\r\n <input type="button" value="<{$lang_avatar}>" onclick="location=\'edituser.php?op=avatarform\'" />\r\n <input type="button" value="<{$lang_inbox}>" onclick="location=\'viewpmsg.php\'" />\r\n\r\n <{if $user_candelete == true}>\r\n <input type="button" value="<{$lang_deleteaccount}>" onclick="location=\'user.php?op=delete\'" />\r\n <{/if}>\r\n\r\n <input type="button" value="<{$lang_logout}>" onclick="location=\'user.php?op=logout\'" /></td>\r\n </tr>\r\n</table>\r\n</form>\r\n\r\n<br /><br />\r\n<{elseif $xoops_isadmin != false}>\r\n\r\n<br /><br />\r\n\r\n<table width="70%" align="center" border="0">\r\n <tr align="center">\r\n <td><input type="button" value="<{$lang_editprofile}>" onclick="location=\'<{$xoops_url}>/modules/system/admin.php?fct=users&uid=<{$user_uid}>&op=modifyUser\'" />\r\n <input type="button" value="<{$lang_deleteaccount}>" onclick="location=\'<{$xoops_url}>/modules/system/admin.php?fct=users&op=delUser&uid=<{$user_uid}>\'" />\r\n </tr>\r\n</table>\r\n\r\n<br /><br />\r\n<{/if}>\r\n\r\n<table width="100%" border="0" cellspacing="5">\r\n <tr valign="top">\r\n <td width="50%">\r\n <table class="outer" cellpadding="4" cellspacing="1" width="100%">\r\n <tr>\r\n <th colspan="2" align="center"><{$lang_allaboutuser}></th>\r\n </tr>\r\n <tr valign="top">\r\n <td class="head"><{$lang_avatar}></td>\r\n <td align="center" class="even"><img src="<{$user_avatarurl}>" alt="Avatar" /></td>\r\n </tr>\r\n <tr>\r\n <td class="head"><{$lang_realname}></td>\r\n <td align="center" class="odd"><{$user_realname}></td>\r\n </tr>\r\n <tr>\r\n <td class="head"><{$lang_website}></td>\r\n <td class="even"><{$user_websiteurl}></td>\r\n </tr>\r\n <tr valign="top">\r\n <td class="head"><{$lang_email}></td>\r\n <td class="odd"><{$user_email}></td>\r\n </tr>\r\n <tr valign="top">\r\n <td class="head"><{$lang_privmsg}></td>\r\n <td class="even"><{$user_pmlink}></td>\r\n </tr>\r\n <tr valign="top">\r\n <td class="head"><{$lang_icq}></td>\r\n <td class="odd"><{$user_icq}></td>\r\n </tr>\r\n <tr valign="top">\r\n <td class="head"><{$lang_aim}></td>\r\n <td class="even"><{$user_aim}></td>\r\n </tr>\r\n <tr valign="top">\r\n <td class="head"><{$lang_yim}></td>\r\n <td class="odd"><{$user_yim}></td>\r\n </tr>\r\n <tr valign="top">\r\n <td class="head"><{$lang_msnm}></td>\r\n <td class="even"><{$user_msnm}></td>\r\n </tr>\r\n <tr valign="top">\r\n <td class="head"><{$lang_location}></td>\r\n <td class="odd"><{$user_location}></td>\r\n </tr>\r\n <tr valign="top">\r\n <td class="head"><{$lang_occupation}></td>\r\n <td class="even"><{$user_occupation}></td>\r\n </tr>\r\n <tr valign="top">\r\n <td class="head"><{$lang_interest}></td>\r\n <td class="odd"><{$user_interest}></td>\r\n </tr>\r\n <tr valign="top">\r\n <td class="head"><{$lang_extrainfo}></td>\r\n <td class="even"><{$user_extrainfo}></td>\r\n </tr>\r\n </table>\r\n </td>\r\n <td width="50%">\r\n <table class="outer" cellpadding="4" cellspacing="1" width="100%">\r\n <tr valign="top">\r\n <th colspan="2" align="center"><{$lang_statistics}></th>\r\n </tr>\r\n <tr valign="top">\r\n <td class="head"><{$lang_membersince}></td>\r\n <td align="center" class="even"><{$user_joindate}></td>\r\n </tr>\r\n <tr valign="top">\r\n <td class="head"><{$lang_rank}></td>\r\n <td align="center" class="odd"><{$user_rankimage}><br /><{$user_ranktitle}></td>\r\n </tr>\r\n <tr valign="top">\r\n <td class="head"><{$lang_posts}></td>\r\n <td align="center" class="even"><{$user_posts}></td>\r\n </tr>\r\n <tr valign="top">\r\n <td class="head"><{$lang_lastlogin}></td>\r\n <td align="center" class="odd"><{$user_lastlogin}></td>\r\n </tr>\r\n </table>\r\n <br />\r\n <table class="outer" cellpadding="4" cellspacing="1" width="100%">\r\n <tr valign="top">\r\n <th colspan="2" align="center"><{$lang_signature}></th>\r\n </tr>\r\n <tr valign="top">\r\n <td class="even"><{$user_signature}></td>\r\n </tr>\r\n </table>\r\n </td>\r\n </tr>\r\n</table>\r\n\r\n<!-- start module search results loop -->\r\n<{foreach item=module from=$modules}>\r\n\r\n<p>\r\n<h4><{$module.name}></h4>\r\n\r\n <!-- start results item loop -->\r\n <{foreach item=result from=$module.results}>\r\n\r\n <img src="<{$result.image}>" alt="<{$module.name}>" /><b><a href="<{$result.link}>"><{$result.title}></a></b><br /><small>(<{$result.time}>)</small><br />\r\n\r\n <{/foreach}>\r\n <!-- end results item loop -->\r\n\r\n<{$module.showall_link}>\r\n</p>\r\n\r\n<{/foreach}>\r\n<!-- end module search results loop -->\r\n');
INSERT INTO `xoops_tplsource` VALUES (4, '<fieldset style="padding: 10px;">\r\n <legend style="font-weight: bold;"><{$lang_login}></legend>\r\n <form action="user.php" method="post">\r\n <{$lang_username}> <input type="text" name="uname" size="26" maxlength="25" value="<{$usercookie}>" /><br />\r\n <{$lang_password}> <input type="password" name="pass" size="21" maxlength="32" /><br />\r\n <input type="hidden" name="op" value="login" />\r\n <input type="hidden" name="xoops_redirect" value="<{$redirect_page}>" />\r\n <input type="submit" value="<{$lang_login}>" />\r\n </form>\r\n <a name="lost"></a>\r\n <div><{$lang_notregister}><br /></div>\r\n</fieldset>\r\n\r\n<br />\r\n\r\n<fieldset style="padding: 10px;">\r\n <legend style="font-weight: bold;"><{$lang_lostpassword}></legend>\r\n <div><br /><{$l