PDA

View Full Version : TOTW: Thread of the Week Poll - Version 1.16


Marco van Herwaarden
01-19-2005, 10:00 PM
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/showthread.php?t=71542&highlight=hack+installer+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.

sabret00the
01-20-2005, 03:00 PM
thank you, i've installed this and it's a great hack :)

Polo
01-20-2005, 03:50 PM
This one will come really handy for me :)

RaZor Edge
01-20-2005, 06:17 PM
Can be great if we can set an option to only choose threads started in the current week!

Marco van Herwaarden
01-20-2005, 06:39 PM
You can set it to only choose threads from the past 7 days (or last week).

How you mean current week?

yoyoyoyo
01-20-2005, 07:12 PM
excellent! I will click install now and add it in later tonight with some other stuff I have lined up, also! thanks

lordofgun
01-21-2005, 01:05 AM
So you must use the HIS system?

lordofgun
01-21-2005, 01:39 AM
So you must use the HIS system?
Never mind. :D

trafix
01-21-2005, 01:46 AM
Nice job :) ..... now if my forum had some thread ... lol

Marco van Herwaarden
01-21-2005, 03:35 AM
Nice job :) ..... now if my forum had some thread ... lol
Lol that was my problem in testing :)

Marco van Herwaarden
01-21-2005, 03:43 PM
I would really like to have some input from people who have installed this hack on the following 2 things:
- Integration with an Award system? If yes which one?
- More 'Weight' criteria to select threads. Based on what would you like threads to be selected. Can't believe that replies and views are enough.

trackpads
01-21-2005, 04:02 PM
Excellent! I would like to see some Ucash support if you get the time. May give some bucks to the thread starter.

Thanks!!

-Jason

Marco van Herwaarden
01-21-2005, 06:44 PM
Hmm never used uShop, but will look into it.

trackpads
01-21-2005, 07:12 PM
Hmm never used uShop, but will look into it.
Much appreciated!!

docvader
01-22-2005, 05:39 AM
Excellent. Seems to work great on 3.06. An automatic donation to thread winner via UCash UShop would be great, but I'm bypassing that doing it manually. Nice job.

AlexanderT
01-22-2005, 02:19 PM
looks like a great job!

j_86
01-22-2005, 02:27 PM
Nice hack :)

yoyoyoyo
01-22-2005, 03:11 PM
finally got it installed...excellent!

docvader
01-22-2005, 04:40 PM
Getting this error, not sure if it's from this hack, but I have nothing else that would "look" for these things:
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

Any idea?? I did have this running well, with a test poll, without any apparent problems yesterday.

Marco van Herwaarden
01-22-2005, 05:07 PM
Hmm this shouldn't be possible. It looks like the values for the rule are not filled. There must be a rule, or script would never even come to this point.

And the entry screen for the settings, don't allow empty values if all is good.

Could you check your rule settings. (maybe printscreen)

docvader
01-22-2005, 05:18 PM
I just did the 3.06 upgrade, which has screwed up a bunch of my hacks. So, I'm not sure it's your hack that's doing this, I was just wondering if you thought it might. (I'm still dealing with some Shoutbox issues, LOL). The rule settings for the poll look fine to me, as does the functioning of the hack within the AdminCP. But the only two new Cron additions were the Statistics hack by PDFreak, and yours. So, I was just wondering if you had seen this error before, or, if you might recognize it.

Marco van Herwaarden
01-22-2005, 09:56 PM
Well the hack is pretty stand alone, an upgrade shouldn't effect anything except maybe some phrases.

Yes this query is part of the cronjob for this hack.

What this cronjob does is read the rules table and then execute for every rule some code.

This query that give you an error is inside the part that gets triggered for each rule that needs to be run (meaning that there IS a rule row in the database that needs to be run).

So given the fact that this part of the code can only be executed if there is a rule, i really dont get why this query have no values from the rules row.

The line , ((views * ) + (replycount * )) AS score
should have the values of the weight for views and replies inserted there. So for example:
, ((views * VIEWWEIGHT) + (replycount * REPLYWEIGHT)) AS score
If you have access to the database, please check if there is somehow an empty row in the 'threadofweekrules' table.

Otherwise all i can think of is to clear all rules, and add them again.

Romeos Tune
01-22-2005, 10:23 PM
Thanks for the fun hack! :) Good Job!

docvader
01-22-2005, 11:13 PM
This is what is in the database:
row(s) starting from record #
in mode and repeat headers after cells

Full Texts threadofweekrulesid description active schedule_type schedule_value postforumid postasuser threadtitle posttext sticky pollquestion pollpublic numberpolloptions analyzeforums permission_usergroupids weight_views weight_replies lastrun currentpollid previouspolledthreads


All boxes have data in them, with the exception of permission_usergroupids

Now, I did set this up so that it ran for one day. And, it seemed to have worked. So, I'm not saying that this doesn't work; I just don't understand where this error came from. I wanted you to be aware of it.

let me know what I can do to help, if need be.

James T Brock
01-26-2005, 06:58 PM
It doesn't work as advertised. On my forum I have it set for the last 7 days but it shows threads from months ago in the poll!!

sabret00the
01-26-2005, 07:10 PM
It doesn't work as advertised. On my forum I have it set for the last 7 days but it shows threads from months ago in the poll!!
it will do that for the inital poll, proceeding polls will be as set.

sabret00the
01-26-2005, 07:11 PM
- Integration with an Award system? If yes which one?
uCash unless you mean adding a simple to show thread to show that "this a thread of the month winner"

- More 'Weight' criteria to select threads. Based on what would you like threads to be selected. Can't believe that replies and views are enough.it seems to work of views, it would be nice to have something like replies * views = weight

fiber1
01-26-2005, 07:29 PM
I have the same issue that docvader does so there is an issue there. I am just not sure of the resolution.

