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}

History: Old BPFK Data

Source of version: 7 (current)

Search Lojban Resources