time zone mod problems

[Jayphen]

I have installed the time zone mod and it seems when I put it forward to the time it should be at, the images don't show (because I have posted them ahead of the time the server is at, and pixelpost won't show images that are posted with a date that hasn't arrived yet).

so basically, if I put my timezone forward 9 hours and post an image, that image won't show up until 9 hours later.

[usafdcc]

I believe that is the whole idea of posting in the future. I do that to post 3 or 4 days worth of photo at one sitting.

[Jayphen]

yes but you don't seem to understand my problem. if I set my time forward 19 hours to make it the correct time in Sydney, Australia (to make up for the difference in my server time), if I post an image, it is not displayed until 19 hours later. in the admin control panel it says the correct time and date, and it should show up on my photoblog immediately with that time and date.

the timezone mod needs to modify index.php and not just admin/index.php.. I need them both to be put forward 19 hours, not just admin/index.php.

I hope that someone understands. I'm having difficulty explaining my problem.

[Jayphen]

hmm.. say I put my timezone ahead 19 hours with the mod, if I go to post an image it says the date is this (right now, as I speak):

2005-02-04 17:21

the image is posted with that date attached to it. BUT my index.php doesn't recognise that that date is right NOW, because it hasn't been modified with the same changes in admin/index.php.. so when the SERVER reaches 2005-02-04 17:21, the image will display. I want it to display right NOW, because right now it is 2005-02-04 17:21 where I am.

hopefully that makes it a little clearer.

[usafdcc]

Okay, next question. After installing the mod, under admin/options, did you adjust the time offset for your time zone. I just have to ask

[Jayphen]

yes. I typed in 19

[Jayphen]

bump.

this is keeping my photoblog from going online.

[Anonymous]

Sorry about that! The bug's now fixed and tested. You can download an update from the link below:

http://www.pixelpost.org/index.php?x=downloads&details=36

Please also ensure you always backup those files that are affected in the patch (ie. the index.php files).

Thanks,

Remy.

[n0d3]

Just to be clear, all I need to do is to add the new code that retrieves the time offset to my main index.php then import the SQL query from the .txt file? Nice addon btw. :D

[Jayphen]

awesome, thanks alot remy :)

[Anonymous]

Just to be clear, all I need to do is to add the new code that retrieves the time offset to my main index.php then import the SQL query from the .txt file? Nice addon btw. :D

Yep - that's correct, but I can't repeat myself enough - make sure you've got backups of the files you're changing.

Remy.

[blinking8s]

Ill test it out in the morning, although Ive made a lot of changes in my index so a breakdown of the code altered/added might be nice for some of us.

your effort is highly highly appreciated though! keep it up!

[Jayphen]

yeah, I used WinMerge to make the changes. it does get tedious after awhile.

[Anonymous]

Ill test it out in the morning, although Ive made a lot of changes in my index so a breakdown of the code altered/added might be nice for some of us.

your effort is highly highly appreciated though! keep it up!

I'm happy to send a patch file for the admin index and the root index file if that would help? The only thing is it might be better not to include any context if you've changed your index files that much.

Happy to help.

[yungyaw]

Quote:
"You must submit the .sql file before overwriting the admin/index.php file. This will change the structure of the config table."

Hi, can anyone tell me what should I do with my MySQL database so that I can apply thise update? Sorry I am new to web hosting.

It would be nice if I can use this update too because I have 13 hours different with my hosting server.

[Jayphen]

do you have phpmyadmin? if you do, just go to 'SQL', copy and paste what's inside that SQL file into the query box there, and click 'submit query' .. that's it!

[n0d3]

Ok, I did the mySQL thingy, updated the admin/index.php file and the main index.php file. Still can't get it to work. The posts won't show until that date itself has occured/past in accordance with the server time.

[Anonymous]

Thanks for this excellent mod, and it works perfectly on my image/index page!

However on the comments popup page the timestamp has not been adjusted. Is it possible I have not made proper changes to the index.php file, or does someone else have a similar problem?

All ideas are appreciated, thanks!

[Anonymous]

i've updated my index and admin php pages as well as mysql and still when i post an image it does not appear until hours later because of the server time... help!