|
| View previous topic :: View next topic |
| Author |
Message |
| Pat
 | | Joined: 06 Sep 2006 | | Posts: 128 | | : | |
Items |
|
 Posted: Tue Apr 27, 2010 6:41 am Post subject: |
 |
|
| Red Ed wrote: | Is there any mileage in setting up a Google Group? It's free and it might be possible to prevent it becoming overrun with spammers. There's no forum structure to it, but at least it's searchable. And I imagine that Google keep backups  |
haven't tried Google Groups
if we're considering non-phpBB options,
then i'd suggest Multiply- instead of the familiar bbCode,
you'd use HTML - no forum structure --
but you can place tags on your post - and Multiply.com already has millions of registered members,
so i'd guess they do maintain backups---
|
|
| Back to top |
|
 |
| gsf
| | Joined: 18 Aug 2005 | | Posts: 408 | | : | | Location: NJ USA |
Items |
|
| Posted: Tue Apr 27, 2010 7:52 am Post subject: |
|
|
jasonlion and I have been working on resurrecting the may 2009 html snapshot in a phpBB3 forum
phpBB forums are driven by sql data
the forum backup is one huge sql db initialization script
jason set up an (almost) empty phpBB forum and did a backup
so we know the sql tables
there's a bunch of support programs required for hashing/checksumming/encoding some of the fields
thanks to jason we have working code for that
my approach is to convert the snapshot html to flat file dbs
and from those dbs generate the sql initialization scripts
the result will be a few html2flat scripts and a bunch of flat2sql scripts
we have users.flat => users.sql (users common to players and programmers forum)
and we have forums.flat for the top level forums
posts.flat just finished (67093 posts 62512581 bytes)
I believe this is the most complicated because it converts html back to bbcode
next todo is topics.flat -- the topics for each forum
once that is done the remainder of the flat2sql scripts can be done |
|
| Back to top |
|
|
| Pat
| | Joined: 06 Sep 2006 | | Posts: 128 | | : | |
Items |
|
| Posted: Tue Apr 27, 2010 8:57 am Post subject: |
|
|
| gsf wrote: |
posts.flat just finished (67093 posts 62512581 bytes)
I believe this is the most complicated because it converts html back to bbcode
next todo is topics.flat -- the topics for each forum
once that is done the remainder of the flat2sql scripts can be done |
yes, Posts would be the most complicated, there might be all sorts of quirks there---
re Topics,
just a couple of minor points --- most Topics are open for replies;
a Topic which has been Locked
can be recognized by the missing "Post Reply" button
- each Topic also has an indication of the original poster --
this is usually the same as the poster of the head post,
but you will see exceptions ( where the original head post has been removed ),
therefore the correct source for this information is
in the Table Of Contents ( "index" ) for the section ( "Forum" )
|
|
| Back to top |
|
|
| ronk
| | Joined: 15 Apr 2010 | | Posts: 9 | | : | | Location: Southeastern USA |
Items |
|
| Posted: Tue Apr 27, 2010 10:17 am Post subject: |
|
|
| gsf wrote: | we have users.flat => users.sql (users common to players and programmers forum)
and we have forums.flat for the top level forums |
I expected the parenthetical to say ... all users that have posted on Players' Forums ... with users common to Players' and Programmers' Forums being those to be notified of their 'restart password.'
Otherwise, couldn't someone else register using one of the missing user names and edit old posts? |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
Igloo Theme Version 1.0 :: Created By: Andrew Charron |
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in
Log in to check your private messages
