XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Installation Troubleshooting 
  4.  / Automatically users registrations
Register
1
titanus
Automatically users registrations

  • 2005/6/17 7:22

  • titanus

  • Just popping in

  • Posts: 6

  • Since: 2005/6/16


i need to register some (about 3000) users each one in his group and i already have the name, surname, password, and all the data needed.
Its is possible (i know it is but i don't know how) to make a MySQL query that can do this for me?
I can do a text file with all the data needed and in which ever format.

thanks
2
bluenova
Re: Automatically users registrations

It's very easy to add the data from a text file, phpmyadmin has an option to do that, but I don't know how you'll get round the password issue, because the password is encrypted in the database.
3
titanus
Re: Automatically users registrations

  • 2005/6/17 9:47

  • titanus

  • Just popping in

  • Posts: 6

  • Since: 2005/6/16


Thank you,
I know how (OLD_PASSWORD('password') because i have MySQL 4.1.12a) but i don't know how many tables i have to INSERT my data and which.
Can you help me?
4
bluenova
Re: Automatically users registrations

You need to add the user data to 'users' and then there group has to be added to 'groups_users_links' using the 'UID' of the user and the 'GroupID'

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

355 user(s) are online (306 user(s) are browsing Support Forums)

Members: 0

Guests: 355

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits