I am just new to joomla community builder. Currently I am working for a perfact community solution . As far as I know one good combination was using vbulletin with the phpfox , but due to certain factors I can't use PHPFOX.
Vbulletin is the best forum script ( you will second me). They have great support, separate hackinhg site in the form of vbulletin.org . There are many complications regarding phpfox.
they have a very limited support. The most striking thing is when you buy 300$ script .NO UPDATES INCLUDED in the deal. they time and again release new versions and there is a m upgrade fee of 50$ . More over every feature like arcade system is sold for 50$+ ( i don't know the exact price). It is said about phpfox time and again that You have to pay them again and again or to live with the Bugs if any.
Then I forund joomla ( developed by 30,000 + developers ) every minute as an opensource. Joomla+ community builder was the best alternative to the PHPFOX etc.
I bought vbulletin integrated that with joomla + community builder using a paid module.
I want my fellows ( you) to help me out in a little thing to do. Here are the details
IF
CB profile URL after mod rewrite is
www.joomlepolis.com/memberID
Vbulletin Profile ID is :
www.joomlapolis.com/forum/members.php?u=123
Provided USER ID is same on both scripts.
How Can I redirect vbulletin member's profiles pages to the CB member's profile pages
one of the PHPFOX member done that as follows ( vbulletin integration is introduced in the latest version only at phpfox)
[code:1]
<?php
// This redirects the member profile to PHPFOX
// this should replace member.php in the vb forums directory. (make a backup of the old member.php)
// you need to make sure the usernames are the same in phpfox and vBulletin
// e.g. username in vb is Kicksome, user in phpfox is Kicksome
// this looks up the member's name in the vb table and then retrieves the
// member id from the phpfox table and redirects.
if (isset($_GET["u"])) { $userid = $_GET["u"]; } else {$userid = "1";}
$g_dbconnection = "127.0.0.1";
$g_dbusername = "root";
$g_dbpassword = "DBPASSWORDHERE";
$g_dbdatabase = "VBDATABASEHERE";
$link1 = mysql_pconnect($g_dbconnection, $g_dbusername, $g_dbpassword);
// connect to VB
if (!$link1) { die('Could not connect to: ' . $g_dbdatabase . mysql_error()); }
if (! mysql_select_db($g_dbdatabase) ) { echo "<P>Unable to locate the database: " . $g_dbdatabase . " at this time.</P>"; exit(); }
$query="select userid, username, password from user where userid = '" . $userid . "'";
$result1=mysql_query($query);
if (!$result1) { echo("<P>Error performing query: " . mysql_error() . "</P>"«»); exit(); }
if ($num_rows = mysql_num_rows($result1) == 0) echo "no rows....";
$num_rows = mysql_num_rows($result1);
$row = mysql_fetch_assoc($result1);
$username = $row;
//
// now connect to phpfox
//
$g_dbdatabase = "PHPFOXDATABASEHERE";
$link1 = mysql_pconnect($g_dbconnection, $g_dbusername, $g_dbpassword);
if (!$link1) { die('Could not connect to: ' . $g_dbdatabase . mysql_error()); }
if (! mysql_select_db($g_dbdatabase) ) { echo "<P>Unable to locate the database: " . $g_dbdatabase . " at this time.</P>"; exit(); }
$query2="select id from user where user = '" . $username . "'";
$result2=mysql_query($query2);
if (!$result2) { echo("<P>Error performing query: " . mysql_error() . "</P>"«»); exit(); }
if ($num_rows2 = mysql_num_rows($result2) == 0) echo "no rows....";
$num_rows2 = mysql_num_rows($result2);
$row2 = mysql_fetch_assoc($result2);
$user = $row2;
header("Location:
www.YOURSITEHERE.com/profile.php?id=" . $user); /* Redirect browser */
?>
[/code:1]
can any one plz help me out in this case. I need your support badly
Lookin for good response
Ali
Post edited by: alimalik, at: 2006/08/28 15:47
Post edited by: alimalik, at: 2006/08/29 10:46