| Author |
 Topic Search  Topic Options
|
donaldhill 
Newbie
Joined: 04 December 2003
Status: Offline
Points: 5
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Importing member user name passwords
Posted: 08 December 2003 at 12:24am |
I have read afew posts about this but cant seem to understand what to do.
Does anyone have asimple way to get user name and passworddetails and bring them in say from excell table, csv file, or access database table??
|
 |
india
Senior Member
Joined: 21 November 2003
Status: Offline
Points: 499
|
Post Options
Thanks(0)
Quote Reply
Posted: 08 December 2003 at 12:29am |
Password are 160bit encrypted and you cannot see them. However, you can change the users password if you are a mod or admin
Usernames, you can go to the database, go to TBLAUTHOR and copy all of them.
hope this helps.....
|
|
donaldhill
Newbie
Joined: 04 December 2003
Status: Offline
Points: 5
|
Post Options
Thanks(0)
Quote Reply
Posted: 08 December 2003 at 12:50am |
No I dont thin kthat is what I meant.
I havea list of 2000 people with a user name and an existing passowrd. These are not in the web wiz forum database. They are in another database.
I want to import an excell list or csv file or access database table of these data and want to put them into the web wiz table but what do I have to do to make the password encrypted?
|
|
wistex
Mod Builder Group
Joined: 30 August 2003
Location: United States
Status: Offline
Points: 877
|
Post Options
Thanks(0)
Quote Reply
Posted: 08 December 2003 at 1:14am |
You could import the information into the tblAuthors table into the appropriate columns. But... and a big but... you have to turn off the encrypted password feature that is turned on by default.
There is a variable that you turn off somewhere, but if forgot where.
If you do a search, you should find it. This has come up many times already.
|
|
|
|
donaldhill
Newbie
Joined: 04 December 2003
Status: Offline
Points: 5
|
Post Options
Thanks(0)
Quote Reply
Posted: 08 December 2003 at 1:43am |
thanks guys,
but does that turning off the encryption process mean the passwords are never encrypted?
What can be done to encrypt them?
|
|
india
Senior Member
Joined: 21 November 2003
Status: Offline
Points: 499
|
Post Options
Thanks(0)
Quote Reply
Posted: 08 December 2003 at 1:45am |
 donaldhill wrote:
No I dont thin kthat is what I meant.
I havea list of 2000 people with a user name and an existing passowrd. These are not in the web wiz forum database. They are in another database.
I want to import an excell list or csv file or access database table of these data and want to put them into the web wiz table but what do I have to do to make the password encrypted?
|
Well, then i dont think password will come. Is it phpbb forum? tell me forum name, there are converters to do this job,
|
|
psycotik
Groupie
Joined: 27 November 2003
Status: Offline
Points: 73
|
Post Options
Thanks(0)
Quote Reply
Posted: 08 December 2003 at 1:48am |
|
Which version is it that encryption started? If you find the code for the upgrade wizard you will find a way to convert passwords to hashes.
|
|
india
Senior Member
Joined: 21 November 2003
Status: Offline
Points: 499
|
Post Options
Thanks(0)
Quote Reply
Posted: 08 December 2003 at 1:49am |
donaldhill wrote:
thanks guys,
but does that turning off the encryption process mean the passwords are never encrypted?
*** How will you turn off encryption?
Moreover, its a security risk.
Forum v7.0 and above have pass encrypted but if you write in plain text it WILL NOT WORK.
What can be done to encrypt them?
*** my R&D says there is a way out. Like suppose you are installing a new forum. You register and put user xyz pass abc. Go to database. Notice the encryptedd form of the pass abc. then copy in all of them. so all users will get a pass of abc by default
|
My replies in " *** "
|
|
