[HakkieDEV]

Originally Posted by miz

hmm
you mean use cornjob from admincp right ?

then write a php page that every time we run it its doing the update to query's
then just add it via admincp..

Uhum, I know how to add a php file into the cronjob list in admincp.

I only have trouble in automating the process of selecting multiple fields and after modifications, inserting it again in multiple fields.

I know how to do it for a single field:

[sql]
$single= $DB_site->query("SELECT posts, helppoints FROM user WHERE userid=6");
$posts = $single['posts'];
$helppoints = $single['helppoints'];
$contributionpoints = $posts + $helppoints*3;
$update=$DB_site->query_first("UPDATE user SET contributionpoints=$contributionpoints WHERE userid=6");
[/sql]

However, this only works for 1 user per time.

I would like the same formula, but it should do this for ALL users.