And now a late, slightly half-assed Christmas present...
Here's an almost complete backup of Press F1 and PC World Chat, saved as an .sql file. Making it hosted and searchable was problematic so have skipped that step, but all the threads and posts are here if you need it. You'll just need to load them into whatever DBMS you fancy.
(04-01-2023, 09:43 PM)yousnoozeyoulose Wrote: And now a late, slightly half-assed Christmas present...
Here's an almost complete backup of Press F1 and PC World Chat, saved as an .sql file. Making it hosted and searchable was problematic so have skipped that step, but all the threads and posts are here if you need it. You'll just need to load them into whatever DBMS you fancy.
It's not the least charm of a theory that it is refutable. The hundred-times-refuted theory of "free will" owes its persistence to this charm alone; some one is always appearing who feels himself strong enough to refute it - Friedrich Nietzsche
05-01-2023, 11:27 AM (This post was last modified: 05-01-2023, 11:28 AM by king1.)
(04-01-2023, 09:43 PM)yousnoozeyoulose Wrote: And now a late, slightly half-assed Christmas present...
Here's an almost complete backup of Press F1 and PC World Chat, saved as an .sql file. Making it hosted and searchable was problematic so have skipped that step, but all the threads and posts are here if you need it. You'll just need to load them into whatever DBMS you fancy.
(05-01-2023, 09:24 AM)zqwerty Wrote: May be a spam post perhaps.
it's all legit, yousnoozeyoulose was able to backup some of the trademe threads when it closed down so we did enquire before xmas about the possibility of saving the PCW forum data...
As Wai said - the "Press F1 archive" link on the "pf1.orgfree.com" page says "PAGE NOT FOUND, FILE NOT FOUND or WEBSITE NOT FOUND!"
They didn't like the zip file either by the look of it
Pagination - you will see the problem with that at the bottom of the index page... A *lot* of threads... Layout - Like I said it is VERY rudimentary Security - running on a DDNS address, no security certificates, you might need to override the browser security warnings Search - None, as yet Basic search or Thread titles implemented. Forums - Press F1 and PCWorld Chat are currently amalgamated, in due course they could be separated DONE URL Links - No active links in posts, copy and paste to browser for now. DONE Quoted Posts - No provision for those haven't found one yet, but if you could let me know a thread or post ID that has quoted posts within a post, pls let me know the ID numbers... Not really happening - there is no delineation of quoted text in the database, so no real way to capture and highlight it... I have done a pretty basic search for quoted text by splitting posts into phrases and comparing phrases with each subsequent post - Far from perfect, and I do note it seems to messing up any links in the quoted text...
Anyway, it's a start. I don't anticipate spending a huge amount of time on this but I will do the quick and easy stuff as time allows...
