Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
3 Registered (driv, 2 invisible), 24 Guests and 15 Spiders online.
Key: Admin, Global Mod, Mod
Top Posters
Gizmo 11706
Rick 7567
Ian 4107
Mark S 3983
ntdoc 3114
Sirdude 2041
jgeoff 1882
David Dreezer 1759
driv 1569
AllenAyres 1530
Latest Photos
Carrie - So Very
Testing
Test Photo
4TH of July at the river!
Test shots from D300 part 3
Topic Options
Rate This Topic
#216278 - 08/07/08 07:02 AM Using the USERS DB for other app login verification
ThomasM Offline
stranger

Registered: 12/24/03
Posts: 10
I want to use the Users table to authenticate my users on other web pages also.
I'm coding in coldfusion, and when i look into the users table, the password is encrypted, how do unencrypt it to compare to what they are entering?

Also, unfortunately i'm not a PHP person, so how is the session validation carried once the user logs in succesfully?
Cookies? Session variables?

Thanks,
Thomas

Top
#216280 - 08/07/08 07:53 AM Re: Using the USERS DB for other app login verification [Re: ThomasM]
Sirdude Moderator Offline


Registered: 04/19/07
Posts: 2041
Loc: SoCal, USA
you can't decrypt to a nice ascii representation.. it's an md5 hash.

so what you'll need to do is take the ascii from what they entered and md5 it, then compare with the DB..
_________________________

A taxpayer voting for Obama is like a chicken voting for Colonel Sanders.

Top
#216282 - 08/07/08 07:54 AM Re: Using the USERS DB for other app login verification [Re: Sirdude]
ThomasM Offline
stranger

Registered: 12/24/03
Posts: 10
Thanks, md5 is what i needed!

Top
#216311 - 08/08/08 01:31 AM Re: Using the USERS DB for other app login verification [Re: ThomasM]
Gizmo Moderator Offline


Registered: 06/04/06
Posts: 11706
Loc: Portland, OR; USA
It's simple to compare using MD5, you'd have a form which would accept the user/pass, and your pass variable would be something like;
$pass = md5($_GET["pass"]);

You'd ofcoarse want to sanitize all user input however
_________________________
UGN Security, Elite Web Gamers & VNC Web Design Owner
Longtime UBB Supporter, UBB7 Beta Tester & Resident Post-A-Holic

Top
#216317 - 08/08/08 05:03 AM Re: Using the USERS DB for other app login verification [Re: Gizmo]
ThomasM Offline
stranger

Registered: 12/24/03
Posts: 10
Actually I’m using coldfusion to authenticate against the ubbt db. It uses HASH but i had to specify the algorithm to use.

Thanks Again.

Top


Shout Box

Recent Topics
[7.3.x] Ignore link showed in userprofile for global moderators
by blaaskaak
Today at 01:27 PM
[7.3.x] Database password shown in adminlogs...
by blaaskaak
Today at 10:24 AM
7.3.1 Flood protection
by MattUK
Today at 03:55 AM
Changing title of forum
by Baby Boomer
Yesterday at 07:38 AM
Disable PM's for one group
by Musky
Yesterday at 07:10 AM
Forum Stats
4026 Members
33 Forums
30883 Topics
156825 Posts

Max Online: 978 @ 06/24/07 08:19 PM