- 'imageset_id' => array('UINT', 0),

- 'imageset_id' => array('INDEX', 'imageset_id'),

- $schema_data['phpbb_styles_imageset'] = array(

- 'COLUMNS' => array(

- 'imageset_id' => array('UINT', NULL, 'auto_increment'),

- 'imageset_name' => array('VCHAR_UNI:255', ''),

- 'imageset_copyright' => array('VCHAR_UNI', ''),

- 'imageset_path' => array('VCHAR:100', ''),

- ),

- 'PRIMARY_KEY' => 'imageset_id',

- 'KEYS' => array(

- 'imgset_nm' => array('UNIQUE', 'imageset_name'),

- ),

- );

-

- $schema_data['phpbb_styles_imageset_data'] = array(

- 'COLUMNS' => array(

- 'image_id' => array('UINT', NULL, 'auto_increment'),

- 'image_name' => array('VCHAR:200', ''),

- 'image_filename' => array('VCHAR:200', ''),

- 'image_lang' => array('VCHAR:30', ''),

- 'image_height' => array('USINT', 0),

- 'image_width' => array('USINT', 0),

- 'imageset_id' => array('UINT', 0),

- ),

- 'PRIMARY_KEY' => 'image_id',

- 'KEYS' => array(

- 'i_d' => array('INDEX', 'imageset_id'),

- ),

- );

-

-

- $valid_localized = array(

- 'icon_back_top', 'icon_contact_aim', 'icon_contact_email', 'icon_contact_icq', 'icon_contact_jabber', 'icon_contact_msnm', 'icon_contact_pm', 'icon_contact_yahoo', 'icon_contact_www', 'icon_post_delete', 'icon_post_edit', 'icon_post_info', 'icon_post_quote', 'icon_post_report', 'icon_user_online', 'icon_user_offline', 'icon_user_profile', 'icon_user_search', 'icon_user_warn', 'button_pm_forward', 'button_pm_new', 'button_pm_reply', 'button_topic_locked', 'button_topic_new', 'button_topic_reply',

- );

-

- $sql_ary = array();

-

- $sql = 'SELECT *

- FROM ' . STYLES_IMAGESET_TABLE;

- $result = $db->sql_query($sql);

-

- while ($imageset_row = $db->sql_fetchrow($result))

- {

- if (@file_exists("{$phpbb_root_path}styles/{$imageset_row['imageset_path']}/imageset/{$lang_pack['lang_iso']}/imageset.cfg"))

- {

- $cfg_data_imageset_data = parse_cfg_file("{$phpbb_root_path}styles/{$imageset_row['imageset_path']}/imageset/{$lang_pack['lang_iso']}/imageset.cfg");

- foreach ($cfg_data_imageset_data as $image_name => $value)

- {

- if (strpos($value, '*') !== false)

- {

- if (substr($value, -1, 1) === '*')

- {

- list($image_filename, $image_height) = explode('*', $value);

- $image_width = 0;

- }

- else

- {

- list($image_filename, $image_height, $image_width) = explode('*', $value);

- }

- }

- else

- {

- $image_filename = $value;

- $image_height = $image_width = 0;

- }

-

- if (strpos($image_name, 'img_') === 0 && $image_filename)

- {

- $image_name = substr($image_name, 4);

- if (in_array($image_name, $valid_localized))

- {

- $sql_ary[] = array(

- 'image_name' => (string) $image_name,

- 'image_filename' => (string) $image_filename,

- 'image_height' => (int) $image_height,

- 'image_width' => (int) $image_width,

- 'imageset_id' => (int) $imageset_row['imageset_id'],

- 'image_lang' => (string) $lang_pack['lang_iso'],

- );

- }

- }

- }

- }

- }

- $db->sql_freeresult($result);

-

- if (sizeof($sql_ary))

- {

- $db->sql_multi_insert(STYLES_IMAGESET_DATA_TABLE, $sql_ary);

-

- if ($db->sql_error_triggered)

- {

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

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

- }

- }

