Tag: PHP-Nuke

I found an old SQL dump of this r3dux.org site yesterday which I thought was lost to time. The site ran php-nuke back then, and rather than importing the SQL into a database and fiddling with it to export all the old articles I thought I’d take the python hammer to it. It’s a bit of a bodge/hack – but it seems to work well enough.

The idea is you copy JUST the insert statement which deals with “stories” (nuke’s word for articles / posts) from the SQL dump and put it in a file (mine’s called “nuke_stories.sql”), then run the parse_nuke_stories python script and it’ll dump out all the articles into separate files with filenames like “Article_ID_YEAR_MONTH_DAY.html” and such.

Here’s the top few lines of my SQL insert statement:

INSERT INTO `nuke_stories` (`sid`, `catid`, `aid`, `title`, `time`, `hometext`, `bodytext`, `comments`, `counter`, `topic`, `informant`, `notes`, `ihome`, `alanguage`, `acomm`, `haspoll`, `pollID`, `score`, `ratings`, `associated`) VALUES
(1, 0, 'r3duxAdmin', 'W00t! The site it be a-changin''...', '2004-09-10 12:35:06', 'Well, PHP-Nuke seems to be up and running, so now it''s time to mess w/ it in a huge way and configure all the millions of options needed to make it just the way I want.\r\n

Here’s what it’ll dump out into a file called Article_001_2004_09_10.html if this was all that was there:
Article ID : 1
Author : r3duxAdmin
Title : W00t! The site it be a-changin’…
Date : 2004-09-10 12:35:06

Well, PHP-Nuke seems to be up and running, so now it’s time to mess w/ it in a huge way and configure all the millions of options needed to make it just the way I want.

It’s been so long since I looked at my old site, since I was my old young (better yet so much worse) self, that I’d almost forgotten that I used to write…

I really should get ’round to making a PDF of the old PHP-Nuke site… I’m sure it’s aged terribly, and probably isn’t relevant any more (How To: Fix Some Stupid Shit in Windows XP etc.) – but it’s part of my life, and I think it deserves the light of day, if not much else…

I’ll have to wait for my return to the UK to get a copy of the old database (September 2010 currently planned), but once I have it raw, I don’t think it would take more effort than it’s worth to sling the lot into some kind of compendium of misplaced youth…