View Single Post
  #7  
Old 08-21-2008, 02:55 PM
Toupsx Toupsx is offline
 
Join Date: Aug 2008
Posts: 133
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Regs View Post
I believe what he is asking is pretty straightforward in the sense that it doesn't matter which modification he is using.

The point being made is that both structures are the same just the 2 columns are names differently. On one side, the 2 columns has all the data and the other has none.

To the original poster, one avenue you might want to try is export the 2 tables using phpmyadmin, open them up in a spreadsheet and copy the data over from one file to the other. Then import back using phpmyadmin.

This is of course assuming that the userids in both tables match up, if not, you might need to do some 'massaging'.

I would test this out on a test install first.

There are probably much better ways of doing this but you'll need a helpful coder here to get you going.

Cheers,

Regs.

--------------- Added [DATE]1219333529[/DATE] at [TIME]1219333529[/TIME] ---------------

I should add that when I say copy the data over, I mean just the 2 columns, not everything
Hello, yes that basically sums it up, I tried exporting the data & then importing it selecting "just the columns I wanted" in the import.. didn't work, it completely erased the user (made it on a test user just importing those two columns for just it). So yeah. if someone could give me some better instructions on how to do it or a better way to do it, would be great.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01422 seconds
  • Memory Usage 1,763KB
  • 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