Below follows a small script to convert your QuickBlog date data to UNIX timestamp. You’ll have to execute the sql statements yourself. It’ll print out what you need to do. Sorry, I just don’t feel ‘safe’ entirely automating this you can change the echo to a mysql_query() if you feel the need.

After you’re done, please remember to change your qbdate type to an int. While you’re at it, add a second entry ‘qbmodifydate’ int(15). Yes, it’s overkill, but you can always ‘fall back’ to the elder QuickBlog format without much mucking about – heck, you can just ‘reverse’ the script below. ;)

To be compatible with my upcoming release, feel free to use the following template:

ALTER TABLE `$dbnick` ( `qbid` int(11) NOT NULL auto_increment, `qbtitle` varchar(99) NOT NULL default ‘’, `qbcontent` text NOT NULL, `qbdate` int(15) NOT NULL default ‘0’, `qbmodifydate` int(15) NOT NULL default ‘0’, `qbtype` varchar(15) NOT NULL default ‘’, PRIMARY KEY (`qbid`) );

And here’s the code to dump your old date format.

[This code has been superceeded – I have included a table conversion and dump program within the Rollator archive.]