Import - Match data fields from old forum

[charlietfl]

Am attempting to manually import in mySQL from an old forum script.

Not sure how to handle a few fields:

Table: xf_user_authenticate
Field : data

Is there a simple helper function somehere to help convert from unencoded text password to data format that is compatible with login authentication?
Read somewhere here that can use an md5 + salt but not sure how to enable in any config so login will work. Also how to generate remember field?

Table: xf_node
How to assign 'lft" and "rgt" values ?

 

[Jake Bunce]

If the source passwords are plain text then you can convert them to XenForo's own hashing scheme. See this post:

http://xenforo.com/community/threads/quick-questions.14758/#post-193255

The records are stored in the xf_user_authenticate table.

edit - see this file:

library/XenForo/Authentication/Core.php

 

[charlietfl]

Thanks Jake,

Although I don't understand the "lft" and "rft" fields for nodes in xf_node table, I managed to get my full import up and running from an ancient coldfusion script in MSQL

 

[Paul B]

The lft and rgt are to do with nested sets.

http://en.wikipedia.org/wiki/Nested_set_model