- theme_id INTEGER DEFAULT 0 NOT NULL,

- imageset_id INTEGER DEFAULT 0 NOT NULL

-CREATE INDEX phpbb_styles_imageset_id ON phpbb_styles(imageset_id);;

-# Table: 'phpbb_styles_imageset'

-CREATE TABLE phpbb_styles_imageset (

- imageset_id INTEGER NOT NULL,

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

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

- imageset_path VARCHAR(100) CHARACTER SET NONE DEFAULT '' NOT NULL

-);;

-

-ALTER TABLE phpbb_styles_imageset ADD PRIMARY KEY (imageset_id);;

-

-CREATE UNIQUE INDEX phpbb_styles_imageset_imgset_nm ON phpbb_styles_imageset(imageset_name);;

-

-CREATE GENERATOR phpbb_styles_imageset_gen;;

-SET GENERATOR phpbb_styles_imageset_gen TO 0;;

-

-CREATE TRIGGER t_phpbb_styles_imageset FOR phpbb_styles_imageset

-BEFORE INSERT

-AS

-BEGIN

- NEW.imageset_id = GEN_ID(phpbb_styles_imageset_gen, 1);

-END;;

-

-

-# Table: 'phpbb_styles_imageset_data'

-CREATE TABLE phpbb_styles_imageset_data (

- image_id INTEGER NOT NULL,

- image_name VARCHAR(200) CHARACTER SET NONE DEFAULT '' NOT NULL,

- image_filename VARCHAR(200) CHARACTER SET NONE DEFAULT '' NOT NULL,

- image_lang VARCHAR(30) CHARACTER SET NONE DEFAULT '' NOT NULL,

- image_height INTEGER DEFAULT 0 NOT NULL,

- image_width INTEGER DEFAULT 0 NOT NULL,

- imageset_id INTEGER DEFAULT 0 NOT NULL

-);;

-

-ALTER TABLE phpbb_styles_imageset_data ADD PRIMARY KEY (image_id);;

-

-CREATE INDEX phpbb_styles_imageset_data_i_d ON phpbb_styles_imageset_data(imageset_id);;

-

-CREATE GENERATOR phpbb_styles_imageset_data_gen;;

-SET GENERATOR phpbb_styles_imageset_data_gen TO 0;;

-

-CREATE TRIGGER t_phpbb_styles_imageset_data FOR phpbb_styles_imageset_data

-BEFORE INSERT

-AS

-BEGIN

- NEW.image_id = GEN_ID(phpbb_styles_imageset_data_gen, 1);

-END;;

-

-

- [theme_id] [int] DEFAULT (0) NOT NULL ,

- [imageset_id] [int] DEFAULT (0) NOT NULL

-CREATE INDEX [imageset_id] ON [phpbb_styles]([imageset_id]) ON [PRIMARY]

-GO

-

- Table: 'phpbb_styles_imageset'

-*/

-CREATE TABLE [phpbb_styles_imageset] (

- [imageset_id] [int] IDENTITY (1, 1) NOT NULL ,

- [imageset_name] [varchar] (255) DEFAULT ('') NOT NULL ,

- [imageset_copyright] [varchar] (255) DEFAULT ('') NOT NULL ,

- [imageset_path] [varchar] (100) DEFAULT ('') NOT NULL

-) ON [PRIMARY]

-GO

-

-ALTER TABLE [phpbb_styles_imageset] WITH NOCHECK ADD

- CONSTRAINT [PK_phpbb_styles_imageset] PRIMARY KEY CLUSTERED

- (

- [imageset_id]

- ) ON [PRIMARY]

-GO

-

-CREATE UNIQUE INDEX [imgset_nm] ON [phpbb_styles_imageset]([imageset_name]) ON [PRIMARY]

-GO

-

-

