The Arcive of Official vBulletin Modifications Site.

Week / Month Topic Nominations · **Released**: 09-18-2009

Week / Month Topic Nominations

Acknowledgments:
This release would not have been possible without the existence of the former ?Topic Nominations? by J98680B2423E (Data) and "Post Thank You" by Abe1, which provided the mod?s core structure. A nice set of button and awards images have also been provided by princeedward. You can view screenshots at the original mod's thread: VB 3.7 Topic Nominations

What is Topic Of The Week/Fortnight/Month?
It adds a "Topic Of The Week/Month" nomination system for your community.
Topic of the Week/Month is a contest that select posts on which your community can nominate as the best and then discuss them during the course of the selected week/fortnight /month. Any listed topic (post, thread) is eligible for the Topic of the Week/Fortnight /Month selection. This mod should also work in VB 3.7.x, but it has only been tested in VB 3.8.

Features of New 2.0 Version:

50+ bugs fixed & 30+ phrases changed for clarification.
Fixed ajax functionality for adding & removing nominations.
16 settings to determine which users can nominate and which posts can be nominated.
Documented this mod?s limitations & changelog in the 2nd post.
Fixed Hall of Fame to to correctly display most awarded members and topic winners from the past 3 contests (3 awards per contest).
Added new setting, max # of nominations user can receive, to prevent a poll being dominated by a single user.
Added new function to recount # of current nominations received and past awards.
Added new function to manually finalize the current contest, close the old poll thread, and create a new poll thread.
An option to enable blog nominations is available and should work (coded by Data), but is not supported (I do not have VB Blog).
You must have 3 VB default hooks in the postbit template: see troubleshooting below for details. If you ask for help with a problem, you must state in your post if you have reverted ALL nomination templates and read the troubleshooting tips in the 2nd post. If you haven?t, do so otherwise you will be ignored & can debug it yourself.

Installation instructions:

Upload the content of the "upload" folder into your forum root directory
Import the "product_nominate_topic.xml" product via your ACP:
ACP -> Plugins & Products -> Manage Product -> Add/Import Product (Allow overwrite for updating)
For upgrades only, REVERT ALL nominate_topic templates in ACP -> ?Find Updated Templates? or top FYI section of Control Panel. This mod will work only if ALL templates are reverted since major changes were done to them. Reapply custom phrasing to changed phrases as needed.
Adjust & save the mod settings to your preference in ACP -> VB Options. It is strongly recommended that you use the default, preset options.
Specify the Forum ID that will receive nomination threads and the Forum ID's for which posts can be nominated. Also specify the User ID of the nomination thread owner.
For new installs only, start a new nomination poll at:
ACP side menu -> Nominate Topic -> Special Actions -> Create New Poll Thread
Read the 2nd post for Troubleshooting Tips & Mod Limitations and the 3rd post for specific features of this mod.

Version History:
2.0.0: Initial Release.
2.0.2: Fixed table column bug.

MAKE SURE TO CLICK INSTALL

Thanks to everyone who nominated this mod for October, 2009 You can vote for this mod at: this thread.

vbboarder · #22 09-20-2009, 06:30 PM

Note: I added a new troubleshooting tip to the 2nd post about file uploading. Hope that helps.

1320Nation · #23 09-20-2009, 06:32 PM

Quote:

Database error in vBulletin 3.7.3:

Invalid SQL:
ALTER TABLE board_nominate_topic_thread ADD `is_manual` TINYINT(1) UNSIGNED DEFAULT '0' NOT NULL;

MySQL Error : Duplicate column name 'is_manual'
Error Number : 1060
Request Date : Sunday, September 20th 2009 @ 04:24:09 PM
Error Date : Sunday, September 20th 2009 @ 04:24:59 PM
Script : http://www.*****.com/forums/admincp/...=productimport
Referrer : http://www.*****.com/forums/admincp/...?do=productadd
IP Address : ***.***.27.224
Username : ******
Classname : vB_Database
MySQL Version : 5.0.45

I got the above error while importing the product. Any ideas for a cure?

vbboarder · #24 09-20-2009, 06:48 PM

@psychobike: read new post below for better solution.

AzzidReign · #25 09-20-2009, 07:22 PM

