SMF -> Joomlaboard conversion

Discuss the integration of SMF here.
User avatar
maxdg
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 4173
Joined: Sun Sep 04, 2005 3:52 pm
Location: Colli Euganei
Contact:

SMF -> Joomlaboard conversion

Postby maxdg » Fri Mar 03, 2006 3:52 am

Is there a script to perform this conversion..?  :P
"Civiltà è la misura con cui la comunità provvede a tutti, nel disinteresse collettivo. Il disinteresse è la norma di selezione per l’immortalità di una razza intelligente."

http://www.ufomachine.org/

quiquedcode
Joomla! Ace
Joomla! Ace
Posts: 1376
Joined: Thu Aug 18, 2005 10:11 pm
Location: San Juan - Argentina
Contact:

Re: SMF -> Joomlaboard conversion

Postby quiquedcode » Thu Mar 30, 2006 7:13 pm

Searching for same stuff
If someone knows... please let us know
@kabeza
Freelance Joomla/CodeIgniter Developer
Home: http://www.beza.com.ar

User avatar
maxdg
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 4173
Joined: Sun Sep 04, 2005 3:52 pm
Location: Colli Euganei
Contact:

Re: SMF -> Joomlaboard conversion

Postby maxdg » Thu Mar 30, 2006 7:49 pm

I tried this with a 80% of success..

TSMF

Here's the code posted:

    include("mysql.php");
   
    connectbdd();
   
    $query = "SELECT * FROM smf_messages order by ID_TOPIC ASC, posterTime ASC";
    $bigr = mysql_query( $query ) or die(mysql_error());
   
    $prec_sb_id = 0;
    $prec_smf_topic = 0;
    $parent        = 0;
    $thread        = 0;
    $threadupdate  = 1;
   
    echo mysql_num_rows( $bigr );
    //
    // Pour chaque message...
    while( $row = mysql_fetch_array( $bigr ))
    {
        $id            = $row['ID_MSG'];
        $id_topic      = $row['ID_TOPIC'];
        $id_board      = $row['ID_BOARD'];
        $posterTime    = $row['posterTime'];
        $subject        = $row['subject'];
        $posterName    = $row['posterName'];
        $posterEmail    = $row['posterEmail'];
        $posterIP      = $row['posterIP'];
        $body          = $row['body'];
       
        $subject = addslashes($subject);
        $body    = addslashes($body);
       
        if( $id_topic == $prec_smf_topic )
            $parent = $prec_sb_id;
        else
            $parent = 0;
           
        $thread = $threadupdate;
       
        //
        // On récupere le nom du board et on trouve la correspondance avec Joomlaboard
        $r = mysql_query( "SELECT name from smf_boards where ID_BOARD='$id_board'") or die(mysql_error());
        $result = mysql_fetch_array($r);
       
        $boardname = $result['name'];
       
        $r = mysql_query( "SELECT id FROM mos_sb_categories where name='$boardname'") or die(mysql_error());
        if( mysql_num_rows($r) == 0 )
            die ("CATEGORIE $boardname INEXISTANTE DANS LA BASE MAMBO!!!");
        else
        {
            $result = mysql_fetch_array($r);
            $catid =  $result['id'];
        }
       
        //
        // On récupere maintenant l'id de l'auteur du message
        $r = mysql_query( "SELECT id FROM mos_users where username='$posterName'") or die(mysql_error());
        if (mysql_num_rows($r) == 0 )
            die( "UTILISATEUR $posterName inexistant dans la base MAMBO!!!");
        else
        {
            $result = mysql_fetch_array($r);
            $userid = $result['id'];
        }
       
        //
        // INSERTION DANS LA BASE DE JB
        $query = "INSERT INTO mos_sb_messages VALUES ('', '$parent', '$thread', '$catid', '$posterName', '$userid', '
$posterEmail', '$subject', '$posterTime', '$posterIP', '0', '0', '0', '0', '0', '0' )";
        mysql_query( $query ) or die ("$query" . "
" . mysql_error());
       
        //
        // On choppe l'id du dernier enregistrement
        $r = mysql_query( "SELECT id FROM mos_sb_messages order by id DESC limit 1" ) or die (mysql_error());
            $result = mysql_fetch_array( $r );
            $prec_sb_id = $result['id'];
       
        if( $parent == 0 )
            $threadupdate = $prec_sb_id;
       
        mysql_query( "UPDATE mos_sb_messages SET thread = '$threadupdate' WHERE id='$prec_sb_id'") or die(mysql_error());
       
        //
        // Et maintenant faut inserer le texte dans la base de sb aussi....
        $query = "INSERT INTO mos_sb_messages_text VALUES ('$prec_sb_id', '$body')";
        mysql_query($query) or die ("$query" . "
" . mysql_error());
       
        $prec_smf_topic = $id_topic;
    }
    echo "done";
?>


Change

Code: Select all

mos_sb_

with the joomla table name

Code: Select all

jos_sb_


Notice that:

    include("mysql.php");


refers to a connection file you must create at the same level.

This:

Code: Select all

<?php

function connectbdd()
{
    if( false == mysql_connect("", "", "") )  /// FILL with your connections details
        die("Error");
   
    if( false == mysql_select_db("") ) // FILL with your database name
        die("Error.");
}

?>


In this way I saved about 80% of messages.. still don't know why..  :(

Here's the results:
joomlaboard
SMF
Last edited by maxdg on Thu Mar 30, 2006 7:53 pm, edited 1 time in total.
"Civiltà è la misura con cui la comunità provvede a tutti, nel disinteresse collettivo. Il disinteresse è la norma di selezione per l’immortalità di una razza intelligente."

http://www.ufomachine.org/

quiquedcode
Joomla! Ace
Joomla! Ace
Posts: 1376
Joined: Thu Aug 18, 2005 10:11 pm
Location: San Juan - Argentina
Contact:

Re: SMF -> Joomlaboard conversion

Postby quiquedcode » Thu Mar 30, 2006 7:51 pm

Thanks maxdg
I'll try this to see what happens

:)
@kabeza
Freelance Joomla/CodeIgniter Developer
Home: http://www.beza.com.ar

User avatar
maxdg
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 4173
Joined: Sun Sep 04, 2005 3:52 pm
Location: Colli Euganei
Contact:

Re: SMF -> Joomlaboard conversion

Postby maxdg » Thu Mar 30, 2006 7:56 pm

...let us know..  ;)
"Civiltà è la misura con cui la comunità provvede a tutti, nel disinteresse collettivo. Il disinteresse è la norma di selezione per l’immortalità di una razza intelligente."

