autoclose autoprune

[AScherff]

Autoclose

in table "node" are the fields "open" and "showopen". If these are "0" thread may closed.

The field "routeid" shows to channel (routenew, there in "arguments" is some channel)

Unfortunately in the table "node" there are more then one records for one thread. One difference is "contentypeid". Is there anywhere a documentation for "contentypeid"?

20 seems the text and shows to table "text".
23 seems to bee picture
22 Text (difference to 20?)
24 answer ?

Now to close a threat, only set all "open" to 0 or only some (contenttypeid) ?

Autoprune

Which records i must delete to prune a threat?

The records in "node".
Records in "text" withe the correspondenting "nodeid" to node
Other records, files ? (Attachments, Bilder).

Did someone investigated these things ?

thanks
Alfred

[kh99]

Originally Posted by AScherff

Is there anywhere a documentation for "contentypeid"?

Look at the db table contenttype.

[AScherff]

Originally Posted by kh99

Look at the db table contenttype.

yeah

[kh99]

Oh, sorry, I didn't notice that this was a vb5 question, so I don't even know if there is a contenttype table.

[AScherff]

Originally Posted by kh99

Oh, sorry, I didn't notice that this was a vb5 question, so I don't even know if there is a contenttype table.

Well, the table can be from VB3, because it seems that tables are not been truncated or deleted during update to VB5 ...