Transcript people.cis.ksu.edu

phpBB2 and its Database
Tim Messer
What the heck is phpBB2?
●
●
●
PhpBB2 is an Internet forum build.
Currently most widely used forum.
Uses mySQL for its databasing procedures.
What is mySQL?
●
●
●
MySQL is an open-source relational
database management system (RDBMS)
that uses SQL.
It is stable, very portable, and easily
accessible
However, there are some severe security
issues.
How does it work?
●
●
Thanks to mySQL's accessibility, the
controlling message board software can
directly query the database with php.
This, however, has security ramifications.
Interface -> DB
Instead of Interface -> Processing -> DB
Works Cited
●
●
●
●
Sitepoint, “Interview, James Atkinson”,
http://www.sitepoint.com/article/james-atkinson-founder-phpbb
Forumtopics, “PhpBB2 database model”,
http://www.forumtopics.com/phpBBDemo/downloads/phpBB2_DBer.gif
Movable Type Community, http://www.sixapart.com/movabletype/
Shop-script, “What is mySQL?” http://www.shopscript.com/glossary.html