You are missing our premiere tool bar navigation system! Register and use it for FREE!

NukeCops  
•  Home •  Downloads •  Gallery •  Your Account •  Forums • 
Readme First
- Readme First! -

Read and follow the rules, otherwise your posts will be closed
Modules
· Home
· FAQ
· Buy a Theme
· Advertising
· AvantGo
· Bookmarks
· Columbia
· Community
· Donations
· Downloads
· Feedback
· Forums
· PHP-Nuke HOWTO
· Private Messages
· Search
· Statistics
· Stories Archive
· Submit News
· Surveys
· Theme Gallery
· Top
· Topics
· Your Account
Who's Online
There are currently, 174 guest(s) and 0 member(s) that are online.

You are Anonymous user. You can register for free by clicking here
Nuke Cops :: View topic - Looking for mySQL command to edit all Time Zones [ ]
 Forum FAQ  •  Search  •   •  Memberlist  •  Usergroups   •  Register  •  Profile •    •  Log in to check your private messages  •  Log in

 
Post new topic  Reply to topicprinter-friendly view
View previous topic Log in to check your private messages View next topic
Author Message
GJSchaller
Corporal
Corporal


Joined: Aug 05, 2004
Posts: 62

Location: Valhalla, NY, USA

PostPosted: Wed Dec 22, 2004 7:02 am Reply with quoteBack to top

I migrated from an old site with ubb.threads to PHP-Nuke 7.5. My forums & profiles all moved, and the site has been runnning smoothly for some time now, but I just caught on to a small issue that is lingering from the move.

When all my users were moved over, thier Time Zones did not carry properly. Some have been smart enough to set it back to "GMT -5", but many haven't, and they can't figure out why the time is so whacky on the fourms. I could post about it, but a lot of them still won't get it.

I have phpMyAdmin on my site - what is the querry I would run to update everyone's Time Zones to be "GMT -5"?

Thank you!

_________________
Geoffrey Schaller
Knight Realms, Technical Officer
http://www.knightrealms.com
Find all posts by GJSchallerView user's profileSend private messageSend e-mailVisit poster's website
madman
Support Mod
Support Mod


Joined: Feb 15, 2004
Posts: 806


PostPosted: Wed Dec 22, 2004 9:43 am Reply with quoteBack to top

Code:
UPDATE nuke_users SET user_timezone = '-5' WHERE user_timezone <> -5 AND user_id > 1;

_________________
I'm Image
Find all posts by madmanView user's profileSend private messageVisit poster's websiteYahoo MessengerMSN Messenger
GJSchaller
Corporal
Corporal


Joined: Aug 05, 2004
Posts: 62

Location: Valhalla, NY, USA

PostPosted: Wed Dec 22, 2004 9:51 am Reply with quoteBack to top

Thank you - I ran it, now we'll see if that does the trick. Wink

_________________
Geoffrey Schaller
Knight Realms, Technical Officer
http://www.knightrealms.com
Find all posts by GJSchallerView user's profileSend private messageSend e-mailVisit poster's website
Display posts from previous:      
Post new topic  Reply to topicprinter-friendly view
View previous topic Log in to check your private messages View next topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2005 phpBB Group

Ported by Nuke Cops © 2003 www.nukecops.com
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::
Powered by TOGETHER TEAM srl ITALY http://www.togetherteam.it - DONDELEO E-COMMERCE http://www.DonDeLeo.com - TUTTISU E-COMMERCE http://www.tuttisu.it
Web site engine's code is Copyright © 2002 by PHP-Nuke. All Rights Reserved. PHP-Nuke is Free Software released under the GNU/GPL license.
Page Generation: 0.080 Seconds - 172 pages served in past 5 minutes. Nuke Cops Founded by Paul Laudanski (Zhen-Xjell)
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::