4images Forum & Community

4images Issues / Ausgaben => Discussion & Troubleshooting => Topic started by: hyde101 on March 18, 2005, 04:06:03 PM

Title: Copy Users to any other db
Post by: hyde101 on March 18, 2005, 04:06:03 PM
Hi,

I couldn't find this topic which was already going on for some time...

Since 4images holds users in db w/each having their own attributes, can we just copy their e-mail address & username, later import these to another table, with the e-mail & nicks, and finally run a small script to send them an e-mail which we previously created randomly to the same table?.

I guess v@no is the man to do it, but since I am not too good with this, I don't want to mess up anything. ;)  :oops:

maybe
select username from username_table
select email from username_table

boy, now I know I should have studied more when I took sql in college.. you never know when they can be handy..  :|
Title: Re: Copy Users to any other db
Post by: Chris on March 18, 2005, 04:11:59 PM
Why not just use www.phpmyadmin.net  :?:
Title: Re: Copy Users to any other db
Post by: hyde101 on March 18, 2005, 04:20:37 PM
yeah, it is already set up..

But my question is, the password part.

 user_name        user_password        user_email

could probably be extracted from the table very easily.

and this other forum or s/w has the same columns.

user_name     user_password           user_email

of course the password will not match, they both use thier own algoritm for the pw to encrypt it.

The most difficult part is to assign them all random passwords & insert these random passwords to db and send them an e-mail.

* sorry, this may have to be moved to chit-chat