It would be nice to combine the User Add Admin Page and Link Add Admin Page on one page. The way it is set up now, I have go to both Add pages (User and Link) before I can add the new link to the db. If I don't create a user first, then that link and its related information doesn't appear when you go to Email->Selected Links and do a search.

I'm just looking to save time when adding new links.

Any feedback on this matter would be great!

Thanks.

Mark G.
OhioBiz

Good suggestion...yet in terms of coding, the validation coding would have to be re-written as a plugin to preserve code in future releases.

The problem is that the validation screen would be cluttered with data to validate in two different tables within your LINKS SQL database. I, personally, prefer modularized applications where you can intuitively view data in separate tables.

Of course, one way around this would be to "auto-validate" user accounts. Then they can create and validate their own accounts and can only add links after their account is validated.

Regards,

Eliot Lee

Hi,

Sorry, I don't understand? If you are adding the link, why not do it directly from the admin?

Cheers,

Alex

--
Gossamer Threads Inc.

Alex,

I am adding all new links from the admin area. In my situation, I really have no need for the "linkowner" function since I don't allow other users to add, modify, or delete their links - everything goes through me.

The older version of LinksSQL (1.13) worked well because I could add everything on one admin page for a given new link. In addition, the main inconvenience now seems to be when I attempt to send an emailing out. The contact email address of a particular link seems to be tied to the linkowner (user) of that link versus the email contact. Also, the linkowner (user) has to be defined prior to the link being added to the database.

It just seems that I have to go through more steps to add a new link and to make sure the link can be "emailed" properly
than before.

Thanks.

Mark G.
OhioBiz

Hi,

You may want to download 2.0.4. It has a contact name/email separated from the linkowner information so all links are owned by admin, but you can still mass mail the links using the contact email info.

Cheers,

Alex

--
Gossamer Threads Inc.

Hello,
what you can do in Links-SQL 2.04. is the folowwing:
create an registered user in your database (no editor/admin).
set the name as default in your LinkOwner table.
now you can add links with contact name/email without adding a linkowner.
the contact_name & email refers to the email you entered and not the linkowner.
I'am sure it works!

Thanks a lot.

Mark G.
OhioBiz

Alex,

Thanks a lot. I did.

Mark G.
OhioBiz

This works great now. My only dilemma now is to go back through 5,000+ links to change all the linkowners to my one user that I'm now using and cut and paste all previous email addresses from the linkowner field to the new Contact email field.

Mark G.
OhioBiz

you could do this with simple SQL calls using mysqladmin

ASciFi.com http://www.ASciFi.com/
Help Desk http://www.Techuk.com/HelpDesk/

I really don't know SQL that well. What call would you suggest?

Thanks.

Mark G.
OhioBiz

Hi,

Sorry I've not been following this thread but this is the basic command you want to change all Link Owners to the new username:

UPDATE Links SET LinkOwner='New Owner';

That will change ALL LinkOwners to "New Owner".




Installations:http://www.wiredon.net/gt/
Favicon:http://www.wiredon.net/favicon/

Thanks Paul!

sorry been away, Paul beat me to it. I should have posted that when i made the suggestion :)

ASciFi.com http://www.ASciFi.com/
Help Desk http://www.Techuk.com/HelpDesk/

Paul,

What commands do I use to perform this:

Move all current data in a record's LinkOwner field to the Contact Email Field. After I do that, I want to make all of the Linkowners "me". Is there a way to perform these steps for all 5,500 records at once versus doing it individually?

I upgraded to Links SQL 2.0.4 and want to move any email addresses that were being used as the LinkOwner data and move it to the new Contact Email field. What I will then do is make me, "mark" the linkowner for all links in the db.

Thanks for your help/advice in advance!!

Mark G.
OhioBiz

Hmmm

UPDATE Links SET 'Contact Email'=LinkOwner;
UPDATE Links SET LinkOwner='Me';

I _THINK_ that should work.

Installations:http://www.wiredon.net/gt/
Favicon:http://www.wiredon.net/favicon/

Paul,

I tried that first command you posted but it didn't seem to copy or move any data over from the LinkOwner to the Contact_Email field - after looking at the table via MySQLMan.


Mark

You fooled me by saying Contact Email, and in that post you just said Contact_Email

UPDATE Links SET Contact_Email=LinkOwner;

Try that!

Installations:http://www.wiredon.net/gt/
Favicon:http://www.wiredon.net/favicon/

I get this Error Message:

Error: Query Error: Failed to execute query: 'UPDATE Links SET Contact_Email=LinkOwner' Reason: Unknown column 'LinkOwner' in 'field list'

Make sure the column names in the query are identical to the actual ones.

Installations:http://www.wiredon.net/gt/
Favicon:http://www.wiredon.net/favicon/