Import scripts vbulletin5.rb

The import script searches for contenttypeid=23 and contenttypeid=22 to create postings.

By skimming through the node table I can say, that the 23 stands for a posting with an attachment and 22 should be the attachment itself.

The majority of the posts are of contenttypeid=21 - postings without attachments. And I don’t see an import for those. Or is this covered by:

post_count = mysql_query("SELECT COUNT(nodeid) cnt FROM #{DBPREFIX}node WHERE parentid NOT IN (
SELECT nodeid FROM #{DBPREFIX}node WHERE contenttypeid=23 ) AND contenttypeid=22;").first["cnt"]

This goes through everything that is left over after the import is done with 23/22. But there are more content type IDs beside 23/22/21 - so this would get those as well.


And categories are imported relative to a ROOT_NODE that was preset to 2. I might have to set it to 3 to support my “3-level nested” URLs?

UPDATE: I just re-ran the import with ROOT_NODE=3 and and it did not change anything