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: 411 | : | 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 |
|
 |
| gsf
| Joined: 18 Aug 2005 | Posts: 411 | : | Location: NJ USA | Items |
|
Posted: Tue Apr 27, 2010 12:37 pm Post subject: |
|
|
ronk wrote: | 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? |
unless there is a corresponding programmer's forums user name
there is no automated way of transferring the new forum password
anyone in that category should register on the programmer's forum now
they are at an advantage over any interlopers now because the player's forum is down
and they know their name and the interlopers would have to guess
that's why I haven't posted the missing names here
the most important part of the missing names are users who joined the players forum after 2009-05-19
they should pm me here to be added to the new forum db |
|
Back to top |
|
 |
| gsf
| Joined: 18 Aug 2005 | Posts: 411 | : | Location: NJ USA | Items |
|
Posted: Tue Apr 27, 2010 12:39 pm Post subject: |
|
|
Pat wrote: |
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" )
|
thanks Pat
I'll add locked and original_poster fields to the topic flat db
the snapshot has the TOC |
|
Back to top |
|
 |
| JasonLion
| Joined: 16 Nov 2008 | Posts: 62 | : | Location: Silver Spring, MD | Items |
|
Posted: Tue Apr 27, 2010 1:21 pm Post subject: |
|
|
ronk wrote: | Otherwise, couldn't someone else register using one of the missing user names and edit old posts? | This won't be possible. All of the old names will be locked out. Old users will then need to claim them one way or another. Old users with accounts here at the programmers forum will be fairly easy. Then we will need to come up with something for the remaining old users when/if they eventually show up. |
|
Back to top |
|
 |
| gsf
| Joined: 18 Aug 2005 | Posts: 411 | : | Location: NJ USA | Items |
|
Posted: Tue Apr 27, 2010 1:36 pm Post subject: |
|
|
JasonLion wrote: | ronk wrote: | Otherwise, couldn't someone else register using one of the missing user names and edit old posts? | This won't be possible. All of the old names will be locked out. Old users will then need to claim them one way or another. Old users with accounts here at the programmers forum will be fairly easy. Then we will need to come up with something for the remaining old users when/if they eventually show up. |
jason and ronk raise a good point about the new forum users
the phpbb sql db requires a user corresponding to each post
so we will initialize the new forum with all users
the ones with the same name on the programmers forum will have access to the new forum |
|
Back to top |
|
 |
|