manuel install af joomlaboard, SQL indhold - Joomla! Forum - community, help and support
hej, jeg har forsøgt @ installere joomlaboard manuelt. men beskrivelsen var til det gamle simpleboard, og der er vist lidt forskel.
jeg tror jeg vil være hjulpet hvis jeg kunne se hvad der skal stå databasen.
beskrivelsen til simpleboard ser sådan ud.
insert `mos_components` ( `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`,
`ordering`, `admin_menu_img`, `iscore`, `comdir`, `admindir`) values ('simpleboard forum', 'option=com_simpleboard', 0,
0, 'option=com_simpleboard', 'simpleboard forum', 'com_simpleboard', 0, 'js/themeoffice/component.png', 0,
'your_path/components/com_simpleboard/', 'your_path/administrator/components/com_simpleboard/'); ('sb
configuration', '', 0, 100030, 'option=com_simpleboard&task=showconfig', 'sb configuration', 'com_simpleboard', 0,
'js/themeoffice/component.png', 0, 'your_path/components/com_simpleboard/',
'your_path/administrator/components/com_simpleboard/'); ('forum administration', '', 0, 100030,
'option=com_simpleboard', 'forum administration', 'com_simpleboard', 1, 'js/themeoffice/component.png', 0,
'your_path/components/com_simpleboard/', 'your_path/administrator/components/com_simpleboard/'); ('user
administration', '', 0, 100030, 'option=com_simpleboard&task=showprofiles', 'user administration', 'com_simpleboard', 2,
'js/themeoffice/component.png', 0, 'your_path/components/com_simpleboard/',
'your_path/administrator/components/com_simpleboard/'); ('edit css template', '', 0, 100030,
'option=com_simpleboard&task=showcss', 'edit css template', 'com_simpleboard', 3, 'js/themeoffice/component.png',
0, 'your_path/components/com_simpleboard/', 'your_path/administrator/components/com_simpleboard/'); ('instructions',
'', 0, 100030, 'option=com_simpleboard&task=showinstructions', 'instructions', 'com_simpleboard', 4,
'js/themeoffice/component.png', 0, 'your_path/components/com_simpleboard/',
'your_path/administrator/components/com_simpleboard/');
just copy , paste query text editor , update 'your_path' bit matches path other
components have there. "/home/myuserid/public_html", check first!
then copy , paste 'sql' section of phpmyadmin , execute it.
jeg kan selv se @ databasen er opbygget med andre poster, ca. sådan her:
insert `jos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) values (20, 'joomlaboard forum', 'option=com_joomlaboard', 0, 0, 'option=com_joomlaboard', 'joomlaboard forum', 'com_joomlaboard', 0, 'js/themeoffice/component.png', 0, '');
insert `jos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) values (21, 'jb configuration', '', 0, 100030, 'option=com_joomlaboard&task=showconfig', 'jb configuration', 'com_joomlaboard', 0, 'js/themeoffice/component.png', 0, '');
insert `jos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) values (22, 'forum administration', '', 0, 100030, 'option=com_joomlaboard', 'forum administration', 'com_joomlaboard', 1, 'js/themeoffice/component.png', 0, '');
insert `jos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) values (23, 'user administration', '', 0, 100030, 'option=com_joomlaboard&task=showprofiles', 'user administration', 'com_joomlaboard', 2, 'js/themeoffice/component.png', 0, '');
insert `jos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) values (24, 'edit css template', '', 0, 100030, 'option=com_joomlaboard&task=showcss', 'edit css template', 'com_joomlaboard', 3, 'js/themeoffice/component.png', 0, '');
insert `jos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) values (25, 'instructions', '', 0, 100030, 'option=com_joomlaboard&task=showinstructions', 'instructions', 'com_joomlaboard', 4, 'js/themeoffice/component.png', 0, '');
men, det virker ikke efter hensigten.
kan nogen evt. lave et dump af deres databasedel der viser joomlaboard indstillinger?
hilsen henrik
jeg tror jeg vil være hjulpet hvis jeg kunne se hvad der skal stå databasen.
beskrivelsen til simpleboard ser sådan ud.
insert `mos_components` ( `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`,
`ordering`, `admin_menu_img`, `iscore`, `comdir`, `admindir`) values ('simpleboard forum', 'option=com_simpleboard', 0,
0, 'option=com_simpleboard', 'simpleboard forum', 'com_simpleboard', 0, 'js/themeoffice/component.png', 0,
'your_path/components/com_simpleboard/', 'your_path/administrator/components/com_simpleboard/'); ('sb
configuration', '', 0, 100030, 'option=com_simpleboard&task=showconfig', 'sb configuration', 'com_simpleboard', 0,
'js/themeoffice/component.png', 0, 'your_path/components/com_simpleboard/',
'your_path/administrator/components/com_simpleboard/'); ('forum administration', '', 0, 100030,
'option=com_simpleboard', 'forum administration', 'com_simpleboard', 1, 'js/themeoffice/component.png', 0,
'your_path/components/com_simpleboard/', 'your_path/administrator/components/com_simpleboard/'); ('user
administration', '', 0, 100030, 'option=com_simpleboard&task=showprofiles', 'user administration', 'com_simpleboard', 2,
'js/themeoffice/component.png', 0, 'your_path/components/com_simpleboard/',
'your_path/administrator/components/com_simpleboard/'); ('edit css template', '', 0, 100030,
'option=com_simpleboard&task=showcss', 'edit css template', 'com_simpleboard', 3, 'js/themeoffice/component.png',
0, 'your_path/components/com_simpleboard/', 'your_path/administrator/components/com_simpleboard/'); ('instructions',
'', 0, 100030, 'option=com_simpleboard&task=showinstructions', 'instructions', 'com_simpleboard', 4,
'js/themeoffice/component.png', 0, 'your_path/components/com_simpleboard/',
'your_path/administrator/components/com_simpleboard/');
just copy , paste query text editor , update 'your_path' bit matches path other
components have there. "/home/myuserid/public_html", check first!
then copy , paste 'sql' section of phpmyadmin , execute it.
jeg kan selv se @ databasen er opbygget med andre poster, ca. sådan her:
insert `jos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) values (20, 'joomlaboard forum', 'option=com_joomlaboard', 0, 0, 'option=com_joomlaboard', 'joomlaboard forum', 'com_joomlaboard', 0, 'js/themeoffice/component.png', 0, '');
insert `jos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) values (21, 'jb configuration', '', 0, 100030, 'option=com_joomlaboard&task=showconfig', 'jb configuration', 'com_joomlaboard', 0, 'js/themeoffice/component.png', 0, '');
insert `jos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) values (22, 'forum administration', '', 0, 100030, 'option=com_joomlaboard', 'forum administration', 'com_joomlaboard', 1, 'js/themeoffice/component.png', 0, '');
insert `jos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) values (23, 'user administration', '', 0, 100030, 'option=com_joomlaboard&task=showprofiles', 'user administration', 'com_joomlaboard', 2, 'js/themeoffice/component.png', 0, '');
insert `jos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) values (24, 'edit css template', '', 0, 100030, 'option=com_joomlaboard&task=showcss', 'edit css template', 'com_joomlaboard', 3, 'js/themeoffice/component.png', 0, '');
insert `jos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) values (25, 'instructions', '', 0, 100030, 'option=com_joomlaboard&task=showinstructions', 'instructions', 'com_joomlaboard', 4, 'js/themeoffice/component.png', 0, '');
men, det virker ikke efter hensigten.
kan nogen evt. lave et dump af deres databasedel der viser joomlaboard indstillinger?
hilsen henrik
jeg fandt selv en løsning:
insert `jos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) values (??, 'joomlaboard forum', 'option=com_joomlaboard', 0, 0, 'option=com_joomlaboard', 'joomlaboard forum', 'com_joomlaboard', 0, '../administrator/components/com_joomlaboard/images/sbmenu.png', 0, '');
--
-- struktur dump tabellen `jos_sb_attachments`
--
create table `jos_sb_attachments` (
`mesid` int(11) not null default '0',
`filelocation` text not null,
key `mesid` (`mesid`)
) engine=myisam default charset=utf8;
--
-- data dump tabellen `jos_sb_attachments`
--
-- --------------------------------------------------------
--
-- struktur dump tabellen `jos_sb_categories`
--
create table `jos_sb_categories` (
`id` int(11) not null auto_increment,
`parent` int(11) default '0',
`name` tinytext,
`cat_emoticon` tinyint(4) not null default '0',
`locked` tinyint(4) not null default '0',
`alert_admin` tinyint(4) not null default '0',
`moderated` tinyint(4) not null default '0',
`moderators` varchar(15) default null,
`pub_access` tinyint(4) default '1',
`pub_recurse` tinyint(4) default '1',
`admin_access` tinyint(4) default '0',
`admin_recurse` tinyint(4) default '1',
`ordering` tinyint(4) not null default '0',
`future2` int(11) default '0',
`published` tinyint(4) not null default '0',
`checked_out` tinyint(4) not null default '0',
`checked_out_time` datetime not null default '0000-00-00 00:00:00',
`review` tinyint(4) not null default '0',
`hits` int(11) not null default '0',
`description` text not null,
unique key `catid` (`id`),
key `catparent` (`parent`)
) engine=myisam default charset=utf8 auto_increment=1 ;
--
-- data dump tabellen `jos_sb_categories`
--
-- --------------------------------------------------------
--
-- struktur dump tabellen `jos_sb_messages`
--
create table `jos_sb_messages` (
`id` int(11) not null auto_increment,
`parent` int(11) default '0',
`thread` int(11) default '0',
`catid` int(11) not null default '0',
`name` tinytext,
`userid` int(11) not null default '0',
`email` tinytext,
`subject` tinytext,
`time` int(11) not null default '0',
`ip` varchar(15) default null,
`topic_emoticon` int(11) not null default '0',
`locked` tinyint(4) not null default '0',
`hold` tinyint(4) not null default '0',
`ordering` int(11) default '0',
`hits` int(11) default '0',
`moved` tinyint(4) default '0',
primary key (`id`),
key `thread` (`thread`),
key `id` (`id`),
key `parent` (`parent`),
key `catid` (`catid`),
key `ip` (`ip`),
key `userid` (`userid`),
key `time` (`time`,`hold`)
) engine=myisam default charset=utf8 auto_increment=1 ;
--
-- data dump tabellen `jos_sb_messages`
--
-- --------------------------------------------------------
--
-- struktur dump tabellen `jos_sb_messages_text`
--
create table `jos_sb_messages_text` (
`mesid` int(11) not null default '0',
`message` text not null,
unique key `mesid` (`mesid`)
) engine=myisam default charset=utf8;
--
-- data dump tabellen `jos_sb_messages_text`
--
-- --------------------------------------------------------
--
-- struktur dump tabellen `jos_sb_moderation`
--
create table `jos_sb_moderation` (
`catid` int(11) not null default '0',
`userid` int(11) not null default '0',
`future1` tinyint(4) default '0',
`future2` int(11) default '0',
primary key (`catid`,`userid`),
key `catid` (`catid`)
) engine=myisam default charset=utf8;
--
-- data dump tabellen `jos_sb_moderation`
--
-- --------------------------------------------------------
--
-- struktur dump tabellen `jos_sb_sessions`
--
create table `jos_sb_sessions` (
`userid` int(11) not null default '0',
`allowed` text,
`lasttime` int(11) not null default '0',
`readtopics` text,
primary key (`userid`)
) engine=myisam default charset=utf8;
--
-- data dump tabellen `jos_sb_sessions`
--
-- --------------------------------------------------------
--
-- struktur dump tabellen `jos_sb_smileys`
--
create table `jos_sb_smileys` (
`id` int(4) not null auto_increment,
`code` varchar(12) not null default '',
`location` varchar(50) not null default '',
`greylocation` varchar(60) not null default '',
`emoticonbar` tinyint(4) not null default '0',
primary key (`id`)
) engine=myisam default charset=utf8 auto_increment=38 ;
--
-- data dump tabellen `jos_sb_smileys`
--
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (1, 'b)', 'cool.png', 'cool-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (8, ';)', 'wink.png', 'wink-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (3, ':)', 'smile.png', 'smile-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (10, ':p', 'tongue.png', 'tongue-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (6, ':laugh:', 'laughing.png', 'laughing-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (17, ':ohmy:', 'shocked.png', 'shocked-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (22, ':sick:', 'sick.png', 'sick-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (14, ':angry:', 'angry.png', 'angry-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (25, ':blink:', 'blink.png', 'blink-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (2, ':(', 'sad.png', 'sad-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (16, ':unsure:', 'unsure.png', 'unsure-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (27, ':kiss:', 'kissing.png', 'kissing-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (29, ':woohoo:', 'w00t.png', 'w00t-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (21, ':lol:', 'grin.png', 'grin-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (23, ':silly:', 'silly.png', 'silly-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (35, ':pinch:', 'pinch.png', 'pinch-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (30, ':side:', 'sideways.png', 'sideways-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (34, ':whistle:', 'whistling.png', 'whistling-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (33, ':evil:', 'devil.png', 'devil-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (31, ':s', 'dizzy.png', 'dizzy-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (26, ':blush:', 'blush.png', 'blush-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (7, ':cheer:', 'cheerful.png', 'cheerful-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (18, ':huh:', 'wassat.png', 'wassat-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (19, ':dry:', 'ermm.png', 'ermm-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (4, ':-)', 'smile.png', 'smile-grey.png', 0);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (5, ':-(', 'sad.png', 'sad-grey.png', 0);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (9, ';-)', 'wink.png', 'wink-grey.png', 0);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (37, ':d', 'laughing.png', 'laughing-grey.png', 0);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (12, ':x', 'sick.png', 'sick-grey.png', 0);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (13, ':x', 'sick.png', 'sick-grey.png', 0);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (15, ':mad:', 'angry.png', 'angry-grey.png', 0);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (20, ':ermm:', 'ermm.png', 'ermm-grey.png', 0);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (24, ':y32b4:', 'silly.png', 'silly-grey.png', 0);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (28, ':rolleyes:', 'blink.png', 'blink-grey.png', 0);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (32, ':s', 'dizzy.png', 'dizzy-grey.png', 0);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (36, ':p', 'tongue.png', 'tongue-grey.png', 0);
-- --------------------------------------------------------
--
-- struktur dump tabellen `jos_sb_subscriptions`
--
create table `jos_sb_subscriptions` (
`thread` int(11) not null default '0',
`userid` int(11) not null default '0',
`future1` int(11) default '0',
key `thread` (`thread`),
key `userid` (`userid`)
) engine=myisam default charset=utf8;
--
-- data dump tabellen `jos_sb_subscriptions`
--
-- --------------------------------------------------------
--
-- struktur dump tabellen `jos_sb_users`
--
create table `jos_sb_users` (
`userid` int(11) not null default '0',
`view` varchar(8) not null default 'flat',
`signature` text,
`moderator` int(11) default '0',
`ordering` int(11) default '0',
`posts` int(11) default '0',
`avatar` varchar(50) default null,
`karma` int(11) default '0',
`karma_time` int(11) default '0',
primary key (`userid`)
) engine=myisam default charset=utf8;
--
-- data dump tabellen `jos_sb_users`
--
hentede jsas, og lavade en lokal install. så kunne jeg se hvad der skulle stå i databasen.
obs ?? erstattes med det tal der svarer til næste entry
henrik
insert `jos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) values (??, 'joomlaboard forum', 'option=com_joomlaboard', 0, 0, 'option=com_joomlaboard', 'joomlaboard forum', 'com_joomlaboard', 0, '../administrator/components/com_joomlaboard/images/sbmenu.png', 0, '');
--
-- struktur dump tabellen `jos_sb_attachments`
--
create table `jos_sb_attachments` (
`mesid` int(11) not null default '0',
`filelocation` text not null,
key `mesid` (`mesid`)
) engine=myisam default charset=utf8;
--
-- data dump tabellen `jos_sb_attachments`
--
-- --------------------------------------------------------
--
-- struktur dump tabellen `jos_sb_categories`
--
create table `jos_sb_categories` (
`id` int(11) not null auto_increment,
`parent` int(11) default '0',
`name` tinytext,
`cat_emoticon` tinyint(4) not null default '0',
`locked` tinyint(4) not null default '0',
`alert_admin` tinyint(4) not null default '0',
`moderated` tinyint(4) not null default '0',
`moderators` varchar(15) default null,
`pub_access` tinyint(4) default '1',
`pub_recurse` tinyint(4) default '1',
`admin_access` tinyint(4) default '0',
`admin_recurse` tinyint(4) default '1',
`ordering` tinyint(4) not null default '0',
`future2` int(11) default '0',
`published` tinyint(4) not null default '0',
`checked_out` tinyint(4) not null default '0',
`checked_out_time` datetime not null default '0000-00-00 00:00:00',
`review` tinyint(4) not null default '0',
`hits` int(11) not null default '0',
`description` text not null,
unique key `catid` (`id`),
key `catparent` (`parent`)
) engine=myisam default charset=utf8 auto_increment=1 ;
--
-- data dump tabellen `jos_sb_categories`
--
-- --------------------------------------------------------
--
-- struktur dump tabellen `jos_sb_messages`
--
create table `jos_sb_messages` (
`id` int(11) not null auto_increment,
`parent` int(11) default '0',
`thread` int(11) default '0',
`catid` int(11) not null default '0',
`name` tinytext,
`userid` int(11) not null default '0',
`email` tinytext,
`subject` tinytext,
`time` int(11) not null default '0',
`ip` varchar(15) default null,
`topic_emoticon` int(11) not null default '0',
`locked` tinyint(4) not null default '0',
`hold` tinyint(4) not null default '0',
`ordering` int(11) default '0',
`hits` int(11) default '0',
`moved` tinyint(4) default '0',
primary key (`id`),
key `thread` (`thread`),
key `id` (`id`),
key `parent` (`parent`),
key `catid` (`catid`),
key `ip` (`ip`),
key `userid` (`userid`),
key `time` (`time`,`hold`)
) engine=myisam default charset=utf8 auto_increment=1 ;
--
-- data dump tabellen `jos_sb_messages`
--
-- --------------------------------------------------------
--
-- struktur dump tabellen `jos_sb_messages_text`
--
create table `jos_sb_messages_text` (
`mesid` int(11) not null default '0',
`message` text not null,
unique key `mesid` (`mesid`)
) engine=myisam default charset=utf8;
--
-- data dump tabellen `jos_sb_messages_text`
--
-- --------------------------------------------------------
--
-- struktur dump tabellen `jos_sb_moderation`
--
create table `jos_sb_moderation` (
`catid` int(11) not null default '0',
`userid` int(11) not null default '0',
`future1` tinyint(4) default '0',
`future2` int(11) default '0',
primary key (`catid`,`userid`),
key `catid` (`catid`)
) engine=myisam default charset=utf8;
--
-- data dump tabellen `jos_sb_moderation`
--
-- --------------------------------------------------------
--
-- struktur dump tabellen `jos_sb_sessions`
--
create table `jos_sb_sessions` (
`userid` int(11) not null default '0',
`allowed` text,
`lasttime` int(11) not null default '0',
`readtopics` text,
primary key (`userid`)
) engine=myisam default charset=utf8;
--
-- data dump tabellen `jos_sb_sessions`
--
-- --------------------------------------------------------
--
-- struktur dump tabellen `jos_sb_smileys`
--
create table `jos_sb_smileys` (
`id` int(4) not null auto_increment,
`code` varchar(12) not null default '',
`location` varchar(50) not null default '',
`greylocation` varchar(60) not null default '',
`emoticonbar` tinyint(4) not null default '0',
primary key (`id`)
) engine=myisam default charset=utf8 auto_increment=38 ;
--
-- data dump tabellen `jos_sb_smileys`
--
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (1, 'b)', 'cool.png', 'cool-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (8, ';)', 'wink.png', 'wink-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (3, ':)', 'smile.png', 'smile-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (10, ':p', 'tongue.png', 'tongue-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (6, ':laugh:', 'laughing.png', 'laughing-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (17, ':ohmy:', 'shocked.png', 'shocked-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (22, ':sick:', 'sick.png', 'sick-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (14, ':angry:', 'angry.png', 'angry-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (25, ':blink:', 'blink.png', 'blink-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (2, ':(', 'sad.png', 'sad-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (16, ':unsure:', 'unsure.png', 'unsure-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (27, ':kiss:', 'kissing.png', 'kissing-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (29, ':woohoo:', 'w00t.png', 'w00t-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (21, ':lol:', 'grin.png', 'grin-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (23, ':silly:', 'silly.png', 'silly-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (35, ':pinch:', 'pinch.png', 'pinch-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (30, ':side:', 'sideways.png', 'sideways-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (34, ':whistle:', 'whistling.png', 'whistling-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (33, ':evil:', 'devil.png', 'devil-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (31, ':s', 'dizzy.png', 'dizzy-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (26, ':blush:', 'blush.png', 'blush-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (7, ':cheer:', 'cheerful.png', 'cheerful-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (18, ':huh:', 'wassat.png', 'wassat-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (19, ':dry:', 'ermm.png', 'ermm-grey.png', 1);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (4, ':-)', 'smile.png', 'smile-grey.png', 0);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (5, ':-(', 'sad.png', 'sad-grey.png', 0);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (9, ';-)', 'wink.png', 'wink-grey.png', 0);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (37, ':d', 'laughing.png', 'laughing-grey.png', 0);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (12, ':x', 'sick.png', 'sick-grey.png', 0);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (13, ':x', 'sick.png', 'sick-grey.png', 0);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (15, ':mad:', 'angry.png', 'angry-grey.png', 0);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (20, ':ermm:', 'ermm.png', 'ermm-grey.png', 0);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (24, ':y32b4:', 'silly.png', 'silly-grey.png', 0);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (28, ':rolleyes:', 'blink.png', 'blink-grey.png', 0);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (32, ':s', 'dizzy.png', 'dizzy-grey.png', 0);
insert `jos_sb_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) values (36, ':p', 'tongue.png', 'tongue-grey.png', 0);
-- --------------------------------------------------------
--
-- struktur dump tabellen `jos_sb_subscriptions`
--
create table `jos_sb_subscriptions` (
`thread` int(11) not null default '0',
`userid` int(11) not null default '0',
`future1` int(11) default '0',
key `thread` (`thread`),
key `userid` (`userid`)
) engine=myisam default charset=utf8;
--
-- data dump tabellen `jos_sb_subscriptions`
--
-- --------------------------------------------------------
--
-- struktur dump tabellen `jos_sb_users`
--
create table `jos_sb_users` (
`userid` int(11) not null default '0',
`view` varchar(8) not null default 'flat',
`signature` text,
`moderator` int(11) default '0',
`ordering` int(11) default '0',
`posts` int(11) default '0',
`avatar` varchar(50) default null,
`karma` int(11) default '0',
`karma_time` int(11) default '0',
primary key (`userid`)
) engine=myisam default charset=utf8;
--
-- data dump tabellen `jos_sb_users`
--
hentede jsas, og lavade en lokal install. så kunne jeg se hvad der skulle stå i databasen.
obs ?? erstattes med det tal der svarer til næste entry
henrik

Comments
Post a Comment