Portal XL Home

[Coralreef]

DM many will be removing their Premod versions and go plain !

Could you please make a post with "Which tables to delete and which to modify(delete single fields)" ?

Thanks !

[Concepts]

please view this post for that info: http://www.portalxl.nl/forum/ ... ml?#p13166

[Coralreef]

Year i know but is that list complete ?

I mean delete those tabels and remove the few things from _users ?

[DaMysterious]

I've tried to put together a complete list to be able to remove a Portal XL 4.0 RC8 set-up from your forum.

Bear in mind to have a recent backup of your forum and database before starting the procedure from below!

After the changes from both lists below where made, you have to upload a fresh package of phpBB 3.0.3 to get back to original state. Do not upload/replace file config.php (this will disconnect your forum from database) and folder \install\ of that package. Empty directory \cache\ by FTP to be sure all remnants are removed in there.

If your original phpBb 3.0.3 is up and running you can proceed to install Portal XL 5.0 Plain.

Please do not forget to remove the entry's below from config.php before installing Portal XL 5.0 Plain

Code: Select all

@define('PORTAL', true); // true/false = enable/disable whole portal so you have a plain phpBB3 if false
@define('PORTAL_INDEX_PAGE', true); // true/false = enable/disable whole index page so you have a plain phpBB3 if false


[Coralreef]

Nice !

I deleted all files and installed phpBB and Plain, so my files are nice and clean !

So only the database part is a mess up ! I have deleted the tables by hand but can part 2 be run even when a plain version is installed ?

Code: Select all

// filebase         
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'filebase_allowedsize';
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'filebase_dateformat';
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'filebase_statistics';
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'filebase_order';
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'filebase_target';
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'filebase_password';
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'filebase_update';
DELETE FROM phpbb_acl_options
        WHERE (phpbb_acl_options . auth_option ) = 'u_comment_filebase';
DELETE FROM phpbb_acl_options
        WHERE (phpbb_acl_options . auth_option ) = 'u_upload_filebase';
DELETE FROM phpbb_acl_options
        WHERE (phpbb_acl_options . auth_option ) = 'u_manage_filebase';
DELETE FROM phpbb_acl_options
        WHERE (phpbb_acl_options . auth_option ) = 'u_view_filebase';
DELETE FROM phpbb_acl_options
        WHERE (phpbb_acl_options . auth_option ) = 'u_approve_filebase';
DELETE FROM phpbb_acl_options
        WHERE (phpbb_acl_options . auth_option ) = 'u_password_filebase';
DELETE FROM phpbb_acl_options
        WHERE (phpbb_acl_options . auth_option ) = 'u_download_filebase';

// contact board admin / this can give errors on boards without already activated contact feature?      
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'contact_confirm_guests';
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'contact_max_attempts';
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'contact_method';
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'contact_bot_user';
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'contact_bot_forum';
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'contact_reasons';
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'contact_version';

// evaluate topics
DELETE FROM phpbb_acl_options
        WHERE (phpbb_acl_options . auth_option ) = 'f_evaluation_see';
DELETE FROM phpbb_acl_options
        WHERE (phpbb_acl_options . auth_option ) = 'f_evaluation';
DELETE FROM phpbb_acl_options
        WHERE (phpbb_acl_options . auth_option ) = 'f_evaluation_own';
DELETE FROM phpbb_acl_options
        WHERE (phpbb_acl_options . auth_option ) = 'f_evaluation_change';

// knowledge base
DELETE FROM phpbb_acl_options
        WHERE (phpbb_acl_options . auth_option ) = 'u_add_kb';
DELETE FROM phpbb_acl_options
        WHERE (phpbb_acl_options . auth_option ) = 'm_edit_kb';
DELETE FROM phpbb_acl_options
        WHERE (phpbb_acl_options . auth_option ) = 'm_del_kb';
DELETE FROM phpbb_acl_options
        WHERE (phpbb_acl_options . auth_option ) = 'm_activate_kb';

// event calendar
DELETE FROM phpbb_acl_options
        WHERE (phpbb_acl_options . auth_option ) = 'a_calendar';
DELETE FROM phpbb_acl_options
        WHERE (phpbb_acl_options . auth_option ) = 'm_calendar_edit_other_users_events';
DELETE FROM phpbb_acl_options
        WHERE (phpbb_acl_options . auth_option ) = 'm_calendar_delete_other_users_events';
DELETE FROM phpbb_acl_options
        WHERE (phpbb_acl_options . auth_option ) = 'u_calendar_view_events';
DELETE FROM phpbb_acl_options
        WHERE (phpbb_acl_options . auth_option ) = 'u_calendar_create_events';
DELETE FROM phpbb_acl_options
        WHERE (phpbb_acl_options . auth_option ) = 'u_calendar_edit_events';
DELETE FROM phpbb_acl_options
        WHERE (phpbb_acl_options . auth_option ) = 'u_calendar_delete_events';

// additinal button images
DELETE FROM phpbb_styles_imageset_data
        WHERE (phpbb_styles_imageset_data . image_name ) = 'button_quick_reply';
DELETE FROM phpbb_styles_imageset_data
        WHERE (phpbb_styles_imageset_data . image_name ) = 'button_upload_image';

// country flags 1.0.0
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'require_flag';
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'flags_path';
ALTER TABLE phpbb_users
        DROP user_flag;
ALTER TABLE phpbb_groups
        DROP group_flag;

// gender mod
ALTER TABLE phpbb_users
        DROP user_gender;

// forum evaluation mod
ALTER TABLE phpbb_forums
        DROP forum_evaluation;

// autogroup mod
ALTER TABLE phpbb_groups
        DROP group_min_posts;
ALTER TABLE phpbb_groups
        DROP group_max_posts;
ALTER TABLE phpbb_groups
        DROP group_min_warnings;
ALTER TABLE phpbb_groups
        DROP group_max_warnings;
ALTER TABLE phpbb_groups
        DROP group_min_days;
ALTER TABLE phpbb_groups
        DROP group_max_days;
ALTER TABLE phpbb_groups
        DROP group_auto_default;
ALTER TABLE phpbb_user_group
        DROP auto_group;

// member guest books
ALTER TABLE phpbb_users
        DROP user_guestbook_active;

ALTER TABLE phpbb_users
        DROP user_guestbook_limit;

// reputation mod      
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'rp_block_per_points';
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'rp_comment_max_chars';
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'rp_display';
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'rp_enable';

DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'rp_max_blocks';
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'rp_max_power';
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'rp_membership_days';
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'rp_min_posts';
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'rp_recent_points';
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'rp_reg_bonus';
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'rp_time_limitation';
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'rp_total_posts';
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'rp_user_spread';
DELETE FROM phpbb_acl_options
        WHERE (phpbb_acl_options . auth_option ) = 'u_rp_give';
DELETE FROM phpbb_acl_options
        WHERE (phpbb_acl_options . auth_option ) = 'u_rp_view';
DELETE FROM phpbb_acl_options
        WHERE (phpbb_acl_options . auth_option ) = 'u_rp_disable';
DELETE FROM phpbb_acl_options
        WHERE (phpbb_acl_options . auth_option ) = 'u_rp_ignore';

ALTER TABLE phpbb_users
        DROP user_reputation;
ALTER TABLE phpbb_users
        DROP user_hide_reputation;
ALTER TABLE phpbb_groups
        DROP group_reputation_power;

// bbcode
DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '50';
DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '51';
DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '52';
DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '53';
DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '54';
DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '55';
DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '56';
DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '57';
DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '58';
DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '59';
DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '60';
DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '61';
DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '62';
DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '63';
DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '64';
DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '65';
DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '66';
DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '67';
DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '68';
DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '69';
DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '70';
DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '71';
DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '72';
DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '73';
DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '74';
DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '75';
DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '76';
DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '77';
DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '78';
DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '79';

// modules
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_ADMIN';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_INFO';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_ANNOUNCE_INFO';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_NEWS_INFO';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_RECENT_INFO';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_WORDGRAPH_INFO';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_PAYPAL_INFO';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_ATTACHMENTS_NUMBER_INFO';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_MEMBERS_INFO';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_POLLS_INFO';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_BOTS_INFO';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_MOST_POSTER_INFO';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_WELCOME_INFO';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_SHOUTBOX_INFO';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_MINICALENDAR_INFO';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_WEATHER_INFO';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_SCROLL_MESSAGE_INFO';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_METATAGS_INFO';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_ADMIN_BLOCKS';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_MANAGE_BLOCKS';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_MANAGE_INDEX_BLOCKS';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_MANAGE_PAGES';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_ADMIN_MENUS';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_MANAGE_MENUS';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_ADMIN_QUOTES';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_MANAGE_QUOTES';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_ADMIN_LINKS';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_MANAGE_LINKS';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_ADMIN_BANNERS_HO';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_MANAGE_BANNERS';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_MANAGE_BANNERS_HO';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_MANAGE_BANNERS_VE';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_ADMIN_MODS';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_MANAGE_MODS';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_ADMIN_ADDS';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_MANAGE_ADDS';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_ADMIN_NEWSFEEDS';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_MANAGE_NEWSFEEDS';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_ADMIN_FILEBASE';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_FILEBASE_ADMIN_SETTINGS';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_FILEBASE_ADMIN_CATEGORYS';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_FILEBASE_ADMIN_FILES';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_FILEBASE_ADMIN_USERFIELDS';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_ADMIN_ACRONYMS';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_MANAGE_ACRONYMS';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_ADMIN_KB';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_ADMIN_KB_MAIN';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_ADMIN_KB_SUB';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_ADMIN_IMPRESSUM';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_MANAGE_IMPRESSUM';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_CALENDAR';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_CALENDAR_SETTINGS';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_CALENDAR_ETYPES';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_CAT_PHPBB_SEO';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_PHPBB_SEO_CLASS';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_FORUM_URL';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_HTACCESS';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_COUNTER_SETTINGS';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_WPM_SETTINGS';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_GYM_SITEMAPS';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_GYM_GOOGLE_MAIN';
DELETE FROM phpbb_modules
        WHERE (phpbb_modules . module_langname ) = 'ACP_GYM_RSS_MAIN';

