Hi folks,
i wanna upgrade another board system to vB4. At the moment the system for this comunity is at Woltlab Burning Board 2.3.6.
It is a community about 6000 member and there was an old gallery system too. So here we are at my big problem, i dont wanna loose this content. We are talking about 1500 Images, not that much, but too much, to make this import manually.
I think it must be quiet easy, to import the data, but im not expierienced enough to do a script by myself.
Of course i'm willing to pay a little amount for a import script, but i would be thankful for some hints, to do it by my own, too.
First of all i will begin with the data structure:
Galerie V3.5.0:
/html/wbb2/galerie_data/
/html/wbb2/galerie_data/pics/
/html/wbb2/galerie_data/thumbs/
/html/wbb2/galerie_data/mini/
Filenames:
- Thumbs: t_imageid(?)_title_uperid_xxxx.jpg
- Pics: imageid(?)_title_uperid_xxxx.jpg
In some cases it is userid, not uperid.
Copying this files manually is nor problem.
Database Structure:
tables:
bb1_gal_cats (think thats not important, that can be done manually)
bb1_gal_groups (think thats not important, that can be done manually)
bb1_gal_highlights (can be ignored, no similar function at the
vB gallery)
bb1_gal_mailed (not important)
bb1_gal_main:
Here we are, main information for the pics, list of fields and description:
gal_id: gallery picture id
gal_date: upload date (format like: 1080061092)
gal_catid: caterogy id
gal_picname: pic title
gal_picdesc: pic description
gal_hits: picture visits
gal_closed: private or public (1 = pic is public, 0 = pic is private)
gal_link: dont know, but always empty
gal_link_on: dont knwo, but always 0
gal_down: filename
gal_userid: gallery user id, similar to userid
gal_username: gallery username, similar to forum username
gal_size: dont know
gal_imp: dont know, always 0
gal_lastv: maybe last visit, format: 1290510403
gal_bew: pic rating format: xx,x (xx = summation of all ratings, x = number of ratings)
gal_bew_id: userids who rated the picture, always starts with a 0. format: 0,userid1,userid2,userid3...
gal_comment: comments for the pics (one text field for alle comments), format:
Code:
Content visible to verified customers only.
gal_comcount: total number of comments
gal_bewert: rating value, seems to be first value of gal_bew/secondvalue (total rating summation/number of ratings)
gal_bewtime: dont know, maybe rating time.. format: 1180374065
Notice for the rating system: It is a 10 Point System, User can select 1 to 10 from a dropdown menu and rate the picture.
Some things that i would like to see:
- pic posting date, should be the original one, not the on from the import
- private pictures can be ignored (gal_closed = 0)
- would be really nice, to import the rating from the 10 point system, to the 5 star vbgallery system.
- there must be a solution for a new cat id, is new cat ids are not equal to the old ones (but i think cat ids would be similar)
- i dont know, if it is possible to get the same userids after a import of a wbb2.3.6 system to a vB4. My last import (phpBB) result in new userid = olduserid + 1, because of the Adminstaror user of the
vB. Hope there is a way to handle this problem.
Nice to have:
Actually there is just one textfield for comments, would be really great to seperate the comments, extract date and time, and to add comments one by another belonging to the correct user. If this is not possible, There should be 1 Comment, containing the old comments. This comment should be assigned to a special user id.
thank you.