vb.org Archive - Top Topics/Threads

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)

- - Top Topics/Threads (https://vborg.vbsupport.ru/showthread.php?t=99397)

tnguy3n

10-25-2005 10:00 PM

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.

michaelbenson

10-26-2005 09:40 PM

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

/me says yey, install #1

TTG	10-27-2005 12:17 AM

Should there be a plugin / product in the zip ?

tnguy3n

10-27-2005 12:40 AM

Quote:

Originally Posted by TTG

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	10-27-2005 12:44 AM

Quote:

Originally Posted by tnguy3n

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

Quote:

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

10-27-2005 01:20 AM

Quote:

Originally Posted by TTG

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

Look for Top Topics in vBulletin options.

TTG	10-27-2005 03:02 AM

Quote:

Originally Posted by tnguy3n

Look for Top Topics in vBulletin options.

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

Code:

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

10-27-2005 06:41 PM

Thanks, like the hack. :)

lazytown

10-31-2005 05:11 AM

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

10-31-2005 05:22 AM

I think the problem may be with the SQL inserts.

lazytown

10-31-2005 05:31 AM

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

Quote:

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

10-31-2005 05:41 AM

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

11-01-2005 08:54 AM

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

11-02-2005 10:45 AM

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

Snake

11-02-2005 01:46 PM

This is funny. Now I get this error permission.

Quote:

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

11-05-2005 08:41 AM

Thanks but no display :(

Snake

11-05-2005 06:13 PM

Bump.

Snake

11-06-2005 06:17 PM

Bump!!!

Allan

11-08-2005 07:21 PM

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

Snake

11-09-2005 09:07 AM

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

11-09-2005 10:04 AM

the members can see the private forums but no enter it

Snake

11-13-2005 01:08 PM

Anyone please?

Snake

11-25-2005 05:05 PM

Anyone?

Snake

11-26-2005 03:21 PM

I just don't get it lol.

Snake

01-04-2006 04:38 PM

Bump!

Snake

01-24-2006 12:22 PM

Snake

01-27-2006 10:43 AM

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

mlx	02-17-2006 11:49 PM

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

PHP Code:


		
			
FROM " . TABLE_PREFIX . "thread

to:

PHP Code:


		
			
FROM " . TABLE_PREFIX . "thread AS thread

Otherwise it won't work with a TABLE_PREFIX.

adhesive

02-18-2006 02:09 AM

cool instaled

lazytown

07-01-2006 02:06 AM

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

07-16-2006 01:50 PM

Has any one tried this with 3.6?

All times are GMT. The time now is 02:20 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01184 seconds Memory Usage 1,779KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (2)bbcode_php_printable (7)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (31)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: