$id = (int)$_REQUEST['id']; $blocktime = (int)$_REQUEST['blocktime']; $blocktimesec =60*$blocktime; $time=$db->GetOne("SELECT NOW()+".$blocktimesec); $db->Execute("UPDATE useri SET user_perm='blocked',user_blocked_till= ".$time.", user_block_tot =".$blocktime." WHERE user_id=".$id."");
$blocktime is amount of minutes user will be blocked for
user_block_tot is db field where amount of minutes user will be blocked for is stored (as integer)
user_blocked_till is db field where time whom till user will be blocked is stored (as timestamp)
problem is that something is stored in user_blocked_till but seems that it is not the time of present moment increased by the minutes user is blocked for, maybe someone could help what is not right in my code to make this happen?