vb.org Archive
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Administrative and Maintenance Tools - Hot Topics/Threads (https://vborg.vbsupport.ru/showthread.php?t=79757)

tnguy3n 04-10-2005 10:00 PM
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

tnguy3n 04-11-2005 05:23 AM
Oops sorry, post in wrong forum. Can mods pls move this hack to appropriate forum? thanks.

Allan 04-11-2005 11:39 AM
and one moreover, cheer have you, I very well also find it, good job :)

-=Sniper=- 04-11-2005 12:38 PM
nice and simple hack :) will use it.

JoeLouie 04-11-2005 03:34 PM
I followed the instructions, but it doesn't seem to work. Who I go to toptopics.php is says:

Quote:
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 04-11-2005 04:11 PM
that's weird. what version of vb you'r running?

JoeLouie 04-11-2005 04:17 PM
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 04-11-2005 04:33 PM
Quote:
Originally Posted by 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.
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 04-11-2005 04:41 PM
This is displaying the threads double here

JoeLouie 04-11-2005 04:46 PM
Quote:
Originally Posted by tnguy3n
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 04-11-2005 04:47 PM
im getting the same as JoeLouie but on vb 3.06

any ideas?

JoeLouie 04-11-2005 04:56 PM
just figured it out... in the grouptitle field you have the value in there... fixing it now.

xtreme-mobile 04-11-2005 05:03 PM
? whats up with it mate?

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

cheers mate

JoeLouie 04-11-2005 05:09 PM
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 04-11-2005 05:10 PM
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 04-11-2005 05:12 PM
if i cant get this to work, how do you remove the queries??? im new to all this

JoeLouie 04-11-2005 05:13 PM
The instructions said to do this:
Code:
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*:
Code:
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 04-11-2005 05:13 PM
sorry 3.07

tnguy3n 04-11-2005 05:18 PM
Quote:
Originally Posted by JoeLouie
The instructions said to do this:
Code:
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:
Code:
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 04-11-2005 05:19 PM
Mine are correct. Best to do is insert into settings('varname',...) values(....

Lionel 04-11-2005 09:37 PM
Any ideas yet about the double threads display?

tnguy3n 04-11-2005 10:49 PM
:confused: Did you make any change in the script? You alter vote to totalvote?

Lionel 04-11-2005 10:54 PM
none whatsoever. not in templates not in file. straight from downloading to my server.

dede1 04-12-2005 04:57 AM
Hello

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

pjdaley 04-12-2005 05:09 AM
Quote:
Originally Posted by dede1
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 04-12-2005 07:26 AM
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 04-12-2005 08:09 AM
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 04-13-2005 03:38 AM
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 04-19-2005 10:54 PM
this looks very nice...one question though...would it be possible to display the top threads from specific forums??

vakvak 04-21-2005 01:30 PM
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 04-21-2005 02:14 PM
Quote:
Originally Posted by JoeLouie

but it should be this*:
Code:
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 04-23-2005 03:25 PM
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 04-26-2005 07:28 AM
How do I place a link to the toptopic section from the forum home?

deb0 04-26-2005 10:21 AM
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 05-12-2005 09:54 PM
Quote:
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

http://img34.echo.cx/img34/5392/tp7yk.jpg
I have the same thing, an idea please ? :(

Allan 05-12-2005 10:59 PM
Quote:
Originally Posted by JoeLouie
The instructions said to do this:
Code:
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*:
Code:
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 05-14-2005 06:52 AM
grt hack
/me click install

Acers 05-14-2005 08:18 AM
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 05-14-2005 01:10 PM
@Acers, U R Da Man! Works flawlessly. thx.

Acers 05-14-2005 02:18 PM
glad to be of help mate :)


All times are GMT. The time now is 04:02 PM.
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03585 seconds
  • Memory Usage 1,839KB
  • 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
  • (7)bbcode_code_printable
  • (4)bbcode_php_printable
  • (8)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete