The Forum has been Updated
The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.
G'day, haven't posted here in a long time but still read what's happening almost every day...
Looking to build a mod to restrict certain users from logging in initially outside normal hours but then for different times.
Thinking I should add a TZ_ID to the FORUM_MEMBERS table linked to 2 new tables FORUM_TIMEZONE and FORUM_TIMEZONE_DEF
FORUM_TIMEZONE:
TZ_ID = integer, identity seed, primary key
TZ_DESCRIPTION
FORUM_TIMEZONE_DEF:
TZ_ID = integer
DAYOFWEEK = integer
START = Integer 4 digits eg 0800
STOP = Integer 4 digits eg 1700
Then some code to check the server day of week/time against user on login against their allowed timezone and throw them back with a 'Outside Allowed hours access violation' message.
Anyone see any issues by going this route or is there an easier way. Anyone done something similar already?<
Looking to build a mod to restrict certain users from logging in initially outside normal hours but then for different times.
Thinking I should add a TZ_ID to the FORUM_MEMBERS table linked to 2 new tables FORUM_TIMEZONE and FORUM_TIMEZONE_DEF
FORUM_TIMEZONE:
TZ_ID = integer, identity seed, primary key
TZ_DESCRIPTION
FORUM_TIMEZONE_DEF:
TZ_ID = integer
DAYOFWEEK = integer
START = Integer 4 digits eg 0800
STOP = Integer 4 digits eg 1700
Then some code to check the server day of week/time against user on login against their allowed timezone and throw them back with a 'Outside Allowed hours access violation' message.
Anyone see any issues by going this route or is there an easier way. Anyone done something similar already?<
Posted
Why split it into 2 tables and what's the purpose of a TZ description? Assuming that you want to use different times for weekdays vs weekends (else why DOW?), you'd only need five fields.
To do what you want, I'd make a single new table; include TZ_ID, WEEKDAY_START, WEEKDAY_STOP, WEEKEND_START & WEEKEND_STOP. I'd then add TZ_ID to the member table & put it into the "register.asp" & "inc_profile.asp" files.
Then for implementation, you would query the (TZ_ID field from the member table) & the (TZ's allowed times from the TZ table) in both "inc_header.asp" & "inc_header_short.asp"; compare them to current time and deny/grant access accordingly.<
To do what you want, I'd make a single new table; include TZ_ID, WEEKDAY_START, WEEKDAY_STOP, WEEKEND_START & WEEKEND_STOP. I'd then add TZ_ID to the member table & put it into the "register.asp" & "inc_profile.asp" files.
Then for implementation, you would query the (TZ_ID field from the member table) & the (TZ's allowed times from the TZ table) in both "inc_header.asp" & "inc_header_short.asp"; compare them to current time and deny/grant access accordingly.<
Posted
Couldn't the users change the time setting on their computers and also change the timezone setting in the profiles to emulate an allowed time?<
Posted
Changing the time or time zone on their computers would be meaningless if the server is comparing the start/stop times to YOUR computer's time. An ability to edit the time zone in their profiles would be necessary for anyone who travels, otherwise they would have to recalculate their time based upon the location they lived when they originally registered.
It would be a lot easier to restrict their login times based upon the first letter of their user name. Then you wouldn't need any additional table or variables.<
It would be a lot easier to restrict their login times based upon the first letter of their user name. Then you wouldn't need any additional table or variables.<
Posted
I think I misunderstood the problem then.
Do you mean something like this (putting this in offline terms):
The office is located on the east coast (USA). The timezone there is EST. Anyone who calls there after 5 PM EST, regardless of where they are calling from, will get an automated reply from the answering machine because no one is there after 5 PM EST.
Is that what you mean by saying the time is based off of YOUR computer's time?
<
Do you mean something like this (putting this in offline terms):
The office is located on the east coast (USA). The timezone there is EST. Anyone who calls there after 5 PM EST, regardless of where they are calling from, will get an automated reply from the answering machine because no one is there after 5 PM EST.
Is that what you mean by saying the time is based off of YOUR computer's time?
<
Posted
Yes, I want to restrict by Server Time regardless of where the user is. Initially 1 Timezone (perhaps timezone is not a good descriptor) for normal office hours but I can see they will want additional timezones set up for users authorised for overtime and on weekends which is why I suggested the 2 tables - 1 with description.<