Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Link Owner Question

Quote Reply
Link Owner Question
What does the Linkowner in the database corresponds to?

In the supplied templates, two field for adding links are Name and Email but these don’t appear in the default column names.

So the question is whether this Linkowner is for Email/Name or something else, and if not, I presume a Name & Email must be added in as columns.


Quote Reply
Re: Link Owner Question In reply to
Well, since <%LinkOwner%> by default displays an email address, I'd guess it was the email field...

--Bri

Quote Reply
Re: Link Owner Question In reply to
LinkOwner is the "Username" of the logged in user who uploaded the link.

PUGDOG® Enterprises, Inc.
FAQ:http://LinkSQL.com/FAQ
Forum:http://LinkSQL.com/forum
Quote Reply
Re: Link Owner Question In reply to
Hmm... One says Email the other says UserName???

Ok this is my problem...

using the default add template with the form fields Contact_Name, Contact_Email puts the submitter info into the user section of the database.

Then deleting the submitters links keeps the User info in the database. So say I had 10,000 links 1000 are invalid so I delete 1000 links, but the 1000 user details are still in the database!

How do you let submitters add a link without it becoming a User?

Removing the default forms Contact_Name, Contact_Email give this error: LinkOwner breaks foreign key relation with the Users table.


Quote Reply
Re: Link Owner Question In reply to
In Reply To:
How do you let submitters add a link without it becoming a User?
Good question - I also don't want to force submitters to register as users before they can submit a link. They should have to submit the name and email info, so that I get this info in the LinkOwner field when validating the links and that the submitters will be emailed.

The reason is that I want to have the possibility to submit links and enter the name and email of the webmaster of the submitted page so that he gets an email saying something like "your page was added to our site - what about placing a link to our site on your page?".
This way you can notify others that your page exists and have them place a link to your site. This was a very useful feature for site promotion in LinksSQL 1.13 and I would really like to be able to do that with LinksSQL 2, too.

Any ideas?
would be great!

Andreas

--------------------------------------------
http://www.archaeologie-online.de
Quote Reply
Re: Link Owner Question In reply to
This is somewhat convoluted.

The reason for logging in is to attach a link to a user. By not logging in, you bypass a lot of the checks that are in place.

What I've done is allowed for a Contact_Email and Contact_Name in the link record, if different from the user. It's auto-filled by the User record, but can be overridden if the uploader wants to.

A lot of times webmasters do not maintain their links, or want to. A 3rd party who likes the site does it. If a webmaster then requests the ability to maintain their link, it's easy enough to change the link owner after the webmaster registers.

The days of "anonymous" are really over. With dynamic HTML and more advanced features, you really need to have a user name of some sort to make things work properly.

PUGDOG® Enterprises, Inc.
FAQ:http://LinkSQL.com/FAQ
Forum:http://LinkSQL.com/forum