I'm trying to download all attachments from newbb with their original file names, but it seems XOOPS randomizes the names...

In uploads/newbb I have several files like this:

5_4862cdec4b5dc.doc
5_4862d19a99185.doc
5_4862d890bde2c.doc
5_4887a2c2d5913.doc
5_4937195eb6c37.doc
6_487d41fecc821.docx

In the attachment field in xoops_bb_posts I have attachment as:

YToxOntpOjEyMzE5NDM1MTE7YTo0OntzOjEwOiJuYW1lX3NhdmVkIjtzOjE5OiI4XzQ5NmRmNzU3M
jNiZGIuZG9jIjtzOjEyOiJuYW1lX2Rpc3BsYXkiO3M6NTY6IkUtR3VhcmRzIFZlcm8gQmVhY2ggU3
Vic3RhdGlvbiAjOCBTY2FyZWNyb3cgU25hcHNob3QuZG9jIjtzOjg6Im1pbWV0eXBlIjtzOjE4OiJ
hcHBsaWNhdGlvbi9tc3dvcmQiO3M6MTI6Im51bV9kb3dubG9hZCI7aTo0O319

Yet the original post might say "Site Survey.doc"

So how do I download all of the attachments and figure out what their original file names were when they were attached?

bmolloy, welcome on the XOOPS forum!

Did you have a look in the bb_attachments table?

This was my first place to look, though the table is completely empty.

They are in the attachment field of bb_posts as a base64 encoded serialized array. (see eg /class/post.php)