// Log Connections 1.2
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'lc_disable';
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'lc_acp_disable';
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'lc_founder_disable';
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'lc_admin_disable';
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'lc_prune_entries';
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'lc_prune_day';
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'lc_interval';
ALTER TABLE phpbb_log DROP log_number;

// Anti Double Posts Version 2.0.0
DELETE FROM phpbb_acl_options
        WHERE (phpbb_acl_options . auth_option ) = 'u_adp_allow';
ALTER TABLE phpbb_forums DROP adp_enable;
ALTER TABLE phpbb_forums DROP adp_admins;
ALTER TABLE phpbb_forums DROP adp_modos;
ALTER TABLE phpbb_forums DROP adp_auto_edit;
ALTER TABLE phpbb_forums DROP adp_text_edit;
ALTER TABLE phpbb_forums DROP adp_always;
ALTER TABLE phpbb_forums DROP adp_days;
ALTER TABLE phpbb_forums DROP adp_hours;
ALTER TABLE phpbb_forums DROP adp_mins;
ALTER TABLE phpbb_forums DROP adp_secs;

// Anti Bot Question Version 1.1.0
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'enable_abquestion';
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'abquestion';
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'abanswer';
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'abanswer2';

// Thanks MOD
ALTER TABLE phpbb_users
        DROP user_thanked;
ALTER TABLE phpbb_users
        DROP user_thanked_others;

// Welcome PM MOD
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'wpm_enable';
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'wpm_send_id';
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'wpm_subject';
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'wpm_message';
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'wpm_preview';
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'wpm_variables';

// File Base
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'filebase_pagination';
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'filebase_remote';
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'filebase_link';

// GYM Sitemap
DELETE FROM phpbb_config
        WHERE (phpbb_config . config_name ) = 'gym_installed';

[DaMysterious]

I have deleted the tables by hand but can part 2 be run even when a plain version is installed ?

Not at all.

If you like to keep the bbcodes exclude from list

Code: Select all

    // bbcode
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '50';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '51';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '52';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '53';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '54';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '55';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '56';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '57';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '58';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '59';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '60';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '61';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '62';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '63';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '64';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '65';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '66';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '67';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '68';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '69';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '70';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '71';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '72';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '73';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '74';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '75';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '76';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '77';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '78';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '79';


If you have a working XL 5.0 Portal ACP tab already exclude

Code: Select all

    // modules
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_ADMIN';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_INFO';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_ANNOUNCE_INFO';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_NEWS_INFO';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_RECENT_INFO';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_WORDGRAPH_INFO';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_PAYPAL_INFO';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_ATTACHMENTS_NUMBER_INFO';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_MEMBERS_INFO';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_POLLS_INFO';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_BOTS_INFO';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_MOST_POSTER_INFO';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_WELCOME_INFO';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_SHOUTBOX_INFO';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_MINICALENDAR_INFO';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_WEATHER_INFO';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_SCROLL_MESSAGE_INFO';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_METATAGS_INFO';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_ADMIN_BLOCKS';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_MANAGE_BLOCKS';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_MANAGE_INDEX_BLOCKS';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_MANAGE_PAGES';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_ADMIN_MENUS';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_MANAGE_MENUS';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_ADMIN_QUOTES';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_MANAGE_QUOTES';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_ADMIN_LINKS';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_MANAGE_LINKS';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_ADMIN_BANNERS_HO';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_MANAGE_BANNERS';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_MANAGE_BANNERS_HO';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_MANAGE_BANNERS_VE';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_ADMIN_MODS';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_MANAGE_MODS';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_ADMIN_ADDS';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_MANAGE_ADDS';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_ADMIN_NEWSFEEDS';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_MANAGE_NEWSFEEDS';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_ADMIN_FILEBASE';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_FILEBASE_ADMIN_SETTINGS';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_FILEBASE_ADMIN_CATEGORYS';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_FILEBASE_ADMIN_FILES';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_FILEBASE_ADMIN_USERFIELDS';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_ADMIN_ACRONYMS';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_MANAGE_ACRONYMS';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_ADMIN_KB';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_ADMIN_KB_MAIN';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_ADMIN_KB_SUB';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_PORTAL_ADMIN_IMPRESSUM';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_MANAGE_IMPRESSUM';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_CALENDAR';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_CALENDAR_SETTINGS';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_CALENDAR_ETYPES';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_CAT_PHPBB_SEO';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_PHPBB_SEO_CLASS';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_FORUM_URL';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_HTACCESS';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_COUNTER_SETTINGS';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_WPM_SETTINGS';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_GYM_SITEMAPS';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_GYM_GOOGLE_MAIN';
    DELETE FROM phpbb_modules
            WHERE (phpbb_modules . module_langname ) = 'ACP_GYM_RSS_MAIN';



[Coralreef]

If you like to keep the bbcodes exclude from list

Code: Select all

    // bbcode
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '50';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '51';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '52';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '53';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '54';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '55';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '56';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '57';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '58';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '59';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '60';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '61';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '62';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '63';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '64';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '65';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '66';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '67';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '68';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '69';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '70';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '71';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '72';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '73';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '74';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '75';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '76';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '77';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '78';
    DELETE FROM phpbb_bbcodes   WHERE (phpbb_bbcodes. bbcode_id ) = '79';


[ * Censored * ] !

I ran that part - how to undo

[Coralreef]

Could someone please help on the BBcode table issue that i [ * Censored * ] up in ?

[DaMysterious]

bbcode SQL to run on your database

Code: Select all

--
-- Table structure for table 'phpbb_bbcodes'
--

DROP TABLE IF EXISTS phpbb_bbcodes;
CREATE TABLE phpbb_bbcodes (
  bbcode_id tinyint(3) NOT NULL default '0',
  bbcode_tag varchar(16) binary NOT NULL default '',
  bbcode_helpline varchar(255) binary NOT NULL default '',
  display_on_posting tinyint(1) unsigned NOT NULL default '0',
  bbcode_match text NOT NULL,
  bbcode_tpl mediumtext NOT NULL,
  first_pass_match mediumtext NOT NULL,
  first_pass_replace mediumtext NOT NULL,
  second_pass_match mediumtext NOT NULL,
  second_pass_replace mediumtext NOT NULL,
  PRIMARY KEY  (bbcode_id),
  KEY display_on_post (display_on_posting)
) TYPE=MyISAM;

--
-- Dumping data for table 'phpbb_bbcodes'
--