Marco van Herwaarden
01-26-2005, 08:51 PM
It doesn't work as advertised. On my forum I have it set for the last 7 days but it shows threads from months ago in the poll!!
In the current version the initial poll takes threads from the beginning. I got a new version here that has some small modifications, one of them is that also the initial poll limits the age of the threads.

have the same issue that docvader does so there is an issue there. I am just not sure of the resolution.
I have send docvader (i think, or am i mixing up mail addresses now) a test version with some extra debug options to find the problem. I don't have a result from that yet. You can send me a pm with MSN/ICQ or mail contact info and i could send you that also.

it seems to work of views, it would be nice to have something like replies * views = weight
Current selection score is calculated as follows:
score = (views * weight_views) + (replies * weight_replies)

General:
Will look soon into a uShop integration.

trackpads
01-26-2005, 09:44 PM
Will look soon into a uShop integration.


Thanks!!!!!

TTG
01-27-2005, 02:44 PM
Looks like it could be a useful addition. Installed a week ago and it worked well for the 1st poll .. never worked again no matter what I do. Checked all details and after 10 days still waiting for the next poll !?

Polo
01-27-2005, 02:53 PM
so is this mod working correctly for anyone?

Marco van Herwaarden
01-27-2005, 02:54 PM
Looks like it could be a useful addition. Installed a week ago and it worked well for the 1st poll .. never worked again no matter what I do. Checked all details and after 10 days still waiting for the next poll !?
- How often is your Scheduled Task set to run?
- What Schedule type and value did you set?
- What is the last run date?

TTG
01-27-2005, 04:47 PM
My mistake .. set the schedule and forgot to add the filename for the task .. duh

Marco van Herwaarden
01-27-2005, 08:32 PM
:D

Glad that this also answers the question of Polo ;)

sabret00the
01-28-2005, 09:17 AM
so is this mod working correctly for anyone?
working perfectly for me.

Polo
01-28-2005, 08:19 PM
Ok, sounds good, will install on my forum :)

Marco van Herwaarden
01-28-2005, 08:54 PM
There is a modified version ready, but i am still waiting to get test results back. Seems the person testing is a bit busy with other things atm.

fiber1
01-29-2005, 04:15 AM
Well the hack is pretty stand alone, an upgrade shouldn't effect anything except maybe some phrases.

Yes this query is part of the cronjob for this hack.

What this cronjob does is read the rules table and then execute for every rule some code.

This query that give you an error is inside the part that gets triggered for each rule that needs to be run (meaning that there IS a rule row in the database that needs to be run).

So given the fact that this part of the code can only be executed if there is a rule, i really dont get why this query have no values from the rules row.

The line , ((views * ) + (replycount * )) AS score
should have the values of the weight for views and replies inserted there. So for example:
, ((views * VIEWWEIGHT) + (replycount * REPLYWEIGHT)) AS score
If you have access to the database, please check if there is somehow an empty row in the 'threadofweekrules' table.

Otherwise all i can think of is to clear all rules, and add them again.

If you could just post the fix once resolved, when you find it that would be great

docvader
01-29-2005, 04:48 AM
There is a modified version ready, but i am still waiting to get test results back. Seems the person testing is a bit busy with other things atm.
OH, were you talking about me?

Sorry. Will try it again. didn't get that file to work, but, the hack seems to be working great.

docvader
01-29-2005, 05:00 AM
Sent it to you. Hope that helps.

Marco van Herwaarden
01-29-2005, 06:21 AM
I will have a look at your feedback, thanks for sending.

Hope i can do this this weekend, otherwise on monday.

trackpads
02-01-2005, 02:43 AM
There is a modified version ready, but i am still waiting to get test results back. Seems the person testing is a bit busy with other things atm.
Let me know!

Is Ucash support in this one?

thanks!

-Jason

sabret00the
02-02-2005, 07:39 AM
ok, well yesterday was the first of the month and it failed to create a new poll :(

Marco van Herwaarden
02-04-2005, 03:10 PM
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.

sabret00the
02-05-2005, 08:38 PM
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.

Marco van Herwaarden
02-05-2005, 09:23 PM
Optional maybe?

The Geek
02-08-2005, 09:13 PM
Nice 1 ;)

*The geek toggles his install switch

sabret00the
02-09-2005, 09:59 AM
Optional maybe?
that would actually be a good idea.

The Geek
02-09-2005, 11:56 AM
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 :)

Marco van Herwaarden
02-09-2005, 11:58 AM
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?

deb0
02-14-2005, 10:02 AM
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!

Marco van Herwaarden
02-14-2005, 10:15 AM
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.

sabret00the
02-14-2005, 10:15 AM
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.

SnowBot
02-14-2005, 04:11 PM
Think i may try this out.

/me clicks install

TTG
02-17-2005, 02:32 AM
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 !?

Marco van Herwaarden
02-17-2005, 03:43 AM
After you run it manually, it still say last run 5.2?

It could be that there are not enough candidate threads selected.

Marco van Herwaarden
02-17-2005, 03:44 AM
Edit: On what schedule is this Poll set in the Rule?

TTG
02-17-2005, 10:25 AM
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.

The Geek
02-17-2005, 10:51 AM
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:


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?

Marco van Herwaarden
02-17-2005, 10:54 AM
What settings do you use in the rule for Schedule Options for Rule?

The Geek
02-17-2005, 11:02 AM
see attachment :)

Marco van Herwaarden
02-17-2005, 03:57 PM
At "Post Poll in Forum" you have set it to "Main". Is this a postable forum, not a section?

The Geek
02-17-2005, 04:39 PM
At "Post Poll in Forum" you have set it to "Main". Is this a postable forum, not a section?
Its a postable forum.

