Creating a cronjob

[HakkieDEV]

Hi

Inside the table user I have 3 fields, posts and helppoints, contributionpoints.

Now, I would like to have a cronjob do every 24 hours a calculation like this:

$posts+$helppoints*3=$contributionpoints.

Now, it should update all contributionpoints fields in the table user.

And, like you've guessed, I have totally no idea how to do that. Anyone willing to help me a bit?

[sabret00the]

i have to go out for a few hours but i'll write the code for you when i come back

[HakkieDEV]

Originally Posted by sabret00the

i have to go out for a few hours but i'll write the code for you when i come back

Now that is a fast response!

I know how to make queryes/update/insert/etc, but I have no idea how to select data from multiple fields, then do some modifications with it and then update the table again.

It would be really helpfull.

Thanks in advance.

[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..

[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.

[Marco van Herwaarden]

[sql]UPDATE user SET contributionpoints=posts + helppoints * 3;[/sql]

[HakkieDEV]

Originally Posted by MarcoH64

[sql]UPDATE user SET contributionpoints=posts + helppoints * 3;[/sql]

Oh my god, tell me it isn't that simple? /me == stupid.

It is definitly this simple.

I'm shocked.

Thanks a bunch, I was thinking about much more difficult solutions.

[Marco van Herwaarden]

Yes it is that simple

It will for each row take the rows value for posts and helppoints, multiply by 3, then store back in the contributepoints for that same row. You could add a WHERE clause if you want it to limit to only some users.

[HakkieDEV]

Originally Posted by MarcoH64

Yes it is that simple

It will for each row take the rows value for posts and helppoints, multiply by 3, then store back in the contributepoints for that same row. You could add a WHERE clause if you want it to limit to only some users.

Thanks a lot mate, I already inserted a WHERE clause.

It working like a charm now.