Author Topic: Copy Users to any other db  (Read 3409 times)

0 Members and 1 Guest are viewing this topic.

Offline hyde101

  • Sr. Member
  • ****
  • Posts: 410
  • 34TR.COM (Running 4images)
    • View Profile
    • Nostalgia Istanbul
Copy Users to any other db
« 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..  :|

Please Vote for my site: Here

Offline Chris

  • 4images Moderator
  • 4images Guru
  • *****
  • Posts: 4.487
  • Did u ever stop to think and then forget to start?
    • View Profile
Re: Copy Users to any other db
« Reply #1 on: March 18, 2005, 04:11:59 PM »
Why not just use www.phpmyadmin.net  :?:

Offline hyde101

  • Sr. Member
  • ****
  • Posts: 410
  • 34TR.COM (Running 4images)
    • View Profile
    • Nostalgia Istanbul
Re: Copy Users to any other db
« Reply #2 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

Please Vote for my site: Here