Administrative and Maintenance Tools - Hot Topics/Threads

Author: tnguy3n (Thinh Nguyen)
Support Site: http://www.all4a-designs.com
Live Demo: http://www.all4actions.net/forums/toptopics.php (click on the link to see demo on my site)

Description:
This hacks show hot threads/topics on one page. Admins have ability to enable/disable guest access, select which blocks display on the page.

New settings: 7
Template Mods: 4 new templates
File Mods: 0
New File: 1

Requested by Aceman here

[vakvak]

Originally Posted by JoeLouie

but it should be this*:

INSERT INTO `setting` VALUES ('toptopics_limit', 'toptopics', '5', '5', '', 7, 0, 0);
INSERT INTO `setting` VALUES ('toptopics_titlecut', 'toptopics', '120', '120', '', 5, 0, 0);
INSERT INTO `setting` VALUES ('toptopics_highvote', 'toptopics', '1', '1', 'yesno', 4, 0, 0);
INSERT INTO `setting` VALUES ('toptopics_mostreplies', 'toptopics', '1', '1', 'yesno', 2, 0, 0);
INSERT INTO `setting` VALUES ('toptopics_mostviews', 'toptopics', '1', '1', 'yesno', 3, 0, 0);
INSERT INTO `setting` VALUES ('toptopics_noguest', 'toptopics', '1', '1', 'yesno', 1, 0, 0);
INSERT INTO `setting` VALUES ('toptopics_forumcut', 'toptopics', '160', '160', '', 6, 0, 0);

* That's what I had to change to get this working on my board running vB 3.0.7 (http://board.optical-edge.net/toptopics.php)

thank you my friend yes should be this

[deb0]

I'm getting this error after following the instructions:

Database error in vBulletin 3.0.6:

Invalid SQL: SELECT thread.threadid, thread.title AS threadtitle, thread.lastpost, thread.forumid, thread.open, thread.replycount, thread.postusername, thread.postuserid, thread.lastposter, thread.dateline, thread.visible, forum.forumid, forum.title AS forumtitle, user.username, user.userid AS lastposterid
FROM thread
LEFT JOIN forum AS forum ON(forum.forumid = thread.forumid)
LEFT JOIN user AS user ON(user.username = thread.lastposter)
WHERE thread.open = 1
AND thread.visible = 1
ORDER BY thread.replycount DESC
LIMIT 0,

mysql error: 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 8

mysql error number: 1064

[kthlnwrnr]

How do I place a link to the toptopic section from the forum home?

[deb0]

This is an awesome hack. I just have one biggy request that's missing: Is it possible to include a setting that allows you to exclude/include forums?

I want it to only list the 'non-entertainment' forums in my site.

[Allan]

Originally Posted by vakvak

thank...

But problem

Problem vbulletin options/top topics setting

settings not
Upload toptopics.php to your /forum home :::::::: ok
Sql ::::::: ok
4 new template :::::::: ok

but view not: help pls

I have the same thing, an idea please ?

[Allan]

Originally Posted by JoeLouie

The instructions said to do this:

INSERT INTO `setting` VALUES ('toptopics_limit', '5', '', 7, 'toptopics', '5', 0, 0);
INSERT INTO `setting` VALUES ('toptopics_titlecut', '120', '', 5, 'toptopics', '150', 0, 0);
INSERT INTO `setting` VALUES ('toptopics_highvote', '1', 'yesno', 4, 'toptopics', '1', 0, 0);
INSERT INTO `setting` VALUES ('toptopics_mostreplies', '1', 'yesno', 3, 'toptopics', '1', 0, 0);
INSERT INTO `setting` VALUES ('toptopics_mostviews', '1', 'yesno', 2, 'toptopics', '1', 0, 0);
INSERT INTO `setting` VALUES ('toptopics_noguest', '1', 'yesno', 1, 'toptopics', '1', 0, 0);
INSERT INTO `setting` VALUES ('toptopics_forumcut', '160', '', 6, 'toptopics', '150', 0, 0);

but it should be this*:

INSERT INTO `setting` VALUES ('toptopics_limit', 'toptopics', '5', '5', '', 7, 0, 0);
INSERT INTO `setting` VALUES ('toptopics_titlecut', 'toptopics', '120', '120', '', 5, 0, 0);
INSERT INTO `setting` VALUES ('toptopics_highvote', 'toptopics', '1', '1', 'yesno', 4, 0, 0);
INSERT INTO `setting` VALUES ('toptopics_mostreplies', 'toptopics', '1', '1', 'yesno', 2, 0, 0);
INSERT INTO `setting` VALUES ('toptopics_mostviews', 'toptopics', '1', '1', 'yesno', 3, 0, 0);
INSERT INTO `setting` VALUES ('toptopics_noguest', 'toptopics', '1', '1', 'yesno', 1, 0, 0);
INSERT INTO `setting` VALUES ('toptopics_forumcut', 'toptopics', '160', '160', '', 6, 0, 0);

* That's what I had to change to get this working on my board running vB 3.0.7 (http://board.optical-edge.net/toptopics.php)

Ok, I had not seen this part

@tnguy3n: You should modify your file to attach

Thank you for the second time (post #3) for your hack.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Click install
~~~~~~~~~~~~~~~~~~~~~~~~~~~~

[Acers]

grt hack
/me click install

[Acers]

hey guys... i just found that this is taking all threads from all the forums.
So to protect the private forums..i did this
in the toptopics.php below line

PHP Code:

// ######################## START MAIN SCRIPT ############################ 


added below

PHP Code:

$excludedforums = "48,34"; // forums to be excluded from latest threads. Format "0,1,2,3" 


i have taken 48,34 as an example. these are the forum ids btw

then in same file find

PHP Code:

WHERE thread.open = 1
AND thread.visible = 1 


and add below

PHP Code:

AND thread.forumid NOT IN ($excludedforums) 


did this for all three occurences in that page.

Now forums are safe from all private forum posts showing there.
Btw same can be extended to whatever forums you wanna hide. say if you just want this to work for one forum exclude all the rest forums.

[deb0]

@Acers, U R Da Man! Works flawlessly. thx.

[Acers]

glad to be of help mate