Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Changing user's group problem-Urgent Help needed!
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Changing user's group problem-Urgent Help needed!

 Post Reply Post Reply Page  <12
Author
MadDog View Drop Down
Mod Builder Group
Mod Builder Group
Avatar

Joined: 01 January 2002
Status: Offline
Points: 3008
Post Options Post Options   Thanks (0) Thanks(0)   Quote MadDog Quote  Post ReplyReply Direct Link To This Post Posted: 29 January 2007 at 10:02pm
You can change the username in the database. But you have to change the password through the profile section of the board.

Or you can copy the Password and Salt field from a fresh database and put it into your current database to reset the password to "letmein".
Back to Top
MadDog View Drop Down
Mod Builder Group
Mod Builder Group
Avatar

Joined: 01 January 2002
Status: Offline
Points: 3008
Post Options Post Options   Thanks (0) Thanks(0)   Quote MadDog Quote  Post ReplyReply Direct Link To This Post Posted: 29 January 2007 at 10:03pm
Originally posted by jazzis jazzis wrote:

Originally posted by MadDog MadDog wrote:

You can change the username.
 
HOW???
Through the database... like you where just asking!
Back to Top
jazzis View Drop Down
Newbie
Newbie


Joined: 01 January 2006
Location: Israel
Status: Offline
Points: 32
Post Options Post Options   Thanks (0) Thanks(0)   Quote jazzis Quote  Post ReplyReply Direct Link To This Post Posted: 29 January 2007 at 10:06pm
OK thanks a lot. Password not a problem, does not requre a change.
 
Now another question if I may.
 
How do I move all the post done by a user to another user? (i.e all Bob's posts to John)?
Back to Top
MadDog View Drop Down
Mod Builder Group
Mod Builder Group
Avatar

Joined: 01 January 2002
Status: Offline
Points: 3008
Post Options Post Options   Thanks (0) Thanks(0)   Quote MadDog Quote  Post ReplyReply Direct Link To This Post Posted: 29 January 2007 at 10:07pm
You will have to go through the database and replace the Author_ID in all the tables from the old users author id to the new users author id.
Back to Top
jazzis View Drop Down
Newbie
Newbie


Joined: 01 January 2006
Location: Israel
Status: Offline
Points: 32
Post Options Post Options   Thanks (0) Thanks(0)   Quote jazzis Quote  Post ReplyReply Direct Link To This Post Posted: 29 January 2007 at 10:09pm
Thanks a lot - that's what I thought!
 
You were a great help!!!  Hug
Back to Top
 Post Reply Post Reply Page  <12

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.