Welcome, Guest. Please Login or Register.
October 02, 2024, 08:37:34 PM
Home Help Search Log in Register
News: SMF is the next generation in forum software, almost completely re-written from the ground up, make sure you don't fall for cheap imitations that suffer from feature bloat!

YaBB SE Community  |  Development  |  Converters  |  Time of messages? « previous next »
Pages: [1] Reply Ignore Print
Author Topic: Time of messages?  (Read 1137 times)
PioneeR
Llama Hunter
YaBB God
*****
Posts: 767
Time of messages?
« on: May 12, 2002, 10:22:45 AM »		 Reply with quote
When converting from Y1G over to SE.

All messages come across fine.. apart from the time (some seem to get hours added onto them.. thrown into the future)

Anyone else had this happen??
Logged
Jeff Lewis
Global Moderator
YaBB God
*****
Posts: 10149


I'm a llama!

WWW
Re:Time of messages?
« Reply #1 on: May 12, 2002, 01:42:22 PM »		 Reply with quote
Not me  ;D
Logged

My Amazon Wishlist
My Blog
PioneeR
Llama Hunter
YaBB God
*****
Posts: 767
Re:Time of messages?
« Reply #2 on: May 12, 2002, 01:49:32 PM »		 Reply with quote
It happens with all my posts that are converted over.

I have a forum offset of 1 hour..

The original post on the Y1G board was

« on: May 11th, 2002, 10:08am »

Once converted over to SE its

« on: May 11, 2002, 01:08:21 PM »

Anything to do with that fact that SE keeps track of seconds too??
Logged
PioneeR
Llama Hunter
YaBB God
*****
Posts: 767
Re:Time of messages?
« Reply #3 on: May 13, 2002, 06:31:14 PM »		 Reply with quote
Tried a few times to convert.. every time.. all posts get 3 hours added to them (plus a few seconds?!)

Anyone know why??
Logged
PioneeR
Llama Hunter
YaBB God
*****
Posts: 767
Re:Time of messages?
« Reply #4 on: May 13, 2002, 06:53:22 PM »		 Reply with quote
Not too good at SQL.. can just about find my way around phpMyAdmin.

What SQL would I need to subtract 3 hours from every post??
« Last Edit: May 13, 2002, 06:57:33 PM by PioneeR » Logged
Greg Robson
Training to be like Joseph
YaBB SE Developer
YaBB God
*****
Posts: 1459


Hello!

ICQ - 81390136 WWW
Re:Time of messages?
« Reply #5 on: May 14, 2002, 10:01:19 AM »		 Reply with quote
The time is stored using the UNIX time function which returns the number of seconds since midnight at the beginning of 1/1/1970.

So three hours would be 3 * 3600 = 10800.

I still not too good at MySQL but the query should subtract 10800 from each record in the table. :)
Logged
You can't have everything... where would you put it? -- Steve Wright
Jeff Lewis
Global Moderator
YaBB God
*****
Posts: 10149


I'm a llama!

WWW
Re:Time of messages?
« Reply #6 on: May 14, 2002, 12:26:25 PM »		 Reply with quote
I have not tried is but use:

UPDATE messages SET posterTime=posterTime-10800 WHERE posterTime>1

That should do it.
Logged

My Amazon Wishlist
My Blog
PioneeR
Llama Hunter
YaBB God
*****
Posts: 767
Re:Time of messages?
« Reply #7 on: May 15, 2002, 05:33:10 PM »		 Reply with quote
Not sure why it is adding 3 hours when i convert!

But that SQL fixes it  ;D

Thanks
Logged
Jeff Lewis
Global Moderator
YaBB God
*****
Posts: 10149


I'm a llama!

WWW
Re:Time of messages?
« Reply #8 on: May 15, 2002, 05:43:24 PM »		 Reply with quote
Yeah that is weird but glad the SQL worked for you  ;D
Logged

My Amazon Wishlist
My Blog
PioneeR
Llama Hunter
YaBB God
*****
Posts: 767
Re:Time of messages?
« Reply #9 on: May 15, 2002, 05:44:59 PM »		 Reply with quote
All i have to do now.. is close down my Y1G board.. and entice my members over to the SE version!!

Logged
Chris Cromer
The Strange One
Mod Team
YaBB God
*****
Posts: 3152


I am just a figment of your imagination.

WWW
Re:Time of messages?
« Reply #10 on: May 15, 2002, 05:49:53 PM »		 Reply with quote
Tell them you will give them cheese if they come over to the dark... errr I mean SE side! ;)

Ah the power of cheese! ;D
Logged
Chris Cromer

I am not suffering from insanity, I am enjoying every minute of it.
PioneeR
Llama Hunter
YaBB God
*****
Posts: 767
Re:Time of messages?
« Reply #11 on: May 17, 2002, 01:24:06 AM »		 Reply with quote
With the aid of that lovely New IM mod... they are finally coming over and helping me test it!! About time :-)
Logged
Chris Cromer
The Strange One
Mod Team
YaBB God
*****
Posts: 3152


I am just a figment of your imagination.

WWW
Re:Time of messages?
« Reply #12 on: May 17, 2002, 02:04:00 AM »		 Reply with quote
Well I am glad my mod is of some use to people. :)
Logged
Chris Cromer

I am not suffering from insanity, I am enjoying every minute of it.
Pages: [1] Reply Ignore Print 
YaBB SE Community  |  Development  |  Converters  |  Time of messages? « previous - next »
 


Powered by MySQL Powered by PHP YaBB SE Community | Powered by YaBB SE
© 2001-2003, YaBB SE Dev Team. All Rights Reserved.
SMF 2.1.4 © 2023, Simple Machines
 Valid XHTML 1.0! Valid CSS

Page created in 0.120 seconds with 21 queries.