The Geek
02-17-2005, 06:35 PM
BTW:

I got it to work by deleting the lastrun value from the rule. I also changes the sql critera so that it pulled based on dateline not lastpost. Really old threads that had been bumped within the last week appeared and it was a tad confusing. Since it should be thread of the week I assumed that the thread would have started within the time frame.

Anyway - just thought I would throw that in if it helps.

BTW: Why check when the lastrun was? If its a cron job then that runs automatically whenever you specify. If I wanted twice a week, I would set the cron job up accordingly. What is happening is that the lastrun date is never lower than the $cut date so it doesnt run the do_run_rule

Marco van Herwaarden
02-17-2005, 07:00 PM
Thanks for looking into it. I have a new version being beta tested and one of the new options is the choice of selecting threads based on thread start or on last post. Also it will have uShop integration, posting of the result in a "Winners Post", replacement variables in the thread title, and some more small things.

About testing the lastrun, you can have multiple rules, 1 running every day, and one running on a weekly or monthly schedule. The cronjob will need to run every day in this scenario, and only execute those rules that are supposed to be executed. Don't get what you say about lastrun never being lower then $cut, but will check it against the code tomorrow.

PS If you are just starting up, you could also help beta testing the new version ;)

TTG
02-17-2005, 07:53 PM
Its a postable forum.

Already posted twice into the specified 'Polls Forum'

Marco van Herwaarden
02-18-2005, 02:59 AM
Already posted twice into the specified 'Polls Forum'
Sorry i don't understand this reaction? you mean it already worked good twice on your board?

TTG
02-18-2005, 10:59 AM
Sorry i don't understand this reaction? you mean it already worked good twice on your board?

Correct .. worked fine twice and then never worked again !?

Marco van Herwaarden
02-18-2005, 03:50 PM
New version released, now with uCash integration.

Please check out the change log.

All reported bugs should be solved. If you find any (new) bugs, please report them again.

sabret00the
02-18-2005, 03:52 PM
fantastic update, thank you, you've done some great work here :)

Marco van Herwaarden
02-21-2005, 09:55 AM
fantastic update, thank you, you've done some great work here :)
And thank you for testing :D

PS sabre, you might wanna download the released version and upload the threadoftheweek.php to your board, made some minor changes after your last test.

TTG
02-25-2005, 02:33 PM
Another week passes and still waiting for this to work, either via cron or manually running cron :ermm:

KW802
02-25-2005, 03:06 PM
I think this hack might do what I'm after but I'm curious about the rules.

Would I be able to create a rule so that the selection criteria is ... Select the first X amount of threads between date X & date Y sorted by descending (high to low) rating by replies by views?

Romeos Tune
02-26-2005, 01:17 AM
It ran once for me and then never worked again even manually running the script and seems abandoned. I dunno.....

Marco van Herwaarden
02-26-2005, 06:44 AM
I think this hack might do what I'm after but I'm curious about the rules.

Would I be able to create a rule so that the selection criteria is ... Select the first X amount of threads between date X & date Y sorted by descending (high to low) rating by replies by views?
Not until date Y, but from date X until now. And yes, it can take the top X threads based on (configurable) replies and views.

@all who have problems.
What version are you running?
If you have problems, please post the version you're running, the settings for schedule you're using, the settings for the weights, and how often the cronjob is run.

Marco van Herwaarden
02-26-2005, 06:45 AM
It ran once for me and then never worked again even manually running the script and seems abandoned. I dunno.....
How you mean abandoned? That the script don't work anymore, or that there is no support?

Please see my remark above, about posting your config in case of problems. If you want you can also send it to me by PM.

Romeos Tune
02-26-2005, 03:32 PM
Sorry about that..... I am running 1.13 and getting database errors when running the cronscript:

Invalid SQL: SELECT * FROM vb3_threadoftheweekpolloption
WHERE threadofweekrulesid = 1
mysql error: Table 'vb.vb3_threadoftheweekpolloption' doesn't exist

mysql error number: 1146

It's inserting and extra vb into the table name for whatever reason.

MikaK
02-26-2005, 05:34 PM
So installed.

Nice job :) ..... now if my forum had some thread ... lol

I?m in pre-launch and have 3 article bots posting day n night:) Let?s see whos most popular:D

Marco van Herwaarden
02-27-2005, 07:56 AM
Sorry about that..... I am running 1.13 and getting database errors when running the cronscript:

Invalid SQL: SELECT * FROM vb3_threadoftheweekpolloption
WHERE threadofweekrulesid = 1
mysql error: Table 'vb.vb3_threadoftheweekpolloption' doesn't exist

mysql error number: 1146

It's inserting and extra vb into the table name for whatever reason.
Did you start with version 1.13, or did you upgrade from an older version (if upgrade, did you run the upgrade script?).

What do you mean with the "extra vb"? "vb is probably your databasename and "vb3_" your table prefix.

Romeos Tune
02-27-2005, 02:34 PM
Yep, that was the problem...... I'm sorry for the confusion....... Thankyou! :)

deb0
03-01-2005, 09:54 PM
I have this hack installed, and it appears to be partially working:

the poll starts as schedule, but Isn't a new poll supposed to begin every week or x days?

What does it do to the last poll results? I don't see it anywhere.

Also, I don't see an option for UCash integration.

Marco van Herwaarden
03-02-2005, 03:46 PM
I have this hack installed, and it appears to be partially working:

the poll starts as schedule, but Isn't a new poll supposed to begin every week or x days?

What does it do to the last poll results? I don't see it anywhere.

Also, I don't see an option for UCash integration.
@all who have problems.
What version are you running?
If you have problems, please post the version you're running, the settings for schedule you're using, the settings for the weights, and how often the cronjob is run.
uCash You should find in the new Thread of teh Week option group in your vB settings.

