phpBB.de

#
#-----[ SQL ]------------------------------------------
#
CREATE TABLE `phpbb_announcement_centre` (
`announcement_show` tinyint (1) NOT NULL,
`announcement_enable` tinyint (1) NOT NULL,
`announcement_enable_guests` tinyint (1) NOT NULL,
`announcement_show_birthdays` tinyint (1) NOT NULL,
`announcement_birthday_avatar` tinyint (1) NOT NULL,
`announcement_draft` text NOT NULL,
`announcement_text` text NOT NULL,
`announcement_text_guests` text NOT NULL,
`announcement_title` varchar(255) NOT NULL default '',
`announcement_title_guests` varchar(255) NOT NULL default '',
`announcement_show_group` varchar(255) NOT NULL default '')
CHARACTER SET utf8 COLLATE utf8_bin;


INSERT INTO phpbb_announcement_centre (announcement_show, announcement_enable, announcement_enable_guests, announcement_show_birthdays, announcement_birthday_avatar, announcement_title, announcement_text, announcement_draft, announcement_title_guests, announcement_text_guests, announcement_show_group) VALUES ('0', '1', '1', '0', '0', 'Site Announcements', 'Site Announcements can be seen here!! :mrgreen:', 'Draft Announcements can be seen here!! :mrgreen:', 'Guest Announcements', 'Guest Announcements can be seen here!! ', '2');
#
#-----[ COPY ]------------------------------------------
#
# the file announcement_smilies.html needs to be in the prosilver template folder, regardless if you have another style installed and as default
root/adm/style/acp_announcement_centre.html to adm/style/acp_announcement_centre.html
root/includes/functions_announcements.php to includes/functions_announcements.php
root/includes/acp/acp_announcements_centre.php to includes/acp/acp_announcements_centre.php
root/includes/acp/info/acp_announcements_centre.php to includes/acp/info/acp_announcements_centre.php
root/language/en/acp/announcement_centre.php to language/en/acp/announcement_centre.php
root/styles/prosilver/template/announcement_centre.html to styles/prosilver/template/announcement_centre.html
root/styles/prosilver/template/announcement_smilies.html to styles/prosilver/template/announcement_smilies.html
root/styles/prosilver/imageset/birthday.png to styles/prosilver/imageset/birthday.png
root/styles/subsilver2/template/announcement_centre.html to styles/subsilver2/template/announcement_centre.html
root/styles/subsilver2/imageset/birthday.png to styles/subsilver2/imageset/birthday.png

CREATE TABLE `phpbb_announcement_centre` (
`announcement_show` tinyint (1) NOT NULL,
`announcement_enable` tinyint (1) NOT NULL,
`announcement_enable_guests` tinyint (1) NOT NULL,
`announcement_show_birthdays` tinyint (1) NOT NULL,
`announcement_birthday_avatar` tinyint (1) NOT NULL,
`announcement_draft` text NOT NULL,
`announcement_text` text NOT NULL,
`announcement_text_guests` text NOT NULL,
`announcement_title` varchar(255) NOT NULL default '',
`announcement_title_guests` varchar(255) NOT NULL default '',
`announcement_show_group` varchar(255) NOT NULL default '')
CHARACTER SET utf8 COLLATE utf8_bin;


INSERT INTO phpbb_announcement_centre (announcement_show, announcement_enable, announcement_enable_guests, announcement_show_birthdays, announcement_birthday_avatar, announcement_title, announcement_text, announcement_draft, announcement_title_guests, announcement_text_guests, announcement_show_group) VALUES ('0', '1', '1', '0', '0', 'Site Announcements', 'Site Announcements can be seen here!! :mrgreen:', 'Draft Announcements can be seen here!! :mrgreen:', 'Guest Announcements', 'Guest Announcements can be seen here!! ', '2');