http://www.ufomachine.org/

User avatar
kai920
Joomla! Guru
Joomla! Guru
Posts: 542
Joined: Sun Sep 04, 2005 3:59 pm
Location: Hong Kong

Re: SMF -> Joomlaboard conversion

Postby kai920 » Wed May 24, 2006 3:37 pm

I'm also considering moving over to Joomlaboard (currently running SMF 1.1RC2)

Any updates to this thread & stories of success porting the posts over?

Thanks!

User avatar
maxdg
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 4173
Joined: Sun Sep 04, 2005 3:52 pm
Location: Colli Euganei
Contact:

Re: SMF -> Joomlaboard conversion

Postby maxdg » Wed May 24, 2006 3:47 pm

...I miss SMF....  :'(

PS.. SMF forum (link posted above) don't longer exist on my site.. so don't search for...
"Civiltà è la misura con cui la comunità provvede a tutti, nel disinteresse collettivo. Il disinteresse è la norma di selezione per l’immortalità di una razza intelligente."

http://www.ufomachine.org/

User avatar
kai920
Joomla! Guru
Joomla! Guru
Posts: 542
Joined: Sun Sep 04, 2005 3:59 pm
Location: Hong Kong

Re: SMF -> Joomlaboard conversion

Postby kai920 » Wed May 24, 2006 3:48 pm

maxdg wrote:...I miss SMF....  :'(

PS.. SMF forum (link posted above) don't longer exist on my site.. so don't search for...



Hehe, I tried a few minutes ago and found it wasn't up...

Why do you miss SMF?

User avatar
maxdg
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 4173
Joined: Sun Sep 04, 2005 3:52 pm
Location: Colli Euganei
Contact:

Re: SMF -> Joomlaboard conversion

Postby maxdg » Wed May 24, 2006 4:40 pm

kai920 wrote:Why do you miss SMF?


Because there is still some minor problems and isn't "that" killer application like SMF.
But users are tired of my "upgrading syndrome" and I want to take it easy for a while..  ;D
If you need a strong and multifunctional forum... leave JB where it is, for now.. (but if your needs are to let Community Builder driving the bus and have a little forum just-for-having-it.. it may be a solution).

