'group_legend' => array('UINT', 0),

),

),

),

);

}

);

_add_modules($modules_to_install);

// Localise Global Announcements

$sql = 'SELECT topic_id, topic_approved, (topic_replies + 1) AS topic_posts, topic_last_post_id, topic_last_post_subject, topic_last_post_time, topic_last_poster_id, topic_last_poster_name, topic_last_poster_colour

$template->assign_var('T_ASSETS_PATH', '../assets');

$template->assign_var('T_TEMPLATE_PATH', '../adm/style');

$install = new module();

$install->create('install', "index.$phpEx", $mode, $sub);

$error = $db->sql_error($db->sql_error_sql);

$this->p_master->db_error($error['message'], $db->sql_error_sql, __LINE__, __FILE__);

}

}

}

closedir($dir);

// Set custom template again. ;)

$template->set_custom_template('../adm/style', 'admin');

$template->assign_vars(array(

'S_USER_LANG' => $user->lang['USER_LANG'],

'S_CONTENT_DIRECTION' => $user->lang['DIRECTION'],

style_copyright VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,

style_active INTEGER DEFAULT 1 NOT NULL,

template_id INTEGER DEFAULT 0 NOT NULL,

);;

ALTER TABLE phpbb_styles ADD PRIMARY KEY (style_id);;

CREATE UNIQUE INDEX phpbb_styles_style_name ON phpbb_styles(style_name);;

CREATE INDEX phpbb_styles_template_id ON phpbb_styles(template_id);;

CREATE INDEX phpbb_styles_theme_id ON phpbb_styles(theme_id);;

CREATE GENERATOR phpbb_styles_gen;;

SET GENERATOR phpbb_styles_gen TO 0;;

template_copyright VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,

template_path VARCHAR(100) CHARACTER SET NONE DEFAULT '' NOT NULL,

bbcode_bitfield VARCHAR(255) CHARACTER SET NONE DEFAULT 'kNg=' NOT NULL,

template_inherits_id INTEGER DEFAULT 0 NOT NULL,

template_inherit_path VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL

);;

END;;

# Table: 'phpbb_styles_theme'

CREATE TABLE phpbb_styles_theme (

theme_id INTEGER NOT NULL,

theme_name VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,

theme_copyright VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,

);;

ALTER TABLE phpbb_styles_theme ADD PRIMARY KEY (theme_id);;

END;;

# Table: 'phpbb_topics'

CREATE TABLE phpbb_topics (

topic_id INTEGER NOT NULL,

[style_copyright] [varchar] (255) DEFAULT ('') NOT NULL ,

[style_active] [int] DEFAULT (1) NOT NULL ,

[template_id] [int] DEFAULT (0) NOT NULL ,

) ON [PRIMARY]

GO

CREATE INDEX [theme_id] ON [phpbb_styles]([theme_id]) ON [PRIMARY]

GO

/*

Table: 'phpbb_styles_template'

[template_copyright] [varchar] (255) DEFAULT ('') NOT NULL ,

[template_path] [varchar] (100) DEFAULT ('') NOT NULL ,

[bbcode_bitfield] [varchar] (255) DEFAULT ('kNg=') NOT NULL ,

[template_inherits_id] [int] DEFAULT (0) NOT NULL ,

[template_inherit_path] [varchar] (255) DEFAULT ('') NOT NULL

) ON [PRIMARY]

/*

Table: 'phpbb_styles_theme'

*/

CREATE TABLE [phpbb_styles_theme] (

[theme_id] [int] IDENTITY (1, 1) NOT NULL ,

[theme_name] [varchar] (255) DEFAULT ('') NOT NULL ,

[theme_copyright] [varchar] (255) DEFAULT ('') NOT NULL ,

GO

ALTER TABLE [phpbb_styles_theme] WITH NOCHECK ADD

/*

Table: 'phpbb_topics'

*/

CREATE TABLE [phpbb_topics] (

style_active tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

template_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

theme_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

PRIMARY KEY (style_id),

UNIQUE style_name (style_name(255)),

KEY template_id (template_id),

);

template_copyright blob NOT NULL,

template_path varbinary(100) DEFAULT '' NOT NULL,

bbcode_bitfield varbinary(255) DEFAULT 'kNg=' NOT NULL,

template_inherits_id int(4) UNSIGNED DEFAULT '0' NOT NULL,

template_inherit_path varbinary(255) DEFAULT '' NOT NULL,

PRIMARY KEY (template_id),

);

