I have some pretty big changes to make that would take like a month if I did it all manually… I’m writing a script to do it for me. I use a mySQL database and I figured if I just inserted into the databases it would work out.
So this is what I do. I add a user to a buddylist, and then I assign it a group to be in. That’s it.
I do like this,
insert into ofRoster (rosterID, username, jid, sub, ask, recv, nick) values (1603, ‘Amy’, ‘email@example.com’, 3, -1, 2, ‘Melissa’);
I take the last record in ofRoster and increment it by one for the rosterID there.
So, after doing that, I have to assign it a group. So I do like this:
insert into ofRosterGroups (rosterID, rank, groupName) values (1603, 0, ‘Sales’);
So now I’ve assigned melissa in Amy’s roster as being in the group ‘Sales’.
I figure this would be all I need, I looked in the other tables and I think this is it.
But when I go into the openfire admin console the changes aren’t there. So I restart openfire, still the changes aren’t there. I try to add one of them- it tells me the JID is already taken (From my script)
So what am I not updating??? What else do I need to do?