close ad
Help us test the new Databridge BETA with MySQLi support
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Using SA's user accounts with a forum like this

Thread began 11/10/2009 7:56 am by larsentim278054 | Last modified 1/12/2010 8:31 pm by Jimmy Wu | 2241 views | 11 replies |

larsentim278054

Using SA's user accounts with a forum like this

Hi,

I want to incorporate a forum in one of my sites that I'm already utilizing SA's user registration pages. I don't want them to have to have a separate forum account. Is this possible? I know you guys did it for this forum we're on - Could you help me accomplish this same task on my site? What forum software is this?

Thanks!

Sign in to reply to this post

Dani Chankhour

Although it is possible to use Security Assist with a forum software, usually most Forums have their own installation process and their own database configuration.

I would recommend looking into

www.phpbb.com/

since it is free.

Our Forums uses vbulletin.

Sign in to reply to this post

larsentim278054

Vbulletin isn't free? And I do realize that forums use their own user registration. I was wondering how to avoid that and use what the user is already logged in as (like you guys do). Is this a difficult process? I'm trying to avoid making the user register twice and have two diff. usernames and pwords. Can you tell me how to accomplish this?

Edit: Nevermind - I saw Vbulletin's price. I'd still like to know if it's possible to use the user registration details that the site is already utilizing, for the forum software (phpBB or Vbulletin). I know this forum is doing that - is it easy to accomplish with Vbulletin?

Sign in to reply to this post

Dani Chankhour

vbulletin is not free.

In order to accomplish this you will need to add some custom coding. Basically when a user comes to the forum and tries to register you will need to redirect them to your regular registration page (this is how we do it as well) and when you add them to your database, you will also need to add them to the forum software database with the specified information.

You can use DataAssist insert server behavior when adding the user to the forum database. or just write your own code to do that. And after a user log in, you will need to set the appropriate cookies and session to log them automatically to the forum.

Sign in to reply to this post

larsentim278054

Okay - so this can be done with PhpBB presumably, correct? So in my site user registration, I'll need the fields that the forum requires also in this registration, and have it update the forums database as well as the user database that SA uses. Is this difficult to do? I already have the SA user database registration page working. So I might need to add a few more fields to get it to work with the forum. That's fine, but how do I get it to update another database?

Sign in to reply to this post

Dani Chankhour

Yeah, you should be able to do it with PhpBB.

If you have DataAssist you can use the DataAssist Insert Server behavior which will insert the required information in the forum database after registering the user.

You will just need to add another database connection to your forum database.

Sign in to reply to this post

ijk76319396

I am trying to do the same thing and running into the following problems. When I open data assist and try to select the table phpbb_users I get a pop up message that says 'SQL type not recognized: 'unknown'.

All of my tables are in the same database as well.

Sign in to reply to this post

Dani Chankhour

Are you using a PHP Site in Dreamweaver?

Make sure to have a php site defined and a valid connect to a mysql database.

Sign in to reply to this post

phil

I'm curious about this too.

I would have thought data-duplication with usernames and passwords would be a hazardous situation?

There must be a better alternative. The only thing really would be to have your custom registration process add people to the PHPBB users table, and share that. the problem I found (and this is going back a bit now) was to do with PHPBB's password encryption, and getting around that. Can you configure PHPBB to not encrypt user password?

Sign in to reply to this post

Jimmy Wu

I'm not sure what you would have to do to remove the password encryption for PHPBB, but it will require some custom changes. It might be a good idea to bring this up with the support at PHPBB.

Inserting the data into two different databases, if they're on the same server, shouldn't cause much additional risk.

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...