Just my € 0,10 ..
"Civiltà è la misura con cui la comunità provvede a tutti, nel disinteresse collettivo. Il disinteresse è la norma di selezione per l’immortalità di una razza intelligente."

http://www.ufomachine.org/

User avatar
maxdg
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 4173
Joined: Sun Sep 04, 2005 3:52 pm
Location: Colli Euganei
Contact:

Re: SMF -> Joomlaboard conversion

Postby maxdg » Wed May 24, 2006 5:41 pm

...and... there's another important reason that makes me change my mind about SMF...

It's called Mambelfish (actual Joomfish)

If you need to setting up a multilanguage website, which translates contents, menus, hyperlinks and stuff just clicking a button, Joomlaboard is for you.

As you know, in a bridged-SMF you (as user) have to set your preferred language in your profile preferences, this don't affects Joomla default language at all and vice-versa.

Take a look on this: www.78live.net
It's a Joomla 1.0.8 + Joomlaboard + Mambelfish + Community Builder almost fully integrated (sorry, but I didn't planned to have chinese visitors.. so there's only european languages to choose  :-[)

Here: www.string.is.it there's some Japanese (just for take a look at UTF-8 results)

Ciao!
"Civiltà è la misura con cui la comunità provvede a tutti, nel disinteresse collettivo. Il disinteresse è la norma di selezione per l’immortalità di una razza intelligente."

http://www.ufomachine.org/

User avatar
tonybone
Joomla! Apprentice
Joomla! Apprentice
Posts: 36
Joined: Fri Feb 03, 2006 1:51 pm

Re: SMF -> Joomlaboard conversion

Postby tonybone » Thu May 25, 2006 2:12 am

Excuse my "newbieness" here but where do you have to run the script from to do the conversion? Also, I assume that the connection details and database in the mysql.php file is for the SMF database? Is this right?
Thanks.

User avatar
kai920
Joomla! Guru
Joomla! Guru
Posts: 542
Joined: Sun Sep 04, 2005 3:59 pm
Location: Hong Kong

Re: SMF -> Joomlaboard conversion

Postby kai920 » Thu May 25, 2006 6:08 am

Thanks maxdg for your input. as someone who has used both, I value your opinions very much  ;)
I think I will stay put for now with SMF

User avatar
maxdg
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 4173
Joined: Sun Sep 04, 2005 3:52 pm
Location: Colli Euganei
Contact:

Re: SMF -> Joomlaboard conversion

Postby maxdg » Thu May 25, 2006 1:59 pm

tonybone wrote:Excuse my "newbieness" here but where do you have to run the script from to do the conversion? Also, I assume that the connection details and database in the mysql.php file is for the SMF database? Is this right?
Thanks.


That's right.
Place both files in the SMF root and launch the convertor one.
Don't forget to backup, first !!!  8)
"Civiltà è la misura con cui la comunità provvede a tutti, nel disinteresse collettivo. Il disinteresse è la norma di selezione per l’immortalità di una razza intelligente."

http://www.ufomachine.org/

User avatar
chadness
Joomla! Guru
Joomla! Guru
Posts: 768
Joined: Mon Aug 22, 2005 5:43 pm
Location: Minneapolis, MN
Contact:

Re: SMF -> Joomlaboard conversion

Postby chadness » Thu May 25, 2006 2:05 pm

maxdg wrote:...and... there's another important reason that makes me change my mind about SMF...

It's called Mambelfish (actual Joomfish)


Read this post carefully to the end.  He found a way to integrate SMF's language switching in with Joomfish.

User avatar
maxdg
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 4173
Joined: Sun Sep 04, 2005 3:52 pm
Location: Colli Euganei
Contact:

Re: SMF -> Joomlaboard conversion

Postby maxdg » Thu May 25, 2006 2:27 pm

chadness wrote:
maxdg wrote:...and... there's another important reason that makes me change my mind about SMF...

It's called Mambelfish (actual Joomfish)


Read this post carefully to the end.  He found a way to integrate SMF's language switching in with Joomfish.


Chadness... I actually don't know if I got to love or hate you....
This is a very important point (with the other one regarding layouting).. but you've waked up my sleeping "upgrading syndrome" ..  ;D

Anyway... many thanks..  ;)
"Civiltà è la misura con cui la comunità provvede a tutti, nel disinteresse collettivo. Il disinteresse è la norma di selezione per l’immortalità di una razza intelligente."

