emberlegion
10-24-2016, 10:14 PM
I'm moving my board from ips to vb5. I was unable to find a built in way to do so.
is this the only way? https://vborg.vbsupport.ru/showthread.php?t=319738
and does this work for vb5?
any help is appreciated,
emberlegion
10-26-2016, 01:51 AM
update:
all we wanted was the users to transfer over so we exported the member list from ips and used the following
use strict;
use warnings;
my $joinDate = 1477441800;
my $insertStmt = "INSERT INTO user(username,email,ipaddress,usergroupid,joindate )values";
my $fh;
if (open($fh, '<', "members.csv")) {
while (my $row = <$fh>) {
chomp $row;
$row =~ /(.*),(.*),(.*)/;
my $name = $1;
my $email = $2;
my $ipaddress = $3;
$name =~ s/"//g;
$insertStmt .= "('$name','$email','$ipaddress',2,$joinDate),";
}
}
close $fh;
if (open($fh, '>', "insert.txt")) {
print $fh $insertStmt;
}
close $fh;
it imported all the users from the csv file. all they had to do was request a password reset. i'm sure with a bit more work other fields could be made to work as well.
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.