[BETA] - The Blog Mod

[MWE_001]

Would love to help out any way I can testing or what not. Ill keep checking back through out the night for info. Ray

[Dragonsys]

http://beta.dragonsys.org/im_test/

TestUser
password


or you can create your own account.

Try out everything that fails at your site(s) and let me know what you find.

[MWE_001]

Ok will do. Im sry to take so long to reply It is 3:08 am my time just got home from an emergency I will go therre and starte testing after work In the afternoon. thx again chief Ill let ya know what happens. ray

[Dragonsys]

Not a problem. I am gonna test for the next couple of days, then I will repackage the Mod for download.

After that I will start testing the add-ons, patches, etc for the MOD and add them if they meet the following:

Work Properly
Add Value
Requested Features
Needed Upgrades
etc...

[Dragonsys]

well... it seems to be working great, for me anyway. I have not gotten it to fail yet.

If I don't hear anything before tomorrow sometime, I'm gonna go ahead and package this up and update my downloads. Then I will get to work on the add-ons and stuff.

[spode]

Well the only thing I am seeing is a message stating "You need Security Fixes" and I don't think that relates to your mod. The mod itself looks fine.

Thanks for the continued effort Dragonsys.

[Dragonsys]

that message is due to me testing out some security flaws. Once I apply the fixes it will go away.

[Dragonsys]

I am including the code for the Security fixes here, in case anyone wants to go ahead and install them on their site.

I warn you though, I have not tested these yet (They have been tested by other boards though, just not IM), and they require your site to have the base phpBB v2.0.21. So if you have not updated your site to 2.0.21 yet, do not install these.

Code: Select all

#-----[ 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>';

If you use the block:

Code: Select all

#-----[ 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]

I have applied the above fixes to my test site, and everything seems to be working fine.

[spode]

that message is due to me testing out some security flaws. Once I apply the fixes it will go away.

That is what I thought. Also, Thanks for posting the fixes, I hadn't seen those yet.

Rob...

[Dragonsys]

I have updated the first post with the corrected download file. This does not include the security fixes, but I have added a link to pre-modded files for them as well.

The next release will include the fixes in place, as well as a few add-ons.

I encourage everyone to update to at least the regular version I have uploaded. Do not install the Security Fixes unless you are running base phpBB 2.0.21. If you are running 2.0.21 then I suggest you add the fixes as well.

[IntegraMOD]

i've installed The Blog Mod but suddenly when i want to post my posting it appear this error:

[code]Error getting category information  DEBUG MODE  SQL Error ]

help me..what should i do....

[spode]

[quote=""alan_rast";p="15775""]i've installed The Blog Mod but suddenly when i want to post my posting it appear this error:

Code: Select all

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);

You run these SQL statements in phpmyadmin to create and populate the database tables for the mod. Alternately I believe that there is a "db_update.php" file included that you could upload to your forums and execute via your browser to update the database. Remember to delete this file after running it.

[Dragonsys]

spode is correct. You need to run the db_update.php file. You will get a lot of failures, if you already had the mod installed, but there will be a few successes. I am working on a clear upgrade path, but it is not complete yet.

[IntegraMOD]

thanx spode..
i've done it before..
i forgot to dump phpbb_weblog_entries....