Fix for Aurora: Chect Check Fails today does not reset

[757jterrell]

It was brought to my attention that the cheat check today field does not reset on the admin panels Cheat Check Failure Manager here is the fix:

go to your cron.php file and make line 136 has what is added in bold:

$sql=$Db1->query("UPDATE user SET clicked_today=0, xclicked_today=0, ptphits_today=0, earned_today=0, ptra_clicks_today=0, emails_today=0, floodguard_today=0, ref_hits_unique=0, ref_hits_raw=0, clicksref=0, referral_earns_today=0");

$sql=$Db1->query("UPDATE cheat_failed SET failed_today=0");


This fix as been added to the SDR 3 Sept 1, 2011 Update.

[reider666]

Thanks

[vizdo]

Database error: Invalid SQL: UPDATE user SET clicked_today=0, xclicked_today=0, failed_today=0, ptphits_today=0, earned_today=0, ptra_clicks_today=0, emails_today=0, floodguard_today=0, ref_hits_unique=0, ref_hits_raw=0, clicksref=0, referral_earns_today=0
MySQL Error: 1054 (Unknown column 'failed_today' in 'field list')
Session halted.

[bprasetio]

I think the failed_today is stored in cheat_failed table, so lets try with this modification:

$sql=$Db1->query("UPDATE user SET clicked_today=0, xclicked_today=0, ptphits_today=0, earned_today=0, ptra_clicks_today=0, emails_today=0, floodguard_today=0, ref_hits_unique=0, ref_hits_raw=0, clicksref=0, referral_earns_today=0");

$sql=$Db1->query("UPDATE cheat_failed SET failed_today=0");

[757jterrell]

Good catch, updated the OP