Admin Functions

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.

[JJR512]

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

[dwh]

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?

[eva2000]

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

?

[Nicholas Brown]

Originally posted by Fryzid
In rematt.php

$DB_site->query("UPDATE post SET attachment=0 WHERE postid='$postid'");

should be

$DB_site->query("UPDATE post SET attachmentid=0 WHERE postid='$postid'");

Don't know why noone else discovored this.

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

Originally posted by Nicholas Brown


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 above

$DB_site->query("DELETE FROM attachment WHERE attachmentid='$attachmentid'");

Another thing I found is that the attachment count is not reduced when you delete an attachment.

[ethank]

Tubedog

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

Ethan

[ethank]

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

[tubedogg]

Another thing I found is that the attachment count is not reduced when you delete an attachment.

Fixed.

$DB_site->query("UPDATE post SET attachment=0 WHERE postid='$postid'");

should be

$DB_site->query("UPDATE post SET attachmentid=0 WHERE postid='$postid'");

Fixed.

does it need new instructions [for 2.0.3]

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!

[tubedogg]

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