Top Topics/Threads

[tnguy3n]

Author: tnguy3n
Live Demo: http://www.vbviet.org/vb35/toptopics.php

This is port of my vb3.0 Top/Topics/Threads (https://vborg.vbsupport.ru/showthread.php?t=79757)

Description:
This hack pulls out from database most viewed, most replied, and high rated topics, and display them 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

#########
UPGRADE

If you had previously installed my Top Topics/Threads for vb3.0, you don't need to run the queries again. All you have to do is upload (and overwrite) the toptopics.php file.

[michaelbenson]

I like it, nice idea.
Sort of like a mini statistics page

/me says yey, install #1

[TTG]

Should there be a plugin / product in the zip ?

[tnguy3n]

Should there be a plugin / product in the zip ?

that's why it's called extension. :p
well, i think you can make this as a plugin too, but it still runs the same number of queries.

[TTG]

that's why it's called extension. :p
well, i think you can make this as a plugin too, but it still runs the same number of queries.

ok thanks .. but there are no options in admincp to allow viewing the toptopics !?

You are not logged in or you do not have permission to access this page. This could be due to one of several reasons:

[tnguy3n]

ok thanks .. but there are no options in admincp to allow viewing the toptopics !?

Look for Top Topics in vBulletin options.

[TTG]

Look for Top Topics in vBulletin options.

That's where I thought it would be, but it 'aint there !

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: 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 ';

INSERT INTO `setting` VALUES ('toptopics_noguest', 'toptopics', '1', '1', '' at line 1

[Snake]

Thanks, like the hack. :)

[lazytown]

Something is missing from the Zip file. I installed it correctly, however, in the AdminCP under TopTpics, there are no options at all, just a heading for TopTopics. I'm assuming there are supposed to be some options there.

When I go direclty to the toptopics.php file I get

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

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?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.
-----

Please DL the file and see if I am missing something, because I don't see where in any of the files or directions the adminCP would have settings.

-vissa

[lazytown]

I think the problem may be with the SQL inserts.

[lazytown]

I disabled the "no permission" setting to get the script to run, and received the following error

Database error in vBulletin 3.5.0:

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
Error Number : 1064
Date : Sunday, October 30th 2005 @ 11:29:18 PM
Script : XXX
Referrer :
IP Address : XXX
Username : XXX
Classname : vb_database

-vissa

[lazytown]

The provided phpmyadmin SQL statements are whacked... They won't work for most people (at least on 3.5 gold)... Anyone got this to work? what did you change?

-vissa

[tnguy3n]

sorry if that doesn't work for you.
I'll put it into product manager if that helps you with the installation (of course, only when I have time).

[Snake]

The SQL queries do not work. Please fix it asap.

[Snake]

This is funny. Now I get this error permission.

Aftermath, 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.

[Allan]

Thanks but no display :(

[Snake]

Bump.

[Snake]

Bump!!!

[Allan]

The problem with your hack, it is because the members can see the private forums

[Snake]

Nope, they cannot view the private forums. I have just logged into the admincp and check whether they can or not. The option was set to "No" already. So what's the problem? :)

[Allan]

the members can see the private forums but no enter it

[Snake]

Anyone please?

[Snake]

Anyone?

[Snake]

I just don't get it lol.

[Snake]

Bump!

[Snake]

<font size="5">Bump!!!</font>

[Snake]

Man I feel like beating the shit out of this hack!

[mlx]

If you are using a vBulletin MySQL Table Prefix make sure to edit those queries in toptopics_vb35_instruction.txt (change `settinggroup`, `setting` & `phrase` to whatever your tables are actually called).

Also make sure to edit toptopics.php and change (3 times!):
FROM " . TABLE_PREFIX . "thread

to:
FROM " . TABLE_PREFIX . "thread AS thread

Otherwise it won't work with a TABLE_PREFIX.

[adhesive]

cool instaled

[lazytown]

This is actually a pretty good little top threads hack/mod once you figure out how to get it working. I would love to see an update to this (perhaps fixed as a plugin). More features like the ability to have the top threads in specifc forums listed separately (based on specific criteria or a combination of them) would be killer.

-vissa

[thenetbox]

Has any one tried this with 3.6?