Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.0 > vBulletin 3.0 Full Releases
Reload this Page TOTW: Thread of the Week Poll - Version 1.16
FAQ Community Calendar Today's Posts Search

Reply
Page 4 of 13 « First 23 4 56 Last »
 
Thread Tools
TOTW: Thread of the Week Poll - Version 1.16 Details »»
TOTW: Thread of the Week Poll - Version 1.16
MOD Information
The Developer
 
Version: 1.16, by Marco van Herwaarden Marco van Herwaarden is offline
Developer Last Online: Dec 2010 Show Printable Version Email this Page
Version: 3.0.7 Rating:
Released: 01-19-2005 Last Update: 04-12-2005 Installs: 39
DB Changes
 
No support by the author.

Thread of the Week Poll - Version 1.16

Description
With this hack it is possible to setup an automated system for electing a "Thread of the Week". Based on 1 or more rules you define it will select a number of threads from your board and will post a poll to let your members select their favourite thread.

This hack was written based on a requestion made here previously: https://vborg.vbsupport.ru/showthread.php?t=63969

Tested on
- vB 3.0.7
- vB 3.0.6
- vB 3.0.5
- vB 3.0.3 (Will probably also work on earlier versions)

Install Information
Installation using HIS installer included (HIS by Link14716 https://vborg.vbsupport.ru/showthrea...staller+system)
Uninstaller included
Install time: 2 minutes, easy
File edits: 0
Template edits: 0
Database modifications: 2 new tables

Features
  • Can run 1 or more Rules for selecting threads to include in Poll
  • Forums to be scanned for candidate threads can be selected.
  • Selection of candidate threads is done based on views and replies. The 'weight' of these selection criteria is settable for every rule.
  • Poll's are fully configurable (Posted as user, Thread title, Poll question, number of options)
  • Polls are automatic closed when a new poll is started
  • Polls can be generated on a settable interval. Interval can be given in days or weeks. Alternativle a new poll can also be generated on a fixed day every month.
  • uCash Integration. Activate in ACP Settings if you have uCash installed
  • Setable uCash price money for place 1, 2 and 3.
  • Date selection based on Thread Start Date or Last Reply Date. Selection can be made for every Rule.
  • Optional result post on closing of Poll, user configurable text.
  • Thread title with replacement variables. See Admin help!!
  • Poll title with replacement variables. See Admin help!!
  • Result post with replacement variables. See Admin help!!
  • Help added to the Admin screen.
  • .......
To be included in future releases
If enough request i am think of the following to add in a future release. More suggestions are welcome
- Integration with more existing Award system, already rewards possible using uCash
- More selection criteria

Support
Support will be given in this thread.

If you have problems, please first check the following:
- Did you set the uCash/uShop correct in ACP->vB Options->Thread of the Week (On/Off)
- Turn on logging in the Scheduled Taks for Thread of the Week. Check the Scheduled Task Log for any messages.

If you still have problems, please post the following information, so i can quickly try to help you:
- vBulletin version
- PHP and MySQL Version
- Version of this hack
- The schedule options you have set in the Rule Manager
- Selection Options
- When is it scheduled to run in the Scheduled Task Manager
- Any other relevant information

Thanks to
A big thanks to link14716 for the installer and to trafix for letting me use a script as a starting point for the admin settings, saved me a lot of time.

Also a huge thanks to sabret00th for testing (now i got someone to blame if there are still any errors left ).


Donations
I will not charge for this hack. But if you like it and are looking for a way to spend your money, paypal donations are always welcome (marcoh64@msn.com)

Please click Install if you are using this hack

Change log:
Version 1.16:
- Fixed bugs in updating Username/Userid/Thread Title in posted thread and forum info
- Removed 2 unneeded queries
- Added replacement variables for Thread Title:
- {date} - Current date formatted according to vB settings
- {beginofweek} - Date (formatted) of the start of the current week (sunday is start)
- {endofweek} - Date (formatted) of the end of the current week (saturday is end)
- {beginofweekmon} - Date (formatted) of the start of the current week (monday is start)
- {endofweekmon} - Date (formatted) of the end of the current week (sunday is end)
- Added {date} replacement variable to Poll Title
- Made all replacement variables case-insensitive
- Admin Help pages updated accordingly

Version 1.15:
- Add the option to override the default calculation for the cutoff date when selecting candidates. Now possible to enter a number of days to go back when selecting candidates.

Version 1.14:
- Bug that would make the cronjob crash if the current poll thread was deleted.
- Fixed version number in Manager script

Version 1.13:
- uCash Integration. Activate in ACP Settings to show them.
- Setable uCash price money for place 1, 2 and 3.
- Date selection can now be based on Thread Start Date or Last Reply Date. Selection can be made for every Rule.
- Optional result post on closing of Poll, user configurable text.
- Thread title with replacement variables. See Admin help!!
- Poll title with replacement variables. See Admin help!!
- Result post with replacement variables. See Admin help!!
- Help added to the Admin screen.
- Some minor modifications and bug fixes
- Removed debugging lines
- Scheduled task will now log information on the processing of the Rules in the Scheduled Task Log
- INSTALLER WILL ALSO UPGRADE FROM PREVIOUS VERSIONS, SEE UPGRADE NOTES.

Version 1.12:
- Fixed bug where threadoftheweek.php would not run correct (or even generate a database error) when running through the scheduler (as oppsed to running it with "Run Now")
- Added loads of debug information. To activate debugging, change includes/cron/threadoftheweek.php and uncomment the line "// $TOTW_DEBUG = TRUE;". Debug lines will go to the Scheduler log.
- Forum counters will now be updated when a new poll is posted.
- Fixed bug where "Run on day x of month" didn't work.
- Some minor changes
- The first time the rule is run, only threads with a last postdate in the time interval which is set for the rule will be selected as Candidates. In the older versions all threads where considered on the first run.

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #47  
Old 02-05-2005, 08:38 PM
sabret00the's Avatar
sabret00the sabret00the is offline
 
Join Date: Jan 2003
Location: London
Posts: 5,268
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by MarcoH64
My excuses for all that have been waiting for a fix to this hack, but i have hardly been online due to some unexpected family things i had to take care of.

With the help of the debug information provided by 'docvader' (thanks for this) i finally pinned the problem down to a strange difference in the way a Cron Job handles variables when using the "Run Now" or when it is run started by the Scheduler. This is sorted now and should solve all the problems mentioned in this thread.

I decided to release this now and not to wait until uShop integration will be finished, because it makes the hack almost useless without.

You can simply patch your installation by replacing the "includes/cron/threadoftheweek.php" with the new supplied version 1.12.


Changes in this version:
- Fixed bug where threadoftheweek.php would not run correct (or even generate a database error) when running through the scheduler (as oppsed to running it with "Run Now")
- Added loads of debug information. To activate debugging, change includes/cron/threadoftheweek.php and uncomment the line "// $TOTW_DEBUG = TRUE;". Debug lines will go to the Scheduler log.
- Forum counters will now be updated when a new poll is posted.
- Fixed bug where "Run on day x of month" didn't work.
- Some minor changes
- The first time the rule is run, only threads with a last postdate in the time interval which is set for the rule will be selected as Candidates. In the older versions all threads where considered on the first run.
in the next version can it use the thread-create-date instead of the last post date.
Reply With Quote
  #48  
Old 02-05-2005, 09:23 PM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Optional maybe?
Reply With Quote
  #49  
Old 02-08-2005, 09:13 PM
The Geek's Avatar
The Geek The Geek is offline
 
Join Date: Sep 2003
Location: Behind you
Posts: 2,779
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Nice 1

*The geek toggles his install switch
Reply With Quote
  #50  
Old 02-09-2005, 09:59 AM
sabret00the's Avatar
sabret00the sabret00the is offline
 
Join Date: Jan 2003
Location: London
Posts: 5,268
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by MarcoH64
Optional maybe?
that would actually be a good idea.
Reply With Quote
  #51  
Old 02-09-2005, 11:56 AM
The Geek's Avatar
The Geek The Geek is offline
 
Join Date: Sep 2003
Location: Behind you
Posts: 2,779
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by sabret00the
that would actually be a good idea.
Dont know if this has been suggested... but a naming scheme would be good instead of all polls with the same title.

Just a thought
Reply With Quote
  #52  
Old 02-09-2005, 11:58 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by the nail geek
Dont know if this has been suggested... but a naming scheme would be good instead of all polls with the same title.

Just a thought
I am working on the next version right now. Any suggestions for some naming scheme's?
Reply With Quote
  #53  
Old 02-14-2005, 10:02 AM
deb0 deb0 is offline
 
Join Date: Sep 2004
Location: somewhere
Posts: 183
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by docvader
Database error in vBulletin 3.0.6:

Invalid SQL: SELECT
threadid
, ((views * ) + (replycount * )) AS score
, views
, replycount
, title
, postusername
, postuserid
FROM thread
WHERE lastpost > 0
AND forumid IN ()

ORDER BY score DESC
LIMIT

mysql error: You have an error in your SQL syntax near ') + (replycount * )) AS score
, views
, replycount
, title
, postuse' at line 3

mysql error number: 1064

Date: Saturday 22nd of January 2005 04:14:04 AM
Script: http://x.russbo.com/vb/cron.php?&rand=173925
Referer:
Username: Unregistered
IP Address: 65.173.88.230.
I'm getting the same thing.

I also noticed that the mod doesn't seem to be working. Isn't a poll/thread supposed to appear in the forum you specify?

Help!
Reply With Quote
  #54  
Old 02-14-2005, 10:15 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Are you using the 1.12 version of the threadoftheweek.php?

This one is downloadable seperate in this thread (look at the hack in the top).

PS This week there will be a new version with some extra's like uCash integration. I will post it as soon as i had time to finish upgrade/installer and it is tested. But a bit busy with normal work atm.
Reply With Quote
  #55  
Old 02-14-2005, 10:15 AM
sabret00the's Avatar
sabret00the sabret00the is offline
 
Join Date: Jan 2003
Location: London
Posts: 5,268
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by MarcoH64
I am working on the next version right now. Any suggestions for some naming scheme's?
i thought if it could get the 'month' or 'week' and use that it'd be good.
Reply With Quote
  #56  
Old 02-14-2005, 04:11 PM
SnowBot's Avatar
SnowBot SnowBot is offline
 
Join Date: Jul 2003
Location: Manchester UK
Posts: 631
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Think i may try this out.

/me clicks install
Reply With Quote
  #57  
Old 02-17-2005, 02:32 AM
TTG's Avatar
TTG TTG is offline
 
Join Date: May 2004
Location: Sth London
Posts: 1,042
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Appears to have stopped again !?
Last run 5.2.2005 .. run the cron job manually and see message "Thread of the Week
Done", but no new poll !?
Reply With Quote
  #58  
Old 02-17-2005, 03:43 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
After you run it manually, it still say last run 5.2?

It could be that there are not enough candidate threads selected.
Reply With Quote
  #59  
Old 02-17-2005, 03:44 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Edit: On what schedule is this Poll set in the Rule?
Reply With Quote
  #60  
Old 02-17-2005, 10:25 AM
TTG's Avatar
TTG TTG is offline
 
Join Date: May 2004
Location: Sth London
Posts: 1,042
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by MarcoH64
After you run it manually, it still say last run 5.2?

It could be that there are not enough candidate threads selected.
After a manual cron the date of the next run is listed as "18-02-05 12:59 AM" but no new Thread has been added to the poll section !

I've changed the The weight the number of thread views has in the selection process and The weight the number of replies has in the selection process to just 5 and still no joy.
Reply With Quote
  #61  
Old 02-17-2005, 10:51 AM
The Geek's Avatar
The Geek The Geek is offline
 
Join Date: Sep 2003
Location: Behind you
Posts: 2,779
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by TTG
After a manual cron the date of the next run is listed as "18-02-05 12:59 AM" but no new Thread has been added to the poll section !

I've changed the The weight the number of thread views has in the selection process and The weight the number of replies has in the selection process to just 5 and still no joy.
Same here.
First run was fine. Since then, scheduled or manually running it doesnt work. Looking at the cron log, it keeps telling me it is updated - but no new thread. Just ran with debugging on and got this:

PHP Code:
Thread of the Week Started. 12:49 PM
Start processing rule 1 (Thread of the week)
Key data - id: 1 - active: 1 - s.type: 0 - s.value: 7 - postfid: 7 - postuser: The Nail Geek - aforums: a:7:{i:0;s:2:"11";i:1;s:1:"7";i:2;s:1:"6";i:3;s:2:"17";i:4;s:2:"21";i:5;s:2:"18";i:6;s:2:"22";} - wviews: 50 - wreplies: 50 - last: 1107904020 - prevpoll: 11863
Rule has run before, daily or weekly schedule. Timenow: 1108644573 timecut: 1108039773 
Rule don't need to run now, skipping 
Thread of the Week polls updated. 12:49 PM 
So it looks like it is already thinking it has run?
Reply With Quote
Reply
Page 4 of 13 « First 23 4 56 Last »

« Previous Thread | Next Thread »

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT. The time now is 01:32 PM.

Contact Us - Archive - Top

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05366 seconds
  • Memory Usage 2,388KB
  • Queries Executed 30 (?)
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
  • (1)bbcode_php
  • (8)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (16)post_thanks_box
  • (16)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (16)post_thanks_postbit_info
  • (15)postbit
  • (16)postbit_onlinestatus
  • (16)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_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete