Probaly a stupid question

[Saintless]

Okay this made sound stupid but its the only option :)

I need to be able to do to things to the database.

1) I need to generate random passwords for roughly 30,000 members and have the username and password (in plain text) exploreted to a plain text document. (just going to pm the new passwords to each user on the old boards)


2) How am i able to insert RP's into the database by username
we had a similar system on yabb which was a custom built script. But we explorted all the data to a txt file so right now it is sitting like this (e.g. saintless,5)

Is there any way i would be able to import this on a larger scale then one a time :)

Thanks for any help :)

[Marco van Herwaarden]

1) I would strongly advice against that. Sending out plain text passwords is very insecure.

2) Have a look at these 2 links: http://dev.mysql.com/doc/refman/5.0/en/load-data.html & http://dev.mysql.com/doc/refman/5.0/en/mysqlimport.html

[Saintless]

we are aware that it is very insecure. But many years ago we advised user's not to use real email adress's (varity of reasons)

This is the only thing that we have been able to come up with. any other suggestions? since retrive password is out of the question.


Also assuming i use load data what strings would i throw in for the RP section of the Vbulletin database?

Thanks for your reply.