Sudoku Programmers Forum Index

 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister   ProfileProfile   Log inLog in          Games  Calendar

Log in to check your private messagesLog in to check your private messages   

Players Forums, anything wrong ?!
Goto page Previous  1, 2, 3 ... 9, 10, 11
 
Post new topic   Reply to topic    Sudoku Programmers Forum Index -> Random thoughts
View previous topic :: View next topic  
Author Message
Pat

Joined: 06 Sep 2006
Posts: 128
:

Items
PostPosted: Tue Apr 27, 2010 6:41 am    Post subject: Reply with quote

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 Rolling Eyes

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
View user's profile Send private message Visit poster's website
gsf

Joined: 18 Aug 2005
Posts: 408
:
Location: NJ USA

Items
PostPosted: Tue Apr 27, 2010 7:52 am    Post subject: Reply with quote

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
View user's profile Send private message Visit poster's website
Pat

Joined: 06 Sep 2006
Posts: 128
:

Items
PostPosted: Tue Apr 27, 2010 8:57 am    Post subject: Reply with quote

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
View user's profile Send private message Visit poster's website
ronk

Joined: 15 Apr 2010
Posts: 9
:
Location: Southeastern USA

Items
PostPosted: Tue Apr 27, 2010 10:17 am    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    Sudoku Programmers Forum Index -> Random thoughts All times are GMT
Goto page Previous  1, 2, 3 ... 9, 10, 11
Page 11 of 11

 
Jump to:  
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
Sudoku Programmers topic RSS feed 


Powered by phpBB © 2001, 2005 phpBB Group

Igloo Theme Version 1.0 :: Created By: Andrew Charron