vb.org Archive - Administrative and Maintenance Tools

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)

im getting the same as JoeLouie but on vb 3.06

any ideas?

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

? whats up with it mate?

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

cheers mate

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.

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.

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

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)

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.

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

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)bbcode_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01043 seconds Memory Usage 1,742KB 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 (4)bbcode_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)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
Messages: