vBadvanced CMPS - Old Support Thread

Tigga - let me be the first to say what an absolutely outstanding hack this is. I've been using it now for about a month (or whenever you first released it on your website).

Installed and working great on 3.0.1. Fantastic work !!!! Waiting to vote for it on 'Hack of the Month'.



* Intex clicks INSTALL. Even though it was installed a few weeks ago .

[Scutter]

quick question regarding the last xxx posts. with the current version of vBAdvanced I use, users can still see the topics in this list whether they can access them or not, with this version can this list be restricted so that only topics they can access are displayed?

[mattster2002]

Hey Would dearly love to make a post here - Recently installed your hack and its very nice. I am upgrading from PHPNuke/PhpBB heavily modded (especially the theme). I found it was quite an effort to convert my phpnuke theme across, but well worth the effort. Just thought i might post one thing in the style system (for the borders).

I had to do a tiny bit of modding, but i think it'd be a good idea to have themes for blocks so you dont have to design each block individualaly, what i mean is a standard for blocks to be done, I've done a makeshift version that is just block_open module_content and block_close - works like a charm at the moment.

Love the module

[Tigga]

tccra - I'm pretty sure that should work. Just create the style, then select that style on your CMPS page in the admin cp.

Scutter - Your users should only be able to see the threads they have permission to see in either the CMPS or the Homepage. If not then you most likely have your forum permissions set incorrectly.

mattster2002 - I almost changed it so that all of the modules would be surrounded by one template where you could change that and have all of the module blocks change, but ended up not doing it mostly because I couldn't think of a good way to put the titles in the blocks when they contained links. I'm thinking I may just add those as phrases and change the way it's done in a future version though.

[DrkFusion]

Outstanding job Brian, the load was a +++++ for me to handle because of the required mods the site relies on with a little code optimization this hack is working sweet and very sound!

>> Clicks Install <<

[Tigga]

Why thank you sir.

[Scutter]

Originally Posted by Tigga

Scutter - Your users should only be able to see the threads they have permission to see in either the CMPS or the Homepage. If not then you most likely have your forum permissions set incorrectly.

settings are all OK and they can not access the posts, but they can see the topic titles which I do not want them to see. Is there a way to stop these showing or is it a case where I say only certain forums will show in the latest topics?

[Yuber]

Kickass, thanks for sharing. Any ideas on what future addon modules you'll be adding such as weather?

[PranK]

Originally Posted by Tigga

PranK - Seems to load at about the same speed as your forum's home for me. Do you have the 'Quick Moderation' module enabled? If so, that could slow it down on your account since it has to check a couple of tables. That would only affect mods and admins though since they're the only ones that can see the module.

Sorry mate, totally forgot about checking back here..

Ok sweet, well It does load quite slowly for me, but nobody else has complained about it, so it must just be the quick moderation.

Thanks Tigga!

Christian

[Garfield01]

It might be a great hack, but it don?t work to me
I get:

SELECT IF(votenum >= 2, votenum, 0) AS votenum, IF(votenum >= 2 AND votenum != 0, votetotal / votenum, 0) AS voteavg,
thread.threadid, thread.title, replycount, postusername, postuserid, thread.dateline AS postdateline, thread.lastposter, thread.lastpost, IF(views<=replycount, replycount+1, views) AS views, forumid, post.postid, pagetext, allowsmilie
, showsignature, usertextfield.signature
,thread.iconid AS threadiconid, iconpath AS threadiconpath
, avatarpath, NOT ISNULL(avatardata) AS hascustom, customavatar.dateline AS avatardateline, avatarrevision
, NOT ISNULL(subscribethread.subscribethreadid) AS subscribed
, attachment.filename, attachment.filesize, attachment.visible, attachmentid, counter, thumbnail, LENGTH(thumbnail) AS thumbnailsize
FROM thread AS thread
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN icon USING (iconid)
LEFT JOIN attachment AS attachment ON (post.postid = attachment.postid)
LEFT JOIN user AS user ON (user.userid = post.userid)

LEFT JOIN usertextfield AS usertextfield ON (post.userid = usertextfield.userid)

LEFT JOIN avatar as avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN customavatar as customavatar ON (customavatar.userid = user.userid)

LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = '59')
LEFT JOIN deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE forumid IN(93) AND thread.visible = 1 AND thread.open != 10 AND deletionlog.primaryid IS NULL
GROUP BY post.postid
ORDER BY postdateline DESC
LIMIT 4
mysql error: Column: 'iconpath' in field list is ambiguous

mysql error number: 1052

Can anyone help me please?
Edit: I?m using VB 3.0.3
Garfiled

[Tigga]

Sounds like you've got another hack installed that's clashing (maybe the forum specific icon's one?). If you'll look in your modules/news.php file for:

iconpath AS threadiconpath

And replace that with:

icon.iconpath AS threadiconpath

That should fix the problem.