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: 411
:
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
gsf

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

Items
PostPosted: Tue Apr 27, 2010 12:37 pm    Post subject: Reply with quote

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

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

Items
PostPosted: Tue Apr 27, 2010 12:39 pm    Post subject: Reply with quote

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

Joined: 16 Nov 2008
Posts: 62
:
Location: Silver Spring, MD

Items
PostPosted: Tue Apr 27, 2010 1:21 pm    Post subject: Reply with quote

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

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

Items
PostPosted: Tue Apr 27, 2010 1:36 pm    Post subject: Reply with quote

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