Strategic problem of logouts

[sansoft]

Hi,

this one's very imp for me.i have got two links on a single form namely logintime and logouttime. when the user comes to the office and starts the project he/she first logs in and after 8 hrs of work logs out.

ok fine thats happening.......no issues.the values are inserted in the table taskdatetime when logging in and updated when "logging out".

now there may be some cheaters who can keep on updating the logout field.

what i want is once u "LOGOUT" of the scene there can be no way a user can again update the table.Any suggesstions???below is the code.....which can be updated at any time.i dont want that...plz help

Code: Select all


include"../include/mysqlconnect.php";

$now = time();

$anh = $date = date("Y-m-d H:i:s a",$now);

$sql="update taskdatetime set outtime='$anh' where user_id='$sesuserid'" ;

$result=mysql_query($sql,$conn);









[Redcircle]

now there may be some cheaters who can keep on updating the logout field.

I'm not exactly sure what you mean by this. They are extending the logout time after they have logged out?

[gesf]

I supose you´re working with sessions and/or cookies in some way!
Anyway, you need to check if the user is active (logged in), before update his/her data!

Or you can make something like (example):

Code: Select all

if(logout_time < time_now) ...

Where logout_time is the datetime stored when the user logs out from your system and time_now is the actual datetime (always server time)!