[LBmtb]

Originally Posted by RMS-Chef

What kind of queries are involved here and can I alter it to update cache like every 12 hours instead? I just get a little worried since I have over 1.3 million "thanks" issued on my board. Thanks for any advice you may be able to give.

The query is:

SELECT p.username, p.userid
FROM {$this->db_prefix}post_thanks t INNER JOIN {$this->db_prefix}post p 
ON t.postid = p.postid 
WHERE t.date BETWEEN ". $this->beginning ." AND ". $this->end_month ."
ORDER BY date DESC

You CAN change the option for how long it takes to refresh the query. You'd have to supply constructor arguments to the class when you create the instance of it (in the php file). For a thourough rundown on what arguments it takes and how to do it, check out this link. It's on the last paragraph of page 272 and then beginning of the next page.

Let me know if you need help with that. Good luck!