Top Topics/Threads

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

This is port of my vb3.0 Top/Topics/Threads

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.

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