#-----[ SQL ]------------------------------------------
#
execute sql.txt using phpMyAdmin
Att jag ska utföra det som står i sql text dokumentet men vad e de jag ska lägga in alla koder som står i sql dokumentet?
SQL Dokumentet:
DROP TABLE IF EXISTS phpbb_block_position;
CREATE TABLE phpbb_block_position (
bpid int(10) NOT NULL auto_increment,
pkey varchar(30) NOT NULL default '',
bposition char(1) NOT NULL default '',
layout int(10) NOT NULL default '1',
PRIMARY KEY (bpid)
) TYPE=MyISAM;
INSERT INTO phpbb_block_position VALUES (1, 'header', '@', 0);
INSERT INTO phpbb_block_position VALUES (2, 'footer', '*', 0);
INSERT INTO phpbb_block_position VALUES (3, 'right', 'r', 1);
INSERT INTO phpbb_block_position VALUES (4, 'center', 'c', 1);
INSERT INTO phpbb_block_position VALUES (5, 'center', 'c', 2);
INSERT INTO phpbb_block_position VALUES (6, 'center', 'c', 3);
DROP TABLE IF EXISTS phpbb_block_variable;
CREATE TABLE phpbb_block_variable (
bvid int(10) NOT NULL auto_increment,
label varchar(30) NOT NULL default '',
sub_label varchar(255) default NULL,
config_name varchar(30) NOT NULL default '',
field_options varchar(255) default NULL,
field_values varchar(255) default NULL,
type char(1) NOT NULL default '',
block varchar(255) default NULL,
PRIMARY KEY (config_name),
KEY bvid (bvid)
) TYPE=MyISAM;
INSERT INTO phpbb_block_variable VALUES (1, 'Number of news on portal', '', 'md_num_news', '', '', '1', 'forum');
INSERT INTO phpbb_block_variable VALUES (2, 'Length of news', 'Number of characters displayed', 'md_news_length', '', '', '1', 'forum');
INSERT INTO phpbb_block_variable VALUES (3, 'Poll Forum ID(s)', 'comma delimited', 'md_poll_forum_id', '', '', '1', 'poll');
INSERT INTO phpbb_block_variable VALUES (4, 'News Forum ID(s)', 'comma delimited', 'md_news_forum_id', '', '', '1', 'forum');
INSERT INTO phpbb_block_variable VALUES (5, 'Poll Bar Length', 'decrease/increase the value for 1 vote bar length', 'md_poll_bar_length', '', '', '1', 'poll');
INSERT INTO phpbb_block_variable VALUES (6, 'Number of recent topics', 'number of topics displayed', 'md_num_recent_topics', '', '', '1', 'recent_topics');
INSERT INTO phpbb_block_variable VALUES (7, 'Approve MOD installed?', 'tick if Approve MOD is installed', 'md_approve_mod_installed', '', '', '4', 'recent_topics');
INSERT INTO phpbb_block_variable VALUES (8, 'Recent Topics Style', 'choose static display or scrolling display', 'md_recent_topics_style', 'Scroll,Static', '1,0', '3', 'recent_topics');
INSERT INTO phpbb_block_variable VALUES (9, 'Search option text', 'Text displayed as the default option', 'md_search_option_text', '', '', '1', 'search');
DROP TABLE IF EXISTS phpbb_blocks;
CREATE TABLE phpbb_blocks (
bid int(10) NOT NULL auto_increment,
title varchar(60) NOT NULL default '',
content text NOT NULL,
bposition char(1) NOT NULL default '',
weight int(10) NOT NULL default '1',
active int(1) NOT NULL default '1',
blockfile varchar(255) NOT NULL default '',
view int(1) NOT NULL default '0',
layout int(10) NOT NULL default '1',
cache int(1) NOT NULL default '0',
cache_time int(10) NOT NULL default '0',
block_bbcode_uid varchar(10) default NULL,
type int(1) NOT NULL default '1',
PRIMARY KEY (bid)
) TYPE=MyISAM;
INSERT INTO phpbb_blocks VALUES (1, 'Board Navigation', '<table width="100%" cellpadding="0" cellspacing="1" border="0">\r\n<tr>\r\n<td class="row1" align="left"><span class="genmed" style="line-height: 150%">\r\n<a href="portal.php">Home</a><br />\r\n<a href="index.php">Forum</a><br />\r\n<a href="memberlist.php">Memberlist</a><br />\r\n<a href="faq.php">FAQ</a><br />\r\n<a href="search.php">Search</a><br />\r\n</span></td>\r\n</tr>\r\n</table>', '@', 1, 1, '', 0, 0, 0, 0, '', 0);
INSERT INTO phpbb_blocks VALUES (2, 'Statistics', '', 'r', 4, 1, 'blocks_imp_statistics', 0, 1, 1, 43200, '', 1);
INSERT INTO phpbb_blocks VALUES (3, 'Links', '<table width="100%" cellpadding="0" cellspacing="1" border="0">\r\n<tr>\r\n<td class="row1" align="center"><a href="http://phpbbintegramod.sourceforge.net" target="_blank" class="gen">IntegraMOD</a></td>\r\n</tr>\r\n</table>', 'r', 3, 1, '', 0, 1, 0, 0, '', 0);
INSERT INTO phpbb_blocks VALUES (4, 'Welcome to IM Portal', '<table cellspacing="0" cellpadding="0" border="0" width="100%">\r\n<tr>\r\n<td class="row1" align="center"><span class="gen">\r\nWelcome to IM (IntegraMOD) Portal<br /><br />For questions, comments and suggestions, please visit <a href="http://phpbbintegramod.sourceforge.net">IntegraMOD</a>\r\n</span>\r\n</td>\r\n</tr>\r\n</table>', 'c', 2, 1, '', 0, 1, 0, 0, '', 0);
INSERT INTO phpbb_blocks VALUES (5, 'News', '', 'c', 3, 1, 'blocks_imp_forum', 0, 1, 0, 0, '', 1);
INSERT INTO phpbb_blocks VALUES (6, 'User Block', '', '@', 2, 1, 'blocks_imp_user_block', 0, 0, 0, 0, '', 1);
INSERT INTO phpbb_blocks VALUES (7, 'Who is Online', '', '@', 3, 1, 'blocks_imp_online_users', 0, 0, 1, 300, '', 1);
INSERT INTO phpbb_blocks VALUES (8, 'Poll', '', 'r', 1, 1, 'blocks_imp_poll', 0, 1, 0, 0, NULL, 1);
INSERT INTO phpbb_blocks VALUES (9, 'Recent Topics', '', 'r', 2, 1, 'blocks_imp_recent_topics', 0, 1, 1, 300, '', 1);
INSERT INTO phpbb_blocks VALUES (10, 'Search', '', '@', 4, 1, 'blocks_imp_search', 0, 0, 1, 1000000000, '', 1);
INSERT INTO phpbb_blocks VALUES (11, 'sample block', '[b:6028ff3fda][color=red:6028ff3fda]This is just a sample block[/color:6028ff3fda][/b:6028ff3fda] showing the new capabilities of [b:6028ff3fda][color=green:6028ff3fda]IM Portal[/color:6028ff3fda][/b:6028ff3fda] with the use of BBCodes.[/size:6028ff3fda] \r\n\r\n
\r\n\r\n[quote:6028ff3fda]This version of IM Portal uses a multi-page feature to create more than one page for your portal. Try visiting this address: [b:6028ff3fda]http://www.myforum.com/portal.php?page=2[/b:6028ff3fda][/quote:6028ff3fda]', 'c', 1, 1, '', 0, 1, 0, 0, '6028ff3fda', 1);INSERT INTO phpbb_blocks VALUES (12, 'Sample 1', 'This page shows an example of the multi-page feature of IM Portal. This page also displays the forum-wide blocks.\r\n\r\n[code:1:e03b7533c8]Try to visit: http://www.myforum.com/portal.php?page=3[/code:1:e03b7533c8]', 'c', 1, 1, '', 0, 2, 0, 0, 'e03b7533c8', 1);
INSERT INTO phpbb_blocks VALUES (13, 'News', '', 'c', 2, 1, 'blocks_imp_forum', 0, 2, 0, 0, '', 0);
INSERT INTO phpbb_blocks VALUES (14, 'Sample 2', 'This block also shows the [b:69b8f55113][color=orange:69b8f55113]multi-page feature of IM Portal[/color:69b8f55113][/b:69b8f55113]. But this time, it does not display the forum-wide blocks.\r\n\r\nYou can now proceed to the [b:69b8f55113][color=blue:69b8f55113]ACP[/color:69b8f55113][/b:69b8f55113] and delete the sample layouts/pages in the layout management page.', 'c', 1, 1, '', 0, 3, 0, 0, '69b8f55113', 1);
INSERT INTO phpbb_blocks VALUES (15, 'News', '', 'c', 2, 1, 'blocks_imp_forum', 0, 3, 0, 0, '', 0);
DROP TABLE IF EXISTS phpbb_layout;
CREATE TABLE phpbb_layout (
lid int(10) unsigned NOT NULL auto_increment,
name varchar(100) NOT NULL default '',
template varchar(100) NOT NULL default '',
forum_wide int(1) NOT NULL default '1',
PRIMARY KEY (lid)
) TYPE=MyISAM;
INSERT INTO phpbb_layout VALUES (1, 'IM Portal Default', 'portal_body.tpl', 1);
INSERT INTO phpbb_layout VALUES (2, 'Sample 1', 'layout1.tpl', 1);
INSERT INTO phpbb_layout VALUES (3, 'Sample 2', 'layout1.tpl', 0);
DROP TABLE IF EXISTS phpbb_portal_config;
CREATE TABLE phpbb_portal_config (
id int(10) unsigned NOT NULL auto_increment,
config_name varchar(255) NOT NULL default '',
config_value varchar(255) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;
INSERT INTO phpbb_portal_config VALUES (1, 'default_portal', '1');
INSERT INTO phpbb_portal_config VALUES (2, 'portal_header', '1');
INSERT INTO phpbb_portal_config VALUES (3, 'portal_tail', '0');
INSERT INTO phpbb_portal_config VALUES (4, 'cache_enabled', '1');
INSERT INTO phpbb_portal_config VALUES (5, 'md_news_length', '250');
INSERT INTO phpbb_portal_config VALUES (6, 'md_news_forum_id', '1');
INSERT INTO phpbb_portal_config VALUES (7, 'md_num_news', '5');
INSERT INTO phpbb_portal_config VALUES (8, 'md_search_option_text', 'IM Portal');
INSERT INTO phpbb_portal_config VALUES (9, 'md_num_recent_topics', '10');
INSERT INTO phpbb_portal_config VALUES (10, 'md_approve_mod_installed', '0');
INSERT INTO phpbb_portal_config VALUES (11, 'md_recent_topics_style', '1');
INSERT INTO phpbb_portal_config VALUES (12, 'md_poll_bar_length', '65');
INSERT INTO phpbb_portal_config VALUES (13, 'md_poll_forum_id', '1');
