History: Old BPFK Data

Source of version: 7 (current)

!!BPFK Reports * ((BPFK 2003 Report)) !!Data from the old BPFK site. [http://www.lojban.org/tiki/tiki-download_wiki_attachment.php?attId=2|Zip file of the raw SQL data from the old PHPBB forums] is about 450KiB. [http://www.lojban.org/tiki/tiki-download_wiki_attachment.php?attId=3|BPFK data from the old TWiki, as zip of text files] is about 38KiB. -Robin This query extracts posted text chronologically from the PHPBB database: {CODE(colors="sql")} select t.topic_title, pt.post_subject, u.username, from_unixtime(p.post_time) as post_time, pt.post_text from phpbb_posts p join phpbb_posts_text pt on pt.post_id = p.post_id join phpbb_users u on p.poster_id = u.user_id join phpbb_topics t on t.topic_id = p.topic_id order by p.post_time \G {CODE}