[Done 1.5.1-1.5.5] Blog Mod (07/19)

[Spaceman-Spiff]

ID: Blog Mod
Version: 1.1

Blog demo: http://omanga.monkey-pirate.com/index.php?board=27
SSI demo:  http://www.monkey-pirate.com/blogs/spiff/ (with style)

Mod Info:
This mod allows people to write blogs (Web Logs or Journals) through the Forum. Each topic in a blog board will act like an individual blog. Each allowed users can only post an entry in their own blogs.
To get forum styles working properly, save your template style in an external css file called 'style.css'. Install the External CSS Mod if you wish to have a style editor (like the template editor) in admin center.

Features:
• Blog commenting
• Option to reverse the Post Display (new blog entries on top)
• SSI: include your blog in your site, ala News.php!
• Available templates: blog comments popup & ssi. You can edit the look of your blog comments page and SSI.
• IP is logging

Permission Settings available:
• Minimum post count required to have a blog
• Membergroup allowed to have a blog
• Max blog per user
• Guest commenting
• Self moderation: Moderator owner have moderator's power (can delete comments in his/her own blog)

Screenshots:
- ModSettings


Download:
• BoardMod File
Run "blogmod_dbmod_upgrade.php" if you were running version 0.9x
You don't need to run the dbmod file anymore if u're upgrading from 1.x

Available Translations:
-

BoardMod Installation Instructions:
1. Upload the blogmod_dbmod.php file into your forum directory and execute it
2. Run this .mod file in BoardMod
3. Upload the changed souce and language files into their directories and upload Blog.php into Sources directory
4. Create 'template' subdirectory inside your forum directory and upload the content of template/ there.

Changelogs:
Ver 1.1:
• fixed a bug in blog posting permission
Ver 1.0:
• added last commenter into Display.php
• added [new] image for unread comments
Ver 0.94:
• fixed permission logic bug
(for older changelogs, see the .mod file)

[Spaceman-Spiff]

Btw, I haven't tested it in a clean board, so, please tell me if anyone is having problems with it. Suggestions are also welcomed.

Stuff i'm considering for the future release:
- show [new] icon for new comments

[Valconeye]

WONDERFUL! i was just thinking about a blog mod, and walla! Spaceman-Spiff has cam to the rescue! i am very excited about this mod!

[amango]

After installation and after starting a new topic, I got this error message:

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Datei: c:\Webs\yabbse\Sources\Post.php
Zeile: 59

[/size]

The code from line 59 is something your mod added in post.php

$requestBlog = mysql_query("SELECT ID_BOARD FROM {$db_prefix}boards WHERE ID_BOARD=$board AND isBlog=1;") or database_error(__FILE__, __LINE__);
   $isBlog = (mysql_num_rows($requestBlog) > 0) ? true : false;
   $requestBlog = mysql_query("SELECT posts FROM {$db_prefix}members WHERE ID_MEMBER=$ID_MEMBER;") or database_error(__FILE__, __LINE__);
   $post_count = mysql_fetch_row($requestBlog);
   //check posting permission
   if ($isBlog && $settings[7] != 'Administrator' && $settings[7] != 'Global Moderator' && !in_array($username,$moderators))
   {
      //check for new topic post
      if ($threadid == '')
      {
         if ( ($post_count[0] < $modSettings['blogmod_minpost']) || ($modSettings['blogmod_groups'] != '' && !in_array($settings[7], $blogmod_groups)) )
            fatal_error($txt['blogmod11']);
         $requestBlog = mysql_query("SELECT COUNT(*) FROM {$db_prefix}topics WHERE ID_BOARD=$board AND ID_MEMBER_STARTED=$ID_MEMBER;") or database_error(__FILE__, __LINE__);
         $blog_total = mysql_fetch_row($requestBlog);
         if ($blog_total[0] >= $modSettings['blogmod_maxblogsperuser'])
            fatal_error($txt['blogmod12']);
      }
      //check for post reply
      else
      {
         $requestBlog = mysql_query("SELECT ID_TOPIC FROM {$db_prefix}topics WHERE ID_BOARD=$board AND ID_MEMBER_STARTED=$ID_MEMBER;") or database_error(__FILE__, __LINE__);
         if (mysql_num_rows($requestBlog) == 0)
            fatal_error($txt['blogmod13']);
      }
   }

I have YabbSE 1.54 (modded)

[Spaceman-Spiff]

hmm... have u run the blogmod_dbmod.php file?

[amango]

Of course.

[Spaceman-Spiff]

darn, i really don't know what could cause that...
i'll take a look again tomorrow
gotta sleep now...

[Spaceman-Spiff]

released v0.91, changes:
• fixed error $txt in ManageBoard
• fixed error query in Post.php
• fixed String not found in ModSettings.php
• made "Re: subject" not show on blog boards

[amango]

Now it doesn't make error messages anymore for me.

But... it does not work.

If I click on "post comment" and I type something in all boxes - no comments are displayed after this. (No comments yet is displayed in the window).

If I make a SSI-Listing with index.php?action=blog_ssi;board=2;threadid=2 for example, clicking "comments" and "post comments" leads to an error message "Blog not found."

You can see this for yourself if you click on your own testsite: http://www.monkey-pirate.com/php/test/includetest.php

[Spaceman-Spiff]

*sigh* I make stupid mistakes
i added a column in blog_comments table right before releasing 0.9 and forgot to include it in the dbmod file
its weird that the core blog system was working fine before i added more features to it
thx for testing help, amango

anyway, v0.92 is released, changes:
- fixed link error in SSI
- fixed posting error (forgot to include posterEmail field into dbmod)
- guest fields no longer showing to members
- added ip logged image

If you're upgrading from previous versions, drop table blog_comments first and run blogmod_dbmod.php again. There are no changes to the .mod file, so you only need to upgrade the database and reuploaded Blog.php and the templates.

* Spaceman-Spiff hopes this version is finally ready to use...

[amango]

Another possible bug:

1) In ModifySettings.php - option "Groups allowed to have blog (blank for all)". After clicking "!" and selecting the groups (Adminstrator, Global Moderator...) the field remains blank.

2) After posting a comment the window is not closing. After closing it manually and then clicking again on comment to see it, the now opened window remains "blank". Tested wie IE6 and Mozilla.

[Spaceman-Spiff]

1) In ModifySettings.php - option "Groups allowed to have blog (blank for all)". After clicking "!" and selecting the groups (Adminstrator, Global Moderator...) the field remains blank.

fixed, should be included in the next release

2) After posting a comment the window is not closing. After closing it manually and then clicking again on comment to see it, the now opened window remains "blank". Tested wie IE6 and Mozilla.

guess what, i forgot to include another thing in the dbmod
do you think its better if the window closes automatically after posting?

[BuildHome]

How can I rejuvenate it and not add it as new mod ?
I installed the Blod Mod v0.91

[amango]

do you think its better if the window closes automatically after posting?

Yes, I think it's useful - you don't end up in making multiple comments, if you press the button more then once. So the window should close automatically.

[amango]

How can I rejuvenate it and not add it as new mod ?
I installed the Blod Mod v0.91

Just uninstall it with BoardMod - drop the DB "Blogmod" with PHPMyAdmin.