-/*

- Table: 'phpbb_styles_imageset_data'

-*/

-CREATE TABLE [phpbb_styles_imageset_data] (

- [image_id] [int] IDENTITY (1, 1) NOT NULL ,

- [image_name] [varchar] (200) DEFAULT ('') NOT NULL ,

- [image_filename] [varchar] (200) DEFAULT ('') NOT NULL ,

- [image_lang] [varchar] (30) DEFAULT ('') NOT NULL ,

- [image_height] [int] DEFAULT (0) NOT NULL ,

- [image_width] [int] DEFAULT (0) NOT NULL ,

- [imageset_id] [int] DEFAULT (0) NOT NULL

-) ON [PRIMARY]

-GO

-

-ALTER TABLE [phpbb_styles_imageset_data] WITH NOCHECK ADD

- CONSTRAINT [PK_phpbb_styles_imageset_data] PRIMARY KEY CLUSTERED

- (

- [image_id]

- ) ON [PRIMARY]

-GO

-

-CREATE INDEX [i_d] ON [phpbb_styles_imageset_data]([imageset_id]) ON [PRIMARY]

-GO

-

-

-/*

- imageset_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

- KEY theme_id (theme_id),

- KEY imageset_id (imageset_id)

-# Table: 'phpbb_styles_imageset'

-CREATE TABLE phpbb_styles_imageset (

- imageset_id mediumint(8) UNSIGNED NOT NULL auto_increment,

- imageset_name blob NOT NULL,

- imageset_copyright blob NOT NULL,

- imageset_path varbinary(100) DEFAULT '' NOT NULL,

- PRIMARY KEY (imageset_id),

- UNIQUE imgset_nm (imageset_name(255))

-);

-

-

-# Table: 'phpbb_styles_imageset_data'

-CREATE TABLE phpbb_styles_imageset_data (

- image_id mediumint(8) UNSIGNED NOT NULL auto_increment,

- image_name varbinary(200) DEFAULT '' NOT NULL,

- image_filename varbinary(200) DEFAULT '' NOT NULL,

- image_lang varbinary(30) DEFAULT '' NOT NULL,

- image_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL,

- image_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL,

- imageset_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

- PRIMARY KEY (image_id),

- KEY i_d (imageset_id)

-);

-

-

- imageset_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

- KEY theme_id (theme_id),

- KEY imageset_id (imageset_id)

-# Table: 'phpbb_styles_imageset'

-CREATE TABLE phpbb_styles_imageset (

- imageset_id mediumint(8) UNSIGNED NOT NULL auto_increment,

- imageset_name varchar(255) DEFAULT '' NOT NULL,

- imageset_copyright varchar(255) DEFAULT '' NOT NULL,

- imageset_path varchar(100) DEFAULT '' NOT NULL,

- PRIMARY KEY (imageset_id),

- UNIQUE imgset_nm (imageset_name)

-) CHARACTER SET `utf8` COLLATE `utf8_bin`;

-

-

-# Table: 'phpbb_styles_imageset_data'

-CREATE TABLE phpbb_styles_imageset_data (

- image_id mediumint(8) UNSIGNED NOT NULL auto_increment,

- image_name varchar(200) DEFAULT '' NOT NULL,

- image_filename varchar(200) DEFAULT '' NOT NULL,

- image_lang varchar(30) DEFAULT '' NOT NULL,

- image_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL,

- image_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL,

- imageset_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

- PRIMARY KEY (image_id),

- KEY i_d (imageset_id)

-) CHARACTER SET `utf8` COLLATE `utf8_bin`;

-

-

- imageset_id number(8) DEFAULT '0' NOT NULL,

-CREATE INDEX phpbb_styles_imageset_id ON phpbb_styles (imageset_id)

-/

- Table: 'phpbb_styles_imageset'

-*/