# Table: 'phpbb_styles_theme'

CREATE TABLE phpbb_styles_theme (

theme_id mediumint(8) UNSIGNED NOT NULL auto_increment,

theme_name blob NOT NULL,

theme_copyright blob NOT NULL,

theme_path varbinary(100) DEFAULT '' NOT NULL,

PRIMARY KEY (theme_id),

UNIQUE theme_name (theme_name(255))

);

# Table: 'phpbb_topics'

CREATE TABLE phpbb_topics (

topic_id mediumint(8) UNSIGNED NOT NULL auto_increment,

style_active tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

template_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

theme_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

PRIMARY KEY (style_id),

UNIQUE style_name (style_name),

KEY template_id (template_id),

) CHARACTER SET `utf8` COLLATE `utf8_bin`;

template_copyright varchar(255) DEFAULT '' NOT NULL,

template_path varchar(100) DEFAULT '' NOT NULL,

bbcode_bitfield varchar(255) DEFAULT 'kNg=' NOT NULL,

template_inherits_id int(4) UNSIGNED DEFAULT '0' NOT NULL,

template_inherit_path varchar(255) DEFAULT '' NOT NULL,

PRIMARY KEY (template_id),

) CHARACTER SET `utf8` COLLATE `utf8_bin`;

# Table: 'phpbb_styles_theme'

CREATE TABLE phpbb_styles_theme (

theme_id mediumint(8) UNSIGNED NOT NULL auto_increment,

theme_name varchar(255) DEFAULT '' NOT NULL,

theme_copyright varchar(255) DEFAULT '' NOT NULL,

theme_path varchar(100) DEFAULT '' NOT NULL,

PRIMARY KEY (theme_id),

UNIQUE theme_name (theme_name)

) CHARACTER SET `utf8` COLLATE `utf8_bin`;

# Table: 'phpbb_topics'

CREATE TABLE phpbb_topics (

topic_id mediumint(8) UNSIGNED NOT NULL auto_increment,

style_active number(1) DEFAULT '1' NOT NULL,

template_id number(8) DEFAULT '0' NOT NULL,

theme_id number(8) DEFAULT '0' NOT NULL,

CONSTRAINT pk_phpbb_styles PRIMARY KEY (style_id),

CONSTRAINT u_phpbb_style_name UNIQUE (style_name)

)

/

CREATE INDEX phpbb_styles_theme_id ON phpbb_styles (theme_id)

/

CREATE SEQUENCE phpbb_styles_seq

/

template_copyright varchar2(765) DEFAULT '' ,

template_path varchar2(100) DEFAULT '' ,

bbcode_bitfield varchar2(255) DEFAULT 'kNg=' NOT NULL,

template_inherits_id number(4) DEFAULT '0' NOT NULL,

template_inherit_path varchar2(255) DEFAULT '' ,

CONSTRAINT pk_phpbb_styles_template PRIMARY KEY (template_id),

/*

Table: 'phpbb_styles_theme'

*/

CREATE TABLE phpbb_styles_theme (

theme_name varchar2(765) DEFAULT '' ,

theme_copyright varchar2(765) DEFAULT '' ,

theme_path varchar2(100) DEFAULT '' ,

CONSTRAINT pk_phpbb_styles_theme PRIMARY KEY (theme_id),

CONSTRAINT u_phpbb_theme_name UNIQUE (theme_name)

)

/*

Table: 'phpbb_topics'

*/

CREATE TABLE phpbb_topics (

style_active INT2 DEFAULT '1' NOT NULL CHECK (style_active >= 0),

template_id INT4 DEFAULT '0' NOT NULL CHECK (template_id >= 0),

theme_id INT4 DEFAULT '0' NOT NULL CHECK (theme_id >= 0),

PRIMARY KEY (style_id)

);

CREATE UNIQUE INDEX phpbb_styles_style_name ON phpbb_styles (style_name);

