Lojban
The Logical Language
Log in
Username:
Password:
I forgot my password |
CapsLock is on.
Log in
History: Old BPFK Data
View page
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}
About
Introduction
What Others Say
FAQ
Learning
Books
Vocabulary
Lojbanic Software
Community
Web/Email Forums
IRC Chat
Links
News
Dictionary
Swag
Multimedia
Lojbanic Texts
Audio
Wiki
Recent Changes
Popular Pages
How To Edit
The LLG
Official Projects
Publications
Donate!
Contact Us
Search Lojban Resources