Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Community and Links SQL

Quote Reply
Community and Links SQL
Hello,

I test Community script with Links SQL.

I have a problem.

If I record a user of Community towards Links SQL, Community records the data in the Users table of links SQL.

That functions very well for fields Username and Email.

But, it does not record Password of the user.

It is a bug ?

Thank you for your answer.

Mick
Quote Reply
Re: [mick31] Community and Links SQL In reply to
I think this is because Community uses encrypted passwords and Links uses cleartext passwords. I don't think it is a bug.
Quote Reply
Re: [afinlr] Community and Links SQL In reply to
Hello Afnir,

Thank you for your answer.

I seek to know if it is correct to use Community.

It seems that it is not a good strategy.

Community obliges to use the prefix prof_ to create a new column in the table.

For example, the columns ReceiveMail and Newsletter do not have the prefix in the table de Links SQL.

I do not understand how to register a user in Newsletter and ReceiveMail with Community in LinksSQL.

It is one of the reasons which poses a problem to me to use Community.

ReceiveMail and Newsletter are essential tools for Links SQL...

You found a solution in order to solve this problem ?

The use of Community obliges us to create different tools (Newsletter and ReceiveMail).

Your opinion?

Mick
Quote Reply
Re: [mick31] Community and Links SQL In reply to
Hi Mick,

You need to add the fields to the Users table in Community and then create a link between the two tables. See this thread for details:
http://www.gossamer-threads.com/...i?post=259632#259632
Quote Reply
Re: [afinlr] Community and Links SQL In reply to
Thank you Afnir,

I still need your opinion.

I created additional columns in my table Users of Links SQL.

With your opinion, I must mark my columns by prof _?

For example in Links SQL:

I currently have a column country.
I must use prof_country.

This would give more facility to work with both software ?

Mick
Quote Reply
Re: [mick31] Community and Links SQL In reply to
No - unfortunately it isn't quite that simple. It doesn't matter what you call the fields in Links - Community will only look in the Community tables.

You need to login to Community as the administrator, and choose Database. Then choose Customise Profile to add new fields to your user database.

Once you've added a field you can link it to the field in the Links database using the thread in my post above.
Quote Reply
Re: [afinlr] Community and Links SQL In reply to
Thank you,

I already created my columns in the table of Community.

Also, it is better to have identical names of columns for both software?

In Links SQL
Column: prof_country

In Community
Column: prof_country

Or, it is possible to have different names of columns for the two software?

In Links SQL
Column: country

In Community
Column: prof_country

I do not want to use Community now. But, I would like to prepare me for a future use.
Also, I would like to limit the problems the day when I would use Community...

Your opinion ?

Thank you.

Mick
Quote Reply
Re: [mick31] Community and Links SQL In reply to
They don't need to have the same name - whether it is better that they do or not, I'm not sure. I suppose it depends how you are going to use them. It is probably better to only have the fields in the Community tables and not in the Links tables at all.