vBulletin Blog - Blog Comments vBAdvanced CMPS

One of the main problems with the vB blog module is its poor integration with the main forum. This module allows you to show the last 5 blog comments in a module on your vba portal page.

Features
Comments will not display if they have not been approved.

Instructions
Click install and download the attached zip file
Edit comments.php and change the variables to allow connection to your database.
Edit cmps_comments_block.php and change the path.
Upload comments.php to your forum directory.
Upload cmps_comments_block.php to your modules directory.

From your admincp - vba cmps
Add new module
PHP file
Title - call it what you want
Active - yes
File to include - cmps_comments_block.php
Identifier - call it what you want
Link - choose either blog home or comments page as you wish
Save and add to the page of your choice, the module has been designed to be a left or right block.

[optrex]

The only links that appear are

"comments" and the "username" , so you need to change www.mysite.com to blogs.mysite.com in comments.php to get the paths correct

[carrlos]

Originally Posted by optrex

If you want help, you need to click install, but to give you a clue, your path is wrong.

Can you tell me what my path should look like? I really like the hack and would really like to have it work. You're help is appreciated.

BTW, I originally clicked "Installed" but when I couldn't get it to work, I then clicked "Uninstalled".

[optrex]

/path/to/forum/comments.php

change /path/to/forum/

to your forum path

[yotsume]

I tried your mod. Entered my correct database info but it didn't work.

It gives me this message in the block: Table 'dbxxxxxxxxxxx.blog_text' doesn't exist

So what did I miss? Your instructions are lacking and how you commented inside your files is also not clear enough.

Hope you can help.

THANKS!

[yotsume]

Originally Posted by optrex

check your main DB and look for the table blog_text
It thinks its missing. If you can see it then your reference to the DB is wrong

What do you mean your reference to the DB is wrong? What reference and where? How about real instructions please.

That listing for me shows as: vb_blog_text

My table prefix is the default. vb_

So what gives here?

[yotsume]

I need to bump here because I really need to get this block to work on my CMPS for my site. Can anyone help me out here?

THANKS!

[tormodg]

Getting only white pages. Verified correct db settings and forum path.

[yotsume]

Originally Posted by tormodg

Getting only white pages. Verified correct db settings and forum path.

Yea this module would be great if iit worked and the instructions were better written. Be even been if it was ACTUALLY supported! I've been waiting for help but get nothing!

The VB Blog system needs more modules design by better coders. The people over at VBA need to design the mods directly! We desperately need better blog full integrated mods asap!

What I am going to do is look at the people who have posted in this thread and PM them for help and ask if they have got this to work and how...

[yotsume]

Where in the code do you set your table prefix? Your instructions inside the file lack. Please give better specific instructions so maybe one person can get this to work!

// You may need to change the db_table_prefix if you altered it from default to something else or removed it
$result = mysql_query("SELECT username,title,pagetext,dateline,state,userid,blogtextid
FROM blog_text
WHERE title = ''
    AND state = 'visible' 
ORDER BY dateline desc 
LIMIT 5" ) or die(mysql_error());
while($row = mysql_fetch_array( $result )) {

I tried my table prefix in here: WHERE title = '' like WHERE title = 'vb_'

Nothing I do works and my error remains: Table 'db218080794.blog_text' doesn't exist

My paths seems to be correct and my database info is correct.

Some help please. Unfortunately this is the only mod for blog comments. It says beta but you did set it as supported so please support it!

[yotsume]

// You may need to change the db_table_prefix if you altered it from default to something else or removed it
$result = mysql_query("SELECT username,title,pagetext,dateline,state,userid,blog textid
FROM " . TABLE_PREFIX . " blog_text

Thsi mod will not work because the designer left out any way for all of us to enter in our table prefix in this line of code. For this mod to work and not spit back this error:

Table 'dbxxxxxxxxxxx.blog_text' doesn't exist

This mod needs the proper code for calling the table prefix. Anything I have tried does not work. Can anyone post the correct line of code here to the blog_txt table will include our correct vb_ prefix?

I don't know how to get the correct table prefix code entered on this line. I have compared this to the recent blog mod for VBA but that hasn't helped me.

Just telling people here their url is wrong and database info is wrong is poor advise when the original code in comments.php is missing vital code need to make this mod work in the first place.

Hello community wake up and lets fix this because we all need real blog blocks ASAP!