Create files from attachments

This is not like the attachments as files hack, it is simply a way to import files from the attachment table to real files for whatever reason, maybe you just wanted an actualy backup of the files instead of the database.

Simply upload the file into your admin directory.

Open up /admin/index.php

look for

PHP Code:

makenavoption("Back-up Database","backup.php?action=choose","<br>"); 


below it add

PHP Code:

makenavoption("Export Attachments","attachment_export.php?action=import","<br>"); 


done

[Scott MacVicar]

nope thats definately beyhond the limitations of php, yes it wouldn't be hard to zip a couple of files, but it would have a limit of about 30mb worth of files as if you tried to zip any more i'm sure that php would run out of memory.

You can simply tar then gzip it in shell

tar -cvf attachments.tar attachments
gzip attachments.tar

and you get attachments.tar.gz

[Tim Wheatley]

Does this export all files, or can you choose only certain attachments? I don't want people to be able to download all the file without having to do some through the board (because it gives download counts).

[Scott MacVicar]

It exports all files, though I'm workin on an attachment manager which allows you to manipulate attachments via the admin panel, delete attachments, view attachments, rename attachment, make attachment to file or upload a new attachment. You can also sort the attachments via size and search and other things really.

[Tim Wheatley]

Oh that's great thanks

If you need a beta tester let me know

[Scrooge]

I'm getting the following error:

Warning: fopen("/home/reefaqua/public_html/forums/attachments/hermit crab small.jpg", "wb") - Permission denied in /home/reefaqua/public_html/forums/admin/attachment_export.php on line 32

Warning: Supplied argument is not a valid File-Handle resource in /home/reefaqua/public_html/forums/admin/attachment_export.php on line 33

Any ideas?

[Scott MacVicar]

chmod the attachments folder to 666

[Admin]

w00t now I have a huge folder with all attachments. That was fun...

[eva2000]

PPN i love this hack!!

i wanted this for sooooooooooooo long.. actually check out my sig request at https://vborg.vbsupport.ru/showthrea...threadid=32024

maybe a further extension of this hack ?

[eva2000]

does this hack actually delete the original attachments in the database or keeps them after exporting?

looked at my attachment table and it's 225mb in size!

[Scott MacVicar]

It leaves them in the database though if you want to have all attachments as files instead ot the databse then look in my huge long sig and the attachments as files imports all the attachments and when you upload attachments it puts them into a folder.

I could do the forum gallery hack but I have too little time spread too thinly (is that a word?)