Banki
02-23-2009, 04:31 AM
ortal XL 4.0 v0.4B3 (open Beta) CHANGED/PRE-MODDED files RC4 is released!
This version can be used to create Portal XL 4.0 along a running plain/clean phpBB3 RC4.
Proper working on prior versions are not supported or guaranteed.
Read /portal/contrib/install/install_plusxl40-portal.txt for more detailed portal info and installation on a modded phpBB3. View install_plusxl40-portal.xml in your browser.
No support on custom changes anymore!
Mysql only supported.
Change prefix phpbb_ in code below if you use a different one.
Please run the queries below manually if the enclosed install option did fail:
Demo:http://damysterious.xs4all.nl/plusxl40/portal.php
## --- changes since PlusXL 4.0 Portal v0.4.B2 (change prefix to suite your needs) --- ##
ALTER TABLE phpbb_config CHANGE config_value config_value VARCHAR( 255 ) NOT NULL;
UPDATE phpbb_portal_config SET config_value = '0.4.B3' WHERE (phpbb_config.config_name) = 'portal_version' LIMIT 1;
INSERT INTO phpbb_portal_config (config_name, config_value, is_dynamic) VALUES ('portal_max_lastvisits', '5', 0);
INSERT INTO phpbb_portal_config (config_name, config_value, is_dynamic) VALUES ('portal_index_actual_recent_hot_topics', '0', 0);
INSERT INTO phpbb_portal_config (config_name, config_value, is_dynamic) VALUES ('portal_index_actual_recent_topics', '0', 0);
INSERT INTO phpbb_portal_config (config_name, config_value, is_dynamic) VALUES ('portal_index_announcements_important', '0', 0);
INSERT INTO phpbb_portal_config (config_name, config_value, is_dynamic) VALUES ('portal_index_downloads', '0', 0);
INSERT INTO phpbb_portal_config (config_name, config_value, is_dynamic) VALUES ('portal_actual_recent_hot_topics', '0', 0);
INSERT INTO phpbb_portal_config (config_name, config_value, is_dynamic) VALUES ('portal_actual_recent_topics', '0', 0);
INSERT INTO phpbb_portal_config (config_name, config_value, is_dynamic) VALUES ('portal_announcements_important', '0', 0);
INSERT INTO phpbb_portal_config (config_name, config_value, is_dynamic) VALUES ('portal_downloads', '1', 0);
INSERT INTO phpbb_portal_config (config_name, config_value, is_dynamic) VALUES ('portal_forumlist', '0', 0);
INSERT INTO phpbb_portal_config (config_name, config_value, is_dynamic) VALUES ('portal_index_forumlist', '0', 0);
INSERT INTO phpbb_portal_config (config_name, config_value, is_dynamic) VALUES ('portal_mainmenu_normal', '0', 0);
INSERT INTO phpbb_portal_config (config_name, config_value, is_dynamic) VALUES ('portal_mainmenu_dhtml', '1', 0);
INSERT INTO phpbb_portal_config (config_name, config_value, is_dynamic) VALUES ('portal_index_mainmenu_normal', '1', 0);
INSERT INTO phpbb_portal_config (config_name, config_value, is_dynamic) VALUES ('portal_index_mainmenu_dhtml', '0', 0);
INSERT INTO phpbb_portal_config (config_name, config_value, is_dynamic) VALUES ('portal_phpinfo', '0', 0);
INSERT INTO phpbb_portal_config (config_name, config_value, is_dynamic) VALUES ('portal_index_phpinfo', '0', 0);
DELETE FROM phpbb_portal_config WHERE (phpbb_portal_config.config_name) = 'portal_exclude_forums' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_exclude_forums' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_attachments_number' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_right_collumn_width' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_left_collumn_width' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_max_online_friends' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_max_most_poster' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_max_last_member' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_poll_topic' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_poll_topic_id' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_last_visited_bots_number' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_load_last_visited_bots' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_pay_acc' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_pay_s_block' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_pay_c_block' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_recent_title_limit' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_max_topics' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_news_forum' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_news_length' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_number_of_news' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_show_all_news' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_news' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_announcments' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_number_of_announcments' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_announcments_day' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_announcments_length' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_global_announcments_forum' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_word_graph_word_counts' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_word_graph_max_words' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_wordgraph' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_welcome' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_links' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_link_us' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_clock' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_random_member' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_latest_members' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_attachments' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_top_posters' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_leaders' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_advanced_stat' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_forum_block' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_google_c_block' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_google_s_block' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_ran_li_block' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_ran_ve_block' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_ran_ho_block' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_ran_h_block' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_word_graph_ratio' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_recent' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_ranks' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_version' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_welcome_intro' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_welcome_back' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_drag_drop' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_chatbox_deafault_delay' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_chatbox_session_time' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_chatbox_number' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_shoutbox' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_minicalendar' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_minicalendar_today_color' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_minicalendar_day_link_color' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_visit_counter' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_weather' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_weather_zipcode' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_weather_alternate_url1' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_weather_alternate_url' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_weather_ger' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_weather_alternate_url2' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_syndicate' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_links' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_clock' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_random_member' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_latest_members' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_top_posters' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_google_c_block' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_google_s_block' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_ran_ho_block' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_ran_ve_block' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_ran_li_block' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_weather' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_weather_ger' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_wordgraph' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_attachments' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_leaders' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_forum_block' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_recent' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_advanced_stat' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_minicalendar' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_shoutbox' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_ranks' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_link_us' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_load_last_visited_bots' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_syndicate' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_left_column' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_left_collumn_width' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_right_column' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_right_collumn_width' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_poll_forum_id' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_poll_post_id' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_layout' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_media_player' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_media_player' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_picture_gallery' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_picture_gallery' LIMIT 1;
DROP TABLE IF EXISTS phpbb_portal_blocks;
DROP TABLE IF EXISTS phpbb_portal_block;
CREATE TABLE phpbb_portal_block (
block_id mediumint(8) unsigned NOT NULL auto_increment,
block_edit mediumint(8) unsigned NOT NULL default '0',
block_name varchar(255) binary NOT NULL default '',
block_alias varchar(255) binary NOT NULL default '',
block_disable mediumint(8) unsigned NOT NULL default '0',
block_order tinyint(8) unsigned default NULL,
block_position char(2) binary NOT NULL default '',
block_last_position char(2) binary NOT NULL default '',
PRIMARY KEY (block_id),
KEY config_value (block_order)
);
INSERT INTO phpbb_portal_block (block_id, block_edit, block_name, block_alias, block_disable, block_order, block_position, block_last_position) VALUES (1, 0, '', 'Announce', 0, 1, '', '');
INSERT INTO phpbb_portal_block (block_id, block_edit, block_name, block_alias, block_disable, block_order, block_position, block_last_position) VALUES (2, 0, '', 'Tweety', 0, 2, '', '');
INSERT INTO phpbb_portal_block (block_id, block_edit, block_name, block_alias, block_disable, block_order, block_position, block_last_position) VALUES (7, 0, 'actual_recent_announcements.html', 'Left', 0, 7, '1', '');
INSERT INTO phpbb_portal_block (block_id, block_edit, block_name, block_alias, block_disable, block_order, block_position, block_last_position) VALUES (8, 0, 'last_posts.html', 'Suburban', 0, 1, '2', '');
INSERT INTO phpbb_portal_block (block_id, block_edit, block_name, block_alias, block_disable, block_order, block_position, block_last_position) VALUES (9, 0, 'forumblock.html', 'Right', 0, 18, '3', '');
INSERT INTO phpbb_portal_block (block_id, block_edit, block_name, block_alias, block_disable, block_order, block_position, block_last_position) VALUES (10, 0, 'downloads.html', 'Left test', 0, 9, '1', '');
INSERT INTO phpbb_portal_block (block_id, block_edit, block_name, block_alias, block_disable, block_order, block_position, block_last_position) VALUES (11, 0, 'google_adds.html', 'Right Test', 0, 20, '3', '');
INSERT INTO phpbb_portal_block (block_id, block_edit, block_name, block_alias, block_disable, block_order, block_position, block_last_position) VALUES (12, 0, 'google_adds_portal.html', 'Nocturno', 0, 1, '4', '');
INSERT INTO phpbb_portal_block (block_id, block_edit, block_name, block_alias, block_disable, block_order, block_position, block_last_position) VALUES (13, 0, 'google_adds_footer.html', 'Devils Brunch', 0, 2, '5', '');
DROP TABLE IF EXISTS phpbb_portal_menu;
CREATE TABLE phpbb_portal_menu (
menu_id mediumint(8) unsigned NOT NULL auto_increment,
menu_img varchar(150) binary NOT NULL default '',
menu_name varchar(150) binary NOT NULL default '',
menu_url varchar(150) binary NOT NULL default '',
menu_view varchar(20) binary NOT NULL default '',
menu_order mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (menu_id),
KEY menu_order (menu_order)
);
INSERT INTO phpbb_portal_menu (menu_id, menu_img, menu_name, menu_url, menu_view, menu_order) VALUES (1, 'icon_menu_022.gif', 'Portal', 'portal.php', '1', 3);
INSERT INTO phpbb_portal_menu (menu_id, menu_img, menu_name, menu_url, menu_view, menu_order) VALUES (2, 'icon_menu_016.png', 'Forum', 'index.php', '1', 5);
INSERT INTO phpbb_portal_menu (menu_id, menu_img, menu_name, menu_url, menu_view, menu_order) VALUES (3, 'icon_menu_027.gif', 'Memberlist', 'memberlist.php', '3', 6);
INSERT INTO phpbb_portal_menu (menu_id, menu_img, menu_name, menu_url, menu_view, menu_order) VALUES (4, 'icon_menu_008.gif', 'Staff', 'memberlist.php?mode=leaders', '4', 4);
INSERT INTO phpbb_portal_menu (menu_id, menu_img, menu_name, menu_url, menu_view, menu_order) VALUES (5, 'icon_menu_005.gif', 'Bookmarks', 'ucp.php?i=main&mode=bookmarks', '3', 2);
INSERT INTO phpbb_portal_menu (menu_id, menu_img, menu_name, menu_url, menu_view, menu_order) VALUES (6, 'icon_menu_001.gif', 'Profile', 'ucp.php', '3', 1);
INSERT INTO phpbb_portal_menu (menu_id, menu_img, menu_name, menu_url, menu_view, menu_order) VALUES (7, 'icon_menu_004.gif', 'Faq', 'faq.php', '1', 7);
INSERT INTO phpbb_portal_menu (menu_id, menu_img, menu_name, menu_url, menu_view, menu_order) VALUES (9, 'icon_menu_020.gif', 'EgoSearch', 'search.php?search_id=egosearch', '0', 8);
After using the installer all your Portal XL 4.0 values are set back to install's default (chat tables are not involved) to be sure you have the latest version changes as this version holds major code and database changes!
Install procedure phpBB3 Portal XL 4.0
Before using the installer follow the essential steps below exactly.
Unpack the latest archive of phpBB3 Portal XL 4.0 (0.4b3).
Copy/upload from directory root/includes/ of the distribution folder acp only to folder /includes/ on your server (this step is verry important as the installer needs to read portal's module information for further processing to generate module ID's automatically). Not follow up this part of the installation procedure will surprise you a lot of errors.
Copy/upload plusxl40_install.php to the root of your server, log in as admin first and run plusxl40_install.php in you browser. Click on Install at the bottom of this screen to proceed.
Now copy/upload all other content of the archive of phpBB3 Portal XL 4.0 (0.4b3) to your server root.
Go to you admincenter and do the steps below:
Attention!
After update to phpBB3 Portal XL 4.0 it is highly recommended to refresh your style or styles in use to make changes visible.
How to:
ACP -> Styles -> under Style components choose Themes, under Installed themes choose Prosilver -> Refresh and click Yes! Go back to ACPs General tab and run Purge the cache.
Last step is purging/refreshing (F5) you browsers cache. Ready!
Have fun with your Portal XL 4.0 ~ v0.4B3).
Download
http://www.cosmoload.com/618plusxl40_portal_04b3_changed_RC4.zip
This version can be used to create Portal XL 4.0 along a running plain/clean phpBB3 RC4.
Proper working on prior versions are not supported or guaranteed.
Read /portal/contrib/install/install_plusxl40-portal.txt for more detailed portal info and installation on a modded phpBB3. View install_plusxl40-portal.xml in your browser.
No support on custom changes anymore!
Mysql only supported.
Change prefix phpbb_ in code below if you use a different one.
Please run the queries below manually if the enclosed install option did fail:
Demo:http://damysterious.xs4all.nl/plusxl40/portal.php
## --- changes since PlusXL 4.0 Portal v0.4.B2 (change prefix to suite your needs) --- ##
ALTER TABLE phpbb_config CHANGE config_value config_value VARCHAR( 255 ) NOT NULL;
UPDATE phpbb_portal_config SET config_value = '0.4.B3' WHERE (phpbb_config.config_name) = 'portal_version' LIMIT 1;
INSERT INTO phpbb_portal_config (config_name, config_value, is_dynamic) VALUES ('portal_max_lastvisits', '5', 0);
INSERT INTO phpbb_portal_config (config_name, config_value, is_dynamic) VALUES ('portal_index_actual_recent_hot_topics', '0', 0);
INSERT INTO phpbb_portal_config (config_name, config_value, is_dynamic) VALUES ('portal_index_actual_recent_topics', '0', 0);
INSERT INTO phpbb_portal_config (config_name, config_value, is_dynamic) VALUES ('portal_index_announcements_important', '0', 0);
INSERT INTO phpbb_portal_config (config_name, config_value, is_dynamic) VALUES ('portal_index_downloads', '0', 0);
INSERT INTO phpbb_portal_config (config_name, config_value, is_dynamic) VALUES ('portal_actual_recent_hot_topics', '0', 0);
INSERT INTO phpbb_portal_config (config_name, config_value, is_dynamic) VALUES ('portal_actual_recent_topics', '0', 0);
INSERT INTO phpbb_portal_config (config_name, config_value, is_dynamic) VALUES ('portal_announcements_important', '0', 0);
INSERT INTO phpbb_portal_config (config_name, config_value, is_dynamic) VALUES ('portal_downloads', '1', 0);
INSERT INTO phpbb_portal_config (config_name, config_value, is_dynamic) VALUES ('portal_forumlist', '0', 0);
INSERT INTO phpbb_portal_config (config_name, config_value, is_dynamic) VALUES ('portal_index_forumlist', '0', 0);
INSERT INTO phpbb_portal_config (config_name, config_value, is_dynamic) VALUES ('portal_mainmenu_normal', '0', 0);
INSERT INTO phpbb_portal_config (config_name, config_value, is_dynamic) VALUES ('portal_mainmenu_dhtml', '1', 0);
INSERT INTO phpbb_portal_config (config_name, config_value, is_dynamic) VALUES ('portal_index_mainmenu_normal', '1', 0);
INSERT INTO phpbb_portal_config (config_name, config_value, is_dynamic) VALUES ('portal_index_mainmenu_dhtml', '0', 0);
INSERT INTO phpbb_portal_config (config_name, config_value, is_dynamic) VALUES ('portal_phpinfo', '0', 0);
INSERT INTO phpbb_portal_config (config_name, config_value, is_dynamic) VALUES ('portal_index_phpinfo', '0', 0);
DELETE FROM phpbb_portal_config WHERE (phpbb_portal_config.config_name) = 'portal_exclude_forums' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_exclude_forums' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_attachments_number' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_right_collumn_width' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_left_collumn_width' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_max_online_friends' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_max_most_poster' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_max_last_member' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_poll_topic' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_poll_topic_id' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_last_visited_bots_number' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_load_last_visited_bots' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_pay_acc' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_pay_s_block' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_pay_c_block' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_recent_title_limit' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_max_topics' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_news_forum' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_news_length' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_number_of_news' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_show_all_news' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_news' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_announcments' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_number_of_announcments' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_announcments_day' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_announcments_length' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_global_announcments_forum' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_word_graph_word_counts' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_word_graph_max_words' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_wordgraph' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_welcome' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_links' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_link_us' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_clock' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_random_member' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_latest_members' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_attachments' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_top_posters' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_leaders' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_advanced_stat' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_forum_block' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_google_c_block' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_google_s_block' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_ran_li_block' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_ran_ve_block' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_ran_ho_block' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_ran_h_block' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_word_graph_ratio' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_recent' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_ranks' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_version' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_welcome_intro' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_welcome_back' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_drag_drop' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_chatbox_deafault_delay' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_chatbox_session_time' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_chatbox_number' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_shoutbox' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_minicalendar' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_minicalendar_today_color' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_minicalendar_day_link_color' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_visit_counter' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_weather' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_weather_zipcode' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_weather_alternate_url1' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_weather_alternate_url' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_weather_ger' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_weather_alternate_url2' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_syndicate' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_links' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_clock' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_random_member' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_latest_members' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_top_posters' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_google_c_block' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_google_s_block' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_ran_ho_block' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_ran_ve_block' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_ran_li_block' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_weather' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_weather_ger' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_wordgraph' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_attachments' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_leaders' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_forum_block' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_recent' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_advanced_stat' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_minicalendar' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_shoutbox' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_ranks' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_link_us' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_load_last_visited_bots' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_syndicate' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_left_column' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_left_collumn_width' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_right_column' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_right_collumn_width' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_poll_forum_id' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_poll_post_id' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_layout' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_media_player' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_media_player' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_picture_gallery' LIMIT 1;
DELETE FROM phpbb_config WHERE (phpbb_config.config_name) = 'portal_index_picture_gallery' LIMIT 1;
DROP TABLE IF EXISTS phpbb_portal_blocks;
DROP TABLE IF EXISTS phpbb_portal_block;
CREATE TABLE phpbb_portal_block (
block_id mediumint(8) unsigned NOT NULL auto_increment,
block_edit mediumint(8) unsigned NOT NULL default '0',
block_name varchar(255) binary NOT NULL default '',
block_alias varchar(255) binary NOT NULL default '',
block_disable mediumint(8) unsigned NOT NULL default '0',
block_order tinyint(8) unsigned default NULL,
block_position char(2) binary NOT NULL default '',
block_last_position char(2) binary NOT NULL default '',
PRIMARY KEY (block_id),
KEY config_value (block_order)
);
INSERT INTO phpbb_portal_block (block_id, block_edit, block_name, block_alias, block_disable, block_order, block_position, block_last_position) VALUES (1, 0, '', 'Announce', 0, 1, '', '');
INSERT INTO phpbb_portal_block (block_id, block_edit, block_name, block_alias, block_disable, block_order, block_position, block_last_position) VALUES (2, 0, '', 'Tweety', 0, 2, '', '');
INSERT INTO phpbb_portal_block (block_id, block_edit, block_name, block_alias, block_disable, block_order, block_position, block_last_position) VALUES (7, 0, 'actual_recent_announcements.html', 'Left', 0, 7, '1', '');
INSERT INTO phpbb_portal_block (block_id, block_edit, block_name, block_alias, block_disable, block_order, block_position, block_last_position) VALUES (8, 0, 'last_posts.html', 'Suburban', 0, 1, '2', '');
INSERT INTO phpbb_portal_block (block_id, block_edit, block_name, block_alias, block_disable, block_order, block_position, block_last_position) VALUES (9, 0, 'forumblock.html', 'Right', 0, 18, '3', '');
INSERT INTO phpbb_portal_block (block_id, block_edit, block_name, block_alias, block_disable, block_order, block_position, block_last_position) VALUES (10, 0, 'downloads.html', 'Left test', 0, 9, '1', '');
INSERT INTO phpbb_portal_block (block_id, block_edit, block_name, block_alias, block_disable, block_order, block_position, block_last_position) VALUES (11, 0, 'google_adds.html', 'Right Test', 0, 20, '3', '');
INSERT INTO phpbb_portal_block (block_id, block_edit, block_name, block_alias, block_disable, block_order, block_position, block_last_position) VALUES (12, 0, 'google_adds_portal.html', 'Nocturno', 0, 1, '4', '');
INSERT INTO phpbb_portal_block (block_id, block_edit, block_name, block_alias, block_disable, block_order, block_position, block_last_position) VALUES (13, 0, 'google_adds_footer.html', 'Devils Brunch', 0, 2, '5', '');
DROP TABLE IF EXISTS phpbb_portal_menu;
CREATE TABLE phpbb_portal_menu (
menu_id mediumint(8) unsigned NOT NULL auto_increment,
menu_img varchar(150) binary NOT NULL default '',
menu_name varchar(150) binary NOT NULL default '',
menu_url varchar(150) binary NOT NULL default '',
menu_view varchar(20) binary NOT NULL default '',
menu_order mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (menu_id),
KEY menu_order (menu_order)
);
INSERT INTO phpbb_portal_menu (menu_id, menu_img, menu_name, menu_url, menu_view, menu_order) VALUES (1, 'icon_menu_022.gif', 'Portal', 'portal.php', '1', 3);
INSERT INTO phpbb_portal_menu (menu_id, menu_img, menu_name, menu_url, menu_view, menu_order) VALUES (2, 'icon_menu_016.png', 'Forum', 'index.php', '1', 5);
INSERT INTO phpbb_portal_menu (menu_id, menu_img, menu_name, menu_url, menu_view, menu_order) VALUES (3, 'icon_menu_027.gif', 'Memberlist', 'memberlist.php', '3', 6);
INSERT INTO phpbb_portal_menu (menu_id, menu_img, menu_name, menu_url, menu_view, menu_order) VALUES (4, 'icon_menu_008.gif', 'Staff', 'memberlist.php?mode=leaders', '4', 4);
INSERT INTO phpbb_portal_menu (menu_id, menu_img, menu_name, menu_url, menu_view, menu_order) VALUES (5, 'icon_menu_005.gif', 'Bookmarks', 'ucp.php?i=main&mode=bookmarks', '3', 2);
INSERT INTO phpbb_portal_menu (menu_id, menu_img, menu_name, menu_url, menu_view, menu_order) VALUES (6, 'icon_menu_001.gif', 'Profile', 'ucp.php', '3', 1);
INSERT INTO phpbb_portal_menu (menu_id, menu_img, menu_name, menu_url, menu_view, menu_order) VALUES (7, 'icon_menu_004.gif', 'Faq', 'faq.php', '1', 7);
INSERT INTO phpbb_portal_menu (menu_id, menu_img, menu_name, menu_url, menu_view, menu_order) VALUES (9, 'icon_menu_020.gif', 'EgoSearch', 'search.php?search_id=egosearch', '0', 8);
After using the installer all your Portal XL 4.0 values are set back to install's default (chat tables are not involved) to be sure you have the latest version changes as this version holds major code and database changes!
Install procedure phpBB3 Portal XL 4.0
Before using the installer follow the essential steps below exactly.
Unpack the latest archive of phpBB3 Portal XL 4.0 (0.4b3).
Copy/upload from directory root/includes/ of the distribution folder acp only to folder /includes/ on your server (this step is verry important as the installer needs to read portal's module information for further processing to generate module ID's automatically). Not follow up this part of the installation procedure will surprise you a lot of errors.
Copy/upload plusxl40_install.php to the root of your server, log in as admin first and run plusxl40_install.php in you browser. Click on Install at the bottom of this screen to proceed.
Now copy/upload all other content of the archive of phpBB3 Portal XL 4.0 (0.4b3) to your server root.
Go to you admincenter and do the steps below:
Attention!
After update to phpBB3 Portal XL 4.0 it is highly recommended to refresh your style or styles in use to make changes visible.
How to:
ACP -> Styles -> under Style components choose Themes, under Installed themes choose Prosilver -> Refresh and click Yes! Go back to ACPs General tab and run Purge the cache.
Last step is purging/refreshing (F5) you browsers cache. Ready!
Have fun with your Portal XL 4.0 ~ v0.4B3).
Download
http://www.cosmoload.com/618plusxl40_portal_04b3_changed_RC4.zip