MikaK
03-03-2005, 07:57 AM
I would like to run a poll every Friday GMT 10 pm or so. How should I set the timer and the cron?

Thanks for any ideas,
-Mika

Marco van Herwaarden
03-03-2005, 06:41 PM
- Create the Cronjob to run every day around 10PM.
- Set the schedule to run every 1 week.
- Make sure you create the rule (or set to active) the first time on a friday.

PS I might add a "Run every day X of the week" schedule type in the next release.

MikaK
03-04-2005, 01:59 AM
- Create the Cronjob to run every day around 10PM.
- Set the schedule to run every 1 week.
- Make sure you create the rule (or set to active) the first time on a friday.

PS I might add a "Run every day X of the week" schedule type in the next release.

Thanks Marco.

-Mika

deb0
03-04-2005, 11:01 AM
uCash You should find in the new Thread of teh Week option group in your vB settings.

Ok, I got that part now. But I still don't see full functionality:

Ok, people vote, and I see that clearly, but at the end of the week, where does it post results of which thread won?

All cron and weight settings are set to default.
I'm running VB306

Marco van Herwaarden
03-04-2005, 11:12 AM
When it is time to rune the Rule again according to the schedule, it will close the current poll, post the results (and give away the uCash points if set) and create a new Poll.

MikaK
03-06-2005, 08:35 AM
Any idea why trying to run the cron via ACDP scheduled tasks by pressing "run now!" gives this sql error:

Database error in vBulletin 3.0.3:

Invalid SQL: UPDATE scll
SET =+0 WHERE userid=11
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 '=+0 WHERE userid=11' at line 2

mysql error number: 1064


Date: Sunday 06th of March 2005 02:17:50 AM
Script: http://www.soundchilds.net/loud_lounge/admincp/cronadmin.php?do=runcron&cronid=24 (http://www.soundchilds.net/loud_lounge/admincp/cronadmin.php?do=runcron&cronid=24)
Referer: http://www.soundchilds.net/loud_lounge/admincp/index.php? (http://www.soundchilds.net/loud_lounge/admincp/index.php?)

Username: MikaK
IP Address: nono


Thanks for any ideas,
-Mika

Marco van Herwaarden
03-06-2005, 08:54 AM
Please tell me which version you're running, also php and MySQL versions.

scll is your uCash points table? Do you have uCash installed? How is the uCash integration set in the vB settings for Thread of the Week?

MikaK
03-06-2005, 10:59 AM
Please tell me which version you're running, also php and MySQL versions.

scll is your uCash points table? Do you have uCash installed? How is the uCash integration set in the vB settings for Thread of the Week?

scll is the data table prefix in my vBulletin database.



I have ToW 1.13 installed on vB 3.0.3. I tried to install ucash but rolled back to a previous backup since I had trouble with it.

uCash setting in your script for this poll are the default ones: first three fields as 0 and the fourth empty.


PHP version 4.3.10

MySQL version 4.0.23-standard.



Regs,

-Mika

Marco van Herwaarden
03-06-2005, 12:01 PM
ACP->vBulletin Settings-->Thread of the Week-->uCah integration: No

That should solve your problem.

MikaK
03-06-2005, 12:13 PM
ACP->vBulletin Settings-->Thread of the Week-->uCah integration: No

That should solve your problem.

Thanks Marco,

The message changed shape a tad: Warning: Invalid argument supplied for foreach() in /home/soundchi/public_html/loud_lounge/includes/cron/threadoftheweek.php on line 358

my file looks from row 358 like:

foreach ($svotes AS $key=>$values)
{
if ($count != 0)
{
--$count;
++$position;
continue 1;
}
if ($values['votes'] == 0) // No more winners
break;

++$position;
$winners[$position] = $values['polloption'];

// More sharing the same number of votes?
$count = 0;
while (++$count)
{
if ($svotes[$key + $count]['votes'] == $values['votes'])
{
$winners[$position] .= "," . $svotes[$key + $count]['polloption'];
}
else
{
--$count;
break 1;
}

}
}


How critical is this? The cron was executed ok and the poll apeaed at the wanted forum.

Regs,
-Mika

jzewatsky
03-10-2005, 01:06 AM
What a great hack! I'm sure my thread count will increase by installing this. Thank you!

Side note.

Does anyone know how to give ucash for responding to polls?

Thanks again!!!!!

Lionel
03-11-2005, 02:35 PM
Hi,

I was wondering if the thread title could be automated to say "thread of the week for week of xxx to xxx" ?

This way, while being specific, it will change the monotomy of title.

Marco van Herwaarden
03-11-2005, 03:47 PM
Hi,

I was wondering if the thread title could be automated to say "thread of the week for week of xxx to xxx" ?

This way, while being specific, it will change the monotomy of title.
Hmm sounds like a good suggestion, will try to implement in a next version.

Lionel
03-11-2005, 04:20 PM
Hmm sounds like a good suggestion, will try to implement in a next version.

Thanks for considering it. Real nice hack! Couldn't that be achieved now by doing something like:

Best thread for week ending $lastrundate (something to that extent using that parameter)

Marco van Herwaarden
03-11-2005, 05:51 PM
Well that parameter is not implemented, only start weeknumber and i think start date if i remember correct.

Kru
03-15-2005, 03:55 AM
I am getting the following error message, too: Warning: Invalid argument supplied for foreach() in /includes/cron/threadoftheweek.php on line 358 if I run it in the Scheduled Task Manager. I am using vBulletin. 3.0.7

Marco van Herwaarden
03-15-2005, 05:53 AM
Edit your includes/cron/threadoftheweek.php.

Find:
if ($pollid)
Add above:
$svotes = array();

Please report back if this is solving anything.

1 Question, did the current poll maybe never get any votes?

