Page 1 of 2
complete dream book archive
Posted: Thu Nov 21, 2024 1:48 am
by Baffle
a while ago I shared pdf back ups of the dreambook site and the your webapps site. The thread is still here, Executionous linked the files in his signature.
But it was missing the stories that were never archived. The last archive had stories from August 2009 and the board went until jan 2014.
Well i realized something obvious which is archive.org had enough snapshots of the front page to cover all the stories that were never added to the archives. Except April to May 2011. No one made a backup then.
Anyway, I took all the text from the archives and front page backups and put them in text files which can be downloaded in the 7zip file in the link below. The files are separated by date (bascially one whole page at a time). its 11 pages of front page copies so its a lot of stories. probably over 1000 given the archieves had 100 stories each. Will probably do the same to the webapps board at some point. Hopefully someone finds this useful
https://anonpaste.io/share/4a17fbdfd8
Re: complete dream book archive
Posted: Fri Nov 22, 2024 4:04 pm
by Hooked6
Useful?? It is about as close to discovering a goldmine that I will probably ever get. NICE JOB!
An archive like that would be extremely valuable. There is only one problem. I can't seem to get the link to work. Any suggestions
Hooked6
Re: complete dream book archive
Posted: Fri Nov 22, 2024 4:13 pm
by underdog_13
Hooked6, the link worked fine for me. And yes, that's really a goldmine.
I've put a copy of Baffle's file in my Mega cloud, see if you can get it there:
https://mega.nz/file/mugxWQ6T#wkpo9pQla ... vpxyZdUfD4
Re: complete dream book archive
Posted: Fri Nov 22, 2024 6:02 pm
by PhilMarlowe
I have an SQL backup file of Dreambook(I think) that contains postings with dates in 2014-2019. I used this to create a set of HTML files that I have been re-posting to the Archives forum.
If anyone else wants this file (6MB Zipfile), transfers can be arranged.
Re: complete dream book archive
Posted: Sat Nov 23, 2024 12:35 am
by Hooked6
Yes the Mega.nz file worked perfectly thank you so much.
Hooked6
Re: complete dream book archive
Posted: Sun Nov 24, 2024 1:17 pm
by Baffle
PhilMarlowe wrote: ↑Fri Nov 22, 2024 6:02 pm
I have an SQL backup file of Dreambook(I think) that contains postings with dates in 2014-2019. I used this to create a set of HTML files that I have been re-posting to the Archives forum.
If anyone else wants this file (6MB Zipfile), transfers can be arranged.
the dreambook is the one that died in 2014. The "your web apps" board is the one that ran after. I think i have the same database. like 700 separate html files. I found a linux program that automatically grabbed all of them and made them into a big pdf. Its in that thread and execuionous's mega upload.
i want to turn that in a text file too at some point for portability and share here
by the way, i can take this zip and split it into 17 250kb zip part files and upload them here as attachments since they wouldnt break the 256kb file limit. Is that a weird thing to do to circumvent the upload limit in place?
Re: complete dream book archive
Posted: Sun Nov 24, 2024 8:14 pm
by PhilMarlowe
The database I have seems to have 7109 postings. I can try to get a listing of the id,author,date_entered,subject if anyone is interested.
first 20 entries:
Code: Select all
+----+----------------------+---------------------+-------------------------------------------------------+
| id | author | date_entered | subject |
+----+----------------------+---------------------+-------------------------------------------------------+
| 2 | Bea | 2014-02-14 12:25:20 | Super Drunk at New Years party (xxx) |
| 3 | Ems | 2014-02-15 01:50:18 | Discipline |
| 4 | NA | 2014-02-15 01:52:31 | I never should of cheated |
| 5 | Emma | 2014-02-15 01:56:33 | Flight of Fancy |
| 6 | Code Name Mama Melon | 2014-02-15 01:58:56 | that untitled |
| 7 | Ashamed | 2014-02-16 13:55:57 | De towelled in corridor |
| 8 | Mike's Hard | 2014-02-16 13:57:34 | Jordan's Bad Day |
| 9 | Jozza | 2014-02-16 13:59:12 | Unlucky You - Part 1 |
| 10 | Elyssa | 2014-02-16 14:00:42 | Fight |
| 11 | Ann | 2014-02-16 14:02:18 | What boys do |
| 12 | Jozza | 2014-02-16 14:03:49 | Unlucky You - Part 2 |
| 13 | Marvin | 2014-02-16 14:05:46 | The Hike |
| 14 | Elizabeth | 2014-02-16 14:07:03 | Tough Luck |
| 15 | Elizabeth | 2014-02-16 14:11:03 | Staying Home |
| 16 | elizabeth | 2014-02-16 14:12:26 | Stuck in Bed |
| 17 | Andy | 2014-02-16 14:14:41 | Two weeks in Ibiza |
| 18 | May | 2014-02-16 14:17:05 | You just got May'd! |
| 19 | May | 2014-02-16 14:18:46 | Friend pain |
| 20 | Nathaniel Keam | 2014-02-16 14:22:51 | Rock Chicks and Country Girls – A Tale of a Univers |
| 21 | Girl | 2014-02-16 14:27:59 | T O D pantsing |
+----+----------------------+---------------------+-------------------------------------------------------+
Re: complete dream book archive
Posted: Mon Nov 25, 2024 2:02 am
by Baffle
PhilMarlowe wrote: ↑Sun Nov 24, 2024 8:14 pm
The database I have seems to have 7109 postings
Ah, so does mine. I knew it had a 7. also a folder literally labeled "html dump" so that should be it. going to see if i can get all that in txt. I think I'm going to upload them in 7zip part files directly to board so that as long as this board is here, the files can be downloaded. Maybe I could pm the boad owner to see if he can make an exception for easy accesss to other users? when compressed these zips are only like 3mb
Re: complete dream book archive
Posted: Mon Nov 25, 2024 1:47 pm
by PhilMarlowe
For my reposting, I skip the short postings that are not stories. I worked out some SQL/REXX code to extract the 'author,subject,message' fields into html files.
Let me know if I can help in some way.
Re: complete dream book archive
Posted: Fri Nov 29, 2024 8:38 pm
by Baffle
PhilMarlowe wrote: ↑Mon Nov 25, 2024 1:47 pm
For my reposting, I skip the short postings that are not stories. I worked out some SQL/REXX code to extract the 'author,subject,message' fields into html files.
Let me know if I can help in some way.
I've trying to learn to code so something that can grab and mass filter all that text shouldnt be too hard.
Well I was going to add those attachments but 7zip part files are "invalid". Well the annon paste link isnt set to expire. If anyone has issues downloading it, I'd recommend trying with a vpn or a different browser. it worked on all my devices