-CREATE TABLE phpbb_styles_imageset (

- imageset_id number(8) NOT NULL,

- imageset_name varchar2(765) DEFAULT '' ,

- imageset_copyright varchar2(765) DEFAULT '' ,

- imageset_path varchar2(100) DEFAULT '' ,

- CONSTRAINT pk_phpbb_styles_imageset PRIMARY KEY (imageset_id),

- CONSTRAINT u_phpbb_imgset_nm UNIQUE (imageset_name)

-)

-/

-

-

-CREATE SEQUENCE phpbb_styles_imageset_seq

-/

-

-CREATE OR REPLACE TRIGGER t_phpbb_styles_imageset

-BEFORE INSERT ON phpbb_styles_imageset

-FOR EACH ROW WHEN (

- new.imageset_id IS NULL OR new.imageset_id = 0

-)

-BEGIN

- SELECT phpbb_styles_imageset_seq.nextval

- INTO :new.imageset_id

- FROM dual;

-END;

-/

-

-

-/*

- Table: 'phpbb_styles_imageset_data'

-*/

-CREATE TABLE phpbb_styles_imageset_data (

- image_id number(8) NOT NULL,

- image_name varchar2(200) DEFAULT '' ,

- image_filename varchar2(200) DEFAULT '' ,

- image_lang varchar2(30) DEFAULT '' ,

- image_height number(4) DEFAULT '0' NOT NULL,

- image_width number(4) DEFAULT '0' NOT NULL,

- imageset_id number(8) DEFAULT '0' NOT NULL,

- CONSTRAINT pk_phpbb_styles_imageset_data PRIMARY KEY (image_id)

-)

-/

-

-CREATE INDEX phpbb_styles_imageset_data_i_d ON phpbb_styles_imageset_data (imageset_id)

-/

-

-CREATE SEQUENCE phpbb_styles_imageset_data_seq

-/

-

-CREATE OR REPLACE TRIGGER t_phpbb_styles_imageset_data

-BEFORE INSERT ON phpbb_styles_imageset_data

-FOR EACH ROW WHEN (

- new.image_id IS NULL OR new.image_id = 0

-)

-BEGIN

- SELECT phpbb_styles_imageset_data_seq.nextval

- INTO :new.image_id

- FROM dual;

-END;

-/

-

-

-/*

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

-CREATE INDEX phpbb_styles_imageset_id ON phpbb_styles (imageset_id);

- Table: 'phpbb_styles_imageset'

-*/

-CREATE SEQUENCE phpbb_styles_imageset_seq;

-

-CREATE TABLE phpbb_styles_imageset (

- imageset_id INT4 DEFAULT nextval('phpbb_styles_imageset_seq'),

- imageset_name varchar(255) DEFAULT '' NOT NULL,

- imageset_copyright varchar(255) DEFAULT '' NOT NULL,

- imageset_path varchar(100) DEFAULT '' NOT NULL,

- PRIMARY KEY (imageset_id)

-);

-

-CREATE UNIQUE INDEX phpbb_styles_imageset_imgset_nm ON phpbb_styles_imageset (imageset_name);

-

-/*

- Table: 'phpbb_styles_imageset_data'

-*/

-CREATE SEQUENCE phpbb_styles_imageset_data_seq;

-

-CREATE TABLE phpbb_styles_imageset_data (

- image_id INT4 DEFAULT nextval('phpbb_styles_imageset_data_seq'),

- image_name varchar(200) DEFAULT '' NOT NULL,

- image_filename varchar(200) DEFAULT '' NOT NULL,

- image_lang varchar(30) DEFAULT '' NOT NULL,

- image_height INT2 DEFAULT '0' NOT NULL CHECK (image_height >= 0),

- image_width INT2 DEFAULT '0' NOT NULL CHECK (image_width >= 0),

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

- PRIMARY KEY (image_id)

-);

-

-CREATE INDEX phpbb_styles_imageset_data_i_d ON phpbb_styles_imageset_data (imageset_id);

-

