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.

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 [sql], ((views * ) + (replycount * )) AS score[/sql]
should have the values of the weight for views and replies inserted there. So for example:
[sql], ((views * VIEWWEIGHT) + (replycount * REPLYWEIGHT)) AS score[/sql]
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.

Thanks for the fun hack! :) Good Job!

This is what is in the database:
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.

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.

uCash unless you mean adding a simple to show thread to show that "this a thread of the month winner"

it seems to work of views, it would be nice to have something like replies * views = weight

I have the same issue that docvader does so there is an issue there. I am just not sure of the resolution.

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.

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.

Current selection score is calculated as follows:
score = (views * weight_views) + (replies * weight_replies)

General:
Will look soon into a uShop integration.

Thanks!!!!!