cotonti.com : how to import users only

Lombi

Pzt, 16 Mar 2009 19:50:11 -0000

Interesting. Last time we did exactly that hundreds of people had permission issues for certain stuff until we rebuilt the auth completely.

Glad to see your users not having those kinds of problems.

GHengeveld

Pzt, 16 Mar 2009 17:38:37 -0000

Is sed_auth really necessary to be converted? Can't you just set the users rights afterwards?
I've recently copied all users from a different (custom) CMS to Cotonti and it worked fine. I did this by writing a small script that did something like this:

$sql = 'SELECT * FROM users'; // On old database
$query = mysql_query($sql);
while ($row = mysql_fetch_array($query)) {
$newsql = "INSERT INTO sed_users (user_id, user_name, user_password etc) 
VALUES ('".$row['user_id']."', '".$row['user_name']."', '".$row['user_password']."' etc)";
$newquery = mysql_query($newsql); // On new database
}

Kingsley

Pzt, 16 Mar 2009 17:19:46 -0000

:(

to bad.. would have made live easier..

Lombi

Pzt, 16 Mar 2009 17:11:57 -0000

It's not that simple really. Users arent just stored in that table, but also in sed_auth (which controls all the permissions on the site).

And you cant just copy that database over since it contains other permissions as well.

Kingsley

Pzt, 16 Mar 2009 17:02:40 -0000

Hi,

I was waiting for the tut on how to convert sed to cotonti. However, I decided that a fresh install would be better. this way I can clean up a bit.

I only want to import the users from sed. I compared the sql's users to one and eachother, and there are some differences.
I want to know how I can import the users? How do I convert them to utf-8? and what must I change in the users sql table so that it will actually work.

Thx in advance for the help.