Kru
03-15-2005, 02:07 PM
Edit your includes/cron/threadoftheweek.php.

Find:
if ($pollid)
Add above:
$svotes = array();

Please report back if this is solving anything.

1 Question, did the current poll maybe never get any votes?

Made the change but still same error message.

I installed the hack last week. Told it that the poll should happen every 1 week.

Because I wanted to start with the poll directly after I installed the hack I run it in the Scheduled Task Manager but nothing happened. It still said poll never run.

Because I was busy with other stuff I didn't check any longer at it but then on saturday the poll started automatically but instead to show 3 poll options it just showed 2. I thought I made something wrong and deleted the thread. I reset date last run and reset previous polled threads.

Again I tried to run it in the Scheduled Task Manager but this time I got the error message mentioned above.

Marco van Herwaarden
03-15-2005, 02:17 PM
Made the change but still same error message.

I installed the hack last week. Told it that the poll should happen every 1 week.

Because I wanted to start with the poll directly after I installed the hack I run it in the Scheduled Task Manager but nothing happened. It still said poll never run.

Because I was busy with other stuff I didn't check any longer at it but then on saturday the poll started automatically but instead to show 3 poll options it just showed 2. I thought I made something wrong and deleted the thread. I reset date last run and reset previous polled threads.

Again I tried to run it in the Scheduled Task Manager but this time I got the error message mentioned above.
Thank you very much for this description. Think i finally got an old bug out now. The reason for the error is that the cron job is trying to close a thread that don't exist anymore (you deleted it).

I will post an update in an hour.

Marco van Herwaarden
03-15-2005, 03:14 PM
Made the change but still same error message.

I installed the hack last week. Told it that the poll should happen every 1 week.

Because I wanted to start with the poll directly after I installed the hack I run it in the Scheduled Task Manager but nothing happened. It still said poll never run.

Because I was busy with other stuff I didn't check any longer at it but then on saturday the poll started automatically but instead to show 3 poll options it just showed 2. I thought I made something wrong and deleted the thread. I reset date last run and reset previous polled threads.

Again I tried to run it in the Scheduled Task Manager but this time I got the error message mentioned above.
Updated version posted. Just upload all files, no upgrade scripts to be run.

Marco van Herwaarden
03-15-2005, 03:15 PM
About only selecting 2 options, maybe there where not enough posts to select from based on the criteria.

Please test again, if your problems continue send me a PM and we will look at it.

Kru
03-16-2005, 04:34 AM
About only selecting 2 options, maybe there where not enough posts to select from based on the criteria.

Please test again, if your problems continue send me a PM and we will look at it.
The error message is gone. Thank you. :)

But if I run the Scheduled Task Manager manually nothing is happening. Well it says DONE but in the Thread of the Weeks option it says that the poll is never run and it doesn't make any new poll at the forum. :(

SnowBot
03-19-2005, 02:59 AM
is their a way to uninstall this?

Lionel
03-19-2005, 07:20 AM
I have none of the problems described in this thread. The second poll ran itself as scheduled in cron while closing the first one.

2 minor details:

1-The closed thread says below are the winners and is empty
2-on forumdisplay.php the "Last Post" by has no username.

I keep on manually adjusting the thread title to say Week Ending {today} instead of the plain Thread of the Week Poll.

Marco van Herwaarden
03-19-2005, 02:38 PM
@lionel

Thanks, i will look inti that second issue. Can you PM me the config for the winners post, so i can look at your first problem.

@snowbot
Run the installer again, choose to uninstall and follow instructions. If you added the Manager to your ACP menu, you will have to manually remove that edit. The scheduled task also needs to be removed manually.

Lionel
03-19-2005, 07:19 PM
I have none of the problems described in this thread. The second poll ran itself as scheduled in cron while closing the first one.

2 minor details:

1-The closed thread says below are the winners and is empty
2-on forumdisplay.php the "Last Post" by has no username.

I keep on manually adjusting the thread title to say Week Ending {today} instead of the plain Thread of the Week Poll.

OK, I did not realize that there were more options about variables in the question mark help to be included with #1

fiber1
04-05-2005, 12:35 AM
Here is the biggest problem with this hack. One cannot exclude certain forums not to choose from for the Thread of the week. Besides this it would be a great hack!

Marco van Herwaarden
04-05-2005, 03:50 AM
Here is the biggest problem with this hack. One cannot exclude certain forums not to choose from for the Thread of the week. Besides this it would be a great hack!I don't understand what you mean. You can select the forums from which the threads are selected.

Marco van Herwaarden
04-07-2005, 07:13 PM
Small update, see change log.


@lionel
I have not forgotten your request, but i am a bit short on time atm. It will come as soon as i got a bit more time.

Lionel
04-08-2005, 02:41 AM
Marco, there is a small typo in upgrade_queries.php, the last line selectdays smallint(6) unsigned NOT NULL default 0, sould be selectdays smallint(6) unsigned NOT NULL default \'0\'

Marco van Herwaarden
04-08-2005, 04:02 AM
Marco, there is a small typo in upgrade_queries.php, the last line sould beDid you get an error on that? What MySQL version are you using?

Shouldn't get an error it is a numerical row, so no quotes needed. Oops i see it now, a comma on the end, will update in a few minutes.

Edit: Updated.

Lionel
04-08-2005, 04:07 AM
I followed your advice and upgraded to the latest.

I did get an error and fixed as per above.Invalid SQL: ALTER TABLE threadofweekrules ADD COLUMN (
selectdays smallint(6) unsigned NOT NULL default 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 3

mysql error number: 1064

Marco van Herwaarden
04-08-2005, 06:20 AM
I followed your advice and upgraded to the latest.

I did get an error and fixed as per above.Yes this error was because of the trailing comma. Is removed and zip file updated.

fiber1
04-08-2005, 09:27 PM
I don't understand what you mean. You can select the forums from which the threads are selected.


This is what I am refering too, unless I am missing something here?

Thread Selection Options:

Select forums to analyze for selecting threads.

You can only highlight the ones that are ordered together.

For example:

Forums named:

My forum1

My forum2

My forum3

My forum4

My forum5

I only wanted to use forum1, forum2, and forum5 there is no way just to select those particualr ones.

You can only select the ones that are all order together.

Hope you understand what I mean?

jzewatsky
04-09-2005, 12:21 AM
Try pressing the Control key while useing your mouse to select the thread (ctrl + Left mouse). You should then be able to select (highlight) any thread you wish. To unselect, use the control+left mouse again to un highlight. Hope I'm understanding what your asking and that the above helps.

fiber1
04-09-2005, 12:35 AM
Thanks I guess that works... Sorry never seen that approach yet! :D

jzewatsky
04-09-2005, 12:48 AM
Sorry, in my post above replace "thread" with "forum"

thread = forum

Sorry if there was any confusion.

Marco van Herwaarden
04-09-2005, 06:03 AM
Thanks I guess that works... Sorry never seen that approach yet! :DThat is default behaviour for all multiselect fields:
- Simple click: deselect all and select only the one you clicked
- Control Click: togle state of the line you clicked, keeping all previously selected
- shift click: select from/until lines.

Kru
04-09-2005, 01:14 PM
It works like a charm. Great work MarcoH64 and big thank you for the changes that I requested. :)

Lionel
04-13-2005, 09:39 AM
When it is time to rune the Rule again according to the schedule, it will close the current poll, post the results (and give away the uCash points if set) and create a new Poll.

It is not happening for me in that order. Seems that it is creating the new poll first, then post the results and close the poll last. So, for example in forumhome, last thread column will show April 2nd instead of April 9th.

I manually change the title for every thread created to make it as Week Ending 00/00/0000. And whenever the cron runs, the closed thread displays as last posted instead of new poll.

Lionel
04-13-2005, 09:45 AM
Thanks for considering it. Real nice hack! Couldn't that be achieved now by doing something like:

Best thread for week ending $lastrundate (something to that extent using that parameter)

Well that parameter is not implemented, only start weeknumber and i think start date if i remember correct.

What about $today? date? The creation date of the thread has to be somewhere.

Marco van Herwaarden
04-13-2005, 10:02 AM
Lionel,

Can you PM me an URL where i can see this behaviour?

Edit: And i will look if i have some time today for adding some more variables to the title.

Lionel
04-13-2005, 10:14 AM
Marco I sent you the PM. If you look closely, the post number for the closed poll is lower than the new poll, indicating that it was created first. Yet it displays as last.

Marco van Herwaarden
04-13-2005, 11:31 AM
What about $today? date? The creation date of the thread has to be somewhere.Today is already possible (with exception of the year). Just use one of the following for Thread Title:
- Poll for {day}-{month}-2005
- Poll for {day} {monthname} 2005

Marco van Herwaarden
04-13-2005, 02:51 PM
New version 1.16 released:

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

Polo
04-19-2005, 01:47 PM
I dont know if this has been asked before... but is it possible to select just random threads? if yes, what do i need to modify?

Marco van Herwaarden
04-19-2005, 02:03 PM
Nope that is not possible with the current version.
How did you have this in mind?

Just 3 (or more) random threads from the last week?

Polo
04-26-2005, 10:24 PM
Nope that is not possible with the current version.
How did you have this in mind?

Just 3 (or more) random threads from the last week?
yes.... I would like for this hack to just pick out 10 random threads from a specific forum... that is it... dont know how complicated that would be... but I would like to accomplish it...

Marco van Herwaarden
04-27-2005, 03:45 AM
Shouldn't be to difficult, will have a look later.

kall
05-08-2005, 06:20 AM
Anyone else having this problem?

Some of the threads chosen have the lat poster as the name listed, rather than the thread starter.

*sighs*

Looks like I am a moron. Updating counters fixed it.

Top stuff as always Marco!

Marco van Herwaarden
05-08-2005, 09:08 AM
Thanks for the compliment. With a lot of user feedback it is now a nice and stable hack, unfortunatly it didn't start like that.

If you have any suggestions for improvement, i might be able to spend some time on previous wishes in the next week.

dsboyce8624
05-08-2005, 03:52 PM
Thanks for the compliment. With a lot of user feedback it is now a nice and stable hack, unfortunatly it didn't start like that.

If you have any suggestions for improvement, i might be able to spend some time on previous wishes in the next week.

I'd like to change the poll so the voters names are not displayed.

Other than that, excellent piece of work.

Marco van Herwaarden
05-08-2005, 06:11 PM
I'd like to change the poll so the voters names are not displayed.

Other than that, excellent piece of work.You can already choose in the Rule settings if it should be a Public Poll or not.

kall
05-09-2005, 08:19 AM
Thanks for the compliment. With a lot of user feedback it is now a nice and stable hack, unfortunatly it didn't start like that.

If you have any suggestions for improvement, i might be able to spend some time on previous wishes in the next week.
Well...the 'Place 1 gets... Place 2 gets...' could be changed to 'First place, second place, third place..' that might be nice.

Also, what about when threads have an equal number of votes? It could say 'First equal' .. I think at the moment it just says 'Place 1, Place 1, Place 1'.

Marco van Herwaarden
05-09-2005, 08:23 AM
This would be difficult since it would make things language dependant. Will think about it.

And about ending up equal, you are right, i was just being lazy there. ;)

michael5472
05-10-2005, 09:40 PM
Cheers mate added it in.

Lets see how it goes :)

