Q:How would i move users from vb to another vb?

[TheVoice]

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

[Gamingforce]

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.

[TheVoice]

ok thanks

[Xenon]

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.

[TheVoice]

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.

[Xenon]

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

[TheVoice]

I think i can handle it from here. I"ll get back to you when I get somewhere. Thanks

[Dean C]

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 ...

[Brad]

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.