Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
8 registered (bakerzdosen, Iann128, luket, MacW, Pink Jazz, Ruben Rocha, Sirdude, 1 invisible), 24 Guests and 19 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 06/23/06
Posts: 2
Top Posters (30 Days)
Ruben Rocha 159
Rick 117
Gizmo 110
Thelockman 62
driv 56
AllenAyres 35
ScriptKeeper 34
Ian 31
Mark S 30
blaaskaak 29
Latest Photos
My Home System
test photo gallery
Bernese Mountain Dogs
My Daimler
Dorado and shark
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 Online   happy

*****

Registered: 04/19/07
Posts: 2065
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..
_________________________


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: 11967
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
Neptin
Recent Topics
How do I set Moderation Queue for an individual user?
by luket
11/20/08 11:28 AM
Custom Island per Forum?
by unixpaul
11/20/08 10:18 AM
SQL Corruption?
by Jason Carey
11/20/08 05:52 AM
adding views column to portal page
by nick1
11/20/08 05:12 AM
Upload broken in 7.4.1
by MacW
11/20/08 03:23 AM
Forum Stats
4247 Members
33 Forums
30483 Topics
154626 Posts

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