I've taken Guganei's query to skip deleted blogs, and added a bit to only use blogs that are visible for everyone. Small change. I'm sure the entire module can be a lot more mature and intelligent but for now this works for me:
Code:$latestblogs = $db->query(" SELECT blogid, blog.title, blog_user.title AS blogname, username, dateline, userid, views FROM " . TABLE_PREFIX . "blog LEFT JOIN blog_user ON blog_user.bloguserid=blog.userid WHERE blog_user.deleted=0 AND blog_user.options_everyone=3 ORDER BY dateline DESC LIMIT 5
Change the path to blog.php in the blog_navbar_link template.
I got this error:
Database error in vBulletin 3.6.8:
### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO adv_modules
(`0`, `active`, `userperms`)
('', '1', '4,6,8,9,7,2,5,1,3');
MySQL Error : Unknown column '0' in 'field list'
Error Number : 1054
I had missed the "private entry" part in the last query. The following works perfect for me.
I dont think that the "blog_user.deleted=0" posted above is a safe way to filter deleted blog posts. Use "blog.state='visible' and blog.pending=0 and blog_user.options_everyone=3" instead.PHP Code:
SELECT blogid, blog.title, blog_user.title AS blogname, comments_visible, username, dateline, userid, views
FROM " . TABLE_PREFIX . "blog
LEFT JOIN blog_user ON blog_user.bloguserid=blog.userid
WHERE blog.state='visible' and blog.pending=0 and blog_user.options_everyone=3
ORDER BY dateline DESC
Hope that it works for you also.
can any help? how to install the module file?
hai gorp , i had the same error
install nostalgias module its working
imprezion --> to install module , goto admincp > vba cmps > Download / Upload Module
The file you have uploaded is not a valid module file.
I've tried both versions on 3.6.8 & neither function.
EDIT: I managed to get it to work by manually creating the php file, template, & module.
I will post full instructions when I get a chance.
Last edited by Buffer.OverRun; 11-07-2007 at 03:46 AM.
Got Nostalgia's module to work, but then I deleted it to try and make some visual changes to the module and reupload it and am now getting this error:
Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /admincp/vba_cmps_admin.php on line 3374
I reverted to his original code and reuploaded and it gives the same error.
What edit needs to be made in the modules>vb_blogs.php file to get the path in the module to link correctly? My cmps_index.php is in my '****.net/members/' directory, and the links to blogs and users are 'pointing' to ****.net/members/blog.php?=....
I tried changing all instances oftoCode:<a href=\"blog.php?.....****">****</a>";but that not only didn't work but wouldn't allow cmps_index.php to load at all....Code:<a href="http://www.****.net/forums/blog.php?.....****">****</a>";
other than that I had no problems installing the '2nd' module in this thread. No drafts or private blogs present at this time so I have encountered the problems with regard to those as mentioned in previous posts....
Last edited by Eq4bits; 11-10-2007 at 10:10 PM.
It claims it is not a valid module file (on RC2).
it loads fine here as well, but i can not get the links to the blogs to show the right directory. it just shows blog.php?b=1 etc instead of /forum/blog...
i've tried "hacking" the vb_blogs.php, i tried setting the module link to /forum/blog.php .. nothing helps :P
There are currently 2 users browsing this thread. (0 members and 2 guests)