1 Topic by tagwolf

  • tagwolf
  • Baby member
  • Offline
  • Registered: 2011-05-19
  • Posts: 20

Topic: Forum integration problems

We are launching our site soon and are running into a problem integrating a forum into vld. We have tried both punbb and phpbb3.

I put the site into debug mode and it outputs the following when I try to sync the dbs:

MySQL ERROR

Error Number: 1146

Description: Table 'vldpersonals.users' doesn't exist

Query: SELECT user_id, user_type FROM users WHERE username_clean='admin' LIMIT 1

It's trying to connect to the table of phpbb3 here but it's using the vldpersonals database. Obviously this won't work. Am I forced to install the database tables into the dating database and prefix them?


This is the db connection string for both pun and phpbb3 in the mod code:

function mod_punbb_add_member(&$MDB, $params)
{
        global $DB, $SESSION, $PREFS;

        // fetch system member
    $result = $DB->query("SELECT username, password, email, lastvisit, joindate, ipaddress FROM  " . DB_PREFIX . "members WHERE member_id='{$params['member_id']}' LIMIT 1");

I've gone over configs a bunch of times. Here's what I have currently:

Enable phpbb3: yes
relative forum url: /forum (dating is in /dating)
table prefix: (blank)
db host: (blank)
database name: phpbb
database user: phpbb
database password: *******


Can someone please help me with this? I'm only focusing on phpbb3 here, but wanted to let you know I TRIED punbb and got the same issue of it trying to use the dating database instead of, in that case, punbb.

2 Reply by tagwolf

  • tagwolf
  • Baby member
  • Offline
  • Registered: 2011-05-19
  • Posts: 20

Re: Forum integration problems

*sigh*

On a whim I tried filling in db hostname with 'localhost'. It worked....

File this under bugs.

This does bring up a good question though. How can I ensure new users are synced after creation? Or at least after approval / paying, etc.

I definitely want them to have access to the forum right away.

Last edited by tagwolf (2011-05-27 14:56:13)

3 Reply by tagwolf

  • tagwolf
  • Baby member
  • Offline
  • Registered: 2011-05-19
  • Posts: 20

Re: Forum integration problems

I have one more problem too. It appears my forum admin account lost admin privileges as there is a user in my dating panel called admin and one in phpbb called admin. For some reason it overwrote permissions.

FYI I'm using the "perfect phpbb integration script now to even get phpbb3 working at all. It was having some default_lang column doesn't exist error for the one that comes with vldpersonals."

Anyways here's the code include/modules/forums/mod_phpbb3.php:

<?php
/*
=====================================================
vldPersonals - by VLD Interactive
----------------------------------------------------
http://www.vldpersonals.com/
http://www.vldinteractive.com/
-----------------------------------------------------
Copyright (c) 2005-2010 VLD Interactive
=====================================================
THIS IS COPYRIGHTED SOFTWARE
PLEASE READ THE LICENSE AGREEMENT
http://www.vldpersonals.com/agreement/
=====================================================
*/
// ------------------------------------------------
// Add member
// ------------------------------------------------
function mod_phpbb3_add_member(&$MDB, $params)
{
    global $DB, $SESSION, $PREFS;
    // fetch system member
    $result = $DB->query("SELECT username, password, email, lastvisit, joindate, ipaddress FROM  " . DB_PREFIX . "members WHERE member_id='" . $params['member_id'] . "' LIMIT 1");
    if (!$DB->num_rows($result)) return;
    $user_data = $DB->fetch_array($result);
    // set general details
    $user_data['username'] = mysql_real_escape_string($user_data['username']);
    $user_data['email'] = mysql_real_escape_string($user_data['email']);
    $user_data['ipaddress'] = mysql_real_escape_string($user_data['ipaddress']);
    $user_data['lastvisit'] = mysql_real_escape_string($user_data['lastvisit'] ? $user_data['lastvisit'] : time());
    $user_data['joindate'] = mysql_real_escape_string($user_data['joindate']);
    $user_data['ipaddress'] = mysql_real_escape_string($user_data['ipaddress'] != 'Uknown' ? $user_data['ipaddress'] : '127.0.0.1');
    // set password
    if (isset($params['password']) && $params['password']) {
        $user_data['password'] = mysql_real_escape_string(md5($params['password']));
    } else {
        $user_data['password'] = mysql_real_escape_string($user_data['password']);
    }
    // set group/block
    if (isset($params['block']) && $params['block']) {
        $user_data['inactive'] = "1";
        $user_data['admin'] = "0";
    } elseif (isset($params['admin']) && $params['admin']) {
        $user_data['inactive'] = "0";
        $user_data['admin'] = "1";
    } else {
        $user_data['inactive'] = "0";
        $user_data['admin'] = "0";
    }
    $usernameTL = strtolower($user_data['username']);
    // fetch forum member
    $result = $MDB->query("SELECT user_id, user_type FROM " . $PREFS->conf['module_phpbb3_table_prefix'] . "users WHERE username_clean='" . $usernameTL . "' LIMIT 1");
    if ($MDB->num_rows($result)) {
        $arrUserID = $MDB->fetch_array($result);
    } else {
        $arrUserID = array('user_id' => 0, 'user_type' => 0);
    }
    // set commmon details
    $where_sql = "SET group_id=2,
        username = '" . $user_data['username'] . "',
        username_clean = '" . strtolower($user_data['username']) . "',
        user_password = '{$user_data['password']}',
        user_passchg = '{$user_data['lastvisit']}',
        user_email = '{$user_data['email']}',
        user_type = {$user_data['inactive']},
        user_inactive_reason = {$user_data['inactive']},
        user_regdate = '{$user_data['joindate']}',
        user_lastmark = '{$user_data['lastvisit']}',
        user_lastvisit = '{$user_data['lastvisit']}'";
    
    // new member
    if (! $arrUserID['user_id']) {
        $where_sql .= ",user_style = 1,
                         user_ip = '{$user_data['ipaddress']}',
                          user_lang = 'en'";

        $MDB->query("INSERT INTO " . $PREFS->conf['module_phpbb3_table_prefix'] . "users {$where_sql}");
        $userID = $MDB->get_insert_id();

        $MDB->query("INSERT INTO " . $PREFS->conf['module_phpbb3_table_prefix'] . "user_group (user_id, group_id, group_leader, user_pending) VALUES ({$userID}, 2, 0, 0)");

        if (!$user_data['inactive']) {
            $MDB->query("UPDATE " . $PREFS->conf['module_phpbb3_table_prefix'] . "config SET config_value=config_value+1 WHERE config_name='num_users' LIMIT 1");
        }
    }
    // existing member
    else {
        $MDB->query("UPDATE " . $PREFS->conf['module_phpbb3_table_prefix'] . "users {$where_sql} WHERE user_id = {$arrUserID['user_id']} LIMIT 1");

        if (!$arrUserID['user_type'] && $user_data['inactive']) {
            $MDB->query("UPDATE " . $PREFS->conf['module_phpbb3_table_prefix'] . "config SET config_value=config_value-1 WHERE config_name='num_users' LIMIT 1");
        } elseif ($arrUserID['user_type'] && !$user_data['inactive']) {
            $MDB->query("UPDATE " . $PREFS->conf['module_phpbb3_table_prefix'] . "config SET config_value=config_value+1 WHERE config_name='num_users' LIMIT 1");
        }
    }
    // set admin permissions    if ($user_data['admin']) {
        $MDB->query("INSERT INTO " . $PREFS->conf['module_phpbb3_table_prefix'] . "acl_users (user_id, forum_id, auth_option_id, auth_role_id, auth_setting) VALUES ({$arrUserID['user_id']}, 0, 0, 11, 0)");
        $MDB->query("INSERT INTO " . $PREFS->conf['module_phpbb3_table_prefix'] . "moderator_cache (forum_id, user_id, username, group_id, group_name, display_on_index) values (0,{$arrUserID['user_id']},'{$user_data['username']}',0,'',
1)");
    } else {
        $MDB->query("DELETE FROM " . $PREFS->conf['module_phpbb3_table_prefix'] . "acl_users WHERE user_id = {$arrUserID['user_id']}");
        $MDB->query("DELETE FROM " . $PREFS->conf['module_phpbb3_table_prefix'] . "moderator_cache WHERE user_id = {$arrUserID['user_id']}");
    }
}
// End function
// ------------------------------------------------
// Update member
// ------------------------------------------------
function mod_phpbb3_update_member(&$MDB, $params)
{
    global $DB, $SESSION, $PREFS;

    mod_phpbb3_add_member($MDB, $params);
}
// End function
// ------------------------------------------------
// Block member
// ------------------------------------------------
function mod_phpbb3_block_member(&$MDB, $params)
{
    global $DB, $SESSION, $PREFS;
    // fetch system member
    $result = $DB->query("SELECT username FROM  " . DB_PREFIX . "members WHERE member_id='" . $params['member_id'] . "' LIMIT 1");
    if (!$DB->num_rows($result)) return;
    $user_data = $DB->fetch_array($result);
    $usernameTL = strtolower($user_data['username']);
    // fetch forum member
    $result = $MDB->query("SELECT user_id FROM " . $PREFS->conf['module_phpbb3_table_prefix'] . "users WHERE username_clean = '$usernameTL' LIMIT 1");
    if ($MDB->num_rows($result)) {
        $arrUserID = $MDB->fetch_array($result);
    } else {
        $arrUserID = array('user_id' => 0);
    }
    // block member
    if ($arrUserID['user_id']) {
        $DB->query("UPDATE " . $PREFS->conf['module_phpbb3_table_prefix'] . "users SET user_type=1, user_inactive_reason=1 WHERE user_id = {$arrUserID['user_id']} LIMIT 1");
        $DB->query("UPDATE " . $PREFS->conf['module_phpbb3_table_prefix'] . "config SET config_value=config_value-1 WHERE config_name='num_users' LIMIT 1");
    }
}
// End function
// ------------------------------------------------
// Unblock member
// ------------------------------------------------
function mod_phpbb3_unblock_member(&$MDB, $params)
{
    global $DB, $SESSION, $PREFS;
    // fetch system member
    $result = $DB->query("SELECT username FROM  " . DB_PREFIX . "members WHERE member_id='" . $params['member_id'] . "' LIMIT 1");
    if (!$DB->num_rows($result)) return;
    $user_data = $DB->fetch_array($result);
    $usernameTL = strtolower($user_data['username']);
    // fetch forum member
    $result = $MDB->query("SELECT user_id FROM " . $PREFS->conf['module_phpbb3_table_prefix'] . "users WHERE username_clean = '$usernameTL' LIMIT 1");
    if ($MDB->num_rows($result)) {
        $arrUserID = $MDB->fetch_array($result);
    } else {
        $arrUserID = array('user_id' => 0);
    }
    // unblock member
    if ($arrUserID['user_id']) {
        $MDB->query("UPDATE " . $PREFS->conf['module_phpbb3_table_prefix'] . "users SET user_type=0, user_inactive_reason=0 WHERE user_id = {$arrUserID['user_id']} LIMIT 1");
        $MDB->query("UPDATE " . $PREFS->conf['module_phpbb3_table_prefix'] . "config SET config_value=config_value+1 WHERE config_name='num_users' LIMIT 1");
    }
}
// End function
// ------------------------------------------------
// Delete member
// ------------------------------------------------
function mod_phpbb3_delete_member(&$MDB, $params)
{
    global $DB, $SESSION, $PREFS;
    // fetch system member
    $result = $DB->query("SELECT username, email, joindate FROM  " . DB_PREFIX . "members WHERE member_id='" . $params['member_id'] . "' LIMIT 1");
    if (!$DB->num_rows($result)) return;
    $user_data = $DB->fetch_array($result);
    $usernameTL = strtolower($user_data['username']);
    // fetch forum member
    $result = $MDB->query("SELECT * FROM " . $PREFS->conf['module_phpbb3_table_prefix'] . "users WHERE username_clean = '$usernameTL' LIMIT 1");
    if ($MDB->num_rows($result)) {
        $arrUserID = $MDB->fetch_array($result);
    } else {
        $arrUserID = array('user_id' => 0, 'user_type' => 0);
    }
    // delete member
    if ($arrUserID['user_id']) {
        // $arrUserID - contains a user;
        if(!defined("GUEST_NAME"))
            define("GUEST_NAME", "Ospite"); // name of the guest in your language;
        if(!defined("ANONYMOUS"))
            define('ANONYMOUS', 1); //Anonymous ID. Default is 1;

        $uname=$arrUserID['username'];

        // set forum's laster postred name to Guest;
        $sql = 'UPDATE ' . $PREFS->conf['module_phpbb3_table_prefix'] . 'forums
                    SET forum_last_poster_id = ' . ANONYMOUS . ",   forum_last_poster_colour = '',
                     forum_last_poster_name = '" .$uname . "'
                    WHERE forum_last_poster_id = " . $arrUserID['user_id'] ;
        $MDB->query($sql);
        // reset all their posts to Anonymous user
        $sql = 'UPDATE ' . $PREFS->conf['module_phpbb3_table_prefix'] . 'posts
                    SET poster_id = ' . ANONYMOUS . ",
                    post_username = '" . $uname . "'
                    WHERE poster_id = " . $arrUserID['user_id'] ;
        $MDB->query($sql);
        // reset last edit
        $sql = 'UPDATE ' . $PREFS->conf['module_phpbb3_table_prefix'] . 'posts
                    SET post_edit_user = ' . ANONYMOUS . "
                    WHERE post_edit_user = " . $arrUserID['user_id'] ;
        $MDB->query($sql);
        // reset first poster for every topic;
        $sql = 'UPDATE ' . $PREFS->conf['module_phpbb3_table_prefix'] . 'topics
                    SET topic_poster = ' . ANONYMOUS . ",   topic_first_poster_colour = '',  topic_first_poster_name = '" . $uname . "'
                    WHERE topic_poster = " . $arrUserID['user_id'] ;
        $MDB->query($sql);

        // reset last poster for every topic
        $sql = 'UPDATE ' . $PREFS->conf['module_phpbb3_table_prefix'] . 'topics
                    SET topic_last_poster_id = ' . ANONYMOUS . ", topic_last_poster_colour = '',
                    topic_last_poster_name = '" . $uname . "'
                    WHERE topic_last_poster_id = " . $arrUserID['user_id'] ;
        $MDB->query($sql);

        // reset attachments;
        $sql = 'UPDATE ' . $PREFS->conf['module_phpbb3_table_prefix'] . 'attachments
                    SET poster_id = ' . ANONYMOUS . "
                    WHERE poster_id = " . $arrUserID['user_id'] ;
        $MDB->query($sql);
        // if user had posts; we increment the number of posts for anonymous;
        if ($arrUserID['user_posts']) {
            $sql = 'UPDATE ' . $PREFS->conf['module_phpbb3_table_prefix'] . 'users
                        SET user_posts = user_posts + ' . $arrUserID['user_posts'] . '
                        WHERE user_id = ' . ANONYMOUS;
            $MDB->query($sql);
        }
        // removing the user as per original script;
        $MDB->query("DELETE FROM " . $PREFS->conf['module_phpbb3_table_prefix'] . "users WHERE user_id = {$arrUserID['user_id']} LIMIT 1");
        $MDB->query("DELETE FROM " . $PREFS->conf['module_phpbb3_table_prefix'] . "banlist WHERE ban_userid = {$arrUserID['user_id']} LIMIT 1");
        $MDB->query("DELETE FROM " . $PREFS->conf['module_phpbb3_table_prefix'] . "sessions WHERE session_user_id = {$arrUserID['user_id']}");
        $MDB->query("DELETE FROM " . $PREFS->conf['module_phpbb3_table_prefix'] . "sessions_keys WHERE user_id = {$arrUserID['user_id']}");
        $MDB->query("DELETE FROM " . $PREFS->conf['module_phpbb3_table_prefix'] . "user_group WHERE user_id = {$arrUserID['user_id']}");
        $MDB->query("DELETE FROM " . $PREFS->conf['module_phpbb3_table_prefix'] . "acl_users WHERE user_id = {$arrUserID['user_id']}");

        if (!$arrUserID['user_type']) {
            $MDB->query("UPDATE " . $PREFS->conf['module_phpbb3_table_prefix'] . "config SET config_value=config_value-1 WHERE config_name='num_users' LIMIT 1");
        }
    }
}
// End function
// ------------------------------------------------
// Login member
// ------------------------------------------------
function mod_phpbb3_login_member(&$MDB, $params)
{
    global $DB, $SESSION, $PREFS, $LANG;

    $config = array();
    $config = get_config($MDB);

    $usernameTL = strtolower($params['username']);
    // fetch forum member
    $result = $MDB->query("SELECT user_id FROM " . $PREFS->conf['module_phpbb3_table_prefix'] . "users WHERE username_clean = '$usernameTL' LIMIT 1");
    if ($MDB->num_rows($result)) {
        $arrUserID = $MDB->fetch_array($result);

    } else {
        return;
    }

    unset($result);

    $userID = $arrUserID['user_id'];
    $current_time = time();
    $auto_login_key = unique_id($MDB);
    // fetch forum data
    $result = $MDB->query("SELECT key_id FROM " . $PREFS->conf['module_phpbb3_table_prefix'] . "sessions_keys WHERE user_id = '$userID' LIMIT 1");
    if ($MDB->num_rows($result)) {
        $arrUSK = $MDB->fetch_array($result);
        $key_id = $arrUSK['key_id'];

        $MDB->query("UPDATE " . $PREFS->conf['module_phpbb3_table_prefix'] . "sessions_keys
            SET key_id = '" . md5($auto_login_key) . "' WHERE key_id = '$key_id' LIMIT 1");
    } else {
        $MDB->query("INSERT INTO " . $PREFS->conf['module_phpbb3_table_prefix'] . "sessions_keys
            (key_id, user_id, last_ip, last_login)
            VALUES ('" . md5($auto_login_key) . "', $userID, 0, $current_time)");
    }
    // And now rebuild the cookie
    $cookie_expire = time() + (($config['max_autologin_time']) ? 86400 * (int) $config['max_autologin_time'] : 31536000);

    set_cookie('u', $userID, $cookie_expire, $MDB);
    set_cookie('k', $auto_login_key, $cookie_expire, $MDB);
    set_cookie('sid', session_id(), $cookie_expire, $MDB);
}
// End function
// ------------------------------------------------
// Logout member
// ------------------------------------------------
function mod_phpbb3_logout_member(&$MDB, $params)
{
    global $DB, $SESSION, $PREFS, $LANG;
    $config = array();
    $config = get_config($MDB);

    $usernameTL = strtolower($params['username']);
    // fetch forum member
    $result = $MDB->query("SELECT user_id FROM " . $PREFS->conf['module_phpbb3_table_prefix'] . "users WHERE username_clean = '$usernameTL' LIMIT 1");
    if ($MDB->num_rows($result)) {
        $arrUserID = $MDB->fetch_array($result);
    } else {
        return;
    }

    unset($result);

    $userID = $arrUserID['user_id'];
    $current_time = time();

    $MDB->query("DELETE FROM " . $PREFS->conf['module_phpbb3_table_prefix'] . "sessions WHERE session_user_id ='$userID'");
    $MDB->query("DELETE FROM " . $PREFS->conf['module_phpbb3_table_prefix'] . "sessions_keys WHERE user_id = '$userID'");
    // And now kill the cookie
    $cookie_expire = $current_time - 31536000;

    set_cookie('u', '', $cookie_expire, $MDB);
    set_cookie('k', '', $cookie_expire, $MDB);
    set_cookie('sid', '', $cookie_expire, $MDB);

    unset($current_time, $cookie_expire);
}
// End Function
function get_config(&$MDB)
{
    global $DB, $PREFS;

    $result = $MDB->query("SELECT config_name, config_value
                FROM " . $PREFS->conf['module_phpbb3_table_prefix'] . "config");

    if ($MDB->num_rows($result)) {
        // ------------------------------------------------
        // Fetch resultset
        // ------------------------------------------------
        while ($obj = $MDB->fetch_array($result, MYSQL_ASSOC)) {
            $board_config[$obj['config_name']] = $obj['config_value'];
        }

        unset($obj);
    }
    unset($result);
    return $board_config;
}

function set_cookie($name, $cookiedata, $cookietime, &$MDB)
{
    $config = get_config($MDB);

    $name_data = rawurlencode($config['cookie_name'] . '_' . $name) . '=' . rawurlencode($cookiedata);
    $expire = gmdate('D, d-M-Y H:i:s \\G\\M\\T', $cookietime);
    $domain = (!$config['cookie_domain'] || $config['cookie_domain'] == 'localhost' || $config['cookie_domain'] == '127.0.0.1') ? '' : '; domain=' . $config['cookie_domain'];

    header('Set-Cookie: ' . $name_data . (($cookietime) ? '; expires=' . $expire : '') . '; path=' . $config['cookie_path'] . $domain . ((!$config['cookie_secure']) ? '' : '; secure') . '; HttpOnly', false);
}

/**
 * Return unique id
 *
 * @param string $extra additional entropy
 */
function unique_id(&$MDB)
{
    global $DB;
    $config = get_config($MDB);


    unset($current_time, $cookie_expire);
}
// End Function
function get_config(&$MDB)
{
    global $DB, $PREFS;

    $result = $MDB->query("SELECT config_name, config_value
                FROM " . $PREFS->conf['module_phpbb3_table_prefix'] . "config");

    if ($MDB->num_rows($result)) {
        // ------------------------------------------------
        // Fetch resultset
        // ------------------------------------------------
        while ($obj = $MDB->fetch_array($result, MYSQL_ASSOC)) {
            $board_config[$obj['config_name']] = $obj['config_value'];
        }

        unset($obj);
    }
    unset($result);
    return $board_config;
}

function set_cookie($name, $cookiedata, $cookietime, &$MDB)
{
    $config = get_config($MDB);

    $name_data = rawurlencode($config['cookie_name'] . '_' . $name) . '=' . rawurlencode($cookiedata);
    $expire = gmdate('D, d-M-Y H:i:s \\G\\M\\T', $cookietime);
    $domain = (!$config['cookie_domain'] || $config['cookie_domain'] == 'localhost' || $config['cookie_domain'] == '127.0.0.1') ? '' : '; domain=' . $config['cookie_domain'];

    header('Set-Cookie: ' . $name_data . (($cookietime) ? '; expires=' . $expire : '') . '; path=' . $config['cookie_path'] . $domain . ((!$config['cookie_secure']) ? '' : '; secure') . '; HttpOnly', false);
}

/**
 * Return unique id
 *
 * @param string $extra additional entropy
 */
function unique_id(&$MDB)
{
    global $DB;
    $config = get_config($MDB);

    $val = $config['rand_seed'] . microtime();
    $val = md5($val);

    return substr($val, 4, 16);
}

?>

Last edited by tagwolf (2011-05-27 15:21:53)

4 Reply by Christopher

  • Christopher
  • Regular member
  • Offline
  • Registered: 2008-10-30
  • Posts: 165

Re: Forum integration problems

We have a flawless punbb integration - check it out and send us a mail for a quote.

[Commercial 2.5.3 and 2.5.7]
Never mess with a blue banana.

Christopher's Website

5 Reply by tagwolf

  • tagwolf
  • Baby member
  • Offline
  • Registered: 2011-05-19
  • Posts: 20

Re: Forum integration problems

Sorry to post so much. I keep discovering more and more. I found that punbb gets completely broken when you integrate it with vldpersonals and it doesn't hash or insert any passwords so noone can login.

phpbb3 integration that comes stock doesn't work at all due to the default_lang column error, possibly others.

the "perfect phpbb3 script" I posted earlier is the closest I've gotten but it corrupted somewhat the admin account on my forum, I'm gonna have to reinstall.

Does ANYONE have a working copy of the latest stable vldpersonals and latest stable phpbb3 or some other forum software working at all? How did you do it? etc.

Any help would be greatly appreciated. Again sorry to post 5 times but I kept discovering new data I felt was important.

So far other than this I LOVE the product.

6 Reply by tagwolf

  • tagwolf
  • Baby member
  • Offline
  • Registered: 2011-05-19
  • Posts: 20

Re: Forum integration problems

Christopher wrote:

We have a flawless punbb integration - check it out and send us a mail for a quote.

Thank you but I already paid for Seamless forum integration in vldpersonals

Seamless forum integration
vldPersonals can be automatically integrated with several popular forum boards to allow your members communicate with each other. Supported forums include phpBB2, phpBB3, vBulletin3, Vanilla and punBB boards. Integration is seamless and doesn’t require your members to register or login twice.

7 Reply by fainonline

  • fainonline
  • Regular member
  • Offline
  • From: [Commercial X.X.X]
  • Registered: 2007-02-10
  • Posts: 152

Re: Forum integration problems

I don't know why you have so much problem, i have Vbulletin3 and punbb integration without any problems... mmmm

Unfortunately no one can be told what G.A.Y is - you have to See It  to believe it. :-)

fainonline's Website

8 Reply by Christopher

  • Christopher
  • Regular member
  • Offline
  • Registered: 2008-10-30
  • Posts: 165

Re: Forum integration problems

If you´ve paid for a mod, should´nt you ask the people who did it to fix it?

[Commercial 2.5.3 and 2.5.7]
Never mess with a blue banana.

Christopher's Website

9 Reply by Richard1969

  • Richard1969
  • Baby member
  • Offline
  • Registered: 2010-03-11
  • Posts: 35

Re: Forum integration problems

I have phpbb3 integrated with vld personals.
Without any problems. Just followed the instructions.
Vld and phpbb3 tables are in same database.
When user registrates member is automaticly created in phpbb members.
When edit or delete member in vld, member is updated or deleted without problems.
Modified some phpbb3 files to make a redirect to users profile in vld when user profile is viewed in phpbb3

Vld personals version 2.6
Phpbb3 version 3.08

Vld comercial version 2.6

10 Reply by tagwolf

  • tagwolf
  • Baby member
  • Offline
  • Registered: 2011-05-19
  • Posts: 20

Re: Forum integration problems

Ok. I got VLDpersonals working with an old version of punbb.

Currently I want to report:

vldpersonals does NOT work with phpbb3 3.0.8 or the latest version of punbb. But will work with the older version PunBB 1.2.23

vldpersonals will error if you do not put in localhost into the host field even though it states it will default

vldpersonals breaks the phpbb database ADM login and will also error with no "default_lang" column in the config table.

vldpersonals will not retain admin groups when syncing with either stock code of the code I posted above.

I'd like to see group mapping as a feature in vld personals. I.e. the ability to map vld groups to phpbb3 groups.

Last edited by tagwolf (2011-05-29 16:24:52)

11 Reply by Christopher

  • Christopher
  • Regular member
  • Offline
  • Registered: 2008-10-30
  • Posts: 165

Re: Forum integration problems

VLD works fine with latest punbb - we have 1.3.4 integrated in our site, works like a charm.

Last edited by Christopher (2011-05-30 09:13:56)

[Commercial 2.5.3 and 2.5.7]
Never mess with a blue banana.

Christopher's Website