-/*

-INSERT INTO phpbb_styles (style_name, style_copyright, style_active, template_id, theme_id, imageset_id) VALUES ('prosilver', '© phpBB Group', 1, 1, 1, 1);

-

-# -- phpbb_styles_imageset

-INSERT INTO phpbb_styles_imageset (imageset_name, imageset_copyright, imageset_path) VALUES ('prosilver', '© phpBB Group', 'prosilver');

-

-# -- phpbb_styles_imageset_data

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('site_logo', 'site_logo.gif', '', 52, 139, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('forum_link', 'forum_link.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('forum_read', 'forum_read.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('forum_read_locked', 'forum_read_locked.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('forum_read_subforum', 'forum_read_subforum.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('forum_unread', 'forum_unread.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('forum_unread_locked', 'forum_unread_locked.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('forum_unread_subforum', 'forum_unread_subforum.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('topic_moved', 'topic_moved.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('topic_read', 'topic_read.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('topic_read_mine', 'topic_read_mine.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('topic_read_hot', 'topic_read_hot.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('topic_read_hot_mine', 'topic_read_hot_mine.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('topic_read_locked', 'topic_read_locked.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('topic_read_locked_mine', 'topic_read_locked_mine.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('topic_unread', 'topic_unread.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('topic_unread_mine', 'topic_unread_mine.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('topic_unread_hot', 'topic_unread_hot.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('topic_unread_hot_mine', 'topic_unread_hot_mine.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('topic_unread_locked', 'topic_unread_locked.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('topic_unread_locked_mine', 'topic_unread_locked_mine.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('sticky_read', 'sticky_read.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('sticky_read_mine', 'sticky_read_mine.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('sticky_read_locked', 'sticky_read_locked.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('sticky_read_locked_mine', 'sticky_read_locked_mine.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('sticky_unread', 'sticky_unread.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('sticky_unread_mine', 'sticky_unread_mine.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('sticky_unread_locked', 'sticky_unread_locked.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('sticky_unread_locked_mine', 'sticky_unread_locked_mine.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('announce_read', 'announce_read.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('announce_read_mine', 'announce_read_mine.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('announce_read_locked', 'announce_read_locked.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('announce_read_locked_mine', 'announce_read_locked_mine.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('announce_unread', 'announce_unread.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('announce_unread_mine', 'announce_unread_mine.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('announce_unread_locked', 'announce_unread_locked.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('announce_unread_locked_mine', 'announce_unread_locked_mine.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('global_read', 'announce_read.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('global_read_mine', 'announce_read_mine.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('global_read_locked', 'announce_read_locked.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('global_read_locked_mine', 'announce_read_locked_mine.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('global_unread', 'announce_unread.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('global_unread_mine', 'announce_unread_mine.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('global_unread_locked', 'announce_unread_locked.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('global_unread_locked_mine', 'announce_unread_locked_mine.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('pm_read', 'topic_read.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('pm_unread', 'topic_unread.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('icon_back_top', 'icon_back_top.gif', '', 11, 11, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('icon_contact_aim', 'icon_contact_aim.gif', '', 20, 20, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('icon_contact_email', 'icon_contact_email.gif', '', 20, 20, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('icon_contact_icq', 'icon_contact_icq.gif', '', 20, 20, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('icon_contact_jabber', 'icon_contact_jabber.gif', '', 20, 20, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('icon_contact_msnm', 'icon_contact_msnm.gif', '', 20, 20, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('icon_contact_www', 'icon_contact_www.gif', '', 20, 20, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('icon_contact_yahoo', 'icon_contact_yahoo.gif', '', 20, 20, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('icon_post_delete', 'icon_post_delete.gif', '', 20, 20, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('icon_post_info', 'icon_post_info.gif', '', 20, 20, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('icon_post_report', 'icon_post_report.gif', '', 20, 20, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('icon_post_target', 'icon_post_target.gif', '', 9, 11, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('icon_post_target_unread', 'icon_post_target_unread.gif', '', 9, 11, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('icon_topic_attach', 'icon_topic_attach.gif', '', 10, 7, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('icon_topic_latest', 'icon_topic_latest.gif', '', 9, 11, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('icon_topic_newest', 'icon_topic_newest.gif', '', 9, 11, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('icon_topic_reported', 'icon_topic_reported.gif', '', 14, 16, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('icon_topic_unapproved', 'icon_topic_unapproved.gif', '', 14, 16, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('icon_user_warn', 'icon_user_warn.gif', '', 20, 20, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('subforum_read', 'subforum_read.gif', '', 9, 11, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('subforum_unread', 'subforum_unread.gif', '', 9, 11, 1);

- theme_id INTEGER UNSIGNED NOT NULL DEFAULT '0',

- imageset_id INTEGER UNSIGNED NOT NULL DEFAULT '0'

-CREATE INDEX phpbb_styles_imageset_id ON phpbb_styles (imageset_id);

-# Table: 'phpbb_styles_imageset'

-CREATE TABLE phpbb_styles_imageset (

- imageset_id INTEGER PRIMARY KEY NOT NULL ,

- imageset_name varchar(255) NOT NULL DEFAULT '',

- imageset_copyright varchar(255) NOT NULL DEFAULT '',

- imageset_path varchar(100) NOT NULL DEFAULT ''

-);

-

-CREATE UNIQUE INDEX phpbb_styles_imageset_imgset_nm ON phpbb_styles_imageset (imageset_name);

-

-# Table: 'phpbb_styles_imageset_data'

-CREATE TABLE phpbb_styles_imageset_data (

- image_id INTEGER PRIMARY KEY NOT NULL ,

- image_name varchar(200) NOT NULL DEFAULT '',

- image_filename varchar(200) NOT NULL DEFAULT '',

- image_lang varchar(30) NOT NULL DEFAULT '',

- image_height INTEGER UNSIGNED NOT NULL DEFAULT '0',

- image_width INTEGER UNSIGNED NOT NULL DEFAULT '0',

- imageset_id INTEGER UNSIGNED NOT NULL DEFAULT '0'

-);

-

-CREATE INDEX phpbb_styles_imageset_data_i_d ON phpbb_styles_imageset_data (imageset_id);

-

- 'SUPPORT_BODY' => 'Full support will be provided for the current stable release of phpBB3, free of charge. This includes:</p><ul><li>installation</li><li>configuration</li><li>technical questions</li><li>problems relating to potential bugs in the software</li><li>updating from Release Candidate (RC) versions to the latest stable version</li><li>converting from phpBB 2.0.x to phpBB3</li><li>converting from other discussion board software to phpBB3 (please see the <a href="http://www.phpbb.com/community/viewforum.php?f=65">Convertors Forum</a>)</li></ul><p>We encourage users still running beta versions of phpBB3 to replace their installation with a fresh copy of the latest version.</p><h2>MODs / Styles</h2><p>For issues relating to MODs, please post in the appropriate <a href="http://www.phpbb.com/community/viewforum.php?f=81">Modifications Forum</a>.<br />For issues relating to styles, templates and imagesets, please post in the appropriate <a href="http://www.phpbb.com/community/viewforum.php?f=80">Styles Forum</a>.<br /><br />If your question relates to a specific package, please post directly in the topic dedicated to the package.</p><h2>Obtaining Support</h2><p><a href="http://www.phpbb.com/community/viewtopic.php?f=14&amp;t=571070">The phpBB Welcome Package</a><br /><a href="http://www.phpbb.com/support/">Support Section</a><br /><a href="http://www.phpbb.com/support/documentation/3.0/quickstart/">Quick Start Guide</a><br /><br />To ensure you stay up to date with the latest news and releases, why not <a href="http://www.phpbb.com/support/">subscribe to our mailing list</a>?<br /><br />',