kall
05-10-2005, 09:44 PM
This would be difficult since it would make things language dependant. Will think about it.

And about ending up equal, you are right, i was just being lazy there. ;)
*grins*

I scooped all the Points last time...only got 1 vote per thread too.

xtreme-mobile
05-11-2005, 12:29 PM
ive just installed this and sounds really good

is there a way of testing it now to make sure its working? or do i have to wait till the end of the week, is there anyway of getting it run now just so i know its working?

thanks

clicks install

bonnmac
05-12-2005, 12:43 AM
couple of quick questions please 1. do i have to add this to ucs or dose the installer automaticly do it? 2. i am going to set this up with 3 threads every 3days (just to keep it intresting) now how do i make a post where it auto shows winners in 1 st 2 nd and 3rd as a reply to the poll i'm kinda slow with this thanks for a great hack!!

Marco van Herwaarden
05-12-2005, 04:27 AM
ive just installed this and sounds really good

is there a way of testing it now to make sure its working? or do i have to wait till the end of the week, is there anyway of getting it run now just so i know its working?

thanks

clicks installYou could setup a test Rule posting into your Mod/Admin forum and have it run each day.

For testing you could clear the Last Run date in the rule, and run the Scheduled task with Run Now.

Marco van Herwaarden
05-12-2005, 04:28 AM
couple of quick questions please 1. do i have to add this to ucs or dose the installer automaticly do it? 2. i am going to set this up with 3 threads every 3days (just to keep it intresting) now how do i make a post where it auto shows winners in 1 st 2 nd and 3rd as a reply to the poll i'm kinda slow with this thanks for a great hack!!1. What is ucs?
2. Look into the Rule settings (make sure to also use the Admin help - questionmark behind each setting). You can set there how result should be posted.

Marco van Herwaarden
05-12-2005, 08:26 AM
Hmm never mind ucs = uCash/uShop, didn't have enough coffee this morning to understand that.

1. No changes to ucs needed to make this work.

osariase
05-29-2005, 08:38 PM
How do i create a cron job,
I know this question is dumb but please excuse me, can someone please show or tell me how
thanks

rinkrat
05-30-2005, 03:23 AM
/me hits install

Brilliant!!

Marco van Herwaarden
05-30-2005, 04:10 AM
How do i create a cron job,
I know this question is dumb but please excuse me, can someone please show or tell me how
thanksAdminCP->Scheduled Tasks->Add Scheduled Task

Goodspeed
06-10-2005, 01:27 PM
We have 1.11 version installed and would like to do clean uninstall and clean install of new version. How can I do clean uninstall of 1.11 version?

Thank you!

Marco van Herwaarden
06-10-2005, 01:44 PM
You should be able to upgrade using the 1.16 installer.

If you want to uninstall first, upload the 1.11 installer again (if you removed it) and run it, and select to uninstall. Then just follow instrctions.

KevinL
06-19-2005, 02:10 AM
I want to install as it sounds like an awesome hack, but first was wondering if something is possible.

Could it be possible to say have a button in the first post to nominate that thread? So users can nominate threads instead of it picking based on views/replies?

Then after a month it will make a poll thread on the first of every month based on those threads clicked and close after say five days?

Any thoughts on this? :)

Marco van Herwaarden
06-19-2005, 06:13 AM
That would have to be an addon to this hack. I don't know if i would have time for that right now, maybe in a few weeks.

KevinL
06-19-2005, 12:23 PM
That would have to be an addon to this hack. I don't know if i would have time for that right now, maybe in a few weeks.
That would be great! Thanks

A donation might be in order when thats done ;)

Marco van Herwaarden
06-21-2005, 02:48 PM
That would be great! Thanks

A donation might be in order when thats done ;)Kevin

You would really need to specify a bit more how you want this. Should nomination votes get reset after selection? It would not be possible to have more then 1 Poll running at the same time i think.

dsboyce8624
06-21-2005, 03:02 PM
Kevin

You would really need to specify a bit more how you want this. Should nomination votes get reset after selection? It would not be possible to have more then 1 Poll running at the same time i think.

Sounds like a whole new hack to me. And I do like the idea.

Users vote during the week, at the end of the week, the votes are used to create a poll, then the votes are reset and a new vote begins. The winners from the the last X number of weeks are ineligable and X is defined in ACP.

Marco van Herwaarden
06-21-2005, 03:15 PM
Ok, i might be better off telling what i have in mind.

First of all i already made some changes to TOTW:
- New option to close a Poll after X-days instead of when a new Poll is started.
- Created basic support for alternative way of Candidate selection.
- Moved current Poll from Rules table to a new Polls table.
- Added a Poll Manager (not much, just a place to see the current ongoing Polls).
- Created to possiblility to End a Poll, the next time the cronjob is run. This means you can end it earlier then normal.

What i was thinking of is creating a function (maybe an addon, depending on the fact if vBfiles/tables must be edited or not, since the current TOTW is more a "plugin") that can do the following:
- Create a way of allowing external votes to be made to Candidate a thread for a predefined Rule. You would only need to add a link to that function with the ruleid as parameter somewhere in a template.
- Make it impossible to vote more then once for a user.
- Empty the new Candidate voting after a new Poll is created?


(I know this doesn't make sense, but i just slowly start to figure out how to solve this)

PS Not sure if i would make this addon for free.

dsboyce8624
06-21-2005, 03:29 PM
Most of what you said, sounds like what I said.

If it ends up being what I said, I have no problems shelling out a few clams.

KevinL
06-21-2005, 03:33 PM
Excellent :)

