Hi Dark,
I looked at that line in credits_daily.php. Perhaps my post was not clear, or I am missing something, or simply am making a mistake.
I want users who have been inactive for two years to receive no credit for anything (especially credit for having their old posts viewed, since we get a lot of traffic).
Does this one line in credits_daily.php "do it all", in other words, it is the one line that adds user credits for post views, posts, etc.?
Code:
$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET credits = credits + CASE$pcsql ELSE 0 END WHERE credits_canearn = 1")
How about the query_write above that one?
Code:
$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET credits = credits + CASE$cdtsql ELSE 0 END, credits_numrefs = credits_numrefs + CASE$refsql ELSE 0 END WHERE credits_canearn = 1 AND usergroupid IN (" . implode(', ', $goodug) . ")")
;
Thanks!