Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
  #1  
Old 05-28-2002, 05:53 PM
TheVoice TheVoice is offline
 
Join Date: May 2002
Posts: 4
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Q:How would i move users from vb to another vb?

I have lots of sites with vb running. I would like to take just the users from all forums and combine them into one forum. I tried backing up just the users from the vb admin then adding them to the new sql db on the new board. The problem is that they overwrite any other users that are there instead of adding to them. Is there a way to do this properly or some hack to make this possible?

Thanks
Reply With Quote
  #2  
Old 05-28-2002, 06:16 PM
Gamingforce's Avatar
Gamingforce Gamingforce is offline
 
Join Date: Oct 2001
Location: New York City
Posts: 128
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

There is no real easy way to do this unfortunately since tables and rows are going to clash. You should stick with your most popular board and ask everyone to go over there. You can still leave your old board as an archive with registration / posting disabled if you want.
Reply With Quote
  #3  
Old 05-28-2002, 06:35 PM
TheVoice TheVoice is offline
 
Join Date: May 2002
Posts: 4
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

ok thanks
Reply With Quote
  #4  
Old 05-28-2002, 09:32 PM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

you can write a small php script, which writes all users into a file, and then write a small script which includes data from the file into the new user-db.

if you dont need the signatures and such small thing, this can be done within 1/4h.

if you need all the personalstuff, it'll take a bit longer, but not soo much.
Reply With Quote
  #5  
Old 05-28-2002, 09:49 PM
TheVoice TheVoice is offline
 
Join Date: May 2002
Posts: 4
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

all I really want to move over is the username/passwords. I want people from the other forums to just come to the new ones and login and start posting. So having signatures and post counts isn't neccessary.
Reply With Quote
  #6  
Old 05-28-2002, 10:04 PM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

so it isnt a really hard problem

just make a file get.php

with the sql-quere SELECT username, password FROM user WHERE 1

then make a while(fetcharray)-loop and write it to a textfile (be sure PHP can write to directory)
in the loop something like that:
fputs($file, htmlspecialchars($user[username]));
fputs($file, "\n");
fputs($file, htmlspecialchars($user[password]));
fputs($file, "\n");

and a put.php which reads the info and puts it into the DB.
while (! feof($file)) {
$username = fgets($file, 1024);
$password = fgets($file, 1024);

$DB_site->query("INSERT INTO user (userid,username,password) VALUES ('NULL','".addslashes($username)."','".addslashes( $password)."')
}

and do so for all your forums.

PS. don't forget to make lines in the userprofilefield too for each user, or you cannot edit them in the admin-cp

can you code it from here?
i'm not sure if the htmlspecials are correct there, but make a few tests before to be sure
Reply With Quote
  #7  
Old 05-28-2002, 10:07 PM
TheVoice TheVoice is offline
 
Join Date: May 2002
Posts: 4
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I think i can handle it from here. I"ll get back to you when I get somewhere. Thanks
Reply With Quote
  #8  
Old 05-29-2002, 06:11 PM
Dean C's Avatar
Dean C Dean C is offline
 
Join Date: Jan 2002
Location: England
Posts: 9,071
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

i want to do this too...

surely if people can create phpbb > vb importerts etc...

and ubb member importers... cudn't a hack be made where people can transfer users from a vb to a vb ?

id try runningt that query if i hadn't mucked it doin the store hack on firefly's query hack... now i cant run any ...
Reply With Quote
  #9  
Old 05-30-2002, 02:31 AM
Brad Brad is offline
 
Join Date: Nov 2001
Posts: 4,765
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

the problem is that if you want to import the topics aswell as members the old topics will show the names of people already reged then the correct ones due tot he differnce in user id's.

if its a small forum the easyest way ive found id to reg them all via the cp and copy/paste all old topics in full to the new forum in a arvice somewhere, much as eva did with his vB, it takes time, but if you worried about adding tot eh database with scripts its the only way.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 06:29 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04368 seconds
  • Memory Usage 2,232KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (9)post_thanks_box
  • (9)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (9)post_thanks_postbit_info
  • (9)postbit
  • (9)postbit_onlinestatus
  • (9)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • 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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete