<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> </div>
<div>- Len W. Brown</div>
<div> <a href="mailto:lenwbrown@gmail.com">lenwbrown@gmail.com</a> <br></div>
<div class="gmail_quote">On Mon, Nov 2, 2009 at 1:32 PM, Len Brown <span dir="ltr"><<a href="mailto:lenwbrown@gmail.com">lenwbrown@gmail.com</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<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 class="h5">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 style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div>
<div></div>
<div class="h5">
<div lang="EN-GB" vlink="purple" link="blue">
<div>
<p class="MsoNormal"><span style="COLOR: #1f497d; FONT-SIZE: 11pt">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="COLOR: #1f497d; FONT-SIZE: 11pt"> </span></p>
<p class="MsoNormal"><span style="COLOR: #1f497d; FONT-SIZE: 11pt">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="COLOR: #1f497d; FONT-SIZE: 11pt"></span></p>
<p class="MsoNormal"><a href="http://www.epochconverter.com/" target="_blank">http://www.epochconverter.com/</a><span style="COLOR: #1f497d; FONT-SIZE: 11pt"></span></p>
<p class="MsoNormal"><span style="COLOR: #1f497d; FONT-SIZE: 11pt"> </span></p>
<p class="MsoNormal"><span style="COLOR: #1f497d; FONT-SIZE: 11pt">Hope that helps,</span></p>
<p class="MsoNormal"><span style="COLOR: #1f497d; FONT-SIZE: 11pt">Chris</span></p>
<p class="MsoNormal"><span style="COLOR: #1f497d; FONT-SIZE: 11pt"> </span></p>
<div style="BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0cm; PADDING-RIGHT: 0cm; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
<p class="MsoNormal"><b><span style="FONT-SIZE: 10pt" lang="EN-US">From:</span></b><span style="FONT-SIZE: 10pt" lang="EN-US"> <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>