Migrate Guestbook to use Jot

Hi,
just upgraded to 0.9.5 and wnt to migrate a guestbook to use jot.
Currently I use UserComments but you know, thats got spammed ;-(
Ok, I found the captcha-hack for UserComments, but I would like to use jot, it’s much more better ;-)

It might be possible to preserve the current entries and feed them into the db-structe of jot?
There are just a few ones, so I am sure I can manage them.

Can one tell me/confirm (table jot_content):
uparent is the id of the doc, where the comments are attached.
sechash is a hashed value of ??
createdon is the post time as Unix-Timestamp
publishedby 0 or the id of af a webuser?
publishedon
mode is definded as and is used for subscriptions??

sechash and secip could be empty?

Thanks a lot
Friedhelm

- uparent and mode are there for future implementations you don’t need them.
- uparent will be used for threading (in the future)
- mode is always 1 (for current versions of Jot)
- docid is the column you need for the source (where the comments are attached to)
- sechash and secip can be empty (check code for how they are used)
- publishedby and publishedon are used when comments are moderated.
- publishedon is the the Unix-timestamp of the update that caused the published field to change
- publishedby holds the id of the moderator who made the action.

for all userid fields, these are the rules:
- userid is a positive number if it involves a manager user
- userid is a negative number if it involves a web user

I hope this helps

Thanks, that helps definitley.
As soon as I will find the time, I will try the migration and maybe have to ask some more questions ;-)

Thanks again,
Friedhelm

p.s: At the moment I use the captcha hack for UserComments.