View Single Post
  #641  
Old 06-25-2009, 02:30 PM
amjadz4's Avatar
amjadz4 amjadz4 is offline
 
Join Date: Aug 2007
Posts: 245
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by fmckinnon View Post
Thanks - I can easily change the username, etc., in phpmyadmin - but how can I get all my posts from userID one migrated over to the new user, w/o merging them?

Ex: User 1 is twc_admin - it has hundreds of posts and history.
User 2395 is what will BECOME my personal account.

how do I move all posts from user1 to user2395 yet, still keeping user1 available (seems like the merge command would delete user1) ....

Then, after moving all my history and posts from user1 to user2395, I'd rename user1 to be what I want (a more generic, sitewide ID)

Thks
Buddy you are simply complicating things. I am gonna repeat the same thing what I said in much more simple words so that you know what im trying to say.

Just do the following steps, you will get what you want.

1. Backup the database. (in case anything goes wrong)
2. Create a new account on forum - This will be your TO BE ADMIN account. Make a new one, forget the existing 2395 or whatever. And add it to the admin usergroup.
3. In phpmyadmin, edit user ID field of "1" to the ID of the one you just created above.
Now you have your personal admin account with which you will post.

Now for the "blog-forum posting" account.
1. Create another new account on the forum - this will be one which will post.
2. In phpmyadmin, edit user ID field of the one you just created above to "1"
3. go to admincp and give it permissions you want.

DONE!
--u ask how?.... That's how!
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01638 seconds
  • Memory Usage 1,764KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete