[Marco van Herwaarden]

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.