update om_timezone set order_id = 32 where id = 42;

On Fri, Aug 23, 2013 at 11:49 AM, John Tran <findingj...@gmail.com> wrote:

> Maxim
>
> From the below:
> | 39 | Alberta, Colorado,
> Phoenix                                                   |       25 |
> | 40 | Canada (Alberta), Mexico (Chihuahua), USA
> (Colorado)                         |       26 |
> | 41 | Canada (northeastern British Columbia), Mexico (Sonora), USA
> (Arizona)       |       26 |
> | 42 | Vancouver, Portland, Las Vegas,
> California                                   |       27 |
> | 43 | Anchorage, Fairbanks,
> Juneau                                                 |       28 |
>
> If my choice of tZ is 42, would I my command be:
>
> update om_timezone set order_id = 27 where id = 44;
>
>
> On Thu, Aug 22, 2013 at 9:28 PM, Maxim Solodovnik <solomax...@gmail.com>wrote:
>
>> stop OM
>>
>> open connection to your database using anything you like
>> run following
>> select id, label, order_id from om_timezone;
>> this will give you the full list on timezones
>>
>> update om_timezone set order_id = 32 where id = 41;
>>
>> to set highest order for your timezone
>>
>> start OM
>>
>>
>> On Fri, Aug 23, 2013 at 11:19 AM, John Tran <findingj...@gmail.com>wrote:
>>
>>> Oh.  I am using MySQL.
>>>
>>>
>>> On Thu, Aug 22, 2013 at 9:17 PM, Maxim Solodovnik 
>>> <solomax...@gmail.com>wrote:
>>>
>>>> unfortunately it is not enough :(
>>>> What DB are you using?
>>>>
>>>>
>>>> On Fri, Aug 23, 2013 at 11:15 AM, John Tran <findingj...@gmail.com>wrote:
>>>>
>>>>> Not in DB, i wouldnt' know how.  I make the change in
>>>>> usr/lib/red5/webapps/
>>>>> openmeetings/languages/timezones.xml and move GMT-8 to the top of the
>>>>> list, above Samoa  and change the orderId to 0(zero) and restart red5
>>>>>
>>>>>
>>>>> On Thu, Aug 22, 2013 at 9:12 PM, Maxim Solodovnik <
>>>>> solomax...@gmail.com> wrote:
>>>>>
>>>>>> did you moved it in timezones.xml or in the DB?
>>>>>> have you just change the line? or also change "orderId" value?
>>>>>>
>>>>>>
>>>>>> On Fri, Aug 23, 2013 at 11:04 AM, John Tran <findingj...@gmail.com>wrote:
>>>>>>
>>>>>>> I am on  GMT-8.  I did move it to the top of the list and changed it
>>>>>>> to 0(zero).  It did not help.   Still showed Samoa as the first on the 
>>>>>>> list
>>>>>>> as default.
>>>>>>>
>>>>>>>
>>>>>>> On Thu, Aug 22, 2013 at 9:00 PM, Maxim Solodovnik <
>>>>>>> solomax...@gmail.com> wrote:
>>>>>>>
>>>>>>>> First one is selected in case timezone offset was not retrieved or
>>>>>>>> timezone with your offset was not found.
>>>>>>>> Also you can check browser javascript console (to ensure there were
>>>>>>>> no errors)
>>>>>>>>
>>>>>>>>  What Time Zone do you have?
>>>>>>>> To move you timezone on top you might need to edit database and
>>>>>>>> change orderId of your time zone to have lowest number
>>>>>>>>
>>>>>>>>
>>>>>>>> On Fri, Aug 23, 2013 at 10:50 AM, John Tran 
>>>>>>>> <findingj...@gmail.com>wrote:
>>>>>>>>
>>>>>>>>> Maxim
>>>>>>>>>
>>>>>>>>> It does not seem to pick it up for whatever reason. When I do an
>>>>>>>>> invite an pick a "period" option, it default to GMT+13 (Samoa), first 
>>>>>>>>> one
>>>>>>>>> on the list.
>>>>>>>>>
>>>>>>>>> -john-
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> On Thu, Aug 22, 2013 at 8:46 PM, Maxim Solodovnik <
>>>>>>>>> solomax...@gmail.com> wrote:
>>>>>>>>>
>>>>>>>>>> according to the code:
>>>>>>>>>> Timezone offset is taking from your browser
>>>>>>>>>> Timezone with your timezone offset is preselected
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> On Fri, Aug 23, 2013 at 7:52 AM, John Tran <findingj...@gmail.com
>>>>>>>>>> > wrote:
>>>>>>>>>>
>>>>>>>>>>> Thanks Lee.  Already tried that.
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> On Thu, Aug 22, 2013 at 4:45 PM, Lee Saunders <
>>>>>>>>>>> leesenglishless...@gmail.com> wrote:
>>>>>>>>>>>
>>>>>>>>>>>> Go here: \webapps\openmeetings\languages\timezones.xml. You can
>>>>>>>>>>>> change the order in that.
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> On Fri, Aug 23, 2013 at 12:04 AM, Lee Saunders <
>>>>>>>>>>>> leesenglishless...@gmail.com> wrote:
>>>>>>>>>>>>
>>>>>>>>>>>>> I could find the default time zone in Administration >
>>>>>>>>>>>>> Configuration > Number 30 in the list.
>>>>>>>>>>>>> There is no selection box to change it though.
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> On Thu, Aug 22, 2013 at 9:46 PM, John Tran <
>>>>>>>>>>>>> findingj...@gmail.com> wrote:
>>>>>>>>>>>>>
>>>>>>>>>>>>>> Does one know how to change or where to go to change the
>>>>>>>>>>>>>> default timezone shown in the invitation popup.  Somewhere in 
>>>>>>>>>>>>>> archive
>>>>>>>>>>>>>> someone said moving the intended timzone to the top of the list 
>>>>>>>>>>>>>> in
>>>>>>>>>>>>>> /usr/lib/red5/webapps/openmeetings/languages/timezones.xml 
>>>>>>>>>>>>>> worked for
>>>>>>>>>>>>>> them.  It didn't work for me when I tried it, even when I 
>>>>>>>>>>>>>> changed the
>>>>>>>>>>>>>> orderId to 0
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> --
>>>>>>>>>>>>>> -john-
>>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> --
>>>>>>>>>>> jt
>>>>>>>>>>> ________________________________
>>>>>>>>>>> John Tran
>>>>>>>>>>> Northern California, CA
>>>>>>>>>>> findingj...@gmail.com
>>>>>>>>>>>      ICQ IM: 27741710
>>>>>>>>>>>     AOL IM: find1ngj0hn
>>>>>>>>>>> Yahoo! IM: findingj0hn
>>>>>>>>>>>    MSN IM: findingj...@hotmail.com
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> --
>>>>>>>>>> WBR
>>>>>>>>>> Maxim aka solomax
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> --
>>>>>>>>> jt
>>>>>>>>> ________________________________
>>>>>>>>> John Tran
>>>>>>>>> Northern California, CA
>>>>>>>>> findingj...@gmail.com
>>>>>>>>>      ICQ IM: 27741710
>>>>>>>>>     AOL IM: find1ngj0hn
>>>>>>>>> Yahoo! IM: findingj0hn
>>>>>>>>>    MSN IM: findingj...@hotmail.com
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>> WBR
>>>>>>>> Maxim aka solomax
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> jt
>>>>>>> ________________________________
>>>>>>> John Tran
>>>>>>> Northern California, CA
>>>>>>> findingj...@gmail.com
>>>>>>>      ICQ IM: 27741710
>>>>>>>     AOL IM: find1ngj0hn
>>>>>>> Yahoo! IM: findingj0hn
>>>>>>>    MSN IM: findingj...@hotmail.com
>>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> WBR
>>>>>> Maxim aka solomax
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> jt
>>>>> ________________________________
>>>>> John Tran
>>>>> Northern California, CA
>>>>> findingj...@gmail.com
>>>>>      ICQ IM: 27741710
>>>>>     AOL IM: find1ngj0hn
>>>>> Yahoo! IM: findingj0hn
>>>>>    MSN IM: findingj...@hotmail.com
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> WBR
>>>> Maxim aka solomax
>>>>
>>>
>>>
>>>
>>> --
>>> jt
>>> ________________________________
>>> John Tran
>>> Northern California, CA
>>> findingj...@gmail.com
>>>      ICQ IM: 27741710
>>>     AOL IM: find1ngj0hn
>>> Yahoo! IM: findingj0hn
>>>    MSN IM: findingj...@hotmail.com
>>>
>>
>>
>>
>> --
>> WBR
>> Maxim aka solomax
>>
>
>
>
> --
> jt
> ________________________________
> John Tran
> Northern California, CA
> findingj...@gmail.com
>      ICQ IM: 27741710
>     AOL IM: find1ngj0hn
> Yahoo! IM: findingj0hn
>    MSN IM: findingj...@hotmail.com
>



-- 
WBR
Maxim aka solomax

Reply via email to