| Author |
 Topic  |
|
|
jrountree
Starting Member
20 Posts |
 Posted - 15 May 2003 : 15:43:28
|
I want to convert a phpBB2 to Snitz...
please someone help, i'm begging! |
Edited by - ruirib on 04 July 2003 14:09:43 |
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
Steve D.
Average Member
USA
640 Posts |
|
|
surfsteve
New Member
90 Posts |
Posted - 21 May 2003 : 12:08:38
|
I would love to be able to convert my PHPBB forum over to Snitz. Who in their right mind would want to go the other way? Please email me if anyone reads this thread in the future and comes across an easy way to do this.
If there were some way to get all the member names and passwords from PHPBB and automaticaly register everyone to the new snitz forum that would be just about as good and probably a hell of a lot easier. |
Edited by - surfsteve on 21 May 2003 12:21:07 |
 |
|
|
jrountree
Starting Member
20 Posts |
Posted - 29 May 2003 : 12:24:43
|
| yes, I hope we can find something - I got a guy wanting to do it! |
|
|
|
snaayk
Senior Member
USA
1061 Posts |
Posted - 29 May 2003 : 15:05:16
|
| does phpbb use a database backend or a flat file? |
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2085 Posts |
Posted - 29 May 2003 : 17:02:47
|
The ones I have played with have been DB back-end.quote:
Originally posted by snaayk
does phpbb use a database backend or a flat file?
It depends on the DB you are asking about as well. I have had it running under both MySQL and Access 2000. |
Cheers,
David Greening |
|
|
|
snaayk
Senior Member
USA
1061 Posts |
Posted - 29 May 2003 : 23:15:12
|
In that case, if the data is similat to Snitz's it should not be too diffulcult. Then again, it depends on their schema.
Not that I'm volunteering, just noting :)] |
|
|
|
subliminalmuzik
Starting Member
9 Posts |
Posted - 04 July 2003 : 08:40:53
|
im in desperate need of help..
i have a snitz forum on online but on my old server which wirks but i had to mave servers due to bandwidth problems...
now i'm stuck with a blasted php bb forum noone likes and my server hasn't got asp installed on it...
if anyone comes accross a way of my forum displaying without active server pages it would be most appriciated as my whole site is lost with the whack forum we got at the mo
www.subliminalmuzik.com but www.subliminalmuzik.com/forum/default.asp won't have it.. no asp bollox
Dizzy@dnbstreet.co.uk |
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
jrountree
Starting Member
20 Posts |
Posted - 07 July 2003 : 22:41:04
|
phpBB2 does not use the ID schemes that Snitz uses which is why it is so difficult.
For instance, the REPLY_ID and such referring to other tables is not done with phpBB2.
phpBB2 has one table for all of it's posts and the database is much more compressed.
Snitz is a much more intense application than phpBB2.
You would think it would be the other way around. |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 08 July 2003 : 00:30:07
|
quote:
Originally posted by jrountree
phpBB2 does not use the ID schemes that Snitz uses which is why it is so difficult.
For instance, the REPLY_ID and such referring to other tables is not done with phpBB2.
phpBB2 has one table for all of it's posts and the database is much more compressed.
Snitz is a much more intense application than phpBB2.
You would think it would be the other way around.
The phpBB board I set up on MySQL uses id's in every table, and there are a lot more tables than snitz. All in all phpbb has a quite comprehensive database schema. There are 28 tables in my database.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
ASP.Confused
Starting Member
16 Posts |
Posted - 17 June 2004 : 09:09:25
|
Hey...in case anyone still wants to do the conversion, here is the T-SQL commands for migrating *only* user names. I'm still working on migrating the entire user structure, but there's issues with column types, and that's the reason why I'm not releasing that script.
Here's the commands to be executed. First, clear out the snitz user table (ALSO MAKE SURE TO BACK UP YOUR ADMINISTRATOR ACCOUNT, OR AT LEAST THE PASSWORD OUT OF THE M_PASSWORD FIELD, OR YOU WILL NOT BE ABLE TO ADMINISTER IT!!!) Edit the code so that it fits your specific needs. When you are finished, find your account within the snitz user table (the migrated account), and paste your password back into the M_PASSWORD field. Then, there should be a field for what type of user you are. By default, it is set to 1. It will need to be changed to 3, to give you administrative privledges.
SET IDENTITY_INSERT forum_members ON;
INSERT INTO FORUM_MEMBERS(MEMBER_ID, M_STATUS, M_NAME, M_USERNAME) SELECT user_id AS member_id, user_active AS m_status, CONVERT(nvarchar(256), username) AS m_name, CONVERT(nvarchar(256), username) AS m_username FROM phpbb_users ORDER BY user_id DESC; |
|
|
| |
Topic |
|
Topic Locked
