Hot Topics/Threads

[tnguy3n]

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 (https://vborg.vbsupport.ru/showthread.php?t=78751)

[tnguy3n]

Oops sorry, post in wrong forum. Can mods pls move this hack to appropriate forum? thanks.

[Allan]

and one moreover, cheer have you, I very well also find it, good job :)

[-=Sniper=-]

nice and simple hack :) will use it.

[JoeLouie]

I followed the instructions, but it doesn't seem to work. Who I go to toptopics.php is says:

JoeLouie, you do not have permission to access this page. This could be due to one of several reasons:

1. Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
2. If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

If I go to the settings all I see is "Top Topics Settings" with the save and reset button... no actual settings. I've looked through the instructions a few times and can't see what I missed. Any help?

[tnguy3n]

that's weird. what version of vb you'r running?

[JoeLouie]

sorry, shoulda mentioned that. I'm running 3.0.7.

I must have looked over the instructions 20 times by now and can't find any steps that I missed.

[tnguy3n]

sorry, shoulda mentioned that. I'm running 3.0.7.

I must have looked over the instructions 20 times by now and can't find any steps that I missed.
It must be the queries in setting table that messes this hack up. Can you browse your vb setting table in phpMyAdmin, then post (or PM) settings of this hacks? It should be last 7 settings.

[Lionel]

This is displaying the threads double here (http://www.haitiwebs.com/haitianforums/toptopics.php)

[JoeLouie]

It must be the queries in setting table that messes this hack up. Can you browse your vb setting table in phpMyAdmin, then post (or PM) settings of this hacks? It should be last 7 settings.

How's this?

[xtreme-mobile]

im getting the same as JoeLouie but on vb 3.06

any ideas?

[JoeLouie]

just figured it out... in the grouptitle field you have the value in there... fixing it now.

[xtreme-mobile]

? whats up with it mate?

how can i fix mine also mate can you give me the instructions lol

cheers mate

[JoeLouie]

yep, just give me a few minutes, gotta test it to make sure I fixed it right :)

EDIT: Check the 2nd page, I posted the fix there. Some people seem to have gotten it working without the fix, but I'm running 3.0.7 and it wouldn't work without it.

[tnguy3n]

Settings seems right. I doubt if settinggroup got anything do with that error thou.
I'll write installers for next time to prevent these problems.

@Lionel: I can't figure out at the moment why it print a thread twice. I may use SELECT DISTINCT in next release if it fix that problem. btw, it may help to track the bug if you could provide version of vb you'r running.

[xtreme-mobile]

if i cant get this to work, how do you remove the queries??? im new to all this

[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)

[Lionel]

sorry 3.07

[tnguy3n]

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);
Interesting! I wrote this hack on dev board (3.0.7) on my PC, then installed it on v.3.0.5, I got that same problem as you guys described and I had to manually change those values. I doubt if the structure of vb setting table got changed since version 3.0.5.

[Lionel]

Mine are correct. Best to do is insert into settings('varname',...) values(....

[Lionel]

Any ideas yet about the double threads display?

[tnguy3n]

:confused: Did you make any change in the script? You alter vote to totalvote?

[Lionel]

none whatsoever. not in templates not in file. straight from downloading to my server.

[dede1]

Hello

I get only a white side, look:
http://www.dede1.mine.nu/Board/toptopics.php

[pjdaley]

Hello

I get only a white side, look:
http://www.dede1.mine.nu/Board/toptopics.php

check your templates, make sure you did them right.

[DR?@M W?@V?R]

nice mod, thanks for the database update. I noticed that there was 4 uncached templates, under.

$specialtemplates = array();

I put.

$globaltemplates = array(
'TOPTOPICS',
'toptopics_highvote',
'toptopics_mostreplies',
'toptopics_mostviews');

And I had to require the back-end after this or it would not pre-cache.

// #################### DEFINE IMPORTANT CONSTANTS #######################
//define('NO_REGISTER_GLOBALS', 1);
//define('THIS_SCRIPT', 'toptopics');

// ################### PRE-CACHE TEMPLATES AND DATA ######################
// get special phrase groups
$phrasegroups = array();

// get special data templates from the datastore
$specialtemplates = array();

$globaltemplates = array(
'TOPTOPICS',
'toptopics_highvote',
'toptopics_mostreplies',
'toptopics_mostviews');

// ######################### REQUIRE BACK-END ############################
require_once('./global.php');

[DR?@M W?@V?R]

how would you apply permissions to view topics, as 2 threads I have are in the admin forum and I dont want guest to view them.

http://www.majesticforum.com/forum/toptopics.php

[dede1]

If guests the side see comes may only the white side may guests you do not see comes no rights.

Where is the mistake there?

[Nordinho]

this looks very nice...one question though...would it be possible to display the top threads from specific forums??

[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

https://vborg.vbsupport.ru/external/2005/05/16.jpg

[vakvak]

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]

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

http://img34.echo.cx/img34/5392/tp7yk.jpg

I have the same thing, an idea please ? :(

[Allan]

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
// ######################## START MAIN SCRIPT ############################

added below

$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

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

and add below

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 :)

[organik81]

I have the same problem too; in #35'th post...

[lefthome]

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);


Installed the hack and found out these were wrong. Can somebody tell me how to remove these so I install the correct ones?

[lairnoc]

will there be a port to 3.5 ?? i really love this hack..

[tnguy3n]

will be released later of the day. ;)