yahoooh
08-11-2005, 06:05 AM
when i try to install i get this error :
[11-Aug-2005 02:36:40] PHP Warning: chdir(): No such file or directory (errno 2) in /home/xxx/public_html/forum/install/his_files/hack_install_b3.php on line 30
[11-Aug-2005 02:36:40] PHP Warning: main(./global.php): failed to open stream: No such file or directory in /home/xxx/public_html/forum/install/his_files/hack_install_b3.php on line 31
[11-Aug-2005 02:36:40] PHP Fatal error: main(): Failed opening required './global.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/xxx/public_html/forum/install/his_files/hack_install_b3.php on line 31

Marco van Herwaarden
08-11-2005, 01:33 PM
If you have renamed your admincp directory, then please have a look at the config file in install/his_files. This file must be renamed and edited to reflect your directory names.

yahoooh
08-27-2005, 04:20 AM
installed ,

i have q :
how to exclude specific forums from the thread of the week
i need to exlude about 5 forums from 30 forums
is there away to do this?

Marco van Herwaarden
08-27-2005, 08:02 AM
No, then you will just have to select them all, and while holding down the Ctrl, de-select the ones you don't want.

yahoooh
08-27-2005, 11:19 AM
thanks, it works

Logician
10-04-2005, 09:18 AM
This is a beautifulhack in which a lot of efforts are put so it is unfortunate it is not very active. Hope my bump will get some more attention.

While I'm on it, here is a small suggestion : :glasses:

Wouldn't you consider adding "open<>10 and visible=1" to the query of select_candidates function? (when it is added $selectforumssql also need to be prefixed with " AND "). This would make sure redirected and disabled threads won't get pulled. Or maybe "open=1 and visible=1" to exclude closed ones too?

Marco van Herwaarden
10-04-2005, 12:12 PM
Thx for the bump. :D

That change sounds like a very good suggestion. Will put it in the next version i hope.

AshokForums.com
11-14-2005, 05:39 AM
Great hack... Is it compatible with Vb 3.5?? If not.. can someone update it pleaseeeeeeee

Thanks

Marco van Herwaarden
11-14-2005, 08:17 AM
No it is not compatible with 3.5.

I do have plans to update it, but i have some other things i must finish first.

lazytown
11-14-2005, 08:20 AM
I would be very excited to see a 3.5 port as well.

-vissa

mcyates
11-19-2005, 01:46 PM
Yes we need a Port to VB 3.5

Marco van Herwaarden
11-19-2005, 04:22 PM
Like said, it will be updated, but got some other things to finish first.

lazytown
01-12-2006, 08:13 AM
Pretty Please? (been patient) :)

-vissa

Marco van Herwaarden
01-22-2006, 09:12 PM
It is still on my todo list.

lazytown
02-23-2006, 10:53 PM
Any updates/progress? Willing to donate/pay for this one.

-vissa

James T Brock
05-20-2006, 01:30 AM
This is one older hack which could use an upgrade.

blueberry
06-10-2006, 06:38 AM
I am waiting for this hack to be released for the 3.5
It is pretty cool :)
I was looking for it since along time..

Bratz-Designs
08-16-2006, 08:52 AM
Hey Marco,

Whats the status on the 3.5 version? :)

James T Brock
08-24-2006, 07:18 PM
Status?

OrangeFlea
10-08-2006, 02:59 AM
Why hasn't anyone made an update on this wonderful mod yet?

Lionel
10-08-2006, 05:19 AM
No it is not compatible with 3.5.

I do have plans to update it, but i have some other things i must finish first.

LOL, Marco has a lonnnnnnnnnnnnnnnnng to do list. That goes with the new duties.

Just kidding you Marco. All along you have been extremely helpful to all. If you can't do it, I am sure it's like you said: time.

sabret00the
11-23-2006, 05:11 PM
i'll add my name to the list of people interested in a 3.5/3.6 version.

Martin-TMGRS
01-09-2007, 07:02 PM
Is there any news on this yet being made for VB3.6.4 ?

Snyper
01-11-2007, 10:44 PM
Is there any news on this yet being made for VB3.6.4 ?

I hope it :D

James T Brock
01-13-2007, 08:48 PM
What's the point of not allowing anyone else to update a mod if the original author has no plans of doing it either? I've even offered twice in the other section to pay someone to make this mod but no takers either time.

Jeordie015
02-28-2007, 09:16 PM
I'd like to see an updated version of this.

lazytown
03-04-2007, 05:56 AM
Years later and still not 3.5 or 3.6 conversion.. Can it be handed off to someone? Lots of interest.

-vissa

Hornstar
07-16-2007, 11:35 AM
Has this mod been upgraded to 3.6.7? was looking but can only find this so far.

mommiesrus
09-28-2007, 05:39 PM
Still wondering the same thing . . .

lasto
09-28-2007, 06:02 PM
it dont work on 3.6.7 just tried it

Fatal error: Call to undefined function: query() in /home/custom/install/his_files/hack_install_b3.php on line 48

nexialys
09-28-2007, 06:18 PM
as it is located in the 3.0x section of the site, and not in the 3.5+ or 3.6, you can be assured that it is not working with the latest, as the entire script was modified between versions.

yahoooh
10-06-2007, 10:12 PM
needed for 3.6.8?

Been Told
10-21-2007, 10:44 AM
Also very much interested in a 3.6 version of this.

periphrastic
10-28-2007, 12:11 AM
^ co-sign

3.6.8 would be great, if you could

droid101
02-03-2008, 04:11 PM
Wow, this is cool. Is there an updated version of this for 3.6.8?

Artes_Marciales
02-04-2008, 04:44 PM
I need it for 3.7 :)

parabat
02-13-2008, 02:56 PM
This Mod is marked as supported, but it seems the developer is not supporting his Mod. No good :(
I would like to see this ported to 3.6.X as well, so hopefully permission will be granted for this to happen.

Is there anyone out there with enough vB knowledge who is willing to write this mod from scratch for the new versions?

-PB