http://www.ufomachine.org/

User avatar
tonybone
Joomla! Apprentice
Joomla! Apprentice
Posts: 36
Joined: Fri Feb 03, 2006 1:51 pm

Re: SMF -> Joomlaboard conversion

Postby tonybone » Thu May 25, 2006 7:54 pm

maxdg wrote:
tonybone wrote:Excuse my "newbieness" here but where do you have to run the script from to do the conversion? Also, I assume that the connection details and database in the mysql.php file is for the SMF database? Is this right?
Thanks.


That's right.
Place both files in the SMF root and launch the convertor one.
Don't forget to backup, first !!!  8)


So, for the converter to work do the Joomla and SMF tables have to be in the same database? I have them on separate databases and when I tried to run the converter, I basically get an error telling me that 'jos_sb_categories' doesn't exist in my SMF database (which of course, it doesn't).

manuelap
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Sat May 27, 2006 6:49 am

Re: SMF -> Joomlaboard conversion

Postby manuelap » Sat May 27, 2006 6:54 am

Who has managed to do a succesful conversion for smf 1.1 rc2 to joomlaboard? Am looking for months to find a working solution.... am willing to provide a small financial compensation to whoever manages to get it to work!
Last edited by manuelap on Sat May 27, 2006 6:56 am, edited 1 time in total.

User avatar
maxdg
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 4173
Joined: Sun Sep 04, 2005 3:52 pm
Location: Colli Euganei
Contact:

Re: SMF -> Joomlaboard conversion

Postby maxdg » Sat May 27, 2006 4:39 pm

tonybone wrote:So, for the converter to work do the Joomla and SMF tables have to be in the same database?


Yes, they should..
Last edited by maxdg on Sat May 27, 2006 4:41 pm, edited 1 time in total.
"Civiltà è la misura con cui la comunità provvede a tutti, nel disinteresse collettivo. Il disinteresse è la norma di selezione per l’immortalità di una razza intelligente."

http://www.ufomachine.org/

manuelap
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Sat May 27, 2006 6:49 am

Re: SMF -> Joomlaboard conversion

Postby manuelap » Sun May 28, 2006 4:40 am

Maxdg, have you managed to get a conversion working for smf 1.1. rc2 to joomlaboard and can you reproduce this?

User avatar
maxdg
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 4173
Joined: Sun Sep 04, 2005 3:52 pm
Location: Colli Euganei
Contact:

Re: SMF -> Joomlaboard conversion

Postby maxdg » Sun May 28, 2006 1:42 pm

manuelap wrote:Maxdg, have you managed to get a conversion working for smf 1.1. rc2 to joomlaboard and can you reproduce this?


As I wrote above, I've FOUND a script to manage this conversion but it worked for me at 80%, since I've lost some messagges and actually don't know why.

There's a link to the original article in my post... I can't say much more about this.
"Civiltà è la misura con cui la comunità provvede a tutti, nel disinteresse collettivo. Il disinteresse è la norma di selezione per l’immortalità di una razza intelligente."

http://www.ufomachine.org/

HolmesSPH
Joomla! Intern
Joomla! Intern
Posts: 56
Joined: Mon Feb 27, 2006 11:39 pm

Re: SMF -> Joomlaboard conversion

Postby HolmesSPH » Sun Jun 04, 2006 3:06 am

I unfortunately switched from Simpleboard to SMF, and while SMF is by far the more superior program in way of Forums are concerned, they are not good for those integrating into CB, or CBE... Unfortunately, it's even worse if you using a bridge too, because the search engines did NOT pick my forum posts because I set up the bridge to wrapp it, so it's .... a loose loose... Im going back to Joomlaboard because I have 16K members and I can't continueally be having trouble any more...

Oh yeah, also the SMF< CB login module does not take advantage of new the login bug fixes present in Joomla 1.0.8 so AOL users and others behind proxies will have ALOT of trouble.....
Signature rules: Literal URLs only - viewtopic.php?f=8&t=65

User avatar
radianation
Joomla! Intern
Joomla! Intern
Posts: 53
Joined: Tue Nov 15, 2005 4:28 am
Location: Louisville, KY
Contact:

Re: SMF -> Joomlaboard conversion

Postby radianation » Sat Jun 24, 2006 10:27 pm

I'm getting this error message:

96202CATEGORIE INEXISTANTE DANS LA BASE MAMBO!!!


