A how-to-question

[lintu]

Dear Pligg Experts,

I have a requirement to run a job on a nightly basis that will update a column on the user and links tables based on a calculation. I am calling this field ‘Accuracy Rating’ and is similar to the user’s karma rating.

I looked at the code on the karma.php file and could not get come up with a workable solution. Appreciate it if someone could give me some pointers or sample code.

Thanks,
Abu

[ChuckRoast]

I'm not sure I completely grasp the question. I would assume you will need to build a php file in your root to be called nightly by your cron.

Add in the necessary php includes files

Then use something like
$db->query($sql="UPDATE " . table_users . " SET WHATEVERCOLUMN+'".$db->escape($_REQUEST['WHATEVERCOLUMN'])."' WHERE user_login='".$db->escape($_REQUEST['WHATEVERCOLUMN'])."'");

Hope that at least gets you pointed in the right direction.

[lintu]

Chuckroast,

That's exactly how I ended up doing and it's working. Thanks.

Closing this thread.