Originally Posted by TTG

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 !?

Originally Posted by Polo

so is this mod working correctly for anyone?

Originally Posted by MarcoH64

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.

Originally Posted by MarcoH64

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.