# Importa script vbulletin5.rb

**URL:** <https://meta.discourse.org/t/import-scripts-vbulletin5-rb/132531>\
**Category:** Self-hosting\
**Created:** [4 Novembre 2019, 1:17pm UTC](https://meta.discourse.org/t/import-scripts-vbulletin5-rb/132531 "2019-11-04T13:17:03Z")\
**Posts on this page:** 1\
**Showing post:** 9

<div class="post-metadata">

**Author:** ![INSTAR](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/instar/32/359540_2.png) [@INSTAR](https://meta.discourse.org/u/INSTAR)\
**Post date:** [5 Novembre 2019, 10:49am UTC](https://meta.discourse.org/t/import-scripts-vbulletin5-rb/132531/9 "2019-11-05T10:49:50Z")

</div>

Ok. È il `contenttypeid` a causare il problema:

```ruby
def import_categories
    puts "", "importazione delle categorie di primo livello..."

    categories = mysql_query("SELECT nodeid AS forumid, title, description, displayorder, parentid
	      FROM #{DBPREFIX}node
          WHERE parentid=#{ROOT_NODE}
        UNION
          SELECT nodeid, title, description, displayorder, parentid
          FROM #{DBPREFIX}node
          WHERE contenttypeid = 20
            AND parentid IN (SELECT nodeid FROM #{DBPREFIX}node WHERE parentid=#{ROOT_NODE})").to_a

```

Ad esempio, la funzione `import_categories` utilizza `contenttypeid = 23`, che è lo stesso ID usato dallo script per i post. L’ID per le categorie è `20`. Modificando questo valore nello script, sono finalmente riuscito a vedere le mie sottocategorie / argomenti 🙌

 ![Untitled](https://global.discourse-cdn.com/meta/original/3X/1/c/1c8334e3bd53855eca84f6e59d44c9f0556130aa.png)

Ora manca solo il recupero dei thread / post

---

_[View the full topic](https://meta.discourse.org/t/import-scripts-vbulletin5-rb/132531)._