User points

[klik]

Hi,

When a user successfully logins into my system I have the following code:

mysql_query("UPDATE cms_users SET user_points=user_points+1 WHERE username='$username'");

This, as you can see, updates the users points by adding one onto the existing value after every successful login.

What I would like to do, is only update the users points once per day, to prevent people from logging in multiple times just to gain points.

I have no clue how to code this though.

I have last_login stored in the database for every user, if this will aid the process.

Help very much appreciated.

[nemonoman]

Add a timestamp column to the table, then

mysql_query("
UPDATE cms_users
SET user_points=user_points+1
WHERE username='$username'
AND timestampColumn <NOW()-INTERVAL 1 DAY");

Change timestampColumn above to the name you assign to the timestamp column.