I have no idea what it's trying to tell me?

User avatar
maxdg
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 4173
Joined: Sun Sep 04, 2005 3:52 pm
Location: Colli Euganei
Contact:

Re: SMF -> Joomlaboard conversion

Postby maxdg » Sun Jun 25, 2006 8:53 am

Maybe "he" wants you to manually generate your old-SMF category tree in new-JB.
This is a conditio sine-qua-non for this script to works.. ;)

(it isn't written somewhere?)
"Civiltà è la misura con cui la comunità provvede a tutti, nel disinteresse collettivo. Il disinteresse è la norma di selezione per l’immortalità di una razza intelligente."

http://www.ufomachine.org/

User avatar
radianation
Joomla! Intern
Joomla! Intern
Posts: 53
Joined: Tue Nov 15, 2005 4:28 am
Location: Louisville, KY
Contact:

Re: SMF -> Joomlaboard conversion

Postby radianation » Sun Jun 25, 2006 7:05 pm

I seem to recall seeing this about 6 months ago when I first looked into the conversion, but I didn't see it anywhere when I looked this time. So I need to recreate the forum categories by hand in Joomlaboard and then make the conversion. Got it. I'll give it a shot.

User avatar
Selwyn Wacks
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Sat Jul 08, 2006 11:07 pm
Contact:

Re: SMF -> Joomlaboard conversion

Postby Selwyn Wacks » Mon Jul 24, 2006 9:14 pm

conversion from smf 1.1.rc2 to joomlaboard is perfect

see it on http://www.turbocashtraining.co.za/joomla

first you convert smf to phpbb2 (you have to install phpbb2 on same dbase as joomla. and load the ucs convert as well as the smf converter)

then you do the phpbb2 to joomlaboard converter

perfect
Skype=swacks

User avatar
radianation
Joomla! Intern
Joomla! Intern
Posts: 53
Joined: Tue Nov 15, 2005 4:28 am
Location: Louisville, KY
Contact:

Re: SMF -> Joomlaboard conversion

Postby radianation » Mon Jul 24, 2006 11:40 pm

Excellent. Thank you for the tip.

User avatar
ITzorro
Joomla! Apprentice
Joomla! Apprentice
Posts: 12
Joined: Wed Aug 02, 2006 2:28 pm
Location: Sweden
Contact:

Re: SMF -> Joomlaboard conversion

Postby ITzorro » Thu Aug 03, 2006 9:38 am

Hi,
I am new at Joomla and are preparing a site that has multilanguage support (Joomfish) together with Joomlaboard and I saw that maxdg's site had that, so my question is how do I do this?

User avatar
maxdg
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 4173
Joined: Sun Sep 04, 2005 3:52 pm
Location: Colli Euganei
Contact:

Re: SMF -> Joomlaboard conversion

Postby maxdg » Thu Aug 03, 2006 11:22 am

ITzorro wrote:Hi,
I am new at Joomla and are preparing a site that has multilanguage support (Joomfish) together with Joomlaboard and I saw that maxdg's site had that, so my question is how do I do this?


Hi,
When you have successfully completed your Joomfish installation the only thing to do is to popolate the /languages folder for each component you want to be Joomfished..
Joomfish do the rest, so when you clic a flag it calls the appropriate language.php file.
"Civiltà è la misura con cui la comunità provvede a tutti, nel disinteresse collettivo. Il disinteresse è la norma di selezione per l’immortalità di una razza intelligente."

http://www.ufomachine.org/

User avatar
ITzorro
Joomla! Apprentice
Joomla! Apprentice
Posts: 12
Joined: Wed Aug 02, 2006 2:28 pm
Location: Sweden
Contact:

Re: SMF -> Joomlaboard conversion

Postby ITzorro » Thu Aug 03, 2006 11:52 am

Thanks, just got it to work

User avatar
ITzorro
Joomla! Apprentice
Joomla! Apprentice
Posts: 12
Joined: Wed Aug 02, 2006 2:28 pm
Location: Sweden
Contact:

Re: SMF -> Joomlaboard conversion

Postby ITzorro » Fri Aug 04, 2006 10:43 am

Just one more question, how did you get the flags (instead of drop downlist) on your site 78live?
I have Joomfish and Multilingual aware Main Menu installed.
http://www.stefansukulele.se


Return to “SMF - Simplemachines.org Forum”

Who is online

Users browsing this forum: No registered users and 1 guest