Search options (Page 1 of 3)

I need to get the intergration, it's a must for the new site. If I manage to intergrate phpBB succesfully with Mambo, I will do it - even if I can't convert from PunBB and keep all members. Converting from phpBB to PunBB was easy, so if intergratoin with Mambo and PunBB is done sometime, I will come back.

I don't have time to wait anymore. The new version of my site has been delayed in weeks now.
The phpBB-people did not have any converters. I don't have a clue about what to do now - exept re-installing my forum and loose all members and posts... But there is a converter from phpBB to PunBB, would it be that hard to just.. make the opposite something? Ehh. Is it hard to make a converter? I have no ideas.. I'm stuck. Please help if you know what to do!

What? Can't I change from PunBB? Am I bound to use PunBB forever?
What should I do?

I will still use PunBB, but not on this site. I need to change to phpBB to make the intergration. But is it impossible to convert to phpBB from PunBB?

Suggestions are very welcome.

Sorry for bumping again, but I'm near giving this up. I might have to use SMF or PhpBB instead of PunBB, and that would be horrible. Can't anyone here answer post #16?

Now both Mambo and PunBB is installed in the same database, and with the right prefix.
What would be the next step? When somebody register at the page, they should register at the forum at the same time. But I don't where in the code (and which code) to make that. Suggestions? Anyone?

Nooo. I renamed all tables to "punbb_name", and changed the prefix to punbb_ in config.php

I get this error message when opening the forum:

An error was encountered
Error: Unable to fetch user information.

What does that mean? What could be wrong?

I'm not sure, but I will start with editing registration.php in Mambo, right? So that when a user register on the site, he will also be registered in the forum?

Here is the "registration.php" in Mambo:

<?php
/**
* @version $Id: registration.php,v 1.19 2004/09/22 00:12:41 prazgod Exp $
* @package Mambo_4.5.1
* @copyright (C) 2000 - 2004 Miro International Pty Ltd
* @license http://www.gnu.org/copyleft/gpl.html GNU/GPL
* Mambo is Free Software
*/

/** ensure this file is being included by a parent file */
defined( '_VALID_MOS' ) or die( 'Direct Access to this location is not allowed.' );

$task = mosGetParam( $_REQUEST, 'task', "" );
require_once( $mainframe->getPath( 'front_html' ) );

switch( $task ) {
    case "lostPassword":
    lostPassForm( $option );
    break;

    case "sendNewPass":
    sendNewPass( $option );
    break;

    case "register":
    registerForm( $option, $mosConfig_useractivation );
    break;

    case "saveRegistration":
    saveRegistration( $option );
    break;

    case "activate":
    activate( $option );
    break;
}

function lostPassForm( $option ) {
  global $mainframe;
  $mainframe->SetPageTitle(_PROMPT_PASSWORD);
    HTML_registration::lostPassForm($option);
}

function sendNewPass( $option ) {
    global $database, $Itemid;
    global $mosConfig_live_site, $mosConfig_sitename;

    $_live_site = $mosConfig_live_site;
    $_sitename = $mosConfig_sitename;

    // ensure no malicous sql gets past
    $checkusername = trim( mosGetParam( $_POST, 'checkusername', '') );
    $checkusername = $database->getEscaped( $checkusername );
    $confirmEmail = trim( mosGetParam( $_POST, 'confirmEmail', '') );
    $confirmEmail = $database->getEscaped( $confirmEmail );

    $database->setQuery( "SELECT id FROM #__users"
    . "\nWHERE username='$checkusername' AND email='$confirmEmail'"
    );

    if (!($user_id = $database->loadResult()) || !$checkusername || !$confirmEmail) {
        mosRedirect( "index.php?option=$option&task=lostPassword&mosmsg="._ERROR_PASS );
    }

    $database->setQuery( "SELECT name, email FROM #__users"
    . "\n WHERE usertype='superadministrator'" );
    $rows = $database->loadObjectList();
    foreach ($rows AS $row) {
        $adminName = $row->name;
        $adminEmail = $row->email;
    }

    $newpass = mosMakePassword();
    $message = _NEWPASS_MSG;
    eval ("\$message = \"$message\";");
    $subject = _NEWPASS_SUB;
    eval ("\$subject = \"$subject\";");

    mosMail($mosConfig_mailfrom, $mosConfig_fromname, $confirmEmail, $subject, $message);

    $newpass = md5( $newpass );
    $sql = "UPDATE #__users SET password='$newpass' WHERE id='$user_id'";
    $database->setQuery( $sql );
    if (!$database->query()) {
        die("SQL error" . $database->stderr(true));
    }

    mosRedirect( "index.php?Itemid=$Itemid&mosmsg="._NEWPASS_SENT );
}

function registerForm( $option, $useractivation ) {
    global $mainframe, $database, $my, $acl;

    if (!$mainframe->getCfg( 'allowUserRegistration' )) {
        mosNotAuth();
        return;
    }

  $mainframe->SetPageTitle(_REGISTER_TITLE);
    HTML_registration::registerForm($option, $useractivation);
}

