I am new at SQL so all help is appriciated.

History:
I imported the users from my site into another installation of xoops. Both 2.0.9.2. Everything went smooth.

Problem:
None of my users has a group. None of them are either regitered or webmasters. I can't add them from System -> Groups because there is no "Not in the group" list at the bottom.



Question:
Can someone please help me do an SQL query that will create a new entry for 278 rows (up to my last user) in the table xoops_users_link* and input the following data into the following fields:



*that is the table that I need, right?

Never mind, I did it myself.


Close please.

Glad to see you got it sorted out so quickly. I had the very same trouble in that after importing users none of them were members of any groups, and as there is no "Not in the group" function I couldn't see or do anything to correct this from the XOOPS group managemen admin. What made it worse for me was that I was merging to XOOPS sites, not just migrating. I had to get a script written that merged the two XOOPS sites as well as another one that ensured membership to at least the Registered Members group. Lucky I didn't have a complex group structure. I think some work is planned for the group admin functionality in XOOPS 2.1