Gossamer Forum: Products: Gossamer Links: Discussions: How do I get the Users Password on the link pages?

Feb 2, 2004, 6:39 PM

BryanL

User (100 posts)

Feb 2, 2004, 6:39 PM

Post #1 of 6

Shortcut

How do I get the Users Password on the link pages?

I've looked all over and I just can't figure out how to show a users password in a link-type page. What I'm trying to do is email a LinkOwner his Username and password. The Username is easy, since it's the same as the LinkOwner, but how do I get the Password out of the Users table?

Thanks!

Bryan

Feb 3, 2004, 12:56 AM

Andy

Veteran / Moderator (18441 posts)

Feb 3, 2004, 12:56 AM

Post #2 of 6

Shortcut

Re: [BryanL] How do I get the Users Password on the link pages? In reply to

Not quite sure why you are trying to do this... but you could use this (if you have <%LinkOwner%> available)...

<%grab_password($LinkOwner)%>

Code:
sub { 

   my $user = $_[0]; 
   my $table = $DB->table('Users'); 
   my $pass = $table->select( ['Password'], { Username => $user } )->fetchrow || return $GT::SQL::error; 
   return $pass; 

}

This is untested, but should work :)

Cheers

Andy (mod)
andy@ultranerds.co.uk

Feb 3, 2004, 5:08 AM

VishalT

Veteran (1127 posts)

Feb 3, 2004, 5:08 AM

Post #3 of 6

Shortcut

Re: [Andy] How do I get the Users Password on the link pages? In reply to

Hi Andy,

Would this global work in email-add.txt too? so when end users receives the email of their listing being validated, they also get the password in the email.

Vishal

Vishal
-------------------------------------------------------

Feb 3, 2004, 6:08 AM

Andy

Veteran / Moderator (18441 posts)

Feb 3, 2004, 6:08 AM

Post #4 of 6

Shortcut

Re: [NeedScripts.Com] How do I get the Users Password on the link pages? In reply to

Should do. Your best bet is to just give it a go :)

Cheers

Andy (mod)
andy@ultranerds.co.uk

Feb 3, 2004, 9:10 AM

FrankM

User (202 posts)

Feb 3, 2004, 9:10 AM

Post #5 of 6

Shortcut

Re: [BryanL] How do I get the Users Password on the link pages? In reply to

I think for a Links page you can display the password by preceding it as follows:

<%Links::Utils::load_user%>
<%Password%>

If you want to include it in the email that is sent to the Link Owner when their link is validated, you don't need to do anything special. You can just use the <%Password%> tag on the email-add.txt template, and it will include the Password from the Users table.

--Frank

Feb 3, 2004, 5:13 PM

BryanL

User (100 posts)

Feb 3, 2004, 5:13 PM

Post #6 of 6

Shortcut

Re: [FrankM] How do I get the Users Password on the link pages? In reply to

Thanks! That did the trick for me.

The reason I'm using this is in conjunction with Andy's Expired_Link script. When someone upgrades a link, the upgrade lasts for a year.

At the end of a year, I want to email them a notice and include their username and password. Many times people have forgotten after a year, email addresses change, etc. This way, they can log right back in.

Cheers,

Bryan