you can certainly install a 3rd party BB on your server, and then have the sign up process from cs-cart write to the BB tables so that the user information is the same and hence just one login account. I have not done this with cs-cart, but another application i did just that - installed phpBB and from my other application added some php code that updated 3 tables in phpBB for account creations.
good luck
Delta9000, do you have the coding portions available at all?
Would love to use this myself for my autoparts store
Jesse
here is my php code - this is assuming I have gotten the username and password from a previous step - then I connect to the phpBB database and update the required tables to add a new user - hope this helps you
//now lets add the info to the bb tables
//there are 3 tables we need to insert into
//step 1 - connect to this db
$db = mysql_connect(“localhost”, “USERNAME”, “PASSWORD”);
mysql_select_db(“DBNAME”,$db);
if (!$db)
{
die(‘Could not connect: ’ . mysql_error());
}
//step 2a - get the next available id number
$SQLstring = “SELECT max(user_id) from phpbb_users”;
$result = mysql_query($SQLstring ,$db);
$myrow = mysql_fetch_array($result);
$NEXT_CID_NUM = $myrow[0];
$ID = $NEXT_CID_NUM +1;
//step 2b - load the data into the tables
$sql1 = "INSERT INTO phpbb_groups ( group_id , group_type , group_name , group_description , group_moderator , group_single_user ) ";
$sql1 .= "VALUES (’$ID’, ‘1’, ‘’, ‘Personal User’, ‘0’, ‘1’)“;
$result = mysql_query($sql1 ,$db);
$sql2 = “INSERT INTO phpbb_user_group ( group_id , user_id , user_pending ) “;
$sql2 .= “VALUES (‘$ID’, ‘$ID’, ‘0’)”;
$result = mysql_query($sql2 ,$db);
$enc_pwd = md5($password);
$sql3 = “INSERT INTO phpbb_users ( user_id , user_active , username , user_password , user_session_time , user_session_page , user_lastvisit , user_regdate , user_level , user_posts , user_timezone , user_style , user_lang , user_dateformat , user_new_privmsg , user_unread_privmsg , user_last_privmsg , user_login_tries , user_last_login_try , user_emailtime , user_viewemail , user_attachsig , user_allowhtml , user_allowbbcode , user_allowsmile , user_allowavatar , user_allow_pm , user_allow_viewonline , user_notify , user_notify_pm , user_popup_pm , user_rank , user_avatar , user_avatar_type , user_email , user_icq , user_website , user_from , user_sig , user_sig_bbcode_uid , user_aim , user_yim , user_msnm , user_occ , user_interests , user_actkey , user_newpasswd ) “;
$sql3 .= “VALUES (‘$ID’, ‘1’, ‘$userid’, ‘$enc_pwd’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0.00’, NULL , NULL , ‘d M Y H:i’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, NULL , NULL , NULL , ‘1’, ‘1’, ‘1’, ‘1’, ‘1’, ‘1’, ‘1’, ‘0’, ‘0’, ‘0’, NULL , ‘0’, NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL )”;
$result = mysql_query($sql3 ,$db);
// echo “|”.$sql1.”|”.$sql2.”|”.$sql3.”|";
//step 3 - close the db since we are done
mysql_close($db);
[quote name=‘DELTA9000’]Jesse
here is my php code - this is assuming I have gotten the username and password from a previous step - then I connect to the phpBB database and update the required tables to add a new user - hope this helps you
//now lets add the info to the bb tables
//there are 3 tables we need to insert into
//step 1 - connect to this db
$db = mysql_connect("localhost", "USERNAME", "PASSWORD");
mysql_select_db("DBNAME",$db);
if (!$db)
{
die('Could not connect: ' . mysql_error());
}
//step 2a - get the next available id number
$SQLstring = "SELECT max(user_id) from phpbb_users";
$result = mysql_query($SQLstring ,$db);
$myrow = mysql_fetch_array($result);
$NEXT_CID_NUM = $myrow[0];
$ID = $NEXT_CID_NUM +1;
//step 2b - load the data into the tables
$sql1 = "INSERT INTO `phpbb_groups` ( `group_id` , `group_type` , `group_name` , `group_description` , `group_moderator` , `group_single_user` ) ";
$sql1 .= "VALUES ('$ID', '1', '', 'Personal User', '0', '1')";
$result = mysql_query($sql1 ,$db);
$sql2 = "INSERT INTO `phpbb_user_group` ( `group_id` , `user_id` , `user_pending` ) ";
$sql2 .= "VALUES ('$ID', '$ID', '0')";
$result = mysql_query($sql2 ,$db);
$enc_pwd = md5($password);
$sql3 = "INSERT INTO `phpbb_users` ( `user_id` , `user_active` , `username` , `user_password` , `user_session_time` , `user_session_page` , `user_lastvisit` , `user_regdate` , `user_level` , `user_posts` , `user_timezone` , `user_style` , `user_lang` , `user_dateformat` , `user_new_privmsg` , `user_unread_privmsg` , `user_last_privmsg` , `user_login_tries` , `user_last_login_try` , `user_emailtime` , `user_viewemail` , `user_attachsig` , `user_allowhtml` , `user_allowbbcode` , `user_allowsmile` , `user_allowavatar` , `user_allow_pm` , `user_allow_viewonline` , `user_notify` , `user_notify_pm` , `user_popup_pm` , `user_rank` , `user_avatar` , `user_avatar_type` , `user_email` , `user_icq` , `user_website` , `user_from` , `user_sig` , `user_sig_bbcode_uid` , `user_aim` , `user_yim` , `user_msnm` , `user_occ` , `user_interests` , `user_actkey` , `user_newpasswd` ) ";
$sql3 .= "VALUES ('$ID', '1', '$userid', '$enc_pwd', '0', '0', '0', '0', '0', '0', '0.00', NULL , NULL , 'd M Y H:i', '0', '0', '0', '0', '0', NULL , NULL , NULL , '1', '1', '1', '1', '1', '1', '1', '0', '0', '0', NULL , '0', NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL )";
$result = mysql_query($sql3 ,$db);
// echo "|".$sql1."|".$sql2."|".$sql3."|";
//step 3 - close the db since we are done
mysql_close($db);
What version do you have this working with at the moment delta?
I’ll try to get this installed on my test store when I get around to it
i first wrote this code for a non cs-cart solution that I created - just a programmed php mysql solution - that had user sign ups, so I wrote it so that when they registered for the site, the installation of phpBB i installed also got updated.
I then wanted to try from my demo store as well - and I added some code for it to work in 1.34 i believe sp2 - was a while ago i did it, and it did connect… i can try to find my files that I updated and get those off to you. But the 3 tables that I updated in phpbb database seemed to have been all that was needed - if my memory serves me correct the only issue i had was something with the signup date was 1970 or something.
good luck
Hi there ,
i was wondering if there has been any update for this post , as im in need to have universal login details between the main shop front and phpBB ,
kind regards
Dave
In fact… I am taking a looking in this idea for a good time.
In my case, I will use SMF ([url]http://www.simplemachines.org/[/url] ) this is one of the best foruns I know.
And it has a very good thing: COMMUNITY PARTICIPATION. You post in forum, people answer in the same day. Very good.
I tryed phpbb, too. But, because nobody answer… I will not use it.
I will try to integrate STORE (cs-cart) + FORUM (smf) + PORTAL (joomla) + GALLERY (bodyspace).
This is what people from Bodybuilding com does.
When you are looking a product, you can see who are the people that had already bought that supplement in the past, you can visit his/her profile and see photos from that person.
Very good idea.
Please let us know if you have any luck dragondf or anyone else. I really want this!
[quote name=‘ecb1’]Please let us know if you have any luck dragondf or anyone else. I really want this![/QUOTE]
I haven’t did it yet.
But If you have time, take a look in SimpleMachines forum (community)
I think to do this integration by SSO (single sign on).
You can take a lot of informatin using a framework from Sun, if I am not wrong. It has support to php.
Good lucky!