<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16890" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=507363220-02112009><FONT face=Arial
color=#0000ff size=2>sounds interesting .. by changing outside surrounding ..
you mean to completely</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=507363220-02112009><FONT face=Arial
color=#0000ff size=2>change/replace the OSGRID provided textures for sky and
ocean ? hmm there we</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=507363220-02112009><FONT face=Arial
color=#0000ff size=2>could need some infos from the people with deeper knowledge
of the sim source.</FONT></SPAN></DIV>
<DIV><SPAN class=507363220-02112009></SPAN><FONT face=Arial><FONT
color=#0000ff><FONT size=2></FONT></FONT></FONT> </DIV>
<DIV><FONT><FONT><FONT face=Arial color=#0000ff size=2>the <SPAN
class=507363220-02112009>"</SPAN>create a
box and live in it" (i do not say this is a bad i<SPAN
class=507363220-02112009>d</SPAN>ea as i have also an</FONT></FONT></FONT></DIV>
<DIV><FONT><FONT color=#0000ff><FONT size=2><SPAN
class=507363220-02112009></SPAN></FONT></FONT></FONT><SPAN
class=507363220-02112009></SPAN><FONT face=Arial><FONT color=#0000ff><FONT
size=2>i<SPAN class=507363220-02112009>sland with 6 of those 256x256 boxes each
on top of each other for differnt worlds)</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=507363220-02112009>is for a start </SPAN></FONT></FONT></FONT><FONT
face=Arial><FONT color=#0000ff><FONT size=2>a<SPAN class=507363220-02112009>
very good idea. so you can test if you like the new surrounding ..
</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=507363220-02112009></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=507363220-02112009>but i dont think the sorrounding (blue to black sky) is
replaceable because of sun/moon phases .. ?</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=507363220-02112009></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=507363220-02112009>best regards</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=507363220-02112009>Wordfromthe Wise</SPAN></FONT></FONT></FONT></DIV>
<DIV><BR></DIV>
<DIV class=OutlookMessageHeader lang=de dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>Von:</B> opensim-users-bounces@lists.berlios.de
[mailto:opensim-users-bounces@lists.berlios.de] <B>Im Auftrag von </B>Len
Brown<BR><B>Gesendet:</B> Montag, 2. November 2009 21:10<BR><B>An:</B>
opensim-users@lists.berlios.de<BR><B>Betreff:</B> Re: [Opensim-users] How is
"Date/Time" Recorded in the Database?<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV>I changed the avatar birthdate by only 10 seconds and it still killed my
inventory and made my avatar Ruth.</DIV>
<DIV> </DIV>
<DIV>I'm going to check some other things in the database and see what I can
come up with. There must be something linked to the avatar birthdate for
it to break everything like this.<BR></DIV>
<DIV>- Len<BR></DIV>
<DIV class=gmail_quote>On Mon, Nov 2, 2009 at 1:53 PM, Len Brown <SPAN
dir=ltr><<A
href="mailto:lenwbrown@gmail.com">lenwbrown@gmail.com</A>></SPAN> wrote:<BR>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<DIV>WARNING:</DIV>
<DIV> </DIV>
<DIV> Thankfully I am religious about making
backups. I made a backup of my database just before asking about the
time/date question.</DIV>
<DIV> </DIV>
<DIV> I just tried this twice to make sure it is not a
quirk...</DIV>
<DIV> </DIV>
<DIV> I shut down OpenSim. Then went into the
database and changed the "birthday" of my avatare to 1257076800 which is
November 1, 2009 12:00:00 (noon). I then saved the change in the
database then restarted OpenSim.</DIV>
<DIV> </DIV>
<DIV>Two things:</DIV>
<DIV> </DIV>
<DIV> My avatar is the default Ruth (with a birthday
of Nov 1)</DIV>
<DIV> </DIV>
<DIV> My entire inventory is gone.</DIV>
<DIV> </DIV>
<DIV>Again, thankfully I had a backup (whew!). I shut everything down
and restored from backup twice - both times logging in and my custom
avatar was intact. Each time I changed the birthday in the database it
turned my avatar to Ruth and killed my entire inventory.</DIV>
<DIV> </DIV>
<DIV> I'm guessing "maybe" the issue is that the time
stamp I gave the avatar is prior to the time stamp when I actually set
everything up - it was in the late evening of Nov 1st.</DIV>
<DIV> </DIV>
<DIV> So at least I have a backup - so everything is
running perfectly again.</DIV>
<DIV> </DIV>
<DIV> Any suggestions on why the date change for teh
AV killed everything else?</DIV>
<DIV> </DIV>
<DIV> Of note also - everything in-world was still
there, and the textual stuff I'd added to my avatar's profile was also
intact.</DIV>
<DIV class=im>
<DIV> </DIV>
<DIV>- Len W. Brown</DIV>
<DIV> <A href="mailto:lenwbrown@gmail.com"
target=_blank>lenwbrown@gmail.com</A> <BR></DIV></DIV>
<DIV>
<DIV></DIV>
<DIV class=h5>
<DIV class=gmail_quote>On Mon, Nov 2, 2009 at 1:32 PM, Len Brown <SPAN
dir=ltr><<A href="mailto:lenwbrown@gmail.com"
target=_blank>lenwbrown@gmail.com</A>></SPAN> wrote:<BR>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<DIV>Very cool and thank you very much. Wow, I didn't expect such a
quick reply.</DIV>
<DIV> </DIV>
<DIV>Much appreciated!<BR><BR></DIV>
<DIV class=gmail_quote>
<DIV>
<DIV></DIV>
<DIV>On Mon, Nov 2, 2009 at 1:31 PM, Chris Hart <SPAN dir=ltr><<A
href="mailto:Chris@codetorque.co.uk"
target=_blank>Chris@codetorque.co.uk</A>></SPAN> wrote:<BR></DIV></DIV>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<DIV>
<DIV></DIV>
<DIV>
<DIV lang=EN-GB link="blue" vlink="purple">
<DIV>
<P class=MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d">Sounds
like a timezone conflict between where your server thinks it is and where
your client thinks you are when it converts to human-readable
time.</SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d"></SPAN> </P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d">The
number in the database is Epoch time which means the time is nice and
universal and timezone-independant:</SPAN></P>
<P class=MsoNormal><A href="http://en.wikipedia.org/wiki/Unix_time"
target=_blank>http://en.wikipedia.org/wiki/Unix_time</A><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d"></SPAN></P>
<P class=MsoNormal><A href="http://www.epochconverter.com/"
target=_blank>http://www.epochconverter.com/</A><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d"></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d"></SPAN> </P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d">Hope that
helps,</SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d">Chris</SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d"></SPAN> </P>
<DIV
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0cm; BORDER-TOP: #b5c4df 1pt solid; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; PADDING-TOP: 3pt; BORDER-BOTTOM: medium none">
<P class=MsoNormal><B><SPAN lang=EN-US
style="FONT-SIZE: 10pt">From:</SPAN></B><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> <A
href="mailto:opensim-users-bounces@lists.berlios.de"
target=_blank>opensim-users-bounces@lists.berlios.de</A> [mailto:<A
href="mailto:opensim-users-bounces@lists.berlios.de"
target=_blank>opensim-users-bounces@lists.berlios.de</A>] <B>On Behalf Of
</B>Len Brown<BR><B>Sent:</B> 02 November 2009 7:27 PM<BR><B>To:</B> <A
href="mailto:opensim-users@lists.berlios.de"
target=_blank>opensim-users@lists.berlios.de</A><BR><B>Subject:</B>
[Opensim-users] How is "Date/Time" Recorded in the
Database?</SPAN></P></DIV>
<DIV>
<DIV></DIV>
<DIV>
<P class=MsoNormal> </P>
<DIV>
<P class=MsoNormal>Hi Everyone!</P></DIV>
<DIV>
<P class=MsoNormal> </P></DIV>
<DIV>
<P class=MsoNormal> Do any of you know how OpenSim
saves time in the database?</P></DIV>
<DIV>
<P class=MsoNormal> </P></DIV>
<DIV>
<P class=MsoNormal> Here's the situation - I
started a brand new fully updated "bleeding edge" OpenSim server
at home on November 1st. The region shows it was created on Nov 1st
but after creating a new skin, shape, etc for my new avatar - I
noticed my avatar profile says it was created on November 2nd.</P></DIV>
<DIV>
<P class=MsoNormal> </P></DIV>
<DIV>
<P class=MsoNormal> In the database for my avatar
is the following: <STRONG>1257137090</STRONG> to represent when the
avatar was created. I suppose I could make the number slightly
smaller in the database and see what happens, but if there is some "basic
and simple" means that the current date is encoded, what is it? I
want my avatar to also show a birthday of November 1, like the region it's
building...</P></DIV>
<DIV>
<P class=MsoNormal> </P></DIV>
<DIV>
<P class=MsoNormal>Any hints?</P></DIV>
<DIV>
<P class=MsoNormal> </P></DIV>
<DIV>
<P class=MsoNormal>Thanks!</P></DIV>
<DIV>
<P class=MsoNormal> </P></DIV>
<DIV>
<P class=MsoNormal>- Len W. Brown</P></DIV>
<DIV>
<P class=MsoNormal> <A
href="mailto:lenwbrown@gmail.com" target=_blank>lenwbrown@gmail.com</A>
</P></DIV></DIV></DIV>
<P><SPAN style="FONT-SIZE: 10pt">No virus found in this incoming
message.<BR>Checked by AVG - <A href="http://www.avg.com/"
target=_blank>www.avg.com</A><BR>Version: 8.5.423 / Virus Database:
270.14.39/2468 - Release Date: 11/02/09
07:51:00</SPAN></P></DIV></DIV><BR></DIV></DIV>_______________________________________________<BR>Opensim-users
mailing list<BR><A href="mailto:Opensim-users@lists.berlios.de"
target=_blank>Opensim-users@lists.berlios.de</A><BR><A
href="https://lists.berlios.de/mailman/listinfo/opensim-users"
target=_blank>https://lists.berlios.de/mailman/listinfo/opensim-users</A><BR><BR></BLOCKQUOTE></DIV><BR></BLOCKQUOTE></DIV><BR></DIV></DIV></BLOCKQUOTE></DIV><BR></BODY></HTML>