INSERT INTO phpbb_bbcodes (bbcode_id, bbcode_tag, bbcode_helpline, display_on_posting, bbcode_match, bbcode_tpl, first_pass_match, first_pass_replace, second_pass_match, second_pass_replace) VALUES(13, 'spoiler', 'Insert spoiler: [spoiler]your text here[/spoiler]', 1, '[spoiler]{TEXT}[/spoiler]', '<dl class="codebox"><dt>Spoiler: <a href="javascript&#058; void(0);" onClick="var spoiler = this.parentNode.parentNode.getElementsByTagName(''dd'')[0]; if ( spoiler.style.display == ''none'' ) { spoiler.style.display = ''block''; this.innerHTML = ''hide''; } else { spoiler.style.display = ''none''; this.innerHTML = ''show''; };">show</a></dt><dd style="display: none;">{TEXT}</dd></dl>', '!\\[spoiler\\](.*?)\\[/spoiler\\]!ies', '''[spoiler:$uid]''.str_replace(array("\\r\\n", ''\\"'', ''\\'''', ''('', '')''), array("\\n", ''"'', ''&#39;'', ''&#40;'', ''&#41;''), trim(''${1}'')).''[/spoiler:$uid]''', '!\\[spoiler:$uid\\](.*?)\\[/spoiler:$uid\\]!s', '<dl class="codebox"><dt>Spoiler: <a href="javascript&#058; void(0);" onClick="var spoiler = this.parentNode.parentNode.getElementsByTagName(''dd'')[0]; if ( spoiler.style.display == ''none'' ) { spoiler.style.display = ''block''; this.innerHTML = ''hide''; } else { spoiler.style.display = ''none''; this.innerHTML = ''show''; };">show</a></dt><dd style="display: none;">${1}</dd></dl>');
INSERT INTO phpbb_bbcodes (bbcode_id, bbcode_tag, bbcode_helpline, display_on_posting, bbcode_match, bbcode_tpl, first_pass_match, first_pass_replace, second_pass_match, second_pass_replace) VALUES(14, 'iframe', 'Insert iframe: [iframe]http://url.here[/iframe]', 1, '[iframe]{URL}[/iframe]', '<iframe src="{URL}" name="frame1" scrolling="auto" frameborder="no" align="center" width="600" height="500"></iframe><br />', '!\\[iframe\\]([a-z0-9]+://)?([^< "\\r\\n\\t\\]]*)\\[/iframe\\]!ie', '''[iframe:$uid]''.((''${1}'') ? ''${1}${2}'' : ''http://${2}'').''[/iframe:$uid]''', '!\\[iframe:$uid\\](.*?)\\[/iframe:$uid\\]!s', '<iframe src="${1}" name="frame1" scrolling="auto" frameborder="no" align="center" width="600" height="500"></iframe><br />');
INSERT INTO phpbb_bbcodes (bbcode_id, bbcode_tag, bbcode_helpline, display_on_posting, bbcode_match, bbcode_tpl, first_pass_match, first_pass_replace, second_pass_match, second_pass_replace) VALUES(15, 'youtube', 'Insert youtube: [youtube]videonumber[/youtube]', 1, '[youtube]{TEXT}[/youtube]', '<object width="425" height="350"><param name="movie" value="http://www.youtube.com/v/{TEXT}"></param><param name="wmode" value="transparent"></param><embed src="http://www.youtube.com/v/{TEXT}" type="application/x-shockwave-flash" wmode="transparent" width="425" height="350"></embed></object><br />\n<a href="http://youtube.com/watch?v={TEXT}" target="_blank">Link</a><br />', '!\\[youtube\\](.*?)\\[/youtube\\]!ies', '''[youtube:$uid]''.str_replace("\\r\\n","\\n", str_replace(''\\"'', ''"'', str_replace(''\\'''', ''&#39;'', trim(''${1}'')))).''[/youtube:$uid]''', '!\\[youtube:$uid\\](.*?)\\[/youtube:$uid\\]!s', '<object width="425" height="350"><param name="movie" value="http://www.youtube.com/v/${1}"></param><param name="wmode" value="transparent"></param><embed src="http://www.youtube.com/v/${1}" type="application/x-shockwave-flash" wmode="transparent" width="425" height="350"></embed></object><br />\n<a href="http://youtube.com/watch?v=${1}" target="_blank">Link</a><br />');
INSERT INTO phpbb_bbcodes (bbcode_id, bbcode_tag, bbcode_helpline, display_on_posting, bbcode_match, bbcode_tpl, first_pass_match, first_pass_replace, second_pass_match, second_pass_replace) VALUES(16, 'GVideo', 'Insert GVideo: [GVideo]videonumber[/GVideo]', 1, '[GVideo]{TEXT}[/GVideo]', '<object width="425" height="350">\n        <param name="movie" value="http://video.google.com/googleplayer.swf?docId={TEXT}"></param>\n<embed style="width:400px; height:326px;" id="VideoPlayback"\n        align="middle" type="application/x-shockwave-flash"\n        src="http://video.google.com/googleplayer.swf?docId={TEXT}"\n        allowScriptAccess="sameDomain" quality="best" bgcolor="#ffffff"\n        scale="noScale" salign="TL"  FlashVars="playerMode=embedded">\n</embed>\n</object><br />\n<a href="http://video.google.de/videoplay?docid={TEXT}" target="_blank">Link</a><br />', '!\\[gvideo\\](.*?)\\[/gvideo\\]!ies', '''[gvideo:$uid]''.str_replace("\\r\\n","\\n", str_replace(''\\"'', ''"'', str_replace(''\\'''', ''&#39;'', trim(''${1}'')))).''[/gvideo:$uid]''', '!\\[gvideo:$uid\\](.*?)\\[/gvideo:$uid\\]!s', '<object width="425" height="350">\n        <param name="movie" value="http://video.google.com/googleplayer.swf?docId=${1}"></param>\n<embed style="width:400px; height:326px;" id="VideoPlayback"\n        align="middle" type="application/x-shockwave-flash"\n        src="http://video.google.com/googleplayer.swf?docId=${1}"\n        allowScriptAccess="sameDomain" quality="best" bgcolor="#ffffff"\n        scale="noScale" salign="TL"  FlashVars="playerMode=embedded">\n</embed>\n</object><br />\n<a href="http://video.google.de/videoplay?docid=${1}" target="_blank">Link</a><br />');
INSERT INTO phpbb_bbcodes (bbcode_id, bbcode_tag, bbcode_helpline, display_on_posting, bbcode_match, bbcode_tpl, first_pass_match, first_pass_replace, second_pass_match, second_pass_replace) VALUES(17, 'myvideo', 'Insert myvideo: [myvideo]videonumber[/myvideo]', 1, '[myvideo]{TEXT}[/myvideo]', '<object width="425" height="350"><param name="movie" value="http://www.myvideo.de/movie/{TEXT}"></param><embed src="http://www.myvideo.de/movie/{TEXT}" width="470" height="406" type="application/x-shockwave-flash"></embed></object><br />\n<a href="http://www.myvideo.de/watch/{TEXT}" target="_blank">Link</a><br />', '!\\[myvideo\\](.*?)\\[/myvideo\\]!ies', '''[myvideo:$uid]''.str_replace("\\r\\n","\\n", str_replace(''\\"'', ''"'', str_replace(''\\'''', ''&#39;'', trim(''${1}'')))).''[/myvideo:$uid]''', '!\\[myvideo:$uid\\](.*?)\\[/myvideo:$uid\\]!s', '<object width="425" height="350"><param name="movie" value="http://www.myvideo.de/movie/${1}"></param><embed src="http://www.myvideo.de/movie/${1}" width="470" height="406" type="application/x-shockwave-flash"></embed></object><br />\n<a href="http://www.myvideo.de/watch/${1}" target="_blank">Link</a><br />');
INSERT INTO phpbb_bbcodes (bbcode_id, bbcode_tag, bbcode_helpline, display_on_posting, bbcode_match, bbcode_tpl, first_pass_match, first_pass_replace, second_pass_match, second_pass_replace) VALUES(18, 'clipfish', 'Insert clipfish: [clipfish]videonumber[/clipfish]', 1, '[clipfish]{TEXT}[/clipfish]', '<object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,0,0" width="464" height="380" id="player" align="middle">\n<param name="allowScriptAccess" value="sameDomain" />\n<param name="movie" value="http://www.clipfish.de/videoplayer.swf?as=0&videoid={TEXT}" />\n<param name="wmode" value="transparent">  \n<param name="quality" value="high" />\n<param name="bgcolor" value="#999999" />\n<embed src="http://www.clipfish.de/videoplayer.swf?as=0&videoid={TEXT}" quality="high" bgcolor="#999999" width="464" height="380" name="player" align="middle" allowScriptAccess="sameDomain" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer"></embed>\n</object>\n<br />\n<a href="http://www.clipfish.de/player.php?videoid={TEXT}" target="_blank">Link</a><br />', '!\\[clipfish\\](.*?)\\[/clipfish\\]!ies', '''[clipfish:$uid]''.str_replace("\\r\\n","\\n", str_replace(''\\"'', ''"'', str_replace(''\\'''', ''&#39;'', trim(''${1}'')))).''[/clipfish:$uid]''', '!\\[clipfish:$uid\\](.*?)\\[/clipfish:$uid\\]!s', '<object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,0,0" width="464" height="380" id="player" align="middle">\n<param name="allowScriptAccess" value="sameDomain" />\n<param name="movie" value="http://www.clipfish.de/videoplayer.swf?as=0&videoid=${1}" />\n<param name="wmode" value="transparent">  \n<param name="quality" value="high" />\n<param name="bgcolor" value="#999999" />\n<embed src="http://www.clipfish.de/videoplayer.swf?as=0&videoid=${1}" quality="high" bgcolor="#999999" width="464" height="380" name="player" align="middle" allowScriptAccess="sameDomain" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer"></embed>\n</object>\n<br />\n<a href="http://www.clipfish.de/player.php?videoid=${1}" target="_blank">Link</a><br />');
INSERT INTO phpbb_bbcodes (bbcode_id, bbcode_tag, bbcode_helpline, display_on_posting, bbcode_match, bbcode_tpl, first_pass_match, first_pass_replace, second_pass_match, second_pass_replace) VALUES(19, 'myspace', 'Insert myspace: [myspace]videonumber[/myspace]', 1, '[myspace]{TEXT}[/myspace]', '<embed src="http://lads.myspace.com/videos/vplayer.swf" flashvars="m={TEXT}&type=video" type="application/x-shockwave-flash" width="425" height="350"></embed><br />\n<a href="http://vids.myspace.com/index.cfm?fuseaction=vids.individual&videoid={TEXT}" target="_blank">Link</a><br />', '!\\[myspace\\](.*?)\\[/myspace\\]!ies', '''[myspace:$uid]''.str_replace("\\r\\n","\\n", str_replace(''\\"'', ''"'', str_replace(''\\'''', ''&#39;'', trim(''${1}'')))).''[/myspace:$uid]''', '!\\[myspace:$uid\\](.*?)\\[/myspace:$uid\\]!s', '<embed src="http://lads.myspace.com/videos/vplayer.swf" flashvars="m=${1}&type=video" type="application/x-shockwave-flash" width="425" height="350"></embed><br />\n<a href="http://vids.myspace.com/index.cfm?fuseaction=vids.individual&videoid=${1}" target="_blank">Link</a><br />');
INSERT INTO phpbb_bbcodes (bbcode_id, bbcode_tag, bbcode_helpline, display_on_posting, bbcode_match, bbcode_tpl, first_pass_match, first_pass_replace, second_pass_match, second_pass_replace) VALUES(20, 'gametrailers', 'Insert gametrailers: [gametrailers]trailernumber[/gametrailers]', 1, '[gametrailers]{TEXT}[/gametrailers]', '<object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000"  codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=8,0,0,0" id="gtembed" width="480" height="409">\n  <param name="allowScriptAccess" value="sameDomain" />\n  <param name="movie" value="http://www.gametrailers.com/remote_wrap.php?mid={TEXT}"/>\n  <param name="quality" value="high" />\n  <embed src="http://www.gametrailers.com/remote_wrap.php?mid={TEXT}" swLiveConnect="true" name="gtembed" align="middle" allowScriptAccess="sameDomain" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="480" height="409"></embed>\n</object>', '!\\[gametrailers\\](.*?)\\[/gametrailers\\]!ies', '''[gametrailers:$uid]''.str_replace("\\r\\n","\\n", str_replace(''\\"'', ''"'', str_replace(''\\'''', ''&#39;'', trim(''${1}'')))).''[/gametrailers:$uid]''', '!\\[gametrailers:$uid\\](.*?)\\[/gametrailers:$uid\\]!s', '<object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000"  codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=8,0,0,0" id="gtembed" width="480" height="409">\n  <param name="allowScriptAccess" value="sameDomain" />\n  <param name="movie" value="http://www.gametrailers.com/remote_wrap.php?mid=${1}"/>\n  <param name="quality" value="high" />\n  <embed src="http://www.gametrailers.com/remote_wrap.php?mid=${1}" swLiveConnect="true" name="gtembed" align="middle" allowScriptAccess="sameDomain" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="480" height="409"></embed>\n</object>');
INSERT INTO phpbb_bbcodes (bbcode_id, bbcode_tag, bbcode_helpline, display_on_posting, bbcode_match, bbcode_tpl, first_pass_match, first_pass_replace, second_pass_match, second_pass_replace) VALUES(21, 'center', 'Insert center: [center]your text[/center]', 1, '[center]{text}[/center]', '<center>{text}</center>', '!\\[center\\](.*?)\\[/center\\]!ies', '''[center:$uid]''.str_replace("\\r\\n","\\n", str_replace(''\\"'', ''"'', str_replace(''\\'''', ''&#39;'', trim(''${1}'')))).''[/center:$uid]''', '!\\[center:$uid\\](.*?)\\[/center:$uid\\]!s', '<center>${1}</center>');
INSERT INTO phpbb_bbcodes (bbcode_id, bbcode_tag, bbcode_helpline, display_on_posting, bbcode_match, bbcode_tpl, first_pass_match, first_pass_replace, second_pass_match, second_pass_replace) VALUES(22, 'strike', 'Insert strike: [strike]your text[/strike]', 1, '[strike]{text}[/strike]', '<strike>{text}</strike>', '!\\[strike\\](.*?)\\[/strike\\]!ies', '''[strike:$uid]''.str_replace("\\r\\n","\\n", str_replace(''\\"'', ''"'', str_replace(''\\'''', ''&#39;'', trim(''${1}'')))).''[/strike:$uid]''', '!\\[strike:$uid\\](.*?)\\[/strike:$uid\\]!s', '<strike>${1}</strike>');
INSERT INTO phpbb_bbcodes (bbcode_id, bbcode_tag, bbcode_helpline, display_on_posting, bbcode_match, bbcode_tpl, first_pass_match, first_pass_replace, second_pass_match, second_pass_replace) VALUES(23, 'bgcolor=', 'Insert bgcolor: [bgcolor=red]your text[/bgcolor]', 1, '[bgcolor={COLOR}]{TEXT}[/bgcolor]', '<span style="background-color:{COLOR};">{TEXT}</span>', '!\\[bgcolor\\=([a-z]+|#[0-9abcdef]+)\\](.*?)\\[/bgcolor\\]!ies', '''[bgcolor=${1}:$uid]''.str_replace("\\r\\n","\\n", str_replace(''\\"'', ''"'', str_replace(''\\'''', ''&#39;'', trim(''${2}'')))).''[/bgcolor:$uid]''', '!\\[bgcolor\\=(.*?):$uid\\](.*?)\\[/bgcolor:$uid\\]!s', '<span style="background-color:${1};">${2}</span>');
INSERT INTO phpbb_bbcodes (bbcode_id, bbcode_tag, bbcode_helpline, display_on_posting, bbcode_match, bbcode_tpl, first_pass_match, first_pass_replace, second_pass_match, second_pass_replace) VALUES(24, 'hiddenlink=', 'Insert hidden link: [hiddenlink=http//url.her]your text[/hiddenlink]', 1, '[hiddenlink={TEXT1}]{TEXT2}[/hiddenlink]', '<span onclick="window.open(''{TEXT1}'')">{TEXT2}</span>', '!\\[hiddenlink\\=(.*?)\\](.*?)\\[/hiddenlink\\]!ies', '''[hiddenlink=''.str_replace("\\r\\n","\\n", str_replace(''\\"'', ''"'', str_replace(''\\'''', ''&#39;'', trim(''${1}'')))).'':$uid]''.str_replace("\\r\\n","\\n", str_replace(''\\"'', ''"'', str_replace(''\\'''', ''&#39;'', trim(''${2}'')))).''[/hiddenlink:$uid]''', '!\\[hiddenlink\\=(.*?):$uid\\](.*?)\\[/hiddenlink:$uid\\]!s', '<span onclick="window.open(''${1}'')">${2}</span>');
INSERT INTO phpbb_bbcodes (bbcode_id, bbcode_tag, bbcode_helpline, display_on_posting, bbcode_match, bbcode_tpl, first_pass_match, first_pass_replace, second_pass_match, second_pass_replace) VALUES(25, 'offtopic', 'Insert offtopic: [offtopic]your text[/offtopic]', 1, '[offtopic]{TEXT}[/offtopic]', '<i><b><font color="#114499">Offtopic:</font></b> <font color="#2277DD">{TEXT}</font></i>', '!\\[offtopic\\](.*?)\\[/offtopic\\]!ies', '''[offtopic:$uid]''.str_replace("\\r\\n","\\n", str_replace(''\\"'', ''"'', str_replace(''\\'''', ''&#39;'', trim(''${1}'')))).''[/offtopic:$uid]''', '!\\[offtopic:$uid\\](.*?)\\[/offtopic:$uid\\]!s', '<i><b><font color="#114499">Offtopic:</font></b> <font color="#2277DD">${1}</font></i>');
INSERT INTO phpbb_bbcodes (bbcode_id, bbcode_tag, bbcode_helpline, display_on_posting, bbcode_match, bbcode_tpl, first_pass_match, first_pass_replace, second_pass_match, second_pass_replace) VALUES(26, 'marquee=', '[marquee=color here]your text[/marquee]', 1, '[marquee={COLOR}]{TEXT}[/marquee]', '<marquee style="color:{COLOR}" onmouseout="this.start()" onmouseover="this.stop()" loop="-1" scrollamount="4" width="100%">{TEXT}</marquee>', '!\\[marquee\\=([a-z]+|#[0-9abcdef]+)\\](.*?)\\[/marquee\\]!ies', '''[marquee=${1}:$uid]''.str_replace(array("\\r\\n", ''\\"'', ''\\'''', ''('', '')''), array("\\n", ''"'', ''&#39;'', ''&#40;'', ''&#41;''), trim(''${2}'')).''[/marquee:$uid]''', '!\\[marquee\\=([a-zA-Z]+|#[0-9abcdefABCDEF]+):$uid\\](.*?)\\[/marquee:$uid\\]!s', '<marquee style="color:${1}" onmouseout="this.start()" onmouseover="this.stop()" loop="-1" scrollamount="4" width="100%">${2}</marquee>');
INSERT INTO phpbb_bbcodes (bbcode_id, bbcode_tag, bbcode_helpline, display_on_posting, bbcode_match, bbcode_tpl, first_pass_match, first_pass_replace, second_pass_match, second_pass_replace) VALUES(27, 'gallery', 'Insert Gallery Picture: [gallery]picID[/gallery]', 1, '[gallery]{NUMBER}[/gallery]', '<a href="gallery/image_page.php?id={NUMBER}"><img src="gallery/thumbnail.php?pic_id={NUMBER}" /></a>', '!\\[gallery\\]([0-9]+)\\[/gallery\\]!i', '[gallery:$uid]${1}[/gallery:$uid]', '!\\[gallery:$uid\\]([0-9]+)\\[/gallery:$uid\\]!s', '<a href="gallery/image_page.php?id=${1}"><img src="gallery/thumbnail.php?pic_id=${1}" /></a>');
INSERT INTO phpbb_bbcodes (bbcode_id, bbcode_tag, bbcode_helpline, display_on_posting, bbcode_match, bbcode_tpl, first_pass_match, first_pass_replace, second_pass_match, second_pass_replace) VALUES(28, 'tab=', 'Insert intended text: [tab=number here]your text[/tab]', 1, '[tab={NUMBER}]{TEXT}[/tab]', '<span style="margin-left: {NUMBER}px;">{TEXT}</span>', '!\\[tab\\=([0-9]+)\\](.*?)\\[/tab\\]!ies', '''[tab=${1}:$uid]''.str_replace(array("\\r\\n", ''\\"'', ''\\'''', ''('', '')''), array("\\n", ''"'', ''&#39;'', ''&#40;'', ''&#41;''), trim(''${2}'')).''[/tab:$uid]''', '!\\[tab\\=([0-9]+):$uid\\](.*?)\\[/tab:$uid\\]!s', '<span style="margin-left: ${1}px;">${2}</span>');
INSERT INTO phpbb_bbcodes (bbcode_id, bbcode_tag, bbcode_helpline, display_on_posting, bbcode_match, bbcode_tpl, first_pass_match, first_pass_replace, second_pass_match, second_pass_replace) VALUES(29, 'album', 'Insert Album Picture: [album]picID[/album]', 1, '[album]{NUMBER}[/album]', '<a href="http://damysterious.xs4all.nl/plusxl40/gallery/image_page.php?image_id={NUMBER}"><img src="http://damysterious.xs4all.nl/plusxl40/gallery/thumbnail.php?image_id={NUMBER}" alt="image_id: {NUMBER}" /></a>', '!\\[album\\]([0-9]+)\\[/album\\]!i', '[album:$uid]${1}[/album:$uid]', '!\\[album:$uid\\]([0-9]+)\\[/album:$uid\\]!s', '<a href="http://damysterious.xs4all.nl/plusxl40/gallery/image_page.php?image_id=${1}"><img src="http://damysterious.xs4all.nl/plusxl40/gallery/thumbnail.php?image_id=${1}" alt="image_id: ${1}" /></a>');
INSERT INTO phpbb_bbcodes (bbcode_id, bbcode_tag, bbcode_helpline, display_on_posting, bbcode_match, bbcode_tpl, first_pass_match, first_pass_replace, second_pass_match, second_pass_replace) VALUES(30, 'align=', 'Insert align: [align=direction]your text[/align]', 1, '[align={TEXT1}]{TEXT2}[/align]', '<div style="text-align: {TEXT1};">{TEXT2}</div>', '!\\[align\\=(.*?)\\](.*?)\\[/align\\]!ies', '''[align=''.str_replace(array("\\r\\n", ''\\"'', ''\\'''', ''('', '')''), array("\\n", ''"'', ''&#39;'', ''&#40;'', ''&#41;''), trim(''${1}'')).'':$uid]''.str_replace(array("\\r\\n", ''\\"'', ''\\'''', ''('', '')''), array("\\n", ''"'', ''&#39;'', ''&#40;'', ''&#41;''), trim(''${2}'')).''[/align:$uid]''', '!\\[align\\=(.*?):$uid\\](.*?)\\[/align:$uid\\]!s', '<div style="text-align: ${1};">${2}</div>');
INSERT INTO phpbb_bbcodes (bbcode_id, bbcode_tag, bbcode_helpline, display_on_posting, bbcode_match, bbcode_tpl, first_pass_match, first_pass_replace, second_pass_match, second_pass_replace) VALUES(31, 'img_l', 'Align Image Left: [img_l]http://img_url[/img_l]', 1, '[img_l]{TEXT}[/img_l]', '<span style="float:left;padding-left:20px;padding-right:20px;padding-top:20px;padding-bottom:20px"><img src="{TEXT}" alt="" /></span>', '!\\[img_l\\](.*?)\\[/img_l\\]!ies', '''[img_l:$uid]''.str_replace(array("\\r\\n", ''\\"'', ''\\'''', ''('', '')''), array("\\n", ''"'', ''&#39;'', ''&#40;'', ''&#41;''), trim(''${1}'')).''[/img_l:$uid]''', '!\\[img_l:$uid\\](.*?)\\[/img_l:$uid\\]!s', '<span style="float:left;padding-left:20px;padding-right:20px;padding-top:20px;padding-bottom:20px"><img src="${1}" alt="" /></span>');
INSERT INTO phpbb_bbcodes (bbcode_id, bbcode_tag, bbcode_helpline, display_on_posting, bbcode_match, bbcode_tpl, first_pass_match, first_pass_replace, second_pass_match, second_pass_replace) VALUES(32, 'img_r', 'Align Image Right: [img_r]http://img_url[/img_r]', 1, '[img_r]{TEXT}[/img_r]', '<span style="float:right;padding-left:20px;padding-right:20px;padding-top:20px;padding-bottom:20px"><img src="{TEXT}" alt="" /></span>', '!\\[img_r\\](.*?)\\[/img_r\\]!ies', '''[img_r:$uid]''.str_replace(array("\\r\\n", ''\\"'', ''\\'''', ''('', '')''), array("\\n", ''"'', ''&#39;'', ''&#40;'', ''&#41;''), trim(''${1}'')).''[/img_r:$uid]''', '!\\[img_r:$uid\\](.*?)\\[/img_r:$uid\\]!s', '<span style="float:right;padding-left:20px;padding-right:20px;padding-top:20px;padding-bottom:20px"><img src="${1}" alt="" /></span>');
INSERT INTO phpbb_bbcodes (bbcode_id, bbcode_tag, bbcode_helpline, display_on_posting, bbcode_match, bbcode_tpl, first_pass_match, first_pass_replace, second_pass_match, second_pass_replace) VALUES(33, 'mail=', 'Insert mailto: [mail=e-mail addres]e-mail addres[/mail]', 1, '[mail={TEXT2}]{TEXT1}[/mail]', '<a href="mailto:{TEXT2}">{TEXT1}</a>', '!\\[mail\\=(.*?)\\](.*?)\\[/mail\\]!ies', '''[mail=''.str_replace(array("\\r\\n", ''\\"'', ''\\'''', ''('', '')''), array("\\n", ''"'', ''&#39;'', ''&#40;'', ''&#41;''), trim(''${1}'')).'':$uid]''.str_replace(array("\\r\\n", ''\\"'', ''\\'''', ''('', '')''), array("\\n", ''"'', ''&#39;'', ''&#40;'', ''&#41;''), trim(''${2}'')).''[/mail:$uid]''', '!\\[mail\\=(.*?):$uid\\](.*?)\\[/mail:$uid\\]!s', '<a href="mailto:${1}">${2}</a>');
INSERT INTO phpbb_bbcodes (bbcode_id, bbcode_tag, bbcode_helpline, display_on_posting, bbcode_match, bbcode_tpl, first_pass_match, first_pass_replace, second_pass_match, second_pass_replace) VALUES(36, 'hr', 'Insert horizontal ruler: [hr][/hr]', 0, '[hr][/hr]', '<hr />', '!\\[hr\\]\\[/hr\\]!i', '[hr:$uid][/hr:$uid]', '[hr:$uid][/hr:$uid]', '');
INSERT INTO phpbb_bbcodes (bbcode_id, bbcode_tag, bbcode_helpline, display_on_posting, bbcode_match, bbcode_tpl, first_pass_match, first_pass_replace, second_pass_match, second_pass_replace) VALUES(37, 'br', 'Insert line break: [br][/br]', 1, '[br][/br]', '<br style="clear:both;" />', '!\\[br\\]\\[/br\\]!i', '[br:$uid][/br:$uid]', '[br:$uid][/br:$uid]', '');
INSERT INTO phpbb_bbcodes (bbcode_id, bbcode_tag, bbcode_helpline, display_on_posting, bbcode_match, bbcode_tpl, first_pass_match, first_pass_replace, second_pass_match, second_pass_replace) VALUES(38, 'wmv', 'Insert WMV: [wmv]http://wmv_url[/wmv]', 1, '[wmv]{URL}[/wmv]', '<object type="video/x-ms-wmv" data="{URL}" width="480" height="360">\n  <param name="src" value="{URL}" />\n  <param name="autoStart" value="0" />\n  alt : <a href="{URL}">Link</a>\n</object>', '!\\[wmv\\](?:([a-z][a-z\\d+\\-.]*:/{2}(?:(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+|[0-9.]+|\\[[a-z0-9.]+:[a-z0-9.]+:[a-z0-9.:]+\\])(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?)|(www\\.(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?))\\[/wmv\\]!ie', '''[wmv:$uid]''.$this->bbcode_specialchars((''${1}'') ? ''${1}'' : ''http://${2}'').''[/wmv:$uid]''', '!\\[wmv:$uid\\](?i)((?:[a-z][a-z\\d+\\-.]*:/{2}(?:(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+|[0-9.]+|\\[[a-z0-9.]+:[a-z0-9.]+:[a-z0-9.:]+\\])(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?)|(?:www\\.(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?))(?-i)\\[/wmv:$uid\\]!s', '<object type="video/x-ms-wmv" data="${1}" width="480" height="360">\n  <param name="src" value="${1}" />\n  <param name="autoStart" value="0" />\n  alt : <a href="${1}">Link</a>\n</object>');
INSERT INTO phpbb_bbcodes (bbcode_id, bbcode_tag, bbcode_helpline, display_on_posting, bbcode_match, bbcode_tpl, first_pass_match, first_pass_replace, second_pass_match, second_pass_replace) VALUES(39, 'sup', 'Insert super script: [sup]your text[/sup]', 1, '[sup]{TEXT}[/sup]', '<sup>{TEXT}</sup>', '!\\[sup\\](.*?)\\[/sup\\]!ies', '''[sup:$uid]''.str_replace(array("\\r\\n", ''\\"'', ''\\'''', ''('', '')''), array("\\n", ''"'', ''&#39;'', ''&#40;'', ''&#41;''), trim(''${1}'')).''[/sup:$uid]''', '!\\[sup:$uid\\](.*?)\\[/sup:$uid\\]!s', '<sup>${1}</sup>');
INSERT INTO phpbb_bbcodes (bbcode_id, bbcode_tag, bbcode_helpline, display_on_posting, bbcode_match, bbcode_tpl, first_pass_match, first_pass_replace, second_pass_match, second_pass_replace) VALUES(40, 'flash_i', 'Insert Flash video: [flash_i]your url[/flash_i]', 1, '[flash_i]{URL}[/flash_i]', '<object data="{URL}" type="application/x-shockwave-flash" width="400" height="300">\n  <param name="movie" value="{URL}" />\n  <param name="quality" value="high" />\n  <param name="scale" value="exactfit" />\n  <param name="menu" value="true" />\n  <param name="autostart" value="false" />\n  <param name="bgcolor" value="#000000" />\n</object>', '!\\[flash_i\\](?:([a-z][a-z\\d+\\-.]*:/{2}(?:(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+|[0-9.]+|\\[[a-z0-9.]+:[a-z0-9.]+:[a-z0-9.:]+\\])(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?)|(www\\.(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?))\\[/flash_i\\]!ie', '''[flash_i:$uid]''.$this->bbcode_specialchars((''${1}'') ? ''${1}'' : ''http://${2}'').''[/flash_i:$uid]''', '!\\[flash_i:$uid\\](?i)((?:[a-z][a-z\\d+\\-.]*:/{2}(?:(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+|[0-9.]+|\\[[a-z0-9.]+:[a-z0-9.]+:[a-z0-9.:]+\\])(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?)|(?:www\\.(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?))(?-i)\\[/flash_i:$uid\\]!s', '<object data="${1}" type="application/x-shockwave-flash" width="400" height="300">\n  <param name="movie" value="${1}" />\n  <param name="quality" value="high" />\n  <param name="scale" value="exactfit" />\n  <param name="menu" value="true" />\n  <param name="autostart" value="false" />\n  <param name="bgcolor" value="#000000" />\n</object>');
INSERT INTO phpbb_bbcodes (bbcode_id, bbcode_tag, bbcode_helpline, display_on_posting, bbcode_match, bbcode_tpl, first_pass_match, first_pass_replace, second_pass_match, second_pass_replace) VALUES(41, 'stream', 'Insert stream: [stream]your url[/stream]', 1, '[stream]{URL}[/stream]', '<object type="application/x-shockwave-flash" data="http://www.euerforum.de/media/mp3/emff_lila_info.swf" width="200" height="55">\n<param name="movie" value="http://www.euerforum.de/media/mp3/emff_lila_info.swf" />\n<param name="FlashVars" value="src={URL}" />\n</object>', '!\\[stream\\](?:([a-z][a-z\\d+\\-.]*:/{2}(?:(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+|[0-9.]+|\\[[a-z0-9.]+:[a-z0-9.]+:[a-z0-9.:]+\\])(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?)|(www\\.(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?))\\[/stream\\]!ie', '''[stream:$uid]''.$this->bbcode_specialchars((''${1}'') ? ''${1}'' : ''http://${2}'').''[/stream:$uid]''', '!\\[stream:$uid\\](?i)((?:[a-z][a-z\\d+\\-.]*:/{2}(?:(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+|[0-9.]+|\\[[a-z0-9.]+:[a-z0-9.]+:[a-z0-9.:]+\\])(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?)|(?:www\\.(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?))(?-i)\\[/stream:$uid\\]!s', '<object type="application/x-shockwave-flash" data="http://www.euerforum.de/media/mp3/emff_lila_info.swf" width="200" height="55">\n<param name="movie" value="http://www.euerforum.de/media/mp3/emff_lila_info.swf" />\n<param name="FlashVars" value="src=${1}" />\n</object>');
INSERT INTO phpbb_bbcodes (bbcode_id, bbcode_tag, bbcode_helpline, display_on_posting, bbcode_match, bbcode_tpl, first_pass_match, first_pass_replace, second_pass_match, second_pass_replace) VALUES(42, 'flv', 'Insert FLV: [flv]your url[/flv]', 1, '[flv]{URL}[/flv]', '<object type="application/x-shockwave-flash" style="width:425px; height:350px;" data="http://www.euerforum.de/media/flv/mediaplayer.swf">\n<param name="movie" value="http://www.euerforum.de/media/flv/mediaplayer.swf" />\n<param name="FlashVars" value="file={URL}" />\n</object>', '!\\[flv\\](?:([a-z][a-z\\d+\\-.]*:/{2}(?:(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+|[0-9.]+|\\[[a-z0-9.]+:[a-z0-9.]+:[a-z0-9.:]+\\])(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?)|(www\\.(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?))\\[/flv\\]!ie', '''[flv:$uid]''.$this->bbcode_specialchars((''${1}'') ? ''${1}'' : ''http://${2}'').''[/flv:$uid]''', '!\\[flv:$uid\\](?i)((?:[a-z][a-z\\d+\\-.]*:/{2}(?:(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+|[0-9.]+|\\[[a-z0-9.]+:[a-z0-9.]+:[a-z0-9.:]+\\])(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?)|(?:www\\.(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?))(?-i)\\[/flv:$uid\\]!s', '<object type="application/x-shockwave-flash" style="width:425px; height:350px;" data="http://www.euerforum.de/media/flv/mediaplayer.swf">\n<param name="movie" value="http://www.euerforum.de/media/flv/mediaplayer.swf" />\n<param name="FlashVars" value="file=${1}" />\n</object>');
INSERT INTO phpbb_bbcodes (bbcode_id, bbcode_tag, bbcode_helpline, display_on_posting, bbcode_match, bbcode_tpl, first_pass_match, first_pass_replace, second_pass_match, second_pass_replace) VALUES(43, 'rm', 'Insert Real Media: [rm]your url[/rm]', 0, '[rm]{URL}[/rm]', '<object classid="clsid:CFCDAA03-8BE4-11cf-B84B-0020AFBBCCFA" width="380" height="280">\n  <param name="src" value="{URL}" />\n  <param name="controls" value="all" />\n  <object type="video/x-pn-realaudio-plugin"\n          data="{URL}" width="380" height="280"\n          class="hiddenObjectForIE">\n    <param name="controls" value="all" />\n    alt : <a href="{URL}">Real Media</a>\n  </object>\n</object>', '!\\[rm\\](?:([a-z][a-z\\d+\\-.]*:/{2}(?:(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+|[0-9.]+|\\[[a-z0-9.]+:[a-z0-9.]+:[a-z0-9.:]+\\])(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?)|(www\\.(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?))\\[/rm\\]!ie', '''[rm:$uid]''.$this->bbcode_specialchars((''${1}'') ? ''${1}'' : ''http://${2}'').''[/rm:$uid]''', '!\\[rm:$uid\\](?i)((?:[a-z][a-z\\d+\\-.]*:/{2}(?:(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+|[0-9.]+|\\[[a-z0-9.]+:[a-z0-9.]+:[a-z0-9.:]+\\])(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?)|(?:www\\.(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?))(?-i)\\[/rm:$uid\\]!s', '<object classid="clsid:CFCDAA03-8BE4-11cf-B84B-0020AFBBCCFA" width="380" height="280">\n  <param name="src" value="${1}" />\n  <param name="controls" value="all" />\n  <object type="video/x-pn-realaudio-plugin"\n          data="${1}" width="380" height="280"\n          class="hiddenObjectForIE">\n    <param name="controls" value="all" />\n    alt : <a href="${1}">Real Media</a>\n  </object>\n</object>');
INSERT INTO phpbb_bbcodes (bbcode_id, bbcode_tag, bbcode_helpline, display_on_posting, bbcode_match, bbcode_tpl, first_pass_match, first_pass_replace, second_pass_match, second_pass_replace) VALUES(44, 'mov', 'Insert MOV: [mov]your url[/mov]', 1, '[mov]{URL}[/mov]', '<object classid="clsid:02BF25D5-8C17-4B23-BC80-D3488ABDDC6B"\n        codebase="http://www.apple.com/qtactivex/qtplugin.cab"\n        width="480" height="360">\n  <param name="src" value="{URL}" />\n  <param name="controller" value="true" />\n  <param name="autoplay" value="false" />\n\n  <!--[if gte IE 7]> <!-->\n  <object type="video/quicktime" data="{URL}" width="480" height="360">\n    <param name="controller" value="true" />\n    <param name="autoplay" value="false" />\n   alt : <a href="{URL}">Link</a>\n  </object>\n  <!--<![endif]-->\n  <!--[if lt IE 7]>\n    alt : <a href="data/test.mov">test.mov</a>\n  <![endif]-->\n</object>', '!\\[mov\\](?:([a-z][a-z\\d+\\-.]*:/{2}(?:(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+|[0-9.]+|\\[[a-z0-9.]+:[a-z0-9.]+:[a-z0-9.:]+\\])(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?)|(www\\.(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?))\\[/mov\\]!ie', '''[mov:$uid]''.$this->bbcode_specialchars((''${1}'') ? ''${1}'' : ''http://${2}'').''[/mov:$uid]''', '!\\[mov:$uid\\](?i)((?:[a-z][a-z\\d+\\-.]*:/{2}(?:(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+|[0-9.]+|\\[[a-z0-9.]+:[a-z0-9.]+:[a-z0-9.:]+\\])(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?)|(?:www\\.(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?))(?-i)\\[/mov:$uid\\]!s', '<object classid="clsid:02BF25D5-8C17-4B23-BC80-D3488ABDDC6B"\n        codebase="http://www.apple.com/qtactivex/qtplugin.cab"\n        width="480" height="360">\n  <param name="src" value="${1}" />\n  <param name="controller" value="true" />\n  <param name="autoplay" value="false" />\n\n  <!--[if gte IE 7]> <!-->\n  <object type="video/quicktime" data="${1}" width="480" height="360">\n    <param name="controller" value="true" />\n    <param name="autoplay" value="false" />\n   alt : <a href="${1}">Link</a>\n  </object>\n  <!--<![endif]-->\n  <!--[if lt IE 7]>\n    alt : <a href="data/test.mov">test.mov</a>\n  <![endif]-->\n</object>');
INSERT INTO phpbb_bbcodes (bbcode_id, bbcode_tag, bbcode_helpline, display_on_posting, bbcode_match, bbcode_tpl, first_pass_match, first_pass_replace, second_pass_match, second_pass_replace) VALUES(45, 'col=', 'Column: [col=collumn1]collumn2[/col]', 1, '[col={TEXT1}]{TEXT2}[/col]', '<table><tr><td><div style="width:48%; float:left;">{TEXT1}</div><div style="width:48%; float:left; margin-left:4%;">{TEXT2}</div> </td></tr></table>', '!\\[col\\=(.*?)\\](.*?)\\[/col\\]!ies', '''[col=''.str_replace(array("\\r\\n", ''\\"'', ''\\'''', ''('', '')''), array("\\n", ''"'', ''&#39;'', ''&#40;'', ''&#41;''), trim(''${1}'')).'':$uid]''.str_replace(array("\\r\\n", ''\\"'', ''\\'''', ''('', '')''), array("\\n", ''"'', ''&#39;'', ''&#40;'', ''&#41;''), trim(''${2}'')).''[/col:$uid]''', '!\\[col\\=(.*?):$uid\\](.*?)\\[/col:$uid\\]!s', '<table><tr><td><div style="width:48%; float:left;">${1}</div><div style="width:48%; float:left; margin-left:4%;">${2}</div> </td></tr></table>');
INSERT INTO phpbb_bbcodes (bbcode_id, bbcode_tag, bbcode_helpline, display_on_posting, bbcode_match, bbcode_tpl, first_pass_match, first_pass_replace, second_pass_match, second_pass_replace) VALUES(46, 'light1=', 'Light1: [light1=URL to Thumbnail]URL to big Picture[/light1]', 1, '[light1={URL1}]{URL2}[/light1]', '<a href="{URL1}" rel="lightbox"><img style="border: 1px solid black;" src="{URL2}"></a>', '!\\[light1\\=(?:([a-z][a-z\\d+\\-.]*:/{2}(?:(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+|[0-9.]+|\\[[a-z0-9.]+:[a-z0-9.]+:[a-z0-9.:]+\\])(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?)|(www\\.(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?))\\](?:([a-z][a-z\\d+\\-.]*:/{2}(?:(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+|[0-9.]+|\\[[a-z0-9.]+:[a-z0-9.]+:[a-z0-9.:]+\\])(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?)|(www\\.(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?))\\[/light1\\]!ie', '''[light1=''.$this->bbcode_specialchars((''${1}'') ? ''${1}'' : ''http://${2}'').'':$uid]''.$this->bbcode_specialchars((''${3}'') ? ''${3}'' : ''http://${4}'').''[/light1:$uid]''', '!\\[light1\\=(?i)((?:[a-z][a-z\\d+\\-.]*:/{2}(?:(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+|[0-9.]+|\\[[a-z0-9.]+:[a-z0-9.]+:[a-z0-9.:]+\\])(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?)|(?:www\\.(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?))(?-i):$uid\\](?i)((?:[a-z][a-z\\d+\\-.]*:/{2}(?:(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+|[0-9.]+|\\[[a-z0-9.]+:[a-z0-9.]+:[a-z0-9.:]+\\])(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?)|(?:www\\.(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?))(?-i)\\[/light1:$uid\\]!s', '<a href="${1}" rel="lightbox"><img style="border: 1px solid black;" src="${2}"></a>');
INSERT INTO phpbb_bbcodes (bbcode_id, bbcode_tag, bbcode_helpline, display_on_posting, bbcode_match, bbcode_tpl, first_pass_match, first_pass_replace, second_pass_match, second_pass_replace) VALUES(47, 'light2=', 'Lightbox2: [light2=URL to image]Link text[/light2]', 1, '[light2={URL}]{TEXT}[/light2]', '<a href="{URL}" rel="lightbox" title="Click to see image">{TEXT}</a>', '!\\[light2\\=(?:([a-z][a-z\\d+\\-.]*:/{2}(?:(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+|[0-9.]+|\\[[a-z0-9.]+:[a-z0-9.]+:[a-z0-9.:]+\\])(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?)|(www\\.(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?))\\](.*?)\\[/light2\\]!ies', '''[light2=''.$this->bbcode_specialchars((''${1}'') ? ''${1}'' : ''http://${2}'').'':$uid]''.str_replace(array("\\r\\n", ''\\"'', ''\\'''', ''('', '')''), array("\\n", ''"'', ''&#39;'', ''&#40;'', ''&#41;''), trim(''${3}'')).''[/light2:$uid]''', '!\\[light2\\=(?i)((?:[a-z][a-z\\d+\\-.]*:/{2}(?:(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+|[0-9.]+|\\[[a-z0-9.]+:[a-z0-9.]+:[a-z0-9.:]+\\])(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?)|(?:www\\.(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?))(?-i):$uid\\](.*?)\\[/light2:$uid\\]!s', '<a href="${1}" rel="lightbox" title="Click to see image">${2}</a>');
INSERT INTO phpbb_bbcodes (bbcode_id, bbcode_tag, bbcode_helpline, display_on_posting, bbcode_match, bbcode_tpl, first_pass_match, first_pass_replace, second_pass_match, second_pass_replace) VALUES(48, 'lightgroup=', '[lightgroup=URL to thumb]URL to big pic[/lightgroup]', 1, '[lightgroup={URL1}]{URL2}[/lightgroup]', '<a href="{URL1}" rel="lightboxgroup"><img style="border: 1px solid black;" alt="" title="" src="{URL2}"></a>', '!\\[lightgroup\\=(?:([a-z][a-z\\d+\\-.]*:/{2}(?:(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+|[0-9.]+|\\[[a-z0-9.]+:[a-z0-9.]+:[a-z0-9.:]+\\])(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?)|(www\\.(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?))\\](?:([a-z][a-z\\d+\\-.]*:/{2}(?:(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+|[0-9.]+|\\[[a-z0-9.]+:[a-z0-9.]+:[a-z0-9.:]+\\])(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?)|(www\\.(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?))\\[/lightgroup\\]!ie', '''[lightgroup=''.$this->bbcode_specialchars((''${1}'') ? ''${1}'' : ''http://${2}'').'':$uid]''.$this->bbcode_specialchars((''${3}'') ? ''${3}'' : ''http://${4}'').''[/lightgroup:$uid]''', '!\\[lightgroup\\=(?i)((?:[a-z][a-z\\d+\\-.]*:/{2}(?:(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+|[0-9.]+|\\[[a-z0-9.]+:[a-z0-9.]+:[a-z0-9.:]+\\])(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?)|(?:www\\.(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?))(?-i):$uid\\](?i)((?:[a-z][a-z\\d+\\-.]*:/{2}(?:(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+|[0-9.]+|\\[[a-z0-9.]+:[a-z0-9.]+:[a-z0-9.:]+\\])(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?)|(?:www\\.(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?))(?-i)\\[/lightgroup:$uid\\]!s', '<a href="${1}" rel="lightboxgroup"><img style="border: 1px solid black;" alt="" title="" src="${2}"></a>');
INSERT INTO phpbb_bbcodes (bbcode_id, bbcode_tag, bbcode_helpline, display_on_posting, bbcode_match, bbcode_tpl, first_pass_match, first_pass_replace, second_pass_match, second_pass_replace) VALUES(49, 'lightbox=', '[lightbox=URL to thumb]URL to big pic[/lightgroup]', 1, '[lightbox={URL1}]{URL2}[/lightbox]', '<a href="{URL1}" rel="lightbox[slideshow]"><img src="{URL2}" alt="image" /></a>', '!\\[lightbox\\=(?:([a-z][a-z\\d+\\-.]*:/{2}(?:(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+|[0-9.]+|\\[[a-z0-9.]+:[a-z0-9.]+:[a-z0-9.:]+\\])(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?)|(www\\.(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?))\\](?:([a-z][a-z\\d+\\-.]*:/{2}(?:(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+|[0-9.]+|\\[[a-z0-9.]+:[a-z0-9.]+:[a-z0-9.:]+\\])(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?)|(www\\.(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?))\\[/lightbox\\]!ie', '''[lightbox=''.$this->bbcode_specialchars((''${1}'') ? ''${1}'' : ''http://${2}'').'':$uid]''.$this->bbcode_specialchars((''${3}'') ? ''${3}'' : ''http://${4}'').''[/lightbox:$uid]''', '!\\[lightbox\\=(?i)((?:[a-z][a-z\\d+\\-.]*:/{2}(?:(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+|[0-9.]+|\\[[a-z0-9.]+:[a-z0-9.]+:[a-z0-9.:]+\\])(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?)|(?:www\\.(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?))(?-i):$uid\\](?i)((?:[a-z][a-z\\d+\\-.]*:/{2}(?:(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+|[0-9.]+|\\[[a-z0-9.]+:[a-z0-9.]+:[a-z0-9.:]+\\])(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?)|(?:www\\.(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})+(?::\\d*)?(?:/(?:[a-z0-9\\-._~\\!$&''()*+,;=:@|]+|%[\\dA-F]{2})*)*(?:\\?(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?(?:#(?:[a-z0-9\\-._~\\!$&''()*+,;=:@/?|]+|%[\\dA-F]{2})*)?))(?-i)\\[/lightbox:$uid\\]!s', '<a href="${1}" rel="lightbox[slideshow]"><img src="${2}" alt="image" /></a>');
INSERT INTO phpbb_bbcodes (bbcode_id, bbcode_tag, bbcode_helpline, display_on_posting, bbcode_match, bbcode_tpl, first_pass_match, first_pass_replace, second_pass_match, second_pass_replace) VALUES(50, 'aligntable=', '[aligntable =align,width,marginleft,marginright,border,brdcolor,bkgrdcolor]{TEXT}[/aligntable]', 1, '[aligntable={TEXT1},{TEXT2},{NUMBER1},{NUMBER2},{TEXT3},{TEXT4},{TEXT5}]{TEXT}[/aligntable]', '<div style="float:{TEXT1}; margin: 0px {NUMBER2}px 0px {NUMBER1}px;"> <table width="{TEXT2}" border="{TEXT3}" bordercolor="{TEXT4}" bgcolor="{TEXT5}">\n      <tr> \n      <td>{TEXT} </td>\n      </tr>\n    </table> </div>', '!\\[aligntable\\=(.*?),(.*?),([0-9]+),([0-9]+),(.*?),(.*?),(.*?)\\](.*?)\\[/aligntable\\]!ies', '''[aligntable=''.str_replace(array("\\r\\n", ''\\"'', ''\\'''', ''('', '')''), array("\\n", ''"'', ''&#39;'', ''&#40;'', ''&#41;''), trim(''${1}'')).'',''.str_replace(array("\\r\\n", ''\\"'', ''\\'''', ''('', '')''), array("\\n", ''"'', ''&#39;'', ''&#40;'', ''&#41;''), trim(''${2}'')).'',${3},${4},''.str_replace(array("\\r\\n", ''\\"'', ''\\'''', ''('', '')''), array("\\n", ''"'', ''&#39;'', ''&#40;'', ''&#41;''), trim(''${5}'')).'',''.str_replace(array("\\r\\n", ''\\"'', ''\\'''', ''('', '')''), array("\\n", ''"'', ''&#39;'', ''&#40;'', ''&#41;''), trim(''${6}'')).'',''.str_replace(array("\\r\\n", ''\\"'', ''\\'''', ''('', '')''), array("\\n", ''"'', ''&#39;'', ''&#40;'', ''&#41;''), trim(''${7}'')).'':$uid]''.str_replace(array("\\r\\n", ''\\"'', ''\\'''', ''('', '')''), array("\\n", ''"'', ''&#39;'', ''&#40;'', ''&#41;''), trim(''${8}'')).''[/aligntable:$uid]''', '!\\[aligntable\\=(.*?),(.*?),([0-9]+),([0-9]+),(.*?),(.*?),(.*?):$uid\\](.*?)\\[/aligntable:$uid\\]!s', '<div style="float:${1}; margin: 0px ${4}px 0px ${3}px;"> <table width="${2}" border="${5}" bordercolor="${6}" bgcolor="${7}">\n      <tr> \n      <td>${8} </td>\n      </tr>\n    </table> </div>');
INSERT INTO phpbb_bbcodes (bbcode_id, bbcode_tag, bbcode_helpline, display_on_posting, bbcode_match, bbcode_tpl, first_pass_match, first_pass_replace, second_pass_match, second_pass_replace) VALUES(51, 'Think_F', 'Think Female', 1, '[Think_F]{TEXT}[/Think_F]', '<table border="0" cellpadding="0" cellspacing="0"><tr><td style="margin: 0;padding: 0;border: 0;"><div style=" background-color: #FFCCFF;color: #000000; -moz-border-radius: 16px; -webkit-border-radius: 16px; border: 1px solid #330644; padding: 4px;font-size: 1em;" >&nbsp; {TEXT} &nbsp;</div><img src="./portal/images/think_f.gif"></td></tr></table>', '!\\[think_f\\](.*?)\\[/think_f\\]!ies', '''[think_f:$uid]''.str_replace(array("\\r\\n", ''\\"'', ''\\'''', ''('', '')''), array("\\n", ''"'', ''&#39;'', ''&#40;'', ''&#41;''), trim(''${1}'')).''[/think_f:$uid]''', '!\\[think_f:$uid\\](.*?)\\[/think_f:$uid\\]!s', '<table border="0" cellpadding="0" cellspacing="0"><tr><td style="margin: 0;padding: 0;border: 0;"><div style=" background-color: #FFCCFF;color: #000000; -moz-border-radius: 16px; -webkit-border-radius: 16px; border: 1px solid #330644; padding: 4px;font-size: 1em;" >&nbsp; ${1} &nbsp;</div><img src="./portal/images/think_f.gif"></td></tr></table>');
INSERT INTO phpbb_bbcodes (bbcode_id, bbcode_tag, bbcode_helpline, display_on_posting, bbcode_match, bbcode_tpl, first_pass_match, first_pass_replace, second_pass_match, second_pass_replace) VALUES(52, 'Think_M', 'Think Male', 1, '[Think_M]{TEXT}[/Think_M]', '<table border="0" cellpadding="0" cellspacing="0"><tr><td style="margin: 0;padding: 0;border: 0;"><div style=" background-color: #CCFFFF;color: #000000; -moz-border-radius: 16px; -webkit-border-radius: 16px; border: 1px solid #330644; padding: 4px;font-size: 1em;" >&nbsp; {TEXT} &nbsp;</div><img src="./portal/images/think_m.gif"></td></tr></table>', '!\\[think_m\\](.*?)\\[/think_m\\]!ies', '''[think_m:$uid]''.str_replace(array("\\r\\n", ''\\"'', ''\\'''', ''('', '')''), array("\\n", ''"'', ''&#39;'', ''&#40;'', ''&#41;''), trim(''${1}'')).''[/think_m:$uid]''', '!\\[think_m:$uid\\](.*?)\\[/think_m:$uid\\]!s', '<table border="0" cellpadding="0" cellspacing="0"><tr><td style="margin: 0;padding: 0;border: 0;"><div style=" background-color: #CCFFFF;color: #000000; -moz-border-radius: 16px; -webkit-border-radius: 16px; border: 1px solid #330644; padding: 4px;font-size: 1em;" >&nbsp; ${1} &nbsp;</div><img src="./portal/images/think_m.gif"></td></tr></table>');



[Coralreef]

As allways sweet !