Re: [BETA] - The Blog Mod
Posted: Tue Sep 19, 2006 4:29 pm
Would love to help out any way I can testing or what not. Ill keep checking back through out the night for info. Ray
Home of phpBB Integrated Modifications
https://integramod.com/forum/
#-----[ OPEN ]------------------------------------------------ weblog.php #-----[ FIND ]------------------------------------------------ $page_title = $weblog_data['weblog_name']; #-----[ REPLACE WITH ]------------------------------------------------ $page_title = strip_tags($weblog_data['weblog_name']); #-----[ FIND ]------------------------------------------------ $action = '<strong>[</strong> ' . sprintf($lang['Currently], '<img>', $currently['action_text'] . ' ' . $entry_data[$i]['currently_text']) . ' <strong>]</strong>'; #-----[ REPLACE WITH ]------------------------------------------------ $action = '<strong>[</strong> ' . sprintf($lang['Currently:'], '<img>', $currently['action_text'] . ' ' . strip_tags(htmlspecialchars($entry_data[$i]['currently_text']))) . ' <strong>]</strong>'; #-----[ FIND ]------------------------------------------------ $action = '<strong>[</strong>' . sprintf($lang['Currently:'], '', $entry_data[$i]['currently_text']) . ' <strong>]</strong>'; #-----[ REPLACE WITH ]------------------------------------------------ $action = '<strong>[</strong>' . sprintf($lang['Currently:'], '', strip_tags(htmlspecialchars($entry_data[$i]['currently_text']))) . ' <strong>]</strong>'; #-----[ FIND ]------------------------------------------------ 'SUBJECT' => $entry_data[$i]['entry_subject'], #-----[ REPLACE WITH ]------------------------------------------------ 'SUBJECT' => strip_tags(htmlspecialchars($entry_data[$i]['entry_subject'])), #-----[ FIND ]------------------------------------------------ 'POST_COMMENT' => ( !$entry_data[$i]['no_replies'] ) ? sprintf($weblog_data['post_reply_text'], $entry_data[$i]['entry_replies']) : '', #-----[ REPLACE WITH ]------------------------------------------------ 'POST_COMMENT' => ( !$entry_data[$i]['no_replies'] ) ? sprintf(strip_tags($weblog_data['post_reply_text']), $entry_data[$i]['entry_replies']) : '', #-----[ FIND ]------------------------------------------------ 'REPLIES' => ( !$entry_data[$i]['no_replies'] ) ? sprintf($weblog_data['replies_text'], $entry_data[$i]['entry_replies']) : '', #-----[ REPLACE WITH ]------------------------------------------------ 'REPLIES' => ( !$entry_data[$i]['no_replies'] ) ? sprintf(strip_tags($weblog_data['replies_text']), $entry_data[$i]['entry_replies']) : '', #-----[ OPEN ]------------------------------------------------ weblog_entry.php #-----[ FIND ]------------------------------------------------ $weblog_name = $weblog_entry_data['weblog_name']; $entry_subject = $weblog_entry_data['entry_subject']; #-----[ REPLACE WITH ]------------------------------------------------ $weblog_name = strip_tags($weblog_entry_data['weblog_name']); $entry_subject = strip_tags(htmlspecialchars($weblog_entry_data['entry_subject'])); #-----[ FIND ]------------------------------------------------ $page_title = $weblog_entry_data['weblog_name'] . ' :: ' . $weblog_entry_data['entry_subject']; #-----[ REPLACE WITH ]------------------------------------------------ $page_title = strip_tags($weblog_entry_data['weblog_name']) . ' :: ' . strip_tags(htmlspecialchars($weblog_entry_data['entry_subject'])); #-----[ FIND ]------------------------------------------------ $action = '<strong>[</strong> ' . sprintf($lang['Currently:'], '<img>', $currently['action_text'] . ' ' . $entry_data['currently_text']) . ' <strong>]</strong>'; #-----[ REPLACE WITH ]------------------------------------------------ $action = '<strong>[</strong> ' . sprintf($lang['Currently:'], '<img>', $currently['action_text'] . ' ' . strip_tags(htmlspecialchars($entry_data['currently_text']))) . ' <strong>]</strong>'; #-----[ FIND ]------------------------------------------------ $action = '<strong>[</strong>' . sprintf($lang['Currently:'], '', $entry_data['currently_text']) . ' <strong>]</strong>'; #-----[ REPLACE WITH ]------------------------------------------------ $action = '<strong>[</strong>' . sprintf($lang['Currently:'], '', strip_tags(htmlspecialchars($entry_data['currently_text']))) . ' <strong>]</strong>'; #-----[ OPEN ]------------------------------------------------ weblogs.php #-----[ FIND ]------------------------------------------------ $action = sprintf($lang['Currently:'], '<img>', $currently['action_text'] . ' ' . $last_entry_data['currently_text']); #-----[ REPLACE WITH ]------------------------------------------------ $action = sprintf($lang['Currently:'], '<img>', $currently['action_text'] . ' ' . strip_tags(htmlspecialchars($last_entry_data['currently_text']))); #-----[ FIND ]------------------------------------------------ $action = sprintf($lang['Currently:'], '', $last_entry_data['currently_text']); #-----[ REPLACE WITH ]------------------------------------------------ $action = sprintf($lang['Currently:'], '', strip_tags(htmlspecialchars($last_entry_data['currently_text']))); #-----[ FIND ]------------------------------------------------ $action = sprintf($lang['Currently:'], '<img>', $currently['action_text'] . ' ' . $last_entry_data['currently_text']); #-----[ REPLACE WITH ]------------------------------------------------ $action = sprintf($lang['Currently:'], '<img>', $currently['action_text'] . ' ' . strip_tags(htmlspecialchars($last_entry_data['currently_text']))); #-----[ FIND ]------------------------------------------------ $action = sprintf($lang['Currently:'], '', $last_entry_data['currently_text']); #-----[ REPLACE WITH ]------------------------------------------------ $action = sprintf($lang['Currently:'], '', strip_tags(htmlspecialchars($last_entry_data['currently_text']))); #-----[ FIND ]------------------------------------------------ 'WEBLOG_NAME' => $weblog_data[$i]['weblog_name'], #-----[ REPLACE WITH ]------------------------------------------------ 'WEBLOG_NAME' => strip_tags($weblog_data[$i]['weblog_name']), #-----[ OPEN ]------------------------------------------------ weblog_posting.php #-----[ FIND ]------------------------------------------------ 'ENTRY_SUBJECT' => $entry_subject, #-----[ REPLACE WITH ]------------------------------------------------ 'ENTRY_SUBJECT' => strip_tags(htmlspecialchars($entry_subject)), #-----[ FIND ]------------------------------------------------ 'WEBLOG_NAME' => $weblog_data['weblog_name'], #-----[ REPLACE WITH ]------------------------------------------------ 'WEBLOG_NAME' => strip_tags($weblog_data['weblog_name']), #-----[ FIND ]------------------------------------------------ $post_subject = stripslashes($subject); #-----[ REPLACE WITH ]------------------------------------------------ $post_subject = strip_tags(htmlspecialchars(stripslashes($subject))); #-----[ FIND ]------------------------------------------------ $preview_action = '<strong>[</strong> ' . sprintf($lang['Currently:'], '<img>', $currently['action_text'] . ' ' . $action_text) . ' <strong>]</strong>'; #-----[ REPLACE WITH ]------------------------------------------------ $preview_action = '<strong>[</strong> ' . sprintf($lang['Currently:'], '<img>', strip_tags(htmlspecialchars($currently['action_text'])) . ' ' . strip_tags(htmlspecialchars($action_text))) . ' <strong>]</strong>'; #-----[ FIND ]------------------------------------------------ $preview_action = '<strong>[</strong>' . sprintf($lang['Currently:'], '', $action_text) . ' <strong>]</strong>'; #-----[ REPLACE WITH ]------------------------------------------------ $preview_action = '<strong>[</strong>' . sprintf($lang['Currently:'], '', strip_tags(htmlspecialchars($action_text))) . ' <strong>]</strong>'; #-----[ FIND ]------------------------------------------------ $entry_action = '<strong>[</strong> ' . sprintf($lang['Currently:'], '<img>', $entry_currently['action_text'] . ' ' . $entry_data['currently_text']) . ' <strong>]</strong>'; #-----[ REPLACE WITH ]------------------------------------------------ $entry_action = '<strong>[</strong> ' . sprintf($lang['Currently:'], '<img>', $entry_currently['action_text'] . ' ' . strip_tags(htmlspecialchars($entry_data['currently_text']))) . ' <strong>]</strong>'; #-----[ FIND ]------------------------------------------------ $entry_action = '<strong>[</strong>' . sprintf($lang['Currently:'], '', $entry_data['currently_text']) . ' <strong>]</strong>'; #-----[ REPLACE WITH ]------------------------------------------------ $entry_action = '<strong>[</strong>' . sprintf($lang['Currently:'], '', strip_tags(htmlspecialchars($entry_data['currently_text']))) . ' <strong>]</strong>'; #-----[ OPEN ]------------------------------------------------ weblog_friends.php #-----[ FIND ]------------------------------------------------ $action = '<strong>[</strong> ' . sprintf($lang['Currently:'], '<img>', $currently['action_text'] . ' ' . $entry_data[$i]['currently_text']) . ' <strong>]</strong>'; #-----[ REPLACE WITH ]------------------------------------------------ $action = '<strong>[</strong> ' . sprintf($lang['Currently:'], '<img>', $currently['action_text'] . ' ' . strip_tags(htmlspecialchars($entry_data[$i]['currently_text']))) . ' <strong>]</strong>'; #-----[ FIND ]------------------------------------------------ $action = '<strong>[</strong>' . sprintf($lang['Currently:'], '', $entry_data[$i]['currently_text']) . ' <strong>]</strong>'; #-----[ REPLACE WITH ]------------------------------------------------ $action = '<strong>[</strong>' . sprintf($lang['Currently:'], '', strip_tags(htmlspecialchars($entry_data[$i]['currently_text']))) . ' <strong>]</strong>'; #-----[ FIND ]------------------------------------------------ 'WEBLOG_NAME' => $friend_data[$i]['weblog_name'], #-----[ REPLACE WITH ]------------------------------------------------ 'WEBLOG_NAME' => strip_tags($friend_data[$i]['weblog_name']), #-----[ FIND ]------------------------------------------------ 'SUBJECT' => $friend_entry_data['entry_subject'], #-----[ REPLACE WITH ]------------------------------------------------ 'SUBJECT' => strip_tags(htmlspecialchars($friend_entry_data['entry_subject'])), #-----[ FIND ]------------------------------------------------ 'WEBLOG_NAME' => $weblog_data['weblog_name']) #-----[ REPLACE WITH ]------------------------------------------------ 'WEBLOG_NAME' => strip_tags($weblog_data['weblog_name'])) #-----[ FIND ]------------------------------------------------ 'POST_COMMENT' => ( !$friend_entry_data['no_replies'] && $friend_entry_data['entry_text'] ) ? sprintf($friend_data[$i]['post_reply_text'], $friend_entry_data['entry_replies']) : '', #-----[ REPLACE WITH ]------------------------------------------------ 'POST_COMMENT' => ( !$friend_entry_data['no_replies'] && $friend_entry_data['entry_text'] ) ? sprintf(strip_tags($friend_data[$i]['post_reply_text']), $friend_entry_data['entry_replies']) : '', #-----[ FIND ]------------------------------------------------ 'REPLIES' => ( !$friend_entry_data['no_replies'] && $friend_entry_data['entry_text'] ) ? sprintf($friend_data[$i]['replies_text'], $friend_entry_data['entry_replies']) : '', #-----[ REPLACE WITH ]------------------------------------------------ 'REPLIES' => ( !$friend_entry_data['no_replies'] && $friend_entry_data['entry_text'] ) ? sprintf(strip_tags($friend_data[$i]['replies_text']), $friend_entry_data['entry_replies']) : '', #-----[ FIND ]------------------------------------------------ $friend_entry_data['entry_text'] = nl2br($friend_entry_data['entry_text']); #-----[ AFTER ADD ]------------------------------------------------ $friend_entry_data['entry_text'] = undo_htmlspecialchars($friend_entry_data['entry_text']); #-----[ OPEN ]------------------------------------------------ weblog_news.php #-----[ FIND ]------------------------------------------------ $action = sprintf($lang['Currently:'], '<img>', $currently['action_text'] . ' ' . $last_entry_data['currently_text']); #-----[ REPLACE WITH ]------------------------------------------------ $action = sprintf($lang['Currently:'], '<img>', $currently['action_text'] . ' ' . strip_tags(htmlspecialchars($last_entry_data['currently_text']))); #-----[ FIND ]------------------------------------------------ $action = sprintf($lang['Currently:'], '', $last_entry_data['currently_text']); #-----[ REPLACE WITH ]------------------------------------------------ $action = sprintf($lang['Currently:'], '', strip_tags(htmlspecialchars($last_entry_data['currently_text']))); #-----[ FIND ]------------------------------------------------ 'L_LATEST_ENTRIES' => $blog_row[$i]['entry_subject'], #-----[ REPLACE WITH ]------------------------------------------------ 'L_LATEST_ENTRIES' => strip_tags(htmlspecialchars($blog_row[$i]['entry_subject'])), #-----[ FIND ]------------------------------------------------ 'L_LATEST_REPLY' => $replies_row[$i]['entry_subject'], #-----[ REPLACE WITH ]------------------------------------------------ 'L_LATEST_REPLY' => strip_tags(htmlspecialchars($replies_row[$i]['entry_subject'])), #-----[ FIND ]------------------------------------------------ 'L_BLOG_NAME' => $replies_row[$i]['weblog_name'], #-----[ REPLACE WITH ]------------------------------------------------ 'L_BLOG_NAME' => strip_tags($replies_row[$i]['weblog_name']), #-----[ OPEN ]------------------------------------------------ weblog_allentries.php #-----[ FIND ]------------------------------------------------ $page_title = $weblog_data['weblog_name'] . ' :: ' . $lang['Entries']; #-----[ REPLACE WITH ]------------------------------------------------ $page_title = strip_tags($weblog_data['weblog_name']) . ' :: ' . $lang['Entries']; #-----[ FIND ]------------------------------------------------ 'WEBLOG_NAME' => $weblog_data['weblog_name'], #-----[ REPLACE WITH ]------------------------------------------------ 'WEBLOG_NAME' => strip_tags($weblog_data['weblog_name']), #-----[ FIND ]------------------------------------------------ $entry_subject = ( count($orig_word) && $weblog_config['censor_weblog'] ) ? preg_replace($orig_word, $replacement_word, $entry_data[$i]['entry_subject']) : $entry_data[$i]['entry_subject']; #-----[ REPLACE WITH ]------------------------------------------------ $entry_subject = ( count($orig_word) && $weblog_config['censor_weblog'] ) ? preg_replace($orig_word, $replacement_word, strip_tags(htmlspecialchars($entry_data[$i]['entry_subject']))) : strip_tags(htmlspecialchars($entry_data[$i]['entry_subject'])); #-----[ FIND ]------------------------------------------------ $action = '<img>'; #-----[ REPLACE WITH ]------------------------------------------------ $action = '<img>';
#-----[ OPEN ]------------------------------------------------ blocks/blocks_imp_blogs.php #-----[ FIND ]------------------------------------------------ $recent_blogs .= $current['entry_subject']; // Subject #-----[ REPLACE WITH ]------------------------------------------------ $recent_blogs .= strip_tags(htmlspecialchars($current['entry_subject'])); // Subject
"Dragonsys";p="15720" wrote:that message is due to me testing out some security flaws. Once I apply the fixes it will go away.
Error getting category information DEBUG MODE SQL Error ]
help me..what should i do....[/quote]
Did you preform the following changes in the install file?[code]# #-----[ SQL ]------------------------------------------ # Replace "phpbb_" with the prefix of your forums. # If you do not understand how to do this part, use EasyMod, or # upload the db_update.php file to your server and run it. # Do NOT run both the db_update.php file & this SQL. Pick ONE. # ALTER TABLE phpbb_groups ADD group_allow_weblogs TINYINT(1) UNSIGNED NOT NULL DEFAULT '0'; ALTER TABLE phpbb_users ADD user_allowweblog TINYINT(1) UNSIGNED NOT NULL DEFAULT '1'; ALTER TABLE phpbb_users ADD user_allowadvweblog TINYINT(1) UNSIGNED NOT NULL DEFAULT '0'; ALTER TABLE phpbb_users ADD user_showfriends TINYINT(1) UNSIGNED NOT NULL DEFAULT '1'; ALTER TABLE phpbb_users ADD user_weblog MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0'; CREATE TABLE phpbb_weblog_actions ( action_id SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL, action_text VARCHAR(50) DEFAULT '', action_url VARCHAR(100) DEFAULT '', PRIMARY KEY (action_id) ); CREATE TABLE phpbb_weblog_blocked ( owner_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', blocked_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (owner_id, blocked_id) ); CREATE TABLE phpbb_weblog_config ( config_name VARCHAR(255) NOT NULL DEFAULT '', config_value VARCHAR(255) NOT NULL DEFAULT '', PRIMARY KEY (config_name) ); CREATE TABLE phpbb_weblog_contributors ( weblog_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', user_id MEDIUMINT(8) NOT NULL DEFAULT '0', PRIMARY KEY (weblog_id, user_id) ); CREATE TABLE phpbb_weblog_entries ( entry_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', weblog_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', entry_access TINYINT(4) UNSIGNED NOT NULL DEFAULT '0', entry_subject VARCHAR(60) NOT NULL DEFAULT '', entry_text TEXT NOT NULL DEFAULT '', bbcode_uid VARCHAR(10) NOT NULL DEFAULT '', entry_mood SMALLINT(5) NOT NULL DEFAULT '0', entry_currently SMALLINT(5) NOT NULL DEFAULT '0', currently_text VARCHAR(60) NOT NULL DEFAULT '', entry_time INT(11) NOT NULL DEFAULT '0', entry_views MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', enable_bbcode TINYINT(1) UNSIGNED NOT NULL DEFAULT '1', enable_smilies TINYINT(1) UNSIGNED NOT NULL DEFAULT '1', enable_html TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', memorable TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', no_replies TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', entry_replies MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', entry_last_post_userid MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', entry_last_post_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', entry_poster_id MEDIUMINT(8) NOT NULL DEFAULT '0', entry_trackbacks SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0', entry_deleted TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (entry_id), KEY (weblog_id), KEY (entry_last_post_userid), KEY (entry_last_post_id), KEY (entry_poster_id) ); CREATE TABLE phpbb_weblog_friends ( owner_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', friend_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (owner_id, friend_id) ); CREATE TABLE phpbb_weblog_mood_sets ( set_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', set_name VARCHAR (255) NOT NULL DEFAULT '', PRIMARY KEY (set_id) ); CREATE TABLE phpbb_weblog_moods ( mood_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', mood_text VARCHAR (255) NOT NULL DEFAULT '', mood_url VARCHAR (255) NOT NULL DEFAULT '', mood_set MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (mood_id), KEY (mood_set) ); CREATE TABLE phpbb_weblog_replies ( reply_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', entry_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', poster_id MEDIUMINT(8) NOT NULL DEFAULT '0', post_time INT(11), post_username VARCHAR(25) NOT NULL DEFAULT '', post_subject VARCHAR (60) NOT NULL DEFAULT '', enable_bbcode TINYINT(1) UNSIGNED NOT NULL DEFAULT '1', enable_smilies TINYINT(1) UNSIGNED NOT NULL DEFAULT '1', enable_html TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', enable_sig TINYINT(1) UNSIGNED NOT NULL DEFAULT '1', reply_text TEXT NOT NULL DEFAULT '', bbcode_uid VARCHAR(10) NOT NULL DEFAULT '', PRIMARY KEY (reply_id), KEY (entry_id), KEY (poster_id) ); CREATE TABLE phpbb_weblog_shoutbox ( shout_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', shout_weblog MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', shout_text TEXT NOT NULL DEFAULT '', shout_poster MEDIUMINT(8) NOT NULL DEFAULT '0', shout_username VARCHAR(25) NOT NULL DEFAULT '', bbcode_uid VARCHAR (10) NOT NULL DEFAULT '', shout_time INT(11) NOT NULL DEFAULT '0', shout_www VARCHAR (100) NOT NULL DEFAULT '', PRIMARY KEY (shout_id), KEY (shout_weblog), KEY (shout_poster) ); CREATE TABLE phpbb_weblog_templates ( template_id SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0', template_name VARCHAR(100) NOT NULL DEFAULT '', template_dir VARCHAR (100) NOT NULL DEFAULT '', template_private TINYINT(1) NOT NULL DEFAULT '0', PRIMARY KEY (template_id) ); CREATE TABLE phpbb_weblog_trackbacks ( tb_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', tb_entry MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', tb_blog VARCHAR (255) NOT NULL DEFAULT '', tb_time INT(11) NOT NULL DEFAULT '0', tb_excerpt VARCHAR(255) NOT NULL DEFAULT '', tb_url VARCHAR(255) NOT NULL DEFAULT '', tb_title VARCHAR(255) NOT NULL DEFAULT '', PRIMARY KEY (tb_id), KEY (tb_entry) ); CREATE TABLE phpbb_weblogs ( weblog_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', template_id SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0', weblog_name VARCHAR(60) NOT NULL DEFAULT '', weblog_desc VARCHAR(255) NOT NULL DEFAULT '', weblog_auth TINYINT(4) UNSIGNED NOT NULL DEFAULT '0', replies_auth TINYINT(4) UNSIGNED NOT NULL DEFAULT '0', weblog_entries MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', entries_perpage SMALLINT(5) UNSIGNED NOT NULL DEFAULT '5', post_reply_text VARCHAR(60) NOT NULL DEFAULT '', replies_text VARCHAR(60) NOT NULL DEFAULT '', weblog_create_date INT(11) NOT NULL DEFAULT '0', weblog_views MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', weblog_advanced TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', weblog_shoutbox_desc TINYINT(1) UNSIGNED NOT NULL DEFAULT '1', show_profile_info TINYINT(1) UNSIGNED NOT NULL DEFAULT '1', show_calendar TINYINT(1) UNSIGNED NOT NULL DEFAULT '1', show_contact_info TINYINT(1) UNSIGNED NOT NULL DEFAULT '1', show_weblog_info TINYINT(1) UNSIGNED NOT NULL DEFAULT '1', show_shoutbox TINYINT(1) UNSIGNED NOT NULL DEFAULT '1', reply_in_popup TINYINT(1) UNSIGNED NOT NULL DEFAULT '1', deleted TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', weblog_last_entry_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', mood_set MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', custom_block TEXT NOT NULL DEFAULT '', custom_block_title VARCHAR (64) NOT NULL DEFAULT '', background_color VARCHAR(6) NOT NULL DEFAULT '', entry_bg_color VARCHAR(6) NOT NULL DEFAULT '', border_color VARCHAR(6) NOT NULL DEFAULT '', background_image VARCHAR(255) NOT NULL DEFAULT '', background_image_fixed TINYINT(1) NOT NULL DEFAULT '0', tile_bg VARCHAR(9) NOT NULL DEFAULT '', sb_face_color VARCHAR(6) NOT NULL DEFAULT '', sb_highlight_color VARCHAR(6) NOT NULL DEFAULT '', sb_shadow_color VARCHAR(6) NOT NULL DEFAULT '', sb_3dlight_color VARCHAR(6) NOT NULL DEFAULT '', sb_arrow_color VARCHAR(6) NOT NULL DEFAULT '', sb_track_color VARCHAR(6) NOT NULL DEFAULT '', sb_darkshadow_color VARCHAR(6) NOT NULL DEFAULT '', font SMALLINT(5) NOT NULL DEFAULT '0', font_color VARCHAR(6) NOT NULL DEFAULT '000000', font_size TINYINT(2) NOT NULL DEFAULT '0', normal_link_color VARCHAR(6) NOT NULL DEFAULT '', active_link_color VARCHAR(6) NOT NULL DEFAULT '', hover_link_color VARCHAR(6) NOT NULL DEFAULT '', visited_link_color VARCHAR(6) NOT NULL DEFAULT '', weblog_title_color VARCHAR(6) NOT NULL DEFAULT '', entry_title_color VARCHAR(6) NOT NULL DEFAULT '', date_time_color VARCHAR(6) NOT NULL DEFAULT '', block_title_color VARCHAR(6) NOT NULL DEFAULT '', block_bg_color VARCHAR(6) NOT NULL DEFAULT '', block_border_color VARCHAR(6) NOT NULL DEFAULT '', bg_ypos VARCHAR(6) NOT NULL DEFAULT '', bg_xpos VARCHAR(6) NOT NULL DEFAULT '', normal_link_underline TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', active_link_underline TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', hover_link_underline TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', visited_link_underline TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', weblog_title_font_size TINYINT(2) UNSIGNED NOT NULL DEFAULT '16', entry_title_font_size TINYINT(2) UNSIGNED NOT NULL DEFAULT '12', date_time_font_size TINYINT(2) UNSIGNED NOT NULL DEFAULT '14', block_title_font_size TINYINT(2) UNSIGNED NOT NULL DEFAULT '14', cblock_bbcode_uid VARCHAR(10) NOT NULL DEFAULT '', PRIMARY KEY (weblog_id), KEY (template_id), KEY (mood_set) ); INSERT INTO phpbb_weblog_actions (action_id, action_text, action_url) VALUES (1, 'Eating', 'action_eat.gif'); INSERT INTO phpbb_weblog_actions (action_id, action_text, action_url) VALUES (2, 'Listening to', 'action_listen.gif'); INSERT INTO phpbb_weblog_actions (action_id, action_text, action_url) VALUES (3, 'Playing', 'action_play.gif'); INSERT INTO phpbb_weblog_actions (action_id, action_text, action_url) VALUES (4, 'Reading', 'action_read.gif'); INSERT INTO phpbb_weblog_actions (action_id, action_text, action_url) VALUES (5, 'Watching', 'action_watch.gif'); INSERT INTO phpbb_weblog_actions (action_id, action_text, action_url) VALUES (6, 'Working', 'action_work.gif'); INSERT INTO phpbb_weblog_config (config_name, config_value) VALUES ('enable_mod', 1); INSERT INTO phpbb_weblog_config (config_name, config_value) VALUES ('no_avatars_index', 0); INSERT INTO phpbb_weblog_config (config_name, config_value) VALUES ('default_name', '%s's blog'); INSERT INTO phpbb_weblog_config (config_name, config_value) VALUES ('default_desc', 'Welcome to my Blog'); INSERT INTO phpbb_weblog_config (config_name, config_value) VALUES ('main_sorttype', 0); INSERT INTO phpbb_weblog_config (config_name, config_value) VALUES ('main_sortorder', 'desc'); INSERT INTO phpbb_weblog_config (config_name, config_value) VALUES ('main_blogsperpage', 10); INSERT INTO phpbb_weblog_config (config_name, config_value) VALUES ('use_default_faceplates', 1); INSERT INTO phpbb_weblog_config (config_name, config_value) VALUES ('condense_index', 0); INSERT INTO phpbb_weblog_config (config_name, config_value) VALUES ('censor_weblog', 0); INSERT INTO phpbb_weblog_config (config_name, config_value) VALUES ('default_auth', 0); INSERT INTO phpbb_weblog_config (config_name, config_value) VALUES ('default_reply_auth', 0); INSERT INTO phpbb_weblog_config (config_name, config_value) VALUES ('default_entries_perpage', 5); INSERT INTO phpbb_weblog_config (config_name, config_value) VALUES ('require_auth', 1); INSERT INTO phpbb_weblog_config (config_name, config_value) VALUES ('default_post_reply_text', '(Post your comment)'); INSERT INTO phpbb_weblog_config (config_name, config_value) VALUES ('default_replies_text', '%s Comments'); INSERT INTO phpbb_weblog_config (config_name, config_value) VALUES ('index_list_by_username', 0); INSERT INTO phpbb_weblog_config (config_name, config_value) VALUES ('shoutbox_flood_delay', 15); INSERT INTO phpbb_weblog_config (config_name, config_value) VALUES ('max_pic_width', 500); INSERT INTO phpbb_weblog_config (config_name, config_value) VALUES ('max_pic_height', 500); INSERT INTO phpbb_weblog_config (config_name, config_value) VALUES ('max_pic_size', 131072); INSERT INTO phpbb_weblog_config (config_name, config_value) VALUES ('pic_upload_enabled', 1); INSERT INTO phpbb_weblog_mood_sets (set_id, set_name) VALUES (0, 'Default Set'); INSERT INTO phpbb_weblog_moods (mood_id, mood_text, mood_url, mood_set) VALUES (1, 'Angelic', 'mood_angelic.gif', 0); INSERT INTO phpbb_weblog_moods (mood_id, mood_text, mood_url, mood_set) VALUES (2, 'Confused', 'mood_confused.gif', 0); INSERT INTO phpbb_weblog_moods (mood_id, mood_text, mood_url, mood_set) VALUES (3, 'Cool', 'mood_cool.gif', 0); INSERT INTO phpbb_weblog_moods (mood_id, mood_text, mood_url, mood_set) VALUES (4, 'Silly', 'mood_silly.gif', 0); INSERT INTO phpbb_weblog_moods (mood_id, mood_text, mood_url, mood_set) VALUES (5, 'Very Sad', 'mood_verysad.gif', 0); INSERT INTO phpbb_weblog_moods (mood_id, mood_text, mood_url, mood_set) VALUES (6, 'Shocked', 'mood_shocked.gif', 0); INSERT INTO phpbb_weblog_moods (mood_id, mood_text, mood_url, mood_set) VALUES (7, 'Evil', 'mood_evil.gif', 0); INSERT INTO phpbb_weblog_moods (mood_id, mood_text, mood_url, mood_set) VALUES (8, 'In Love', 'mood_love.gif', 0); INSERT INTO phpbb_weblog_moods (mood_id, mood_text, mood_url, mood_set) VALUES (9, 'Amused', 'mood_amused.gif', 0); INSERT INTO phpbb_weblog_moods (mood_id, mood_text, mood_url, mood_set) VALUES (10, 'Angry', 'mood_angry.gif', 0); INSERT INTO phpbb_weblog_moods (mood_id, mood_text, mood_url, mood_set) VALUES (11, 'Neutral', 'mood_neutral.gif', 0); INSERT INTO phpbb_weblog_moods (mood_id, mood_text, mood_url, mood_set) VALUES (12, 'Sick', 'mood_sick.gif', 0); INSERT INTO phpbb_weblog_moods (mood_id, mood_text, mood_url, mood_set) VALUES (13, 'Scared', 'mood_scared.gif', 0); INSERT INTO phpbb_weblog_moods (mood_id, mood_text, mood_url, mood_set) VALUES (14, 'Happy', 'mood_happy.gif', 0); INSERT INTO phpbb_weblog_moods (mood_id, mood_text, mood_url, mood_set) VALUES (15, 'Fed Up WIth Life', 'mood_fedup.gif', 0); INSERT INTO phpbb_weblog_moods (mood_id, mood_text, mood_url, mood_set) VALUES (16, 'Distorted', 'mood_distorted.gif', 0); INSERT INTO phpbb_weblog_moods (mood_id, mood_text, mood_url, mood_set) VALUES (17, 'Hypnotized', 'mood_hypnotized.gif', 0); INSERT INTO phpbb_weblog_moods (mood_id, mood_text, mood_url, mood_set) VALUES (18, 'Embarrased', 'mood_embarrased.gif', 0); INSERT INTO phpbb_weblog_moods (mood_id, mood_text, mood_url, mood_set) VALUES (19, 'Sleepy', 'mood_sleepy.gif', 0); INSERT INTO phpbb_weblog_templates (template_id, template_name, template_dir) VALUES (1, 'Infinity', 'Infinity'); INSERT INTO `phpbb_portal_config` VALUES ( '', 'md_num_blogs', '10' ); INSERT INTO `phpbb_portal_config` VALUES ( '', 'md_blogs_style', '0' ); -- -- Dumping table for category -- ALTER TABLE `phpbb_weblog_entries` ADD `category` VARCHAR( 60 ) NOT NULL DEFAULT ''; -- -- Dumping table for weblogs news -- INSERT INTO `phpbb_weblog_config` ( `config_name` , `config_value` ) VALUES ( 'hot_level', '5' ); INSERT INTO `phpbb_weblog_config` ( `config_name` , `config_value` ) VALUES ( 'latest_entry_max', '5' ); INSERT INTO `phpbb_weblog_config` ( `config_name` , `config_value` ) VALUES ( 'latest_reply_max', '10' ); INSERT INTO `phpbb_weblog_config` ( `config_name` , `config_value` ) VALUES ( 'show_action', '1' ); INSERT INTO `phpbb_weblog_config` ( `config_name` , `config_value` ) VALUES ( 'show_comments', '1' ); INSERT INTO `phpbb_weblog_config` ( `config_name` , `config_value` ) VALUES ( 'show_latest_entries', '1' ); INSERT INTO `phpbb_weblog_config` ( `config_name` , `config_value` ) VALUES ( 'show_latest_replies', '1' ); INSERT INTO `phpbb_weblog_config` ( `config_name` , `config_value` ) VALUES ( 'no_blocks_text', 'The Administrator of this website has chosen not to show any blocks on this page' ); ALTER TABLE `phpbb_weblog_actions` CHANGE `action_id` `action_id` SMALLINT( 5 ) UNSIGNED NOT NULL DEFAULT '0' AUTO_INCREMENT; ALTER TABLE `phpbb_weblogs` CHANGE `weblog_id` `weblog_id` MEDIUMINT( 8 ) UNSIGNED NOT NULL AUTO_INCREMENT; ALTER TABLE `phpbb_weblog_entries` CHANGE `entry_id` `entry_id` MEDIUMINT( 8 ) UNSIGNED NOT NULL AUTO_INCREMENT; ALTER TABLE `phpbb_weblog_replies` CHANGE `reply_id` `reply_id` MEDIUMINT( 8 ) UNSIGNED NOT NULL AUTO_INCREMENT; ALTER TABLE `phpbb_weblog_shoutbox` CHANGE `shout_id` `shout_id` MEDIUMINT( 8 ) UNSIGNED NOT NULL AUTO_INCREMENT; ALTER TABLE `phpbb_weblog_moods` CHANGE `mood_id` `mood_id` MEDIUMINT( 8 ) UNSIGNED NOT NULL AUTO_INCREMENT; INSERT INTO phpbb_weblog_config (config_name, config_value) VALUES ('no_trackback', 0);