function saveRegistration( $option ) {
    global $database, $my, $acl;
    global $mosConfig_sitename, $mosConfig_live_site, $mosConfig_useractivation, $mosConfig_allowUserRegistration;
    global $mosConfig_mailfrom, $mosConfig_fromname, $mosConfig_mailfrom, $mosConfig_fromname;

    if ($mosConfig_allowUserRegistration=="0") {
        mosNotAuth();
        return;
    }

    $row = new mosUser( $database );

    if (!$row->bind( $_POST, "usertype" )) {
        echo "<script> alert('".$row->getError()."'); window.history.go(-1); </script>\n";
        exit();
    }

    mosMakeHtmlSafe($row);

    $row->id = 0;
    $row->usertype = '';
    $row->gid = $acl->get_group_id('Registered','ARO');

    if ($mosConfig_useractivation=="1") {
        $row->activation = md5( mosMakePassword() );
        $row->block = "1";
    }

    if (!$row->check()) {
        echo "<script> alert('".$row->getError()."'); window.history.go(-1); </script>\n";
        exit();
    }

    $pwd = $row->password;
    $row->password = md5( $row->password );
    $row->registerDate = date("Y-m-d H:i:s");

    if (!$row->store()) {
        echo "<script> alert('".$row->getError()."'); window.history.go(-1); </script>\n";
        exit();
    }
    $row->checkin();

    $name = $row->name;
    $email = $row->email;
    $username = $row->username;

    $subject = sprintf (_SEND_SUB, $name, $mosConfig_sitename);
    $subject = html_entity_decode($subject, ENT_QUOTES);
    if ($mosConfig_useractivation=="1"){
        $message = sprintf (_USEND_MSG_ACTIVATE, $name, $mosConfig_sitename, $mosConfig_live_site."/index.php?option=com_registration&task=activate&activation=".$row->activation, $mosConfig_live_site, $username, $pwd);
    } else {
        $message = sprintf (_USEND_MSG, $name, $mosConfig_sitename, $mosConfig_live_site);
    }

    $message = html_entity_decode($message, ENT_QUOTES);
    // Send email to user
    if ($mosConfig_mailfrom != "" && $mosConfig_fromname != "") {
        $adminName2 = $mosConfig_fromname;
        $adminEmail2 = $mosConfig_mailfrom;
    } else {
        $database->setQuery( "SELECT name, email FROM #__users"
        ."\n WHERE usertype='superadministrator'" );
        $rows = $database->loadObjectList();
        $row2 = $rows[0];
        $adminName2 = $row2->name;
        $adminEmail2 = $row2->email;
    }

    mosMail($adminEmail2, $adminName2, $email, $subject, $message);

    // Send notification to all administrators
    $subject2 = sprintf (_SEND_SUB, $name, $mosConfig_sitename);
    $message2 = sprintf (_ASEND_MSG, $adminName2, $mosConfig_sitename, $row->name, $email, $username);
    $subject2 = html_entity_decode($subject2, ENT_QUOTES);
    $message2 = html_entity_decode($message2, ENT_QUOTES);

    // get superadministrators id
    $admins = $acl->get_group_objects( 25, 'ARO' );

    foreach ( $admins['users'] AS $id ) {
        $database->setQuery( "SELECT email, sendEmail FROM #__users"
            ."\n WHERE id='$id'" );
        $rows = $database->loadObjectList();

        $row = $rows[0];

        if ($row->sendEmail) {
            mosMail($adminEmail2, $adminName2, $row->email, $subject2, $message2);
        }
    }

    if ( $mosConfig_useractivation == "1" ){
        echo _REG_COMPLETE_ACTIVATE;
    } else {
        echo _REG_COMPLETE;
    }

}

function activate( $option ) {
    global $database;

    $activation = trim( mosGetParam( $_REQUEST, 'activation', '') );

    $database->setQuery( "SELECT id FROM #__users"
    ."\n WHERE activation='$activation' AND block='1'" );
    $result = $database->loadResult();

    if ($result) {
        $database->setQuery( "UPDATE #__users SET block='0', activation='' WHERE activation='$activation' AND block='1'" );
        if (!$database->query()) {
            echo "SQL error" . $database->stderr(true);
        }
        echo _REG_ACTIVATE_COMPLETE;
    } else {
        echo _REG_ACTIVATE_NOT_FOUND;
    }
}

function is_email($email){
    $rBool=false;

    if(preg_match("/[\w\.\-]+@\w+[\w\.\-]*?\.\w{1,4}/", $email)){
        $rBool=true;
    }
    return $rBool;
}
?>

Where should I edit?

After that, do I have to re-install either the forum or the site? Or can I keep both sites and edit prefix through phpMyAdmin? If i understood right, I should first go to the PunBB-database and change

users
posts
topics

to

punbb_users
punbb_posts
punbb_topics

with all tables?

And after that, I go to config.php in PunBB and change the table-information so it matches?

I'm no master in this, so it would be very nice if anyone could correct me and help me further.

Will I have to re-install both Mambo and the forum? Does that mean that I have to loose all members and posts in the forum, and all content at the homepage? Can I make a complete backup of PunBB, then re-install the forum with prefix as you said, then use the backup to get all members back? If I do as you say, would it work then?

I'll try, but I can't loose all members and posts in the forum, like starting all over again..

Thanks. I know, it's a little dark. Beause some of the outer borders in topics disappeared. If anyone could improve the css and post here, that would be great!