Nvm about it working with legacy. I get an error when I nominate (I didn't press the button last time, just checked to see if the button showed up):

PHP Code:


			
Invalid SQL:

UPDATE user SET nominate_topic_nominated_times = 1 + nominate_topic_nominated_times, nominate_topic_nominated_posts = 1 + nominate_topic_nominated_posts, nominate_topic_user_received = 1 + nominate_topic_user_received WHERE userid = '75422';

MySQL Error   : Unknown column 'nominate_topic_user_received' in 'field list'
Error Number  : 1054
Request Date  : Sunday, September 20th 2009 @ 03:21:06 PM
Error Date    : Sunday, September 20th 2009 @ 03:21:06 PM
Script        : http://www.se7ensins.com/forums/nominate_topic.php
Referrer      : http://www.se7ensins.com/forums/firmware-hack-tutorials/147269-got-my-kit-my-probe-nothing-else-but-continuos-green-light-and-no-usb-support-hel.html
IP Address    : ************
Username      : AzzidReign
Classname     : vB_Database
MySQL Version : 4.1.22-standard</textarea></form>

Not sure if it is a legacy problem or not...

And then any time I try to use one of the special actions:

PHP Code:


			

Invalid SQL:
UPDATE user SET nominate_topic_user_amount = 0, nominate_topic_user_received = 0 WHERE '1';

MySQL Error   : Unknown column 'nominate_topic_user_received' in 'field list'
Error Number  : 1054
Request Date  : Sunday, September 20th 2009 @ 03:25:50 PM
Error Date    : Sunday, September 20th 2009 @ 03:25:52 PM
Script        : http://www.se7ensins.com/forums/admincp/cronadmin.php?do=runcron&cronid=95
Referrer      : http://www.se7ensins.com/forums/admincp/nominate_topic_admin.php?do=executenominationcron
IP Address    : ***************
Username      : AzzidReign
Classname     : vB_Database
MySQL Version : 4.1.22-standard

vbboarder · #26 09-20-2009, 07:40 PM

@AzzidReign:

Thanks for testing. Here's the fix: you can do it manually or wait for the updated xml - same results either way. The problem only happens for updated installs. To fix, go to ACP -> Plugins & Products -> Manage Product -> Edit Product (for Topic Nominations) -> ADD to the "2.0.0 Install Code" and make sure you click the BOTTOM "Save" button:

Code:

$vbulletin->db->query_write("ALTER TABLE `". TABLE_PREFIX ."user` ADD `nominate_topic_user_received` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL");

TimberFloorAu · #27 09-20-2009, 07:48 PM

We use the original coders TOTW nomination system, its our most popular feature.

However, we have always had the issue of having to run the cron manually, i think this was an ongoing issue with this mod.

Furthermore, can you please confirm that cron on weekly basis NOW works for this NEW mod...

Also what is the process for upgrading from OLDER mod to this NEW mod... will we lose anything ?

1320Nation · #28 09-20-2009, 07:48 PM

Quote:

Originally Posted by vbboarder

@psychobike:

That really strange you got that error. If you look at the line that say "mysql error", you see that it says "Duplicate column name 'is_manual'. That's should not happen because previous versions do not have that column. Did you manually add that column to the database? In any case, the fix is simple: FIRST: verify with phpMyAdmin or MySql Browser that you have the column 'is_manual' for the 'nominate_topic_thread' table, THEN go to ACP -> Plugins & Products -> Manage Product -> Edit Product (for Topic Nominations) -> REMOVE from the "2.0.0 Install Code" and make sure you click the BOTTOM "Save" button:

Code:

$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."nominate_topic_thread ADD `is_manual` TINYINT(1) UNSIGNED DEFAULT '0' NOT NULL");

Ok I did what you suggested.

I use postbit legacy. I tried the mod out by nominating a thread. I then clicked on the "View Poll" option and it directs me to a page that says "The Administrator(s) did not defined a receiving forum for hosting poll results of the TOTW/TOTM contest". I do not see this option available in the acp vb options anywhere. What needs to be done to get this working.
Btw, I do have a forum option selected where it says...
Forum:
Specify the ID of the forum that will receive threads containing results of the nomination contest.

AzzidReign · #29 09-20-2009, 07:48 PM

Still getting:

PHP Code:


			
Invalid SQL:
UPDATE user SET nominate_topic_user_amount = 0, nominate_topic_user_received = 0 WHERE '1';

MySQL Error   : Unknown column 'nominate_topic_user_received' in 'field list'
Error Number  : 1054
Request Date  : Sunday, September 20th 2009 @ 03:48:00 PM
Error Date    : Sunday, September 20th 2009 @ 03:48:01 PM
Script        : http://www.se7ensins.com/forums/admincp/nominate_topic_admin.php?do=createnewpollthread
Referrer      : http://www.se7ensins.com/forums/admincp/nominate_topic_admin.php?do=special_actions
IP Address    : 
Username      : AzzidReign
Classname     : vB_Database
MySQL Version : 4.1.22-standard

That is when I try to create a new poll.

vbboarder · #30 09-20-2009, 07:58 PM

@psychobike: wait for the updated xml, then apply the fix below.

That really strange you got that error. If you look at the line that say "mysql error", you see that it says "Duplicate column name 'is_manual'. That's should not happen because previous versions do not have that column. Did you manually add that column to the database? In any case, the fix is simple: FIRST: verify with phpMyAdmin or MySql Browser that you have the column 'is_manual' for the 'nominate_topic_thread' table, THEN remove from product_nominate_topic2.xml and reinstall (allow overwrite):

Code:

$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."nominate_topic_thread ADD `is_manual` TINYINT(1) UNSIGNED DEFAULT '0' NOT NULL");

vbboarder · #31 09-20-2009, 08:05 PM

@AzzidReign:

Did you save using the BOTTOM "Save" button? Note that the top button does not save edits to install code. Verify with phpMyAdmin or MySql browser that you have the column 'nominate_topic_user_received' in the 'user' table. If you look at the query that you should have added, it says to add that column to the 'user' table:

Code:

$vbulletin->db->query_write("ALTER TABLE `". TABLE_PREFIX ."user` ADD `nominate_topic_user_received` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL");

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.08169 seconds Memory Usage 2,366KB Queries Executed 27 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (4)bbcode_code (3)bbcode_php (2)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (4)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (1)postbit_attachment (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_attachment postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!