IP.Board DB

4
4na4
silvestris
  • 15 Aug '14

Here's IPB database structure for topics, posts and members.
https://github.com/gmanley/ipboard_db/blob/master/lib/ipboard.rb

Most of the fields can be skipped.

nitely
Esteban C Borsani
  • 15 Aug '14

I'd skip all of them but why is this important again?

4
4na4
silvestris
  • 15 Aug '14

I have more than 50K members. They are too lazy to register new account.

To be serious. Most of traffic comes from Google and Google likes unique content. Every year of building community is important.

A fresh install is an option only for start-ups.

nitely
Esteban C Borsani
  • 15 Aug '14

Oh! yep, this will be useful to create a migration from IPB to Spirit, but we are far from there yet.

4
4na4
silvestris
  • 15 Aug '14

As I said members & posts are important. It drives community to success or epic fail.

Users do not like changes. Any changes. Even upgrading software or forum skin can result in rats abandoning a sinking ship effect. Users hate today's Facebook-like forum software.

Ubuntu (Linux distribution) introduced Discourse as secondary forum software for Chit Chat. But they have huge community, resources and team.

New forums created by small communities are rare nowadays.

4
4na4
silvestris
  • 16 Aug '14

I have found something quite interesting.

punBB to MyghtyBoard importer
http://www.rkblog.rk.edu.pl/w/p/punbb-myghtyboard-importer/

Myghty Board & source code:
https://code.google.com/p/diamanda/source/browse/trunk/diamandas/myghtyboard/
https://code.google.com/p/diamanda/ # .zip archive
https://code.google.com/p/diamanda/source/browse/trunk/diamandas/myghtyboard/models.py # database scheme

Problems solved:
1) encoding - converting IPB to any other forum software and vice versa will always break language specific letters,
2) passwords and passwords salts.