osTicket Community Forums

Adjusting Time Zone Using The My Preference Link

1. I login to OsTicket with my primary admin username and password.
2. I click on the My Preference Link.
3. I scrol down to the section that says time zone, and select server time and click on save.
4. A staff member, jill, repeats the same steps above and logs into there admin account.
5. Jill clicks on the My Preference link under her account.
6. Jill scrols down to the time zone section, and selects GMT -6 for central standard time, then she clicks on the save button.
When the primary admin then logs in, and then clicks on his My Preference link, the admin's time zone was changed to Jill's GMT -6 time zone, instead of keeping the admin's default time zone of server time zone GMT -4.

I love this kind of bug - look in /scp/profile.php around line 30 and you'll notice the problem !

$sql='UPDATE '.STAFF_TABLE.' SET updated=NOW() '.
',daylight_saving='.db_input(isset($_POST['daylight_saving'])?1:0).
',max_page_size='.db_input($_POST['max_page_size']).
line 30 >>> ',timezone_offset='.db_input($_POST['timezone_offset']);
' WHERE staff_id='.db_input($thisuser->getId());

obviously remove the semi-colon and replace with a dot so that line 30 is now,

',timezone_offset='.db_input($_POST['timezone_offset']).


See also my new bug http://osticket.com/forums/project.php?issueid=148 for a related timezone/daylight issue.