String -> MD5 Encrypted String function added. To upgrade just reupload convert.php to your admin directory.

----------------------------------------------------------------

2 bugs fixed. To upgrade just reupload the files.

----------------------------------------------------------------

This is a series of four adminstration scripts covering two functions. They are:
Attachment Management
--Find and view attachments with ease, remove with two clicks
--Remove multiple attachments by forum, extension, and other options
Conversion/Encryption Functions
--Converts to and from Unix Timestamp format, which is used by vBulletin in the database
--Encrypt a text string with md5 - useful for comparing a string to an encrypted password in the database

Screenshots

For version: 2.0.3 and above

Files needed: rematt.php, browseatt.php, convert.php, viewatt.php

Files to edit: admin/index.php

Instructions are in the zip file - look for att.txt

DO NOT PM or email me about this hack - it will be ignored!

I will not support you if you edit these files.

You may not redistribute these scripts, edited or unedited, without my prior permission.

Disclaimer: I disclaim all responsibility for your use of this hack. It has been extensively tested but still may screw something up. It is recommended that if you are going to be deleting a lot of attachments you have a recent database backup on hand.

Then findAnd right below it, add
may i ask the point of this is... surely you made a mistake... isn't it just the same thing...??

*Doh* Sorry yeah. I'll update the instructions above.

Great job Tubedogg!!!

This will be very helpful :)

Nice work :)

Great Hack, as usual :rolleyes:

delete attachement doesn't work

Um...yeah it does...? :confused:

not for me everything work but when i click on delete the attachment is still there

In rematt.phpshould beDon't know why noone else discovored this.

Is this fully compatible with 2.0.3, or does it need new instructions, or what?

Cool hack, now if you could add an optimizer that optimizes all pics with 100% no lossy compressions that would be the end of the world. Are there any functions for this?

can this hack be modified to display a gallery like page (similar to the admin view of smilies/avatars) for attachments specific to a forum?

i.e.

gallery.php?s=&forumid=1

?

Actually, correct me if Im wrong but setting the attachementid=0 wouldnt remove the attached file, it would just set its id to 0.

Try to find a field called attachment in the post table. It does not exist.
Threads with no attachment have set the attachmentid to 0.
The actual delete is done in the line aboveAnother thing I found is that the attachment count is not reduced when you delete an attachment.

Tubedog

How difficult would it be to add an option to save attachments to the file system on the server?

Ethan

To answer my own question:

Not too difficult at all!

I hacked in code that allows me to search for threads with attachments in a certain folder, then save all attachments with extension X to the file system, in a directory like this THREADID_threadttitle

Works like a charm. I extracted 2 gigs of MP3s out of the database. The next step is to redo it so it also creates an index file with the contents of the posts.

EThan

Fixed.

Fixed.

No.

Fatal error: Call to undefined function: getrowbg() in /home/dlrarmy/public_html/forums/admin/browseatt.php on line 25

This script does not work for me

When I search for attachments by user or by forums it just gives me the above error message.

Whats up with that?
I did it exactly like in the instructions!

You'll need to upgrade to 2.0.3 to run it...plus 2.0.3 has an important security fix.

I would prefer not to upgrade.
Any chances on this working on 2.0?
Thanks in advance

Chris trust me you want to upgrade. You don't want to be running 2.0 when the details of the security hole are released.

I'm getting the same error as Sarge. I'm not comfortable upgrading though. I don't feel comfortable enough to back up my data and upgrade. I'm afraid something will go wrong and I won't be able to get it working. I know nothing of php or mysql. I tried adding the session.php file and it wouldn't let anyone but me log on. I would really like this admin mod of yours to work though. Can it be modified for 2.0.1?

I am using 2.0.3 and the Delete function is not working. ?? No errors are shown, it just goes to a blank screen. No message at all.

Are you using mass-delete or the "remove" link next to each attachment?

The Remove link next to each attachment.

-- fixed --

Ok, done. I got this error message:
Your session hash doesn't match the one in the database. Try logging in again.

I logged out and back in again and it worked! Thanks!
I just hope I don't have to do that often. ;)

I don't know what caused that. It shouldn't have happened...but I've added error-checking to make sure that if it does happen again you won't just get a blank screen.

Great hack!

Finally upgraded to 2.0.3. :D

Great hack tubedogg!!

what is this hack to do??somebody tell me~~

have any picture??

Can you upgrade this to work on vb 2.2.0 ?

Thanks.

It works with 2.2.0. Just add:

makenavoption("Browse","browseatt.php?action=intro ","<br>");
makenavoption("Delete","rematt.php?action=intro");
makenavselect("Attachments");

wherever you want it to appear in admin/index.php.

Gracias!

Glad to help. It's a great hack. :)

:D
Work great with 2.21 too. Thx !!!

cya

awesome

here are updated install instructions for 2.2

i'm not taking credit, just putting it all in one place for everyone :)

I've updated the hack with instructions for v2.2 and above and with a new function for encrypting strings with md5.

See the first post for instructions.

:cool: x 2 :D