Hello, All ! (sorry for my pure english :) I've made expire_date for customer user. This is int (unixtimestamp) field in customer_user table and 5 (or so) strings in CustomerAuth/DB.pm. If customer account is expired then auth failed and some log go to otrs.log. Also I want to make available to set expire_date in admin interface in "Customer User Management". How I can commit this features into CVS ? wbr, Abylai Ospan
Hi Abylai, Abylai Ospan wrote:
I've made expire_date for customer user. This is int (unixtimestamp) field in customer_user table and 5 (or so) strings in CustomerAuth/DB.pm. If customer account is expired then auth failed and some log go to otrs.log. Also I want to make available to set expire_date in admin interface in "Customer User Management".
How I can commit this features into CVS ?
Just post it oh the list. Then let's discuss about it! .-)
wbr, Abylai Ospan
Martin Edenhofer -- ((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg http://www.otrs.de/ :: Manage your communication!
Hello, Martin.
How I can commit this features into CVS ? Just post it oh the list. Then let's discuss about it! .-)
First need to update db to create new column: ALTER TABLE customer_user ADD COLUMN expire_date int default 0; then cvs diff CustomerAuth/DB.pm Index: CustomerAuth/DB.pm =================================================================== RCS file: /home/cvs/otrs/Kernel/System/CustomerAuth/DB.pm,v retrieving revision 1.11 diff -r1.11 DB.pm 17a18
use Time::Local; 97a99 my $expire_date = ''; 100c102 < my $SQL = "SELECT $Self->{Pw}, $Self->{Key}".
my $SQL = "SELECT $Self->{Pw}, $Self->{Key}, expire_date".
108a111
$expire_date = $Row[2];
118a122,129
if ($expire_date != 0 && $expire_date < time ){ $Self->{LogObject}->Log( Priority => 'notice', Message => "CustomerUser: User '$User' expired !
(REMOTE_ADDR: $RemoteAddr)",
); return; };
default value is 0 (never expire). is it ok ? :) wbr, Abylai Ospan
participants (2)
-
Abylai Ospan -
Martin Edenhofer