CREATE INDEX phpbb_styles_template_id ON phpbb_styles (template_id);

CREATE INDEX phpbb_styles_theme_id ON phpbb_styles (theme_id);

/*

Table: 'phpbb_styles_template'

template_copyright varchar(255) DEFAULT '' NOT NULL,

template_path varchar(100) DEFAULT '' NOT NULL,

bbcode_bitfield varchar(255) DEFAULT 'kNg=' NOT NULL,

template_inherits_id INT4 DEFAULT '0' NOT NULL CHECK (template_inherits_id >= 0),

template_inherit_path varchar(255) DEFAULT '' NOT NULL,

PRIMARY KEY (template_id)

CREATE UNIQUE INDEX phpbb_styles_template_tmplte_nm ON phpbb_styles_template (template_name);

/*

Table: 'phpbb_styles_theme'

*/

CREATE SEQUENCE phpbb_styles_theme_seq;

theme_name varchar(255) DEFAULT '' NOT NULL,

theme_copyright varchar(255) DEFAULT '' NOT NULL,

theme_path varchar(100) DEFAULT '' NOT NULL,

PRIMARY KEY (theme_id)

);

CREATE UNIQUE INDEX phpbb_styles_theme_theme_name ON phpbb_styles_theme (theme_name);

/*

Table: 'phpbb_topics'

*/

CREATE SEQUENCE phpbb_topics_seq;

INSERT INTO phpbb_acl_roles (role_name, role_description, role_type, role_order) VALUES ('ROLE_FORUM_NEW_MEMBER', 'ROLE_DESCRIPTION_FORUM_NEW_MEMBER', 'f_', 10);

# -- phpbb_styles

# -- phpbb_styles_template

# -- phpbb_styles_theme

# -- Forums

INSERT INTO phpbb_forums (forum_name, forum_desc, left_id, right_id, parent_id, forum_type, forum_posts, forum_topics, forum_topics_real, forum_last_post_id, forum_last_poster_id, forum_last_poster_name, forum_last_poster_colour, forum_last_post_time, forum_link, forum_password, forum_image, forum_rules, forum_rules_link, forum_rules_uid, forum_desc_uid, prune_days, prune_viewed, forum_parents) VALUES ('{L_FORUMS_FIRST_CATEGORY}', '', 1, 4, 0, 0, 1, 1, 1, 1, 2, 'Admin', 'AA0000', 972086460, '', '', '', '', '', '', '', 0, 0, '');

style_copyright varchar(255) NOT NULL DEFAULT '',

style_active INTEGER UNSIGNED NOT NULL DEFAULT '1',

template_id INTEGER UNSIGNED NOT NULL DEFAULT '0',

);

CREATE UNIQUE INDEX phpbb_styles_style_name ON phpbb_styles (style_name);

CREATE INDEX phpbb_styles_template_id ON phpbb_styles (template_id);

CREATE INDEX phpbb_styles_theme_id ON phpbb_styles (theme_id);

# Table: 'phpbb_styles_template'

CREATE TABLE phpbb_styles_template (

template_copyright varchar(255) NOT NULL DEFAULT '',

template_path varchar(100) NOT NULL DEFAULT '',

bbcode_bitfield varchar(255) NOT NULL DEFAULT 'kNg=',

template_inherits_id INTEGER UNSIGNED NOT NULL DEFAULT '0',

template_inherit_path varchar(255) NOT NULL DEFAULT ''

);

CREATE UNIQUE INDEX phpbb_styles_template_tmplte_nm ON phpbb_styles_template (template_name);

# Table: 'phpbb_styles_theme'

CREATE TABLE phpbb_styles_theme (

theme_id INTEGER PRIMARY KEY NOT NULL ,

theme_name varchar(255) NOT NULL DEFAULT '',

theme_copyright varchar(255) NOT NULL DEFAULT '',

);

CREATE UNIQUE INDEX phpbb_styles_theme_theme_name ON phpbb_styles_theme (theme_name);

# Table: 'phpbb_topics'

CREATE TABLE phpbb_topics (

topic_id INTEGER PRIMARY KEY NOT NULL ,