Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
2 registered (Island Piper, 1 invisible), 20 Guests and 24 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 06/05/06
Posts: 24
Top Posters (30 Days)
Rick 126
Gizmo 101
Thelockman 53
AllenAyres 48
driv 47
ScriptKeeper 37
blaaskaak 35
Morgan 33
flyboy105 27
ntdoc 22
Latest Photos
Christmas in Gizzyville
Blonde Batman...
Sunset Between Boarders
My two favorite words..
XTERRA K9 Challenge
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: 2052
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: 11829
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

Today's Birthdays
ax, bigatom
Recent Topics
Image Verification issues
by intouchweb
Today at 05:54 PM
How do I search for Numeric strings in posts
by Ruben Rocha
Today at 02:35 PM
wrong count of members in a group
by Zarzal
Today at 02:34 PM
Last Post Column
by zoomeister
Today at 12:27 AM
Account Suspended... any clues?
by jgeoff
Yesterday at 07:02 PM
Forum Stats
4156 Members
33 Forums
30238 Topics
153144 Posts

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