Encrypted?
Moderator: General Moderators
Encrypted?
When a password gets entered into a database it gets encrypted but is there a way of converting it back to normal in its non-encrypted form?
All i've got in the USER INFO table is this:
Code: Select all
CREATE TABLE `bb".$n."_user_table` (
`userid` int(11) NOT NULL auto_increment,
`username` varchar(30) NOT NULL default '',
`userpassword` varchar(50) NOT NULL default '',
`useremail` varchar(150) NOT NULL default '',
`regemail` varchar(150) NOT NULL default '',
`userposts` int(11) NOT NULL default '0',
`groupid` int(7) NOT NULL default '0',
`statusextra` varchar(25) default NULL,
`regdate` int(11) NOT NULL default '0',
`lastvisit` int(11) NOT NULL default '0',
`lastactivity` int(11) NOT NULL default '0',
`session_link` int(1) NOT NULL default '1',
`signatur` text NOT NULL,
`usericq` varchar(30) NOT NULL default '',
`aim` varchar(30) NOT NULL default '',
`yim` varchar(30) NOT NULL default '',
`userhp` varchar(200) NOT NULL default '',
`age_m` varchar(10) NOT NULL default '',
`age_d` int(2) NOT NULL default '0',
`age_y` int(4) NOT NULL default '0',
`avatarid` int(11) NOT NULL default '0',
`interests` varchar(250) NOT NULL default '',
`location` varchar(250) NOT NULL default '',
`work` varchar(250) NOT NULL default '',
`gender` int(1) NOT NULL default '0',
`usertext` text NOT NULL,
`show_email_global` int(1) NOT NULL default '0',
`mods_may_email` int(1) NOT NULL default '1',
`users_may_email` int(1) NOT NULL default '1',
`invisible` int(1) NOT NULL default '0',
`hide_signature` int(1) NOT NULL default '0',
`hide_userpic` int(1) NOT NULL default '0',
`prunedays` int(4) NOT NULL default '0',
`umaxposts` int(2) NOT NULL default '0',
`bbcode` int(1) NOT NULL default '1',
`style_set` int(11) NOT NULL default '0',
`activation` int(10) NOT NULL default '0',
`blocked` int(1) NOT NULL default '0',
`warnings` int(2) NOT NULL default '0',
`blockedbywarn` int(1) NOT NULL default '0',
`instantm` int(1) NOT NULL default '1',
PRIMARY KEY (`userid`)- twigletmac
- Her Royal Site Adminness
- Posts: 5371
- Joined: Tue Apr 23, 2002 2:21 am
- Location: Essex, UK
It's likely (in a MySQL database) that the password was encrypted using MySQL's PASSWORD() function. This is a one way encrytion, you can't get the original string back, but because the same string is always encrypted in the same way you can compare another encrypted string to see if they're the same.
Mac
Mac
- RandomEngy
- Forum Contributor
- Posts: 173
- Joined: Wed Jun 26, 2002 3:24 pm
- Contact: