PDA

View Full Version : just created an Ikonboard member convertor


LoB
25 Aug 2001, 20:56
and have tested it with my board (STGN) at www.ugforums.com
its fully working, i've just got to do some obvious stuff (like removing my database username/pass from the file hehe :D) then ill upload it,

Glen C
27 Aug 2001, 22:55
posting to get email notification when released :)

Is there a MESSAGE converter from ikonboard to vB?

LoB
27 Aug 2001, 23:35
Originally posted by Glen C
posting to get email notification when released :)

Is there a MESSAGE converter from ikonboard to vB?

you just made my day, i thought noone was interested so i didnt bother posting it :D

uploading it now as an attatchment, im making a post convertor at the moment, should be done in a few days

Glen C
28 Aug 2001, 00:27
Thanks! i'll have a test vB board up after labor day weekend and will get this tested ASAP :)

Juan
28 Aug 2001, 01:05
What version/s of Ikonboard does it convert from?

Do you need to start with an empty Vbulletin database? If not, does it import the past post count?

LoB
28 Aug 2001, 01:29
Originally posted by Juan
What version/s of Ikonboard does it convert from?

Do you need to start with an empty Vbulletin database? If not, does it import the past post count?

you can start with an existing database, however for test purposes, there is a paragraph commented out which creates it for you if you uncomment it

it imports from all versions of IB that use flat text files (well all of 2.x anyway), it converts most things including postcount, date of birth, homepage, icq number etc. and puts it in the vbulletin database
overwrites existing users with the same name in the database (well its supposed to but i havent had the opportunity to test that bit)

Dimitri
28 Aug 2001, 06:37
I'm not very interested in the user converter since most of my users are well established on my vB now, but would definitely be interested in the post converter so I can remove iB from my server completely. :cool:

KRIDER
28 Aug 2001, 17:18
but it will not work with the new files where the data is in hexcode?

i need such a converter very urgent :( :( :(

LoB
28 Aug 2001, 17:32
Originally posted by KRIDER
but it will not work with the new files where the data is in hexcode?

i need such a converter very urgent :( :( :(

ummmmmmmm to my knowlege no board exists that stores its memberfiles in hex...

KRIDER
28 Aug 2001, 17:51
its the Ikonboard 3

I don't know if its really hexcode, but it looks like
I cannot extract the plain text so I asked here if someone knows...

justsomedude
31 Aug 2001, 02:29
Just wanted to post a note of thanks LoB!!

worked like a charm :) can't wait for an update on the post conversion.

LoB
31 Aug 2001, 09:05
Originally posted by justsomedude
Just wanted to post a note of thanks LoB!!

worked like a charm :) can't wait for an update on the post conversion.

*mr burns voice* exxxcellent....

my old server is now back online so i have access to the IB posts/threads so ill be writing the convertor tonight when i get back from work, should only take a few hours hopefully

Juan
31 Aug 2001, 09:51
Thank you for this. I will be testing both scripts to see if they can merge both the posts and members.

Juan
04 Sep 2001, 16:17
Doesn't work on version 2.19.

After following all the instructions correctly and using 3 different populated vbulletin databases as well as 2 different IB forums, I get the following:


Processing 153 members ..1136: Column count doesn't match value count at row 1

and then these 153 times:

1136: Column count doesn't match value count at row 1
USERFIELD database
.1136: Column count doesn't match value count at row 1

LoB
04 Sep 2001, 18:06
Originally posted by Juan
Doesn't work on version 2.19.

After following all the instructions correctly and using 3 different populated vbulletin databases as well as 2 different IB forums, I get the following:


Processing 153 members ..1136: Column count doesn't match value count at row 1

and then these 153 times:

1136: Column count doesn't match value count at row 1
USERFIELD database
.1136: Column count doesn't match value count at row 1

that means that in your userfield table, you have more columns than has been accounted for (have you added any hacks that changes/adds to the userfield table?) to fix, just go into the script and where it writes to the DB, add the extra column information for your database

Juan
04 Sep 2001, 18:19
Here is the structure, no idea on what to do.


#
# Table structure for table 'userfield'
#

CREATE TABLE `userfield` (
`userid` int(10) unsigned NOT NULL default '0',
`field1` char(250) NOT NULL default '',
`field2` char(250) NOT NULL default '',
`field3` char(250) NOT NULL default '',
`field4` char(250) NOT NULL default '',
`importuserid` int(10) unsigned NOT NULL default '0',
`isnew` int(1) unsigned NOT NULL default '0',
`field5` char(250) NOT NULL default '',
`field6` char(250) NOT NULL default '',
PRIMARY KEY (`userid`)
) TYPE=MyISAM;

Jet
26 Oct 2001, 14:42
I tried your converter (IB 2.19b to VB 2.0.3) and found it very useful.
Just a couple of questions or 'bug notification', if any...
:p


First, I realize that you don't import all the fields (i.e. IP address or some other handwrited in the php). Is there a particular reason ?

Second, I noticed that the files in the working directory aren't correctly chosen (*.cgi), but all the files (Apache Un*x server) are listed, even '.' and '..'

O-T: is there any way to reset an auto_increment field in mySql (with phpMyAdmin) for example for a lot of members deleted ?

Thank you very much and excuse my requests.
Bye

JimG
27 Oct 2001, 01:09
I know that this topic is a bit old now but have you completed the posts convertor?
If not, how far have you got?

vjspeedy
27 Oct 2001, 13:12
i also realy need the post converter
right now i use yabb and i already have a member/post converter from YaBB to Ikonboard but i realy need to be able to convert from IB to VB since my board has got 80+ members and over 4000 posts and i do not want to lose em.

http://www.metallica-mechanix.com/metalboard/logo.gif

Juan
27 Oct 2001, 16:56
Which version of Ikonboard you have?

I can convert all your posts and members to a vbulletin database. E-mail me for information, as this involves much more than just a scipt. The method works 100%.

webmaster_listings@yahoo.com

Or you can wait for Jelsoft to release the conversion script they are working on.

vjspeedy
27 Oct 2001, 19:35
i have version 2.1.9 of ikonboard but i need to convert the members and posts to it first (installed IB today)

LoB
27 Oct 2001, 20:36
Originally posted by Juan
Which version of Ikonboard you have?

I can convert all your posts and members to a vbulletin database. E-mail me for information, as this involves much more than just a scipt. The method works 100%.

webmaster_listings@yahoo.com

Or you can wait for Jelsoft to release the conversion script they are working on.

doing something liek that isn't possible without a script, or a lot of manual work

DarkReaper
20 Nov 2001, 18:00
I just used it successfully, but there's one thing that bothers me. Everyone's last posted date is set to 1970. why?

DarkReaper
01 Dec 2001, 04:44
This doesn't work with 2.2.1...... :(

Jawelin
01 Dec 2001, 10:37
The only differences are the encrypted pw (md5 hash) and a field added to the end of the row in table USER.
You should apply later the step3 of upgradeXX.php (XX >
12)

But in the converter there are a lot of other fields not copied from IB to VB.... :(

Bye

Tech_Koss
19 Jan 2002, 10:38
what exactly is the "iKonBoard member cgi files" ??

Jawelin
19 Jan 2002, 10:48
Do you have ikonboard to "upgrade" from ? ;)

Otherwise you wouldn't need this hack/importer !
:stupid:
If you had, you absolutely should know the users are individually stored in .cgi files in members directory.
One file per user... <grin>

Tech_Koss
19 Jan 2002, 11:32
Yes I have (had) ikonboard & im trying to convert my members into my vbulletin forum.

Are you talking about the member folders in the "database" folder? ...because there is no cgi file in those directories; there is 2 *.ibx & a *.cb file in there.

Jawelin
19 Jan 2002, 11:59
I think the converter talks about Ikonboard v2.19, NOT v3.0.
In the first one there's no DB, but only .cgi files...

Thanks

Tech_Koss
19 Jan 2002, 18:46
Originally posted by Jawelin
I think the converter talks about Ikonboard v2.19, NOT v3.0.
In the first one there's no DB, but only .cgi files...

Thanks
ohh man :cry: ....stupid ikonboard!

merit5
26 Apr 2002, 03:55
Do these convertors (this and the post/thread convertor) .. convert to/from MySQL databases? .. i'm subscribing to this because I very much need some help .. for a VERY LARGE msg board that bought the software.. i'm trying to help them.

thanks in advance.

merit5
26 Apr 2002, 08:49
like the subject.. can anyone help me on this please.. bought the license.. but need this to work with MySQL in order for me to take advantage of my purchase...

any info would be great .. or at least if someone can point me in the right direction.

thanks

merit5
26 Apr 2002, 23:32
gotta keep bumping for hope!@

eGoR
17 Jun 2002, 14:25
thats amazing...Iam trying right now :0
great... installed

/me loves u, m8